$100M Sheet

	A	B	C	D	E	F	G	H
1				*update the cells in blue
2	Projections Simulator
3	Business Metrics	Value	Goal			May	April
4	Monthly Ad Spend	$8,000			Monthly Ad Spend	$8,000	$8,000
5	CPL	$60	$5		CPL	$60	$60
6	Total Leads	133			Total Leads	133	133
7	Lead To Booked Call %	10%	15%
8	Total Booked Calls	13			Intro Calls	154	155	118
9	Cost Per Booked Call	$600			Intro Calls Showed	106	81	76
10	Show Up Rate	50%	70%		Intro Show Rate	68%	52%	64%
11					Intro-to-Sales Call	31.13%	48.15%	55.26%
12	Total Taken Calls	7			Sales Calls	33	39	42
13	Cost Per Taken Call	$1,200			Sales Calls Showed	32	39	42
14	Close Rate	10%	20%		Sales Call Show Rate	97%	100%	100%
15	Total Sales	1			Sales	13	11	19
16	Cost Per Acquistion/Sale	$12,000			Close Rate	40.63%	28.21%	45.24%
17	Total Customer Value	$20,000	$25,000		AOV	$4,300.00	$4,300.00	$4,300.00
18	Cash to Revenue Ratio	60%			PIF	40%
19	Total Cash Collected	$8,000			Total Revenue Collected	$55,900.00	$47,300.00	$81,700.00
20	Total Revenue Collected	$13,333
21	Revenue Return On Ad Spend	2	1.5
22	Cash Return On Ad Spend	1	2
23	Calls Closer Can Take Per Month	60
24	Closers Needed	0
25	Closers Commission %	10%
26	Closers Commision	$1,333
27	Net Profit	$4,000
28	Net Margins	30%
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