The FP&A Trends Webinar: Mastering Analytical Transformation with FP&A Trends Maturity Model
Click here to view details and register
The FP&A Trends Webinar: Mastering Analytical Transformation with FP&A Trends Maturity Model
Click here to view details and register
By Samuel Owens, FP&A Manager at Vericast
For the modern FP&A professional, Excel is an invaluable and versatile tool, but to provide best-in-class business partnering support, FP&A professionals must find ways to evolve Excel-based tools into more integrated solutions. In this FP&A Trends webinar, Larysa Melnychuk, CEO and Managing Director at FP&A Trends Group was joined by Jim Boswell, VP of Finance at FullSpeed Automotive, Tomasz Klimek, Head of FP&A at International Airlines Group, and Jonathan Yahalom, Head of FP&A Solutions at DataRails, to discuss strategies and best practices to transition from Excel to Integrated FP&A.
The discussion centred around three main topics:
Driver-Based Modeling is the basis for flexible and dynamic FP&A, and its purpose is to operationalise financials in a tangible way for the operators of the business. So, what exactly is DBM?
DBM starts with the systematic deconstruction of the business model into discrete components. These components, or operational “drivers,” are then managed by operations managers and monitored routinely. Financial budgets and forecasts are constructed using these operational drivers. This approach moves the organisation away from traditional budgeting practices, such as “last year-plus,” and creates integrated driver-based financials that are rooted in operations activities.
Some best practices for implementing DBM in your organisation:
The simplest approach to deconstructing the business for operational drivers is to start with the largest revenue and cost categories. It helps to create a decomposition diagram so the organisation can decide which costs the business has the most control over the greatest influence. A good approach is to make this a cross-departmental exercise that involves people with lots of industry experience. Have a “painstorming” session to learn what doesn’t work but follow that up with a brainstorming session to create solutions.
Once those drivers are identified, decide how they should be measured and how they directly influence costs. These drivers become the inputs in an integrated database solution.
These design sessions should also focus on the desired outputs. Some examples are financial statements, fixed/variable analysis, variance analysis, business cases, dashboards, etc. Thinking through these outputs and then working backwards will guide the organisation when designing these processes. And while designing the model, consider not only the implementation costs but also the resources needed to maintain and operate the model.
An effective model should integrate all business functions, such as procurement, business operations, HR, and Finance, so inputs and outputs utilised by those functions contribute to and we sourced from a central database.
Once the model is built and utilised, the organisation moves into the continuous improvement stage. In this stage, the organisation asks itself: How do we refine the model? How do we improve correlation and causality? What analytics (such as variance analysis) can be automated? Whether this can be done in-house or through an external business solutions provider will depend on the capabilities and resources of the organisation.
In most companies relying on Excel-based solutions, Excel is doing everything: it functions as the database, the calculation engine, and the analytical tool, sometimes all within one workbook. This approach is resource-intensive and eventually becomes unsustainable. And while Excel is an excellent tool for spreadsheets, financial modelling, and provides FP&A with much-needed agility, it’s not effective for sophisticated FP&A processes such as data consolidation, repetitive reporting processes, drill-downs, and comparison analysis (such as scenario comparisons). A technology solution is needed to unlock additional power.
To have the best of both solutions, the current processes that were built using the “Start Now in Excel” approach can be deconstructed and subsequently reconstructed using an integrated technology solution.
How this approach works: First, remove databases from Excel and move those into the cloud. Next, move all data mappings, scenarios, and drivers out of Excel and build those into the technology solution. What’s kept are the calculations that spreadsheets do well.
This unification process elevates the strengths of each solution while reducing complexity, providing the organisation with an integrated FP&A solution.
The first step in implementing a Driver-Based Model is to start now in Excel, identifying the 20% of operational drivers that explain 80% of the financial variances. This first step establishes the framework for an integrated, technology-based solution.
As the model develops and data flow is integrated cross-functionally, it will naturally and necessarily increase in complexity.
To unify these processes with a technology solution, the current processes can be deconstructed and then reconstructed using an integrated approach, allowing technology solutions to handle the weaknesses of Excel-based processes (databases, global assumptions, Scenarios Planning) and keeping all the desirable aspects of Excel (financial modelling, ad hoc reporting, analytics).
We would like to thank our global sponsor, DataRails, for their great support with this FP&A Trends Webinar.
Strategic planning is mostly done with qualitative analysis. In this article, we will explore the use...
Financial models are crucial to the business but building them in Excel can be both complicated...
So, the article described the methodology of creating a driver-based model on the example of an...
Driver-based planning is a key topic for any FP&A team today. But what is not always...
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.