Total capital = 10 + 8 + 2 = 20 Million
Weight of bonds (Wd) = 10/20 = 0.5
Weight of preferred stock(Wp) = 2/20 = 0.1
Weight of stock equity(We) = 8/20 = 0.4
Cost of debt = YTM of the bonds issued (We assume its annual coupon)
YTM =rate(nper,pmt,pv,fv) in excel =rate(20,60,-950,1000) = 6.4521%
Cost of debt after tax(Rd) = 6.4521*(1-0.34) = 4.2584%
Cost of preferred shares (Rp) = Preferred dividend/ price = 2.5/25 = 0.10 =10%
Cost of equity (Re) = Rf + beta*(Rm-Rf) = 3.5 + 1.2*(13-3.5) =14.9%
WACC = Wd*Rd + Wp*Rp + We& Re
WACC = 0.5*4.2584% +0.1*10% + 0.4*14.9% = 9.089 = 9.09%