Scenario Planning for Volatile Markets: How to Prepare for What You Can’t Predict

Scenario Planning Risk and Resilience FP&A

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.

Scenarios, Sensitivities and Forecasts Are Different Things

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

Why Most Teams Can't Do It Quickly

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.

19%
can run a scenario in real time or within a single day
11%
have real-time or near-real-time access to critical data
29%
can plan with high confidence beyond six months, down from 39%

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.

How to Build Scenario Planning That Gets Used

1

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.

2

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.

3

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.

4

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.

5

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.

Common Pitfalls

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

Where to Start

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.

Where Keansa Fits

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