.png)
Key Takeaway
Scenario planning isn't about predicting the future. It's about deciding in advance how you'll respond to a few plausible futures, so that when conditions shift, you act in days instead of scrambling for weeks.
Few finance leaders would say their last annual plan played out exactly as written. Demand moves, currencies swing, suppliers slip, interest rates change. The question isn't whether conditions will surprise you. It's how ready you'll be when they do.
Scenario planning is the discipline of preparing for that. Done well, it's lighter than most teams expect and more useful than a longer forecast.
You can't predict what's coming. You can decide, ahead of time, what you'd do about it.
These terms get mixed up, and the confusion leads to muddled models. Each answers a different question.
Three Tools, Three Questions
| Tool | The Question It Answers | Example |
|---|---|---|
| Forecast | What do we expect to happen? | Most likely revenue for the next four quarters |
| Sensitivity Analysis | What happens if one thing changes? | Margin impact of a 5% rise in material costs |
| Scenario Planning | What if several things change together, and what would we do? | Demand falls 10% while currency weakens and lead times lengthen |
The 10th annual FP&A Trends Group survey (475 finance professionals, sponsored by OneStream) points to why scenario work often stalls. It is vendor-sponsored and self-reported, so read the numbers as directional.
Source: FP&A Trends Group, 10th Annual FP&A Trends Survey (2026), 475 respondents, as published by OneStream, the survey sponsor. Self-reported.
When data is slow to arrive and the model lives in linked spreadsheets, every "what if" becomes a mini-project. By the time the answer is ready, the question has changed.
Identify the Few Uncertainties That Matter
Ask which external factors could change your results most: demand, pricing, currency, input costs, interest rates, a key customer or supplier. Pick three or four, not twenty.
Build Three to Four Distinct Scenarios
A base case, a downside, an upside and perhaps one severe stress case. Make them different enough to trigger different decisions, not just base plus or minus five percent.
Run Them Through Your Drivers
Scenarios work best on a driver-based model. Change volume, price or cost per unit, and let the full P&L, cash flow and balance sheet respond together.
Agree on Triggers and Responses in Advance
For each scenario, define the early warning signs and what you'd do: pause hiring, delay capital spend, renegotiate terms, draw on a credit line. Deciding in calm conditions beats deciding under pressure.
Review and Refresh Regularly
Revisit scenarios each quarter or after a major event. Drop the ones that no longer apply and add the ones that now do.
A scenario that never changes a decision is just a spreadsheet exercise. The value is in the response plan, not the numbers.
| Pitfall | What Goes Wrong | Fix |
|---|---|---|
| Too many scenarios | Leaders can't absorb them and nothing gets decided | Limit to three or four with clearly different outcomes |
| Only numbers, no actions | The model shows the damage but not the response | Attach triggers and pre-agreed actions to each scenario |
| Finance builds it alone | Operational reality is missing from the assumptions | Involve sales, operations and supply chain in setting scenarios |
| Rebuilt from scratch each time | Every request takes days, so people stop asking | Use a model where assumptions can be switched in minutes |
Pick the single biggest uncertainty facing your business this year. For some it's currency, for others demand or a key input cost. Build one downside scenario around it, link it to your forecast, and write down what you would do if it started to happen. That small exercise usually reveals more about your exposure than a large model built without a clear question.
Keansa helps finance teams build scenario capability into their planning platforms, so that switching assumptions, comparing outcomes and updating forecasts takes minutes, not days. We focus on the drivers and decisions that matter most to your business, and we design the model so the business can use it.
Want to see how fast your team could run a "what if"?
Talk to a Keansa Consultant