The rule in plain words
Each of the cells it checks in liquidity ratios must be reported.
EBA checks it for two columns: planned Year 2 Position and planned Year 3 Position. And for four rows: net stable funding ratio (per cent), available stable funding, required stable funding and NSFR surplus/(deficit). That makes eight checks. A failure names the one that failed.
How the Line4 Check report words itShowHide
The first of its checks, word for word as the report shows it when it fails. The others read the same, with their own column, row or sheet.
Planned Year 2 Position: Net Stable Funding Ratio (per cent) is reported
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Report a value in this cell. A 0 counts as reported; a cell left out of the file does not.
- 03It runs only when your filing indicators mark P 01.03 as reported.
- 04This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Liquidity ratios (P 01.03)
Rows
- 010Net Stable Funding Ratio (per cent)
- 012Available stable funding
- 014Required stable funding
- 020NSFR surplus/(deficit)
Columns
- 040Planned Year 2 Position
- 050Planned Year 3 Position
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}.
not(empty({P_01.03,r010,c040,}))The next five:
not(empty({P_01.03,r012,c050,}))not(empty({P_01.03,r014,c050,}))not(empty({P_01.03,r020,c050,}))not(empty({P_01.03,r014,c040,}))not(empty({P_01.03,r012,c040,}))And 2 more, the same formula for the other cells it covers.
Other rules on P 01.03
- Liquidity coverage ratio (per cent) must be more than 1 (v6213_m)Warning
- Each of the 20 cells it checks in liquidity ratios must be reported (v6215_m)Warning
- Net stable funding ratio (per cent) must be less than 6 (v6212_m)Warning
- If actual current position is not zero, planned Year 1 Position cannot be zero, and planned Year 2 Position cannot be zero, and planned Year 3 Position cannot be zero (v6231_m)Warning
- None of the 16 values it checks in liquidity ratios can be negative (v4395_s)Warning
- None of the six values it checks in liquidity ratios can be negative (v4394_s)Warning
- Liquidity coverage ratio (per cent) must be less than 6 (v09244_m)Warning
- If actual current position is not zero, planned Year 1 Position cannot be zero (v09245_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.