You spent two months building the model. You know every assumption, every formula, every growth curve. You walk into the investor meeting feeling ready. Then someone asks, “What happens if you miss Q3?” And the honest answer is: you haven’t modeled that.
That moment is more common than most founders admit. The forecast looks clean. The trajectory looks right. But it was built around one version of the future, the version where everything goes according to plan.
The problem isn’t the financial model. It’s that one scenario was never enough. Markets don’t move in straight lines. Customers churn on their own schedule. A hiring freeze or a fundraise that drags six months longer than planned can unwind a single-point forecast fast.
What-if analysis is how you get ahead of that. Instead of betting everything on one trajectory, you build out multiple versions of your business so you know exactly what to do when conditions change. And financial scenario planning connects those versions to real decisions, so your team isn’t improvising when things get hard.
Founders who do this work walk into investor meetings having already stress-tested their own assumptions. When someone asks what happens if Q3 misses, they have a specific answer.
Key takeaways
Investors have shifted their focus back to fundamentals. They want to see realism, not a forecast that assumes flawless execution from day one. A model built around one outcome tells investors you haven’t seriously questioned your own assumptions yet.
Static models also have no answer for macro-level disruption. A sudden inflation spike doesn’t care about your linear revenue projection. When that hits, a rigid spreadsheet gives you no room to respond.
The real problem is what happens next. When leadership has only one version of the business in their heads, every unexpected event becomes a crisis. Decisions get made under pressure, and the options that were available a month ago are gone.
What-if analysis gives you room to think clearly before the pressure arrives. When the downside scenario happens, you’ve already worked through it on paper.
|
Never hardcode variable inputs directly into your revenue formulas. Always use a dedicated assumptions tab. When conditions change, you want to update one cell, not rebuild your entire model. |
The goal with financial scenario planning is specificity, not exhaustiveness. Three clearly defined scenarios are more useful than ten vague ones. This framework works best for founders preparing for fundraising or board reviews.
This is your most realistic path forward, grounded in current traction and honest assumptions about CAC, conversion rates, and headcount growth. It’s the version of the business you’d bet on today. It also sets the baseline for measuring every other scenario you build.
This scenario explores what happens if growth accelerates faster than expected. A major competitor exits the market. A viral moment drives a surge in inbound leads. The question isn’t just “how much revenue do we make?” It’s whether your infrastructure and team can handle it without breaking.
This is the scenario most founders avoid, and the one investors pay the most attention to. What happens if your sales cycle doubles in length? If a key customer churns early? If the fundraise takes six months longer than planned? The downside case proves you can protect your cash runway without needing an emergency capital injection. It’s also where your credibility is built.
Once you have all three, build a clean summary page that shows them side by side. When a specific trigger hits, like missing a quarterly revenue target by more than 20%, you already have a pre-agreed plan to activate.
|
Review and update your three scenarios at the end of every month. Actual vs. base case comparison is one of the fastest ways to sharpen your future assumptions. |
When a VC reviews your financial model, they’re not just checking the math. They’re evaluating how you think about your own business.
Investors have seen thousands of decks with hockey stick projections. What stops them is a founder who has genuinely red-teamed their own assumptions. Showing that you’ve already stress-tested your model builds more credibility than any top-line number.
Specific is better than general. If your cash runway drops below six months, what happens? If your burn multiple exceeds a certain threshold, what gets cut? Investors want to see defined decision points, not vague language about “adjusting strategy as needed.”
The deeper question investors ask isn’t whether you’ve built a downside model. It’s whether your team can actually execute it. Does your leadership have the discipline to freeze hiring and cut marketing spend if the numbers call for it? A detailed what-if analysis shows you’ve already had that conversation internally.
Building a dynamic model requires structure from the start. The goal is a setup where you can switch between scenarios instantly, without rewriting a single formula.
Start with your historical data. Which variables actually move the needle for your business? For most SaaS startups, that’s CAC, LTV, and churn. For others, it might be contract length or gross margin. Use a tornado chart to visualize which inputs have the biggest effect on cash flow, and prioritize those for your scenario work.
A quick note on terminology: sensitivity analysis changes one variable at a time to find your model’s breaking points. What-if analysis combines multiple changes at once to model a full alternate reality. Both are useful. What-if analysis is the one that prepares you for how business actually goes sideways.
Centralize all your key variables in one dedicated tab. Use a dropdown or scenario manager so you can toggle between cases without rewriting formulas. Color-code your input cells so anyone reviewing the model can immediately tell which numbers are adjustable. A data table lets you stress-test two changing drivers at once, like CAC and churn, across a range of outcomes in a single view.
For every revenue drop in your model, there should be a corresponding expense reduction. If revenue falls 20%, which costs get cut first? In what order? This is what makes a financial model actionable. Use Goal Seek to work backward from a target runway and identify exactly which input needs to change to get there.
Then generate a side-by-side summary report across all three cases. That report is what you bring to board meetings and investor diligence. When your department heads know which scenario has been triggered, they know exactly what to do next.
A single forecast tells investors where you hope to go. A multi-scenario model tells them you understand where things could go wrong, and that you’ve already planned for it.
That’s what what-if analysis really does. It shifts your financial model from a document you built once to something your team actually uses. Reactive decisions get replaced with plans that were made in a calm moment, before the pressure arrived.
If you want a raise-ready model built for real-world conditions, schedule a demo and let’s build your multi-scenario forecast together.