Why a bridge model is useful
MRR forecasts can get complicated fast. A bridge model keeps the levers explicit: how much MRR comes from new customers vs how much comes from retaining and expanding existing customers. It's a great first-pass planning tool for budgets, targets, and scenario analysis.
Core monthly bridge
MRR_next = MRR + new MRR + expansion - contraction - churn (computed monthly).
How to set inputs (practical defaults)
- Starting MRR: current month recurring run-rate (exclude one-time revenue).
- New MRR: use trailing 3-month average if growth is volatile.
- Expansion/churn rates: start with your trailing monthly revenue retention behavior (or approximate from NRR/GRR).
- Horizon: 6-12 months for execution, 12-24 months for strategy scenarios.
How to interpret results
- Ending MRR and ARR run-rate show where the business lands if assumptions hold.
- CMGR helps compare scenarios (growth rate compounded monthly).
- Implied monthly NRR/GRR reflects existing-customer health independent of new MRR.
Common mistakes
- Mixing monthly and annual rates (e.g., annual churn used as monthly churn).
- Double counting: including expansions inside 'new MRR' or vice versa.
- Forecasting long horizons without scenarios (small rate changes compound a lot).
- Using this instead of cohort curves when you have meaningful seasonality or changing retention by cohort.