---
# === IDENTITY ===
id: finance/startup-finance/saas-financial-model-spreadsheet-template/2026
canonical_question: "How do I build a SaaS financial model — MRR waterfall, cohort analysis, P&L, cash flow, cap table, scenario toggles?"
aliases:
  - "SaaS financial model spreadsheet template"
  - "How to build an MRR waterfall in Google Sheets"
  - "SaaS startup financial projections template"
  - "Three-statement SaaS model with cohort analysis"
  - "SaaS cap table and scenario analysis spreadsheet"
entity_type: execution_recipe
domain: finance > startup-finance > saas financial model spreadsheet template
region: global
jurisdiction: global
temporal_scope: 2024-2026

# === VERIFICATION ===
last_verified: 2026-03-11
confidence: 0.88
version: 1.0
first_published: 2026-03-11

# === TEMPORAL VALIDITY ===
temporal_validity:
  status: evolving
  last_breaking_change: "SaaS valuation multiples compressed to 6-10x ARR median in 2025; CAC payback benchmarks shifted to 15 months median"
  next_review: 2026-09-07
  change_sensitivity: high

# === CONSTRAINTS ===
constraints:
  - "MRR waterfall must separate five components: New, Expansion, Contraction, Churn, Reactivation — aggregated MRR masks retention problems"
  - "Cohort analysis requires minimum 6 months of data to produce meaningful retention curves; pre-revenue models use assumption-based cohorts"
  - "Three-statement model must be integrated — P&L net income flows to cash flow, ending cash flows to balance sheet. Broken links produce garbage"
  - "Scenario toggles must change only assumption cells, never formula cells. Hardcoded overrides create model fragility"
  - "Cap table must model SAFEs and convertible notes pre-conversion — most seed-stage startups use these, not priced equity"

# === SKIP CONDITIONS ===
skip_this_unit_if:
  - condition: "User needs SaaS metrics definitions only, not a working model"
    use_instead: "Search knowledgelib.io for SaaS metric definitions — no glossary unit yet"
  - condition: "User needs fundraising pitch deck financials, not a full operating model"
    use_instead: "business/fundraising/financial-projections-for-investors/2026"
  - condition: "User is post-Series B and needs enterprise FP&A tooling"
    use_instead: "Search knowledgelib.io for enterprise FP&A tooling — no dedicated unit yet"

# === AGENT HINTS ===
inputs_needed:
  - key: tool_preference
    question: "Which spreadsheet tool should be used?"
    type: choice
    options: ["Google Sheets", "Microsoft Excel", "Causal/Mosaic (dedicated FP&A)", "no preference — auto-select"]
  - key: technical_skill
    question: "What is the user's financial modeling skill level?"
    type: choice
    options: ["non-technical (needs guided templates)", "semi-technical (can edit formulas)", "developer/analyst (can build from scratch)"]
  - key: stage
    question: "What stage is the SaaS company?"
    type: choice
    options: ["pre-revenue (projections only)", "early-revenue ($0-$50K MRR)", "growth ($50K-$500K MRR)", "scale ($500K+ MRR)"]
  - key: fundraising_timeline
    question: "Is the user building this for fundraising?"
    type: choice
    options: ["yes, raising in 0-3 months", "yes, raising in 3-12 months", "no, internal planning only"]

