Guide · 2026-07-12 · 7 min read
Written and reviewed by Project Financial Advisor · FCA · CGMA · ACMA — Chartered Accountant
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
A worked two-way sensitivity table
Consider a DCF with a base enterprise value of $50m at a 10% WACC and 2.5% terminal growth. A two-way table recalculates value as both inputs vary: at 9% WACC value might rise to $58m, and at 11% fall to $44m; raising terminal growth to 3.5% lifts each column further. The grid shows the plausible range — say $40m to $60m — far more honestly than a single $50m point estimate.
Flex the inputs the output is most sensitive to and least certain about: usually revenue growth, margin, WACC and terminal assumptions. Flexing an input the model barely responds to wastes effort and clutters the analysis.
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.
From analysis to decision
Sensitivity and scenario work only earns its keep when it changes a decision. Once the tables are built, translate them into action: identify the two or three assumptions that move the outcome most, quantify the downside case in the metric that matters — covenant headroom, runway, valuation — and decide in advance what you will do if it materialises. A model that shows the business survives the downside, and names the trigger points for management action, is far more persuasive to a board or lender than a single confident base case. The goal is not to predict the future precisely but to understand which uncertainties are worth managing and which the plan can absorb.
Frequently asked questions
What is the difference between sensitivity and scenario analysis?
Sensitivity analysis changes one input at a time to see its isolated impact. Scenario analysis changes several inputs together into coherent cases — base, upside, downside — to model realistic combinations.
How do I build a two-way sensitivity table?
Use a data table that varies two inputs — for example WACC and terminal growth — across a grid, recalculating the output such as enterprise value in each cell to show the range.
Why is sensitivity analysis important?
A single forecast implies false precision. Sensitivity and scenario analysis reveal which assumptions drive the outcome and the plausible range, so decisions account for risk.
→ 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) of the Institute of Chartered Accountants of Pakistan (ICAP), 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 16-sheet model