Sales Pipeline Calculator
Model your funnel stages and conversion rates to forecast monthly and annual revenue.
About Sales Pipeline Calculator
What it does
Calculates the exact pipeline value you need to hit your revenue target, factoring in stage-weighted probabilities, win rates, and average deal sizes across each pipeline stage.
Why it matters
78% of sales leaders say they don't have enough pipeline to hit quota. This calculator shows the exact dollar gap so you can take action before it's too late.
Definition
Pipeline calculation uses weighted opportunity values (deal amount × stage probability) to forecast expected revenue and determine required pipeline coverage for target attainment.
Assumptions
- Stage probabilities are calibrated to your actual win rates
- Average deal sizes are consistent with historical performance
- Pipeline coverage ratio of 3-4x is recommended
How to interpret your results
If your current pipeline is below the required amount, you need to generate more top-of-funnel. If it's above but you're still missing, your conversion rates need work.
How to improve
Clean your pipeline weekly
Remove stalled and dead deals to get an accurate coverage picture
Calibrate stage probabilities
Use actual historical data, not gut feelings, to set probability percentages
Build pipeline consistently
Prospecting should happen daily, not just when the pipeline looks thin
Pipeline Stages
Revenue Forecast
30
Won Deals/mo
$150K
Monthly Revenue
$1.8M
Annual Revenue
Pipeline Visualization
💡 Tip: Try changing a single conversion rate by 5% to see how it impacts revenue downstream.
What the Sales Pipeline Calculator does
The Sales Pipeline Calculator reverse-engineers your quota into the pipeline that has to exist for you to hit it. In plain words: pipeline required = revenue goal ÷ win rate, and opportunities required = pipeline required ÷ average deal size. Feed in your sales cycle length and the calculator goes one step further — how many new deals you must open each week to keep that pipeline full.
Small teams need this math more than large ones, because they feel pipeline gaps later and harder. When a deal slips in a fifty-rep organization, another deal covers it; in a three-person business, one slipped deal is the month. Knowing your required coverage turns "hope we close enough" into a number you can check every Monday.
How to use the Sales Pipeline Calculator
Enter your revenue goal and win rate
Use your actual historical win rate, not the one you would like to have. This single input moves the answer more than any other.
Add deal size and cycle length
The calculator converts required pipeline value into a count of opportunities and shows how the sales cycle spreads them across the period.
Turn the result into a weekly target
Divide the required new opportunities across the weeks available and make that weekly deal-creation number the team's standing commitment.
How to read your results
Current pipeline meets the requirement
You have the raw material — the job shifts to protecting it. Watch for aging deals padding the total, and keep prospecting anyway: pipeline you open this month is what covers next quarter.
A moderate gap
Closable with focus. Set the weekly deal-creation target, work dormant leads already in your system, and consider whether nudging win rate through faster follow-up shrinks the requirement from the other side.
A large gap
The quota and the pipeline are telling two different stories, and the pipeline is the honest one. Either commit real resource to lead generation or reset the goal — carrying an impossible target all year damages morale more than a revised number does.
Real-world examples
A web design studio starting the year blind
The founder set a revenue goal but had never connected it to pipeline. The calculator showed his win rate and deal size required roughly two new qualified opportunities every week — far above his current one-a-fortnight pace. He committed two mornings a week to outreach rather than discovering the shortfall in October.
A B2B services firm testing a quota before announcing it
Before communicating next year's team quota, the sales lead ran it through the calculator and found the implied pipeline requirement exceeded anything the team had ever built. She trimmed the quota and paired it with a funded lead-generation plan, so the target announced was one the math actually supported.
Related free tools
Sales Pipeline Calculator — frequently asked questions
Quick answer
What pipeline coverage ratio do I need to hit quota?
- How do you calculate pipeline requirements
- What is a 3x pipeline coverage rule
- How often should I recalculate my pipeline requirement