Sarah Schlott
  • Home
  • About
  • Services
    • FP&A Consulting
      • Forecasting & Planning
      • Scenario Modeling
      • Management Reporting
      • Cash Forecasting
      • FP&A Systems & Processes
      • Variance Analysis
      • KPI Dashboards
      • Board Reporting
      • FP&A for PE-Backed Companies
    • Accounting Services
      • Bookkeeping Support
      • Month-End Close
      • Financial Statements
      • Accounts Payable
      • Accounts Receivable
      • Accounting Cleanup
  • FP&A Resources
    • FP&A Library
    • Tools & Templates
    • Blog
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
Finance, 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 This article focuses on using scenarios when uncertainty is unusually high. For the broader FP&A method, start with my financial scenario planning guide. 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/1 Comment/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-300x300.png Sarah Schlott2025-05-21 20:49:142026-10-02 09:05:34Scenario Planning in Uncertain Times: A Practical Framework
You might also like
Advanced Excel Forecasting Models for CFOs: From Scenario Planning to Sensitivity Analysis
FP&A forecasting process FP&A Forecasting Process: A Practical Step-by-Step Guide
FP&A software planning and evaluation FP&A Software: When Does Your Finance Team Actually Need It?
Budget variance analysis for FP&A Budget Variance Analysis: How FP&A Finds What Actually Matters
Why Most Annual Operating Plans Are DOA by Q2 (And What Smart CFOs Are Doing Instead)
13-week cash flow forecasting 13-Week Cash Flow Forecast: A Practical Step-by-Step Guide
1 reply
  1. Sarah Schlott
    Sarah Schlott says:
    October 2, 2026 at 12:35 pm

    What uncertainty is actually worth building a scenario around right now in your business?

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Join the Discussion Cancel reply

What do you think? No account or email required.

Latest Posts

  • Contractor+ Is Growing. I’m More Interested in What the Cash Has to Do Next.
  • Private Colleges Have a Revenue Problem That Looks Familiar
  • The Orlando Housing Story I’m Watching Isn’t Home Prices. It’s Household Pressure.
  • Bookkeeping vs. Accounting: What Does Your Business Actually Need?
  • The 2,232-Acre Osceola Data Center Story Needs One Important Asterisk
  • Orlando Tourism Doesn’t Get to Coast on Being Orlando
  • Statusphere Just Made a Very Physical Bet on Scaling Software
  • A $103 Million Orlando Industrial Deal Says More Than the Price Tag
  • How Much Do Accounting Services Cost in Orlando?
  • Carvana Is Adding 100 Orlando-Area Jobs. The Number I’m Watching Is What Comes Next.
  • Accounting Services in Orlando: What Should a Growing Business Actually Expect?
  • The FP&A Calendar: Build a Finance Rhythm That Leaves Time to Think
  • How Often Should You Update a Financial Forecast?
  • Capital Expenditure Forecasting: The Annual CapEx Number Is Not the Forecast
  • Gross Margin Forecasting: Revenue Can Be Right and the Economics Still Be Wrong
  • Forecast Assumptions: The Model Should Remember What Changed
  • Working Capital Forecasting: Why the P&L Can Be Right and Cash Still Be Wrong
  • Operating Expense Forecasting: Stop Treating Every Cost the Same
  • Month-End Close and FP&A: When Are the Actuals Actually Ready?
  • Ad Hoc Reporting in FP&A: When the Same Quick Question Keeps Coming Back
  • Headcount Forecasting: Why Approved Hires Keep Breaking the Plan
  • Management Reporting Pack: What CFOs Actually Need Every Month
  • Budget Variance Analysis: How FP&A Finds What Actually Matters
  • FP&A Software vs. Excel: When Has Finance Actually Outgrown Spreadsheets?
  • What Is FP&A? A Practical Guide to Financial Planning & Analysis
  • FP&A Software: When Does Your Finance Team Actually Need It?
  • Driver-Based Forecasting: How to Find the Right Business Drivers
  • Financial Forecasting Methods: How to Choose the Right One
  • Financial Scenario Planning: How FP&A Can Build Scenarios That Actually Help Management
  • AI Agents in Finance: What Should CFOs Actually Let Them Do?

Sarah Schlott

FP&A consulting, forecasting, accounting support and finance strategy for CFOs and growing finance teams.

Work With Sarah →

FP&A

FP&A ConsultingForecasting & PlanningScenario Modeling & Decision SupportManagement ReportingCash ForecastingFP&A Function & Finance SystemsVariance AnalysisKPI DashboardsBoard ReportingFP&A for PE-Backed CompaniesOrlando FP&A Consulting

Accounting

Accounting ServicesAccounting & Bookkeeping SupportMonth-End Close & Financial ReportingFinancial Statements & ReportingAccounts Payable SupportAccounts Receivable SupportAccounting Cleanup & Catch-UpOrlando Accounting Services
© 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