Scenario analysis compares financial results under coherent alternative assumptions, revealing downside exposure without treating cases as forecasts.
Scenario analysis compares financial outcomes under alternative sets of assumptions that describe different possible conditions. A scenario might combine weaker demand, slower cash collection, and higher input costs to show how a business plan behaves under pressure.
It answers “What would happen if these conditions occurred?” It does not, by itself, say how likely those conditions are.
Start with a specific question and horizon, such as whether a one-year project creates value or whether a company can meet payments during a downturn.
Then identify the linked drivers. Lower demand might reduce sales receipts while supplier prices rise. A delayed project opening might postpone receipts without postponing every cash payment. Explain those links rather than arbitrarily changing all inputs by the same percentage.
For each case, document the assumptions, calculate the result using the same model, and identify what would change the conclusion. NYU Stern’s probabilistic approaches to risk discusses scenario selection and the distinction between scenario analysis and simulation.
Assume a hypothetical launch requires USD 100,000 today. For a simplified comparison, treat all subsequent receipts and payments as occurring at the end of year one, use a 10% annual discount rate, and assume no taxes, residual value, or other cash flows.
The rates and amounts are teaching assumptions, not market estimates.
| Case | Operating assumptions | Cash receipts | Cash payments | Net cash inflow |
|---|---|---|---|---|
| Downside | Lower sales and higher input costs | USD 130,000 | USD 50,000 | USD 80,000 |
| Base | Planned sales and input costs | USD 160,000 | USD 40,000 | USD 120,000 |
| Upside | Stronger sales with additional fulfillment costs | USD 200,000 | USD 50,000 | USD 150,000 |
For each case:
| Case | Present value of net cash inflow | NPV |
|---|---|---|
| Downside | USD 72,727.27 | -USD 27,272.73 |
| Base | USD 109,090.91 | USD 9,090.91 |
| Upside | USD 136,363.64 | USD 36,363.64 |
The base case has positive NPV, but the downside case destroys value under the assumptions. Management can now examine whether reducing the initial commitment, changing supplier terms, or staging the launch would alter that downside.
Holding the discount rate fixed isolates the operating cases here. In a fuller model, financing conditions and discount rates may also change, with care not to count the same risk inconsistently.
The downside NPV is not the cash balance or the largest possible loss. It is the difference between discounted project inflows and the initial cost for that particular case.
The example also cannot establish whether the project can make every interim payment: it deliberately places all subsequent cash flows at year-end. A liquidity review would need a dated cash-flow schedule and available funding.
Likewise, three calculated cases do not mean each has a one-third chance of occurring. Probability-weighted results need justified weights and cases that appropriately cover the modeled outcomes without double-counting them. When probabilities are too uncertain to defend, present conditional results without invented precision.
| Method | Main question | Typical approach |
|---|---|---|
| Sensitivity analysis | Which assumptions drive the result? | Systematically vary one or more inputs |
| Scenario analysis | What happens under a specified set of conditions? | Recalculate a coherent alternative case |
| Stress testing | How vulnerable is the exposure to adverse conditions? | Apply deliberately severe assumptions |
| Monte Carlo simulation | What distribution follows from this probability model? | Repeatedly sample inputs or paths |
These methods overlap. A scenario can be explored with sensitivity tests, and a simulation can be run within a stressed environment. They are distinguished by the question and assumptions, not by the number of spreadsheet cells changed.
The Federal Reserve’s stress-testing explanation illustrates the difference between hypothetical adverse scenarios and economic forecasts. That banking application is not a rule that every business must follow.
This article provides general financial education, not a project approval, valuation opinion, or personalized investment recommendation.