Rolling Forecast

What is a Rolling Forecast

A Rolling Forecast is a business forecast which is updated on a regular basis. Forecasts are a map of where a business is going, they are a guide, not a manifesto to be stuck to come what may. To make them useful they need to be updated on a monthly basis and used to manage.

Here’s a simple way to create a rolling forecast each month.

  1. Start with an original five year forecast. First two years on a monthly basis and the remaining three years shown annually.
  2. At the end of each month replace the original forecast with the actual figures for that month.
  3. Each month revise the rest of the forecast whenever it is apparent from the emerging pattern of actuals that the original forecast is wrong. Spend the majority of the time on the next twelve months, with a quick review of the remaining years. At the end of twelve months, the forecast will show actual figures for the first year and projected figures for the remaining four.
  4. Use the remaining four years projected figures as the starting point for a new projection adding a new fifth year at the end to complete.
  5. Repeat steps 2 to 4.

Using this method to produce a rolling forecast, the business always has a map, but the route changes (hopefully only slightly) each month from the original. It now has a dynamic tool which enables it to refocus as and when necessary.

Rolling Forecast November 6th, 2016Team

You May Also Like

Related pages

cash cover ratioscrap value accountingbasic accounting concepts and principlesexamples of cash receipts journalstock turnover days formulasimple petty cash templatedefinition cashiers checkexcel nperexcel formula for growthaccounting basic quizreversing journalsmaterial requisition slip formatinventory journal entries examplesfv of annuity tableinterview for accounts payable positionbank reconciliation definition in accountingseries discount calculatortotal labor variance formulaexamples of comprehensive incomejournal entries for accounts receivable processdeferred rent assetextended dupont analysisbank reconciliation xlsaccounts payable ledgerprofit and markupt accounts excel templateexamples of receivablestimesheet sample templatebank discount note examplebond sinking fund balance sheetmulti step income statement formatactivity ratios examplesaccounts receivable turnover daysis prepaid rent a current assetexample of fifo methodfreight in freight out accountingcash disbursement examplecompute the payback periodperpetuities formulapmt excel exampledouble declining depreciation formularoa ratio formulawhat is uncredited chequean example of deferred revenue is unearned rentmargin and markup calculator ukfixed asset register template downloadaccounting closing entries examplesaccounts ledger templatecvp income statementwhat is a contra account in accountingjournal entry for bad debtsexcel debt calculatorcalculate gross margin percentage formuladupont turnovercapital lease lessor accountingwhat is provision for doubtful debthow to compute manufacturing overhead rateimprest moneyliquidating a partnershipreceivable turnover in daysleverage ratio equationaccounts aptitude questions and answersconsignment inventory sheetpto accrual formuladeclared cash dividenddegree of total leverage calculatoradvance cash receipt formatprovision accounting entriespetty cash flowsample timesheet template excelincome gearing ratiobank reconciliation exercisemeaning of debit note and credit notepetty cash ledgerwhat does nett mean on an invoice