70.2K

Verified Solution

Link Copied!

Hello, can anyone help with this question? This questions need to be done in Excel. Thanks in advance!

Sweet Dreams Corp. Income Statement For the Year Ended Dec. 31 2020 2020 2019 Sales Cost of Goods Sold Gross Profit 3,074,000 2,088,000 986,000 2,567,000 1,711,000 856,000 Selling and G&A Expenses 294,000 295,000 Fixed Expenses 35,000 35,000 Depreciation Expense 239,000 223,000 EBIT 418,000 93,000 303,000 91.000 Interest Expense Earnings Before Taxes 325,000 212,000 Taxes 94,000 64,000 Net Income 231,000 148,000 Assets Sweet Dreams Corp. Balance Sheet As of Dec. 31 2020 2020 431,000 503,000 289,000 Cash Accounts Receivable Inventories 2019 339,000 365,000 300,000 Total Current Assets 1.223.000 1,004,000 Gross Fixed Assets 4,669,000 4,322,000 2.295.000 2,056,000 Accumulated Depreciation Net Fixed Assets Total Assets 2,374.000 2,266,000 3,597.000 3,270,000 Liabilities and Owners' Equity 270,000 Accounts Payable Short-term Notes Payable Accrued Expenses 382,000 79,000 159,000 99,000 114,000 620,000 483.000 Total Current Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 1,023,000 1,643,000 819.000 1,135,000 967,000 1.450,000 808,000 1,012,000 1.954,000 1.820,000 3,597,000 3,270,000 Ratio Industry Value Firm Value Ratio Industry Value Firm Value Current Ratio 2.50x 0.84 0.60% 4.49 6.50x Quick Ratio Inventory Tumover Ratio Accounts Receivable Turnover Ratio Average Collection Period Total Asset Turnover 8.00x 0.74 Debt to Equity 0.90x 1.51 Times Interest Earned 2.50x 7.22 Cash Coverage Ratio 3.50x 6.11 Net Profit Margin 5.00% 58.91 Return on Total Assets 5.00% 0.85 Return on Equity 8.00% Return on Common 45.68% 10.00% Equity 7.51% 40.00 days 6.429 2.00x 11.82% Total Debt Ratio 50.00% (a) Please calculate all the ratios given below for Year 2020 (b) Benchmark each ratio using the Industry Average given below. (Bench marking means comparing each ratio and stating whether it is good or poor.] c) Calculate 2 score for the firm assuming it to be a private firm

Answer & Explanation Solved by verified expert

See Answer