Formula Used
| Metric | Formula |
|---|---|
| Remaining target | Revenue target − adjusted achieved revenue |
| Required won deals | Remaining target ÷ average deal value |
| Required opportunities | Required won deals ÷ win rate |
| Required pipeline | Maximum of remaining target × coverage multiple, or remaining target ÷ win rate |
| Weighted pipeline | Sum of opportunity value × stage probability |
| Pipeline coverage | Current pipeline ÷ remaining target |
| Projected attainment | (Adjusted achieved revenue + weighted pipeline) ÷ revenue target × 100 |
| Daily target | Remaining target ÷ working days remaining × seasonality weighting |
How to Use This Calculator
Enter your revenue target, achieved revenue, average deal value, and expected win rate. Add renewals, upsells, churn, team size, remaining working days, and average sales-cycle length. These values establish the target gap and the practical time available to close it.
Choose stage summary mode for fast planning or detailed opportunity mode for account-level forecasting. In stage summary mode, enter opportunity totals and stage probabilities. In detailed mode, add each opportunity with its owner, value, stage, probability, close date, source, product, and territory.
Adjust the conversion funnel to match your sales process. The calculator works backward from required wins to proposals, meetings, conversations, calls, and emails. Review scenario assumptions to compare downside, expected, and upside outcomes before submitting the form.
After calculation, inspect pipeline coverage, weighted forecast, target pace, team quotas, activity requirements, warnings, and recommended actions. Export the summary to CSV or use the print button to save a PDF report. Treat the probability result as a planning estimate rather than a guaranteed forecast.
Worked Example
A team has a $ 100,000.00 monthly target and has already achieved $ 25,000.00. Its average deal value is $ 10,000.00, expected win rate is 25%, and desired coverage is three times the remaining target. The team has five representatives and twenty working days left.
The remaining target equals $ 75,000.00 before renewal, upsell, or churn adjustments. At an average deal value of $ 10,000.00, the team needs eight additional wins. With a 25% win rate, roughly thirty-two qualified opportunities may be needed.
A three-times coverage goal suggests at least $ 225,000.00 in pipeline. The detailed forecast should then be checked by stage probability and expected close date. Late-stage deals can support the current period, while early-stage deals may belong in a future forecast.
Example Data Table
| Stage | Opportunities | Total Value | Probability | Weighted Value |
|---|---|---|---|---|
| Qualified | 8 | $80,000 | 25% | $20,000 |
| Discovery | 5 | $60,000 | 40% | $24,000 |
| Proposal Sent | 4 | $50,000 | 60% | $30,000 |
| Negotiation | 2 | $35,000 | 80% | $28,000 |
| Total | 19 | $225,000 | — | $102,000 |
CRM and Pipeline Planning Guidance
Pipeline coverage shows whether the total opportunity value is large enough to support the remaining target. A three-times target is common in many teams, but the correct multiple depends on win rate, deal quality, sales cycle, market, and forecast discipline. Lower win rates usually require more pipeline coverage.
Weighted pipeline applies a probability to each opportunity. It is more informative than total pipeline, but it can still mislead when probabilities are outdated or inconsistent. Update stages, probabilities, and close dates regularly so the forecast reflects real buyer progress.
Do not rely only on a single forecast number. Compare conservative, expected, and aggressive scenarios to understand the range of possible outcomes. Use activity planning to translate the revenue gap into daily behaviors that representatives can control.
Review concentration risk when one or two deals represent a large share of the target. Large opportunities may create strong upside, but they also increase forecast volatility. Protect the plan by developing enough qualified opportunities across several accounts, owners, products, sources, and territories.
Frequently Asked Questions
What is pipeline coverage?
Pipeline coverage is current pipeline value divided by the remaining sales target. It shows how much opportunity value supports each unit of revenue still required.
What is weighted pipeline?
Weighted pipeline multiplies each opportunity value by its assigned probability. The result estimates the probability-adjusted revenue expected from open opportunities.
How many deals do I need?
Divide the remaining target by the average deal value. Round upward because a partial deal cannot normally be closed.
Why does required pipeline exceed the remaining target?
Not every opportunity closes successfully. Additional pipeline compensates for losses, delays, smaller deals, and changing buyer priorities.
Should I use stage summary or detailed mode?
Use stage summary for fast planning. Use detailed mode when you need account, owner, product, territory, source, and close-date visibility.
How is target achievement probability estimated?
The calculator combines coverage, weighted pipeline, sales pace, and sales-cycle feasibility. It is a directional planning score, not a statistical guarantee.
Can this calculator handle subscriptions?
Yes. Enter expected renewal and upsell revenue, then apply a churn adjustment. You can use monthly or annual recurring revenue as the target basis.
How often should CRM assumptions be updated?
Update material changes immediately and review the full pipeline at least weekly. High-velocity teams may need daily updates.
Can I save the report as a PDF?
Yes. Use the Print / Save PDF button and select your browser's PDF destination.
Important Disclaimer
This calculator provides planning estimates based on user-entered assumptions. Actual results can differ because of buyer behavior, market conditions, pricing changes, data quality, sales execution, and unexpected delays. Validate important forecasts with current CRM records and management judgment.