Sales Pipeline Calculator

Project what your funnel will produce, or work backwards from a target to size the leads, opportunities, and pipeline coverage you need to hit it.

The pipeline is the clearest early-warning signal you have for whether revenue will land. Run it forwards to forecast from your funnel, or backwards to reverse-engineer the volume behind a number, then pressure-test it against the 3x coverage benchmark B2B SaaS teams rely on.

Project revenue
Plan from target
Project Revenue From Your Funnel
Enter your funnel volume and conversion rates to forecast opportunities, wins, and revenue. All inputs must cover the same period.
The number you need to hit this period
$
Worked leads entering the pipeline this period
B2B SaaS benchmark ≈ 15%
%
B2B SaaS benchmark ≈ 25%
%
Avg revenue per closed-won deal
$
Projected Revenue
$0
Funnel Breakdown
Benchmark Check
Lever Simulator

Build a pipeline you can trust

Revenue Grid flags stalled deals, missing stakeholders, and forecast risk in real time — so you keep coverage above the line without chasing dirty data.

Book a Demo →

Math is exact; accuracy depends on clean CRM inputs. Use rolling 90-day averages for conversion rates and ACV.

How to Use the Sales Pipeline Calculator

The calculator runs in two directions. Project forwards from your funnel to a revenue number, or plan backwards from a target to the leads you need. Both use the same three conversion inputs, so you can switch modes without re-entering everything.

1

Pick a direction. Use Project (Forward) when you already have leads and want the revenue they will produce. Use Plan (Backward) when you have a target and need to know the volume to hit it.

2

Enter your two conversion rates: lead-to-opportunity and opportunity-to-win. Use a rolling 90-day average rather than a single best month so the projection holds up.

3

Add your average deal value (ACV). Keep it to the revenue booked per closed-won deal, and make sure every input covers the same period.

4

Fill the mode-specific field. In Project mode, enter qualified lead volume (a sales target is optional, but it unlocks the coverage and gap checks). In Plan mode, enter the revenue target.

5

Calculate, then read the headline first: projected revenue in Project mode, or leads needed in Plan mode. The funnel breakdown shows where each number comes from stage by stage.

6

Check the risk signals and the lever simulator. The simulator shows the dollar (or lead) impact of a 10% lift on each input, so you can see which fix moves the number most for the least spend.

Interpreting Your Results: Project mode tells you whether your current funnel will clear the target and where it falls short. Plan mode tells you the lead, opportunity, and pipeline volume to build before the period starts. Run both and the gap between them is your early-warning signal.

Pro Tip: Recalculate at the start of each quarter in Plan mode to set lead targets, then re-run Project mode mid-quarter with live numbers. If the projection drops below target while coverage looks fine, the leak is in conversion, not volume.

Sales Pipeline Formulas

Forward (Project): Revenue = Leads × Lead-to-Opp % × Opp-to-Win % × ACV Backward (Plan): Leads Needed = (Target ÷ ACV) ÷ Opp-to-Win % ÷ Lead-to-Opp % Coverage Check: Coverage = Open Pipeline Value ÷ Revenue Target (aim for 3x)
Explanation of Each Term:
  • Qualified Leads: The leads entering your pipeline for the period being measured.
  • Lead-to-Opportunity Rate: The share of leads that become qualified opportunities.
  • Opportunity-to-Win Rate: The share of opportunities that close won — your win rate.
  • Average Deal Value (ACV): Average revenue booked per closed-won deal.
  • Open Pipeline Value: Opportunities × ACV — the dollar value of deals currently in play.
Important Note: Coverage and revenue answer different questions. You can clear the 3x coverage benchmark and still miss the target if your win rate is low, because coverage measures pipeline size while revenue depends on conversion.

Understanding Your Results

Pipeline health comes down to coverage depth and conversion efficiency. Here is how to read the signals the calculator surfaces:

Positive Indicators (Healthy Pipeline)

Coverage of 3x or more:

Enough open pipeline to absorb normal deal slippage and still hit quota.

Lead-to-opp above 15%:

Strong qualification and a clear fit with your ideal customer profile.

Opp-to-win above 25%:

An efficient mid-funnel that converts deals without heavy leakage.

Projected revenue meets target:

Your funnel clears the goal at current rates — no structural gap.

Warning Indicators (Requires Attention)

Coverage below 3x:

The pipeline is too thin to survive normal loss rates.

Lead-to-opp below 10%:

Usually a targeting or qualification problem upstream of sales.

Opp-to-win below 15%:

A mid-funnel leak: stalled deals, missing stakeholders, weak qualification.

Projected below target:

Adding leads is the slowest fix — move a conversion lever first.

Key Metrics to Monitor

Pipeline Coverage Ratio:

Target at least 3:1 (open pipeline vs. revenue target).

Conversion Rates:

Track lead-to-opp and opp-to-win over time; they drive everything downstream.

Lever Sensitivity:

A 10% lift on any single input moves projected revenue by the same 10%.

