The rule in plain words
Secured cash 30 day inflows, value / percentage must equal these 24 worked out:
- Inflows from secured lending and capital market-driven transactions, subject to the 75% cap on inflows
- Inflows from secured lending and capital market-driven transactions, subject to the 90% cap on inflows
- Inflows from secured lending and capital market-driven transactions, exempted from the cap on inflows
- Minus collateral is used to cover a short position, subject to the 75% cap on inflows (under counterparty is central bank)
- Minus collateral is used to cover a short position, subject to the 90% cap on inflows (under counterparty is central bank)
- Minus collateral is used to cover a short position, exempted from the cap on inflows (under counterparty is central bank)
- Minus collateral is used to cover a short position, subject to the 75% cap on inflows (under counterparty is non-central bank)
- Minus collateral is used to cover a short position, subject to the 90% cap on inflows (under counterparty is non-central bank)
- Minus collateral is used to cover a short position, exempted from the cap on inflows (under counterparty is non-central bank)
- Minus memorandum items secured by L1 excl. EHQCB, subject to the 75% cap on inflows
- Minus memorandum items secured by L1 excl. EHQCB, subject to the 90% cap on inflows
- Minus memorandum items secured by L1 excl. EHQCB, exempted from the cap on inflows
- Minus memorandum items secured by L1 EHQCB, subject to the 75% cap on inflows
- Minus memorandum items secured by L1 EHQCB, subject to the 90% cap on inflows
- Minus memorandum items secured by L1 EHQCB, exempted from the cap on inflows
- Minus memorandum items secured by L2A, subject to the 75% cap on inflows
- Minus memorandum items secured by L2A, subject to the 90% cap on inflows
- Minus memorandum items secured by L2A, exempted from the cap on inflows
- Minus memorandum items secured by L2B, subject to the 75% cap on inflows
- Minus memorandum items secured by L2B, subject to the 90% cap on inflows
- Minus memorandum items secured by L2B, exempted from the cap on inflows
- Minus memorandum items secured by non-liquid assets, subject to the 75% cap on inflows
- Minus memorandum items secured by non-liquid assets, subject to the 90% cap on inflows
- Minus memorandum items secured by non-liquid assets, exempted from the cap on inflows
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
C_76.00.W: Secured cash 30 day inflows = C_74.00.W: Inflows from secured lending and capital market-driven transactions, Subject to the 75% cap on inflows + C_74.00.W: Inflows from secured lending and capital market-driven transactions, Subject to the 90% cap on inflows + C_74.00.W: Inflows from secured lending and capital market-driven transactions, Exempted from the cap on inflows - (C_74.00.W: Counterparty is central bank, collateral is used to cover a short position, Subject to the 75% cap on inflows + C_74.00.W: Counterparty is central bank, collateral is used to cover a short position, Subject to the 90% cap on inflows + C_74.00.W: Counterparty is central bank, collateral is used to cover a short position, Exempted from the cap on inflows) - (C_74.00.W: Counterparty is non-central bank, collateral is used to cover a short position, Subject to the 75% cap on inflows + C_74.00.W: Counterparty is non-central bank, collateral is used to cover a short position, Subject to the 90% cap on inflows + C_74.00.W: Counterparty is non-central bank, collateral is used to cover a short position, Exempted from the cap on inflows) - (C_74.00.W: of which: secured by L1 excl. EHQCB, Subject to the 75% cap on inflows + C_74.00.W: of which: secured by L1 excl. EHQCB, Subject to the 90% cap on inflows + C_74.00.W: of which: secured by L1 excl. EHQCB, Exempted from the cap on inflows) - (C_74.00.W: of which: secured by L1 EHQCB, Subject to the 75% cap on inflows + C_74.00.W: of which: secured by L1 EHQCB, Subject to the 90% cap on inflows + C_74.00.W: of which: secured by L1 EHQCB, Exempted from the cap on inflows) - (C_74.00.W: of which: secured by L2A, Subject to the 75% cap on inflows + C_74.00.W: of which: secured by L2A, Subject to the 90% cap on inflows + C_74.00.W: of which: secured by L2A, Exempted from the cap on inflows) - (C_74.00.W: of which: secured by L2B, Subject to the 75% cap on inflows + C_74.00.W: of which: secured by L2B, Subject to the 90% cap on inflows + C_74.00.W: of which: secured by L2B, Exempted from the cap on inflows) - (C_74.00.W: of which: secured by non-liquid assets, Subject to the 75% cap on inflows + C_74.00.W: of which: secured by non-liquid assets, Subject to the 90% cap on inflows + C_74.00.W: of which: secured by non-liquid assets, Exempted from the cap on inflows)
What to do if your filing fails it
- 01Open the templates below and find the cells the rule reads.
- 02Work out both sides from your file, as the rule in plain words sets out, and compare them.
- 03EBA allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark C 74.00 and C 76.00 as reported.
- 05This 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 coverage, inflows, significant currencies (DA) (C 74.00.w)
Rows
- 0263Inflows from secured lending and capital market-driven transactions
- 0297collateral is used to cover a short position
- 0337collateral is used to cover a short position
- 0530of which: secured by L1 excl. EHQCB
- 0540of which: secured by L1 EHQCB
- 0550of which: secured by L2A
- 0560of which: secured by L2B
- 0570of which: secured by non-liquid assets
Columns
- 0010Subject to the 75% cap on inflows
- 0020Subject to the 90% cap on inflows
- 0030Exempted from the cap on inflows
Liquidity coverage, calculations, significant currencies (DA) (C 76.00.w)
Row
- 0080Secured cash 30 day inflows
Column
- 0010Value / Percentage
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{C_76.00.w,r0080,c0010,} = ({C_74.00.w,r0263,c0010,} + {C_74.00.w,r0263,c0020,} + {C_74.00.w,r0263,c0030,}) - ({C_74.00.w,r0297,c0010,} + {C_74.00.w,r0297,c0020,} + {C_74.00.w,r0297,c0030,}) - ({C_74.00.w,r0337,c0010,} + {C_74.00.w,r0337,c0020,} + {C_74.00.w,r0337,c0030,}) - ({C_74.00.w,r0530,c0010,} + {C_74.00.w,r0530,c0020,} + {C_74.00.w,r0530,c0030,}) - ({C_74.00.w,r0540,c0010,} + {C_74.00.w,r0540,c0020,} + {C_74.00.w,r0540,c0030,}) - ({C_74.00.w,r0550,c0010,} + {C_74.00.w,r0550,c0020,} + {C_74.00.w,r0550,c0030,}) - ({C_74.00.w,r0560,c0010,} + {C_74.00.w,r0560,c0020,} + {C_74.00.w,r0560,c0030,}) - ({C_74.00.w,r0570,c0010,} + {C_74.00.w,r0570,c0020,} + {C_74.00.w,r0570,c0030,})Other rules on C 74.00.w
- Subject to the 75% cap on inflows: if amount is zero or more, inflow cannot be negative (v7633_m)Warning
- Subject to the 90% cap on inflows: if amount is zero or more, inflow cannot be negative (v7634_m)Warning
- Exempted from the cap on inflows: if amount is zero or more, inflow cannot be negative (v7635_m)Warning
- Subject to the 75% cap on inflows cannot be more than 1, and subject to the 90% cap on inflows cannot be more than 1, and exempted from the cap on inflows cannot be more than 1 (v7636_m)Warning
- Subject to the 75% cap on inflows cannot be more than 0.5, and subject to the 90% cap on inflows cannot be more than 0.5, and exempted from the cap on inflows cannot be more than 0.5 (v7637_m)Warning
- Loans with an undefined contractual end date cannot be more than 0.2 (v7638_m)Warning
- Monies due from financial customers being classified as operational deposits where the credit institution is not able to establish a corresp cannot be more than 0.05 (v7639_m)Warning
- Subject to the 75% cap on inflows: if amount is zero or more, applicable weight cannot be negative (v7640_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
