{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Inputs","Data","Summary - Return on assets","Summary - Return on equity","Profitability - Gas Tx"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":327,"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":"Introduction","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,2,9,9],[10,2,10,9],[11,2,11,9],[12,2,12,9],[14,2,14,9],[7,2,7,9],[1,2,1,9],[2,2,2,9],[3,2,3,9],[5,2,5,9],[6,2,6,9]]}
[]
[null,null," Gas transmission pipelines"]
[null,null,"Financial performance data"]
[null,null,"This workbook contains financial performance data for the gas transmission pipelines that are regulated as scheme pipelines. A series of explanatory notes are published alongside this dataset on our website. We encourage stakeholders to read these notes, which detail how we calculate and interpret the profitability measures. "]
[]
[null,null,"Coverage"]
[null,null,"The data covers the regulatory years from 2014 to 2024. Victorian Transmission System (VTS) report on a calendar year basis, and so for these businesses the label 2015 refers to the year ending 31 December 2015. Amadeus Gas Pipeline (AGP) and the Roma to Brisbane Pipeline (RBP) report on a financial year basis, and for these businesses the label 2015 refers to data collected for the year ending 30 June 2015. \n\nAll profitability metrics relate to services provided as a scheme pipeline for gas transmission pipelines.\n\nUnless otherwise stated, all financial values are in nominal dollar terms.\n\n"]
[null,null,"Confidentiality"]
[null,null,"The following revenue and return on assets data have been redacted from this dataset for confidentiality reasons:\n   Amadeus Gas Pipeline - for the entire time series\n   Roma to Brisbane Pipeline - from 2022 to 2024."]
[]
[]
[null,null,"Sources"]
[null,null,"Data sources for the financial and non-financial information used to determine the profitability measures are listed in each of the worksheets."]
[]
[null,null,"Version record"]
[null,null,"Version","Publication date","Data","Profitability measures","Segment"]
[null,null,4.3,"December 2025","Regulatory years 2014 to 2024","RoRE and ROA","Transmission only"]
[null,null,4.2,"December 2024","Regulatory years 2014 to 2023","RoRE and ROA","Transmission only"]
[null,null,4.0999999999999996,"June 2024","Regulatory years 2014 to 2023","RoRE, RoA and EBIT per customer","Distribution only"]
[null,null,3,"December 2023","Regulatory years 2014 to 2022","RoRE, RoA and EBIT per customer","Distribution and Transmission"]
[null,null,2,"December 2022","Regulatory years 2014 to 2021","RoRE, RoA and EBIT per customer","Distribution and Transmission"]
[null,null,1,"December 2021","Regulatory years 2014 to 2020","RoA and EBIT per customer","Distribution only"]

{"sheet":"Inputs","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
["TNSP","Returns from indexation of the RAB","Incentive Schemes","Revenue pass-throughs","Summary headings","Benchmark","Capex"]
["Amadeus Gas Pipeline","Inclusive","Inclusive","Inclusive","Allowed nominal rate of return","Yes","Yes"]
["Roma Brisbane Pipeline","Exclusive","Exclusive","Exclusive","Allowed real rate of return","No","No"]
["Victorian Transmission System",null,null,null,"Allowed nominal return on equity"]
[null,null,null,null,"Allowed real return on equity"]
[null,null,null,null,"Nominal return on assets"]
[null,null,null,null,"Real return on assets"]
[null,null,null,null,"Nominal return on regulated equity"]
[null,null,null,null,"Real return on regulated equity"]

{"sheet":"Data","index":2,"n_rows":704,"n_cols":4,"rows_kept":704,"cut":false,"hidden":false,"merged":[]}
["Trading Name",null,"Year","Value"]
["Amadeus Gas Pipeline","Indexation",2014,3109779.2868840499]
["Amadeus Gas Pipeline","Indexation",2015,1429683.78057955]
["Amadeus Gas Pipeline","Indexation",2016,1407669.89889095]
["Amadeus Gas Pipeline","Indexation",2017,1709473.3181253001]
["Amadeus Gas Pipeline","Indexation",2018,2278575.8845333699]
["Amadeus Gas Pipeline","Indexation",2019,2135977.4389172401]
["Amadeus Gas Pipeline","Indexation",2020,2255960.9681442198]
["Amadeus Gas Pipeline","Indexation",2021,1129387.66721866]
["Amadeus Gas Pipeline","Indexation",2022,4463253.7010411797]
["Amadeus Gas Pipeline","Inflation rate",2014,2.9296900000000001E-2]
["Amadeus Gas Pipeline","Inflation rate",2015,1.32827E-2]
["Amadeus Gas Pipeline","Inflation rate",2016,1.31086E-2]
["Amadeus Gas Pipeline","Inflation rate",2017,1.47601E-2]
["Amadeus Gas Pipeline","Inflation rate",2018,1.9090900000000001E-2]
["Amadeus Gas Pipeline","Inflation rate",2019,1.7841200000000002E-2]
["Amadeus Gas Pipeline","Inflation rate",2020,1.8404899999999998E-2]
["Amadeus Gas Pipeline","Inflation rate",2021,8.6058999999999997E-3]
["Amadeus Gas Pipeline","Inflation rate",2022,3.4982899999999997E-2]
["Amadeus Gas Pipeline","Inflation rate",2024,4.0519877675840865E-2]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2014,5635374.2433018684]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2015,5864832.8439174062]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2016,3381143.9242010978]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2017,3509657.1845646985]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2018,3812538.6796056172]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2019,4008104.4425311699]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2020,4203322.5477896715]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2021,4410630.358515406]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2022,4362193.6503275735]
["Amadeus Gas Pipeline","Nominal straight line depreciation",2024,5228369.4794307947]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2014,106147132.992309]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2015,107634764.623615]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2016,107385103.71539301]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2017,115816817.302958]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2018,119353974.90412401]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2019,119721535.451296]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2020,122573879.26917]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2021,131234846.930748]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2022,127583739.941971]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2024,147303164.780763]
["Amadeus Gas Pipeline","Operating expenditure",2014,11412055.4549769]
["Amadeus Gas Pipeline","Operating expenditure",2015,11669200.226063799]
["Amadeus Gas Pipeline","Operating expenditure",2016,12125176.575495901]
["Amadeus Gas Pipeline","Operating expenditure",2017,12221570.514673101]
["Amadeus Gas Pipeline","Operating expenditure",2018,11748571.7381527]
["Amadeus Gas Pipeline","Operating expenditure",2019,12049037.2354184]
["Amadeus Gas Pipeline","Operating expenditure",2020,12198028.389327001]
["Amadeus Gas Pipeline","Operating expenditure",2021,10981058.6931371]
["Amadeus Gas Pipeline","Operating expenditure",2022,12991294.478964999]
["Amadeus Gas Pipeline","Operating expenditure",2024,14457007.31675612]
["Amadeus Gas Pipeline","allowed nominal rate of return",2014,0.108738455774864]
["Amadeus Gas Pipeline","allowed nominal rate of return",2015,0.108738455774864]
["Amadeus Gas Pipeline","allowed nominal rate of return",2016,0.108738455774864]
["Amadeus Gas Pipeline","allowed nominal rate of return",2017,6.6196480115324002E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2018,6.5911429637089E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2019,6.5270291956785007E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2020,6.4489934340061006E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2021,6.2861517215951998E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2022,5.0806944651709998E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2024,5.0335359885633785E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2014,8.1168655070564005E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2015,8.1168655070564005E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2016,8.1168655070564005E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2017,4.1300228208348999E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2018,4.1021833809593997E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2019,4.0395667033332999E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2020,3.9633531179826001E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2021,3.8043138457118E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2022,3.0209075738066998E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2024,2.9746734954666953E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2014,0.1033]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2015,0.1033]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2016,0.1033]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2017,7.0999999999999994E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2018,7.0999999999999994E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2019,7.0999999999999994E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2020,7.0999999999999994E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2021,7.0999999999999994E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2022,4.9995756003469997E-2]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2024,4.9995756003470913E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2014,7.5865431496830782E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2015,7.5865431496830782E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2016,7.5865431496830782E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2017,4.5991583362303003E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2018,4.5991583362303003E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2019,4.5991583362303003E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2020,4.5991583362303003E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2021,4.5991583362303003E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2022,2.9413787972026002E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2024,2.9413787972025984E-2]
["Amadeus Gas Pipeline","forecast inflation",2014,2.5499999999999998E-2]
["Amadeus Gas Pipeline","forecast inflation",2015,2.5499999999999998E-2]
["Amadeus Gas Pipeline","forecast inflation",2016,2.5499999999999998E-2]
["Amadeus Gas Pipeline","forecast inflation",2017,2.3908812494749999E-2]
["Amadeus Gas Pipeline","forecast inflation",2018,2.3908812494749999E-2]
["Amadeus Gas Pipeline","forecast inflation",2019,2.3908812494749999E-2]
["Amadeus Gas Pipeline","forecast inflation",2020,2.3908812494749999E-2]
["Amadeus Gas Pipeline","forecast inflation",2021,2.3908812494749999E-2]
["Amadeus Gas Pipeline","forecast inflation",2022,1.9993872504847E-2]
["Amadeus Gas Pipeline","forecast inflation",2024,1.9993872504847632E-2]
["Amadeus Gas Pipeline","Forecast Opening RAB",2014,104446801.302641]
["Amadeus Gas Pipeline","Forecast Opening RAB",2015,103203639.281161]
["Amadeus Gas Pipeline","Forecast Opening RAB",2016,101375203.060546]
["Amadeus Gas Pipeline","Forecast Opening RAB",2017,115816817.302958]
["Amadeus Gas Pipeline","Forecast Opening RAB",2018,122985574.89579201]
["Amadeus Gas Pipeline","Forecast Opening RAB",2019,124717276.730726]
["Amadeus Gas Pipeline","Forecast Opening RAB",2020,125961838.45295601]
["Amadeus Gas Pipeline","Forecast Opening RAB",2021,127120447.32361899]
["Amadeus Gas Pipeline","Forecast Opening RAB",2022,127583739.941971]
["Amadeus Gas Pipeline","Forecast Opening RAB",2024,129484803.053701]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2014,14520954.040157994]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2015,15505760.298655719]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2016,17303210.999184702]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2017,12159581.117138203]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2018,13406490.855660629]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2019,14649002.523783557]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2020,12719407.038252017]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2021,13358563.801050317]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2022,10729255.312687784]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2024,11052579.829484787]
["Victorian Transmission System","Allowed nominal return on equity",2014,8.0198999999999993E-2]
["Victorian Transmission System","Allowed nominal return on equity",2015,8.0198999999999993E-2]
["Victorian Transmission System","Allowed nominal return on equity",2016,8.0198999999999993E-2]
["Victorian Transmission System","Allowed nominal return on equity",2017,8.0198999999999993E-2]
["Victorian Transmission System","Allowed nominal return on equity",2018,7.2999999999999995E-2]
["Victorian Transmission System","Allowed nominal return on equity",2019,7.2999999999999995E-2]
["Victorian Transmission System","Allowed nominal return on equity",2020,7.2999999999999995E-2]
["Victorian Transmission System","Allowed nominal return on equity",2021,7.2999999999999995E-2]
["Victorian Transmission System","Allowed nominal return on equity",2022,7.2999999999999995E-2]
["Victorian Transmission System","Allowed nominal return on equity",2024,7.4444320526457622E-2]
["Victorian Transmission System","Allowed real return on equity",2014,5.3852682926829321E-2]
["Victorian Transmission System","Allowed real return on equity",2015,5.3852682926829321E-2]
["Victorian Transmission System","Allowed real return on equity",2016,5.3852682926829321E-2]
["Victorian Transmission System","Allowed real return on equity",2017,5.3852682926829321E-2]
["Victorian Transmission System","Allowed real return on equity",2018,4.7340665345846002E-2]
["Victorian Transmission System","Allowed real return on equity",2019,4.7340665345846002E-2]
["Victorian Transmission System","Allowed real return on equity",2020,4.7340665345846002E-2]
["Victorian Transmission System","Allowed real return on equity",2021,4.7340665345846002E-2]
["Victorian Transmission System","Allowed real return on equity",2022,4.7340665345846002E-2]
["Victorian Transmission System","Allowed real return on equity",2024,4.0654369383444688E-2]
["Victorian Transmission System","forecast inflation",2014,2.5000000000000001E-2]
["Victorian Transmission System","forecast inflation",2015,2.5000000000000001E-2]
["Victorian Transmission System","forecast inflation",2016,2.5000000000000001E-2]
["Victorian Transmission System","forecast inflation",2017,2.5000000000000001E-2]
["Victorian Transmission System","forecast inflation",2018,2.4499511480039999E-2]
["Victorian Transmission System","forecast inflation",2019,2.4499511480039999E-2]
["Victorian Transmission System","forecast inflation",2020,2.4499511480039999E-2]
["Victorian Transmission System","forecast inflation",2021,2.4499511480039999E-2]
["Victorian Transmission System","forecast inflation",2022,2.4499511480039999E-2]
["Victorian Transmission System","forecast inflation",2024,3.2469907528502873E-2]
["Victorian Transmission System","Forecast Opening RAB",2014,649947401.63782704]
["Victorian Transmission System","Forecast Opening RAB",2015,742463656.781937]
["Victorian Transmission System","Forecast Opening RAB",2016,756282007.15469801]
["Victorian Transmission System","Forecast Opening RAB",2017,757495949.55119801]
["Victorian Transmission System","Forecast Opening RAB",2018,971113287.50821102]
["Victorian Transmission System","Forecast Opening RAB",2019,1022808481.94634]
["Victorian Transmission System","Forecast Opening RAB",2020,1085617940.7992599]
["Victorian Transmission System","Forecast Opening RAB",2021,1145020679.20455]
["Victorian Transmission System","Forecast Opening RAB",2022,1141798582.0996001]
["Victorian Transmission System","Forecast Opening RAB",2024,1391265466.95895]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2014,30542489.354829099]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2015,32006502.415155932]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2016,33506750.835917529]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2017,34105143.331185877]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2018,26417209.042356603]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2019,27007916.330226038]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2020,27247910.341073669]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2021,29292567.78958581]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2022,31810030.845856301]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2024,38478840.01084087]
["Victorian Transmission System","Indexation",2014,11160882.2841186]
["Victorian Transmission System","Indexation",2015,12875290.768457901]
["Victorian Transmission System","Indexation",2016,12437931.2196241]
["Victorian Transmission System","Indexation",2017,17525245.668597698]
["Victorian Transmission System","Indexation",2018,17325839.2062147]
["Victorian Transmission System","Indexation",2019,17969136.624081299]
["Victorian Transmission System","Indexation",2020,8592214.2788378093]
["Victorian Transmission System","Indexation",2021,34851039.279033698]
["Victorian Transmission System","Indexation",2022,81862011.696983293]
["Victorian Transmission System","Inflation rate",2014,1.7175599999999999E-2]
["Victorian Transmission System","Inflation rate",2015,1.6885600000000001E-2]
["Victorian Transmission System","Inflation rate",2016,1.47601E-2]
["Victorian Transmission System","Inflation rate",2017,1.9090900000000001E-2]
["Victorian Transmission System","Inflation rate",2018,1.7841200000000002E-2]
["Victorian Transmission System","Inflation rate",2019,1.8404899999999998E-2]
["Victorian Transmission System","Inflation rate",2020,8.6058999999999997E-3]
["Victorian Transmission System","Inflation rate",2021,3.4982899999999997E-2]
["Victorian Transmission System","Inflation rate",2022,7.8318200000000004E-2]
["Victorian Transmission System","Inflation rate",2024,2.4246877296105973E-2]
["Victorian Transmission System","Nominal straight line depreciation",2014,26370110.123073265]
["Victorian Transmission System","Nominal straight line depreciation",2015,30152812.410316393]
["Victorian Transmission System","Nominal straight line depreciation",2016,31569014.664335873]
["Victorian Transmission System","Nominal straight line depreciation",2017,29773524.829767283]
["Victorian Transmission System","Nominal straight line depreciation",2018,36530703.625995792]
["Victorian Transmission System","Nominal straight line depreciation",2019,40307568.455474697]
["Victorian Transmission System","Nominal straight line depreciation",2020,43622721.497549959]
["Victorian Transmission System","Nominal straight line depreciation",2021,47832215.695420012]
["Victorian Transmission System","Nominal straight line depreciation",2022,43983041.226876318]
["Victorian Transmission System","Nominal straight line depreciation",2024,70650145.452361122]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2014,649811368.54216599]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2015,762503331.06531203]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2016,842669840.12930501]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2017,917989058.83127201]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2018,971113287.50821102]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2019,976323089.90842795]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2020,998415299.20049298]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2021,996229708.171507]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2022,1045248633.56259]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2024,1453049635.3785901]
["Victorian Transmission System","Operating expenditure",2014,24872334.465585701]
["Victorian Transmission System","Operating expenditure",2015,25603383.262285601]
["Victorian Transmission System","Operating expenditure",2016,26794560.769188602]
["Victorian Transmission System","Operating expenditure",2017,28172320.5408477]
["Victorian Transmission System","Operating expenditure",2018,25637901.097880501]
["Victorian Transmission System","Operating expenditure",2019,25009625.0602661]
["Victorian Transmission System","Operating expenditure",2020,28028337.284541201]
["Victorian Transmission System","Operating expenditure",2021,32922422.570689701]
["Victorian Transmission System","Operating expenditure",2022,38287325.411908098]
["Victorian Transmission System","Operating expenditure",2024,46833812.483159803]
["Victorian Transmission System","allowed nominal rate of return",2014,8.1000000000000003E-2]
["Victorian Transmission System","allowed nominal rate of return",2015,8.1000000000000003E-2]
["Victorian Transmission System","allowed nominal rate of return",2016,8.1000000000000003E-2]
["Victorian Transmission System","allowed nominal rate of return",2017,8.1000000000000003E-2]
["Victorian Transmission System","allowed nominal rate of return",2018,6.1697711514303998E-2]
["Victorian Transmission System","allowed nominal rate of return",2019,6.1623331980714E-2]
["Victorian Transmission System","allowed nominal rate of return",2020,6.0639831532744999E-2]
["Victorian Transmission System","allowed nominal rate of return",2021,5.9268113194878999E-2]
["Victorian Transmission System","allowed nominal rate of return",2022,5.8253768258436998E-2]
["Victorian Transmission System","allowed nominal rate of return",2024,5.9867325265854809E-2]
["Victorian Transmission System","allowed real rate of return",2014,5.4600000000000003E-2]
["Victorian Transmission System","allowed real rate of return",2015,5.4600000000000003E-2]
["Victorian Transmission System","allowed real rate of return",2016,5.4600000000000003E-2]
["Victorian Transmission System","allowed real rate of return",2017,5.4600000000000003E-2]
["Victorian Transmission System","allowed real rate of return",2018,3.6308655706947003E-2]
["Victorian Transmission System","allowed real rate of return",2019,3.6236054858671998E-2]
["Victorian Transmission System","allowed real rate of return",2020,3.5276073485378999E-2]
["Victorian Transmission System","allowed real rate of return",2021,3.3937157924663001E-2]
["Victorian Transmission System","allowed real rate of return",2022,3.294706966686E-2]
["Victorian Transmission System","allowed real rate of return",2024,2.653580267819633E-2]
["Victorian Transmission System","Revenue",2014,109316939.13]
["Victorian Transmission System","Revenue",2015,116709754.33]
["Victorian Transmission System","Revenue",2016,124342220.22]
["Victorian Transmission System","Revenue",2017,129001891.55]
["Victorian Transmission System","Revenue",2018,104718924.94]
["Victorian Transmission System","Revenue",2019,111990765.09]
["Victorian Transmission System","Revenue",2020,113159165.04000001]
["Victorian Transmission System","Revenue",2021,127741394.13]
["Victorian Transmission System","Revenue",2022,140100325.94999999]
["Victorian Transmission System","Revenue",2024,142393837.38]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2014,7.7499999999999999E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2015,7.7499999999999999E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2016,7.7499999999999999E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2017,7.7499999999999999E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2018,7.0000000000000007E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2019,7.0000000000000007E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2020,7.0000000000000007E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2021,7.0000000000000007E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2022,7.0000000000000007E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2024,5.7833522385201251E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2014,5.0706972208678001E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2015,5.0706972208678001E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2016,5.0706972208678001E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2017,5.0706972208678001E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2018,4.4668107798591997E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2019,4.4668107798591997E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2020,4.4668107798591997E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2021,4.4668107798591997E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2022,4.4668107798591997E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2024,3.0525081897705197E-2]
["Roma Brisbane Pipeline","forecast inflation",2014,2.5499999999999998E-2]
["Roma Brisbane Pipeline","forecast inflation",2015,2.5499999999999998E-2]
["Roma Brisbane Pipeline","forecast inflation",2016,2.5499999999999998E-2]
["Roma Brisbane Pipeline","forecast inflation",2017,2.5499999999999998E-2]
["Roma Brisbane Pipeline","forecast inflation",2018,2.4248746575396E-2]
["Roma Brisbane Pipeline","forecast inflation",2019,2.4248746575396E-2]
["Roma Brisbane Pipeline","forecast inflation",2020,2.4248746575396E-2]
["Roma Brisbane Pipeline","forecast inflation",2021,2.4248746575396E-2]
["Roma Brisbane Pipeline","forecast inflation",2022,2.4248746575396E-2]
["Roma Brisbane Pipeline","forecast inflation",2024,2.6499539862928634E-2]
["Roma Brisbane Pipeline","Forecast Opening RAB",2014,417101369.25863498]
["Roma Brisbane Pipeline","Forecast Opening RAB",2015,415872620.28741801]
["Roma Brisbane Pipeline","Forecast Opening RAB",2016,412078509.58787203]
["Roma Brisbane Pipeline","Forecast Opening RAB",2017,408578257.92053097]
["Roma Brisbane Pipeline","Forecast Opening RAB",2018,452120626.79344797]
["Roma Brisbane Pipeline","Forecast Opening RAB",2019,473326179.56735998]
["Roma Brisbane Pipeline","Forecast Opening RAB",2020,483666362.25560898]
["Roma Brisbane Pipeline","Forecast Opening RAB",2021,484037098.17149699]
["Roma Brisbane Pipeline","Forecast Opening RAB",2022,492148220.63350397]
["Roma Brisbane Pipeline","Forecast Opening RAB",2024,529004291.947106]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2014,13277177.753610855]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2015,13556292.774563016]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2016,13947822.952431625]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2017,14885657.05202074]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2018,14783851.402817616]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2019,14987382.929848354]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2020,15207968.178250432]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2021,15317231.631412426]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2022,16095534.91560295]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2024,23170144.761621807]
["Roma Brisbane Pipeline","Indexation",2014,12326672.9483095]
["Roma Brisbane Pipeline","Indexation",2015,5676687.91937856]
["Roma Brisbane Pipeline","Indexation",2016,5751766.3421083102]
["Roma Brisbane Pipeline","Indexation",2017,9290231.7743640393]
["Roma Brisbane Pipeline","Indexation",2018,8592337.7037678491]
["Roma Brisbane Pipeline","Indexation",2019,6084858.5069490904]
["Roma Brisbane Pipeline","Indexation",2020,10123138.6629896]
["Roma Brisbane Pipeline","Indexation",2021,5305478.7179689799]
["Roma Brisbane Pipeline","Indexation",2022,24430767.9324889]
["Roma Brisbane Pipeline","Inflation rate",2014,2.9296900000000001E-2]
["Roma Brisbane Pipeline","Inflation rate",2015,1.32827E-2]
["Roma Brisbane Pipeline","Inflation rate",2016,1.31086E-2]
["Roma Brisbane Pipeline","Inflation rate",2017,2.1299999999999999E-2]
["Roma Brisbane Pipeline","Inflation rate",2018,1.9004524886877761E-2]
["Roma Brisbane Pipeline","Inflation rate",2019,1.3321492007104752E-2]
["Roma Brisbane Pipeline","Inflation rate",2020,2.1910604732690686E-2]
["Roma Brisbane Pipeline","Inflation rate",2021,1.1149228130360234E-2]
["Roma Brisbane Pipeline","Inflation rate",2022,5.0890585241730291E-2]
["Roma Brisbane Pipeline","Inflation rate",2024,3.6199095022624528E-2]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2014,16455514.429398542]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2015,17913199.963008527]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2016,17645516.930134203]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2017,16776832.954380728]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2018,16665988.72323174]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2019,17937681.976722322]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2020,18495203.19570259]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2021,12699363.61430368]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2022,10725453.35254175]
["Roma Brisbane Pipeline","Nominal straight line depreciation",2024,17119647.664019234]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2014,420750436.63563198]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2015,427373504.78743201]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2016,438777603.81225097]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2017,437044816.5158]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2018,452120626.79344797]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2019,456770045.25514001]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2020,462020048.57885897]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2021,475860629.62707299]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2022,480064589.87340999]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2024,544926847.21838105]
["Roma Brisbane Pipeline","Operating expenditure",2014,13497307.018845201]
["Roma Brisbane Pipeline","Operating expenditure",2015,13373649.342512]
["Roma Brisbane Pipeline","Operating expenditure",2016,14664845.9819708]
["Roma Brisbane Pipeline","Operating expenditure",2017,15758025.2538414]
["Roma Brisbane Pipeline","Operating expenditure",2018,15190502.879014]
["Roma Brisbane Pipeline","Operating expenditure",2019,17174999.268088501]
["Roma Brisbane Pipeline","Operating expenditure",2020,17963454.514030199]
["Roma Brisbane Pipeline","Operating expenditure",2021,18892507.880947199]
["Roma Brisbane Pipeline","Operating expenditure",2022,20263882.1906811]
["Roma Brisbane Pipeline","Operating expenditure",2024,24588734.176912803]
["Roma Brisbane Pipeline","allowed nominal rate of return",2014,7.8841647975754006E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2015,7.8841647975754006E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2016,7.8841647975754006E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2017,7.8841647975754006E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2018,5.8907656246808E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2019,5.8824320982702002E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2020,5.8601765782174998E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2021,5.7531151074265E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2022,5.6503536895624998E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2024,5.1609674932277722E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2014,5.2015258874455003E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2015,5.2015258874455003E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2016,5.2015258874455003E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2017,5.2015258874455003E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2018,3.3838371574575997E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2019,3.3757009244979999E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2020,3.3539722964406E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2021,3.2494454701701002E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2022,3.1491168945115E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2024,2.4461905820924112E-2]
["Roma Brisbane Pipeline","Revenue",2014,57358760.359999999]
["Roma Brisbane Pipeline","Revenue",2015,61330744.649999999]
["Roma Brisbane Pipeline","Revenue",2016,67562094.310000002]
["Roma Brisbane Pipeline","Revenue",2017,70586820.049999997]
["Roma Brisbane Pipeline","Revenue",2018,70941151.840000004]
["Roma Brisbane Pipeline","Revenue",2019,69654049.679999992]
["Roma Brisbane Pipeline","Revenue",2020,70220688.040000007]
["Roma Brisbane Pipeline","Revenue",2021,65251849.860000007]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2014,6.0324298407150048E-2]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2015,5.6803086729211312E-2]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2016,0.15666196657651058]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2017,0.16691047918413648]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2018,0.20107520957309311]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2019,0.1935120399605684]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2020,0.1901607463531349]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2021,0.19462458243867808]
["Amadeus Gas Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2022,0.13385047533466823]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2014,6.3281890544707259E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2015,6.9377399693019134E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2016,7.9301243652073056E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2017,8.5250659409215793E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2018,8.4835164733009241E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2019,7.4626774296731938E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2020,7.1508032399021093E-2]
["Roma Brisbane Pipeline","Real return on assets - Excluding returns from incentive schemes",2021,6.9955006765795968E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2014,8.2103031953404904E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2015,7.0353553747166842E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2016,0.12363498078723406]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2017,0.1313650116641476]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2018,0.13509359229644249]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2019,9.5244562455435652E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2020,0.11315553222984662]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2021,0.10440658719245516]
["Roma Brisbane Pipeline","Real return on regulated equity - Excluding returns from incentive schemes",2022,0.15763023896801165]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2014,8.7862225531782398E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2015,7.8611344383243548E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2016,7.7158283542895556E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2017,7.5953992869446291E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2018,4.3047993162193723E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2019,4.6941503407448272E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2020,4.1219259763270753E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2021,4.5570395505873641E-2]
["Victorian Transmission System","Real return on assets - Excluding returns from incentive schemes",2022,5.1308148484809857E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2014,0.10802795329523962]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2015,9.2495949203781111E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2016,0.12429919235057411]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2017,0.11420522839774046]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2018,4.6747358720217728E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2019,5.0220360682328234E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2020,2.9462845780549467E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2021,8.4868187542745249E-2]
["Victorian Transmission System","Real return on regulated equity - Excluding returns from incentive schemes",2022,0.18451187429292421]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2014,6.0324298407150048E-2]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2015,5.6803086729211312E-2]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2016,0.15666196657651058]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2017,0.16691047918413648]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2018,0.20107520957309311]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2019,0.1935120399605684]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2020,0.1901607463531349]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2021,0.19462458243867808]
["Amadeus Gas Pipeline","Real return on regulated equity - Including returns from incentive schemes",2022,0.13385047533466823]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2014,6.3281890544707259E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2015,6.9377399693019134E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2016,7.9301243652073056E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2017,8.5250659409215793E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2018,8.4835164733009241E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2019,7.4626774296731938E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2020,7.1508032399021093E-2]
["Roma Brisbane Pipeline","Real return on assets - Including returns from incentive schemes",2021,6.9955006765795968E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2014,8.2103031953404904E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2015,7.0353553747166842E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2016,0.12363498078723406]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2017,0.1313650116641476]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2018,0.13509359229644249]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2019,9.5244562455435652E-2]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2020,0.11315553222984662]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2021,0.10440658719245516]
["Roma Brisbane Pipeline","Real return on regulated equity - Including returns from incentive schemes",2022,0.15763023896801165]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2014,8.7862225531782398E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2015,7.8611344383243548E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2016,7.7158283542895556E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2017,7.5953992869446291E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2018,4.3047993162193723E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2019,4.6941503407448272E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2020,4.1219259763270753E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2021,4.5570395505873641E-2]
["Victorian Transmission System","Real return on assets - Including returns from incentive schemes",2022,5.1308148484809857E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2014,0.10802795329523962]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2015,9.2495949203781111E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2016,0.12429919235057411]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2017,0.11420522839774046]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2018,4.6747358720217728E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2019,5.0220360682328234E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2020,2.9462845780549467E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2021,8.4868187542745249E-2]
["Victorian Transmission System","Real return on regulated equity - Including returns from incentive schemes",2022,0.18451187429292421]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2014,9.1388513345154479E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2015,7.084028508930941E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2016,0.17182418563157539]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2017,0.18413419454794225]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2018,0.2240048162915321]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2019,0.21480572696791286]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2020,0.2120655358736897]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2021,0.20490540213268713]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2022,0.17351585312825338]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2014,9.4432753763806485E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2015,8.358161887992159E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2016,9.3449371934610628E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2017,0.1083664984546321]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2018,0.10545194161933785]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2019,8.8942406281146608E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2020,9.4985421364819175E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Including returns from incentive schemes",2021,8.1884179225448953E-2]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2014,0.11380529627024061]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2015,8.45707388955243E-2]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2016,0.13836426229638163]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2017,0.15546308641259396]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2018,0.15666550672017571]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2019,0.10983485414001068]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2020,0.13754544310254271]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2021,0.11671986818173642]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Including returns from incentive schemes",2022,0.21654271932261784]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2014,0.10654691197262608]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2015,9.6824344099961226E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2016,9.3057247523817041E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2017,9.6494922951917597E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2018,6.1657221017799052E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2019,6.6210357083512014E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2020,5.0179888590867486E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2021,8.2147480094816067E-2]
["Victorian Transmission System","Nominal return on assets - Including returns from incentive schemes",2022,0.13364471031947292]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2014,0.12705899820985736]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2015,0.11094339880365643]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2016,0.14089396085958783]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2017,0.13547640899255889]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2018,6.5422587696616866E-2]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2019,6.9549561398650414E-2]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2020,3.8322300085052295E-2]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2021,0.12282002286073436]
["Victorian Transmission System","Nominal return on regulated equity - Including returns from incentive schemes",2022,0.27728071216617228]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2014,9.1388513345154479E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2015,7.084028508930941E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2016,0.17182418563157539]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2017,0.18413419454794225]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2018,0.2240048162915321]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2019,0.21480572696791286]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2020,0.2120655358736897]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2021,0.20490540213268713]
["Amadeus Gas Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2022,0.17351585312825338]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2014,9.4432753763806485E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2015,8.358161887992159E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2016,9.3449371934610628E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2017,0.1083664984546321]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2018,0.10545194161933785]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2019,8.8942406281146608E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2020,9.4985421364819175E-2]
["Roma Brisbane Pipeline","Nominal return on assets - Excluding returns from incentive schemes",2021,8.1884179225448953E-2]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2014,0.11380529627024061]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2015,8.45707388955243E-2]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2016,0.13836426229638163]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2017,0.15546308641259396]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2018,0.15666550672017571]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2019,0.10983485414001068]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2020,0.13754544310254271]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2021,0.11671986818173642]
["Roma Brisbane Pipeline","Nominal return on regulated equity - Excluding returns from incentive schemes",2022,0.21654271932261784]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2014,0.10654691197262608]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2015,9.6824344099961226E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2016,9.3057247523817041E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2017,9.6494922951917597E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2018,6.1657221017799052E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2019,6.6210357083512014E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2020,5.0179888590867486E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2021,8.2147480094816067E-2]
["Victorian Transmission System","Nominal return on assets - Excluding returns from incentive schemes",2022,0.13364471031947292]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2014,0.12705899820985736]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2015,0.11094339880365643]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2016,0.14089396085958783]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2017,0.13547640899255889]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2018,6.5422587696616866E-2]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2019,6.9549561398650414E-2]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2020,3.8322300085052295E-2]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2021,0.12282002286073436]
["Victorian Transmission System","Nominal return on regulated equity - Excluding returns from incentive schemes",2022,0.27728071216617228]
["Amadeus Gas Pipeline","EBSS",2023,0]
["Victorian Transmission System","EBSS",2023,0]
["Roma Brisbane Pipeline","EBSS",2023,0]
["Amadeus Gas Pipeline","Efficiency carryover",2023,2708684.8855203027]
["Amadeus Gas Pipeline","Efficiency carryover",2024,0]
["Victorian Transmission System","Efficiency carryover",2023,-2649294.3348018667]
["Victorian Transmission System","Efficiency carryover",2024,-2175816.2151241349]
["Roma Brisbane Pipeline","Efficiency carryover",2023,-3447137.8219091129]
["Roma Brisbane Pipeline","Efficiency carryover",2024,-3285906.6597634964]
["Amadeus Gas Pipeline","other",2023,0]
["Victorian Transmission System","other",2023,0]
["Roma Brisbane Pipeline","other",2023,0]
["Amadeus Gas Pipeline","Allowed nominal return on equity",2023,4.9995756003469997E-2]
["Victorian Transmission System","Allowed nominal return on equity",2023,7.4444320526456997E-2]
["Roma Brisbane Pipeline","Allowed nominal return on equity",2023,5.7833522385201001E-2]
["Amadeus Gas Pipeline","Allowed real return on equity",2023,2.9413787972026002E-2]
["Victorian Transmission System","Allowed real return on equity",2023,4.0654369383444001E-2]
["Roma Brisbane Pipeline","Allowed real return on equity",2023,3.0525081897705E-2]
["Amadeus Gas Pipeline","allowed nominal rate of return",2023,4.9867883578823997E-2]
["Victorian Transmission System","allowed nominal rate of return",2023,5.8874595052334999E-2]
["Roma Brisbane Pipeline","allowed nominal rate of return",2023,5.0584396209270001E-2]
["Amadeus Gas Pipeline","allowed real rate of return",2023,2.9288422096705999E-2]
["Roma Brisbane Pipeline","allowed real rate of return",2023,2.3463095121852E-2]
["Victorian Transmission System","allowed real rate of return",2023,2.5574292607751001E-2]
["Amadeus Gas Pipeline","Operating expenditure",2023,15616022.402683085]
["Roma Brisbane Pipeline","Operating expenditure",2023,26731093.525001056]
["Amadeus Gas Pipeline","Opening Regulatory Asset Base (Nominal)",2023,134104624.682289]
["Victorian Transmission System","Opening Regulatory Asset Base (Nominal)",2023,1266356689.3145058]
["Roma Brisbane Pipeline","Opening Regulatory Asset Base (Nominal)",2023,510367334.37426722]
["Amadeus Gas Pipeline","Forecast Opening RAB",2023,128821312.12672]
["Victorian Transmission System","Forecast Opening RAB",2023,1262750435.6420701]
["Roma Brisbane Pipeline","Forecast Opening RAB",2023,509857280.07252598]
["Amadeus Gas Pipeline","Forecast inflation",2023,1.9993872504847E-2]
["Victorian Transmission System","Forecast inflation",2023,3.2469907528501998E-2]
["Roma Brisbane Pipeline","Forecast inflation",2023,2.6499539862927999E-2]
["Amadeus Gas Pipeline","Forecast operating and maintenance expenditure",2023,10096317.387750341]
["Victorian Transmission System","Forecast operating and maintenance expenditure",2023,38865681.16189824]
["Roma Brisbane Pipeline","Forecast operating and maintenance expenditure",2023,21570706.877889562]
["Amadeus Gas Pipeline","Nominal Straight Line Depreciation",2023,4702275.3169966107]
["Roma Brisbane Pipeline","Nominal Straight Line Depreciation",2023,14490597.129088299]
["Victorian Transmission System","Nominal Straight Line Depreciation",2023,55050224.5490252]
["Amadeus Gas Pipeline","Inflation Rate",2023,7.8318219291014124E-2]
["Victorian Transmission System","Inflation Rate",2023,4.0519877675839977E-2]
["Roma Brisbane Pipeline","Inflation Rate",2023,7.0217917675544639E-2]
["Victorian Transmission System","Revenue",2023,124693807.02]
["Victorian Transmission System","Other Revenue",2023,301993.56999999302]
["Victorian Transmission System","Other Revenue",2024,367744.28999999899]
["Victorian Transmission System","Operating expenditure",2023,49119224.221583456]
["Roma Brisbane Pipeline","Nominal return on assets",2014,9.4432753763806485E-2]
["Roma Brisbane Pipeline","Nominal return on assets",2015,8.358161887992159E-2]
["Roma Brisbane Pipeline","Nominal return on assets",2016,9.3449371934610628E-2]
["Roma Brisbane Pipeline","Nominal return on assets",2017,0.1083664984546321]
["Roma Brisbane Pipeline","Nominal return on assets",2018,0.10545194161933785]
["Roma Brisbane Pipeline","Nominal return on assets",2019,8.8942406281146608E-2]
["Roma Brisbane Pipeline","Nominal return on assets",2020,9.4985421364819175E-2]
["Roma Brisbane Pipeline","Nominal return on assets",2021,8.1884179225448953E-2]
["Victorian Transmission System","Nominal return on assets",2014,0.10654691197262608]
["Victorian Transmission System","Nominal return on assets",2015,9.6824344099961226E-2]
["Victorian Transmission System","Nominal return on assets",2016,9.3057247523817041E-2]
["Victorian Transmission System","Nominal return on assets",2017,9.6494922951917597E-2]
["Victorian Transmission System","Nominal return on assets",2018,6.1657221017799052E-2]
["Victorian Transmission System","Nominal return on assets",2019,6.6210357083512014E-2]
["Victorian Transmission System","Nominal return on assets",2020,5.0179888590867486E-2]
["Victorian Transmission System","Nominal return on assets",2021,8.2147480094816067E-2]
["Victorian Transmission System","Nominal return on assets",2022,0.13364471031947292]
["Victorian Transmission System","Nominal return on assets",2023,5.6965758994368718E-2]
["Victorian Transmission System","Nominal return on assets",2024,4.1643133500315406E-2]
["Roma Brisbane Pipeline","Real return on assets",2014,6.3281890544707259E-2]
["Roma Brisbane Pipeline","Real return on assets",2015,6.9377399693019134E-2]
["Roma Brisbane Pipeline","Real return on assets",2016,7.9301243652073056E-2]
["Roma Brisbane Pipeline","Real return on assets",2017,8.5250659409215793E-2]
["Roma Brisbane Pipeline","Real return on assets",2018,8.4835164733009241E-2]
["Roma Brisbane Pipeline","Real return on assets",2019,7.4626774296731938E-2]
["Roma Brisbane Pipeline","Real return on assets",2020,7.1508032399021093E-2]
["Roma Brisbane Pipeline","Real return on assets",2021,6.9955006765795968E-2]
["Victorian Transmission System","Real return on assets",2014,8.7862225531782398E-2]
["Victorian Transmission System","Real return on assets",2015,7.8611344383243548E-2]
["Victorian Transmission System","Real return on assets",2016,7.7158283542895556E-2]
["Victorian Transmission System","Real return on assets",2017,7.5953992869446291E-2]
["Victorian Transmission System","Real return on assets",2018,4.3047993162193723E-2]
["Victorian Transmission System","Real return on assets",2019,4.6941503407448272E-2]
["Victorian Transmission System","Real return on assets",2020,4.1219259763270753E-2]
["Victorian Transmission System","Real return on assets",2021,4.5570395505873641E-2]
["Victorian Transmission System","Real return on assets",2022,5.1308148484809857E-2]
["Victorian Transmission System","Real return on assets",2023,1.5805446557410441E-2]
["Victorian Transmission System","Real return on assets",2024,1.69844366527468E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2014,9.1388513345154479E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2015,7.084028508930941E-2]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2016,0.17182418563157539]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2017,0.18413419454794225]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2018,0.2240048162915321]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2019,0.21480572696791286]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2020,0.2120655358736897]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2021,0.20490540213268713]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2022,0.17351585312825338]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2023,0.27649634893743336]
["Amadeus Gas Pipeline","Nominal return on regulated equity",2024,0.14841866010113017]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2014,0.11380529627024061]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2015,8.45707388955243E-2]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2016,0.13836426229638163]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2017,0.15546308641259396]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2018,0.15666550672017571]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2019,0.10983485414001068]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2020,0.13754544310254271]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2021,0.11671986818173642]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2022,0.21654271932261784]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2023,0.31782069205183799]
["Roma Brisbane Pipeline","Nominal return on regulated equity",2024,0.10865598372726466]
["Victorian Transmission System","Nominal return on regulated equity",2014,0.12705899820985736]
["Victorian Transmission System","Nominal return on regulated equity",2015,0.11094339880365643]
["Victorian Transmission System","Nominal return on regulated equity",2016,0.14089396085958783]
["Victorian Transmission System","Nominal return on regulated equity",2017,0.13547640899255889]
["Victorian Transmission System","Nominal return on regulated equity",2018,6.5422587696616866E-2]
["Victorian Transmission System","Nominal return on regulated equity",2019,6.9549561398650414E-2]
["Victorian Transmission System","Nominal return on regulated equity",2020,3.8322300085052295E-2]
["Victorian Transmission System","Nominal return on regulated equity",2021,0.12282002286073436]
["Victorian Transmission System","Nominal return on regulated equity",2022,0.27728071216617228]
["Victorian Transmission System","Nominal return on regulated equity",2023,9.5435926848507976E-2]
["Victorian Transmission System","Nominal return on regulated equity",2024,3.289263699121172E-2]
["Amadeus Gas Pipeline","Real return on regulated equity",2014,6.0324298407150048E-2]
["Amadeus Gas Pipeline","Real return on regulated equity",2015,5.6803086729211312E-2]
["Amadeus Gas Pipeline","Real return on regulated equity",2016,0.15666196657651058]
["Amadeus Gas Pipeline","Real return on regulated equity",2017,0.16691047918413648]
["Amadeus Gas Pipeline","Real return on regulated equity",2018,0.20107520957309311]
["Amadeus Gas Pipeline","Real return on regulated equity",2019,0.1935120399605684]
["Amadeus Gas Pipeline","Real return on regulated equity",2020,0.1901607463531349]
["Amadeus Gas Pipeline","Real return on regulated equity",2021,0.19462458243867808]
["Amadeus Gas Pipeline","Real return on regulated equity",2022,0.13385047533466823]
["Amadeus Gas Pipeline","Real return on regulated equity",2023,0.18378445815069311]
["Amadeus Gas Pipeline","Real return on regulated equity",2024,0.10369699295538456]
["Roma Brisbane Pipeline","Real return on regulated equity",2014,8.2103031953404904E-2]
["Roma Brisbane Pipeline","Real return on regulated equity",2015,7.0353553747166842E-2]
["Roma Brisbane Pipeline","Real return on regulated equity",2016,0.12363498078723406]
["Roma Brisbane Pipeline","Real return on regulated equity",2017,0.1313650116641476]
["Roma Brisbane Pipeline","Real return on regulated equity",2018,0.13509359229644249]
["Roma Brisbane Pipeline","Real return on regulated equity",2019,9.5244562455435652E-2]
["Roma Brisbane Pipeline","Real return on regulated equity",2020,0.11315553222984662]
["Roma Brisbane Pipeline","Real return on regulated equity",2021,0.10440658719245516]
["Roma Brisbane Pipeline","Real return on regulated equity",2022,0.15763023896801165]
["Roma Brisbane Pipeline","Real return on regulated equity",2023,0.2313573434783012]
["Roma Brisbane Pipeline","Real return on regulated equity",2024,6.9925643684390706E-2]
["Victorian Transmission System","Real return on regulated equity",2014,0.10802795329523962]
["Victorian Transmission System","Real return on regulated equity",2015,9.2495949203781111E-2]
["Victorian Transmission System","Real return on regulated equity",2016,0.12429919235057411]
["Victorian Transmission System","Real return on regulated equity",2017,0.11420522839774046]
["Victorian Transmission System","Real return on regulated equity",2018,4.6747358720217728E-2]
["Victorian Transmission System","Real return on regulated equity",2019,5.0220360682328234E-2]
["Victorian Transmission System","Real return on regulated equity",2020,2.9462845780549467E-2]
["Victorian Transmission System","Real return on regulated equity",2021,8.4868187542745249E-2]
["Victorian Transmission System","Real return on regulated equity",2022,0.18451187429292421]
["Victorian Transmission System","Real return on regulated equity",2023,5.2777510887472304E-2]
["Victorian Transmission System","Real return on regulated equity",2024,8.4410896305874578E-3]

