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

pv formula annuityannuity due formulaunderstanding bookkeeping basicsclosing entries are dated in the journal as ofpresent worth excelworking out gross profit marginis prepaid insurance a liabilitycompounding formula in exceldebtors turnover ratio meaningamortizing a bond discountbalance sheet with accumulated depreciationdoubtful accounts journal entrydsi accountingfixed asset turnover ratio examplewhat does fob shipping point meanprepaid insurance journal entry examplejournal entry for insurance premiuminvestment turnover ratio interpretationbookkeeping examwhat is the present value of a perpetuitynet realizable value equationamortisation chartreturn of capital journal entrycredit memo journal entryaccounting for unrealized gains and losses on investmentsaccounts payable journal entry examplewhat are consumable goodshow is cogs calculatedpetty cash template downloadtimes interest earned ratio calculationexamples of owner's equity in accountingunearned revenue meaningunearn revenueaccounting forms printablehow to calculate receivables turnover ratioannuity formula with growthratio to unit rate calculatordebits and credits in accountingtvc calculationcredit debit balance sheet excelcash flow to creditorwhat goes on a trial balanceaccounting concepts quizfuture value continuous compoundingbookkeeping defhow to calculate gearing ratiodiscounted payback period calculator exceldiscount rate formula excelwhat is imprest accountexamples of suspensesundries expenses examplesdupont analysis excel templateformula for contribution marginexplain debit noteamortized depreciationreceipts and payments accounts templatefob meaning shippingformula to calculate gpmethods of bank reconciliation statementpre determined overhead ratefixed asset turnover formulahow to calculate perpetual inventoryfob shipping point freight prepaidbonds payable on cash flow statementhow to compute for retained earningseffective interest rate amortization calculatorjournal entry for uncollectible accountsending inventory formulaaccounting fobdupont analysis roe