Free sales forecast calculator for 2026: stage-weighted pipeline forecast timed to your sales cycle, win rate, pipeline coverage and the pipeline needed to hit quota; revenue growth rate, annualized and projected with bands; customer retention rate, churn, lifetime and churned revenue.
Pipeline, win rate and quota: list each pipeline stage with its open value, the historical probability that a deal at that stage closes, and the deal count. Add the quota for the period, the deals won and lost in the trailing period (for the win rate), the average sales cycle, the forecast window and the average deal size. You get the stage-weighted forecast, the share expected to close inside the window, win rate, pipeline coverage, the gap to quota and how much new pipeline closes it.
Revenue growth and projection: enter the previous and current period revenue and the period length. You get growth, the annualized and monthly compound rates and the doubling time, then a projection for as many periods as you like at the measured rate or one you choose, with an optimistic and conservative band.
Customer retention and churn: enter customers at the start and end of the period and the new customers added. You get the retention and churn rates, their annualized versions, average customer lifetime, the customers needed just to stand still, and, with a revenue-per-customer figure, what the churn costs.
Links from the old revenue forecast, pipeline, win rate, revenue growth and customer retention pages open the matching tab; each tab keeps its own history.
A stage-weighted forecast multiplies each open deal by the chance that deals at that stage have historically closed, which is a better estimate than total pipeline times a blended win rate because late-stage deals are worth more than early ones. The timing factor then removes the part of the weighted pipeline that cannot close inside the window given the sales cycle. Growth compounds, so the same percentage measured over a month and over a year are very different rates; the calculator restates both and projects with a band because small differences in rate compound into large differences in outcome. Retention excludes new customers so that acquisition cannot disguise churn, and the inverse of monthly churn gives the average lifetime that feeds customer lifetime value.
Qualified $600,000.00 × 10% = $60,000.00; Discovery / demo $500,000.00 × 25% = $125,000.00; Proposal $400,000.00 × 50% = $200,000.00; Negotiation $250,000.00 × 75% = $187,500.00; Verbal commit $150,000.00 × 90% = $135,000.00. Weighted pipeline $707,500.00 on $1,900,000.00 open (37%). Win rate 25 ÷ 85 = 29.4%; coverage 3.2×. Forecast $707,500.00, $107,500.00 ahead of quota.
Only 45 ÷ 90 = 50% of the weighted pipeline can close in time: forecast $353,750.00. Against $900,000 the gap is $546,250.00; at a 29.4% win rate and the timing factor, about $3,714,500.00 of new pipeline is needed now.
Growth 20.0% ($200,000.00), monthly compound 1.53%, doubling time 3.8 years. Three-year projection at 20%: $1,440,000.00 → $1,728,000.00 → $2,073,600.00; conservative $1,825,050.00, optimistic $2,343,750.00.
$100,000 to $105,000 in a month is 5% monthly, 79.6% annualized. Twelve more months at 5% with a ±2-point band: $149,704.89 / $188,564.91 / $236,480.12.
Retained = 480 − 50 = 430; retention 430 ÷ 500 = 86.0%; churn 14.0% (70 customers). Annualized retention 16.4%; lifetime 7.14 months; churned revenue $8,400.00 this month, ≈ $602,154.25 a year at $120 per customer.
| Stage | Open value | Close probability | Weighted value | Share of pipeline |
|---|---|---|---|---|
| Qualified | $600,000.00 | 10% | $60,000.00 | 32% |
| Discovery / demo | $500,000.00 | 25% | $125,000.00 | 26% |
| Proposal | $400,000.00 | 50% | $200,000.00 | 21% |
| Negotiation | $250,000.00 | 75% | $187,500.00 | 13% |
| Verbal commit | $150,000.00 | 90% | $135,000.00 | 8% |
| Total | $1,900,000.00 | 37% | $707,500.00 | 100% |
Win rate 29.4% (25 won of 85 closed), coverage 3.2×, forecast $707,500.00 against a $600,000 quota: $107,500.00 ahead. Pipeline needed for quota at this win rate: $2,040,000.00, about 20 deals at $30,000.
| Stage | Typical probability | What has happened |
|---|---|---|
| Lead / qualified | 5 – 15% | Fit confirmed, first conversation held |
| Discovery / demo | 20 – 30% | Need and budget established, product shown |
| Proposal / quote sent | 40 – 60% | Price and scope on the table |
| Negotiation | 70 – 80% | Terms being agreed, decision-maker engaged |
| Verbal commit / contract out | 85 – 95% | Buyer has said yes; signature pending |
Probabilities should come from your own data: deals that reached this stage ÷ deals that went on to close. If the stage-weighted forecast and the win-rate forecast disagree by much, the stage probabilities are stale.
| Year | Conservative (15%) | Base (20%) | Optimistic (25%) |
|---|---|---|---|
| Now | $1,200,000.00 | $1,200,000.00 | $1,200,000.00 |
| +1 | $1,380,000.00 | $1,440,000.00 | $1,500,000.00 |
| +2 | $1,587,000.00 | $1,728,000.00 | $1,875,000.00 |
| +3 | $1,825,050.00 | $2,073,600.00 | $2,343,750.00 |
A 5-point band on the growth rate is a $518,700.00 spread after three years. Doubling time at 20%: 3.8 years.
The example carries $1,900,000.00 of open deals. Multiplying by the 29.4% historical win rate gives $558,823.53; weighting each stage by its own close probability gives $707,500.00. The weighted figure is higher here because $400,000.00 of the pipeline is already in negotiation or verbal commit. When the two disagree, the mix of the pipeline is telling you something the blended win rate cannot.
Timing matters as much as probability. With a 90-day cycle and a 90-day window the whole weighted pipeline can close in time; cut the window to 45 days and only half of it can, so the forecast falls to $353,750.00. Against a $900,000 quota that leaves a $546,250.00 gap, and because new deals need a full cycle to close, the calculator's estimate of pipeline to add now balloons to $3,714,500.00 — a signal that the period cannot be rescued with new pipeline; it had to be sourced a cycle earlier. That is why the "3× coverage" rule of thumb exists: at a 25–35% win rate you need roughly three dollars of open pipeline for every dollar of quota, in place before the period starts.
$1,000,000 to $1,200,000 is 20.0% growth over a year, 1.53% a month compounded, and doubles the business every 3.8 years. The same 5% measured month over month — $100,000 to $105,000 — is 79.6% a year, not 60%, because each month's growth builds on the last; carried forward twelve months at 5% it reaches $188,564.91.
Projections should carry a band. Three years at 20% takes the example to $2,073,600.00; at 15% it is $1,825,050.00 and at 25% it is $2,343,750.00. Plan costs on the conservative line and hiring on the base line; the optimistic line is for capacity planning, not budgets.
The retention example starts a month with 500 customers, adds 50 and ends with 480. Net growth looks like -4.0%, but 70 customers left: 14.0% monthly churn, 86.0% retention. Compounded, that is 16.4% annual retention — only 82 of today's 500 customers will still be there in a year without new ones — and an average customer lifetime of 7.14 months. At $120 a month per customer the churn costs $8,400.00 this month and roughly $602,154.25 over a year.
Small changes compound here too. Losing 55 customers instead of 70 (89.0% retention) lifts annual retention from 16.4% to 24.7%, average lifetime from 7.14 to 9.09 months, and cuts the new customers needed just to stand still from 70 to 55 a month. For a subscription business that is the difference between a sales team that grows the company and one that runs to stay in place.
Find answers to the most common questions about sales forecast calculator.
Multiply the open value at each stage by that stage's historical close probability and add them up: $707,500.00 on the example's $1,900,000.00 of open deals. Then keep only the share that can close inside the forecast window given your sales cycle. Compare the result with pipeline × win rate ($558,823.53 here); a large difference means the stage probabilities need refreshing.
Deals won ÷ deals closed (won + lost) over a trailing period, ignoring deals still open: 25 ÷ 85 = 29.4% in the example. Counting open deals in the denominator understates it. Track it by rep, segment and deal size; the blended number hides most of the signal.
Open pipeline ÷ quota: 3.2× here. The common rule is 3×, which is simply 1 ÷ a 33% win rate; at a 20% win rate you need 5×, at 50% only 2×. The calculator derives the pipeline needed from your actual win rate ($2,040,000.00 for the example quota) rather than the rule.
Gap ÷ win rate, then divided by the share of the window a new deal can use. In the 45-day example the $546,250.00 gap needs about $3,714,500.00 of fresh pipeline because only half a sales cycle remains. Sourcing earlier is always cheaper than discounting later.
Growth = (current − previous) ÷ previous. To restate a period rate as annual, raise (current ÷ previous) to the power of 12 ÷ months in the period and subtract 1: 5% a month is 79.6% a year, not 60%. The calculator shows the period, annual and monthly rates together so they are never confused.
Revenue × (1 + rate) raised to the number of periods. $1,200,000 at 20% for three years is $2,073,600.00. Add a band of a few points either side: compounding turns a small uncertainty in the rate into a wide range of outcomes ($1,825,050.00 to $2,343,750.00 here), and that range is the honest forecast.
(Customers at end − new customers) ÷ customers at start, so that acquisition cannot hide churn: (480 − 50) ÷ 500 = 86.0% in the example. Churn is 1 minus that. Measure it over a consistent period and annualize with the exponent, not by multiplying by 12.
It depends on the business: consumer subscriptions often lose 3–7% of customers a month, small-business software 1–3%, enterprise software under 1% a month (annual retention above 90%). Because the rates compound, the useful comparison is annual retention and average lifetime, which the calculator shows; even a point of monthly churn is worth a lot of lifetime value.
They are the three tabs of this page: pipeline, win rate and quota together, because one feeds the other; growth and projection together; and retention. Their links open the right tab and each tab keeps its own saved history.
| Stage | Open value | Close probability | Deals | Weighted | |
|---|---|---|---|---|---|
$ | % | $60,000.00 | |||
$ | % | $125,000.00 | |||
$ | % | $200,000.00 | |||
$ | % | $187,500.00 | |||
$ | % | $135,000.00 |
For the historical win rate
Quarter = 90
Forecast for the next 90 days
$707,500.00
weighted pipeline $707,500.00 · quota $600,000.00 → $107,500.00 ahead
Total open pipeline
$1,900,000.00
56 deals
Historical win rate
29.4%
25 won / 85 closed
Pipeline coverage
3.2×
open pipeline ÷ quota (3× is the usual rule)
Pipeline needed for quota
$2,040,000.00
≈ 20 deals at $30,000.00
| Stage | Open value | Probability | Weighted | Share of pipeline |
|---|---|---|---|---|
| Qualified | $600,000.00 | 10% | $60,000.00 | 32% |
| Discovery / demo | $500,000.00 | 25% | $125,000.00 | 26% |
| Proposal | $400,000.00 | 50% | $200,000.00 | 21% |
| Negotiation | $250,000.00 | 75% | $187,500.00 | 13% |
| Verbal commit | $150,000.00 | 90% | $135,000.00 | 8% |
| Total | $1,900,000.00 | 37% | $707,500.00 | 100% |
Stage-weighted forecast = Σ open value × stage probability. Win-rate forecast (total × 29.4%) = $558,823.53; the two agree when stage probabilities reflect history.