# === EXECUTION METADATA ===
execution:
  required_inputs:
    - name: "Pricing structure"
      source: "user/business plan or pricing page"
      format: "structured data — tiers, prices, billing frequency"
    - name: "Historical MRR data (if available)"
      source: "billing system (Stripe, Chargebee, Recurly) or manual records"
      format: "CSV or spreadsheet — month, new customers, churned customers, MRR by tier"
    - name: "Operating expense budget"
      source: "user/financial records or estimates"
      format: "structured data — headcount plan, tool costs, marketing spend"
  outputs:
    - name: "Integrated SaaS Financial Model"
      format: "spreadsheet (Google Sheets or Excel)"
      description: "7-tab workbook: Assumptions, MRR Waterfall, Cohort Analysis, P&L, Cash Flow, Balance Sheet, Cap Table — with 3 scenario toggles"
    - name: "Investor-Ready Summary Dashboard"
      format: "spreadsheet tab with charts"
      description: "Key metrics visualization: ARR trajectory, unit economics, runway, and scenario comparison charts"
  tools_required:
    - name: "Google Sheets"
      purpose: "Primary modeling platform — free, collaborative, version history"
      tier: free
      cost: "$0"
      alternatives: ["Microsoft Excel", "LibreOffice Calc"]
    - name: "Causal"
      purpose: "Dedicated financial modeling with built-in scenario analysis and natural language formulas"
      tier: paid
      cost: "$50-250/month"
      alternatives: ["Mosaic", "Jirav", "Pry (now Brex)"]
    - name: "Stripe Dashboard or billing system"
      purpose: "Source of truth for actual MRR data import"
      tier: free
      cost: "$0 (part of payment processing)"
      alternatives: ["Chargebee", "Recurly", "Baremetrics", "ChartMogul"]
  credentials_needed:
    - service: "Google Workspace"
      type: "Google account"
      where_to_get: "https://accounts.google.com/signup"
      free_tier_limits: "Unlimited spreadsheets, 10M cells per spreadsheet"
  estimated_duration: "4-8 hours for full model build; 1-2 hours using template with real data"
  estimated_cost: "$0 (Google Sheets) to $250/month (dedicated FP&A tool)"

# === DISTRIBUTION ===
canonical_source: "https://knowledgelib.io/finance/startup-finance/saas-financial-model-spreadsheet-template/2026"
suggested_citation: "Source: knowledgelib.io — AI Knowledge Library (verified 2026-03-11)"

# === RELATED UNITS ===
related_kos:
  depends_on:
    - id: "finance/modeling/startup-financial-model/2026"
      label: "General startup financial projections framework — P&L, cash flow and runway with assumptions discipline"
  feeds_into:
    - id: "business/fundraising/financial-projections-for-investors/2026"
      label: "How to present financial projections to investors — pitch-deck financials by stage, assumptions, and common investor questions"
  related_to:
    - id: "finance/industry-benchmarks/saas-industry-benchmarks-2026/2026"
      label: "SaaS industry benchmarks 2026 — CAC, LTV:CAC, NRR, churn, gross margin, Rule of 40 by segment"
    - id: "finance/saas-metrics/arr-growth-benchmarks/2026"
      label: "SaaS ARR growth rate benchmarks by revenue band, with guidance on setting growth targets"
  alternative_to: []

# === SOURCES ===
sources:
  - id: src1
    title: "SaaS Financial Plan 2.0"
    author: Christoph Janz
    url: https://christophjanz.blogspot.com/2016/03/saas-financial-plan-20.html
    type: technical_blog
    published: 2016-03-01
    reliability: authoritative
  - id: src2
    title: "SaaS Metrics 2.0 — A Guide to Measuring and Improving What Matters"
    author: David Skok
    url: https://www.forentrepreneurs.com/saas-metrics-2/
    type: technical_blog
    published: 2013-02-01
    reliability: authoritative
  - id: src3
    title: "The SaaS Cohort Analysis Model Every Founder Needs"
    author: The VC Corner
    url: https://www.thevccorner.com/p/saas-cohort-analysis-model-excel-template
    type: technical_blog
    published: 2025-06-01
    reliability: high
  - id: src4
    title: "How to Create Your MRR Schedule"
    author: Ben Murray (The SaaS CFO)
    url: https://www.thesaascfo.com/how-to-create-your-mrr-schedule/
    type: technical_blog
    published: 2024-01-15
    reliability: authoritative
  - id: src5
    title: "3-Statement Model — Complete Guide"
    author: Wall Street Prep
    url: https://www.wallstreetprep.com/knowledge/build-integrated-3-statement-financial-model/
    type: official_docs
    published: 2024-06-01
    reliability: authoritative
  - id: src6
    title: "SaaS CAC Payback Benchmarks: 2025 Report"
    author: First Page Sage
    url: https://firstpagesage.com/reports/saas-cac-payback-benchmarks/
    type: industry_report
    published: 2025-01-15
    reliability: high
  - id: src7
    title: "Cap Table and Exit Waterfall Tool"
    author: Foresight
    url: https://foresight.is/cap-table/
    type: official_docs
    published: 2025-03-01
    reliability: high
  - id: src8
    title: "How to Build a Startup Financial Model (2024 Edition)"
    author: Causal
    url: https://www.causal.app/blog/how-to-build-a-startup-financial-model-2024
    type: technical_blog
    published: 2024-01-01
    reliability: high
