TL;DR: Scenario planning means building multiple versions of your financial forecast showing what happens under different conditions. Most SaaS companies have one forecast that assumes everything goes perfectly. Smart companies model best case (everything improves 20%), base case (current trends continue), and worst case (key metrics degrade 20%). This lets you plan for uncertainty, understand which metrics matter most, and make contingency decisions before you’re forced to. Scenario planning transforms forecasting from wishful thinking into risk management and strategic tool.
Every quarter, we see SaaS companies present one forecast to their board: revenue will grow 25% quarterly, churn will stay at 2%, CAC will remain at $3,500. The board approves the plan and everyone moves forward.
Three months later, reality differs from the forecast. Maybe growth was only 18% because a key channel underperformed. Maybe churn spiked to 3.5% due to a product issue. Maybe CAC increased to $4,200 because competition intensified.
The company is now scrambling to adjust. Should they cut spending? Shift resources? Raise prices? Nobody planned for this scenario so every decision is reactive rather than prepared.
This is the core problem with single-point forecasts. They assume the future is knowable and predictable. It’s not. Market conditions change, execution falters, unexpected opportunities emerge. A single forecast leaves you unprepared for reality.
Scenario planning fixes this by building multiple forecasts that bracket likely outcomes. When reality unfolds, you’ve already modeled something close to it. Your response plan exists. Decisions become execution of pre-planned strategies rather than panic reactions.
Build your scenario planning framework around three versions of your forecast:
Base case represents your most likely outcome given current trends. This is your primary forecast. Use historical trends for your key drivers: growth rate, churn, CAC, expansion. If you’ve been growing 20% quarterly for the last four quarters, assume 20% continues. Base case should have 50% probability of happening.
Best case shows what happens if things go better than expected. Typically we model 15-20% improvement across key metrics. Growth accelerates to 24% quarterly, churn improves to 1.6%, CAC drops to $2,800 due to channel optimization, expansion increases. Best case should have 25% probability.
Worst case shows what happens if things deteriorate. Model 15-20% degradation across key metrics. Growth slows to 16% quarterly, churn spikes to 2.4%, CAC increases to $4,200, expansion stagnates. Worst case should have 25% probability.
This three-scenario framework brackets likely outcomes. Reality will probably land somewhere between your base and best case, or between your base and worst case. Rarely does everything improve or everything degrade simultaneously.
Don’t vary every number in your model. Focus on the five to seven drivers that actually determine outcomes:
New customer acquisition: What if you add 20% more customers monthly than base case? 20% fewer?
Customer retention: What if churn improves from 2% to 1.5% monthly? Degrades to 2.5%?
Expansion rate: What if existing customers expand at 5% monthly instead of 4%? Or at 3%?
Average revenue per customer: What if new customers pay $900 instead of $750? Or $600?
CAC by channel: What if your most efficient channel gets 30% better? Or 30% worse?
Sales rep productivity: What if reps ramp to quota faster? Or slower?
Pricing: What if you increase prices 15%? What if you need to discount 10% to stay competitive?
Pick the drivers that have biggest impact on revenue and cash flow. These typically differ by business model and stage. An early-stage company with limited acquisition channels should focus on customer acquisition and retention. A mature company with established acquisition should focus on expansion and pricing.
Run sensitivity analysis to find out what matters. Change each driver by 20% and see impact on 12-month revenue and cash burn. The drivers with biggest impact are the ones to vary in scenarios.
Build different scenario frameworks depending on planning horizon:
13-week cash flow scenarios: Best case, base case, worst case for cash collections, spending, and burn. This is about surviving near-term uncertainty. Focus on collection timing, spending flexibility, and runway implications.
Annual operating plan scenarios: Three versions of your full-year plan showing revenue, expenses, hiring, and cash position. This drives budget decisions. If worst case shows cash running out in month 10, you need contingency plans.
3-year strategic scenarios: Multiple paths for how the business could evolve. This is less about precision, more about understanding strategic choices. If you pursue enterprise, what does 3-year trajectory look like? If you stay SMB-focused? If you expand internationally?
Each time horizon requires different detail and different decisions. 13-week scenarios determine whether you cut spending now. 3-year scenarios determine whether you pursue a market segment.
The point of scenario planning isn’t prediction, it’s preparation. When you’ve modeled three scenarios, decisions become clearer:
Budget planning: Your worst case shows cash running out at month 18. This means you need to plan fundraising to start at month 12, not month 15. Or you need to cut burn by 20% to extend runway.
Hiring decisions: Your base case supports adding 5 sales reps. But worst case shows that if growth slows, those reps will be underutilized and burn will be unsustainable. So you hire 3 reps now, hold slots for 2 more pending Q1 results.
Pricing changes: Your best case shows strong expansion rates, suggesting customers see value. You test 15% price increase on new customers because scenario analysis says you have room.
Channel investment: Your worst case assumes your primary channel efficiency degrades. You proactively invest in diversification now rather than being forced to pivot later when the channel actually degrades.
Product roadmap: Your scenarios show retention is critical to reaching profitability. You shift product resources from new features to improving onboarding and activation.
We use scenario planning in every board meeting. Show all three scenarios. Discuss which is tracking closest to reality. Adjust the base case as you get new information. Make strategic decisions based on scenarios, not just on base case.
Structure your model to make scenario planning easy:
Separate assumptions from formulas. Create an assumptions tab listing all key drivers: new customers per month, churn rate, expansion rate, average MRR per customer. Your forecast formulas reference this tab.
Create scenario tabs for each case. Base Case Assumptions, Best Case Assumptions, Worst Case Assumptions. Each lists the same drivers with different values.
Build one forecast engine that pulls from whichever assumptions tab you select. This means your forecast formulas are identical across scenarios, only the inputs change.
Create a dashboard comparing all three scenarios side-by-side. Show key outputs: revenue, cash balance, customers, burn rate. Make it visual so you can quickly see the spread between scenarios.
This structure lets you update scenarios quickly. When reality unfolds and you get new data, you update base case assumptions and regenerate all three scenarios in minutes.
We built a client model where scenarios are controlled by a dropdown at the top: “Select Scenario: Base | Best | Worst”. Choose a scenario and the entire model updates. The board can toggle between scenarios during meetings to understand implications of different outcomes.
Before you finalize your scenarios, run sensitivity analysis to understand which variables actually drive outcomes:
Take your base case model. Change one assumption at a time by 20% up and down. Measure impact on 12-month revenue and 12-month cash burn.
Example results might show:
– 20% increase in new customer acquisition → Revenue +15%, Cash burn +8%
– 20% decrease in churn → Revenue +12%, Cash burn flat
– 20% increase in expansion rate → Revenue +18%, Cash burn flat
– 20% decrease in CAC → Revenue flat, Cash burn -6%
This reveals that expansion rate and new customer acquisition drive revenue most. Churn and CAC drive cash efficiency most. Now you know which variables to focus scenarios on.
It also reveals which variables don’t matter much. Maybe you thought pricing was critical, but 20% price change only moves revenue 5%. This tells you pricing isn’t the leverage point you thought it was.
Run this sensitivity analysis quarterly as your business evolves. What matters at $1M ARR differs from what matters at $10M ARR.
We see companies make these mistakes when building scenarios:
Scenarios that are too close together: If best case is only 5% better than base case and worst case is only 5% worse, you haven’t modeled real uncertainty. Use 15-20% swings to capture realistic variance.
Varying too many things: If you change 15 different assumptions, scenarios become impossible to interpret. Focus on the five variables that drive most of the variance.
Not updating scenarios regularly: Build scenarios once for fundraising, never touch them again. Scenarios should be updated monthly as you get new information.
Building scenarios that are internally inconsistent: Your best case shows 30% higher growth but doesn’t add sales capacity to support it. Make sure scenarios are logically coherent.
Only showing base case to the board: Your board should see all three scenarios and understand probability ranges. Hiding uncertainty doesn’t make it go away.
Not connecting scenarios to decisions: Scenarios are pointless if they don’t drive action. “If worst case happens, we’ll cut marketing 30% and delay 2 engineering hires.” Define the triggers and responses.
Use scenarios to evaluate major decisions before you commit:
Considering opening European office? Model best case (Europe grows to 30% of revenue in 24 months), base case (Europe grows to 15% of revenue), worst case (Europe doesn’t work, writes off $500K investment). Compare scenarios to decide if expected value justifies risk.
Evaluating enterprise sales motion? Model best case (enterprise deals are $100K ACV with 90% retention), base case ($60K ACV with 85% retention), worst case ($40K ACV with 80% retention). Does even the worst case justify the investment?
Deciding on pricing increase? Model best case (no churn impact, 15% revenue increase), base case (5% churn spike, net 10% revenue increase), worst case (12% churn spike, net revenue flat). If worst case is neutral, the upside justifies the risk.
This turns big decisions from opinions into quantified risk-return tradeoffs. Some bets only make sense if best case happens. Others are worth it even if worst case happens. Scenarios reveal which type of bet you’re making.
—
Q: How often should we update our scenarios?
Update base case monthly as you get actual results. Update all three scenarios quarterly as market conditions or strategy changes. Between quarterly updates, you can adjust base case without rebuilding all scenarios. The key is keeping base case current so it reflects latest reality. If you go six months without updating scenarios, they become decorative rather than useful. We recommend full scenario rebuild quarterly, base case updates monthly, and ad-hoc scenario runs for major decisions.
Q: Should we show worst case scenarios to investors or will it scare them?
Always show investors all three scenarios. Sophisticated investors expect scenario planning and distrust companies that only show one rosy forecast. Present scenarios as “here’s the range of likely outcomes, here’s our plan for each.” This shows operational maturity. The investors who get scared by worst-case planning are investors you don’t want anyway—they’re not prepared for the reality that startups face uncertainty. Good investors appreciate teams that plan for multiple outcomes.
Q: What probability ranges should we assign to each scenario?
Typical framework is base case 50% probability, best case 25%, worst case 25%. This means you think base case is most likely but there’s equal chance things go better or worse. Don’t get too precise about probabilities—the point is showing a reasonable range of outcomes, not predicting the future exactly. Some companies use 40/30/30 if they think reality will likely diverge from base case. The exact percentages matter less than having the three scenarios and understanding the spread between them.