Question: Consider the financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in
Consider the financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 20152018 as they were in 2014. What would Mydeco's EPS have been each year in this case?
Calculate the new EPS for 20152018 below. (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.)
| Year |
| 2015 |
|
| Revenue (millions) | $ |
|
|
| Net Profit Margin |
|
| % |
| New Net Income (millions) | $ |
|
|
| Shares Outstanding (millions) |
|
|
|
| New EPS | $ |
|
|

2018 604.1 (293.4) 310.7 (120.8) (78.5) (38.6) 72.8 (39.4) 33.4 (11.7) 21.7 55 $0.39 2018 2014-2018 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) Income Statement 2014 2015 2016 2017 Revenue 404.3 363.8 424.6 510.7 Cost of Goods Sold (188.3) (173.8) (206.2) (246.8) Gross Profit 216.0 190.0 218.4 263.9 Sales and Marketing (66.7) (66.4) (82.8) (102.1) Administration (60.6) (59.1) (59.4) (66.4) Depreciation & Amortization (27.3) (27.0) (34.3) (38.4) EBIT 61.4 37.5 41.9 57.0 Interest Income (Expense) (33.7) (32.9) (32.2) (37.4) Pretax Income 27.7 4.6 9.7 19.6 Income Tax (9.7) (1.6) (3.4) (6.9) Net Income 18.0 3.0 6.3 12.7 Shares Outstanding (millions) 55 55 55 55 Earnings per Share $0.33 $0.05 $0.11 $0.23 Balance Sheet 2014 2015 2016 2017 Assets Cash 48.8 68.9 86.3 77.5 Accounts Receivable 88.6 69.8 69.8 76.9 Inventory 33.7 30.9 28.4 31.7 Total Current Assets 171.1 169.6 184.5 186.1 Net Property, Plant & Equipment 245.3 243.3 309.0 345.6 Goodwill & Intangibles 361.7 361.7 361.7 361.7 Total Assets 778.1 774.6 855.2 893.4 Liabilities & Stockholders' Equity Accounts Payable 18.7 22.0 26.8 Accrued Compensation 6.7 6.4 7.0 8.1 Total Current Liabilities 25.4 24.3 29.0 34.9 Long-Term Debt 500.0 500.0 575.0 600.0 Total Liabilities 525.4 524.3 604.0 634.9 Stockholders' Equity 252.7 250.3 251.2 258.5 Total Liabilities & Stockholders' 778.1 774.6 855.2 893.4 Equity Statement of Cash Flows 2014 2015 2016 2017 Net Income 18.0 3.0 6.3 12.7 Depreciation & Amortization 27.3 27.0 34.3 38.4 Change in Accounts Receivable 3.9 18.8 0.0 (7.1) Change in Inventory (2.9) 2.8 2.5 (3.3) Change in Pay. & Accrued Comp. 2.2 (1.1) 4.7 5.9 Cash from Operations 48.5 50.5 47.8 46.6 Capital Expenditures (25.0) (25.0) (100.0) (75.0) Cash from Investing Activ. (25.0) (25.0) (100.0) (75.0) Dividends Paid (5.4) (5.4) (5.4) (5.4) Sale (or Purchase) of Stock Debt Issuance (Pay Down) 75.0 25.0 Cash from Financing Activ. (5.4) (5.4) 69.6 19.6 Change in Cash 18.1 20.1 17.4 (8.8) Mydeco Stock Price $7.92 $3.30 $5.25 $8.71 85.0 86.1 35.3 206.4 347.0 361.7 915.1 17.9 31.7 9.7 41.4 600.0 641.4 273.7 915.1 2018 21.7 38.6 (9.2) (3.6) 6.5 54.0 (40.0) (40.0) (6.5) (6.5) 7.5 $10.89 2018 604.1 (293.4) 310.7 (120.8) (78.5) (38.6) 72.8 (39.4) 33.4 (11.7) 21.7 55 $0.39 2018 2014-2018 Financial Statement Data and Stock Price Data for Mydeco Corp. (All data as of fiscal year end; in $ millions) Income Statement 2014 2015 2016 2017 Revenue 404.3 363.8 424.6 510.7 Cost of Goods Sold (188.3) (173.8) (206.2) (246.8) Gross Profit 216.0 190.0 218.4 263.9 Sales and Marketing (66.7) (66.4) (82.8) (102.1) Administration (60.6) (59.1) (59.4) (66.4) Depreciation & Amortization (27.3) (27.0) (34.3) (38.4) EBIT 61.4 37.5 41.9 57.0 Interest Income (Expense) (33.7) (32.9) (32.2) (37.4) Pretax Income 27.7 4.6 9.7 19.6 Income Tax (9.7) (1.6) (3.4) (6.9) Net Income 18.0 3.0 6.3 12.7 Shares Outstanding (millions) 55 55 55 55 Earnings per Share $0.33 $0.05 $0.11 $0.23 Balance Sheet 2014 2015 2016 2017 Assets Cash 48.8 68.9 86.3 77.5 Accounts Receivable 88.6 69.8 69.8 76.9 Inventory 33.7 30.9 28.4 31.7 Total Current Assets 171.1 169.6 184.5 186.1 Net Property, Plant & Equipment 245.3 243.3 309.0 345.6 Goodwill & Intangibles 361.7 361.7 361.7 361.7 Total Assets 778.1 774.6 855.2 893.4 Liabilities & Stockholders' Equity Accounts Payable 18.7 22.0 26.8 Accrued Compensation 6.7 6.4 7.0 8.1 Total Current Liabilities 25.4 24.3 29.0 34.9 Long-Term Debt 500.0 500.0 575.0 600.0 Total Liabilities 525.4 524.3 604.0 634.9 Stockholders' Equity 252.7 250.3 251.2 258.5 Total Liabilities & Stockholders' 778.1 774.6 855.2 893.4 Equity Statement of Cash Flows 2014 2015 2016 2017 Net Income 18.0 3.0 6.3 12.7 Depreciation & Amortization 27.3 27.0 34.3 38.4 Change in Accounts Receivable 3.9 18.8 0.0 (7.1) Change in Inventory (2.9) 2.8 2.5 (3.3) Change in Pay. & Accrued Comp. 2.2 (1.1) 4.7 5.9 Cash from Operations 48.5 50.5 47.8 46.6 Capital Expenditures (25.0) (25.0) (100.0) (75.0) Cash from Investing Activ. (25.0) (25.0) (100.0) (75.0) Dividends Paid (5.4) (5.4) (5.4) (5.4) Sale (or Purchase) of Stock Debt Issuance (Pay Down) 75.0 25.0 Cash from Financing Activ. (5.4) (5.4) 69.6 19.6 Change in Cash 18.1 20.1 17.4 (8.8) Mydeco Stock Price $7.92 $3.30 $5.25 $8.71 85.0 86.1 35.3 206.4 347.0 361.7 915.1 17.9 31.7 9.7 41.4 600.0 641.4 273.7 915.1 2018 21.7 38.6 (9.2) (3.6) 6.5 54.0 (40.0) (40.0) (6.5) (6.5) 7.5 $10.89
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
