Sales Forecast Template
A pipeline-weighted sales forecast with monthly targets, deal stages and scenario planning.
A look inside the workbook
These fictional examples illustrate the included dashboard and working sheets.
| Workbook sheet | What's inside |
|---|---|
| Opportunities | Stage-weighted deals with expected close dates |
| Stage Settings | Editable conversion assumptions |
| Monthly Forecast | Bookings vs monthly sales targets |
| Scenarios | Conservative, base and upside cases |
Download status: The complete Excel workbook is now available for free. ↓ Download Free Excel System (.xlsx) No account or membership is required.
Browse the Verwick template library →How to use the sales forecast template
A sales forecast estimates future bookings based on the opportunities in a pipeline and the assumptions assigned to their stages. This Excel system combines opportunities, expected close dates, editable probabilities and monthly targets with conservative and upside scenario views.
Step-by-step workbook workflow
- Review the deal stages and enter probabilities that reflect your business rather than treating sample rates as benchmarks.
- Record opportunity value, owner, current stage and expected close month for each deal.
- Compare the weighted forecast with sales targets and use scenarios to understand uncertainty before planning capacity or spending.
Frequently asked questions
How is a weighted sales forecast calculated?
A typical weighted forecast multiplies an opportunity's estimated value by its current win probability. The result is an estimate, not guaranteed revenue.
What if my pipeline changes?
Update opportunities and assumptions as deals progress, stall or close. A forecast is only useful when the underlying data remains current.
Related: customer journey map template. These workbooks are editable templates with fictional sample data, not live SaaS applications or substitutes for professional advice.
