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.

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

Detailed section: Step-by-Step Process

Originally a 2763-byte section in this SKILL.md. Moved to references/details.md to fit Codex's 8 KB skill body cap.

Business Model Templates

SaaS Financial Model

Revenue Drivers:

• New MRR (customers × ARPU)
• Expansion MRR (upsells)
• Contraction MRR (downgrades)
• Churned MRR (lost customers)

Key Ratios:

• Gross margin: 75-85%
• S&M as % revenue: 40-60% (early stage)
• CAC payback: < 12 months
• Net retention: 100-120%

Example Projection:

Year 1: $500K ARR, 50 customers, $100K MRR by Dec
Year 2: $2.5M ARR, 200 customers, $208K MRR by Dec
Year 3: $8M ARR, 600 customers, $667K MRR by Dec

Marketplace Financial Model

Revenue Drivers:

• GMV (Gross Merchandise Value)
• Take rate (% of GMV)
• Net revenue = GMV × Take rate

Key Ratios:

• Take rate: 10-30% depending on category
• CAC for buyers vs. sellers
• Contribution margin: 60-70%

Example Projection:

Year 1: $5M GMV, 15% take rate = $750K revenue
Year 2: $20M GMV, 15% take rate = $3M revenue
Year 3: $60M GMV, 15% take rate = $9M revenue

E-Commerce Financial Model

Revenue Drivers:

• Traffic (visitors)
• Conversion rate
• Average order value (AOV)
• Purchase frequency

Key Ratios:

• Gross margin: 40-60%
• Contribution margin: 20-35%
• CAC payback: 3-6 months

Services / Agency Financial Model

Revenue Drivers:

• Billable hours or projects
• Hourly rate or project fee

…