Net revenue retention calculator

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

Which inputs do you need?

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

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

This output is expressed as a percentage.

Gross revenue retention

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

This output is expressed as a percentage.

That cohort in three years, no new customers

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:

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 to align definitions, browse all calculators for adjacent calculations, and keep a measurement worksheet beside the model. The pricing hub and growth hub cover decisions that often change these inputs.

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.

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 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 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 for related methods and the category field guides 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 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.

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.