Customer Cohort Analysis Calculator
Customer cohort retention value.
Calculate cohort retention metrics and 12-month cohort revenue from retention rates and MRR. Enter cohort size and month 1 retained for an instant result.
What this tool does
This tool calculates cohort retention at M1/M3/M6/M12 and estimates 12-month cohort revenue.
Enter Values
Formula Used
Spotted something off?
Calculations, display, or translation — let us know.
Disclaimer
Results are estimates for educational purposes only. They do not constitute financial advice. Consult a qualified professional before making financial decisions.
Cohort analysis tracks how a specific group of customers (usually signup month) behaves over time. Month 1 retention, month 3, month 6, month 12 show the retention curve. Strong products show mild decay (month 12 at 60-80% of month 1); weak products show steep decay (month 12 at 10-20%). Revenue cohorts add MRR to this to reveal cohort lifetime value.
1,000 customer cohort: 95% M1 (950), 80% M3 (800), 65% M6 (650), 50% M12 (500). 80 avg MRR per retained × 12 months × avg retention ≈ 672,000 cohort year-1 revenue. The decay pattern reveals product stickiness: if M6 is 65% but M12 is 50%, year 2 may land around 35% - project forward to see full cohort value.
Cohort analysis matters because aggregate metrics lie. A business reporting 'overall retention 70%' might have month-1 cohorts retaining 90% but stale cohorts retaining 40%. Breaking apart by cohort reveals whether product is improving (newer cohorts retaining better) or declining (newer cohorts retaining worse) - the leading indicator aggregate metrics completely miss.
A worked example
Try the defaults: cohort size of 1,000, month 1 retained of 95%, month 3 retained of 80%, month 6 retained of 65%. The tool returns 696,000.00. You can adjust any input and the result updates as you type — no submit button, no reload. That's the real power here: seeing how sensitive the output is to one or two assumptions.
What moves the number most
The result responds to Cohort Size, Month 1 Retained %, Month 3 Retained %, Month 6 Retained %, and Month 12 Retained %. Not every input has equal weight. Flip one at a time toward extreme values to feel which ones move the needle most for your situation.
The formula behind this
Retention at each milestone = cohort size × retention %. Avg retained = (M1 + M3 + M6 + M12) ÷ 4. 12-month revenue = avg retained × MRR × 12. Everything the calculator does is shown in the formula box below, so you can check the math against your own spreadsheet if you want.
Using this as a check-in
Re-run this every three months. A single reading tells you where you stand; four readings tell you whether things are improving. The trend matters more than any individual snapshot.
What this doesn't capture
The score is a composite of the inputs you provide. Life context — job security, family obligations, health, housing — doesn't appear in the math but shapes the real picture. Use the number as a prompt, not a verdict.
1,000 cohort × 95/80/65/50% × £80 £ = $696,000.00.
Inputs
This example uses typical values for illustration. Adjust the inputs above to match a specific situation and see how the result changes.
Sources & Methodology
Methodology
Retention at each milestone = cohort size × retention %. Avg retained = (M1 + M3 + M6 + M12) ÷ 4. 12-month revenue = avg retained × MRR × 12.
References
Frequently Asked Questions
What retention is healthy?
Why M1 vs M0?
Can I compare cohorts?
Does this project full LTV?
Related Calculators
Customer Lifetime Value Calculator
Calculate customer lifetime value from purchase metrics and retention. Enter purchase value and purchase frequency for an instant result.
Net Revenue Retention Calculator
Calculate net revenue retention from starting MRR, churn, contraction, and expansion. Enter churned mrr to see nrr from starting mrr and churned mrr.
More Financial Health Calculators
Financial Health
Accounting Software Cost Calculator
Calculate total accounting software cost over years including setup. Enter subscription and setup hours for an instant result.
Financial Health
Accounts Payable Turnover Calculator
Calculate accounts payable turnover and days payable outstanding from supplier purchases and average AP. Free educational tool.
Financial Health
Accounts Receivable Turnover Calculator
Calculate accounts receivable turnover and days sales outstanding from credit sales and average AR. Enter net credit sales and see the result instantly.
Financial Health
Adjusted EBITDA Calculator
Calculate adjusted EBITDA with add-backs for owner compensation, one-offs, and non-recurring items. Enter reported ebitda and see the result instantly.
Financial Health
Affiliate Commission Calculator
Calculate affiliate commission earnings from clicks, conversion rate, order value, and commission percentage. Free educational tool.
Financial Health
Affiliate Marketing Income Calculator
Calculate affiliate marketing income from clicks, conversion rate, and commission per sale or per-order commission rate.
Explore Other Financial Tools
Major Purchases
3D Printer ROI Calculator
Calculate ROI on a 3D printer from purchase price, filament cost, and equivalent retail savings per print. Enter printer cost to see payback months.
Income
Unpaid Overtime Lifetime Cost Calculator
Calculate the lifetime cost of regular unpaid overtime in real wage terms. Enter weekly extra hours and hourly rate to see lifetime value given away.
Mortgage
Seller Net Proceeds Calculator
Calculate net proceeds from selling your home after mortgage payoff, agent fees, legal costs, and other selling expenses.