---

# SaaS Financial Model Spreadsheet Template

## Purpose

This recipe produces a complete, integrated SaaS financial model in a 7-tab spreadsheet workbook covering MRR waterfall (new, expansion, contraction, churn, reactivation), cohort retention analysis, three-statement financials (P&L, balance sheet, cash flow), cap table with SAFE/convertible note modeling, and base/bull/bear scenario toggles. The output is investor-grade — suitable for board reporting, fundraising decks, and internal planning from pre-revenue through Series A. [src1]

## Prerequisites

- [ ] **Pricing structure defined** — tier names, monthly/annual prices, expected distribution across tiers
- [ ] **Historical MRR data** (if post-revenue) — monthly breakdown from billing system (Stripe, Chargebee, or manual) with new, expansion, contraction, and churned MRR
- [ ] **Operating expense estimates** — headcount plan (roles, salaries, start dates), tool/infrastructure costs, marketing budget
- [ ] **Cap table inputs** (if modeling equity) — founder splits, any existing SAFEs/convertible notes, option pool size
- [ ] **Google Sheets or Excel** — free Google account sufficient; Excel requires Microsoft 365 subscription
- [ ] **3-6 hours of focused time** — model construction is sequential; interrupted work produces broken links

## Constraints

- MRR waterfall must decompose into five distinct components (New, Expansion, Contraction, Churn, Reactivation) — a single "net new MRR" line hides whether growth comes from acquisition or retention. [src4]
- Cohort analysis requires month-by-month tracking per acquisition cohort. Rolling averages obscure retention decay patterns that investors scrutinize. [src3]
- The three-statement model must be fully linked: P&L net income feeds the cash flow statement, ending cash balance feeds the balance sheet. Any break in linkage invalidates the entire model. [src5]
- All assumptions must live in a single dedicated tab. Formula cells must never contain hardcoded numbers. This enables scenario toggling without hunting through sheets. [src1]
- CAC payback period benchmarks shifted in 2025: median is now 15 months across B2B SaaS, up from 12 months. Models using pre-2024 benchmarks will appear unrealistically optimistic. [src6]

## Tool Selection Decision

```
Which path?
├── User is non-technical AND wants fastest setup
│   └── PATH A: Template-Based — Google Sheets with pre-built template
├── User is semi-technical AND wants customizable model
│   └── PATH B: Build in Sheets — Google Sheets from scratch using this recipe
├── User wants dedicated FP&A tool AND has budget
│   └── PATH C: Dedicated Platform — Causal, Mosaic, or Jirav
└── User is analyst/developer AND wants maximum control
    └── PATH D: Excel Power Build — Excel with VBA macros and data connections
```

| Path | Tools | Cost | Build Time | Flexibility |
|------|-------|------|------------|-------------|
| A: Template-Based | Google Sheets + template | $0 | 1-2 hours | Low — constrained to template structure |
| B: Build in Sheets | Google Sheets from scratch | $0 | 4-8 hours | High — fully customizable |
| C: Dedicated Platform | Causal/Mosaic/Jirav | $50-250/mo | 2-4 hours | Medium — platform-guided but extensible |
| D: Excel Power Build | Excel + VBA | $7-13/mo | 6-12 hours | Maximum — full programmatic control |

## Execution Flow

### Step 1: Create Workbook Structure and Assumptions Tab

**Duration**: 30-45 minutes
**Tool**: Google Sheets or Excel

Create the 7-tab workbook skeleton. The Assumptions tab is the control center — every other tab reads from it.

