Calculator inputs
Example data table
| Scenario | Adjusted Goal | Current Revenue | Avg Deal | Win Rate | Deals Needed | Pipeline Needed |
|---|---|---|---|---|---|---|
| SMB outbound team | $630,000 | $210,000 | $9,000 | 24% | 47 | $1,470,000 |
| Mid-market team | $1,260,000 | $325,000 | $18,000 | 25% | 52 | $3,272,500 |
| Enterprise pod | $2,100,000 | $900,000 | $70,000 | 31% | 18 | $4,200,000 |
Formula used
Adjusted Goal = Base Revenue Goal × (1 + Stretch Buffer % ÷ 100)
Revenue Gap = max(Adjusted Goal − Current Revenue, 0)
Attainment % = (Current Revenue ÷ Adjusted Goal) × 100
Expected Revenue = Adjusted Goal × (Months Elapsed ÷ Period Months)
Monthly Needed = Revenue Gap ÷ Remaining Months
Deals Needed = Revenue Gap ÷ Average Deal Size
Opportunities Needed = Deals Needed ÷ Win Rate
Leads Needed = Opportunities Needed ÷ Lead to Opportunity Rate
Pipeline Needed = Revenue Gap × Pipeline Coverage Ratio
Pipeline Gap = max(Pipeline Needed − Current Open Pipeline, 0)
This calculator converts a top-line revenue target into practical execution metrics. It helps sales leaders connect revenue planning with pipeline generation, opportunity creation, lead volume, daily activity, and rep-level accountability.
How to use this calculator
- Enter your base revenue goal for the period.
- Add a stretch buffer if you want a more aggressive target.
- Fill in current booked revenue and open pipeline value.
- Enter conversion inputs like average deal size, win rate, and lead-to-opportunity rate.
- Set the planning period, elapsed time, working days, and team size.
- Optionally include average calls and emails required per lead.
- Click Calculate revenue goal to see the results above the form.
- Use the CSV or PDF buttons to export the plan for meetings or tracking.
FAQs
1. What does the stretch buffer do?
It raises the original goal by a chosen percentage. Teams use it to create a tougher target for uncertainty, discounts, churn, or ambitious board expectations.
2. Why does pipeline coverage matter?
Revenue gaps are rarely closed with one-to-one pipeline. Coverage ratios account for slippage, no-decisions, deal loss, and timing risk inside the funnel.
3. Should I use booked revenue or invoiced revenue?
Use the revenue metric your team manages against. Booked revenue works for quota planning, while invoiced or recognized revenue may fit finance reporting better.
4. What if my win rate changes by segment?
Run separate scenarios for SMB, mid-market, or enterprise. Segment-specific calculations usually produce more realistic goals than blended averages.
5. Why are deals and leads rounded up?
Sales teams cannot usually close a fraction of a deal or source part of a lead. Rounding up gives a safer execution target.
6. Can this calculator help rep capacity planning?
Yes. The per-rep revenue, deals, and leads outputs show whether your current headcount can reasonably support the remaining target.
7. How should I choose the pipeline coverage ratio?
Use historical funnel quality and stage conversion data. Many teams start near 3× to 5×, then refine the ratio by stage mix and forecast accuracy.
8. Is the graph a forecast or a guarantee?
It is a directional forecast based on your inputs. It helps planning, but actual outcomes still depend on deal timing, conversion quality, and execution.