How to Calculate a Sales Forecast: Methods, Formulas, and Examples

• A sales forecast estimates future revenue using pipeline data, historical results, or a combination of both
• The core sales forecasting formula: Forecasted Revenue = Deal Value × Win Rate %
• There are 6 sales forecasting methods — the right one depends on your data maturity and business size
• Clean CRM data makes every method more accurate and removes manual guesswork
• NetHunt CRM automates weighted forecast calculations directly inside your sales pipeline

Sales forecasting separates reactive businesses from proactive ones. Companies with accurate forecasts are 10% more likely to grow revenue year-over-year — and twice as likely to be at the top of their industry. Yet 67% of organizations still lack a formalized approach to the sales forecasting process altogether.

The gap isn't motivation — it's method. Most sales teams either don't know which forecasting method to use, or they're working with sales data that's too messy to trust.

This guide fixes both. You'll learn the core sales forecasting formulas, six proven sales forecasting calculations with real numbers, how to choose the best forecasting method for your business, and how to automate the whole process inside a CRM to produce an accurate sales forecast every time. Whether you want to forecast next month's revenue or build an annual sales plan, the method is the same — and it starts here.

What is a sales forecast (and why it matters)

A sales forecast is a data-driven estimate of the sales revenue your business will generate over a specific period — a month, quarter, or year. It's based on the deals currently in your sales pipeline, their likelihood of closing, and the timing of future revenue.

Done well, sales forecasting isn't just a number on a spreadsheet. It's a decision-making tool that touches almost every part of the business. Sales leaders use it to set realistic sales goals and targets, finance teams use it to inform decisions about budgeting and resource allocation, and sales management uses it to track sales results and performance against goals. A forecast predicts not just revenue but the business outcomes that depend on it — hiring plans, marketing spend, and sales capacity.

Here's what an accurate sales forecast enables:

• Budget planning. Finance teams use forecasts to allocate spend, plan headcount, and set realistic sales targets.
• Quota setting. Sales leaders can assign fair, data-backed sales quotas instead of guessing.
• Inventory management. For businesses selling a product or service, forecasts prevent overordering or running out of stock.
• Investor confidence. A solid, defensible sales forecast signals business maturity to investors and boards.
• Identifying risk early. A forecast that's trending below target gives you 60 days to act — not six.

The further out you can see, the more time you have to course-correct. That's why modern sales forecasting is one of the highest-leverage activities a sales leader can invest in.

The core sales forecasting formula

Before diving into methods, here's the formula that underpins most sales forecasting approaches:

• Forecasted Revenue = Total Deal Value × Win Rate %

Example: If you have a $10,000 deal in the contract stage and your historical close rate at that stage is 80%, the forecasted value of that deal is:

$10,000 × 80% = $8,000

Add up the weighted values of every deal in your sales pipeline, and you have your total sales forecast for that forecast period. This weighted sum is essentially your sales run rate — a baseline for forecasting sales going forward and tracking whether you're on track to hit your sales goals.

For historical or top-down forecasting, a different sales forecasting formula applies:

• Forecasted Sales = Previous Period Sales × (1 + Expected Growth Rate)

Example: If your monthly sales revenue was $500,000 last month and you typically grow at 10% month-over-month:

$500,000 × 1.10 = $550,000

Both sales forecasting formulas are simple in isolation. The complexity — and the accuracy of your sales forecast — comes from how you gather the inputs and which forecasting method you use to structure the calculation. When creating a forecast, the goal is to predict future sales and sales outcomes as precisely as your data allows. That's what the next section covers.

How to calculate sales forecasts: 6 sales forecasting methods

There's no single best forecasting method. The right approach depends on how long you've been in business, the quality of your sales data, and the complexity of your sales cycle. Here are the six most widely used sales forecasting methods, each with a formula and a worked example to make the sales forecasting calculations concrete.

1. Opportunity stage forecasting method

Best for: Businesses with defined pipeline stages and historical CRM data — typically B2B companies and SaaS sales teams.

This is the most common method for sales teams with an active pipeline. Opportunity stage forecasting assigns a close probability to each stage of your sales process, based on historical win rates. Deals that are further along carry a higher probability of closing. If you haven't yet defined your pipeline stages, start with setting up your first sales pipeline before applying this method.

Formula:

• Forecast = Σ (Deal Value × Stage Probability %)

Example:

Pros:

• Simple to set up and run
• Relatively objective — based on historical sales data, not gut feel
• Works at any pipeline size

Cons:

• Doesn't account for deal age (a stale deal in "Proposal" still gets 60%)
• Probabilities can be miscalibrated if your historical data is limited
• Ignores deal-specific factors like lead quality or sales rep performance

2. Historical forecasting method

Best for: Established companies with at least one year of consistent sales data and predictable sales growth patterns.

This method extrapolates from past sales performance. If your business grows steadily and seasonality is predictable, historical forecasting gives you a fast, reliable baseline. It's also useful for validating projected sales figures generated by more complex models.

Formula:

• Forecasted Sales = Previous Period Sales × (1 + Growth Rate)

