12.

2015-2019 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) Income Statement 2015 2016 2017 2018 2019 Revenue 408.1 363.4 420.1 507.2 607.6 Cost of Goods Sold (185.2) (175.4) (207.3) (247.0) (295.5) Gross Profit 222.9 188.0 212.8 260.2 312.1 Sales and Marketing (65.7) (68.1) (81.3) (104.4) (118.2) Administration (60.1) (58.9) (58.9) (65.1) (79.3) Depreciation & (28.7) (28.9) (32.8) (38.2) (39.7) Amortization EBIT 68.4 32.1 39.8 52.5 74.9 Interest Income (Expense) (31.9) (31.0) (32.1) (37.2) (37.7) Pretax Income 36.5 1.1 7.7 15.3 37.2 Income Tax (12.8) (0.4) (2.7) (5.4) (13.0) Net Income 23.7 0.7 5.0 9.9 24.2 Shares Outstanding 56.1 56.1 56.1 56.1 56.1 (millions) Earnings per Share $0.42 $0.01 $0.09 $0.18 $0.43 Balance Sheet 2015 2016 2017 2018 2019 Assets Cash 49.2 70.2 88.3 75.5 87.7 Accounts Receivable 87.1 70.1 68.3 77.8 84.3 Inventory 32.8 29.4 29.2 30.1 33.3 Total Current Assets 169.1 169.7 185.8 183.4 205.3 Net Property, Plant & 247.3 241.6 309.3 347.9 342.7 Equipment Goodwill & Intangibles 366.7 366.7 366.7 366.7 366.7 Total Assets 783.1 778.0 861.8 898.0 914.7 Liabilities & Stockholders' Equity Accounts Payable 20.3 18.1 20.5 26.7 30.9 Accrued Compensation 6.5 7.3 6.5 7.2 9.6 Total Current Liabilities 26.8 25.4 27.0 33.9 40.5 Long-Term Debt 504.2 504.2 581.0 604.2 604.2 Total Liabilities 531.0 529.6 608.0 638.1 644.7 Stockholders' Equity 252.1 248.4 253.8 259.9 270.0 Total Liabilities & 783.1 778.0 861.8 898.0 914.7 Stockholders' Equity Statement of Cash Flows 2015 2016 2017 2018 2019 Net Income 23.7 0.7 5.0 9.9 24.2 Depreciation & 28.7 28.9 32.8 38.2 39.7 Amortization Change in Accounts 3.9 17.0 1.8 (9.5) (6.5) Receivable Change in Inventory (2.9) 3.4 0.2 (0.9) (3.2) Change in Pay. & Accrued 2.6 (1.4) 1.6 6.9 6.6 Comp. Cash from Operations 56.0 48.6 41.4 44.6 60.8 Capital Expenditures (24.5) (23.1) (95.6) (76.1) (41.1) Cash from Investing (24.5) (23.1) (95.6) (76.1) (41.1) Activ. Dividends Paid (4.5) (4.5) (4.5) (4.5) (7.5) Sale (or Purchase) of Stock Debt Issuance (Pay Down) 76.8 23.2 (4.5) (4.5) 72.3 18.7 (7.5) Cash from Financing Activ. Change in Cash Mydeco Stock Price 27.0 $8.73 21.0 $2.38 18.1 $5.68 (12.8) $8.32 12.2 $9.98 See Table 2.5 3: showing financial statement data and stock price data for Mydeco Corp. Use the data from the balance sheet and cash flow statement in 2015 to determine the following: a. How much cash did Mydeco have at the end of 2014? b. What were Mydeco's accounts receivable and inventory at the end of 2014? c. What were Mydeco's total liabilities at the end of 2014? d. Assuming goodwill and intangibles were equal in 2014 and 2015, what was Mydeco's net property, plant, and equipment at the end of 2014? a. How much cash did Mydeco have at the end of 2014? The amount in cash at the end of 2014 was $ million. (Round to one decimal place.) 2015-2019 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) Income Statement 2015 2016 2017 2018 2019 Revenue 408.1 363.4 420.1 507.2 607.6 Cost of Goods Sold (185.2) (175.4) (207.3) (247.0) (295.5) Gross Profit 222.9 188.0 212.8 260.2 312.1 Sales and Marketing (65.7) (68.1) (81.3) (104.4) (118.2) Administration (60.1) (58.9) (58.9) (65.1) (79.3) Depreciation & (28.7) (28.9) (32.8) (38.2) (39.7) Amortization EBIT 68.4 32.1 39.8 52.5 74.9 Interest Income (Expense) (31.9) (31.0) (32.1) (37.2) (37.7) Pretax Income 36.5 1.1 7.7 15.3 37.2 Income Tax (12.8) (0.4) (2.7) (5.4) (13.0) Net Income 23.7 0.7 5.0 9.9 24.2 Shares Outstanding 56.1 56.1 56.1 56.1 56.1 (millions) Earnings per Share $0.42 $0.01 $0.09 $0.18 $0.43 Balance Sheet 2015 2016 2017 2018 2019 Assets Cash 49.2 70.2 88.3 75.5 87.7 Accounts Receivable 87.1 70.1 68.3 77.8 84.3 Inventory 32.8 29.4 29.2 30.1 33.3 Total Current Assets 169.1 169.7 185.8 183.4 205.3 Net Property, Plant & 247.3 241.6 309.3 347.9 342.7 Equipment Goodwill & Intangibles 366.7 366.7 366.7 366.7 366.7 Total Assets 783.1 778.0 861.8 898.0 914.7 Liabilities & Stockholders' Equity Accounts Payable 20.3 18.1 20.5 26.7 30.9 Accrued Compensation 6.5 7.3 6.5 7.2 9.6 Total Current Liabilities 26.8 25.4 27.0 33.9 40.5 Long-Term Debt 504.2 504.2 581.0 604.2 604.2 Total Liabilities 531.0 529.6 608.0 638.1 644.7 Stockholders' Equity 252.1 248.4 253.8 259.9 270.0 Total Liabilities & 783.1 778.0 861.8 898.0 914.7 Stockholders' Equity Statement of Cash Flows 2015 2016 2017 2018 2019 Net Income 23.7 0.7 5.0 9.9 24.2 Depreciation & 28.7 28.9 32.8 38.2 39.7 Amortization Change in Accounts 3.9 17.0 1.8 (9.5) (6.5) Receivable Change in Inventory (2.9) 3.4 0.2 (0.9) (3.2) Change in Pay. & Accrued 2.6 (1.4) 1.6 6.9 6.6 Comp. Cash from Operations 56.0 48.6 41.4 44.6 60.8 Capital Expenditures (24.5) (23.1) (95.6) (76.1) (41.1) Cash from Investing (24.5) (23.1) (95.6) (76.1) (41.1) Activ. Dividends Paid (4.5) (4.5) (4.5) (4.5) (7.5) Sale (or Purchase) of Stock Debt Issuance (Pay Down) 76.8 23.2 (4.5) (4.5) 72.3 18.7 (7.5) Cash from Financing Activ. Change in Cash Mydeco Stock Price 27.0 $8.73 21.0 $2.38 18.1 $5.68 (12.8) $8.32 12.2 $9.98 See Table 2.5 3: showing financial statement data and stock price data for Mydeco Corp. Use the data from the balance sheet and cash flow statement in 2015 to determine the following: a. How much cash did Mydeco have at the end of 2014? b. What were Mydeco's accounts receivable and inventory at the end of 2014? c. What were Mydeco's total liabilities at the end of 2014? d. Assuming goodwill and intangibles were equal in 2014 and 2015, what was Mydeco's net property, plant, and equipment at the end of 2014? a. How much cash did Mydeco have at the end of 2014? The amount in cash at the end of 2014 was $ million. (Round to one decimal place.)