The Use of Exponentially-Smoothed Transition Matrices to Improve Forecasting of Cash Flows from Accounts Receivable
AbstractA pioneering application of a Markov chain to forecast account receivable flows (Cyert, Davidson, and Thompson [Cyert, R. M., H. J. Davidson, G. L. Thompson. 1962. Estimation of the allowance for doubtful accounts by Markov chains. Management Sci. (August) 287-303.]) employed an unusual (the oldest balance) method of aging accounts and an assumption that the resulting transition matrix was stable. Forecasting steady state results was the primary focus of the application. The present research uses a commonly found (partial balance) method of aging, an assumption of dynamic changes in the transition matrix, and does not focus on steady state results. A manufacturer's data were analyzed and exponential smoothing was introduced to update the average transition matrix thereby enabling a tracking of changing customer payment behavior. The actual and Markovian estimates of the company's cash collections checked favorably. The paper also discusses how modifications such as the seasonal and trend adjustments introduced by Winters (Winters, P. R. 1960. Forecasting sales by exponentially weighted moving averages. Management Sci. (April) 324-342.) may be incorporated into the model. Extensions to other areas are offered.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoArticle provided by INFORMS in its journal Management Science.
Volume (Year): 24 (1978)
Issue (Month): 7 (March)
You can help add them by filling out this form.
CitEc Project, subscribe to its RSS feed for this item.
- Robert Till & David Hand, 2003. "Behavioural models of credit card usage," Journal of Applied Statistics, Taylor & Francis Journals, vol. 30(10), pages 1201-1220.
- Schechtman, Ricardo, 2013. "Default matrices: A complete measurement of banks’ consumer credit delinquency," Journal of Financial Stability, Elsevier, vol. 9(4), pages 460-474.
- Thomas, Lyn C., 2000. "A survey of credit and behavioural scoring: forecasting financial risk of lending to consumers," International Journal of Forecasting, Elsevier, vol. 16(2), pages 149-172.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Mirko Janc).
If references are entirely missing, you can add them using this form.