analyzing-saas-business-metrics

name	analyzing-saas-business-metrics
description	Deconstructs SaaS operating metrics including ARR, NRR, gross retention, magic number, rule of 40, and cohort economics. Use when analyzing SaaS businesses, benchmarking software metrics, or evaluating subscription model health.
tags	["analysis","growth-equity"]
metadata	{"author":"casemark","practice_areas":["Growth Equity","Expansion Capital","Late-Stage Investing"],"document_types":["Analysis Report"],"skill_modes":["Analysis"]}

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

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