The template it checks
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{D_02.00.a,r0090,c0010,} = {D_02.00.a,r0090,c0020,} + {D_02.00.a,r0090,c0030,} + {D_02.00.a,r0090,c0040,} + {D_02.00.a,r0090,c0050,} + {D_02.00.a,r0090,c0060,} + {D_02.00.a,r0090,c0070,} + ({D_02.00.a,r0090,c0150,} * (1 - {D_02.00.b,r0090,c0160,}))Other rules on D 02.00.a
- Total non-EU area: loans collateralised by residential immovable property, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16078_m)Warning
- Total non-EU area, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16082_m)Warning
- Total EU area: loans collateralised by commercial immovable property, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16084_m)Warning
- Total EU area: loans collateralised by residential immovable property, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16086_m)Warning
- Collateral obtained by taking possession: residential and commercial immovable properties, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16088_m)Warning
- Level of energy efficiency (EP score in kWh/m² of collateral) estimated, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16090_m)Warning
- Total non-EU area: loans collateralised by commercial immovable property, total gross carrying amount (in M EUR) must equal a sum of seven terms (v16092_m)Warning
- None of the 56 values it checks in banking book: Indicators of potential climate change transition risk can be negative (v16057_s)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.