ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Customer Lifetime Value (CLV/CLTV) Workbook
2
3
Sheets included:
4
5
1) Simple
6
2) Margin-Based
7
3) Retention/Churn-Based
8
4) Discounted Cash Flow (DCF)
9
5) Predictive (Probability × Spend)
10
11
Notes:
12
• Enter values in the light cells; outputs will calculate automatically.
13
• Ensure your period units match across inputs (e.g., monthly ARPU with monthly churn).
14
• Discount rates are per period (e.g., monthly discount for monthly periods).
15
16
17
18
19
20
21
22
23
24
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