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 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?
mkdir -p ~/.claude/skills/startup-financial-modeling # Save SKILL.md to ~/.claude/skills/startup-financial-modeling/SKILL.md
- 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.
- 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.
- 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.
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.