Qm
Core

Sanity-Checking a Finished DCF

A DCF can be built without a single arithmetic error and still be nonsense, the numbers need to be checked against the real world, not just against each other.

Prerequisites: The Gordon Growth Terminal Value, The Growth = ROIC x Reinvestment Identity

A DCF can pass every formula check, the discounting is correct, the terminal value formula is applied properly, the model ties out to the penny, and still imply that a mid-size regional retailer will be worth more than the entire US economy in forty years. The model isn't broken; the assumptions feeding it are. Checking a DCF's internal arithmetic is necessary but nowhere near sufficient, the numbers it spits out need to be checked against what's actually plausible in the real world.

A finished DCF should always be tested against a short list of external sanity checks, comparisons to peer multiples, growth-rate ceilings, terminal-value share of total value, and reasonableness of implied return on capital, because internal consistency alone cannot catch an assumption that is arithmetically fine but economically absurd.

The checks that catch the most damage

Terminal value as a share of total value. If the terminal value makes up 85–95% of a DCF's total value, nearly the entire valuation rests on assumptions about a period more than a decade out, which should be flagged and stress-tested even if the near-term forecast is well-researched.

Perpetual growth rate versus the economy. A company's cash flows cannot grow faster than the overall economy forever, a terminal growth rate above roughly the long-run nominal GDP growth rate (commonly 2–4% for developed economies) implies the company eventually becomes the entire economy, which is not a plausible steady state.

Implied return on capital in the terminal year. If the terminal-year numbers imply a return on invested capital far above what any company in the industry has sustained historically, the growth and margin assumptions feeding the model deserve a second look.

Cross-check against multiples. If the DCF's implied valuation is wildly out of line with what comparable companies actually trade at, that's not automatically a sign the market is wrong, it's a prompt to check whether the DCF's assumptions (growth, margin, discount rate) are actually defensible, or whether an error has crept in.

finished DCF output TV % of value growth vs GDP implied ROIC multiples cross-check
Every finished DCF should pass through the same four external checks before its output is trusted, regardless of how carefully the model itself was built.

Worked example

A DCF for a consumer goods company produces an enterprise value of $8.0 billion, of which the terminal value contributes $7.4 billion.

  1. Terminal value share: 7.4/8.0=92.5%7.4/8.0 = 92.5\%, a flag that nearly the entire valuation rests on the terminal-year assumptions.
  2. Checking the terminal assumptions: the model uses a 4.5% perpetual growth rate, above the roughly 2.5% long-run nominal GDP growth typically used as a ceiling, a second flag.
  3. Checking implied ROIC in the terminal year: the model's terminal operating income and invested capital imply a 35% return on invested capital, well above this industry's historical range of 12–16%, a third flag, and now a pattern.
  4. Cross-check against peers: comparable consumer goods companies trade at 12x EV/EBITDA; this DCF's $8.0 billion implies roughly 19x the company's current EBITDA, well outside the peer range, consistent with the three flags already raised.

Lowering the terminal growth rate to 2.5% and the implied terminal ROIC to a level consistent with peers brings the DCF down to roughly $5.1 billion, in line with the peer multiple range, and a far more defensible number than the original $8.0 billion.

What this means in practice

Sanity checks are cheapest to run, and most valuable, at the very end of a DCF build, once every number is in place, running them earlier means re-checking after every subsequent change, but skipping them entirely is how obviously wrong valuations survive into a final report. A DCF that fails several of these checks isn't necessarily useless, but every failed check should trace back to a specific assumption that gets revisited and explicitly justified, not silently left as-is.

A model that "ties out", every cell references correctly, every formula computes without error, is not the same thing as a model that's right. Internal consistency only proves the arithmetic is correct given the assumptions; it says nothing about whether the assumptions themselves are plausible, which is exactly what these external checks exist to catch.

Discussion

Sign in to join the discussion · reading is open to everyone

💡 Discussion rules

  1. Ask and answer about this concept. Off-topic gets removed.
  2. No homework dumps. Show what you tried first.
  3. Corrections are welcome. Cite a source when you claim an error.

Loading discussion…

Related concepts

Practice in interviews

Further reading

  • Damodaran, Investment Valuation (ch. 'Loose Ends in Valuation')
ShareTwitterLinkedIn