Sales & marketing
Weighted sales pipeline Calculator
Apply stage win probabilities to the value of open opportunities. This free weighted sales pipeline calculator shows the calculation and its assumptions so you can compare your own figures.
Your results
Apply stage win probabilities to the value of open opportunities.
Stages · 4 rows
| Stage | Stage Revenue | Probability Percent | Expected Stage Revenue |
|---|---|---|---|
| Prospect | €100,000.00 | 10% | €10,000.00 |
| Qualified | €80,000.00 | 25% | €20,000.00 |
| Proposal | €60,000.00 | 50% | €30,000.00 |
| Negotiation | €40,000.00 | 75% | €30,000.00 |
Assumptions and estimates
- Deals appear once, in their current stage. Stage probabilities should come from historic outcomes; timing, correlated deals and large single opportunities can make the weighted average misleading.
- Method: Weighted forecast = sum of stage value × stage win probability.
- Each opportunity must appear in one stage only. Use historic probabilities and consider deal timing and correlated outcomes separately.
Useful next steps
- Use Compare options to test an alternative side by side.
- Copy, print or download a record of this calculation when you need one.
Reports open your email app addressed to s@s1.ie with the public page address only. Your inputs are never added.
How the weighted sales pipeline calculation works
Weighted forecast = sum of stage value × stage win probability.
Each opportunity must appear in one stage only. Use historic probabilities and consider deal timing and correlated outcomes separately.
Using this calculator
- Enter your own figures in the labelled inputs. Keep the currencies, units and time periods consistent.
- Choose any applicable rate profile, pattern or assumption shown for this tool. Open additional inputs when relevant.
- Review weighted forecast and pipeline value and weighted probability percent, then read the stated assumptions and eligibility conditions before using the result.
Worked example
This is a static example using illustrative inputs, not facts about you or today’s date. The displayed eligibility selections and assumptions apply only to this example.
See example inputs
- Prospect-stage value (€)
- 100000
- Prospect win probability (%)
- 10
- Qualified-stage value (€)
- 80000
- Qualified win probability (%)
- 25
- Proposal-stage value (€)
- 60000
- Proposal win probability (%)
- 50
- Negotiation-stage value (€)
- 40000
- Negotiation win probability (%)
- 75
- Weighted Forecast
- €90,000.00
- Pipeline Value
- €280,000.00
- Weighted Probability Percent
- 32.14%