How it's calculated
Each percentage is the share of today's ARR you expect to lose or add from these customers over the next 12 months. Customers won during the year are left out, as in any NRR figure. The sensitivity line moves churn 2 points each way and leaves contraction and expansion as they are: NRR is a straight sum, so 2 points of churn is 2 points of NRR and 2% of starting ARR.
With the example figures ($10,000,000 of starting ARR, 7% churn, 3% contraction and 15% expansion): GRR is 100 − 7 − 3 = 90.0%, NRR is 90 + 15 = 105.0%, churn and downgrades take $1,000,000, expansion adds $1,500,000, and these customers pay $10,500,000 in 12 months. At 5% churn, NRR would be 107.0% and ending ARR $10,700,000; at 9%, 103.0% and $10,300,000.
Finding your inputs
- Starting ARR: the ARR your current customers pay today, matched to finance's figure.
- Churn and contraction: start from the last 12 months (lost ARR ÷ starting ARR, and downgraded ARR ÷ starting ARR), then adjust for what you know about the renewals ahead: the accounts already flagged as at risk, and any large renewal that looks unusually safe or unusually exposed.
- Expansion: last year's expansion ÷ starting ARR, adjusted for the upsell pipeline and any price increase at renewal.
Questions
How is this different from the GRR and NRR calculator?
The GRR and NRR calculator works from dollars you have already lost and won, for a period that's over. This one works from percentages you expect, for the year ahead, and shows how much the result depends on churn.
Why does NRR move exactly 2 points when churn moves 2 points?
Because NRR adds and subtracts shares of the same starting ARR. Every point of churn you prevent is a point of NRR and 1% of starting ARR kept, which makes it easy to put a dollar figure on a retention target: with $10,000,000 of starting ARR, every point is $100,000.
Can I use it for a quarter instead of a year?
Yes, if the three percentages are for the quarter. Don't divide annual percentages by 4 and read the result as a quarter: renewals cluster, so one quarter can carry most of a year's churn.
Embed this calculator
Free to use on your blog, wiki or community page. Paste this where you want it to appear:
<iframe src="https://renewalfix.com/embed/nrr-forecast-calculator/" title="NRR forecast calculator by Horizon" width="100%" height="620" style="border:0;max-width:760px" loading="lazy"></iframe>
<p><a href="https://renewalfix.com/tools/nrr-forecast-calculator/">NRR forecast calculator</a> by Horizon</p>
<script>addEventListener("message",function(e){if(e.origin!=="https://renewalfix.com"||!e.data||!e.data.horizonEmbedHeight)return;document.querySelectorAll("iframe").forEach(function(f){if(f.contentWindow===e.source)f.style.height=e.data.horizonEmbedHeight+"px"})})</script>More on this topic: revenue retention, definitions, guides and tools.
Updated November 3, 2026