WACC Calculator Template
Executive Summary
Key Takeaways
- ✓ The template separates every WACC input into its own labelled, sourced cell, with the blended WACC formula referencing those cells rather than embedding any rate directly.
- ✓ This is a structural template for how to organize the calculation, not a source of specific rate assumptions — every input must be sourced and justified for the specific valuation it supports.
- ✓ The template includes a dedicated notes column for the source and date of each input, so the calculation can be independently replicated and reviewed.
- ✓ Using this structure directly supports the audit checks described in the DCF Model Audit Checklist, since every input is already isolated and traceable.
Purpose¶
This template sets out how a WACC calculation should be structured as a standalone, auditable block within a financial model, following the build methodology in How to Build WACC (Step-by-Step). It is a structural template — it does not provide specific rate assumptions, which must be sourced and justified for each valuation.
Template Structure¶
Section 1 — Cost of Equity Inputs (CAPM)
| Input | Value | Source | Date |
|---|---|---|---|
| Risk-free rate (Rf) | [input] | [government bond yield source, tenor-matched] | [date] |
| Beta (β) | [input] | [observed, or comparable-derived and relevered] | [date] |
| Equity risk premium (ERP) | [input] | [historical, implied, or survey source] | [date] |
| Cost of Equity (Re) | = Rf + β × ERP |
— | — |
Section 2 — Cost of Debt Inputs
| Input | Value | Source | Date |
|---|---|---|---|
| Pre-tax cost of debt (Rd) | [input] | [actual borrowing rate, comparable bond yield, or synthetic rating spread] | [date] |
| Corporate tax rate (Tc) | [input] | [applicable jurisdiction rate] | [date] |
| After-Tax Cost of Debt | = Rd × (1 - Tc) |
— | — |
Section 3 — Capital Structure Weights
| Input | Value | Source |
|---|---|---|
| Target/market value of equity (E) | [input] | [market capitalization or stated target structure] |
| Target/market value of debt (D) | [input] | [market value or stated target structure] |
| E / (E+D) | = calculated |
— |
| D / (E+D) | = calculated |
— |
Note: Use a fixed target capital structure here, not the model's own live calculated enterprise value, to avoid the WACC circularity described in Resolving WACC Circularity in a DCF Model.
Section 4 — Blended WACC
WACC = (E/V) × Cost of Equity + (D/V) × After-Tax Cost of Debt
Every term in this final formula should reference the labelled cells above — no rate should be typed directly into this formula.
How to Use This Template¶
Populate each labelled input cell individually, with its source and date recorded in the adjacent notes column. This structure ensures every WACC input can be independently verified, updated, and sensitized without editing the blended formula itself — directly supporting the structural checks in the DCF Model Audit Checklist, particularly the requirement that the discount rate not be hardcoded and that every input trace to a sourced assumption cell.
Common Pitfalls¶
Embedding a rate directly in the blended formula, rather than referencing a labelled input cell, defeats the purpose of the structure and reintroduces the hardcoded-rate risk this template is designed to prevent.
Leaving the source/date column blank. An unsourced input cannot be independently assessed or updated as market conditions change.
Using the model's own live enterprise value for the weighting section, reintroducing the circularity this template's structure is designed to avoid.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
Related Resources¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Does this template provide specific WACC input values?
No. This is a structural template for organizing the calculation — every rate, premium, and weighting must be sourced and justified for the specific company, project, or valuation date being analyzed, following the sourcing guidance in the How to Build WACC technical guide.
Why does the template separate every input into its own cell?
So that each component — risk-free rate, beta, equity risk premium, cost of debt, tax rate, and capital structure weights — can be independently sourced, dated, updated, and audited, rather than being buried inside a single combined formula that cannot be checked component by component.
How does this template handle the WACC circularity issue?
The template's capital structure weighting section is designed to reference a fixed target structure input rather than the model's own live enterprise value output, eliminating the circularity by default, consistent with the standard resolution described in the WACC circularity technical guide.
Can this template be adapted for a private company or project valuation?
Yes. The beta input row should reference a comparable-company-derived, relevered beta rather than an observed listed beta, and the capital structure weighting should use the target structure rather than an observable market value, per the guidance in the How to Build WACC technical guide.
Related Articles
WACC (Weighted Average Cost of Capital)
WACC (Weighted Average Cost of Capital) is the rate of return that a company must earn on its existing assets to maintain the value of its equity and satisfy both its debt holders and equity investors. It is calculated as the weighted average of the after-tax cost of debt and the cost of equity, with the weights determined by the proportion of each in the total capital structure. WACC is used primarily as the discount rate in a discounted cash flow (DCF) valuation, where it converts projected free cash flows into present value. It is also used as a return hurdle: a project or investment is value-creating if its expected return exceeds the WACC.
How to Build WACC (Step-by-Step)
Building WACC correctly requires three separate sub-builds — cost of equity via CAPM, after-tax cost of debt, and capital structure weights — combined into a single weighted average. Each sub-build has its own inputs, sources, and common errors, and the overall WACC figure is only as reliable as the weakest of its components. This guide walks through each step in order, the capital structure weighting convention (market values, not book values), and the structural checks that confirm the build is internally consistent with the rest of the model, including the circularity that arises when capital structure weights depend on a total value that itself depends on WACC.
Resolving WACC Circularity in a DCF Model
A circular reference arises in a DCF model whenever WACC's capital structure weights are drawn from the model's own calculated enterprise value, since that value is itself the output of discounting cash flow at WACC. This guide sets out why the circularity occurs, the two standard resolution approaches — using a fixed target capital structure to eliminate the circularity entirely, or a controlled iterative calculation with documented convergence settings where target weights are not appropriate — and the structural audit checks that confirm whichever approach is used has been implemented correctly and consistently.
Terminal Value Calculator Template
This template sets out how to calculate DCF terminal value using both the perpetuity growth (Gordon Growth) method and the exit multiple method side by side, with a built-in cross-check cell that back-solves each method's implied value under the other method's assumptions. Calculating both methods together, rather than relying on a single approach, surfaces an unreasonable growth rate, discount rate, or multiple assumption that either method alone might not reveal.