startup-financial-modeling – Data & Science skill for AI agents

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.
• Use the examples below; no separate implementation playbook is bundled.

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:

Net Cash Burn = Cash Outflows - Operating Cash Inflows
Runway = Current Cash Balance / Net Cash Burn  # only when Net Cash Burn > 0

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:

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

Base Scenario:

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

Optimistic Scenario:

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

These are explicitly chosen scenarios, not measured probability percentiles. Do not label them P10/P50/P90 unless a documented probabilistic model and sampling justify those quantiles.

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 < 0:
  Funding Need = -Ending Cash
  Runway = 0
Else:
  Runway = Ending Cash / Average Positive Monthly Net Cash Burn
If Net Cash Burn <= 0: report runway as not applicable, not a negative duration

Step 6: Calculate Key Metrics

Track metrics that matter for stage.

Revenue Metrics:

• MRR / ARR
• Growth rate (MoM, YoY)
• Revenue by segment or cohort

Unit Economics:

• CAC (Customer Acquisition Cost)
• LTV (Lifetime Value)
• CAC Payback Period
• LTV / CAC Ratio

Efficiency Metrics:

• Burn multiple (Net Burn / Net New ARR)
• Magic number (Net New ARR / S&M Spend)
• Rule of 40 (Growth % + Profit Margin %)

Cash Metrics:

• Monthly burn rate
• Runway (months)
• Cash efficiency

Step 7: Scenario Analysis

Create three scenarios with different assumptions.

Variable Assumptions:

• Customer acquisition rate (±30%)
• Churn rate (±20%)
• Average contract value (±15%)
• CAC (±25%)

Fixed Assumptions:

• Pricing structure
• Core operating expenses
• Hiring plan (adjust timing, not roles)

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, $41.7K 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
• Utilization rate
• Team capacity

Key Ratios:

• Gross margin: 50-70%
• Utilization: 70-85%
• Revenue per employee

Fundraising Integration

Funding Scenario Modeling

Pre-Money Valuation:

Based on metrics and comparables.

Dilution:

Post-Money = Pre-Money + Investment
Dilution % = Investment / Post-Money

Use of Funds:

Allocate funding to extend runway and achieve milestones.

Example:

Raise: $5M at $20M pre-money
Post-Money: $25M
Dilution: 20%

Use of Funds:
- Product Development: $2M (40%)
- Sales & Marketing: $2M (40%)
- G&A and Operations: $0.5M (10%)
- Working Capital: $0.5M (10%)

Milestone-Based Planning

Identify Key Milestones:

• Product launch
• First $1M ARR
• Break-even on CAC
• Series A fundraise

Funding Amount:

Ensure runway to achieve next milestone + 6 months buffer.

Common Pitfalls

Pitfall 1: Overly Optimistic Revenue

• New startups rarely hit aggressive projections
• Use conservative customer acquisition assumptions
• Model realistic churn rates

Pitfall 2: Underestimating Costs

• Add 20% buffer to expe

… (full content is in the download package)