Beyond best case and worst case
Most finance teams approach scenario planning with three buckets: optimistic, base, and pessimistic. While this is better than a single-point forecast, it barely scratches the surface of what scenario analysis can do for decision-making.
Effective scenario planning isolates specific variables and models their impact independently. What if we lose our largest customer? What if we accelerate hiring by two quarters? What if our cost of goods increases by 15%? Each scenario tells a different story about risk and opportunity.
Building scenarios that drive decisions
The best scenarios are built around decisions the business actually needs to make. Instead of asking "what if revenue grows 20%?", ask "what if we invest 500k in a new sales team?" The first is a guess about the future. The second is a choice you can evaluate.
For each scenario, define the key assumptions that change, hold everything else constant, and measure the impact on the metrics that matter: cash runway, EBITDA margin, headcount, and capital requirements.
The speed problem
In theory, every CFO wants scenario analysis. In practice, building scenarios in spreadsheets takes so long that by the time the analysis is ready, the decision window has closed.
This is where FP&A platforms change the game. When your model is centralised and formula-driven, creating a new scenario is a matter of adjusting a handful of assumptions. The cascading impact calculates in seconds, not days.
Presenting scenarios to the board
Board members do not want to see twenty scenarios. They want to see two or three that frame the decision clearly. For each scenario, present: the key assumption that changes, the financial impact over the planning horizon, the risk profile, and the recommended action.
Side-by-side comparison views are invaluable here. When the board can see base versus upside versus downside on a single screen, the conversation moves from "what does this mean?" to "which path do we choose?"
Making it a habit
Scenario planning should not be an annual exercise. The most effective finance teams maintain a small library of live scenarios that they update as conditions change. When a new risk or opportunity emerges, they can model the impact in hours and present options to leadership the same week.