The template it checks
Repricing cash flows (simplified for SNCIS) (II) (J 07.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_07.00.b,r0230,c0010,} >= {J_07.00.b,r0230,c0070,} + {J_07.00.b,r0230,c0080,} + {J_07.00.b,r0230,c0090,} + {J_07.00.b,r0230,c0100,} + {J_07.00.b,r0230,c0110,} + {J_07.00.b,r0230,c0120,} + {J_07.00.b,r0230,c0130,} + {J_07.00.b,r0230,c0140,} + {J_07.00.b,r0230,c0150,} + {J_07.00.b,r0230,c0160,} + {J_07.00.b,r0230,c0170,} + {J_07.00.b,r0230,c0180,} + {J_07.00.b,r0230,c0190,} + {J_07.00.b,r0230,c020And 38 more, the same formula for the other cells it covers.
Other rules on J 07.00.b
- NMDs: wholesale financial cannot be less than operational deposits (v22244_m)Warning
- NMDs: wholesale non-financial cannot be less than NMDs: wholesale non-financial exempted from the 5Y cap (v22243_m)Warning
- NMDs: wholesale non-financial cannot be less than core component (v22242_m)Warning
- NMDs: retail non-transactional cannot be less than NMDs: retail non-transactional exempted from the 5Y cap (v22241_m)Warning
- NMDs: retail non-transactional cannot be less than core component (v22240_m)Warning
- NMD: retail transactional cannot be less than NMD: retail transactional exempted from the 5Y cap (v22239_m)Warning
- NMD: retail transactional cannot be less than core component (v22238_m)Warning
- Term deposits must equal retail plus wholesale non-financial plus wholesale financial (v22196_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.