Free Weighted Sales Forecast Calculator

What is a weighted sales forecast calculator?

A weighted sales forecast calculator takes every open deal in your pipeline, applies a win probability based on its stage, and adds up the result. The total is the revenue you can reasonably expect, not the revenue you hope for.

Define the terms once. Pipeline is the list of open deals with a value. Stage probability is the share of deals at that stage that you expect to close. Weighted pipeline is deal value multiplied by that probability. Coverage ratio is the total unweighted pipeline divided by your target. Gap is the target minus the weighted forecast.

A deal that has only been qualified is far less likely to close than one the customer has verbally agreed. Count both at full value and your forecast is fiction. Count both at zero until they sign and you cannot plan hiring, ad spend or cash. Weighting sits between those extremes.

The Weighted Sales Forecast Calculator on this page lets you enter four stage rows, each with a deal count, an average value and a probability. It then shows the weighted forecast, a best case and worst case, the unweighted pipeline, the coverage ratio and the gap to target. It runs in your browser. You can use it for a month, a quarter or a single campaign.

The stage probabilities are your inputs, and the forecast is only as good as they are.

Why does forecasting matter for Indian sales teams?

Forecasting matters because decisions about people, spend and cash depend on it, and most Indian sales teams make those decisions on gut feel.

A real estate developer must decide how much to spend on Meta lead ads next month. A coaching institute must decide how many counsellors to keep before admission season. A manufacturer quoting to buyers found on IndiaMART must plan raw material and dispatch. Each decision runs on a revenue expectation, and a wrong one means wasted spend or missed capacity.

Gut feel fails in predictable ways. Reps are optimistic about deals they have worked hard on. A deal sits at "interested" for weeks and still feels alive. Managers add up the full value of everything open and call it the pipeline. Then the month ends and the number is half of what was promised. Nobody learns anything, because there was no stage level logic to compare against.

Weighted forecasting gives you a method that can be wrong in a useful way. If you forecast ₹21,16,000 and close ₹15,00,000, you can ask which stage probabilities were too high. Over a few months you adjust them and the forecast gets better. A gut feel number gives you nothing to adjust.

Indian sales cycles add noise. Festival seasons, admission windows and financial year end shift conversion, and bank finance delays bookings. Keep separate probability sets for busy and slow periods if your history shows a difference.

Weighted forecasts also depend on clean pipeline data. A deal with no owner or no next follow up date should not be counted at full stage probability. Run your open deals through the Stuck Deals Finder before you forecast, so stale deals are reviewed rather than counted.

How to use the Weighted Sales Forecast Calculator

Set aside fifteen minutes and use real pipeline numbers from your CRM or tracker.

1. Name your stages. Use the stages your team actually uses. The tool starts with Qualified, Proposal or visit done, Negotiation and Verbal commit. Rename them to match your process.
2. Enter the number of deals in each stage. Count open deals only. Exclude lost deals and anything with no activity that you would not defend in a review.
3. Enter the average deal value. If values vary a lot, split a stage into two rows or use a conservative average. The tool lets you set a different value per stage.
4. Set a probability for each stage. Use your own history: of the deals that reached this stage in the last two or three quarters, what share closed? If you have no history, start with a cautious guess and mark it for review.
5. Enter your target. Use the same period as the pipeline. If the pipeline closes this quarter, use the quarterly target.
6. Read the outputs. Check the weighted forecast, best and worst case, coverage ratio and gap.
7. Copy the result. Paste it into your weekly review or share it with finance.

After you read the result, ask three questions. Is the forecast within reach of the target? Does the best case reach it? Which stage holds the most expected revenue? The answer to the third tells you where the manager's attention should go this week. If you also want to translate the target into calls and visits, use the Sales Target to Daily Activity Calculator.

How is a weighted sales forecast calculated?

You calculate it by multiplying deals, average value and probability for each stage, then adding the stages together.

The formula line is:

weighted forecast = sum of (deals x average value x stage probability) across stages

Related measures:

• Unweighted pipeline = sum of (deals x average value)
• Coverage ratio = unweighted pipeline / target
• Gap to target = target minus weighted forecast
• Best case = the same formula with each probability raised by 10 percentage points, capped at 100%
• Worst case = the same formula with each probability cut by 10 percentage points, floored at 0%

Inputs explained:

• Deals. Open opportunities at that stage right now.
• Average value. Expected contract, booking or fee amount in rupees.
• Probability. The share of deals at that stage you expect to close in the forecast period.
• Target. The revenue you need to hit.

