Set smarter sales targets using real pipeline inputs. See required deals, leads, and coverage instantly. Download results, share with reps, and iterate monthly easily.
Built for revenue planning, funnel math, and pipeline coverage.
Use this as a starting point, then replace with your real pipeline stats.
| Month | Revenue Target | Avg Deal | Win Rate | Coverage | Deals Needed | Opps Needed | Leads Needed | Pipeline Required |
|---|---|---|---|---|---|---|---|---|
| April | $80,000 | $12,000 | 25% | 3× | 7 | 28 | 140 | $240,000 |
| May | $95,000 | $12,000 | 27% | 3× | 8 | 30 | 150 | $285,000 |
| June | $110,000 | $14,000 | 28% | 3.5× | 8 | 29 | 145 | $385,000 |
Pipeline coverage links your revenue goal to the value you must carry in open opportunities. If you target $250,000 and set a 3× coverage ratio, the calculator recommends $750,000 in pipeline. Coverage protects you from slippage, discounting, and no-decisions. Predictable motions may run near 2×, while new segments often need 3–4×. Review coverage by stage and confirm late-stage deals have clear next steps. Use historical stage aging to validate coverage assumptions.
Two percentages drive the funnel: win rate and lead-to-opportunity conversion. Deals needed equals target revenue divided by average deal size, then rounded up. Opportunities needed equals deals needed divided by win rate. Leads needed equals opportunities needed divided by lead-to-opportunity conversion. With a $15,000 average deal, 25% win rate, and 20% lead-to-opportunity, $250,000 implies 17 deals, 68 opportunities, and 340 leads. Refresh rates each quarter as markets shift.
Targets become actionable when translated into rep-level pacing. The calculator uses an effective rep count: reps multiplied by a ramp factor. With 3 reps at 90% productivity, you have 2.7 effective reps. Required deals, opportunities, and leads are divided by effective reps to produce per-rep targets. Weekly pacing divides required volumes by period weeks, supporting consistent pipeline reviews and coaching. Use for hiring planning.
Revenue plans fail when the activity layer is ignored. Total activities equal leads multiplied by activities per lead, and total meetings equal opportunities multiplied by meetings per opportunity. If you assume six touches per lead and two meetings per opportunity, 340 leads imply 2,040 activities and 68 opportunities imply 136 meetings. Divide by selling days and weeks to set daily touches and weekly meeting goals. Calibrate using activity logs.
The gap section turns planning into prioritization. Pipeline gap equals required pipeline minus current pipeline, floored at zero. Opportunity and lead gaps use the same logic. If required pipeline is $750,000 and current is $120,000, the gap is $630,000, signaling immediate sourcing needs. Pair gaps with cycle length to choose actions: accelerate late-stage deals, create qualified opportunities, or increase top-of-funnel volume. Export results and track progress weekly. Prioritize sources by quality, not raw volume.
It is the pipeline value you need relative to your revenue goal. A 3× ratio means $300,000 pipeline for a $100,000 target. Higher ratios help absorb slippage and lower close rates.
Use your closed-won divided by total closed over the same period, segmented by deal type if possible. If data is noisy, start conservative and tighten after four to eight weekly reviews.
Use an average when your pricing is consistent and discounts are stable. Use a median when a few very large deals skew results. Keep the chosen metric consistent across quarters for comparability.
Ramp scales rep capacity to reflect onboarding, territory resets, or part-time focus. For example, 5 reps at 80% productivity behave like 4 effective reps. This impacts per-rep targets and pacing.
Rounding prevents under-target plans caused by fractions. If you need 16.2 deals, planning for 17 avoids shortfalls. You can still distribute fractional targets across reps by splitting accounts or weeks.
CSV downloads from the server after you calculate, so you can paste into sheets or CRM notes. PDF downloads capture the result block for sharing. Printing is also available for offline reviews.
Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.