# Net revenue retention calculator

> NRR and GRR from one cohort, plus what your revenue does over three years if nothing else changes. See the formula, change the inputs and save your results.

Source: https://saas-marketing.net/calculators/nrr/
Topic: SaaS Metrics and Analytics
Type: calculator
Published: 2026-09-17
Last updated: 2026-09-17
Publisher: SaaS Marketing (saas-marketing.net)
License: CC BY 4.0. Quote or republish with attribution and a link to https://saas-marketing.net/calculators/nrr/

## Short answer

Net revenue retention uses cohort mrr twelve months ago, expansion mrr from that cohort, contraction mrr from that cohort and the additional inputs below to estimate net revenue retention. Change the example inputs to your own figures. The result is a planning calculation, not an industry benchmark or a prediction.

## Key takeaways

- The main result is net revenue retention; the formula is shown below.
- The three-year projection assumes the entered retention movements describe a full year and the same annual rate repeats. It is a scenario, not a forecast.
- Keep the reporting period, currency and customer cohort consistent across inputs.
- Defaults are an illustrative scenario. A blank, invalid or undefined ratio displays as n/a.

---

Use this tool alongside the [saas metrics guide](/saas-metrics/). NRR and GRR from one cohort, plus what your revenue does over three years if nothing else changes.

<Calculator id="nrr" cluster="saas-metrics" />

## Which inputs do you need?

| Input | Example value | What to check |
| --- | --- | --- |
| Cohort MRR twelve months ago | 100,000 | Use the value from the same reporting period as the other inputs. |
| Expansion MRR from that cohort | 18,000 | Use the value from the same reporting period as the other inputs. |
| Contraction MRR from that cohort | 4,000 | Use the value from the same reporting period as the other inputs. |
| Churned MRR from that cohort | 9,000 | Use the value from the same reporting period as the other inputs. |

Before entering numbers, choose the unit of analysis. An account, a user and a paying subscription are different objects. Counting users in one field and accounts in another can produce a precise answer to the wrong question. Record the start and end dates beside your source export so another person can reproduce your work.

## What formulas does the calculator use?

### Net revenue retention

```text
nrr = starting > 0 ? ((starting + expansion - contraction - churned) / starting) * 100 : NaN
```

This output is expressed as a percentage.

### Gross revenue retention

```text
grr = starting > 0 ? ((starting - contraction - churned) / starting) * 100 : NaN
```

This output is expressed as a percentage.

### That cohort in three years, no new customers

```text
y3 = starting * Math.pow(nrr / 100, 3)
```

This output is expressed as currency in the same units as the inputs.

Percent fields use whole percentages: enter 5 for five percent. The formula divides by 100 where a decimal rate is needed. Values in the formulas correspond to the labelled inputs above; earlier outputs can be used by later formulas.

## Worked example

The defaults are a constructed scenario, not results from a named company or survey. With the example inputs above, the calculation produces:

| Output | Example result |
| --- | --- |
| Net revenue retention | 105% |
| Gross revenue retention | 87% |
| That cohort in three years, no new customers | 115,762.5 |

Change one assumption at a time and watch the main result. Then test a conservative case by reducing the expected benefit or increasing the associated cost. If a decision works only at the most optimistic settings, investigate the uncertain input before committing the budget.

## How should you interpret the result?

- The three-year projection assumes the entered retention movements describe a full year and the same annual rate repeats. It is a scenario, not a forecast.

A formula describes the assumptions entered into it. It cannot establish that a channel caused a sale, that historical retention will continue, or that a projected cost is achievable. Compare the output with your own previous cohorts before using a broad market comparison.

For a management review, save the result together with the source date, segment, owner and planned action. Recalculate when the underlying input changes. Keep a separate copy of the original scenario so the team can explain the difference between the plan and the observed outcome.

## Continue the analysis

Use the [metrics guide](/saas-metrics/) to align definitions, browse [all calculators](/calculators/) for adjacent calculations, and keep a [measurement worksheet](/resources/) beside the model. The [pricing hub](/saas-pricing/) and [growth hub](/saas-growth/) cover decisions that often change these inputs.
{/* expanded-practice-2026-09 */}
## Apply net revenue retention calculator in a working review

Record the source and unit of every input before using the result. Change one assumption at a time to understand which inputs matter most. Keep outputs that describe money, time and percentages distinct, and preserve undefined cases rather than converting them into plausible-looking zeroes.

