ARR / MRR Waterfall
A reconciled SaaS revenue bridge from beginning ARR/MRR to ending.
It measures new, expansion, reactivation, contraction, and churn — plus NRR.
Use it to see whether growth is new logo, expansion, or just churn recovery.
Signal Lab · Model
ARR / MRR Waterfall
Reconciled SaaS revenue bridge — ending is formula-only (no plug). NRR and SaaS Quick Ratio included.
Illustrative AU SaaS / recurring sample until you enter actuals. Not financial advice.
Beginning and movement
Toggle ARR vs MRR labels. Ending is computed — reconcile enforced. Persist locally only · Jump to waterfall
Ending, NRR, and Quick Ratio
Ending = Begin + New + Expansion + Reactivation − Contraction − Churn. No plug line.
Equations
- Ending = Beginning + New + Expansion + Reactivation − Contraction − Churn
- NRR = (Beginning + Expansion − Contraction − Churn) ÷ Beginning
- SaaS Quick Ratio = (New + Expansion) ÷ (Churn + Contraction)
Revenue waterfall
Growth (green) vs leakage (amber). Running total must match formula ending.
How this is calculated
- Ending = Beginning + New + Expansion + Reactivation − Contraction − Churn (formula-only; no plug)
- NRR = (Beginning + Expansion − Contraction − Churn) ÷ Beginning
- SaaS Quick Ratio = (New + Expansion) ÷ (Churn + Contraction)
- Net new = New + Expansion + Reactivation − Contraction − Churn
Further reading (footnote only, not scraped): HiBob · Fairview · ORM-Tech. Illustrative — not advice.
Sensitivity dials
+New · +Expansion · −Churn — live ending, NRR, and Quick Ratio.
What-if dials
Each dial stacks on your base inputs. Biggest growth vs leakage lever updates with the insight.
Adds to New bookings / logos.
Adds to Expansion (upsell / seat growth).
Reduces Churn (cannot go below zero).
Take it with you
Download a prompt, export the Excel workbook, or email yourself.
Email opens your mail client with the prompt in the body (mailto). No account required. Data stays in this browser (localStorage).