Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
The Stockholm FP&A Board: Rolling Forecast
October 15, 2019

By Jonny Boström, Stockholm FP&A Board member

FP&A Tags
Rolling Forecast
Forecasting Quality
Planning and Budgeting

On 15 October 2019, I attended the 7th Stockholm FP&A Board, which was sponsored by OneStream Software and Michael Page. The topic of the evening was rolling forecast.  

The event started with a short introduction and a poll on the experience of using rolling forecast. It turned out that less than 50% of FP&A Board members had some or a lot of experience in working with rolling forecast. The overall feedback was a mix of both really good and some bad experiences. 

Basics of Rolling Forecast and Its Implementation

Rickard Olsson started with going through the main definitions, advantages and disadvantages. Forecast is often mixed up with a budget and you need to understand the differences. The main takeaway for me was that it is crucial to understand the difference between targets, forecast and resource allocation:

  • Targets tell us where we want to be.
  • Forecast shows our best guess of where we are. 
  • The resource allocation is what it takes to make it happen and is linked to both targets and forecast.


Forecasts vs Targets

The forecast should be unbiased and show the expected outcome. There is no need to have the forecast on a detailed level. A good estimate on a high level with limited details is enough. To support the forecast, you can use the actuals with very much details and the drill-down possibility to the individual transactions. 

The target can be inspiring and stretching, while it is impossible to have any stretch in the forecast. It is even against the definition of the forecast since it should be unbiased and show what is expected to happen. 

Why Do We Need Rolling Forecast?

Rolling forecast is a useful tool for supporting decision making since the world often turns out different from the way you expected it.  Forecast should be a call to action. It can be a tool to get things on the radar screen early enough to be able to take corrective actions. 

With Rolling forecast you can avoid forecast with some sort of miracle happening in the figures after some years, also called Hockey stick forecast. This is very easy to spot if you make a graph of the expected outcome in the forecast. The rolling forecast takes away this type of estimates since it is based on the latest actuals and with a realistic estimate of what is expected in the future. 

According to Rickard, there are three levels of forecasts: operational forecasting, business forecasting and strategic planning. 

  • Operational forecasting has the purpose of execution and is a detailed forecast with the purpose to predict the future. 
  • Business forecast is focused on decision making, not too many details (more ranges) with the purpose of shaping the future. 
  • Strategic planning is aiming to create the future by creating options with broad brush estimates. 

The benefits of using a rolling forecast are: 

  • better accuracy
  • more flexibility
  • quicker decision-making
  • better link to strategy.

At the Board, we also discussed 7 factors for the successful implementation of rolling forecasts. You can read more about these factors here: https://www.fpa-trends.com/article/rolling-forecast-7-factors-success

The Board also looked at three types of forecasting techniques:

  • Mathematical - based on hard facts like volume, material, price, usage etc put into a model like a cost model to get cost forecast. 
  • Statistical - where you use statistical methods and extrapolating
  • Judgemental - forecast done by the ones with long experience within the business, based on their judgment

Presentation: Practical Experience on Rolling Forecast

James Watkins, Finance Director at Electronic Arts Europe, continued the event. He shared with us his experience of working with a rolling forecast for several years. 
According to James, there are several advantages of a rolling forecast:

  • Allows for strategic planning for products with a long lead time.
  • Acts as a forcing function for cross-function co-operation
  • Enables long term currency/tax planning
  • Drives a smoother annual planning process

Nevertheless, it also has some disadvantages:

  • Allows executives to focus decisions purely on numbers
  • Sometimes disconnected
  • Ineffective if data is incomplete or missing
  • Time-consuming 

According to James, it is not a good idea to base bonuses on forecasts. The bonuses should instead be based on the budget, where the forecast is only showing where we likely would end up. 

James also told us that they had separated FP&A from Accounting in EA to clarify the different roles. This had worked out very well according to him. 

Group Work: Different Aspects of Rolling Forecast

The evening continued with some group work on the success factors for implementing a rolling forecast. 

Success factors from a human and a cultural aspect are:

  • acceptance that the forecast will require enough time allocated
  • respect for the forecast (i.e. do not put in black boxes)
  • transparency - need to have the trust to put both good and bad outcome into the forecast
  • management buy-in, they must support the process and the idea behind the forecast
  • celebration of failures - do not only see failures as a mistake, instead treat it as a learning experience where you have gained new knowledge

