In: Finance
WACC = (weight of debt * cost of debt) + (weight of common stock * cost of common stock)
market value of debt = bonds outstanding * market price per bond
market value of common stock = shares outstanding * market price per share
weight of debt = market value of debt / total market value
weight of common stock = market value of common stock / total market value
cost of debt = YTM of bond * (1 - tax rate)
YTM is calculated using RATE function in Excel with these inputs :
nper = 30 (30 years to maturity with 1 annual coupon payments each year)
pmt = 1000 * 5% (annual coupon payment = face value * annual coupon rate / 2. This is a positive figure as it is an inflow to the bondholder)
pv = -950 (current bond price. This is a negative figure as it is an outflow to the buyer of the bond)
fv = 1000 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)
cost of debt = YTM * (1 - tax rate)
cost of equity = risk free rate + (beta * market risk premium)
WACC = 5.93%
The calculations are below