Skip to main content
Agent skill

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 creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-ready financials for a seed or Series A raise.

Get started

Get the complete skill folder, including its scripts and reference files.

When to use this skill

Use Startup Financial Modeling when an AI agent needs a reusable SKILL.md workflow for this job: 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 creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-ready financials for a seed or Series A raise.

When not to use it

Skip Startup Financial Modeling when the task is outside the business category, or when a more specific skill in this directory already covers the same workflow with clearer triggers.

How to install

Where will you use it?

Install scope
Claude Code folder setup
mkdir -p ~/.claude/skills/startup-financial-modeling
# Save SKILL.md to ~/.claude/skills/startup-financial-modeling/SKILL.md
  1. Claude Code personal install: place the skill and its bundled files at ~/.claude/skills/startup-financial-modeling/SKILL.md. For a shared project, commit the folder at .claude/skills/startup-financial-modeling/ instead.
  2. Current Claude Code detects SKILL.md changes in watched directories during the session. If you just created a top-level skills directory, run /reload-skills. Check that the skill is listed before testing its trigger.
  3. For Claude chat or Cowork in the Desktop app, manage uploaded skills in Customize > Skills; copying files into a local Claude Code folder is not a Desktop install. Other agents may use different install locations.

Full install guide for Claude, Cursor, and Codex →

Try a starter prompt

After installing the skill, paste this starter prompt into your agent to verify it triggers on a small task.

Starter prompt
Use the Startup Financial Modeling skill for this task: Use Startup Financial Modeling when this documented workflow matches the task. Confirm any required inputs or files before making changes.

What supports this recommendation?

72/100 provisional content score. This measures documentation, practical detail and source signals. It is not a measured task success rate or a security certification.

Documentation
77/100
Practical detail
68/100
Source evidence
63/100
Source signals
80/100
Model compatibility evidence
  • claudeuntested

    No model-specific signal or recorded compatibility test was found.

  • chatgptuntested

    No model-specific signal or recorded compatibility test was found.

  • geminiuntested

    No model-specific signal or recorded compatibility test was found.

  • copilotuntested

    No model-specific signal or recorded compatibility test was found.

  • llamauntested

    No model-specific signal or recorded compatibility test was found.

  • perplexityuntested

    No model-specific signal or recorded compatibility test was found.

  • mistraluntested

    No model-specific signal or recorded compatibility test was found.

  • grokuntested

    No model-specific signal or recorded compatibility test was found.

Inferred compatibility is based on content signals. Check the app, its available tools and setup requirements before running a skill.

What this skill does

# 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 - 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.

## 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

Intended uses

  • Use Startup Financial Modeling when this documented workflow matches the task.

Implementation notes

  • Review the source instructions and adapt inputs before running the workflow.

Try it, then tell us how it went

A copied prompt does not tell us whether the task worked. Report your result after checking the output. We collect your tool and outcome, never your files or prompt.