{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Investment Holdings","Alternative"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Investment Holdings","index":0,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Cambridgeshire Pension Fund - Investments  as at 30th June 2022  (unaudited)"]
["Investment Holdings"]
[]
["Asset Name","No. of Shares held","Asset Class","ISIN","Country","Market Value (GBP)"]
["Alternative Assets",null,null,null,null,873579179.4000001]
["Accrued Income",null,null,null,null,777844.60999999987]
["Cash and Cash Equivalents",null,null,null,null,29644570.530000005]
["UBS ASST MGMT LIFE EX UK EQ TRK HGD A   ACC NAV",37409418.759999998,"Equities","GB00B65PD805","Europe Region",108876372.36]
["UBS ASST MGMT LIFE JPN EQ TRAKAR HGD A  ACC NAV",35000353.226000004,"Equities","GB00B65PDB35","Japan",82726834.879999995]
["UBS ASST MGMT LIFE USA EQ TRKER HGD A   ACC NAV",39021428.200000003,"Equities","GB00B65PDG89","North America Region",174082395.49000001]
["UBS ASST MGMT LIFE PC EX JP EQ TK HG A  ACC NAV",50367076.858999997,"Equities","GB00B65PDD58","Pacific Region less Japan",107619333.12]
["LINK FUND SOL LTD ACCESS GLOBAL EQUITY AGBP",309754422.704,"Equities","GB00BGWL4221","United Kingdom",394812987.18000001]
["LINK FUND SOL LTD ACCESS GLOBAL STOCK A GBP",393557793.07099998,"Equities","GB00BGWL3Y77","United Kingdom",548580207.75999999]
["NORTHERN TRUST GLO LF ACCESS GLOBAL EQTYJOHCM",388858228.31199998,"Equities","GB00BJ9NBJ83","United Kingdom",472268318.27999997]
["UBS ASST MGMT LIFE DEV WLD EQ FNDMTLY W IDX A",60552812.726000004,"Equities","GB00BSPNJL36","United Kingdom",100989981.06]
["UBS ASST MGMT LIFE UK EQUITY TRACKER A  NAV",27305050.822000001,"Equities","GB0002680139","United Kingdom",86679883.829999998]
["UBS GLOBAL ASSET MANAGEMENT LIFE WLD    EQTY OPTIMISED VOLATILITY IDX A NAV",46044902.674999997,"Equities","GB00BH579T69","United Kingdom",112041061.68000001]
["UBS GLOBAL ASSET MANAGEMENT LIFE WORLD  QUALITY COS INDEX A NAV",30021117.204,"Equities","GB00BH5MHR52","United Kingdom",94068168.650000006]
["LINK FUND SOL LTD ACCESS ALPHA OPPS A   GBP DIS",201303058.75600001,"Fixed Income","GB00BJT13T61","United Kingdom",197578952.16999999]
["TSY 2046 I/L STOCK DUE                  22/03/2046",3961000,"Fixed Income","GB00BYMWG366","United Kingdom",6335524.8600000003]
["AXA EUROPEAN ADDED VALUE FUND LP",1,"Real Estate",null,"Europe Region",6281.57]
["INCOME PLUS REAL ESTATE DEBT FUND",19886089.949999999,"Real Estate",null,"United Kingdom",18907839.489999998]
["INDUSTRIAL PROPERTY INVESTMENT FUND     IPIF FEEDER GBP",21770.9,"Real Estate","JE00BSTJTG29","Jersey, Channel Islands",47365621.280000001]
["BLACKROCK UK FD",349038,"Real Estate","GB0005201990","United Kingdom",17895457.489999998]
["HERMES PROPERTY UT",3595518,"Real Estate","GB0004262191","United Kingdom",28293131.140000001]
["LEGAL AND GENERAL MANAGED PROPERTY FUND",79304.42,"Real Estate",null,"United Kingdom",5505693.5]
["MAYFAIR CAP PPTY (MCPUT)",16096.165000000001,"Real Estate",null,"United Kingdom",24466170.800000001]
["METRO PPTY UNIT TR",33779.65,"Real Estate",null,"United Kingdom",21517974.850000001]
["MULTI-LET INDL PROPERTY UNIT TRUST",11053.603999999999,"Real Estate",null,"United Kingdom",21750287.129999999]
["REAL INCOME FD",10624.421,"Real Estate",null,"United Kingdom",8832187.4199999999]
["SCHRODER INVT MGMT REGL OFFICE PPTY UNITTR",18737.268,"Real Estate",null,"United Kingdom",19597308.600000001]
["SCHRODERS CAPITAL UNIT TRUSTS UK REAL ESTATE SREF I INC",480330.43900000001,"Real Estate","GB00B8215Z66","United Kingdom",25894613.969999999]
["SCHRODERS LOCAL RETAIL FUND",7362.5119999999997,"Real Estate",null,"United Kingdom",7699715.0499999998]
["SDR CAPITAL RE DEBT SCSP LOANS LP",10298607,"Real Estate",null,"United Kingdom",10298607]
["SSHF UNIT TRUST",5749397,"Real Estate",null,"United Kingdom",5979372.8799999999]
["Schroder RECAP SSF Unit Trust",9783520,"Real Estate",null,"United Kingdom",10304981.619999999]
["THREADNEEDLE PROP THREADNEEDLE PROP UNITTRST",46354.36,"Real Estate","GB0005086672","United Kingdom",15372496.41]
["UK RETIREMENT LIVING UNIT TRUST",7604868,"Real Estate",null,"United Kingdom",5832933.7599999998]
["OCTOPUS INVSTS LTD OCTOPUS HEALTHCARE   UNITS Q",3175.4490000000001,"Real Estate","GB00BD9FRF09","United Kingdom",3841848.73]
["BLUEBAY FUNDS MGMT TOTAL RETURN         DIVERSIFIED CR",1666898.987,"Fixed Income","LU1050660825","Global Region",178941606.25]
["UK(GOVERNMENT OF) 0.125% I/L            22/03/2058",3205000,"Fixed Income","GB00BP9DLZ64","United Kingdom",5464527.5199999996]
["UK(GOVERNMENT OF) 0.25% I/L             22/03/2052",3623000,"Fixed Income","GB00B73ZYW09","United Kingdom",6532820.8499999996]
["UK(GOVERNMENT OF) 0.75% I/L 22/3/34 GBP",4320000,"Fixed Income","GB00B46CGH68","United Kingdom",7767152.7199999997]
["UK(GOVERNMENT OF) 1.25% I/L             22/11/2027",4138000,"Fixed Income","GB00B128DH60","United Kingdom",8323003.1600000001]
["UK(GOVT OF) 0.125% I/L                   22/03/29",4863000,"Fixed Income","GB00B3Y1JG82","United Kingdom",7657784.0999999996]
["UK(GOVT OF) 0.125% I/L SNR 22/03/68 GBP",3641000,"Fixed Income","GB00BDX8CX86","United Kingdom",7021822.8499999996]
["UK(GOVT OF) 0.125% I/L SNR 22/11/36 GBP",4242000,"Fixed Income","GB00BYZW3J87","United Kingdom",6487230.1900000004]
["UK(GOVT OF) 0.125% I/L SNR 22/11/56 GBP",1886100,"Fixed Income","GB00BYVP4K94","United Kingdom",3071724]
["UK(GOVT OF) 0.375% I/L SNR 22/03/62 GBP",3640000,"Fixed Income","GB00B4PTCY75","United Kingdom",7481301.6500000004]
["UK(GOVT OF) 0.5% I/L GILT SNR 03/2050",3679000,"Fixed Income","GB00B421JZ66","United Kingdom",7903405.4800000004]
["UK(GOVT OF) 0.625% I/L GILT 03/40 GBP",4264000,"Fixed Income","GB00B3LZBF68","United Kingdom",8562747.0500000007]
["UK(GOVT OF) 0.625% IDX/LKD 22/11/42",3692000,"Fixed Income","GB00B3MYD345","United Kingdom",7788316.7300000004]
["UK(GOVT OF) 0.75% I/L STK               22/11/2047",3520000,"Fixed Income","GB00B24FFM16","United Kingdom",8010090.2800000003]
["UK(GOVT OF) 1.125% IDX/LKD 22/11/37",3929000,"Fixed Income","GB00B1L6W962","United Kingdom",8891156.9100000001]
["UK(GOVT OF) 1.25% IDX/LKD 22/11/55 GBP",2925000,"Fixed Income","GB00B0CNHZ09","United Kingdom",8721754.4499999993]
["UK(GOVT OF) 2% IDX/LKD SNR 26/01/35",2753000,"Fixed Income","GB0031790826","United Kingdom",7474395]
["UK(GOVT OF) IDX/LKD GTD 10/08/2031 GBP",1103000,"Fixed Income","GB00BNNGP551","United Kingdom",1453876.8]
["UK(GOVT OF) IDX/LKD GTD 22/03/2051 GBP",647000,"Fixed Income","GB00BNNGP882","United Kingdom",924727.87]
["UK(GOVT OF) IDX/LKD SNR 10/08/2028 GBP",4973000,"Fixed Income","GB00BZ1NTB69","United Kingdom",6626280.8700000001]
["UK(GOVT OF) IDX/LKD SNR 10/08/2041 GBP",3565000,"Fixed Income","GB00BGDYHF49","United Kingdom",5203602.95]
["UK(GOVT OF) IDX/LKD SNR 10/08/2048 GBP",3475000,"Fixed Income","GB00BZ13DV40","United Kingdom",5270929.16]
["UK(GOVT OF) IDX/LKD SNR 22/03/2039 GBP",272000,"Fixed Income","GB00BLH38265","United Kingdom",366589.45]
["UK(GOVT OF) IDX/LKD SNR 22/03/2044 GBP",4781000,"Fixed Income","GB00B7RN0G65","United Kingdom",8047993.5999999996]
["UK(GOVT OF) IDX/LKD SNR 22/07/2030 GBP",1422000,"Fixed Income","GB0008932666","United Kingdom",5130263.16]
["UK(GOVT OF)1.25% I/L STK 22/11/2032",4377000,"Fixed Income","GB00B3D4VD98","United Kingdom",8703018.0199999996]
["UNITED KINGDOM(GOVERNMENT OF) .125% IDX LKD GILT 22/11/2065 GBP0.1 (WI)",2191600,"Fixed Income","GB00BD9MZZ71","United Kingdom",3906092.64]
["SPECIALIST INVESTM M&G EUROPEAN LOAN C  DIS GBP",758140.08900000004,"Fixed Income","IE00B0CQS903","Ireland",61947626.670000002]
["NUVEEN UK RETAIL WAREHOUSE FUND",624.12900000000002,"Real Estate",null,"United Kingdom",4475273.3099999996]
["CALL IXO ROYCGB2L 31/05/2023 DOW JONES EURO STO 4107.8826 L 81401",-40642,"Equities",null,"European Union",-1392412.42]
["PUT IXO ROYCGB2L 31/05/2023 DOW JONES EURO STO 2652.447 L 81402",-52253,"Equities",null,"European Union",-4950724.6500000004]
["PUT IXO ROYCGB2L 31/05/2023 DOW JONES EURO STO 3410.289 L 81403",40642,"Equities",null,"European Union",11720761.32]
["CALL IXO BARCGB22 31/05/2023 NIKKEI 225 INDEX 30078.98 L 81394",-377569,"Equities",null,"Japan",-1275657.51]
["PUT IXO BARCGB22 31/05/2023 NIKKEI 225 INDEX 19095.86 L 81392",-485440,"Equities",null,"Japan",-1429270.37]
["PUT IXO BARCGB22 31/05/2023 NIKKEI 225 INDEX 24551.82 L 81393",377569,"Equities",null,"Japan",3615725.99]
["CALL IXO BARCGB22 05/31/2023 STANDARD AND POOR' 4754.04 L 81406",-70423,"Equities",null,"United States",-2328359.59]
["CALL IXO GSILGB2X 05/31/2023 STANDARD AND POOR' 4751.97 L 81409",-70423,"Equities",null,"United States",-2341330.59]
["PUT IXO BARCGB22 05/31/2023 STANDARD AND POOR' 2892.51 L 81404",-90543,"Equities",null,"United States",-7638279.3799999999]
["PUT IXO BARCGB22 05/31/2023 STANDARD AND POOR' 3718.94 L 81405",70423,"Equities",null,"United States",18084864.579999998]
["PUT IXO GSILGB2X 05/31/2023 STANDARD AND POOR' 2892.51 L 81407",-90543,"Equities",null,"United States",-7638279.3799999999]
["PUT IXO GSILGB2X 05/31/2023 STANDARD AND POOR' 3718.93 L 81408",70423,"Equities",null,"United States",18084640.170000002]
[null,null,null,null,null,4120692930.4099984]

{"sheet":"Alternative","index":1,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Cambridgeshire Pension Fund - Investments  NAV as at 30th June 2022 (unaudited)"]
["Alternative Assets"]
[]
["Asset Name","Amount Committed (Currency)","Amount Drawn as at 31/03/2022 (Currency)","Distributions as at 31/03/2022 Currency)","Amount Undrawn at 31/03/2022 (Currency)","Net Asset value as at 30/06/2022 (Currency)","Net Asset value as at 30/06/2022 (GBP)"]
["Adams Street Partners 2003 US Fund",9000000,8550000,13634181,450000,220516,181576.85]
["Adams Street Partners 2003 Non US Fund",9000000,8595000,13245734,405000,274341,225897.32]
["Adams Street Partners 2004 US Fund",9000000,8550000,13354111,450000,254692,209717.98]
["Adams Street Partners 2004 Non US Fund",9000000,8577900,11577640,422100,347055,285771.34000000003]
["Adams Street Partners 2007 US Fund",8800000,8390800,15559019,409200,2341653,1928159.25]
["Adams Street Partners 2007 Non US Fund",5600000,5322800,7592314,277200,1222283.01,1006449.84]
["Adams Street Partners 2007 Direct Fund",1600000,1558400,3248104,41600,704842,580379.6]
["Adams Street Partners 2008 US Fund",10000000,9307000,18174959,693000,4522335,3723772.08]
["Adams Street Partners 2008 Non US Fund",8000000,7306400,10246901,693600,4074628.11,3355122.16]
["Adams Street Partners 2008 Direct Fund",2000000,1949800,4236782,50200,1154413,950564.45]
["Adams Street Partners 2009 US Fund",10000000,9180000,15801717,820000,7466282.0599999996,6147871.0999999996]
["Adams Street Partners 2009 Non US Developed Markets Fund",6000000,5337000,7282755,663000,3188487.07,2625457.67]
["Adams Street Partners 2009 Non US Emerging Markets Fund",2000000,1837000,1772344,163000,1867013.98,1537332.93]
["Adams Street Partners 2009 Direct Fund",2000000,1960400,3034025,39600,1081121,890214.5]
["Adams Street Partners 2010 US Fund ",10000000,8810000,14910578,1190000,8104340.9000000004,6673260.2400000002]
["Adams Street Partners 2010 Non US Developed Market Fund",6000000,5403000,6996310,597000,3427441.05,2822216.68]
["Adams Street Partners 2010 Non US Emerging Market Fund",2000000,1796000,1638932,204000,2129192.98,1753215.84]
["Adams Street Partners 2010 Direct Fund",2000000,1922000,2633455,78000,1185024.02,975770.12]
["Adams Street 2012 Global Fund",20000000,17278000,17397084,2722000,21693393.350000001,17862730.739999998]
["Adams Street 2014 Global Fund",20000000,17900000,12414365,2100000,29537892.780000001,24322032.84]
["Adams Street 2017 Global Fund",20000000,14458286,2782092,5541714,28145967.640000001,23175896.609999999]
["Adams Street 2018 Global Fund",40000000,22080000,3696406,17920000,41204219.420000002,33928296.280000001]
["Adams Street 2019 Global Fund",47500000,19166413,2570493,28333587,38206567.469999999,31459975.68]
["Adams Street 2020 Global Fund",49000000,14212793,960289,34787207,4937237.2,4065410.02]
["Adams Street 2021 Global Fund",50000000,2500000,0,47500000,23617266.550000001,19446882.579999998]
[]
["HarbourVest Partners Buyout Fund VII 2002",10000000,9450000,15667962,{"$f":"B31-C31","v":550000},34081,28062.91]
["HarbourVest Partners Venture Fund VII 2002",8000000,7860000,12419281,140000,214103,176296.27]
["HarbourVest Partners Buyout Fund VIII 2007",17000000,16490000,26936655,510000,2463008.0099999998,2028085.15]
["HarbourVest Partners Venture Fund VIII 2007",3000000,2940000,5120268,60000,1394274,1148070.32]
["HarbourVest Partners IX Venture Fund",6000000,5700000,10057671,300000,10589513.859999999,8719596.4100000001]
["HarbourVest Partners IX Buyout Fund",14000000,11935000,15422001,2065000,11200969.01,9223079.5899999999]
["HarbourVest Partners HIPEP VII (AIF) Partnership Fund",30000000,25650000,20344220,4350000,34179248.090000004,28143808.379999999]
["HarbourVest Partners X AIF",15000000,11175000,6620885,3825000,18656437.68,15362046.75]
["HarbourVest Partners HIPEP VIII (AIF) Partnership L.P",15000000,8062500,1496884,6937500,12612607.17,10385447.869999999]
["HarbourVest Partners International Partnership Fund V 2005",10000000,9600000,15599605,400000,368790,317470.07]
["HarbourVest Partners International Direct Fund V 2005",5000000,4862500,6499634,137500,213125.01,183467.05]
["HarbourVest Partners International Partnership Fund VI 2008",13000000,12350000,16826139,650000,9664098.2300000004,8319265.6399999997]
["HarbourVest Partners Global Feeder AIF LP 2018",40000000,26000000,4609108,14000000,44855023.390000001,36934434.020000003]
["HarbourVest Partners Global Feeder AIF LP 2019",47500000,24225000,5256999,23275000,39081040.299999997,32180032.359999999]
["HarbourVest Partners Global Feeder AIF LP 2020",49000000,26705000,2781579,22295000,35841647.509999998,29512658]
["HarbourVest Partners Global Feeder AIF LP 2021",50000000,7250000,0,42750000,11032267.699999999,9084167.8900000006]
[]
["UBS Infrastructure Fund 2007",30000000,28538085,20455182.82,1461915,11626952.57,9573842.1300000008]
[]
["M&G Real Estate",55000000,55000000,0,0,58162335,58162335]
[]
["M&G SOF",50000000,14621900,0,{"$f":"B52-C52","v":35378100},15784380.32,15784380.32]
[]
["Equitix Infrastructure Fund II",20000000,19981932.940000001,12969680.039999999,18067.059999998659,30628093.370000001,30628093.370000001]
[]
["Partners Group 2012",50000000,41226491,34277891,8773509,24663244.059999999,21231166.539999999]
["Partners Group 2015",33000000,25740036,3865941,7259964,33819742.219999999,29113468.52]
[]
["ARES CAPITAL INFRASTRUCTURE DEBT FUND   III (EUR)LP",32000000,30556001,18622624,1443999,17512088.989999998,15075148.949999999]
["ARES INFRASTRUCTURE DEBT FUND IV (EUR)",35000000,33286362,15383128,1713638,31278326.789999999,26925710.32]
[]
["Allianz UK Infrastructure Debt 2 LP",28000000,18708241,1228849,9291759,17183249.73,17183249.73]
[]
["JP Morgan Infrastructure Investments Fund",93500000,80000000,12242997.890000001,13500000,78034272.269999996,64254825.039999999]
[]
["IFM Global Infrastructure (UK) B, L.P.",60000000,60000000,4478622.4000000004,0,82409385.299999997,82409385.299999997]
[]
["Foresight",50000000,22139186.960000001,0,27860813.039999999,21357610.800000001,21357610.800000001]
[]
["CAMBRIDGE BUILDING SOCIETY",null,null,null,null,15000000,15000000]
["THE CAMBRIDGE & COUNTIES BANK",null,null,null,null,85000000,85000000]
[]
[null,null,null,null,null,null,{"$f":"SUM(G5:G72)","v":873579179.4000001}]