Quick Answer
Scenario planning in FP&A is the practice of creating multiple versions of your financial plan based on different assumptions about the future. Each scenario models a distinct set of conditions — typically base case, optimistic, and pessimistic — allowing leadership to understand the range of possible outcomes and prepare contingency plans for each.
Scenario planning creates alternative versions of your financial model, each reflecting a different set of assumptions about future conditions. Rather than committing to a single forecast, you explore "what if?" questions and prepare for multiple outcomes.
Base case: Your best estimate of what will happen. This is usually your primary forecast, built from realistic assumptions grounded in historical data and current pipeline.
Upside / optimistic: What happens if things go better than expected. Higher revenue, faster customer acquisition, better retention, favourable market conditions.
Downside / pessimistic: What happens if things go worse than expected. Revenue misses, higher churn, delayed deals, economic downturn.
Stress test: An extreme negative scenario designed to test survival. What if revenue drops 40%? What if your largest customer churns? How long does your cash last?
1. Identify key variables. Not every assumption needs to vary. Focus on the 5-10 variables that have the biggest P&L and cash impact: revenue growth, churn, headcount, pricing, key costs.
2. Define scenario narratives. Each scenario should tell a coherent story. "In the downside scenario, the economic slowdown reduces new business by 30%, churn increases to 15%, and we freeze all non-essential hiring."
3. Model the financials. For each scenario, adjust the key variables and let the model recalculate. Review the full P&L, cash flow, and runway implications.
4. Define trigger points. Set thresholds that tell you which scenario is playing out. "If Q1 bookings are below £X, we activate the downside contingency plan."
5. Prepare contingency plans. For each scenario, define the management actions you would take. The downside plan might include a hiring freeze, marketing budget reduction, or accelerated fundraising.
Present scenarios as a range: "We expect revenue between £4M (downside) and £6M (upside), with a base case of £5M. In all three scenarios, cash runway exceeds 18 months." This gives the board confidence that management has thought through different outcomes.
Scenario planning in spreadsheets means maintaining parallel workbooks or complex tab structures. FP&A software like Grove FP lets you create scenarios from a single model, compare them side by side with one click, and recalculate instantly when you change an assumption.
Related Questions
Model three to five scenarios for most planning purposes. The standard set is base case (most likely), upside (optimisti...
Sensitivity analysis is a technique that tests how changes in individual input variables affect your financial model's o...
A what-if analysis is a technique that models the financial impact of changing specific assumptions or decisions in your...
To model growth scenarios, identify the 5-7 key growth drivers for your business — new customer acquisition, expansion r...
During economic uncertainty, shift from single-point forecasts to range-based planning with multiple scenarios. Shorten ...
FAQ
Three is standard: base, upside, and downside. Add a stress test scenario for board and investor presentations. More than five scenarios typically creates confusion rather than clarity. Focus on scenarios that are materially different and lead to different management actions.
Scenario planning changes multiple assumptions simultaneously to tell a coherent story (e.g., recession scenario). Sensitivity analysis changes one variable at a time to see its isolated impact (e.g., what if churn increases 5%?). Both are valuable and complementary.
Lead with the base case as your primary forecast. Show upside and downside as a range around it. Use simple visual comparisons — waterfall charts, side-by-side P&Ls — rather than dense tables. Focus on the key metrics that differ between scenarios.
Share the base case broadly and use it for operational planning. Share all scenarios with the leadership team and board. Be thoughtful about sharing downside scenarios with the full team — context is important to prevent anxiety.
Grove FP lets you create unlimited named scenarios from a single model. Compare any two scenarios side by side with automatic variance calculation on every line item. Change assumptions and see the full P&L impact in under 50 milliseconds.
Grove FP gives UK finance teams a modern platform for budgeting, forecasting, and reporting — so you can focus on the decisions that matter.
Budgeting, forecasting, and workforce planning in one platform. No credit card required.