United States version
How it works
Keep new-customer revenue outside the opening-cohort retention measures and allow genuinely negative net revenue churn.
This is the United States planning view, with monetary inputs and outputs in USD. A currency label does not establish that a tax rate, construction price, coverage rule or legal limit has been verified locally. The inputs and limitations below describe the actual scope.
Input query strings and outputs
Use an input name in this page’s URL as ?name=value, and join additional inputs with &. Portable shared links may instead use the compact ?ac= state parameter.
Input query strings
6-
?openingCustomers=Paying customers at period startNumber · Required · Default: 1,000
-
?lostCustomers=Customers from that opening cohort lost in periodNumber · Required · Default: 30
-
?openingMrr=Recurring revenue from opening cohortMoney · Required · Default: 100,000
-
?churnedMrr=Recurring revenue lost from opening cohort cancellationsMoney · Required · Default: 3,000
-
?contractionMrr=Recurring revenue lost from opening cohort downgradesMoney · Required · Default: 1,000
-
?expansionMrr=Recurring revenue gained from opening cohort expansionMoney · Required · Default: 5,000
Outputs
4-
logoChurnOpening-cohort customer churn, percentNumber
-
grossRevenueRetentionGross revenue retention, percentNumber
-
netRevenueRetentionNet revenue retention, percentNumber · Primary output
-
netRevenueChurnNet revenue churn, percentNumber
Formula
NRR = (opening recurring revenue − churn − contraction + expansion) ÷ opening recurring revenue.
Calculations retain numeric precision internally. Displayed values are rounded for readability. Quantities that must be purchased as whole units are rounded up only where the formula explicitly requires it.
Read the inputs before calculating
- Paying customers at period start: Enter the quantity described by the label.
- Customers from that opening cohort lost in period: Enter the quantity described by the label.
- Recurring revenue from opening cohort: Enter the quantity described by the label.
- Recurring revenue lost from opening cohort cancellations: Enter the quantity described by the label.
- Recurring revenue lost from opening cohort downgrades: Enter the quantity described by the label.
- Recurring revenue gained from opening cohort expansion: Enter the quantity described by the label.
Reproducible worked example
The following is a fictional arithmetic example, not a local quote, a verified claimant or a market forecast. Its values are included so the formula can be checked. The form does not automatically confirm any verification checkbox.
| Input | Example value |
|---|---|
| Paying customers at period start | 1,000 |
| Customers from that opening cohort lost in period | 30 |
| Recurring revenue from opening cohort | 100,000 |
| Recurring revenue lost from opening cohort cancellations | 3,000 |
| Recurring revenue lost from opening cohort downgrades | 1,000 |
| Recurring revenue gained from opening cohort expansion | 5,000 |
| Output | Calculated result |
|---|---|
| Opening-cohort customer churn, percent | 3 |
| Gross revenue retention, percent | 96 |
| Net revenue retention, percent | 101 |
| Net revenue churn, percent | -1 |
Interpreting a changed assumption
Start with one complete scenario and change only one input when diagnosing a difference. Recheck units, the period of every rate, whether an amount is recurring or one-off, and whether a cost is already included elsewhere. A larger calculated benefit is not evidence that an assumption is more likely to occur.
Limitations
- Inputs are explicit management assumptions. This is not a valuation opinion, tax filing, employment-law assessment or investment recommendation.
- New logos acquired during the period do not belong in the opening denominator. Define reactivation, pauses, currencies and recurring-revenue recognition consistently.
Frequently asked questions
What does this Customer and Revenue Churn result represent?
Keep new-customer revenue outside the opening-cohort retention measures and allow genuinely negative net revenue churn. It applies the displayed formula to your inputs; it does not infer omitted facts.
Are the starting amounts verified United States prices or legal rules?
No. Numeric defaults are illustrative unless an input or dated reference explicitly identifies a researched component. Currency is USD; local quotes, eligibility and unsupported rules must be entered and verified separately.
What must I check before relying on the result?
Inputs are explicit management assumptions. This is not a valuation opinion, tax filing, employment-law assessment or investment recommendation.
Can I compare or share different assumptions?
Change one assumption at a time and use the browser-local project or share controls. A shared URL contains the encoded input values; do not include information you do not wish to disclose.
Sources and reference scope
- Stripe opening-cohort churn — retrieved 2026-09-25. Lost customers divided by the opening cohort.
- Stripe churn calculation guide — retrieved 2026-09-25. Customer versus revenue churn; new-customer revenue is excluded from our opening-cohort retention.
These references support only their stated scope. They are not evidence that every local rule or price needed by the master expansion has been loaded.