The rule in plain words
Other retail must equal SME plus non-SME other retail.
All the values are in the write-offs column (0060) of C 09.02.
EBA writes it out 14 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Geographical breakdown of exposures by residence of the obligor (IRB exposures) (C 09.02)
Rows
- 0110Other Retail
- 0120Of which: SME
- 0130Of which Non-SME
Column
- 0060Write-offs
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,r0110,c0060,} = {C_09.02,r0120,c0060,} + {C_09.02,r0130,c0060,}And 13 more, the same formula for the other cells it covers.
Other rules on C 09.02
- 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
- 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
- Risk weighted exposure amount after supporting factor must equal the sum of its three parts (v4785_m)Warning
- Original exposure pre conversion factors cannot be less than defaulted (v4784_m)Warning
- Risk weighted exposure amount pre supporting factor cannot be less than defaulted (v4783_m)Warning
- Retail secured by immovable property must equal the sum of its two parts (row 0070, v4782_m)Warning
- Other retail cannot be less than SME plus non-SME other retail (v4779_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.