Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started