BYTETOOLS

Pipeline Coverage Calculator

Weight your pipeline by stage probability and get the coverage ratio against the quota gap, plus the new pipeline needed to close it at your win rate.

Pipeline by stage

Columns, left to right: stage name, number of opportunities, total value, stage win probability (%).

$4,180,000
Raw pipeline
$1,294,000
Weighted pipeline
$1,350,000
Quota gap
3.10×
Coverage ratio (raw)
0.96×
Coverage ratio (weighted)
$1,944,000
Expected to land
$56,000
Expected shortfall
$254,545
New pipeline needed
StageOpportunitiesValueProbabilityWeighted valueAverage deal
Discovery40$1,600,00010%$160,000$40,000
Qualified24$1,200,00025%$300,000$50,000
Proposal14$900,00050%$450,000$64,286
Negotiation6$480,00080%$384,000$80,000
Total84$4,180,00031%$1,294,000$49,762

Three times coverage is the conventional rule of thumb: it roughly matches a 30-35% win rate with some slippage allowance.

The average sales cycle of 75 days is longer than the 60 days left in the period, so anything created from today closes after the period ends. The $254,545 of new pipeline needed will count towards the next period, not this one — this period has to be closed from what is already in the funnel.

weighted pipeline = Σ(value × probability)  ·  coverage = pipeline ÷ (quota − closed won)  ·  new pipeline = (gap − weighted pipeline) ÷ win rate

Worked example: $200,000 at 20%, $150,000 at 50% and $300,000 at 80% weight to 40,000 + 75,000 + 240,000 = $355,000. Against a $400,000 quota with $120,000 already closed, the gap is $280,000, so raw coverage is 650,000 ÷ 280,000 = 2.32× and weighted coverage 1.27×. When closed-won already meets quota the gap is zero, so the tool reports “Covered” instead of dividing by zero.

Stage probabilities from a CRM are historical averages, not forecasts for the specific deals in front of you — weighted pipeline is a sanity check, never a commit number. The 3× coverage rule of thumb only holds at a win rate near one third; at a 20% win rate you need closer to 5×, which is why the win rate is an input here. Everything is calculated in your browser and nothing is uploaded.

What is the Pipeline Coverage Calculator?

Pipeline coverage is the ratio of pipeline to the gap still left against quota. The rule of thumb is three times, but that only holds at a win rate near a third — at 20% you need closer to five times, which is why this calculator takes your actual win rate as an input rather than assuming one.

  • Weighted pipeline as the sum of value × stage probability
  • Coverage ratio on both the raw and the probability-weighted basis
  • Quota gap after closed-won, reporting “Covered” when it reaches zero
  • New pipeline and opportunity count required at your win rate
  • Warns when the sales cycle is longer than the days remaining
  • Editable stage table with per-stage average deal size

How to use the Pipeline Coverage Calculator

  1. 1

    Enter the quota for the period and the revenue already closed-won against it.

  2. 2

    Add your team's win rate, average sales cycle in days and the days left in the period.

  3. 3

    Fill one row per pipeline stage with the opportunity count, total value and stage probability.

  4. 4

    Read the coverage ratio on both the raw and the weighted basis.

  5. 5

    Check the new pipeline needed, and whether the sales cycle still fits inside the period.

About the Pipeline Coverage Calculator

Pipeline coverage is the ratio of pipeline to the gap still left against quota. The rule of thumb is three times, but that only holds at a win rate near a third — at 20% you need closer to five times, which is why this calculator takes your actual win rate as an input rather than assuming one.

Build the pipeline stage by stage with an opportunity count, a value and a stage probability. The tool returns raw and weighted pipeline, the quota gap after closed-won revenue, coverage on both bases, what is expected to land, and how much new pipeline has to be created to close the remaining gap.

It also checks your average sales cycle against the days left in the period, because pipeline created too late to close is not coverage. Everything is calculated in your browser and nothing is uploaded. Estimates for planning, not financial advice.

Frequently asked questions

How do you calculate pipeline coverage?

Divide open pipeline by the gap between quota and closed-won revenue. With 650,000 of open pipeline against a 280,000 gap, coverage is 2.3 times. Weighting each opportunity by its stage probability first gives a second, more conservative figure — here 355,000 ÷ 280,000 = 1.3 times.

Is 3x pipeline coverage enough?

Only if your win rate is about a third. Coverage and win rate are two sides of the same coin: at a 20% win rate you need roughly five times, at 50% roughly two times. Quoting 3x without checking the win rate behind it is how forecasts miss.

Should I use raw or weighted pipeline for coverage?

Track both. Raw coverage is the conventional number and is easy to compare across teams; weighted coverage is a sanity check on whether the pipeline is actually mature. If raw looks fine and weighted looks thin, the pipeline is full of early-stage deals that will not close this period.

What happens if I have already hit quota?

The quota gap is zero, so coverage has no denominator. Rather than showing an infinity symbol, the calculator reports “Covered”. It is worth still tracking pipeline at that point, because next period's coverage starts from whatever you did not close this one.

Why does the sales cycle length matter for coverage?

Because pipeline that cannot close inside the period is not coverage for that period. If the average cycle is 75 days and there are 60 days left, anything created today lands next quarter — this quarter has to be closed from what is already in the funnel.

Related tools