SaaS Financial Model Template

FINANCIAL MODELING PHILOSOPHY

Understanding Models as Decision Tools

FINANCIAL MODELING FUNDAMENTALS

WHAT FINANCIAL MODELS DO:
☐ Project future financial outcomes
☐ Test assumptions and scenarios
☐ Support strategic decisions
☐ Communicate plans to investors
☐ Enable resource allocation

CEO'S ROLE IN MODELING:
☐ Own the key assumptions
☐ Understand model drivers
☐ Challenge unrealistic inputs
☐ Use models for decisions
☐ Don't delegate model understanding

SAAS MODEL COMPONENTS:
1. Revenue Model: How you make money
2. Cost Model: How you spend money
3. Cash Flow: How cash moves
4. Metrics: What you track
5. Scenarios: What might happen

COMMON MODELING MISTAKES:
☐ Over-complexity (harder to understand)
☐ Unrealistic assumptions (hockey stick)
☐ No scenario analysis (only one future)
☐ Ignoring cash timing
☐ Not tying to operational plans

THE MODELING MINDSET:
"A model is a simplified representation
of reality. The goal isn't perfection—
it's understanding what drives your
business and making better decisions."

---

COMPREHENSIVE SAAS FINANCIAL MODEL

SaaS Revenue Model Framework

═══════════════════════════════════════
SAAS FINANCIAL MODEL
═══════════════════════════════════════

COMPANY: _______________
Projection Period: _______________
Last Updated: _______________

═══════════════════════════════════════
SECTION 1: REVENUE MODEL
═══════════════════════════════════════

ARR WATERFALL:

Beginning ARR: $_____________

New Business:
+ New logos acquired: ___
× Average ACV: $_____
= New Business ARR: $_____________

Expansion:
+ Existing customers expanded: ___
× Average expansion: $_____
= Expansion ARR: $_____________

Contraction:
- Customers contracted: ___
× Average contraction: $_____
= Contraction ARR: ($_____________)

Churn:
- Customers churned: ___
× Average churned ACV: $_____
= Churned ARR: ($_____________)

─────────────────────────────────────
ENDING ARR: $_____________
Net New ARR: $_____________
ARR Growth Rate: ___% YoY

MONTHLY REVENUE DETAIL:
| Month | Begin ARR | New | Expand | Contract | Churn | End ARR | MRR |
|-------|-----------|-----|--------|----------|-------|---------|-----|
| Jan | $_____ | $_____ | $_____ | ($____) | ($____) | $_____ | $_____ |
| Feb | $_____ | $_____ | $_____ | ($____) | ($____) | $_____ | $_____ |
| Mar | $_____ | $_____ | $_____ | ($____) | ($____) | $_____ | $_____ |
| ... | | | | | | | |

REVENUE RECOGNITION (GAAP):
| Quarter | ARR (Ending) | Recognized Rev | Deferred Rev |
|---------|--------------|----------------|--------------|
| Q1 | $_____ | $_____ | $_____ |
| Q2 | $_____ | $_____ | $_____ |
| Q3 | $_____ | $_____ | $_____ |
| Q4 | $_____ | $_____ | $_____ |

═══════════════════════════════════════
SECTION 2: COST MODEL
═══════════════════════════════════════

COST OF REVENUE (COGS):
| Category | Fixed/Var | Driver | Monthly | Annual | % Rev |
|----------|-----------|--------|---------|--------|-------|
| Hosting/Infra | Variable | Per user | $_____ | $_____ | ___% |
| Support | Semi-var | Tickets | $_____ | $_____ | ___% |
| Services | Variable | Projects | $_____ | $_____ | ___% |
| Other COGS | Fixed | | $_____ | $_____ | ___% |
| **Total COGS** | | | $_____ | $_____ | ___% |
| **Gross Profit** | | | $_____ | $_____ | ___% |

SALES & MARKETING:
| Category | Fixed/Var | Driver | Monthly | Annual | % Rev |
|----------|-----------|--------|---------|--------|-------|
| Sales Salaries | Semi-fixed | Headcount | $_____ | $_____ | ___% |
| Sales Commissions | Variable | Bookings | $_____ | $_____ | ___% |
| Marketing Programs | Semi-var | Budget | $_____ | $_____ | ___% |
| Marketing Salaries | Fixed | Headcount | $_____ | $_____ | ___% |
| Sales Tools | Fixed | | $_____ | $_____ | ___% |
| **Total S&M** | | | $_____ | $_____ | ___% |

