Cohort Matrix Calculator
Inputs
The matrix you paste (including the second segment) is written into the address-bar link; if you share or reopen it, the numbers go with the address.
Result
LTV per user: $38.8
LTV per user
$38.8
Observed $21.5 + projection $17.3.
This result is computed from sample data and sample values; it is not real.
45% of the LTV rests on unobserved periods
The projection carries the loss rate of the latest periods out to the horizon. The larger the share, the more of the figure is assumption.
No plateau in the observation window
Conditional retention did not clear the 95% threshold for two periods in a row. Loss did not slow within this window.
69% of the total loss happens in M1: look at the first moment of value first. The newest three cohorts' M1 retention is 6.3 points higher than the earlier ones on average. A hint, not a diagnosis.
A segment difference (channel, plan, country) does not show in a single matrix. Paste a second matrix into the "Compare with a segment" section in the inputs.
M1 retention
49.3%
Share remaining after the first period on the pooled curve.
Tail rate (q_tail)
92.4%
Geometric mean of the last 3 observed conditional rates.
| Cohort | M0 | M1 | M2 | M3 | M4 | M5 | M6 |
|---|---|---|---|---|---|---|---|
| Pooled curveall cohorts | 100.0 | 49.3 | 39.1 | 33.8 | 30.4 | 28.4 | 26.7 |
| C1n = 800 | 100.0 | 45.0 | 35.0 | 30.0 | 26.9 | 25.0 | 23.5 |
| C2n = 750 | 100.0 | 46.0 | 36.0 | 30.9 | 27.7 | 26.0 | not yet observed |
| C3n = 900 | 100.0 | 47.0 | 37.0 | 32.0 | 29.0 | not yet observed | not yet observed |
| C4n = 850 | 100.0 | 50.0 | 40.0 | 35.1 | not yet observed | not yet observed | not yet observed |
| C5n = 920 | 100.0 | 52.0 | 42.0 | not yet observed | not yet observed | not yet observed | not yet observed |
| C6n = 880 | 100.0 | 55.0 | not yet observed | not yet observed | not yet observed | not yet observed | not yet observed |
Retention curve
LTV: observed and projected
- Observed periods$21.5
- Resting on unobserved periods$17.3
Horizon: 24 periods.
| Cohort | Size | Last | Observed | LTV (24) |
|---|---|---|---|---|
| C1 | 800 | M6: 23.5% | $20 | $35.2 |
| C2 | 750 | M5: 26% | $18.7 | $35.9 |
| C3 | 900 | M4: 29% | $17.2 | $36.8 |
| C4 | 850 | M3: 35.1% | $15.8 | $40 |
| C5 | 920 | M2: 42% | $13.6 | $43.1 |
| C6 | 880 | M1: 55% | $10.9 | $50.2 |
Scenario: M1 retention +5 points
M1 retention (scenario)
54.3%
Current 49.3%.
Scenario LTV
$42.1
24 periods, same assumptions.
LTV difference
+$3.2
+8.3%
This is a sensitivity calculation, not a forecast; only running the experiment will show whether +5 points happens.
Results are estimates based on the values you enter, not investment or financial advice. The calculation runs in your browser and no separate request is made to send your numbers. The values you enter are written into the link in the address bar.