Skip to content

Subscription churn calculator

This calculator takes your active subscriber count, your monthly churn rate and your monthly price and shows what churn does over time. It returns how many of today's subscribers will still be paying in twelve months, how many months an average subscriber stays, what a subscriber pays you over that lifetime, and how much revenue the current base will produce over the next year with no new sign-ups. It assumes churn stays constant every month and that everyone pays the same price. It does not include new subscribers, pauses, skips or price changes, so it shows the base you have, not the business you might build.

%
$

Lifetime revenue per subscriber

–

Subscribers still active after 12 months
–
Average subscriber lifetime in months
–
Revenue from today's base over the next 12 months
–

Plain arithmetic on your inputs. Nothing is sent anywhere. Not a forecast.

What each output is calculated from

Subscribers after twelve months is today's count multiplied by the retained share, which is one minus monthly churn, raised to the power of twelve. At 6 percent monthly churn, 94 percent stay each month, and after a year about 48 percent remain, so 1,000 subscribers become roughly 476. Average lifetime is one divided by the monthly churn rate: at 6 percent that is about 16.7 months. Lifetime revenue is that lifetime multiplied by the monthly price, so 16.7 months at 40 dollars is about 667 dollars. The twelve-month revenue figure adds up what each month's surviving subscribers pay, which is less than twelve times the starting base because the base shrinks every month.

How to read the numbers

The retained figure shows how fast the base decays and therefore how many new subscribers you must add each month just to stand still. If half your base is gone in a year, acquisition is running on a treadmill. Lifetime revenue is the ceiling on what you can pay to acquire a subscriber, and you need to apply your margin to it before comparing with CAC. The twelve-month revenue figure is the most useful for planning: it is what the current base will pay if you do nothing, and every month of churn reduction moves it up. Change the churn input by a single point and watch how much it moves.

Churn is the repeat purchases lever with a number on it

For a subscription store, the repeat purchases lever is churn. A subscriber who stays one more month is exactly one more order, and the tool shows what that is worth across the base. Lowering churn by a point usually costs less than raising sign-ups by the same value, because the fixes are on the product and the flows: a better first box, a reminder before the renewal, an easy skip instead of a cancel, and a winback sequence for those who leave. Run the calculator at your current churn and again at your target, and the gap in lifetime revenue is the budget you can justify for retention work.

Questions

Take the subscribers who cancelled during the month and divide by the subscribers you had at the start of the month. Exclude new sign-ups from that month in both numbers. Average the last three to six months so one bad month does not drive the model.

Not if they come back. Count a pause as churn only once it has lasted past the point where most paused subscribers do not return, which you can see from your own data. Until then, treat paused subscribers as active but not paying.

Because some subscribers leave each month and stop paying. The tool sums what the remaining subscribers pay in each of the twelve months, so the total reflects the shrinking base rather than the starting one.

No. Lifetime revenue is what a subscriber pays. Lifetime value for acquisition decisions should be that figure multiplied by your gross margin, because that is what is left to pay for ads and overhead.

Related

Want these numbers read for you?

Send your store. The plan runs your real figures through the four levers.

Store, name, email and phone. A person replies from a real inbox. Privacy

Get your free growth plan