Problem Calculator

	B	C	D
1
2
3		Problem Calculator
4
5
6
7
8
9	Instructions
10	Step 1: Define your # of prospects contacted monthly (green cells)
11	Step 2: Define your conversion rates (blue cells)
12	Step 3: Define your average deal size (violet cells)
13
14		New Logos Only	Expansion Only
15	# prospects contacted	400	400
16	Reply rate	5%	15%
17	# prospects replied	20	60
18	Meeting rate	20%	20%
19	#meetings booked	4	12
20	Opportunity rate	50%	50%
21	#opporunites generated	2	6
22	Win rate	50%	50%
23	#deals won	1	3
24	Average deal size	$15,000.00	$15,000.00
25	Total Won	$15,000.00	$45,000.00
26	Missed Sales:		$30,000.00
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