Expert knowledge for digital decisions
How to Create a Reliable Revenue Forecast?
Short answer
The Calculation
For each opportunity: Value × Probability of the Stage. Adding everything gives the weighted pipeline.
Example: 100,000 euros in the stage "Offer" with a 40 percent historical closing rate results in a forecast of 40,000 euros – not 100,000.
Where the Percentages Must Come From
From your own numbers: Of one hundred opportunities that were in the stage "Offer", how many turned into orders? This rate is the probability.
Percentages estimated by sales are systematically too optimistic. This is not a criticism – sales operates with confidence.
What Destroys the Forecast
- Opportunities without a date. Without an expected closing date, nothing can be distributed over months.
- Zombie opportunities. Opportunities that have remained unchanged for six months inflate the number. Regularly clean up.
- Optimistic values. The value should be the realistic order value, not the maximum variant.
What It Achieves – and What It Does Not
Achieves: an order of magnitude, trends over months, early warning of a shrinking pipeline.
Does Not Achieve: a reliable statement for a single month with few large orders. With five opportunities of 200,000 euros each, every forecast is a coin toss.
The fewer and the larger the deals, the less useful the statistics.
Key facts
- Formula
- Value × historical closing rate of the stage
- Important
- Rates from your own numbers, not estimated
- Limit
- Few large deals cannot be forecasted