Sales Pipeline Calculator: Coverage and Revenue

Key terms

What each figure means

Open deals

Qualified deals past a defined stage, such as proposal sent, still open.

Average deal value

Total value of those open deals divided by their count.

Pipeline value

Open deals multiplied by average deal value.

Win rate by value

Share of closed deal value won over the previous four quarters.

Expected revenue

Pipeline value multiplied by win rate by value.

Sales target

The revenue the team must close in the period.

Pipeline needed

Sales target divided by win rate by value.

Coverage ratio

Pipeline needed divided by target. 4x means ₹4 of pipeline for every ₹1 of target.

Pipeline gap

Pipeline needed minus current open pipeline.

Working example

Does this quarter's pipeline cover a ₹6 crore target?

An industrial equipment maker's enterprise sales team in Pune has a ₹6,00,00,000 target for Q3. It holds 40 qualified open deals averaging ₹50,00,000. Over the previous four quarters it won 25% of closed deal value.

Step 1. Open pipeline = 40 × ₹50,00,000 = ₹20,00,00,000

Step 2. Expected revenue = ₹20,00,00,000 × 25% = ₹5,00,00,000

Step 3. Pipeline needed = ₹6,00,00,000 ÷ 25% = ₹24,00,00,000, a coverage ratio of 4x

Step 4. Pipeline gap = ₹24,00,00,000 - ₹20,00,00,000 = ₹4,00,00,000

Step 5. Deals to add = ₹4,00,00,000 ÷ ₹50,00,000 = 8 qualified deals

The answer

The open pipeline should bring in ₹5 crore against a ₹6 crore target. The team needs ₹4 crore more qualified pipeline, about 8 deals, to cover the target at its win rate.

Sales Pipeline Calculator

Get Results

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Sales Pipeline

The sales pipeline is a key aspect of the sales process, mapping out the stages from initial contact to deal closure. A sales pipeline calculator simplifies this by providing a quick overview of opportunities at each stage. It helps sales reps identify bottlenecks, prioritize tasks, and make informed decisions to optimize the pipeline. This tool streamlines planning, allowing sales teams to set realistic targets and enhance overall sales performance efficiently.

FAQs

How do I work out how much revenue our open pipeline will bring in?

Multiply the value of qualified open deals by your win rate by value. A ₹20 crore pipeline at a 25% win rate by value should bring in ₹5 crore. Use the rate from the previous four quarters, since one strong month overstates it. The win percentage calculator gives that rate from your won and lost deals.

What pipeline coverage ratio should we plan for this quarter?

Divide 1 by your win rate by value. At a 25% win rate the team needs 4x coverage, so ₹24 crore of qualified pipeline for a ₹6 crore target. A fixed rule such as 3x only works if your win rate is close to 33%. Sales performance management tracks the ratio by rep through the quarter.

Should we count every open deal when we calculate pipeline?

No. Count only qualified deals past a defined stage, and remove deals past their close date with no recent activity. Ten stale deals of ₹50 lakh add ₹5 crore of pipeline and ₹1.25 crore of expected revenue that will not arrive. The sales velocity calculator shows how cycle length affects what closes in time.

How should a rep's quota relate to the pipeline they hold?

Check each quota against the pipeline that rep can build at their own win rate. A rep with a ₹1.5 crore quota and a 25% win rate needs ₹6 crore of qualified pipeline. A quota the pipeline cannot support is a payout the rep cannot reach. Quota and incentive planning software keeps both on one record inside incentive compensation management.

Should sales incentives pay on pipeline created or only on closed revenue?

Pay the main incentive on closed revenue. A small pipeline-creation incentive can suit roles that open deals, such as SDRs. Claw it back when a deal is disqualified within a set window. Keep it a small share of variable pay. The sales commission calculator shows how each part adds up to the payout.

Why does our pipeline look full but the quarter still misses?

Three causes show up again and again. Stale deals stay in the count, large deals are won less often than small ones, and close dates slip past period end. Each one makes coverage look healthier than it is. Review all three before the quarter starts, and coach reps on the stage where their deals stall.

Last reviewed: 11 October 2026

Quotas, attainment and payouts on one record

Kennect holds each rep's quota in the plan and tracks attainment as deals close. It calculates every payout with an audit trail and 90x faster calculation.

Book a demo

Sales Pipeline Calculator: coverage and expected revenue

What each figure means

Does this quarter's pipeline cover a ₹6 crore target?