```
Tab structure:
1. Assumptions        — all input variables (blue cells = editable)
2. MRR Waterfall      — monthly MRR movements
3. Cohort Analysis    — retention by acquisition cohort
4. P&L               — income statement (monthly for Year 1-2, quarterly for Year 3)
5. Cash Flow          — operating/investing/financing activities
6. Balance Sheet      — assets, liabilities, equity
7. Cap Table          — ownership, dilution, exit scenarios

ASSUMPTIONS TAB LAYOUT:
═══════════════════════════════════════════════════

Row 1:  SCENARIO TOGGLE → [Base] [Bull] [Bear]  (data validation dropdown)

REVENUE ASSUMPTIONS
  Pricing tiers:
    Basic:      $__/mo    Annual discount: ___%
    Pro:        $__/mo    Annual discount: ___%
    Enterprise: $__/mo    Annual discount: ___%
  Tier distribution:      ___% / ___% / ___%

  Customer acquisition:
    Month 1 new customers:        ___
    Monthly growth rate (Base):   ___%
    Monthly growth rate (Bull):   ___%
    Monthly growth rate (Bear):   ___%

  Retention:
    Monthly logo churn (Base):    ___%
    Monthly logo churn (Bull):    ___%
    Monthly logo churn (Bear):    ___%
    Expansion rate (% of base):   ___%
    Contraction rate:             ___%

UNIT ECONOMICS
    CAC (blended):                $___
    Gross margin target:          ___%
    LTV:CAC target ratio:        ___:1

OPERATING EXPENSES
  Headcount plan:
    Eng hires (month, salary):   ___
    Sales hires (month, salary): ___
    G&A hires (month, salary):   ___
  Non-headcount:
    Infrastructure/hosting:      $___/mo
    Tools & software:            $___/mo
    Marketing spend:             $___/mo
    Legal & accounting:          $___/mo

FINANCING
    Existing cash:               $___
    Planned raise amount:        $___
    Expected raise month:        ___
    Pre-money valuation:         $___
```

**Verify**: Every blue input cell has a value. No formula cells contain hardcoded numbers. Scenario dropdown switches between three columns of assumptions.
**If failed**: If dropdown does not toggle values, check that formulas in other tabs use INDEX/MATCH or IF statements referencing the scenario cell, not direct cell references.

### Step 2: Build MRR Waterfall

**Duration**: 45-60 minutes
**Tool**: Google Sheets / Excel

The MRR waterfall tracks monthly recurring revenue movements across five components. This is the most important tab for SaaS investors. [src4]

```
MRR WATERFALL TAB:
═══════════════════════════════════════════════════

         Month 1   Month 2   Month 3  ... Month 36
         ───────   ───────   ───────      ────────
Beginning MRR       $0     [=End M1] [=End M2]

(+) New MRR       [=new_customers × blended_ARPU]
(+) Expansion MRR [=prior_base × expansion_rate]
(-) Contraction   [=prior_base × contraction_rate]
(-) Churn MRR     [=prior_base × churn_rate]
(+) Reactivation  [=churned_base × reactivation_rate]
                  ─────────
Ending MRR        [=Beginning + New + Expansion - Contraction - Churn + Reactivation]

Net New MRR       [=Ending - Beginning]

KEY FORMULAS:
  New customers (Month N) = ROUND(Month_1_customers × (1 + growth_rate)^(N-1), 0)
  New MRR = New_customers × (Basic_price × Basic_pct + Pro_price × Pro_pct + Ent_price × Ent_pct)
  Blended ARPU = New_MRR / New_customers
  Expansion MRR = Beginning_MRR × monthly_expansion_rate
  Churn MRR = Beginning_MRR × monthly_churn_rate

DERIVED METRICS (below waterfall):
  ARR              = Ending_MRR × 12
  MoM Growth       = Net_New_MRR / Beginning_MRR
  Net Revenue Retention = (Beginning - Contraction - Churn + Expansion) / Beginning
  Gross Revenue Retention = (Beginning - Contraction - Churn) / Beginning
  Quick Ratio      = (New + Expansion) / (Contraction + Churn)
```

**Expected output**: A 36-column waterfall showing monthly MRR progression with all five components, plus derived metrics row.
**Verify**: Ending MRR of Month N must exactly equal Beginning MRR of Month N+1. NRR should be 95-115% for a healthy model. Quick Ratio above 4 indicates strong growth. [src2]
**If failed**: If MRR grows unrealistically fast, check that churn applies to the full base, not just new customers. Common error: applying churn rate only to new MRR.

### Step 3: Build Cohort Retention Analysis

**Duration**: 45-60 minutes
**Tool**: Google Sheets / Excel

Cohort analysis shows how each monthly acquisition cohort retains over time. Investors use this to assess true retention quality versus blended averages. [src3]

