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.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
ARR / MRR Waterfall
Reconciled SaaS revenue bridge — ending is formula-only (no plug). NRR and SaaS Quick Ratio included.
Sample figures: AU SaaS / recurring.
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)
Recurring revenue waterfall, beginning to ending ($)
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
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.