Business
Weighted Sales Pipeline Calculator
Calculate gross pipeline, probability-weighted value by stage, total weighted pipeline, and weighted target coverage. The page includes a stage contribution visual, exact scenarios, operating guidance, limitations, and an exportable calculation record.
Gross pipeline-
Weighted discovery value-
Weighted proposal value-
Weighted negotiation value-
Weighted commit value-
Total weighted pipeline-
Weighted target coverage-
Decision view
Stage-weighted sales pipeline
Stage-weighted sales pipelineGross stage values narrow to their probability-weighted contribution.
Weighted pipeline response to proposal confidenceProposal-stage probability is varied across the exact scenarios while total weighted pipeline is plotted against the same monetary scale.
Exact scenario comparisonProposal probability (%) changes while all other entered assumptions remain constant.
| Proposal probability (%) | Gross pipeline | Weighted discovery value | Weighted proposal value | Weighted negotiation value | Weighted commit value | Total weighted pipeline | Weighted target coverage |
|---|
Period-by-period detail
Stage-weighted pipeline ledger
How to use Weighted Sales Pipeline Calculator
- Enter eligible pipeline value for each mutually exclusive stage.
- Use probabilities calibrated from comparable historical opportunities.
- Review each stage's weighted contribution before the total.
- Compare weighted value with the period target and inspect deal concentration separately.
Calculator guide
Understanding Weighted Sales Pipeline Calculator
A weighted pipeline converts each sales stage into expected revenue using its own probability. Keeping discovery, proposal, negotiation, and commit separate prevents a strong late-stage book from being confused with a large but immature pipeline.
Calculation method
How the calculation works
Weight each named sales stage by its entered probability and reconcile gross pipeline with expected weighted value and target coverage. Each stage value is multiplied by its entered probability. The four weighted amounts are summed, then divided by the period target to calculate weighted target coverage.
Pipeline governance
Audit the stage model before using the total
A defensible weighted pipeline begins with clear stage entry and exit criteria.
Worked situations
Practical examples
- A large discovery-stage pipeline may add little weighted value at a 15% probability.
- A smaller commit-stage book can contribute more than proposal-stage pipeline.
- Increasing proposal probability should be supported by conversion evidence, not forecast optimism.
Better inputs
Useful tips
- Remove duplicate and stale opportunities before entering stage totals.
- Recalibrate probabilities by segment, deal size, and sales-cycle age.
- Pair expected value with a deal-level downside review.
Before relying on the result
Limitations and common mistakes
- Expected values do not guarantee period revenue.
- Opportunity outcomes can be correlated rather than independent.
- Timing, slippage, multi-period contracts, and deal concentration are not modeled.
Reference
Key terms
- Stage probability
- Historical likelihood that an eligible opportunity in a stage becomes revenue.
- Weighted value
- Stage pipeline multiplied by its probability.
- Gross pipeline
- Unweighted value of all entered stages.
- Target coverage
- Weighted pipeline divided by the period target.
Important note
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Frequently asked questions
Why not use one probability for the whole pipeline?
One rate erases stage maturity and can overvalue early opportunities.
Can weighted coverage exceed 100%?
Yes. It means expected weighted value exceeds the target, not that attainment is certain.
Should closed-won deals be included?
No. This calculator is intended for open pipeline; recognized or closed-won revenue should be tracked separately.
How often should probabilities change?
Update them when a sufficiently large comparable cohort shows a durable conversion change.