bcbusiness consulting
← Home

Sales pipeline target calculator

Work backward from a revenue goal. Estimate required wins, then divide by your qualified-opportunity win rate to plan pipeline volume.

Opportunities needed

Calculating…

A planning estimate, not a probability guarantee. Assumes comparable opportunities can close within the target period.

The formula

Wins needed = ceiling(revenue target ÷ average won deal value).
Opportunities needed = ceiling(wins needed ÷ win rate as a decimal).

A $100,000 goal at $10,000 per won deal requires 10 wins. At a 25% win rate, plan for 40 qualified opportunities. At 20%, the same target requires 50.

Use the right denominator

A qualified-opportunity win rate is won opportunities divided by comparable closed opportunities, including losses. It is different from a raw-lead conversion rate. Use a consistent cohort and stage definition; mixing new inquiries with fully qualified prospects makes the estimate unreliable.

Timing matters

A 90-day sales cycle will not usually turn today's new inquiries into this month's revenue. Separate pipeline that can close in the period from earlier-stage work. If the average deal size varies greatly, build a conservative scenario as well as your central estimate.

Make the number actionable

  1. Define a qualified opportunity in writing.
  2. Give each opportunity an owner and a dated next action.
  3. Review stalled opportunities instead of repeatedly pushing close dates.
  4. Track actual wins and deal values, then refresh your assumptions.

Choose between a CRM and a shared spreadsheet.

Request a pipeline workbook for your team