Sales Pipeline Coverage Calculator
Calculate your current coverage and required pipeline
- Remaining revenue target = period revenue target minus revenue already won
- Current coverage = current qualified pipeline divided by remaining revenue target
- Required pipeline = remaining revenue target divided by assumed win rate
- Pipeline shortfall = required pipeline minus current qualified pipeline. Negative results are surpluses.
Enter nonnegative monetary values and a win rate above 0% and no more than 100%, using the same period, currency, segment and opportunity cohort. If your target is already revenue still to win, enter it as the target and enter zero already won. A zero remaining target means no additional pipeline is required. See other revenue calculators.
The result shows how many times your remaining target is covered, how much qualified pipeline your win rate implies you need, and whether you have a shortfall or surplus.
How to read your calculator results
Current coverage is the multiple of the remaining revenue target represented by current qualified pipeline. Required coverage follows the pipeline coverage formula: 1 divided by the assumed sales win rate. A 25 percent win rate implies 4x required coverage before considering timing or pipeline quality.
In the illustrative result, current coverage is 3x versus 4x required coverage. The required sales pipeline is $3,200,000, producing an $800,000 pipeline shortfall.
Treat that shortfall as a planning signal, not proof that generating more leads is the root solution. Conversion, sales capacity, target assumptions, and qualification may also explain the gap.
Likewise, surplus coverage does not guarantee target attainment. Opportunity timing, stage quality, deal-size mix, and forecast accuracy still matter. Use relevant B2B revenue benchmarks for external context rather than treating any pipeline coverage ratio as a universal health score.
Calculator methodology
This sales pipeline coverage calculator applies an empirical sales win-rate assumption to unweighted qualified pipeline. Unweighted coverage uses the full value of qualified opportunities, while forecast-weighted pipeline adjusts each opportunity using its stage probability.
Keeping these approaches separate avoids multiplying pipeline by stage probabilities and then dividing by win rate again, which would double-adjust for conversion. See the published calculation methodology for definitions, formulas, and assumptions.
Variable definitions
Use an amount-based win rate for pipeline value, especially when deal sizes vary materially.
| Variable | Meaning | Required unit |
|---|---|---|
| Revenue target | Total revenue to win in the selected period. | Currency |
| Revenue already won | Closed-won revenue credited to the same target and period. | Currency |
| Remaining revenue target | Portion of the period target not yet won. | Currency |
| Current qualified pipeline | Unweighted open opportunities meeting team qualification standards and able to close in-period. | Currency |
| Win rate | Share of comparable qualified opportunity value historically won. | Percentage |
| Required sales pipeline | Pipeline needed to produce the remaining target at the stated win rate. | Currency |
| Pipeline coverage ratio | Current qualified pipeline divided by required pipeline. | Multiple |
Formulas and assumptions
The sales pipeline coverage calculator uses these arithmetic identities:
- Decimal win rate = entered win rate ÷ 100
- Required coverage = 1 ÷ decimal win rate
- Required pipeline = remaining revenue target ÷ decimal win rate
- Current coverage = current qualified pipeline ÷ remaining revenue target
- Shortfall = maximum of (required pipeline − current qualified pipeline) and zero
- Surplus = maximum of (current qualified pipeline − required pipeline) and zero
The model assumes qualified pipeline is eligible to close within the selected period and the sales win rate applies to that cohort. See the published calculation methodology.
Worked sales pipeline coverage example
Illustrative example: To verify the sales pipeline coverage calculator manually, start with the following inputs. The 25 percent sales win rate is an assumption for this example, not a universal benchmark.
| Step | Calculation |
|---|---|
| Remaining revenue target | $1,000,000 minus $200,000 won = $800,000 |
| Qualified open pipeline | $2,400,000 |
| Amount-based win rate | 25 percent |
| Current coverage | $2,400,000 divided by $800,000 = 3x |
| Required pipeline | $800,000 divided by 0.25 = $3,200,000 |
| Required coverage | 1 divided by 0.25 = 4x |
| Pipeline shortfall | $3,200,000 minus $2,400,000 = $800,000 |
The result indicates an illustrative $800,000 gap between qualified pipeline and win-rate-based requirements. Explore evidence-led revenue research for broader context on pipeline and conversion.
Why required pipeline coverage varies
A fixed 3x or 4x rule can mislead. Lower observed sales win rates mathematically require more starting pipeline for the same revenue target, while higher win rates require less.
Enterprise, mid-market and smaller-business segments often differ in deal size, buying process, qualification and conversion. Sales-cycle length also determines whether open pipeline can close within the target period, regardless of its total value.
| Win rate | Required pipeline | Coverage |
|---|---|---|
| 10% | $8,000,000 | 10x |
| 20% | $4,000,000 | 5x |
| 25% | $3,200,000 | 4x |
| 40% | $2,000,000 | 2.5x |
| 50% | $1,600,000 | 2x |
New-business, expansion, partner and other GTM motions should not automatically share one win-rate assumption. Calculate separate coverage ratios where performance differs materially, and explore related pipeline and conversion topics.
Use the result as a diagnostic, not a verdict
A sales pipeline coverage shortfall is a prompt to investigate, not a verdict that more opportunities are automatically needed. Test whether the cause is insufficient pipeline creation, weak qualification, declining conversion, close-date timing, limited capacity, or an unrealistic revenue target.
- Review coverage by segment, owner, stage, source, and expected close period, not only the company-wide total.
- Compare the assumed sales win rate with a recent historical cohort that resembles the current qualified pipeline.
- Check whether sales capacity and sales-cycle timing can support the required opportunity volume.
For example, the same $800,000 shortfall can indicate a pipeline creation gap when win rate is stable. If the entered win rate came from a noncomparable segment, it may instead reveal an assumption problem.
Use the Revenue Engine Diagnostic to evaluate pipeline, conversion, capacity, and economics together before choosing a response.
Important limitations and planning caveats
This sales pipeline coverage calculator is a planning model, not a forecast or guarantee of revenue attainment. Stale opportunities, pushed close dates, inconsistent qualification and reliance on a few large deals can overstate usable coverage.
For example, $3 million spread across many comparable qualified deals is not operationally equivalent to $3 million concentrated in one unusually large opportunity. Also, do not compare a full-period revenue target with pipeline restricted to only part of that period.
Use a sales win rate that matches the value-based pipeline coverage formula. A count-based win rate can distort required sales pipeline when won and lost deals have different average values. Explore RevXForge revenue research for evidence-led context across the wider revenue engine.
Frequently Asked Questions
How do you keep track of your sales pipeline?
Keep track of your sales pipeline in a CRM using consistent qualification criteria, opportunity values, stages, owners, and expected close dates. Take regular period snapshots and review coverage by segment and stage so deleted, delayed, or stale opportunities do not obscure changes.
Should pipeline coverage use weighted or unweighted pipeline?
Use unweighted qualified pipeline with a historical win-rate assumption for pipeline coverage. Applying win rate to an already probability-weighted pipeline can double-discount its value, although weighted pipeline can be analyzed separately for forecasting.
Which win rate should I enter in the calculator?
Enter a recent, amount-based win rate for qualified opportunities that are comparable in segment, GTM motion, stage definition, and sales cycle. Avoid relying solely on a company-wide rate or external benchmark, since either may not represent the current opportunity cohort.
Is 3x pipeline coverage enough?
Not necessarily. A 3x pipeline coverage ratio mathematically supports the target at a 33.3% win rate, but whether it is enough also depends on close timing, pipeline quality, segment mix, deal concentration, and whether coverage is calculated against the full or remaining target.
Conclusion
A sales pipeline coverage calculator shows whether current qualified pipeline is sufficient for the revenue target, but the result should be interpreted alongside historical win rate, deal timing, stage quality, and sales capacity. RevXForge’s Revenue Engine Diagnostic assesses pipeline, conversion, sales capacity, and GTM economics together, helping distinguish a true coverage gap from a symptom of a wider revenue engine issue.
Find out what your coverage result is really telling you
Use the RevXForge Revenue Engine Diagnostic to assess pipeline, conversion, sales capacity, and GTM economics together, then identify what deserves attention before treating a pipeline shortfall as the root cause.
Learn more