toolbox
Home / Business & Operations / Agency Forecast Estimator

Agency Forecast Estimator

The Agency Forecast Estimator projects future agency revenue from current monthly revenue, an expected growth rate, and a forecast horizon. It also estimates cumulative revenue across the projection period using monthly compounding.

This is a planning model rather than a guarantee. Agency leaders can use it to create a baseline for hiring, capacity, cash planning, and sales targets, then compare the projection with a conservative or aggressive growth assumption.

Enter your assumptions

$
%
months
Result
—
Projected revenue in the final month
Starting monthly revenue—
Cumulative forecast revenue—
Total growth—
Forecast horizon—

1. Enter the baseline
Use the latest representative month of agency revenue, excluding unusual one-time items when appropriate.

2. Choose a monthly growth rate
Enter the expected percentage change from one month to the next. A negative rate models contraction.

3. Set the horizon
Choose the number of months to project.

4. Read the final month
The headline result shows revenue expected in the last forecast month.

5. Check cumulative revenue
Use the cumulative figure as the total projected revenue generated over all forecast months.

Revenue in Month n = Current Monthly Revenue × (1 + Monthly Growth Rate)^n

Where:

  • Current Monthly Revenue = baseline revenue at month 0
  • Monthly Growth Rate = expected monthly change expressed as a decimal
  • n = number of months into the forecast
  • Cumulative Revenue = sum of each projected month from 1 through n

What the result means

The headline is the estimated revenue level in the last month, while cumulative revenue represents the total projected over the full horizon.

Compounding assumes the same monthly growth rate throughout the forecast and does not model seasonality or capacity constraints.

Given: Current monthly revenue of $60,000, monthly growth of 2%, and a six-month horizon.

Calculation: Month 6 revenue = $60,000 × 1.026 = $67,569.75. Cumulative months 1–6 revenue = $378,973.45.

Result: The final month is projected at $67,569.75, about 12.6% above the baseline.

Is the growth rate monthly or annual?

It is monthly. Convert an annual assumption to an equivalent monthly rate before entering it if you need a monthly compound forecast.

Does cumulative revenue include the starting month?

No. It sums forecast months 1 through the selected horizon; the starting revenue is the month-0 baseline.

Can the growth rate be negative?

Yes, as long as it is greater than -100%. A negative rate models declining monthly revenue.

Does this account for seasonality?

No. It applies one constant growth rate. Build separate monthly assumptions when seasonal changes are material.

How can I create scenarios?

Run the estimator with conservative, base, and aggressive growth rates and compare the final-month and cumulative totals.