Success factors from an analytical and systematical aspect: 

  • zooming out from accounting
  • finding the right people, with FP&A skills
  • thinking "events" rather than fixed time table
  • not having too many numbers 
  • developing the right management mindset
  • focusing on small instead of big data
  • ensuring good communication
  • paying attention to the user interface, Excel front end
  • automating – e.g. feeding data with actuals
  • ensuring data integrity, mastering data
  • implementing a step by step approach
  • using scenario management, what if's
  • providing access to granular data

 

Related articles

FP&A Trends E-Book: Rolling Forecast. Issue #1
October 8, 2019

FP&A Trends E-Books is a series of publications consisting of articles on FP&A-related subjects. The issues...

Read more
Best Practices in Rolling Forecasts
April 18, 2018

Many businesses have yet to discover the full benefits of evolving their planning process to include...

Read more
Ten Reasons to Adopt Rolling Forecasts
October 21, 2019

Today’s FP&A practitioners are highly trained professionals with a greater ability to see the big picture...

Read more
Budget Tracking with Rolling Statistical Forecasts
April 30, 2018

For organizations with annual expense budgets, it is important to have procedures for monitoring expenditures and...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

Pagination

  • ‹‹ Previous
  • September 2023
  • Next ››
Su Mo Tu We Th Fr Sa
27
28
29
30
31
1
2
 
 
 
 
 
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
24
25
26
27
28
29
30
Creating Your Transformation Map with the FP&A Trends Maturity Model
 
Using AI to Enhance Your Predictive Planning and Forecasting
 
All events for the year
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Future Meetings

The Face-to-Face London FP&A Board
The Face-to-Face London FP&A Board Creating Your Transformation Map with the FP&A Trends Maturity Model
September 27, 2023
The FP&A Trends Webinar
The FP&A Trends Webinar Using AI to Enhance Your Predictive Planning and Forecasting
September 28, 2023
The Power of AI and Human Intelligence in FP&A
The FP&A Trends Webinar Empowered Decision-making: Human-Led, AI-Backed Intelligence in FP&A
October 4, 2023
The Face-to-Face Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Five Critical Roles for Building a World-Class FP&A Team
October 5, 2023
ZBB
The FP&A Trends Webinar A New Age of Zero-Based Budgeting
October 10, 2023
The FP&A Trends Webinar
The FP&A Trends Webinar Navigating Intelligent Transformation with FP&A Trends Maturity Model
October 11, 2023
The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board FP&A Storytelling in a Data-Driven World
October 12, 2023
The Face-to-Face Toronto FP&A Board
The Face-to-Face Toronto FP&A Board FP&A Storytelling in a Data-Driven World
October 17, 2023
Value Adding FP&A
The FP&A Trends Webinar Mastering the Art and Science of Value Adding FP&A
October 18, 2023
FP&A Storytelling in a Data-Driven World
The Face-to-Face San Francisco FP&A Board FP&A Storytelling in a Data-Driven World
October 19, 2023
The Face-to-Face Seattle FP&A Board: FP&A Storytelling in a Data-Driven World
The Face-to-Face Seattle FP&A Board FP&A Storytelling in a Data-Driven World
October 24, 2023
The Face-to-Face Boston FP&A Board
The Face-to-Face Boston FP&A Board Creating Your Transformation Map with the FP&A Board Maturity Model
October 26, 2023
Geneva FP&A Board
The Face-to-Face Geneva FP&A Board FP&A Storytelling in a Data-Driven World
November 7, 2023
Continuous Planning
The FP&A Trends Webinar Real-Time and Continuous Planning: What Does It Involve
November 8, 2023
Zurich FP&A Board
The Face-to-Face Zurich FP&A Board FP&A Storytelling in a Data-Driven World
November 9, 2023
The Face-to-Face Munich FP&A Board
The Face-to-Face Munich FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
November 14, 2023
Helsinki
The Launch of the Face-to-Face Helsinki FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
November 16, 2023
From Insights to Impact: Unveiling the Potential of FP&A Scenario Management
The FP&A Trends Webinar From Insights to Impact: Unveiling the Potential of FP&A Scenario Management
November 22, 2023
The Launch of the Face-to-Face Riyadh FP&A Board
The Launch of the Face-to-Face Riyadh FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
November 27, 2023

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • Munich
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2023 fpa-trends.com. All rights reserved.

0