An open resource for founders, investors & operatorsPRIVATE MARKETS, EXPLAINED.
Sales & GTMFREE ACCESS

Sales Pipeline & Coverage Calculator

Compare qualified pipeline with a bookings target and the capacity required per rep.

6 min guideTransparent methodologyUSDGo to calculator ↓
01 / UNDERSTAND THE CONCEPT

Coverage only matters relative to conversion.

Pipeline coverage compares eligible qualified pipeline with a target using the same ACV basis and closing period. Required pipeline works backward from the target using an entered value-weighted win rate. It shows whether the apparent coverage can support the plan under that assumption.

A three-times coverage ratio has no universal meaning without conversion and timing. This model excludes opportunities outside the period and does not probability-weight pipeline twice. Required opportunity counts assume every opportunity has the entered ACV; a value-weighted win rate need not equal a count-based win rate when deal sizes vary.

02 / THE MATHEMATICS

The formula, made clear.

Coverage = qualified pipeline ÷ target; required pipeline = target ÷ value win rate; required opportunities = required pipeline ÷ assumed opportunity ACV
Qualified pipeline
Unweighted ACV for opportunities with a credible path to close within the target period.
Value win rate
Expected won value as a share of the eligible pipeline value. Do not substitute a count win rate without equal deal sizes.
Additional pipeline
The positive shortfall between required and entered pipeline. A surplus is shown separately.
03 / A WORKED EXAMPLE

Put the numbers in context.

A $1,200,000.00 target at a 25% value win rate requires $4,800,000.00 qualified pipeline. Against $3,000,000.00 available, the additional requirement is $1,800,000.00. At $30,000.00 per opportunity and five reps, the plan requires 32 opportunities per rep.

Illustrative scenario · USD
InputExample value
New ACV bookings target$1,200,000.00
Qualified pipeline ACV$3,000,000.00
Expected pipeline value win rate25%
Assumed ACV per opportunity$30,000.00
Productive sales reps5 people
Required qualified pipeline ACV$4,800,000.00
MODEL BOUNDARIES

What this calculation assumes

One closing period and one consistent ACV basis. No stage-specific probabilities, timing slippage, renewals, expansion or capacity constraints. Count outputs assume homogeneous deal sizes and are fractional expectations. Zero win rate cannot support a positive target; zero reps leaves per-rep outputs undefined.

FROM UNDERSTANDING TO ACTION

What to consider next.

Use the funnel plan to estimate the leads needed to create these opportunities, and review whether the sales-capacity assumptions can support the target.

How we approach financial models →
THE OAKSHORE NETWORK

Understand the mechanics.
Then enter the market.

Oakshore connects verified founders and investors through a private, thesis-aligned market network.

Explore Oakshore