Churn Rate Calculator

How to calculate and interpret customer churn

Customer churn measures the share of a starting customer base that leaves during a defined period. It is commonly used by subscription businesses, software companies, membership services, marketplaces, and any organization where repeat customer relationships matter. The calculator focuses on customer-count churn rather than revenue churn, so it treats every lost customer equally regardless of account size.

What the calculator estimates

The primary result is the churn rate for one measurement period. It also calculates the complementary retention rate, the number of customers retained, an expected customer lifetime based on a steady-state approximation, and a forward projection showing how repeated churn compounds when no new customers are added. The projection is not a forecast of actual business performance; it is a controlled scenario that isolates the effect of churn.

The lifetime estimate uses the reciprocal relationship: expected lifetime in periods = 1 ÷ churn rate expressed as a decimal. For example, a monthly churn rate of 5% produces an estimated lifetime of 20 months. This approximation is most useful when churn is relatively stable and customer departures are distributed consistently through time.

How to use each input

• Customers at start of period is required for a valid churn calculation. Use the count active at the exact beginning of the measurement window. Do not use the ending count, an average balance, or a total that includes customers acquired later in the same period. A higher starting count lowers the churn rate when losses are unchanged.
• Customers lost during period is the number of customers who cancelled, failed to renew, became inactive under your chosen definition, or otherwise exited. It must not exceed the starting count. A higher loss count directly raises churn and shortens estimated lifetime.
• Measurement period identifies whether the churn observation is weekly, monthly, quarterly, or annual. It does not change the churn percentage itself, but it changes how the lifetime estimate is labeled and converted into months and years. Compare churn rates only when they use compatible periods.
• Projection horizon controls the number of repeated periods shown in the chart and table. Longer horizons make compounding more visible. Choosing no projection removes the forward-looking visual without changing the current-period churn calculation.

Understanding every result

Churn rate is the percentage of starting customers lost. Lower is generally preferable, but an acceptable level depends on contract length, customer segment, acquisition economics, and business maturity. A zero rate means no customers were lost in the observed period. A 100% rate means the entire starting base was lost.

Retention rate is 100% minus churn. It shows the share of the starting base that remained. Customers retained is the corresponding count, calculated as starting customers minus customers lost. These two results cross-check the churn calculation: retained and lost customers should always sum to the starting base.

Customer lifetime expresses the reciprocal of churn. At zero churn, a finite lifetime cannot be calculated, so the tool reports that the estimate is not finite rather than displaying an infinite or invalid number. The estimate is a simplified average, not a contractual duration or cohort survival model.

Projected customers is the closing customer count at the selected horizon if the same churn rate repeats and no customers are added. The line chart shows the compounding path. The table lists opening customers, losses, closing customers, cumulative losses, and the percentage of the original base remaining for every period. Decimal customer values are kept internally because the projection represents an expected value; display values are rounded for readability.

What drives the projection

The model applies the retention factor repeatedly: projected customers after n periods = starting customers × (1 − churn rate)ⁿ. Because each period starts with a smaller base, the absolute number lost declines over time even though the percentage churn stays constant. This is why a constant churn rate creates a curved decline rather than a straight line.

Real businesses usually add new customers, recover paused accounts, and experience different churn by cohort, plan, geography, and tenure. For deeper analysis, compare this customer-count view with revenue churn, net revenue retention, and cohort retention. Useful background is available from Stripe’s overview of churn, Investopedia’s churn-rate definition, and ChartMogul’s SaaS metrics guide.

Common mistakes and practical tradeoffs

• Mixing customers acquired during the period into the starting denominator can understate churn.
• Using different inactivity definitions across periods makes trend comparisons unreliable.
• Comparing monthly churn directly with annual churn ignores compounding and period length.
• Using only aggregate churn can hide high-risk customer segments or improving newer cohorts.
• Treating the reciprocal lifetime estimate as a precise forecast ignores changing behavior and customer heterogeneity.

Use a consistent period, a stable definition of “lost,” and the same data extraction logic each time. The Excel export records current inputs, results, breakdown values, projection rows, and model notes so the calculation can be reviewed or incorporated into a broader operating model.