The tool's default rows give a feel for the shape:

Assumptions to be honest about. First, stage probabilities are assumptions you supply, not facts, and benchmarks vary by industry, so use your own data. Second, the model treats each deal in a stage as equally likely, which hides big differences between deals. Third, it assumes the pipeline closes within the period you chose. A deal that closes next quarter should not be weighted into this quarter. Fourth, the plus or minus 10 point range is a simple stress test, not a statistical confidence interval.

Worked example: a four stage forecast against a ₹25 lakh target

This example uses the defaults loaded when you open the tool. The numbers are illustrative inputs, so treat the stage probabilities as assumptions for a team that sells services or admissions at an average of ₹80,000.

The weighted forecast is ₹4,80,000 + ₹7,20,000 + ₹5,76,000 + ₹3,40,000 = ₹21,16,000. The unweighted pipeline is ₹85,60,000 across 107 deals. With a target of ₹25,00,000, the coverage ratio is 85,60,000 / 25,00,000 = 3.42x, and the gap to target is ₹3,84,000.

Now read it properly. A coverage ratio of 3.42x looks comfortable, yet the forecast reaches only about 85% of target. The reason is the shape of the pipeline. The Qualified stage holds 56% of pipeline value but contributes only about 23% of the forecast. Negotiation and Verbal commit together hold ₹13,60,000 of pipeline but contribute ₹9,16,000, or about 43% of the forecast. Late stage deals carry the number.

The range matters too:

The target sits between base and best. That means you will hit it only if probabilities run a little better than your assumptions, or if you move deals forward.

What would close the gap of ₹3,84,000? Moving one Proposal deal to Negotiation adds ₹80,000 x (60% minus 30%) = ₹24,000 of forecast. You would need 16 such moves. Alternatively, adding 4.8 deals at full value does it. The work this tells you to do is progress deals, not add more unqualified leads.

How do you read your result?

Read four things in order: the forecast against target, the range, the coverage ratio and the stage mix. Together they tell you whether you have a number problem, a pipeline problem or a conversion problem.

Here is how to interpret each.

• Forecast above target. You are on track if probabilities are right. Check that your late stage deals are real and dated.
• Forecast below target but best case above it. You have a recoverable gap. Focus on moving deals from the middle stages.
• Best case below target. You have a pipeline problem. No amount of coaching on current deals will fix it, so add qualified leads or lower the target.
• High coverage with low forecast. You hold plenty of early stage deals that rarely close. This is common when ad leads are plentiful and qualification is weak.
• Low coverage with high forecast. The forecast depends on a few advanced deals. One slip changes the month.

Coverage is a rough guide only. If your history shows you close about a quarter of pipeline value, you need about 4x coverage. That is an illustration, not a benchmark.

Do not read the range as a promise. Real life rarely shifts every stage by the same 10 points.

Weighted sales forecasting by industry

Every industry has a different stage structure and different reasons for deals to stall. Adapt the stages and probabilities to the way your customers buy.

Real estate

Stages often run enquiry, site visit booked, site visit done, negotiation and booking. The visit is the big filter, so the probability jump from visit done to negotiation is large. Deal values are high, so one booking moves the forecast. Split projects into separate rows and lower the probability when bank loan sanction is pending.

Education: schools, colleges, EdTech and study abroad

Forecast by intake. Stages may run counselled, demo or campus visit, applied and fee paid. Values are lower but counts are higher, so averages are stable. Study abroad cycles are longer, with documents and visas, so use separate rows per intake.

Manufacturing and B2B

Deals are larger and slower, so the forecast period matters. Stages may be requirement captured, quote sent, sample or trial and purchase order received. Use a different average value per row, since order sizes vary widely. Discount heavily any quote with no follow up in several weeks.

Healthcare and clinics

Treatment plans and packages create the revenue. Stages may be appointment booked, visited, treatment plan given and started. Multi session treatments mean revenue arrives over time, so decide whether to forecast package value or cash received this month, and stay consistent.

Automotive

Stages run test drive booked, test drive done, quote and booked. Delivery depends on stock and finance approval, so separate bookings from deliveries and forecast each. Exchange valuation and bank approvals delay closure.

Insurance and financial services

Stages may be needs analysis, quote, documents and policy issued. The gap between documents submitted and policy issued depends on underwriting and medical checks. Keep renewals in their own rows, apart from new business.

