IDEAS home Printed from https://ideas.repec.org/p/arx/papers/1611.04941.html
   My bibliography  Save this paper

Empirical analysis of daily cash flow time series and its implications for forecasting

Author

Listed:
  • Francisco Salas-Molina
  • Juan A. Rodr'iguez-Aguilar
  • Joan Serr`a
  • Montserrat Guillen
  • Francisco J. Martin

Abstract

Cash managers make daily decisions based on predicted monetary inflows from debtors and outflows to creditors. Usual assumptions on the statistical properties of daily net cash flow include normality, absence of correlation and stationarity. We provide a comprehensive study based on a real-world cash flow data set from small and medium companies, which is the most common type of companies in Europe. We also propose a new cross-validated test for time-series non-linearity showing that: (i) the usual assumption of normality, absence of correlation and stationarity hardly appear; (ii) non-linearity is often relevant for forecasting; and (iii) typical data transformations have little impact on linearity and normality. Our results provide a forecasting strategy for cash flow management which performs better than classical methods. This evidence may lead to consider a more data-driven approach such as time-series forecasting in an attempt to provide cash managers with expert systems in cash management.

Suggested Citation

  • Francisco Salas-Molina & Juan A. Rodr'iguez-Aguilar & Joan Serr`a & Montserrat Guillen & Francisco J. Martin, 2016. "Empirical analysis of daily cash flow time series and its implications for forecasting," Papers 1611.04941, arXiv.org, revised Jun 2017.
  • Handle: RePEc:arx:papers:1611.04941
    as

    Download full text from publisher

    File URL: http://arxiv.org/pdf/1611.04941
    File Function: Latest version
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. William J. Baumol, 1952. "The Transactions Demand for Cash: An Inventory Theoretic Approach," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 66(4), pages 545-556.
    2. Clements, Michael P. & Franses, Philip Hans & Swanson, Norman R., 2004. "Forecasting economic and financial time-series with non-linear models," International Journal of Forecasting, Elsevier, vol. 20(2), pages 169-183.
    3. Castle, Jennifer L. & Hendry, David F., 2010. "A low-dimension portmanteau test for non-linearity," Journal of Econometrics, Elsevier, vol. 158(2), pages 231-245, October.
    4. Franses, Philip Hans & van Dijk, Dick, 2005. "The forecasting performance of various models for seasonality and nonlinearity for quarterly industrial production," International Journal of Forecasting, Elsevier, vol. 21(1), pages 87-102.
    5. Baccarin, Stefano, 2009. "Optimal impulse control for a multidimensional cash management system with generalized cost functions," European Journal of Operational Research, Elsevier, vol. 196(1), pages 198-206, July.
    6. Penttinen, Markku J., 1991. "Myopic and stationary solutions for stochastic cash balance problems," European Journal of Operational Research, Elsevier, vol. 52(2), pages 155-166, May.
    7. Merton H. Miller & Daniel Orr, 1966. "A Model of the Demand for Money by Firms," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 80(3), pages 413-435.
    8. De Gooijer, Jan G. & Hyndman, Rob J., 2006. "25 years of time series forecasting," International Journal of Forecasting, Elsevier, vol. 22(3), pages 443-473.
    9. Premachandra, I. M., 2004. "A diffusion approximation model for managing cash in firms: An alternative approach to the Miller-Orr model," European Journal of Operational Research, Elsevier, vol. 157(1), pages 218-226, August.
    10. Srinivasan, Venkat & Kim, Yong H, 1986. "Deterministic cash flow management: State of the art and research directions," Omega, Elsevier, vol. 14(2), pages 145-166.
    11. Lee, Tae-Hwy & White, Halbert & Granger, Clive W. J., 1993. "Testing for neglected nonlinearity in time series models : A comparison of neural network methods and alternative tests," Journal of Econometrics, Elsevier, vol. 56(3), pages 269-290, April.
    12. J. P. Royston, 1982. "The W Test for Normality," Journal of the Royal Statistical Society Series C, Royal Statistical Society, vol. 31(2), pages 176-180, June.
    13. Miller, Tom W. & Stone, Bernell K., 1985. "Daily Cash Forecasting and Seasonal Resolution: Alternative Models and Techniques for Using the Distribution Approach," Journal of Financial and Quantitative Analysis, Cambridge University Press, vol. 20(3), pages 335-351, September.
    14. George M. Constantinides & Scott F. Richard, 1978. "Existence of Optimal Simple Policies for Discounted-Cost Inventory and Cash Management in Continuous Time," Operations Research, INFORMS, vol. 26(4), pages 620-636, August.
    15. Zhang, Guoqiang & Eddy Patuwo, B. & Y. Hu, Michael, 1998. "Forecasting with artificial neural networks:: The state of the art," International Journal of Forecasting, Elsevier, vol. 14(1), pages 35-62, March.
    16. Gormley, Fionnuala M. & Meade, Nigel, 2007. "The utility of cash flow forecasts in the management of corporate cash balances," European Journal of Operational Research, Elsevier, vol. 182(2), pages 923-935, October.
    17. Granger, Clive W. J. & Terasvirta, Timo, 1993. "Modelling Non-Linear Economic Relationships," OUP Catalogue, Oxford University Press, number 9780198773207.
    18. Gregory, Geoffrey, 1976. "Cash flow models: A review," Omega, Elsevier, vol. 4(6), pages 643-656.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Francisco Salas-Molina & Juan A. Rodríguez-Aguilar & Montserrat Guillen, 2023. "A multidimensional review of the cash management problem," Financial Innovation, Springer;Southwestern University of Finance and Economics, vol. 9(1), pages 1-35, December.
    2. Francisco Salas-Molina & David Pla-Santamaria & Juan A. Rodriguez-Aguilar, 2018. "A multi-objective approach to the cash management problem," Annals of Operations Research, Springer, vol. 267(1), pages 515-529, August.
    3. Salas-Molina, Francisco & Martin, Francisco J. & Rodríguez-Aguilar, Juan A. & Serrà, Joan & Arcos, Josep Ll., 2017. "Empowering cash managers to achieve cost savings by improving predictive accuracy," International Journal of Forecasting, Elsevier, vol. 33(2), pages 403-415.
    4. Francisco Salas-Molina & Juan A. Rodríguez-Aguilar, 2018. "Data-driven multiobjective decision-making in cash management," EURO Journal on Decision Processes, Springer;EURO - The Association of European Operational Research Societies, vol. 6(1), pages 77-91, June.
    5. Francisco Salas-Molina, 2020. "Risk-sensitive control of cash management systems," Operational Research, Springer, vol. 20(2), pages 1159-1176, June.
    6. Yonit Barron, 2022. "A probabilistic approach to the stochastic fluid cash management balance problem," Annals of Operations Research, Springer, vol. 312(2), pages 607-645, May.
    7. Moraes, Marcelo Botelho da Costa & Nagano, Marcelo Seido, 2014. "Evolutionary models in cash management policies with multiple assets," Economic Modelling, Elsevier, vol. 39(C), pages 1-7.
    8. Francisco Salas-Molina & Juan A. Rodriguez-Aguilar & David Pla-Santamaria & Ana García-Bernabeu, 2021. "On the formal foundations of cash management systems," Operational Research, Springer, vol. 21(2), pages 1081-1095, June.
    9. Francisco Salas-Molina, 2024. "Fitting random cash management models to data," Papers 2401.08548, arXiv.org.
    10. Van Son Lai & Duc Khuong Nguyen & William Sodjahin & Issouf Soumaré, 2018. "Discretionary Idiosyncratic Risk, Firm Cash Holdings and Investment," Working Papers 2018-008, Department of Research, Ipag Business School.
    11. Fernando Alvarez & Francesco Lippi & Roberto Robatto, 2019. "Cost of Inflation in Inventory Theoretical Models," Review of Economic Dynamics, Elsevier for the Society for Economic Dynamics, vol. 32, pages 206-226, April.
    12. Barron, Yonit, 2023. "A stochastic card balance management problem with continuous and batch-type bilateral transactions," Operations Research Perspectives, Elsevier, vol. 10(C).
    13. Schroeder, Pascal & Kacem, Imed, 2020. "Competitive difference analysis of the cash management problem with uncertain demands," European Journal of Operational Research, Elsevier, vol. 283(3), pages 1183-1192.
    14. Francisco Salas-Molina & Juan A. Rodriguez-Aguilar & David Pla-Santamaria, 2020. "A stochastic goal programming model to derive stable cash management policies," Journal of Global Optimization, Springer, vol. 76(2), pages 333-346, February.
    15. Opler, Tim & Pinkowitz, Lee & Stulz, Rene & Williamson, Rohan, 1999. "The determinants and implications of corporate cash holdings," Journal of Financial Economics, Elsevier, vol. 52(1), pages 3-46, April.
    16. Hinderer, K. & Waldmann, K. -H., 2001. "Cash management in a randomly varying environment," European Journal of Operational Research, Elsevier, vol. 130(3), pages 468-485, May.
    17. García Cabello, Julia, 2017. "The future of branch cash holdings management is here: New Markov chains," European Journal of Operational Research, Elsevier, vol. 259(2), pages 789-799.
    18. Alvarez, Fernando & Lippi, Francesco, 2013. "The demand of liquid assets with uncertain lumpy expenditures," Journal of Monetary Economics, Elsevier, vol. 60(7), pages 753-770.
    19. Bar-Ilan, Avner & Marion, Nancy, 2013. "Demand for cash with intra-period endogenous consumption," Journal of Economic Dynamics and Control, Elsevier, vol. 37(12), pages 2668-2678.
    20. García Cabello, Julia & Lobillo, F.J., 2017. "Sound branch cash management for less: A low-cost forecasting algorithm under uncertain demand," Omega, Elsevier, vol. 70(C), pages 118-134.

    More about this item

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:arx:papers:1611.04941. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: arXiv administrators (email available below). General contact details of provider: http://arxiv.org/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.