Scenario Planning for People Who Hate Spreadsheets
What-if modeling isn't just for big companies with finance teams — it's how you stop being surprised by the future.
A few weeks ago we talked about why your runway is probably shorter than you think — the hidden costs, the optimism bias, the gap between the number in your head and the number that’s real.
A few of you replied with some version of: Okay, I’m terrified now. What do I do about it?
Fair. Let’s talk about the tool that answers that question — and no, it’s not a more complicated spreadsheet.
Scenario planning sounds like something a Fortune 500 CFO does in a boardroom with a 47-tab Excel model and a team of analysts. And honestly? That’s not entirely wrong. Big companies do this religiously. They map out best case, worst case, and base case. They stress-test assumptions. They run the numbers before the numbers run them.
But the concept itself is dead simple: What happens if things change?
What happens if your biggest client leaves? If you hire two people next quarter? If revenue dips 20% for three months? If that grant you’re counting on doesn’t come through?
These aren’t paranoid questions. They’re survival questions. And right now, they’re more relevant than ever.
If you’re a nonprofit, you already know what I’m about to say. Federal funding is being cut mid-cycle across thousands of programs, with non-defense spending facing a 22% reduction in the proposed FY2026 budget. Grants that organizations planned around — budgeted around, hired around — are disappearing. And it’s not just federal. The ripple effect hits state funding, foundation priorities, and donor confidence.
If you’re a bootstrapped startup, you’re facing a different version of the same problem. Capital is scarce. The customers you’re counting on might churn. That partnership might not close. The economy might do something weird in Q3.
The point isn’t to predict the future. It’s to stop being surprised by it.
So here’s what scenario planning actually looks like when you strip away the MBA jargon:
You take your current financial picture — your revenue, your expenses, your cash position — and you ask three questions. What if things go well? What if things stay flat? What if something breaks?
For each scenario, you adjust the inputs. Revenue up 15%. Revenue flat. Revenue down 20%. Then you look at where each path takes your cash position over the next three, six, twelve months.
In theory, this takes about an hour.
In practice? You need current numbers (not last month’s — this week’s). You need to model each variable independently. You need to remember that expenses aren’t static — they shift with headcount, seasonality, vendor contracts, and the forty-seven subscription tools you forgot you’re paying for. And you need to do this regularly, because the moment your assumptions go stale, the whole exercise becomes fiction.
Most founders I talk to have tried this once. Built a three-tab spreadsheet on a Sunday. Felt great about it. Opened is twice. Never opened it again.
The spreadsheet isn’t the problem. The maintenance is.
This is the gap we built MyRunwayHealth to close. Not the math — founders can do math. The consistency. For me, it was the time it took to go find the updated numbers to plug back in to the worksheet, and then that extra 40 minutes trying to figure out where I clicked to break that one formula. The part where you need current bank data, accurate expense tracking, and the ability to toggle assumptions and immediately see what happens to your runway. Without spending your Saturday rebuilding formulas.
A scenario plan you built two months ago is just a story you told yourself. A live one — one that updates when your numbers change and shows you the impact of decisions before you make them — that’s how you stop being blindsided.
The best practice isn’t having a plan for when things go wrong. It’s having a plan you actually keep current.
What’s the one scenario that would change everything for your business? And have you
actually modeled what it would look like? I’d love to hear what keeps you up at night.