In: Finance
Q2: Firm AAA wants to issue bonds with a 5% coupon rate, a face value of $1,000, and 5 years to maturity. Firm AAA estimates that the bonds will sell for $1,080 and that flotation costs will equal $10 per bond. Firm AAA common stock currently sells for $30 per share. Firm AAA can sell additional shares by incurring flotation costs of $2.5 per share. Firm AAA paid a dividend yesterday of $4.00 per share (D0=4) and expects the dividend to grow at a constant rate of 5% per year. Firm AAA also expects to have $12 million of retained earnings available for use in capital budgeting projects during the coming year. Firm AAA 's capital structure is 30% debt and 70% common equity. Firm AAA’s marginal tax rate is 35%. a). Assuming Firm AAA 's bonds are its only debt, its after-tax cost of debt is__________. b). The cost of retained earnings is ________. c). The cost of new common stock is_________ d). Assuming firm AAA's total capital budget is $50 million, its WACC is________.
Please explain how you calculated the answer.
| A | B | C | D | E | F | G | H | I | 
| 2 | a) | |||||||
| 3 | Calculation of after-tax cost of debt: | |||||||
| 4 | Cost of debt will be the yield to maturity of the bond can be calculated as follows: | |||||||
| 5 | Time to maturity | 5 | years | |||||
| 6 | Annual coupon rate | 5.00% | ||||||
| 7 | Par value | $1,000 | ||||||
| 8 | Market Price | $1,080 | ||||||
| 9 | Annual coupon | $50 | =D7*D6 | |||||
| 10 | Annual Period | 5 | =D5 | |||||
| 11 | Floatation cost | $10 | ||||||
| 12 | Net proceed by issuing bond | $1,070 | =D8-D11 | |||||
| 13 | Rate(nper,pmt,PV, [fv],type) function of excel can be used to find the yield to maturity as follows: | |||||||
| 14 | NPER | 5 | ||||||
| 15 | PMT | $50 | ||||||
| 16 | PV | $ (1,070.00) | ||||||
| 17 | FV | $1,000 | ||||||
| 18 | ||||||||
| 19 | Yield to maturity of the bond | 3.45% | =RATE(D14,D15,D16,D17) | |||||
| 20 | ||||||||
| 21 | Hence Cost of debt is | 3.45% | ||||||
| 22 | ||||||||
| 23 | Tax rate | 35% | ||||||
| 24 | ||||||||
| 25 | After Tax cost of debt | =Cost of debt*(1-Tax rate) | ||||||
| 26 | =3.45%*(1-35%) | |||||||
| 27 | 2.24% | =D21*(1-D23) | ||||||
| 28 | ||||||||
| 29 | Hence After Tax cost of debt | 2.24% | ||||||
| 30 | ||||||||
| 31 | b) | |||||||
| 32 | In the calculation of cost of retained earnings, floatation cost will be ignored, | |||||||
| 33 | as stocks are not issued in the market. | |||||||
| 34 | Cost of retained earnings can be calculated as below: | |||||||
| 35 | Dividend This Year (Div 0) | $4.00 | ||||||
| 36 | Price | $30 | ||||||
| 37 | Growth rate | 5% | ||||||
| 38 | ||||||||
| 39 | From Dividend growth model, | |||||||
| 40 | r(E) = (Div0*(1+g)/P)+g | |||||||
| 41 | ||||||||
| 42 | Cost of retained earnings= | 19.00% | =(D35*(1+D37)/D36)+D37 | |||||
| 43 | ||||||||
| 44 | Hence cost of retained earnings is | 19.00% | ||||||
| 45 | ||||||||
