Question

In: Accounting

Find the Acid-test ratio, Cash ratio, and Accruals ratio for the years 2015-2017   first column is...

Find the Acid-test ratio, Cash ratio, and Accruals ratio for the years 2015-2017  

first column is 2017 then  2016 then 2015

Cash and due from banks 2,012 1,853 1,382
Interest-bearing deposits in other banks 1,899 3,583 3,932
Federal funds sold and securities purchased under agreements to resell 70 15 -
Debt securities held to maturity 1,658 1,362 1,946
Trading account securities - 124 143
Debt securities available for sale 23,403 23,781 22,710
Loans held for sale 348 718 448
Loans, net of unearned income 79,947 80,095 81,162
Allowance for loan losses (934) (1,091) (1,106)
Net loans 79,013 79,004 80,056
Other earning assets 1,891 1,644 1,652
Premises and equipment, net 2,064 2,096 2,152
Interest receivable 337 319 319
Goodwill 4,904 4,904 4,878
Residential mortgage servicing rights at fair value 336 324 252
Other identifiable intangible assets 177 221 259
Other assets 6,182 6,020 5,921
Total assets 124,294 125,968 126,050
Liabilities and Stockholders’ Equity
Deposits:
Non-interest-bearing 36,127 36,046 34,862
Interest-bearing 60,762 62,989 63,568
Total deposits 96,889 99,035 98,430
Borrowed funds:
Short-term borrowings:
Other short-term borrowings 500 - 10
Total short-term borrowings 500 - 10
Long-term borrowings 8,132 7,763 8,349
Total borrowed funds 8,632 7,763 8,359
Other liabilities 2,581 2,506 2,417
Total liabilities 108,102 109,304 109,206
Stockholders' equity:
Preferred stock 820 820 820
Common stock 12 13 13
Additional paid-in capital 15,858 17,092 17,883
Retained earnings 1,628 666 (115)
Treasury stock (1,377) (1,377) (1,377)
Accumulated other comprehensive income (loss), net (749) (550) (380)
Total stockholders' equity 16,192 16,664 16,844
Total liabilities and stockholders' equity 124,294 125,968 126,050

Ratios:

Find the Acid-test ratio, Cash ratio, and Accruals ratio for the years 2015-2017  

Solutions

Expert Solution

Acid Test Ratio = Cash + Cash Equivalents + Short Term Investments + Current Receivables
Current Liabilities
Cash Ratio = Cash + Cash Equivalents
Current Liabilities
Accruals Ratio = Net Income - Free Cash Flow
Total Assets

Acid Test Ratio

Year 2017 2016 2015
Cash 2012 1853 1382
Interest Bearing Deposits 1899 3583 3932
Securities to resell 70 15 0
Trading Account Securities - 124 143
Debt Securities for sale 23403 23781 22710
Loans held for sale 348 718 448
Interest Receivable 337 319 319
Liquid Assets 28069 30393 28934
Short Term Borrowing 500 10
Other Liabilities 2581 2506 2417
Non interest Bearing 36127 36046 34862
Current Liabilities 39208 38552 37289
Cash Ratio 0.7159 0.7884 0.7759
.7159 : 1 .7884 : 1 .7759 : 1

Cash Ratio

Year 2017 2016 2015
Cash 2012 1853 1382
Interest Bearing Deposits 1899 3583 3932
Total cash and cash equivalents 3911 5436 5314
Short Term Borrowing 500 10
Other Liabilities 2581 2506 2417
Non interest Bearing 36127 36046 34862
Current Liabilities 39208 38552 37289
Cash Ratio 0.0998 0.1410 0.1425
.0998 : 1 .1410 : 1 .1425 : 1

Related Solutions

