{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Contents","Styles","Inputs>>>","Profitability","CPI data","Output>>>","EBITDA Summary"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":50,"defined_names":3966,"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":"Contents","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,1,11,2],[12,1,12,2],[13,1,13,2],[18,0,18,2],[14,1,14,2]]}
[]
[null,null,"EBITDA Calculation for ALF Review Consultation "]
[]
["Information"]
[]
["Title ","EBITDA Calculation for ALF Review Consultation "]
["Objective","Calculate EBITDA for MNOs for ALF Review"]
["Confidentiality","Non-confidential Ofcom model"]
[]
["Contents"]
[]
["Worksheet","Description"]
["Profitability","Profitability data from MNO financial statements"]
["CPI data","CPI data sourced from the ONS"]
["EBITDA Summary","Real EBITDA calculations for the MNOs"]
[]
["Terms and conditions"]
[]
["The terms and conditions on which OFCOM is making available this model are set out below.\n\nThe EBITDA Calculation model ('the Model') has been developed to estimate MNOs real EBITDA based on published financial statements. The Model is provided as part of the explanation of OFCOM’s proposals in its consultation “Review of Annual Licence Fees”, dated 13 December 2024.\n\nWhile you may freely use the Model for the purposes for which it is provided, as set out in any accompanying model documentation, OFCOM does not guarantee that the Model will function when used in any modified way.\n\nNo representation or warranty is given as to the accuracy, completeness or correctness of the provided Model and it is provided 'as is'. It is provided without any representation or endorsement made and without warranty of any kind, whether express or implied, including but not limited to the implied warranties of satisfactory quality, fitness for a particular purpose, non-infringement, compatibility, security and accuracy.\n\nOFCOM does not accept any responsibility for any loss, disruption or damage to your data or your computer system which may occur whilst using the Model or material derived from the Model. OFCOM does not warrant that the functions contained in the Model will be uninterrupted or error free. Also, OFCOM does not warrant that defects will be corrected, or that the Model provided is free of viruses.\n\nIn no event will OFCOM be liable for any loss or damage including, without limitation, indirect or consequential loss or damage, or any loss or damages whatsoever arising from use or loss of use of, data or profits arising out of or in connection with the use or otherwise of the provided Model. By using the Model, you agree to the above."]

{"sheet":"Styles","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Styles"]
[]
[]
[null,"Input data",100,null,"Input data (e.g. RFS data, inflation, etc)"]
[]
[null,"Input assumption or parameter",100,null,"Input assumptions or parameters (e.g. for a scenario or control sheet)"]
[]
[null,"Feed internal",100,null,"Feed cell from within this workbook"]
[]
[null,"Feed external",100,null,"Feed cell from a different workbook"]
[]
[null,"Confidential",100,null,"Confidential data, to be removed or randomized before publication"]
[]
[null,"Randomized",100,null,"Randomized data"]
[]
[null,"Calculation",100,null,"Intermediate calculation (not final output)"]
[]
[null,"Model logic",100,null,"Cells required for model logic (e.g. year counters)"]
[]
[null,"Intentionally blank",null,null,"Cells left intentionally blank"]
[]
[null,"Output",100,null,"A key result from this part of the model (in particular one that will be used elsewhere in the model)"]
[]
[null,"Highlight",100,null,"A cell that is highlighted for uncertainty"]
[]
[null,"QA highlight",100,null,"A cell that is highlighted for quality assurance"]
[]
[null,"Check pass",true,null,"A side calculation intended solely to cross check a result (and which therefore should not be referenced anywhere else in the model)"]
[null,"Check fail",false]
[]
[null,"Note or source","Text",null,"Note/source"]
[]
[null,"Named range",null,null,"Cells which are part of a named range"]
[]
[null,"Name","named_range_1",null,"An Excel Name applying to one or more adjacent cells (use Insert Name Create to actually create the Excel Names)"]
[]
[null,"Un-format",null,null,"Going back to default Excel formatting"]

{"sheet":"Inputs>>>","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Profitability","index":3,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[15,1,15,3]]}
["Profitability"]
["Note: 2023 is either year ended 31 March 2024 or 31 December 2023"]
[]
["Vodafone - March year end","VODAFONE LIMITED overview - Find and update company information - GOV.UK (company-information.service.gov.uk)"]
[null,2018,2019,2020,2021,2022,2023]
["Revenue",5512.9,5657.6,5384,5543.2,5810.6,5816]
["Operating profit",{"$f":"-676.8","v":-676.8},{"$f":"-351.5","v":-351.5},186.8,-317.7,16.5,8.3000000000000007]
["Net profit",{"$f":"-587.2","v":-587.20000000000005},{"$f":"-226.2","v":-226.2},276,136.9,-3.1,11.3]
["Exceptionals ",-114.9,-6.1,{"$f":"678.5-145.7+1.4","v":534.19999999999993},-137,-181.5]
["Amortisation of Spectrum",402.1,410.3,433.3,334.9,94.9,81.400000000000006]
["Total depreciation and amortisation ",{"$f":"641.4+402.1+209.5","v":1253},{"$f":"579.9+498.6+410.3+216","v":1704.8},{"$f":"568.5+583.7+433.3+193.8","v":1779.3},{"$f":"334.9+185.7+523.1+631.3","v":1674.9999999999998},{"$f":"509.9+668.7+94.9+194.8","v":1468.3},{"$f":"475.6+705.6+81.4+238.2","v":1500.8000000000002}]
["Adjusted EBITDAaL",1127.7,1304.7,1123,1123,1153.4000000000001,1180.5]
["Estimate for EBITDA",{"$f":"B7+B11","v":576.20000000000005},{"$f":"C7+C11","v":1353.3},1966.1,1357.2999999999997,1484.8,{"$f":"G7+G11","v":1509.1000000000001}]
["Estimated EBITDA margin (%)",{"$f":"B13/B6","v":0.10451849298917087},{"$f":"C13/C6","v":0.23920036764705879},0.36517459138187219,0.24485856544955978,0.25553299142945651,0.25947386519944982]
[]
["Telefonica - December year end","O2 HOLDINGS LIMITED overview - Find and update company information - GOV.UK (company-information.service.gov.uk)",null,null,"TELEFONICA UK LIMITED filing history - Find and update company information - GOV.UK (company-information.service.gov.uk)"]
[null,2018,2019,2020,2021,2022,2023]
["Revenue",6007,6235,5962,5485,5663.18,5945.9669999999996]
["Operating profit",784,824,792,768,1102.3810000000001,1235.0119999999999]
["Net profit",629,641,608,656,1006.037,1592.0719999999999]
["Amortisation of Spectrum",152,158,171,193,88.158000000000001,88.585999999999999]
["Total Depreciation and amortisation",{"$f":"523+298","v":821},{"$f":"536+181+264","v":981},{"$f":"525+19+273","v":817},{"$f":"577+183+310","v":1070},{"$f":"799.928+184.371","v":984.29899999999998},{"$f":"805.757+184.545","v":990.30199999999991}]
["Estimate for EBITDA",{"$f":"B19+B22","v":1605},1805,1609,1838,2086.6800000000003,{"$f":"G19+G22","v":2225.3139999999999}]
["Estimated EBITDA margin (%)",{"$f":"(B19+B22)/B18","v":0.26718828033960379},0.28949478748997592,0.26987588057698758,0.33509571558796719,0.36846436101271729,{"$f":"(G19+G22)/G18","v":0.37425602933887792}]
[]
["Hutchison - December year end","HUTCHISON 3G UK LIMITED overview - Find and update company information - GOV.UK (company-information.service.gov.uk)"]
[null,2018,2019,2020,2021,2022,2023]
["Revenue",2379,2327,2220.3530000000001,2311.3960000000002,2380.2530000000002,2500.4969999999998]
["Operating profit",{"$f":"78.342","v":78.341999999999999},{"$f":"360.319","v":360.31900000000002},175.733,1125.165,94.644000000000005,-73.582999999999998]
["Net profit",{"$f":"72.385","v":72.385000000000005},{"$f":"238.569","v":238.56899999999999},195.21100000000001,1411.644,158.45699999999999,-46.298000000000002]
["Exceptional items",-315.99299999999999,131.85499999999999,0,1078.2,0]
["Amortisation of Spectrum",0,0,0,0,0]
["Total depreciation and amortisation",{"$f":"111.386+250.776","v":362.16200000000003},{"$f":"101.483+60.691+288.458","v":450.63200000000006},{"$f":"107.737+19.35+82.463+282.113","v":491.66300000000001},{"$f":"142.512+48.492+87.586+269.842","v":548.43200000000002},{"$f":"183.072+57.71+91.23+226.892","v":558.904},{"$f":"238.603+71.016+95.301+265.248","v":670.16800000000001}]
["Reported EBITDA",756,679,648,1725,628,526]
["Estimate for EBITDA",{"$f":"B29+B33-B31","v":756.49700000000007},679.096,667.39599999999996,595.39699999999993,653.548,596.58500000000004]
["Estimated EBITDA margin (%)",{"$f":"B35/B28","v":0.31798949138293403},0.29183326171035667,0.30058103373652745,0.25759194876170066,0.27457081243044329,0.23858656899008479]
[]
["EE - March year end","EE LIMITED filing history - Find and update company information - GOV.UK (company-information.service.gov.uk)"]
[null,2018,2019,2020,2021,2022,2023]
["Revenue",7149,7264,6971,6856,6913,7169]
["Operating profit",1455,1661,1402,1589,1722,1300]
["Net profit",1174,1323,1130,1184,1454,1053]
["Amortisation of Spectrum",104,129,134,150,157,157]
["Total depreciation and amortisation",{"$f":"195+440","v":635},{"$f":"209+469+171","v":849},911,1016,990,1039]
["Reported EBITDA",2090,2510,2462,2605,2712,2358]
["Reported EBITDA margin",{"$f":"B45/B40","v":0.29234858022100996},0.34553964757709249,0.35317744943336682,0.37995915985997664,0.39230435411543468,0.32891616682940439]
["Estimate for EBITDA",{"$f":"B41+B44","v":2090},2510,2313,2605,2712,2339]
["Estimated EBITDA margin (%)",{"$f":"B47/B40","v":0.29234858022100996},0.34553964757709249,0.33180318462200548,0.37995915985997664,0.39230435411543468,0.32626586692704701]

