Sales Forecast Calculator
Forecast next month’s sales and the months after from your last six months, using a straight-line trend, with the monthly growth rate and a 3-month moving average.
Results
How do I forecast next month’s sales?
Fit a straight-line trend through your last six months of sales and extend it one month forward. Average monthly growth = (last month ÷ first month)^(1/5) − 1. Adjust the result for festivals or seasons the trend cannot see.
About the Sales Forecast Calculator
A forecast does not need to be perfect to be useful. Knowing roughly what the next three months should bring helps you plan stock, cash and hiring. This draws a straight-line trend through your last six months and extends it forward.
Treat the result as a baseline. If a festival, a new product or a price change is coming, adjust for it. Businesses with strong seasons get much better forecasts from a model trained on two or more years of history, which is what predictive analytics adds.
How to use the Sales Forecast Calculator
- Enter sales for each of the last six months.
- Pick how many months to forecast.
- Read the forecast, the trend and the moving average.
Questions
How accurate is a six-month trend?
Good enough for planning stock and cash a few months out when sales are steady. Seasonal businesses need two or more years of data and a model that knows the seasons.