Scenario analysis is a financial modelling technique that evaluates the impact of different future conditions on business performance. By modelling distinct scenarios — typically base case, upside, and downside — FP&A teams help leadership understand the range of possible outcomes and make more resilient decisions.
In Depth
Scenario analysis acknowledges that the future is uncertain and plans accordingly. Rather than building a single forecast and hoping it is right, FP&A teams construct multiple plausible scenarios to bracket the range of outcomes and identify risks and opportunities.
The standard framework includes three scenarios. The base case represents the most likely outcome given current trends and known information. The upside case models favourable conditions — stronger demand, successful product launches, or market expansion. The downside case models adverse conditions — economic slowdown, customer losses, or competitive pressure.
Each scenario should be internally consistent — meaning all assumptions within a scenario should make sense together. A downside scenario with reduced revenue but unchanged headcount is unrealistic; cost responses should align with revenue assumptions.
FP&A teams should present scenarios with clear trigger points: "If revenue falls below £X by Q2, we execute the downside cost plan." This makes scenario analysis actionable rather than theoretical. Pre-agreed responses to different scenarios enable faster decision-making when conditions change.
Scenario analysis differs from sensitivity analysis in an important way. Sensitivity analysis changes one variable at a time to test its impact. Scenario analysis changes multiple variables simultaneously to model coherent alternative futures.
For UK businesses, common scenarios include: Brexit-related trade disruption, Bank of England rate changes, HMRC policy shifts, and sector-specific regulatory changes.
Real-World Example
A UK hospitality group models three scenarios for the coming year. Base case: 5% revenue growth, 85% occupancy. Upside: 10% growth driven by a major local event, 92% occupancy. Downside: flat revenue due to economic slowdown, 78% occupancy. The FP&A team models each scenario's impact on cash flow and identifies that the downside case breaches a bank covenant in Q3, prompting a proactive conversation with the lender.
Related Terms
A rolling forecast is a financial projection that continuously extends the planning horizon by addin...
Driver-based planning is a financial planning methodology that links key operational and business dr...
Sensitivity analysis tests how changes in individual input variables affect the output of a financia...
Monte Carlo simulation is a statistical technique that models uncertainty by running thousands of it...
What-if analysis is a financial modelling technique that explores the impact of changing one or more...
Stop wrestling with spreadsheets. Grove FP gives your finance team a purpose-built platform for budgeting, forecasting, and financial modelling — designed for UK businesses.
FAQ