samuelcastro/startup-skills / fundraising
fundraising
VerifiedGuide 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 8.5 KB |
| assets/SaaS_Cohort_Analysis.xlsx | binary | 282.0 KB |
| references/financial-projections.md | markdown | 8.3 KB |
| references/investor-research.md | markdown | 9.3 KB |
| references/outreach-templates.md | markdown | 11.8 KB |
| references/pitch-deck-structure.md | markdown | 7.6 KB |
| references/saas-metrics.md | markdown | 9.2 KB |
| references/vc-insights.md | markdown | 8.4 KB |
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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |