Sales Weighted Forecast Calculator

How to calculate a weighted forecast?

A weighted forecast calculates expected revenue by multiplying the total value of a deal by its probability percentage.

Formula: Weighted Value = Deal Amount × Probability (%)

Using the weighted forecast calculator: an example

Suppose you have a $50,000 Deal Value with a 40% Close Probability.

Step-by-step calculation:

1. Identify the gross Deal Value ($50,000).
2. Determine the probability of closing (40% or 0.40).
3. Multiply $50,000 by 0.40 to get the weighted result ($20,000).

Frequently Asked Questions

What is a 'weighted' forecast?

It is a more realistic view of your pipeline that accounts for the fact that not every deal in your list will close.

When should I update probabilities?

Update percentages whenever a deal moves to a new stage in your sales cycle, such as after a successful demo or contract review.

Does this guarantee revenue?

No, it is a statistical estimate to help with budgeting and resource planning rather than a literal guarantee.