Verwick
Free Templates   /   SALES & MARKETING
VERWICK FREE BUSINESS SYSTEMS

Sales Forecast Template

A pipeline-weighted sales forecast with monthly targets, deal stages and scenario planning.

Editable ExcelWorking formulasDashboard previewFree — no registration
Free Excel workbook · Instant download · No account↓ Download the Excel template

A look inside the workbook

These fictional examples illustrate the included dashboard and working sheets.

V E R W I C K  /  WORKBOOK PREVIEWEXCEL BUSINESS SYSTEM
PIPELINE$166,000
WEIGHTED FORECAST$113,100
OPEN DEALS5
Workbook sheetWhat's inside
OpportunitiesStage-weighted deals with expected close dates
Stage SettingsEditable conversion assumptions
Monthly ForecastBookings vs monthly sales targets
ScenariosConservative, base and upside cases
Stage SettingsOpportunitiesMonthly ForecastScenariosActivities

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

  1. Review the deal stages and enter probabilities that reflect your business rather than treating sample rates as benchmarks.
  2. Record opportunity value, owner, current stage and expected close month for each deal.
  3. 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.