Corporate Strategy & FP&A Decision Lab

Scenario Planning & Tornado Lab

Model Bear, Base, and Bull financial scenarios, evaluate probability-weighted expected values, and rank key driver sensitivities.

Scenario Model Three-Case Comparison Tornado Sensitivity FAQ

Business Presets

Load calibrated corporate operating models.

Step 1: Base Case & Scenario Deviations

Financial Drivers & Scenario Assumptions

1. Base Case Financial Drivers

$
units
$
$
%

2. Bear Case (Downside Deviations %)

%
%
%
%
%

3. Bull Case (Upside Deviations %)

%
%
%
%
%
Base Case EBIT
$0
Expected EBIT E(X)
$0
Bear Case Downside
$0
Bull Case Upside
$0
Top Sensitivity Driver
Selling Price

Step 2: Pro-Forma Comparison

Bear, Base & Bull Pro-Forma Income Statement

Evaluates revenues, direct costs, fixed operating expenses, operating profit (EBIT), and bottom-line net income.

Financial Metric Bear Case (Downside) Base Case (Target) Bull Case (Upside)

Step 3: Key Driver Sensitivity Ranking

Tornado Analysis: EBIT Swing Range (±10% Shift)

Ranks business drivers by their isolated impact on operating profit, pinpointing your highest strategic levers.

Rank & Key Value Driver Low Case EBIT (−10%) High Case EBIT (+10%) Total EBIT Swing Range (Δ)

Strategic Planning Guide

Understanding scenario planning & tornado charts

Static budgets fail because business environments change dynamically. Scenario planning prepares leadership for volatility.

  • Asymmetric Payoffs: Downside losses often hurt more than upside gains help. Stress-testing Bear case liquidity prevents bankruptcy.
  • Tornado Hierarchy: In most businesses, a 1% change in price impacts EBIT far more than a 1% change in volume or fixed OpEx.
  • Expected Value Budgeting: Probability-weighting gives board members a realistic baseline rather than an over-optimistic bull forecast.

Explore multi-criteria tradeoffs in the Decision Matrix Lab.

Scenario Equations

Essential scenario planning formulas

Revenue = Selling Price × Unit Sales Volume

Gross Profit = Revenue − (Unit COGS × Volume)

EBIT (Operating Profit) = Gross Profit − Fixed OpEx

Expected Value E(X) = ∑ [ Probability(i) × Outcome(i) ]

Tornado Swing Δ = | EBIT(High +10%) − EBIT(Low −10%) |

Measure financial resilience in the Business Resilience Lab.

FAQ

Scenario planning and sensitivity questions

What is Scenario Planning in financial and strategic management?

Scenario Planning models discrete alternative futures (typically Bear, Base, and Bull cases) by simultaneously varying multiple interdependent assumptions such as pricing, sales volume, unit costs, and operating expenses.

What is Tornado Sensitivity Analysis and how is it interpreted?

Tornado Analysis evaluates one input variable at a time (e.g. ±10%) while holding all other factors constant, measuring the resulting swing in EBIT. Drivers with the widest swing bars represent the business's greatest financial sensitivities.

How is Probability-Weighted Expected Value calculated?

Expected Value E(EBIT) = (Bear EBIT × Bear Weight) + (Base EBIT × Base Weight) + (Bull EBIT × Bull Weight). It provides a single risk-adjusted benchmark for budgeting and capital allocation.

What is the difference between Scenario Analysis and Sensitivity Analysis?

Sensitivity Analysis changes one single driver at a time to test its isolated impact (Tornado chart). Scenario Analysis changes multiple correlated drivers together to represent a cohesive macroeconomic or market state.

Can I export scenario models and sensitivity schedules to CSV?

Yes. You can export complete 3-case pro-forma income statements, expected values, and Tornado sensitivity driver rankings as a UTF-8 CSV spreadsheet with formula injection defense or print an executive brief.

Is this tool certified financial forecasting or investment advisory consulting?

No. This tool provides educational corporate finance and strategy models for business training without certified auditing, financial forecasting guarantees, or fiduciary investment advisory consulting.

Continue Exploring Strategy & Financial Tools

Explore our Strategy & Decision-Making Hub, model multi-criteria scores in the Decision Matrix Lab, test operating leverage in the Business Resilience Lab, or value businesses in the Business Valuation Lab.