Risks
In TurnKey Lender you can find risks reports on the Reports workplace. General overview of the Risks reports page can be found below.
Filtering panel
The risk reports are available in charts and tables. To display the reports only in charts, the user should click the Chart button
The risk reports are available in charts and tables. To display the reports only in charts, the user should click the Table button
The risk reports are available in charts and tables. To display the reports only in charts, the user should click the Both button
By default, the user can review all risk reports on one web page. To review any specific risk report, the user should click the All Reports split button and select a report from the list
The following reports are available to the user:
Bad Rate Trend
Delinquency Performance
Delinquency Migration
Vintage Analysis
The data in all risks reports can be displayed according to a certain period.
To select a period of the reports, the user clicks the Monthly split button
A selected period applies automatically to all risks reports.
Besides, the user can select a specific time interval for the reports:
A time interval refers to a time frame according to which the data of the reports will be displayed.
The beginning and the end of the time interval depend on availability of loan applications in the system.
The beginning of the time interval is considered to be the date when the first loan application has been created in the system, while the end of this interval corresponds to a current date.
The current date is the date when the reports have been last updated.
To determine a time interval of the reports, on the horizontal scale, point to the semi-circle at the beginning of the interval, click it and drag to the right to a required date that gets displayed in the From box and indicates the beginning of the time interval.
On the horizontal scale, point to the semi-circle at the end of the interval, click it and drag to the left to a required date that gets displayed in the To box and indicates the end of the time interval (see Fig. 9):
A selected time interval applies automatically to all risks reports.
The Bad Rate Trend, Delinquency Performance, and Delinquency Migration reports contain loan statistics according to past due periods:
The user can export the data of the risks reports to the Excel spreadsheet by clicking the Export button
Bad Rate Trend report
Non-performing loans are the loans that had a Past Due status for the end of the selected time interval.
The Bad Rate Trend report displays the number of non-performing loans in each delinquency period according to a period selected.
The report displays the quantity of non-performing loans in delinquency periods and a total amount of non-performing loans according to a selected time interval
Delinquency Performance report
The Delinquency Performance report displays the loans statistics in risk groups.
The report displays the number of loan applications in each delinquency period in a corresponding risk group pursuant to a selected time interval.
The Good parameter stands for the number of performing loans in the corresponding risk group, while the Total parameter displays the total number of loans in that risk group.
Delinquency Migration report
The Delinquency Migration report displays the statistics of loans migration according to delinquency periods
The table of the report displays the migration of non-performing loans from previous delinquency periods into current delinquency periods according to a selected period. For example, if the Monthly period is selected, the table of the Delinquency Migration report is displayed as follows (see Fig. 15):
The left part of the table displays the delinquency periods as of the beginning of the period while the right part displays the delinquency periods as of the current date. The 0 period corresponds to the period without delinquencies.
In the table, the user can observe how many non-performing loans from delinquency periods as of the beginning of the period migrated into current delinquency periods.
The cells of the table get highlighted in case of significant changes in comparison with the previous period.
If the number of non-performing loans in a cell of the current table has decreased in comparison with the number of non-performing loans in the same cell of the previous table as of the previous period, the cell is highlighted in green.
In case the number of non-performing loans has increased, the corresponding cell is highlighted in red.
On the chart of the Delinquency Migration report (see Fig. 16), the x-axis displays the delinquency buckets at the beginning of the period, while the y-axis displays a number of non-performing loans.The delinquency buckets as of the current date are depicted in colors on the chart.
The chart shows how the non-performing loans of previous delinquency periods migrated into the delinquency periods as of the current date
Vintage Analysis report
The Vintage Analysis report (see Fig. 17) displays information on a quantity of non-performing loans depending on a month of origination (a vintage) and an age (months on the books) accordingly to a period and a time interval selected:
The report gets displayed according to a selected time interval which is divided by months. These months are considered to be origination periods in which loans have been taken out by the borrowers.
The origination periods are displayed in the Payment Period column of the report table
The incremental figures in the Intervals Since Disbursement columns of the table correspond to the age of the loan: a number of months since the loan has been taken out
The figures in the columns correspond to a bad rate: a percentage of non-performing loans in relation to the total number of loans disbursed during this interval.
The chart of the Vintage Analysis report (see Fig. 20) displays the dynamics of changes in the bad rate according to the months on the books:
The y-axis of the chart displays the bad rate in percentage. The x-axis displays the age of loans (months since origination). Different colors of curves correspond to origination periods. The curve of each origination period has a different length along the x-axis since the dynamics of changes in the bad rate is shown according to the age of the loans.