SaaS LTV Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
 
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 0100
8
New customers, m/m growth rate6%
9
MRR beginning of month 0$0
10
MRR per staying customer in lifetime month $100$101$102$103$104$105$106$107$108$109$110$111$112$113$114$115$116$117
11
MRR increase relative to lifetime month 01%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%1%
12
MRR retained at lifetime month100%98%96%94%92%90%88%86%85%83%81%79%78%76%74%73%71%70%
13
Gross Margin80%
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/20191009794918986838178767472696765636160
40
12/2019106103100979491888683817876747169676563
41
23/201911210910610399969491888583807876737169
42
34/201911911611210910510299969391888583807875
43
45/201912612211911511210810510299969390888582
44
56/201913413012612211811511110810510299969390
45
67/201914213813312912612211811511110810510198
46
78/2019150146141137133129125121118114111108
47
89/2019159155150145141137133129125121118
48
910/2019169164159154150145141137132128
49
1011/2019179174169163159154149145140
50
1112/2019190184179173168163158153
51
121/2020201195189184178173168
52
132/2020213207201195189183
53
143/2020226219213206200
54
154/2020240232225219
55
165/2020254246239
56
176/2020269261
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/20191009794918986838178767472696765636160
62
12/20191061031009794918886838178767471696765
63
23/2019112109106103999694918885838078767371
64
34/2019119116112109105102999693918885838078
65
45/2019126122119115112108105102999693908885
66
56/2019134130126122118115111108105102999693
67
67/2019142138133129126122118115111108105101
68
78/2019150146141137133129125121118114111
69
89/2019159155150145141137133129125121
70
910/2019169164159154150145141137132
71
1011/2019179174169163159154149145
72
1112/2019190184179173168163158
73
121/2020201195189184178173
74
132/2020213207201195189
75
143/2020226219213206
76
154/2020240232225
77
165/2020254246
78
176/2020269
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$10,000$9,797$9,597$9,401$9,207$9,017$8,830$8,645$8,464$8,287$8,112$7,940$7,771$7,605$7,442$7,282$7,125$6,971
84
2/2019$10,600$10,385$10,173$9,965$9,759$9,558$9,359$9,164$8,972$8,784$8,598$8,416$8,237$8,062$7,889$7,719$7,553$7,389
85
3/2019$11,236$11,008$10,783$10,562$10,345$10,131$9,921$9,714$9,511$9,311$9,114$8,921$8,732$8,545$8,362$8,182$8,006
86
4/2019$11,910$11,668$11,430$11,196$10,966$10,739$10,516$10,297$10,081$9,869$9,661$9,456$9,255$9,058$8,864$8,673
87
5/2019$12,625$12,368$12,116$11,868$11,624$11,383$11,147$10,915$10,686$10,462$10,241$10,024$9,811$9,601$9,396
88
6/2019$13,382$13,111$12,843$12,580$12,321$12,066$11,816$11,570$11,327$11,089$10,855$10,625$10,399$10,177
89
7/2019$14,185$13,897$13,614$13,335$13,060$12,790$12,525$12,264$12,007$11,755$11,507$11,263$11,023
90
8/2019$15,036$14,731$14,431$14,135$13,844$13,558$13,276$13,000$12,727$12,460$12,197$11,939
91
9/2019$15,938$15,615$15,296$14,983$14,675$14,371$14,073$13,779$13,491$13,207$12,929
92
10/2019$16,895$16,552$16,214$15,882$15,555$15,234$14,917$14,606$14,300$14,000
93
11/2019$17,908$17,545$17,187$16,835$16,488$16,148$15,812$15,483$15,159
94
12/2019$18,983$18,598$18,218$17,845$17,478$17,116$16,761$16,412
95
1/2020$20,122$19,713$19,311$18,916$18,526$18,143$17,767
96
2/2020$21,329$20,896$20,470$20,051$19,638$19,232
97
3/2020$22,609$22,150$21,698$21,254$20,816
98
4/2020$23,966$23,479$23,000$22,529
99
5/2020$25,404$24,888$24,380
100
6/2020$26,928$26,381
Loading...