```
COHORT ANALYSIS TAB:
═══════════════════════════════════════════════════

LOGO RETENTION COHORT TABLE
(Rows = acquisition month, Columns = months since acquisition)

Cohort    M0     M1     M2     M3     M4  ... M12    M24
──────   ────   ────   ────   ────   ────    ────   ────
Jan-26   100%   [=1-churn]  [=M1×(1-churn)]  ...
Feb-26   100%   [=1-churn]  ...
Mar-26   100%   ...
...

REVENUE RETENTION COHORT TABLE (MRR per cohort)

Cohort    M0        M1           M2              ...
──────   ────      ────         ────
Jan-26   $[ARPU]  [=M0×(1-churn+expansion)]     ...
Feb-26   $[ARPU]  ...

FORMULAS:
  Logo retention M(N) = M(N-1) × (1 - monthly_logo_churn)
  Revenue per cohort M(N) = M(N-1) × (1 - gross_churn + expansion_rate)

  NRR (from cohort) = Sum of M12 revenue / Sum of M0 revenue
  GRR (from cohort) = Sum of M12 revenue (no expansion) / Sum of M0 revenue

CONDITIONAL FORMATTING:
  Green: retention > 90%
  Yellow: retention 80-90%
  Red: retention < 80%

  Apply color scale to entire cohort triangle for visual pattern detection.
```

**Expected output**: Two triangular cohort tables (logo retention + revenue retention) with conditional formatting showing retention decay patterns.
**Verify**: Diagonal patterns should be consistent — if Month 3 retention suddenly drops for all cohorts, the churn assumption may be too aggressive. NRR calculated from cohort data should match the NRR derived in the MRR Waterfall tab. [src3]
**If failed**: If cohort revenue increases over time while logo count decreases, expansion rate may be unrealistically high. Cross-check with industry benchmarks: median NRR is 100-110% for B2B SaaS.

### Step 4: Build Three-Statement Model (P&L, Cash Flow, Balance Sheet)

**Duration**: 60-90 minutes
**Tool**: Google Sheets / Excel

The three statements must be integrated so changes in assumptions cascade correctly through all financial outputs. [src5]

```
P&L TAB (INCOME STATEMENT):
═══════════════════════════════════════════════════

                      Month 1   Month 2  ...  Year 1    Year 2    Year 3
Revenue
  Subscription MRR    [=from MRR Waterfall Ending MRR]
  Annual prepay adj.  [=annual_customers × annual_discount_savings / 12]
  ─────────
  Total Revenue       [=sum]

Cost of Revenue
  Hosting/infra       [=from Assumptions]
  Support staff       [=headcount × salary / 12]
  Payment processing  [=Revenue × 2.9%]
  ─────────
  Total COGS          [=sum]

GROSS PROFIT          [=Revenue - COGS]
  Gross Margin %      [=Gross Profit / Revenue]

Operating Expenses
  R&D (engineering)   [=eng_headcount × avg_eng_salary / 12]
  Sales & Marketing   [=marketing_spend + sales_headcount × salary / 12]
  G&A                 [=g&a_headcount × salary / 12 + tools + legal]
  ─────────
  Total OpEx          [=sum]

EBITDA                [=Gross Profit - OpEx]
  EBITDA Margin %     [=EBITDA / Revenue]

D&A                   [=capex_depreciation_schedule]
EBIT                  [=EBITDA - D&A]
Interest              [=debt × interest_rate / 12]
Tax                   [=MAX(0, EBT × tax_rate)]
─────────
NET INCOME            [=EBIT - Interest - Tax]


CASH FLOW TAB:
═══════════════════════════════════════════════════

Operating Activities
  Net Income           [=from P&L]
  (+) D&A              [=from P&L]
  (+/-) Working cap    [=change in AR + AP + deferred revenue]
  ─────────
  Cash from Operations [=sum]

Investing Activities
  CapEx                [=from Assumptions]
  ─────────
  Cash from Investing  [=sum]

Financing Activities
  Equity raised        [=from Cap Table raise schedule]
  Debt drawn/repaid    [=from Assumptions]
  ─────────
  Cash from Financing  [=sum]

NET CASH CHANGE        [=Ops + Investing + Financing]
Beginning Cash         [=prior month ending cash]
ENDING CASH            [=Beginning + Net Change]

RUNWAY (months)        [=Ending Cash / ABS(monthly burn rate)]


BALANCE SHEET TAB:
═══════════════════════════════════════════════════

Assets
  Cash                 [=from Cash Flow ending cash]
  Accounts Receivable  [=Revenue × days_sales_outstanding / 30]
  Prepaid Expenses     [=annual_prepaid_tools / 12 × remaining_months]
  ─────────
  Total Current Assets [=sum]

  PP&E (net)           [=CapEx - Accumulated D&A]
  ─────────
  TOTAL ASSETS         [=Current + PP&E]

Liabilities
  Accounts Payable     [=COGS × days_payable / 30]
  Deferred Revenue     [=annual_prepay_customers × annual_price × remaining_months / 12]
  Accrued Expenses     [=payroll accrual]
  ─────────
  Total Current Liab   [=sum]

  Long-term Debt       [=from Assumptions]
  ─────────
  TOTAL LIABILITIES    [=Current + LT Debt]

Equity
  Common Stock         [=from Cap Table]
  Additional Paid-In   [=from Cap Table — invested capital]
  Retained Earnings    [=prior RE + Net Income]
  ─────────
  TOTAL EQUITY         [=sum]

TOTAL L + E            [=Liabilities + Equity]
BALANCE CHECK          [=Assets - (L+E)]  ← MUST BE $0
```

