WACC

WACC (weighted average cost of capital) measures a company's blended cost of debt and equity. Step-by-step calculation, worked example, Excel and common errors.

5 min readGlossary
Contents
  1. WACC formula
  2. How to calculate WACC step by step
  3. WACC calculation example
  4. How to calculate WACC in Excel
  5. Common WACC mistakes
  6. Frequently asked questions

WACC, short for weighted average cost of capital, is the blended rate a company pays for its financing: the cost of equity and the after-tax cost of debt, each weighted by its share of total capital at market value. Calculating it takes five inputs and a few judgment calls, and an error in any of them flows directly into every valuation that uses the rate.

This page walks through the calculation. For what WACC means, how it is used and its limitations, see the full guide to weighted average cost of capital.

WACC formula

WACC = (E/V × Re) + (D/V × Rd × (1 − Tc))

  • E and D are the market values of equity and debt.
  • V = E + D.
  • Re is the cost of equity and Rd the pretax cost of debt.
  • Tc is the marginal corporate tax rate.

How to calculate WACC step by step

Step 1: Find the market value of equity

Multiply the share price by diluted shares outstanding. This is the company's market capitalization, adjusted for options and convertible securities likely to become shares. Use the current share price, not the book value of equity from the balance sheet.

Step 2: Find the market value of debt

For traded bonds, multiply the face value by the quoted price as a percentage of par. For bank loans and other debt that does not trade, book value is a common proxy. Include all interest-bearing debt, short- and long-term, and many analysts also count lease liabilities. Leave out operating liabilities such as accounts payable, which carry no explicit interest cost.

Step 3: Estimate the cost of equity with CAPM

The cost of equity is the shareholders' required rate of return, typically estimated with the capital asset pricing model:

Re = Rf + β × (Rm − Rf)

  • Risk-free rate (Rf): the yield on a long-term government bond in the same currency as the cash flows. For US companies, the 10-year Treasury yield is the most common choice.
  • Beta (β): from a regression of the stock's returns against a market index, from a data provider, or from comparable companies' betas, unlevered and re-levered at the company's own debt level.
  • Market risk premium (Rm − Rf): the extra return investors expect from stocks over the risk-free rate. Estimates vary by source and method, so state the figure you use.

Step 4: Estimate the after-tax cost of debt

The pretax cost of debt is the yield to maturity (YTM) on the company's long-term bonds: the rate that equates the bond's price with the present value of its remaining coupons and principal. If the company has no traded bonds, use the yield on bonds with a comparable credit rating, or the risk-free rate plus a credit spread. Then apply the interest tax shield: after-tax Rd = Rd × (1 − Tc).

Step 5: Weight the costs and add them

Divide E and D by V to get the weights, multiply each weight by its cost, and add the results. Only the debt component receives the tax adjustment.

WACC calculation example

A manufacturer has 60 million shares trading at $25. It has $400 million (face value) of 10-year bonds with a 5.3% annual coupon trading at 95% of par, plus a $120 million bank term loan priced at a similar rate. The risk-free rate is 4.0%, the stock's beta is 1.2, the market risk premium is 5.5% and the marginal tax rate is 21%.

  1. Equity: 60 million × $25 = $1,500 million.
  2. Debt: $400 million × 0.95 = $380 million of bonds, plus the $120 million loan at book value, for $500 million in total.
  3. Weights: V = $2,000 million, so E/V = 75% and D/V = 25%.
  4. Cost of equity: 4.0% + 1.2 × 5.5% = 10.6%.
  5. Cost of debt: the bonds' YTM is about 6.0%; after tax, 6.0% × (1 − 0.21) = 4.74%.
  6. WACC: (75% × 10.6%) + (25% × 4.74%) = 7.95% + 1.19% = 9.14%.

The manufacturer's WACC is 9.14%, so it should use about 9.1% to discount cash flows from projects with its typical risk. The cost of debt is the 6.0% market yield, not the 5.3% coupon: the bonds trade below par because investors now demand more than the coupon pays.

How to calculate WACC in Excel

Put the inputs in their own cells: equity value in B1, debt value in B2, cost of equity in B3, pretax cost of debt in B4 and tax rate in B5.

  • Cost of equity: =4%+1.2*5.5% returns 10.6%.
  • Bond YTM: =RATE(10, 5.3, -95, 100) returns about 5.98% for the bond in the example. For bonds with particular settlement and maturity dates, use =YIELD(settlement, maturity, rate, pr, redemption, frequency).
  • WACC: =B1/(B1+B2)*B3+B2/(B1+B2)*B4*(1-B5) returns 9.135% with the example inputs, or 9.14% rounded.

Keeping each input in a labeled cell makes the rate simple to update when the share price, interest rates or capital structure change, and lets you run the same model at different betas or risk premiums.

Common WACC mistakes

  • Using book weights. Book equity is typically far below market value. With book equity of $600 million and book debt of $520 million, the example's WACC would fall to 7.88%, understating the rate by more than a percentage point.
  • Using the coupon rate as the cost of debt. The coupon reflects rates when the debt was issued. Using 5.3% instead of the 6.0% YTM gives 9.00%.
  • Forgetting the tax adjustment. Using the pretax cost of debt raises WACC to 9.45% in the example.
  • Applying the tax adjustment to equity. Dividends are not deductible, so only debt receives the (1 − Tc) factor.
  • Mismatching the risk-free rate. A short-term Treasury bill rate is a poor match for long-lived cash flows. Use a long-term government bond yield in the same currency as the cash flows.
  • Counting non-interest-bearing liabilities as debt. Accounts payable and accrued expenses belong in working capital, not in D.
  • Using one WACC for every project. A project riskier than the business as a whole requires a higher rate.

Frequently asked questions

How do you calculate WACC for a company with no debt?

With no debt, D/V is zero and WACC equals the cost of equity. Without debt, though, the company's beta, and so its cost of equity, would be lower than for the same business with leverage.

What tax rate should I use in WACC?

Use the marginal tax rate that applies to the company's next dollar of interest deduction. For US companies, that is the 21% federal rate combined with applicable state taxes; a company with losses that pays no tax may receive little near-term value from the tax shield.

Where do I find beta for a private company?

Take the betas of comparable public companies, remove the effect of their debt (unlever them), average them and re-lever the result at the private company's capital structure. Many analysts then add a premium for size or illiquidity.

How often should WACC be recalculated?

Update it whenever interest rates, the share price or the capital structure change materially, and at least once a year for budgeting. A stale WACC can approve projects that no longer clear the real cost of capital.

Let’s make AP
work for you.