R&D:
| Category | Fixed/Var | Driver | Monthly | Annual | % Rev |
|----------|-----------|--------|---------|--------|-------|
| Engineering Salaries | Fixed | Headcount | $_____ | $_____ | ___% |
| Product Salaries | Fixed | Headcount | $_____ | $_____ | ___% |
| Contractors | Variable | Projects | $_____ | $_____ | ___% |
| Dev Tools | Fixed | | $_____ | $_____ | ___% |
| **Total R&D** | | | $_____ | $_____ | ___% |

G&A:
| Category | Fixed/Var | Driver | Monthly | Annual | % Rev |
|----------|-----------|--------|---------|--------|-------|
| Finance/HR | Fixed | Headcount | $_____ | $_____ | ___% |
| Legal | Semi-var | Activity | $_____ | $_____ | ___% |
| Facilities | Fixed | Lease | $_____ | $_____ | ___% |
| Insurance | Fixed | | $_____ | $_____ | ___% |
| Other G&A | Fixed | | $_____ | $_____ | ___% |
| **Total G&A** | | | $_____ | $_____ | ___% |

═══════════════════════════════════════
SECTION 3: HEADCOUNT MODEL
═══════════════════════════════════════

HEADCOUNT PLAN:
| Department | Q1 | Q2 | Q3 | Q4 | EOY | Growth |
|------------|----|----|----|----|-----|--------|
| Sales | | | | | | ___% |
| Marketing | | | | | | ___% |
| CS/Support | | | | | | ___% |
| Engineering | | | | | | ___% |
| Product | | | | | | ___% |
| G&A | | | | | | ___% |
| **Total** | | | | | | ___% |

COST PER HEAD (FULLY LOADED):
| Role | Base | Bonus | Benefits | Total |
|------|------|-------|----------|-------|
| AE | $_____ | $_____ | $_____ | $_____ |
| SDR | $_____ | $_____ | $_____ | $_____ |
| Engineer | $_____ | $_____ | $_____ | $_____ |
| Product | $_____ | $_____ | $_____ | $_____ |
| CS | $_____ | $_____ | $_____ | $_____ |
| G&A | $_____ | $_____ | $_____ | $_____ |

═══════════════════════════════════════
SECTION 4: CASH FLOW & SCENARIOS
═══════════════════════════════════════

CASH FLOW PROJECTION:
| Item | Q1 | Q2 | Q3 | Q4 | Annual |
|------|----|----|----|----|--------|
| Collections | $_____ | $_____ | $_____ | $_____ | $_____ |
| Payroll | ($____) | ($____) | ($____) | ($____) | ($____) |
| Vendors | ($____) | ($____) | ($____) | ($____) | ($____) |
| Other | ($____) | ($____) | ($____) | ($____) | ($____) |
| **Net Cash Flow** | $_____ | $_____ | $_____ | $_____ | $_____ |
| **Ending Cash** | $_____ | $_____ | $_____ | $_____ | $_____ |

SCENARIO COMPARISON:
| Metric | Downside | Base | Upside |
|--------|----------|------|--------|
| Revenue Growth | ___% | ___% | ___% |
| New Business | $_____ | $_____ | $_____ |
| Churn Rate | ___% | ___% | ___% |
| Gross Margin | ___% | ___% | ___% |
| S&M % of Rev | ___% | ___% | ___% |
| Monthly Burn | $_____ | $_____ | $_____ |
| Year-End Cash | $_____ | $_____ | $_____ |
| Runway | ___ mo | ___ mo | ___ mo |

SCENARIO TRIGGERS:
Downside if: Revenue <___% of plan
Upside if: Revenue >___% of plan

Key Model Assumptions

Assumption	Value	Source	Sensitivity
Win rate	___%	Historical	High
Deal cycle	___ days	Historical	Medium
Churn rate	___%	Historical	High
Expansion rate	___%	Historical	Medium
Avg deal size	$_____	Historical	Medium
Sales productivity	$_____/AE	Target	High
Hosting cost/user	$_____	Contract	Low

Model Output Summary

Metric	Y1	Y2	Y3	Y4	Y5
ARR	$_____	$_____	$_____	$_____	$_____
Growth	___%	___%	___%	___%	___%
Gross Margin	___%	___%	___%	___%	___%
Headcount	___	___	___	___	___
Cash Balance	$_____	$_____	$_____	$_____	$_____

---