The rule in plain words
Secured by mortgages on immovable property and ADC exposures must equal these eleven added up:
- Secured by mortgages on residential immovable property - non-IPRE (secured)
- Secured by mortgages on residential immovable property - non-IPRE (unsecured)
- Secured by mortgages on residential immovable property - other - non-IPRE
- Secured by mortgages on residential immovable property - IPRE
- Secured by mortgages on residential immovable property - other - IPRE
- Secured by mortgages on commercial immovable property - non-IPRE (secured)
- Secured by mortgages on commercial immovable property - non-IPRE (unsecured)
- Secured by mortgages on commercial immovable property - other - non-IPRE
- Secured by mortgages on commercial immovable property - IPRE
- Secured by mortgages on commercial immovable property - other - IPRE
- Acquisition, development and construction (ADC)
All the values are in the original exposure pre conversion factors column (0010) of C 09.01.a.
EBA writes it out ten 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 (SA exposures) (C 09.01.a)
Rows
- 0090Secured by mortgages on immovable property and ADC exposures
- 0091Secured by mortgages on residential immovable property - non-IPRE (secured)
- 0092Secured by mortgages on residential immovable property - non-IPRE (unsecured)
- 0093Secured by mortgages on residential immovable property - Other - non-IPRE
- 0094Secured by mortgages on residential immovable property - IPRE
- 0900Secured by mortgages on residential immovable property - Other - IPRE
- 0901Secured by mortgages on commercial immovable property - non-IPRE (secured)
- 0902Secured by mortgages on commercial immovable property - non-IPRE (unsecured)
- 0903Secured by mortgages on commercial immovable property - Other - non-IPRE
- 0904Secured by mortgages on commercial immovable property - IPRE
- 0905Secured by mortgages on commercial immovable property - Other - IPRE
- 0906Acquisition, development and construction (ADC)
Column
- 0010ORIGINAL EXPOSURE PRE CONVERSION FACTORS
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.01.a,r0090,c0010,} = {C_09.01.a,r0091,c0010,} + {C_09.01.a,r0092,c0010,} + {C_09.01.a,r0093,c0010,} + {C_09.01.a,r0094,c0010,} + {C_09.01.a,r0900,c0010,} + {C_09.01.a,r0901,c0010,} + {C_09.01.a,r0902,c0010,} + {C_09.01.a,r0903,c0010,} + {C_09.01.a,r0904,c0010,} + {C_09.01.a,r0905,c0010,} + {C_09.01.a,r0906,c0010,}And 9 more, the same formula for the other cells it covers.
Other rules on C 09.01.a
- Specialised lending cannot be more than corporates (v23040_m)Warning
- The absolute value of corporates cannot be less than the absolute value of SME (v23543_h)Warning
- The absolute value of retail cannot be less than the absolute value of SME (row 0080, v23611_m)Warning
- The absolute value of secured by mortgages on immovable property and ADC exposures cannot be less than the absolute value of SME (row 0090, v23612_m)Warning
- Secured by mortgages on immovable property and ADC exposures must equal the sum of its eleven parts (row 0090, v23670_h)Warning
- The absolute value of retail cannot be less than the absolute value of SME (row 0080, v23731_h)Warning
- The absolute value of secured by mortgages on immovable property and ADC exposures cannot be less than the absolute value of SME (row 0090, v23732_h)Warning
- Each of the 70 values it checks in geographical breakdown of exposures cannot be more than zero (v10299_s)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.