Business
Sales Pipeline Forecast Calculator
This model converts open counts into probability-and-slippage weighted wins, bookings, collections, gross profit, target coverage, and period contribution. It keeps unweighted pipeline multiple separate from weighted target coverage so large early-stage volume is not mistaken for forecast confidence.
Expected wins from qualification-
Expected wins from proposal-
Expected wins from negotiation-
Total probability-and-slippage weighted wins-
Unweighted value of open opportunities-
Probability-and-slippage weighted bookings-
Collections expected inside forecast period-
Gross profit on forecast collections-
Gross profit less assigned sales cost-
Weighted bookings divided by target-
Target bookings not covered by weighted forecast-
Unweighted pipeline divided by target-
Decision view
Stage probability forecast matrix
Stage probability forecast matrixMutually exclusive qualification, proposal, and negotiation pools use separate win probabilities and a shared close-date slippage adjustment.
Exact scenario comparisonWin probability from negotiation (%) changes while all other entered assumptions remain constant.
| Win probability from negotiation (%) | Expected wins from qualification | Expected wins from proposal | Expected wins from negotiation | Total probability-and-slippage weighted wins | Unweighted value of open opportunities | Probability-and-slippage weighted bookings | Collections expected inside forecast period | Gross profit on forecast collections | Gross profit less assigned sales cost | Weighted bookings divided by target | Target bookings not covered by weighted forecast | Unweighted pipeline divided by target |
|---|
How to use Sales Pipeline Forecast Calculator
- Export one mutually exclusive count for qualification, proposal, and negotiation.
- Estimate eventual win probability from recent comparable opportunities in each stage.
- Apply expected close-date slippage and compare weighted bookings with the target and sales cost.
Calculator guide
Understanding Sales Pipeline Forecast Calculator
Forecast an open pipeline from mutually exclusive stage pools instead of applying one average conversion rate to every opportunity. Qualification, proposal, and negotiation each use a different probability, while close-date slippage removes expected wins that are likely to leave the forecast period.
Detailed calculation process
Weight each stage and reconcile the forecast with its target
The default has 120 qualification, 55 proposal, and 20 negotiation opportunities with 15%, 35%, and 65% win probabilities, 20% slippage, $18,000 average contract value, and a $500,000 bookings target.
General formula: W_q = Q_q p_q(1 - s)W_p = Q_p p_p(1 - s)W_n = Q_n p_n(1 - s)W_total = W_q + W_p + W_nB_weighted = W_total vCash = B_weighted kGP = Cash gContribution = GP - C_salesCoverage = B_weighted / Target Each probability is applied only to the opportunities currently in that stage. The shared slippage factor then restricts expected wins to the forecast period before value and collection economics are added.
What each symbol means
Worked substitution with the default inputs
The default forecast contains 40.2 expected in-period wins, $723,600 weighted bookings, 144.72% target coverage, and $365,868 contribution.
Forecast matrix
Compare stage volume, probability, and expected wins together
Bubble position and size retain three dimensions that a simple funnel hides.
Worked situations
Practical examples
- One hundred twenty qualification opportunities at 15% win probability and 20% slippage contribute 14.4 expected in-period wins.
- The default stage pools sum to 40.2 expected wins and $723,600 weighted bookings.
Better inputs
Useful tips
- Estimate stage probabilities from recent opportunities with the same segment, sales motion, and qualification rules.
- Remove duplicate, stalled, and already-lost opportunities before calculating weighted value.
- Review close-date slippage and sales-cycle age separately; probability alone does not determine when revenue arrives.
Before relying on the result
Limitations and common mistakes
- One average contract value is applied to every stage and no deal-size distribution is modeled.
- Opportunity dependencies, seller judgment, renewals, upsells, stage regression, and seasonality are excluded.
- Expected wins may be fractional because the result is a probability-weighted forecast.
Reference
Key terms
- Mutually exclusive stage pool
- Each open opportunity is counted in exactly one current stage.
- Close-date slippage
- Share of otherwise expected wins assumed to move outside the forecast period.
- Weighted bookings
- Expected in-period wins multiplied by average contract value.
Important note
Audit stage hygiene before interpreting coverage; duplicate or stale opportunities can overwhelm the probability assumptions.
Frequently asked questions
Why can proposal expected wins exceed qualification?
Proposal has fewer opportunities but a materially higher win probability.
Are the stage pools cumulative?
No. Each open opportunity must appear in exactly one current-stage count.
What does a 7.02x pipeline multiple mean?
Unweighted open contract value is 7.02 times the target; it does not mean the target is seven times likely.
Should slippage differ by stage?
Often yes. This page uses one shared rate; use a CRM cohort model for stage-specific timing.