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
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
- Define a qualified opportunity in writing.
- Give each opportunity an owner and a dated next action.
- Review stalled opportunities instead of repeatedly pushing close dates.
- Track actual wins and deal values, then refresh your assumptions.