Your numbers
Explore the numbers
Examples, chart, and saved snapshots
Start with a realistic example, adjust the inputs, or save your numbers before experimenting.
300,000 open against 120,000 still to close
The period quota is 200,000. Closed revenue is 80,000, so 120,000 remains. Open pipeline is 300,000. The coverage target you typed is 3.
Quota for the period: 25% lower
Change quota for the period to 150,000 while keeping the other example values the same.
Quota for the period: 25% higher
Change quota for the period to 250,000 while keeping the other example values the same.
Interactive chart
See what changes the result
This result is categorical, so compare the calculated values in the examples and snapshots instead.
The chart changes one input while holding all other current values steady. It is a sensitivity view, not a forecast.
Browser snapshots
Freeze these values
Save the current calculation, experiment freely, and restore it later.
No saved snapshots for this calculator yet.
Compare snapshots
What changed?
Save one more snapshot to compare plans.
Saved only in this browser. Nothing is uploaded, and clearing browser data removes the snapshots.
Quick answer
What does the Pipeline coverage calculate?
How much open pipeline covers the quota still left to close? This calculator uses quota for the period, closed revenue, open pipeline, and coverage target to estimate open pipeline against the quota left immediately in your browser.
With the values currently entered, the result is 2.5× — coverage of the quota still open. It also shows quota still to close, pipeline the target needs, and short of the target.
How to use the Pipeline coverage
- Replace the example values with your own numbers.
- Review the result and supporting figures as they update automatically.
- Check the formula and assumptions before using the estimate for a decision.
Inputs used
- Quota for the period
- Closed revenue
- Open pipeline
- Coverage target
Pipeline coverage formula
Remaining quota = quota − closed revenue. Coverage = open pipeline ÷ remaining quota. Pipeline at the target = remaining quota × the target you type.
Assumptions
- SBA tells you to set a sales goal and compare results with it. Coverage divides the open pipeline you type by the quota still left after closed revenue.
- The coverage target is a multiple you type. This page does not set a required multiple. A probability-weighted pipeline is a smaller number than the sum of deal values. Put the version you want in the pipeline box.
Verify the inputs
Authoritative sources
These sources explain the definitions, factors, or rules behind this tool. Their geographic scope is shown because an official source for one country is not automatically valid somewhere else.
Sources do not endorse Calculum. Check the source date, scope, and your own documents before making a financial, tax, insurance, or reporting decision.
Practical guide
Pipeline coverage example and edge cases
Pipeline coverage compares open deals with the quota you still have to close. SBA tells you to set a sales goal and measure results against it. The multiple here is open pipeline divided by quota minus closed revenue.
Example: 300,000 open against 120,000 still to close
The period quota is 200,000. Closed revenue is 80,000, so 120,000 remains. Open pipeline is 300,000. The coverage target you typed is 3.
- Quota for the period
- 200,000
- Closed revenue
- 80,000
- Open pipeline
- 300,000
- Coverage target
- 3
Calculated result2.5×coverage of the quota still open
Coverage is 2.5×. A target of 3 on the remaining 120,000 would need 360,000 of pipeline. The open pipeline is 60,000 short of that target. The target is the number you typed.
Example results use the default display profile. The calculator above follows your selected country and units.
How to read the result
- The multiple is open pipeline divided by the quota still left. The gap line uses the target you typed.
- Put closed deals in the closed box. Leaving them in the open pipeline counts the same revenue on both sides of the quota.
Edge cases worth checking
Weighted pipeline sits next to a full quota
Type the pipeline the way you want to compare it with the quota. A probability-weighted total is smaller than the sum of deal values. The quota stays the goal you set.
Closed revenue already passed the quota
Remaining quota is zero, so the ratio has no denominator. The result says the quota is met and shows the pipeline that is still open.
What changes the result most
Quota for the period
Use a current amount for quota for the period. Include fees or recurring costs that belong in the same figure.
Closed revenue
Use a current amount for closed revenue. Include fees or recurring costs that belong in the same figure.
Open pipeline
Use a current amount for open pipeline. Include fees or recurring costs that belong in the same figure.
Try a different scenario
Small changes show whether the answer is stable or sensitive.
Quota for the period: 25% lower
150,0004.29×coverage of the quota still open
Quota for the period: 25% higher
250,0001.76×coverage of the quota still open
Closed revenue: 25% higher
100,0003×coverage of the quota still open
Common mistakes
Check quota for the period
SBA tells you to set a sales goal and compare results with it. Coverage divides the open pipeline you type by the quota still left after closed revenue. Make sure this matches the number you enter.
Keep coverage target consistent
The coverage target is a multiple you type. This page does not set a required multiple. A probability-weighted pipeline is a smaller number than the sum of deal values. Put the version you want in the pipeline box. Use the same units and time period throughout the calculation.
Do not rely on one pipeline coverage scenario
Run a cautious case and an optimistic case. The range is often more useful than one exact-looking number.
Use this result well
How much open pipeline covers the quota still left to close?
It does not replace a quote, contract, accountant, or local employment guidance.