Expected bookings from pipeline

What is weighted sales pipeline value?

Weighted sales pipeline value is the expected revenue from your open deals after adjusting for the chance each one closes. It multiplies the number of qualified opportunities by average deal size and win probability. Unlike raw pipeline, which assumes every deal closes, the weighted figure gives a realistic bookings forecast. Sales leaders, RevOps teams, and founders use it to forecast revenue, check progress against quota, and decide how much new pipeline they need.

Expected bookings from pipeline

Opportunities × avg ACV × win %

1
Pipeline coverage
2
Win rates

Embed this free calculator on your website—copy the snippet after signup and keep the Built with Calclet link for attribution (or upgrade to remove branding).

Expected bookings from pipeline — formula: Weighted pipeline value = Opportunities × Average deal size × Win probability % ÷ 100
Expected bookings from pipeline — formula: Weighted pipeline value = Opportunities × Average deal size × Win probability % ÷ 100
1200×630

Weighted pipeline value formula

Multiply qualified opportunities by average deal size and win probability.

Weighted pipeline value = Opportunities × Average deal size × Win probability % ÷ 100
  • Unweighted pipeline = Opportunities × Average deal size.
  • Opportunities needed for a target = Target bookings ÷ (Average deal size × Win probability).
  • Stage-weighted value = Sum of (Deals in each stage × Stage win probability) × Average deal size.

Inputs explained

Base inputs on qualified deals and historical win rates, not rep optimism.

Qualified opportunities in pipe
Number of open, qualified deals expected to close in the forecast period. Exclude early-stage leads and stale deals.
Average ACV ($)
Average annual contract value per deal. Use first-year value for multi-year deals, and check whether a few very large deals are skewing the average.
Weighted win probability (%)
The average chance a deal closes, based on historical win rates by stage or your forecast categories.

Example weighted pipeline calculation

A sales team has 34 qualified opportunities averaging $18,500 with a 28% win probability. Unweighted pipeline = 34 × $18,500 = $629,000. Weighted pipeline value = $629,000 × 0.28 = $176,120. That's the realistic bookings estimate, equal to about 9.5 expected wins.

Put this calculator on your site

We'll copy this tool into your Calclet account—tweak branding and fields, then paste the embed on WordPress, Webflow, Shopify, or any HTML page. Every embed can link back to Calclet for discovery.

Platform embed guides · Pricing

How to use the expected bookings from pipeline

  1. In Pipeline coverage, input qualified opportunities in pipe and average ACV ($) consistent with CRM probability modeling—typically stage-three-plus inventory.
  2. In Win rates, set weighted win probability (%) using historical stage yields or forecast category percentages leadership approved.
  3. Read weighted pipeline value and unweighted pipe side by side before reconciling to quota coverage multiples.
  4. Refresh averages weekly because stale ACV assumptions distort weighted dollars faster than opportunity counts move.

Common weighted pipeline mistakes

  • Treating unweighted pipeline as the forecast.
  • Using rep-entered probabilities instead of historical win rates.
  • Counting multi-year contract value instead of annual value.
  • Letting one very large deal skew the average deal size.
  • Keeping slipped or stale deals in the current period's pipeline.

Weighted pipeline forecasting context

Stage-based probability hygiene
Finance-grade forecasts anchor win percentages on trailing stage conversion data rather than AE optimism sliders unless pipeline reviews override with evidence.
ACV normalization
Average deal inputs should exclude one-time services unless quota credits services revenue; multi-year totals often deflate to annual recurring equivalents.
Weighted versus gross coverage
Coverage ratios frequently reference gross pipe multiples while board forecasts cite weighted expected bookings—label both when presenting.

FAQs

How many opportunities do we need to hit a $250,000 quota?

Divide the quota by the expected value per deal. Each deal is worth $18,500 × 0.28 = $5,180 on a weighted basis, so $250,000 ÷ $5,180 ≈ 48.3. You need 49 qualified opportunities, 15 more than today's 34.

What win rate would we need to hit $250,000 with our current pipeline?

Divide the target by unweighted pipeline. $250,000 ÷ $629,000 ≈ 39.75%, well above the current 28%. Raising win rate that much in one quarter is hard, so adding pipeline is usually the more realistic fix.

How do I weight pipeline by deal stage instead of one blended rate?

Apply each stage's historical win rate. With 8 late-stage deals at 75%, 12 mid-stage at 40%, and 14 early-stage at 10%, you expect 12.2 wins. At $18,500 each, that's $225,700, compared with $176,120 using a blended 28%. Stage weighting reflects where deals actually sit.

One huge deal is in our pipeline—how much does it affect the forecast?

Separate it from the rest. If one $150,000 deal sits among 34, the other 33 average about $14,515. At 28%, those 33 deals are worth $134,120 weighted, and the large deal adds $42,000. If you lose it, you lose a big share of the forecast, so forecast large deals individually.

Should we focus on bigger deals or higher win rates?

On paper, they're equal. Raising average deal size 10% (to $20,350) or win rate 10% (to 30.8%) each adds $17,612 of weighted pipeline. In practice, bigger deals often close less often or take longer, so test which lever your team can move.

How accurate is a weighted pipeline forecast?

It's an average, so actual results vary, especially with few deals. With 34 deals at 28%, you expect about 9.5 wins, but a typical range is roughly 7 to 12 wins, or about $128,000 to $225,000. Larger pipelines produce more reliable forecasts.

How do end-of-quarter discounts affect weighted pipeline?

Discounts reduce deal value. A 15% discount cuts average deal size from $18,500 to $15,725, dropping weighted value from $176,120 to about $149,702. If discounts don't raise the win rate enough, they lower bookings.

What if 30% of our deals slip into next quarter?

Remove them from this period's forecast. With 30% of 34 deals slipping, about 23.8 remain, and weighted value falls from $176,120 to about $123,284. Track historical slip rates and apply them to make forecasts more realistic.

What's the difference between weighted and unweighted pipeline?

Unweighted pipeline assumes every deal closes: $629,000 here. Weighted pipeline adjusts for win probability: $176,120 at 28%. Use unweighted pipeline for coverage ratios and weighted pipeline for bookings forecasts.

Should I use rep-entered probabilities or historical win rates?

Historical win rates are usually more accurate, because reps tend to be optimistic. Use stage-based rates from the past few quarters, and only override them for specific deals with clear evidence, such as a signed verbal agreement.

Related calculators

Step-by-step articles on building, embedding, and ranking calculator pages like this one.

Browse all blog posts →

Category: Sales forecasting and pipeline analyticsTopics: Weighted pipeline value, Expected bookings, Win probability

Last reviewed: 2026-05-07

Reviewed by: Souhayb Kama Ldine