Deal Stage Probability Calculator
Assign win probabilities to each pipeline stage and calculate weighted expected revenue for a more accurate sales forecast.
| Stage name | Deal count | Avg deal ($) | Win probability (%) | Raw pipeline | Weighted | |
|---|---|---|---|---|---|---|
| $160.0k | $16.0k | |||||
| $96.0k | $24.0k | |||||
| $64.0k | $25.6k | |||||
| $40.0k | $24.0k | |||||
| $24.0k | $19.2k |
Pipeline summary
Automate this in your CRM. HelloGrowthCRM tracks deal stage probabilities and updates your weighted pipeline automatically. See pipeline management and sales forecasting.
About weighted pipeline calculations
What does this tool do?
Multiplies each stage's deal value by its win probability to produce a weighted pipeline figure that reflects realistic close likelihood.
Why does it matter?
Raw pipeline totals overstate revenue potential. Weighted pipeline gives sales managers a more honest forecast to share with leadership.
Definition
A weighted pipeline multiplies each open deal's value by the estimated probability of closing at its current stage, then sums those values.
Assumptions
- Win probabilities should ideally be set using historical stage-to-close conversion rates from your CRM, not guesses.
- This tool uses per-stage averages — individual deal characteristics can vary significantly within a stage.
How do you interpret your results?
A weighted pipeline below your monthly revenue target is a signal to add more deals at higher-probability stages or increase deal values.
How can you improve your numbers?
Use historical data
Replace default probabilities with your actual stage conversion rates for a more accurate forecast.
Review stage distribution
If most deals sit in early stages, pipeline coverage may look healthy but close risk is high.
Automate pipeline probability tracking in HelloGrowthCRM
HelloGrowthCRM updates deal stage probabilities automatically and shows your weighted pipeline in real time — no spreadsheet needed.
What the Deal Stage Probability Calculator does
The Deal Stage Probability Calculator turns a pipeline into a weighted forecast. You list up to seven stages, and for each one enter the number of open deals, the average deal value, and the probability that a deal at that stage eventually closes. It multiplies through to show raw pipeline and weighted value per stage, then totals deal count, raw pipeline, and weighted pipeline across the whole board in one summary.
Raw pipeline is the number sales teams quote and the number that gets them into trouble, because it counts a first conversation the same as a signed-off proposal. Weighting by stage produces a figure you can put next to a revenue target without embarrassment. It also exposes shape: two pipelines with identical totals can describe completely different businesses depending on whether the value sits at the top or at the bottom.
The calculator uses one probability and one average value per stage, so it cannot see that a single deal in negotiation is worth ten times the others, and it does not model time at all - a deal that has sat in proposal for six months is weighted exactly like one that arrived yesterday. It gives you shape and expected value, not a forecast of when the revenue lands.
How to use the Deal Stage Probability Calculator
Recreate your actual stages
Rename the defaults to match the stages your team really uses. Using somebody else's stage names produces a tidy calculation of a pipeline you do not have, which is worse than no calculation at all.
Count only live deals
Enter open deals per stage, excluding anything that has gone quiet for longer than one full sales cycle. Dead deals left in the count are the main reason weighted forecasts still come in above what closes.
Set probabilities from your own history
The defaults are conventional starting points rather than benchmarks. If you can work out what share of deals reaching each stage eventually closed, use those figures - that one change does more for accuracy than everything else on the form combined.
Enter average value per stage, not overall
Deal sizes often differ by stage because larger deals move more slowly. Using one blended average across every stage flatters the early stages and understates the late ones, which distorts the shape you are trying to read.
Compare the weighted total against your target
Put the weighted figure next to the revenue you need this period. The gap between the two, rather than the total on its own, is the number that should decide what the team does next week and whether the real problem is closing or prospecting.
How to read your results
Shape matters as much as the total. If most of the weighted value comes from early stages, the pipeline looks healthy and is fragile, because those deals are both least likely to close and furthest from closing. If most of it sits in the last two stages with little behind them, this period is safe and next period is the problem. Read the per-stage weighted column before you read the summary.
The mistake that undermines this every time is setting probabilities by feel. Optimistic percentages produce a forecast that reads well and misses, and the miss usually gets blamed on execution rather than on the assumption that caused it. With no historical data yet, start conservative and correct as deals close - a forecast that runs slightly low is far more useful to plan against than one that runs high.
Real-world examples
A sales manager preparing a monthly number for the founder
Raw pipeline was several times the target and the founder kept planning hires against it. Presenting the weighted total instead, with the probability assumptions written next to it in the same document, changed the conversation from why the team was underperforming to how much new pipeline the quarter still needed to add.
A services firm with a top-heavy board
Sixty open deals, most of them sitting in prospecting, and a weekly meeting that felt comfortable to everyone in it. The weighted total landed under the monthly target despite a raw pipeline that looked more than sufficient. The team stopped adding new leads for a fortnight and worked on moving qualified deals forward instead.
A founder setting stage probabilities for the first time
He started with the conventional defaults because he had nothing else to go on, then recalculated from a year of closed deals and found his proposal stage converted well below the default figure. Correcting that one number dropped the forecast noticeably and made it match what actually happened for the first time.
Deal Stage Probability Calculator — frequently asked questions
Quick answer
What is a weighted pipeline calculation?
- What win probabilities should I use per deal stage