Skip to content
Omnikalc

Pipeline coverage calculator: is your sales pipeline big enough?

Enter your revenue target, closed revenue, win rate and open pipeline to get the coverage ratio, the pipeline you need and the projected revenue.

Updated on
Your inputs
$

Value out of range

$

Value out of range

%

Value out of range

$

Value out of range

Results

Pipeline you need to cover the gap

$3,000,000

Coverage ratio you have

2.93 ×

Pipeline as a share of what you need

73%

Short: build more pipeline

Pipeline still to create

$800,000

Revenue still to close
$750,000
Coverage ratio you need
4.0 ×
Expected revenue from open pipeline
$550,000
Projected total revenue
$800,000

A sales team can only close what is in the pipeline. This pipeline coverage calculator takes your revenue target, the revenue already closed, the win rate and the open pipeline to show the revenue left to close, the pipeline you need, your coverage ratio against the ratio you need, the expected revenue and how much new pipeline you still have to create.

How the calculation works

  • Revenue still to close = target − revenue already closed.
  • Pipeline needed = revenue still to close ÷ win rate.
  • Coverage ratio needed = 1 ÷ win rate, for example 4× at a 25 % win rate.
  • Coverage ratio you have = open pipeline ÷ revenue still to close.
  • Projected revenue = closed revenue + open pipeline × win rate.

Example

A team targets $1,000,000 this quarter and has already closed $250,000, so $750,000 remains. At a 25 % win rate it needs $3,000,000 of pipeline, a 4× coverage ratio. It has $2,200,000 open, which is 2.93×, or 73 % of what it needs. The pipeline should produce about $550,000, for a projected total of $800,000, and the team still needs to create $800,000 of pipeline.

Why it matters

Missing a target is usually decided weeks before the quarter ends, when the pipeline was too small. Coverage gives an early warning. A ratio of 4 times means little unless it is compared with your own win rate, so converting the rule of thumb into the exact amount you need turns it into a number for planning prospecting, marketing spend and headcount, and tells you how large the gap is today.

Good to know

Win rates differ by stage, source, region and deal size, so use the one that matches the pipeline you count. If you include early stage deals, the win rate is lower and the coverage needed is higher. Coverage should be measured on pipeline that can close within the period, not on all open deals. Pipeline created late in the period rarely closes in it because of the length of the sales cycle. Treat the projection as a base case and review it weekly. A coverage ratio above what you need can still miss if a few large deals slip.

The marketing funnel calculator turns leads into customers, the CAC payback calculator measures how fast acquisition spend returns, and the customer lifetime value calculator values each win.

Frequently asked questions

What is pipeline coverage?

The ratio of open pipeline value to the revenue you still need to close. A 3× or 4× coverage is a common rule of thumb.

How do I find the coverage I need?

Divide 1 by your win rate. At a 25 percent win rate you need 4 times as much pipeline as revenue, and at 33 percent you need 3 times.

Which win rate should I use?

Use the win rate on pipeline value from recent periods at the same stage, not the win rate of late-stage deals alone.

Does pipeline quality matter?

Yes. Old, stalled or unqualified deals inflate pipeline and lower the real win rate, so clean the pipeline before you measure coverage.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.