Vellward
Request pilot reviewPilot review

Free sales calculator

Sales Pipeline Calculator

This sales pipeline calculator checks whether your current pipeline covers your target. Every stage probability comes from you.

It measures current unweighted coverage, probability-weighted pipeline, the weighted gap to target, and the rough opportunity count needed to cover that gap.

Enter the target this pipeline needs to cover.

Enter the total value in your early stage.

Enter the total value in your middle stage.

Enter the total value in your late stage.

Customize calculation

Enter your probability for the early stage.

Enter your probability for the middle stage.

Enter your probability for the late stage.

Enter the average value of one won deal.

Enter your win rate as a percent.

Enter the days left in the target period. This is shown with the coverage result.

Formula and assumptions

How this calculation works

The calculator adds the stage values for raw coverage. It then applies only the probabilities you enter. Required opportunities is a scenario estimate and may include part of an opportunity.

  • Unweighted coverage = total pipeline ÷ revenue target
  • Weighted pipeline = sum of each stage value × its probability
  • Weighted coverage = weighted pipeline ÷ revenue target
  • Gap = greater of zero or revenue target minus weighted pipeline
  • Required opportunities = gap ÷ (average deal value × win rate)

It does not forecast what will close in a set period. It also does not prove that any deal will close.

Fictional aggregate example

Fictional aggregate example

This made-up pipeline shows the math. It does not say that any deal will close.

Made-up inputs

  • $100,000 target
  • $60,000 at 20%, $50,000 at 50%, and $40,000 at 80%
  • $10,000 average deal value and 25% win rate
  • 60 days remaining

Example result

  • 1.5× unweighted coverage
  • $69,000 weighted pipeline and 0.69× weighted coverage
  • $31,000 gap and about 12.4 additional qualified opportunities

Questions

sales pipeline calculator FAQ

What is pipeline coverage?

Pipeline coverage compares your pipeline value with a revenue target.

Where do the stage probabilities come from?

They come from you. Use rates from your own process when you have them. The calculator does not add industry rates.

Why can required opportunities be a decimal?

It is a planning estimate. Round up if you need a whole-opportunity planning count.

Related tools