Cohort_Analysis_Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Cohort Analysis Template
2	Track customer cohorts by acquisition month. Yellow = inputs. Black = formulas.
3
4	CUMULATIVE REVENUE PER CUSTOMER BY COHORT
5	Cohort	Customers	Month 0	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
6	Jan 2026
7	Feb 2026
8	Mar 2026
9	Apr 2026
10	May 2026
11	Jun 2026
12	Jul 2026
13	Aug 2026
14	Sep 2026
15	Oct 2026
16	Nov 2026
17	Dec 2026
18
19
20	RETENTION RATE BY COHORT (% customers who reorder)
21	Cohort	Customers	Month 0	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
22	Jan 2026
23	Feb 2026
24	Mar 2026
25	Apr 2026
26	May 2026
27	Jun 2026
28	Jul 2026
29	Aug 2026
30	Sep 2026
31	Oct 2026
32	Nov 2026
33	Dec 2026
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