Pipeline Coverage Ratio Calculator
Plug in quota and open pipeline to instantly see your coverage ratio, and use your actual win rate — not the generic '3x-4x' rule — to find the coverage number you really need.
What's inside
- Coverage ratio formula: Open Pipeline Value ÷ Remaining Quota
- Win-rate-to-minimum-coverage table showing why 3x-4x only holds at 25-33% win rate
- Fill-in worksheet with a fully worked example ($1.6M pipeline / $500K quota at 22% win rate)
- Gap calculation showing exactly how much more pipeline is needed
- Stage-weighted pipeline table with per-stage win-rate weighting
- Weighted coverage ratio benchmark (~1.0x-1.2x) as a stricter health check
- Threshold guide for reading raw coverage ratios (below 3x, 3x-4x, above 5x)
- Segmentation warning against trusting a blended team number
The formula
`` Pipeline Coverage Ratio = Open Pipeline Value ÷ Remaining Quota ``
Why 3x–4x, specifically — the math behind the rule of thumb
Coverage ratio needed is really a function of your average win rate: `` Minimum Coverage Needed ≈ 1 ÷ Win Rate ``
| Average win rate | Minimum coverage needed |
|---|---|
| 40% | 2.5x |
| 33% | 3.0x |
| 25% | 4.0x |
| 20% | 5.0x |
| 15% | 6.7x |
The commonly-cited "3x–4x" rule assumes a 25–33% win rate. If your real win rate is lower, 3x-4x will underperform — calculate your own number, don't borrow the industry rule of thumb.
Worksheet
| Field | Your Number |
|---|---|
| Remaining quota this period ($) | ___________ |
| Total open pipeline value ($) — all open deals, undiscounted | ___________ |
| Current Coverage Ratio = Pipeline ÷ Quota | ___________ |
| Trailing-12-month average win rate (%) | ___________ |
| Minimum coverage needed = 1 ÷ win rate | ___________ |
| Gap: (Minimum needed − Current ratio) × Quota = $ pipeline still needed | ___________ |
Worked example
- Remaining quota: $500,000
- Open pipeline: $1,600,000
- Current coverage: 1,600,000 ÷ 500,000 = 3.2x
- Trailing win rate: 22%
- Minimum needed: 1 ÷ 0.22 = 4.5x
- Verdict: Under-covered. Need $2,250,000 in open pipeline to hit 4.5x — a further $650,000 must be generated or the number is at risk before a single deal slips.
Stage-weight it (a more honest version)
Raw open pipeline overstates coverage because it counts a deal in "Qualified" the same as a deal in "Negotiation." Use stage-weighted pipeline against the same formula for a stricter read:
| Stage | Raw Value | Win Rate at Stage | Weighted Value |
|---|---|---|---|
| Qualified | ×15% | ||
| Discovery | ×25% | ||
| Proposal | ×40% | ||
| Negotiation | ×65% | ||
| Verbal Commit | ×85% | ||
| Total Weighted Pipeline |
Weighted Coverage Ratio = Total Weighted Value ÷ Remaining Quota. A healthy weighted ratio is close to 1.0x–1.2x — because the stage weighting has already priced in expected loss.
Reading the raw ratio
- Below 3x: Under-covered for almost any win rate. Pipeline generation is now the #1 priority, ahead of deal execution.
- 3x–4x: Adequate only if trailing win rate is 25–33%. Check your actual win rate before declaring victory.
- Above 5x: Either genuinely strong, or a sign that stale/dead deals aren't being purged — check average deal age before celebrating.
Segment it before you trust it
A blended 4x can hide a segment at 1.5x. Run the same worksheet by segment, rep, and territory — coverage math lies when it's aggregated.
How to use it
Plug in this period's remaining quota and total open pipeline to get your raw coverage ratio, then use your trailing win rate to find the coverage number you actually need — don't rely on the generic 3x-4x rule if your win rate is below 30%.