{"sheet":"Summary - Return on assets","index":3,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Return on assets - Summary results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Returns from indexation of the RAB","Exclusive"]
[]
[null,"Transmission"]
[]
[null,{"$f":"IF(C30 = \"Inclusive\", \"Nominal return on assets\",\"Real return on assets\")","v":"Real return on assets"},"Including returns from incentive schemes"]
[]
[null,"Return on Assets",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Victorian Transmission System",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,C$36,Data!$B:$B,$B$34)","v":8.7862225531782398E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,D$36,Data!$B:$B,$B$34)","v":7.8611344383243548E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,E$36,Data!$B:$B,$B$34)","v":7.7158283542895556E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,F$36,Data!$B:$B,$B$34)","v":7.5953992869446291E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,G$36,Data!$B:$B,$B$34)","v":4.3047993162193723E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,H$36,Data!$B:$B,$B$34)","v":4.6941503407448272E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,I$36,Data!$B:$B,$B$34)","v":4.1219259763270753E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,J$36,Data!$B:$B,$B$34)","v":4.5570395505873641E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,K$36,Data!$B:$B,$B$34)","v":5.1308148484809857E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,L$36,Data!$B:$B,$B$34)","v":1.5805446557410441E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,M$36,Data!$B:$B,$B$34)","v":1.69844366527468E-2}]
[null,"Roma Brisbane Pipeline",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,C$36,Data!$B:$B,$B$34)","v":6.3281890544707259E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,D$36,Data!$B:$B,$B$34)","v":6.9377399693019134E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,E$36,Data!$B:$B,$B$34)","v":7.9301243652073056E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,F$36,Data!$B:$B,$B$34)","v":8.5250659409215793E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,G$36,Data!$B:$B,$B$34)","v":8.4835164733009241E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,H$36,Data!$B:$B,$B$34)","v":7.4626774296731938E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,I$36,Data!$B:$B,$B$34)","v":7.1508032399021093E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,J$36,Data!$B:$B,$B$34)","v":6.9955006765795968E-2}]
[null,"Average",{"$f":"AVERAGE(C37:C38)","v":7.5572058038244821E-2},{"$f":"AVERAGE(D37:D38)","v":7.3994372038131334E-2},7.8229763597484306E-2,8.0602326139331049E-2,6.3941578947601482E-2,6.0784138852090108E-2,5.6363646081145927E-2,5.7762701135834801E-2,5.1308148484809857E-2,{"$f":"AVERAGE(L37:L38)","v":1.5805446557410441E-2},{"$f":"AVERAGE(M37:M38)","v":1.69844366527468E-2}]
[]
[null,{"$f":"IF(C30 = \"Inclusive\", \"WACC - Allowed nominal rate of return\",\"WACC - Allowed real rate of return\")","v":"WACC - Allowed real rate of return"},2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Victorian Transmission System",{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,C$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,C$41))","v":5.4600000000000003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,D$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,D$41))","v":5.4600000000000003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,E$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,E$41))","v":5.4600000000000003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,F$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,F$41))","v":5.4600000000000003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,G$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,G$41))","v":3.6308655706947003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,H$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,H$41))","v":3.6236054858671998E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,I$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,I$41))","v":3.5276073485378999E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,J$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,J$41))","v":3.3937157924663001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,K$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,K$41))","v":3.294706966686E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,L$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,L$41))","v":2.5574292607751001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,M$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B42,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,M$41))","v":2.653580267819633E-2}]
[null,"Roma Brisbane Pipeline",{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,C$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,C$41))","v":5.2015258874455003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,D$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,D$41))","v":5.2015258874455003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,E$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,E$41))","v":5.2015258874455003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,F$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,F$41))","v":5.2015258874455003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,G$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,G$41))","v":3.3838371574575997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,H$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,H$41))","v":3.3757009244979999E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,I$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,I$41))","v":3.3539722964406E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,J$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,J$41))","v":3.2494454701701002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,K$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,K$41))","v":3.1491168945115E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,L$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,L$41))","v":2.3463095121852E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,M$41),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,M$41))","v":2.4461905820924112E-2}]
[null,"Average",{"$f":"AVERAGE(C42:C43)","v":5.3307629437227499E-2},{"$f":"AVERAGE(D42:D43)","v":5.3307629437227499E-2},5.3307629437227499E-2,5.3307629437227499E-2,3.50735136407615E-2,3.4996532051825999E-2,3.44078982248925E-2,3.3215806313182002E-2,3.2219119305987504E-2,{"$f":"AVERAGE(L42:L43)","v":2.4518693864801502E-2},{"$f":"AVERAGE(M42:M43)","v":2.5498854249560221E-2}]