Example: Your sales team closed $120,000 in monthly sales last month. Based on the past 12 months, you typically grow at 5% month-over-month.

$120,000 × 1.05 = $126,000

For an annual sales forecast with inflation adjustment:

$450,000 (last year) + ($450,000 × 0.05 growth) = $472,500

Pros:

• Fast and easy to calculate
• Doesn't require detailed pipeline data
• Good baseline for sense-checking more complex sales projections

Cons:

• Ignores seasonality unless you account for it manually
• Falls apart during market conditions shifts or rapid sales growth phases
• Doesn't reflect current sales pipeline health

3. Sales cycle length forecasting method

Best for: B2B and SaaS sales teams with a consistent, trackable sales cycle length.

Instead of focusing on pipeline stage, this forecasting method uses time as the proxy for close probability. The further a deal has progressed through your average sales cycle, the more likely it is to close — and the more it contributes to your forecast for the period.

Formula:

• Probability = Days in Pipeline ÷ Average Sales Cycle Length Expected Revenue = Deal Value × Probability

Example: Your average sales cycle is 60 days. A deal that entered your sales pipeline 30 days ago:

30 ÷ 60 = 50% probability

If the deal value is $40,000:

$40,000 × 50% = $20,000 weighted forecast

Pros:

• Objective — doesn't rely on sales rep judgment
• Works across multiple lead sources with different sales cycles
• Highlights deals that are overdue relative to their expected close date

Cons:

• Requires accurate tracking of when deals enter your pipeline (needs a CRM)
• Doesn't account for deal size or quality differences
• A paused deal inflates its apparent probability

4. Bottom-up forecasting method

Best for: Startups launching new products, sales teams entering new markets, or businesses with limited historical sales data.

Rather than looking at past sales performance, bottom-up forecasting builds a sales projection from the ground up — starting with your addressable market and working through estimated conversion rates to reach expected sales.

Formula:

• Sales Forecast = Estimated New Customers × Average Deal Value

Example: You estimate reaching 200 potential new customers this quarter. Based on similar products and services, your expected average deal value is $150.

200 × $150 = $30,000

For a B2B version:

If you have 50 qualified leads, a 20% close rate, and an average deal value of $5,000:

50 × 20% × $5,000 = $50,000

Pros:

• Works without historical sales data
• Forces a structured view of your go-to-market assumptions
• Useful for new product launches and investor projections

Cons:

• Highly dependent on the accuracy of your market estimates
• Easy to be overly optimistic about reachable customers and close rates
• Doesn't reflect real sales pipeline dynamics

5. Intuitive forecasting method

Best for: Early-stage startups with zero historical data and small, experienced sales teams.

The simplest forecasting method — ask your sales reps to estimate the likelihood and size of each deal they're working on. This relies on the expertise and pattern recognition of the people closest to the deals.

Method: Sales management asks each sales rep: "How confident are you this deal closes this quarter, and for how much?" Responses are aggregated into a team sales forecast.

Pros:

• Works immediately, even without any sales data
• Captures qualitative intelligence that CRM data can't (relationship strength, internal champion, budget cycle)
• Fast to produce

Cons:

• Highly subjective — sales reps tend to be optimistic
• No scalable way to verify individual estimates
• Sales forecast accuracy varies dramatically by rep experience

The only way to make intuitive forecasting reliable is to pair it with disciplined CRM logging — so sales leaders can cross-reference rep predictions against actual sales pipeline activity. Sales automation can help enforce this habit by triggering reminders when deal fields go unupdated.

6. Multivariable forecasting method

Best for: Enterprise sales teams with rich CRM history, RevOps support, and complex deal dynamics.

This is the most sophisticated forecasting method. It combines multiple data inputs — stage probability, time in pipeline, sales rep historical win rate, deal size, lead source, and external factors — into a single weighted sales forecast. Most teams use dedicated forecasting software or predictive analytics tools to run this model.

Method: Assign weights to multiple variables and calculate a composite probability for each deal to forecast future sales.

Example:

Applied to a $50,000 deal: $50,000 × 71% = $35,500

Pros:

• Highest sales forecast accuracy of all methods
• Reduces the impact of sales rep subjectivity
• Surfaces at-risk deals before they slip

Cons:

• Requires clean, comprehensive CRM data
• Complex to set up without dedicated forecasting software
• Needs regular recalibration as market conditions change

How to choose the right sales forecasting method

The best forecasting method is the one your sales team will actually use consistently — and that matches the sales data you have available today.

• If you're a startup with no data: Start with intuitive forecasting and document everything in a CRM from day one. Switch to opportunity stage forecasting as soon as you have 3–6 months of sales pipeline data.
• If you're an SMB with an active pipeline: Opportunity stage forecasting is your best starting point. It's simple, effective, and improves as your historical sales data grows. You can use a sales forecast template in a spreadsheet to get started before moving into CRM automation.
• If you're a scaling B2B team: Combine opportunity stage with sales cycle length forecasting. The two methods complement each other — one tracks pipeline position, the other tracks time. Together, they give you a more realistic view of expected sales for each period.
• If you're an enterprise team: Invest in multivariable or predictive analytics-powered forecasting. The complexity is justified by the sales forecast accuracy gains at scale.

