The rule in plain words
These eight worked out cannot be negative:
- Loans collateralised by commercial immovable property, > 200; <= 300 (under total EU area)
- Loans collateralised by commercial immovable property, > 300; <= 400 (under total EU area)
- Loans collateralised by residential immovable property, > 200; <= 300 (under total EU area)
- Loans collateralised by residential immovable property, > 300; <= 400 (under total EU area)
- Loans collateralised by commercial immovable property, > 200; <= 300 (under total non-EU area)
- Loans collateralised by commercial immovable property, > 300; <= 400 (under total non-EU area)
- Loans collateralised by residential immovable property, > 200; <= 300 (under total non-EU area)
- Loans collateralised by residential immovable property, > 300; <= 400 (under total non-EU area)
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
Total EU area, of which Loans collateralised by commercial immovable property, > 200; <= 300 + Total EU area, of which Loans collateralised by commercial immovable property, > 300; <= 400 + Total EU area, of which Loans collateralised by residential immovable property, > 200; <= 300 + Total EU area, of which Loans collateralised by residential immovable property, > 300; <= 400 + Total non-EU area, of which Loans collateralised by commercial immovable property, > 200; <= 300 + Total non-EU area, of which Loans collateralised by commercial immovable property, > 300; <= 400 + Total non-EU area, of which Loans collateralised by residential immovable property, > 200; <= 300 + Total non-EU area, of which Loans collateralised by residential immovable property, > 300; <= 400 >= 0
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Work out both sides from your file, as the rule in plain words sets out, and compare them.
- 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark D 02.00 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
Rows
- 0020Of which Loans collateralised by commercial immovable property
- 0030Of which Loans collateralised by residential immovable property
- 0070Of which Loans collateralised by commercial immovable property
- 0080Of which Loans collateralised by residential immovable property
Columns
- 0040> 200; <= 300
- 0050> 300; <= 400
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{D_02.00.a,r0020,c0040,} + {D_02.00.a,r0020,c0050,} + {D_02.00.a,r0030,c0040,} + {D_02.00.a,r0030,c0050,} + ({D_02.00.a,r0070,c0040,} + {D_02.00.a,r0070,c0050,} + {D_02.00.a,r0080,c0040,} + {D_02.00.a,r0080,c0050,}) >= 0Other rules on D 02.00.a
- An upper-limit check on banking book: Indicators of potential climate change transition risk (row 0020, v89276_m)Warning
- An upper-limit check on banking book: Indicators of potential climate change transition risk (row 0020, v89278_m)Warning
- The sum of eight cells cannot be negative (v89275_m)Warning
- A sum of eight cells cannot be negative (row 0020, v89279_m)Warning
- An upper-limit check on banking book: Indicators of potential climate change transition risk (row 0020, v89274_m)Warning
- An upper-limit check on banking book: Indicators of potential climate change transition risk (row 0050, v89280_m)Warning
- The sum of six cells cannot be negative (v89273_m)Warning
- A sum of twelve cells cannot be negative (v89281_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.