WACC Calculator for DCF Valuation
TL;DR
Your DCF intrinsic value is only as good as the WACC plugged into it. A 1 percentage-point error in WACC can shift intrinsic value 10-40%. Use market-value weights(not book), the 10-year Treasury as the risk-free rate (normalized across cycles), an ERP of 4.5-5.5%, and the after-tax cost of debt. Then run a sensitivity table — the WACC range is your valuation range.
Why WACC is the foundation of a DCF
In a Discounted Cash Flow model, every assumption about future cash flows is only as meaningful as the discount rate you apply to them. WACC is that rate. Get it wrong by 2 percentage points and your intrinsic value estimate can be off by 30% or more — even if your cash flow projections are perfect. Getting WACC right is not optional; it is the foundation of the entire model.
The three most common mistakes analysts make are:
- Using the spot risk-free rate without normalizing for the interest rate cycle.
- Using book-value rather than market-value weights for debt and equity.
- Forgetting to apply the tax shield to the cost of debt.
This calculator handles all three correctly — auto-filling market-value capital structure weights from live data and applying the after-tax cost of debt formula automatically. The remaining work is yours: normalize the risk-free rate, pick a defensible equity risk premium, and decide whether to use the current or the target capital structure.
The WACC formula, broken down for DCF use
WACC = (E/V) x Re + (D/V) x Rd x (1 - t)
Where Re = Rf + beta x (Rm - Rf) (CAPM cost of equity)
And Rd_after_tax = Rd_pre_tax x (1 - tax_rate)
- E and D are market values. Market cap for equity. Market value of debt for debt (book value is acceptable when debt trades near par, which is most large-cap names).
- Rf is the risk-free rate. Use 10-year Treasury for most equity DCFs; 30-year for multi-decade models. Normalize across rate cycles.
- beta is the levered beta. Use the company observed beta if it has a stable 2-5 year regression beta. Otherwise unlever industry peers and re-lever.
- Rm - Rf is the equity risk premium. 4.5-5.5% is the working range for US equities.
- Rd is the pre-tax cost of debt. Use the yield on the company existing bonds, or interest expense / total debt as a proxy.
- t is the marginal tax rate. Use the statutory rate (21% US) for forward projections; the effective rate is acceptable when it has been stable.
Worked example: Microsoft (MSFT)
Microsoft is a useful WACC case because it is a mega-cap with modest leverage, well-known beta, and easily observable cost of debt. The numbers below are illustrative anchors — pull current data with the auto-fill function before drawing conclusions.
Capital structure. Market cap approximately $3.1T; gross debt about $97B; net debt is significantly negative (large net cash position). Equity weight (E/V) = 3100 / (3100 + 97) = 97.0%. Debt weight (D/V) = 3.0%.
Cost of equity. Rf = 4.2% (normalized 10-year Treasury). MSFT levered beta = 0.92 (representative for a mature tech mega-cap). ERP = 5.0%. CAPM Re = 4.2% + 0.92 x 5.0% = 4.2% + 4.6% = 8.8%.
Cost of debt. MSFT outstanding bonds yield roughly 5.0-5.5%. Pre-tax cost of debt approximately 5.2%. After-tax cost of debt = 5.2% x (1 - 0.21) = 4.1%.
WACC. 0.97 x 8.8% + 0.03 x 4.1% = 8.54% + 0.12% = approximately 8.66%. Rounded for DCF use: 8.7% or 9% depending on the analyst preference for precision.
Why the debt weight matters less than you think. Even though MSFT after-tax cost of debt is materially below cost of equity, the equity weight is so dominant (97%) that the cost of debt contributes less than 15 basis points to the WACC. For high-debt companies, this contribution can be 200-400 basis points, which is why getting the capital structure right matters more for leveraged businesses.
Sensitivity in the DCF. If you build a 10-year DCF for MSFT and the intrinsic value comes out at, say, $450 per share at 8.7% WACC, the same model at 9.7% WACC may give $370 (15-18% lower) and at 7.7% may give $560 (20-25% higher). The honest report is "intrinsic value range $370-$560" — not a single point estimate. The width of that range comes overwhelmingly from WACC sensitivity, not from cash flow assumptions.
Run the calculation
The calculator below pre-fills capital structure data from any ticker. Confirm the equity weight, set the risk-free rate to a normalized level, and adjust the equity risk premium to your house view (4.5-5.5% is the defensible range). The output WACC plugs straight into the discount rate field of your DCF spreadsheet — or the discount rate slider in the ValueMarkers DCF Calculator.