What-if analysis for startups: How to model multiple futures and impress investors

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

• Prepare for compound events. Financial scenario planning helps you model situations like a market dip hitting at the same time as a hiring delay, so you’re not figuring it out in the moment.
• Know your tools. Sensitivity analysis tests one variable at a time. What-if analysis models what happens when several things go wrong at once.
• Build actionable cases. Every scenario should connect directly to a management decision: a hiring freeze, a marketing pivot, a revised burn target.
• Build investor confidence. A well-constructed downside model does more for your credibility than any top-line projection.

Table of contents

• Why single-point forecasts fail in today’s market
• How to build practical scenarios: the triple-thread approach
• What investors actually look for in your scenarios
• Step-by-step: implementing what-if analysis in your model
• FAQs

Why single-point forecasts fail in today’s market

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.

How to build practical scenarios: the triple-thread approach

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.

The base case

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.

The upside case

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.

The downside case

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.

 

What investors actually look for in your scenarios

When a VC reviews your financial model, they’re not just checking the math. They’re evaluating how you think about your own business.

Realism over optimism

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.

Triggers and thresholds

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.”

Operational discipline

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.

Step-by-step: implementing what-if analysis in your model

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. 

Step 1: Identify your high-impact drivers

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.

Step 2: Create an assumptions hub

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.

Step 3: Map impact to mitigation

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.

Build the model that holds up

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.