skills/founderjourney/claude-skills/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
15
GitHub Stars
3
First Seen
Feb 8, 2026
Installed on
opencode12
codex11
gemini-cli10
github-copilot9
amp9
kimi-cli9