Calculating Lifetime Value (Example)

	B	C	D	E	F	G	H
1
2	The gross profit from the entire cohort of users in dynamics by days from the moment of registration for each user
3
4		days from the moment of registration for each user
5		Day 0	Day 1	Day 2	Day 3	Day 4	Day 5
6	Gross Profit (user 1)	10	5	0	0	2	1
7	Gross Profit (user 2)	5	0	0	3	2	0
8	...
9	Gross Profit (user 100)	0	2	3	0	0	0
10
11	we assume there are 100 users in our cohort
12
13	The gross profit for the entire cohort of users in dynamics by days from the moment of registration for each user
14
15		Day 0	Day 1	Day 2	Day 3	Day 4	Day 5
16	Gross Profit (users 1-100)	150	80	60	50	40	30
17
18	Cummulative Gross Profit (users 1-100) for the entire cohort of users in dynamics by days from the moment of registration for each user
19
20		Day 0	Day 1	Day 2	Day 3	Day 4	Day 5
21	Cummulative Gross Profit (users 1-100)	150	230	290	340	380	410
22
23	LTV for the entire cohort of users in dynamics by days from the moment of registration for each user
24
25		Day 0	Day 1	Day 2	Day 3	Day 4	Day 5
26	LTV	1.5	2.3	2.9	3.4	3.8	4.1
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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