# Pipeline coverage calculator

https://salesbond.app/tools/pipeline-coverage-calculator/
Updated: 2026-11-06

# Pipeline Coverage Calculator: Ratio and Pipeline Needed

Pipeline coverage is open pipeline ÷ the sales still needed to hit the target. With a 150,000 target, 30,000 closed and 400,000 of open deals, coverage is 400,000 ÷ 120,000 = 3.33×. The coverage you need is 1 ÷ your win rate: at 25% that is 4×, so 80,000 more pipeline is needed.

Enter the target, sales already closed and open pipeline in any currency. You get your coverage ratio and how it compares with the 3× rule, or with what your win rate needs. Add the average deal size to see how many new opportunities to create.

## Pipeline coverage formulas

| Figure | Formula |
| --- | --- |
| Pipeline coverage | P ÷ (T − C) |
| Coverage needed | 1 ÷ W |
| Pipeline needed | (T − C) ÷ W |
| New opportunities | gap ÷ D |

P: open pipeline. T: sales target. C: sales already closed. W: win rate. D: average deal size. Gap: pipeline needed − P.

## Example

A team has a quarterly target of 150,000.00 and has closed 30,000.00, so 120,000.00 is still to close. Its open pipeline is 400,000.00: coverage is 400,000 ÷ 120,000 = 3.33×, which passes the 3× rule. But the team wins 25% of its deals, so it needs 1 ÷ 0.25 = 4× coverage, or 480,000.00 of pipeline. The gap is 80,000.00: at 4,800.00 a deal, that is 17 new opportunities. Without them the forecast is 30,000 + 400,000 × 25% = 130,000.00.

## Coverage needed by win rate

| Win rate | Coverage needed |
| --- | --- |
| 20% | 5× |
| 25% | 4× |
| 33% | 3× |
| 40% | 2.5× |
| 50% | 2× |

## Frequently asked questions

### What is pipeline coverage?

Pipeline coverage is the value of open deals divided by the sales you still need to close in the period. A 400,000 pipeline against 120,000 still to close is 3.33× coverage. It tells you early whether there are enough deals in play to hit the target.

### What is the pipeline coverage formula?

Pipeline coverage = open pipeline ÷ (sales target − sales already closed). Use deals expected to close in the same period, not the whole CRM. To know what coverage you need, divide 1 by your win rate: a 25% win rate needs 4×, a 40% win rate needs 2.5×.

### Is 3x pipeline coverage enough?

The 3× rule assumes a win rate of about 33%. If you win fewer deals, 3× is not enough; if you win more, you can hit the target with less. Use your own win rate from recent quarters to set the coverage you need.

### How do I calculate how much pipeline I need?

Pipeline needed = still to close ÷ win rate. With 120,000 still to close and a 25% win rate you need 480,000 of pipeline. Subtract what you have to see the pipeline to add, and divide by the average deal size to get the number of new opportunities.

### What if my pipeline coverage is too low?

Create pipeline early: prospect, run campaigns, ask for referrals and pull in deals from next period. Improve the win rate with better qualification. If coverage stays low late in the period, adjust the forecast rather than counting on deals that are not there.

Related tools: [sales forecast calculator](https://salesbond.app/tools/sales-forecast-calculator/), [sales velocity calculator](https://salesbond.app/tools/sales-velocity-calculator/), [commission and quota calculator](https://salesbond.app/tools/commission-calculator/). More on sales and running a sales team on the [SalesBond blog](https://salesbond.app/blog/) and the [home page](https://salesbond.app/).

## Official sources

- [Salesforce, the 3x pipeline coverage rule](https://www.salesforce.com/blog/pipeline-coverage/) — why the coverage you need depends on the win rate.
- [Forecastio, Sales Pipeline Coverage](https://www.forecastio.ai/blog/pipeline-coverage) — formula and ratios.
- [DealHub, What is Pipeline Coverage?](https://www.dealhub.io/glossary/pipeline-coverage/) — definition.
- [Wikipedia, Sales management](https://en.wikipedia.org/wiki/Sales_management) — pipeline and forecasting in sales management.

**Updated on Nov 6, 2026.** This calculator is for information only and is not tax, legal or payroll advice. Results come from the formulas above. Count only open deals expected to close in the period, and use a win rate measured on deals of that kind.