In: Finance
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
2013-2016 as they were in 2012.
What would? Mydeco's EPS have been each year in this? case?
Calculate the new EPS for 2013?-2016 ?below:???(Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal? places.)
Income Statement 2012 2013
2014 2015 2016
Revenue 404.6 361.5
421.4 510.7 608.4
Cost of Goods Sold (185.6)
(171.8) (207.9) (248.0)
(289.1)
Gross Profit 219.0 189.7
213.5 262.7 319.3
Sales and Marketing (68.0)
(65.0) (82.6) (99.3)
(116.0)
Administration (60.0) (57.1)
(58.9) (67.0) (76.8)
Depreciation & Amortization (27.7)
(28.2) (35.2) (40.0)
(39.7)
EBIT 63.3 39.4 36.8
56.4 86.8
Interest Income (Expense) (34.8)
(32.1) (31.2) (39.2)
(38.9)
Pretax Income 28.5 7.3
5.6 17.2 47.9
Income Tax (10.0) (2.6)
(2.0) (6.0) (16.8)
Net Income 18.5 4.7
3.6 11.2 31.1
Shares outstanding (millions) 55.2
55.2 55.2 55.2
55.2
Earnings per share $0.34 $0.09
$0.07 $0.20 $0.56
Balance Sheet 2012 2013
2014 2015 2016
Assets
Cash 46.9 71.7 82.0
69.2 90.8
Accounts Receivable 88.7 69.1
71.4 77.2 85.7
Inventory 33.7 30.9
26.6 33.5 35.7
Total Current Assets 169.3
171.7 180.0 179.9
212.2
Net Property, Plant & Equip. 250.1
241.6 308.1 348.5
345.4
Goodwill & Intangibles 361.1
361.1 361.1 361.1
361.1
Total Assets 780.5 774.4
849.2 889.5 918.7
Liabilities & Stockholders' Equity
Accounts Payable 20.4 18.8
20.8 25.4 31.8
Accrued Compensation 6.6 7.2
7.3 8.3 10.2
Total Current Liabilities 27.0
26.0 28.1 33.7
42.0
Long-term Debt 504.4 504.4
577.8 602.1 602.1
Total Liabilities 531.4 530.4
605.9 635.8 644.1
Stockholders' Equity 249.1
244.0 243.3 253.7
274.6
Total Liabilities & Stockholders' Equity
780.5 774.4 849.2
889.5 918.7
Statement of Cash Flows 2012
2013 2014 2015
2013
Net Income 18.5 4.7
3.6 11.2 2016
Depreciation & Amortization 27.7
28.2 35.2 40.0
39.7
Chg. in Accounts Receivable 3.9
19.6 -2.3 (5.8)
(8.5)
Chg. in Inventory (2.9) 2.8
4.3 (6.9) (2.2)
Chg. in Pay. & Accrued Comp. 2.5
(1.0) 2.1 5.6
8.3
Cash from Operations 49.7 54.3
42.9 44.1 68.4
Capital Expenditures (24.4)
(23.4) (99.9) (75.1)
(40.0)
Cash from Investing Activ. (24.4)
(23.4) (99.9) (75.1)
(40.0)
Dividends Paid (6.1) (6.1)
(6.1) (6.1) (6.8)
Sale (or purchase) of stock - -
- - -
Debt Issuance (Pay Down) - -
73.4 24.3 -
Cash from Financing Activ. (6.1)
(6.1) 67.3 18.2
(6.8)
Change in Cash 19.2 24.8
10.3 (12.8) 21.6
Mydeco Stock Price $7.71 $3.92
$5.49 $8.24 $12.84
Income Statement | 2012 | % of revenue | 2013 | Calculation | 2014 | 2015 | 2016 | |
Revenue | 404.6 | 1 | 361.5 | 421.4 | 510.7 | 608.4 | ||
Cost of Goods Sold | 185.6 | 45.87% | 165.83 | 361.5*45.87% | 193.31 | 234.27 | 279.09 | |
Gross Profit | 219 | 54.13% | 195.67 | 228.09 | 276.43 | 329.31 | ||
Sales and Marketing | 68 | 16.81% | 60.76 | 361.5*16.81% | 70.82 | 85.83 | 102.25 | |
Administration | 60 | 14.83% | 53.61 | 361.5*14.83% | 62.49 | 75.73 | 90.22 | |
Depreciation & Amortization | 27.7 | 6.85% | 24.75 | 361.5*6.85% | 28.85 | 34.96 | 41.65 | |
EBIT | 63.3 | 56.56 | 65.93 | 79.90 | 95.18 | |||
Interest Income (Expense) | 34.8 | 8.60% | 31.09 | 361.5*8.60% | 36.24 | 43.93 | 52.33 | |
Pretax Income | 28.5 | 25.46 | 29.68 | 35.97 | 42.86 | |||
Income Tax | 10 | 2.47% | 8.93 | 361.5*2.47% | 10.42 | 12.62 | 15.04 | |
Net Income | 18.5 | 16.53 | 19.27 | 23.35 | 27.82 | |||
Shares outstanding (millions) | 55.2 | 55.2 | 55.2 | 55.2 | 55.2 | |||
Earnings per share | 0.34 | 0.30 | 0.35 | 0.42 | 0.50 |