Startup Financial Modeling

Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.

Use this skill when

• Working on startup financial modeling tasks or workflows
• Needing guidance, best practices, or checklists for startup financial modeling

Do not use this skill when

• The task is unrelated to startup financial modeling
• You need a different domain or tool outside this scope

Instructions

• Clarify goals, constraints, and required inputs.
• Apply relevant best practices and validate outcomes.
• Provide actionable steps and verification.
• If detailed examples are required, open resources/implementation-playbook.md.

Overview

Financial modeling provides the quantitative foundation for startup strategy, fundraising, and operational planning. Create realistic projections using cohort-based revenue modeling, detailed cost structures, and scenario analysis to support decision-making and investor presentations.

Core Components

Revenue Model

Cohort-Based Projections: Build revenue from customer acquisition and retention by cohort.

Formula:

MRR = Σ (Cohort Size × Retention Rate × ARPU)
ARR = MRR × 12

Key Inputs:

• Monthly new customer acquisitions
• Customer retention rates by month
• Average revenue per user (ARPU)
• Pricing and packaging assumptions
• Expansion revenue (upsells, cross-sells)

Cost Structure

Operating Expenses Categories:

1. Cost of Goods Sold (COGS)

   • Hosting and infrastructure
   • Payment processing fees
   • Customer support (variable portion)
   • Third-party services per customer

2. Sales & Marketing (S&M)

   • Customer acquisition cost (CAC)
   • Marketing programs and advertising
   • Sales team compensation
   • Marketing tools and software

3. Research & Development (R&D)

   • Engineering team compensation
   • Product management
   • Design and UX
   • Development tools and infrastructure

4. General & Administrative (G&A)

   • Executive team
   • Finance, legal, HR
   • Office and facilities
   • Insurance and compliance

Cash Flow Analysis

Components:

• Beginning cash balance
• Cash inflows (revenue, fundraising)
• Cash outflows (operating expenses, CapEx)
• Ending cash balance
• Monthly burn rate
• Runway (months of cash remaining)

Formula:

Runway = Current Cash Balance / Monthly Burn Rate
Monthly Burn = Monthly Revenue - Monthly Expenses

Headcount Planning

Role-Based Hiring Plan: Track headcount by department and role.

Key Metrics:

• Fully-loaded cost per employee
• Revenue per employee
• Headcount by department (% of total)

Typical Ratios (Early-Stage SaaS):

• Engineering: 40-50%
• Sales & Marketing: 25-35%
• G&A: 10-15%
• Customer Success: 5-10%

Financial Model Structure

Three-Scenario Framework

Conservative Scenario (P10):

• Slower customer acquisition
• Lower pricing or conversion
• Higher churn rates
• Extended sales cycles
• Used for cash management

Base Scenario (P50):

• Most likely outcomes
• Realistic assumptions
• Primary planning scenario
• Used for board reporting

Optimistic Scenario (P90):

• Faster growth
• Better unit economics
• Lower churn
• Used for upside planning

Time Horizon

Detailed Projections: 3 Years

• Monthly detail for Year 1
• Monthly detail for Year 2
• Quarterly detail for Year 3

High-Level Projections: Years 4-5

• Annual projections
• Key metrics only
• Support long-term planning

Step-by-Step Process

Step 1: Define Business Model

Clarify revenue model and pricing.

SaaS Model:

• Subscription pricing tiers
• Annual vs. monthly contracts
• Free trial or freemium approach
• Expansion revenue strategy

Marketplace Model:

• GMV projections
• Take rate (% of transactions)
• Buyer and seller economics
• Transaction frequency

Transactional Model:

• Transaction volume
• Revenue per transaction
• Frequency and seasonality

Step 2: Build Revenue Projections

Use cohort-based methodology for accuracy.

Monthly Customer Acquisition: Define new customers acquired each month.

Retention Curve: Model customer retention over time.

Typical SaaS Retention:

• Month 1: 100%
• Month 3: 90%
• Month 6: 85%
• Month 12: 75%
• Month 24: 70%

Revenue Calculation: For each cohort, calculate retained customers × ARPU for each month.

Step 3: Model Cost Structure

Break down costs by category and behavior.

Fixed vs. Variable:

• Fixed: Salaries, software, rent
• Variable: Hosting, payment processing, support

Scaling Assumptions:

• COGS as % of revenue
• S&M as % of revenue (CAC payback)
• R&D growth rate
• G&A as % of total expenses

Step 4: Create Hiring Plan

Model headcount growth by role and department.

Inputs:

• Starting headcount
• Hiring velocity by role
• Fully-loaded compensation by role
• Benefits and taxes (typically 1.3-1.4x salary)

Example:

Engineer: $150K salary × 1.35 = $202K fully-loaded
Sales Rep: $100K OTE × 1.30 = $130K fully-loaded

Step 5: Project Cash Flow

Calculate monthly cash position and runway.

Monthly Cash Flow:

Beginning Cash
+ Revenue Collected (consider payment terms)
- Operating Expenses Paid
- CapEx
= Ending Cash

Runway Calculation:

If Ending Cash  3, payback < 18 months)
- [ ] Burn multiple is reasonable (< 2.0 in Year 2-3)
- [ ] Headcount scales with revenue (revenue per employee growing)
- [ ] Gross margin is appropriate for business model
- [ ] S&M spending aligns with CAC and growth targets

**Benchmark Against Peers:**
Compare key metrics to similar companies at similar stage.

**Investor Feedback:**
Share model with advisors or investors for feedback on assumptions.

## Additional Resources

### Reference Files

For detailed model structures and advanced techniques:
- **`references/model-templates.md`** - Complete financial model templates by business model
- **`references/unit-economics.md`** - Deep dive on CAC, LTV, payback, and efficiency metrics
- **`references/fundraising-scenarios.md`** - Modeling funding rounds and dilution

### Example Files

Working financial models with formulas:
- **`examples/saas-financial-model.md`** - Complete 3-year SaaS model with cohort analysis
- **`examples/marketplace-model.md`** - Marketplace GMV and take rate projections
- **`examples/scenario-analysis.md`** - Three-scenario framework with sensitivities

## Quick Start

To create a startup financial model:

1. **Define business model** - Revenue drivers and pricing
2. **Project revenue** - Cohort-based with retention
3. **Model costs** - COGS, S&M, R&D, G&A by month
4. **Plan headcount** - Hiring by role and department
5. **Calculate cash flow** - Revenue - expenses = burn/runway
6. **Compute metrics** - CAC, LTV, burn multiple, runway
7. **Create scenarios** - Conservative, base, optimistic
8. **Validate assumptions** - Sanity check and benchmark
9. **Integrate fundraising** - Model funding rounds and milestones

For complete templates and formulas, reference the `references/` and `examples/` files.