In: Accounting
Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $50,900; total assets, $169,400; common stock, $89,000; and retained earnings, $44,555.)
CABOT CORPORATION Income Statement For Year Ended December 31, 2017 |
|||
Sales | $ | 452,600 | |
Cost of goods sold | 297,750 | ||
Gross profit | 154,850 | ||
Operating expenses | 98,900 | ||
Interest expense | 4,800 | ||
Income before taxes | 51,150 | ||
Income taxes | 20,605 | ||
Net income | $ | 30,545 | |
CABOT CORPORATION Balance Sheet December 31, 2017 |
|||||||
Assets | Liabilities and Equity | ||||||
Cash | $ | 22,000 | Accounts payable | $ | 15,500 | ||
Short-term investments | 8,000 | Accrued wages payable | 4,800 | ||||
Accounts receivable, net | 33,800 | Income taxes payable | 4,000 | ||||
Notes receivable (trade)* | 7,000 | ||||||
Merchandise inventory | 34,150 | Long-term note payable, secured by mortgage on plant assets | 69,400 | ||||
Prepaid expenses | 2,550 | Common stock | 89,000 | ||||
Plant assets, net | 150,300 | Retained earnings | 75,100 | ||||
Total assets | $ | 257,800 | Total liabilities and equity | $ | 257,800 | ||
(Do not round intermediate calculations.)
Compute the current ratio and acid-test ratio.
|
Compute the days' sales uncollected.
|
Compute the inventory turnover.
|
Compute the days' sales in inventory.
|
Compute the debt-to-equity ratio.
|
Compute the times interest earned.
|
Current ratio Numerator Denominator Current ratio Years Current assets Current liabilities Current ratio 2017 1,07,500 24,300 4.42 to 1
Acid Test Ratio Denominator Quick assets/Current liabilitiesAcid Test Ratio 24,300 Numerator | = | Acid Test Ratio 2017 63,800 2.63 to1
Days Sales Uncollected Days Sales Uncollected Years Numerator DenominatorX Days I/1 Net Sales 365E Accounts Receivable 2017 452600 X 36527.26 days
Inventory turn over ratio Inventory Turn over ratio Inventory Turn over ratio Numerator Denominator Average Inventory 42,525 Cost of goods sold / = | 2017 2,97,750 7.0 Times
Average Inventory Beginning Inventory Ending Inventory/ 2 2 Average Inventory 42525 2017 50,900 34,150
We were unable to transcribe this image
Debt To Equity Ratio Denominator Numerator |=| Debt To Equity DebtShareholder EquityDebt To Equity 93.7001,64,100 Years 2017 0.57 to 1
Times interest Earned Ratio / Denominator = Times interest Earned Income befor tax nterest Expenses Interest Expenses Times interest Earned Numerator 2017 51150 4800 4800 11.66