ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAM
1
Get an editable copy of this sheetIf you like the sheet, consider an upvote on ProductHunt. Thanks. :-)
2
3
Assumptions1234567891011121314151617The sample data is generated based on these inputs. You can modify it by changing the blue parameters.

To keep it simple, all cohorts have the same ARPA, customer churn rate and revenue churn rate. This is a gross oversimplification, but you can replace the cohort data below with your own real data.
4
Customer churn rate in lifetime month3.0%3.0%3.0%3.0%3%3%3%3%3%3%3%3%3%3%3%3%3%
5
Customers retained at lifetime month100%97%94%91%89%86%83%81%78%76%74%72%69%67%65%63%61%60%
6
Customers beginning of month 00
7
New customers month 010
8
New customers, m/m growth rate15%
9
MRR beginning of month 0$0
10
MRR per staying customer in lifetime month $200$201$202$203$204$205$206$207$208$209$210$211$212$213$214$215$216$217
11
MRR increase relative to lifetime month 00.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%0.5%
12
MRR retained at lifetime month100%97%95%93%90%88%86%84%82%79%77%75%74%72%70%68%66%65%
13
Gross Margin78%
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Retained customers by lifetime monthLifetime month
38
Customer cohortMonth 0Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Month 13Month 14Month 15Month 16Month 17
39
01/201910109999888877777666
40
12/20191211111010101099988888777
41
23/20191313121212111111101010999988
42
34/201915151414131313121212111111101010
43
45/2019171716161515151414131313121211
44
56/20192020191818171716161515141414
45
67/201923222221202019191818171716
46
78/2019272625242423222121202019
47
89/20193130292827262525242323
48
910/201935343332313029282827
49
1011/2019403938373635343332
50
1112/20194745444241403938
51
121/202054525049474645
52
132/2020626058565453
53
143/20207169676563
54
154/202081797774
55
165/2020949188
56
176/2020108104
57
58
01234567891011121314151617
59
Retained customers by monthMonth
60
Customer cohort1/20192/20193/20194/20195/20196/20197/20198/20199/201910/201911/201912/20191/20202/20203/20204/20205/20206/2020
61
01/201910109999888877777666
62
12/2019121111101010109998888877
63
23/2019131312121211111110101099998
64
34/2019151514141313131212121111111010
65
45/20191717161615151514141313131212
66
56/201920201918181717161615151414
67
67/2019232222212020191918181717
68
78/20192726252424232221212020
69
89/201931302928272625252423
70
910/2019353433323130292828
71
1011/20194039383736353433
72
1112/201947454442414039
73
121/2020545250494746
74
132/20206260585654
75
143/202071696765
76
154/2020817977
77
165/20209491
78
176/2020108
79
80
01234567891011121314151617
81
Retained MRR by lifetime monthLifetime month
82
Customer cohortMonth 0Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Month 13Month 14Month 15Month 16Month 17
83
1/2019$2,000$1,950$1,901$1,853$1,806$1,760$1,716$1,673$1,630$1,589$1,549$1,509$1,471$1,434$1,397$1,361$1,327$1,293
84
2/2019$2,300$2,242$2,186$2,131$2,077$2,024$1,973$1,923$1,875$1,827$1,781$1,736$1,692$1,649$1,607$1,566$1,526$1,487
85
3/2019$2,645$2,578$2,514$2,450$2,388$2,328$2,269$2,212$2,156$2,101$2,048$1,996$1,945$1,896$1,848$1,801$1,755
86
4/2019$3,042$2,965$2,891$2,818$2,747$2,677$2,610$2,544$2,479$2,416$2,355$2,295$2,237$2,180$2,125$2,071
87
5/2019$3,498$3,410$3,324$3,240$3,159$3,079$3,001$2,925$2,851$2,779$2,708$2,640$2,573$2,507$2,443
88
6/2019$4,023$3,922$3,823$3,726$3,633$3,541$3,451$3,364$3,279$3,196$3,115$3,036$2,959$2,883
89
7/2019$4,626$4,510$4,396$4,285$4,177$4,072$3,969$3,869$3,771$3,675$3,582$3,491$3,402
90
8/2019$5,320$5,186$5,056$4,928$4,804$4,683$4,564$4,449$4,336$4,226$4,119$4,015
91
9/2019$6,118$5,964$5,814$5,668$5,525$5,385$5,249$5,116$4,987$4,860$4,737
92
10/2019$7,036$6,859$6,686$6,518$6,353$6,193$6,036$5,884$5,735$5,589
93
11/2019$8,091$7,888$7,689$7,495$7,306$7,122$6,942$6,766$6,595
94
12/2019$9,305$9,071$8,842$8,620$8,402$8,190$7,983$7,781
95
1/2020$10,701$10,431$10,169$9,913$9,663$9,419$9,181
96
2/2020$12,306$11,996$11,694$11,399$11,112$10,831
97
3/2020$14,151$13,796$13,448$13,109$12,779
98
4/2020$16,274$15,865$15,465$15,076
99
5/2020$18,715$18,245$17,785
100
6/2020$21,523$20,981