What is the difference between scenario and sensitivity analysis?

Sensitivity analysis varies one input at a time. Scenario analysis changes multiple assumptions simultaneously to reflect coherent economic environments like a recession scenario.

What scenarios should I model?

Base case: most likely outcome. Bull case: best realistic outcome. Bear case: adverse but plausible scenario. Crisis scenario: severe but tail-risk scenario for stress testing capital adequacy.

How do I communicate scenario analysis to non-financial stakeholders?

Use visual range charts, tornado charts for sensitivity ranking, and simple scenario tables. Stakeholders need the key takeaway, not every cell of the model.

Scenario Analysis and Sensitivity Calculator

Build best case, base case, and worst case financial scenarios by varying key assumptions. Shows output range for NPV, EBITDA, or revenue under different input combinations.

Use the full interactive calculator below, or

Related Calculators

Rolling Forecast

Finance & Accounting

NPV Calculator

Finance & Accounting

Monte Carlo Inputs

Finance & Accounting

Scenario Analysis and Sensitivity Calculator

Related Calculators

Frequently Asked Questions

What is the difference between scenario and sensitivity analysis?

What scenarios should I model?

How do I communicate scenario analysis to non-financial stakeholders?