Scenario and Sensitivity Analysis for Startup Financial Models

Why scenario analysis matters to investors

A single-point forecast is a liability in a fundraising conversation. Any investor who has been in venture for more than two years knows that startups almost never perform exactly on plan. Presenting a single forecast implicitly assumes certainty that does not exist and signals that you have not thought carefully about risk.

Scenario analysis replaces false precision with structured uncertainty. It shows: here is our base case (what we think is most likely), here is our downside (what happens if growth is slower or costs are higher), and here is our upside (what we could achieve if assumptions play out favorably). This framing builds credibility precisely because it acknowledges that the future is uncertain.

Building three scenarios: what to vary

The key variables to stress-test depend on your business model. For SaaS: monthly new customer growth rate, churn rate, average contract value, and gross margin are the four highest-impact variables. For marketplace: take rate, GMV growth, and supply/demand balance. For e-commerce: customer acquisition cost, repeat purchase rate, and average order value.

Base case: your central estimate, not your optimistic view. Most founders present their optimistic view as 'base case' because they want to justify valuation. Investors with experience recognise this. Present a base case you would be comfortable defending as your actual internal plan, not as a floor.

Downside case: not a catastrophe, but a plausible underperformance scenario. Typically: growth rate 30-40% below base, or key metric (CAC, churn) 20-30% worse than expected. The important question about the downside is not just 'what happens to revenue' but 'do we survive?' If the downside case shows you running out of cash, investors will focus on that.

Upside case: achievable with favourable conditions, not just by multiplying everything by 2x. Specific drivers of upside: a particular partnership closes, a new market segment opens, or product-led growth kicks in ahead of schedule.

Sensitivity tables: showing which variables matter most

A sensitivity table varies two key inputs simultaneously and shows the impact on a single output metric (typically revenue in year 2, or ending runway, or LTV/CAC ratio). The table grid shows output values across all combinations of the two inputs.

The most useful sensitivity tables for investor conversations: monthly churn rate vs. new customer growth rate on year 2 ARR. CAC vs. gross margin on LTV/CAC ratio. Average contract value vs. sales cycle length on quarterly bookings. These combinations reveal which variables have the most leverage on outcomes.

Build these in Excel or Google Sheets using the Data Table function (two-variable data table). This is native spreadsheet functionality; no VBA or complex formulas required. The table recalculates automatically when you change any model assumption.

Presenting scenarios to investors

Show all three scenarios in your financial projections, but spend the most time on your base case and your downside. Investors are more interested in the downside than the upside because their job is risk management as much as return maximisation.

When presenting the downside, walk through: what triggers this scenario, how early would you see it happening (what are the leading indicators), and what would you do operationally in response. A specific response plan ('we would pause marketing spend and extend runway by 6 months, giving us time to find the problem') is more credible than a vague assurance that you would adapt.

---

Related: Financial Modelling: Complete Guide • All Articles • The Raise Ready Book