Financial Model Template (SaaS)

MODEL PHILOSOPHY

Financial Model Fundamentals

FINANCIAL MODEL PHILOSOPHY

WHY A MODEL MATTERS:
☐ Investors expect professional models
☐ Forces you to understand your business
☐ Enables scenario planning
☐ Supports valuation discussions
☐ Guides hiring and spending decisions
☐ Creates accountability

MODEL PRINCIPLES:

1. ASSUMPTIONS DRIVE EVERYTHING
   ☐ Make assumptions explicit
   ☐ Document your reasoning
   ☐ Be able to defend them
   ☐ Update with actuals

2. SIMPLE > COMPLEX
   ☐ Fewer assumptions = clearer
   ☐ Complex models hide errors
   ☐ Investors prefer clarity
   ☐ Focus on key drivers

3. BOTTOMS-UP + TOP-DOWN
   ☐ Build from unit economics
   ☐ Validate against market
   ☐ Reconcile differences
   ☐ Explain variances

4. SCENARIOS ARE ESSENTIAL
   ☐ Base, upside, downside
   ☐ Key variable sensitivity
   ☐ Break-even analysis
   ☐ Runway implications

---

COMPREHENSIVE MODEL

Complete SaaS Model Structure

SAAS FINANCIAL MODEL STRUCTURE

═══════════════════════════════════════
TAB 1: ASSUMPTIONS
═══════════════════════════════════════

REVENUE ASSUMPTIONS:
Starting MRR: $_____________
New MRR growth rate: ___% monthly
Expansion revenue: ___% of base monthly
Gross churn rate: ___% monthly
Net churn (incl. expansion): ___%
Pricing assumptions: _____________

CUSTOMER ASSUMPTIONS:
Starting customers: _____
New customers/month: _____
Growth in new customers: ___% monthly
Logo churn rate: ___%
ARPU: $_____/month
ARPU growth: ___% annually

COST ASSUMPTIONS:
COGS (as % of revenue): ___%
S&M (as % of revenue): ___%
R&D (as % of revenue): ___%
G&A (as % of revenue): ___%
OR fixed cost budget: $_____/month

HEADCOUNT ASSUMPTIONS:
Current headcount: _____
Monthly hiring: _____ new hires
Avg cost per employee: $_____
Dept mix: Eng ___% / Sales ___% / Other ___%

═══════════════════════════════════════
TAB 2: REVENUE MODEL
═══════════════════════════════════════

MONTHLY REVENUE BUILD:
| Month | Beg MRR | New | Expansion | Churn | End MRR |
|-------|---------|-----|-----------|-------|---------|
| M1 | | | | | |
| M2 | | | | | |
| M3 | | | | | |
| ... | | | | | |
| M12 | | | | | |

ANNUAL SUMMARY:
| | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|--------|--------|--------|--------|--------|--------|
| ARR | | | | | |
| Growth | | | | | |
| NRR | | | | | |

═══════════════════════════════════════
TAB 3: COST MODEL
═══════════════════════════════════════

EXPENSE BUILD:
| Category | M1 | M2 | M3 | ... | Y1 Total |
|----------|-----|-----|-----|------|----------|
| COGS | | | | | |
| S&M | | | | | |
| R&D | | | | | |
| G&A | | | | | |
| Total | | | | | |

HEADCOUNT BUILD:
| Dept | M1 | M2 | M3 | ... | Y1 End |
|------|-----|-----|-----|------|---------|
| Engineering | | | | | |
| Sales | | | | | |
| Marketing | | | | | |
| G&A | | | | | |
| Total | | | | | |

═══════════════════════════════════════
TAB 4: P&L
═══════════════════════════════════════

| Line Item | M1 | M2 | ... | Y1 | Y2 | Y3 |
|-----------|-----|-----|------|------|------|------|
| Revenue | | | | | | |
| COGS | | | | | | |
| Gross Profit | | | | | | |
| Gross Margin | | | | | | |
| S&M | | | | | | |
| R&D | | | | | | |
| G&A | | | | | | |
| Total OpEx | | | | | | |
| EBITDA | | | | | | |
| EBITDA Margin | | | | | | |

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

| | M1 | M2 | ... | Y1 | Y2 |
|-----------------|------|------|------|------|------|
| Beginning Cash | | | | | |
| Net Income | | | | | |
| + Adjustments | | | | | |
| = Operating CF | | | | | |
| - CapEx | | | | | |
| + Financing | | | | | |
| Ending Cash | | | | | |
| Runway (months) | | | | | |

Key Metrics Dashboard

Metric	M1	M3	M6	M12	Y2	Y3
MRR
ARR
Customers
ARPU
Gross Margin
Burn Rate
Runway
CAC
LTV
LTV:CAC

Scenario Planning Framework

SCENARIO MODELING

BASE CASE:
Description: "Most likely outcome"
New customer growth: ___%/month
Churn: ___%/month
Burn rate: $_____/month
Runway post-raise: ___ months
Path to profitability: Month ___

UPSIDE CASE:
Description: "Things go well"
New customer growth: ___%/month (+___%)
Churn: ___%/month (-___%)
Burn rate: $_____/month
Runway post-raise: ___ months
Path to profitability: Month ___

DOWNSIDE CASE:
Description: "Conservative/problems"
New customer growth: ___%/month (-___%)
Churn: ___%/month (+___%)
Burn rate: $_____/month
Runway post-raise: ___ months
Path to profitability: Month ___

KEY SENSITIVITIES:
If churn +1%: Impact = _____________
If growth -10%: Impact = _____________
If ARPU -10%: Impact = _____________

---