The template it checks
Repricing cash flows (II) (J 05.00.b)
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,r0460,c0010,} >= {J_05.00.b,r0460,c0070,} + {J_05.00.b,r0460,c0080,} + {J_05.00.b,r0460,c0090,} + {J_05.00.b,r0460,c0100,} + {J_05.00.b,r0460,c0110,} + {J_05.00.b,r0460,c0120,} + {J_05.00.b,r0460,c0130,} + {J_05.00.b,r0460,c0140,} + {J_05.00.b,r0460,c0150,} + {J_05.00.b,r0460,c0160,} + {J_05.00.b,r0460,c0170,} + {J_05.00.b,r0460,c0180,} + {J_05.00.b,r0460,c0190,} + {J_05.00.b,r0460,c020And 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.