Skip to content

samuelcastro/startup-skills / fundraising

fundraising

Verified

Guide founders through the complete fundraising journey from pitch deck to close. Use when a founder says "help me raise", "build a pitch deck", "find investors", "financial projections", "how much to raise", "investor outreach", or asks about valuations, term sheets, or VC meetings. Covers pre-seed through Series A with stage-appropriate frameworks.

references/financial-projections.md

View on GitHub
# Financial Projections for Fundraising

## What Investors Actually Care About

### Key Insight from VC Research
A survey of 885 institutional VCs revealed surprising truths about financial analysis:
- **9%** use no financial metrics at all
- **20%** don't forecast cash flows
- **Only 20%** use DCF/NPV analysis
- VCs prefer **cash-on-cash multiples (63%)** and **IRR (42%)**

**Bottom Line:** VCs aren't looking for perfect spreadsheets. They want to see you understand your business drivers and can think clearly about growth.

---

## The 3-Year P&L Template

### Structure
```
Year 1: Monthly detail
Year 2: Quarterly detail  
Year 3: Annual summary
```

### Revenue Section

**SaaS Business:**
```
New MRR
- New customers × ARPU
- Self-serve vs. sales-assisted breakdown

Expansion MRR  
- Upgrades
- Seat expansion
- Usage growth

Churned MRR
- Logo churn × lost ARPU
- Downgrades

Net New MRR = New + Expansion - Churned
Ending MRR = Beginning MRR + Net New MRR
ARR = MRR × 12
```

**Marketplace/Transaction Business:**
```
GMV = Transactions × Average Order Value
Net Revenue = GMV × Take Rate
```

**Service Business:**
```
Revenue = Customers × Contract Value
- Utilization rate
- Average engagement length
```

### Cost of Goods Sold (COGS)

**SaaS COGS typically includes:**
- Hosting/infrastructure (AWS, GCP, etc.)
- Payment processing fees
- Customer support (portion)
- Third-party software costs
- Professional services delivery

**Target Gross Margin:** 70-80% for SaaS

### Operating Expenses

**Sales & Marketing (S&M):**
- Salaries (sales team, marketing team)
- Marketing spend (paid, content, events)
- Sales tools (CRM, outreach)
- Travel and events

**Research & Development (R&D):**
- Engineering salaries
- Product management
- Design
- Tools and infrastructure

**General & Administrative (G&A):**
- Executive team
- Finance/legal/HR
- Office and facilities
- Insurance, legal fees

### Key Outputs

```
Gross Profit = Revenue - COGS
Gross Margin = Gross Profit / Revenue

Operating Expenses = S&M + R&D + G&A
Operating Income = Gross Profit - Operating Expenses

Net Income = Operating Income - Interest - Taxes

Monthly Burn = Cash Out - Cash In
Runway = Cash Balance / Monthly Burn
```

---

## Building Credible Assumptions

### Revenue Assumptions

**Growth Rate Justification:**
Don't just put 100% growth—justify it:

1. **Bottoms-up from capacity:**
   - "We can acquire X customers/month with current team"
   - "Each sales rep closes Y deals/quarter"
   - "Our conversion rate is Z% at current traffic"

2. **Comparable company benchmarks:**
   - Similar companies at your stage grew at X%
   - Public company grew at Y% when our size

3. **Historical extrapolation:**
   - "We've grown X% MoM for past 6 months"
   - "Trend shows acceleration because..."

**Current SaaS Growth Benchmarks (2024-2025):**
| ARR Range | Median Growth | Top Quartile |
|-----------|---------------|--------------|
| <$1M | 100%+ | 250-300% |
| $1-5M | 50-70% | 100%+ |
| $5-20M | 30-40% | 60%+ |
| $20-50M | 25-30% | 40-50% |

### Customer Acquisition Assumptions

**CAC Calculation:**
```
CAC = (S&M Spend in Period) / (New Customers in Period)
```

**Justify with:**
- Current CAC from existing data
- Channel-specific CAC breakdown
- Expected CAC changes as you scale

**CAC Payback Benchmarks:**
| ACV Range | Target Payback |
|-----------|----------------|
| <$5K | <6 months |
| $5-25K | 6-12 months |
| $25-100K | 12-18 months |
| >$100K | 18-24 months |

### Retention Assumptions

**Key Metrics:**
- **Logo Churn:** % of customers lost
- **Gross Revenue Retention (GRR):** Revenue retained excluding expansion
- **Net Revenue Retention (NRR):** Revenue retained including expansion

**Current Benchmarks (2024-2025):**
| Segment | Target GRR | Target NRR |
|---------|------------|------------|
| SMB | 80-85% | 95-100% |
| Mid-market | 85-90% | 100-110% |
| Enterprise | 90-95% | 110-125% |

### Expense Assumptions

**Typical Expense Ratios by Stage:**

