please show how numbers are calculated. and all work must be done in excel

CHAPTER 3: FINANCIAL STATEMENT ANALYSIS TOOLS NOTE: PLEASE USE WORKSHEET #3 IN THE ATTACHED EXCEL FILE TITLED "Homework for Chapter 3 Excel TO SOLVE THE FOLLOWING PROBLEM. Homework for Chapter 3: Problem in the text (Chapter 3) Sweet Dreams Corp. Balance Sheet As of Dec. 31 2017 Assets 2017 2016 Cash 431,000 339,000 Accounts Receivable 503.000 365,000 Inventories 289,000 300,000 Total Current Assets 1.223,000 7,004,000 Sweet Dreams Corp. Income Statement For the Year Ended Dec. 31 2017 2017 2016 Sales 3,074,000 2,567,000 Cost of Goods Sold 2,088,000 1,711,000 Gross Profit 986,000 856,000 Selling and G&A 294,000 295,000 Expenses Fixed Expenses 35,000 35,000 Depreciation 239.000 223,000 Expense EBIT 478,000 303,000 Interest Expense 93.000 91.000 Earnings Before 325,000 212,000 Taxes Taxes 94,000 64,000 Net Income 231,000 148,000 4,669,000 4,322,000 2.295,000 2,056,000 Gross Fixed Assets Accumulated Depreciation Net Fixed Assets Total Assets 2.374,000 3,597,000 2,266,000 3.270.000 Liabilities and Owners' Equity Accounts Payable 382.000 270,000 Short-term Notes 79.000 99.000 Payable Accrued Expenses 159.000 114.000 Total Current Liabilities 620.000 483.000 Long-term Debt 1.023.000 967.000 Total Liabilities 1.643.000 1,450,000 Common Stock 819.000 808,000 Retained Earnings 1.135.000 1.012.000 Total Shareholder's 1.954,000 1.820.000 Equity Total Liabilities and 3,597,000 3.270,000 Owners' Equity a) Set up an EXCEL worksheet similar to the following one, and calculate all of the ratios for Sweet Dreams Corp Ratio Value 2017 2016 Liquidity Ratios Current Ratio Quick Ratio Elliciency Ratios Inventory Tumover Ratio Accounts Receivable Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Turnover Leverage Ratios Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity LTD 1o Equity Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity b) Calculate Sweet Dreams Corp. 's economic profit for these years and compare it to net income. Assume that the weighted average cost of capital is 12%. c) Using the following 2017 industry averages, evaluate Sweet Dreams Corp's financial situation. Use the ratio analysis system in sheet 3 in the attached excel file for HW Chapter 3. Ratio Current Ratio Quick Ratio Inventory Turnover Ratio Accounts Receivable Turnover Ratio Average Collection Period Value 2.50X 0.60 6.50x 8.00x Ratio Debt to Equity Long-Term Debt to Equity Times Interest Eamed Cash Coverage Ratio Value 0.90x 40.00% 2.50x 3.50x Gross Profit Margin 20.00% Fixed Asset Turnover Total Asset Turnover Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization 40.00 days 2.00x 2.00x 50.00% 20.00% 30.00% Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity Return on Common Equity 7.00% 5.00% 5.00% 8.00% 10.00% Sweet Dreams Corp. Income Statement For the Year Ended Dec. 31 2017 2017 2016 Sales 3,074,000 2,567,000 Cost of Goods Sold 2,088,000 1,711,000 Gross Profit 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 303,000 Interest Expense 93,000 91,000 Earnings Before Taxes 325,000 212,000 Taxes 94,000 64.000 Net Income 231,000 148,000 Tax Rate 28.92% 30.19% Sweet Dreams Corp. Balance Sheet As of Dec. 31 2017 Assets 2017 Cash 431,000 Accounts Receivable 503.000 Inventories 289.000 Total Current Assets 1.223.000 Gross Fixed Assets 4,669,000 Accumulated Depreciation 2.295.000 Nel Fixed Assets 2,374,000 Total Assets 3,597,000 Liabilities and Owners' Equity Accounts Payable 382,000 Short-term Notes Payable 79,000 Accrued Expenses 159.000 Total Current Liabilities 620.000 Long-term Debt 1.023.000 Total Liabilities 1.643.000 Common Stock 819,000 Retained Earnings 1,135,000 Total Shareholder's Equity 1.954.000 Total Liabilities and Owners' Equity 3,597,000 2016 339.000 365,000 300.000 1.004.000 4.322.000 2.056,000 2,266,000 3,270,000 270,000 99,000 114.000 483.000 967.000 1,450,000 808,000 1,012.000 1.820,000 3,270,000 Sweet Dreams Corp 2017 Analysis 2017 2016 Liquidin Ratios Efficiency Ratios Ivan Turnover Ratio Accounts Receivable Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Tumover Leverage Ratios Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity Long-Term Debt to Equity Profitability Ratios Gross Profit Margin Operating Proft Margin Net Proft Margin Return on Total Assets Return on Equity Retum on Common Equity 2016 Sweet Dreams, Corp. Economic Profit Calculations 2017 Tax Rate NOPAT Total Operating Capital After-tax Cost of Capital Dollar Cost of Capital Economic Profit