Sheet 1: Home

	
	
	

		

 
		
		
	

		
Sales Pipeline Calculator
		
	

		


		


	
	

		
It's no secret you need leads to reach your monthly, quarterly, and annual Revenue Goals, but some Sales leaders struggle when it comes to determining how many leads are needed to realistically hit their targets. You can use the templates in this worksheet to determine exactly how many Leads/Opportunities are realistically needed to achieve annual Sales goals. Then, you can create a strategy to fill any gaps identified.
		
	

		


		


	
	

		
On the first tab, input your Revenue Goal, Average Deal Size, and Win Rate percetage to determine how many Sales Qualified Leads (SQLs) you need in your pipeline to achieve your Revenue Goal.
		
	

		


		


	
	

		
On the second tab, you will need to run a historical Sales report in your CRM and input numbers from that report into the appropriate cell to determine your conversion rate at each stage of the Sales Funnel.
		
	

		


		


	
	

		


		


	
	

		
We can help you find, acquire, and engage with customers every day, and in every way.
		
Learn more.
	
	

		


		


	
	

		


		


	
	

		
Use your historical performance and closing histories in your CRM to make sure you have a clear picture of how leads progress through the funnel.
		


	



Sheet 2: Sales Pipeline

	
	
	
	
	
	
	
	

		

 
		
		


		


		


		


		


	
	

		
Sales Pipeline
		


		


		


		


		


	
	

		
To determine the number of Sales Qualifited Leads (SQLs) needed to acheive your Sales Goal, input your Sales Goal (in dollars), your Average Deal Size (in dollars), and your Win Rate (percentage).
		
	

		


		


		
	

		


		


		


		


		


		


		


	
	

		


		
Sales Goal
		
 $-   
		


		


		


		


	
	

		


		
Average deal size
		
 $-   
		


		


		


		


	
	

		


		
Win Rate
		
0%
		


		


		


		


	
	

		


		
SQLs needed
		
#DIV/0!
		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Home
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
We can help you find, acquire, and engage with customers every day, and in every way.
		
Learn more.