Pipeline Value Calculator
Pipeline Value Calculator
Number of active, qualified deals currently in your pipeline
Average contract or deal value per opportunity
Your historical win rate — closed won deals ÷ total opportunities
Average number of days from opportunity creation to close (used for velocity)
Your monthly or quarterly revenue goal (optional — enables coverage ratio)
Sets the benchmark coverage ratio for health status
Enter Your Pipeline Data
Fill in the number of opportunities, average deal size, and win rate to calculate your weighted pipeline value, coverage ratio, and velocity.
Weighted pipeline value, coverage ratio, and velocity in one place
Managing a sales pipeline means knowing exactly how much revenue you can realistically expect to close — not just how many deals are open. The Pipeline Value Calculator helps sales teams, revenue operations leaders, and business owners quantify what their pipeline is actually worth by weighting every deal or stage by its true close probability. Most sales teams track total pipeline value, but that number is misleading. A $5 million pipeline where most deals are in early prospecting stages is very different from a $5 million pipeline full of deals in active negotiation. Weighted pipeline value solves this by multiplying each deal's dollar amount by the probability it will actually close. The result is a far more reliable forecast of expected closed revenue. The calculator supports two modes. Simple mode is designed for quick calculations — enter the number of qualified opportunities, your average deal size, overall win rate, and optionally your sales cycle length and revenue target. Advanced mode unlocks full multi-stage pipeline management: add up to eight pipeline stages, each with its own deal amount and win probability. This mirrors how modern CRMs like Salesforce and HubSpot compute weighted pipeline forecasts. Beyond the core weighted pipeline number, the calculator surfaces several critical metrics. Pipeline coverage ratio tells you how many times over your weighted pipeline covers your revenue target. Industry benchmarks show you what healthy coverage looks like for your segment — SaaS companies typically target 3–4x coverage, enterprise sales require 4–5x, mid-market B2B aims for 2.5–4x, and high-velocity SMB teams often manage with 2–3x. Anything below 1x is at risk. Pipeline velocity reveals the daily, monthly, and quarterly rate of revenue flowing through your pipeline. The formula — (Opportunities × Average Deal Size × Win Rate) ÷ Sales Cycle Days — is the industry standard used by RevOps teams and CRM platforms alike. This tells you not just how much revenue you might close, but how fast it arrives. The goal-backward calculation is particularly valuable for quarterly planning. Enter your revenue target and the calculator instantly tells you how many qualified opportunities you need in the pipeline right now, and how large your total pipeline must be to hit quota at your current win rate. The optimal pipeline size calculator uses the industry benchmark for your segment to answer the question: how much pipeline do I need to build? Scenario modeling provides best-case (+20% probability), most-likely (base), and worst-case (-30% probability) forecasts so you can plan for uncertainty. The stage contribution breakdown — including a donut chart — shows which pipeline stages are contributing the most to weighted value, helping you identify where to focus coaching, deal acceleration, and resource allocation. All results can be exported to CSV for use in spreadsheets, CRM reports, or board presentations. The print view generates a clean summary for team meetings and QBRs.
Understanding Sales Pipeline Value
What Is Weighted Pipeline Value?
Weighted pipeline value is the sum of all deal values in your pipeline, each multiplied by its probability of closing. For example, a $100,000 deal at 25% probability contributes $25,000 to weighted pipeline value. Unweighted pipeline adds up raw deal amounts without probability adjustment, which consistently overstates expected revenue. Weighted pipeline is what CRMs actually use to generate revenue forecasts, because it accounts for the fact that not every open deal will close. The formula is: Weighted Pipeline Value = Sum of (Deal Amount × Close Probability) across all active opportunities.
How Is Pipeline Value Calculated?
The core formula is straightforward: Weighted Pipeline = Σ(Stage Amount × Stage Win Rate%). In simple mode with a single win rate, this becomes: Opportunities × Average Deal Size × Win Rate. In advanced mode, each stage has its own amount and probability, which is more accurate because close rates genuinely differ at each stage — a deal in negotiation is far more likely to close than one in prospecting. Pipeline velocity adds a time dimension: (Opportunities × ACV × Win Rate) ÷ Sales Cycle Days = daily revenue generation rate. Coverage ratio compares weighted pipeline to your quota: Coverage = Weighted Pipeline ÷ Revenue Target.
Why Does Pipeline Coverage Ratio Matter?
Pipeline coverage ratio directly predicts whether you will hit quota. If your coverage is below 1x, you mathematically cannot close enough to meet your target — you need to build more pipeline immediately. A ratio of 3x means for every dollar of quota, you have three dollars of weighted pipeline, giving you a buffer for deals that slip or go cold. Revenue operations teams monitor this weekly. Sales managers use it to decide whether to accelerate deals, run prospecting sprints, or adjust forecasts. Industry benchmarks matter: SaaS companies target 3–4x because deals frequently slip quarters; enterprise sales need 4–5x due to long, unpredictable cycles.
Limitations of Pipeline Value Calculators
Pipeline value calculations are only as good as the underlying data. Win rates must reflect actual historical performance, not aspirational targets. Deal amounts should be realistic ACVs, not best-case scenarios. Probability percentages by stage should be calibrated from real closed-won data, ideally segmented by deal size, market segment, and rep performance. Static calculators also do not account for deal age — a $500,000 negotiation-stage deal that has been stalled for six months is worth far less than the probability suggests. Regular pipeline hygiene (removing stale or poorly qualified deals every week) is essential for these numbers to remain meaningful. The calculator provides estimates based on the inputs provided and should be used alongside CRM data and management judgment.
Formulas
Sums each deal or stage value multiplied by its win probability. In simple mode: Opportunities × Average Deal Size × Win Rate. This produces a realistic revenue forecast that accounts for the fact that not every deal will close.
Measures how many times your weighted pipeline covers your quota. A 3x ratio means you have three dollars of expected revenue for every dollar of target. Industry benchmarks: SaaS 3-4x, Enterprise 4-5x, Mid-Market 2.5-4x, SMB 2-3x.
Calculates the daily rate at which revenue flows through your pipeline. Multiply by 30 for monthly or 90 for quarterly velocity. Improving any of the four inputs (more deals, larger deals, higher win rate, shorter cycle) increases velocity.
Works backward from your revenue goal to determine how many qualified opportunities you need in your pipeline right now. Accounts for the fraction of deals that will not close by dividing by win rate.
Reference Tables
Pipeline Coverage Benchmarks by Industry Segment
| Segment | Target Coverage | Healthy Range | Sales Cycle | Typical Win Rate |
|---|---|---|---|---|
| SaaS | 3–4× | 3×–5× | 30–90 days | 20–30% |
| Enterprise | 4–5× | 4×–6× | 90–270 days | 15–25% |
| Mid-Market B2B | 2.5–4× | 2.5×–5× | 45–120 days | 20–35% |
| SMB / High-Velocity | 2–3× | 2×–4× | 14–45 days | 25–40% |
| Services / Consulting | 2–3× | 2×–4× | 30–90 days | 30–50% |
Standard Pipeline Stage Probabilities
| Stage | Typical Win Rate | Activities at This Stage | Average Time in Stage |
|---|---|---|---|
| Prospecting / Lead | 5–10% | Initial outreach, cold calls, inbound qualification | 1–2 weeks |
| Qualification / Discovery | 15–25% | Needs analysis, budget/authority confirmation, pain identified | 1–3 weeks |
| Proposal / Demo | 40–60% | Solution presentation, pricing proposal, stakeholder demo | 2–4 weeks |
| Negotiation | 65–80% | Contract review, legal, procurement, terms negotiation | 2–6 weeks |
| Closing / Contract Sent | 85–95% | Final signatures, PO processing, onboarding handoff | 1–2 weeks |
Worked Examples
Simple Pipeline Valuation and Velocity
Unweighted pipeline: 30 × $20,000 = $600,000
Weighted pipeline: $600,000 × 25% = $150,000
Coverage ratio: $150,000 / $200,000 = 0.75×
Daily velocity: (30 × $20,000 × 0.25) / 45 = $3,333/day
Monthly velocity: $3,333 × 30 = $100,000/month
Quarterly velocity: $3,333 × 90 = $300,000/quarter
Multi-Stage Advanced Pipeline Calculation
Prospecting: $200,000 × 10% = $20,000 (5.3%)
Qualification: $150,000 × 25% = $37,500 (9.9%)
Proposal: $300,000 × 50% = $150,000 (39.6%)
Negotiation: $180,000 × 75% = $135,000 (35.6%)
Closing: $80,000 × 90% = $72,000 (19.0%)
Unweighted total: $910,000
Weighted total: $20,000 + $37,500 + $150,000 + $135,000 + $72,000 = $414,500
Goal-Backward Planning for Quarterly Target
Deals needed to close: $500,000 / $25,000 = 20 deals
Opportunities required: 20 / 0.20 = 100 qualified opportunities
Optimal weighted pipeline: $500,000 × 3.5 = $1,750,000
Optimal unweighted pipeline: $1,750,000 / 0.20 = $8,750,000
Per month (assuming 90-day quarter): ~33 new opportunities per month needed
How to Use This Calculator
Choose Simple or Advanced Mode
Use Simple Mode for a quick three-field calculation using overall opportunities, deal size, and win rate. Switch to Advanced Mode to define individual pipeline stages — each with its own deal amount and close probability — for a more accurate weighted forecast that mirrors how CRMs calculate expected revenue.
Enter Your Pipeline Data
In Simple Mode, enter the count of qualified opportunities, your average deal size in dollars, and your historical win rate as a percentage. Add your sales cycle length in days to unlock pipeline velocity. In Advanced Mode, enter amounts and win rates for each stage. Click 'Load Defaults' to pre-fill the standard five-stage pipeline (Prospecting 10%, Qualification 25%, Proposal 50%, Negotiation 75%, Closing 90%).
Set a Revenue Target for Coverage Analysis
Enter your monthly or quarterly revenue target (quota) to see your pipeline coverage ratio. This tells you whether your weighted pipeline is sufficient to hit quota — a ratio of 3x means you have three dollars of expected pipeline for every dollar of quota. Select your industry segment to compare against the relevant benchmark (SaaS: 3–4x, Enterprise: 4–5x, SMB: 2–3x).
Review Results and Export
Examine the weighted pipeline value, coverage ratio and health status, pipeline velocity, goal-backward deal counts, and scenario analysis (best/most-likely/worst case). In Advanced Mode, the stage breakdown chart shows each stage's weighted contribution. Export results to CSV for CRM reporting or board presentations, or print a clean summary for team reviews.
Frequently Asked Questions
What is the difference between weighted and unweighted pipeline value?
Unweighted pipeline is the simple sum of all open deal values — it treats every deal as if it will certainly close, which always overstates expected revenue. Weighted pipeline multiplies each deal's value by its probability of closing, producing a realistic forecast of revenue you can actually expect to recognize. For example, a $100,000 deal at a 25% close probability contributes $25,000 to weighted pipeline. Most CRMs use weighted pipeline for revenue forecasting. Unweighted pipeline still has uses — it shows you the ceiling of potential revenue and how much business you have engaged — but for quota planning, weighted pipeline is the metric that matters.
What is a healthy pipeline coverage ratio?
Pipeline coverage ratio is your weighted pipeline value divided by your revenue target, expressed as a multiplier. A ratio of 3x means you have three dollars of expected pipeline for every dollar of quota. Most sales organizations target a minimum of 3x coverage at the start of a quarter. Industry benchmarks vary: SaaS companies typically maintain 3–4x because deals frequently slip quarters; enterprise sales teams carry 4–5x due to long and unpredictable cycles; mid-market B2B targets 2.5–4x; high-velocity SMB teams often manage with 2–3x. Below 1x coverage means it is mathematically impossible to close enough to hit quota.
How is pipeline velocity calculated?
Pipeline velocity measures the daily rate at which revenue flows through your pipeline. The formula is: Pipeline Velocity = (Number of Qualified Opportunities × Average Deal Size × Win Rate) ÷ Sales Cycle Length in Days. The result is daily revenue generation. Multiply by 30 for monthly velocity, by 90 for quarterly. For example, if you have 20 deals averaging $25,000 each with a 25% win rate and a 60-day cycle, your daily velocity is (20 × $25,000 × 0.25) ÷ 60 = $2,083 per day, or about $62,500 per month. Improving any of the four inputs increases velocity.
What pipeline stage probabilities should I use?
The most accurate probabilities come from your own historical data — divide closed-won deals by total opportunities that reached each stage. If you lack this data, standard industry defaults are a reasonable starting point: Prospecting 10%, Qualification 25%, Proposal 50%, Negotiation 75%, and Closing / Contract Sent 90%. These defaults are widely used across CRM platforms and sales methodology frameworks. For more accuracy, segment your win rates by deal size, market segment, and sales rep. Probabilities should be reviewed quarterly and updated as market conditions or your sales process changes.
How do I use the goal-backward calculation?
The goal-backward analysis answers a critical planning question: given my revenue target, how many deals and qualified opportunities do I need right now? Enter your revenue target and the calculator computes deals needed to close (Target ÷ Average Deal Size) and the total qualified opportunities required (Deals Needed ÷ Win Rate). It also shows the optimal total pipeline needed to maintain the industry benchmark coverage ratio for your segment. Use this output to drive weekly prospecting targets, set SDR quotas, and determine whether you need to accelerate existing deals or build more top-of-funnel pipeline.
What is scenario analysis and when should I use it?
Scenario analysis models three versions of your pipeline outcome: best case (+20% on weighted value), most likely (the base calculation), and worst case (-30% on weighted value). Best case applies if close rates improve due to strong market conditions, deal acceleration, or competitive advantages. Worst case reflects slippage, lost deals, or economic headwinds. Use scenario analysis in quarterly planning sessions, board presentations, and budget reviews. It helps leadership understand the revenue range, not just a single-point forecast, enabling better hiring, spend, and capacity decisions. Most RevOps teams present all three scenarios to their CFO and CEO.