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. Make sure the header is pasted in cell A1.

a)What is the formula for the debt-equity ratio?

b)What is the formula for the Weight of Equity?

c)What is the formula in E13?

d) What is the formula in Excel to calculate the mean of a range of cells?

e)When calculating your Dividend, what numbers do you need to reference in your formula?

f)What is the difference in the formulas between the Cost of New Equity and the Cost of Retained Earnings?

g)What is the difference in WACC formulas between the With Retained Earnings and With New Equity?