You may also be interested in:

Articles

Driver-Based Models: Defining the Mathematical Link

  • By Nilly Essaides
  • Published: 12/4/2015

forecastlinesDriver-based models express the mathematical relationship between key business drivers and financial performance, e.g., how the number of website hits translates into revenue. They are the way more than 80 percent of companies are, to some degree, looking to advance the accuracy of their forecasting process by tying operational key performance indicators (KPIs) to enterprise performance.

But how can companies create the right algorithms to capture that relationship? This will be explored in an upcoming AFP FP&A Guide, What’s Driver-Based Modeling & How Does It Work?.

First companies need to identify the right drivers. Next, according to Philip Peck, vice president, finance transformation at the Peloton Group, they can use several techniques to develop the models, which apply to:

  1. The determination of the candidate operational drivers
  2. Testing the mathematical algorithms and drivers for the effectiveness and accuracy of their predictive value
  3. Refining those drivers and related model relationships over time.

Slicing and dicing

One way to start is by decomposing the end-to-end value chain of the underlying business. Essentially, that’s looking at the business and understanding all of the various activities and functions that contribute to making, packaging, selling, delivering and supporting the goods and services generated by the organization.

“The analysis helps one develop a horizontally integrated view of the organization and highlights the key integration points between various aspects of the business,” said Peck.

The most common approaches include “driver trees” or “predictive logic diagrams.” Those help determine the driver/model relationships and candidate drivers. This involves looking at the outcome measure in question (dependent variable) and determine all of the contributing drivers (independent variables) that impact the outcome measure. Depending on the domain area in question, the number of levels or layers can be as simple as one or could continue into multiple levels. “Driver models can be quite simple, e.g., A x B = C. Alternatively, the driver models could be complex and incorporate a multitude of independent variables and potentially several levels of driver interdependencies,” Peck explained.

Once the initial driver model relationships and candidate drivers are determined, FP&A professionals can employ statistical techniques using representative data to identify the most applicable drivers and refine their math.

The goal is to find drivers that are most highly correlated with the outcome measure and demonstrate clear causality, versus mere correlation. That’s how FP&A can ensure the model has good predictive capabilities.

But it’s not all about math, according to Tony Levy, business unit executive, business analytics at IBM Software Group. FP&A also needs to work closely with the business to make sure it picks the right drivers before it develops the complex or simple models. He encourages finance to get closer to business leadership in addition to do the statistical analysis of the data. “Use both to refine and adapt your models,” he said.

The AFP FP&A Guide, What’s Driver-Based Modeling and how How does Does it Work?, will be published on January 22, 2016.

Data Quality for Financial Professionals
Wednesdays, July 24 - August 7
This three-part series aims to demonstrate how financial professionals can attack data quality proactively, with special emphasis on the first steps they can take. This course illustrates the benefits that finance departments can reap by attacking data quality proactively. 
Learn More

Copyright © 2018 Association for Financial Professionals, Inc.
All rights reserved.