Modeling of Cash Flows from Nonperforming Loans in a Commercial Bank Srečko Devjak Rizikomanagement d.o.o., Velike Lašče, Slovenia srecko.devjak@rizikomanagement.si Abstract The purpose of this paper is to derive a model for calculation of maturities and volumes of repayments that a bank may expect from nonretail nonperforming loans (hereafter NPLs). Expected inflows from nonretail NPLs follow a probability distribution, defined by size and timing of historic repayments of NPLs. Empirical analysis has shown that probability distribution of expected inflows from nonretail NPLs considerably deviates from symmetric distribution and is asymmetric to the right. Accuracy of derived model depends upon available data in banks about NPLs by corporate sectors and recovery rates by time intervals. The model in this paper is in interest of any bank and in particular of banks with a higher fraction of NPLs in their loan portfolio. Contribution of this paper to the added value in the area of liquidity risk management in banks is high because the remaining literature does not deliver other models for the same purpose. ORIGINAL SCIENTIFIC PAPER RECEIVED: OCTOBER 2018 REVISED: NOVEMBER 2018 ACCEPTED: NOVEMBER 2018 DOI: 10.2478/ngoe-2018-0018 UDK: 336.71:33.067 JEL: G21, G33, C53 Citation: Devjak, S. (2018). Modeling of Cash Flows from Nonperforming Loans in a Commercial Bank. Nase Gospodarstvo/Our Economy, 64(4), 3-9. DOI: 10.2478/ngoe-2018-0018 Keywords: bank, liquidity risk, cash flow modeling, credit risk, non-performing loans Introduction An NPL is a loan that is subject to late repayment or is unlikely to be repaid by the borrower. Each NPL not only reduces profitability of the bank but deteriorates its liquidity situation. If the NPL portfolio increases, the bank needs to increase loan loss provisions. Loan loss provisions reduce bank profits. If enlargement of loan loss provisions due to the NPL portfolio increase is greater than operating profit, the bank ends up with a loss. And a loss over a number of subsequent time horizons requires owners to increase capital of the bank. Therefore, appearance of each new NPL in the loan portfolio of a bank reduces equity value of bank owners. More about equity value and goal of corporate operations can be found in Levy and Sarnat (1977). Business environments with low interest rates are particularly demanding for banks, as low interest rates reduce interest income and consequently operating profit of a bank. The lower operating profit of a bank, the sooner will the bank end up with a loss at a given level of loan loss provisions. Enlargement of the NPL portfolio will additionally worsen a bank's position as appearance of an NPL stops contractual interest payments. Interest income of the bank will therefore additionally decline. The larger the NPL portfolio of a bank, the lower is the bank's interest income. This paper is organized as follows. We will first review available literature, relevant to our research. Then, we will build a model for calculation of maturities and volumes NG NASE GOSPODARSTVO OUR ECONOMY Vol. . 64 No. 4 2018 pp . 3-9 39 NASE GOSPODARSTVO / OUR ECONOMY Vol. 64 No. 4 / December 2018 of repayments, which a bank may expect from NPLs. Based on empirical data about nonretail NPLs from a sample bank, we will then estimate probability distribution of expected inflows from NPLs. In the following section, we will review results and discuss them. In the last section, we will provide a conclusion, which also shows model limitations and recommendations for further research. Literature Review Absence of interest payments deteriorates a bank's liquidity. But this is not the only reason why a bank's liquidity deteriorates in the case the NPL portfolio of the bank increases. At the moment of NPL identification become contractual maturities and amounts of repayments random variables. Cutoff times and corresponding amounts of repayments in the future are linked to probabilities, which vary. A bank can steer the level of probabilities with the quality of its internal workout process. Guo, Jarrow, and Zeng (2009) explained that the earlier a bank identifies an NPL, the higher is the expected recovery rate. The authors assumed that default triggers the recovery rate process, which, if triggered, depends on asset value of the firm. If the debt matures before the firm becomes insolvent (defined as the firm's asset value falling below an insolvency barrier), then the debt is paid in full or at some fractional level. The fractional recovery when the firm is solvent exceeds the amount that would be paid if the firm becomes insolvent and enters bankruptcy. Guo, Jarrow, and Zeng (2009) also showed that, if the firm's asset value is below an insolvency threshold at the time of default, then the default and bankruptcy intensity are equal. However, if the asset value is above or equal to this critical level, then the default and bankruptcy intensities are distinct, and default does not necessarily lead to immediate bankruptcy. Carey and Gordy (2007) offered a model and evidence that private debtholders play a key role in setting the endogenous asset value threshold below which corporations declare bankruptcy. The model, in the spirit of Black and Cox (1976), implies that the recovery rate at emergence from bankruptcy on all of a firm's debt is related to the pre-bankruptcy share of private debt in all of a firm's debt. Recovery rates depend on general activity of business subjects in the economy. The number of defaulting firms in recessions rises and average recovery rate decreases (Bruche & Gon-zales-Aguado, 2010). Truck et al. (2005) also explain that recoveries in recessions are much lower in comparison with times of economic expansion. Carey (1998) found that, especially for risky loans, recessions have an enormous impact on the distribution of recovery rates. According to his findings, this is especially true for the tails of the loss distribution. While for investment-grade loans, the cyclical effect is rather small; thus, the author found that loss rates for subinvestment grade loans during a recession are more than 50% higher than during an expansion of the economy. Deshpande and Iyer (2009) explored correlations between loss rates and proposed a model for measurement of credit concentration risk and for calculation of the portfolio loss distribution. Despite abundant literature on the determinants of default on loans and other debt instruments, relatively little is known about the factors that influence bank recoveries following default. However, recovery is critical to bank performance as well as to the proper measure of the capital needed to buffer against risk. Therefore, Khieu et al. (2012) identified determinants of bank loan recovery rates. The authors show that loan characteristics are, in general, more significant determinants of recovery rates than borrower characteristics prior to default. A variety of loan contract features are strongly related to the ultimate payoff for creditors. Secured loans have higher recoveries, especially when the collateral takes the form of inventories and accounts receivable. Loans to borrowers with prior defaults yield higher recoveries than first-time defaults, and arranging a prepackaged bankruptcy increases recoveries. Loan recoveries vary significantly and nonlinearly with the length of time to emerge. Macroeco-nomic conditions significantly affect recovery prospects, but the probability of default at the time of loan origination is unrelated to ultimate recoveries. In an annual default study, Moody's (2013) explained the corporate default and recovery rates on a time horizon between 1920 and 2012. Measured by post-default trading prices, the average recovery rate for senior unsecured bonds in 2012 rose to 43,4% from 39,7% in 2011. If the size of the NPL portfolio has raised rapidly, a liquidity crisis becomes inevitable for a bank (Sohaimi, 2013). Appearance of a new NPL deteriorates a bank's liquidity because cutoff times and amounts of future repayments for this loan deviate from contractually agreed maturities and amounts of repayments. As NPL appears due to inability of the obligor to pay on time, we can expect future repayments to occur later than contractually agreed. This reduces liquidity surplus of a bank in the short-term and increases the probability of illiquidity. The impact on probability is lower if an NPL is an amortizing loan and not a bullet loan. Consequently, it holds that, among two completely identical banks, which differ among themselves only in type of loans in the loan portfolio, where the first bank only has amortizing loans and the second bank only has bullet loans, exposure to liquidity risk is lower in the first bank. We can conclude that the timing and size of future repayments of a new NPL based upon the timing and size of 40 Srecko Devjak: Modeling of Cash Flows from Nonperforming Loans in a Commercial Bank historic repayments of NPLs, which have either been already repaid or written off by the bank (historic NPLs). We are going to show a possible approach in this paper. The Model Assume a bank maintains a database, in which all NPLs are included. Also assume for each NPL the following data are available: exposure at default, default start date, default end date, cut-off date, and amount of each payment between default start and default end date, and exposure at default end date. If an NPL has a default end date, then recovery process for this particular loan was finished. This happened either because the counterparty fully repaid its debt or because the outstanding debt was written off. In the first case, exposure at the default end date was zero; in the second case, exposure at default end date was positive, but the bank wrote off the remaining debt, as it expected no additional repayment. On the other hand, if an NPL does not have a default end date in the database, then this NPL is a pending NPL. For the NPL cash flow modeling, pending NPLs in the database cannot be considered, as the default end date for pending NPLs is unknown. Only historic NPLs can therefore be used for modeling of cash flows from NPLs. BIS (2008) defined a set of principles for sound liquidity risk management and supervision. Principle 5 defines that a bank should have a sound process for identifying, measuring, monitoring, and controlling liquidity risk. This process should include a robust framework for projecting cash flows arising from assets, liabilities, and off-balance sheet items over an appropriate set of time horizons. The number of time horizons should correspond to a variety of factors. These include vulnerabilities to changes in liquidity needs and funding capacity on an intraday basis, day-to-day liquidity needs and funding capacity over short - and medium-term horizons up to one year, longer-term liquidity needs over one year and vulnerabilities to events, activities, and strategies that can put a significant strain on internal cash generation capability. Assume that a bank is in line with principles for sound liquidity risk management and supervision calculates net cash flows over a number of predefined time intervals, which are in general defined as (tM, t¡ ], i e {1, 2, ..., n}. For each historic NPL, a bank should first calculate the number of all payments in a time horizon between default start date and default end date. Each payment is an inflow for the bank and reduces outstanding exposure to the counterparty in default. Then, cut-off dates of payments should be observed, and the time difference between cutoff date of each payment and default start date should be calculated. Let m be the number of all payments between the default start date and default end date. Time difference S between cutoff i date Ci of payment p. and default start date ds is in general defined as S. = c. - d, where j e {1, 2, ..., m}. Calculated Sj indicate into which time interval payment pj of an NPL should be mapped. Assume the bank defined n time intervals. Then, payment p. should be mapped to time interval i, where i e {1, 2, ..., n} such that t^ < Sj < t¡. All m payments p. of an NPL should be mapped to corresponding time intervals the bank has defined for management of liquidity risk and for calculation of net cash flows. Then, payments p. should be aggregated by time intervals such that only one payment per time interval exists. Let be the number of all payments Pj, . e {1, 2, ..., m}, which meet the criteria t¡_i ,. i=i ¡=i i=i Payments pa for each k e {1, 2, ..., w} in the NPL portfolio of the bank should be distributed over all ie {1, 2, ..., n} time intervals. Therefore, in case of full recovery, it holds =1, as are expected write-offs equal to zero; therefore, i=i is g = 1. In case expected write-offs differ from zero and n holds g < 1, consequently, it also holds = g. >=i Recovery rate r. is an inflow from each cash unit, which is expected from an NPL in time interval i e {1, 2, ..., n}. EU Commission adopted the Basel 3 framework and in the Official Journal of the European Union (L 176, 2013) published a corresponding framework for the supervision of credit institutions, investment firms, and their parent companies in all member states of the European Union and the EEA. 5 NASE GOSPODARSTVO / OUR ECONOMY Vol. 64 No. 4 / December 2018 This framework is capital requirements directives CRD 4, which replace capital requirements directives 2006/48 and 2006/49. They are composed of the capital requirements directive (hereafter CRD) and of the capital requirements regulation (hereafter CRR) (Ernst & Young, 2011). Default of a nonretail obligor is defined in Article 178 of the CRR. A default of a particular obligor shall be considered to have occurred when the institution considers that the obligor is unlikely to pay its credit obligations to the institution, the parent undertaking, or any of its subsidiaries in full, without recourse by the institution to actions such as realizing security, or when the obligor is past due more than 90 days on any material credit obligation to the institution, the parent undertaking or any of its subsidiaries. Empirical Data and Analysis Probability distribution of expected inflows from NPLs will now be estimated empirically. For this purpose, we are going to use data about NPLs from the database of a sample bank. A database with NPLs of the bank only includes nonretail NPLs; therefore, probability distribution of expected inflows from nonretail NPLs will be estimated. For estimation of probability distribution, we need for each NPL recovery rate and data about size and timing of all repayments. Recovery rate is only available for historic NPLs. The same is true for data about size and timing of all repayments. Consequently, we should only use data about historic NPLs from database of the bank. Average recovery rate and average repayment speed depend on general activity of business subjects in the economy (Bruche & Gonzales-Aguado, 2010). The higher general activity of business subjects in the economy, the higher is the average recovery rate and average repayment speed. In order to estimate time invariable probability distribution of expected inflows from NPLs, historic NPLs with default start dates on time horizon over at least one economic cycle should be considered. Modeling of inflows from NPLs connects liquidity with a bank's credit risk management. Connection exists in the area of models for loss given default (hereafter LGD) estimation. Therefore, the minimal spread between maximum and minimum default start dates of historic NPLs is defined with CRR requirements for one's own LGD estimates. CRR requires that banks estimate LGDs by facility grade or pool on the basis of the average realized LGDs by facility grade or pool using all observed defaults within the data sources (default weighted average). For exposures to corporates, institutions, and central governments and central banks, own LGD estimates shall be based on data over a minimum of five years (The European Parliament, 2013). Consequently, we conclude that the difference between maximum and minimum default start date of historic NPLs should be at least five years. However, five years might not be enough to calculate time invariable probability distribution of inflows from NPLs—particularly not in times with high volatility of GDP in the economy. In the case of one's own LGD estimations, CRR requires that banks use LGD estimates, which are appropriate for an economic downturn if those are more conservative than the long-run average. Consequently, the same also holds for differences between default end date and default start date at historic NPLs. High volatility of GDP since 2007 helps to conclude that historic NPLs with default start dates over last five years do not cover a sufficiently long-time horizon for estimation of time invariable probability distribution of expected inflows from NPLs. Minimum historic observation period should therefore be much longer than five years. Assume that the bank defined time intervals for calculation of liquidity position as follows: one day, two days, three days, four days, five days, six days, seven days, eight days, nine days, 10, days, 11 days, 12 days, 13 days, 14, days, 15 days, 30 days, two months, three months, six months, one year, two years, three years, four years, five years, seven years, 10 years, and more than 10 years. Because we assume that a time interval for liquidity positions with remaining maturities over 10 years exists, also NPLs with difference between default end dates and default start dates of more than 10 years should be considered. If the last condition is not met, then it is not possible to estimate the probability distribution of expected inflows from NPLs on the time horizon beyond maximum difference between default end date and default start date. Lower bound of the open interval is important because it defines maximum tenor of a liquidity position, which a bank would like to include in the management of liquidity risk. The higher the lower bound of the open interval, the higher is precision of the bank with management of the structural liquidity risk. Results and Discussion For each historic NPL in the database of the bank, we are now going to calculate the difference between the default end date and default start date. Consequently, obtained results are values of the variable X, i.e., the difference between default end date and default start date, which we can describe with the following descriptive statistics. Maximum difference between default end date and default start date is 2948 days, which is ^^ = 8,1 years. This 42 Srecko Devjak: Modeling of Cash Flows from Nonperforming Loans in a Commercial Bank Table 1. Descriptive Statistics for Difference Between Default End Date and Default Start Date Figure 1. Frequency Distribution of Differences Between Default End Date and Default Start Date Statistics difference between default end date and default start date N Valid 375 Missing 0 Mean 829,55 Median 727,00 Mode 422 Std. Deviation 607,333 Variance 368853,938 Skewness ,626 Std. Error of Skewness ,126 Minimum 1 Malximum 2948 Source: Author's calculation. measure of dispersion explains that we will not be able to estimate probability distribution of inflows from NPLs over a time horizon with a minimum tenor of over 10 years. It also explains that calculated probability distribution of expected inflows from NPLs will correspond to economic downturn and will therefore not be time invariable, however conservative and therefore appropriate for estimation of expected inflows from NPLs. Mean explains average difference between default end date and default start date. On average, the bank in the last 8,1 829 55 years needed ^ = 2,3 years to reach default end date 365 after identification of a NPL. 100 80 & 60 Histogram œ D CX œ 40 20 0 500 1000 1500 2000 2500 3000 Difference between default end date and defaulst start date Source: Author's calculation. Assume that expected total recovery rate for an NPL is g = 1. With a mathematical model for calculation of expected recovery rates r. by time intervals, we can now estimate probability distribution of expected inflows from nonretail NPLs on time intervals, which were defined by the bank for calculation of liquidity positions. Results are shown in Figure 2. Figure 2. Probability Distribution of Expected Inflows from Nonretail NPLs by Time Intervals of the Bank We can show frequency distribution of differences between default end date and default start date also with a histogram. From Figure 1, we can see that the distribution of differences between default end date and default start date is asymmetric to the right. The skewness statistics, as defined by Campbell, Lo, and MacKinlay (1997) for a population with mean p and standard deviation S , is S = ( \ 3 •¿^-^ =0*626. Result shows explicit deviation from symmetric distributions, for which holds S = 0. This is in line with expectations, as, on the one hand, some NPLs are simple in complexity and can be therefore repaid quickly; on the other hand, some NPLs are complex and require more time until final repayment. 0,300 0,200 (U "D > -Q £ 0,100 0,000 II 1d 3d 1 5d 1 7d 1 9d 11d 13d'15d 2m '6m 1 2y 1 4y 1 7y 10y 2d 4d 6d 8d 10d 12d 14d 30d 3m 1y 3y 5y 10y Time intervals Source: Author's calculation. 0 5 NASE GOSPODARSTVO / OUR ECONOMY Vol. 64 No. 4 / December 2018 If write-offs differ from zero and total recovery rate for a NPL is g < 1, then expected recovery rate r per time interval B i e {1, 2, ..., n} reduces to Z7/ = g < 1 and by definition i=i also W W B 1a YuPik n w i'Z5/ 5> " k=' I* However, the probability distribution of expected inflows from nonretail NPLs by time intervals of the bank remains unchanged. Conclusion Modeling of inflows from NPLs connects liquidity with a bank's credit risk management. Data requirements for modeling of inflows from NPLs are therefore implicitly defined with CRR requirements for one's own LGD estimates. Based on sample data about historic nonretail NPLs of a bank, we found that probability distribution of expected inflows from nonretail NPLs considerably deviates from symmetric distribution and is asymmetric to the right. The result is in line with expectations, as, on the one hand, some nonretail NPLs are simple in complexity and can be repaid quickly; on the other hand, some nonretail NPLs are complex and require more time until final repayment and default end date. The first limitation of the model presented in this paper is linked to available data in banks about NPLs. Banks were not collecting data about NPLs and, therefore, are available time series of data short. Only recent regulations in the area of credit risk management, which offers to banks a possibility for construction of their own models for credit risk measurement, introduce new requirements for data collection. A longer data series, especially data series over a few economic cycles, will enable derivation of a more stable and time invariable probability distribution of expected inflows from NPLs. The second limitation of this model is its generality. There is only one model for all corporate sectors, but recovery rates and repayment possibilities by corporate sectors may be different. Consequently, this is one recommendation for future research and development. The third limitation of this model is equal recovery rate by time intervals. Various studies have shown that recovery rates reduce as time passes after default start date. Guo, Jarrow, and Zeng (2009) explain that the earlier a bank identifies an NPL, the higher is the expected recovery rate. Consequently, the key impact on model quality has identification of an NPL and hence definition of a default start date, which reflects the quality of credit risk management function in a bank. Finally, a similar model could be developed for a retail NPL, which is another recommendation for future research and development. References BIS (2008). Principles for sound liquidity risk management and supervision. Basel: Bank for international settlements. Retrieved on 10th December 2013 from: http://www.bis.org/publ/bcbs144.pdf Black F., Cox J. C. (1976). Valuing corporate securities: Some effects of bond indenture provisions. Journal of Finance, 31(2), 351-367. https://doi.org/10.1111/j.1540-6261.1976.tb01891.x Bruche M., Gonzales-Aguado C. (2010). Recovery rates, default probabilities, and the credit cycle. Journal of banking and finance, 34(4), 754-764. https://doi.org/10.1016/jjbankfin.2009.04.009 Campbell John Y., Lo Andrew W., MacKinlay Craig A. (1997). The econometrics of financial markets. Princeton: Princeton University Press. Carey, M. (1998). Credit Risk in Private Debt Portfolios. Journal of Finance, 53(4), 1363-1387. https://doi.org/10.1111/0022-1082.00056 Carey M., Gordy M. B. (2007). The bank as grim reaper: debt composition and recoveries on defaulted debt. In Proceedings 1056. Chicago: Federal Reserve Bank of Chicago. Deshpande A., Iyer S. K. (2009). The credit risk+ model with general sector correlations. Central European Journal of Operations Research, 17(2), 219-228. https://doi.org/10.1007/s10100-009-0084-4 Ernst&Young (2011). European non-performing loan report 2011. Restructuring follows strategy - a review of the European loan portfolio market. Eschborn: Ernst&Young. Guo X., Jarrow R., Zeng Y. (2009). Modeling the recovery rate in a reduced form model. Mathematical Finance, 19(1), 73-97. https://doi. org/10.1111/j.1467-9965.2008.00358.x Khieu H. D., Mullineaux D. J., Yi H. C. (2012). The determinants of bank loan recovery rates. Journal of Banking and Finance, 36(4), 923-933. https://doi.org/10.1016/jjbankfin.2011.10.005 Levy H., Sarnat M. (1977). A pedagogic note on alternative formulations of the goal of the firm. Journal of business, 50(4), 526-528. https://doi.org/10.1086/295971 Moody's (2013). Annual Default Study: Corporate Default and Recovery Rates, 1920-2012. Retrieved on 5th January 2014 from: http://www. moodys.com/research/Annual-Default-Study-Corporate-Default-and-Recovery-Rates-1920-2012--PBC_151031. 44 Srecko Devjak: Modeling of Cash Flows from Nonperforming Loans in a Commercial Bank The European Parliament (2013). Regulation (EU) No 575/2013 of the European Parliament and of the Council of 26 June 2013 on prudential requirements for credit institutions and investment firms and amending Regulation (EU) No 648/2012 (1). Brussels: Official Journal of the European Union, L 176, 1-337. Sohaimi, A. N. A. (2013). Liquidity risk and performance of banking system in Malaysia. Working paper. Mara University of Technology, Malaysia. https://doi.org/10.2139/ssrn.2271427 Trück S., Harpaintner S., Rachev S. T. (2005). A note on forecasting aggregate recovery rates with macroeconomic variables. Retrieved on 5th January 2014 from: http://www.pstat.ucsb.edu/research/papers/recovery.pdf Author Dr. Srečko Devjak holds a PhD in operations research from the University of Ljubljana, Faculty of Economics. He is a banker and works in London as a risk manager and quant engineer in the area of market, liquidity, interest rate risk, and model risk management. His research focuses on models for measurement of noncredit risks in banks and econometric models for forecasting of macroeconomic variables, which enter as inputs into a bank's capital planning process. He is also an assistant professor for risk management in finance. Modeliranje denarnih tokov iz slabih posojil v komercialni banki Izvleček Namen tega članka je izpeljati model za izračun zapadlosti in obsega odplačil, ki jih lahko banka pričakuje iz nepotrošniških slabih posojil (NPL). Pričakovani prilivi iz nepotrošniških NPL-jev sledijo verjetnostni porazdelitvi, opredeljeni z velikostjo in izbiro pravih trenutkov zgodovinskih odplačil NPL-jev. Empirična analiza je pokazala, da verjetnostna porazdelitev pričakovanih vplačil nepotrošniških NPL-jev znatno odstopa od simetrične porazdelitve in je asimetrična v desno. Natančnost izpeljanega modela je odvisna od razpoložljivih bančnih podatkov o NPL-jih korporativnih sektorjev in stopnjah vračil po časovnih intervalih. V tem članku izoblikovan model je v interesu katerekoli banke, še posebej bank z višjimi deleži NPL-jev v njihovem posojilnem portfelju. Dodana vrednost tega članka se kaže na področju upravljanja tveganja likvidnosti v bankah, saj v preostali literaturi ni drugega modela za isti namen. Ključne besede: banka, tveganje likvidnosti, modeliranje denarnega toka, kreditno tveganje, slaba posojila 5