The rule in plain words
Gross carrying amount (Mln EUR) cannot be less than these four added up:
- <= 5 years
- > 5 year <= 10 years
- > 10 year <= 20 years
- > 20 years
All the values are in the water supply; sewerage, waste management and remediation activities row (0050) of D 05.00.a.
EBA writes it out twelve times. These words are for the first; the others are the same rule on other cells.
The template it checks
Banking book - Indicators of potential climate change physical risk: exposures subject to physical risk (I) (D 05.00.a)
Row
- 0050E - Water supply; sewerage, waste management and remediation activities
Columns
- 0010Gross carrying amount (Mln EUR)
- 0020<= 5 years
- 0030> 5 year <= 10 years
- 0040> 10 year <= 20 years
- 0050> 20 years
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}.
{D_05.00.a,r0050,c0010,} >= {D_05.00.a,r0050,c0020,} + {D_05.00.a,r0050,c0030,} + {D_05.00.a,r0050,c0040,} + {D_05.00.a,r0050,c0050,}And 11 more, the same formula for the other cells it covers.
Other rules on D 05.00.a
- None of the 132 values it checks in banking book: Indicators of potential climate change physical risk can be negative (v12822_s)Warning
- Each of the 36 values it checks in banking book: Indicators of potential climate change physical risk cannot be more than zero (v12823_s)Warning
- Gross carrying amount (Mln EUR) cannot be less than the sum of four columns (row 0110, v89329_m)Warning
- The sum of 24 cells cannot be negative (row 0010, v89374_m)Warning
- The sum of 24 cells cannot be negative (row 0010, v89375_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
