Funnel Calculator

Option 1 - Cascade Through Funnel (Start with No. of Enquiries)

Top of Funnel (TOF)
Number of Enquiries coming into the Top of the Funnel (TOF):		Input # Leads
What is the probability of an Enquiry becoming a Lead (%):		Input %
This is the estimated number of Leads that are coming into the Middle of the Funnel (MOF)		Calculated
Middle of Funnel (MOF)
What is the probability of a Lead becoming fully qualified and becoming a Commercial Opportunity (%)		Input %
This is the estimated number of Commercial Opportunities that are coming into the Bottom of the Funnel (BOF)		Calculated
Bottom of Funnel (BOF)
What is the probability of a Commercial Opportunity becoming a Closed Won Deal (%)		Input Opportunity Win Rate %
This is the Number of Deals you win!		WIN (#)
Average Deal Size (£):		Input £
This is your Total Revenue! (£)		WIN (£)

Option 2 - Reverse Calculation (Start with Revenue Target)

Target Revenue (£):

TOP TIP:

Take the # of Enquiries going into TOF required: you have calculated in Option 2, and feed this into the Number of Enquiries coming into the Top of the Funnel (TOF): in Option 1, so you can check if your assumptions about the conversion rates from one part of the funnel stack up.

Be sure to update your Average Deal Size (£) to be sure to make sure you have enough going in the top to hit your quota.

If you need any help with this, please do get in touch using the Connect button in the menu bar.