What is a rolling projection?
- Advanced Analytics, Data Science, Planning
- data, forward projection, prognosis
- 3 May 2021
- 3 min reading time

Dr. Dominik Bertsche
Business ratios provide a snapshot of the current state of a company. If, on the other hand, one wants to gain an impression of the direction in which a company will develop in the future, projections of these key figures are more in demand. A clear distinction should be made between the targets and an objectively considered probable development. In contrast to planning, the instrument of a rolling extrapolation offers the possibility of depicting current developments and is therefore helpful for flexible corporate management. For these reasons, this tool is an integral part of the entire SAP product range, including the SAP Analytics Cloud.
Advantages of rolling extrapolation
- Flexible control options
- Faster and more accurate forecast for target achievement
- Create greater room for manoeuvre and action
- Enabling faster action
- Continuous forecast
- Very good addition to planning
What does "rolling" mean?
Decisive characteristics for rolling extrapolation are the forecast horizon and the frequency of extrapolation. The attribute "rolling" indicates that the forecast horizon is unchanging, which means that regardless of the current point in time, the same distance into the future is always looked at.
What distinguishes rolling extrapolation from annual extrapolation and rolling planning?
Basically, rolling extrapolation is to be distinguished from two terms: annual extrapolation and (rolling) planning.
Like the rolling extrapolation, the annual projection refers to the question of where a company is likely to develop. It refers to a company's financial year, which in most cases coincides with the calendar year. This results in a variable forecast horizon, which is the most obvious difference to rolling projections. For example, nine months have to be forecast at the beginning of April, while the forecast horizon at the beginning of October is only three months. Of course, this is also accompanied by fluctuating forecast uncertainty, since a forecast with a larger horizon is characterised by a higher number of contingencies. Finally, the annual projection can be assigned more to the operational business, whereas the rolling projection serves more for strategic corporate management.
The planning of a company usually refers to the coming financial year, i.e. it is usually made 15-18 months in advance. Often, the planning figures are then no longer changed and can therefore no longer be adjusted to current developments. Although planning can also be rolling, it is nevertheless aimed more at the question of what a company wants to achieve within the planning horizon.
Horizon and frequency of rolling extrapolation
Responsible persons must first clarify two basic points: How far do we look into the future and how often do we revise our rolling forecast?
The forecasting horizon is in most cases between twelve and 18 months, with exactly one year being by far the most frequently chosen approach. The frequency of extrapolation depends mainly on the volatility of a company's business field. If there are constantly new developments, a monthly reassessment is recommended. If, on the other hand, the environment is rather characterised by great stability, it is usually sufficient to revise the projection once per quarter.
Challenges and goals of rolling extrapolation
One difficulty in interpreting a rolling projection is the firmly anchored annual thinking of most addressees. Thus, awareness must be created for the fact that a rolling projection is not an annual forecast. Furthermore, with a forecast horizon that does not correspond exactly to one year, fluctuations in the rolling extrapolation can arise due to seasonalities that may not be attributable to either positive or negative developments in the company.
Whereas budgeted figures are primarily used to define targets and annual projections to review them, rolling projections offer flexible management options. It is advisable to focus on the key figures that are essential for the company's success instead of getting lost in the details of the lowest item levels.
The rolling projection should complement planning and in no way replace it.
The experts at s-peers offer an automation of the rolling extrapolation, which can make time-consuming, manual processes in a company superfluous on the basis of data. Nevertheless, there is always the possibility of replacing the algorithm-driven forecast if, for example, a knowledge carrier in the company has additional information that is not mapped in the historical data.
Know more?
Would you like to delve deeper into this topic? Then we would be happy to present all the advantages of rolling extrapolation to you in person - very much in combination with details on other functions of the SAP Analytics Cloud. Simply get in touch with us!

Published by:

Dr. Dominik Bertsche
Professional Analytics consultant

Dr. Dominik Bertsche
How did you like the article?
How helpful was this post?
Click on a star to rate!
Average rating 4 / 5.
Number of ratings: 2
No votes so far! Be the first person to rate this post!