excel hw .. see instructions below in the attached documents.
HW 11
|
The Claustrophobic Solution, Inc. |
|||||
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
EPS |
$1.10 |
$1.05 |
$1.00 |
$0.95 |
$0.90 |
|
Payout Ratio |
60% |
|
|
|
|
|
Stock Price |
$10.00 |
|
|
|
|
|
Flotation Costs (Equity) |
7% |
|
|
|
|
|
Shares Outstanding |
30,000,000 |
|
|
|
|
|
Debt-Equity Ratio |
0.5 |
|
|
|
|
|
WeightDebt |
33.33% |
|
|
|
|
|
WeightEquity |
66.67% |
|
|
|
|
|
After-tax Cost of Debt |
9.00% |
|
|
|
|
|
|
2017 |
2016 |
2015 |
2014 |
2013 |
|
EPS Growth Rate |
4.76% |
5.00% |
5.26% |
5.56% |
|
|
Average EPS Growth Rate |
5.15% |
|
|
|
|
|
Dividend2018 |
$0.69 |
|
|
|
|
|
Cost of RE |
12.08% |
|
|
|
|
|
Cost of New Equity |
12.61% |
|
|
|
|
|
WACC |
|
|
|
|
|
|
With Retained Earnings |
11.06% |
|
|
|
|
|
With New Equity |
11.40% |
|
|
|
|
Create the table above. Everything in blue needs to be a formula.