Pipeline Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P
1
2	Edit this section
3	Outbound
4	Demo rate	1%
5	Close rate	35%
6	ACV	$6,000	ARR
7	Sales outreach	50	weekly
8	Growth rate	0%	MoM
9
10	Inbound
11	Demo rate	0.5%
12	Close rate	45%
13	ACV	$4,000	ARR
14	Vistors	500	weekly
15	Growth rate	10%	MoM
16
17
18	Network
19	Demo rate	10%
20	Close rate	50%
21	ACV	$6,000	ARR
22	Network outerach	10	weekly
23	Growth rate	-15%	MoM
24
25
26
27			January	February	March	April	May	June	July	August	September	October	November	December	Comment
28	Outbound
29		Activity	200	200	200	200	200	200	200	200	200	200	200	200
30		Pipeline	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000
31		ARR		$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	$4,200	For ARR the assumption is that deals take 4 weeks to close
32
33	Inbound
34		Activity	2000	2200	2420	2662	2928	3221	3543	3897	4287	4716	5187	5706
35		Pipeline	$40,000	$44,000	$48,400	$53,240	$58,564	$64,420	$70,862	$77,949	$85,744	$94,318	$103,750	$114,125
36		ARR		$18,000	$19,800	$21,780	$23,958	$26,354	$28,989	$31,888	$35,077	$38,585	$42,443	$46,687	For ARR the assumption is that deals take 4 weeks to close
37
38	Network
39		Activity	40	34	29	25	21	18	15	13	11	9	8	7
40		Pipeline	$24,000	$20,400	$17,340	$14,739	$12,528	$10,649	$9,052	$7,694	$6,540	$5,559	$4,725	$4,016
41		ARR		$12,000	$10,200	$8,670	$7,370	$6,264	$5,324	$4,526	$3,847	$3,270	$2,779	$2,362	For ARR the assumption is that deals take 4 weeks to close
42
43					Q1 Pipeline			Q2 Pipeline			Q3 Pipeline			Q4 Pipeline
44	Outbound Pipeline				$36,000			$36,000			$36,000			$36,000
45	Inbound Pipeline				$132,400			$176,224			$234,555			$312,192
46	Network Pipeline				$61,740			$37,916			$23,285			$14,300
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