casemark/analyzing-saas-business-metrics

Analyzing Saas Business Metrics

Deconstructs SaaS operating metrics including ARR, NRR, gross retention, magic number, rule of 40, and cohort economics.

When To Use

• Evaluating a SaaS company for growth equity or late-stage investment
• Benchmarking a portfolio company's operating metrics against peer cohorts
• Assessing subscription model health during due diligence or quarterly reviews
• Analyzing expansion revenue dynamics and churn trends for board-level reporting
• Comparing "efficient growth" profiles across competing deal opportunities

Inputs To Gather

• Revenue data: Monthly or quarterly MRR/ARR schedules covering at least 12–24 months; breakdown by new, expansion, contraction, and churned revenue
• Customer data: Beginning-of-period and end-of-period customer counts by cohort (sign-up quarter or ACV tier); logo churn counts
• Expense data: Fully loaded S&M spend by quarter (including headcount costs); COGS broken out to show hosting, support, and CS costs separately
• Cohort schedules: Revenue by vintage cohort showing retention and expansion over time (ideally 8+ quarterly cohorts)
• Billing & contract details: Contract term mix (monthly vs. annual vs. multi-year), average ACV, and gross-to-net revenue adjustments
• Context: Industry vertical, target customer segment (SMB/mid-market/enterprise), and pricing model (seat-based, usage-based, platform fee)

Workflow

1. Validate the ARR bridge

   • Reconstruct ARR from Beginning ARR + New + Expansion − Contraction − Churn = Ending ARR
   • Confirm each component ties to underlying MRR schedules; flag any reconciliation gaps with [VERIFY]
   • Distinguish between committed ARR and run-rate ARR if usage-based revenue is material

2. Calculate core retention metrics

   • Gross Dollar Retention (GDR): (Beginning ARR − Contraction − Churn) / Beginning ARR. Healthy benchmark: >90% for enterprise, >80% for SMB [VERIFY against current market benchmarks]
   • Net Dollar Retention (NDR/NRR): (Beginning ARR + Expansion − Contraction − Churn) / Beginning ARR. Best-in-class: >120% enterprise, >110% mid-market
   • Logo retention: 1 − (churned logos / beginning logos). Separate from dollar retention to isolate unit economics from mix effects
   • Note whether retention is calculated on a trailing-12-month basis or quarterly annualized — results differ materially

3. Assess growth efficiency

   • Magic Number: Net New ARR (current quarter) / S&M Spend (prior quarter). Targets: >0.75 indicates efficient spend; >1.0 is strong; <0.5 signals concern
   • CAC Payback: Fully loaded S&M per new customer / (new ARR per customer × gross margin). Express in months; <18 months is generally attractive for enterprise SaaS
   • LTV/CAC: (ARR per customer × gross margin) / (1 − GDR) / CAC. Minimum threshold typically >3x
   • Separate new-logo acquisition efficiency from expansion-driven growth — blended metrics can mask deteriorating new-business economics

4. Evaluate profitability and the Rule of 40

   • Rule of 40 = YoY ARR growth rate (%) + FCF margin (%) or EBITDA margin (%). Score ≥40 is the benchmark; identify which component is driving the result
   • Break out gross margin (target >70% for pure SaaS, >60% if managed services are included [VERIFY]). Scrutinize hosting costs, capitalized development, and professional services pass-throughs
   • Examine operating leverage: is S&M as a % of revenue declining as revenue scales? Is G&A staying flat or growing?

5. Analyze cohort economics

   • Build a cohort waterfall: for each vintage, show cumulative revenue as a multiple of first-period revenue at 4, 8, 12, and 16+ quarters
   • Identify whether newer cohorts retain and expand at the same rate as older ones — declining cohort quality is a red flag
   • Calculate cohort payback: quarters until cumulative gross profit from a cohort exceeds the S&M cost to acquire it
   • Flag if expansion is concentrated in a small number of large accounts vs. broad-based

6. Benchmark and contextualize

   • Compare all key metrics against relevant public SaaS comps and private benchmarks (e.g., Bessemer Cloud Index, ICONIQ Growth reports, KeyBanc SaaS survey) [VERIFY data sources are current]
   • Adjust for company stage (e.g., $10M ARR vs. $100M ARR expectations differ), end-market, and contract structure
   • Highlight where the company is top-quartile, median, or below-median on each metric

Output

Produce a structured SaaS Metrics Analysis containing:

• Executive summary: 3–5 sentence assessment of subscription model health and growth quality
• ARR bridge table: Quarterly ARR waterfall with all components for the trailing 8+ quarters
• Retention dashboard: GDR, NDR, and logo retention trended over time with commentary on drivers
• Efficiency scorecard: Magic number, CAC payback, LTV/CAC, and Rule of 40 — each with a benchmark comparison
• Cohort matrix: Vintage cohort retention/expansion grid with visual highlighting of trends
• Key findings: Bulleted list of 5–10 specific observations (strengths, risks, and areas requiring further diligence)
• Open items: Any metrics that could not be calculated due to missing data, marked [VERIFY]

Quality Checks

• ARR bridge reconciles to within 1% of reported ending ARR; any variance is explained
• Retention metrics are calculated on a consistent basis (same period definition) throughout
• Magic number uses prior-quarter S&M spend (not same-quarter) to reflect the sales cycle lag
• Gross margin excludes capitalized software development costs unless explicitly noted
• Cohort analysis covers enough vintages (minimum 4) to identify trend vs. noise
• All benchmark comparisons cite the source and vintage of the benchmark data
• No metric is presented without context — raw numbers always accompanied by what "good" looks like for the company's stage and segment
• Assumptions about annualization, seasonality adjustments, or pro-forma treatments are stated explicitly