Skip to content
ENExplore Calculators

Sales Forecast Calculator

Work out sales forecast instantly with clear inputs, formula shown and shareable results.

About Sales Forecast Calculator

A credible forecast weights each category by its historical close rate rather than trusting the label. Commits rarely close at 100%, and best-case deals close far less often than optimism suggests.

Formula

Weighted forecast

Forecast = commits × commit close rate + best case × best case close rate

Worked example

With the default values below, Sales Forecast Calculator returns Weighted Forecast of $3,095,000.00. Change any input above and every figure here is recalculated in your browser.

Inputs used

Committed Dealsminimum 0
2,200,000
Best Case Dealsminimum 0
3,500,000
Historical Close Rate On Commitsaccepts 10–100 %
85 %
Historical Close Rate On Best Caseaccepts 1–100 %
35 %

Results

Weighted Forecast
$3,095,000.00
Expected From Committed Deals
$1,870,000.00
Expected From Best Case Deals
$1,225,000.00
Upside If Everything Closes
$2,605,000.00

Step by step

  1. 1Values used
  2. 2Weighted forecast
  3. 3Weighted Forecast= 3,095,000.00
  4. 4Expected From Committed Deals= 1,870,000.00
  5. 5Expected From Best Case Deals= 1,225,000.00
  6. 6Upside If Everything Closes= 2,605,000.00

Assumptions and limits

  • The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
  • In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
  • Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
  • Figures are estimates based on the inputs given. Marketing performance, platform fees and conversion behaviour vary by audience, channel and season. Use this as a planning guide, not a forecast.
  • This is an estimate for general information and not professional financial, tax or legal advice. See the full disclaimer for the limits that apply to this kind of calculator.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Figures are estimates based on the inputs given. Marketing performance, platform fees and conversion behaviour vary by audience, channel and season. Use this as a planning guide, not a forecast.

Frequently Asked Questions

Why not just add the commits?

Because historically some slip or vanish. Applying the observed close rate removes the systematic optimism.

How are the rates obtained?

From your own closed history by category over several quarters, not from published benchmarks.

Related Calculators

Sales Forecast Calculator – Calculate Weighted Forecast