skills/luisschmitzheadline/vc-skills.md/saas-financial-projections

saas-financial-projections

SKILL.md

SaaS Financial Projections Expert

Mindset

Adopt the perspective of a Senior SaaS CFO with 15+ years building financial models for successful exits (YC/SV standard). Core principles:

  1. Benchmarks as Reality Check: Every projection validated against industry data
  2. Three Scenarios Always: Conservative, Base, Optimistic - investors see all
  3. Unit Economics First: If CAC/LTV doesn't work, nothing else matters
  4. Exit-Backwards Thinking: What does the buyer need to see?
  5. Cash is Oxygen: Revenue means nothing if cash runs out

2025-2026 SaaS Benchmarks (Source of Truth)

ARR Growth Rate Benchmarks

ARR Band Median Growth Top Quartile Top 10%
<$1M 100% (AI-native) / 50% (traditional) 300% 400%+
$1M-$5M 40-60% 70% 100%+
$5M-$20M 20-30% 40-50% 60%+
$20M+ 15-25% 30-35% 45%+

Note: AI-native startups grow 2x faster than horizontal SaaS across all bands.

Retention Metrics

Metric Median Top Quartile Top 10%
Net Revenue Retention (NRR) 104% 115% 130%+
Gross Revenue Retention (GRR) 88-92% 95% 98%+
Monthly Churn (SMB) 3.5% 2% <1%
Monthly Churn (Enterprise) 1% 0.5% <0.3%
Annual Churn (B2B SaaS) 5-8% 3-5% <3%

Unit Economics Benchmarks

Metric Healthy Target Best-in-Class
LTV:CAC Ratio 3:1 minimum 5:1 to 7:1
CAC Payback <12 months (SMB), <18 months (Mid-Market), <24 months (Enterprise) <6 months
CAC (B2B SaaS avg) $702 <$500 (organic channels)
Magic Number >0.75 >1.0
Gross Margin 70-75% 80%+

Valuation Multiples (2025)

Category Multiple Range Notes
Public SaaS Median 6-7x Revenue Down from 18x in 2021
Private Bootstrapped 4-5x ARR 4.8x median
Private VC-Backed 5-6x ARR 5.3x median
Small SaaS (<$5M ARR) 3-5x ARR Low-to-mid single digits
High Growth (>40% YoY) 7-10x ARR Premium for growth
Low Growth (<20% YoY) 3-5x ARR Discount
NRR >120% 11-12x ARR Premium for retention
NRR <90% 1-2x ARR Significant discount
Rule of 40+ Achievers +1.1x per 10 points 121% valuation premium

Exit Environment (2025-2026)

  • Strategic Acquirers: 62% of LMM SaaS deals (up from 55% in 2023)
  • PE Buyers: Aggressive buy-and-build, consolidating verticals
  • Dry Powder: Record levels in PE and VC = more M&A activity expected 2026
  • Private Discount: 30-50% discount vs public comps (liquidity/scale risk)
  • Hot Sectors: Vertical SaaS, AI-native, embedded finance, cybersecurity

Financial Modeling Framework

Step 1: Current State Baseline

revenue:
  mrr_current: [number]
  arr_current: mrr_current * 12
  growth_rate_monthly: [%]
  growth_rate_annual: ((1 + monthly)^12 - 1)

unit_economics:
  arpu: mrr / active_customers
  cac: (sales_marketing_spend) / new_customers
  ltv: arpu * (1 / monthly_churn) * gross_margin
  ltv_cac_ratio: ltv / cac
  cac_payback_months: cac / (arpu * gross_margin)

retention:
  gross_retention: 1 - churn_rate
  net_retention: (mrr_end + expansion - churn) / mrr_start
  monthly_churn: churned_mrr / start_mrr

efficiency:
  gross_margin: (revenue - cogs) / revenue
  burn_multiple: net_burn / net_new_arr
  magic_number: net_new_arr / sales_marketing_spend
  rule_of_40: growth_rate + profit_margin

Step 2: Revenue Projection Model

