Churn Rate Calculator

What this calculator estimates

This calculator measures the percentage of a starting customer cohort that became inactive during one consistent period. It also calculates the complementary retention rate, the number of customers still active at the end of the period, and a simple expected customer lifetime based on the reciprocal of the churn rate. A cohort breakdown and repeated-churn projection make the arithmetic easier to audit.

Churn is a business operating metric rather than a complete measure of growth. A company can lose customers and still grow when new customer acquisition exceeds losses. For that reason, use the projection as a view of one starting cohort, not as a prediction of the company's total active customer base.

How to complete each input

Customers at start of period is required. Count customers who were active under one clearly defined rule at the first instant of the period. For a subscription business, that may be paying subscriptions; for a marketplace, it may be customers who completed a qualifying transaction. A larger starting count does not automatically improve the rate because churn is calculated proportionally. Avoid mixing accounts, users, seats, and households.

Second customer measure lets you choose how records are available. Select “Customers lost” when your system directly identifies cancellations, non-renewals, or deactivations. Select “Customers at end” when you have beginning and ending cohort counts. In either mode, the second count cannot exceed the starting cohort because this calculator isolates losses and does not treat newly acquired customers as retained members of the original cohort.

Measurement period labels the lifetime estimate and projection. Select week, month, quarter, or year to match the source data. Changing the label does not mathematically convert the churn rate. A monthly churn rate and an annual churn rate describe different observation windows, so do not compare them without converting assumptions carefully.

Projection periods is optional and controls how many repeated periods appear in the chart and table. Higher values extend the sensitivity horizon but do not add new information about future acquisitions. Projection display changes only visible rounding. Full precision is retained for calculations and Excel export.

The churn rate and lifetime formulas

Retention rate equals one hundred percent minus churn rate. Customers retained equals customers at start minus customers lost. When the churn rate is greater than zero, the simple lifetime estimate is one divided by the churn rate expressed as a decimal. For example, a five percent churn rate produces a simple lifetime estimate of twenty periods.

The reciprocal approach assumes a stable churn probability and is best treated as a practical approximation. Real customer survival patterns can change by tenure, plan, channel, contract term, season, and product cohort. Zero observed churn does not create a mathematically finite reciprocal lifetime, so the calculator reports that no finite limit can be estimated from the current period.

How to read every result

Customer churn rate is the primary output. Lower values mean a smaller share of the starting cohort was lost during the selected period. A zero value means no observed losses in that cohort; it does not prove that future churn will remain zero. A high value signals that customer losses consume a large share of the starting base, but the meaning depends on industry, billing frequency, customer segment, and product maturity.

Retention rate shows the share that remained active. Customers retained is the ending size of the original cohort, excluding new acquisitions. Expected customer lifetime converts churn into an intuitive number of measurement periods. Customers lost confirms the loss count derived from the selected input basis.

The donut chart uses the same retained and lost values as the breakdown table and Excel workbook. The line chart applies the retention factor repeatedly to the prior period. In the detail table, “Lost in period” is the expected reduction for that row, “Remaining cohort” is the post-churn balance, and “Cumulative lost” reconciles the starting cohort to the remaining cohort.

Common mistakes and better measurement practice

• Do not include newly acquired customers in the ending count of the starting cohort. Track them as a separate cohort.
• Use the same active-customer definition at the beginning and end of every period.
• Keep period length consistent. Weekly and monthly rates are not directly comparable.
• Separate voluntary churn from involuntary churn when payment failure, fraud controls, or administrative closures matter.
• Segment by plan, acquisition channel, customer size, region, or tenure when an overall average hides important behavior.

A single period can be noisy, particularly with a small cohort. Review a time series and investigate both the rate and the absolute number of customers lost. The Investopedia overview of churn rate explains the metric in a broader business context. Stripe's churn rate guide discusses subscription measurement considerations, while the U.S. Small Business Administration's marketing and sales guidance provides general context for customer relationships and sales management.