{"id":3796,"date":"2024-01-29T09:00:40","date_gmt":"2024-01-29T08:00:40","guid":{"rendered":"https:\/\/holisticds.com\/?post_type=articulo&p=3796"},"modified":"2024-05-02T11:39:01","modified_gmt":"2024-05-02T10:39:01","slug":"how-rolling-forecast-can-improve-your-organizations-competitiveness","status":"publish","type":"articulo","link":"https:\/\/holisticds.com\/en\/articulo\/how-rolling-forecast-can-improve-your-organizations-competitiveness\/","title":{"rendered":"How Rolling Forecast can improve your organization’s competitiveness"},"content":{"rendered":"

There was a time when static, assumption-based planning was sufficient to work through the year. But that time has passed, and finance teams and managers today need new systems that offer <\/span>greater flexibility and the ability to replan in real time<\/b>.<\/span><\/p>\n

Traditional planning systems lose their effectiveness when there are fluctuations in the market, in periods of change or when faced with events of international impact. That is, in the new normal, “thanks” to legislative and governmental changes, wars, pandemics, climate crisis, economic instability, new competitors, etc.<\/span><\/p>\n

To stay ahead of the curve you need more agile planning, and this is where the <\/span>rolling forecast<\/b> comes in.<\/span><\/p>\n

What is Rolling Forecast?<\/span><\/h2>\n

Rolling forecast<\/b> allows to have a more probable forecast of future results thanks to a re-estimation of the budget.<\/span><\/p>\n

Unlike the annual budgets that many organizations prepare at the beginning of the year, which are a “static” snapshot, the <\/span>rolling forecast uses available data from the current year to extrapolate and update the budget more accurately<\/b>.<\/span><\/p>\n

This process, usually performed by the controlling or financial team, can be carried out during the year in order to readjust the forecasts for the remaining months, taking into account information from previous months. In this way, the company has room for maneuver to take measures that will help it to achieve the expected objectives.<\/span><\/p>\n

According to data from <\/span>FSN’s Agility in Planning, Budgeting and Forecasting (PBF) Survey 2021<\/span><\/i><\/a>, only 43% of organizations manage to forecast their revenue with a deviation of less than 5%. In addition, 52% of organizations say they are unable to plan beyond 6 months ahead.<\/span><\/p>\n

This data shows how important it is today to have agile tools that allow companies to stay competitive and on budget, and rolling forecasting is a key part of this.<\/span><\/p>\n

What is the difference between a rolling forecast and a traditional forecast?<\/span><\/h2>\n

The traditional budget made at the beginning of the year usually includes an income statement forecast. This static plan reflects where the company wants revenues and expenses to be at the end of the year, which is used to allocate resources, define which products or services will need to be promoted or where investments will have to be made.\u00a0<\/span><\/p>\n

The main problem with the traditional budget is that it is fixed, it does not “react” to everything that happens during the year. <\/span>This turns out to be very limiting, since the annual budgeting process in many companies is a long and tedious process that can take several weeks<\/b>.<\/span><\/p>\n

In addition to this, there are other problems, such as the fact that the business units that provide the information on which this budget is based may be tempted to give lower forecasts if they know that these are going to be used as targets. This has a negative impact as it reduces the accuracy of the forecasts and causes revenue to trend downward.<\/span><\/p>\n

Rolling forecasting solves many of these problems<\/b> by allowing forecasts and resource allocation to be readjusted based on what is happening. It gives managers a view of how the current year will close or, if not restricted to business years, a 12 (or 6, 8, 18, etc.) month view at any point in the year.<\/span><\/p>\n

Automating the rolling forecast: a competitive advantage.<\/span><\/h2>\n

Rolling forecasting is important, but it is even more important to do it efficiently.<\/span><\/p>\n

If your organization’s financial processes involve reviewing and updating dozens of different Excel spreadsheets, making a rolling forecast can be a headache that can take days or weeks.<\/span><\/p>\n

However, <\/span>performing this process with a good solution implemented on a robust platform is a fast and agile process that can be solved in a few hours<\/b> by the controlling team, even by creating different versions or scenarios.<\/span><\/p>\n

The automation of the rolling forecast allows a company to have a monthly estimate of how the year will close or a 12-month forecast. The key to this is to have a process that, using various statistical methods, allows the actual data for each of the items on the income statement to be extrapolated to future months. These are simple and modifiable methods that make it possible to calculate in a very agile way how each accounting item will evolve, both in terms of expenses and income.\u00a0<\/span><\/p>\n

This information makes it possible to make decisions within the period based on the evolution of the data, for example:<\/span><\/p>\n