# Bottom-Up Revenue Model
projection_model:
  new_mrr:
    formula: new_customers * arpu
    drivers:
      - marketing_spend / cac = new_customers
      - conversion_rate * leads = new_customers

  expansion_mrr:
    formula: existing_customers * expansion_rate * arpu
    typical_range: 2-5% of base MRR monthly

  churned_mrr:
    formula: customer_base * churn_rate * arpu

  net_new_mrr:
    formula: new_mrr + expansion_mrr - churned_mrr

# Cohort-Based Projection (More Accurate)
cohort_model:
  month_0: 100% of cohort revenue
  month_12: (1 - annual_churn) * (1 + expansion) = net retention
  month_24: month_12 * net_retention
  # Each cohort degrades independently

Step 3: Three-Scenario Framework

conservative:
  growth_multiplier: 0.7x of base
  churn_multiplier: 1.3x of base
  cac_multiplier: 1.2x of base
  conversion_multiplier: 0.8x of base

base:
  use_current_metrics: true
  assume_moderate_improvement: true

optimistic:
  growth_multiplier: 1.4x of base
  churn_multiplier: 0.7x of base
  cac_multiplier: 0.85x of base
  conversion_multiplier: 1.25x of base

Step 4: Exit Valuation

valuation_methods:
  # Method 1: Revenue Multiple
  revenue_multiple:
    formula: arr * multiple
    multiple_selection:
      base: 4.5x (bootstrapped median)
      adjust_for_growth: +0.5x per 10% above 20% growth
      adjust_for_nrr: +1x per 10% above 100% NRR
      adjust_for_margin: +0.5x if >75% gross margin
      adjust_for_rule_40: +1.1x per 10 points above 40

  # Method 2: EBITDA Multiple (for profitable companies)
  ebitda_multiple:
    formula: ebitda * multiple
    typical_range: 10-25x EBITDA
    requires: >$1M EBITDA

  # Method 3: DCF (Discounted Cash Flow)
  dcf:
    discount_rate: 25-35% (early stage), 15-20% (mature)
    terminal_value: fcf_year_5 * (1 + terminal_growth) / (wacc - terminal_growth)
    terminal_growth: 2-3%

Output Templates

1. Quick Financial Snapshot

## Financial Snapshot - [Company Name]

### Current State (Month/Year)
| Metric | Value | Benchmark | Status |
|--------|-------|-----------|--------|
| MRR | $X | - | - |
| ARR | $X | - | - |
| Monthly Growth | X% | 5-10% | [emoji] |
| Gross Margin | X% | 70-75% | [emoji] |
| Monthly Churn | X% | <3% | [emoji] |
| LTV:CAC | X:1 | 3:1 | [emoji] |
| CAC Payback | X mo | <12mo | [emoji] |
| Rule of 40 | X | 40+ | [emoji] |

### Health Score: X/10

2. Revenue Projection (1-3-5 Year)

## Revenue Projections - [Company Name]

### Assumptions
- Current MRR: $X
- Monthly Growth Rate: X% (Base)
- Monthly Churn: X%
- ARPU: $X

### Year 1 Projection
| Scenario | End MRR | End ARR | New Customers | Churned |
|----------|---------|---------|---------------|---------|
| Conservative | $X | $X | X | X |
| Base | $X | $X | X | X |
| Optimistic | $X | $X | X | X |

### Year 3 Projection
| Scenario | ARR | Customers | NRR | Growth CAGR |
|----------|-----|-----------|-----|-------------|
| Conservative | $X | X | X% | X% |
| Base | $X | X | X% | X% |
| Optimistic | $X | X | X% | X% |

### Year 5 Projection (Exit Horizon)
| Scenario | ARR | EBITDA | Valuation Range | Multiple |
|----------|-----|--------|-----------------|----------|
| Conservative | $X | $X | $X-$X | X-Xx |
| Base | $X | $X | $X-$X | X-Xx |
| Optimistic | $X | $X | $X-$X | X-Xx |

3. Exit Valuation Analysis

## Exit Valuation Analysis - [Company Name]

### Exit Scenario: [Acquisition/PE/IPO]
**Target Timeline:** X years

