The rule in plain words
L2B collateral 30 day outflows, value / percentage must equal these 93 worked out:
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0331)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0323)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0335)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0283)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0287)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0291)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0323)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0327)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0283)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0327)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0287)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0323)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0295)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0283)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0287)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0295)
- Collateral received meets operational requirements, exempted from the cap on inflows (row 0331)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0335)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0327)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0295)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0291)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0331)
- Collateral received meets operational requirements, subject to the 75% cap on inflows (row 0291)
- Collateral received meets operational requirements, subject to the 90% cap on inflows (row 0335)
- Minus memorandum items secured by L2B, exempted from the cap on inflows
- Minus memorandum items secured by L2B, subject to the 90% cap on inflows
- Minus memorandum items secured by L2B, subject to the 75% cap on inflows
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0310)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0970)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2030)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1460)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2330)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2140)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2520)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1970)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2480)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1180)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2650)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0780)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0650)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1290)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2350)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1500)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0840)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1120)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0330)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0460)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1630)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0670)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0120)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0800)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0950)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2010)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2540)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1350)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1010)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2160)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2370)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2690)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2200)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1520)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2710)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0630)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0990)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1990)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0100)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2670)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0500)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0290)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1480)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1650)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0820)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0440)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1840)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2310)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1820)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1140)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1670)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0610)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1860)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1310)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2500)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1330)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0140)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 2180)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0270)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1800)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0160)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1160)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 1690)
- Collateral swapped meets operational requirements, liquidity value of collateral borrowed (row 0480)
- Minus collateral borrowed is L2B, liquidity value of collateral borrowed
- Central institutions: Level 2B assets which are considered liquid assets for the depositing credit institution, value according to Article 9
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
C_76.00.A: L2B collateral 30 day outflows = C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0331) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0323) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Exempted from the cap on inflows + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0287) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0291) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0323) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0327) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0327) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0287) + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0323) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Exempted from the cap on inflows + C_74.00.A: Level 2B asset backed securities (residential or auto) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0283) + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0287) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Subject to the 90% cap on inflows + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0331) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Subject to the 75% cap on inflows + C_74.00.A: Level 2B high quality covered bonds collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0327) + C_74.00.A: Level 2B collateral not already captured in section 1.2.1.4, 1.2.1.5 or 1.2.1.6, of which collateral received meets operational requirements, Subject to the 75% cap on inflows + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0291) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0331) + C_74.00.A: Level 2B asset backed securities (commercial or individuals) collateral, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0291) + C_74.00.A: Level 2B collateral not already captured in section 1.2.2.4, 1.2.2.5 or 1.2.2.6, of which collateral received meets operational requirements, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L2B, Exempted from the cap on inflows - C_74.00.A: of which: secured by L2B, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L2B, Subject to the 75% cap on inflows + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0970) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2030) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1460) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2330) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2520) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1970) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2480) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1180) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2650) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0780) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0650) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1290) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2350) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1500) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0840) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1120) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0330) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0460) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1630) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0670) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0120) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0800) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0950) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2010) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2540) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1350) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1010) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2160) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2370) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2690) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2200) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1520) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2710) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0630) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0990) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1990) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0100) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2670) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0500) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0290) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1480) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1650) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0820) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0440) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1840) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1820) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1670) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0610) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1860) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1310) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2500) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1330) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0140) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2180) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0270) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1800) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0160) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1160) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1690) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0480) - C_75.01.A: of which: collateral borrowed is L2B, Liquidity value of collateral borrowed + C_72.00.A: Central institutions: Level 2B assets which are considered liquid assets for the depositing credit institution, Value according to Article 9
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 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 , liquid assets, total (DA) (C 72.00.a)
Row
- 0470Central institutions: Level 2B assets which are considered liquid assets for the depositing credit institution
Column
- 0040Value according to Article 9
Liquidity coverage, inflows, total (DA) (C 74.00.a)
Rows
- 0283of which collateral received meets operational requirements
- 0287of which collateral received meets operational requirements
- 0291of which collateral received meets operational requirements
- 0295of which collateral received meets operational requirements
- 0323of which collateral received meets operational requirements
- 0327of which collateral received meets operational requirements
- 0331of which collateral received meets operational requirements
- 0335of which collateral received meets operational requirements
- 0560of which: secured by L2B
Columns
- 0110Subject to the 75% cap on inflows
- 0120Subject to the 90% cap on inflows
- 0130Exempted from the cap on inflows
Liquidity coverage, collateral swaps, total (DA) (C 75.01.a)
Rows
- 0100Of which collateral swapped meets operational requirements
- 0120Of which collateral swapped meets operational requirements
- 0140Of which collateral swapped meets operational requirements
- 0160Of which collateral swapped meets operational requirements
- 0270Of which collateral swapped meets operational requirements
- 0290Of which collateral swapped meets operational requirements
- 0310Of which collateral swapped meets operational requirements
- 0330Of which collateral swapped meets operational requirements
- 0440Of which collateral swapped meets operational requirements
- 0460Of which collateral swapped meets operational requirements
- 0480Of which collateral swapped meets operational requirements
- 0500Of which collateral swapped meets operational requirements
- 0610Of which collateral swapped meets operational requirements
- 0630Of which collateral swapped meets operational requirements
- 0650Of which collateral swapped meets operational requirements
- 0670Of which collateral swapped meets operational requirements
- 0780Of which collateral swapped meets operational requirements
- 0800Of which collateral swapped meets operational requirements
- 0820Of which collateral swapped meets operational requirements
- 0840Of which collateral swapped meets operational requirements
- 0950Of which collateral swapped meets operational requirements
- 0970Of which collateral swapped meets operational requirements
- 0990Of which collateral swapped meets operational requirements
- 1010Of which collateral swapped meets operational requirements
- 1120Of which collateral swapped meets operational requirements
- 1140Of which collateral swapped meets operational requirements
- 1160Of which collateral swapped meets operational requirements
- 1180Of which collateral swapped meets operational requirements
- 1290Of which collateral swapped meets operational requirements
- 1310Of which collateral swapped meets operational requirements
- 1330Of which collateral swapped meets operational requirements
- 1350Of which collateral swapped meets operational requirements
- 1460Of which collateral swapped meets operational requirements
- 1480Of which collateral swapped meets operational requirements
- 1500Of which collateral swapped meets operational requirements
- 1520Of which collateral swapped meets operational requirements
- 1630Of which collateral swapped meets operational requirements
- 1650Of which collateral swapped meets operational requirements
- 1670Of which collateral swapped meets operational requirements
- 1690Of which collateral swapped meets operational requirements
And 25 more.
Column
- 0040Liquidity value of collateral borrowed
Liquidity coverage, calculations, total (DA) (C 76.00.a)
Row
- 0230L2B collateral 30 day outflows
Column
- 0010Value / Percentage
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
{C_76.00.a,r0230,c0010,} = sum({C_74.00.a,r0331,c0110,},{C_74.00.a,r0323,c0130,},{C_74.00.a,r0335,c0130,},{C_74.00.a,r0283,c0130,},{C_74.00.a,r0287,c0130,},{C_74.00.a,r0291,c0130,},{C_74.00.a,r0323,c0120,},{C_74.00.a,r0327,c0110,},{C_74.00.a,r0283,c0110,},{C_74.00.a,r0327,c0130,},{C_74.00.a,r0287,c0110,},{C_74.00.a,r0323,c0110,},{C_74.00.a,r0295,c0130,},{C_74.00.a,r0283,c0120,},{C_74.00.a,r0287,c0120,},{C_74.00.a,r0295,c0120,},{C_74.00.a,r0331,c0130,},{C_74.00.a,r0335,c0110,},{C_74.00.a,r0327,c0120,},{C_74.00.a,r0295,c0110,},{C_74.00.a,r0291,c0120,},{C_74.00.a,r0331,c0120,},{C_74.00.a,r0291,c0110,},{C_74.00.a,r0335,c0120,}) - sum({C_74.00.a,r0560,c0130,},{C_74.00.a,r0560,c0120,},{C_74.00.a,r0560,c0110,}) + sum({C_75.01.a,r0310,c0040,},{C_75.01.a,r0970,c0040,},{C_75.01.a,r2030,c0040,},{C_75.01.a,r1460,c0040,},{C_75.01.a,r2330,c0040,},{C_75.01.a,r2140,c0040,},{C_75.01.a,r2520,c0040,},{C_75.01.a,r1970,c0040,},{C_75.01.a,r2480,c0040,},{C_75.01.a,r1180,c0040,},{C_75.01.a,r2650,c0040,},{C_75.01.a,r0780,c0040,},{C_75.01.a,r0650,c0040,},{C_75.01.a,r1290,c0040,},{C_75.01.a,r2350,c0040,},{C_75.01.a,r1500,c0040,},{C_75.01.a,r0840,c0040,},{C_75.01.a,r1120,c0040,},{C_75.01.a,r0330,c0040,},{C_75.01.a,r0460,c0040,},{C_75.01.a,r1630,c0040,},{C_75.01.a,r0670,c0040,},{C_75.01.a,r0120,c0040,},{C_75.01.a,r0800,c0040,},{C_75.01.a,r0950,c0040,},{C_75.01.a,r2010,c0040,},{C_75.01.a,r2540,c0040,},{C_75.01.a,r1350,c0040,},{C_75.01.a,r1010,c0040,},{C_75.01.a,r2160,c0040,},{C_75.01.a,r2370,c0040,},{C_75.01.a,r2690,c0040,},{C_75.01.a,r2200,c0040,},{C_75.01.a,r1520,c0040,},{C_75.01.a,r2710,c0040,},{C_75.01.a,r0630,c0040,},{C_75.01.a,r0990,c0040,},{C_75.01.a,r1990,c0040,},{C_75.01.a,r0100,c0040,},{C_75.01.a,r2670,c0040,},{C_75.01.a,r0500,c0040,},{C_75.01.a,r0290,c0040,},{C_75.01.a,r1480,c0040,},{C_75.01.a,r1650,c0040,},{C_75.01.a,r0820,c0040,},{C_75.01.a,r0440,c0040,},{C_75.01.a,r1840,c0040,},{C_75.01.a,r2310,c0040,},{C_75.01.a,r1820,c0040,},{C_75.01.a,r1140,c0040,},{C_75.01.a,r1670,c0040,},{C_75.01.a,r0610,c0040,},{C_75.01.a,r1860,c0040,},{C_75.01.a,r1310,c0040,},{C_75.01.a,r2500,c0040,},{C_75.01.a,r1330,c0040,},{C_75.01.a,r0140,c0040,},{C_75.01.a,r2180,c0040,},{C_75.01.a,r0270,c0040,},{C_75.01.a,r1800,c0040,},{C_75.01.a,r0160,c0040,},{C_75.01.a,r1160,c0040,},{C_75.01.a,r1690,c0040,},{C_75.01.a,r0480,c0040,}) - {C_75.01.a,r2780,c0040,} + {C_72.00.a,r0470,c0040,}Other rules on C 72.00.a
- L2A collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, v10183_m)Warning
- L1 EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, v10181_m)Warning
- L1 excl. EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, v10179_m)Warning
- Applicable weight cannot be negative (v8642_s)Warning
- Amount or market value cannot be negative (v7683_s)Warning
- Value according to Article 9 cannot be negative (v7681_s)Warning
- If amount or market value is zero or more, applicable weight cannot be negative (v7571_m)Warning
- Qualifying CIU shares or units: underlying is corporate debt securities (CQS2/3), shares (major stock index) or non-interest bearing assets (he, applicable weight cannot be more than 0.45 (v7570_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
