The rule in plain words
Notional amount cannot be less than these eight added up:
- Overnight
- Greater than overnight up to 1 month
- Greater than 1 month up to 3 months
- Greater than 3 months up to 6 months
- Greater than 6 months up to 9 months
- Greater than 9 months up to 12 months
- Greater than 12 months up to 1.5 years
- Greater than 1.5 years up to 2 years
All the values are in the core component row (0290) of J 05.00.b.
EBA writes it out 49 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Repricing cash flows (II) (J 05.00.b)
Row
- 0290Of which: core component
Columns
- 0260Notional amount
- 0320Overnight
- 0330Greater than overnight up to 1 month
- 0340Greater than 1 month up to 3 months
- 0350Greater than 3 months up to 6 months
- 0360Greater than 6 months up to 9 months
- 0370Greater than 9 months up to 12 months
- 0380Greater than 12 months up to 1.5 years
- 0390Greater than 1.5 years up to 2 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}.
{J_05.00.b,r0290,c0260,} >= {J_05.00.b,r0290,c0320,} + {J_05.00.b,r0290,c0330,} + {J_05.00.b,r0290,c0340,} + {J_05.00.b,r0290,c0350,} + {J_05.00.b,r0290,c0360,} + {J_05.00.b,r0290,c0370,} + {J_05.00.b,r0290,c0380,} + {J_05.00.b,r0290,c0390,}And 48 more, the same formula for the other cells it covers.
Other rules on J 05.00.b
- Loans and advances must equal retail plus wholesale non-financial plus wholesale financial (v22358_m)Warning
- NMDs: wholesale financial cannot be less than operational deposits (v22229_m)Warning
- NMDs: wholesale non-financial cannot be less than NMDs: wholesale non-financial exempted from the 5Y cap (v22228_m)Warning
- NMDs: wholesale non-financial cannot be less than core component (v22227_m)Warning
- NMDs: retail non-transactional cannot be less than NMDs: retail non-transactional exempted from the 5Y cap (v22226_m)Warning
- NMDs: retail non-transactional cannot be less than core component (v22225_m)Warning
- NMD: retail transactional cannot be less than NMD: retail transactional exempted from the 5Y cap (v22224_m)Warning
- NMD: retail transactional cannot be less than core component (v22223_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
