Skip to content
Free business tool

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.

Free, no signup Runs in your browser Instant results

Your numbers

₹
₹
₹
₹
₹
₹

Results

    Quick answer

    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

    1. Enter sales for each of the last six months.
    2. Pick how many months to forecast.
    3. 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.