Rolling forecast
A rolling forecast is a financial projection updated regularly by adding a new period as one ends, keeping a constant forward-looking horizon. Businesses use it to revise expected revenue, costs and cash as actual results and assumptions change.
How it works
A business with a 12-month rolling forecast might update it monthly. Once January closes, the forecast moves from January–December to February–January of the following year.
Each update should revise future assumptions using actual results, not just add another column. Unlike an annual budget, which sets a plan for a financial year, a rolling forecast shows what management now expects to happen.
A sales delay cuts projected cash by $30,000
In this illustrative startup example, cash at January's close is $600,000. February's forecast originally included $120,000 in customer receipts and $150,000 in cash payments. A sales delay reduces expected receipts to $90,000; payments stay unchanged.
| February cash forecast | Before update | After update |
|---|---|---|
| Opening cash | $600,000 | $600,000 |
| Customer receipts | $120,000 | $90,000 |
| Cash payments | $150,000 | $150,000 |
| Closing cash | $570,000 | $540,000 |
The calculation is:
Closing cash = opening cash + receipts − payments
The revised result is $600,000 + $90,000 − $150,000 = $540,000.
Nothing has changed in the bank yet. The forecast shows a future shortfall against the earlier expectation. For a founder, that could mean delaying a hire or starting fundraising sooner. Extend the same calculation through the remaining months to see whether the cash gap persists.
Questions people ask
What is a 12-month rolling forecast?
It always covers the next 12 months, rather than only the months left in the financial year. It looks forward, unlike trailing 12-month reporting, which measures past performance.
How do you prepare a rolling forecast?
Start with actual results, choose a horizon and update schedule, and model drivers such as sales volume, collection timing and payroll. At each update, compare actuals with the previous forecast, revise assumptions and extend the horizon. There is no single rolling-forecast formula.