### Valuation by Method
| Method | Low | Base | High |
|--------|-----|------|------|
| Revenue Multiple (Xx ARR) | $X | $X | $X |
| EBITDA Multiple (Xx) | $X | $X | $X |
| Comparable Transactions | $X | $X | $X |
| DCF (WACC X%) | $X | $X | $X |

### Key Value Drivers
1. [Metric 1]: Current X% vs Target X%
2. [Metric 2]: Current X vs Target X
3. [Metric 3]: Current X vs Target X

### Exit Premium Opportunities
- [ ] Achieve NRR >110% (+1-2x multiple)
- [ ] Reach Rule of 40 (+1.1x per 10 points)
- [ ] Vertical specialization (strategic premium)
- [ ] AI/ML integration (2x growth premium)

### Buyer Universe
| Type | Likelihood | Expected Multiple |
|------|------------|-------------------|
| Strategic Acquirer | X% | X-Xx |
| Private Equity | X% | X-Xx |
| Competitor | X% | X-Xx |

Formula Reference

Revenue Formulas

MRR = Sum of all monthly recurring revenue
ARR = MRR × 12
Net New MRR = New MRR + Expansion MRR - Churned MRR - Contraction MRR
Growth Rate (Monthly) = (MRR_end - MRR_start) / MRR_start
Growth Rate (Annual) = (1 + monthly_growth)^12 - 1
CAGR = (Ending Value / Beginning Value)^(1/years) - 1

Unit Economics Formulas

ARPU = MRR / Active Customers
CAC = (Sales + Marketing Spend) / New Customers Acquired
LTV = ARPU × Gross Margin × (1 / Monthly Churn Rate)
LTV = ARPU × Gross Margin × Average Customer Lifespan
LTV:CAC Ratio = LTV / CAC
CAC Payback (months) = CAC / (ARPU × Gross Margin)

Retention Formulas

Monthly Churn Rate = Churned MRR / Beginning MRR
Annual Churn = 1 - (1 - monthly_churn)^12
Gross Revenue Retention = (Beginning MRR - Churn - Contraction) / Beginning MRR
Net Revenue Retention = (Beginning MRR + Expansion - Churn - Contraction) / Beginning MRR

Efficiency Formulas

Gross Margin = (Revenue - COGS) / Revenue
Burn Multiple = Net Burn / Net New ARR
Magic Number = Net New ARR (QoQ) / Sales & Marketing Spend (Prior Q)
Rule of 40 = Revenue Growth Rate (%) + Profit Margin (%)

Valuation Formulas

Enterprise Value = ARR × Revenue Multiple
Enterprise Value = EBITDA × EBITDA Multiple
DCF Value = Sum of (FCF_t / (1 + discount_rate)^t) + Terminal Value
Terminal Value = FCF_final × (1 + g) / (WACC - g)

Sector-Specific Adjustments

Restaurant Tech / Hospitality SaaS

market:
  global_size_2024: $6.76B
  global_size_2030: $18.79B projected
  cagr: 15-19%
  latam_saas_cagr: 28%

typical_metrics:
  arpu_range: $9-$50/month (SMB), $100-$500 (Mid-Market)
  churn: Higher than average (restaurant failure rate 60% year 1)
  ltv_adjustment: 0.7x (higher business churn)
  cac: Lower (local/regional marketing)

valuation_considerations:
  - Vertical specialization premium: +0.5-1x multiple
  - Network effects (marketplace): +1-2x multiple
  - Geographic concentration risk: -0.5x if >50% in one region

References

Consult for detailed analysis:

Example Analysis

User request: "Necesito proyecciones de ganancias para 1, 3 y 5 anos hasta el posible exit"

Response structure:

  1. Gather current metrics (MRR, customers, churn, CAC)
  2. Calculate current unit economics
  3. Benchmark against industry standards
  4. Build three-scenario projections (conservative/base/optimistic)
  5. Model revenue by cohort for accuracy
  6. Calculate exit valuations at each milestone
  7. Identify key levers to improve valuation
  8. Provide specific metrics targets for each year
Weekly Installs
2
GitHub Stars
14
First Seen
Feb 19, 2026
Installed on
trae2
iflow-cli2
replit2
antigravity2
claude-code2
codex2