{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FOI","Borrowing","Lending"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1600,"comments":0,"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":"FOI","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["WBCIR:18066"]
["1. I'd like details of all loans over £100,000 that this Council has made to other parties since May 2022, and all loans that this Council has taken out over £100,000 in the same period."]
[]
["In particular I'd like to know who the loan was made to or received from, the date the loan or borrowing took place, the date the loan or borrowing was paid back, or is due to be paid back, the loan amount, and the agreed annual interest rate applicable on the loan or borrowing."]

{"sheet":"Borrowing","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Counterparty","Date deal made","Principal","Date of Transfer","Maturity Date","Rate %"]
["West Yorkshire Combined Authority","2022-10-06",15000000,"2022-10-31","2023-10-05",4.0999999999999996]
["Greater Manchester Combined Authority","2022-11-24",10000000,"2022-11-28","2023-01-30",2.9]
["Derbyshire County Council Pension Fund","2022-12-20",10000000,"2022-12-20","2023-01-20",3.5]
["Cambridgeshire & Peterborough Combined Authority","2023-03-17",10027923.289999999,"2023-03-17","2023-03-20",5]
["Durham County Council","2023-03-20",5000000,"2023-03-21","2023-09-21",4.5]
["West Midlands Combined Authority","2022-08-04",10000000,"2023-03-23","2024-03-21",2.5]
["Bournemouth , Christchurch & Poole Council","2023-03-22",10000000,"2023-03-24","2023-04-24",4.4000000000000004]
["City & County of Swansea","2023-03-24",5000000,"2023-03-24","2023-06-30",4.4000000000000004]
["West Midlands Combined Authority","2022-08-04",10000000,"2023-03-28","2024-03-26",2.5]
["Carmarthenshire County Council","2023-05-03",5000000,"2023-05-04","2023-07-31",4.42]
["London Borough of Havering","2023-05-03",5000000,"2023-05-04","2023-07-31",4.42]
["City & County of Swansea","2023-05-30",2000000,"2023-05-30","2023-08-30",4.7]
["West Yorkshire Combined Authority - West Yorkshire Police","2022-11-09",10000000,"2023-06-07","2024-06-05",4.2]
["Hyndburn Borough Council","2023-06-07",2000000,"2023-06-19","2024-06-17",5]
["South Oxfordshire District Council","2023-06-07",3000000,"2023-06-19","2024-06-17",5]
["Northern Ireland Housing Executive","2023-06-26",10000000,"2023-07-03","2024-07-01",5.45]
["Derbyshire County Council","2023-07-31",3500000,"2023-07-31","2023-08-25",5.25]
["City & County of Swansea","2023-07-27",3000000,"2023-08-01","2023-08-08",4.93]
["Morth Northamptonshire Council","2023-08-03",8000000,"2023-08-18","2023-11-20",5.45]
["Manchester City Council","2023-09-28",2000000,"2023-09-29","2023-10-31",5.45]
["Torbay Borough Council","2023-07-05",5000000,"2023-10-02","2024-09-30",5.85]
["West Yorkshire Combined Authority","2023-09-22",15000000,"2023-10-05","2024-08-30",5.55]
["London Borough of Croydon, Pension Fund","2023-12-20",5000000,"2023-12-21","2024-03-21",5.75]
["West Midlands Combined Authority","2023-06-23",10000000,"2024-03-21","2025-03-20",5.6]
["West Midlands Combined Authority","2023-06-23",10000000,"2024-03-26","2025-03-25",5.6]

{"sheet":"Lending","index":2,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Counterparty","Date deal made","Principal","Date of Transfer","Maturity Date","Rate %"]
[]
["Birmingham City Council","2022-07-06",10000000,"2022-07-25","2022-10-25",1.41]
["Cornwall Council","2022-07-26",10000000,"2022-07-29","2022-10-28",1.62]
["Plymouth City Council","2022-07-21",10000000,"2022-08-05","2022-11-07",1.5]
["North Lanarkshire Council","2022-07-21",3000000,"2022-08-23","2022-12-07",1.5]
["West of England Combined Authority","2022-09-01",10000000,"2022-09-15","2022-12-15",2]
["Ashford Borough Council","2022-10-10",10000000,"2022-10-24","2023-01-24",2.85]
["Cornwall Council","2022-10-07",10000000,"2022-10-28","2023-01-30",2.85]
["City of Plymouth","2022-10-20",10000000,"2022-11-07","2023-02-07",2.9]
["Aberdeen City Council","2022-11-08",5000000,"2022-11-14","2023-02-14",2.95]
["Mid Suffolk District Council","2022-11-11",5000000,"2022-11-15","2023-01-31",2.8]
["Central Bedfordshire Council","2022-11-02",10000000,"2022-11-18","2023-01-18",2.5499999999999998]
["Stockport Metropolitan BC","2022-11-16",10000000,"2022-11-21","2022-12-05",2.69]
["London Borough of Barking and Dagenham","2022-11-21",5000000,"2022-11-21","2022-12-12",2.72]
["West Midlands Combined Authority","2022-11-04",10000000,"2022-11-24","2023-01-24",2.75]
["London Borough of Barking and Dagenham","2022-11-21",5000000,"2022-12-01","2022-12-22",2.72]
["Wirral Borough Council","2022-11-16",10000000,"2022-12-02","2023-03-02",3.02]
["Middlesbrough Borough Council","2022-12-13",10000000,"2023-01-03","2023-04-03",3.32]
["South Somerset District Council","2022-11-11",10000000,"2023-01-18","2023-04-18",3.2]
["Cornwall Council","2023-01-25",5000000,"2023-01-30","2023-03-31",3.69]
["Leeds City Council","2023-02-02",5000000,"2023-02-07","2023-03-15",3.75]
["Blackpool Borough Council","2023-03-09",5000000,"2023-03-23","2023-06-23",4.5]
["Peterborough City Council","2023-03-09",5000000,"2023-03-24","2023-06-26",4.5]
["Police and crime commissioner for Hertfordshire","2023-04-06",9000000,"2023-04-06","2023-04-13",4.2]
["Somerset Council","2023-04-05",10000000,"2023-04-18","2024-02-28",4.2300000000000004]
["Cornwall Council","2023-04-21",10000000,"2023-04-24","2023-06-28",4.22]
["Eastleigh Borough Council","2023-04-05",10000000,"2023-04-26","2023-10-27",4.2]
["North Lanarkshire Council","2023-04-13",10000000,"2023-05-02","2024-03-22",4.28]
["The City of Liverpool","2023-04-20",10000000,"2023-05-30","2024-01-26",4.3]
["Eastbourne Borough Council","2023-04-27",10000000,"2023-06-07","2024-03-28",4.5]
["Woking Borough Council","2023-05-18",10000000,"2023-06-08","2024-03-08",4.75]
["Rushmoor Borough Council","2023-05-25",5000000,"2023-06-21","2024-01-19",4.78]
["Derbyshire County Council","2023-07-05",5000000,"2023-07-06","2023-10-06",5.05]
["Leeds City Council","2023-07-18",5000000,"2023-07-19","2023-08-21",5.08]
["Cleveland fire authority","2023-07-18",2500000,"2023-07-21","2023-08-21",5.09]
["North Tyneside Metropolitan Borough Council","2023-07-21",5000000,"2023-07-24","2023-08-14",4.95]
["Derbyshire County Council","2023-07-13",5000000,"2023-07-25","2023-09-25",5]
["The council of the borough of Kirklees","2023-05-25",5000000,"2023-08-15","2024-01-18",4.75]
["Central Bedfordshire Council","2023-10-10",5000000,"2023-10-23","2023-11-06",5.25]
["Police and crime commissioner for Hertfordshire","2023-10-26",7000000,"2023-10-31","2023-11-07",5.4]
["East Dunbartonshire council","2023-11-14",5000000,"2023-11-23","2023-12-18",5.25]
["Dundee city council","2024-02-27",5000000,"2024-02-28","2024-03-07",6.3]
["London Borough of Waltham Forest","2024-03-21",6000000,"2024-03-21","2024-04-22",7]
["Kings Lynn & West Norfolk borough council","2024-03-21",5000000,"2024-03-25","2024-04-25",7.05]
["Police and Crime commissioner for West Mercia","2024-03-25",5000000,"2024-03-28","2024-04-30",7.5]
["Police & crime com. for Lancashire","2024-04-15",10000000,"2024-05-17","2024-07-17",5.4]