Checking Valuation Reasonableness — Check reasonableness of valuation outputs and sensitivity ranges

Corporate valuation has always carried an inherent tension between analytical precision and practical judgment. The earliest applications of discounted cash flow (DCF) analysis in the mid-twentieth century gave practitioners a rigorous mathematical framework, but they soon discovered that small changes in assumptions—growth rates, discount rates, terminal values—could produce wildly divergent outputs. This realization created a demand for systematic methods of checking whether a valuation's results were reasonable, internally consistent, and aligned with observable market data. Over the decades, the field developed a set of best practices for reasonableness checking that now forms an essential part of any credible financial analysis.

The central question this lesson addresses is deceptively simple: once you have computed a valuation, how do you know it makes sense? A DCF model might produce a precise-looking number—say, $47.23 per share—but that precision is meaningless if the underlying assumptions are flawed. Checking reasonableness means subjecting your output to a battery of tests that compare implied metrics against economic reality, industry benchmarks, and the internal logic of the model itself.

Reasonableness checking is not a single technique but a disciplined mindset organized around several foundational principles. These principles provide the intellectual scaffolding for every specific test you will learn to apply. A competent analyst internalizes these ideas so deeply that checking becomes a reflexive part of the valuation process, not an afterthought appended at the end.

The following diagram illustrates the end-to-end process of checking valuation reasonableness. It shows how raw model outputs feed into four parallel checking lanes—internal consistency, external benchmarking, sensitivity analysis, and economic plausibility—before converging into a final valuation range that can be presented with confidence. Each lane produces diagnostic signals that may loop back to the model for assumption revision.

Notice that the process is inherently iterative. A flag raised in the sensitivity analysis lane—say, the discovery that your valuation doubles when WACC drops by 100 basis points—might prompt you to revisit your cost of capital estimation. Similarly, an external benchmarking test that reveals your implied P/E ratio is three times the peer median could indicate that your revenue growth assumptions are overly aggressive. The four lanes are not independent silos; they interact and reinforce one another, collectively building confidence in the final output.

The quantitative backbone of reasonableness checking rests on understanding how valuation formulas respond to changes in their inputs. The Gordon Growth Model (perpetuity growth model) provides a clean analytical setting for illustrating sensitivity because its terminal value formula has a closed-form solution. Most DCF models use this formula—or a variant of it—to estimate the value of cash flows beyond the explicit forecast period.

The sensitivity of terminal value to changes in WACC or g is governed by the denominator (WACC − g). As this spread narrows, the terminal value increases exponentially. This mathematical property explains why small errors in either parameter can produce enormous changes in valuation. Formally, the partial derivative of terminal value with respect to g reveals the magnitude of this sensitivity.

A sensitivity table (sometimes called a data table or football field chart) is the analyst's primary tool for stress-testing a valuation. The standard format is a two-dimensional matrix that varies two key inputs simultaneously—most commonly WACC on one axis and the terminal growth rate on the other—and displays the resulting equity value per share in each cell. The table reveals not only the base-case value but also the range of plausible outcomes and the steepness of the valuation surface.

Several diagnostic insights emerge from a well-constructed sensitivity table. First, the asymmetry of sensitivity is immediately visible: moving from the base case upward (increasing g) produces larger absolute value changes than moving downward (decreasing g). This is a direct consequence of the 1/(WACC − g)² relationship discussed in Section 4. Second, the table reveals the valuation range—in this case, $28 to $133—which tells you how much uncertainty is embedded in your model. A range that spans a factor of nearly 5× is a signal that your valuation is highly assumption-dependent and should be presented with appropriate caveats.

• Red flag #1: If the ratio of the highest to lowest value in the table exceeds 3×, the model is highly sensitive and the base-case estimate should be treated with skepticism.
• Red flag #2: If the base case falls near the edge of the table (rather than the center), your assumption set may be biased toward an optimistic or pessimistic outcome.
• Red flag #3: If any cell implies a negative enterprise value, you have crossed a mathematical boundary (WACC < g), and those scenarios are economically meaningless.

Suppose you have completed a DCF analysis of MidWest Manufacturing Co. and arrived at an enterprise value of $2.4 billion. The company has $400 million in net debt, 100 million diluted shares outstanding, and your model projects Year 1 FCF of $150 million with a terminal growth rate of 3.5% and a WACC of 8.5%. Let us walk through a comprehensive reasonableness check.

Reasonableness checking is a powerful complement to the valuation process, but it is not a substitute for sound initial assumptions. Understanding where the practice excels and where it falls short allows the analyst to deploy it effectively while remaining aware of its limitations.

The reasonableness checks covered in this lesson represent the foundational layer of a much deeper analytical toolkit. As you advance in corporate finance, you will encounter more sophisticated methods for stress-testing valuations and quantifying uncertainty. The table below maps each basic check to its advanced counterpart, providing a roadmap for future study.

The progression from basic to advanced is not about replacing simpler tools with more complex ones. Even experienced practitioners who routinely run Monte Carlo simulations still begin with a sensitivity table, because the two-variable format is the fastest way to identify which parameters deserve the most analytical attention. Advanced methods layer additional rigor on top of this foundation; they do not render it obsolete.