toolbox
Home / Business & Operations / Service Forecast Estimator

Service Forecast Estimator

The Service Forecast Estimator creates a month-by-month revenue projection from current monthly revenue, a recurring growth rate, and a uniform seasonality adjustment. It reports the final forecast month, the total revenue across the forecast horizon, and the average monthly revenue.

It is suited to quick planning scenarios for service businesses with a reasonably stable growth pattern. Managers can test conservative and aggressive cases for hiring, budgeting, or capacity decisions. A single compound growth rate is intentionally simple; businesses with known monthly seasonality or major contract events should build a more detailed forecast.

Service assumptions

USD
%
months
%
Result
—
Revenue in final forecast month
Total forecast revenue—
Average monthly revenue—
Cumulative growth—

1. Enter the current monthly baseline
Use the latest representative month rather than an unusual spike or temporary shutdown.

2. Set expected monthly growth
Enter a compound month-over-month rate. Use a negative value for contraction.

3. Choose the horizon
Select the number of future months to project, up to 120.

4. Apply a uniform adjustment
Use seasonality to shift every forecast month up or down. Leave it at zero when no broad adjustment is needed.

5. Compare scenarios
Run several growth assumptions because small monthly differences compound materially over longer horizons.

Forecast revenue in month n = Current monthly revenue × (1 + Monthly growth rate ÷ 100)n × (1 + Seasonality adjustment ÷ 100)

Total forecast revenue is the sum of every projected month from 1 through the selected horizon. The seasonality input is a uniform adjustment, not a different seasonal factor for each month.

What the result means

The main result is projected revenue in the last month of the forecast horizon.

The forecast is a scenario, not a guarantee. Capacity limits, churn, price changes, and contract timing can make actual revenue follow a different path.

Given: $40,000 current monthly revenue, 3% monthly growth, a 12-month horizon, and no seasonality adjustment.

Calculation: Month 1 = $40,000 × 1.03 = $41,200. Month 12 = $40,000 × 1.0312 = $57,030.42. Summing months 1 through 12 gives approximately $567,681.14.

Result: Final-month revenue is about $57,030.42, and average monthly forecast revenue is about $47,306.76.

The final month is roughly 42.6% above the starting monthly baseline because growth compounds.

Is the growth rate annual or monthly?

It is a monthly rate and compounds each month. Convert an annual assumption before entering it when necessary.

Can I enter negative growth?

Yes, as long as it is greater than -100%. Negative growth models a declining monthly revenue path.

How does the seasonality field work?

It applies one uniform percentage adjustment to every forecast month. It does not model a detailed seasonal calendar.

Why does total forecast revenue differ from final-month revenue times the number of months?

Earlier months have lower or higher values depending on growth. The total sums each separately compounded month.

When should I use a detailed forecast instead?

Use a detailed model when contracts start or end on known dates, capacity changes, prices shift, or monthly seasonal patterns are material.