Churn Impact Calculator
Churn is the silent killer of subscription and recurring revenue businesses. Even a modest monthly churn rate can erode your customer base faster than you might expect — especially when acquisition slows down. This calculator generates a month-by-month 12-month projection showing exactly how your customer count evolves when churn and new acquisition are working against each other. Use it to understand the "leaky bucket" effect and to quantify the value of improving retention.
| Month | Start | New | Lost (Churn) | End |
|---|
What Is Customer Churn?
Customer churn (also called customer attrition) is the rate at which customers stop doing business with you. For subscription businesses, it's the percentage of subscribers who cancel each month. For transactional businesses, it's the percentage of customers who don't make a repeat purchase within a defined period.
Churn is often described as the "leaky bucket" problem: you pour new customers in at the top, but they leak out through the bottom. If the leak is fast enough, you can never fill the bucket — no matter how much you pour in. Understanding your churn rate and its compounding effect over time is essential for building a sustainable business.
Even a seemingly small monthly churn rate has a dramatic effect over time. A 5% monthly churn rate means you lose 46% of your customer base over 12 months — even before accounting for new acquisition. This calculator makes that effect visible.
How It Works
Enter three values:
- Starting Customers: Your current active customer count at the beginning of the projection period.
- Monthly Churn Rate (%): The percentage of customers who leave each month. This is applied to the customer count at the start of each month.
- New Customers per Month: The number of new customers you acquire each month. This is assumed to be constant throughout the 12-month period.
The calculator runs a month-by-month simulation: it applies churn to the starting count, adds new customers, and carries the result forward to the next month. The table shows the full 12-month trajectory.
Formula
This process repeats for each of the 12 months, with the end count of each month becoming the starting count of the next.
Example Calculation
A SaaS company starts with 400 customers, has a 6% monthly churn rate, and acquires 25 new customers per month.
Month 1: Start: 400 | Lost: 24 (6%) | New: 25 | End: 401
Month 3: Start: 402 | Lost: 24 | New: 25 | End: 403
Month 6: Start: 404 | Lost: 24 | New: 25 | End: 405
Month 12: End: ~407
Despite acquiring 300 new customers over the year (25 × 12), the company only grew from 400 to ~407 — a net gain of just 7 customers. The churn consumed almost all of the acquisition effort. This is the leaky bucket in action.
When to Use This Calculator
- When evaluating the impact of your current churn rate — see exactly where your customer base will be in 12 months if nothing changes
- When modelling the value of retention improvements — run the calculator twice: once with your current churn rate and once with a reduced rate to see the difference
- When setting acquisition targets — if you want to reach a specific customer count in 12 months, this calculator helps you understand how much acquisition you need to offset churn
- When presenting to investors or stakeholders — a visual projection table makes the churn problem (or improvement) concrete and easy to understand
- When evaluating a retention initiative — if you're considering investing in customer success, onboarding improvements, or loyalty programmes, this calculator helps you quantify the potential return
Common Mistakes
- Using annual churn instead of monthly churn. This calculator uses monthly churn. If you know your annual churn rate, convert it: Monthly Churn ≈ 1 − (1 − Annual Churn)^(1/12). For example, 40% annual churn ≈ 4.1% monthly churn.
- Assuming new customer acquisition is constant. In reality, acquisition often varies month to month. This calculator uses a constant acquisition rate for simplicity. For a more detailed model, you would need to vary acquisition by month.
- Ignoring the compounding effect of churn. Churn compounds — it applies to a shrinking base each month. This means the absolute number of customers lost decreases over time as the base shrinks, which can make a declining business look more stable than it is.
- Confusing gross churn with net churn. Gross churn is the percentage of customers who leave. Net churn accounts for expansion revenue from existing customers. This calculator models gross customer churn (headcount), not revenue churn.
How to Interpret Your Result
Look at the 12-month projection table and ask:
- Is the end count higher or lower than the start? If it's lower, your churn is outpacing your acquisition — you're shrinking. This is a critical warning sign.
- What is the "steady state"? The point where the customer count stabilises (new customers = churned customers) is your steady state. If your steady state is below your current count, you're in decline.
- How many customers did you lose in total? The "Total Customers Lost" figure shows the cumulative churn over 12 months. This is the number of customers you had to replace just to stay flat.
- What would happen if you reduced churn by 1–2%? Re-run the calculator with a lower churn rate to see the impact. Often, a small improvement in retention has a surprisingly large effect on the 12-month outcome.
Frequently Asked Questions
What is a good monthly churn rate?
For SaaS businesses, a monthly churn rate below 2% is considered good, and below 1% is excellent. Rates of 5–8% are common for early-stage businesses but are difficult to sustain long-term. For consumer subscription businesses, churn tends to be higher — 5–10% monthly is not unusual. The key benchmark is whether your acquisition rate exceeds your churn rate, and by how much.
How do I calculate my monthly churn rate?
Divide the number of customers who cancelled in a month by the number of customers at the start of that month. For example, if you started the month with 300 customers and 15 cancelled, your monthly churn rate is 15 ÷ 300 = 5%. Calculate this consistently over several months to get a reliable average.
What is the difference between customer churn and revenue churn?
Customer churn measures the percentage of customers who leave. Revenue churn measures the percentage of revenue lost. These can differ significantly if your customers have different plan sizes. A business might have 5% customer churn but only 3% revenue churn if the customers who leave are on smaller plans. Revenue churn is often more important for financial planning.
How can I reduce my churn rate?
Common strategies include: improving onboarding so customers reach value faster, proactive customer success outreach to at-risk accounts, building stronger product habits and integrations that make switching costly, offering annual plans (which reduce monthly churn by locking customers in), and gathering exit survey data to understand why customers leave and addressing root causes.
How does this relate to LTV?
Churn rate is a direct input into the LTV formula. A lower churn rate means a longer average customer lifespan, which means higher LTV. Use the LTV Calculator to see exactly how a reduction in churn translates into higher customer lifetime value.
Disclaimer: This calculator provides a simplified projection for informational purposes only. The model assumes constant churn and acquisition rates, which will not reflect real-world variability. Use this as a directional tool, not a precise forecast. Consult a qualified analyst for detailed business modelling.
Related Calculators
LTV Calculator
Calculate Customer Lifetime Value — directly impacted by your churn rate.
Calculate LTV →