Sales Pipeline Calculator

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.

Inputs

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).

What it does

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.

Frequently Asked Questions

What is required pipeline value?

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.

What does "Deals you need to win" mean?

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.

What are concurrent open deals (WIP)?

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.

What does "New deals you need to open per week" mean?

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.

CRM Software for Sales Reps →

Share this calculator:

Add this Free Sales Pipeline Calculator to your Website

Simply copy the code below and paste it into your website. Free to use and share.

<!-- Free Sales Pipeline Calculator - Start -->
<div id="onpipeline-calculator"></div>
<script src="https://freetools.onpipeline.com/pipeline-calculator.min.js" defer></script>
<!-- Free Sales Pipeline Calculator - End -->

Start for Free

No credit card. Free for 14 days.
Keep your data when you subscribe.
Your Full Name
Company Name
Business Email
Choose a password

By continuing, you agree to our Terms and Privacy Policy

Should you have any questions please contact us

Interested but short on time?

Leave your email and we’ll reach out to schedule a conversation with one of our specialists. 

By submitting, you agree to our Privacy Policy

Black Week (23-27): 50% Off Your First Year