Scenario Planning for SMEs: What You Should Actually Be Modelling
Scenario planning is not about predicting a single variable.
It is about understanding how your business responds to change.
For most SMEs, the relevant drivers are not isolated factors like interest rates.
They are the practical variables that affect revenue, costs, and cash in day-to-day operations.
The objective is not precision. It is understanding how the business behaves under different conditions.
Key Takeaways
- Scenario planning should reflect real operational drivers
- Most SMEs are affected by multiple variables at once
- Revenue, costs, and cash timing are typically the most sensitive
- A single forecast creates false certainty
- Use a 3-way forecasting structure to understand the real impact
- Clarity matters more than complexity
Why a Single Forecast Doesn’t Work
A single forecast assumes stability.
In practice, conditions change.
- revenue may not materialise as expected
- costs may increase
- external events may disrupt operations
Adding more detail to one scenario does not solve this.
It increases effort, not understanding.
Without testing alternative outcomes, decisions rely on assumptions that may not hold.
What SMEs Actually Need to Model
SMEs need to model the variables that directly affect performance and cash.
In practice, scenario planning for SMEs is not built around one variable.
It is built around the factors that genuinely affect performance and cash.
These typically include:
- revenue sensitivity (growth, churn, pricing changes)
- input cost increases (supplier pricing, inflation)
- payroll changes (hiring, annual pay rises)
- employer tax changes (NI, corporation tax)
- foreign exchange exposure (for businesses purchasing in foreign currency)
- cash collection timing (delays, customer behaviour)
- one-off external shocks (e.g. furlough schemes, sudden demand changes)
These are the scenarios that require modelling.
Not abstract variables, but operational realities.
These are not hypothetical risks. They are current operating pressures. Data from the Office for National Statistics shows that 21% of trading businesses reported rising input costs, reinforcing the need to model cost sensitivity alongside revenue assumptions
What Scenario Planning Actually Means
Scenario planning does not attempt to predict what will happen.
It tests how the business responds when conditions change.
Instead of asking what will happen, it asks:
What happens if this changes?
Typically, this involves:
- best case – favourable conditions
- worst case – adverse but realistic conditions
- most likely – current expectations
Each scenario adjusts the variables that actually affect the business.
Why Structure Matters More Than the Number of Scenarios
More scenarios do not improve clarity.
Structure does.
If the model is not built correctly:
- scenarios cannot be compared
- outputs are inconsistent
- decisions become unclear
The issue is not how many scenarios exist.
It is whether they behave correctly.
How 3-Way Thinking Applies to Scenario Planning
Scenario planning only works if the model reflects reality.
This requires connecting:
- Profit & Loss → performance
- Cash Flow → movement of cash
- Balance Sheet → financial position
Each change must flow through the model.
For example:
- a reduction in revenue
- reduces profit
- reduces receivables
- affects cash over time
Or:
- an increase in payroll costs
- reduces margins
- increases cash outflows
- affects retained earnings
These movements occur over time, not at once.
A model that reflects this timing behaves like the business.
If these movements are not connected, the scenario is incomplete.
A scenario is only useful if it behaves like the business.
What a “Worst Case” Should Actually Represent
Worst case is often misunderstood.
It is not extreme or theoretical.
It should reflect:
- realistic downside pressure
- conditions that are uncomfortable
- but still plausible
For example:
- revenue underperformance
- cost increases
- delayed collections
- unexpected external disruption
The purpose is to understand pressure, not predict failure.
What a “Best Case” Should Represent
The best case reflects improved conditions:
- stronger revenue
- stable or improved margins
- better cash timing
However, it must still be grounded in reality. If it cannot be explained, it cannot be relied on.
What the “Most Likely” Scenario Is For
The most likely scenario represents the current view.
- based on known information
- supported by reasonable assumptions
It is useful for planning. But it should not be relied on alone.
Where Scenario Planning Typically Breaks Down
The issue is rarely intent.
It is structure.
Common problems include:
- models that do not reflect how the business operates
- lack of connection between profit, cash, and position
- assumptions that do not translate into behaviour
- separate models for reporting and forecasting
Without structure, scenarios become theoretical rather than practical.
If the model doesn’t behave correctly, the scenario won’t be trusted.
Why Simpler Models Make Scenario Planning Work
As businesses grow, financial models often become:
- more detailed
- more fragmented
- harder to interpret
The typical response is to add more:
- more scenarios
- more reports
- more assumptions
The problem is not a lack of modelling. It is too much weight and not enough clarity.
This creates a specific issue in scenario planning:
- scenarios become inconsistent
- outputs cannot be compared
- results become harder to interpret
The model produces answers, but not understanding.
A more effective approach is:
- one structured model
- consistent logic across all scenarios
- fewer moving parts
This allows scenarios to be tested on a like-for-like basis.
- Simplicity improves usability.
- Structure ensures the model behaves reliably
How This Supports Better Decisions
Scenario planning does not provide certainty.
It provides visibility.
It allows you to understand:
- where pressure points emerge
- how cash behaves under stress
- what decisions may be required
For example:
- how much cost increase can be absorbed
- when cash becomes constrained
- what actions would be needed under pressure
The value is not prediction.
It is preparedness.
Plan for Real-World Variables
You do not control external conditions.
- revenue may change
- costs may increase
- external events may disrupt operations
What you control is how your business responds.
Scenario planning provides a structured way to understand that response.
A model that:
- reflects how the business operates
- connects profit, cash, and position
- tests realistic changes
provides clarity under uncertainty.
Better understanding leads to better decisions.
If your current forecasting model cannot show how changes in revenue, costs, or timing affect cash and financial position, it may not be sufficient for scenario planning.
FDPack combines:
- senior financial expertise
- structured, purpose-built forecasting systems
to deliver:
- integrated management accounts
- rolling forecasts that extend directly from actuals
All are built on a consistent 3-way model.
This provides:
- clarity
- consistency
- and financial information that supports better decision-making.
If your model cannot show how the business responds, it cannot support decisions.
FAQs
What is scenario planning in finance?
Scenario planning models different possible outcomes to understand how changes in key variables affect the business.
Why is scenario planning important for SMEs?
SMEs are more sensitive to changes in revenue, costs, and cash flow. Scenario planning provides visibility and supports better decisions.
What should SMEs include in scenario planning?
Revenue assumptions, costs, payroll, taxes, cash timing, FX exposure, and external shocks.
How many scenarios are needed?
Typically three: best case, worst case, and most likely.
What is the biggest mistake in scenario planning?
Relying on a single forecast or using models that do not reflect how the business actually behaves.
