Churn Calculations

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	Churn Calcs Simulator - why definitions matter
2	by @alexoppenheimer
3
4		Initial Customers		1,000
5					Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Month 13	Month 14	Month 15	Month 16	Month 17	Month 18	Month 19	Month 20	Month 21	Month 22	Month 23	Month 24	Month 25
6	Case 1	Of current			1,000	900	810	729	656	590	531	478	430	387	349	314	282	254	229	206	185	167	150	135	122	109	98	89	80
7		% Monthly Churn		10%		90%	81%	73%	66%	59%	53%	48%	43%	39%	35%	31%	28%	25%	23%	21%	19%	17%	15%	14%	12%	11%	10%	9%	8%
8
9
10	Case 2	Of initial			1,000	900	800	700	600	500	400	300	200	100	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
11		% Monthly Churn		10%		90%	80%	70%	60%	50%	40%	30%	20%	10%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
12
13
14	Case 3	Annual contracts			1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	900	900	900	900	900	900	900	900	900	900	900	900	810
15		% Non-renewal		10%		100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	90%	90%	90%	90%	90%	90%	90%	90%	90%	90%	90%	90%	81%
16
17
18	Case 4	Variable contract length	.	.	1,000	1,000	1,000	1,000	1,000	1,000	900	900	900	900	900	900	810	810	810	810	810	810	729	729	729	729	729	729	656
19		% Non-renewal	6	10%		100%	100%	100%	100%	100%	90%	90%	90%	90%	90%	90%	81%	81%	81%	81%	81%	81%	73%	73%	73%	73%	73%	73%	66%
20
21
22
23
24
25		More here:
26		https://alexoppenheimer.substack.com/p/churning
27
28		Tweet @alexoppenheimer for a live copy
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