Question

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 #1 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 1.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 9 86,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 418,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 Gross Fixed Assets 4,669,000 4,322,000 Accumulated 2,295,000 2,056,000 Depreciation Net Fixed Assets 2,374,000 2,266,000 Total Assets 3.597,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 7,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 Equiry Total Liabilities and 3,597,000 3,270,000 Owners' Equity

please show all work in Excel

Answer 1

Date Calculation Ratio of Ratio More Value & 017 I 1-97 2016 9.08 Current Ratio Cuchent that Current Lobility Suick Ratio - Current assed Inventory Current biobility I 1.51 1.46 Indentory turnover Cost of seles sales Avg. Stock held 37.09 5.70 0.79 Assed turn over 40.90 Total sales Aug. Asset Mixed Assed twoven Sales 5 1 Aug.fixed Asset w. Hotel 1. Current Ratio for 2017 19,93,000 1:13 Current Ratio for 2016 - 8.08 Jooyouo 483, ow - 2. Buck i ho for 2017 2016 1993.0w-989000) m m (loro coro-300,000/483000 = 1.42 Teacher's Signature..

Cordova Learning Series - Maths Lab Manual....... 3. turnover Ratio for 2017 - 2088,000 (289 eur 3 co, en - 7.00 turnover Raho for 2016 = 17,81,000 300,000 5.70 Assed turnover 2017 = 3074, cro (3597,000+ 3ato, co - ogo turnover 2016 = 25, 67,000 39,70, oco - 0.79 Asses Fixed Asset turnover 2017 - 30,74, ooo 9374,000+ 29,66,000 - 1.33 Fixed Asset turnoven 2016 1.13

va Leaming Series - Maths Lab Manual ivity No. 2017 Date 6 7.08 9 016 7.03 Account Receivable Het credit sale Aug. Account Receivable luroso Profit margin erros Profit sales 7 32,08 33.35% 17), brosi Profit Ranio 2017 = 98600 x 100 = 32.08%. 30,74,000 856,000 160 - 33-35). 25,67, oco 2016 = 6). Account Receivable Radio 2017 = 3074,000 1503 000+ 365000 2016 = 7:08 95, 67,000 3,65,000 7.03 Teacher's Signature
this is only part answer