B C D E Balance Sheet FG H 2015 2016 2017 2018 2019 Assets Cash 48.8 68.9 86.3 77.5 85.0 Accounts Receivable Inventory 88.6 69.8 69.8 76.9 86.1 33.7 30.9 28.4 31.7 35.3 Total Current Assets 171.1 169.6 184.5 186.1 206.4 Net Property, Plant & Equip. 245.3 243.3 309.0 345.6 347.0 Goodwill & Intangibles 361.7 361.7 361.7 361.7 361.7 Total Assets 778.1 774.6 855.2 893.4 915.1 Liabilities & Stockholders' Equity Accounts Payable 18.7 17.9 22.0 26.8 31.7 Accrued Compensation 6.7 6.4 7.0 8.1 9.7 Total Current Liabilities 25.4 24.3 29.0 34.9 41.4 Long-term Debt 500.0 500.0 575.0 600.0 600.0 Total Liabilities 525.4 524.3 604.0 634.9 641.4 Stockholders' Equity 252.7 250.3 251.2 258.5 273.7 Total Liabilities & Stockholders' 778.1 774.6 855.2 893.4 915.1 Equity Statement of Cash Flows 2015 2016 2017 2018 2019 Net Income 18.0 3.0 6.3 12.7 21.7 Depreciation & Amortization 27.3 27.0 34.3 38.4 38.6 Chg. in Accounts Receivable 3.9 18.8 0.0 (7.1) (9.2) Chg. in Inventory (2.9) 2.8 2.5 (3.3) (3.6) Chg. in Payables & Accrued Comp. 2.2 (1.1) 4.7 5.9 6.5 Cash from Operations 48.5 50.5 47.8 46.6 54.0 Capital Expenditures (25.0) (25.0) (100.0) (75.0) (40.0) Cash from Investing Activities (25.0) (25.0) (100.0) (75.0) (40.0) Dividends Paid (5.4) (5.4) (5.4) (5.4) (6.5) Sale (or Purchase) of Stock 0.0 0.0 0.0 0.0 0.0 Debt Issuance (Pay Down) 0.0 0.0 75.0 25.0 0.0 Cash from Financing Activities (5.4) (5.4) 69.6 19.6 (6.5) Change in Cash 18.1 20.1 17.4 (8.8) 7.5 Mydeco Stock Price $7.92 $3.30 $5.25 $8.71 $10.89 ments 1. Start Excel - completed. 2. In cell D11, by using cell references, calculate the growth rate in revenues for 2016 (1 pt.). 3. To calculate the growth rate in revenues for 2017-2019, copy cell D11 and paste it onto cells E11:G11 (1 pt.). 4. In cell D16, by using cell references, calculate the growth rate in net income for 2016 (1 pt.). 5. To calculate the growth rate in net income for 2017-2019, copy cell D16 and paste it onto cells 2-9 +