Churn Rate Calculator: Customer, MRR, NRR, Annual and LTV
Churn rate calculator for customer and MRR churn, net revenue retention, annual churn compounded correctly (not × 12), customer lifetime and LTV from ARPU.
Churn Rate Calculator (Customer + MRR)
Figures cover one
Customer churn (per month)
3.00%
Gross MRR churn (per month)
4.30%
Net MRR churn (per month)
3.10%
Net revenue retention (NRR)
96.9%
Gross revenue retention (GRR)
95.7%
NRR annualised
68.5%
Annual customer churn (compounded)
30.6%
Annual churn, × 12 shortcut (overstates)
36.0%
Monthly customer churn
3.00%
Avg customer lifetime (1 ÷ monthly churn)
33.3 months
Customer LTV (ARPU × margin × lifetime)
$2,667
LTV on revenue (no margin)
$3,333
Customer churn of 3.00% a month compounds to 30.6% a year, not the 36% you get from × 12. Net MRR churn of 3.10% per month means the existing base shrinks on its own, keeping 96.9% of its revenue (NRR). The average customer stays about 33.3 months (2.8 years); at $100 ARPU and 80% gross margin that is an LTV of $2,667.
Customer churn = customers lost ÷ customers at start. Gross MRR churn = (cancelled + contraction MRR) ÷ starting MRR. Net MRR churn = (cancelled + contraction − expansion) ÷ starting MRR; NRR = 100% − net churn, GRR = 100% − gross churn. Annual churn = 1 − (1 − period churn)^12; × 12 overstates it because customers who already left cannot leave again. Lifetime = 1 ÷ monthly customer churn and LTV = ARPU × gross margin × lifetime (ARPU is monthly, so lifetime is in months). Rough SMB SaaS yardsticks: under 5% monthly customer churn is workable, under 2% is good, NRR above 100% ("negative churn") means the base grows on its own.
Don't take our word for it — turn your wi-fi off.
This tool keeps working with no connection at all, because your file is processed here in the browser. A site that uploads your file cannot do that. Disconnect and try it — this box will notice.
Prefer to check properly? Open DevTools → Network, then run the tool. Your file appears in no request. Why none of our tools upload
You're on 7BusyBoss — 300+ free tools that run instantly in your browser. No signup, nothing uploaded.
Churn rate = customers lost during a period ÷ customers at the start of it. Lose 30 of 1,000 customers in a month and churn is 3.00%. This churn rate calculator does that sum, then the revenue version (MRR churn), net revenue retention, the monthly-to-annual conversion done correctly, and the customer lifetime and LTV that follow from the number.
Customer churn rate formula and revenue churn, side by side
There are two churn numbers and they can disagree. Customer churn counts logos. Revenue churn counts the MRR that left with them.
- Customer churn = customers lost ÷ customers at start of period.
- Gross MRR churn = (cancelled MRR + contraction MRR from downgrades) ÷ MRR at start.
- Net MRR churn = (cancelled + contraction − expansion MRR) ÷ MRR at start. Expansion is upsells and cross-sells to customers you already had.
- Net revenue retention (NRR) = 100% − net MRR churn. Gross revenue retention (GRR) = 100% − gross MRR churn.
Take the same 1,000-customer company. If the 30 who left were all on a $40 plan, revenue churn is $1,200 of $100,000, or 1.20%, while customer churn is 3.00%. If instead one $10,000 account leaves, customer churn is 0.10% and MRR churn is 10.00%. Read both, every month, or you will not know which kind of customer you are losing.
Monthly churn to annual churn: why × 12 is wrong
Annual churn = 1 − (1 − monthly churn)^12. Multiplying by 12 overstates it, because a customer who left in March cannot leave again in April. At 3% a month, × 12 says 36%. The compounded figure is 30.6%, and that is the share of January's customers who are gone by the following January.
| Monthly churn | Annual churn (compounded) | × 12 shortcut | Retained after 12 months | Average lifetime |
|---|---|---|---|---|
| 0.5% | 5.8% | 6% | 94.2% | 200 months (16.67 yr) |
| 1% | 11.4% | 12% | 88.6% | 100 months (8.33 yr) |
| 2% | 21.5% | 24% | 78.5% | 50 months (4.17 yr) |
| 3% | 30.6% | 36% | 69.4% | 33.3 months (2.78 yr) |
| 5% | 46.0% | 60% | 54.0% | 20 months (1.67 yr) |
| 7% | 58.1% | 84% | 41.9% | 14.3 months (1.19 yr) |
| 10% | 71.8% | 120% | 28.2% | 10 months (0.83 yr) |
The gap widens as churn rises. At 10% a month the shortcut gives 120%, which is more customers than you had.
Going the other way, from an annual figure to a monthly one, use monthly = 1 − (1 − annual)^(1/12). Dividing by 12 understates it.
| Annual churn | Monthly equivalent | ÷ 12 shortcut |
|---|---|---|
| 10% | 0.87% | 0.83% |
| 20% | 1.84% | 1.67% |
| 30% | 2.93% | 2.50% |
| 50% | 5.61% | 4.17% |
Quarterly data works the same way with an exponent of 4. Lose 70 of 1,000 customers in a quarter (7%) and annual churn is 25.2%, against 28% from × 4. The monthly equivalent is 2.39%.
Worked example: the calculator's default numbers
A SaaS company starts the month with 1,000 customers and $100,000 of MRR, so ARPU is $100 a month. During the month 30 customers cancel, taking $3,500 of MRR with them. Downgrades cost another $800. Upsells to existing customers add $1,200. Gross margin is 80%.
- Customer churn = 30 ÷ 1,000 = 3.00%
- Gross MRR churn = (3,500 + 800) ÷ 100,000 = 4.30%, so GRR is 95.7%
- Net MRR churn = (3,500 + 800 − 1,200) ÷ 100,000 = 3.10%, so NRR is 96.9%
- Annual customer churn = 1 − 0.97^12 = 30.6% (the × 12 shortcut says 36.0%)
- Average customer lifetime = 1 ÷ 0.03 = 33.3 months, about 2.8 years
- LTV = $100 × 80% × 33.3 = $2,667 of gross profit per customer ($3,333 on revenue with no margin applied)
Run it two years out and 48.1% of this month's customers are still there, so 51.9% have gone. Monthly NRR of 96.9% compounds to 68.5% over a year: an existing cohort worth $100,000 today is worth $68,531 of MRR twelve months on, unless new sales replace it.
Net revenue retention and negative churn
Change one input. Lift expansion from $1,200 to $6,000 and net MRR churn becomes −1.70%. NRR is 101.7% for the month and 122.4% annualised. That is negative churn: the existing base grows on its own, and every new customer is growth on top of growth. The calculator turns the net churn cell green when this happens.
NRR says nothing about how many customers you lose, only about the money. A company at 101.7% NRR can still be shedding 3% of its logos a month, which is why the customer figure sits beside it. The cohort retention calculator shows the same loss month by month for a single signup cohort.
Customer lifetime and LTV from churn
Average customer lifetime = 1 ÷ monthly customer churn. It is the mean of a geometric distribution, so it assumes churn stays constant, which it never does in practice. Older customers usually churn less than new ones. Still, it is the standard first estimate.
LTV = ARPU × gross margin × lifetime, with ARPU per month and lifetime in months. Leave the ARPU box blank and the calculator uses MRR ÷ customers. Type an ARPU to override it, for example for one plan. At 2% monthly churn, $50 ARPU and 75% gross margin, lifetime is 50 months and LTV is $1,875. Skip the margin and you get $2,500, which is revenue and overstates what a customer is worth. Against a CAC of $800, the $2,667 from the example above is an LTV/CAC of 3.33. The LTV calculator takes the same inputs further, and the CAC payback calculator turns the acquisition cost into months.
How to use this churn rate calculator
- Pick the period your figures cover: month, quarter or year. The labels change with it, and the annual and monthly conversions use the right exponent.
- Enter customers at the start and customers lost. Do not count customers who joined during the period.
- Enter MRR at the start, MRR lost to cancellations, contraction MRR from downgrades, and expansion MRR. Leave contraction or expansion at 0 if you do not track them.
- Optionally enter ARPU per month and your gross margin percentage. Blank ARPU means MRR ÷ customers.
- Read the twelve cells: the three churn rates, NRR, GRR, NRR annualised, annual customer churn compounded next to the × 12 shortcut, monthly churn, average lifetime and the two LTVs. The sentence under the grid says it in words, and the copy button takes the whole summary with it.
If you track the MRR movements each month, the MRR / ARR calculator nets new, expansion, contraction and churned MRR into one net-new figure.
Common mistakes and limits
- Dividing by end-of-period customers. Start with 1,000, lose 30, add 100, and 30 ÷ 1,070 gives 2.80% instead of 3.00%. Including the new signups in the denominator (30 ÷ 1,100 = 2.73%) is the same mistake. New customers have not had a chance to churn yet.
- Quoting a monthly rate × 12 as annual churn, or an annual rate ÷ 12 as monthly. A 25% annual rate is 2.37% a month, not 2.08%, and gives a lifetime of 42.2 months.
- Mixing periods. A customer count from the 1st and an MRR figure from the 15th produce rates that do not belong together.
- Treating 1 ÷ churn as a forecast. It is an average over a customer base whose churn is assumed constant. Cohorts with falling churn live longer than it says.
- Counting a downgrade as a cancellation. It belongs in contraction, where it lowers GRR and NRR without touching customer churn.
- The calculator is arithmetic on the numbers you type. It has no benchmark data for your market, and "under 5% a month" is a rough yardstick for SMB SaaS, not a rule.
How to use the Churn Rate Calculator (Customer + MRR)
Takes about a minute. No signup, no download, your data stays in your browser.
- 1Open the tool. Scroll up to the Churn Rate Calculator (Customer + MRR) above — it loads instantly in your browser, no install needed.
- 2Enter your values. The fields come pre-filled with realistic defaults so you can see how it works — replace them with your own numbers.
- 3Read the result. The output updates instantly. Copy or share it — nothing is uploaded to a server, everything stays on your device.
Frequently asked questions
Common questions about the Churn Rate Calculator (Customer + MRR).
How do you calculate churn rate?
Divide the customers lost during a period by the customers you had at the start of it. Lose 30 of 1,000 in a month and churn is 3.00%. Leave out the customers who signed up during the period, since they have not had a chance to leave yet. For revenue churn, divide the MRR lost to cancellations and downgrades by the MRR at the start.
How do I convert monthly churn to annual churn?
Annual churn = 1 − (1 − monthly churn)^12. At 3% a month that is 1 − 0.97^12 = 30.6%, not the 36% you get from multiplying by 12. The shortcut overstates churn because customers who have already left cannot leave again. Going the other way, 25% annual churn is 2.37% a month, not 2.08%.
What is the difference between customer churn and revenue churn?
Customer churn counts accounts that left. Revenue (MRR) churn counts the money that left with them. If 30 small $40 customers out of 1,000 leave, customer churn is 3.00% and MRR churn only 1.20% on $100,000 of MRR. If one $10,000 account leaves, customer churn is 0.10% and MRR churn is 10.00%. Track both.
What is net revenue retention and what does negative churn mean?
Net revenue retention (NRR) is 100% minus net MRR churn, where net churn subtracts expansion from existing customers before dividing by starting MRR. Net churn below zero, so NRR above 100%, is called negative churn: upsells to the customers you kept outweigh the revenue that left. In the example, $6,000 of expansion against $4,300 lost gives net churn of −1.70% and NRR of 101.7%.
How do you calculate customer lifetime from churn rate?
Average customer lifetime = 1 ÷ monthly churn rate, in months. At 3% monthly churn that is 33.3 months, about 2.8 years. At 2% it is 50 months. The figure assumes churn stays constant, so it is a first estimate, and it multiplies into LTV as ARPU × gross margin × lifetime: $100 × 80% × 33.3 = $2,667.
What is a good churn rate for SaaS?
For SMB SaaS, under 5% monthly customer churn is workable and under 2% is good. Enterprise products with annual contracts usually report annual churn, where single digits is strong. For revenue, NRR above 100% means the existing base grows without new sales. Compare against your own history before any benchmark, because the mix of plan sizes moves these numbers a lot.
Should new customers be in the churn denominator?
No. Use customers at the start of the period. Start with 1,000, lose 30 and add 100, and dividing by the 1,070 you ended with gives 2.80%, while dividing by 1,100 gives 2.73%. Both understate the true 3.00%. The customers who joined during the month have not been around long enough to churn.
Community rating
Discussion (0)
No comments yet. Start the discussion.
Keep exploring
Related tools across 7BusyBoss — all free, all instant.