Tornado Analysis for DCF Valuation
Executive Summary
Key Takeaways
- ✓ A tornado chart ranks a DCF's assumptions by the size of their individual effect on value, from largest to smallest, using a horizontal bar for each variable's output range.
- ✓ Tornado charts are built from a series of one-way sensitivity calculations, one per variable, each varied across a defined range while holding everything else at its base case.
- ✓ The chart's name comes from its characteristic shape once sorted — the widest bar (biggest impact) at the top, narrowing toward the bottom.
- ✓ Terminal growth rate and discount rate typically produce the widest bars in a DCF tornado chart, consistent with their outsized combined effect on terminal value.
- ✓ A tornado chart identifies which assumptions deserve the most diligence attention; it does not itself show how two variables interact, which is the role of a two-way sensitivity table.
Institutional Definition¶
A tornado chart ranks a DCF's key assumptions by the size of their individual effect on value, presenting each variable's output range as a horizontal bar sorted from largest to smallest impact. The resulting shape — widest bar at the top, narrowing toward the bottom — gives the chart its name, and its purpose is to identify which assumptions deserve the most scrutiny in a valuation.
How a Tornado Chart Differs From Other Sensitivity Tools¶
| Tornado Chart | Two-Way Sensitivity Table | Scenario Analysis | |
|---|---|---|---|
| Variables tested | Many, one at a time | Two, jointly | Many, together as a named combination |
| Purpose | Rank variables by individual impact | Show how two variables interact | Test specific, coherent narratives |
| Typical output | Ranked horizontal bar chart | Grid of output values | Small table of named-case outputs |
See Sensitivity Analysis for DCF Valuation for the two-way table construction and Scenario Analysis for DCF Valuation for the named-case approach — a tornado chart is the third, complementary diagnostic, answering "which assumption matters most" rather than "what happens under this specific combination."
Building a Tornado Chart¶
- Select the candidate variables — typically WACC (or cost of equity), terminal growth rate or exit multiple, revenue growth rate, margin assumptions, and capital expenditure intensity
- Calculate a one-way sensitivity range for each variable individually, holding every other assumption at its base case value — for example, recalculate enterprise value at the low and high end of a defined WACC range, with growth rate and every other assumption held constant
- Compute each variable's output range (high value minus low value)
- Sort the variables by the size of their output range, from largest to smallest
- Plot each variable as a horizontal bar spanning its low-to-high output values, in the sorted order — the widest bar (largest range) at the top
Why Terminal Value Drivers Typically Dominate¶
In most DCF tornado charts, WACC and the terminal growth rate (or exit multiple) produce the two widest bars, reflecting terminal value's outsized share of total DCF value. This is a useful visual confirmation of a point emphasized throughout this Knowledge Centre's DCF coverage: the assumptions governing the cash flows beyond the explicit forecast period typically matter more to the final valuation conclusion than most individual explicit-period operating assumptions.
Using the Tornado Chart to Prioritize Diligence¶
The tornado chart's practical value is in prioritizing scrutiny: the variables with the widest bars are where additional diligence, sourcing rigor, and cross-checking against external benchmarks deliver the most value. A reviewer with limited time should spend it verifying the discount rate build-up and terminal value methodology before, for example, testing every individual working capital driver assumption, if the tornado chart confirms the former have the larger effect on the conclusion.
Structural Audit Checks¶
| Check | What It Confirms |
|---|---|
| Each bar's low/high range is calculated from the model's actual live output, not a hardcoded estimate | The chart reflects the model as built, not an approximation |
| Every other assumption is held at base case while each variable is tested individually | Each bar genuinely isolates one variable's effect, uncontaminated by simultaneous changes elsewhere |
| The tested range for each variable is disclosed | The reader can assess whether the ranges themselves are reasonable |
| The tornado chart is presented alongside, not instead of, a two-way sensitivity table for the top-ranked variable pair | Variable interaction, which the tornado chart cannot show, is still disclosed |
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Inconsistent ranges across variables | Some variables tested at ±10%, others at ±1%, with no disclosed rationale | Rankings reflect the arbitrary choice of test range rather than genuine relative sensitivity |
| Variables not held constant during each individual test | Other assumptions inadvertently allowed to vary while testing one variable | The isolated impact attributed to that variable is contaminated |
| Tornado chart presented as the only sensitivity disclosure | No two-way table or scenario summary included | Variable interaction and coherent-narrative outcomes are not disclosed |
Continue Reading¶
Prerequisites¶
- Discounted Cash Flow (DCF) Valuation — the parent pillar
- Sensitivity Analysis for DCF Valuation
Related Technical Guides¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is a tornado chart?
A horizontal bar chart ranking a set of assumptions by the size of their individual effect on a model's output, sorted from the largest-impact variable at the top to the smallest at the bottom, producing a shape that narrows toward the bottom like a tornado.
How do you build a tornado chart for a DCF?
Calculate a one-way sensitivity range (low and high output value) for each candidate assumption individually, holding all other assumptions at their base case. Compute the output range (high minus low) for each variable, sort the variables by that range from largest to smallest, and plot each as a horizontal bar spanning its low-to-high output values.
Which assumptions are typically included in a DCF tornado chart?
WACC (or cost of equity), terminal growth rate or exit multiple, revenue growth rate, margin assumptions, and sometimes capital expenditure intensity — the same set of drivers addressed in sensitivity and scenario analysis, ranked here by relative impact rather than tested jointly.
Why does terminal growth rate or WACC usually produce the widest bar?
Because terminal value typically represents the majority of total DCF value, and both the discount rate and the terminal growth assumption drive terminal value directly through the perpetuity growth or exit multiple formula, giving them an outsized effect on total value relative to most explicit-period operating assumptions.
Does a tornado chart replace a two-way sensitivity table?
No. A tornado chart shows the isolated impact of each variable individually, ranked by size, which is useful for prioritizing diligence effort. It does not show how two variables interact when varied jointly, which is the specific purpose of a two-way sensitivity table.
What is the difference between a tornado chart and a scenario summary?
A tornado chart isolates one variable at a time to rank individual impact. A scenario summary tests a small number of named, multi-variable combinations representing coherent narratives (base, upside, downside). They serve different diagnostic purposes and are typically presented together.
Related Articles
Sensitivity Analysis for DCF Valuation
Sensitivity analysis tests how a DCF's enterprise or equity value output changes as key assumptions are varied, most importantly the discount rate and the terminal growth rate or exit multiple, given their disproportionate combined effect on total value. This guide sets out how to build one-way and two-way sensitivity tables for a DCF specifically, which variable pairs are most informative to test together, and how to interpret the resulting output as a decision input rather than a single point estimate.
Scenario Analysis for DCF Valuation
Scenario analysis tests a DCF's value output under a small number of internally consistent, named states of the world — typically base, upside, and downside cases — where every driving assumption changes together as a coherent set, in contrast to sensitivity analysis, which isolates the effect of one or two variables at a time. This guide sets out how to build a scenario switch mechanism in a DCF model, the discipline required to keep each scenario's assumptions genuinely internally consistent, and how scenario output should be presented alongside sensitivity analysis rather than as a substitute for it.
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.