{"sheet":"CPI data","index":4,"n_rows":629,"n_cols":2,"rows_kept":629,"cut":false,"hidden":false,"merged":[]}
["Title","CPI INDEX 00: ALL ITEMS 2015=100"]
["CDID","D7BT"]
["Source dataset ID","MM23"]
["PreUnit",""]
["Unit","Index, base year = 100"]
["Release date","14-08-2024"]
["Next release","18 September 2024"]
["Important notes"]
["1988",49.6]
["1989",52.2]
["1990",55.9]
["1991",60.1]
["1992",62.6]
["1993",64.2]
["1994",65.5]
["1995",67.2]
["1996",68.8]
["1997",70.099999999999994]
["1998",71.2]
["1999",72.099999999999994]
["2000",72.7]
["2001",73.599999999999994]
["2002",74.5]
["2003",75.5]
["2004",76.5]
["2005",78.099999999999994]
["2006",79.900000000000006]
["2007",81.8]
["2008",84.7]
["2009",86.6]
["2010",89.4]
["2011",93.4]
["2012",96.1]
["2013",98.5]
["2014",100]
["2015",100]
["2016",100.7]
["2017",103.4]
["2018",105.9]
["2019",107.8]
["2020",108.7]
["2021",111.6]
["2022",121.7]
["2023",130.5]
["1988 Q1",48.6]
["1988 Q2",49.5]
["1988 Q3",49.9]
["1988 Q4",50.5]
["1989 Q1",51]
["1989 Q2",52.1]
["1989 Q3",52.5]
["1989 Q4",53.3]
["1990 Q1",53.9]
["1990 Q2",55.6]
["1990 Q3",56.4]
["1990 Q4",57.5]
["1991 Q1",57.7]
["1991 Q2",60.3]
["1991 Q3",60.8]
["1991 Q4",61.5]
["1992 Q1",61.7]
["1992 Q2",62.8]
["1992 Q3",62.7]
["1992 Q4",63.1]
["1993 Q1",63.2]
["1993 Q2",64.400000000000006]
["1993 Q3",64.5]
["1993 Q4",64.7]
["1994 Q1",64.7]
["1994 Q2",65.7]
["1994 Q3",65.599999999999994]
["1994 Q4",65.8]
["1995 Q1",66.3]
["1995 Q2",67.3]
["1995 Q3",67.400000000000006]
["1995 Q4",67.7]
["1996 Q1",68.099999999999994]
["1996 Q2",68.900000000000006]
["1996 Q3",68.900000000000006]
["1996 Q4",69.400000000000006]
["1997 Q1",69.400000000000006]
["1997 Q2",70]
["1997 Q3",70.3]
["1997 Q4",70.599999999999994]
["1998 Q1",70.5]
["1998 Q2",71.3]
["1998 Q3",71.2]
["1998 Q4",71.599999999999994]
["1999 Q1",71.599999999999994]
["1999 Q2",72.3]
["1999 Q3",72.099999999999994]
["1999 Q4",72.5]
["2000 Q1",72.099999999999994]
["2000 Q2",72.7]
["2000 Q3",72.7]
["2000 Q4",73.2]
["2001 Q1",72.8]
["2001 Q2",73.8]
["2001 Q3",73.8]
["2001 Q4",73.900000000000006]
["2002 Q1",73.900000000000006]
["2002 Q2",74.5]
["2002 Q3",74.599999999999994]
["2002 Q4",75]
["2003 Q1",75]
["2003 Q2",75.5]
["2003 Q3",75.599999999999994]
["2003 Q4",76]
["2004 Q1",75.900000000000006]
["2004 Q2",76.5]
["2004 Q3",76.599999999999994]
["2004 Q4",77.099999999999994]
["2005 Q1",77.3]
["2005 Q2",78]
["2005 Q3",78.400000000000006]
["2005 Q4",78.8]
["2006 Q1",78.7]
["2006 Q2",79.8]
["2006 Q3",80.3]
["2006 Q4",80.900000000000006]
["2007 Q1",81]
["2007 Q2",81.8]
["2007 Q3",81.7]
["2007 Q4",82.6]
["2008 Q1",82.9]
["2008 Q2",84.6]
["2008 Q3",85.7]
["2008 Q4",85.8]
["2009 Q1",85.4]
["2009 Q2",86.4]
["2009 Q3",86.9]
["2009 Q4",87.6]
["2010 Q1",88.2]
["2010 Q2",89.3]
["2010 Q3",89.6]
["2010 Q4",90.5]
["2011 Q1",91.8]
["2011 Q2",93.3]
["2011 Q3",93.8]
["2011 Q4",94.7]
["2012 Q1",95.1]
["2012 Q2",95.8]
["2012 Q3",96.1]
["2012 Q4",97.3]
["2013 Q1",97.7]
["2013 Q2",98.4]
["2013 Q3",98.7]
["2013 Q4",99.3]
["2014 Q1",99.4]
["2014 Q2",100.1]
["2014 Q3",100.1]
["2014 Q4",100.2]
["2015 Q1",99.5]
["2015 Q2",100.1]
["2015 Q3",100.1]
["2015 Q4",100.3]
["2016 Q1",99.8]
["2016 Q2",100.4]
["2016 Q3",100.9]
["2016 Q4",101.5]
["2017 Q1",102]
["2017 Q2",103.2]
["2017 Q3",103.7]
["2017 Q4",104.6]
["2018 Q1",104.7]
["2018 Q2",105.7]
["2018 Q3",106.3]
["2018 Q4",106.9]
["2019 Q1",106.7]
["2019 Q2",107.8]
["2019 Q3",108.3]
["2019 Q4",108.5]
["2020 Q1",108.5]
["2020 Q2",108.5]
["2020 Q3",108.9]
["2020 Q4",109]
["2021 Q1",109.2]
["2021 Q2",110.7]
["2021 Q3",111.9]
["2021 Q4",114.4]
["2022 Q1",115.9]
["2022 Q2",120.9]
["2022 Q3",123.2]
["2022 Q4",126.7]
["2023 Q1",127.7]
["2023 Q2",131.1]
["2023 Q3",131.4]
["2023 Q4",132]
["2024 Q1",132.30000000000001]
["2024 Q2",133.80000000000001]
["1988 JAN",48.4]
["1988 FEB",48.6]
["1988 MAR",48.7]
["1988 APR",49.3]
["1988 MAY",49.5]
["1988 JUN",49.7]
["1988 JUL",49.7]
["1988 AUG",49.9]
["1988 SEP",50.1]
["1988 OCT",50.3]
["1988 NOV",50.5]
["1988 DEC",50.6]
["1989 JAN",50.8]
["1989 FEB",51]
["1989 MAR",51.2]
["1989 APR",51.9]
["1989 MAY",52.2]
["1989 JUN",52.3]
["1989 JUL",52.3]
["1989 AUG",52.4]
["1989 SEP",52.7]
["1989 OCT",53.1]
["1989 NOV",53.3]
["1989 DEC",53.4]
["1990 JAN",53.6]
["1990 FEB",54]
["1990 MAR",54.2]
["1990 APR",55.2]
["1990 MAY",55.7]
["1990 JUN",55.9]
["1990 JUL",55.8]
["1990 AUG",56.4]
["1990 SEP",57]
["1990 OCT",57.4]
["1990 NOV",57.5]
["1990 DEC",57.5]
["1991 JAN",57.4]
["1991 FEB",57.7]
["1991 MAR",57.9]
["1991 APR",59.9]
["1991 MAY",60.3]
["1991 JUN",60.6]
["1991 JUL",60.5]
["1991 AUG",60.9]
["1991 SEP",61.1]
["1991 OCT",61.3]
["1991 NOV",61.5]
["1991 DEC",61.6]
["1992 JAN",61.4]
["1992 FEB",61.7]
["1992 MAR",62]
["1992 APR",62.7]
["1992 MAY",62.9]
["1992 JUN",62.9]
["1992 JUL",62.6]
["1992 AUG",62.7]
["1992 SEP",62.9]
["1992 OCT",63.1]
["1992 NOV",63.1]
["1992 DEC",63.2]
["1993 JAN",62.8]
["1993 FEB",63.2]
["1993 MAR",63.6]
["1993 APR",64.3]
["1993 MAY",64.5]
["1993 JUN",64.5]
["1993 JUL",64.2]
["1993 AUG",64.5]
["1993 SEP",64.8]
["1993 OCT",64.7]
["1993 NOV",64.599999999999994]
["1993 DEC",64.7]
["1994 JAN",64.5]
["1994 FEB",64.8]
["1994 MAR",65]
["1994 APR",65.5]
["1994 MAY",65.8]
["1994 JUN",65.8]
["1994 JUL",65.400000000000006]
["1994 AUG",65.7]
["1994 SEP",65.8]
["1994 OCT",65.7]
["1994 NOV",65.7]
["1994 DEC",66]
["1995 JAN",66]
["1995 FEB",66.3]
["1995 MAR",66.7]
["1995 APR",67]
["1995 MAY",67.400000000000006]
["1995 JUN",67.400000000000006]
["1995 JUL",67.099999999999994]
["1995 AUG",67.400000000000006]
["1995 SEP",67.7]
["1995 OCT",67.599999999999994]
["1995 NOV",67.599999999999994]
["1995 DEC",68]
["1996 JAN",67.8]
["1996 FEB",68.099999999999994]
["1996 MAR",68.400000000000006]
["1996 APR",68.7]
["1996 MAY",68.900000000000006]
["1996 JUN",69]
["1996 JUL",68.599999999999994]
["1996 AUG",68.900000000000006]
["1996 SEP",69.3]
["1996 OCT",69.3]
["1996 NOV",69.3]
["1996 DEC",69.5]
["1997 JAN",69.2]
["1997 FEB",69.400000000000006]
["1997 MAR",69.5]
["1997 APR",69.8]
["1997 MAY",70]
["1997 JUN",70.2]
["1997 JUL",69.900000000000006]
["1997 AUG",70.3]
["1997 SEP",70.599999999999994]
["1997 OCT",70.599999999999994]
["1997 NOV",70.599999999999994]
["1997 DEC",70.7]
["1998 JAN",70.3]
["1998 FEB",70.5]
["1998 MAR",70.7]
["1998 APR",71.099999999999994]
["1998 MAY",71.400000000000006]
["1998 JUN",71.3]
["1998 JUL",71]
["1998 AUG",71.2]
["1998 SEP",71.5]
["1998 OCT",71.5]
["1998 NOV",71.599999999999994]
["1998 DEC",71.8]
["1999 JAN",71.400000000000006]
["1999 FEB",71.5]
["1999 MAR",71.900000000000006]
["1999 APR",72.2]
["1999 MAY",72.400000000000006]
["1999 JUN",72.3]
["1999 JUL",71.900000000000006]
["1999 AUG",72.099999999999994]
["1999 SEP",72.400000000000006]
["1999 OCT",72.3]
["1999 NOV",72.400000000000006]
["1999 DEC",72.599999999999994]
["2000 JAN",71.900000000000006]
["2000 FEB",72.2]
["2000 MAR",72.3]
["2000 APR",72.599999999999994]
["2000 MAY",72.8]
["2000 JUN",72.900000000000006]
["2000 JUL",72.5]
["2000 AUG",72.5]
["2000 SEP",73.099999999999994]
["2000 OCT",73.099999999999994]
["2000 NOV",73.2]
["2000 DEC",73.2]
["2001 JAN",72.599999999999994]
["2001 FEB",72.7]
["2001 MAR",73]
["2001 APR",73.400000000000006]
["2001 MAY",74]
["2001 JUN",74.099999999999994]
["2001 JUL",73.599999999999994]
["2001 AUG",73.900000000000006]
["2001 SEP",74.099999999999994]
["2001 OCT",73.900000000000006]
["2001 NOV",73.8]
["2001 DEC",74]
["2002 JAN",73.7]
["2002 FEB",73.8]
["2002 MAR",74.099999999999994]
["2002 APR",74.400000000000006]
["2002 MAY",74.599999999999994]
["2002 JUN",74.599999999999994]
["2002 JUL",74.400000000000006]
["2002 AUG",74.599999999999994]
["2002 SEP",74.8]
["2002 OCT",74.900000000000006]
["2002 NOV",74.900000000000006]
["2002 DEC",75.2]
["2003 JAN",74.7]
["2003 FEB",75]
["2003 MAR",75.3]
["2003 APR",75.5]
["2003 MAY",75.5]
["2003 JUN",75.400000000000006]
["2003 JUL",75.3]
["2003 AUG",75.599999999999994]
["2003 SEP",75.900000000000006]
["2003 OCT",76]
["2003 NOV",75.900000000000006]
["2003 DEC",76.2]
["2004 JAN",75.8]
["2004 FEB",76]
["2004 MAR",76.099999999999994]
["2004 APR",76.400000000000006]
["2004 MAY",76.599999999999994]
["2004 JUN",76.599999999999994]
["2004 JUL",76.400000000000006]
["2004 AUG",76.599999999999994]
["2004 SEP",76.7]
["2004 OCT",76.900000000000006]
["2004 NOV",77]
["2004 DEC",77.400000000000006]
["2005 JAN",77]
["2005 FEB",77.2]
["2005 MAR",77.5]
["2005 APR",77.8]
["2005 MAY",78.099999999999994]
["2005 JUN",78.099999999999994]
["2005 JUL",78.2]
["2005 AUG",78.400000000000006]
["2005 SEP",78.599999999999994]
["2005 OCT",78.7]
["2005 NOV",78.7]
["2005 DEC",78.900000000000006]
["2006 JAN",78.5]
["2006 FEB",78.8]
["2006 MAR",78.900000000000006]
["2006 APR",79.400000000000006]
["2006 MAY",79.900000000000006]
["2006 JUN",80.099999999999994]
["2006 JUL",80]
["2006 AUG",80.400000000000006]
["2006 SEP",80.5]
["2006 OCT",80.599999999999994]
["2006 NOV",80.8]
["2006 DEC",81.3]
["2007 JAN",80.599999999999994]
["2007 FEB",81]
["2007 MAR",81.400000000000006]
["2007 APR",81.599999999999994]
["2007 MAY",81.8]
["2007 JUN",82]
["2007 JUL",81.5]
["2007 AUG",81.8]
["2007 SEP",81.900000000000006]
["2007 OCT",82.3]
["2007 NOV",82.5]
["2007 DEC",83]
["2008 JAN",82.4]
["2008 FEB",83]
["2008 MAR",83.4]
["2008 APR",84]
["2008 MAY",84.6]
["2008 JUN",85.2]
["2008 JUL",85.1]
["2008 AUG",85.7]
["2008 SEP",86.1]
["2008 OCT",85.9]
["2008 NOV",85.8]
["2008 DEC",85.5]
["2009 JAN",84.9]
["2009 FEB",85.6]
["2009 MAR",85.8]
["2009 APR",86]
["2009 MAY",86.4]
["2009 JUN",86.7]
["2009 JUL",86.7]
["2009 AUG",87]
["2009 SEP",87.1]
["2009 OCT",87.2]
["2009 NOV",87.5]
["2009 DEC",88]
["2010 JAN",87.8]
["2010 FEB",88.2]
["2010 MAR",88.7]
["2010 APR",89.2]
["2010 MAY",89.4]
["2010 JUN",89.5]
["2010 JUL",89.3]
["2010 AUG",89.8]
["2010 SEP",89.8]
["2010 OCT",90]
["2010 NOV",90.3]
["2010 DEC",91.2]
["2011 JAN",91.3]
["2011 FEB",92]
["2011 MAR",92.2]
["2011 APR",93.2]
["2011 MAY",93.4]
["2011 JUN",93.3]
["2011 JUL",93.3]
["2011 AUG",93.8]
["2011 SEP",94.4]
["2011 OCT",94.5]
["2011 NOV",94.6]
["2011 DEC",95.1]
["2012 JAN",94.6]
["2012 FEB",95.1]
["2012 MAR",95.4]
["2012 APR",96]
["2012 MAY",95.9]
["2012 JUN",95.5]
["2012 JUL",95.6]
["2012 AUG",96.1]
["2012 SEP",96.5]
["2012 OCT",97]
["2012 NOV",97.2]
["2012 DEC",97.6]
["2013 JAN",97.1]
["2013 FEB",97.8]
["2013 MAR",98.1]
["2013 APR",98.3]
["2013 MAY",98.5]
["2013 JUN",98.3]
["2013 JUL",98.3]
["2013 AUG",98.7]
["2013 SEP",99.1]
["2013 OCT",99.1]
["2013 NOV",99.2]
["2013 DEC",99.6]
["2014 JAN",99]
["2014 FEB",99.5]
["2014 MAR",99.7]
["2014 APR",100.1]
["2014 MAY",100]
["2014 JUN",100.2]
["2014 JUL",99.9]
["2014 AUG",100.2]
["2014 SEP",100.3]
["2014 OCT",100.4]
["2014 NOV",100.1]
["2014 DEC",100.1]
["2015 JAN",99.3]
["2015 FEB",99.5]
["2015 MAR",99.7]
["2015 APR",99.9]
["2015 MAY",100.1]
["2015 JUN",100.2]
["2015 JUL",100]
["2015 AUG",100.3]
["2015 SEP",100.2]
["2015 OCT",100.3]
["2015 NOV",100.3]
["2015 DEC",100.3]
["2016 JAN",99.5]
["2016 FEB",99.8]
["2016 MAR",100.2]
["2016 APR",100.2]
["2016 MAY",100.4]
["2016 JUN",100.6]
["2016 JUL",100.6]
["2016 AUG",100.9]
["2016 SEP",101.1]
["2016 OCT",101.2]
["2016 NOV",101.4]
["2016 DEC",101.9]
["2017 JAN",101.4]
["2017 FEB",102.1]
["2017 MAR",102.5]
["2017 APR",102.9]
["2017 MAY",103.3]
["2017 JUN",103.3]
["2017 JUL",103.2]
["2017 AUG",103.8]
["2017 SEP",104.1]
["2017 OCT",104.2]
["2017 NOV",104.6]
["2017 DEC",104.9]
["2018 JAN",104.4]
["2018 FEB",104.9]
["2018 MAR",105]
["2018 APR",105.4]
["2018 MAY",105.8]
["2018 JUN",105.8]
["2018 JUL",105.8]
["2018 AUG",106.5]
["2018 SEP",106.6]
["2018 OCT",106.7]
["2018 NOV",107]
["2018 DEC",107.1]
["2019 JAN",106.3]
["2019 FEB",106.8]
["2019 MAR",107]
["2019 APR",107.6]
["2019 MAY",107.9]
["2019 JUN",107.9]
["2019 JUL",107.9]
["2019 AUG",108.4]
["2019 SEP",108.5]
["2019 OCT",108.3]
["2019 NOV",108.5]
["2019 DEC",108.5]
["2020 JAN",108.2]
["2020 FEB",108.6]
["2020 MAR",108.6]
["2020 APR",108.5]
["2020 MAY",108.5]
["2020 JUN",108.6]
["2020 JUL",109.1]
["2020 AUG",108.6]
["2020 SEP",109.1]
["2020 OCT",109.1]
["2020 NOV",108.9]
["2020 DEC",109.2]
["2021 JAN",109]
["2021 FEB",109.1]
["2021 MAR",109.4]
["2021 APR",110.1]
["2021 MAY",110.8]
["2021 JUN",111.3]
["2021 JUL",111.3]
["2021 AUG",112.1]
["2021 SEP",112.4]
["2021 OCT",113.6]
["2021 NOV",114.5]
["2021 DEC",115.1]
["2022 JAN",114.9]
["2022 FEB",115.8]
["2022 MAR",117.1]
["2022 APR",120]
["2022 MAY",120.8]
["2022 JUN",121.8]
["2022 JUL",122.5]
["2022 AUG",123.1]
["2022 SEP",123.8]
["2022 OCT",126.2]
["2022 NOV",126.7]
["2022 DEC",127.2]
["2023 JAN",126.4]
["2023 FEB",127.9]
["2023 MAR",128.9]
["2023 APR",130.4]
["2023 MAY",131.30000000000001]
["2023 JUN",131.5]
["2023 JUL",130.9]
["2023 AUG",131.30000000000001]
["2023 SEP",132]
["2023 OCT",132]
["2023 NOV",131.69999999999999]
["2023 DEC",132.19999999999999]
["2024 JAN",131.5]
["2024 FEB",132.30000000000001]
["2024 MAR",133]
["2024 APR",133.5]
["2024 MAY",133.9]
["2024 JUN",134.1]
["2024 JUL",133.80000000000001]

