Sensitivity and Scenario Analysis in Financial Modeling

How sensitivity and scenario analysis stress-test a financial model — one-variable tables, base, upside and downside cases, and why investors expect both.

A single-point forecast is a guess dressed up with decimals. Sensitivity and scenario analysis are the techniques that turn a model from a false-precision exercise into a decision tool by showing how the answer moves when the assumptions move. They are what separate a credible model from an optimistic one, and investors expect to see them.

Sensitivity analysis: one variable at a time

Sensitivity analysis flexes a single input across a range and records the effect on an output. In a DCF, the classic is a two-way table of enterprise value against WACC and terminal growth, because those two assumptions move the valuation most. It answers 'how much does the answer change if this input is wrong?' and reveals which assumptions the conclusion actually hinges on.

Scenario analysis: coherent sets of assumptions

Scenario analysis changes several inputs together into internally consistent stories — typically a base case, an upside and a downside. Rather than asking 'what if growth is 2% higher', it asks 'what does the world look like if the product succeeds' versus 'if adoption is slow', flexing growth, margin, churn and timing together. It is more realistic than single-variable sensitivity because real outcomes move variables in bundles.

Why both matter

Sensitivity finds the model's pressure points; scenarios test survivability. Together they answer the two questions a decision-maker has: which assumption should I worry about most, and can the business withstand a bad but plausible world? A model that shows only a base case invites the reader to distrust it.

Building them well

Keep assumptions in one place so a scenario is a switch, not a rebuild. Flex inputs, never hard-coded outputs. Choose ranges that are plausible rather than symmetric for its own sake — downside cases should reflect real risks like slower collections, a delayed launch or a rate rise. And always include the downside; investors respect a founder who has visibly stress-tested the pessimistic case.

A worked example

Suppose a DCF gives a base enterprise value of $10m at 12% WACC and 2.5% terminal growth. A sensitivity table might show the value ranging from $8.2m (13% WACC, 2% growth) to $12.5m (11% WACC, 3% growth) — a wide band that tells you the valuation is highly sensitive to the discount rate, so the WACC build deserves extra scrutiny. That range, not the single $10m, is the honest answer.

Automate it

EasyFinancialModels builds two-way sensitivity tables on WACC, terminal growth, revenue and margin automatically, and lets you flex a full downside scenario by editing the assumptions. Build a model free for up to 3 years and present a range, not a false-precision point estimate.

→ Build your financial modeling model free with the Financial Model tool

More Financial Modeling guides

How to Build a Financial Model in Excel · Quarterly Financial Model: When to Use Quarterly Forecasts Instead of Annual Models · Industry Financial Model Templates: How to Choose the Right Revenue Drivers · How to Build a Startup Financial Model for Investors · The Three-Statement Financial Model Explained

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model