The Weighted Average Cost of Capital (WACC) is the single most important input in any DCF valuation model. A difference of 0.5% in WACC can change a valuation by 10–15% or more. Despite this, most free DCF templates calculate WACC in a single opaque cell with no audit trail. An institutional-grade model builds it from first principles, with every input sourced and documented.
The WACC Formula
Where:
- E / V = Equity weight (market value of equity divided by total firm value)
- Re = Cost of equity (calculated via CAPM)
- D / V = Debt weight (market value of debt divided by total firm value)
- Rd = Cost of debt (pre-tax yield on the company's debt)
- Tc = Corporate tax rate (creates the tax shield on debt)
Step 1: Cost of Equity (CAPM)
The Capital Asset Pricing Model is the standard method for estimating the cost of equity. The formula is:
Each input requires a deliberate, defensible choice:
| Input | Symbol | Where to Source It |
|---|---|---|
| Risk-Free Rate | Rf | 10-year U.S. Treasury yield (current: ~4.0–4.5%) |
| Equity Risk Premium | Rm − Rf | Damodaran or Ibbotson data (historical range: 4.5–5.5%) |
| Levered Beta | β | Bloomberg, Yahoo Finance, or calculated from unlevered beta |
For the Microsoft pre-loaded example in the Institutional-Grade DCF Model, these inputs produce a cost of equity of approximately 10.5%, which feeds into the 9.00% WACC at Microsoft's current capital structure.
Step 2: Cost of Debt
The cost of debt is the effective interest rate the company pays on its borrowings. This is not simply the coupon rate on outstanding bonds—it should reflect the current yield to maturity on the company's debt, adjusted for the tax benefit.
To calculate it:
- Find the company's most recent bond issuances and their yields
- Alternatively, use interest expense from the income statement divided by average debt outstanding
- Multiply by (1 − tax rate) to get the after-tax cost of debt
Interest expense is tax-deductible, which reduces the effective cost of debt. At a 21% corporate tax rate, a 4.0% pre-tax cost of debt becomes 3.16% after tax. This is why debt is cheaper than equity as a financing source—and why WACC changes when the capital structure shifts.
Step 3: Capital Structure Weights
WACC weights the cost of equity and cost of debt by their proportions in the company's capital structure. Crucially, these weights must use market values, not book values:
- Market value of equity = current share price × diluted shares outstanding
- Market value of debt = estimated using the company's bond prices or fair value disclosures
- Total firm value (V) = market value of equity + market value of debt
For Microsoft, equity dominates the capital structure (over 95% of total firm value), which means the cost of equity drives the WACC calculation far more than the cost of debt.
Step 4: Putting It Together in Excel
In a properly built Excel WACC calculator, each input lives in its own cell with a source note. The WACC formula cell simply references these inputs. This is important because when you change the capital structure or market conditions, the WACC updates automatically—and the entire DCF valuation recalculates with it.
For a deeper understanding of how WACC interacts with valuation outputs, see our DCF Scenario Analysis guide, which shows how changes in discount rate affect bear, base, and bull case share prices.
Common WACC Mistakes
- Using book value weights — this understates the cost of equity and produces an artificially low WACC
- Mismatching the risk-free rate and equity risk premium — both must be from the same time period and market
- Ignoring the tax shield — forgetting (1 − Tc) overstates the cost of debt
- Using an outdated beta — beta should be refreshed quarterly or after major corporate events
- One-size-fits-all WACC — different divisions or geographies warrant different discount rates
The Institutional-Grade DCF Valuation Model addresses every one of these through its WACC Builder—a fully transparent, sourced, and documented cost of capital calculation that feeds directly into the 10-year projection engine.