Historical Loss Rate Computation

The first processing step in the Historical Loss Rate Computation process is to group all the accounts based on the Default Grade Rating or the Default DPD Band for the given date. After the accounts are grouped, the total outstanding, total recovery, and total write-off amounts are summed up across these accounts. This step is done only for the given MIS Date.

Note:

Only the accounts in the default grade are considered.

The second step in the process is to compute the Loss Rate for the given MIS Date using the following formula:

Loss Rate (t) = [Write-offs (t) - Recoveries (t) ] or Outstanding (t-1)

These loss rates are then used for the Average 12 month and Lifetime Gross Loss Rate computation within the Roll Rate methodology.

Note:

During the initial Run, historical data will not be available for computation. You need to ensure that historical data is populated manually before executing the Historical Loss Rate Run. OFS Loan Loss Forecasting and Provisioning application stores all the required data from the initial Run onwards. The duration of required historical data is dependent on the value provided in the Loss Rate Historical Data Cap and Loss Rate Historical Data Cap Unit columns of the Application Preferences table. If you update the Loss Rate frequencies that were previously set in the application, you will have to re-execute all the pre-executed Runs for the duration mentioned in the Application Preference table.

Historical data needs to be populated to the columns of the FSI_LLFP_HIST_LOSS_RATE table.