startup-financial-modeling · diff
v1.0.0 to v1.0.0
124 added, 0 removed. Audit A to A.
---
name: startup-financial-modeling
description: This skill should be used when the user asks to "create financial projections", "build a financial model", "forecast revenue", "calculate burn rate", "estimate runway", "model cash flow", or requests 3-5 year financial planning for a startup.
version: 1.0.0
---
# 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
+
+ ## 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.