What do we mean by credit data? This post is a discussion around mathematical terminology and concepts that are useful in the context of working with credit data, taking us from network graph representations of credit systems to commonly used reference data sets
Definition of Credit Data What do we mean by credit data? For our purposes Credit Data is any well-defined dataset that has direct applications in the assessment of the Credit Risk of an individual or an organization, or, more generally, a dataset that allows the application of data driven Credit Portfolio Management policies. The appearance of credit data is quite familiar to practitioners: A spreadsheet, or a table in a database, with a number of columns and rows full of all sorts of information about borrowers and loans.
Summary The Open Risk Academy course NPL270672 is a CrashCourse introducing the EBA NPL Templates.
Content: We start with the motivation for the templates and the domain of credit data (to which NPL data belongs). We discuss three core classes that capture the essence of lending operations from a lenders point of view (Counterparty, Loan, Collateral). Next we explore classes that capture events in the lending relationship lifecycle (which we term NPL Scenarios).
Celebrating Pi Day 2021 Pi Day is celebrated every year on March 14th. The reason of course is that the day is denoted in some calendars as (3/14), which evokes of 3.14, the first three digits of “π”. A thin excuse maybe but sufficient for the true believers to join along! The occasion represents an annual opportunity for mathematics and science enthusiasts to recite the infinite charms of Pi, including its irrationality, to talk to friends and family about math and its uses, and, when everything else fails, simply eat pie.
The Non-Perfoming Loan Ontology The Non-Performing Loan Ontology is a framework that aims to represent and categorize knowledge about non-performing loans using semantic web information technologies. Codenamed NPLO, it codifies the relationship between the various components of a Non-Performing Loan portfolio dataset.(NB: Non-performing loans are bank loans that are 90 days or more past their repayment date or that are unlikely to be repaid, for example if the borrower is facing financial difficulties).
openNPL 0.2 release The open source openNPL platform supports the management of standardized credit portfolio data for non-performing loans. In this respect it implements the detailed European Banking Authority NPL loan templates. It aims to be at the same time easy to integrate in human workflows (using a familiar web interface) and integrate into automated (computer driven) workflows.
The latest (0.2) release exposes a REST API that offers machine oriented access using, what is by now, the most established mechanism for achieving flexible online data transfers.
openNPL now Available in Dockerized Form Following up on the first release of openNPL the platform is now available to install using Docker. Running openNPL via docker is the installation option that simplifies the manual process (but a working docker installation is required!).
Docker Hub You can pull the latest openNPL image from Docker Hub (This method is recommended if you do not want to mess with the source distribution).
Non-Performing Loans: The covid-19 crisis will certainly impact the concentration of Non-Performing Loans but given the special nature of this economic crisis compared (in particular) with the 2008 financial crisis it is unclear how precisely things will evolve.
In a previous post and white paper (OpenRiskWP07_022616) we discussed the importance of advancing open and transparent methodologies for managing the risks associated with such credit portfolios. Effective management of NPL is also a top regulatory priority.
Extending the Open Risk API to include the EBA Portfolio Data Templates: The Open Risk API provides a mechanism to integrate arbitrary collections of risk data and risk modelling resources in the context of assessing and managing financial risk. It is based on two key technologies of the modern Web, RESTful architectures and Semantic Data.
OpenNPL, the credit portfolio management platfrom we launched recently fully integrates the latest versions of the Open Risk API.
Motivation for Building an open source database based on EBA’s Standardized NPL Templates In a recent insightful piece “Overcoming non-performing loan market failures with transaction platforms”, Fell et al. dug deeply into the market failures that help perpetuate the NPL problem. They highlight, in particular, information asymmetries and the attendant costs of valuing NPL portfolios as key obstacles. In the same wavelength, the European Banking Authority published standardized NPL data templates as a step towards reducing the obstacles that prevent the reduction of NPL’s.
Risk Capital for Non-Performing Loans: Currently many countries are drowning in bad credits This visualization from the World Bank shows the current distribution of non-performing loans (NPL’s in short) around the world, as fraction of the total outstanding loans:
Translated in absolute numbers (according to IMF data) the European NPL book alone stands at around 1 trillion EUR.
As the adage goes, a trillion here, a trillion there, you pretty soon talk about serious money
Open Risk White Paper 7: Risk Capital for Non-Performing Loans
We develop a conceptual framework for risk capital calculation for portfolios of non-performing loans. In general banking practice, loans that pass a threshold of delinquency are declared non-performing and are provisioned. Yet there is a residual risk that the provisioning is not sufficient. This risk must be covered by capital buffers. The literature for risk capital requirements for NPL portfolios is very limited, which implies that Stress Testing and Internal Capital Adequacy Assessment (ICAAP) requirements for non-performing loans are harder to meet.