{"sheet":"Summary - Return on equity","index":4,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Return on regulated equity - Summary results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Returns from indexation of the RAB","Exclusive"]
[]
[null,"Transmission"]
[]
[null,{"$f":"IF(C30 = \"Inclusive\", \"Nominal return on regulated equity\",\"Real return on regulated equity\")","v":"Real return on regulated equity"},"Including returns from incentive schemes"]
[]
[null,"Return on Regulated Equity",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Amadeus Gas Pipeline",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,C$36,Data!$B:$B,$B$34)","v":6.0324298407150048E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,D$36,Data!$B:$B,$B$34)","v":5.6803086729211312E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,E$36,Data!$B:$B,$B$34)","v":0.15666196657651058},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,F$36,Data!$B:$B,$B$34)","v":0.16691047918413648},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,G$36,Data!$B:$B,$B$34)","v":0.20107520957309311},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,H$36,Data!$B:$B,$B$34)","v":0.1935120399605684},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,I$36,Data!$B:$B,$B$34)","v":0.1901607463531349},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,J$36,Data!$B:$B,$B$34)","v":0.19462458243867808},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,K$36,Data!$B:$B,$B$34)","v":0.13385047533466823},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,L$36,Data!$B:$B,$B$34)","v":0.18378445815069311},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B37,Data!$C:$C,M$36,Data!$B:$B,$B$34)","v":0.10369699295538456}]
[null,"Victorian Transmission System",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,C$36,Data!$B:$B,$B$34)","v":0.10802795329523962},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,D$36,Data!$B:$B,$B$34)","v":9.2495949203781111E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,E$36,Data!$B:$B,$B$34)","v":0.12429919235057411},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,F$36,Data!$B:$B,$B$34)","v":0.11420522839774046},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,G$36,Data!$B:$B,$B$34)","v":4.6747358720217728E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,H$36,Data!$B:$B,$B$34)","v":5.0220360682328234E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,I$36,Data!$B:$B,$B$34)","v":2.9462845780549467E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,J$36,Data!$B:$B,$B$34)","v":8.4868187542745249E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,K$36,Data!$B:$B,$B$34)","v":0.18451187429292421},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,L$36,Data!$B:$B,$B$34)","v":5.2777510887472304E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B38,Data!$C:$C,M$36,Data!$B:$B,$B$34)","v":8.4410896305874578E-3}]
[null,"Roma Brisbane Pipeline",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,C$36,Data!$B:$B,$B$34)","v":8.2103031953404904E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,D$36,Data!$B:$B,$B$34)","v":7.0353553747166842E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,E$36,Data!$B:$B,$B$34)","v":0.12363498078723406},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,F$36,Data!$B:$B,$B$34)","v":0.1313650116641476},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,G$36,Data!$B:$B,$B$34)","v":0.13509359229644249},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,H$36,Data!$B:$B,$B$34)","v":9.5244562455435652E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,I$36,Data!$B:$B,$B$34)","v":0.11315553222984662},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,J$36,Data!$B:$B,$B$34)","v":0.10440658719245516},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,K$36,Data!$B:$B,$B$34)","v":0.15763023896801165},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,L$36,Data!$B:$B,$B$34)","v":0.2313573434783012},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,$B39,Data!$C:$C,M$36,Data!$B:$B,$B$34)","v":6.9925643684390706E-2}]
[null,"Average",{"$f":"AVERAGE(C37:C39)","v":8.3485094551931524E-2},{"$f":"AVERAGE(D37:D39)","v":7.3217529893386424E-2},0.1348653799047729,0.13749357308200819,0.12763872019658443,0.11299232103277744,0.11092637478784366,0.12796645239129284,0.1586641961985347,0.15597310417215551,6.0687908756787569E-2]
[]
[null,{"$f":"IF(C30 = \"Inclusive\", \"ROE - Allowed nominal return on equity\",\"ROE - Allowed real return on equity\")","v":"ROE - Allowed real return on equity"},2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Amadeus Gas Pipeline",{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,C$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,C$42))","v":7.5865431496830782E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,D$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,D$42))","v":7.5865431496830782E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,E$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,E$42))","v":7.5865431496830782E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,F$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,F$42))","v":4.5991583362303003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,G$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,G$42))","v":4.5991583362303003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,H$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,H$42))","v":4.5991583362303003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,I$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,I$42))","v":4.5991583362303003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,J$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,J$42))","v":4.5991583362303003E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,K$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,K$42))","v":2.9413787972026002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,L$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,L$42))","v":2.9413787972026002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,M$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B43,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,M$42))","v":2.9413787972025984E-2}]
[null,"Victorian Transmission System",{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,C$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,C$42))","v":5.3852682926829321E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,D$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,D$42))","v":5.3852682926829321E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,E$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,E$42))","v":5.3852682926829321E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,F$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,F$42))","v":5.3852682926829321E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,G$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,G$42))","v":4.7340665345846002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,H$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,H$42))","v":4.7340665345846002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,I$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,I$42))","v":4.7340665345846002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,J$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,J$42))","v":4.7340665345846002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,K$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,K$42))","v":4.7340665345846002E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,L$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,L$42))","v":4.0654369383444001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,M$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B44,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,M$42))","v":4.0654369383444688E-2}]
[null,"Roma Brisbane Pipeline",{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,C$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,C$42))","v":5.0706972208678001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,D$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,D$42))","v":5.0706972208678001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,E$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,E$42))","v":5.0706972208678001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,F$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,F$42))","v":5.0706972208678001E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,G$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,G$42))","v":4.4668107798591997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,H$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,H$42))","v":4.4668107798591997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,I$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,I$42))","v":4.4668107798591997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,J$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,J$42))","v":4.4668107798591997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,K$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,K$42))","v":4.4668107798591997E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,L$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,L$42))","v":3.0525081897705E-2},{"$f":"IF($C$30=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,M$42),SUMIFS(Data!$D:$D,Data!$A:$A,$B45,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,M$42))","v":3.0525081897705197E-2}]
[null,"Average",{"$f":"AVERAGE(C43:C45)","v":6.0141695544112701E-2},{"$f":"AVERAGE(D43:D45)","v":6.0141695544112701E-2},6.0141695544112701E-2,5.0183746165936773E-2,4.6000118835580334E-2,4.6000118835580334E-2,4.6000118835580334E-2,4.6000118835580334E-2,4.0474187038821337E-2,3.3531079751058339E-2,3.3531079751058623E-2]

