Imported from Panopticon-AB/WarRoom (scratch/awesome-skills/plugins/antigravity-awesome-skills-claude/skills/startup-financial-modeling/SKILL.md). Install upstream with npx skills add Panopticon-AB/WarRoom --skill startup-financial-modeling. Copyright stays with the author.

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:

Cost of Goods Sold (COGS)
- Hosting and infrastructure
- Payment processing fees
- Customer support (variable portion)
- Third-party services per customer
Sales & Marketing (S&M)
- Customer acquisition cost (CAC)
- Marketing programs and advertising
- Sales team compensation
- Marketing tools and software
Research & Development (R&D)
- Engineering team compensation
- Product management
- Design and UX
- Development tools and infrastructure
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 < 0:
  Funding Need = Negative Cash Balance
  Runway = 0
Else:
  Runway = Ending Cash / Average Monthly Burn

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, $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
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 expense estimates
Include fully-loaded compensation
Account for software and tools

Pitfall 3: Ignoring Cash Flow Timing

Revenue ≠ cash (payment terms)
Expenses paid before revenue collected
Model cash conversion carefully

Pitfall 4: Static Headcount

Hiring takes time (3-6 months to fill roles)
Ramp time for productivity (3-6 months)
Account for attrition (10-15% annually)

Pitfall 5: Not Scenario Planning

Single scenario is never accurate
Always model conservative case
Plan for what you'll do if base case fails

Model Validation

Sanity Checks:

Revenue growth rate is achievable (3x in Year 2, 2x in Year 3)
Unit economics are realistic (LTV/CAC > 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:

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

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

startup-financial-modeling

About

Startup Financial Modeling

Use this skill when

Do not use this skill when

Instructions

Overview

Core Components

Revenue Model

Cost Structure

Cash Flow Analysis

Headcount Planning

Financial Model Structure

Three-Scenario Framework

Time Horizon

Step-by-Step Process

Step 1: Define Business Model

Step 2: Build Revenue Projections

Step 3: Model Cost Structure

Step 4: Create Hiring Plan

Step 5: Project Cash Flow

Step 6: Calculate Key Metrics

Step 7: Scenario Analysis

Business Model Templates

SaaS Financial Model

Marketplace Financial Model

E-Commerce Financial Model

Services / Agency Financial Model

Fundraising Integration

Funding Scenario Modeling

Milestone-Based Planning

Common Pitfalls

Model Validation

Additional Resources

Reference Files

Example Files

Quick Start

Use it

Manifest

Reviews