Sarah Schlott
  • Home
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
FP&A

Scenario Planning in Uncertain Times: A Practical Framework

Let’s start with a blunt truth most leaders don’t want to admit:

You’re not going to predict the future.

Not with that pristine forecast. Not with that 50-tab spreadsheet. Not even with your new AI-powered tool that’s supposed to “learn” the business.

And that’s okay.

Because scenario planning isn’t about guessing right. It’s about being ready when things go wrong—or wildly right. It’s the art of building clarity in the fog of uncertainty. Think of it less like forecasting the weather and more like packing a bag for a week in Iceland: waterproof everything and a swimsuit. Just in case.

I’ve helped companies navigate everything from industry disruptions to interest rate shocks, and the teams that got through it intact weren’t the ones with the smartest predictions. They were the ones who stress-tested assumptions, got ahead of turning points, and had a plan B, C, and D ready to roll.

Here’s how to do that without setting your hair on fire.

Step One: Start With the Truth You’re Ignoring

Every scenario plan starts with a blind spot. A growth assumption you’ve stopped questioning. A supplier that’s “always reliable.” A customer base that’s “locked in.”

You don’t need 20 scenarios. You need three that scare you just enough to think.

Step Two: Pick the Right Variables to Stress

Good scenario planning isn’t about changing every number in your model. That’s just chaos with extra steps. Focus on a few critical variables:

  • Top-line drivers (volume, price, churn)
  • Cost levers (COGS, headcount, fixed vs. variable)
  • Capital constraints (cash runway, access to debt)

Ask: What are the two or three assumptions that, if wrong, would break the business?

Step Three: Build Clear, Comparable Scenarios

Don’t build 10 snowflakes. Build three models:

  • Base Case: Your current plan
  • Downside: The pain scenario (10-30% revenue miss, delayed funding, cost inflation)
  • Upside: The opportunity scenario (breakout product, new market, unexpected tailwinds)

The point isn’t the forecast. It’s understanding how decisions flex across realities.

Scenario Comparison Table

Variable Base Case Downside Upside
Revenue Growth 12% -10% 25%
Gross Margin 58% 50% 62%
Burn Rate $450K/mo $600K/mo $300K/mo
Runway 18 months 9 months 24 months

Step Four: Identify Trigger Points

This is where most finance teams drop the ball. It’s not just about modeling the scenarios—it’s about knowing when to pivot between them.

Set clear triggers:

  • Pipeline drops below X
  • CAC jumps above Y
  • Gross margin dips under Z

When a trigger hits, you don’t panic. You execute. The decision tree is already in your hands.

Step Five: Turn Scenarios Into Action Plans

Each scenario should have:

  • A cost response plan
  • A hiring freeze/playbook
  • A growth bet shift
  • A stakeholder communication strategy

This is the difference between a model and a plan. The spreadsheet shows the numbers. The plan shows who’s doing what on day one of the downturn.

Step Six: Get Cross-Functional Input

If finance builds it alone, no one will follow it.

Bring in sales. Ops. HR. Marketing. Product. Ask them how their world changes in each scenario. Bake that back in. Make it a tool they want to use—not another spreadsheet that just “comes from finance.”

Step Seven: Pressure Test With Executives

A scenario plan is only as good as the leadership’s willingness to use it.

Sit down with the CEO. The board. The business heads.

Walk them through:

  • The logic
  • The assumptions
  • The levers they control

This isn’t about fear-mongering. It’s about credibility. You’re not crying wolf. You’re building trust.

Step Eight: Revisit Monthly. Adjust Quarterly.

Scenario planning isn’t a one-and-done exercise. It’s a mindset.

  • Are your assumptions still holding?
  • Are your trigger thresholds still valid?
  • Is your team ready to pivot?

Update fast. Don’t let inertia turn your plan into a relic.

Step Nine: Translate Scenarios Into Executive Stories

Numbers alone won’t drive action. You need a narrative.

  • What’s the risk?
  • What’s the upside?
  • What’s the cost of delay?

Frame it like a Choose-Your-Own-Adventure for executives. Make the trade-offs visible.

Step Ten: Get Over Perfection

There’s no perfect model. There are only prepared people.

Your job isn’t to be a crystal ball. It’s to be a shock absorber. A scenario planner is the CFO’s version of a storm cellar: unused if you’re lucky, essential if you’re not.

Final Word: Don’t Let Certainty Be Your Strategy

The most dangerous plan is the one that assumes everything will go according to plan.

Scenario planning isn’t about being pessimistic. It’s about being pragmatic. In uncertain markets, it’s your edge. In volatile industries, it’s your life vest.

If your team can’t answer, “What happens if we miss the quarter by 20%?” without spinning into chaos, you’re not planning—you’re hoping.

Hope is not a strategy. But preparedness? That’s power.

So here’s the question: If your worst-case scenario hits tomorrow, do you know what to do next?

May 21, 2025/by Sarah Schlott
Tags: Business assumptions, CFO, Executive decisions, Financial model, Revenue Growth, Runway, Scenario planning, Stress test, Trigger points, Uncertainty
Share this entry
  • Facebook Facebook Share on Facebook
  • X-twitter X-twitter Share on X
  • Linkedin Linkedin Share on LinkedIn
  • Reddit Reddit Share on Reddit
  • Mail Mail Share by Mail
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-tima-miroshnichenko-6694492-scaled-e1747874873980.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-05-21 20:49:142025-08-14 00:48:10Scenario Planning in Uncertain Times: A Practical Framework
You might also like
The Hidden Edge: Why Growing Companies Need FP&A Before They Think They Do
Cash Flow Forecasting: Why 13 Weeks Isn’t Always Enough
From Annual Planning to Rolling Forecasts: What Really Changes
CFO Declares “Strategic Finance” Mission Accomplished After Attending 1 AI Webinar
The 5 Most Common Mistakes I See in Financial Models—and How to Fix Them
How to Stress Test Your Model Without Breaking It

Latest Posts

  • The Budget Was Approved Long Before the Meeting
  • 8 Financial Mistakes Women in Their 40s Make—and How to Fix Them (2026 Guide)
  • Jobless Claims Fell Below 200,000
  • The Most Dangerous “Modern” Excel Formula: =UNIQUE()
  • The Most Dangerous Excel Formula in Finance
  • The Quiet Revolution: AI in FP&A 2025
  • I Didn’t Choose the Spreadsheet Life — The Spreadsheet Life Chose Me
  • The night before our board meeting, the ARR report didn’t tie out.
  • We rebuilt our churn model after it lied to us — in front of the board.
  • Some days being a SaaS CFO feels like air traffic control — but every plane is on fire.
© Copyright - Sarah Schlott
Link to: 3 Excel Functions Every Strategic Finance Team Should Master Link to: 3 Excel Functions Every Strategic Finance Team Should Master 3 Excel Functions Every Strategic Finance Team Should Master Link to: Cash Flow Forecasting: Why 13 Weeks Isn’t Always Enough Link to: Cash Flow Forecasting: Why 13 Weeks Isn’t Always Enough Cash Flow Forecasting: Why 13 Weeks Isn’t Always Enough
Scroll to top Scroll to top Scroll to top