Sales Pipeline Value Calculator

How to use a sales pipeline value calculator

A sales pipeline value calculator helps sales teams and business owners understand how much revenue is currently in play and how much of it is realistically likely to close. Rather than treating every deal as if it will definitely come through, this calculator applies your historical win rate to give a probability-weighted revenue figure, which is far more useful for planning and forecasting.

The total pipeline value is simply your number of active deals multiplied by your average deal size. This tells you the gross opportunity sitting in your pipeline right now. The expected revenue figure goes one step further by applying your win rate. If you have a 30 percent win rate, only about one in three deals will close, so your expected revenue is considerably lower than the raw total.

This gap between total pipeline and expected revenue is one of the most important numbers a sales leader can track. If expected revenue falls short of your monthly or quarterly target, you know you need to add more deals to the top of the funnel, improve your win rate, or increase your average deal size. All three levers can be worked on independently, and this calculator helps you see which one will have the biggest impact.

What inputs does the calculator need?

• Number of active deals: count all open opportunities currently being worked, regardless of stage.
• Average deal value: use a rolling average from recent closed deals. If your deals vary widely, you may want to segment the calculation by deal size tier.
• Win rate: your historical close rate as a percentage. If you do not track this yet, start now. Even a rough estimate helps.

Common questions

Should I include early-stage deals or only late-stage ones?

Including all active deals gives you a complete picture of total opportunity, but some teams prefer to only count deals past a qualifying stage. Either approach is valid as long as you are consistent. The win rate you use should match the stage set you are measuring.

How often should I recalculate my pipeline value?

Most sales teams review pipeline at least weekly during a quarter and daily in the final stretch. Running this calculation at the start of each month gives you a baseline for how much new pipeline you need to generate.

What is a healthy pipeline multiplier?

A common rule of thumb is to maintain a pipeline worth three to four times your revenue target for the period, to account for deals that slip or do not close. If your win rate is 25 percent, you need a pipeline value four times your target to have a realistic chance of hitting it.

Can I use this if my deals have very different sizes?

The calculator uses an average deal value, which works well when your deal sizes are reasonably consistent. If you have a mix of very small and very large deals, consider running the calculation separately for each segment and adding the results together for a more accurate expected revenue figure.