**Verify**: Balance sheet must balance — the BALANCE CHECK cell must show exactly $0. If not zero, trace the error: most common cause is deferred revenue or working capital changes not flowing correctly between P&L and balance sheet. [src5]
**If failed**: If balance sheet does not balance, check three things: (1) Net income from P&L matches cash flow starting point, (2) ending cash from cash flow matches balance sheet cash, (3) retained earnings equals prior RE plus current net income.

### Step 5: Build Cap Table with SAFE/Note Modeling

**Duration**: 30-45 minutes
**Tool**: Google Sheets / Excel

The cap table tracks ownership through funding rounds, modeling SAFE and convertible note conversion at priced rounds. [src7]

```
CAP TABLE TAB:
═══════════════════════════════════════════════════

FOUNDING EQUITY
  Founder 1:     _____ shares (___%)
  Founder 2:     _____ shares (___%)
  Option Pool:   _____ shares (___%)
  ─────────
  Total:         10,000,000 shares (100%)

PRE-SEED / SAFE INSTRUMENTS
  SAFE 1: $___K at $___M cap, [pre/post]-money
  SAFE 2: $___K at $___M cap, [pre/post]-money
  Convert Note: $___K at $___M cap, ___% discount, ___% interest

PRICED ROUND (Seed/Series A)
  Investment amount:    $___
  Pre-money valuation:  $___
  Price per share:      [=Pre-money / pre-round shares]

  SAFE conversion:
    SAFE shares = Investment / MIN(cap_price, round_price × (1 - discount))

  Post-round ownership:
    Founder 1:    ___% [=founder_shares / post_round_total]
    Founder 2:    ___%
    Option Pool:  ___%
    SAFE holders: ___%
    New investor:  ___%
    ─────────
    Total:        100%

EXIT WATERFALL (for scenario analysis)
  Exit value:    $___M
  Liquidation preferences applied first
  Remaining distributed pro-rata

  Per-stakeholder return:
    Investor return: $___  (___x multiple)
    Founder 1:       $___
    Founder 2:       $___
    Option pool:     $___
```

**Verify**: Post-round ownership percentages must sum to exactly 100%. SAFE conversion math must use the lower of (valuation cap / pre-money shares) and (round price x (1 - discount)). [src7]
**If failed**: If ownership exceeds 100%, check whether post-money SAFEs are being double-counted in the pre-round share count. Post-money SAFEs include themselves in the cap — pre-money SAFEs do not.

### Step 6: Add Scenario Toggles and Dashboard

**Duration**: 30-45 minutes
**Tool**: Google Sheets / Excel

Wire up the scenario toggle so a single dropdown changes all assumptions simultaneously, then build a summary dashboard.

