Relationship between conversion rate + CAC

	A	B	C	D	E
1			Month 1	Month 2
2	Facebook Campaign Results	Pageviews	200,000	200,000
3		Total New Signups	5,000	6,000
4		Conversion Rate	2.50%	3.00%	<--- tweak the conversion rate to see its impact on CAC. For example, increase it 5.00% or reduce it to 2.00% and see how the CAC changes.
5		Ad Spends	$1,000	$1,000
6		Cost Per Acquisition	$0.20	$0.17
7
8	Marketing Funnel Results	Lead to Customers	500	600
9	Marketing Funnel Results	Lead to Customer Conversion Rate	10%	10%
10
11	Marketing Expenses	Total Salaries	$20,000	$20,000
12		VP Marketing	$14,000	$14,000
13		Paid Marketing Mgr.	$6,000	$6,000
14
15	CAC	Total Expenses	$21,000	$21,000
16	CAC	CAC	$42.00	$35.00
17
18
19	Note: Feel free to copy this sheet for your own use. Simply, go to file > make a copy > and save.
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