
Sales Forecast Calculator: Weighted Pipeline & Growth
Free sales forecast calculator: project revenue from your weighted pipeline or growth rate, see your gap to quota, and estimate the commission cost.
Four numbers sit at the top of the results: the most likely forecast, the distance to quota, the pipeline coverage ratio and what the forecast would cost in commission. A scenario table then sets commit and best case side by side. In growth mode, a period-by-period table shows a conservative, an expected and an aggressive projection.
The formulas behind each sales forecast
Underneath the results, the calculator writes out each formula with the figures you entered.
Weighted pipeline by opportunity stage
Forecast = closed-won to date + Σ (open value in each stage × that stage's win probability). A £300,000 opportunity sitting in a 60% stage contributes £180,000. Individual deals will close or slip, but over a large enough pipeline the gains and losses even out.
The commit threshold drives the three scenarios. Commit counts only the stages at or above the threshold, at their weighted value. Most likely takes the whole weighted pipeline. Best case treats commit stages as certain, at 100%, while earlier stages stay weighted.
Run-rate with compound growth
Revenue in period n = current revenue × (1 + g)^n, with g the growth rate for one period. Because growth compounds, 3% a month for 12 months raises the monthly run-rate by roughly 42.6% rather than 36%. To derive g from your history, the tool uses (last period ÷ first period)^(1 ÷ (number of periods − 1)) − 1.
Gap to quota and coverage ratio
Gap to quota = forecast − quota. Pipeline coverage = open pipeline ÷ (quota − closed-won), in other words the number of times the open pipeline covers the revenue still needed. A comfortable ratio can still fall short when most of it sits in early stages such as discovery.
When the quota itself looks unrealistic, work backwards from team capacity with the sales quota calculator.
Worked example: a mid-market SaaS quarter in pounds
Picture a UK SaaS team with a £1,000,000 target for the quarter, of which £300,000 is already closed-won. A further £1,950,000 is open across five stages. The calculator opens with these figures, so every number below can be reproduced on screen.
- Discovery: £600,000 × 10% gives £60,000 weighted
- Qualification: £450,000 × 20% gives £90,000
- Solution demo: £380,000 × 40% gives £152,000
- Proposal: £300,000 × 60% gives £180,000
- Negotiation: £220,000 × 80% gives £176,000
Once weighted, the open pipeline is worth £658,000. Adding the £300,000 already won gives a most likely forecast of £958,000, which is 95.8% of target and £42,000 short. The team still needs £700,000, so coverage stands at £1,950,000 ÷ £700,000 = 2.8×.
With the commit threshold at 60%, only Proposal and Negotiation count towards commit, which comes to £656,000 including closed-won. Best case climbs to £1,122,000. At an effective commission rate of 10%, the commission bill would be £65,600 on commit, £95,800 on the most likely figure and £112,200 on best case.
Growth mode applies the same reasoning to a run-rate. Starting from £250,000 a month and growing 3% each month, revenue reaches £356,440 in month 12. The twelve months total £3,654,448, which clears a £3,500,000 annual target.
Forecasting against the UK payroll calendar and tax year
A UK sales forecast has to line up with three calendars: the payroll month, the company's financial year and the tax year that HMRC works to. Aligning them is what turns a revenue forecast into a cost forecast that Finance can book.
Most UK pay runs are monthly
ONS figures from the Annual Survey of Hours and Earnings show that 77.6% of UK employee jobs had a monthly pay period in April 2021, against 11.6% weekly, 9.3% four-weekly and 1.5% fortnightly (provisional data). A sales team on monthly pay has one payroll cut-off a month for the commission earned on closed deals. Forecasting by month shows what each pay run is likely to carry.
The tax year and the financial year are separate calendars
The UK tax year runs from 6 April to 5 April, and the current one ends on 5 April 2027. A company's financial year is set by the company and does not have to match it. Quotas and forecasts follow the financial year, whereas payroll follows the tax year, with rates and thresholds that change every 6 April.
Commission earned in March, paid after 6 April
HMRC's employer guidance (CWG2) treats commission paid on a separate payday as part of total pay at the time it is paid, no matter when it was earned. A commission earned on a March deal and paid after 6 April therefore falls into the next tax year for National Insurance purposes. For 2026/27, employer Class 1 National Insurance is 15% above the secondary threshold, so the cost of a commission to the business is higher than the payout itself. Check edge cases with your payroll provider or accountant.
Which sales forecasting method suits your team?
No single method is right for every team: the choice depends on how far ahead you are looking and which data you trust. Many B2B revenue teams cross-check two methods.
Weighted pipeline
Relies on a well-kept CRM where every opportunity moves through the same stages. It is the strongest method for the month or quarter in progress, when most of the revenue you need is already visible.
Run-rate and historical growth
Requires between 3 and 12 periods of revenue history. It suits the annual budget, headcount planning and the financial-year plan, all of which look beyond the visible pipeline.
Sales cycle and velocity
Uses average deal value, win rate and cycle length to test whether the open pipeline can close before the period ends. The sales velocity calculator works through that angle.
Machine-learning and multivariable models bring in extra signals, such as deal age or buyer engagement, yet they draw on the same CRM records. Our guide to forecasting techniques compares the options in detail.
The article on effective sales forecasting covers the data and review habits that keep any of these methods reliable.
Improving forecast accuracy
Many sales organisations lack confidence in their own forecast. A 2020 Gartner survey found that only 45% of sales leaders and sellers had high confidence in their organisation's forecasting accuracy. Three practices close much of that gap.
Base stage probabilities on your own win rates
Swap the illustrative probabilities for your historical stage conversion: the opportunities that reached a stage and were won, divided by every opportunity that reached it. Review the figures each quarter, and keep separate sets for segments where deal values vary a lot.
Track forecast accuracy and bias
Forecast accuracy = 1 − |forecast − actual| ÷ actual. Forecasting £900,000 and closing £850,000 gives an accuracy of 94.1% and an over-forecast of 5.9%. Record the direction of the error as well, because optimistic forecasts and sandbagging call for different remedies.
Keep commit, best case and pipeline apart
A single forecast number conceals the risk behind it. Reading the three scenarios together shows how much of the target still relies on opportunities that have not reached a late stage.
Turning the revenue forecast into a commission and accruals forecast
Every pound of forecast revenue that closes creates variable pay, which makes a sales forecast a cost forecast too. Finance needs that figure before the payroll cut-off and before the month-end close.
Put a cost on each scenario
Multiply each scenario by your effective commission rate, which is either total commission paid divided by revenue, or variable pay at target divided by quota. The calculator applies that rate to commit, most likely and best case. To budget by role, with attainment bands and accelerators, move on to the sales commission budget calculator.
Commission accruals at month-end and year-end
Commission is usually earned in one month and paid in a later payroll. Finance records an accrued commission for the amount earned but not yet paid, and the forecast gives an early view of how large that accrual will be. The largest accrual often falls at the financial year-end, when the last quarter's deals are still waiting for payroll.
The accrual may also need to cover employer National Insurance and pension contributions, since commission counts as earnings for workplace pension auto-enrolment under the Pensions Act 2008. Check the exact treatment with your accountant.
Groups reporting under IFRS 15, or under revised FRS 102 where they choose to, may also capitalise some commissions as costs of obtaining a contract. The saas commission calculator explains that treatment, and your accountant can confirm the policy that applies.
Excel template or online calculator?
A sales forecast template in Excel or Google Sheets does the job once the model is fixed. The weighted pipeline is a SUMPRODUCT of values and probabilities, compound growth is =start*(1+rate)^n, and FORECAST.LINEAR draws a straight trend through past periods.
While the assumptions are still moving, a sales forecast calculator is quicker: change one probability or growth rate and all three scenarios recalculate at once. Export the result to CSV and paste it into the spreadsheet that Finance already uses.