For this topic, involve the metric owner and the source-system owner and work from metric dictionary, source records and cohort definition. The relevant unit is a consistent account, user, event or revenue cohort. State the question the review should resolve before choosing a chart, an asset or a tool. If participants disagree about the unit or scope, resolve that disagreement before combining their evidence.

### Evidence to prepare

Write the numerator, denominator, unit, period, source and exclusions before interpreting the number. Separate observed data from assumptions and forecasts. A metric can be calculated correctly while still answering the wrong business question.

| Review field | What to record |
| --- | --- |
| Topic | Net revenue retention calculator |
| Decision | The specific action this explanation should help you choose |
| Working evidence | metric dictionary, source records and cohort definition |
| Unit and scope | a consistent account, user, event or revenue cohort |
| Responsible people | metric owner and the source-system owner |
| Remaining uncertainty | The missing fact that could change the decision |

### Two situations that can change the interpretation

#### When NRR includes new customers

A strong acquisition month cannot repair a weak retention metric by being added to its numerator.

Use this check: Reconcile opening revenue with expansion, contraction and churn from the same accounts. Use consistent recurring-revenue definitions and currency treatment.

The [focused diagnostic guide](/guides/nrr-includes-new-logo-revenue/) provides the correction process and a working evidence sheet.

#### When CAC mixes new and existing customers

Dividing this month's acquisition spend by the entire installed base produces a number that does not describe customer acquisition cost.

Use this check: Check the cost scope, new-customer definition and acquisition cohort timing. Costs and conversions must cover comparable periods or cohorts.

The [focused diagnostic guide](/guides/cac-denominator-includes-existing-customers/) provides the correction process and a working evidence sheet.

### Record the decision and the limit

Twenty activated accounts divided by eighty eligible accounts is 25%. Dividing the same twenty accounts by two hundred individual signups produces 10%, but it mixes units. Both inputs can be real while the second ratio is unsuitable for an account-activation claim.

Keep the conclusion beside the evidence that supports it. Record what the team will do, who owns the next action and which event or date will trigger a review. If the underlying definition, audience or product behavior changes, revisit the conclusion rather than assuming the old result still applies. A clear limit is useful information; it tells the next reader where additional investigation is required.

Use the [complete topic collection](/topics/saas-metrics/) for related methods and the [category field guides](/industries/) when the product's buying situation or implementation requirements change how the method should be applied.

### A reproducible sensitivity exercise

The [net revenue retention calculator tool](/calculators/nrr/) provides a related numerical exercise. Its current default inputs are constructed examples, not industry observations. Under those defaults, the output labelled **Net revenue retention** is **105** in the tool's displayed units. The table changes one input at a time and leaves the others at their defaults.

| Input changed | Default input | Alternative input | Net revenue retention after change |
| --- | --- | --- | --- |
| Cohort MRR twelve months ago | 100,000 | 120,000 | 104.17 |
| Expansion MRR from that cohort | 18,000 | 21,600 | 108.6 |
| Contraction MRR from that cohort | 4,000 | 4,800 | 104.2 |
| Churned MRR from that cohort | 9,000 | 10,800 | 103.2 |

The alternative inputs are sensitivity cases, not recommended targets. A result marked not defined means the proposed combination does not satisfy the model or produces an undefined ratio. Keep that state visible. If the output changes sharply after a small input change, investigate the uncertain input before using the model to justify a larger commitment.

Compare the model's scope with the concept on this page. The calculator may represent one particular application rather than every use of the term. Record the reporting period, currency where relevant, and the source of the real values you enter.

## Frequently asked questions

### How does this net revenue retention calculator work?

It evaluates the formulas shown on this page in your browser. NRR and GRR from one cohort, plus what your revenue does over three years if nothing else changes. Inputs are not sent to a calculation server.

### Are the default values SaaS industry benchmarks?

No. They are example inputs chosen to demonstrate the calculation. Replace them with your billing, CRM or finance records before making a decision.

### Why does a result show n/a?

The calculation is undefined or an input is outside its allowed range. Check for an empty field, a zero denominator or an impossible percentage before interpreting the result.

### Can I save or share my calculation?

Use Print or save results to create a local PDF with your browser. Review the inputs before sharing and remove confidential customer or company information.
