Hello, can anyone help with this question? This need to be done in Excel. Thanks in advance!
The balance sheet & income statement
Sweet Dreams Corp Sweet Dreams Corp Yorite Verted Dec. 31230 As of Dec. 31230 ve 2019 Sales Corte Goods Sold 3RD 2 200 1.11 339.000 1 Accounts 50.000 Scing and GRAE tal 2.223.00 322,00 40/000 2.295,00 20 21.00 Geset Alpes Nr. Fixed Depp ERIT Inter 2.0 2 1.000 3.492.000 Kaip len LAN NA KO 2 BASE Ale Shole Asmusse 79.000 tap 10000 . 1,135.000 Tunel 19. . 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 Tumover Ratio Average Collection Period Total Asset Turnover 7.51% 8.00% 40.00 days 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 6.42% 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. 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 2,567,000 1,711,000 986,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 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 2,567,000 1,711,000 986,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 Firm Value Current Ratio Quick Ratio Inventory Turnover Ratio Accounts Receivable Tumover Ratio Average Collection Period Total Asset Turnover Total Debt Ratio Industry Value 2.50x 0.60% 6.50x 8.00x 40.00 days Ratio Industry Value Firm Value 0.74 Debt to Equity 0.90% 0.84 1.51 Times Interest Earned 2.50x 4.49 7.22 Cash Coverage Ratio 3.50% 6.11 Net Profit Margin 5.00% 7.51% 58.91 Return on Total Assets 5.00% 6.42% 0.85 Return on Equity 8.00% 11.82% 45.68% Return on Common Equity 10.00% 2.00x 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 Z score for the firm assuming it to be a private firm
