{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["FSA082","Lists"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"FSA082","index":0,"n_rows":48,"n_cols":14,"rows_kept":48,"merged":[[6,2,6,3],[6,4,6,6],[7,2,7,3],[7,4,7,6],[8,2,8,3],[8,4,8,6],[9,2,9,3],[9,4,9,6],[10,2,10,3],[10,4,10,6],[11,2,11,3],[11,4,11,6],[12,2,12,3],[12,4,12,6],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[18,5,18,9],[18,10,18,12],[18,13,19,13],[22,2,36,2],[37,2,39,2],[41,2,43,2],[44,2,44,4],[45,2,45,4],[48,1,55,13]]}
[]
[]
[null,"FSA082 Pillar 2 Credit Risk IRB Approach Retail"]
[]
[null,"General Information"]
[]
[null,1,"Name of the template",null,"FSA082"]
[null,2,"PRA template version control",null,"V1.00"]
[null,3,"Basis of reporting"]
[null,4,"Submission number (increase by 1 if resubmission)"]
[null,5,"Firm reference number (FRN)"]
[null,6,"Name of the firm"]
[null,7,"Reporting period start date"]
[null,8,"Reporting period end date"]
[null,9,"Reporting currency"]
[null,10,"Currency reporting unit",null,"single"]
[]
[null,"IRB data to create exposure weighted IRB risk weight for Pillar 2A credit risk approach - retail portfolios"]
[null,null,"Loan type","Primary Segment","Classification","Banking Book non-defaulted assets",{"$nulls":4},"Banking Book defaulted assets",null,null,"Comments"]
[{"$nulls":5},"Average LTV","Limit","EAD","RWA","EL","EAD","RWA","EL"]
[{"$nulls":5},{"v":10,"d":"010"},{"v":20,"d":"020"},{"v":30,"d":"030"},{"v":40,"d":"040"},{"v":50,"d":"050"},{"v":60,"d":"060"},{"v":70,"d":"070"},{"v":80,"d":"080"},{"v":90,"d":"090"}]
[]
[null,{"v":10,"d":"010"},"UK mortgage lending","Prime","0% <=LTV <50%"]
[null,{"v":20,"d":"020"},null,"Prime","50% <=LTV <60%"]
[null,{"v":30,"d":"030"},null,"Prime","60% <=LTV <70%"]
[null,{"v":40,"d":"040"},null,"Prime","70% <=LTV <80%"]
[null,{"v":50,"d":"050"},null,"Prime","80% <=LTV <90%"]
[null,{"v":60,"d":"060"},null,"Prime","90% <=LTV <100%"]
[null,{"v":70,"d":"070"},null,"Prime","LTV >= 100%"]
[null,{"v":80,"d":"080"},null,"BTL","0% <=LTV <50%"]
[null,{"v":90,"d":"090"},null,"BTL","50% <=LTV <60%"]
[null,100,null,"BTL","60% <=LTV <70%"]
[null,110,null,"BTL","70% <=LTV <80%"]
[null,120,null,"BTL","80% <=LTV <90%"]
[null,130,null,"BTL","90% <=LTV <100%"]
[null,140,null,"BTL","LTV >= 100%"]
[null,150,null,"Other Mortgages"]
[null,160,"Non-UK mortgages","Prime"]
[null,170,null,"BTL"]
[null,180,null,"Other Mortgages"]
[null,190,"Loans","Personal Loans"]
[null,200,"QRRE","Revolving loans & overdrafts"]
[null,210,null,"Credit cards","UK Credit Cards"]
[null,220,null,"Credit cards","International Credit Cards"]
[null,230,"All other retail lending (provide description below)"]
[null,240,"Total"]
[]
[null,"Firms' notes/qualitative information on data reported"]

{"sheet":"Lists","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"hidden":true}
["Basis_of_Reporting","Currency"]
["Unconsolidated","GBP (Pounds Sterling)"]
["Solo consolidation","USD (US Dollars)"]
["UK Consolidation Group","EUR (Euros)"]
["Capital sub-group","CAD (Canadian Dollars)"]
[null,"CHF (Swiss Francs)"]
[null,"JPY (Japanese Yen)"]
[null,"SEK (Swedish Krona)"]