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:
- Benchmarks as Reality Check: Every projection validated against industry data
- Three Scenarios Always: Conservative, Base, Optimistic - investors see all
- Unit Economics First: If CAC/LTV doesn't work, nothing else matters
- Exit-Backwards Thinking: What does the buyer need to see?
- 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:
- benchmarks-2025.md: Complete 2025-2026 SaaS metrics benchmarks
- valuation-multiples.md: Exit multiples by category, growth rate, and sector
- exit-strategies.md: Exit planning, buyer types, and deal structures
- projection-templates.md: Excel/spreadsheet formulas and templates
- cohort-analysis.md: Cohort modeling for accurate revenue projection
Example Analysis
User request: "Necesito proyecciones de ganancias para 1, 3 y 5 anos hasta el posible exit"
Response structure:
- Gather current metrics (MRR, customers, churn, CAC)
- Calculate current unit economics
- Benchmark against industry standards
- Build three-scenario projections (conservative/base/optimistic)
- Model revenue by cohort for accuracy
- Calculate exit valuations at each milestone
- Identify key levers to improve valuation
- Provide specific metrics targets for each year
Weekly Installs
2
Repository
luisschmitzhead…kills.mdGitHub Stars
14
First Seen
Feb 19, 2026
Security Audits
Installed on
trae2
iflow-cli2
replit2
antigravity2
claude-code2
codex2