Enter Forecast Inputs
Example Data Table
| Input | Sample Value | Why It Matters |
|---|---|---|
| Current Monthly Revenue | $50,000 | Acts as the retained revenue baseline. |
| Qualified Leads | 140 | Estimates potential new deals entering the forecast. |
| Win Rate | 22% | Converts lead volume into expected closed deals. |
| Average Deal Value | $4,200 | Turns closed deals into projected revenue. |
| Sales Cycle | 45 days | Delays when pipeline revenue starts arriving. |
| Upsell, Churn, Growth | 5%, 2.5%, 4% | Adjusts expansion, losses, and momentum each month. |
Formula Used
Pipeline revenue potential = Qualified Leads × Win Rate × Average Deal Value.
Monthly retained revenue = Previous Month Revenue × (1 − Churn Rate).
Growth lift = Monthly Retained Revenue × Monthly Growth Rate.
Upsell lift = Monthly Retained Revenue × Upsell Rate.
Seasonality multiplier = 1 + ((Seasonal Index − 1) × Seasonality Strength × 10).
Monthly forecast revenue = (Retained Revenue + Growth Lift + Upsell Lift + New Revenue) × Seasonality Multiplier.
Confidence weighted total = Total Forecast Revenue × Confidence Level.
How to Use This Calculator
- Enter your current monthly revenue as the baseline.
- Add qualified leads, win rate, and average deal value.
- Set the sales cycle to delay pipeline contribution.
- Enter upsell, churn, and monthly growth assumptions.
- Adjust seasonality strength for peak or slower periods.
- Choose forecast months and a confidence level.
- Submit the form to see totals, scenarios, and monthly detail.
- Use the CSV or PDF buttons to save the report.
FAQs
1. What does this tool forecast?
It forecasts monthly sales revenue by combining current revenue, expected new deals, churn, upsell activity, growth, seasonality, and confidence assumptions into one model.
2. Why is sales cycle included?
Sales cycle delays when pipeline revenue begins. Longer cycles push closed revenue later, helping the forecast reflect timing instead of assuming every deal closes immediately.
3. What does confidence level do?
Confidence level converts the raw forecast into a weighted planning view. It helps teams compare the headline forecast against a more cautious estimate.
4. How should I set seasonality strength?
Use a higher percentage when revenue clearly rises and falls through the year. Use a smaller value when your sales pattern stays relatively stable.
5. What is pipeline coverage ratio?
Pipeline coverage ratio compares total pipeline revenue potential to current monthly revenue. A higher ratio suggests stronger capacity to support future revenue goals.
6. Can I use this for recurring revenue teams?
Yes. Churn, upsell, and monthly growth assumptions make it useful for subscription or account-based teams that manage both retention and expansion.
7. Why are there conservative and aggressive scenarios?
Scenarios help decision-makers plan for a range of outcomes. They support budgeting, hiring, and target setting without relying on one single number.
8. What should I export, CSV or PDF?
Use CSV for spreadsheet work, data review, and sharing with analysts. Use PDF for meetings, presentations, approvals, and printable reporting.