Startup Financial Modeling

1---
2name: startup-financial-modeling
3description: This skill should be used when the user asks to "create financial
4  projections", "build a financial model", "forecast revenue", "calculate burn
5  rate", "estimate runway", "model cash flow", or requests 3-5 year financial
6  planning for a startup.
7metadata:
8  version: 1.0.0
9---
10 
11# Startup Financial Modeling
12 
13Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups.
14 
15## Use this skill when
16 
17- Working on startup financial modeling tasks or workflows
18- Needing guidance, best practices, or checklists for startup financial modeling
19 
20## Do not use this skill when
21 
22- The task is unrelated to startup financial modeling
23- You need a different domain or tool outside this scope
24 
25## Instructions
26 
27- Clarify goals, constraints, and required inputs.
28- Apply relevant best practices and validate outcomes.
29- Provide actionable steps and verification.
30- If detailed examples are required, open `resources/implementation-playbook.md`.
31 
32## Overview
33 
34Financial 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.
35 
36## Core Components
37 
38### Revenue Model
39 
40**Cohort-Based Projections:**
41Build revenue from customer acquisition and retention by cohort.
42 
43**Formula:**
44```
45MRR = Σ (Cohort Size × Retention Rate × ARPU)
46ARR = MRR × 12
47```
48 
49**Key Inputs:**
50- Monthly new customer acquisitions
51- Customer retention rates by month
52- Average revenue per user (ARPU)
53- Pricing and packaging assumptions
54- Expansion revenue (upsells, cross-sells)
55 
56### Cost Structure
57 
58**Operating Expenses Categories:**
59 
601. **Cost of Goods Sold (COGS)**
61   - Hosting and infrastructure
62   - Payment processing fees
63   - Customer support (variable portion)
64   - Third-party services per customer
65 
662. **Sales & Marketing (S&M)**
67   - Customer acquisition cost (CAC)
68   - Marketing programs and advertising
69   - Sales team compensation
70   - Marketing tools and software
71 
723. **Research & Development (R&D)**
73   - Engineering team compensation
74   - Product management
75   - Design and UX
76   - Development tools and infrastructure
77 
784. **General & Administrative (G&A)**
79   - Executive team
80   - Finance, legal, HR
81   - Office and facilities
82   - Insurance and compliance
83 
84### Cash Flow Analysis
85 
86**Components:**
87- Beginning cash balance
88- Cash inflows (revenue, fundraising)
89- Cash outflows (operating expenses, CapEx)
90- Ending cash balance
91- Monthly burn rate
92- Runway (months of cash remaining)
93 
94**Formula:**
95```
96Runway = Current Cash Balance / Monthly Burn Rate
97Monthly Burn = Monthly Revenue - Monthly Expenses
98```
99 
100### Headcount Planning
101 
102**Role-Based Hiring Plan:**
103Track headcount by department and role.
104 
105**Key Metrics:**
106- Fully-loaded cost per employee
107- Revenue per employee
108- Headcount by department (% of total)
109 
110**Typical Ratios (Early-Stage SaaS):**
111- Engineering: 40-50%
112- Sales & Marketing: 25-35%
113- G&A: 10-15%
114- Customer Success: 5-10%
115 
116## Financial Model Structure
117 
118### Three-Scenario Framework
119 
120**Conservative Scenario (P10):**
121- Slower customer acquisition
122- Lower pricing or conversion
123- Higher churn rates
124- Extended sales cycles
125- Used for cash management
126 
127**Base Scenario (P50):**
128- Most likely outcomes
129- Realistic assumptions
130- Primary planning scenario
131- Used for board reporting
132 
133**Optimistic Scenario (P90):**
134- Faster growth
135- Better unit economics
136- Lower churn
137- Used for upside planning
138 
139### Time Horizon
140 
141**Detailed Projections: 3 Years**
142- Monthly detail for Year 1
143- Monthly detail for Year 2
144- Quarterly detail for Year 3
145 
146**High-Level Projections: Years 4-5**
147- Annual projections
148- Key metrics only
149- Support long-term planning
150 
151## Step-by-Step Process
152 
153### Step 1: Define Business Model
154 
155Clarify revenue model and pricing.
156 
157**SaaS Model:**
158- Subscription pricing tiers
159- Annual vs. monthly contracts
160- Free trial or freemium approach
161- Expansion revenue strategy
162 
163**Marketplace Model:**
164- GMV projections
165- Take rate (% of transactions)
166- Buyer and seller economics
167- Transaction frequency
168 
169**Transactional Model:**
170- Transaction volume
171- Revenue per transaction
172- Frequency and seasonality
173 
174### Step 2: Build Revenue Projections
175 
176Use cohort-based methodology for accuracy.
177 
178**Monthly Customer Acquisition:**
179Define new customers acquired each month.
180 
181**Retention Curve:**
182Model customer retention over time.
183 
184**Typical SaaS Retention:**
185- Month 1: 100%
186- Month 3: 90%
187- Month 6: 85%
188- Month 12: 75%
189- Month 24: 70%
190 
191**Revenue Calculation:**
192For each cohort, calculate retained customers × ARPU for each month.
193 
194### Step 3: Model Cost Structure
195 
196Break down costs by category and behavior.
197 
198**Fixed vs. Variable:**
199- Fixed: Salaries, software, rent
200- Variable: Hosting, payment processing, support
201 
202**Scaling Assumptions:**
203- COGS as % of revenue
204- S&M as % of revenue (CAC payback)
205- R&D growth rate
206- G&A as % of total expenses
207 
208### Step 4: Create Hiring Plan
209 
210Model headcount growth by role and department.
211 
212**Inputs:**
213- Starting headcount
214- Hiring velocity by role
215- Fully-loaded compensation by role
216- Benefits and taxes (typically 1.3-1.4x salary)
217 
218**Example:**
219```
220Engineer: $150K salary × 1.35 = $202K fully-loaded
221Sales Rep: $100K OTE × 1.30 = $130K fully-loaded
222```
223 
224### Step 5: Project Cash Flow
225 
226Calculate monthly cash position and runway.
227 
228**Monthly Cash Flow:**
229```
230Beginning Cash
231+ Revenue Collected (consider payment terms)
232- Operating Expenses Paid
233- CapEx
234= Ending Cash
235```
236 
237**Runway Calculation:**
238```
239If Ending Cash < 0:
240  Funding Need = Negative Cash Balance
241  Runway = 0
242Else:
243  Runway = Ending Cash / Average Monthly Burn
244```
245 
246### Step 6: Calculate Key Metrics
247 
248Track metrics that matter for stage.
249 
250**Revenue Metrics:**
251- MRR / ARR
252- Growth rate (MoM, YoY)
253- Revenue by segment or cohort
254 
255**Unit Economics:**
256- CAC (Customer Acquisition Cost)
257- LTV (Lifetime Value)
258- CAC Payback Period
259- LTV / CAC Ratio
260 
261**Efficiency Metrics:**
262- Burn multiple (Net Burn / Net New ARR)
263- Magic number (Net New ARR / S&M Spend)
264- Rule of 40 (Growth % + Profit Margin %)
265 
266**Cash Metrics:**
267- Monthly burn rate
268- Runway (months)
269- Cash efficiency
270 
271### Step 7: Scenario Analysis
272 
273Create three scenarios with different assumptions.
274 
275**Variable Assumptions:**
276- Customer acquisition rate (±30%)
277- Churn rate (±20%)
278- Average contract value (±15%)
279- CAC (±25%)
280 
281**Fixed Assumptions:**
282- Pricing structure
283- Core operating expenses
284- Hiring plan (adjust timing, not roles)
285 
286## Business Model Templates
287 
288### SaaS Financial Model
289 
290**Revenue Drivers:**
291- New MRR (customers × ARPU)
292- Expansion MRR (upsells)
293- Contraction MRR (downgrades)
294- Churned MRR (lost customers)
295 
296**Key Ratios:**
297- Gross margin: 75-85%
298- S&M as % revenue: 40-60% (early stage)
299- CAC payback: < 12 months
300- Net retention: 100-120%
301 
302**Example Projection:**
303```
304Year 1: $500K ARR, 50 customers, $100K MRR by Dec
305Year 2: $2.5M ARR, 200 customers, $208K MRR by Dec
306Year 3: $8M ARR, 600 customers, $667K MRR by Dec
307```
308 
309### Marketplace Financial Model
310 
311**Revenue Drivers:**
312- GMV (Gross Merchandise Value)
313- Take rate (% of GMV)
314- Net revenue = GMV × Take rate
315 
316**Key Ratios:**
317- Take rate: 10-30% depending on category
318- CAC for buyers vs. sellers
319- Contribution margin: 60-70%
320 
321**Example Projection:**
322```
323Year 1: $5M GMV, 15% take rate = $750K revenue
324Year 2: $20M GMV, 15% take rate = $3M revenue
325Year 3: $60M GMV, 15% take rate = $9M revenue
326```
327 
328### E-Commerce Financial Model
329 
330**Revenue Drivers:**
331- Traffic (visitors)
332- Conversion rate
333- Average order value (AOV)
334- Purchase frequency
335 
336**Key Ratios:**
337- Gross margin: 40-60%
338- Contribution margin: 20-35%
339- CAC payback: 3-6 months
340 
341### Services / Agency Financial Model
342 
343**Revenue Drivers:**
344- Billable hours or projects
345- Hourly rate or project fee
346- Utilization rate
347- Team capacity
348 
349**Key Ratios:**
350- Gross margin: 50-70%
351- Utilization: 70-85%
352- Revenue per employee
353 
354## Fundraising Integration
355 
356### Funding Scenario Modeling
357 
358**Pre-Money Valuation:**
359Based on metrics and comparables.
360 
361**Dilution:**
362```
363Post-Money = Pre-Money + Investment
364Dilution % = Investment / Post-Money
365```
366 
367**Use of Funds:**
368Allocate funding to extend runway and achieve milestones.
369 
370**Example:**
371```
372Raise: $5M at $20M pre-money
373Post-Money: $25M
374Dilution: 20%
375 
376Use of Funds:
377- Product Development: $2M (40%)
378- Sales & Marketing: $2M (40%)
379- G&A and Operations: $0.5M (10%)
380- Working Capital: $0.5M (10%)
381```
382 
383### Milestone-Based Planning
384 
385**Identify Key Milestones:**
386- Product launch
387- First $1M ARR
388- Break-even on CAC
389- Series A fundraise
390 
391**Funding Amount:**
392Ensure runway to achieve next milestone + 6 months buffer.
393 
394## Common Pitfalls
395 
396**Pitfall 1: Overly Optimistic Revenue**
397- New startups rarely hit aggressive projections
398- Use conservative customer acquisition assumptions
399- Model realistic churn rates
400 
401**Pitfall 2: Underestimating Costs**
402- Add 20% buffer to expense estimates
403- Include fully-loaded compensation
404- Account for software and tools
405 
406**Pitfall 3: Ignoring Cash Flow Timing**
407- Revenue ≠ cash (payment terms)
408- Expenses paid before revenue collected
409- Model cash conversion carefully
410 
411**Pitfall 4: Static Headcount**
412- Hiring takes time (3-6 months to fill roles)
413- Ramp time for productivity (3-6 months)
414- Account for attrition (10-15% annually)
415 
416**Pitfall 5: Not Scenario Planning**
417- Single scenario is never accurate
418- Always model conservative case
419- Plan for what you'll do if base case fails
420 
421## Model Validation
422 
423**Sanity Checks:**
424- [ ] Revenue growth rate is achievable (3x in Year 2, 2x in Year 3)
425- [ ] Unit economics are realistic (LTV/CAC > 3, payback < 18 months)
426- [ ] Burn multiple is reasonable (< 2.0 in Year 2-3)
427- [ ] Headcount scales with revenue (revenue per employee growing)
428- [ ] Gross margin is appropriate for business model
429- [ ] S&M spending aligns with CAC and growth targets
430 
431**Benchmark Against Peers:**
432Compare key metrics to similar companies at similar stage.
433 
434**Investor Feedback:**
435Share model with advisors or investors for feedback on assumptions.
436 
437## Additional Resources
438 
439### Reference Files
440 
441For detailed model structures and advanced techniques:
442- **`references/model-templates.md`** - Complete financial model templates by business model
443- **`references/unit-economics.md`** - Deep dive on CAC, LTV, payback, and efficiency metrics
444- **`references/fundraising-scenarios.md`** - Modeling funding rounds and dilution
445 
446### Example Files
447 
448Working financial models with formulas:
449- **`examples/saas-financial-model.md`** - Complete 3-year SaaS model with cohort analysis
450- **`examples/marketplace-model.md`** - Marketplace GMV and take rate projections
451- **`examples/scenario-analysis.md`** - Three-scenario framework with sensitivities
452 
453## Quick Start
454 
455To create a startup financial model:
456 
4571. **Define business model** - Revenue drivers and pricing
4582. **Project revenue** - Cohort-based with retention
4593. **Model costs** - COGS, S&M, R&D, G&A by month
4604. **Plan headcount** - Hiring by role and department
4615. **Calculate cash flow** - Revenue - expenses = burn/runway
4626. **Compute metrics** - CAC, LTV, burn multiple, runway
4637. **Create scenarios** - Conservative, base, optimistic
4648. **Validate assumptions** - Sanity check and benchmark
4659. **Integrate fundraising** - Model funding rounds and milestones
466 
467For complete templates and formulas, reference the `references/` and `examples/` files.
468