GUIDE · B2B SALES

How to calculate a weighted sales forecast

Calculate an estimate for a specific month from open deals. See exactly what to change when the buyer moves a decision into the next month.

1,000 credits + 7 days full accessOn first app sign-in · Once per device · No card required

THE SHORT ANSWER

Choose the period and include open opportunities with an expected close date in that period. Multiply each deal’s amount by its chance of winning within that period, then add the results. Show won deals separately and recalculate when an expected close date changes.

UPDATED

· 4 min read · By the Anivo team · Türkçe

01

Start with the deals that could close in the reporting period

Take a snapshot on a stated date. For a June forecast, select open opportunities expected to close in June. Give deals with a missing decision date their own line for review.

Use one definition for the amount, such as the value of the initial order, and one currency. If a deal has alternative quotes for the same purchase, use the amount for the current working scope once.

In this guide the estimate covers the value of future orders that may be won in a period. Use a separate schedule for invoices or cash receipts.

02

Multiply each deal amount by its probability

Weighted deal amount = deal amount × probability. The weighted forecast is the sum of the weighted amounts for eligible open deals.

Three fictional opportunities expected to close in June
Open opportunityOrder amountJune win probabilityWeighted amount
Label print order$12,00050%$6,000
Warehouse signage$8,00025%$2,000
Site maintenance$5,00080%$4,000
Open total$25,000$12,000

Copy the eligible opportunities to their own range. Enter amounts in B2:B4 and probabilities as percentages in C2:C4. Use **=SUMPRODUCT(B2:B4*C2:C4)** or multiply each row and sum the result.

03

Use a comparable past group to estimate the chance of winning

For a stage estimate, take old snapshots at a similar point in the month. Group comparable opportunities by their stage at the snapshot. Count how many won within the target period and divide by all comparable deals that were open in that group at the snapshot.

Once the historical period ends, an opportunity still open after the cutoff counts as a deal that did not win within that period. For example, if 4 of 10 comparable open quotes won by the end of the month, the estimate from that group is 40%. With sparse history, mark your first estimate as an assumption and keep the sample size visible.

Record the reason for an individual exception. For example, the buyer may confirm the decision will move beyond the cutoff. Update the date first when the reporting period changes.

04

Move the deal to the period where the buyer expects to decide

How the June forecast changes when the signage decision moves to July
June viewBefore the date changeAfter the date change
Open order total$25,000$17,000
Weighted open amount$12,000$10,000
Orders already won in June$3,000$3,000
Won plus weighted open estimate$15,000$13,000

The signage deal contributed $2,000 to the June weighted amount. Remove it from June and reassess its likelihood in July. The $3,000 already won stays outside the open calculation.

05

Keep a note that explains the difference between snapshots

FICTIONAL FORECAST UPDATE

Context

“The buyer moved the warehouse signage decision from June to July.”

Forecast note

June weighted open forecast is $10,000. The previous snapshot showed $12,000. Signage moved to July after the buyer confirmed a later review date. Actual June wins remain $3,000. Check the new decision date in the next review.

Save the snapshot date, the input that changed and the reason.

06

Review the estimate and the largest assumptions together

  1. Keep the original snapshot.

    Record its date, period, included deals and probabilities so you can reproduce the total later.

  2. Review large opportunities separately.

    Show what the total would be if a large deal slips or closes. Use the buyer’s latest decision evidence when choosing the scenarios.

  3. Compare the same measure after the cutoff.

    Compare the snapshot’s won plus weighted open estimate with the value of orders actually won in the same period. Keep a note if new deals appeared after the snapshot.

When you have too few records for credible probabilities, show the named deals and plausible scenarios side by side. A weighted total is easier to use when the reader can inspect the assumptions behind it.

FAQ

Frequently asked questions

Keep the period, deal values and probabilities consistent.

What is a weighted sales forecast?

It adds up open deal amounts after multiplying each one by its estimated chance of winning within the chosen period.

How do I calculate it in Excel?

Copy the eligible open deals into their own range. Enter their amounts and probabilities as percentages, then use SUMPRODUCT to add their row-by-row products.

Which date determines if a deal is included?

Use the expected decision or close date for the deal and the start and end dates of the period. Review missing dates separately.

Do closed-won deals go into the weighted amount?

Show won amounts in their own line. Add them once if your report also shows an estimate for the full period.

How do I choose a stage probability?

Start with comparable historical deals from the same stage and a similar time horizon. Use their share of wins within the cutoff or clearly label your starting assumption.

How do I handle different currencies?

Convert to one reporting currency using a documented rate and date, or show separate forecasts per currency.

SOURCES

Sources and example notes

All opportunities, amounts, dates and probabilities are fictional. The calculation can be done by hand or in a spreadsheet.

YOUR FIRST MARKET IS WAITING

Keep the forecast evidence with each opportunity

Use stages and notes in Anivo to record what changed, then calculate the weighted estimate in your spreadsheet.