Signal Lab

ARR / MRR Waterfall

Beginning → new, expansion, reactivation − contraction, churn → ending — with NRR

Industry — SaaS / Recurring Revenue / Pipeline What-ifs Profitability

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

Report as

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).