Question: 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 as
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 as they were in . 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 | 2016 | ||
| Revenue (millions) | $ | ||
| Net Profit Margin | % | ||
| New Net Income (millions) | $ | ||
| Shares Outstanding (millions) | |||
| New EPS | $ |
| Year | 2017 | ||
| Revenue (millions) | $ | ||
| Net Profit Margin | % | ||
| New Net Income (millions) | $ | ||
| Shares Outstanding (millions) | |||
| New EPS | $ |
| Year | 2018 | ||
| Revenue (millions) | $ | ||
| Net Profit Margin | % | ||
| New Net Income (millions) | $ | ||
| Shares Outstanding (millions) | |||
| New EPS | $ |
| Year | 2019 | ||
| Revenue (millions) | $ | ||
| Net Profit Margin | % | ||
| New Net Income (millions) | $ | ||
| Shares Outstanding (millions) | |||
| New EPS | $ |
| Income Statement | 2015 | 2016 | 2017 | 2018 | 2019 |
| Revenue | 405.4 | 364.7 | 420.5 | 509.7 | 607.6 |
| Cost of Goods Sold | (183.9) | (172.2) | (209.3) | (245.1) | (297.7) |
| Gross Profit | 221.5 | 192.5 | 211.2 | 264.6 | 309.9 |
| Sales and Marketing | (66.2) | (65.8) | (82.2) | (105.6) | (119.2) |
| Administration | (61.6) | (60.2) | (58.8) | (64.8) | (77.7) |
| Depreciation & Amortization | (27.9) | (28.8) | (34.9) | (40.1) | (36.8) |
| EBIT | 65.8 | 37.7 | 35.3 | 54.1 | 76.2 |
| Interest Income (Expense) | (33.5) | (31.4) | (31.1) | (38.9) | (37.9) |
| Pretax Income | 32.3 | 6.3 | 4.2 | 15.2 | 38.3 |
| Income Tax | (11.3) | (2.2) | (1.5) | (5.3) | (13.4) |
| Net Income | 21 | 4.1 | 2.7 | 9.9 | 24.9 |
| Shares Outstanding (millions) | 54.4 | 54.4 | 54.4 | 54.4 | 54.4 |
| Earnings per Share | $0.39 | $0.08 | $0.05 | $0.18 | $0.46 |
| Balance Sheet | 2015 | 2016 | 2017 | 2018 | 2019 |
| Assets | |||||
| Cash | 50.1 | 71.2 | 87.2 | 75.8 | 80.5 |
| Accounts Receivable | 87.6 | 70.9 | 69.2 | 75.5 | 87.4 |
| Inventory | 31.9 | 30.3 | 26.7 | 29.9 | 36.6 |
| Total Current Assets | 169.6 | 172.4 | 183.1 | 181.2 | 204.5 |
| Net Property, Plant & Equip. | 246.2 | 247.9 | 307.2 | 347.2 | 343.9 |
| Goodwill & Intangibles | 362.9 | 362.9 | 362.9 | 362.9 | 362.9 |
| Total Assets | 778.7 | 783.2 | 853.2 | 891.3 | 911.3 |
| Liabilities & Stockholders' Equity | |||||
| Accounts Payable | 18.1 | 15.9 | 22.2 | 25.3 | 31.5 |
| Accrued Compensation | 6.8 | 7.2 | 7.5 | 7.3 | 8.7 |
| Total Current Liabilities | 24.9 | 23.1 | 29.7 | 32.6 | 40.2 |
| Long-term Debt | 495.7 | 495.7 | 571.5 | 598.4 | 598.4 |
| Total Liabilities | 520.6 | 518.8 | 601.2 | 631 | 638.6 |
| Stockholders' Equity | 258.1 | 264.4 | 252 | 260.3 | 272.7 |
| Total Liabilities & Stockholders' Equity | 778.7 | 783.2 | 853.2 | 891.3 | 911.3 |
| Statement of Cash Flows | 2015 | 2016 | 2017 | 2018 | 2019 |
| Net Income | 21 | 4.1 | 2.7 | 9.9 | 24.9 |
| Depreciation & Amortization | 27.9 | 28.8 | 34.9 | 40.1 | 36.8 |
| Chg. in Accounts Receivable | 3.9 | 16.7 | 1.7 | (6.3) | (11.9) |
| Chg. in Inventory | (2.9) | 1.6 | 3.6 | (3.2) | (6.7) |
| Chg. in Payables & Accrued Comp. | 2.8 | (1.8) | 6.6 | 2.9 | 7.6 |
| Cash from Operations | 52.7 | 49.4 | 49.5 | 43.4 | 50.7 |
| Capital Expenditures | (24.3) | (23.5) | (104.5) | (76.9) | (39.4) |
| Cash from Investing Activities | (24.3) | (23.5) | (104.5) | (76.9) | (39.4) |
| Dividends Paid | (4.8) | (4.8) | (4.8) | (4.8) | (6.6) |
| Sale (or purchase) of stock | - | - | - | - | - |
| Debt Issuance (Pay Down) | - | - | 75.8 | 26.9 | - |
| Cash from Financing Activities | (4.8) | (4.8) | 71 | 22.1 | (6.6) |
| Change in Cash | 23.6 | 21.1 | 16 | (11.4) | 4.7 |
| Mydeco Stock Price | $7.47 | $4.03 | $4.77 | $7.95 | $10.08 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
