The rule in plain words
Retail cannot be less than retail secured by immovable property.
EBA checks it for twelve columns, from original exposure pre conversion factors (0010) to expected loss amount (0130). That makes twelve checks. A failure names the one that failed.
How the Line4 Check report words itShowHide
The first of its checks, word for word as the report shows it when it fails. The others read the same, with their own column, row or sheet.
General credit risk adjustments: Retail >= Of which: Secured by immovable property
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Compare the values in your file. If the first is smaller than it may be, one of them is wrong: check both before you change either.
- 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark C 09.02 as reported.
- 05This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Geographical breakdown of exposures by residence of the obligor (IRB exposures) (C 09.02)
Rows
- 0060Retail
- 0070Of which: Secured by immovable property
Columns
- 0010ORIGINAL EXPOSURE PRE CONVERSION FACTORS
- 0030Of which: defaulted
- 0040Observed new defaults for the period
- 0050General credit risk adjustments
- 0055Specific credit risk adjustments
- 0060Write-offs
- 0070Credit risk adjustments/write-offs for observed new defaults
- 0105EXPOSURE VALUE
- 0110RISK WEIGHTED EXPOSURE AMOUNT PRE SUPPORTING FACTOR
- 0120Of which: defaulted
- 0125RISK WEIGHTED EXPOSURE AMOUNT AFTER SUPPORTING FACTOR
- 0130EXPECTED LOSS AMOUNT
A worked example
The first of its checks, with simple numbers.
Retail secured by immovable property can then be at most 1,200.
A file that reports 1,200 passes. One that reports 1,300 fails, by 100.
The numbers are illustrative, reported to the unit, so the rounding tolerance does not change the result.
Show the rule as writtenShowHide
EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.
{C_09.02,r0060,c0050,} >= {C_09.02,r0070,c0050,}The next five:
{C_09.02,r0060,c0105,} >= {C_09.02,r0070,c0105,}{C_09.02,r0060,c0040,} >= {C_09.02,r0070,c0040,}{C_09.02,r0060,c0060,} >= {C_09.02,r0070,c0060,}{C_09.02,r0060,c0110,} >= {C_09.02,r0070,c0110,}{C_09.02,r0060,c0130,} >= {C_09.02,r0070,c0130,}And 6 more, the same formula for the other cells it covers.
Other rules on C 09.02
- Other retail cannot be less than SME plus non-SME other retail (v4779_m)Warning
- Retail secured by immovable property must equal the sum of its two parts (row 0070, v4782_m)Warning
- Risk weighted exposure amount pre supporting factor cannot be less than defaulted (v4783_m)Warning
- Original exposure pre conversion factors cannot be less than defaulted (v4784_m)Warning
- Risk weighted exposure amount after supporting factor must equal the sum of its three parts (v4785_m)Warning
- If credit risk adjustments or write-offs for observed new defaults is not zero, observed new defaults for the period cannot be zero (v4787_m)Warning
- Retail secured by immovable property must equal the sum of its two parts (row 0070, v5820_h)Warning
- Total exposures must equal the sum of its eight parts (v6052_m)Warning
Every COREP own funds rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