Most mature sales teams don't pick just one forecasting method. They run opportunity stage forecasting as their baseline and layer in historical trend data to sense-check current sales projections.

How to use sales forecasting in NetHunt CRM (step-by-step)

NetHunt CRM is built inside Gmail, which means every email interaction with a lead is automatically logged to the right deal record. That solves the biggest forecasting problem most sales teams face: incomplete data. When every touchpoint is captured automatically, your close probabilities are based on real sales pipeline activity — not what reps remember to log.

Here's how to set up automated opportunity stage forecasting in NetHunt to calculate sales forecasts without manual effort:

Step 1: Add the right fields to your Deals folder

Go to Settings → Folder and field management → Deals. Add two fields:

• Deal Value (Currency field type)
• Close Probability (Percentage field type)

Step 2: Create a Weighted Forecast formula field

Add a third field of type Formula. Name it "Weighted Forecast" and set the formula to:

• [Deal Value] * [Close Probability]

NetHunt will now automatically run the sales forecasting calculation for every deal as you update the deal value or probability.

Step 3: Build your Pipeline view

Switch to the Card (Kanban) view in your Deals folder, grouped by Stage. Customize the card layout to display the Weighted Forecast field on each deal card — so you can see projected sales at a glance as deals move through your pipeline.

Step 4: Summarize by stage

Click the Summary option on the Weighted Forecast field. NetHunt will display the total weighted forecast for each pipeline stage — giving you an instant, always-updated snapshot of future sales revenue by stage.

Step 5 (Advanced): Connect to Google Looker Studio

For trend visualization and linear regression forecasting, connect NetHunt to Google Looker Studio. Set "Closing Date" as your dimension, add Deal Count and Weighted Forecast as metrics, and plot a trend line. Looker Studio will extrapolate the sales forecast forward based on your historical pattern — giving you a visual sales projection you can share with leadership or use in your business plan.

Because NetHunt lives in Gmail, your CRM sales data stays current without any manual effort from reps. That's what makes the forecast reliable — not just the sales forecasting formula, but the quality of the data feeding it.

How to improve the accuracy of your sales forecast

The formula matters less than the data going into it. Here's what separates accurate sales forecasts that sales teams trust from the ones they ignore:

Clean sales pipeline data. Use Required Fields for Stages in NetHunt to enforce data quality. If a deal can't move to "Proposal" without a budget and close date entered, your sales forecast will always have the inputs it needs to be accurate.

Realistic close probabilities. Don't assign probabilities based on optimism — base them on your actual historical win rates by stage. Pull a Pipeline Report in NetHunt to see what percentage of deals at each stage actually close. That's how you improve sales forecast accuracy over time.

Regular updates. A forecast is only as good as its last update. Set a weekly cadence for sales reps to review and update their deal statuses. The Time-in-Stage Report in NetHunt flags deals that have been sitting in one stage longer than average — a reliable signal that the deal is at risk and your current sales projections may be too optimistic.

External factors adjustment. No sales forecasting formula accounts for a market downturn, new competitors entering your space, or an unexpected enterprise deal closing early. This is where sales forecasting can help beyond just the numbers — it forces you to regularly assess what's changing in your market. Build a 10–15% buffer into your forecast and adjust monthly based on what's happening outside your pipeline.

Sales team alignment. Sales reps who understand how their CRM activity feeds the sales forecast are more diligent about logging calls, emails, and meetings. NetHunt's Gmail integration makes this automatic — but the sales team still needs to know why it matters for overall sales performance.

Common sales forecasting mistakes that kill forecast accuracy

Even with the right forecasting method and clean data, these are the mistakes that skew sales forecasts most often:

1. Using gut feel instead of stage probabilities. "I have a good feeling about this one" is not a sales forecast input. Assign probabilities based on historical close rates, not sales rep optimism. Intuitive forecasting is a starting point for new businesses, not a long-term sales forecasting strategy.

2. Never updating the forecast. A forecast built in January and never revised is fiction by March. Market conditions shift, deals stall, and new opportunities appear. Build weekly review into your sales management process.

3. Ignoring deal age. A deal that's been in "Negotiation" for 90 days when your average sales cycle is 30 days is far less likely to close than the stage probability suggests. Use the Time-in-Stage Report in NetHunt to discount stale deals and keep your projected sales realistic.

4. Relying on a single forecasting method. Opportunity stage forecasting tells you where deals are in your sales funnel. Historical forecasting tells you where your sales growth is trending. Using only one gives you half the picture.

5. Treating all pipeline stages as equal. A lead that just entered discovery and a deal one week from signing should not carry the same weight in your sales forecast. If your probabilities aren't calibrated to actual win rates, your forecast will consistently miss sales targets.

6. Skipping the CRM. Sales teams that track deals in spreadsheets miss the compounding sales analytics that make forecasts more accurate over time. Every month of clean CRM data makes next month's sales forecast more reliable. Modern sales forecasting is built on CRM data — there's no substitute.

Sales forecast FAQ