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.
- 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.
- Schechtman, Ricardo, 2013. "Default matrices: A complete measurement of banks’ consumer credit delinquency," Journal of Financial Stability, Elsevier, vol. 9(4), pages 460-474.
- Robert Till & David Hand, 2003. "Behavioural models of credit card usage," Journal of Applied Statistics, Taylor & Francis Journals, vol. 30(10), pages 1201-1220.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Mirko Janc).
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 references are entirely missing, you can add them using this form.
If the full references list an item that is present in RePEc, but the system did not link 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 profile, as there may be some citations waiting for confirmation.
Please note that corrections may take a couple of weeks to filter through the various RePEc services.