Skip to content
Controllingblog

Home❧Strategic Controlling❧Scenario analysis for uncertain years

Scenario analysis for uncertain years

Nobody knows the future. But you can prepare for several. How scenarios turn an uncertain plan into a robust one.

Strategic Controlling8 min readUpdated 14 Nov 2026
Illustration: mountain with summit flag, path and compass

A classic plan has one number per line. Revenue next year: 12.4 million. That looks precise but is an illusion. In reality it is a bet on one of many possible futures. Scenario analysis makes this uncertainty visible – and, more importantly, manageable.

Why one plan figure is not enough

Energy prices, interest rates, supply chains, collapses in demand: recent years have shown how quickly assumptions can tip. With only one plan, you have to improvise in an emergency. With scenarios, you open a prepared drawer. The difference shows above all in the speed of reaction – and in the calm with which decisions are made.

Step 1: Identify the key drivers

Not every assumption deserves a scenario. You are looking for drivers that have a strong impact and are highly uncertain. A simple method: list all planning assumptions and place them in a matrix of impact and uncertainty. Whatever lands top right goes into the scenarios. Typical candidates are sales volume, selling price, raw material and energy costs, personnel costs and interest rates.

Step 2: Formulate three scenarios

  • Base case: the most realistic expectation – usually what is in the budget anyway.
  • Worst case: a plausible but unfavourable picture. Not the end of the world, but something with roughly a 10–20% chance of happening.
  • Best case: the plausible good picture – important for preparing capacity and financing for growth too.

It is important that each scenario tells a consistent story. A worst case in which demand collapses but prices rise is usually not consistent.

Step 3: Calculate – profit and liquidity

Each scenario is calculated through to the income statement and – crucially – to liquidity.

€kWorstBaseBest
Sales (units)85,000100,000110,000
Revenue10,20012,40013,860
Variable costs−6,120−7,000−7,590
Contribution margin4,0805,4006,270
Fixed costs−4,600−4,600−4,750
Operating result−5208001,520
Lowest bank balance in the year−380640910

In the worst case, the credit line is just about sufficient – but only if countermeasures are taken in time. That insight is exactly the value of the exercise.

Step 4: Early-warning indicators and triggers

A scenario is only useful if you notice in time which one you are in. For each key driver, define an early indicator – including a threshold at which action is taken.

  • Order intake more than 10% below plan for two consecutive months → worst-case actions, stage 1.
  • Energy forward price above a defined level → activate price adjustment clauses.
  • Quote success rate falls below 25% → sales push and price review.

Step 5: Prepare packages of measures

For the worst case, a staged package of measures is put together in advance: what do we do first (postpone investments, hiring freeze), what next (check short-time work, streamline the range)? Likewise for the best case: which capacity can we build up quickly, what financing do we need for more working capital?

Practical tipDon't calculate scenarios in three separate files but in one model with a selector switch. Then all scenarios automatically stay consistent when a basic assumption changes.

Common mistakes

  • The worst case is too mild because nobody wants to present bad news.
  • Scenarios stop at the income statement and liquidity is forgotten.
  • There are no triggers – you only find out in the annual accounts which scenario occurred.
  • Too many scenarios. More than three or four tend to confuse rather than help.

Conclusion

Scenario analysis is not fortune-telling but preparation. It turns uncertainty into a range, shows the consequences for profit and liquidity and defines when to act. In turbulent times this creates something very valuable: the ability to act.

Frequently asked questions

How many scenarios should you calculate?

Three scenarios – worst, base and best case – are ideal for most companies. If there is a single dominant risk, an additional stress scenario can make sense.

What is the difference between scenario analysis and sensitivity analysis?

Sensitivity analysis changes a single variable and shows its effect. Scenario analysis changes several variables at once into a consistent overall picture.

How often should scenarios be updated?

At least with the annual plan and every forecast. When markets move strongly, also on demand as soon as an early-warning indicator is triggered.