SaaS Sales Pipeline Calculator

	A	B
1	Welcom to our SaaS Sales Pipeline Calculator! We built this tool to help SaaS businesses build a starting point for understanding what they need to feed into their sales pipeline in terms of leads and deals, based on what their desired growth outcomes are. Thanks for stopping by, and we hope you find the calculator useful! Please tweet us any feedback @geckoboard and we'll look to improve it if we have time.
2
3	Step 1 - Make a copy of this spreadsheet by hitting "File > Make a Copy" above so you can edit cells and build your own model.
4
5	Step 2 - Input your key metrics to generate an output (Note: If you hover over the cell containing the question, you'll see some guides to help you calculate it)
6	What's your conversion rate from a Lead (Marketing Qualified Lead (MQL)) to a Paying Customer (Won Opportunity or Closed Deal)?	4.50%
7	What's your current Monthly Recurring Revenue (MRR)?	$230,000.00
8	At what percentage do you want to grow Monthly Recurring Revenue (MRR) every month?	6%
9	What is the average Monthly Recurring Revenue (MRR) you generate from each new customer (Average Sale Price (ASP))?	$100.00
10	What's your Net Monthly Recurring Revenue (MRR) Churn rate?	3.00%
11
12	Step 3 - Based on your Lead (Marketing Qualified Lead (MQL)) to Paying Customer (Won Opportunity or Closed Deal) conversion cycle length, identify your relevant output. This is the average period it takes from when you first capture a prospects contact details to when they become a paying customer. To calculate this, you need to look at all your won deals and calculate the average time it took from when you first captured their contact information as a prospect to actually closing them. If you can't get this information, then research from Implisit suggests the average B2B sales cycle is 102 days. However, this will vary greatly depending on your marketing and sales processes, so try to calculate a rough average for your specific business to get the most accurate output. Once you have identified your Lead to Paying Customer conversion length take a look at the relevant tab below to identify your output.
13
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