Net Revenue Retention Calculator
The formula
What the net revenue retention tells you
The compounding base metric: of the ARR you started with, how much remains after expansion, downgrades and churn — over 100% and the existing customers alone grow the company.
Calculation: NRR = (start + expansion − contraction − churn) ÷ start. Enter your inputs and every substitution is shown below the result.
Reading the result
At 120% NRR the installed base doubles every four years without a single new logo; at 85% you spend most of the sales motion refilling a hole.
Rules of thumb: 100–110% solid SMB; 110–130% strong mid-market; 130%+ enterprise — public comps cluster near 115%
Limitations and best practice
Counting new upsells sold by the acquisition team inflates it; NRR is the CS/expansion number. Measure cohort-period NRR, not trailing-twelve blended.
This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Frequently asked questions
Why is NRR more important than growth rate?
Does NRR above 100% make churn irrelevant?
Source & methodology
SaaS metric standard (OpenView / Bessemer definitions).
Net Revenue Retention: what this tool answers
This page was written for one job: turning your own inputs into a defensible figure, with the working shown. Searchers land on a Net Revenue Retention page for three reasons — to plan, to compare options, and to check that somebody else’s arithmetic is honest. This tool serves all three, and everything after the calculator explains the model instead of hiding it.
A calculation like this one is worth roughly as much as a careful sentence: it forces several vague considerations into one comparable quantity. Once Net Revenue Retention is on the table, the argument can stop being about impressions.
The useful way to hold Net Revenue Retention is as a ratio with a story attached: NRR = (start + expansion − contraction − churn) ÷ start says how the parts combine, and the 114.0 % figure above is simply that sentence written in numbers. Everything that follows unpacks one clause of the sentence at a time.
Nothing below is stock text pasted around a number: the worked example computes net revenue retention = 114.0 % from this tool’s own defaults, and the sensitivity section ranks the inputs that move the result — Expansion revenue first, at ≈2.5 % of the headline for a ten-percent error either way in that input — which is the thread the rest of this guide pulls on.
Inside the Net Revenue Retention calculation: formula and every input
One formula, published in full: NRR = (start + expansion − contraction − churn) ÷ start. Anything you can read, you can reproduce in a spreadsheet, and that reproducibility is the whole point of printing it rather than hiding it behind a button.
Starting ARR ($) (example value 8,000,000) is a measured number in the unit named by the label; the formula does not convert for you. This input feeds the formula directly; a defensible figure here is worth more than false precision anywhere else.
Expansion revenue ($) (example value 2,275,000) is a plain measured quantity — the unit shown in the label is the unit the formula expects. This input feeds the formula directly; a defensible figure here is worth more than false precision anywhere else.
Downgrades ($) (example value 463,585) is a quantity rather than a category — precision here is cheap and worth having. The example value is there to demonstrate the mechanics, not to describe your situation — overwrite it.
Logo churn ($) (example value 688,566) is a quantity rather than a category — precision here is cheap and worth having. The example value is there to demonstrate the mechanics, not to describe your situation — overwrite it.
Net Revenue Retention with real numbers, step by step
The tool prints its own working; this is the same arithmetic on the example values, reproduced so you can follow it by hand. Starting figures: Starting ARR ($), Expansion revenue ($), Downgrades ($), Logo churn ($). The computed net revenue retention comes out at 114.0 %, which the interpretation band labels “Excellent — the base grows without new sales”.
- Cohort end = $8,000,000 + $2,275,000 − $463,585 − $688,566 = $9,122,849
- NRR = $9,122,849 ÷ $8,000,000 = 114.0%
Ending cohort ARR — $9,122,849. Compare it against the main result of 114.0 % before drawing conclusions.
Gross churn drag — 14.4 %. Compare it against the main result of 114.0 % before drawing conclusions.
Expansion offset — 28.4 %. This is the number experienced users quote when the headline alone would mislead.
Keep this worked example open while you enter your own figures: matching the shape of the substitution is the fastest way to spot a unit or convention mistake.
Scenario table: Net Revenue Retention at ±10 % and ±20 % of the key input
Read this table as the practical error bar on the headline figure. It answers the question people actually have after seeing a single number: how wrong could this be if the main input is off by ten or twenty percent?
| Expansion revenue setting | Net revenue retention |
|---|---|
| 80 % of the example value | 108.3 % |
| 90 % of the example value | 111.2 % |
| example inputs | 114.0 % |
| 110 % of the example value | 116.9 % |
| 120 % of the example value | 119.7 % |
That spread — 108.3 % at the low end, 119.7 % at the high — is what a careful read of Net Revenue Retention looks like: a band you can state out loud, with the reason for each edge. Reproduce it in the form above by editing Expansion revenue alone; the substitution steps will follow your figures exactly.
What actually moves your Net Revenue Retention
Nobody should have to guess which input matters. The engine was re-run once per field below — ten percent up, ten percent down, everything else frozen — and the results ranked by how far they moved the net revenue retention. For Net Revenue Retention the ranking is measured rather than guessed, and it belongs to these defaults: shift the starting point and the order can shift with it.
- Expansion revenue +10 % → Net Revenue Retention = 116.9 % · −10 % → 111.2 % (the net revenue retention shifts ≈2.5 %)
- Starting ARR: ten percent up gives 112.8 %, ten percent down gives 115.6 % — ≈1.4 % of the net revenue retention either way
- Logo churn +10 % → Net Revenue Retention = 113.2 % · −10 % → 114.9 % (the net revenue retention shifts ≈0.8 %)
- Nudge Downgrades by ±10 % and Net Revenue Retention lands between 113.5 % and 114.6 % (sensitivity ≈0.5 %)
Expansion revenue is the dominant lever here: ten percent either way moves the result by about 2.5 %, from 111.2 % to 116.9 %. Spend your verification effort there first, and treat Starting ARR as the second priority (≈1.4 % per ten percent). The remaining fields can sit at safe defaults without materially changing the answer — knowing which is which is what separates a careful calculation from an anxious one.
What a Net Revenue Retention of 114.0 % means in practice
Nobody acts on a bare figure — they act on a figure with a comparison attached. On the example inputs the band reads “Excellent — the base grows without new sales”; your own figures place you on a different rung of the same ladder. How much of that band is luck? On Expansion revenue alone ten percent either way covers 111.2 % to 116.9 %. The practical reading rules: ask what would have to change to move you one band. If the answer is “a small, plausible input difference”, the band itself is not the finding — the uncertainty is.
Related measures answer related questions, and the distinctions matter: Net Revenue Retention is the quantity, Net revenue retention is this tool’s reading of it, and the decision that follows belongs to neither of them separately.
The errors that quietly break a Net Revenue Retention figure
Counting new upsells sold by the acquisition team inflates it; NRR is the CS/expansion number. Measure cohort-period NRR, not trailing-twelve blended. This calculator gives an estimate based on standard formulas; it is not professional financial, medical, legal or engineering advice. Verify anything you plan to act on with a qualified professional and your own records.
Reusing a Net Revenue Retention from last season. In Business & Entrepreneurship the inputs are the thing that drifts; the formula does not.
One mistake is specific to this engine: assuming every input matters equally. The computation above shows Expansion revenue dominating — a careful figure there beats false precision everywhere else.
The subtlest error is answering the wrong question precisely. Confirm that net revenue retention is actually the quantity your decision needs — the arithmetic is flawless either way, which is what makes the mistake invisible.
Six things to confirm before acting on Net Revenue Retention
- Note the date and the inputs beside the number so the figure can be audited later.
- Record the date and the inputs alongside the number so future-you knows what was assumed.
- Check Expansion revenue before anything else: it is the measured dominant input, ≈2.5 % of Net Revenue Retention per ten percent.
- Verify each input against its original source document, not memory.
- State, in one sentence, which convention each rate, unit or period in the form is using.
- Confirm the answer against one independent method or published benchmark for Net Revenue Retention.
Step by step: getting a trustworthy Net Revenue Retention out of this tool
The tool does the arithmetic; the routine below is what makes the arithmetic trustworthy. Five steps, a minute total — and afterwards you will know not just what the number is, but which assumption produced it.
Step 1 — start from evidence. The inputs behind Net Revenue Retention are starting arr ($), expansion revenue ($), downgrades ($), logo churn ($). Write them down with their source next to each one; if you cannot name where a figure came from, that is the input most likely to be wrong. Numbers are cheap to produce and expensive to retract; the extra minute is the cheapest insurance available.
Step 2 — enter the conservative case first. Resist the flattering scenario. Type the inputs you would defend in front of a sceptical reader, read the Net revenue retention (114.0 % for the example values), and note the verdict band. Precision is a promise you make about your data; make sure your inputs can keep it.
Step 3 — play with the inputs on purpose. Ten percent up, ten percent down, one field at a time. Within a few minutes you will know this calculation better than most people who quote its results. Compare the calculation to the rough guess you arrived with, and ask why they differ.
Step 4 — stress before you commit. A decision that survives a ten-percent squeeze on its two biggest inputs needs no luck to be sound. One that does not survive is a decision about hope, not about arithmetic. Rounding early is the quietest way to introduce a permanent error.
Step 5 — schedule the next run. In Business & Entrepreneurship the inputs drift quietly. Put a reminder a quarter out, re-enter the same fields, and read the change rather than the level. The input you reach for first is usually the one you measured longest ago.
From calculation to decision: where Net Revenue Retention earns its keep
In Sales & Revenue the figure computed here is usually the first one somebody asks to see. Having it — with the formula behind it — changes your position in the conversation from participant to reference. Say the answer out loud before you save it; if it sounds wrong, the model did not change, your understanding did.
The companion outputs — Ending cohort ARR and Gross churn drag — exist for the second stage of that screen: the headline sizes the prize, while the companions describe the trade-off you are accepting to get it. A result worth acting on survives having its two shakiest inputs halved.
There is a personal-administration use people overlook: periodic self-checking. Net Revenue Retention quietly drifts as life changes — rates move, bodies change, costs compound — and re-running it a few times a year catches drift while correction is still cheap. The test of a good estimate is not that it feels right but that it changes what you do.
Quick answers: what searchers ask about Net Revenue Retention
What affects Net Revenue Retention the most?
The short answer: Expansion revenue. The longer answer is the sensitivity table on this page, where every numeric input was probed by ten percent and the net revenue retention recalculated — Expansion revenue moved it furthest, by roughly 2.5 % (111.2 % to 116.9 %).
Which matters more: starting arr or expansion revenue?
By the numbers, Expansion revenue: a ten-percent change in it moves the result ≈2.5 %, versus ≈1.4 % for Starting ARR. Spend your measuring effort in that order — precision on the weaker lever buys almost nothing.
What is a typical Net Revenue Retention?
On the worked example above Net Revenue Retention comes out at 114.0 %. Treat that as one point on a distribution rather than a norm: the bands, the companion outputs and the sensitivity ranking tell you how wide the plausible range really is.
How do I calculate Net Revenue Retention by hand?
Three steps: write the formula (NRR = (start + expansion − contraction − churn) ÷ start), insert your values, and simplify. The worked example section shows exactly that chain for the default inputs; replicating it once on paper teaches you more about Net Revenue Retention than any number of calculator runs.
What happens to Net Revenue Retention if expansion revenue changes by 10 %?
Try it in the form above and the printed substitution will follow you; the pre-computed answer for the defaults is 111.2 % to 116.9 % across the ten-percent probe, i.e. ≈2.5 % sensitivity on the net revenue retention.
Is the Net Revenue Retention result of 114.0 % good or bad?
Neither, on its own — the label “Excellent — the base grows without new sales” is the band this figure falls in for the example inputs, and your own inputs will place you elsewhere on the same ladder. Judge the number against your history and your alternatives, and remember that a ten-percent error in Expansion revenue alone moves it by ≈2.5 %.
How do I calculate Net Revenue Retention manually?
Write down the inputs, then follow the printed steps in order — NRR = (start + expansion − contraction − churn) ÷ start. A spreadsheet replicates it with two or three cells. The manual route is worth doing once to build intuition; after that the calculator saves time and eliminates transcription slips.
What affects Net Revenue Retention the most?
Sensitivity depends on where you start, but the inputs Starting ARR ($) and Expansion revenue ($) typically move Net Revenue Retention further than the rest because they enter the formula multiplicatively. If you can only measure two things well, measure those and hold the others at conservative defaults.
Why is NRR more important than growth rate?
Growth can be bought; NRR cannot be faked without selling more into existing customers. It is the cleanest read on whether the product actually becomes more valuable with time.
Does NRR above 100% make churn irrelevant?
No — churn and expansion can both be large and hide in the net. Read NRR together with gross retention to see the gross flows underneath.
Do I need an account to use this Net Revenue Retention calculator?
No, and no data leaves the tab. The engine runs in the page itself, which is why the worked example, the bands and the sensitivity ranking all respond instantly to your keystrokes.
What the labels on this page mean
- Ending cohort ARR
- $9,122,849 on the example inputs — a companion figure printed beside the headline of Net Revenue Retention so that no result is read in isolation.
- Gross churn drag
- 14.4 % for the Net Revenue Retention worked case; it sits next to the main result because it carries context the headline leaves out.
- Expansion offset
- 28.4 % on the example inputs — a companion figure printed beside the headline of Net Revenue Retention so that no result is read in isolation.
- Net revenue retention
- The primary output of this tool: 114.0 % for the default inputs, computed exactly from NRR = (start + expansion − contraction − churn) ÷ start.
- Worked example
- Every substitution in order, from the example inputs to 114.0 % — the audit trail for the headline figure.
- Verdict band
- The plain-language label — here “Excellent — the base grows without new sales” — mapping the computed figure onto experience-based ranges for Business & Entrepreneurship.
- Sensitivity (±10 %)
- How far the Net Revenue Retention moves when a single input is nudged ten percent either way; the ranked list on this page is computed live from this engine.
Where the Net Revenue Retention model comes from
The model is published arithmetic implemented exactly as written: NRR = (start + expansion − contraction − churn) ÷ start. Source of record: SaaS metric standard (OpenView / Bessemer definitions). Any other implementation of this model should return the same figure for the same inputs. If one does not, the difference is in its assumptions — which this page prints and that one probably does not.
Nothing here replaces a qualified professional, and nothing here is approximate either — the arithmetic is exact, and the honesty is in the inputs you supply. Nothing is smoothed, weighted or adjusted behind the scenes; where judgement enters, this page says so and names the input responsible.
Next steps after the calculation
Save the number together with its inputs and today’s date; a Net Revenue Retention figure without context is unusable the moment an input changes.
The audience here is people who need one trustworthy number before their next decision. Everything you need to defend the result — formula, substitution, sensitivity, source — is printed above, so the only remaining variable is the honesty of your inputs.