Question

Filer Manufacturing has 4,226,345 shares of common stock outstanding. The current share price is $71.75, and the book value per share is $3.07. Filer Manufacturing also has two bond issues outstanding. The first bond issue has a face value of $66,196,171, has a 0.05 coupon, matures in 10 years and sells for 83 percent of par. The second issue has a face value of $76,232,726, has a 0.06 coupon, matures in 20 years, and sells for 92 percent of par.

The most recent dividend was $2.86 and the dividend growth rate is 0.06. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 0.28.

What is Filer's WACC? Enter the answer with 4 decimals (e.g. 0.2345)

Answer 1

D2 X =C2/$C$7 A B с E WACC (Cost %xWeights) 0.0724 1 Cost % Market value 0.1023 $ 303,240,254 =2.86*(1+6%)/71.75+6% =4226345*71.75 Weights 0.7080 2 Common stock 3 0.0507$ 125,076,930 0.2920 0.0148 4 5 Debt (After tax cost) 6 7 8 Total $ 428,317,184 1.0000 9 0.0872 Weighted average cost of capital (WACC) 10 After tax cost % 0.0536 =RATE(10*2,50/2,-830,1000,0)*2*(1-28%) Market value $ 54,942,822 =66196171*83% Weights 0.4393 WACC (Cost %xWeights) 0.0235 11 12 Debt 1 13 14 15 Debt 2 16 17 0.5607 0.0272 0.0485 =RATE(20*2,60/2,-920,1000,0)*2*(1-28%) $ 70,134,108 =76232726*92% 8 Total $ 125,076,930 1.0000 19 20 After tax cost of debt 0.0507

*Please rate thumbs up