In TurnKey Lender, you can view reports on the Reports workplace. General overview of the Scoring reports list can be found below.
Reports are building on all available in the database credit applications.
By hovering over the column name the pop-up hint is displayed showing the column name description.
For reports based on open loans, ‘open loan’ means a loan with the active period that overlaps the reporting period (at least partially).
Note. Such open loans may actually be closed on the day when the report is created.
By default, the user can review all scoring reports on one web page. To review any specific scoring 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:
System Stability
Scorecard Accuracy
Delinquency Performance
Final Score
The data in all risks reports can be displayed according to a certain period.
To select a period of the reports, the user should click the Monthly split button:
A selected period applies automatically to all portfolio reports.
The user can export the data of the scoring reports to the Excel spreadsheet by clicking the Export button:
System Stability report
The System Stability report contains information on score distribution for a loan portfolio and is based on the open loans.
The report allows the user to analyze portfolio stability and changes in the borrowers' credit quality:
The table of the report displays the following information (see Table 1):
Score | score ranges (risk segments). A beginning and an end of the range correspond to those specified in the scorecard settings for estimating a risk level |
Risk Level | the credit risk level that corresponds to the displayed score range |
Actual % | the actual bad rate in a corresponding score range Note: The bad rate denotes a percentage of delinquent loans with the overdue period exceeding a value specified by the Administrator in settings (exceeding the value specified in the first interval: for more information, refer to the Managing Delinquency Settings subsection of the System section) |
Expected % | the expected bad rate in a corresponding score range Note: The value of the expected bad rate is taken from the scorecard |
(A-E) | the actual bad rate less the expected bad rate |
(A/E) | the actual bad rate divided by the expected bad rate |
Ln(A/E) | natural logarithm of the A/E value |
Index | instability index calculated based on the actual and expected values |
A value highlighted in color under the System stability table displays the total of all index values.
This value allows the user to estimate relevant changes in the portfolio as follows:
Index < 0.1: no relevant changes are available; the value is highlighted in green;
0.1 <= Index < 0.25: loan portfolio has insignificant changes. However, a cause of these changes must be determined; the value is highlighted in yellow;
Index >= 0.25: loan portfolio has changed significantly; the value is highlighted in red.
Scorecard Accuracy report
The Scorecard Accuracy report (see Fig. 6) allows the user to analyze risk distributions.
The report is calculated for loans which have been active or past due at least one day during a selected period and which have been closed recently (is based on the open loans).
The table of the report displays the following information
Score | score ranges (risk segments). A beginning and an end of the range correspond to those specified in the scorecard settings for estimating a risk level |
Risk Level | the credit risk level that corresponds to a displayed score range |
Accounts | the total number of loans approved |
Bad | the total number of “bads”. Note: “Bads” are delinquent loans with the overdue period exceeding a value specified by the Administrator in settings (exceeding the value specified in the first interval) |
Bad Rate | the percentage of “bads” in relation to the total number of loans approved |
Exp. Bad Rate | the expected percentage of “bads”. |
Note: The value of the expected bad rate is taken from the scorecard.
These parameters allow estimating appropriate risk distribution.
Delinquency Performance report
The Delinquency Performance report (see Fig. 7) allows the user to estimate the change in the number of overdue loans in score ranges.
Additionally, the Delinquency Performance report allows analyzing the distribution of overdue loans in different delinquency buckets.
The report is calculated for loans which have been active or past due at least one day during a selected period and which have been closed recently (is based on the open loans).
The table of the report displays the following information
Score | score ranges (risk segments). A beginning and an end of the range correspond to those specified in the scorecard settings for estimating a risk level |
Accounts | a number of approved loans within a specified score range |
Current | a number of loans not past due |
1-25, 26-50, 51-75, 76+ | a number of days in arrears. Each delinquency bucket displays a number of overdue loans |
Written off | a number of written off loans |
For example, the Delinquency Performance report may show that the number of “bad” borrowers decreases with the increase in the number of days in arrears.
Final Score report
The Final Score report (see Fig. 8) allows the user to estimate the application of credit rating for new loans created in a selected reporting period.
The table of the report displays the following information:
Score | score ranges (risk segments). A beginning and an end of the range correspond to those specified in the scorecard settings for estimating a risk level |
Risk level | a credit risk level that corresponds to a displayed score range |
Applicants | a credit risk level that corresponds to a displayed score range |
Approved | a number of approved loan applications |
Approved % | a number of approved loan applications |
Low-side % | a number of loan applications which credit rating is below a cut-off point but the loan has been issued. Formula: Approved / Applicants * 100%. |
High-side % | a number of loan applications which credit rating is above a cut-off point but the loan has been rejected Formula: (Applicants- Approved) / Applicants * 100%. |
According to the report shown, the score ranges displayed in lines 1-4 are above the cut-off point (above 63),
while the score range “0-62” (line 5) is below the cut-off point. Total ratios for all loan applications rated above the cut-off point are displayed in line 6.