| Stage | S&M % | R&D % | G&A % |
|-------|-------|-------|-------|
| Pre-seed | 15-25% | 50-70% | 10-20% |
| Seed | 25-35% | 40-50% | 10-15% |
| Series A | 35-45% | 30-40% | 10-15% |
| Growth | 40-50% | 20-30% | 8-12% |

**Hiring Plan Assumptions:**
```
Engineering: $150-250K fully-loaded
Sales: $100-150K base + commission
Marketing: $100-175K fully-loaded
Operations: $80-150K fully-loaded
```

---

## Unit Economics Deep Dive

### The LTV:CAC Framework

**Calculating LTV:**
```
Simple: LTV = ARPU × Gross Margin × Customer Lifetime
Refined: LTV = (ARPU × Gross Margin) / Monthly Churn Rate
With Expansion: LTV = (ARPU × Gross Margin × NRR) / Churn Rate
```

**LTV:CAC Targets:**
- **Minimum viable:** 3:1
- **Healthy:** 4:1 to 5:1
- **Too high:** >8:1 (under-investing in growth)

### Cohort Analysis

Use the provided `SaaS_Cohort_Analysis.xlsx` template to track:

**Customer Cohorts:**
- Starting customers per cohort
- Retention by lifetime month
- Churn curves over time

**Revenue Cohorts:**
- Starting MRR per cohort
- Expansion revenue by month
- Net revenue retention trends

**Key Analyses:**
1. Do retention curves flatten? (Good sign)
2. Is there negative churn? (Expansion > churn)
3. Are newer cohorts better? (Product improving)

### Magic Number / Sales Efficiency

```
Magic Number = Net New ARR / S&M Spend (prior quarter)
```

**Interpretation:**
- <0.5: Inefficient, fix GTM before scaling
- 0.5-0.75: Good, keep optimizing
- 0.75-1.0: Strong, invest more
- >1.0: Excellent, scale aggressively

### Burn Multiple

```
Burn Multiple = Net Burn / Net New ARR
```

**Benchmarks:**
- <1x: Amazing (profitable growth)
- 1-1.5x: Great
- 1.5-2x: Good
- 2-3x: Acceptable early stage
- >3x: Concerning

---

## Rule of 40

The Rule of 40 is a balanced measure of growth and profitability:

```
Rule of 40 = Revenue Growth Rate + Profit Margin
```

**Interpretation:**
- Score of 40+ indicates healthy SaaS business
- Early stage: Emphasize growth (e.g., 60% growth + -20% margin = 40)
- Later stage: Balance required (e.g., 30% growth + 10% margin = 40)

---

## What to Show Investors

### For Pre-Seed
- High-level model showing path to meaningful revenue
- Key assumptions clearly stated
- Use of funds tied to milestones
- Don't over-engineer—show you understand the levers

### For Seed
- Monthly P&L for Year 1
- Quarterly for Years 2-3
- Unit economics framework (even if early data)
- CAC payback assumptions
- Path to next round milestones

### For Series A
- Detailed historical financials
- Cohort analysis showing retention
- Unit economics proof points
- Sales funnel metrics
- Department-level budget
- Multiple scenarios (base, upside, downside)

---

## Common Financial Mistakes

### Projection Mistakes
❌ Hockey stick with no justification
❌ Assuming 100% growth rate indefinitely
❌ Ignoring seasonality
❌ Expense ratios that never change
❌ Hiring plan disconnected from revenue

### Unit Economics Mistakes
❌ Calculating CAC with only ad spend
❌ Ignoring customer support in COGS
❌ Using contracts signed vs. revenue recognized
❌ Cherry-picking best cohorts

### Presentation Mistakes
❌ Not knowing your numbers cold
❌ Can't explain assumption changes
❌ Inconsistent numbers across slides
❌ Showing only best-case scenario

---

## Financial Model Template Structure

### Tab 1: Assumptions
- Growth rate drivers
- Pricing inputs
- Hiring plan
- Expense ratios
- Key unit economics inputs

### Tab 2: Revenue Build
- Customer acquisition funnel
- MRR build by segment
- Expansion and churn

### Tab 3: P&L
- Monthly Year 1
- Quarterly Years 2-3
- Annual summary

### Tab 4: Cash Flow
- Burn rate
- Runway calculation
- Fundraising needs

### Tab 5: Unit Economics
- CAC calculation
- LTV calculation
- Cohort analysis

### Tab 6: Scenarios
- Base case
- Upside (1.5x growth)
- Downside (0.5x growth)

---

## Talking Points for Investor Meetings

Be prepared to answer:

1. "Walk me through your assumptions"
   - Start with customer acquisition
   - Explain growth drivers
   - Show expense leverage over time

2. "What happens if growth is slower?"
   - Show you've modeled downside
   - Explain levers to cut burn
   - Know your cash-out date in each scenario

3. "How did you get to this valuation?"
   - Comparable companies
   - Revenue multiples at stage
   - Don't over-anchor on valuation

4. "What's your biggest financial risk?"
   - Be honest about uncertainties
   - Show mitigation strategies
   - Demonstrate you've stress-tested
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall