The Problem with Most Financial Models

If you're a startup founder or early-stage investor, you've probably built a financial model that breaks the moment you change one assumption. Here's the fix: a multi-scenario model that handles 5 scenarios simultaneously.

Why Multiple Scenarios Matter

Investors love seeing that you've thought about different outcomes. A single "base case" projection is rarely convincing — what if growth slows? What if churn spikes? What if you hit a home run?

The Framework

You need 4 linked tabs:

1. Inputs — all your assumptions in one place
2. Projections — formulas reference the inputs tab
3. Sensitivity Analysis — cross-table showing how changing 2 key drivers affects results
4. Executive Summary — auto-generated dashboard of best, worst, and base case

How to Set It Up (Google Sheets)

In the Inputs tab, set up columns for Conservative, Base Case, Optimistic, Extreme Growth, and Downside Protection. Put your starting MRR, growth rate, churn rate, gross margin, fixed costs, and CAC in each column.

In the Projection tab, use formulas like =B2*(1+Inputs!B$2) to reference scenario inputs. Build 12 rows for months 1-12, with each month referencing the previous month's net MRR.

The Sensitivity Analysis uses a cross-table with growth rates as rows and churn rates as columns, using INDEX/MATCH to pull 12-month results from the projection tab.

Free Template

I've built a ready-to-use version of this — the Multi-Scenario Financial Model — Google Sheets — with sample data for a SaaS startup, 5 pre-built scenarios, and auto-generating dashboards. Grab it at the link below.

Multi-Scenario Financial Model — Google Sheets

This saves hours of formula wrangling. Just copy, enter your assumptions, and you're ready to present to investors.