Resolving WACC Circularity in a DCF Model
Executive Summary
Key Takeaways
- ✓ WACC circularity arises because capital structure weights depend on total firm value, which is itself the output of discounting cash flow at WACC.
- ✓ The standard resolution is to use a fixed target capital structure for the weights, independent of the model's own live calculated value, which eliminates the circularity entirely.
- ✓ Where a live, model-derived capital structure is genuinely required, controlled iterative calculation with documented Maximum Iterations, Maximum Change, and a convergence check cell is the acceptable alternative.
- ✓ An unmanaged WACC circularity can produce a model that displays zero (if iterative calculation is off) or a non-reproducible value (if iterative calculation is on but uncontrolled).
- ✓ This circularity is a specific instance of the general circular reference risk addressed on the Circular Reference glossary page, applied to the WACC/enterprise value relationship specifically.
Institutional Definition¶
WACC circularity is a specific, common instance of a circular reference: capital structure weights (E/V, D/V) in the WACC formula are properly drawn from the market value of equity and debt, but in a DCF being used to estimate that very equity value, the "market value" is the model's own output — creating a dependency loop between WACC, enterprise value, and the weights that produce it. This guide addresses how the circularity arises specifically in a DCF context and the two standard resolution approaches.
Why the Circularity Arises¶
WACC = (E/V) × Re + (D/V) × Rd × (1 - Tc)
Where E (market value of equity) is, in a DCF, derived from:
Equity Value = Enterprise Value - Net Debt
Enterprise Value = Σ FCFF / (1 + WACC)^t + Terminal Value / (1 + WACC)^n
WACC feeds into the calculation of enterprise value, and enterprise value (via the equity value it implies) feeds back into the weights used to calculate WACC. This is the same class of dependency loop addressed generally on the Circular Reference glossary page, here specific to the discount-rate-and-value relationship at the heart of a DCF.
Resolution 1: Fixed Target Capital Structure (Standard Approach)¶
The standard institutional resolution is to base the capital structure weights on a fixed target structure — the capital structure the company intends to maintain over the long run, or an assumed structure appropriate to the specific valuation purpose — rather than the model's own live, calculated value.
This eliminates the circularity entirely: the weights become an independent assumption, sourced and disclosed like any other WACC input (see How to Build WACC), and the model can calculate enterprise value in a single pass with no dependency loop. This is the approach used in the large majority of institutional DCF models, and it is the approach implicitly assumed throughout this Knowledge Centre's WACC-related content unless a specific analysis calls for otherwise.
Resolution 2: Controlled Iterative Calculation¶
Where an analysis specifically requires the capital structure weights to reflect the model's own converged output — for example, to test whether an assumed structure is internally self-consistent with the value it produces — the circularity must be resolved through Excel's iterative calculation feature, with controls:
- Maximum Iterations and Maximum Change settings documented and justified for the model's specific value scale (see the general treatment of default-setting risk on the Circular Reference glossary page)
- A convergence check cell calculating the residual difference in WACC (or enterprise value) between one iteration pass and the next, flagged if it exceeds a defined tolerance
- A fresh-open convergence test — closing and reopening the model, recalculating from a zero starting position, and confirming the outputs match the previously converged state
Iterative calculation resolves the circularity numerically but does not guarantee the result is unique or stable across different starting conditions — the same convergence risk that applies to any circular financial relationship.
Structural Audit Checks¶
| Check | What It Confirms |
|---|---|
| Capital structure weights source is disclosed (target structure or live model value) | The WACC build's weighting basis is transparent and can be independently assessed |
| If target weights are used, they are not silently overridden by a live formula elsewhere in the model | The stated elimination approach is actually implemented consistently |
| If iterative calculation is used, Maximum Iterations/Maximum Change settings are documented | The convergence behaviour is controlled, not left at an arbitrary default (R003) |
| A convergence check cell exists and is tested | Non-convergence would be visible rather than silently producing an unstable output |
| The model has been tested for consistent convergence from a fresh open | The output is reproducible, not dependent on the model's prior calculation history |
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Live enterprise value fed back into WACC weights with no target-structure override | Genuine circular dependency left unmanaged | Model may display zero, or an unstable, non-reproducible value |
| Iterative calculation enabled to silence the warning with no documented settings | Circularity numerically "resolved" without control | Output may not be reproducible across machines or sessions |
| No convergence check cell | No visibility into whether the iterative solution has actually stabilised | A non-converged, understated or overstated WACC can go undetected |
| Confusing target structure with the company's current structure | Weights based on current, not intended, capital structure, without disclosing the choice | WACC may not reflect the structure the valuation is meant to represent |
Continue Reading¶
Prerequisites¶
- Discounted Cash Flow (DCF) Valuation — the parent pillar
- How to Build WACC (Step-by-Step)
Related Glossary¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Why does WACC create a circular reference in a DCF model?
Because WACC's capital structure weights (E/V and D/V) are properly based on the market value of equity and debt, and for a DCF being used to estimate that very value, the "market value of equity" is the model's own output. WACC therefore depends on a figure that depends on WACC.
What is the standard way to resolve WACC circularity?
Use a fixed target capital structure for the weights — the capital structure the company intends to maintain, or an assumed structure appropriate to the valuation — rather than feeding the model's own live calculated enterprise value back into the weights. This breaks the circular dependency entirely and is the approach used in most institutional DCF models.
When is controlled iterative calculation used instead of target weights?
When the analysis specifically requires the capital structure weights to reflect the model's own converged output value — for example, testing whether a particular capital structure is self-consistent with the value it produces. In this case, iterative calculation is enabled with documented Maximum Iterations and Maximum Change settings and a convergence check cell.
What does an unresolved WACC circularity look like in Excel?
If iterative calculation is disabled, Excel displays a circular reference warning and the affected cells show zero, propagating zero through every dependent calculation. If iterative calculation is enabled without documented convergence controls, the model may calculate a value, but that value may not be reproducible from a different starting position or on a different machine.
How do you test that a WACC circularity resolved by iterative calculation has converged correctly?
Save the model after it converges, close it, reopen it, and let it recalculate from a fresh (typically zero) starting position. Compare the resulting WACC, enterprise value, and equity value to the previously saved figures. A material difference indicates the model has not converged to a stable, reproducible solution.
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.
Circular Reference
A circular reference occurs when a formula in a financial model depends, directly or through a chain of intermediate cells, on its own value. Excel flags circular references by default and returns zero in the affected cells unless iterative calculation is enabled. In financial models, circular references arise most often in interest-on-debt calculations, cash sweep mechanics, and tax shield computations — some are structural errors, others reflect genuine simultaneous financial relationships. The distinction between the two, and how each is handled, is addressed in full on the dedicated technical guide linked below.
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.
Discounted Cash Flow (DCF) Valuation
Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.