Tools

NRR forecast calculator

An NRR forecast is a projection of net revenue retention for the next 12 months from the churn, contraction and expansion you expect from today's customers. Enter starting ARR and three percentages to get NRR, GRR and ending ARR, with what 2 points of churn either way would change. Example figures are filled in.

105.0%NRR, next 12 months
90.0%GRR, next 12 months
$10,500,000ARR from these customers in 12 months
$1,000,000ARR lost to churn and downgrades
If churn is 2 points better (5.0%), NRR is 107.0% and ending ARR $10,700,000. If it's 2 points worse (9.0%), NRR is 103.0% and ending ARR $10,300,000.

How it's calculated

GRR = 100% − gross churn % − contraction %
NRR = GRR + expansion %
Ending ARR = starting ARR × NRR

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

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>

Updated November 3, 2026

See which of your renewals are at risk.

A 30-minute call on a demo book, or on your own top 25 accounts.

Book a call