SMBs and services

Small teams have few deals, so one large proposal swings the month. Use fewer stages: proposal sent, negotiation and verbal yes. Add a row for retainers already agreed if you have them. Review weekly and drop deals that go quiet for a month.

What mistakes do teams make with sales forecasting?

Most forecasting errors come from dirty data and wishful probabilities, not from the formula. Avoid these.

• Guessing probabilities. Numbers copied from a blog or a competitor do not describe your funnel. Calculate them from your own closed and lost deals.
• Counting stale deals. A deal untouched for weeks still sits in Negotiation on paper. Remove or downgrade it.
• Using the same probability for every deal. A deal with a dated next step is not the same as one without.
• Ignoring time. A deal that will close next quarter is not part of this month's forecast. Add a close date filter.
• Mixing deal sizes. One ₹20 lakh deal hides inside an average of ₹80,000. List large deals separately.
• Treating coverage as a forecast. A big pipeline number does not predict revenue. The weighted figure does.
• Changing probabilities to hit the target. Raising stage odds to fix a short forecast hides the problem.
• Never comparing forecast with actuals. At each month end, record the forecast and the result. The gap is your calibration signal.

How can you improve your forecast and close the gap?

Improving the forecast means two things: making the number more accurate, and moving the real number closer to target. Work on both.

Make probabilities evidence based

Owner: sales operations. Timeline: one quarter.

• Export closed won and closed lost deals for the last two or three quarters.
• For each stage, count deals that reached it and deals that closed from it.
• Divide to get the actual stage probability. Do this per source or product if volumes allow.
• Replace the defaults in the tool with these figures and note the date.

Write exit criteria for each stage

Owner: sales head. Timeline: two weeks.

• Define what must be true for a deal to enter each stage, such as budget confirmed or visit completed.
• Review a few deals against the criteria every week.
• Use the Sales Pipeline Health Grader to check whether your stages and forecasting practice are strong enough.

Keep the pipeline current

Owner: each rep, checked by team leads. Timeline: daily and weekly.

• Every open deal has a next follow up date.
• Deals with no contact for the number of days you set are reviewed on Monday.
• Close dates are updated whenever the customer moves them.
• Use the Sales Pipeline Tracker Template if your pipeline still lives in scattered sheets.

Close the gap with stage moves

Owner: team leads. Timeline: this week and next.

• List the deals in the middle stage and rank them by value and recency.
• Choose the five you can influence and agree one action each.
• Check the effect of moving a deal one stage: Qualified to Proposal adds ₹16,000 per deal at default values, Proposal to Negotiation adds ₹24,000, Negotiation to Verbal commit adds ₹20,000, and Verbal commit to won adds ₹12,000.

Score the leads feeding the pipeline

Owner: marketing and sales together. Timeline: monthly.

• If the early stage is large but converts poorly, tighten qualification using the Lead Scoring Calculator.

Weighted forecast: spreadsheet, CRM or Erino?

You can build this forecast in a spreadsheet, in a generic CRM or in a CRM designed for high velocity teams. The right choice depends on how fresh your stage data needs to be.

A spreadsheet works for a small number of deals kept by one person. A SUMPRODUCT formula across deal value and stage probability gives the same answer as this tool. The weakness is freshness: stages are updated by hand, and nothing records how the forecast changed week to week.

Generic CRMs such as Zoho CRM, HubSpot, Salesforce, LeadSquared, Kylas and TeleCRM include pipeline stages and forecast reports, and many support stage probabilities. What is included varies by vendor and plan, so check each vendor's current plans. Setting up stages, probabilities and reports often needs admin time.

Erino is an AI first sales CRM for high velocity sales teams in India. It gives every lead an owner on arrival, creates the next follow up at every stage, flags stuck deals in real time and offers dashboards and customizable pipelines. That discipline keeps the stage data behind a forecast accurate, which matters more than the formula.

Read more about the Erino platform, or see how it compares in guides to Zoho CRM alternatives and Salesforce alternatives. You can book a free 15 minute demo and see it working on your own pipeline.

Frequently asked questions

Written by the Erino team

Erino Tech Ventures Pvt. Ltd. builds Erino, an AI first sales CRM for high velocity sales teams in India. Last reviewed 26 Oct 2026. This tool runs in your browser; the numbers you type are not sent anywhere.

Customer results mentioned here come from Erino's published success stories.