Forecast revenue
$586,979
Gross profit
$373,235
Gross margin
64%
Monthly Sales Forecast
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
5 free sales forecast templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 5 spreadsheets from Forecast & Quota, Pipeline & Opportunity and Reordering & Stock Planning. Start with Monthly Sales Forecast, Sales Pipeline CRM and Sales Quota Attainment Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Forecast revenue
$586,979
Gross profit
$373,235
Gross margin
64%
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
Open pipeline
$270,400
Weighted forecast
$89,550
Won
$18,000
Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.
Team attainment
45%
Projected finish
84%
Gap to quota
$347,000
Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.
Forecast units next month
2,189
Units short
1,089
Products growing
4
Forecast next month for each product from the last six months, with a trend and seasonal adjustment.
Quarter target
$250,000
Weighted forecast
$209,200
Commit
$120,000
Forecast the quarter from open deals: stage probability, close month and the gap to target.