a. Equity =8,900,000*37 = 329.3 Million
Preferred stock = 330,000*87 = 28.71 Million
Debt = 175,000*1000*1.18 = 206.5 Million
Total = 329.3 + 28.71 + 206.5 = 564.51
Market value Weight of debt = 206.5/564.51 = 0.3658
Market value of preferred stock = 28.71/564.51 = 0.0509
Market value of equity = 1-0.3658-0.0509 = 0.5833
b. Cost of equity = Rf + beta * Market risk premium = 4+1.45*7.7 = 15.165%
Cost of debt = YTM =rate(nper,pmt,pv,fv)*2 =rate(30,77/2,-1180,1000) *2 = 5.8778%
After tax cost of debt = 5.8778*(1-0.4) = 3.5267%
Cost of preferred stock = 5/87 = 0.057471 = 5.7471%
WACC = 0.5833*15.165% +0.3658*3.5267 +0.0509*5.7471% = 10.43%