Sales Forecast Calculator
Sales Forecast: Forecast = Σ (stage pipeline value × stage close probability). Methodology stated, your own inputs only.
In short
Sales Forecast: Forecast = Σ (stage pipeline value × stage close probability). Methodology stated, your own inputs only.
Formula: Forecast = Σ (stage pipeline value × stage close probability).
What this calculator does
Sales Forecast: Forecast = Σ (stage pipeline value × stage close probability). Methodology stated, your own inputs only. Worked example, questions and limitations included.
Use it to turn Currency (symbol only, never converted), Stage 1 pipeline value, Stage 1 close probability (your figure), Stage 2 pipeline value (blank = none), and the other shown inputs into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this sales calculation.
Inputs and what they mean
- Currency (symbol only, never converted)
- — choice value.
- Stage 1 pipeline value
- — number value.
- Stage 1 close probability (your figure)
- — number value.
- Stage 2 pipeline value (blank = none)
- — number value.
- Stage 2 close probability (your figure) (blank = none)
- — number value.
- Stage 3 pipeline value (blank = none)
- — number value.
- Stage 3 close probability (your figure) (blank = none)
- — number value.
- Stage 4 pipeline value (blank = none)
- — number value.
- Stage 4 close probability (your figure) (blank = none)
- — number value.
How to use it
- Enter each value in the unit shown next to the box (use the unit converter first if your numbers are in other units).
- Check the breakdown to see every intermediate step.
- Read the limitations before relying on the result.
Formula
Methodology: stage-weighted (probability-weighted) pipeline forecast.
Probabilities must come from your own historical stage-to-close rates; no default stage probabilities are used.
It gives an expected value, not a commit or best-case figure.
Forecast = Σ (stage pipeline value × stage close probability).
Inputs used: Currency (symbol only, never converted), Stage 1 pipeline value, Stage 1 close probability (your figure), Stage 2 pipeline value (blank = none), Stage 2 close probability (your figure) (blank = none), Stage 3 pipeline value (blank = none), Stage 3 close probability (your figure) (blank = none), Stage 4 pipeline value (blank = none), and other shown inputs.
Worked example
Four stages
- 40,000 + 90,000 + 120,000 + 90,000 = $340,000.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Up to four stages.
- Expected value; actual results vary.
- Results are educational estimates built only from the figures you enter. They are not personalised investment, tax, legal or accounting advice. Rates, growth and discount assumptions are always yours to choose.
- The result depends on the values you enter for this sales forecast calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Reference: OpenStax
Last reviewed:
Common questions
Where do probabilities come from?
Your CRM history: the share of deals at each stage that eventually closed won. Check the formula, example, and limitations on this page before using the result for a real sales decision.
Commit vs weighted?
Commit forecasts are rep judgements; this is a statistical expected value. Check the formula, example, and limitations on this page before using the result for a real sales decision.
Include only this period's deals?
Yes — only deals expected to close in the forecast period. Check the formula, example, and limitations on this page before using the result for a real sales decision.
How do I use the Sales Forecast Calculator?
Enter the required values for Currency (symbol only, never converted), Stage 1 pipeline value, Stage 1 close probability (your figure), Stage 2 pipeline value (blank = none), Stage 2 close probability (your figure) (blank = none), and the other fields shown. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Sales Forecast Calculator use?
Forecast = Σ (stage pipeline value × stage close probability). The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone.
Can the Sales Forecast Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Sources
Method based on OpenStax.
Cite this page
Free Calculator. (2026, October 15). Sales Forecast Calculator. https://freecalculator.tech/tools/sales-forecast-calculator
"Sales Forecast Calculator." Free Calculator, 15 Oct. 2026, https://freecalculator.tech/tools/sales-forecast-calculator.
Sales Forecast Calculator — Free Calculator, https://freecalculator.tech/tools/sales-forecast-calculator
Related tools
Quota: Quota per rep = target × (1 + over-assignment ÷ 100) ÷ reps. Methodology stated, your own inputs only.
Sales Commission: Flat: commission = sales × rate. Methodology stated, your own inputs only.
Win Rate: Win rate = won ÷ (won + lost) × 100. Methodology stated, your own inputs only.
Conversion Rate: Conversion rate = conversions ÷ starting count × 100. Methodology stated, your own inputs only.
Average Deal Size: Average deal size = total won value ÷ number of won deals. Methodology stated, your own inputs only.
Pipeline Coverage: Coverage = open pipeline ÷ remaining quota. Methodology stated, your own inputs only.