Inputs for WACC $($Re computed using CAPM only$)$

LT Debt: $11,000$ bonds outstanding of a $5-$year maturity; $1050=$ PV; $5\mathrm{.}2\%=$ Coupon Rate

$($Semiannual$)$

Common Stock: $52,000$ shares outstanding; $$32$ price today

Preferred Stock: $14,000$ shares, $4\mathrm{.}6\%$ dividend yield $($ $$100$ part$),$ $$96$ share price

Other CAPM Information:

ERm$=9\%$

$Rf=3\mathrm{.}00\%$

Beta $=1\mathrm{.}18$

Tax Rate $=21\%$

Question:$\_$What is the WACC $($please show inputs on Excel$)?(10$ Points$)$