Description:
These excel files are the exact excel files needed for uploading data for the examples used in the Guidance on Example Excels. Global Credit Data LGD – EAD Platform Template Data Submission File Excel H1 2023.xls can be used as template.
The data model itself consists of 8 tables. For each reported defaulted loan, the tables can be repeated, when relevant, to reflect the evolution through time, allowing 5 different “snapshots” at “Origination”, “one year prior to Default”, “date of the Default”, “post Default” and, finally, at “Resolution”. The table Nr 8, “the Loan Transaction table”- is like a statement of account reflecting the entries in and out (recovery cash flow, write-off, etc) in-between the transfer of the loan in default and its resolution.
Per H2 2020 the Volumetrics of Unresolved Defaults are collected during the submission cycle using the submission template. The sheet Unresolved_Defaults_Volumetrics is included in the example files.
The same examples are also provided in CSV format, download the csv zipped files accordingly.
