Reviewed Aug 2026
DE
BA-13 · LESSON 08

Scenario modelling

KEY DEFINITIONS

Terms used in this lesson

Spread
The gap between executable buy and sell prices in a market.

Forecasts must expose assumptions, ranges, sensitivities, and version history instead of presenting a single projected number as truth.

65 min Difficulty 3/5 Not started

Loading lesson visuals...

01

Learn the idea

Scenario modelling compares outcomes under explicit assumptions rather than predicting one future. A base case is a central planning case, a downside case changes plausible adverse variables, and a stress case tests survival under severe combinations. Sensitivity changes one input at a time; a scenario changes a coherent set. Version history records when and why assumptions changed.

GUIDED EXPLANATION1/5 ideas inspected
1

Define the output formula

State units, dates, cash-flow timing, balance-sheet relationships, and what result such as revenue, profit, liquidity, or return actually means.

Inspect each idea before the worked example.
The worked example follows the explanation

Inspect every idea above to open it.

Important distinctionA detailed spreadsheet makes a forecast objective.

Formulas can be precise while assumptions remain uncertain, biased, correlated, or incomplete. Transparency and stress testing matter more than decimal places.

02
FINISH LEARNING FIRST

The questions unlock after every required learning activity

Inspect every guided idea, open the worked example, rebuild its mechanism, and complete the deterministic lesson tool. Your progress is saved automatically.