{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LCR","NSFR"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LCR","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,4,8,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Stressed Outflows",null,null,"HQLA Pool"]
[null,null,"Amount",null,null,"Amount"]
[null,"Desposit outflows",50,null,"Cash",35]
[null,"Wholesale funding",15,null,"Level 1",50]
[null,"Secured funding",15,null,"Level 2A",40]
[null,"Derivatives",10,null,"Level 2B",15]
[null,"Downgrade exposure",6]
[null,"Loan drawdown",10]
[null,"Intraday",12]
[]
[null,"Total",{"$f":"SUM(C11:C17)","v":118},null,"Total",{"$f":"SUM(F11:F14)","v":140}]
[]
[null,"LCR",{"$f":"F19/C19","v":1.1864406779661016}]
[null,"LCR (without derivatives)",{"$f":"F19/(C19-C14-C15)","v":1.3725490196078431}]

{"sheet":"NSFR","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,1,8,4],[8,6,8,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Liabilities",null,null,null,null,"Assets"]
[null,null,"Amount","ASF Factor","ASF",null,null,"Amount","RSF Factor","RSF"]
[null,"Equity",50,1,{"$f":"C11*D11","v":50},null,"Cash",75,0,{"$f":"H11*I11","v":0}]
[null,"Wholesale funding (> 1 year)",75,1,{"$f":"C12*D12","v":75},null,"Level 1 assets",100,0.05,{"$f":"H12*I12","v":5}]
[null,"Wholesale funding (< 1 year)",275,0,0,null,"Level 2A assets",75,0.15,11.25]
[null,"Stable deposits",225,0.95,213.75,null,"Level 2B assets",50,0.5,25]
[null,"Other desposits",115,0.5,57.5,null,"Residential Mortgages > 1 year",350,0.65,227.5]
[null,"Repos",50,0,0,null,"Other",100,1,100]
[null,"Gross derivative liabilities",100,0,0,null,"Gross derivatives assets equal",100,0,0]
[null,null,null,null,null,null,"Gross derivatives assets excess",40,1,{"$f":"MAX(H18,0)*I18","v":40}]
[null,null,null,null,null,null,"Net derivatives liabilities",15,0.2,3]
[]
[null,"Total",{"$f":"SUM(C11:C17)","v":890},null,{"$f":"SUM(E11:E17)","v":396.25},null,"Total",{"$f":"SUM(H11:H19)-H19","v":890},null,{"$f":"SUM(J11:J19)","v":411.75}]
[]
[]
[null,"NSFR",{"$f":"E21/J21","v":0.9623557984213722}]
[null,"NSFR (no derivatives)",{"$f":"(E21-E17)/SUM(J11:J16)","v":1.0745762711864406}]