Apliqo Insights: Paris FP&A Board meeting 2019

Last week’s meeting focused on Rolling Forecasts and 7 factors for businesses to implement them successfully. The meeting began with a general introduction in which the participants shared their own personal experiences with Rolling Forecasts. The results of the introduction are summarized below:

RFC Implemented and great experience5 %
Implemented with many challenges25 %
Limited to no practical experience65 %

The outcome of last week’s roundtable showed that, despite its many benefits, many companies around the world still aren’t implementing Rolling Forecasts or are struggling to do so effectively. Only a limited number of companies have managed to implement Rolling Forecasts properly and therefore reap the full extent of their benefits.

Key Factors For Successfully Implementing Rolling Forecasts

Following the introduction, the group discussed various definitions of Rolling Forecasts and identified some of the key factors for their successful implementation. The outcomes of this exercise were well-aligned with a summary from previous FP&A Board Meetings which were presented to the group after the discussion and are summarized below:

Culture – Companies need to understand that the Rolling Forecast is not a measurement tool for bonuses. It is more a management tool to identify key risks and opportunities early enough and to better manage the bottom line of the business.

People – Businesses need to assess the skill set of their existing employees because the implementation of Rolling Forecasts requires project teams with the ability to fulfill different roles including analytics, model builders, business partners, and communicators/presenters.

Systems – Organisations need to build a trusted information hub which includes operational and financial insights on which to base their Rolling Forecast model. Furthermore, the system needs to be capable of executing and live modeling big data.

Processes – It’s important to have a management buy-in process that is clearly explained through the whole organization. Regular meetings with full transparency regarding drivers and key estimates help to build trust and increase acceptance of the Rolling Forecast model.

Design – The design phase covers the model itself, including the horizon and frequency of the Rolling Forecast. All of this is driven by the industry, its key market, and business drivers.

Integration – The system needs to be capable of integrating Bottom Up and Top Down planning methods in one application and show transparent deviations of both outcomes.

Participation – The successful implementation of Rolling Forecasts is based on a collaborative approach that involves people from both financial and operational backgrounds, full transparency (regarding drivers and estimates), and a dedicated application on which all of the people involved can work together.

A Case Study from Olivier Goetschy

Last week’s board meeting also featured an inspiring case study presented by Olivier Goetschy, CFO from Gewiss. Olivier shared his experience around the implementation of Rolling Forecast at Gewiss.

The key findings from Ms. Lee’s presentation are summarized below:

Larysa’s Rolling Forecast Maturity Model

Following Olivier Goetschy’s presentation, Larysa Melnychuk also shared it’s 3-stage Rolling Forecast Maturity Model which she developed during the London FP&A Board Meetings:

Group Work

Following these presentations, the meeting’s participants partook in group workshops where they worked on the following questions:

Analytical Aspect of the Rolling Forecast: What is needed for the leading process?

Full transparency about KPIs and the business’ key drivers are an important enabler for the analytical aspect of the Rolling Forecast. The relevant information needs to be stored in a central trusted data hub and should include financial, operational and external market/competitor information. Many organizations focus too much on financial information and miss important drivers which should be an integral part of the Rolling Forecast model.

Human and Cultural Aspect of the Rolling Forecast: What is needed for the leading process?

The move to a Rolling Forecast approach is a big change for many organizations. The relevant people need to be involved early and the project team needs to be empowered by management. People from both financial and operational roles also need to collaborate on the project, and the organization should be made aware that the Rolling Forecast is a management tool, not just a tool for managing bonuses. During the group work following key aspects were identified:

People doing Rolling ForecastPeople feeding Rolling Forecast
Ability to explain why the process is importantUnderstanding of the objectives
Project Team need to be Business OrientedProject is not finance driven
Fast working attitude without losing qualityManagement tool but measurement of forecast accuracy also important
Deadline focusedTechnical Tool Knowledge to streamline the process
Ability to work under pressure 

Apliqo’s Experience with Customers: A Practical Way To Implement Rolling Forecasts

To conclude the meeting, Apliqo shared its experience and tips on practical ways for businesses to implements Rolling Forecasts:

