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

how to calculate manufacturing overheadexpanded accounting equation exampleaccounting formulas and calculationshow to maintain a ledger bookgearing ratio equationfactoring finance examplejournal entry for goodwillterm promissory noteannuity payments formulamarkup ratiocontribution margin and gross marginstock turnover ratio formularequisition slip samplejournal entry for warrantywhat is obsolescence in accountingformula for double declining balance depreciationhow to find the profitability indexdouble entry bookkeeping questions and answersexcel double entry bookkeepingebit interest coverage ratioageing accounts receivableexample of a petty cash bookscrap disposal formathow is inventory turnover calculatedmarkup percent formulahow to calculate common size income statementtrial balance calculatorfuture value of an annuity calculatoraccounting for gift cardsformula of stock turnover ratiobond amortization schedule calculatorcost variance examplediscount perpetuitylease calculator formulahire purchase journal entryfob delivery definitionbalance sheet prepaid expensesdoes accumulated depreciation go on the balance sheethow to calculate gp percentagecreditors turnover daysbad debts debit or creditrule of 78 amortization schedulecashiers check definitioncontra assetzero based budgeting advantagesmirr functionstockholders equity accountingfuture value of lump sum excelcreditor ledgereffective interest amortization tablehow to calculate receivable daysfinancial leverage ratio definitionusance letter of credit meaningyield to maturity formula excelformula for annuity factorjournal entry for salary paid to employeesamortized bondsvalue of a perpetuity formulabond premium calculatorwhat is quick ratio formulaexplain the accounting cycledisbursement ledgerending retained earnings formulareceivables turnover calculationdouble declining depreciation calculationannuity due calculator future valuepercentage complete formula excelfundamental accounting conceptinterest in suspense accounting treatmentdirect material price variance formulamanufacturing overhead costprofitability index excel