FinanceIreland versionFormula-based · Runs in your browser

Customer and Revenue Churn Calculator — Ireland

Keep new-customer revenue outside the opening-cohort retention measures and allow genuinely negative net revenue churn. EUR planning view; stated limitations apply.

Preparing saved example…

Inputs

Enter the values you know. Optional fields may be left empty.

Local save controls below
Required
Required
Required
EUR
Required
EUR
Required
EUR
Required
EUR

Result

Updates as valid inputs change.

Calculated locally
Illustrative defaults are not local quotes or verified legal rules. Dated reference components and user-entered assumptions are explicitly distinguished. Professional review is pending.
Net revenue retention, percent
—
Opening-cohort customer churn, percent
—
Gross revenue retention, percent
—
Net revenue churn, percent
—

Saved locally, explained clearly

Drafts, calculations, scenarios, and workflow progress stay in this browser unless you export them.

Opening local database…

Calculation steps

Follow what happened from the selected formula to the displayed answer.

Show substituted values and intermediate working
Calculate current inputs to see the working.
  1. 1

    Formula selected

    The calculator uses the following formula or method.

    NRR = (opening recurring revenue − churn − contraction + expansion) ÷ opening recurring revenue.

    Inputs are converted to canonical units before evaluating this stated formula.

  2. 2

    Values entered

    Your values are placed into the calculation.

    Enter values to see what is used in this step.

  3. 3

    Result calculated

    The formula or method produces the following result values.

    Results will appear after a successful calculation.

  4. 4

    Answer formatted

    Displayed values are rounded and formatted using each output’s configured precision.

Scenario comparison

Save working scenarios, then select two or three to compare. Formula versions and inputs remain visible.

No scenarios saved for this calculator yet.

Recent calculations

Successful calculations are retained locally according to your privacy settings.

No local history for this calculator yet.

Data and privacy

How it works

Keep new-customer revenue outside the opening-cohort retention measures and allow genuinely negative net revenue churn.

This is the Ireland planning view, with monetary inputs and outputs in EUR. 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 start

    Number · Required · Default: 1,000

  • ?lostCustomers= Customers from that opening cohort lost in period

    Number · Required · Default: 30

  • ?openingMrr= Recurring revenue from opening cohort

    Money · Required · Default: 100,000

  • ?churnedMrr= Recurring revenue lost from opening cohort cancellations

    Money · Required · Default: 3,000

  • ?contractionMrr= Recurring revenue lost from opening cohort downgrades

    Money · Required · Default: 1,000

  • ?expansionMrr= Recurring revenue gained from opening cohort expansion

    Money · Required · Default: 5,000

Outputs

4
  • logoChurn Opening-cohort customer churn, percent

    Number

  • grossRevenueRetention Gross revenue retention, percent

    Number

  • netRevenueRetention Net revenue retention, percent

    Number · Primary output

  • netRevenueChurn Net revenue churn, percent

    Number

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.

InputExample value
Paying customers at period start1,000
Customers from that opening cohort lost in period30
Recurring revenue from opening cohort100,000
Recurring revenue lost from opening cohort cancellations3,000
Recurring revenue lost from opening cohort downgrades1,000
Recurring revenue gained from opening cohort expansion5,000
OutputCalculated result
Opening-cohort customer churn, percent3
Gross revenue retention, percent96
Net revenue retention, percent101
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.

No. Numeric defaults are illustrative unless an input or dated reference explicitly identifies a researched component. Currency is EUR; 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

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.

Sources
Limitations
  • Illustrative defaults are not local quotes or verified legal rules. Dated reference components and user-entered assumptions are explicitly distinguished. Professional review is pending.
  • Inputs are converted to canonical units before evaluating this stated formula.
  • Estimates use the rates, timing, and assumptions entered. Fees, taxes, lender rules, and future changes are included only where explicitly shown.
A LITTLE MORE LOCAL

Where are you calculating?

Choose your country for local calculator versions. You can change it anytime in the navigation bar.

Choose a country