{"sheet":"Profitability - Gas Tx","index":5,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":false,"merged":[[82,1,83,12],[89,1,90,12],[62,1,63,12],[16,1,17,12],[24,1,25,12],[34,1,35,12],[41,1,42,12],[53,1,54,12],[75,1,76,12]]}
[]
[null,"Gas TNSP Financial performance - Detailed calculations"]
[]
[null,"Network Service Provider","Amadeus Gas Pipeline"]
[]
[null,"Returns from indexation of the RAB","Exclusive"]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,"Returns from incentive scheme payments","Inclusive",null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]
[null,"Summary"]
[null,null,"","","","","","","","","","",""]
[null,"Returns on assets",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Return on Assets",{"$f":"IF($C$4=\"Amadeus Gas Pipeline\",\"\",IF($C$6=\"Inclusive\", C66/C80, C66/C81))","v":""},"","","","","","","",{"$f":"IF(AND($C$4=\"Victorian Transmission System\",$C$6=\"Inclusive\"),K66/K80,IF(AND($C$4=\"Victorian Transmission System\",$C$6=\"Exclusive\"),K66/K81,\"\"))","v":""},"",""]
[null,"Allowed rate of return",{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!C$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!C$12))","v":8.1168655070564005E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!D$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!D$12))","v":8.1168655070564005E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!E$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!E$12))","v":8.1168655070564005E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!F$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!F$12))","v":4.1300228208348999E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!G$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!G$12))","v":4.1021833809593997E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!H$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!H$12))","v":4.0395667033332999E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!I$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!I$12))","v":3.9633531179826001E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!J$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!J$12))","v":3.8043138457118E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!K$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!K$12))","v":3.0209075738066998E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!L$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!L$12))","v":2.9288422096705999E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real rate of return\",Data!$C:$C,'Profitability - Gas Tx'!M$12),SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed nominal rate of return\",Data!$C:$C,'Profitability - Gas Tx'!M$12))","v":2.9746734954666953E-2}]
[null,"Difference",{"$f":"IFERROR(C13-C14,\"\")","v":""},"","","","","","","","","",""]
[]
[null,"Source:\nPost tax revenue model - Pre-tax real WACC - 2014 to 2024"]
[]
[]
[null,"Return on regulated equity",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Return on regulated equity",{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,C$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,C$12))","v":6.0324298407150048E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,D$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,D$12))","v":5.6803086729211312E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,E$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,E$12))","v":0.15666196657651058},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,F$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,F$12))","v":0.16691047918413648},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,G$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,G$12))","v":0.20107520957309311},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,H$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,H$12))","v":0.1935120399605684},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,I$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,I$12))","v":0.1901607463531349},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,J$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,J$12))","v":0.19462458243867808},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,K$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,K$12))","v":0.13385047533466823},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,L$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,L$12))","v":0.18378445815069311},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Real return on regulated equity\",Data!$C:$C,M$12),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Nominal return on regulated equity\",Data!$C:$C,M$12))","v":0.10369699295538456}]
[null,"Allowed return on regulated equity",{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,C$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,C$20))","v":7.5865431496830782E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,D$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,D$20))","v":7.5865431496830782E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,E$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,E$20))","v":7.5865431496830782E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,F$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,F$20))","v":4.5991583362303003E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,G$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,G$20))","v":4.5991583362303003E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,H$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,H$20))","v":4.5991583362303003E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,I$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,I$20))","v":4.5991583362303003E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,J$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,J$20))","v":4.5991583362303003E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,K$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,K$20))","v":2.9413787972026002E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,L$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,L$20))","v":2.9413787972026002E-2},{"$f":"IF($C$6=\"Exclusive\",SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,\"Allowed real return on equity\",Data!$C:$C,M$20),SUMIFS(Data!$D:$D,Data!$A:$A,$C$4,Data!$B:$B,\"Allowed nominal return on equity\",Data!$C:$C,M$20))","v":2.9413787972025984E-2}]
[null,"Difference",{"$f":"C21-C22","v":-1.5541133089680734E-2},{"$f":"D21-D22","v":-1.906234476761947E-2},8.0796535079679793E-2,0.12091889582183349,0.15508362621079011,{"$f":"H21-H22","v":0.1475204565982654},0.14416916299083191,0.14863299907637509,{"$f":"K21-K22","v":0.10443668736264224},0.1543706701786671,7.4283204983358581E-2]
[]
[null,"Source:\nPost tax revenue model - Post tax real return on equity - 2014 to 2024"]
[]
[]
[null,"Detailed calculations"]
[]
[null,"Revenue",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Revenue",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!C$30)-IF($C$8=\"Exclusive\",C$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!D$30)-IF($C$8=\"Exclusive\",D$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!E$30)-IF($C$8=\"Exclusive\",E$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!F$30)-IF($C$8=\"Exclusive\",F$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!G$30)-IF($C$8=\"Exclusive\",G$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!H$30)-IF($C$8=\"Exclusive\",H$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!I$30)-IF($C$8=\"Exclusive\",I$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!J$30)-IF($C$8=\"Exclusive\",J$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!K$30)-IF($C$8=\"Exclusive\",K$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!L$30)-IF($C$8=\"Exclusive\",L$74,0)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B31,Data!$C:$C,'Profitability - Gas Tx'!M$30)-IF($C$8=\"Exclusive\",M$74,0)","v":0}]
[null,"Other Revenue",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!C$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!D$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!E$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!F$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!G$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!H$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!I$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!J$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!K$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!L$30)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B32,Data!$C:$C,'Profitability - Gas Tx'!M$30)","v":0}]
[null,"Total revenue",{"$f":"SUM(C31:C32)","v":0},{"$f":"SUM(D31:D32)","v":0},0,0,0,0,0,0,{"$f":"SUM(K31:K32)","v":0},0,0]
[]
[null,"Source:\nAnnual RIN Financial - Income Statement - 2014 to 2024"]
[]
[]
[null,"Cost of Goods Sold expenditure",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Other cost of goods sold expenditure",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!C$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!D$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!E$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!F$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!G$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!H$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!I$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!J$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!K$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!L$38)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B39,Data!$C:$C,'Profitability - Gas Tx'!M$38)","v":0}]
[null,"Total costs of goods sold expenditure",{"$f":"SUM(C39:C39)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(K39:K39)","v":0},0,0]
[]
[null,"Source:\nAnnual RIN Financial - Opex - 2014 to 2024"]
[]
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Total Gross Profit",{"$f":"C33-C40","v":0},{"$f":"D33-D40","v":0},0,0,0,0,0,0,{"$f":"K33-K40","v":0},{"$f":"L33-L40","v":0},{"$f":"M33-M40","v":0}]
[]
[null,"Expenditure",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Operating expenditure",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!C$48)","v":11412055.4549769},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!D$48)","v":11669200.226063799},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!E$48)","v":12125176.575495901},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!F$48)","v":12221570.514673101},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!G$48)","v":11748571.7381527},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!H$48)","v":12049037.2354184},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!I$48)","v":12198028.389327001},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!J$48)","v":10981058.6931371},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!K$48)","v":12991294.478964999},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!L$48)","v":15616022.402683085},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B49,Data!$C:$C,'Profitability - Gas Tx'!M$48)","v":14457007.31675612}]
[null,"Other expenditure",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!C$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!D$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!E$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!F$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!G$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!H$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!I$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!J$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!K$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!L$48)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B50,Data!$C:$C,'Profitability - Gas Tx'!M$48)","v":0}]
[null,"Total expenditure",{"$f":"SUM(C49:C50)","v":11412055.4549769},11669200.226063799,12125176.575495901,12221570.514673101,11748571.7381527,12049037.2354184,12198028.389327001,10981058.6931371,12991294.478964999,15616022.402683085,14457007.31675612]
[null,"Forecast operating and maintenance expenditure",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!C$48)","v":14520954.040157994},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!D$48)","v":15505760.298655719},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!E$48)","v":17303210.999184702},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!F$48)","v":12159581.117138203},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!G$48)","v":13406490.855660629},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!H$48)","v":14649002.523783557},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!I$48)","v":12719407.038252017},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!J$48)","v":13358563.801050317},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!K$48)","v":10729255.312687784},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!L$48)","v":10096317.387750341},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B52,Data!$C:$C,'Profitability - Gas Tx'!M$48)","v":11052579.829484787}]
[]
[null,"Source:\nAnnual RIN Financial - Opex - 2014 to 2024"]
[]
[]
[null,"Total Earnings before Interest, Tax, Depreciation & Amortisation (EBITDA)",{"$f":"C46-C51","v":-11412055.4549769},{"$f":"D46-D51","v":-11669200.226063799},-12125176.575495901,-12221570.514673101,-11748571.7381527,-12049037.2354184,-12198028.389327001,-10981058.6931371,{"$f":"K46-K51","v":-12991294.478964999},{"$f":"L46-L51","v":-15616022.402683085},{"$f":"M46-M51","v":-14457007.31675612}]
[]
[null,"Depreciation",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Nominal Straight Line Depreciation",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!C$59)","v":5635374.2433018684},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!D$59)","v":5864832.8439174062},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!E$59)","v":3381143.9242010978},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!F$59)","v":3509657.1845646985},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!G$59)","v":3812538.6796056172},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!H$59)","v":4008104.4425311699},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!I$59)","v":4203322.5477896715},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!J$59)","v":4410630.358515406},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!K$59)","v":4362193.6503275735},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!L$59)","v":4702275.3169966107},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B60,Data!$C:$C,'Profitability - Gas Tx'!M$59)","v":5228369.4794307947}]
[null,"Indexation of opening Regulatory Asset Base",{"$f":"IF($C$6=\"Inclusive\",C87*C80,\"n/a\")","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[]
[null,"Source:\nRoll Forward Model - Nominal straight line depreciation - 2014 to 2024\nWhere not available - Post tax revenue model - Nominal straight line depreciation (updated for CPI)"]
[]
[]
[null,"Total Earnings before Interest & Tax (EBIT)",{"$f":"IF($C$6=\"Inclusive\",C57-C60+C61,C57-C60)","v":-17047429.69827877},{"$f":"IF($C$6=\"Inclusive\",D57-D60+D61,D57-D60)","v":-17534033.069981206},-15506320.499696998,-15731227.699237799,-15561110.417758316,-16057141.67794957,-16401350.937116671,-15391689.051652506,{"$f":"IF($C$6=\"Inclusive\",K57-K60+K61,K57-K60)","v":-17353488.129292574},-20318297.719679695,{"$f":"IF($C$6=\"Inclusive\",M57-M60+M61,M57-M60)","v":-19685376.796186917}]
[]
[null,"Supplementary Information"]
[]
[null,"Incentive schemes",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"EBSS",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!C$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!D$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!E$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!F$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!G$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!H$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!I$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!J$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!K$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!L$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B71,Data!$C:$C,'Profitability - Gas Tx'!M$70)","v":0}]
[null,"Efficiency carryover",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!C$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!D$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!E$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!F$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!G$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!H$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!I$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!J$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!K$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!L$70)","v":2708684.8855203027},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B72,Data!$C:$C,'Profitability - Gas Tx'!M$70)","v":0}]
[null,"other",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!C$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!D$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!E$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!F$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!G$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!H$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!I$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!J$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!K$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!L$70)","v":0},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B73,Data!$C:$C,'Profitability - Gas Tx'!M$70)","v":0}]
[null,"Total revenue (penalties) allowed (deducted) through incentive schemes",{"$f":"SUM(C71:C73)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(K71:K73)","v":0},2708684.8855203027,0]
[]
[null,"Source:\nAnnual RIN - Revenue - 2014 to 2024"]
[]
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Opening Regulatory Asset Base (Nominal)",{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!C$79))","v":106147132.992309},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!D$79))","v":107634764.623615},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!E$79))","v":107385103.71539301},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!F$79))","v":115816817.302958},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!G$79))","v":119353974.90412401},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!H$79))","v":119721535.451296},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!I$79))","v":122573879.26917},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!J$79))","v":131234846.930748},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!K$79))","v":127583739.941971},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!L$79))","v":134104624.682289},{"$f":"IF($F$6=\"Yes\",#REF!,SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B80,Data!$C:$C,'Profitability - Gas Tx'!M$79))","v":147303164.780763}]
[null,"Opening RAB in common real dollar terms (for calculating real returns on assets)",{"$f":"C80*(1+C87)","v":109256914.93287139},109064444.91168109,108792772.0859566,117526285.10803138,121632549.70362113,121857511.30958965,124829839.25973114,132364240.89994933,132046989.15798697,144607460.08609566,153271870.99894375]
[]
[null,"Source:\nRoll Forward Model - Opening RAB Balance - 2014 to 2024"]
[]
[]
[null,"Inflation",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Inflation Rate",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!C$86)","v":2.9296900000000001E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!D$86)","v":1.32827E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!E$86)","v":1.31086E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!F$86)","v":1.47601E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!G$86)","v":1.9090900000000001E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!H$86)","v":1.7841200000000002E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!I$86)","v":1.8404899999999998E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!J$86)","v":8.6058999999999997E-3},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!K$86)","v":3.4982899999999997E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!L$86)","v":7.8318219291014124E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B87,Data!$C:$C,'Profitability - Gas Tx'!M$86)","v":4.0519877675840865E-2}]
[null,"Forecast inflation",{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!C$86)","v":2.5499999999999998E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!D$86)","v":2.5499999999999998E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!E$86)","v":2.5499999999999998E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!F$86)","v":2.3908812494749999E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!G$86)","v":2.3908812494749999E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!H$86)","v":2.3908812494749999E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!I$86)","v":2.3908812494749999E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!J$86)","v":2.3908812494749999E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!K$86)","v":1.9993872504847E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!L$86)","v":1.9993872504847E-2},{"$f":"SUMIFS(Data!$D:$D,Data!$A:$A,'Profitability - Gas Tx'!$C$4,Data!$B:$B,'Profitability - Gas Tx'!$B88,Data!$C:$C,'Profitability - Gas Tx'!M$86)","v":1.9993872504847632E-2}]
[]
[null,"Source:\nRoll Forward Model - Inflation Rate - 2014 to 2024"]