Home Advanced Analytics What is rolling projection?

What is a rolling projection?

Wiki What is rolling extrapolation

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!

Christiane Maria Kallfass is a Recruiting and Marketing Specialist at s-peers AG
Christiane Grimm
Inside Sales

Published by:

Dr. Dominik Bertsche

Professional Analytics consultant

author

How did you like the article?

How helpful was this post?

Click on a star to rate!

Average rating 3.7 / 5.
Number of ratings: 3

No votes so far! Be the first person to rate this post!

INFORMATION

More information

What is SAP S/4HANA?

SAP S/4HANA is more than just a technical upgrade—it’s a fundamental system transformation. In this article, you’ll learn...

AI Meets BI: Modern Reporting in the Databricks Lakehouse

In the traditional IT world, there are often two distinct realms: Business Intelligence (BI), which deals with the analysis of historical...
Symbolic image for data formats in Databricks. An icon represents the layered structure of Parquet files with an overlying Delta Lake layer.

Data formats in Databricks: A guide to Parquet, Delta Lake, and alternatives

Choosing the right data format is a critical but often underestimated factor for performance and efficiency in Databricks....

SAP Data to Databricks: A Strategic Guide to Data Integration

How does this work in data sharing with SAP and Databricks? The strategic partnership between SAP and Databricks enables...
SAP Databricks Wiki

Zero-Copy Delta Share: The End of Data Plumbing

How does this work in data sharing with SAP and Databricks? The strategic partnership between SAP and Databricks enables...
9.1 Differences between SAP Databricks and native Databricks

SAP Databricks vs. Native Databricks: Choosing the Right Platform

SAP Databricks or Native Databricks? A strategic decision that many companies are facing. While SAP Databricks is a specialized solution...
20251127_Feature Update

SAC Live Connect to Snowflake – explained step by step

How does SAC Live Connect work with Snowflake? In this guide, we will show you step by step how to set up a...