```
SCENARIO TOGGLE IMPLEMENTATION:
═══════════════════════════════════════════════════

Cell B1 (Assumptions tab): Data Validation dropdown → "Base", "Bull", "Bear"

For each scenario-dependent assumption, use:
  =INDEX(base_value, bull_value, bear_value, MATCH(B1, {"Base","Bull","Bear"}, 0))

Example for monthly growth rate:
  Base: 8%    Bull: 12%    Bear: 4%
  Formula: =INDEX({0.08, 0.12, 0.04}, MATCH($B$1, {"Base","Bull","Bear"}, 0))

SCENARIO DEFINITIONS:
  Base: Median outcomes — historical growth rate continues, median churn
  Bull: Top-quartile — 50% faster growth, 30% lower churn, faster expansion
  Bear: Bottom-quartile — 50% slower growth, 50% higher churn, delayed hiring

DASHBOARD TAB (summary charts):
  Chart 1: ARR trajectory — 3 scenario lines over 36 months
  Chart 2: MRR waterfall — stacked bar (new/expansion/contraction/churn)
  Chart 3: Unit economics — CAC, LTV, payback period trend
  Chart 4: Cash runway — months of runway remaining per scenario
  Chart 5: Headcount plan — stacked area by department
  Chart 6: Gross margin trend — line chart with 70% target line

KEY METRICS SUMMARY BOX:
  ┌─────────────────────────────────────────┐
  │ Metric          Base    Bull    Bear    │
  │ Year 1 ARR     $___K   $___K   $___K   │
  │ Year 2 ARR     $___K   $___K   $___K   │
  │ Year 3 ARR     $___M   $___M   $___M   │
  │ Gross Margin    ___%    ___%    ___%    │
  │ NRR             ___%    ___%    ___%    │
  │ CAC Payback     ___mo   ___mo   ___mo   │
  │ LTV:CAC         ___:1   ___:1   ___:1   │
  │ Runway          ___mo   ___mo   ___mo   │
  │ Break-even      M___    M___    M___    │
  └─────────────────────────────────────────┘
```

**Verify**: Toggle scenario dropdown from Base to Bull to Bear. All charts and metrics should update automatically. If any cell shows #REF! or #VALUE!, a formula link is broken.
**If failed**: Trace the error by checking that INDEX/MATCH formulas in the Assumptions tab correctly reference the scenario dropdown cell with an absolute reference ($B$1).

## Output Schema

```json
{
  "output_type": "saas_financial_model",
  "format": "XLSX or Google Sheets",
  "tabs": [
    {"name": "Assumptions", "description": "All editable inputs with scenario toggle", "required": true},
    {"name": "MRR Waterfall", "description": "Monthly MRR movements: new, expansion, contraction, churn, reactivation", "required": true},
    {"name": "Cohort Analysis", "description": "Logo and revenue retention by acquisition cohort", "required": true},
    {"name": "P&L", "description": "Income statement — monthly Year 1-2, quarterly Year 3", "required": true},
    {"name": "Cash Flow", "description": "Operating, investing, financing cash flows with runway calc", "required": true},
    {"name": "Balance Sheet", "description": "Assets, liabilities, equity with balance check", "required": true},
    {"name": "Cap Table", "description": "Ownership, SAFE conversion, exit waterfall", "required": false}
  ],
  "time_horizon": "36 months",
  "scenario_count": 3,
  "deduplication_key": "tab_name"
}
```

## Quality Benchmarks

| Quality Metric | Minimum Acceptable | Good | Excellent |
|---------------|-------------------|------|-----------|
| Balance sheet balances | Within $1 (rounding) | Exactly $0 | $0 with audit trail formulas |
| MRR waterfall components | 3 (new, churn, net) | 5 (new, expansion, contraction, churn, reactivation) | 5 + reactivation + downsell split |
| Cohort depth | 6-month triangle | 12-month triangle | 24-month triangle with revenue overlay |
| Scenario coverage | Base only | Base + Bull + Bear | 3 scenarios + sensitivity tables |
| Assumption documentation | Cells labeled | Cells labeled + source notes | Full assumption log with benchmark citations |
| Integration integrity | P&L standalone | P&L feeds cash flow | All 3 statements fully linked |

