Home Advanced Analytics What is rolling projection?

What is a rolling projection?

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

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!

Your SAP Analytics contact
Nadine Matt_2
Nadine Matt
Inhouse Sales Analytics

Published by:

Dr. Dominik Bertsche

Professional Analytics consultant


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!


Learn more about our Analytics solutions


More information

The importance of data quality for analytics

In the world of analytics, data quality is key to identifying relevant patterns and making informed decisions. Only through...

Wiki Predictive Controlling

Predictive Controlling: Automated Rolling Projection of the Group Income Statement

Predictive controlling enables predictions through data analysis and advanced models. Companies make informed decisions, react to changes at an early stage and strengthen their...

Cover image Wiki Article SAP Data Intelligence

SAP Data Intelligence - Get more from your data with data intelligence.

How can data (streams) from different locations be used efficiently and intelligently?SAP Data Intelligence makes it easier for companies to use their data...

Wiki Introduction Google BigQuery

Google BigQuery: The most important basics

With BigQuery, Google sells a warehousing tool that is supposed to be able to replace established systems. What concrete advantages does Google BigQuery offer, how...

Wiki ESG Reporting

ESG Reporting: Importance, Relevance and SAP Solutions

ESG is now more than just a trend - companies are using it to demonstrate the importance they attach to the issue of sustainability in their organization...

Cover On-Premise vs. Off-Premise Software What's the Difference

On-Premise vs. Off-Premise Software: What's the Difference?

What is on-premise and what is off-premise software and what is the difference? This topic is covered in the following knowledge article. In addition...

Wiki: Eugen interviewed about BW Bridge

Bridge the Gap to Better Business Intelligence with SAP BW Bridge!

The BW Bridge is presented by SAP as a way to integrate a system from a classic on-premise environment into the SAP...

GDPR Cookie Consent with Real Cookie Banner