In: Finance
            The Clause Solution, Inc., a residential window
and door manufacturer, has the following historical record of...
                
            
- The Clause Solution, Inc., a residential window
and door manufacturer, has the following historical record of
earnings per share (EPS) from 2013 to 2017:
 
 | 
 2017 
 | 
 2016 
 | 
 2015 
 | 
 2014 
 | 
 2013 
 | 
| 
 EPS 
 | 
 $1.10 
 | 
 $1.05 
 | 
 $1.00 
 | 
 $0.95 
 | 
 $0.90 
 | 
The company’s payout ratio has been 60% over the
last five years and the last quoted price of the firm’s stock was
$10. Flotation costs for new equity will be 7%. The company
has 30,000,000 common shares
outstanding and a debt-equity
ratio of 0.50.
- If dividends are expected to grow at the same arithmetic
average growth rate of the last five years, what is the dividend
payment in 2018?
 
- Calculate the firm’s cost of retained earnings and the cost of
new common equity using the constant growth dividend discount
model.
 
- If the Clause Solution’s after-tax cost of debt is 9%, what is
the WACC with retained earnings? With new common equity?
 
 | 
 | 
2017 | 
2016 | 
2015 | 
2014 | 
2013 | 
 | 
EPS
Growth Rate | 
 | 
 | 
 | 
 | 
 | 
 | 
Average
EPS Growth Rate | 
 | 
 | 
 | 
 | 
 | 
| a) | 
Dividend2018 | 
 | 
 | 
 | 
 | 
 | 
| b) | 
Cost of
RE | 
 | 
 | 
 | 
 | 
 | 
 | 
Cost of
New Equity | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
 | 
WACC | 
 | 
 | 
 | 
 | 
 | 
| c) | 
With Retained Earnings | 
 | 
 | 
 | 
 | 
 | 
 | 
With New Equity | 
 | 
 | 
 | 
 | 
 | 
Please show any details in the EXCEL!!! Thank you
!!