Assuming a current ratio of 1.4 and an acid-test ratio of 0.78, how will the cash...
Assuming a current ratio of 1.4 and an acid-test ratio of 0.78, how will the cash payment of Prepaided Insurance affect each ratio? Increase the current ratio and increase the acid-test ratio No change to the current ratio and decrease the acid-test ratio Decrease the current ratio and decrease the acid-test ratio Decrease the current ratio and increase the acid-test ratio None of above
Hi, I need to find the current ratio and the acid-test ratio. I know the equations...
Hi, I need to find the current ratio and the acid-test ratio. I know the equations for both, but have been having difficulties with calculating the correct answer Unadjusted Trial Balance Account Debit Credit Cash -350 Merch. Inv. 12,000 Store Supplies 5,900 Prepaid Ins 2,500 Store Equip 42,900 Accumulated depreciation - Store Equip. 16,250 Accounts Payable 15,000 Capital 17,000 Withdrawls 2,100 Sales 114,550 Sales Discounts 1,800 Sales Returns & Allowances 2,050 Cost of Goods Sold 38,000 Depreciation Exp. - Store...
What is its acid-test (quick) ratio?
A company has cash of $100 million, accounts receivable of $600 million, current assets of $1.2 billion, accounts payable of $400 million, and current liabilities of $900 million. What is its acid-test (quick) ratio?
Current Ratio 0.80 0.40 0.40 Quick/Acid-Test Ratio 0.85 0.42 0.43 Current cash debt coverage 0.20 0.09...
Current Ratio 0.80 0.40 0.40 Quick/Acid-Test Ratio 0.85 0.42 0.43 Current cash debt coverage 0.20 0.09 0.11 Accounts Receivable Turnover 4.95 6.51 1.56    Inventory Turnover 102.67 52.21 50.46 Asset Turnover 4.04 5.09 1.05 The first column is for ratio in year 1, the second is for ratio in year 2, and the last one is the change(difference). What are the assessments of these ratios?
For the following matrices, first find a basis for the column space of the matrix. Then...
For the following matrices, first find a basis for the column space of the matrix. Then use the Gram-Schmidt process to find an orthogonal basis for the column space. Finally, scale the vectors of the orthogonal basis to find an orthonormal basis for the column space. (a) [1 1 1, 1 0 2, 3 1 0, 0 0 4 ] b) [?1 6 6, 3 ?8 3, 1 ?2 6, 1 ?4 ?3 ]
Assume that the current ratio for Arch Company is 3.5, its acid-test ratio is 1.5, and...
Assume that the current ratio for Arch Company is 3.5, its acid-test ratio is 1.5, and its working capital is $330,000. Answer each of the following questions independently, always referring to the original information. Required: a. How much does the firm have in current liabilities? (Do not round intermediate calculations.) b. If the only current assets shown on the balance sheet for Arch Company are Cash, Accounts Receivable, and Merchandise Inventory, how much does the firm have in Merchandise Inventory?...
Assume that the current ratio for Arch Company is 3.5, its acid-test ratio is 2.0, and...
Assume that the current ratio for Arch Company is 3.5, its acid-test ratio is 2.0, and its working capital is $370,000. Answer each of the following questions independently, always referring to the original information. Required: How much does the firm have in current liabilities? (Do not round intermediate calculations.) If the only current assets shown on the balance sheet for Arch Company are Cash, Accounts Receivable, and Merchandise Inventory, how much does the firm have in Merchandise Inventory? (Do not...
Assume that the current ratio for Arch Company is 3.0, its acid-test ratio is 1.5, and...
Assume that the current ratio for Arch Company is 3.0, its acid-test ratio is 1.5, and its working capital is $310,000. Answer each of the following questions independently, always referring to the original information. Required: a. How much does the firm have in current liabilities? b. If the only current assets shown on the balance sheet for Arch Company are Cash, Accounts Receivable, and Merchandise Inventory, how much does the firm have in Merchandise Inventory? c. If the firm collects...
(a) The current ratio of a company is 6:1 and its acid-test ratio is 1:1. If...
(a) The current ratio of a company is 6:1 and its acid-test ratio is 1:1. If the inventories and prepaid items amount to $544,000, what is the amount of current liabilities? (b) A company had an average inventory last year of $200,000 and its inventory turnover was 6. If sales volume and unit cost remain the same this year as last and inventory turnover is 8 this year, what will average inventory have to be during the current year? (c)...
1. A corporation reports the following year-end balance sheet data. The company's acid-test ratio equals: Cash...
1. A corporation reports the following year-end balance sheet data. The company's acid-test ratio equals: Cash $ 56,000 Current liabilities $ 91,000 Accounts receivable 71,000 Long-term liabilities 48,000 Inventory 76,000 Common stock 116,000 Equipment 161,000 Retained earnings 109,000 Total assets $ 364,000 Total liabilities and equity $ 364,000 Multiple Choice 0.62 1.40 2.23 0.38 0.62 2. A corporation reports the following year-end balance sheet data. The company's debt-to-equity ratio equals: Cash $ 45,000 Current liabilities $ 80,000 Accounts receivable 60,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT