- Enter current sales. Use the latest representative period.
- Enter growth per period. Match the rate to the period length.
- Choose the horizon. Enter the number of future periods to project.
- Review ending and cumulative sales. Use both to support capacity and budget planning.
Retail Forecast Estimator
The Retail Forecast Estimator projects future sales from a current sales base, expected growth rate, and forecast horizon. It uses a compound growth model so each period builds on the previous period rather than adding the same dollar amount repeatedly.
Retail planners can use the forecast to prepare inventory, staffing, cash flow, and performance targets. The calculator also displays cumulative projected sales and the total change from the starting period. Forecasts are sensitive to the growth assumption and do not automatically model seasonality, store openings, stockouts, or economic shocks.
Calculator inputs
USD
%
periods
Result
—
Calculated result
Cumulative projected sales—
Change vs. starting period—
Ending sales factor—
Sales in period n = Starting sales × (1 + Growth rate)n
Cumulative sales = Sum of projected sales for periods 1 through n
The same growth rate is applied to every period. A period can be a month, quarter, or year as long as the rate uses the same interval.
What the result means
The main result is projected sales in the final forecast period.
Use separate scenarios for conservative, base, and optimistic growth rather than treating one rate as certain.
Given: current monthly sales of $100,000, 4% monthly growth, and 12 forecast months.
Calculation: Month 12 sales = $100,000 × 1.0412 ≈ $160,103. Cumulative forecast sales for months 1–12 ≈ $1,501,032.
Result: Under steady 4% monthly growth, the final month reaches about $160,103.
Should the base period be included in cumulative sales?
No. This calculator sums the future forecast periods only.
Can I use a negative growth rate?
Yes, as long as it is greater than −100% per period.
How do I model seasonality?
Run separate period-specific forecasts or use a more detailed model with seasonal indices.
What period should I choose?
Use the interval at which you manage the business and can support a credible growth assumption.
Why does compound growth rise quickly?
Each period applies growth to the prior period’s larger or smaller sales base.