| A | B | C | D | E | F | G | H | I | J |
| 2 | |||||||||
| 3 | Formula for WACC is given as: | ||||||||
| 4 | WACC = r(E) × w(E) + r(P) × w(P)+r(D) × (1 – t) × w(D) | ||||||||
| 5 | Where, r(E), r(P) and r(D) are cost of equity, preferred stock and cost of debt, w(E), w(P) and W(D) | ||||||||
| 6 | are weight of equity, preferred stock and debt and t is the tax rate | ||||||||
| 7 | Calculation of cost of debt: | ||||||||
| 8 | Cost of debt will be the yield to maturity of the bond can be calculated as follows: | ||||||||
| 9 | |||||||||
| 10 | Yield to maturity of the bond | 6.00% | |||||||
| 11 | |||||||||
| 12 | Hence Cost of debt is | 6.00% | |||||||
| 13 | |||||||||
| 14 | Calculation of cost of common equity using dividend growth: | ||||||||
| 15 | |||||||||
| 16 | As per dividend growth model, Price of share is the present value of all future dividends discounted at cost of equity. | ||||||||
| 17 | Current Price of Share (P) | =Div1)/(r-g) | |||||||
| 18 | Where Div1 is the dividend paid next year, r is cost of equity and g is perpetual growth rate of dividend. | ||||||||
| 19 | |||||||||
| 20 | Cost of equity can be calculated as below: | ||||||||
| 21 | Cost of equity, r(E) = (Div1/P)+g | ||||||||
| 22 | |||||||||
| 23 | Given the following data: | ||||||||
| 24 | Dividend (Div1) | $3.50 | |||||||
| 25 | Price (P) | $85 | |||||||
| 26 | Growth rate (g) | 6.0% | |||||||
| 27 | |||||||||
| 28 | From Dividend growth model, | ||||||||
| 29 | Cost of equity, r(E) = (Div1/P)+g | ||||||||
| 30 | Cost of equity= | 10.12% | =(D24/D25)+D26 | ||||||
| 31 | |||||||||
| 32 | Hence cost of using dividend growth model is | 10.12% | |||||||
| 33 | |||||||||
| 34 | Calculation of Cost of preferred stock and market value of preferred stock: | ||||||||
| 35 | |||||||||
| 36 | Annual Dividend of preferred stock | $8.00 | |||||||
| 37 | Current Price | $110.00 | |||||||
| 38 | Floatation cost (F) | $4.50 | |||||||
| 39 | Cost of preferred stock | =Preferred Dividend/(Current Price - Preferred Stock) | |||||||
| 40 | 7.58% | =D36/(D37-D38) | |||||||
| 41 | |||||||||
| 42 | Hence cost of Preferred Stock is | 7.58% | |||||||
| 43 | |||||||||
| 44 | Calculation of Weighted Cost | ||||||||
| 45 | |||||||||
| 46 | Tax Rate | 30% | |||||||
| 47 | |||||||||
| 48 | Source of capital | Capital Structure | Cost | Weighted Cost | |||||
| 49 | Debt | 20.00% | 6.00% | 0.84% | =E49*(1-D46)*D49 | ||||
| 50 | Common Stock | 45.00% | 10.12% | 4.55% | =E50*D50 | ||||
| 51 | Preferred Stock | 35.00% | 7.58% | 2.65% | =E51*D51 | ||||
| 52 | WACC | 8.05% | =SUM(F49:F51) | ||||||
| 53 | |||||||||
Hel Given the following information: Percent of capital structure: Preferred #toek Comnon equity (retained earnings) Debt...
Given the following information: Percent of capital structure: Preferred stock 35 % Common equity (retained earnings) 45 Debt 20 Additional information: Corporate tax rate 30 % Dividend, preferred $ 8.00 Dividend, expected common $ 3.50 Price, preferred $ 110.00 Growth rate 6 % Bond yield 6 % Flotation cost, preferred $ 4.50 Price, common $ 85.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to...
Given the following information: Percent of capital structure: Preferred stock Common equity (retained earnings) Debt Additional information: Corporate tax rate Dividend, preferred Dividend, expected common Price, preferred Growth rate Bond yield Flotation cost, preferred Price, common 35% $ 10.00 $ 5.5e $106.ee 103 $ 6.50 $89.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) Weighted Cost Debt Preferred stock Common equity...
Given the following information: Percent of capital structure: Preferred stock Common equity (retained earnings) Debt 30% 40 30 Additional information: Corporate tax rate Dividend, preferred Dividend, expected common Price, preferred Growth rate Bond yield Flotation cost, preferred Price, common 40% $ 5.00 $ 3.80 $101.00 6% 6% $ 7.40 $ 72.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) Weighted Cost...
Given the following information: Percent of capital structure: 25% Preferred stock Common equity (retained earnings) Debt 30 45 Additional information: 34% $ 6.00 $ 3.50 $ 96.00 Corporate tax rate Dividend, preferred Dividend, expected common Price, preferred Growth rate Bond yield Flotation cost, preferred Price, common 4% $10.20 $81.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) Weighted Cost Debt Preferred...
Given the following information: Percent of capital structure: 20% Debt Preferred stock Common equity (retained earnings) Additional information: Bond coupon rate Bond yield to maturity Dividend, expected common Dividend, preferred Price, common Price, preferred Flotation cost, preferred Growth rate Corporate tax rate 8% 6% $ 2.00 $ 9.00 $ 45.00 $114.00 $ 7.50 28 40% Calculate the Hamilton Corp.'s weighted cost of each source of capital and the weighted average cost of capital. (Do not round Intermediate calculations. Input your...
Given the following information: Percent of capital structure Preferred stock Common equity (retained earnings) Debt 25% 35 40 eBook Additional information: Corporate tax rate Dividend, preferred Dividend, expected common Price, preferred Growth rate 30% 12.00 $ 7.50 $95.00 10% 12% Bond yield Flotation cost, preferred Price, common $ 8.50 80.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) Weighted Cost Debt...
Given the following information: Percent of capital structure: Debt Preferred stock Common equity (retained earnings) 35 20 45 Additional information: Bond coupon rate Bond yield to maturity Dividend, expected common Dividend, preferred Price, common Price, preferred Flotation cost, preferred Growth rate Corporate tax rate 91 s 5.00 S 12.00 s 60.00 $106.00 S 4.50 61 25t Calculate the Hamilton Corp's weighted cost of each source intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) of capital...
Given the following information: Percent of capital structure: Debt 15% Preferred stock Common equity (retained earnings) 10 75 Additional information: Bond coupon rate Bond yield to maturity Dividend, expected common Dividend, preferred Price, common Price, preferred Flotation cost, preferred Growth rate Corporate tax rate 5% 4% $ 2.00 $ 9.00 $ 45.00 $130.00 %$4 2.20 7% 35% Calculate the Hamilton Corp's weighted cost of each source of capital and the weighted average cost of capital. (Do not round intermediate calculations....
Given the following information. Percent of capital structure: Debt 10 % Preferred stock 5 Common equity 85 Additional information: Bond coupon rate 13 % Bond yield 11 % Dividend, expected common $7.00 Dividend, preferred $14.00 Price, common $70.00 Price, preferred $110.00 Flotation cost, preferred $2.50 Corporate growth rate 4 % Corporate tax rate 30 % Calculate the weighted average cost of capital for Genex Corporation. Line up the calculations in the order shown in Table 11-1. (Do not round your...
Given the following information: Percent of capital structure: 20% Preferred stock Common equity Debt Additional information: Corporate tax rate Dividend, preferred Dividend, expected common Price, preferred Growth rate Bond yield Flotation cost, preferred Price, common 34% $ 8.50 $ 2.50 $ 105.00 7% 9.5% $ 3.60 $ 75.00 Calculate the weighted average cost of capital for Digital Processing Inc. (Do not round intermediate calculations. Input your answers as a percent rounded to 2 decimal places.) Weighted Cost Debt Preferred stock...