How many open deals do they need to reach your revenue goal?
The Sales Pipeline Calculator below helps you determine how much pipeline you need to achieve your revenue target. Enter your revenue goal, win rate, average deal value, and sales cycle length to estimate the number of opportunities and deals required to stay on track.
Revenue target (USD)
Your revenue goal for the selected period.
Win rate (%)
Historical close rate from your CRM (won deals ÷ total qualified).
ARPA / Average deal value (USD)
Used to estimate how many deals you’ll need.
Sales cycle (days)
Average number of days to win a deal.
Target period (days)
Length of the goal period in days (e.g., 30 for monthly, 90 for quarterly).
Required pipeline value
If your target is $500k and win rate is 25%, you need about $2M in pipeline value.
Deals you need to win
If ARPA is $5,000 and the target is $500k, you need 100 deals.
Total open deals required
If you need 100 deals and win rate is 25%, plan for ~400 total deals during the period.
Average concurrent open deals (WIP)
The average number of deals that must stay active at any time.
Window to open new deals
Open new deals within the number of days shown from the start of the period.
New deals you need to open per week
The total opportunities required are spread across the weeks remaining.
Required pipeline value is the total value of opportunities needed in your sales pipeline to achieve your revenue target. It is calculated using your revenue goal and historical win rate. Lower win rates require a larger pipeline value, while higher win rates reduce the amount of pipeline needed.
This metric shows the number of deals that must be successfully closed to reach your target revenue. It is based on your revenue goal and average deal value, helping you understand the volume of wins required during the selected period.
Concurrent open deals, or Work In Progress (WIP), represent the number of opportunities that need to be active in your pipeline at the same time. This calculation takes your sales cycle into account and helps you understand the pipeline capacity required to consistently achieve your sales goals.
This metric estimates how many new opportunities must enter your pipeline each week to generate enough closed deals by the end of the target period. It helps sales teams plan prospecting activities and maintain a healthy flow of opportunities.
Share this calculator:
Should you have any questions please contact us
