Planning inputs
Build your required pipeline
Use values from the same period, market segment, and opportunity definition.
Pipeline plan
Your required coverage
Your deal, opportunity, and pipeline requirements will appear here.
Calculation breakdown
How your plan was calculated
| Metric | Formula | Result |
|---|---|---|
| Enter your values and calculate to see the breakdown. | ||
What Is a Sales Pipeline Calculator?
A sales pipeline calculator translates a revenue goal into the approximate number and value of qualified opportunities needed to support it. It works backward from a target using average won-deal value and the historical percentage of qualified opportunities that become closed-won deals.
Sales Pipeline Formulas
Whole-deal counts are rounded up because a fraction of an opportunity cannot be created. This can make the displayed pipeline slightly larger than the continuous mathematical minimum, especially when the revenue target is small relative to average deal size.
How to Choose Reliable Inputs
Revenue target
Use the booked revenue, ARR, ACV, or other contract-value goal that your average deal size also represents. Keep the measurement basis and time period consistent.
Average deal size
Use historical closed-won value for the same segment and target period. A blended average can be misleading when enterprise and self-serve deals have very different values.
Opportunity win rate
Use closed-won opportunities divided by all opportunities that reached a final won or lost outcome under the same qualification definition. Do not use a lead-to-customer rate unless the pipeline count also starts with leads.
Planning buffer
The buffer adds headroom for normal variation, slippage, or concentration risk. It is not a universal benchmark. Base it on forecast accuracy, deal volatility, sales-cycle timing, and management preference.
How to Interpret Pipeline Coverage
Coverage is the ratio of open pipeline value to the revenue goal. A 4× ratio means four units of unweighted pipeline for every one unit of target revenue. There is no universal ideal coverage ratio: the required level changes with win rate, deal size, stage mix, sales cycle, segment, and forecast reliability.
The current-pipeline comparison is useful only when open opportunities are eligible to close within the target period and follow the same value definition. Remove stale, duplicate, excluded, or out-of-period opportunities before using that figure.
Limitations
This is a deterministic planning model, not a revenue forecast. It assumes the historical win rate and average deal size remain representative. It does not model stage-by-stage conversion, deal aging, sales-cycle capacity, ramp time, seasonality, expansion, contraction, or correlations among deals. For operational planning, review the result alongside stage conversion, pipeline velocity, rep capacity, and close-date quality.
Frequently Asked Questions
How much pipeline do I need to hit a revenue target?
At the simplest level, divide the target by the opportunity win rate. This calculator also rounds to whole deals and opportunities and can add an explicit planning buffer.
What is pipeline coverage?
Pipeline coverage is open pipeline value divided by the revenue target for the same period. A 4× coverage ratio means four units of pipeline for each unit of target.
Should I use weighted or unweighted pipeline?
This calculator requires unweighted pipeline because it applies one overall opportunity win rate. Using weighted pipeline with that win rate would discount risk twice.
What win rate should I use?
Use your own recent closed-won opportunities divided by all opportunities that reached a won or lost outcome, segmented where practical by market, product, channel, or sales motion.
Why are deal and opportunity counts rounded up?
Sales teams cannot create a fraction of a deal or opportunity. Rounding upward provides the minimum whole-number plan that supports the selected inputs.
Is a 3× or 4× pipeline always enough?
No. A fixed benchmark can be misleading. Required coverage is mainly driven by your win rate and is also affected by rounding, buffer, stage mix, timing, and pipeline quality.
Methodology Sources
The definitions and formulas were checked against HubSpot’s pipeline coverage definition, Salesforce’s win-rate guidance, and Pipedrive’s sales velocity methodology.