Reading the 12-Month NRR Projection: Compounding vs Decay
A practical read of the NRR calculator's 12-month projection — how compounding above 100% and decay below it reshape your revenue base, and what a 3-point move is really worth.
Quick answer
The 12-month NRR projection compounds your current monthly NRR forward. Sustained NRR above 100% bends the curve upward (geometric growth on the existing base); sustained NRR below 100% decays it. A 3-point swing — say 103% vs 100% annualised — adds roughly 3% to the trailing 12-month base, which on €4M of ARR is €120k of recurring revenue you didn't have to acquire.
12-Month NRR Projection
A forward-rolling view of how today's Net Revenue Retention rate, applied month over month, reshapes the existing customer base 12 months out.
The 12-month NRR projection takes the Net Revenue Retention rate from your most recent cohort window and compounds it forward across the next 12 monthly periods, holding new-logo acquisition aside. The output is two curves side by side: the trajectory of the current base under sustained NRR, and a counterfactual at 100% (perfect retention, no expansion). The gap between them is the dollar value of retention behaviour over the year. Read above 100%, the curve compounds upward — each month's expansion sits on a slightly larger base. Read below 100%, the same compounding works in reverse and the base decays faster than the headline gap suggests.
Most operators read the chart wrong on the first pass. They see a 2% monthly NRR and translate it linearly: 2% × 12 = 24%. The compounding correction is small at the margin but meaningful at scale — and it goes both ways.
Why the curve compounds above 100%
When monthly NRR sits above 1.0, each month's expansion revenue lands on a base that already grew last month. The geometric series (1 + r)^12 pulls ahead of the linear approximation 1 + 12r by an amount that scales with r.
At 0.25% monthly net expansion (roughly 103% annual NRR), the compounded base after 12 months is 1.0304× — only 0.04 points above the linear read. At 1% monthly (≈112.7% annual), the compounded base is 1.1268× versus 1.12 linear: now the gap matters.
The 110% NRR rule of thumb
A SaaS business sustaining 110% NRR doubles its installed-base revenue every ~7.3 years without acquiring a single new logo. That's the operator argument for treating retention as a growth lever, not a cost centre.
Why decay is steeper than it looks
Below 100%, the same compounding logic works against you. A monthly NRR of 0.99 (≈88.6% annual) doesn't mean you keep 88% of revenue — it means each month's churn eats a slightly smaller base than the last, but the cumulative shrinkage is real.
At 97% annual NRR sustained for 12 months, a €4M ARR base ends the year at roughly €3.88M before any new bookings. The €120k you lost is invisible in any single month's P&L but defines the slope of the projection chart.
Reading a 3-point NRR move
Operators sizing a retention investment usually want to know what a realistic NRR improvement is worth. A 3-point move — from 100% to 103%, or from 97% to 100% — is roughly what a focused six-month program on onboarding, health-scoring, and expansion motions delivers.
On the projection chart, 3 points shows up as a visible fan after month 6 and a clearly separated endpoint at month 12. On a €4M ARR base that's €120k of recurring revenue per year, compounding into year two. That number is what you compare against the program's loaded cost.
Don't extrapolate one good month
The projection assumes the current NRR rate sustains. A single quarter with an unusually large expansion deal will inflate the curve. Use a trailing 3- or 6-month average NRR as the input, not the spot rate, or the chart will lie to you.
From projection to action
Once the chart tells you what a 3-point move is worth in euros, the next decision is whether the retention program can deliver it inside the same window. That's a sizing exercise: gap to 110%, addressable cohorts, expected lift per intervention.
We walk through the math in Sizing a Retention Program From the NRR Gap to 110% — start there once you have a stable projection read. Most teams find the projection chart's compounding effect doubles the apparent ROI of retention work versus a linear back-of-envelope.
Frequently asked questions
No. The projection holds new-logo acquisition aside so you can isolate the behaviour of the existing base. New bookings get added on top in a full revenue forecast, but mixing them into the NRR curve hides what retention is doing.
Use the monthly rate and let the chart compound it. Feeding in an annual NRR figure and re-compounding it produces a double-counted curve. If you only have annual NRR, convert to monthly via NRR_monthly = NRR_annual^(1/12).
Because it compounds. A 3% loss in month one shrinks the base, so month two's 3% loss is calculated against a smaller number — but the curve has already bent down. By month 12 the cumulative effect is closer to a 3.3% reduction than a flat 3%.
At least 3 monthly cohorts, ideally 6. Single-month NRR is too volatile — one churned anchor account or one large expansion can swing the rate by several points and make the projection extrapolate noise.
For most B2B SaaS businesses, a 3-5 point lift in 12 months is achievable with focused work on onboarding, health-scoring, and expansion plays. Anything beyond 5 points usually requires a pricing or packaging change in addition to behavioural work.
It can. If your business has clear quarterly renewal cycles or seasonal expansion patterns, smooth the input rate across a full cycle before projecting. The chart compounds whatever you feed it — including artefacts.
A cohort curve tracks one customer cohort over time. The NRR projection tracks the aggregate base, blending all active cohorts and applying a single compounded retention rate. Use cohort curves to diagnose where churn happens; use the NRR projection to size the financial impact.
Because revenue from retained customers stays in the base and is subject to next month's NRR rate. Month two's expansion lands on month one's already-expanded base, which lands on month zero's, and so on — the definition of a geometric series.
Project a band, not a line. Run the chart with your low, median, and high monthly NRR rates and treat the spread as your uncertainty. If the band is wider than your retention program's expected lift, you don't have enough signal to size the investment yet.
Partially — it gives you the base-revenue trajectory. You still need to layer on new-logo bookings, ramped expansion from new cohorts, and any pricing changes. The NRR projection is one input to the revenue forecast, not the forecast itself.
Test ideas before you ship them
Run unlimited A/B tests, attach hypotheses to outcomes, and build a searchable archive of what works — and what doesn't.