Skip to content
NoClutterCRM

Free calculator

Sales target and pipeline calculator

Estimate how many wins and open opportunities your sales target requires using your average deal value and expected win rate.

  • Free to use
  • No signup
  • Stays in your browser

Enable JavaScript to use this tool in your browser.

Worked example

A target of 50,000 with an average deal value of 5,000 requires 10 wins. At a 25% win rate that means 40 opportunities and 200,000 in pipeline value.

Wins are the target divided by average deal value, rounded up. Opportunities are wins divided by the win-rate fraction, rounded up. Pipeline value is opportunities times average deal value.

How to work out the pipeline your target needs

A sales target is easier to act on once it is broken into the deals behind it. Three numbers are enough: the target, your average deal value and the share of opportunities you usually win.

Divide the target by the average deal value to get the wins you need. Divide the wins by your win rate to get the opportunities you need, then multiply the opportunities by the deal value for the pipeline value to aim for. Wins and opportunities are rounded up, because half a deal never closes.

Use figures from your own past sales. A win rate you have measured is more useful than an industry average.

Sales target and pipeline calculator questions

What is pipeline coverage?

Pipeline value divided by the target. At a 25% win rate you need about four times your target in open opportunities.

How do I work out my win rate?

Divide the deals you won by all the deals you closed, won or lost, over the same period, then multiply by 100.

Does it work in any currency?

Yes. Use one currency and one sales period for every number you enter.

Can I save the result?

Download the calculation as a CSV, with your inputs and the three results.