Rolling Forecasts: Seven Factors for Success

The concept of a rolling forecast is a hot topic in FP&A at the moment. Many companies attempt to implement it, but not all of them are successful. Statistics suggest that one in five of the organisations that implemented rolling forecasts recently have since abandoned them, because they proved to be more complex than initially expected. Additionally, they didn’t find enough value in this tool to continue using it.

However, a rolling forecast can be a powerful tool for FP&A if used correctly. Attendees of the Geneva club looked at the seven factors for success.

  1. Culture: The starting point for successful rolling forecast is an organisation’s business culture. Successful implementation requires support from top management and acceptance by key participants. All parties must understand that a rolling forecast is not a measurement, but is a management tool. It should not follow accounting structures.
  2. People: The next crucial factor for a successful rolling forecast is people. Talent in FP&A in particular is important for individuals working with a rolling forecast. They should be good communicators with analytical skills who can see the ‘big picture’ and possess the ability to build models.
  3. Models and systems: Four in five organisations continue to use Excel for FP&A. Attempting to produce a rolling forecast for a multimillion or multibillion dollar company in Excel is almost impossible. Models and systems are essential and should be driver-based, to make it easier to plan different scenarios and forecast quickly. Systems should be flexible and tailored to FP&A. Many companies evidently still attempt to do this in Excel, but Excel is prone to mistakes and can be one of the reasons why a rolling forecast is unsuccessful.
  4. Process: Processes should be quick, flexible and allow for collaboration, while minimising non-value adding activities. This takes time, effort and education; a company I was previously with could not improve its process because the operational calendar was created three years earlier. Standardisation and modern systems can help improve processes; it is up to FP&A to make sure these are implemented.
  5. Design: It is important to understand the level of detail needed in a rolling forecast. It should be timely, and should allow for action. The forecast should contain the minimum amount of data to understand what drives the future. Only forecasts that are based on drivers and assumptions are actionable. We should not use conventional accounting data structures because they do not explain why and, therefore are not actionable.
  6. Alignment: Typically, companies have three planning processes: Strategic planning, where everything begins; Business planning, where most FP&A people are working; and Operation planning, which provides input to the business plan. Alignment and communication between these different planning processes is vital for a successful rolling forecast.
  7. Participation: The forecasting process involves so many different people; both financial and non-financial. It is up to FP&A practitioners to be business partners and teach non-financial people what drivers and systems to use. There is a gap between strategy and execution at many organisations; involving many departments in the planning process can help to overcome this problem. However, while participation is important, FP&A professionals must also ensure that the process does not become too crowded.

Drawbacks and Challenges

Naturally there are drawbacks to using a rolling forecast. The preparation process can be costly and time-consuming if they are not automated, since a forecast is reviewed and updated several times per year and is too complex for accountants without sufficient training. Constant forecasting throughout the year can also lead to an increase in managers’ workload. Coordination of profit centres can decrease due to the lack of one common budget. Lastly, performance evaluation will be more difficult to carry out.

Rolling Forecasting vs. Budgeting

Many studies present rolling forecasts as the main alternative to budgets. Beyond budgeting propagators view budgets as static, cumbersome and time-consuming; creating little value for an organisation. Alternatively, rolling forecasts and a combination of other performance management tools are said to improve the performance management process.

However, even with rolling forecasting, most companies are unlikely to eliminate the budget altogether. Budgets are often required by external agencies and financial institutions. They may also be required for target setting and performance bonuses. One approach is just to nominate one rolling forecast, which covers the required periods, to be called the budget.

For example, the rolling 18-month forecast produced in November will include the whole of the following year, and the relevant periods could be copied to create the budget for the following year. This may be subject to additional review and approval steps, but would not require the investment in time that was previously dedicated to the standalone budget process.

The next meeting of the Geneva FP&A Club is set to take place on 14 January 2015. More information on the FP&A certification is available here.

For further insights into FP&A, be sure to sign up for the AFP FP&A e-newsletter or visit the FP&A website. To contact the FP&A Club about free membership for finance professionals, or for details on forthcoming international events, please email Larysa Melnychuk or join the LinkedIn FP&A Group. An FP&A conference is also scheduled for 19-20 May 2015 in Amsterdam, Netherlands. Those interested in speaking should contact Larysa Melnychuk.

109 views

Related reading