Sales Funnel Weighted Pipeline Calculator
Estimate your weighted sales pipeline value based on deal counts, average deal size, and close probability at each funnel stage.
Overview
The Sales Funnel Weighted Pipeline Calculator helps you estimate expected revenue from your pipeline using the number of opportunities in each stage, your average deal value, and stage-by-stage close probabilities. It is useful for forecasting pipeline quality as well as total potential revenue.
How it works
The calculator multiplies the number of opportunities in each stage by the average deal value and the probability of closing at that stage. Those weighted stage values are then added together to estimate expected pipeline revenue. It also shows the total unweighted pipeline and an estimated number of expected wins across the funnel.
How to use this calculator
- 1Enter the number of opportunities in each funnel stage.
- 2Add your average deal value.
- 3Enter the estimated close probability for the qualified, proposal, and negotiation stages.
- 4Review the weighted pipeline value and expected wins.
- 5Compare the weighted result with the total pipeline value to judge funnel quality.
Example Calculation
Number of leads
100
Qualified opportunities
40
Proposals sent
15
Negotiations
8
Average deal value
$5,000
Qualified close probability
25%
Proposal close probability
50%
Negotiation close probability
75%
Weighted pipeline value
$167,500
With 100 leads, 40 qualified opportunities, 15 proposals, and 8 negotiations at an average deal value of 5000, the weighted pipeline is about 107500, with around 21 expected wins.
Frequently asked questions
What does a weighted pipeline mean?
A weighted pipeline is your sales pipeline adjusted by the chance of each opportunity closing, giving a more realistic revenue estimate than a simple total pipeline value.
Why is weighted pipeline useful?
It helps you forecast expected revenue, compare pipeline quality over time, and see whether you have enough likely deals to support future targets.
Does this calculator use the same deal value for every stage?
Yes. This version assumes one average deal value across all opportunities. If deal sizes vary a lot, the estimate will be less precise.
Can I change the stage probabilities?
Yes. You can enter your own close rates for the qualified, proposal, and negotiation stages to reflect your sales process.
Why is the total pipeline value different from the weighted pipeline value?
The total pipeline value assumes every deal closes, while the weighted pipeline value adjusts each stage by its estimated probability of closing.
How should I choose my close probabilities?
Use recent historical conversion data if possible. If you do not have data, start with conservative estimates and revise them as results come in.
Explore Related Calculators
Assumptions and warnings
Assumptions
- Each deal is assumed to have the same average value.
- Stage close probabilities are applied independently to each opportunity group.
- The lead stage uses a default 10% close probability in this version of the calculator.
- Results are estimates and do not include timing, churn, discounts, or deal-specific variability.
Warnings
- This calculator provides an estimate only and should not be used as a guarantee of future sales results.
- Real sales outcomes can vary due to deal quality, sales cycle length, pricing changes, and market conditions.