**If below minimum**: Re-check all inter-tab cell references. The most common failure mode is a broken link between P&L net income and the cash flow statement. Use Ctrl+` (grave accent) to show all formulas and trace dependencies.

## Error Handling

| Error | Likely Cause | Recovery Action |
|-------|-------------|----------------|
| Balance sheet does not balance (non-zero check) | Missing working capital adjustment or deferred revenue | Trace: Net Income → Cash Flow → Ending Cash → Balance Sheet Cash. Fix the broken link. |
| MRR grows then suddenly drops to zero | Churn formula references wrong cell range | Check churn formula applies to Beginning MRR, not a fixed cell. Use absolute row + relative column references. |
| Circular reference error | Cash interest depends on cash balance which depends on interest | Break circularity: use prior month cash balance for interest calculation, or enable iterative calculation (File > Settings > Calculation). |
| Scenario toggle does not update all tabs | Some formulas hardcode values instead of referencing Assumptions | Search all tabs for hardcoded numbers (non-blue cells with constants). Replace with references to Assumptions tab. |
| Negative cash but model shows positive runway | Runway formula uses average burn instead of current burn | Use trailing 3-month average burn rate: =Ending_Cash / AVERAGE(last_3_months_net_cash_change × -1). |
| Cap table ownership exceeds 100% | Post-money SAFE double-counted | Post-money SAFEs include their own dilution in the cap. Do not add SAFE shares to pre-money count before calculating price per share. [src7] |

## Cost Breakdown

| Component | Free Tier | Paid Tier | At Scale |
|-----------|-----------|-----------|----------|
| Spreadsheet platform | Google Sheets ($0) | Excel M365 ($7-13/mo) | Google Workspace ($6-18/mo) |
| Dedicated FP&A tool | N/A | Causal ($50/mo) | Mosaic/Jirav ($500-1500/mo) |
| Metrics dashboard | Manual (from model) | ChartMogul ($0-99/mo) | Baremetrics ($108-458/mo) |
| Template purchase | $0 (this recipe) | $50-150 (premium templates) | N/A |
| **Total for seed-stage** | **$0** | **$50-150 one-time** | **$500-2000/mo** |

## Anti-Patterns

### Wrong: Building a single-line MRR forecast without waterfall decomposition
A model showing only "Total MRR" per month tells investors nothing about the health of the business. It masks whether growth comes from new customer acquisition (expensive) or expansion revenue (efficient). Every investor will ask for the waterfall breakdown. [src2]

### Correct: Always decompose MRR into five components
New, Expansion, Contraction, Churn, and Reactivation must be separate line items. This reveals the Net Revenue Retention rate — the single most important SaaS metric for investors. NRR above 100% means the business grows even without new customers. [src4]

### Wrong: Using blended averages instead of cohort-level retention
Blended monthly churn of 3% looks acceptable. But cohort analysis might reveal that Month 1 churn is 15% while Month 6+ churn is 1% — meaning onboarding is broken but retained customers are happy. Blended metrics hide the actionable insight. [src3]

### Correct: Build cohort retention tables from Day 1
Even with assumed data pre-revenue, model retention at the cohort level. When real data arrives, replace assumptions cohort-by-cohort. This structure reveals retention patterns that blended averages obscure.

### Wrong: Hardcoding assumption values directly in formula cells
Scattering constants like "0.05" across 200 formula cells makes the model impossible to audit and scenario analysis impossible. Changing one assumption requires editing dozens of cells.

### Correct: Single Assumptions tab with all inputs in labeled, colored cells
Every variable lives in one place. Formula cells only contain references and calculations. Blue cells = editable inputs. Black cells = computed. This is the standard that Christoph Janz established and investors expect. [src1]

## When This Matters

Use this recipe when a founder or finance lead needs to build an actual working SaaS financial model — not read about SaaS metrics, but construct a spreadsheet they can populate with real data, present to investors, and use for monthly planning. The output is a 7-tab integrated workbook that serves as the single source of truth for revenue projections, cash management, and fundraising preparation.

## Related Units

- [Startup Financial Projections Template](/finance/startup-finance/startup-financial-projections-template/2026) — general framework this recipe builds upon
- [Fundraising Financial Summary](/finance/startup-finance/fundraising-financial-summary/2026) — extract investor-ready summary from this model
- [Startup Runway Calculator](/finance/startup-finance/startup-runway-calculator/2026) — detailed cash runway analysis
- [SaaS Unit Economics Benchmarks](/finance/saas-benchmarks/saas-unit-economics-benchmarks/2026) — validate model assumptions
- [SaaS ARR Growth Benchmarks](/finance/saas-benchmarks/saas-arr-growth-benchmarks/2026) — benchmark growth rates by stage