Circular Reasoning in Valuation Models

Introduction

Valuation models contain a philosophical problem that most junior analysts never notice but that sits at the foundation of the entire DCF framework: the output of the model (the company's value) is used as an input to the model (the capital structure weights in WACC). This creates a logical circularity that, if unaddressed, means the model is solving for a number that depends on itself.

Understanding where these circularities arise, why they are inherent to the valuation framework (not errors to be eliminated), and how to resolve them demonstrates modeling sophistication that goes beyond formula memorization.

The Problem

WACC requires market value weights for debt and equity. The equity weight is the company's market capitalization divided by total capital. But for a private company (or when the analyst believes the market is mispricing a public company), the "correct" equity value is the output of the DCF, which uses WACC as the discount rate. So the discount rate depends on the value, and the value depends on the discount rate.

Three Practical Resolutions

Use the current market value. For public companies, the current market cap provides the equity weight without circularity. The analyst accepts the market's assessment of capital structure even if the DCF will produce a different equity value. This is the most common approach in investment banking and is appropriate when the analyst does not believe the market is dramatically mispricing the stock.

Use the peer group median capital structure. Instead of the target's own equity value, use the median D/E ratio of the peer group. This avoids self-referencing entirely and produces a WACC that reflects industry-typical financing. This approach is standard for private company valuations where there is no observable market cap.

Iterate until convergence. Start with an assumed capital structure, calculate WACC, run the DCF, use the implied equity value to recalculate the weights, recalculate WACC, and repeat. Convergence is rapid (3-5 rounds) because WACC's sensitivity to small changes in capital structure weights is modest. An initial guess that is 20% off typically produces a WACC error of only ~30 basis points, and each iteration narrows the error by 70-80%.

Valuation Circularity

A logical loop in a financial model where the output (the company's value) is used as an input to the calculation that produces the output. The most common valuation circularity is the WACC loop: WACC requires equity value (to calculate capital structure weights), but equity value is the output of the DCF (which uses WACC as the discount rate). Other circularities include the interest expense loop in three-statement models and the terminal value loop (the exit multiple implies a growth rate that may not match the terminal growth assumption). These circularities are not errors; they reflect the genuine interdependence of financial variables.

The three-statement model and LBO debt schedule create a mechanical circular reference in Excel: interest expense depends on the debt balance, which depends on cash flow (through mandatory and optional repayments), which depends on net income, which depends on interest expense.

This circularity is unavoidable because the optional prepayment amount depends on how much cash remains after paying interest, but the interest amount depends on how much debt was prepaid.

Iterative Calculation (in Financial Modeling)

An Excel setting that allows the spreadsheet to recalculate circular formulas multiple times until the results converge to a stable value. Enabled through File > Options > Formulas > "Enable iterative calculation," it is configured with a maximum number of iterations (typically 100) and a convergence threshold (typically 0.001). Iterative calculation is the standard resolution for both the debt schedule circularity and the WACC circularity. The key risk: if the model contains an unintentional circular reference (an error), iterative calculation will silently converge to an incorrect value, which is why the circuit breaker toggle is essential for debugging.

Resolution: Enable iterative calculations in Excel or build a circuit breaker toggle that breaks the circularity for debugging. A third option (using only the beginning-period debt balance for interest, rather than the average) eliminates the circularity but is slightly less accurate. Some banks prefer this simplification for models that will be shared externally, where iterative calculation may not be enabled on the recipient's Excel installation.

A less commonly discussed but equally real circularity affects the beta calculation. Relevering beta uses the target's D/E ratio, where equity is the market value. But if the DCF is being built to determine the equity value, the D/E ratio depends on the output. The relevered beta feeds into cost of equity, which feeds into WACC, which determines the equity value, which determines the D/E used to relever beta.

This nested circularity compounds the WACC circularity. In practice, it is resolved by the same methods: using the current market D/E for public companies, the peer group median D/E for private companies, or iterating. Because beta's sensitivity to small D/E changes is modest (a 10% change in D/E typically shifts beta by only 5-8%), this circularity has less practical impact than the WACC circularity.

When using the exit multiple method for terminal value, the analyst applies a market-based multiple to calculate the terminal value in what is supposed to be an intrinsic (market-independent) valuation. This introduces a logical tension: the DCF claims to value the company independently of market pricing, yet the terminal value (which accounts for 60-80% of total value) is derived from market multiples.

The deeper circularity is that the exit multiple itself should reflect the company's characteristics at the terminal date, which depend on the projections, which are inputs to the DCF. The analyst is simultaneously estimating the company's future state and the market's assessment of that state.

Resolution: Cross-check every exit multiple-based terminal value by calculating the implied perpetuity growth rate. If the implied rate is above 4-5% or below 0%, the exit multiple should be revisited. This cross-check does not eliminate the circularity but ensures internal consistency between the two terminal value approaches.