Family Office Discovers a Circular WACC Reference Masking an Understated Discount Rate
Executive Summary
Illustrative Scenario
This case study is a composite, educational scenario built from patterns commonly observed in financial model reviews. It does not describe a specific, identifiable client engagement, and any resemblance to a particular transaction is coincidental.
Background¶
A family office was evaluating a proposed direct investment in a private operating company, supported by an investment memo built around a DCF valuation. The memo's model calculated WACC using the target's projected capital structure, consistent with the approach described in How to Build WACC (Step-by-Step), and used that WACC to discount projected free cash flows to arrive at a recommended enterprise value.
The Problem¶
Ahead of presenting the investment to the family's investment committee, the office's external advisor conducted a structural review of the memo's underlying model and traced how the WACC figure had actually been calculated, rather than accepting the final percentage shown in the memo's summary output.
Findings¶
The advisor found that the model's capital structure weights, used to calculate WACC, were themselves derived from the DCF's own output enterprise value, which in turn depended on the WACC used to discount the cash flows — a circular reference that the spreadsheet had been set to resolve through iterative calculation, silently enabled at the application level with no documented convergence tolerance or maximum iteration count recorded anywhere in the model or the memo.
Root Cause¶
Because the iterative calculation setting had been enabled without any documented tolerance or record of how many iterations the calculation had run, the circular loop had converged to a capital structure weighting implying a higher proportion of lower-cost debt than the target's actual, sustainable capital structure supported, producing a blended WACC lower than a properly resolved calculation would have shown, and consequently overstating the enterprise value that the memo recommended.
Risk¶
Had the investment committee approved the direct investment on the strength of the memo as originally presented, the recommended valuation would have rested on a discount rate understated by an uncontrolled circular calculation, overstating the investment's implied value and understating the return the family office would need to see for the risk actually being taken.
Resolution¶
The advisor rebuilt the WACC calculation using a standard structural workaround — holding capital structure weights fixed at a target, market-benchmarked level rather than allowing them to circle back to the DCF's own output — consistent with the resolution approaches described in Resolving WACC Circularity in a DCF Model. The revised, non-circular WACC produced a materially lower enterprise value, which the advisor presented to the investment committee alongside a clear explanation of the original circularity and its effect.
Lessons Learned¶
- A circular WACC reference is not merely a spreadsheet mechanics issue — left uncontrolled, it can silently converge to a discount rate that understates risk without any single formula appearing incorrect on inspection.
- Iterative calculation settings enabled without documented convergence tolerances or iteration counts should be treated as a structural red flag in any model presented to support an investment decision.
- Tracing how a summary output figure like WACC was actually derived, rather than accepting the final percentage shown, is what surfaced a circularity that would not have been visible from the memo alone.
- A standard structural workaround — fixing capital structure weights at a target level rather than letting them depend on the DCF's own output — resolves the circularity without sacrificing the model's underlying logic.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Is this a real client engagement?
No. This is an illustrative, composite scenario built from patterns commonly observed in investment memo model reviews. It does not describe a specific, identifiable transaction.
What is a circular WACC reference in a DCF model?
A situation where the weighted average cost of capital depends on the capital structure weights, which in turn depend on the enterprise value the DCF is trying to calculate, which itself depends on the WACC used to discount the cash flows — a genuine circular dependency that requires either iterative calculation or a structural workaround to resolve.
Why is an uncontrolled circularity dangerous rather than just a technical inconvenience?
Because when iterative calculation is silently enabled without documented convergence settings, the spreadsheet will converge to some numeric answer without flagging whether that answer is stable, reasonable, or has settled into a value that understates the true discount rate, all while every individual formula appears to be functioning normally.
How did the WACC end up understated specifically?
The iterative calculation had converged toward a capital structure weighting that assumed a higher proportion of lower-cost debt than the target's actual, sustainable capital structure supported, feeding a lower blended WACC back into the enterprise value calculation that had produced that same weighting.
How is this different from a simple input error in the WACC build?
A simple input error is usually visible on inspection of the formula or the assumption itself. A circularity issue is not visible in any single formula — the WACC calculation and the enterprise value calculation each look internally consistent; the problem only appears when tracing the full circular dependency and the convergence behavior it produced.