a16z GMV Retention Template.xlsx

	B	C	D	E	F	G	H	I	J
1
2	For this sample company, we assume that their first month of transactions is January 2022 - and we imagine we have data through July 2022.
3
4	GMV by Cohort
5	Cohort	Cohort Size	M0	M1	M2	M3	M4	M5	M6
6	Jan-22	10	$10,000	$7,500	$7,000	$5,500	$5,000	$4,500	$4,500
7	Feb-22	15	$20,000	$15,000	$12,000	$10,050	$10,000	$9,000
8	Mar-22	20	$30,000	$22,000	$21,000	$20,000	$18,000
9	Apr-22	40	$65,000	$50,000	$48,000	$42,000
10	May-22	80	$100,000	$80,000	$78,000
11	Jun-22	100	$150,000	$120,000
12
13	GMV Retention by Cohort
14	Cohort	Cohort Size	M0	M1	M2	M3	M4	M5	M6
15	Jan-22	10	100%	75%	70%	55%	50%	45%	45%
16	Feb-22	15	100%	75%	60%	50%	50%	45%
17	Mar-22	20	100%	73%	70%	67%	60%
18	Apr-22	40	100%	77%	74%	65%
19	May-22	80	100%	80%	78%
20	Jun-22	100	100%	80%
21
22	Weighted Average		100%	79%	74%	61%	54%	45%	45%
23
24	GMV Retention by Cohort - "Spaghetti Chart"
25
26
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