Question

The extract of the capital structure on the Statement of Financial Position of Nelson Inc. for the year ended 2018 is shown as below Statement of Financial Position for the year ended 31 December 2018 Total (S) Bonds (zero coupon, $1,000 par, 5-year maturity) 3,000,000 Preferred stock (S100 par, 6% dividend) 900,000 Common stock (Si0 par) 980,000 4,880,000 Market prices per bond/share are $710 for bonds, S96 for preferred stock, and $35 for common stock, respectively. There will be sufficient internal common equity funding (i.e. retained earnings) available such that the firm does not plan to issue new common stocks. Assume the cost of internal equity is the same as issuing new common stock without consideration of the associated floatation costs. Dividends just paid for common stock were $2.50 last year and are projected to have an annual growth rate of 6%. The firm is in a 34% tax bracket What is the weighted average cost of capital (WACC) of the company?

Answer 1

=+C8/$C$17 D8 A В C E Market WACC (Cost %xWeights) Market value 7 Cost % value weights 8 Common equity 13.57% 3,430,000 7.25% 0.53 2.5*(1+6%)/35+6% 98000*35 10 4.68% 2,130,000 11 Debt 1.55% 0.33 =RATE (5,0,-710,1000,0)*(1-34%) 12 -3000*710 13 14 Preferred stock 6.25% $ 864,000 0.84% 0.13 6/96 15 -9000*96 16 Total $ 6,424,000 17 1.00 18 9.64% 19 Weighted average cost of capital (WACC) LO

Please rate thumbs up