Proactive Communication (advertise) – Each company should evaluate the added value of Rolling Forecasts for their organization and, following the buy-in from management, the project team needs to proactively communicate and advertise the concept.

As-Is of Current Plans (document) – The project team needs to review all existing planning layers and document them. Many organizations/departments have planning models with important information for the Rolling Forecast, but these models are often found outside of an existing central planning application.

Analytical Layer (identify drivers) – A Rolling Forecast model starts with the identification of the key drivers of a business. The basis for this is an analytical layer which contains the companies financial and operational information. During this process, the project team should use techniques like Pareto (80/20) to only focus on the most important parts of the business. For example, it doesn`t make sense to forecast all SKUs or customers in a Rolling Forecast. Instead, the forecast should only focus on the key elements that make up roughly 80 % of the companies business.

Design Model/Architecture – Once the analytical part of the process is over, the project team needs to build/design the architecture for the company’s Rolling Forecast Model. This model needs to be fully transparent and clearly documented.

Link Operational And Financial Plans – Financials are only the outcome of operational drivers or processes. Without the links between operational and financial plans, organizations struggle to identify root cause/effects and simulate different rolling scenarios.

Use FP&A Best Practice Methods – A Rolling Forecast will not be successful if companies don’t also follow FP&A best practices like driver-based planning, scenario modeling, or integrated planning. It is impossible to execute monthly or quarterly Rolling Forecasts in Excel or other systems just with basic planning techniques like data entry.

Define Frequency And Horizon – Frequency and horizon are mainly driven by an industry’s lead cycle and vary from monthly to quarterly (frequency) and rolling from 2 to 6 quarters (horizon).

Execute And Review Collaborative Plans – The execution of each Rolling Forecast is based on the aforementioned parameters. For a successful implementation of these forecasts, full transparency during the review process is extremely important. The review needs to be based on a clear overview of the outcomes and key assumptions and should be easy-to-understand for those members of the organization that are not in finance. During review meetings, the project team should be able to change key assumptions or drivers and immediately see the outcomes and impacts on the business’ bottom line.

Last week’s event was hosted and sponsored by FP&A partners Apliqo and Michael Page.

The entire team at Apliqo is looking forward to our other upcoming events in 2019.

The next FP&A Board Meeting sponsered by Apliqo will take place in Frankfurt and is about FP&A Business Partnering.


Are you interested in attending Apliqo webinars? Check out our webinar schedule!


Related Posts

More resources

Combining an internal and external focus for improved private market investing

In this article, we’re going to show how you can blend an internal focus (cash flow projections) with an external focus (fund-level benchmarking) to optimise your investment decisions and arrive at more robust and fine-tuned portfolio constructions.

Read this article
In this article, we’re going to show how you can blend an internal focus (cash flow projections) with an external focus (fund-level benchmarking) to optimise your investment decisions and arrive at more robust and fine-tuned portfolio constructions.

Investing with confidence

How Analytical Portfolio Management enables Limited Partners to make better investment decisions.

Read this article
How Analytical Portfolio Management enables LPs to make better investment decisions

Shape the perspective of your storytelling with data

The ability to rapidly synthesize and respond to financial and operational data is not just an advantage, it's a necessity. Decision-makers across large organizations count on insightful reports that are predicated on detailed, bottom-up data to guide their strategic moves. Only through sophisticated reporting and analytics capabilities, we can truly discern the signal amid the noise.

Read this article
Shape the perspective of your data storytelling

How to stay on top of your private market investments

Institutional assets tend to have sophisticated tools in place to manage the liquid assets in their portfolios but these don’t transfer well to the unique needs of private market investments because they provide little to no flexibility in terms of addressing the specific challenges that come with illiquid assets. In this article, we are going to explore the unique aspects of this opaque asset class and show how an analytical portfolio management solution can support investors in making decisions that are backed by real data and models.

Read this article
Private Market Investments

Using driver-based planning to improve forecast accuracy

Forecasting and planning in complex environments requires a delicate balance between attention to the granular details and a bigger-picture view of what we’re actually trying to accomplish.

Read this article
Forecasting and planning in complex environments requires a delicate balance between attention to the granular details and a bigger-picture view of what we’re actually trying to accomplish.