SaaS ARR Waterfall & Retention Bridge Lab

Model Starting ARR, New Logo Additions, Expansion Upsells, Contraction, Churn, Ending ARR, Net Revenue Retention (NRR), and Gross Retention (GRR).

Recurring Revenue Inputs

$
Beginning annualized recurring revenue of the cohort period.
$
First-time bookings from newly acquired subscription customers.
$
Upsells, cross-sells, seat expansion, and usage upgrades from existing accounts.
$
Downgrades, license reductions, or price discounts on surviving retained clients.
$
Complete subscription non-renewals and customer cancellations.
Waterfall Identity:
Ending ARR = Starting + New + Expansion - Contraction - Churn
Net Revenue Retention (NRR):
NRR = (Starting + Expansion - Contraction - Churn) ÷ Starting
Ending ARR
$13,300,000
+33.0% YoY Growth
Net Revenue Retention
108.0%
Net Expansion
Gross Retention (GRR)
90.0%
Healthy Baseline
SaaS Quick Ratio
4.30x
Top Quartile

ARR Bridge Decomposition Waterfall

Waterfall Step Amount ($) % of Starting ARR Impact Type
Starting ARR $10,000,000 100.0% Baseline
(+) New Logo ARR +$2,500,000 +25.0% Acquisition
(+) Expansion ARR +$1,800,000 +18.0% Existing Growth
(-) Contraction ARR -$400,000 -4.0% Downgrades
(-) Churned ARR -$600,000 -6.0% Full Cancellation
(=) Net New ARR Added +$3,300,000 +33.0% Net Increase
(=) Ending ARR $13,300,000 133.0% Final State

Cohort Retention & Churn Health

  • Gross ARR Churn Drag: 10.0% ($1,000,000)
  • Net Expansion Spread (Expansion - Churn): +$800,000 (+8.0%)
  • Retained Cohort ARR: $10,800,000
  • Acquisition Share of Net Growth: 75.8%

Growth Efficiency Diagnostics

  • Gross ARR Adds (New + Expansion): $4,300,000
  • Gross ARR Destructions (Contraction + Churn): $1,000,000
  • Destruction Leakage Rate: 23.3%
  • Expansion to New Logo Ratio: 0.72x

Sensitivity Matrix: Net Revenue Retention (NRR %) vs. Churn & Expansion

Model how shifting account expansion rates against gross churn affects institutional Net Revenue Retention.

Expansion Rate (% Starting ARR) Gross Churn + Contraction Rate (% Starting ARR)
5.0% 7.5% 10.0% 12.5% 15.0%

Ending ARR Sensitivity: New Logo Acquisition vs. NRR

Ending recurring revenue across varying new logo sales velocity and existing cohort net retention.

New Logo Bookings ($) Net Revenue Retention (NRR %)
90% (Contraction) 100% (Flat Cohort) 110% (Solid Growth) 120% (Top Quartile) 130% (Best in Class)

Executive Guide: Deconstructing the SaaS ARR Waterfall

The Anatomy of an ARR Bridge

Annual Recurring Revenue (ARR) is the master metric for enterprise software companies. The ARR waterfall separates growth into its component drivers:

  • Starting ARR: The baseline contractual run-rate entering the period.
  • New Logo ARR: True greenfield bookings from brand-new clients. Requires substantial CAC (sales reps, outbound marketing, onboarding).
  • Expansion ARR: Organic compound growth from existing customers buying additional seats, higher product tiers, or expanding compute usage. Highest margin revenue in SaaS.
  • Contraction ARR: Surviving accounts reducing headcount licenses or renegotiating pricing.
  • Churned ARR: Accounts that cancel completely. A total loss of accumulated customer equity.

NRR vs. GRR: What Institutional Investors Evaluate

Venture capital and growth equity firms evaluate NRR and GRR concurrently to understand the sustainability of product-market fit:

  • Net Revenue Retention (NRR): Measures cohort growth. If NRR is 120%, the business grows 20% year-over-year even if sales adds zero new customers. Snowflake achieved 158% NRR at IPO.
  • Gross Revenue Retention (GRR): Measures pure retention without masking by upsells. GRR cannot exceed 100%. A company with 120% NRR but 70% GRR is suffering from extreme churn masked by heavy expansion in a few accounts, creating catastrophic concentration risk.

The Growth Treadmill Trap

When churn is high (e.g., GRR < 85%), sales teams must continually run faster just to stand still. Replacing a lost $1,000,000 ARR cohort requires hiring additional sales reps, burning capital, and inflating CAC Payback. In contrast, businesses with NRR > 115% compound effortlessly because the retained base naturally funds new engineering and product expansion.

Diagnosing SaaS Quick Ratio

By comparing gross ARR additions to gross ARR subtractions, the SaaS Quick Ratio reveals capital velocity: Quick Ratio = (New Logo + Expansion) ÷ (Contraction + Churn). Ratios above 4.0x prove exceptional growth efficiency. Ratios below 2.0x indicate that leaky bucket churn is draining capital reserves.

Frequently Asked Questions

The SaaS ARR Waterfall (or MRR Bridge) is the core financial schedule reconciling recurring revenue between two periods: Ending ARR = Starting ARR + New Logo ARR + Expansion ARR - Contraction ARR - Churn ARR. It isolates organic cohort behavior from new logo acquisition.

Net Revenue Retention (NRR) includes account expansion (upsells and cross-sells) alongside downgrades and churn: NRR = (Starting ARR + Expansion - Contraction - Churn) ÷ Starting ARR. Gross Revenue Retention (GRR) excludes expansion entirely, measuring only retained baseline dollars: GRR = (Starting ARR - Contraction - Churn) ÷ Starting ARR (capped at 100%).

In public cloud software and venture-backed enterprise SaaS, top-quartile NRR ranges from 120% to 140%+ (e.g., Snowflake, Datadog), while median NRR is approximately 105%–112%. For GRR, top-quartile enterprise performance is 90%–95%+, whereas sub-85% GRR indicates severe underlying churn.

Top-line ARR can grow even when a SaaS business is losing 30% of its customer base every year if sales outspends churn. However, as the customer base expands, maintaining this growth treadmill requires exponential sales hiring. An ARR waterfall highlights whether growth is powered by healthy customer retention or precarious top-of-funnel spending.

The SaaS Quick Ratio divides total ARR additions (New Logo + Expansion) by total ARR destruction (Contraction + Churn). A ratio above 4.0x indicates excellent capital efficiency and compounding growth, while below 2.0x signals that customer attrition is suffocating growth momentum.