Gap to Target:

The shortfall between projected revenue and the goal, period over period.

How Revenue Grid Helps: Revenue Grid keeps these numbers live instead of static. It captures every email, meeting, and CRM update automatically, then flags stalled deals, missing stakeholders, and forecast drift — so coverage and conversion stay above the line without manual data entry.

Example Calculation:

Scenario: A mid-market SaaS team enters 1,200 qualified leads, a 15% lead-to-opp rate, a 25% opp-to-win rate, an $18,000 ACV, and a $1,000,000 quarterly target.

Calculation:

  • Opportunities: 1,200 × 15% = 180
  • Deals Won: 180 × 25% = 45
  • Revenue: 45 × $18,000 = $810,000
  • Open Pipeline: 180 × $18,000 = $3.24M (3.2x coverage)

Analysis: Coverage looks healthy at 3.2x, but projected revenue lands at $810,000 — a $190,000 gap to the $1M target. The shortfall is structural: it comes from conversion, not pipeline size, which is why more leads alone would not close it.

Improvement Strategy: A 10% relative lift on any single lever adds about $81,000. The fastest paths:

  • Lift opp-to-win from 25% to 27.5% by fixing the mid-funnel leak
  • Lift lead-to-opp from 15% to 16.5% with tighter qualification
  • Stack both conversion levers — the gains compound
  • Raise ACV through packaging before buying more leads

About RevenueGrid

RevenueGrid is an AI-powered revenue intelligence platform that brings clarity and guidance to every stage of your sales process. By analyzing customer interactions, deal progression, and sales activities, RevenueGrid provides actionable insights that help teams close more deals and accelerate revenue growth.

Our platform seamlessly integrates with Salesforce to capture sales data, eliminate manual entry, and deliver predictive analytics that transform how sales teams operate.

Trusted by 900,000 sales professionals globally

Hear it straight from our customers

User Image
User Image

Revenue Grid allows us to work much more efficiently by capturing all our Outlook contacts, correspondence, and meetings and updating Salesforce automatically.

Tasha. K
RevOps Manager

Ready to Build a Pipeline You Can Trust?

A calculator shows you the gap. Revenue Grid helps you close it — surfacing stalled deals, missing stakeholders, and forecast risk so your team lifts conversion without hiring more reps.

Join 800,000+ revenue and operations professionals who use Revenue Grid to keep their pipeline honest and their forecast accurate.

Frequently Asked Questions

What is a sales pipeline calculator and why does it matter? arrow
It converts your funnel into numbers. Forwards, it turns lead volume and conversion rates into projected opportunities, wins, and revenue. Backwards, it turns a revenue target into the leads and pipeline you need. It matters because the pipeline is the earliest reliable signal of whether revenue will land — long before deals actually close.
What is the difference between a pipeline and a funnel? arrow
The funnel is the conversion path leads travel: lead to opportunity to win. The pipeline is the dollar value of the deals currently moving through it. This calculator uses both — funnel rates drive the math, and pipeline value drives the coverage check.
What is pipeline coverage, and what is a good ratio? arrow
Coverage is open pipeline value divided by your revenue target. The common B2B SaaS benchmark is 3x, which gives enough cushion to absorb normal slippage. Much above 4x can mean stalled deals are padding the figure; below 3x, the pipeline is usually too thin to hit quota.
Should I calculate forwards or backwards? arrow
Use Project (forward) when you already have leads and want to know the revenue they will produce. Use Plan (backward) when you have a target and need to know the lead and pipeline volume to hit it. Running both is most useful: the gap between them shows whether your funnel is on track.
Which lever has the biggest impact on revenue? arrow
Mathematically, a 10% lift on any single input — leads, lead-to-opp, opp-to-win, or ACV — moves revenue by the same 10%. The difference is cost. The two conversion levers require no extra ad spend, so improving qualification and fixing the mid-funnel leak is usually the highest-leverage move.
How often should I recalculate? arrow
Run Plan mode at the start of each quarter to set lead targets, then re-run Project mode weekly or monthly with live numbers. If the projection slips below target while coverage still looks fine, the problem is conversion, not volume.
How does Revenue Grid improve pipeline health? arrow
It keeps the inputs honest. Revenue Grid captures every email, meeting, and CRM signal automatically, then flags stalled deals, missing stakeholders, and forecast drift in real time — so coverage and conversion rates stay accurate without manual updates.
What if my CRM data is incomplete? arrow
Use conservative estimates to start: a rolling 90-day average for each conversion rate and your typical ACV. The output is only as reliable as the inputs, so closing CRM gaps — especially win rate and pipeline hygiene — is the single biggest accuracy improvement you can make.
How accurate is this calculator? arrow
The math is exact; the accuracy depends on your inputs. Use real, recent conversion rates and a representative ACV and the projection holds up well. It models a steady-state funnel, so treat it as a planning and diagnostic tool rather than a guarantee for any single deal.
close
expand_less