x] Excel template - Saved Insert Data Review View File Home 0151 Help Tell me what you want to do . F G 3 4 5 6 Cost of debt, id Tax rate, T Preferred dividend Preferred stock price, Pp Common stock price, Po Expected common dividend, D, Common stock constant growth rate, 9, % common stock in capital structure % debt in capital structure % preferred stock in capital structure 9.00% 40.00% $3.00 $57.00 $30.00 $3.50 5.00% 75.00% 15.00% 8 10 11 13 After-tax Cost Weighted Cost Cost of capital components & WACC calculation: After-tax cost of debt, (1-T) Cost of preferred stock, Tp Cost of common stock, T R 14 15 16 17 18 19 20 Weights 15.00% 0.00% 75.00% 1 WACC - SER Project acceptance analysis: Projects Accept Project? YIN Expected Rate Cost of Retum $2,000 16.00% $3,000 15.00% $5,000 13.75% $2,000 12.50% Sheet1 2