Free tool for coaches, studios and membership programs
Membership churn and monthly recurring revenue calculator
Members next month = members × (1 − monthly churn) + new members; MRR = members × monthly fee. In the example, 120 members at $90 a month is $10,800 of MRR today. With 5% monthly churn and 8 new members a month, the projection reaches about 138 members and $12,454.70 MRR in month 12, $141,360.63 of revenue over the 12 months, with about 78 members lost on the way. The steady level, where cancellations equal new joins, is 8 ÷ 5% = 160 members, or $14,400 a month.
Last updated 2026-11-12.
- Monthly recurring revenue in month 12
- MRR today
- Members in month 12
- Revenue over 12 months
- Members lost over 12 months
- Steady level: members / MRR
| Month | MRR |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 |
Check the inputs: fee above 0, churn above 0% and up to 100%, members and new members not negative.
Take it with you
Example scenarios
Three sets of example inputs worked through the same formulas as the calculator above. They are illustrations, not averages or statistics.
| Scenario | Inputs | Members in month 12 | MRR in month 12 | 12-month revenue | Steady level (members) |
|---|---|---|---|---|---|
| Low | 40 members at $60 a month, 8% monthly churn, 3 new a month | 38 | $2,305.15 | $28,090.78 | 38 |
| Typical | 120 members at $90 a month, 5% monthly churn, 8 new a month | 138 | $12,454.70 | $141,360.63 | 160 |
| High | 300 members at $150 a month, 3% monthly churn, 15 new a month | 361 | $54,184.73 | $603,027.09 | 500 |
Method: Each month: members = members last month × (1 − monthly churn %) + new members; MRR = members × monthly fee; 12-month revenue = sum of the 12 monthly MRRs; steady level = new members ÷ churn % (where losses equal joins). Figures checked against the same formulas on 2026-11-12.
How the calculator works
Each month, the churn percentage of members cancel and the new members join. The calculator repeats that 12 times from today's count and multiplies each month's members by the fee to get monthly recurring revenue (MRR). The 12 monthly MRRs added up are the revenue for the year.
When churn takes away exactly as many members as join, the count stops changing. That steady level is new members ÷ churn: with more sign-ups or lower churn it rises, and the projection moves toward it every month.
Worked example
A studio has 120 members at $90 a month, so MRR today is $10,800. It loses 5% a month and signs up 8 new members.
After a year it has about 138 members and $12,454.70 of MRR; the 12 months bring $141,360.63, and about 78 members cancel along the way. It keeps growing toward 8 ÷ 0.05 = 160 members, or $14,400 a month, but never passes that level unless churn falls or sign-ups rise.
Choosing the inputs
Monthly churn is the members who cancelled in a month divided by the members at the start of that month; average the last 6 to 12 months. New members per month is the average of real sign-ups, not the target.
Counts are kept as averages, so the projection shows decimals behind the rounded figures. Churn and sign-ups change with seasons and prices, so treat the result as an estimate, not a forecast or financial advice.
What this tool does not do
It assumes one fee and the same churn and sign-ups every month. It does not handle price tiers, pauses, annual plans, refunds or payment fees, and it keeps nothing after you close the page.
Questions
How much would cutting churn change?
Change the churn field and compare: in the example, every member kept longer raises the steady level, because the level is new members ÷ churn.
Does month 1 include today's members?
Yes. Month 1 starts from today's members, removes the month's cancellations and adds the new members before the MRR is counted.
Does this page store my numbers?
No. The math runs in your browser; nothing is sent or saved.
Made by Bardach Technologies. We also make Checkwren, a separate workspace template for online coaches that runs in Notion and keeps clients, weekly check-ins, training blocks, renewals and 24 reply snippets in one place (USD 78.99, one-time purchase on Gumroad). It does not project churn or recurring revenue. This calculator is free and needs no sign-up; nothing is charged on this page. Get Checkwren on Gumroad (USD 78.99)