{"sheet":"Output>>>","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"EBITDA Summary","index":6,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["EBITDA calculations"]
[]
[null,"Ofcom estimated EBITDA (£m)","2018","2019","2020","2021","2022","2023"]
[null,"Vodafone",{"$f":"Profitability!B13","v":576.20000000000005},{"$f":"Profitability!C13","v":1353.3},{"$f":"Profitability!D13","v":1966.1},{"$f":"Profitability!E13","v":1357.2999999999997},{"$f":"Profitability!F13","v":1484.8},{"$f":"Profitability!G13","v":1509.1000000000001}]
[null,"Telefonica",{"$f":"Profitability!B23","v":1605},{"$f":"Profitability!C23","v":1805},{"$f":"Profitability!D23","v":1609},{"$f":"Profitability!E23","v":1838},{"$f":"Profitability!F23","v":2086.6800000000003},{"$f":"Profitability!G23","v":2225.3139999999999}]
[null,"Hutchison 3G",{"$f":"Profitability!B35","v":756.49700000000007},{"$f":"Profitability!C35","v":679.096},{"$f":"Profitability!D35","v":667.39599999999996},{"$f":"Profitability!E35","v":595.39699999999993},{"$f":"Profitability!F35","v":653.548},{"$f":"Profitability!G35","v":596.58500000000004}]
[null,"EE",{"$f":"Profitability!B47","v":2090},{"$f":"Profitability!C47","v":2510},{"$f":"Profitability!D47","v":2313},{"$f":"Profitability!E47","v":2605},{"$f":"Profitability!F47","v":2712},{"$f":"Profitability!G47","v":2339}]
[null,"Total ",{"$f":"SUM(C4:C7)","v":5027.6970000000001},{"$f":"SUM(D4:D7)","v":6347.3960000000006},6555.4960000000001,6395.6970000000001,6937.0280000000002,6669.9989999999998]
[]
[null,"Ofcom estimated EBITDA margin %"]
[null,"Vodafone",{"$f":"Profitability!B14","v":0.10451849298917087},{"$f":"Profitability!C14","v":0.23920036764705879},{"$f":"Profitability!D14","v":0.36517459138187219},{"$f":"Profitability!E14","v":0.24485856544955978},{"$f":"Profitability!F14","v":0.25553299142945651},{"$f":"Profitability!G14","v":0.25947386519944982}]
[null,"Telefonica",{"$f":"Profitability!B24","v":0.26718828033960379},{"$f":"Profitability!C24","v":0.28949478748997592},{"$f":"Profitability!D24","v":0.26987588057698758},{"$f":"Profitability!E24","v":0.33509571558796719},{"$f":"Profitability!F24","v":0.36846436101271729},{"$f":"Profitability!G24","v":0.37425602933887792}]
[null,"Hutchison 3G",{"$f":"Profitability!B36","v":0.31798949138293403},{"$f":"Profitability!C36","v":0.29183326171035667},{"$f":"Profitability!D36","v":0.30058103373652745},{"$f":"Profitability!E36","v":0.25759194876170066},{"$f":"Profitability!F36","v":0.27457081243044329},{"$f":"Profitability!G36","v":0.23858656899008479}]
[null,"EE",{"$f":"Profitability!B48","v":0.29234858022100996},{"$f":"Profitability!C48","v":0.34553964757709249},{"$f":"Profitability!D48","v":0.33180318462200548},{"$f":"Profitability!E48","v":0.37995915985997664},{"$f":"Profitability!F48","v":0.39230435411543468},{"$f":"Profitability!G48","v":0.32626586692704701}]
[null,"Average EBITDA margin",{"$f":"C8/SUM(Profitability!B6,Profitability!B18,Profitability!B28,Profitability!B40)","v":0.23886929337368573},{"$f":"D8/SUM(Profitability!C6,Profitability!C18,Profitability!C28,Profitability!C40)","v":0.29545308979873025},{"$f":"E8/SUM(Profitability!D6,Profitability!D18,Profitability!D28,Profitability!D40)","v":0.3191986815438192},{"$f":"F8/SUM(Profitability!E6,Profitability!E18,Profitability!E28,Profitability!E40)","v":0.31668770755762787},{"$f":"G8/SUM(Profitability!F6,Profitability!F18,Profitability!F28,Profitability!F40)","v":0.3340403995120535},{"$f":"H8/SUM(Profitability!G6,Profitability!G18,Profitability!G28,Profitability!G40)","v":0.31122460882746972}]
[]
[null,"Ofcom estimated real EBITDA (£m) in 2023 prices"]
[null,"Vodafone",{"$f":"'EBITDA Summary'!C4/VLOOKUP(C$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":710.04815864022669},{"$f":"'EBITDA Summary'!D4/VLOOKUP(D$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1638.27133580705},{"$f":"'EBITDA Summary'!E4/VLOOKUP(E$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2360.4052437902483},{"$f":"'EBITDA Summary'!F4/VLOOKUP(F$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1587.1653225806449},{"$f":"'EBITDA Summary'!G4/VLOOKUP(G$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1592.1643385373868},{"$f":"'EBITDA Summary'!H4/VLOOKUP(H$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1509.1000000000004}]
[null,"Telefonica",{"$f":"'EBITDA Summary'!C5/VLOOKUP(C$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1977.8328611898016},{"$f":"'EBITDA Summary'!D5/VLOOKUP(D$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2185.0881261595546},{"$f":"'EBITDA Summary'!E5/VLOOKUP(E$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":1931.6881324747008},{"$f":"'EBITDA Summary'!F5/VLOOKUP(F$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2149.2741935483873},{"$f":"'EBITDA Summary'!G5/VLOOKUP(G$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2237.5656532456865},{"$f":"'EBITDA Summary'!H5/VLOOKUP(H$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2225.3139999999999}]
[null,"Hutchison 3G",{"$f":"'EBITDA Summary'!C6/VLOOKUP(C$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":932.22718130311625},{"$f":"'EBITDA Summary'!D6/VLOOKUP(D$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":822.09673469387758},{"$f":"'EBITDA Summary'!E6/VLOOKUP(E$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":801.24358785648565},{"$f":"'EBITDA Summary'!F6/VLOOKUP(F$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":696.2303629032258},{"$f":"'EBITDA Summary'!G6/VLOOKUP(G$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":700.80537387017262},{"$f":"'EBITDA Summary'!H6/VLOOKUP(H$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":596.58500000000004}]
[null,"EE",{"$f":"'EBITDA Summary'!C7/VLOOKUP(C$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2575.4957507082154},{"$f":"'EBITDA Summary'!D7/VLOOKUP(D$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":3038.543599257885},{"$f":"'EBITDA Summary'!E7/VLOOKUP(E$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2776.8767249310026},{"$f":"'EBITDA Summary'!F7/VLOOKUP(F$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":3046.1693548387102},{"$f":"'EBITDA Summary'!G7/VLOOKUP(G$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2908.1018898931798},{"$f":"'EBITDA Summary'!H7/VLOOKUP(H$3,'CPI data'!$A$9:$B$44,2,FALSE)*VLOOKUP(\"2023\", 'CPI data'!$A$9:$B$44,2,FALSE)","v":2339}]
[null,"Total",{"$f":"SUM(C18:C21)","v":6195.60395184136},7683.9997959183675,7870.213689052438,7478.8392338709682,7438.6372555464259,6669.9989999999998]
[]
[null,"% Changes"]
[null,"2018-2023",{"$f":"H22/C22-1","v":7.6569621274395372E-2}]
[null,"2020-2023",{"$f":"H22/E22-1","v":-0.15250090232263336}]