The TruEnd-procedure: Treating trailing zero-valued balances in credit data

Arno Botha,Tanja Verster,Roelinde Bester

2024-04-26

Abstract:A novel procedure is presented for finding the true but latent endpoints within the repayment histories of individual loans. The monthly observations beyond these true endpoints are false, largely due to operational failures that delay account closure, thereby corrupting some loans in the dataset with `false' observations. Detecting these false observations is difficult at scale since each affected loan history might have a different sequence of zero (or very small) month-end balances that persist towards the end. Identifying these trails of diminutive balances would require an exact definition of a "small balance", which can be found using our so-called TruEnd-procedure. We demonstrate this procedure and isolate the ideal small-balance definition using residential mortgages from a large South African bank. Evidently, corrupted loans are remarkably prevalent and have excess histories that are surprisingly long, which ruin the timing of certain risk events and compromise any subsequent time-to-event model such as survival analysis. Excess histories can be discarded using the ideal small-balance definition, which demonstrably improves the accuracy of both the predicted timing and severity of risk events, without materially impacting the monetary value of the portfolio. The resulting estimates of credit losses are lower and less biased, which augurs well for raising accurate credit impairments under the IFRS 9 accounting standard. Our work therefore addresses a pernicious data error, which highlights the pivotal role of data preparation in producing credible forecasts of credit risk.

Risk Management,Statistical Finance,Applications

What problem does this paper attempt to address?

The paper addresses the issue of tail-zero balance (TZB) in credit data, which refers to a series of zero or near-zero monthly ending balances in loan repayment history. These erroneous additional records arise from system migration and operational errors that result in accounts not being closed in a timely manner, affecting the timing estimation of default events and the accuracy of loss allowances. The paper proposes a novel method called TruEnd to identify and remove these erroneous historical records by defining "small balances", thereby improving the accuracy and credibility of risk event prediction and reducing the bias in credit loss estimation under the IFRS 9 accounting standard.

The TruEnd-procedure: Treating trailing zero-valued balances in credit data

A procedure for loss-optimising default definitions across simulated credit risk scenarios

Simulation-based optimisation of the timing of loan recovery across different portfolios

The loss optimisation of loan recovery decision times using forecast cash flows

A Proposed Simulation Technique for Population Stability Testing in Credit Risk Scorecards

The not-so-hidden risks of 'hidden-to-maturity' accounting: on depositor runs and bank resilience

Spurious Default Probability Projections in Credit Risk Stress Testing Models

Defining and comparing SICR-events for classifying impaired loans under IFRS 9

The zero-inflated cure rate regression model: Applications to fraud detection in bank loan portfolios

Optimal Credit Scorecard Model Selection Using Costs Arising from Both False Positives and False Negatives

Probability of default for lifetime credit loss for IFRS 9 using machine learning competing risks survival analysis models

Time matters: How default resolution times impact final loss rates

Time to default in credit scoring using survival analysis: a benchmark study

A critical review of existing and new population stability testing procedures in credit risk scoring

Zero-Inflated Autoregressive Conditional Duration Model for Discrete Trade Durations with Excessive Zeros

Endogenous Derivation and Forecast of Lifetime PDs

A Deep Learning Approach for Dynamic Balance Sheet Stress Testing

Generalizing Trimming Bounds for Endogenously Missing Outcome Data Using Random Forests

Zero Inflation as a Missing Data Problem: a Proxy-based Approach

Estimating a distribution function for discrete data subject to random truncation with an application to structured finance

Consumers' Financial Distress: Prediction and Prescription Using Interpretable Machine Learning