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
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, $51,900; total assets, $209,400; common stock, $88,000; and retained earnings, $30,650.)
CABOT CORPORATION Income Statement For Current Year Ended December 31 | |||
Sales | $ | 451,600 | |
Cost of goods sold | 298,350 | ||
Gross profit | 153,250 | ||
Operating expenses | 99,400 | ||
Interest expense | 4,700 | ||
Income before taxes | 49,150 | ||
Income tax expense | 19,800 | ||
Net income | $ | 29,350 | |
CABOT CORPORATION Balance Sheet December 31 | |||||||
Assets | Liabilities and Equity | ||||||
Cash | $ | 20,000 | Accounts payable | $ | 18,500 | ||
Short-term investments | 8,800 | Accrued wages payable | 3,600 | ||||
Accounts receivable, net | 31,200 | Income taxes payable | 4,600 | ||||
Merchandise inventory | 30,150 | Long-term note payable, secured by mortgage on plant assets | 71,400 | ||||
Prepaid expenses | 2,650 | Common stock | 88,000 | ||||
Plant assets, net | 153,300 | Retained earnings | 60,000 | ||||
Total assets | $ | 246,100 | Total liabilities and equity | $ | 246,100 | ||
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.)
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, $51,900; total assets, $209,400; common stock, $88,000; and retained earnings, $30,650.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 451,600 Cost of goods sold 298,350 Gross profit 153, 250 Operating expenses 99,400 Interest expense 4,700 Income before taxes 49, 150 Income tax expense 19,800 Net income $ 29,350 $ Assets Cash Short-term investments Accounts receivable, net Merchandise inventory CABOT CORPORATION Balance Sheet December 31 Liabilities and Equity 20,000 Accounts payable 8,800 Accrued wages payable 31,200 Income taxes payable 30,150 Long-term note payable, secured by mortgage on plant assets 2,650 Common stock 153,300 Retained earnings $ 246,100 Total liabilities and equity $ 18,500 3,600 4,600 71,400 Prepaid expenses Plant assets, net Total assets 88,000 60,000 $ 246,100 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Req 11 Compute the current ratio and acid-test ratio. 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.) Complete this question by entering your answers in the tabs below. Reg 1 and 2 Req3 Reg4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the current ratio and acid-test ratio. (1) Current Ratio Current Ratio Choose Numerator: Current assets S 246,100 Choose Denominator: Current liabilities IS 246,100 Current ratio 1.0 to 1 (2) Choose Numerator: Quick assets / S 88.000 X 1 Acid-Test Ratio Choose Denominator: Current liabilities IS 246,100 X = Acid-Test Ratio Acid-Test Ratio 0.4 to 1 Reg 1 and 2 Req3 > *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Req 10 Reg 11 Compute the days' sales uncollected. (3) Choose Numerator: Accounts Receivable, net S 71,400 X/ Days' Sales Uncollected Choose Days Denominator: Net sales 365 Days Sales Uncollected Days sales uncollected = S 29,350 X 365 887.9 days *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the inventory turnover. Choose Numerator: Cost of goods sold s 298,350 Inventory Turnover Choose Denominator: Average inventory S 30,150 X = Inventory Turnover Inventory turnover 9.9 times *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Rea 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the days' sales in inventory. (5) Days' Sales in Inventory Choose Denominator: Cost of goods sold Choose Numerator: Merchandise inventory Days / Days' Sales in Inventory Days' sales in inventory 36.9 days x 365 IS 30,150 1 S 298,350 x 365 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the debt-to-equity ratio. (6) Debt-to-Equity Ratio Choose Numerator: Choose Denominator: Total liabilities Total equity IS 148,000 $ 71,400 X Debt-to-Equity Ratio Debt-to-equity ratio 2.07 to 1 ( Req 5 Req7 > *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Req 10 Reg 11 Compute the times interest earned. (7) Times Interest Earned Choose Denominator: Choose Numerator: Times Interest Earned Times interest earned Income before tax Interest expense Interest expense IS 19,800 IS 49,150 S 4,700 2.7 times *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Req 11 Compute the profit margin ratio. (8) Profit Margin Ratio Choose Denominator: Choose Numerator: Net income / Net sales Profit margin ratio Profit margin ratio 100.0 IS 29,350 1/ S 29,350 % *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Req 10 Reg 11 Compute the total asset turnover. (9) Choose Numerator: Net sales Total Asset Turnover Choose Denominator: Average total assets S 49,150 X Total Asset Turnover Total asset turnover 0.6 times IS 29,350 X/ *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Reg 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the return on total assets. (10) Choose Numerator: Return on Total Assets Choose Denominator: Average total assets S 148,000 Return on Total Assets Return on total assets Net income 11 IS 29,350 1 19.B % *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 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.) Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Reg 4 Reg 5 Reg 6 Reg 7 Reg 8 Reg 9 Reg 10 Reg 11 Compute the return on common stockholders' equity. (11) Return on Common Stockholders' Equity Choose Denominator = Average common stockholders' equity 71,400 X- Net income Choose Numerator: Preferred dividends 29,350 S 148.000 Return On Common Stockholders' Equity Return on common stockholders' equity (1662) %Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started