Pipeline Value Calculator

Setting it out

Pipeline value is the sum of open opportunities weighted by their probability of closing: Σ(deal value × stage probability).

Unweighted pipeline is the total of everything open, which is always a much larger and much less useful number.

The coverage ratio, pipeline against the target for the period. Is the related figure, and 3× to 4× is the conventional expectation.

A concrete case

Open pipeline of $340,000 unweighted, distributed across stages: $120,000 at 20%, $140,000 at 50%, $80,000 at 80%. Weighted value is $24,000 + $70,000 + $64,000 = $158,000.

Against a quarterly target of $150,000, weighted pipeline covers it with a small margin. Against the unweighted $340,000 the business would appear to have more than double the coverage it has.

Coverage on the unweighted figure is 2.3×, which is below the conventional 3× and suggests the pipeline is thin rather than comfortable.

The two readings support opposite decisions about whether to increase lead generation this month.

What the number hides

Stage probabilities are usually assigned by convention rather than measured, and self-reported confidence is optimistic. A stage nominally at 50% that historically closes at 30% inflates the whole calculation.

Pipeline also ages badly. An opportunity open for six months in a 21-day cycle is not a 50% deal regardless of what stage it sits in.

Where to go from here

Derive stage probabilities from historical close rates rather than assigning them. Most CRM defaults are round numbers that were never checked against outcomes.

Then apply an age filter, moving stale opportunities to a much lower probability or out of the pipeline entirely. A pipeline that is never cleaned reports a forecast made of deals that ended months ago.

Coverage ratio and what it is really telling you

The 3× convention exists because roughly a third of weighted pipeline typically closes in the period. A business with a much higher close rate needs less coverage and one with a lower rate needs more.

Calculating your own historical ratio, pipeline at the start of a period against what actually closed, replaces the convention with a number that fits the business.

That figure then becomes the lead generation target rather than a rule of thumb, which connects marketing volume to sales outcomes in a way most businesses assert rather than calculate. It also makes the consequence of a thin pipeline visible early enough to act on, rather than at the end of a quarter that has already been missed.

Pipeline created rather than pipeline held is the leading indicator worth watching, since the held figure reflects past activity while creation reflects current demand generation.

A business with strong held pipeline and weak creation has a quarter that will look fine and a following one that will not.

Reviewing aged opportunities on a schedule keeps the figure honest, and the discipline of closing them out is what stops a forecast quietly filling with deals that ended long ago.

Weighting by historical close rate per source, rather than per stage alone, sharpens the forecast considerably where lead sources differ in quality.