A sales team can only close what is in the pipeline. This pipeline coverage calculator takes your revenue target, the revenue already closed, the win rate and the open pipeline to show the revenue left to close, the pipeline you need, your coverage ratio against the ratio you need, the expected revenue and how much new pipeline you still have to create.
How the calculation works
- Revenue still to close = target − revenue already closed.
- Pipeline needed = revenue still to close ÷ win rate.
- Coverage ratio needed = 1 ÷ win rate, for example 4× at a 25 % win rate.
- Coverage ratio you have = open pipeline ÷ revenue still to close.
- Projected revenue = closed revenue + open pipeline × win rate.
Example
A team targets $1,000,000 this quarter and has already closed $250,000, so $750,000 remains. At a 25 % win rate it needs $3,000,000 of pipeline, a 4× coverage ratio. It has $2,200,000 open, which is 2.93×, or 73 % of what it needs. The pipeline should produce about $550,000, for a projected total of $800,000, and the team still needs to create $800,000 of pipeline.
Why it matters
Missing a target is usually decided weeks before the quarter ends, when the pipeline was too small. Coverage gives an early warning. A ratio of 4 times means little unless it is compared with your own win rate, so converting the rule of thumb into the exact amount you need turns it into a number for planning prospecting, marketing spend and headcount, and tells you how large the gap is today.
Good to know
Win rates differ by stage, source, region and deal size, so use the one that matches the pipeline you count. If you include early stage deals, the win rate is lower and the coverage needed is higher. Coverage should be measured on pipeline that can close within the period, not on all open deals. Pipeline created late in the period rarely closes in it because of the length of the sales cycle. Treat the projection as a base case and review it weekly. A coverage ratio above what you need can still miss if a few large deals slip.
Related tools
The marketing funnel calculator turns leads into customers, the CAC payback calculator measures how fast acquisition spend returns, and the customer lifetime value calculator values each win.