Calculate your weighted sales pipeline value by applying win probability to each deal stage for accurate revenue forecasting and quota planning.
The Pipeline Value Calculator computes the probability-weighted value of your sales pipeline by applying stage-specific win rates to each deal or deal category. Rather than treating every dollar of pipeline equally, this approach recognizes that an early-stage opportunity has a much lower likelihood of closing than one in final negotiations, producing a more realistic revenue forecast.
Pipeline value is the lifeblood of sales forecasting. Raw pipeline (unweighted) often leads to wildly optimistic projections. A $10 million pipeline with a 20% overall win rate is really worth $2 million in expected revenue. By weighting each stage appropriately, sales leaders get a forecast they can share with finance and the executive team with much greater confidence.
This calculator supports multiple pipeline stages with custom probabilities. You can enter the total value at each stage or add individual deals. The output shows your weighted pipeline, pipeline coverage ratio against quota, and what needs to happen at each stage to hit your revenue target.
Accurate pipeline forecasting prevents two costly mistakes: sandbagging (undercommitting and missing growth opportunities) and overcommitting (failing to deliver a forecast and losing credibility). A probability-weighted pipeline provides the foundation for commit/upside/best-case forecasting methodologies and gives finance teams the confidence to make investment decisions based on anticipated revenue. Instant recalculation lets you test different assumptions side by side, giving you the confidence to act on data rather than gut instinct.
Weighted Pipeline = Σ(Stage Value × Stage Win Probability) Pipeline Coverage = Total Pipeline ÷ Revenue Target Weighted Coverage = Weighted Pipeline ÷ Revenue Target
Result: $920,000 weighted pipeline (0.92x coverage)
With $1.2M at Discovery (10% = $120K), $800K at Demo (25% = $200K), $600K at Proposal (50% = $300K), $400K at Negotiation (75% = $300K), and $200K at Contracting (90% = $180K), the weighted pipeline is $1.1M. Against a $1M quota, the raw coverage is 3.2x (healthy) and weighted coverage is 1.1x (tight — typical target is 1.5–2x weighted).
Raw pipeline numbers are inherently optimistic. A sales team reporting "$5 million in pipeline" sounds healthy, but if most of that value sits at early stages with 10–15% win rates, the expected revenue is only $500K–$750K. Weighted pipeline strips away the optimism and provides a realistic picture of expected revenue. This is why investor-grade forecasts always use probability-weighted figures.
The most reliable probability models are built from your own historical data. Track how many deals enter each pipeline stage and how many ultimately close. If 100 deals enter the Proposal stage annually and 45 close, your Proposal-stage probability is 45%. Update these numbers quarterly to reflect market changes, product releases, and competitive dynamics.
Pipeline coverage ratio (pipeline divided by target) is the primary leading indicator for revenue risk. Low coverage signals that the team is unlikely to hit target without significant new deal creation or win rate improvement. High coverage might indicate healthy demand or a bloated pipeline full of stale deals. Combining coverage with aging analysis gives the most complete risk picture.
Effective weekly pipeline reviews should open with weighted pipeline and coverage metrics, then drill into specific deals that have the highest expected value or have stalled. Focus management attention on mid-stage deals where coaching can have the greatest impact on outcomes, rather than reviewing every deal superficially.
Use your historical data. Typical ranges: Prospecting/Discovery (5–15%), Qualification (15–25%), Demo/Evaluation (25–40%), Proposal (40–60%), Negotiation (60–80%), Verbal Commit (80–95%). Calculate by dividing deals closed from each stage by total deals that entered that stage.
Raw (unweighted) coverage of 3–4x is standard for most B2B sales teams. Weighted coverage of 1.5–2x is a healthy target. Below 1x weighted coverage signals significant risk of missing target. Above 4x raw coverage may indicate too many low-quality or stale deals.
Weight by deal value for revenue forecasting. However, also monitor deal count per stage to ensure the pipeline isn't dependent on a small number of large deals. A balanced pipeline has adequate count and value at each stage.
Recalculate weekly as part of your pipeline review cadence. In fast-moving sales environments (high velocity, short cycles), daily updates may be appropriate. The frequency should match your sales cycle — shorter cycles need more frequent updates.
Pipeline value is the probability-weighted sum of all open opportunities. A forecast is a commitment from the sales team about what they expect to close, which includes subjective judgment about specific deals. Pipeline value provides the mathematical foundation, but forecasts add human insight.
For deals spanning multiple quarters, allocate the relevant quarter's value to that quarter's pipeline. A $1.2M annual contract starting Q3 might contribute $300K to Q3 pipeline (one quarter of annual value) unless the full booking counts in Q3.
Common causes: deals moving to lost/closed-lost, deals being pushed (slipping to next quarter), declining deal sizes, inadequate lead generation feeding the top of the funnel, and pipeline purges of stale opportunities. Track the reasons to address root causes.
If you consistently have more pipeline than your team can work effectively (coverage > 5x), it may be time to hire. If coverage is thin (< 2x), adding reps won't help — you need more lead generation. Pipeline coverage per rep is a key metric for sales capacity planning.