| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Month | Cohort Retention | Expected Revenue | Retained from previous month | Rate of Change | ||||
2 | 1 | 100.00% | $30.00 | ||||||
3 | 2 | 85.00% | $25.50 | 85.00% | Assumptions: | ||||
4 | 3 | 73.10% | $21.93 | 86.00% | 1.00% | Monthly Revenue | $30.00 | ||
5 | 4 | 63.63% | $19.09 | 87.05% | 1.05% | Margin | 50% | ||
6 | 5 | 56.09% | $16.83 | 88.15% | 1.10% | Month 2 % Retained | 85% | ||
7 | 6 | 50.09% | $15.03 | 89.30% | 1.15% | Retention Curve Rate of Change Baseline | 1.00% | ||
8 | 7 | 45.33% | $13.60 | 90.50% | 1.20% | Retention Curve Rate of Change Additions | 0.0005 | ||
9 | 8 | 41.59% | $12.48 | 91.75% | 1.25% | Long-term retention | 97.5% | ||
10 | 9 | 38.70% | $11.61 | 93.05% | 1.30% | ||||
11 | 10 | 36.53% | $10.96 | 94.40% | 1.35% | Outputs | |||
12 | 11 | 35.00% | $10.50 | 95.80% | 1.40% | Lifetime Value | $238.92 | ||
13 | 12 | 34.04% | $10.21 | 97.25% | 1.45% | Average Months Retained | 15.93 | ||
14 | 13 | 33.19% | $9.96 | 97.50% | 1.50% | ||||
15 | 14 | 32.36% | $9.71 | 97.50% | 0.00% | ||||
16 | 15 | 31.55% | $9.46 | 97.50% | 0.00% | ||||
17 | 16 | 30.76% | $9.23 | 97.50% | 0.00% | ||||
18 | 17 | 29.99% | $9.00 | 97.50% | 0.00% | ||||
19 | 18 | 29.24% | $8.77 | 97.50% | 0.00% | ||||
20 | 19 | 28.51% | $8.55 | 97.50% | 0.00% | ||||
21 | 20 | 27.80% | $8.34 | 97.50% | 0.00% | ||||
22 | 21 | 27.10% | $8.13 | 97.50% | 0.00% | ||||
23 | 22 | 26.42% | $7.93 | 97.50% | 0.00% | ||||
24 | 23 | 25.76% | $7.73 | 97.50% | 0.00% | ||||
25 | 24 | 25.12% | $7.54 | 97.50% | 0.00% | ||||
26 | 25 | 24.49% | $7.35 | 97.50% | 0.00% | ||||
27 | 26 | 23.88% | $7.16 | 97.50% | 0.00% | ||||
28 | 27 | 23.28% | $6.98 | 97.50% | 0.00% | ||||
29 | 28 | 22.70% | $6.81 | 97.50% | 0.00% | ||||
30 | 29 | 22.13% | $6.64 | 97.50% | 0.00% | ||||
31 | 30 | 21.58% | $6.47 | 97.50% | 0.00% | ||||
32 | 31 | 21.04% | $6.31 | 97.50% | 0.00% | ||||
33 | 32 | 20.51% | $6.15 | 97.50% | 0.00% | ||||
34 | 33 | 20.00% | $6.00 | 97.50% | 0.00% | ||||
35 | 34 | 19.50% | $5.85 | 97.50% | 0.00% | ||||
36 | 35 | 19.01% | $5.70 | 97.50% | 0.00% | ||||
37 | 36 | 18.54% | $5.56 | 97.50% | 0.00% | ||||
38 | 37 | 18.07% | $5.42 | 97.50% | 0.00% | ||||
39 | 38 | 17.62% | $5.29 | 97.50% | 0.00% | ||||
40 | 39 | 17.18% | $5.15 | 97.50% | 0.00% | ||||
41 | 40 | 16.75% | $5.03 | 97.50% | 0.00% | ||||
42 | 41 | 16.33% | $4.90 | 97.50% | 0.00% | ||||
43 | 42 | 15.93% | $4.78 | 97.50% | 0.00% | ||||
44 | 43 | 15.53% | $4.66 | 97.50% | 0.00% | ||||
45 | 44 | 15.14% | $4.54 | 97.50% | 0.00% | ||||
46 | 45 | 14.76% | $4.43 | 97.50% | 0.00% | ||||
47 | 46 | 14.39% | $4.32 | 97.50% | 0.00% | ||||
48 | 47 | 14.03% | $4.21 | 97.50% | 0.00% | ||||
49 | 48 | 13.68% | $4.10 | 97.50% | 0.00% | ||||
50 | 49 | 13.34% | $4.00 | 97.50% | 0.00% | ||||
51 | 50 | 13.01% | $3.90 | 97.50% | 0.00% | ||||
52 | 51 | 12.68% | $3.80 | 97.50% | 0.00% | ||||
53 | 52 | 12.36% | $3.71 | 97.50% | 0.00% | ||||
54 | 53 | 12.05% | $3.62 | 97.50% | 0.00% | ||||
55 | 54 | 11.75% | $3.53 | 97.50% | 0.00% | ||||
56 | 55 | 11.46% | $3.44 | 97.50% | 0.00% | ||||
57 | 56 | 11.17% | $3.35 | 97.50% | 0.00% | ||||
58 | 57 | 10.89% | $3.27 | 97.50% | 0.00% | ||||
59 | 58 | 10.62% | $3.19 | 97.50% | 0.00% | ||||
60 | 59 | 10.36% | $3.11 | 97.50% | 0.00% | ||||
61 | 60 | 10.10% | $3.03 | 97.50% | 0.00% | ||||
62 | |||||||||
63 | |||||||||
64 | |||||||||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 |