See Table showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs...

 

Transcribed Image Text:

See Table showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 2016-2019 as they were in 2015. What would Mydeco's EPS have been each year in this case? Calculate the new EPS for 2016-2019 below: (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.) Year Revenue (millions) Net Profit Margin New Net Income (millions) Shares Outstanding (millions) New EPS $ $ $ 2016 365.5 0.34 (...) % 2015-2019 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) 2015 2016 2017 Income Statement Revenue Cost of Goods Sold Gross Profit Sales and Marketing Administration Depreciation & Amortization EBIT Interest Income (Expense) Pretax Income Income Tax Net Income Shares Outstanding (millions) Earnings per Share Balance Sheet Assets Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equipment Goodwill & Intangibles Total Assets 403.2 (187.3) 215.9 (66.6) (59.0) (27.5) 62.8 (32.2) 30.6 (10.7) 19.9 56.6 $0.35 2015 48.1 89.1 34.8 172.0 246.7 358.4 777.1 365.5 (176.0) 189.5 (66.9) (58.5) (28.2) 35.9 (33.9) 2.0 (0.7) 1.3 56.6 $0.02 2016 68.9 69.1 32.8 170.8 241.3 358.4 770.5 429.2 (209.9) 219.3 (83.7) (58.6) (34.7) 42.3 2017 (32.3) 10.0 (3.5) 6.5 56.6 $0.11 89.2 70.6 27.5 187.3 310.6 358.4 856.3 2018 513.1 (249.4) 263.7 (96.4) (66.5) (39.2) 61.6 (36.6) 25.0 (8.8) 16.2 56.6 $0.29 2018 81.0 77.5 32.9 191.4 350.2 358.4 900.0 2019 601.4 (289.3) 312.1 (123.8) (79.6) (37.4) 71.3 (38.0) 33.3 (11.7) 21.6 56.6 $0.38 2019 90.3 84.2 35.9 210.4 344.4 358.4 913.2 Liabilities & Stockholders' Equity Accounts Payable Accrued Compensation Total Current Liabilities Long-Term Debt Total Liabilities Stockholders' Equity Total Liabilities & Stockholders' Equity Statement of Cash Flows Net Income Depreciation & Amortization Change in Accounts Receivable Change in Inventory Change in Pay. & Accrued Comp. Cash from Operations Capital Expenditures Cash from Investing Activ. Dividends Paid Sale (or Purchase) of Stock Debt Issuance (Pay Down) Cash from Financing Activ. Change in Cash Mydeco Stock Price 18.3 6.7 25.0 499.6 524.6 252.5 777.1 2015 19.9 27.5 3.9 (2.9) 2.1 50.5 (25.6) (25.6) (6.2) (6.2) 18.7 $7.56 16.2 7.4 23.6 499.6 523.2 247.3 770.5 2016 1.3 28.2 20.0 2.0 (1.4) 50.1 (23.1) (23.1) (6.2) (6.2) 20.8 $3.99 2017 20.8 7.6 28.4 576.4 604.8 251.5 856.3 6.5 34.7 - 1.5 5.3 4.8 49.8 (100.1) (100.1) (6.2) 76.8 70.6 20.3 $4.32 28.1 7.3 35.4 599.7 635.1 264.9 900.0 2018 16.2 39.2 (6.9) (5.4) 7.0 50.1 (75.4) (75.4) (6.2) 23.3 17.1 (8.2) $8.79 33.5 10.3 43.8 599.7 643.5 269.7 913.2 2019 21.6 37.4 (6.7) (3.0) 8.4 57.7 (41.9) (41.9) (6.5) (6.5) 9.3 $10.77 See Table showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 2016-2019 as they were in 2015. What would Mydeco's EPS have been each year in this case? Calculate the new EPS for 2016-2019 below: (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.) Year Revenue (millions) Net Profit Margin New Net Income (millions) Shares Outstanding (millions) New EPS $ $ $ 2016 365.5 0.34 (...) % 2015-2019 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) 2015 2016 2017 Income Statement Revenue Cost of Goods Sold Gross Profit Sales and Marketing Administration Depreciation & Amortization EBIT Interest Income (Expense) Pretax Income Income Tax Net Income Shares Outstanding (millions) Earnings per Share Balance Sheet Assets Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equipment Goodwill & Intangibles Total Assets 403.2 (187.3) 215.9 (66.6) (59.0) (27.5) 62.8 (32.2) 30.6 (10.7) 19.9 56.6 $0.35 2015 48.1 89.1 34.8 172.0 246.7 358.4 777.1 365.5 (176.0) 189.5 (66.9) (58.5) (28.2) 35.9 (33.9) 2.0 (0.7) 1.3 56.6 $0.02 2016 68.9 69.1 32.8 170.8 241.3 358.4 770.5 429.2 (209.9) 219.3 (83.7) (58.6) (34.7) 42.3 2017 (32.3) 10.0 (3.5) 6.5 56.6 $0.11 89.2 70.6 27.5 187.3 310.6 358.4 856.3 2018 513.1 (249.4) 263.7 (96.4) (66.5) (39.2) 61.6 (36.6) 25.0 (8.8) 16.2 56.6 $0.29 2018 81.0 77.5 32.9 191.4 350.2 358.4 900.0 2019 601.4 (289.3) 312.1 (123.8) (79.6) (37.4) 71.3 (38.0) 33.3 (11.7) 21.6 56.6 $0.38 2019 90.3 84.2 35.9 210.4 344.4 358.4 913.2 Liabilities & Stockholders' Equity Accounts Payable Accrued Compensation Total Current Liabilities Long-Term Debt Total Liabilities Stockholders' Equity Total Liabilities & Stockholders' Equity Statement of Cash Flows Net Income Depreciation & Amortization Change in Accounts Receivable Change in Inventory Change in Pay. & Accrued Comp. Cash from Operations Capital Expenditures Cash from Investing Activ. Dividends Paid Sale (or Purchase) of Stock Debt Issuance (Pay Down) Cash from Financing Activ. Change in Cash Mydeco Stock Price 18.3 6.7 25.0 499.6 524.6 252.5 777.1 2015 19.9 27.5 3.9 (2.9) 2.1 50.5 (25.6) (25.6) (6.2) (6.2) 18.7 $7.56 16.2 7.4 23.6 499.6 523.2 247.3 770.5 2016 1.3 28.2 20.0 2.0 (1.4) 50.1 (23.1) (23.1) (6.2) (6.2) 20.8 $3.99 2017 20.8 7.6 28.4 576.4 604.8 251.5 856.3 6.5 34.7 - 1.5 5.3 4.8 49.8 (100.1) (100.1) (6.2) 76.8 70.6 20.3 $4.32 28.1 7.3 35.4 599.7 635.1 264.9 900.0 2018 16.2 39.2 (6.9) (5.4) 7.0 50.1 (75.4) (75.4) (6.2) 23.3 17.1 (8.2) $8.79 33.5 10.3 43.8 599.7 643.5 269.7 913.2 2019 21.6 37.4 (6.7) (3.0) 8.4 57.7 (41.9) (41.9) (6.5) (6.5) 9.3 $10.77