Sales Forecast Calculator
Enter your variables — retained customers, known losses, pipeline deals with close probabilities, and rate adjustments — and get an accurate revenue forecast built from real inputs, not a growth rate applied to last year's number.
Forecast Period
How many months are you forecasting?
Prior Period Revenue
Your total revenue for the last full period — the baseline everything is measured against.
Known Lost Customers
Customers you know you've lost or will lose. Revenue is prorated — a customer lost in month 3 costs you 9 months of revenue, not 12.
Mid-Period New Customers
Customers already won this period. Revenue is prorated from the month they came on board — a customer acquired in month 4 contributes 9 months of revenue.
New Customer Pipeline
Prospects not yet closed. Each deal is probability-weighted and prorated from expected close month. A $100K deal at 60% closing in month 6 contributes $35K to a 12-month forecast.
Rate Adjustments
Applied to your retained customer base. Use negative values for declines.
Organic volume change
Cost pass-through
Deliberate price action
One-Time Revenue Events
Non-recurring gains or losses that affect this period only — a contract buyout, a one-time project, a lost deal outside your normal base. Use + for gains, − for losses.
Forecast Result
—
Enter your prior period revenue in the Prior Period Revenue field to see your forecast.
Need a fractional sales leader to own the forecast?
A fractional sales manager installs forecast discipline, pipeline review cadence, and CRM hygiene — without the full-time cost.
Talk to a fractional sales leaderHow the math works
Retained base
(Prior revenue − lost customer annual value) × (period months / 12)
The revenue you can count on from customers you're keeping, scaled to the forecast period.
Lost customer impact
(Annual revenue / 12) × months remaining after loss month
You don't lose the full year — only the months after they left. A customer lost in month 3 costs 9 months of revenue.
New customers (mid-period)
(Annual revenue / 12) × months active from acquisition month
A customer acquired in month 4 contributes 9 months of revenue in a 12-month period.
Pipeline (probability-weighted)
(Annual revenue / 12) × months active from close month × close probability %
Each deal is discounted by its probability and prorated from expected close. A $100K deal at a 60% closing rate in month 6 = $35K.
Run rate adjustment
Retained base × run rate change %
Applied to the retained base only. Captures organic volume changes in existing accounts.
Inflation & price increase
Retained base × rate %
Both applied to retained base. Inflation = cost pass-through. Price increase = deliberate action. They stack.
What makes a sales forecast accurate
Most sales forecasts are wrong for the same reason: they start with a target and work backward.
Enter what you know — the forecast follows
An accurate revenue forecast starts with your actual customer base, not a growth assumption.
Weight your pipeline — don't count it at face value
Pipeline is not revenue. A $100K deal at a 60% close rate expected in month 6 contributes $35K to a 12-month forecast — not $100K.
Layer in the variables you can control
Once you have your retained base and weighted pipeline, add the adjustments you can actually influence.
A forecast is only as good as its review cadence
The businesses that forecast accurately don't have better data — they have a regular review process.
How to interpret your results
Once you run the numbers, look at the breakdown before you look at the total.
Related terms
Key concepts behind how this calculator works
Sales forecast
Pipeline coverage ratio
Run rate revenue
Probability-weighted pipeline
Churn rate
Mid-period proration
Related articles
Frequently asked questions
People also ask
Common questions about sales forecasting from search
Related Tools & Resources
Sales Diagnostics
Identify what is broken in your sales org before you forecast.
Pipeline Capacity Planner
Calculate how much pipeline you need to hit your revenue target.
Fractional Sales Manager
Install forecast discipline without a full-time hire.
Free Sales Training
20-module curriculum covering every stage of the B2B sales process.
Forecasting & Pipeline Articles
How to Improve Sales Forecast Accuracy: Six Root Causes and How to Fix Them
Quarter after quarter you miss the number. The problem isn't your reps' forecasting ability — it's the system underneath the forecast. Here are the six root causes of chronic forecast inaccuracy and what it takes to fix each one.
Read articleHow to Run a Sales Forecast Your Business Can Actually Use
Most sales forecasts are wrong — not because of bad math, but because the inputs are bad. Here is how to build a forecast grounded in pipeline reality.
Read articleWhy Sales Forecasts Are Usually Wrong (And How to Fix Them)
Inaccurate sales forecasts aren't a math problem — they're a process problem. Here are the 6 root causes and the specific fixes that make your pipeline numbers trustworthy.
Read articlePipeline Stage Definitions: How to Stop Guessing Where Deals Really Are
Most pipelines have stage names but no stage definitions. Here is a stage-by-stage framework with written criteria — based on what the prospect has confirmed, not what the rep intends to do.
Read articleHow to Add SKU-Level Visibility to Your Sales Forecast
Purchasing cannot order from a revenue number. They need to know what is in the pipeline by product. Here is how to add SKU-level visibility to your sales forecast without overwhelming your reps or rebuilding your CRM.
Read articleHow to Build a Sales-to-Ops Feedback Loop That Actually Works
Sales and operations talk when something goes wrong. A feedback loop makes them talk before it does. Here is the simple cadence — monthly data shares, a quarterly joint review — that keeps inventory and pipeline data flowing in both directions.
Read article