Enter Forecast Inputs
Formula Used
- Qualified Leads = Starting Leads × Qualified Lead Rate
- Opportunities = Qualified Leads × Opportunity Creation Rate
- Expected Won Deals = Opportunities × Win Rate × Rep Productivity × Cycle Factor
- Cycle Factor = 365 ÷ (365 + Sales Cycle Days)
- Monthly New Revenue = Expected Won Deals × Average Deal Size × Seasonality Index
- Pipeline Revenue = (Weighted Pipeline Value × Pipeline Realization) × Monthly Seasonality Share
- Expansion Revenue = Renewal Revenue × Expansion Rate
- Monthly Total Revenue = New Revenue + Renewal Revenue + Expansion Revenue + Pipeline Revenue
- Commit Forecast = Monthly Total Revenue × Forecast Confidence
- Annual Forecast = Sum of all monthly total revenue values
How to Use This Calculator
- Enter current lead generation, conversion rates, and average deal size.
- Add sales cycle length and rep productivity to reflect execution speed.
- Include weighted pipeline value and the percent likely to close this year.
- Enter renewal and expansion assumptions to capture recurring revenue impact.
- Adjust quarterly seasonality factors to mirror your historical close pattern.
- Set annual quota, forecast confidence, and scenario spread for planning ranges.
- Press Generate Annual Forecast to view results above the form.
- Use the CSV or PDF buttons to export the report for meetings.
Example Data Table
| Scenario | Starting Leads | Win Rate | Average Deal Size | Weighted Pipeline | Annual Forecast |
|---|---|---|---|---|---|
| Base Plan | 220 | 24% | $6,500 | $180,000 | $690,000 |
| Growth Push | 260 | 26% | $7,200 | $220,000 | $828,400 |
| Enterprise Mix | 140 | 19% | $14,000 | $260,000 | $941,300 |
| SMB Volume | 340 | 21% | $4,100 | $140,000 | $612,900 |
These figures are illustrative examples for benchmarking assumptions and testing scenarios.
FAQs
1. What does this calculator forecast?
It estimates annual sales revenue from lead flow, conversion rates, deal size, current weighted pipeline, renewals, expansion, and seasonality. It also shows commit, best-case, and worst-case views.
2. Why include weighted pipeline value?
Weighted pipeline captures active opportunities already in motion. That makes the forecast more realistic than relying only on future lead generation and conversion assumptions.
3. What is the forecast confidence input for?
Confidence converts the base forecast into a tighter commit view. Higher confidence implies more trust in assumptions and creates a narrower upside and downside range.
4. How should I set seasonality factors?
Use historical close patterns by quarter. If your team usually closes more revenue in Q4, assign Q4 a higher factor and keep earlier quarters slightly lower.
5. Can I use this for a new sales team?
Yes. Start with benchmark conversion rates, modest productivity, and conservative confidence. Then revise the model monthly as actual CRM performance becomes available.
6. Why is sales cycle length part of the model?
Longer cycles delay revenue realization. The cycle factor reduces expected closed business inside the forecast period so totals better match actual timing.
7. Does this replace CRM forecasting reports?
No. It complements CRM reports by combining top-of-funnel assumptions, recurring revenue, and scenario planning into one planning-friendly forecast view.
8. How often should I update the forecast?
Update it monthly at minimum. Refresh sooner when conversion rates, deal size, staffing, pricing, or pipeline health changes materially.