Fitting random cash management models to data

Francisco Salas-Molina

DOI: https://doi.org/10.1016/j.cor.2018.04.007

2024-01-17

Abstract:Organizations use cash management models to control balances to both avoid overdrafts and obtain a profit from short-term investments. Most management models are based on control bounds which are derived from the assumption of a particular cash flow probability distribution. In this paper, we relax this strong assumption to fit cash management models to data by means of stochastic and linear programming. We also introduce ensembles of random cash management models which are built by randomly selecting a subsequence of the original cash flow data set. We illustrate our approach by means of a real case study showing that a small random sample of data is enough to fit sufficiently good bound-based models.

Computational Finance

What problem does this paper attempt to address?

This paper mainly discusses how to fit the stochastic cash management model to actual data in order to improve the traditional cash management models based on specific probability distribution assumptions. The paper proposes a mixed integer linear programming approach to derive the boundary-based base model from general stochastic programming problems, and avoids the computational burden of large-scale linear programming by randomly selecting sub-sequences of the original cash flow dataset. In addition, the paper introduces a set of stochastic cash management models to determine deployment strategies by averaging the outputs of randomly trained models. This approach does not require any formal assumptions about the cash flow process, but directly constructs data-driven cash management models from the data.

Specifically, the main contributions of the paper include:
1. Providing a method to solve the boundary-based base cash management model problem without making assumptions about the cash flow process.
2. Constructing data-driven cash management models by fitting parameters to the data.
3. Introducing a set of stochastic cash management models.

The paper demonstrates this method through a case study of a Spanish industrial company and compares it with the Miller-Orr model, proving that small-scale random data samples are sufficient to construct good enough boundary-based base models. In addition, the paper discusses how to accelerate computations by randomly selecting sub-sequences of data and proposes methods to evaluate the model's generalization ability, such as cross-validation.