80,000 is the example result. Read it using the units and relationship stated below.
Estimate sales revenue from average deal value, the number of open opportunities and their expected win rate.
Read the forecast as expected value
The forecast estimates revenue under the probabilities entered here. It does not identify which individual deals will close. Use opportunities from one defined pipeline and reporting period. The supplied example produces 80,000. Compare that expected value with the concentration of revenue in a few large deals before making delivery commitments.
What the model includes
Result = [Average deal value] × [Open opportunities] × [Expected win rate] ÷ 100 The forecast is a planning relationship. Closed revenue, bookings and collected cash are different source measures; choose the one represented by the field labels. Compare a forecast with its stage evidence before assigning delivery or hiring commitments. Review the gap by account and owner. Increasing an average deal value on a worksheet is not evidence that the current pipeline can deliver that value.
Example with the supplied inputs
Average deal value: 8000; Open opportunities: 40; Expected win rate: 25. Result: 80,000. The values are illustrative.
Compare one changed input
Average deal value changes from 8000 to 8800. The result becomes 88,000. All other inputs remain fixed.
Calculation rule
Result = [Average deal value] × [Open opportunities] × [Expected win rate] ÷ 100
Inputs and output
| Input | Example value | Entry convention |
|---|---|---|
| Average deal value | 8000 | Use the source quantity represented by average deal value. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Open opportunities | 40 | Use the source quantity represented by open opportunities. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Expected win rate | 25 | Enter expected win rate on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
Output: 80,000 is the example result. Read it using the units and relationship stated below. Use the formula to distinguish a cash amount, count, percentage or ratio.
How to use the page
Collect the inputs
Gather Average deal value, Open opportunities, Expected win rate. Use one period and the units shown in the form.
Run the calculation
Enter the values and select the action. The calculation rule above explains how the inputs produce the result.
Compare a scenario
Change Average deal value on its own, keeping the other inputs fixed. Read both results before changing another assumption.
Worked example
With the example inputs listed above, the result is 80,000.
Change Average deal value from 8000 to 8800 while keeping every other value fixed. The result becomes 88,000. This comparison isolates that input; it does not forecast how other variables will respond.
Check the stated formula, units and limits before using the result in a decision.
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026