Scenario Analysis for DCF Valuation
Executive Summary
Key Takeaways
- ✓ Scenario analysis tests a small number of named, internally consistent states of the world (base, upside, downside), where every relevant assumption changes together as a coherent set.
- ✓ This is structurally different from sensitivity analysis, which isolates the effect of one or two variables in isolation while holding everything else constant.
- ✓ A scenario manager should be built as a single switch cell driving every scenario-dependent assumption from one shared assumptions block, not as three separately built, parallel models.
- ✓ Each named scenario should represent a genuinely coherent narrative — an upside case with higher growth but also higher discount rate assumptions, for example, needs an explicit rationale for why both move together.
- ✓ Scenario analysis and sensitivity analysis are complementary, not substitutes — a DCF disclosure benefits from both.
Institutional Definition¶
Scenario analysis tests a DCF's value output under a small number of named, internally consistent states of the world — typically base, upside, and downside cases — where every relevant driving assumption changes together as a coherent narrative. This is structurally distinct from sensitivity analysis, which isolates the effect of one or two variables while holding everything else constant.
Scenario Analysis vs. Sensitivity Analysis¶
| Scenario Analysis | Sensitivity Analysis | |
|---|---|---|
| What varies | Multiple assumptions together, as a named, coherent combination | One or two specific variables, isolated |
| Purpose | Test a small number of specific, analyst-chosen narratives | Systematically show output across a full range of a given variable |
| Typical output | Base / Upside / Downside value for each named case | A one-way or two-way grid of outputs across a variable range |
| Complements | Sensitivity analysis (they are used together, not as substitutes) | Scenario analysis |
Both are addressed as general concepts on the Scenario Analysis glossary page; this guide focuses on their construction specifically within a DCF.
Building a Scenario Manager¶
The correct structural approach is a single switch cell — a dropdown list or numbered toggle — that drives every scenario-dependent assumption from one shared assumptions block, using a lookup formula (INDEX/MATCH, CHOOSE, or an equivalent) referencing the switch. Each scenario-dependent assumption (revenue growth, margin, capex intensity, and where relevant discount rate or terminal growth) is entered once per scenario in the shared block, and the switch selects which column feeds the live calculation.
The common structural error is building each scenario as a separate, duplicated copy of the entire model, rather than a single model driven by a shared switch. Duplicated copies are prone to silently drifting out of consistency with each other: a formula fix or assumption update made in the base case copy may not be replicated into the upside and downside copies, producing scenarios that no longer share a consistent structural foundation even if their headline assumptions still look aligned.
Constructing a Genuinely Coherent Narrative¶
Each named scenario should represent an internally coherent story, not simply a mechanically higher or lower set of numbers. An upside case with a higher growth rate but also, without explicit rationale, a lower discount rate compounds two favourable assumption changes in a way that can produce an implausibly optimistic combined result. Where a scenario changes both operating and risk assumptions together, the model (or its accompanying documentation) should state the rationale for why they move together, not leave the combination unexplained.
Which assumptions typically vary between scenarios: - Revenue growth rate and trajectory - Margin assumptions - Capital expenditure intensity - Working capital efficiency - Less commonly, and only with explicit rationale: discount rate or terminal growth rate
Presenting Scenario Output¶
Scenario output is typically presented as a simple summary table — enterprise value, equity value, or value per share for each named case — alongside, not instead of, the sensitivity tables addressed in the companion Sensitivity Analysis for DCF Valuation guide. Presenting only a base case scenario value, with no upside/downside range and no sensitivity table, is materially incomplete for investment committee purposes.
Structural Audit Checks¶
| Check | What It Confirms |
|---|---|
| A single switch cell drives all scenario-dependent assumptions from one shared block | Scenarios are structurally linked, not maintained as separate, potentially drifting copies (R011, R024) |
| Each scenario's assumption combination has a stated rationale | The scenario represents a coherent narrative, not an arbitrary mechanical adjustment |
| The discount rate is held constant across scenarios unless a specific, disclosed rationale exists for varying it | Scenario output isolates the effect of operating assumptions unless risk itself is deliberately being tested |
| Scenario output is presented alongside sensitivity tables, not as a substitute for them | The DCF disclosure captures both types of uncertainty, not just one |
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Duplicated model copies per scenario | Each scenario built as a separate workbook or sheet rather than driven by a shared switch | Scenarios can silently drift out of consistency as the model is updated |
| Unexplained assumption combinations | Multiple assumptions changed together with no stated rationale for why | Scenario output may represent an implausible or internally inconsistent narrative |
| Scenario analysis presented alone | No sensitivity table accompanying the scenario summary | Reader cannot see how sensitive each scenario's output is to its own individual assumptions |
Continue Reading¶
Prerequisites¶
- Discounted Cash Flow (DCF) Valuation — the parent pillar
- Scenario Analysis
Related Technical Guides¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the difference between scenario analysis and sensitivity analysis in a DCF?
Sensitivity analysis isolates the effect of one or two specific variables, holding everything else constant, to show how output responds to a change in that variable alone. Scenario analysis tests a small number of named, internally consistent combinations of many assumptions changing together, representing a coherent narrative such as a base, upside, or downside case.
How do you build a scenario manager in a DCF model?
Build a single switch cell (a dropdown or numbered toggle) that drives every scenario-dependent assumption from one shared assumptions block, using a lookup or IF/CHOOSE formula referencing the switch, rather than building three separate, parallel copies of the model for each scenario.
What assumptions typically differ between DCF scenarios?
Revenue growth rate, margin trajectory, capital expenditure intensity, and sometimes the discount rate or terminal growth rate, depending on whether the scenario reflects a different operating outcome only or also a different risk assessment.
Should the discount rate change between scenarios?
Only if there is a genuine rationale for the underlying business risk changing between scenarios — otherwise, holding the discount rate constant across scenarios and varying only the operating assumptions isolates the effect of the operating outcome itself, which is usually the more informative construction.
Can scenario analysis replace sensitivity analysis?
No. Scenario analysis shows the output under a small number of specific, named combinations chosen by the analyst. Sensitivity analysis systematically shows output across a full range of a given variable. They answer different questions and are typically presented together.
What is a common structural error in building DCF scenarios?
Building each scenario as a separate, duplicated copy of the model rather than a single model driven by a shared scenario switch. This makes it easy for the scenarios to silently drift out of consistency with each other as the model is updated, since a change made to one copy may not be replicated to the others.
Related Articles
Scenario Analysis
Scenario analysis is the process of recalculating a financial model's outputs under a defined set of alternative assumptions that together represent a coherent possible future state. Each scenario changes multiple assumptions simultaneously to reflect a plausible economic environment or operational outcome — for example, a scenario in which both construction costs are higher than expected and revenue is lower than expected during the ramp-up phase. Scenario analysis is distinct from sensitivity analysis, which changes one variable at a time while holding all others constant. Scenario analysis tests the model under internally consistent combinations of assumptions; sensitivity analysis tests the model's response to changes in individual variables in isolation.
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.
Tornado Analysis for DCF Valuation
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, producing the characteristic tornado-shaped visual. This guide sets out how to construct a tornado chart from a DCF model's one-way sensitivity outputs, which variables are typically included, and how a tornado chart complements rather than replaces the two-way sensitivity tables and scenario summaries addressed elsewhere in this Knowledge Centre.
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.