Sales Forecast Formula
Learn how a sales forecast calculator estimates projected monthly sales, total forecast revenue, and order volume.
The sales forecast formula estimates how revenue may change over time by applying compound monthly growth to current sales, then adjusting for overall seasonality. This helps businesses create rough plans for budgets, inventory, staffing, and sales targets.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Adjusted Projected Monthly Sales
Where:
Start with current monthly sales, grow that amount each month using the expected monthly growth rate, and then adjust the final projected month up or down for seasonality.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| currentMonthlySales - Current Monthly Sales Revenue | Your current average monthly sales revenue before forecasting begins. | currency |
| monthlyGrowthRate - Expected Monthly Growth Rate | The percentage increase or decrease expected each month. | percent |
| forecastMonths - Forecast Period | The number of months included in the forecast. | months |
| seasonalityAdjustment - Seasonality Adjustment | A single percentage adjustment applied to the forecast for overall seasonal effects. | percent |
| averageOrderValue - Average Order Value | The average revenue earned per order or transaction. | currency |
Step-by-Step Calculation
Convert growth rate into a multiplier
Turn the monthly growth percentage into a factor that can be compounded over time.
growthFactor = 1 + monthlyGrowthRate / 100
Project end-of-period monthly sales
Apply the monthly growth factor repeatedly for the number of forecast months.
projectedMonthlySales = currentMonthlySales * pow(growthFactor, forecastMonths)
Convert seasonality into a multiplier
Turn the seasonality percentage into a factor that raises or lowers the forecast.
seasonalityFactor = 1 + seasonalityAdjustment / 100
Adjust projected monthly sales for seasonality
Apply the overall seasonal adjustment to the projected monthly sales at the end of the period.
adjustedProjectedMonthlySales = projectedMonthlySales * seasonalityFactor
Estimate projected monthly orders
Divide projected monthly revenue by average order value to estimate monthly order count.
projectedOrders = adjustedProjectedMonthlySales / averageOrderValue
Estimate total forecast revenue across the period
Use the sum of a compounded monthly revenue series to estimate cumulative revenue over the full forecast period.
totalForecastRevenue = currentMonthlySales * ((pow(growthFactor, forecastMonths) - 1) / (growthFactor - 1)) * seasonalityFactor
Worked example: 12-month sales forecast
Monthly growth factor
1 + 5 / 100
1.05
Projected monthly sales before seasonality
25,000 × 1.05^12
$44,879
Seasonality factor
1 + 10 / 100
1.10
Adjusted projected monthly sales
44,879 × 1.10
$49,366
Projected monthly orders
49,366 / 75
658 orders
Total forecast revenue
25,000 × ((1.05^12 - 1) / (1.05 - 1)) × 1.10
$418,027
Final Result
Projected monthly sales are about $49,366 at the end of 12 months, total forecast revenue is about $418,027, and projected monthly orders are about 658.
Assumptions
- ✓Monthly growth stays constant throughout the full forecast period.
- ✓Seasonality is applied as one overall adjustment rather than changing month by month.
- ✓Average order value remains stable during the period.
- ✓The forecast focuses on revenue and orders, not profit or costs.
Limitations
- !Actual sales may differ if pricing, demand, competition, or marketing performance changes.
- !The total revenue formula becomes unstable when monthly growth rate is exactly 0%, so a zero-growth case should be handled separately in implementation.
- !A single seasonality factor cannot capture detailed monthly peaks and troughs.
- !Refunds, discounts, taxes, and canceled orders are not built into the estimate.
Common Mistakes to Avoid
Entering total annual sales instead of current monthly sales revenue.
Using an unrealistic monthly growth rate without checking whether it can be sustained.
Forgetting that a negative growth rate models decline, not slower growth.
Using average order value that includes one-off large deals and skews the order estimate.
Applying seasonality twice by building it into the growth rate and also using the seasonality adjustment.
Related Formulas
Frequently Asked Questions
What formula is used for sales forecasting in this calculator?
The calculator uses compound monthly growth on current monthly sales, then applies a seasonality factor and divides by average order value to estimate orders.
Why does the calculator use compound growth instead of simple growth?
Because each month's forecast builds on the prior month's level, compound growth better reflects how recurring sales growth usually works over time.
How is total forecast revenue calculated?
It uses the sum of a geometric growth series, which adds each projected month together across the selected forecast period.
What happens if the monthly growth rate is negative?
A negative growth rate reduces projected monthly sales over time, which can be useful for modeling a slowdown or decline.
Does seasonality change every month in this formula?
No. In this calculator, seasonality is applied as one overall percentage adjustment across the forecast rather than as separate monthly adjustments.
Why is average order value needed?
Average order value converts projected revenue into estimated order volume by showing how many orders are needed to reach that revenue level.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.