Pipeline coverage & sales forecast calculator

What is pipeline coverage?

Pipeline coverage compares the value of your open opportunities with what you still need to close this period. With a $300,000 quarterly quota, $95,000 already closed-won and $489,000 of deals expected to close before quarter end, your remaining quota is $205,000 and your pipeline coverage ratio is 489,000 ÷ 205,000, or 2.4x.

The ratio answers one question: do I have enough deals to hit quota, knowing I’ll only win some of them? If you close about one deal in three, you need at least three times your remaining quota in pipeline. That is where the familiar 3x pipeline coverage rule comes from: it is simply 1 ÷ a win rate of roughly 33%. It is a rule of thumb, not an industry standard. A team that wins half its deals can live at 2x; a team that wins one in five needs 5x. The calculator lets you set your own target, and the best one is the inverse of your historical win rate.

Two details change everything. Only count pipeline that can close inside the period: a deal dated next quarter covers nothing today. And divide by remaining quota, not the full number: three weeks before quarter end, the gap is what matters, not where you started.

Sales forecasting: commit, most likely and best case

A sales forecast estimates how much revenue will close by the end of the period. A single number hides the uncertainty; three scenarios show it. Commit is closed-won plus the deals far enough along that you’d stake your number on them, counted at full value: in the calculator, any deal at a stage whose probability reaches the commit threshold, 75% by default. Most likely is closed-won plus each deal multiplied by its stage probability: a $40,000 deal at demo stage, 50%, counts as $20,000. Best case is closed-won plus every deal dated inside the period, as if they all closed.

The most likely number, often called the weighted pipeline forecast, is accurate on average when you have plenty of deals, because misses and surprises cancel out. With ten deals it is much shakier: one large deal slipping can swing the result by tens of percent. That’s why the calculator also shows how dependent you are on your largest deals, and what your forecast becomes if the biggest one slips.

Commit and most likely don’t always come in that order. Commit counts late-stage deals at full value while most likely weights the whole pipeline, so a book of a few big deals in negotiation can show a commit above most likely. That isn’t a bug: it tells you the quarter rests on a handful of deals.

How much pipeline do you need to build each week?

The gap is remaining quota minus your most likely forecast. If it is positive, you are short of expected revenue, and new pipeline doesn’t close at 100%: to find $30,000 of closed-won with a 3x coverage target, you need to build $90,000 of pipeline. Divide by the weeks left and you get your weekly pipeline generation target: $90,000 over ten weeks is $9,000 of new pipeline every week.

That number only helps if new deals have time to close. Enter your average sales cycle and the calculator gives you the date after which a new deal will, on average, close after the period ends. If that date has already passed, new pipeline won’t save this quarter; it sets up the next one. The gap then has to be closed by accelerating existing deals: moving them a stage, getting a decision earlier, unblocking the ones that stalled.

Weekly pipeline then becomes activity. Divide it by your average deal size to get a number of deals, then work back up the funnel with the sales funnel calculator or the prospecting calculator: how many meetings, conversations and calls per week it takes to produce them.

Past-due deals distort your forecast

A deal whose close date has passed without closing is neither won nor lost: it is waiting on a decision nobody made. Leaving it in the forecast inflates coverage; dropping it without a look loses a real opportunity. The calculator pulls these deals out, along with undated ones, shows how much is at stake and lets you redate or remove them right in the list.

A good pipeline review starts here: every past-due deal gets a new date backed by a concrete next step (a meeting, an expected decision), or it gets closed out. A clean pipeline beats a big one: it is what makes your coverage ratio and your forecast credible.

Where stage probabilities come from

The default probabilities (10, 25, 50, 75 and 90%) are starting assumptions, not industry averages. The best ones are yours: the share of past deals at each stage that ended up closed-won. Most CRMs store a probability per stage; check that someone actually measured it rather than guessed it during setup.

If you measured your volumes with the sales funnel calculator, paste its share link: the tool derives each stage’s probability by dividing closed customers by that stage’s volume. With 120 meetings held and 24 customers, a deal at the meeting-held stage has a 20% chance of closing. Probabilities drawn from your own numbers make the weighted forecast far more reliable than a textbook grid.

How to build a forecast you can trust, in four steps

The calculator does the math; the reliability comes from what you feed it. Four habits, once a week.

1. 1

   Export your open pipeline

   From your CRM, export open deals with four columns: name, amount, stage and expected close date. Paste the export as is: separators, dates and amounts are recognized, and unreadable rows are flagged without blocking the rest.

2. 2

   Clean before you calculate

   Start with the “to requalify” list: every past-due deal gets a new, justified date or leaves the pipeline. Also check suspiciously round amounts and deals that haven’t changed stage in a long time.

3. 3

   Calibrate probabilities on history

   Replace the default probabilities with your historical ones, or pull them from the sales funnel calculator. Set your target coverage to 1 ÷ your actual win rate.

4. 4

   Track the trend, not the snapshot

   Copy the link every Monday: comparing week over week shows whether pipeline is moving, slipping or draining. A most likely number that drops while nothing was lost means close dates are being pushed.

What to do when coverage is too low

Three levers, depending on the time left and the length of your cycle.

• Build pipeline, if your cycle allows it

  The weekly number becomes the team’s activity target: meetings to book, prioritizing accounts with short cycles. Cold calling remains the fastest way to start a qualified conversation.

• Advance existing deals

  A deal moving from 50% to 75% adds a quarter of its value to your most likely forecast and may enter commit. For each large deal, name the next step that would move it a stage, and put a date on it.

• Requalify stalled deals

  Past-due and undated deals are hidden pipeline. A call to get a decision or a new date brings some of them back into the period; the rest get closed out, which keeps coverage honest.

• Reduce big-deal dependency

  If one deal carries a large share of the forecast, de-risk it (access to the decision-maker, a written signing timeline) and work several smaller deals in parallel that won’t all slip at once.

Mistakes that skew your forecast

• Counting all pipeline regardless of date

  A deal dated next quarter doesn’t cover this one. Coverage is calculated on pipeline that can close inside the period.

• Dividing by full quota

  Mid-quarter with half closed, you need to cover what’s left, not the total. Dividing by full quota understates coverage early and flatters it late.

• Keeping past-due deals

  A close date in the past with no signature isn’t a forecast, it’s an oversight. These deals pad best case and coverage without adding a dollar.

• Using probabilities nobody measured

  Guessed probabilities produce a weighted forecast that looks precise and isn’t. Measure them on history, even roughly.

• Treating 3x as a law

  The 3x rule assumes a win rate of about one in three. If yours is different, so is your target.

• Building pipeline too late

  A deal created two weeks before quarter end with a three-month cycle won’t save the quarter. Your sales cycle sets the deadline for new pipeline.

Keep going

The tools that take over once your forecast is set.

• Sales Funnel Calculator Your real stage-by-stage conversion rates: the source of your stage probabilities.
• Sales Quota Calculator The period’s target split by rep and by month, ramp-up and time off included.
• How many calls does your target take? Weekly pipeline needs translated into calls, hours and reps.
• Sales Team Size Calculator If pipeline falls short every quarter, the real question may be team capacity.
• SDR metrics and KPIs The activity metrics that feed your pipeline, and how to track them.
• All free tools Cost per meeting, sales rep ROI, call scorecard and more.