Question

Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $48,900; total assets, $199,400; common stock, $86,000; and retained earnings, $39,947.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 449,600 Cost of goods sold 298,050 Gross profit 151,550 Operating expenses 98,900 Interest expense 4,500 Income before taxes 48,150 Income tax expense 19,397 Net income $ 28,753 Assets Cash Short-term investments Accounts receivable, net Merchandise inventory CABOT CORPORATION Balance Sheet December 31 Liabilities and Equity $ 16,000 Accounts payable 8,000 Accrued wages payable 30,200 Income taxes payable 40,150 Long-term note payable, secured by mortgage on plant assets 2,850 Common stock 152,300 Retained earnings $ 249,500 Total liabilities and equity $ 18,500 3,800 3,100 69,400 Prepaid expenses Plant assets, net Total assets 86,000 68,700 $ 249,500 Required: Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)

Answer 1

	RATIOS	Calculation	Ratio
1	Current ratio [Current assets/Current liabilities]	(16000+8000+30200+40150+2850)/(18500+3800+3100)	3.83
2	Acid test ratio [(Cash+short term investments+AR)/Current liabilities]	(16000+8000+30200)/(18500+3800+3100)	2.13
3	Days' sales uncollected [AR*365/Sales]	(30200*365/449600)	24.52
4	Inventory turnover [COGS/Average inventory]	[298050/((48900+40150)/2)]	6.69
5	Days' sales in inventory [Inventory*365/COGS]	(40150*365/298050)	49.17
6	Debt to equity ratio [Total liabilities/Stockholders' equity]	(18500+3800+3100+69400)/(86000+68700)	61.28%
7	Times interest earned [Operating profit/Interest expense]	[(151550-98900)/4500]	11.70
8	Profit margin ratio [Net income/Sales]	(28753/449600)	6.40%
9	Total asset turnover [Sales/Average total assets]	[449600/((249500+199400)/2)]	2.00
10	Return on total assets [Net income/Average total assets]	[28753/((249500+199400)/2)]	12.81%
11	Return on common stockholders' equity [Net income/Average common stockholders' equity]	[28753/((86000+68700+86000+39947)/2)	20.49%