Customer Lifetime Value - Visible.vc - Template

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025

2	Scenario A
3	Average Contract Value (ACV)	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000
4	Gross Margin	85%	85%	85%	85%	85%	85%	85%	85%	85%	85%	85%	85%
5	Gross Profit	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250	$4,250
6	Customer Acquisition Cost (CAC)	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286	$14,286
7	Sum of all Sales & Marketing Expenses	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000
8	Number of New Customer Added	35	35	35	35	35	35	35	35	35	35	35	35
9	Churn Rate	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%	8%
10	Expansion Rate	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
11	Lifetime Value (LTV)	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125	$53,125
12
13	LTV:CAC Ratio	3.72	3.72	3.72	3.72	3.72	3.72	3.72	3.72	3.72	3.72	3.72	3.72
14
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