Modern Appliances Corporation has reported its financial results for the year ended December 31, 2017.

Using the information from the financial statements, complete a comprehensive ratio analysis for Modern Appliances Corporation.
a. Calculate these liquidity ratios: current and quick ratios.
b. Calculate these efficiency ratios: inventory turnover, accounts receivable turnover, DSO.
c. Calculate these asset turnover ratios: total asset turnover, fixed asset turnover.
d. Calculate these leverage ratios: total debt ratio, debt-to-equity ratio, equity multiplier.
e. Calculate these coverage ratios: times interest earned, cash coverage.
f. Calculate these profitability ratios: gross profit margin, net profit margin, ROA, ROE.
g. Use the DuPont identity, after calculating the component ratios, to compute ROE.

Transcribed Image Text:

Modern Appliances Corporation Income Statement for the Fiscal Year Ended December 31, 2017 Net sales $5,398,412,000 Cost of goods sold Gross profit Selling, general, and administrative 3,432,925,255 $1,965,486,745 1,036,311,231 expenses Depreciation Operating income Interest ex pense 299,928,155 $ 629,247,359 35,826,000 $ 593,421,359 EBT Income taxes 163,104,554 $ 430,316,805 Net earnings Modern Appliances Corporation Balance Sheet as of December 31, 2017 Liabilities and Equity: Short-term borrowings Trade accounts payable Assets: $ 514,412,159 $ 117,109,865 Cash and cash equivalents Accounts receivable 1,046,612,233 466,937,985 994,289,383 Inventory 981,870,990 Other current liabilities Other current assets 313,621,610 $2,856,516,992 Total current liabilities $1,578,337,233 Long-term debt Total current assets 1,200,691,565 Net fixed assets 754,660,275 118,407,710 Common stock 397,407,352 Goodwill Retained earnings 1,218,207,588 Other assets 665,058,761 $4,394,643,738 Total liabilities and equity Total assets $4,394,643,738