Decision Support Services Based on Dynamic Digital Analyses - Quality Metrics for Financial Planning Processes

Decision making in corporate financial controlling is typically based on the aggregation of huge data sets of financial planning items stemming from a multitude of companies with heterogeneous financial planning processes and planning quality. Quality of financial planning is usually quantified by its outcome using accepted ex-post metrics such as planning accuracy or alternative derivatives of plan versus actual distances (planning errors). However, additional metrics for measuring the quality of the planning processes themselves are mandatory. First, controllers want to determine suspicious planning data and revisions that will likely result in huge planning errors. Second, the determination of flawed planning processes allows for more profound root cause analysis of poor planning accuracy. Unfortunately, nowadays controllers have little guidance on how to assess running planning processes. This is particularly true because of the complex data structure in financial planning processes often underlying unknown assumptions and dynamics. This papers discusses two ex-ante candidate-metrics for measuring the quality of financial planning, namely Benford's Law and weak planning data efficiency. Both measures are applied to multi-year financial planning data from set of over hundred enterprises. The outcomes of numerical analysis are presented and first managerial implications regarding decision support are drawn.

[1]  Roy Batchelor,et al.  Bias in macroeconomic forecasts , 2007 .

[2]  Hong Tuan Kiet Vo,et al.  Streamlining Foreign Exchange Management Operations with Corporate Financial Portals , 2008 .

[3]  Cindy Durtschi,et al.  The effective use of Benford's Law to assist in detecting fraud in accounting data , 2004 .

[4]  อนิรุธ สืบสิงห์,et al.  Data Mining Practical Machine Learning Tools and Techniques , 2014 .

[5]  Tobias Conte,et al.  Data Quality in Financial Planning - an Empirical Assessment Based on Benford's Law , 2012, ECIS.

[6]  Thomas Lux,et al.  Rational Forecasts or Social Opinion Dynamics? Identification of Interaction Effects in a Business Climate Survey , 2009 .

[7]  Scott D. Schuh An evaluation of recent macroeconomic forecast errors , 2001 .

[8]  Simon Newcomb,et al.  Note on the Frequency of Use of the Different Digits in Natural Numbers , 1881 .

[9]  Campbell R. Harvey,et al.  The Theory and Practice of Corporate Finance: Evidence from the Field , 1999 .

[10]  Jacob K. Thomas UNUSUAL PATTERNS IN REPORTED EARNINGS , 1988 .

[11]  M. Nigrini,et al.  The Use of Benford's Law as an Aid in Analytical Procedures , 1997 .

[12]  Andy P. Field,et al.  Discovering Statistics Using SPSS , 2000 .

[13]  David C. Mauer,et al.  The Determinants of Corporate Liquidity: Theory and Evidence , 1998, Journal of Financial and Quantitative Analysis.

[14]  Mark J. Nigrini,et al.  Computer assisted analytical procedures using Benford's Law , 2000 .

[15]  T. Hill A Statistical Derivation of the Significant-Digit Law , 1995 .

[16]  William D. Nordhaus,et al.  Forecasting Efficiency: Concepts and Applications , 1987 .

[17]  R. Fildes,et al.  The State of Macroeconomic Forecasting , 2002 .