Advertisement

Journal of Financial Services Marketing

, Volume 24, Issue 3–4, pp 69–80 | Cite as

Sales forecasting in financial distribution: a comparison of quantitative forecasting methods

  • Jiří ŠindelářEmail author
Original Article

Abstract

This paper deals with the issue of forecastability of sales activities of independent financial advisers (agents). Employing the most common quantitative methods on a diverse sample of timelines from multiple advisory companies, we have found that under most settings, these methods offer sub-par performance with high relative errors and no statistical differences between them. When a more granular approach is applied (reflecting sales unit size), ARIMA and the simple moving average emerge as significantly less accurate. This outcome is true for all sales units regardless of their size, when relative error is concerned. Thus, our analysis confirms the difficult forecastability of financial sales, speaking against the utilisation of more sophisticated forecasting methods, which mostly fail when compared to their much simpler and less costly counterparts.

Keywords

Financial sales Sales forecasting Quantitative forecasting Mean absolute percentage error (MAPE) Linear model with mixed effects 

Notes

Acknowledgements

This work was supported by the Czech Science Foundation under Grant No. 16-21506S: New sources of systemic risk on financial markets (2016–2018).

References

  1. Ali, M.M., and J.E. Boylan. 2010. The value of forecast information sharing in supply chains. Foresight: The International Journal of Applied Forecasting 18: 14–18.Google Scholar
  2. Catt, P.M. 2009. Forecastability: Insights from physics, graphical decomposition, and information theory. Foresight 13 (Spring): 24–33.Google Scholar
  3. Chen, K.Y. 2011. Combining linear and nonlinear model in forecasting tourism demand. Expert Systems with Applications 38 (8): 10368–10376.CrossRefGoogle Scholar
  4. Chu, C.W., and G.P. Zhang. 2003. A comparative study of linear and nonlinear models for aggregate retail sales forecasting. International Journal of Production Economics 86 (3): 217–231.CrossRefGoogle Scholar
  5. Czech National Bank—CNB. 2018a. Inflation statistics. Accessed 6 September 2018. https://www.cnb.cz/en/statistics/inflation/index.html.
  6. Czech National Bank—CNB. 2018b. Repo interest rate over time. Accessed 6 September 2018. https://www.cnb.cz/cs/faq/jak_se_vyvijela_dvoutydenni_repo_sazba_cnb.html.
  7. Czech Statistical Office—CZSO. 2018a. Employment, unemployment statistics. Accessed 6 September 2018. https://www.czso.cz/csu/czso/employment_unemployment_ekon.
  8. Czech Statistical Office—CZSO. 2018b. Wages and labour statistics. Accessed 6 September 2018. https://www.czso.cz/csu/czso/labour_and_earnings_ekon.
  9. Dalrymple, D.J. 1975. Sales forecasting methods and accuracy. Business Horizons 18 (6): 69–73.CrossRefGoogle Scholar
  10. Dalrymple, D.J. 1987. Sales forecasting practices: Results from a United States survey. International Journal of Forecasting 3 (3–4): 379–391.CrossRefGoogle Scholar
  11. Gilliland, M. 2010. The Business Forecasting Deal: Exposing Myths, Eliminating Bad Practices, Providing Practical Solutions. New York, USA: Wiley.Google Scholar
  12. Goodwin, P. 2011. High on complexity, low on evidence: Are advanced forecasting methods always as good as they seem?. Foresight: The International Journal of Applied Forecasting 23: 10–12.Google Scholar
  13. Gordon, A. 2010. The boundaries of quantitative forecasting methods: Respecting the limits of determinism. Foresight: The International Journal of Applied Forecasting 19: 9–15.Google Scholar
  14. Green, K.C., and J.S. Armstrong. 2015. Simple versus complex forecasting: The evidence. Journal of Business Research 68 (8): 1678–1685.CrossRefGoogle Scholar
  15. Green, K.C., J.S. Armstrong, and W. Soon. 2009. Validity of climate change forecasting for public policy decision making. International Journal of Forecasting 25 (4): 826–832.CrossRefGoogle Scholar
  16. Hyndman, R.J., and G. Athanasopoulos. 2018. Forecasting: Principles and practice. Published by OTexts.com, full text available at: https://www.otexts.org/fpp.
  17. Hyndman, R.J., and A.B. Koehler. 2006. Another look at measures of forecast accuracy. International Journal of Forecasting 22 (4): 679–688.CrossRefGoogle Scholar
  18. Hyndman, R.J., and A.V. Kostenko. 2007. Minimum sample size requirements for seasonal forecasting models. Foresight 6 (Spring): 12–15.Google Scholar
  19. Hofer, P., C. Eisl, and A. Mayr. 2015. Forecasting in Austrian companies: Do small and large Austrian companies differ in their forecasting processes? Journal of Applied Accounting Research 16 (3): 359–382.CrossRefGoogle Scholar
  20. Kaltenbacher, J., and R. Decker. 2014. New product sales forecasting: An approach for the insurance business. World Journal of Management 5 (1): 36–53.CrossRefGoogle Scholar
  21. Lee, J., Lee, C. Y., & Lee, K. S. (2012). Forecasting demand for a newly introduced product using reservation price data and Bayesian updating. Technological Forecasting and Social Change 79 (7): 1280–1291.CrossRefGoogle Scholar
  22. Madhani, P.M. 2016. Sales and marketing integration: Enhancing competitive advantages. The IUP Journal of Business Strategy 13 (4): 50–77.Google Scholar
  23. Makridakis, S., and M. Hibon. 2000. The M3-Competition: Results, conclusions and implications. International Journal of Forecasting 16 (4): 451–476.CrossRefGoogle Scholar
  24. Makridakis, S., A. Andersen, R. Carbone, R. Fildes, M. Hibon, R. Lewandowski, and R. Winkler. 1982. The accuracy of extrapolation (time series) methods: Results of a forecasting competition. Journal of Forecasting 1 (2): 111–153.CrossRefGoogle Scholar
  25. Ministry of Finance of the Czech Republic—MF. 2018. Macroeconomic forecast. Accessed 6 September 2018. http://www.mfcr.cz/cs/verejny-sektor/makroekonomika/makroekonomicka-predikce.
  26. McCarthy, T.M., D.F. Davis, S.L. Golicic, and J.T. Mentzer. 2006. The evolution of sales forecasting management: A 20-year longitudinal study of forecasting practices. Journal of Forecasting 25 (5): 303–324.CrossRefGoogle Scholar
  27. Mentzer, J.T., and K.B. Kahn. 1995. Forecasting technique familiarity, satisfaction, usage, and application. Journal of Forecasting 14 (5): 465–476.CrossRefGoogle Scholar
  28. Merrilees, B., and K.S. Fam. 1999. Effective methods of managing retail sales. The International Review of Retail, Distribution and Consumer Research 9 (1): 81–92.CrossRefGoogle Scholar
  29. O’Grady, J.P. 1965. Sales forecasting techniques used by selected life insurance companies. The Journal of Risk and Insurance 32 (1): 113–120.CrossRefGoogle Scholar
  30. Peterson, R.M., G.L. Gordon, and V. Krishnan. 2015. When sales and marketing align: Impact on performance. Journal of Selling 1 (15): 29–43.Google Scholar
  31. Ramos, P., N. Santos, and R. Rebelo. 2015. Performance of state space and ARIMA models for consumer retail sales forecasting. Robotics and Computer-Integrated Manufacturing 34: 151–163.CrossRefGoogle Scholar
  32. Reifner, U., Neuberger, D., Rissi, R., Riefa, Ch., Knobloch, M., Clerc-Renaud, S. and Finger Ch. 2012. Study on remuneration structures of financial services intermediaries and conflicts of interest. [Working Paper, No. MARKT/2012/026/H]. Hamburg, Germany: IFF - Institut für Finanzdienstleistungen.Google Scholar
  33. Salomon, R., and J.M. Shaver. 2005. Export and domestic sales: Their interrelationship and determinants. Strategic Management Journal 26 (9): 855–871.CrossRefGoogle Scholar
  34. Syntetos, A.A., M.Z. Babai, and E.S. Gardner. 2015. Forecasting intermittent inventory demands: Simple parametric methods vs. bootstrapping. Journal of Business Research 68 (8): 1746–1752.CrossRefGoogle Scholar

Copyright information

© Springer Nature Limited 2019

Authors and Affiliations

  1. 1.University of Finance and Administration PraguePrague 10Czech Republic

Personalised recommendations