Cohort Retention Revenue
Calculator
Results
- Payback month
- 5 mo
- Cumulative contribution
- $254,180.38
- Lifetime value per customer
- $374.18
- Acquisition spend
- $120,000.00
Projected path over the horizon
- Retained customers
- Cumulative contribution
Period-by-period projection
| 1 | 1,000.00 | 45,000.00 | 31,500.00 | -88,500.00 |
| 2 | 920.00 | 41,400.00 | 28,980.00 | -59,520.00 |
| 3 | 846.40 | 38,088.00 | 26,661.60 | -32,858.40 |
| 4 | 778.69 | 35,040.96 | 24,528.67 | -8,329.73 |
| 5 | 716.39 | 32,237.68 | 22,566.38 | 14,236.65 |
| 6 | 659.08 | 29,658.67 | 20,761.07 | 34,997.72 |
| 7 | 606.36 | 27,285.98 | 19,100.18 | 54,097.90 |
| 8 | 557.85 | 25,103.10 | 17,572.17 | 71,670.07 |
| 9 | 513.22 | 23,094.85 | 16,166.39 | 87,836.46 |
| 10 | 472.16 | 21,247.26 | 14,873.08 | 102,709.55 |
| 11 | 434.39 | 19,547.48 | 13,683.24 | 116,392.78 |
| 12 | 399.64 | 17,983.68 | 12,588.58 | 128,981.36 |
| 13 | 367.67 | 16,544.99 | 11,581.49 | 140,562.85 |
| 14 | 338.25 | 15,221.39 | 10,654.97 | 151,217.82 |
| 15 | 311.19 | 14,003.68 | 9,802.57 | 161,020.40 |
| 16 | 286.30 | 12,883.38 | 9,018.37 | 170,038.77 |
| 17 | 263.39 | 11,852.71 | 8,296.90 | 178,335.66 |
| 18 | 242.32 | 10,904.50 | 7,633.15 | 185,968.81 |
| 19 | 222.94 | 10,032.14 | 7,022.50 | 192,991.31 |
| 20 | 205.10 | 9,229.57 | 6,460.70 | 199,452.00 |
| 21 | 188.69 | 8,491.20 | 5,943.84 | 205,395.84 |
| 22 | 173.60 | 7,811.90 | 5,468.33 | 210,864.17 |
| 23 | 159.71 | 7,186.95 | 5,030.87 | 215,895.04 |
| 24 | 146.93 | 6,612.00 | 4,628.40 | 220,523.44 |
| 25 | 135.18 | 6,083.04 | 4,258.13 | 224,781.56 |
| 26 | 124.36 | 5,596.39 | 3,917.48 | 228,699.04 |
| 27 | 114.42 | 5,148.68 | 3,604.08 | 232,303.11 |
| 28 | 105.26 | 4,736.79 | 3,315.75 | 235,618.87 |
| 29 | 96.84 | 4,357.84 | 3,050.49 | 238,669.36 |
| 30 | 89.09 | 4,009.22 | 2,806.45 | 241,475.81 |
| 31 | 81.97 | 3,688.48 | 2,581.94 | 244,057.74 |
| 32 | 75.41 | 3,393.40 | 2,375.38 | 246,433.12 |
| 33 | 69.38 | 3,121.93 | 2,185.35 | 248,618.47 |
| 34 | 63.83 | 2,872.17 | 2,010.52 | 250,629.00 |
| 35 | 58.72 | 2,642.40 | 1,849.68 | 252,478.68 |
| 36 | 54.02 | 2,431.01 | 1,701.71 | 254,180.38 |
Comparison
| Scenario | Cumulative contribution | Lifetime value per customer |
|---|---|---|
| Doing nothing | -88,500.00 | 31.50 |
| Your scenario | 254,180.38 | 374.18 |
Formula
customers_t = N·r^(t−1); contribution_t = customers_t·ARPU·(1−s)= 5.00
Note
Simplified model: this is the exact arithmetic of the stated recurrence applied to your inputs, with every rate held constant for the whole horizon. Real businesses see growth, churn, seasonality and costs move, and no projection accounts for competition, financing terms, tax or one-off events. Treat the crossing month as an order of magnitude, not a date, and check it against your own books before committing money.
More in Business projections
See all →Frequently asked questions
What is a "cohort" in this calculator, and why not just look at total revenue?+
A cohort is a group of customers who joined in the same period (e.g., all signups in March), tracked together over time. Total revenue mixes new and old customers together and can mask a retention problem, since new signups can hide the fact that older cohorts are shrinking fast; cohort analysis isolates how each group actually behaves after acquisition.
How do I read a declining revenue curve within a single cohort?+
A cohort's revenue naturally declines over time as some customers churn or downgrade, so a downward curve isn't inherently bad; what matters is the shape and where it stabilizes. A curve that flattens at 40-60% of the starting value after a few periods indicates a durable core of customers, while one that keeps declining toward zero signals a product with no lasting retention.
What does it mean if later cohorts retain revenue better than earlier ones?+
That's a strong positive signal, usually meaning product improvements, better onboarding, or improved customer targeting are working, since you're comparing groups exposed to different versions of the product or acquisition process. Track this trend explicitly, since it's one of the clearest indicators that retention-focused work is paying off.
Why does the calculator need a cohort's starting size or starting revenue, not just a retention percentage?+
Because retention percentage alone tells you the shape of decay but not the dollar amount at stake; a 90% retention rate on a $10,000 starting cohort is very different in absolute terms from 90% retention on a $1,000 one. The starting figure lets the calculator project actual future revenue, not just a relative curve.
Can I use this to project revenue from a cohort that hasn't fully matured yet?+
Yes, that's one of its main uses: once a cohort has a few periods of observed retention data, you can extrapolate its likely trajectory to estimate revenue from months you haven't reached yet. Be cautious extrapolating from fewer than 3 data points, since early-period retention curves are often steeper than the long-run pattern that follows.