{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["CoverSheet","Description","Table of Contents","Inputs","GPB data","Timing","Diag","RAB","Tax","BBAR","Rev","MAR","Outputs","Outputs to Chartbook","Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":5,"defined_names":54,"comments":1,"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":"CoverSheet","index":0,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Gas Pipeline Businesses"]
["Price-Quality Regulation 1 October 2022 Reset"]
["Default Price Path Financial Model"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Published 31 May 2022"]

{"sheet":"Description","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[18,2,18,5],[19,2,19,5],[14,2,14,5],[13,2,13,5],[10,2,10,5],[11,2,11,5],[12,2,12,5]]}
["Description"]
[]
["General Description"]
[null,"This is the financial model prepared by the Commission to calculate starting prices for those GPBs (suppliers) that are subject to default price quality regulation as from 1 October 2022."]
[null,"Data"]
[null,"Are based on 2021 Information Dislosures."]
[null,"Notes:"]
[null,1,"Financial quantities in this model are expressed in NZD'000. All values are nominal, except for present values which are defined where they are used."]
[null,2,"All data used by the model are entered in the 'Input' worksheet. "]
[null,3,"The 'Output' worksheet uses Excel's data table facility to display the calculated results for all suppliers."]
[null,4,"The model shows the calculation of the outputs for the supplier selected in the 'Inputs' worksheet dropdown list in cell C3. "]
[null,5,"For each supplier, the calculated results are detailed in the Outputs worksheet."]
[null,6,"The applicable X factor used in the calculations is the industry-wide X  factor unless an alternative X factor is entered in the input worksheet in respect of that supplier. In practice, no supplier has an alternative X factor specified."]
[null,7,"A fill colour is used in cells containing a formula that links to another worksheet. "]
[null,8,"A right hand orange border is applied to cells containing a formula that differs from neighbouring cell on the right."]
[null,9,"A red font is applied to input cells to the workbook, including links to other workbooks."]
[]
["Economic Asset Stranding Mitigation"]
[null,"a","The sheet Output contains section which derives the Final ADF from blended ADF, which is copied from Asset Stranding workbook as values."]
[null,"b","Run the Macro which will derive the Final rounded X factor and again back solve for a Final ADF."]
[null,"c","The Model is then run with these Final Values"]

{"sheet":"Table of Contents","index":2,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
[]
[null,"Sheet Name","Link"]
[null,"Inputs","Inputs"]
[null,"GPB data","Inputs for the selected supplier"]
[null,"Timing","Timing"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"RAB","Regulatory asset base"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"Tax","Tax calculations"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"BBAR","Building blocks allowable revenue"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"Rev","Revenue growth index"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"MAR","Maximum allowable revenue"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"Outputs","DPP reset output table"]
[null,null,"Outputs"]
[null,"Outputs to Chartbook","Outputs to chartbook"]
[null,null,"Reasons Paper Charts"]
[null,null,"Chapter 4 tables"]
[null,null,"Transmission Determination Tables & Values"]
[null,null,"Distribution Determination Tables & Values"]
[null,"Notes","Model notes"]

{"sheet":"Inputs","index":3,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Inputs","Values, not time series","Early base year","Standard base year","Gap year","1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year"]
["All input data is entered into this worksheet.","Exceptions to the principle that an inputs sheet should not include anything other than inputs have this grey background."]
["Name of supplier currently chosen as the focus of this workbook",null,"Vector"]
["Supplier number (inferred from chosen name above)",null,{"$f":"HLOOKUP(GPB_name,Inputs!$B$22:$G$23,2,FALSE)","v":3}]
["Supplier number (from Output sheet)",null,{"$f":"Outputs!B22","v":3}]
["Inputs that are the same for all suppliers"]
["BBAR year ending in calendar year:",null,{"$f":"D7-1","v":2020},{"$f":"E7-1","v":2021},{"$f":"F7-1","v":2022},2023,{"$f":"F7+1","v":2024},{"$f":"G7+1","v":2025},{"$f":"H7+1","v":2026},{"$f":"I7+1","v":2027}]
["Forecast changes in CPI used for revaluations, June year-ends",null,null,{"$f":"[1]Output!G8","v":3.3428844317096473E-2},{"$f":"[1]Output!H8","v":6.2999999999999945E-2},{"$f":"[1]Output!I8","v":2.6000000000000023E-2},{"$f":"[1]Output!J8","v":2.2999999999999909E-2},{"$f":"[1]Output!K8","v":2.0000000000000018E-2},{"$f":"[1]Output!L8","v":2.0000000000000018E-2},{"$f":"[1]Output!M8","v":2.0000000000000018E-2}]
["Forecast changes in CPI used for revaluations, September year-ends",null,null,{"$f":"[1]Output!G9","v":4.933586337760909E-2},{"$f":"[1]Output!H9","v":5.0000000000000044E-2},{"$f":"[1]Output!I9","v":2.4999999999999911E-2},{"$f":"[1]Output!J9","v":2.200000000000002E-2},{"$f":"[1]Output!K9","v":2.0000000000000018E-2},{"$f":"[1]Output!L9","v":2.0000000000000018E-2},{"$f":"[1]Output!M9","v":2.0000000000000018E-2}]
["Forecast changes in the CPI element of the price path for GDB",null,null,{"$f":"[1]Output!G10","v":1.8826405867970575E-2},{"$f":"[1]Output!H10","v":1.4638828893688505E-2},{"$f":"[1]Output!I10","v":5.2149479659413522E-2},{"$f":"[1]Output!J10","v":4.6285303231120345E-2},{"$f":"[1]Output!K10","v":2.4743735220526197E-2},{"$f":"[1]Output!L10","v":2.1492154019882248E-2},{"$f":"[1]Output!M10","v":2.000000000000024E-2}]
["Forecast changes in the CPI element of the price path for GTB",null,null,{"$f":"[1]Output!G11","v":2.811532046700016E-2},{"$f":"[1]Output!H11","v":5.9549015063731225E-2},{"$f":"[1]Output!I11","v":3.0921227991357547E-2},{"$f":"[1]Output!J11","v":2.3244538463801812E-2},{"$f":"[1]Output!K11","v":2.0247991487292172E-2},{"$f":"[1]Output!L11","v":2.000000000000024E-2},{"$f":"[1]Output!M11","v":2.0000000000000018E-2}]
["Corporate tax rate",null,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003]
["Days from mid-year to year-end",182]
["Days from revenue date to year-end",148]
["Day prior to start of the regulatory period","2022-09-30"]
["Vanilla WACC (67th percentile)",6.1400000000000003E-2]
["Cost of debt",4.0399999999999998E-2]
["Leverage",0.42]
["Remaining asset life for additional assets before adjustment",45]
["Industry-wide X factor",0]
["Inputs that are specific to individual suppliers",null,null,null,null,null,null,null,"Selected supplier #:",{"$f":"Outputs!B22","v":3},"Value for selected supplier"]
["Name","GasNet","Powerco","Vector","First Gas distribution","First Gas transmission",null,null,null,null,{"$f":"INDEX(B22:F22,,$J$21)","v":"Vector"}]
["Supplier number",1,2,3,4,5]
["Early base year adopted?",false,false,false,false,false,null,null,null,null,{"$f":"INDEX(B24:F24,,$J$21)","v":false}]
["Last day in the standard base year","2021-06-30","2021-09-30","2021-06-30","2021-09-30","2021-09-30",null,null,null,null,{"$f":"INDEX(B25:F25,,$J$21)","v":"2021-06-30"}]
["Tax payable (payable) or deferred tax (deferred)","deferred","deferred","deferred","deferred","payable",null,null,null,null,"deferred"]
["Total revenue cap (TRC) or weighted avg price cap (WAPC)","WAPC","WAPC","WAPC","WAPC","TRC_FQ",null,null,null,null,"WAPC"]
["Adjustment factor (for accelerated depreciation) existing",{"$f":"ADF_GasNet","v":0.81488859839952976},{"$f":"ADF_PowerCo","v":0.83896143833212278},{"$f":"ADF_Vector","v":0.659350593591289},{"$f":"ADF_FGD","v":0.69349352067268055},{"$f":"ADF_FGT","v":0.7507305755130802},null,null,null,null,0.659350593591289]
["Adjustment factor (for accelerated depreciation) additional",{"$f":"B28","v":0.81488859839952976},{"$f":"C28","v":0.83896143833212278},0.659350593591289,0.69349352067268055,0.7507305755130802,null,null,null,null,0.659350593591289]
["Initial conditions"]
["Opening RAB",{"$f":"[2]Output!B5","v":24056},{"$f":"[2]Output!C5","v":388863.03033783386},{"$f":"[2]Output!D5","v":434256},{"$f":"[2]Output!E5","v":174405.16609032877},{"$f":"[2]Output!F5","v":849688.09291020641},null,null,null,null,{"$f":"INDEX(B31:F31,,$J$21)","v":434256}]
["Total depreciation",{"$f":"[2]Output!B6","v":890},{"$f":"[2]Output!C6","v":16520.801233017173},{"$f":"[2]Output!D6","v":12684},{"$f":"[2]Output!E6","v":6273.13395329998},{"$f":"[2]Output!F6","v":34267.213736700003},null,null,null,null,{"$f":"INDEX(B32:F32,,$J$21)","v":12684}]
["Closing RAB",{"$f":"[2]Output!B7","v":24943},{"$f":"[2]Output!C7","v":406139},{"$f":"[2]Output!D7","v":451131},{"$f":"[2]Output!E7","v":181908.46657050299},{"$f":"[2]Output!F7","v":874464.59547156945},null,null,null,null,451131]
["Opening RAB excluding revaluations",{"$f":"[2]Output!B8","v":21153},{"$f":"[2]Output!C8","v":347153.92666327732},{"$f":"[2]Output!D8","v":387877},{"$f":"[2]Output!E8","v":159463.31956999999},{"$f":"[2]Output!F8","v":0},null,null,null,null,387877]
["Adjusted depreciation",{"$f":"[2]Output!B9","v":756},{"$f":"[2]Output!C9","v":14618.992780098553},{"$f":"[2]Output!D9","v":11347},{"$f":"[2]Output!E9","v":5666.2117900000003},{"$f":"[2]Output!F9","v":0},null,null,null,null,11347]
["Tax depreciation",{"$f":"[2]Output!B10","v":668},{"$f":"[2]Output!C10","v":19094.195863992234},{"$f":"[2]Output!D10","v":18496},{"$f":"[2]Output!E10","v":8024.5645442000005},{"$f":"[2]Output!F10","v":22468.7337558},null,null,null,null,18496]
["Opening regulatory tax asset value",{"$f":"[2]Output!B11","v":6332},{"$f":"[2]Output!C11","v":174476.96227626284},{"$f":"[2]Output!D11","v":178920},{"$f":"[2]Output!E11","v":71182.166144752031},{"$f":"[2]Output!F11","v":205340.13392639998},null,null,null,null,178920]
["Amortisation of initial differences in asset values",{"$f":"[2]Output!B12","v":475.38535645472058},{"$f":"[2]Output!C12","v":2286.6438236598287},{"$f":"[2]Output!D12","v":2452.34375},{"$f":"[2]Output!E12","v":1682.6285714285718},{"$f":"[2]Output!F12","v":0},null,null,null,null,2452.34375]
["Term credit spread differential allowance",{"$f":"[2]Output!B13","v":0},{"$f":"[2]Output!C13","v":415.32120157761506},{"$f":"[2]Output!D13","v":394.71036710604159},{"$f":"[2]Output!E13","v":262.7097851636014},{"$f":"[2]Output!F13","v":1271.2165374407055},null,null,null,null,394.71036710604159]
["Opening deferred tax balance",{"$f":"[2]Output!B14","v":-1402},{"$f":"[2]Output!C14","v":-30580.635995102504},{"$f":"[2]Output!D14","v":-33959},{"$f":"[2]Output!E14","v":-8906.8248869922827},{"$f":"[2]Output!F14","v":0},null,null,null,null,-33959]
["Capital expenditure ~ value of commissioned assets",{"$f":"[2]Output!B15","v":961},{"$f":"[2]Output!C15","v":15514.613369451072},{"$f":"[2]Output!D15","v":15572},{"$f":"[2]Output!E15","v":5437.8258400000386},{"$f":"[2]Output!F15","v":18812.792070000003},null,null,null,null,15572]
["Alternative X factor (leave blank if no alternative)",-5.5E-2,-0.05,-0.03,-0.1,-8.5000000000000006E-2,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(B42:F42,,$J$21)),\"blank\",INDEX(B42:F42,,$J$21))","v":-0.03}]
["DPP2 2022 values",4383.9982678933238,51435.568618416459,50702.277198411044,24646.151307304975,131623.38640956243,null,null,null,null,{"$f":"IF(ISBLANK(INDEX(B43:F43,,$J$21)),\"blank\",INDEX(B43:F43,,$J$21))","v":50702.277198411044}]
["Operating expenditure"]
["Operating expenditure in year ending 2021",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B45:F45,,$J$21)","v":0}]
["Operating expenditure in year ending 2022",{"$f":"'[3]Reflation outputs'!B5","v":2105.869235328832},{"$f":"'[3]Reflation outputs'!C5","v":19191.840157610193},{"$f":"'[3]Reflation outputs'!D5","v":14561.01945440998},{"$f":"'[3]Reflation outputs'!E5","v":9825.8240745695639},{"$f":"'[3]Reflation outputs'!F5","v":49431.440867965168},null,null,null,null,14561.01945440998]
["Operating expenditure in year ending 2023",{"$f":"'[3]Reflation outputs'!B6","v":2553.4894983324602},{"$f":"'[3]Reflation outputs'!C6","v":19977.413409223424},{"$f":"'[3]Reflation outputs'!D6","v":15402.436705517925},{"$f":"'[3]Reflation outputs'!E6","v":10562.238769662188},{"$f":"'[3]Reflation outputs'!F6","v":53512.751743738787},null,null,null,null,15402.436705517925]
["Operating expenditure in year ending 2024",{"$f":"'[3]Reflation outputs'!B7","v":2644.9552453802248},{"$f":"'[3]Reflation outputs'!C7","v":20475.165671238672},{"$f":"'[3]Reflation outputs'!D7","v":15938.212911147304},{"$f":"'[3]Reflation outputs'!E7","v":11087.796840539884},{"$f":"'[3]Reflation outputs'!F7","v":55336.411363425221},null,null,null,null,15938.212911147304]
["Operating expenditure in year ending 2025",{"$f":"'[3]Reflation outputs'!B8","v":2722.3744902994758},{"$f":"'[3]Reflation outputs'!C8","v":21057.766360983063},{"$f":"'[3]Reflation outputs'!D8","v":16028.181170698097},{"$f":"'[3]Reflation outputs'!E8","v":11550.223584965943},{"$f":"'[3]Reflation outputs'!F8","v":56654.083035688513},null,null,null,null,16028.181170698097]
["Operating expenditure in year ending 2026",{"$f":"'[3]Reflation outputs'!B9","v":2793.6620963650807},{"$f":"'[3]Reflation outputs'!C9","v":21637.559296758685},{"$f":"'[3]Reflation outputs'!D9","v":16465.675083121463},{"$f":"'[3]Reflation outputs'!E9","v":11986.170278074527},{"$f":"'[3]Reflation outputs'!F9","v":58465.281875978297},null,null,null,null,16465.675083121463]
["Operating expenditure in year ending 2027",{"$f":"'[3]Reflation outputs'!B10","v":2866.7784327857148},{"$f":"'[3]Reflation outputs'!C10","v":22150.628993950744},{"$f":"'[3]Reflation outputs'!D10","v":16951.960145923575},{"$f":"'[3]Reflation outputs'!E10","v":12428.025095660512},{"$f":"'[3]Reflation outputs'!F10","v":59738.560892805966},null,null,null,null,16951.960145923575]
[]
["Constant price revenue growth"]
["Constant price revenue growth in year ending 2021",null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B54:F54,,$J$21)","v":0}]
["Constant price revenue growth in year ending 2022",{"$f":"[4]Output!B3","v":-1.0033357313083537E-3},{"$f":"[4]Output!C3","v":1.3650749273110253E-2},{"$f":"[4]Output!D3","v":1.4021796044457951E-2},{"$f":"[4]Output!E3","v":2.5957454831881638E-2},null,null,null,null,null,{"$f":"INDEX(B55:F55,,$J$21)","v":1.4021796044457951E-2}]
["Constant price revenue growth in year ending 2023",{"$f":"[4]Output!B4","v":-2.928582359688946E-3},{"$f":"[4]Output!C4","v":1.4238869128961456E-2},{"$f":"[4]Output!D4","v":1.5486737211301289E-2},{"$f":"[4]Output!E4","v":1.4469369291354192E-3},null,null,null,null,null,{"$f":"INDEX(B56:F56,,$J$21)","v":1.5486737211301289E-2}]
["Constant price revenue growth in year ending 2024",{"$f":"[4]Output!B5","v":-3.2063940725337173E-3},{"$f":"[4]Output!C5","v":1.3474823449693064E-2},{"$f":"[4]Output!D5","v":1.0322534348871322E-2},{"$f":"[4]Output!E5","v":1.2835748061561796E-3},null,null,null,null,null,1.0322534348871322E-2]
["Constant price revenue growth in year ending 2025",{"$f":"[4]Output!B6","v":-3.464122892165058E-3},{"$f":"[4]Output!C6","v":1.2735838124180559E-2},{"$f":"[4]Output!D6","v":1.0211894743768438E-2},{"$f":"[4]Output!E6","v":1.1230605141631651E-3},null,null,null,null,null,1.0211894743768438E-2]
["Constant price revenue growth in year ending 2026",{"$f":"[4]Output!B7","v":-3.7029118723585089E-3},{"$f":"[4]Output!C7","v":1.2023104585747879E-2},{"$f":"[4]Output!D7","v":1.0101002404889125E-2},{"$f":"[4]Output!E7","v":9.6563196286349098E-4},null,null,null,null,null,1.0101002404889125E-2]
["Constant price revenue growth in year ending 2027",{"$f":"[4]Output!B8","v":-3.9239072501137152E-3},{"$f":"[4]Output!C8","v":1.1344818856514565E-2},{"$f":"[4]Output!D8","v":1.0032881069838436E-2},{"$f":"[4]Output!E8","v":8.1136698196140845E-4},null,null,null,null,null,1.0032881069838436E-2]
["Constant price revenue growth in year ending 2028",null,null,null,null,null,null,null,null,null,0]
["Value of commissioned assets","Data for first row of value of commissioned assets linked differently from rest of panel"]
["Value of commissioned assets, yr ending 2021",{"$f":"B41","v":961},{"$f":"C41","v":15514.613369451072},15572,5437.8258400000386,18812.792070000003,null,null,null,null,{"$f":"INDEX(B63:F63,,$J$21)","v":15572}]
["Value of commissioned assets, yr ending 2022",{"$f":"'[3]Reflation outputs'!B14","v":831.32065970687563},{"$f":"'[3]Reflation outputs'!C14","v":18183.286092983861},{"$f":"'[3]Reflation outputs'!D14","v":7573.7436485038106},{"$f":"'[3]Reflation outputs'!E14","v":21122.861431981779},{"$f":"'[3]Reflation outputs'!F14","v":37106.20044752895},null,null,null,null,7573.7436485038106]
["Value of commissioned assets, yr ending 2023",{"$f":"'[3]Reflation outputs'!B15","v":932.2514036891273},{"$f":"'[3]Reflation outputs'!C15","v":19010.715084471627},{"$f":"'[3]Reflation outputs'!D15","v":6788.7522455598373},{"$f":"'[3]Reflation outputs'!E15","v":13894.172357694977},{"$f":"'[3]Reflation outputs'!F15","v":40302.49785512466},null,null,null,null,6788.7522455598373]
["Value of commissioned assets, yr ending 2024",{"$f":"'[3]Reflation outputs'!B16","v":1001.1422647258236},{"$f":"'[3]Reflation outputs'!C16","v":19197.178541899641},{"$f":"'[3]Reflation outputs'!D16","v":6162.4426395477321},{"$f":"'[3]Reflation outputs'!E16","v":14098.282332110999},{"$f":"'[3]Reflation outputs'!F16","v":47383.78588481043},null,null,null,null,6162.4426395477321]
["Value of commissioned assets, yr ending 2025",{"$f":"'[3]Reflation outputs'!B17","v":1035.8876096069982},{"$f":"'[3]Reflation outputs'!C17","v":20204.483261774491},{"$f":"'[3]Reflation outputs'!D17","v":6867.0688325574665},{"$f":"'[3]Reflation outputs'!E17","v":14182.298914524279},{"$f":"'[3]Reflation outputs'!F17","v":40281.496689504704},null,null,null,null,6867.0688325574665]
["Value of commissioned assets, yr ending 2026",{"$f":"'[3]Reflation outputs'!B18","v":1022.3941237608151},{"$f":"'[3]Reflation outputs'!C18","v":22084.790063844845},{"$f":"'[3]Reflation outputs'!D18","v":7880.5230590525516},{"$f":"'[3]Reflation outputs'!E18","v":14168.41740691315},{"$f":"'[3]Reflation outputs'!F18","v":42695.221917363131},null,null,null,null,7880.5230590525516]
["Value of commissioned assets, yr ending 2027",{"$f":"'[3]Reflation outputs'!B19","v":1050.7006304021706},{"$f":"'[3]Reflation outputs'!C19","v":22259.488314060134},{"$f":"'[3]Reflation outputs'!D19","v":8310.0314222874204},{"$f":"'[3]Reflation outputs'!E19","v":14595.556964571091},{"$f":"'[3]Reflation outputs'!F19","v":45010.918808408438},null,null,null,null,8310.0314222874204]
["Value of commissioned assets, yr ending 2028",null,null,null,null,null,null,null,null,null,0]
["Name","GasNet","Powerco","Vector","First Gas distribution","First Gas transmission"]
["Value of disposed assets"]
["Value of disposed assets, yr ending 2020",{"$f":"[2]Output!B17","v":0},{"$f":"[2]Output!C17","v":587},{"$f":"[2]Output!D17","v":48},{"$f":"[2]Output!E17","v":0},{"$f":"[2]Output!F17","v":53.007250000000006},null,null,null,null,48]
["Value of disposed assets, yr ending 2021",{"$f":"[2]Output!B18","v":0},{"$f":"[2]Output!C18","v":119.5918062400025},{"$f":"[2]Output!D18","v":280},{"$f":"[2]Output!E18","v":118.58533120000001},{"$f":"[2]Output!F18","v":1634.3483787999999},null,null,null,null,280]
["Value of disposed assets, yr ending 2022",{"$f":"[2]Output!B19","v":5.0525917907740485},{"$f":"[2]Output!C19","v":360.59178612043127},{"$f":"[2]Output!D19","v":105.06786362727907},{"$f":"[2]Output!E19","v":31.677926733376466},{"$f":"[2]Output!F19","v":466.06175750051341},null,null,null,null,105.06786362727907]
["Value of disposed assets, yr ending 2023",{"$f":"[2]Output!B20","v":5.1839591773341738},{"$f":"[2]Output!C20","v":369.60658077344198},{"$f":"[2]Output!D20","v":107.79962808158834},{"$f":"[2]Output!E20","v":32.469874901710874},{"$f":"[2]Output!F20","v":477.71330143802624},null,null,null,null,107.79962808158834]
["Value of disposed assets, yr ending 2024",{"$f":"[2]Output!B21","v":5.30319023841286},{"$f":"[2]Output!C21","v":377.73792555045776},{"$f":"[2]Output!D21","v":110.27901952746485},{"$f":"[2]Output!E21","v":33.184212149548515},{"$f":"[2]Output!F21","v":488.22299406966283},null,null,null,null,110.27901952746485]
["Value of disposed assets, yr ending 2025",{"$f":"[2]Output!B22","v":5.4092540431811171},{"$f":"[2]Output!C22","v":385.2926840614669},{"$f":"[2]Output!D22","v":112.48459991801417},{"$f":"[2]Output!E22","v":33.847896392539489},{"$f":"[2]Output!F22","v":497.98745395105612},null,null,null,null,112.48459991801417]
["Value of disposed assets, yr ending 2026",{"$f":"[2]Output!B23","v":5.5174391240447402},{"$f":"[2]Output!C23","v":392.99853774269627},{"$f":"[2]Output!D23","v":114.73429191637445},{"$f":"[2]Output!E23","v":34.524854320390283},{"$f":"[2]Output!F23","v":507.94720303007728},null,null,null,null,114.73429191637445]
["Value of disposed assets, yr ending 2027",{"$f":"[2]Output!B24","v":5.6277879065256355},{"$f":"[2]Output!C24","v":400.85850849755025},{"$f":"[2]Output!D24","v":117.02897775470194},{"$f":"[2]Output!E24","v":35.215351406798092},{"$f":"[2]Output!F24","v":518.10614709067886},null,null,null,null,117.02897775470194]
["Value of disposed assets, yr ending 2028",{"$f":"[2]Output!B25","v":5.7403436646561481},{"$f":"[2]Output!C25","v":408.87567866750123},{"$f":"[2]Output!D25","v":119.36955730979599},{"$f":"[2]Output!E25","v":35.91965843493405},{"$f":"[2]Output!F25","v":528.46827003249234},null,null,null,null,119.36955730979599]
["Other regulated income"]
["Other regulated income, yr ending 2023",{"$f":"[2]Output!B28","v":48.359301180219589},{"$f":"[2]Output!C28","v":614.30678635674963},{"$f":"[2]Output!D28","v":-106.08440959903018},{"$f":"[2]Output!E28","v":276.62057406724773},null,null,null,null,null,-106.08440959903018]
["Other regulated income, yr ending 2024",{"$f":"[2]Output!B29","v":49.47156510736464},{"$f":"[2]Output!C29","v":627.82153565659803},{"$f":"[2]Output!D29","v":-108.52435101980787},{"$f":"[2]Output!E29","v":282.70622669672724},null,null,null,null,null,-108.52435101980787]
["Other regulated income, yr ending 2025",{"$f":"[2]Output!B30","v":50.460996409511935},{"$f":"[2]Output!C30","v":640.37796636973007},{"$f":"[2]Output!D30","v":-110.69483804020403},{"$f":"[2]Output!E30","v":288.36035123066182},null,null,null,null,null,-110.69483804020403]
["Other regulated income, yr ending 2026",{"$f":"[2]Output!B31","v":51.470216337702176},{"$f":"[2]Output!C31","v":653.18552569712472},{"$f":"[2]Output!D31","v":-112.90873480100811},{"$f":"[2]Output!E31","v":294.12755825527506},null,null,null,null,null,-112.90873480100811]
["Other regulated income, yr ending 2027",{"$f":"[2]Output!B32","v":52.499620664456216},{"$f":"[2]Output!C32","v":666.24923621106723},{"$f":"[2]Output!D32","v":-115.16690949702829},{"$f":"[2]Output!E32","v":300.01010942038056},null,null,null,null,null,-115.16690949702829]
["Other regulated income, yr ending 2028",{"$f":"[2]Output!B33","v":53.549613077745342},{"$f":"[2]Output!C33","v":679.57422093528851},{"$f":"[2]Output!D33","v":-117.47024768696886},{"$f":"[2]Output!E33","v":306.01031160878819},null,null,null,null,null,-117.47024768696886]

{"sheet":"GPB data","index":4,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Inputs for the selected supplier","Values, not time series","Early base year","Standard base year","Gap year","1st BBAR or Pricing year","2nd BBAR or Pricing year","3rd BBAR or Pricing year","4th BBAR or Pricing year","5th BBAR or Pricing year"]
["Data from the Inputs sheet that relates to the selected supplier. The supplier's name is user-selected in cell C3 on the Inputs sheet.",null,{"$f":" TEXT(EOMONTH($B$17+1,-25)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,-12),\"dd.mm.yy\")","v":"01.07.19 to 30.06.20"},{"$f":" TEXT(EOMONTH($B$17+1,-13)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,0),\"dd.mm.yy\")","v":"01.07.20 to 30.06.21"},{"$f":" TEXT(EOMONTH($B$17+1,-1)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,12),\"dd.mm.yy\")","v":"01.07.21 to 30.06.22"},{"$f":" TEXT(EOMONTH($B$17+1,11)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,24),\"dd.mm.yy\")","v":"01.07.22 to 30.06.23"},{"$f":" TEXT(EOMONTH($B$17+1,23)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,36),\"dd.mm.yy\")","v":"01.07.23 to 30.06.24"},{"$f":" TEXT(EOMONTH($B$17+1,35)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,48),\"dd.mm.yy\")","v":"01.07.24 to 30.06.25"},{"$f":" TEXT(EOMONTH($B$17+1,47)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,60),\"dd.mm.yy\")","v":"01.07.25 to 30.06.26"},{"$f":" TEXT(EOMONTH($B$17+1,59)+1,\"dd.mm.yy\")  & \" to \" & TEXT(EOMONTH($B$17,72),\"dd.mm.yy\")","v":"01.07.26 to 30.06.27"}]
["Supplier",null,null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"}]
["Supplier number",null,{"$f":"Inputs!C5","v":3}]
["General data"]
["Non business-specific single inputs"]
[{"$f":"Inputs!A16","v":"Vanilla WACC (67th percentile)"},{"$f":"Inputs!B16","v":6.1400000000000003E-2}]
[{"$f":"Inputs!A17","v":"Cost of debt"},{"$f":"Inputs!B17","v":4.0399999999999998E-2}]
[{"$f":"Inputs!A18","v":"Leverage"},{"$f":"Inputs!B18","v":0.42}]
[{"$f":"Inputs!A19","v":"Remaining asset life for additional assets before adjustment"},{"$f":"Inputs!B19","v":45},"years"]
[{"$f":"Inputs!A20","v":"Industry-wide X factor"},{"$f":"Inputs!B20","v":0}]
[{"$f":"Inputs!A13","v":"Days from mid-year to year-end"},{"$f":"Inputs!B13","v":182},"days"]
[{"$f":"Inputs!A14","v":"Days from revenue date to year-end"},{"$f":"Inputs!B14","v":148},"days"]
[{"$f":"Inputs!A15","v":"Day prior to start of the regulatory period"},{"$f":"Inputs!B15","v":"2022-09-30"}]
["General time-series data"]
["Early base year adopted?",{"$f":"Inputs!K24","v":false}]
["Last day in the standard base year",{"$f":"Inputs!K25","v":"2021-06-30"}]
["BBAR year ending in calendar year:",null,{"$f":"Inputs!C7","v":2020},{"$f":"Inputs!D7","v":2021},{"$f":"Inputs!E7","v":2022},{"$f":"Inputs!F7","v":2023},{"$f":"Inputs!G7","v":2024},{"$f":"Inputs!H7","v":2025},{"$f":"Inputs!I7","v":2026},{"$f":"Inputs!J7","v":2027}]
[{"$f":"Inputs!A8","v":"Forecast changes in CPI used for revaluations, June year-ends"},null,null,{"$f":"Inputs!D8","v":3.3428844317096473E-2},{"$f":"Inputs!E8","v":6.2999999999999945E-2},{"$f":"Inputs!F8","v":2.6000000000000023E-2},{"$f":"Inputs!G8","v":2.2999999999999909E-2},{"$f":"Inputs!H8","v":2.0000000000000018E-2},{"$f":"Inputs!I8","v":2.0000000000000018E-2},{"$f":"Inputs!J8","v":2.0000000000000018E-2}]
[{"$f":"Inputs!A9","v":"Forecast changes in CPI used for revaluations, September year-ends"},null,null,{"$f":"Inputs!D9","v":4.933586337760909E-2},{"$f":"Inputs!E9","v":5.0000000000000044E-2},{"$f":"Inputs!F9","v":2.4999999999999911E-2},{"$f":"Inputs!G9","v":2.200000000000002E-2},{"$f":"Inputs!H9","v":2.0000000000000018E-2},{"$f":"Inputs!I9","v":2.0000000000000018E-2},{"$f":"Inputs!J9","v":2.0000000000000018E-2}]
[{"$f":"Inputs!A10","v":"Forecast changes in the CPI element of the price path for GDB"},null,null,null,null,{"$f":"Inputs!F10","v":5.2149479659413522E-2},{"$f":"Inputs!G10","v":4.6285303231120345E-2},{"$f":"Inputs!H10","v":2.4743735220526197E-2},{"$f":"Inputs!I10","v":2.1492154019882248E-2},{"$f":"Inputs!J10","v":2.000000000000024E-2}]
[{"$f":"Inputs!A11","v":"Forecast changes in the CPI element of the price path for GTB"},null,null,null,null,{"$f":"Inputs!F11","v":3.0921227991357547E-2},{"$f":"Inputs!G11","v":2.3244538463801812E-2},{"$f":"Inputs!H11","v":2.0247991487292172E-2},{"$f":"Inputs!I11","v":2.000000000000024E-2},{"$f":"Inputs!J11","v":2.0000000000000018E-2}]
[{"$f":"Inputs!A12","v":"Corporate tax rate"},null,{"$f":"Inputs!C12","v":0.28000000000000003},{"$f":"Inputs!D12","v":0.28000000000000003},{"$f":"Inputs!E12","v":0.28000000000000003},{"$f":"Inputs!F12","v":0.28000000000000003},{"$f":"Inputs!G12","v":0.28000000000000003},{"$f":"Inputs!H12","v":0.28000000000000003},{"$f":"Inputs!I12","v":0.28000000000000003},{"$f":"Inputs!J12","v":0.28000000000000003}]
["Business-specific data"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$18","v":2021},{"$f":"E$18","v":2022},2023,2024,2025,2026,2027]
[{"$f":"\"Forecast changes in CPI used for revaluations, \" & TEXT(B17, \"mmm\")  & \" year-ends\"","v":"Forecast changes in CPI used for revaluations, Jun year-ends"},null,null,{"$f":"IF(MONTH($B$17)=6,D19,D20)","v":3.3428844317096473E-2},{"$f":"IF(MONTH($B$17)=6,E19,E20)","v":6.2999999999999945E-2},2.6000000000000023E-2,2.2999999999999909E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
["CPI price-path",null,null,{"$f":"IF(MONTH($B$17)=6,D21,D22)","v":0},{"$f":"IF(MONTH($B$17)=6,E21,E22)","v":0},{"$f":"IF(Scenario=5,F22,F21)","v":5.2149479659413522E-2},4.6285303231120345E-2,2.4743735220526197E-2,2.1492154019882248E-2,2.000000000000024E-2]
["Year-end timing, tax approach and form of control"]
[{"$f":"Inputs!A26","v":"Tax payable (payable) or deferred tax (deferred)"},{"$f":"Inputs!K26","v":"deferred"}]
[{"$f":"Inputs!A27","v":"Total revenue cap (TRC) or weighted avg price cap (WAPC)"},{"$f":"Inputs!K27","v":"WAPC"}]
["Adjustment factor (for accelerated depreciation) existing",{"$f":"Inputs!K28","v":0.659350593591289}]
["Adjustment factor (for accelerated depreciation) additional",{"$f":"Inputs!K29","v":0.659350593591289}]
[null,null,{"$f":"C1","v":"Early base year"},{"$f":"D1","v":"Standard base year"}]
[{"$f":"Inputs!A31","v":"Opening RAB"},{"$f":"Inputs!K31","v":434256},{"$f":"IF(EarlyBaseYear,B34,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,\"~\",B34)","v":434256}]
[{"$f":"Inputs!A32","v":"Total depreciation"},{"$f":"Inputs!K32","v":12684},"~",12684]
[{"$f":"Inputs!A33","v":"Closing RAB"},{"$f":"Inputs!K33","v":451131},"~",451131]
[{"$f":"Inputs!A34","v":"Opening RAB excluding revaluations"},{"$f":"Inputs!K34","v":387877},"~",387877]
[{"$f":"Inputs!A35","v":"Adjusted depreciation"},{"$f":"Inputs!K35","v":11347},"~",11347]
[{"$f":"Inputs!A36","v":"Tax depreciation"},{"$f":"Inputs!K36","v":18496},"~",18496]
[{"$f":"Inputs!A37","v":"Opening regulatory tax asset value"},{"$f":"Inputs!K37","v":178920},"~",178920]
[{"$f":"Inputs!A39","v":"Term credit spread differential allowance"},{"$f":"IF(Inputs!K39>0,Inputs!K39,0)","v":394.71036710604159},"~",{"$f":"IF(EarlyBaseYear,\"~\",B41)","v":394.71036710604159}]
[{"$f":"Inputs!A40","v":"Opening deferred tax balance"},{"$f":"Inputs!K40","v":-33959},"~",{"$f":"IF(EarlyBaseYear,\"~\",B42)","v":-33959}]
[{"$f":"Inputs!A38","v":"Amortisation of initial differences in asset values"},{"$f":"Inputs!K38","v":2452.34375}]
["Alternative X factor (insert \"blank\" if no alternative)",{"$f":"Inputs!K42","v":-0.03}]
["DPP2 2022 prices",{"$f":"Inputs!K43","v":50702.277198411044}]
["Operating expenditure"]
[{"$f":"Inputs!A45","v":"Operating expenditure in year ending 2021"},{"$f":"Inputs!K45","v":0}]
[{"$f":"Inputs!A46","v":"Operating expenditure in year ending 2022"},{"$f":"Inputs!K46","v":14561.01945440998}]
[{"$f":"Inputs!A47","v":"Operating expenditure in year ending 2023"},{"$f":"Inputs!K47","v":15402.436705517925},"1st BBAR year"]
[{"$f":"Inputs!A48","v":"Operating expenditure in year ending 2024"},{"$f":"Inputs!K48","v":15938.212911147304}]
[{"$f":"Inputs!A49","v":"Operating expenditure in year ending 2025"},{"$f":"Inputs!K49","v":16028.181170698097}]
[{"$f":"Inputs!A50","v":"Operating expenditure in year ending 2026"},{"$f":"Inputs!K50","v":16465.675083121463}]
[{"$f":"Inputs!A51","v":"Operating expenditure in year ending 2027"},{"$f":"Inputs!K51","v":16951.960145923575}]
[]
["Operating expenditure in each year",null,null,{"$f":"TRANSPOSE(B47:B53)","v":0},14561.01945440998,15402.436705517925,15938.212911147304,16028.181170698097,16465.675083121463,16951.960145923575]
["Constant price revenue growth"]
[]
[{"$f":"Inputs!A54","v":"Constant price revenue growth in year ending 2021"},{"$f":"Inputs!K54","v":0}]
[{"$f":"Inputs!A55","v":"Constant price revenue growth in year ending 2022"},{"$f":"Inputs!K55","v":1.4021796044457951E-2}]
[{"$f":"Inputs!A56","v":"Constant price revenue growth in year ending 2023"},{"$f":"Inputs!K56","v":1.5486737211301289E-2},"1st pricing year"]
[{"$f":"Inputs!A57","v":"Constant price revenue growth in year ending 2024"},{"$f":"Inputs!K57","v":1.0322534348871322E-2}]
[{"$f":"Inputs!A58","v":"Constant price revenue growth in year ending 2025"},{"$f":"Inputs!K58","v":1.0211894743768438E-2}]
[{"$f":"Inputs!A59","v":"Constant price revenue growth in year ending 2026"},{"$f":"Inputs!K59","v":1.0101002404889125E-2}]
[{"$f":"Inputs!A60","v":"Constant price revenue growth in year ending 2027"},{"$f":"Inputs!K60","v":1.0032881069838436E-2}]
[{"$f":"Inputs!A61","v":"Constant price revenue growth in year ending 2028"},{"$f":"Inputs!K61","v":0}]
["Constant price revenue growth in each year",null,null,{"$f":"TRANSPOSE(B58:B64)","v":0},1.4021796044457951E-2,1.5486737211301289E-2,1.0322534348871322E-2,1.0211894743768438E-2,1.0101002404889125E-2,1.0032881069838436E-2]
["Value of commissioned assets"]
[]
[{"$f":"Inputs!A63","v":"Value of commissioned assets, yr ending 2021"},{"$f":"Inputs!K63","v":15572}]
[{"$f":"Inputs!A64","v":"Value of commissioned assets, yr ending 2022"},{"$f":"Inputs!K64","v":7573.7436485038106}]
[{"$f":"Inputs!A65","v":"Value of commissioned assets, yr ending 2023"},{"$f":"Inputs!K65","v":6788.7522455598373},"1st BBAR year"]
[{"$f":"Inputs!A66","v":"Value of commissioned assets, yr ending 2024"},{"$f":"Inputs!K66","v":6162.4426395477321}]
[{"$f":"Inputs!A67","v":"Value of commissioned assets, yr ending 2025"},{"$f":"Inputs!K67","v":6867.0688325574665}]
[{"$f":"Inputs!A68","v":"Value of commissioned assets, yr ending 2026"},{"$f":"Inputs!K68","v":7880.5230590525516}]
[{"$f":"Inputs!A69","v":"Value of commissioned assets, yr ending 2027"},{"$f":"Inputs!K69","v":8310.0314222874204}]
[{"$f":"Inputs!A70","v":"Value of commissioned assets, yr ending 2028"},{"$f":"Inputs!K70","v":0}]
["Value of commissioned assets in each year",null,null,{"$f":"TRANSPOSE(B69:B75)","v":15572},7573.7436485038106,6788.7522455598373,6162.4426395477321,6867.0688325574665,7880.5230590525516,8310.0314222874204]
["Disposed assets"]
[{"$f":"Inputs!A73","v":"Value of disposed assets, yr ending 2020"},{"$f":"Inputs!K73","v":48}]
[{"$f":"Inputs!A74","v":"Value of disposed assets, yr ending 2021"},{"$f":"Inputs!K74","v":280}]
[{"$f":"Inputs!A75","v":"Value of disposed assets, yr ending 2022"},{"$f":"Inputs!K75","v":105.06786362727907}]
[{"$f":"Inputs!A76","v":"Value of disposed assets, yr ending 2023"},{"$f":"Inputs!K76","v":107.79962808158834},"1st BBAR year"]
[{"$f":"Inputs!A77","v":"Value of disposed assets, yr ending 2024"},{"$f":"Inputs!K77","v":110.27901952746485}]
[{"$f":"Inputs!A78","v":"Value of disposed assets, yr ending 2025"},{"$f":"Inputs!K78","v":112.48459991801417}]
[{"$f":"Inputs!A79","v":"Value of disposed assets, yr ending 2026"},{"$f":"Inputs!K79","v":114.73429191637445}]
[{"$f":"Inputs!A80","v":"Value of disposed assets, yr ending 2027"},{"$f":"Inputs!K80","v":117.02897775470194}]
[{"$f":"Inputs!A81","v":"Value of disposed assets, yr ending 2028"},{"$f":"Inputs!K81","v":119.36955730979599}]
["Value of disposed assets in each year",null,{"$f":"TRANSPOSE(B79:B86)","v":48},280,105.06786362727907,107.79962808158834,110.27901952746485,112.48459991801417,114.73429191637445,117.02897775470194]
["Other regulated income"]
[{"$f":"Inputs!A83","v":"Other regulated income, yr ending 2023"},{"$f":"Inputs!K83","v":-106.08440959903018},"1st BBAR year"]
[{"$f":"Inputs!A84","v":"Other regulated income, yr ending 2024"},{"$f":"Inputs!K84","v":-108.52435101980787}]
[{"$f":"Inputs!A85","v":"Other regulated income, yr ending 2025"},{"$f":"Inputs!K85","v":-110.69483804020403}]
[{"$f":"Inputs!A86","v":"Other regulated income, yr ending 2026"},{"$f":"Inputs!K86","v":-112.90873480100811}]
[{"$f":"Inputs!A87","v":"Other regulated income, yr ending 2027"},{"$f":"Inputs!K87","v":-115.16690949702829}]
[{"$f":"Inputs!A88","v":"Other regulated income, yr ending 2028"},{"$f":"Inputs!K88","v":-117.47024768696886}]
["Other regulated income in each year",null,null,null,null,{"$f":"TRANSPOSE(B90:B94)","v":-106.08440959903018},-108.52435101980787,-110.69483804020403,-112.90873480100811,-115.16690949702829]

{"sheet":"Timing","index":5,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Timing",null,null,null,null,"1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year"]
["Calculations related to timing"]
["Inputs"]
["Days from mid-year to year-end",null,{"$f":"'GPB data'!B12","v":182}]
["Days from revenue date to year-end",null,{"$f":"'GPB data'!B13","v":148}]
["Vanilla WACC (67th percentile)",null,{"$f":"WACC","v":6.1400000000000003E-2}]
[{"$f":"'GPB data'!A17","v":"Last day in the standard base year"},null,{"$f":"'GPB data'!B17","v":"2021-06-30"}]
[{"$f":"'GPB data'!A14","v":"Day prior to start of the regulatory period"},null,{"$f":"'GPB data'!B14","v":"2022-09-30"}]
["Calculations"]
["Year-end of 1st BBAR year",null,{"$f":"EOMONTH(C7,24)","v":"2023-06-30"}]
["TFrev for MAR calculations",null,{"$f":"(1+$C$6)^(C5/365)","v":1.0244562975994667},"Intra-year timing factor: discount from revenue date to end of year values"]
["Number of days between mid-period and revenue date",null,{"$f":"C4-C5","v":34}]
[null,null,null,null,null,"1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year"]
["BBAR year ending in calendar year:",null,null,null,null,{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},{"$f":"'GPB data'!J18","v":2027}]
["Date of the end of the BBAR year",null,null,null,null,{"$f":"EOMONTH(C$7,24)","v":"2023-06-30"},{"$f":"EOMONTH(F15,12)","v":"2024-06-30"},"2025-06-30","2026-06-30","2027-06-30"]
["Date of the start of the BBAR year",null,null,null,null,{"$f":"EOMONTH(C$7,12)","v":"2022-06-30"},"2023-06-30","2024-06-30","2025-06-30","2026-06-30"]
["Number of days in the BBAR year",null,null,null,null,{"$f":"F15-F16","v":365},366,365,365,365]
["Date of the end of the BBAR period",null,null,null,null,{"$f":"EOMONTH(C7,24)","v":"2023-06-30"},{"$f":"EOMONTH(F18,12)","v":"2024-06-30"},{"$f":"EOMONTH(G18,12)","v":"2025-06-30"},{"$f":"EOMONTH(H18,12)","v":"2026-06-30"},{"$f":"EOMONTH(C8,48)","v":"2026-09-30"}]
["Date of the start of the BBAR period",null,null,null,null,{"$f":"C8","v":"2022-09-30"},{"$f":"F18","v":"2023-06-30"},{"$f":"G18","v":"2024-06-30"},{"$f":"H18","v":"2025-06-30"},{"$f":"I18","v":"2026-06-30"}]
["Number of days in the BBAR period",null,null,null,null,{"$f":"F18-F19","v":273},366,365,365,92]
["Number of days in the latter half of the BBAR period",null,null,null,null,{"$f":"ROUNDDOWN(F20/2,0)","v":136},183,182,182,46]
["Mid period date",null,null,null,null,{"$f":"F18-F21","v":"2023-02-14"},"2023-12-30","2024-12-30","2025-12-30","2026-08-15"]
["Tax date",null,null,null,null,{"$f":"F18-F21","v":"2023-02-14"},"2023-12-30","2024-12-30","2025-12-30","2026-08-15"]
["Number days between tax date and period-end",null,null,null,null,{"$f":"F18-F23","v":136},183,182,182,46]
["Number days between revenue date and period-end",null,null,null,null,{"$f":"F21-$C$12","v":102},149,148,148,12]
["Outputs"]
["TFrev for MAR calculations",null,{"$f":"$C$11","v":1.0244562975994667}]
["Number of days in the BBAR period",null,null,null,null,{"$f":"F20","v":273},366,365,365,92]
["Proportion of building blocks year that is in PV period",null,null,null,null,{"$f":"F28/F17","v":0.74794520547945209},1,1,1,0.25205479452054796]
["TFmid",null,null,null,null,{"$f":"(1+$C$6)^(F21/F17)","v":1.0224512667685453},1.0302426898551622,1.0301585961411983,1.0301585961411983,1.0075380897096562]
["TFtax",null,null,null,null,{"$f":"(1+$C$6)^(F24/F17)","v":1.0224512667685453},1.0302426898551622,1.0301585961411983,1.0301585961411983,1.0075380897096562]
["TFrev",null,null,null,null,{"$f":"(1+$C$6)^(F25/F17)","v":1.0167916310684448},{"$f":"(1+$C$6)^(G25/G17)","v":1.0245554640608723},1.0244562975994667,1.0244562975994667,1.0019610038112214]

{"sheet":"Diag","index":6,"n_rows":34,"n_cols":37,"rows_kept":34,"cut":false,"hidden":false,"merged":[[22,26,22,29],[20,26,20,29],[13,29,13,32]]}
[]
["Gas Pipeline Businesses - DPP reset - Years in the next regulatory period"]
[]
[null,"first day in quarter",{"$f":"EOMONTH(C5,-3)+1","v":"2019-10-01"},"2020-01-01","2020-04-01","2020-07-01","2020-10-01","2021-01-01","2021-04-01","2021-07-01","2021-10-01",{"$f":"EOMONTH(L5,-3)+1","v":"2022-01-01"},{"$f":"EOMONTH(M5,-3)+1","v":"2022-04-01"},{"$f":"EOMONTH(N5,-3)+1","v":"2022-07-01"},"2022-10-01","2023-01-01","2023-04-01","2023-07-01","2023-10-01","2024-01-01","2024-04-01","2024-07-01","2024-10-01","2025-01-01","2025-04-01","2025-07-01","2025-10-01","2026-01-01","2026-04-01","2026-07-01","2026-10-01","2027-01-01","2027-04-01","2027-07-01","2027-10-01","2028-01-01","2028-04-01"]
[null,"last day in quarter","2019-12-31",{"$f":"EOMONTH(C5,3)","v":"2020-03-31"},{"$f":"EOMONTH(D5,3)","v":"2020-06-30"},"2020-09-30","2020-12-31","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31","2028-03-31","2028-06-30"]
["Columns in the RAB, Tax & BBAR sheets"]
[]
[null,null,"C",null,null,null,"D",null,null,null,"E",null,null,null,"F",null,null,null,"G",null,null,null,"H",null,null,null,"I",null,null,null,"J"]
[]
[null,"Last month in the quarter",{"$f":"C5","v":"2019-12-31"},{"$f":"D5","v":"2020-03-31"},"2020-06-30","2020-09-30","2020-12-31","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30"]
[]
["30 June year-end for ID (Vector, GasNet)"]
[null,null,null,null,null,null,"Standard base year",null,null,null,"Gap year",null,null,null,"1st BBAR year",null,null,null,"2nd BBAR year",null,null,null,"3rd BBAR year",null,null,null,"4th BBAR year",null,null,null,"5th BBAR year"]
[null,"Disclosure years",null,null,null,{"$f":"TEXT(F$4,\"dd.mm.yy\") & \" to \" & TEXT(I$5,\"dd.mm.yy\")","v":"01.07.20 to 30.06.21"},null,null,null,null,null,null,null,{"$f":"TEXT(N$4,\"dd.mm.yy\") & \" to \" & TEXT(Q$5,\"dd.mm.yy\")","v":"01.07.22 to 30.06.23"},null,null,null,{"$f":"TEXT(R$4,\"dd.mm.yy\") & \" to \" & TEXT(U$5,\"dd.mm.yy\")","v":"01.07.23 to 30.06.24"},null,null,null,{"$f":"TEXT(V$4,\"dd.mm.yy\") & \" to \" & TEXT(Y$5,\"dd.mm.yy\")","v":"01.07.24 to 30.06.25"},null,null,null,{"$f":"TEXT(Z$4,\"dd.mm.yy\") & \" to \" & TEXT(AC$5,\"dd.mm.yy\")","v":"01.07.25 to 30.06.26"},null,null,null,{"$f":"TEXT(AD$4,\"dd.mm.yy\") & \" to \" & TEXT(AG$5,\"dd.mm.yy\")","v":"01.07.26 to 30.06.27"}]
[]
[null,"Pricing years",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(O$4,\"dd.mm.yy\") & \" to \" & TEXT(R$5,\"dd.mm.yy\")","v":"01.10.22 to 30.09.23"},null,null,null,{"$f":"TEXT(S$4,\"dd.mm.yy\") & \" to \" & TEXT(V$5,\"dd.mm.yy\")","v":"01.10.23 to 30.09.24"},null,null,null,{"$f":"TEXT(W$4,\"dd.mm.yy\") & \" to \" & TEXT(Z$5,\"dd.mm.yy\")","v":"01.10.24 to 30.09.25"},null,null,null,{"$f":"TEXT(AA$4,\"dd.mm.yy\") & \" to \" & TEXT(AD$5,\"dd.mm.yy\")","v":"01.10.25 to 30.09.26"},null,null,null,{"$f":"TEXT(AE$4,\"dd.mm.yy\") & \" to \" & TEXT(AH$5,\"dd.mm.yy\")","v":"01.10.26 to 30.09.27"}]
[]
[null,"Regulatory period",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(O$4,\"dd.mm.yy\") & \" to \" & TEXT(AH$5,\"dd.mm.yy\")","v":"01.10.22 to 30.09.27"}]
["30 September year-end for ID (Powerco, First Gas Distribution, First Gas Transmission)"]
[null,null,null,null,null,null,null,"Standard base year",null,null,null,"Gap year",null,null,null,"1st BBAR year",null,null,null,"2nd BBAR year",null,null,null,"3rd BBAR year",null,null,null,"4th BBAR year"]
[null,"Disclosure years",{"$f":"TEXT(C$4,\"dd.mm.yy\") & \" to \" & TEXT(F$5,\"dd.mm.yy\")","v":"01.10.19 to 30.09.20"},null,null,null,{"$f":"TEXT(G$4,\"dd.mm.yy\") & \" to \" & TEXT(J$5,\"dd.mm.yy\")","v":"01.10.20 to 30.09.21"},null,null,null,null,null,null,null,{"$f":"TEXT(O$4,\"dd.mm.yy\") & \" to \" & TEXT(R$5,\"dd.mm.yy\")","v":"01.10.22 to 30.09.23"},null,null,null,{"$f":"TEXT(S$4,\"dd.mm.yy\") & \" to \" & TEXT(V$5,\"dd.mm.yy\")","v":"01.10.23 to 30.09.24"},null,null,null,{"$f":"TEXT(W$4,\"dd.mm.yy\") & \" to \" & TEXT(Z$5,\"dd.mm.yy\")","v":"01.10.24 to 30.09.25"},null,null,null,{"$f":"TEXT(AA$4,\"dd.mm.yy\") & \" to \" & TEXT(AD$5,\"dd.mm.yy\")","v":"01.10.25 to 30.09.26"}]
[]
[null,"Pricing years",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(O$4,\"dd.mm.yy\") & \" to \" & TEXT(R$5,\"dd.mm.yy\")","v":"01.10.22 to 30.09.23"},null,null,null,{"$f":"TEXT(S$4,\"dd.mm.yy\") & \" to \" & TEXT(V$5,\"dd.mm.yy\")","v":"01.10.23 to 30.09.24"},null,null,null,{"$f":"TEXT(W$4,\"dd.mm.yy\") & \" to \" & TEXT(Z$5,\"dd.mm.yy\")","v":"01.10.24 to 30.09.25"},null,null,null,{"$f":"TEXT(AA$4,\"dd.mm.yy\") & \" to \" & TEXT(AD$5,\"dd.mm.yy\")","v":"01.10.25 to 30.09.26"}]
[]
[null,"Regulatory period",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(O$4,\"dd.mm.yy\") & \" to \" & TEXT(AH$5,\"dd.mm.yy\")","v":"01.10.22 to 30.09.27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st MAR year",null,null,null,"2nd MAR year",null,null,null,"3rd MAR year",null,null,null,"4th MAR year"]
["Columns in the MAR sheet:",null,null,null,"C",null,"D",null,null,null,"E",null,null,null,"F",null,null,null,"G",null,null,null,"H",null,null,null,"I"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"B4","v":"first day in quarter"},null,{"$f":"L4","v":"2022-01-01"},{"$f":"M4","v":"2022-04-01"},"2022-07-01","2022-10-01","2023-01-01","2023-04-01","2023-07-01","2023-10-01","2024-01-01","2024-04-01","2024-07-01","2024-10-01","2025-01-01","2025-04-01","2025-07-01","2025-10-01","2026-01-01","2026-04-01","2026-07-01","2026-10-01","2027-01-01","2027-04-01","2027-07-01","2027-10-01","2028-01-01","2028-04-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"B5","v":"last day in quarter"},null,{"$f":"L5","v":"2022-03-31"},"2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31","2028-03-31","2028-06-30"]

{"sheet":"RAB","index":7,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Regulatory asset base","Values, not time series","Early base year","Standard base year","Gap year","1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year",null,"Spec ref","GTB IM reference","GDB IM reference"]
["Calculations relating to RAB values for full years"]
["Inputs",null,null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"}]
["BBAR year ending in calendar year:",null,{"$f":"'GPB data'!C18","v":2020},{"$f":"'GPB data'!D18","v":2021},{"$f":"'GPB data'!E18","v":2022},{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},{"$f":"'GPB data'!J18","v":2027}]
["Opening RAB",null,{"$f":"'GPB data'!C34","v":"~"},{"$f":"'GPB data'!D34","v":434256}]
["Total depreciation",null,{"$f":"'GPB data'!C35","v":"~"},{"$f":"'GPB data'!D35","v":12684}]
["Closing RAB",null,{"$f":"'GPB data'!C36","v":"~"},{"$f":"'GPB data'!D36","v":451131}]
["Value of disposed assets",null,null,{"$f":"'GPB data'!D88","v":280},{"$f":"'GPB data'!E88","v":105.06786362727907},{"$f":"'GPB data'!F88","v":107.79962808158834},{"$f":"'GPB data'!G88","v":110.27901952746485},{"$f":"'GPB data'!H88","v":112.48459991801417},{"$f":"'GPB data'!I88","v":114.73429191637445},{"$f":"'GPB data'!J88","v":117.02897775470194}]
["Value of commissioned assets",null,null,{"$f":"'GPB data'!D77","v":15572},{"$f":"'GPB data'!E77","v":7573.7436485038106},{"$f":"'GPB data'!F77","v":6788.7522455598373},{"$f":"'GPB data'!G77","v":6162.4426395477321},{"$f":"'GPB data'!H77","v":6867.0688325574665},{"$f":"'GPB data'!I77","v":7880.5230590525516},{"$f":"'GPB data'!J77","v":8310.0314222874204}]
["Remaining life for additional assets before adjustment factor",{"$f":"'GPB data'!B10","v":45}]
["Forecast changes in CPI used for revaluations",null,null,{"$f":"'GPB data'!D26","v":3.3428844317096473E-2},{"$f":"'GPB data'!E26","v":6.2999999999999945E-2},{"$f":"'GPB data'!F26","v":2.6000000000000023E-2},{"$f":"'GPB data'!G26","v":2.2999999999999909E-2},{"$f":"'GPB data'!H26","v":2.0000000000000018E-2},{"$f":"'GPB data'!I26","v":2.0000000000000018E-2},{"$f":"'GPB data'!J26","v":2.0000000000000018E-2}]
["Adjustment factor (for accelerated depreciation) existing",{"$f":"'GPB data'!B31","v":0.659350593591289}]
["Adjustment factor (for accelerated depreciation) additional",{"$f":"'GPB data'!B32","v":0.659350593591289}]
["Remaining life for additional assets after adjustment",{"$f":"B10*B13","v":29.670776711608006}]
["Proportion of building blocks year that is in PV period",{"$f":"Timing!F29","v":0.74794520547945209}]
["Calculations"]
["Roll forward of existing assets",null,"Early base year","Base year","Gap year","First year of reg period"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},2022,2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Remaining asset life for existing assets",null,{"$f":"IF(EarlyBaseYear,100%*C5/C6,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C19-1,100%*D5/D6)","v":34.236518448438979},{"$f":"D19-1","v":33.236518448438979},{"$f":"IF(EarlyBaseYear,B12*C5/C6-3,B12*D5/D6-2)","v":20.573868761477357},{"$f":"F19-1","v":19.573868761477357},{"$f":"G19-1","v":18.573868761477357},17.573868761477357,16.573868761477357,null,null,"4.2.2(3)(a)","4.2.2(3)(a)"]
["Opening RAB value for existing assets",null,{"$f":"IF(EarlyBaseYear,C5,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C24,D5)","v":434256},{"$f":"D24","v":451131},{"$f":"E24","v":465838.79152948648},455185.63045960985,{"$f":"G24","v":442276.85473566828},427187.03318375768,411297.11968253361,null,null,"4.2.1(2)(b)","4.2.1(2)(b)"]
["Value of disposed assets",null,null,{"$f":"D8","v":280},105.06786362727907,107.79962808158834,110.27901952746485,112.48459991801417,114.73429191637445,117.02897775470194,null,"simple ref"]
["Revaluation for existing assets",null,null,{"$f":"(D20*0.999-D21)*D11","v":14492.799465138494},28386.212471591458,12096.89398085677,10456.263813621281,8834.4418656202997,8532.9022371731589,8215.3758717019355,null,null,"4.2.3(2)(a)","4.2.3(2)(a)"]
["Depreciation for existing assets",null,null,{"$f":"D20/D19","v":12684},13573.353078477698,22642.255422651768,23254.760518035386,{"$f":"H20/H19","v":23811.778817612889},24308.081446480883,24815.999547342351,null,null,"4.2.2(2)(a)(ii)","4.2.2(2)(a)(ii)"]
["Closing RAB value for existing assets",null,{"$f":"IF(EarlyBaseYear,C7,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,D20-D21+D22-D23,D7)","v":451131},{"$f":"E20-E21+E22-E23","v":465838.79152948648},455185.63045960985,442276.85473566828,{"$f":"H20-H21+H22-H23","v":427187.03318375768},411297.11968253361,394579.46702913847,null,null,"4.2.1(3)(b)","4.2.1(3)(b)"]
["Total depreciation over four disclosure years, starting 2022/23",{"$f":"SUM(F23:I23)","v":94016.876204780914}]
["Individual roll forward of additional assets"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$4","v":2021},2022,2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Value of commissioned assets",null,null,{"$f":"D$9","v":15572},7573.7436485038106,6788.7522455598373,6162.4426395477321,{"$f":"H$9","v":6867.0688325574665},7880.5230590525516,8310.0314222874204,null,"simple ref"]
[{"$f":"\" Assets commissioned in yr ending \" & C30","v":" Assets commissioned in yr ending 2021"}]
["Year asset is added during modelling period",null,{"$f":"D27","v":2021}]
["Opening RAB",null,null,0,{"$f":"D36","v":0},0,0,{"$f":"G36","v":0},0,0,null,null,"4.2.1(4)","4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"B10","v":45},{"$f":"D32-1","v":44},{"$f":"(E32-1)*B13","v":28.352075524425427},{"$f":"F32-1","v":27.352075524425427},{"$f":"G32-1","v":26.352075524425427},25.352075524425427,24.352075524425427,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D31*D$11","v":0},{"$f":"E31*E$11","v":0},0,0,0,0,0,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D31/D32","v":0},0,0,0,{"$f":"H31/H32","v":0},0,0,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C30","v":"RAB of asset commissioned in year ending 2021"},null,null,{"$f":"IF(EarlyBaseYear,D$28,0)","v":0},{"$f":"IF($C30=E$27,E$28,0)","v":0},0,0,0,0,0]
["Closing RAB",null,null,{"$f":"D31+D33-D34+D35","v":0},{"$f":"E31+E33-E34+E35","v":0},{"$f":"F31+F33-F34+F35","v":0},0,{"$f":"H31+H33-H34+H35","v":0},0,0,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C38","v":" Assets commissioned in yr ending 2022"}]
["Year asset is added during modelling period",null,{"$f":"E27","v":2022}]
["Opening RAB",null,null,0,{"$f":"D44","v":0},7573.7436485038106,7509.6002682627195,{"$f":"G44","v":7414.2304660994496},7288.0301062196786,7153.6049902233863,null,null,{"$f":"M31","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C38-D$27","v":46},{"$f":"D40-1","v":45},{"$f":"(E40-1)*B13","v":29.011426118016715},{"$f":"F40-1","v":28.011426118016715},{"$f":"G40-1","v":27.011426118016715},26.011426118016715,25.011426118016715,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D39*D$11","v":0},{"$f":"E39*E$11","v":0},196.91733486109925,172.72080617004187,148.28460932198914,145.7606021243937,143.07209980446785,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D39/D40","v":0},0,261.0607151021905,268.09060833331182,{"$f":"H39/H40","v":274.48496920176058},280.18571812068592,286.01347865847453,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C38","v":"RAB of asset commissioned in year ending 2022"},null,null,{"$f":"IF($C38=D$27,D$28,0)","v":0},7573.7436485038106,0,0,0,0,0]
["Closing RAB",null,null,{"$f":"D39+D41-D42+D43","v":0},{"$f":"E39+E41-E42+E43","v":7573.7436485038106},{"$f":"F39+F41-F42+F43","v":7509.6002682627195},7414.2304660994496,{"$f":"H39+H41-H42+H43","v":7288.0301062196786},7153.6049902233863,7010.6636113693794,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C46","v":" Assets commissioned in yr ending 2023"}]
["Year asset is added during modelling period",null,{"$f":"F27","v":2023}]
["Opening RAB",null,null,0,{"$f":"D52","v":0},0,6788.7522455598373,{"$f":"G52","v":6708.110556853243},6599.8469544048457,6484.387772294479,null,null,{"$f":"M39","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C46-D$27","v":47},{"$f":"D48-1","v":46},{"$f":"(E48-1)*B13","v":29.670776711608006},{"$f":"F48-1","v":28.670776711608006},{"$f":"G48-1","v":27.670776711608006},26.670776711608006,25.670776711608006,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D47*D$11","v":0},{"$f":"E47*E$11","v":0},0,156.14130164787565,134.16221113706499,131.99693908809704,129.68775544588971,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D47/D48","v":0},0,0,236.78299035446986,{"$f":"H47/H48","v":242.42581358546263},247.45612119846413,252.59803570190843,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C46","v":"RAB of asset commissioned in year ending 2023"},null,null,{"$f":"IF($C46=D$27,D$28,0)","v":0},0,6788.7522455598373,0,0,0,0]
["Closing RAB",null,null,{"$f":"D47+D49-D50+D51","v":0},{"$f":"E47+E49-E50+E51","v":0},6788.7522455598373,6708.110556853243,{"$f":"H47+H49-H50+H51","v":6599.8469544048457},6484.387772294479,6361.4774920384607,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C54","v":" Assets commissioned in yr ending 2024"}]
["Year asset is added during modelling period",null,{"$f":"G27","v":2024}]
["Opening RAB",null,null,0,{"$f":"D60","v":0},0,0,{"$f":"G60","v":6162.4426395477321},6068.1689032885215,5967.500058982092,null,null,{"$f":"M47","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C54-D$27","v":48},{"$f":"D56-1","v":47},{"$f":"(E56-1)*B13","v":30.330127305199294},{"$f":"F56-1","v":29.330127305199294},{"$f":"G56-1","v":28.330127305199294},27.330127305199294,26.330127305199294,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D55*D$11","v":0},{"$f":"E55*E$11","v":0},0,0,123.24885279095476,121.36337806577053,119.35000117964195,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D55/D56","v":0},0,0,0,{"$f":"H55/H56","v":217.52258905016527},222.03222237219916,226.64151942036816,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C54","v":"RAB of asset commissioned in year ending 2024"},null,null,{"$f":"IF($C54=D$27,D$28,0)","v":0},0,0,6162.4426395477321,0,0,0]
["Closing RAB",null,null,{"$f":"D55+D57-D58+D59","v":0},{"$f":"E55+E57-E58+E59","v":0},0,6162.4426395477321,{"$f":"H55+H57-H58+H59","v":6068.1689032885215},5967.500058982092,5860.2085407413661,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C62","v":" Assets commissioned in yr ending 2025"}]
["Year asset is added during modelling period",null,{"$f":"H27","v":2025}]
["Opening RAB",null,null,0,{"$f":"D68","v":0},0,0,{"$f":"G68","v":0},6867.0688325574665,6759.0655529992837,null,null,{"$f":"M55","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C62-D$27","v":49},{"$f":"D64-1","v":48},{"$f":"(E64-1)*B13","v":30.989477898790582},{"$f":"F64-1","v":29.989477898790582},{"$f":"G64-1","v":28.989477898790582},27.989477898790582,26.989477898790582,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D63*D$11","v":0},{"$f":"E63*E$11","v":0},0,0,0,137.34137665114946,135.1813110599858,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D63/D64","v":0},0,0,0,{"$f":"H63/H64","v":0},245.34465620933182,250.43335696768563,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C62","v":"RAB of asset commissioned in year ending 2025"},null,null,{"$f":"IF($C62=D$27,D$28,0)","v":0},0,0,0,6867.0688325574665,0,0]
["Closing RAB",null,null,{"$f":"D63+D65-D66+D67","v":0},{"$f":"E63+E65-E66+E67","v":0},0,0,{"$f":"H63+H65-H66+H67","v":6867.0688325574665},6759.0655529992837,6643.8135070915841,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C70","v":" Assets commissioned in yr ending 2026"}]
["Year asset is added during modelling period",null,{"$f":"I27","v":2026}]
["Opening RAB",null,null,0,{"$f":"D76","v":0},0,0,{"$f":"G76","v":0},0,7880.5230590525516,null,null,{"$f":"M63","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C70-D$27","v":50},{"$f":"D72-1","v":49},{"$f":"(E72-1)*B13","v":31.648828492381874},{"$f":"F72-1","v":30.648828492381874},{"$f":"G72-1","v":29.648828492381874},28.648828492381874,27.648828492381874,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D71*D$11","v":0},{"$f":"E71*E$11","v":0},0,0,0,0,157.61046118105116,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D71/D72","v":0},0,0,0,{"$f":"H71/H72","v":0},0,285.02195169765997,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C70","v":"RAB of asset commissioned in year ending 2026"},null,null,{"$f":"IF($C70=D$27,D$28,0)","v":0},0,0,0,0,7880.5230590525516,0]
["Closing RAB",null,null,{"$f":"D71+D73-D74+D75","v":0},{"$f":"E71+E73-E74+E75","v":0},0,0,{"$f":"H71+H73-H74+H75","v":0},7880.5230590525516,7753.1115685359428,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
[{"$f":"\" Assets commissioned in yr ending \" & C78","v":" Assets commissioned in yr ending 2027"}]
["Year asset is added during modelling period",null,{"$f":"J27","v":2027}]
["Opening RAB",null,null,0,{"$f":"D84","v":0},0,0,{"$f":"G84","v":0},0,0,null,null,{"$f":"M71","v":"4.2.1(4)"},"4.2.1(4)"]
["Years of remaining life",null,null,{"$f":"$B$10+$C78-D$27","v":51},{"$f":"D80-1","v":50},{"$f":"(E80-1)*B13","v":32.308179085973158},{"$f":"F80-1","v":31.308179085973158},{"$f":"G80-1","v":30.308179085973158},29.308179085973158,28.308179085973158,null,null,"4.2.2(3)(b)","4.2.2(3)(b)"]
["Revaluation of assets",null,null,{"$f":"D79*D$11","v":0},{"$f":"E79*E$11","v":0},0,0,0,0,0,null,null,"4.2.3(2)","4.2.3(2)"]
["Depreciation of assets",null,null,{"$f":"D79/D80","v":0},0,0,0,{"$f":"H79/H80","v":0},0,0,null,null,"4.2.2(2)(b)","4.2.2(2)(b)"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C78","v":"RAB of asset commissioned in year ending 2027"},null,null,{"$f":"IF($C78=D$27,D$28,0)","v":0},0,0,0,0,0,8310.0314222874204]
["Closing RAB",null,null,{"$f":"D79+D81-D82+D83","v":0},{"$f":"E79+E81-E82+E83","v":0},0,0,{"$f":"H79+H81-H82+H83","v":0},0,8310.0314222874204,null,null,"4.2.1(5)(b)","4.2.1(5)(b)"]
["Aggregate roll forward of additional assets"]
["Opening RAB of commissioned additional assets",null,null,{"$f":"D31+D39+D47+D55+D63+D71+D79","v":0},{"$f":"D89","v":0},{"$f":"E89","v":7573.7436485038106},14298.352513822556,{"$f":"G89","v":20284.783662500424},26823.114796470512,34245.081433551793,null,null,"4.2.1(4)","4.2.1(4)"]
["Revaluation of commissioned additional assets",null,null,{"$f":"D33+D41+D49+D57+D65+D73+D81","v":0},0,196.91733486109925,328.86210781791749,405.69567325000889,536.46229592941074,684.90162867103641]
["Depreciation of commissioned additional assets",null,null,0,0,261.0607151021905,504.87359868778168,734.43337183738845,995.01871790068094,1300.7083424460966]
["Closing RAB of commissioned additional assets",null,null,{"$f":"D36+D44+D52+D60+D68+D76+D84","v":0},7573.7436485038106,14298.352513822556,20284.783662500424,26823.114796470512,34245.081433551793,41939.306142064153]
["Combined roll forward of existing and additional assets"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$4","v":2021},2022,2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Aggregate opening RAB value",null,null,{"$f":"D20+D86","v":434256},451131,473412.53517799027,469483.9829734324,462561.63839816872,454010.14798022818,445542.2011160854,null,null,"4.2.1(1)","4.2.1(1)"]
["Total revaluation",null,null,{"$f":"D22+D87","v":14492.799465138494},28386.212471591458,12293.811315717869,10785.125921439198,9240.1375388703091,9069.3645331025691,8900.2775003729712,null,null,"4.2.3(1)","4.2.3(1)"]
["Total depreciation",null,null,12684,13573.353078477698,22903.316137753958,23759.634116723166,24546.212189450278,25303.100164381565,26116.707889788449,null,null,"4.2.2(1)","4.2.2(1)"]
["Aggregate closing RAB value",null,null,null,{"$f":"E24+E89","v":473412.53517799027},469483.9829734324,462561.63839816872,454010.14798022818,445542.2011160854,436518.77317120263]
["Check that closing value is as expected. Should = 0",null,null,null,{"$f":"E92+E28+E93-E94-E21-E95","v":0},0,0,0,0,0]
[]
["Outputs"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},2021,2022,2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Value of commissioned assets"]
["Remaining asset life for existing assets",null,null,{"$f":"D19","v":34.236518448438979},33.236518448438979,20.573868761477357,19.573868761477357,18.573868761477357,17.573868761477357,16.573868761477357,null,"simple ref"]
["Total depreciation",null,null,{"$f":"D94","v":12684},13573.353078477698,22903.316137753958,23759.634116723166,{"$f":"H94","v":24546.212189450278},25303.100164381565,26116.707889788449,null,"simple ref"]
["Aggregate opening RAB value",null,{"$f":"C20","v":"~"},{"$f":"D92","v":434256},{"$f":"E92","v":451131},473412.53517799027,469483.9829734324,{"$f":"H92","v":462561.63839816872},454010.14798022818,445542.2011160854,null,"simple ref"]
["Total revaluation",null,null,null,null,{"$f":"F93","v":12293.811315717869},10785.125921439198,{"$f":"H93","v":9240.1375388703091},9069.3645331025691,8900.2775003729712,null,"simple ref"]
["Closing RAB value, 4th BBAR year",{"$f":"J95","v":436518.77317120263}]
["Total depreciation over 4 dislosure years, starting 2022/2023",{"$f":"B25","v":94016.876204780914}]
["Remaining Asset Life for Existing Assets in 2023 adjusted /  Transitional Adjusted Asset Life",{"$f":"F19","v":20.573868761477357}]

{"sheet":"Tax","index":8,"n_rows":105,"n_cols":13,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Tax calculations","Values, not time series","Early base year","Standard base year","Gap year","1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year","Spec ref","GTB IM reference","GDB IM reference"]
["Calculation of adjusted depreciation, tax depreciation, deferred tax, notional deductible interest and regulatory tax adjustments."]
["Inputs",null,null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"}]
["BBAR year ending in calendar year:",null,{"$f":"'GPB data'!C18","v":2020},{"$f":"'GPB data'!D18","v":2021},{"$f":"'GPB data'!E18","v":2022},{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},{"$f":"'GPB data'!J18","v":2027},"GPB data"]
["Corporate tax rate",null,{"$f":"'GPB data'!C23","v":0.28000000000000003},{"$f":"'GPB data'!D23","v":0.28000000000000003},{"$f":"'GPB data'!E23","v":0.28000000000000003},{"$f":"'GPB data'!F23","v":0.28000000000000003},{"$f":"'GPB data'!G23","v":0.28000000000000003},{"$f":"'GPB data'!H23","v":0.28000000000000003},{"$f":"'GPB data'!I23","v":0.28000000000000003},{"$f":"'GPB data'!J23","v":0.28000000000000003},"GPB data"]
["Value of commissioned assets",null,{"$f":"'GPB data'!C77","v":0},{"$f":"'GPB data'!D77","v":15572},{"$f":"'GPB data'!E77","v":7573.7436485038106},{"$f":"'GPB data'!F77","v":6788.7522455598373},{"$f":"'GPB data'!G77","v":6162.4426395477321},{"$f":"'GPB data'!H77","v":6867.0688325574665},{"$f":"'GPB data'!I77","v":7880.5230590525516},{"$f":"'GPB data'!J77","v":8310.0314222874204},"RAB"]
["Remaining life for additional assets",null,null,{"$f":"'GPB data'!B10","v":45},null,null,null,null,null,null,"GPB data"]
["Amortisation of initial differences in asset values",{"$f":"'GPB data'!B43","v":2452.34375},null,null,null,null,null,null,null,null,"GPB data"]
["Value of disposed assets",null,null,{"$f":"'GPB data'!D88","v":280},{"$f":"'GPB data'!E88","v":105.06786362727907},{"$f":"'GPB data'!F88","v":107.79962808158834},{"$f":"'GPB data'!G88","v":110.27901952746485},{"$f":"'GPB data'!H88","v":112.48459991801417},{"$f":"'GPB data'!I88","v":114.73429191637445},{"$f":"'GPB data'!J88","v":117.02897775470194},"RAB"]
["Opening RAB excluding revaluations",null,{"$f":"'GPB data'!C37","v":"~"},{"$f":"'GPB data'!D37","v":387877},null,null,null,null,null,null,"GPB data"]
["Adjusted depreciation",null,{"$f":"'GPB data'!C38","v":"~"},{"$f":"'GPB data'!D38","v":11347},null,null,null,null,null,null,"GPB data"]
["Tax depreciation",null,{"$f":"'GPB data'!C39","v":"~"},{"$f":"'GPB data'!D39","v":18496},null,null,null,null,null,null,"GPB data"]
["Opening regulatory tax asset value",null,{"$f":"'GPB data'!C40","v":"~"},{"$f":"'GPB data'!D40","v":178920},null,null,null,null,null,null,"GPB data"]
["Opening deferred tax balance",null,{"$f":"'GPB data'!C42","v":"~"},{"$f":"'GPB data'!D42","v":-33959},null,null,null,null,null,null,"GPB data"]
["Cost of debt",null,null,{"$f":"'GPB data'!B8","v":4.0399999999999998E-2},null,null,null,null,null,null,"GPB data"]
["Leverage",null,null,{"$f":"'GPB data'!B9","v":0.42},null,null,null,null,null,null,"GPB data"]
["Remaining asset life for existing assets",null,null,{"$f":"RAB!D101","v":34.236518448438979},{"$f":"RAB!E101","v":33.236518448438979},{"$f":"RAB!F101","v":20.573868761477357},{"$f":"RAB!G101","v":19.573868761477357},{"$f":"RAB!H101","v":18.573868761477357},{"$f":"RAB!I101","v":17.573868761477357},{"$f":"RAB!J101","v":16.573868761477357},"RAB"]
["Total depreciation",null,null,null,null,{"$f":"RAB!F102","v":22903.316137753958},{"$f":"RAB!G102","v":23759.634116723166},{"$f":"RAB!H102","v":24546.212189450278},{"$f":"RAB!I102","v":25303.100164381565},{"$f":"RAB!J102","v":26116.707889788449},"RAB"]
["Term credit spread differential allowance, full BBAR years",null,null,null,null,{"$f":"BBAR!F92","v":430.30110246653209},{"$f":"BBAR!G92","v":426.73030486590881},{"$f":"BBAR!H92","v":420.43834535691678},{"$f":"BBAR!I92","v":412.66559858503769},{"$f":"BBAR!J92","v":404.96878745201877},"BBAR"]
["Opening investment value",null,null,null,null,{"$f":"BBAR!F94","v":434285.15058605414},{"$f":"BBAR!G94","v":430126.82217949664},{"$f":"BBAR!H94","v":423337.8007268958},{"$f":"BBAR!I94","v":415264.50675802131},{"$f":"BBAR!J94","v":407577.3673683097},"BBAR"]
["Calculations"]
["Adjusted RAB & depreciation of assets commissioned"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Value of commissioned assets",null,null,{"$f":"D6","v":15572},7573.7436485038106,6788.7522455598373,6162.4426395477321,6867.0688325574665,7880.5230590525516,8310.0314222874204,"simple ref"]
[{"$f":"\"Assets commissioned in year ending \" & C25","v":"Assets commissioned in year ending 2021"},null,{"$f":"D23","v":2021}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D30","v":0},0,0,{"$f":"G30","v":0},0,0,null,"n/a","4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D32","v":45},{"$f":"RAB!E32","v":44},{"$f":"RAB!F32","v":28.352075524425427},{"$f":"RAB!G32","v":27.352075524425427},{"$f":"RAB!H32","v":26.352075524425427},{"$f":"RAB!I32","v":25.352075524425427},{"$f":"RAB!J32","v":24.352075524425427},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D26/D27","v":0},0,0,0,{"$f":"H26/H27","v":0},0,0,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C25","v":"RAB of asset commissioned in year ending 2021"},null,null,{"$f":"IF(EarlyBaseYear,D$24,0)","v":0},{"$f":"IF($C25=E$23,E$24,0)","v":0},{"$f":"IF($C25=F$23,F$24,0)","v":0},0,{"$f":"IF($C25=H$23,H$24,0)","v":0},0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D26-D28+D29","v":0},{"$f":"E26-E28+E29","v":0},{"$f":"F26-F28+F29","v":0},0,{"$f":"H26-H28+H29","v":0},0,0,null,"n/a","4.2.1(5)(b)"]
[{"$f":"\"Assets commissioned in year ending \" & C31","v":"Assets commissioned in year ending 2022"},null,{"$f":"E23","v":2022}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D36","v":0},{"$f":"E36","v":7573.7436485038106},7312.6829334016202,{"$f":"G36","v":7051.6222182994297},6790.5615031972393,6529.5007880950488,null,{"$f":"L26","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D40","v":46},{"$f":"RAB!E40","v":45},{"$f":"RAB!F40","v":29.011426118016715},{"$f":"RAB!G40","v":28.011426118016715},{"$f":"RAB!H40","v":27.011426118016715},{"$f":"RAB!I40","v":26.011426118016715},{"$f":"RAB!J40","v":25.011426118016715},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D32/D33","v":0},0,261.0607151021905,261.0607151021905,{"$f":"H32/H33","v":261.0607151021905},261.0607151021905,261.06071510219056,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C31","v":"RAB of asset commissioned in year ending 2022"},null,null,{"$f":"IF($C31=D$23,D$24,0)","v":0},{"$f":"IF($C31=E$23,E$24,0)","v":7573.7436485038106},{"$f":"IF($C31=F$23,F$24,0)","v":0},0,{"$f":"IF($C31=H$23,H$24,0)","v":0},0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D32-D34+D35","v":0},{"$f":"E32-E34+E35","v":7573.7436485038106},7312.6829334016202,7051.6222182994297,{"$f":"H32-H34+H35","v":6790.5615031972393},6529.5007880950488,6268.4400729928584,null,{"$f":"L30","v":"n/a"},{"$f":"M30","v":"4.2.1(5)(b)"}]
[{"$f":"\"Assets commissioned in year ending \" & C37","v":"Assets commissioned in year ending 2023"},null,{"$f":"F23","v":2023}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D42","v":0},0,6788.7522455598373,{"$f":"G42","v":6551.9692552053675},6315.1862648508977,6078.4032744964279,null,{"$f":"L32","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D48","v":47},{"$f":"RAB!E48","v":46},{"$f":"RAB!F48","v":29.670776711608006},{"$f":"RAB!G48","v":28.670776711608006},{"$f":"RAB!H48","v":27.670776711608006},{"$f":"RAB!I48","v":26.670776711608006},{"$f":"RAB!J48","v":25.670776711608006},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D38/D39","v":0},0,0,236.78299035446986,{"$f":"H38/H39","v":236.78299035446986},236.78299035446986,236.78299035446986,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C37","v":"RAB of asset commissioned in year ending 2023"},null,null,{"$f":"IF($C37=D$23,D$24,0)","v":0},{"$f":"IF($C37=E$23,E$24,0)","v":0},{"$f":"IF($C37=F$23,F$24,0)","v":6788.7522455598373},0,{"$f":"IF($C37=H$23,H$24,0)","v":0},0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D38-D40+D41","v":0},0,6788.7522455598373,6551.9692552053675,{"$f":"H38-H40+H41","v":6315.1862648508977},6078.4032744964279,5841.6202841419581,null,{"$f":"L36","v":"n/a"},{"$f":"M36","v":"4.2.1(5)(b)"}]
[{"$f":"\"Assets commissioned in year ending \" & C43","v":"Assets commissioned in year ending 2024"},null,{"$f":"G23","v":2024}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D48","v":0},0,0,{"$f":"G48","v":6162.4426395477321},5944.920050497567,5727.3974614474018,null,{"$f":"L38","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D56","v":48},{"$f":"RAB!E56","v":47},{"$f":"RAB!F56","v":30.330127305199294},{"$f":"RAB!G56","v":29.330127305199294},{"$f":"RAB!H56","v":28.330127305199294},{"$f":"RAB!I56","v":27.330127305199294},{"$f":"RAB!J56","v":26.330127305199294},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D44/D45","v":0},0,0,0,{"$f":"H44/H45","v":217.52258905016527},217.52258905016527,217.52258905016527,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C43","v":"RAB of asset commissioned in year ending 2024"},null,null,{"$f":"IF($C43=D$23,D$24,0)","v":0},{"$f":"IF($C43=E$23,E$24,0)","v":0},{"$f":"IF($C43=F$23,F$24,0)","v":0},6162.4426395477321,{"$f":"IF($C43=H$23,H$24,0)","v":0},0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D44-D46+D47","v":0},0,0,6162.4426395477321,{"$f":"H44-H46+H47","v":5944.920050497567},5727.3974614474018,5509.8748723972367,null,{"$f":"L42","v":"n/a"},{"$f":"M42","v":"4.2.1(5)(b)"}]
[{"$f":"\"Assets commissioned in year ending \" & C49","v":"Assets commissioned in year ending 2025"},null,{"$f":"H23","v":2025}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D54","v":0},0,0,{"$f":"G54","v":0},6867.0688325574665,6621.7241763481343,null,{"$f":"L44","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D64","v":49},{"$f":"RAB!E64","v":48},{"$f":"RAB!F64","v":30.989477898790582},{"$f":"RAB!G64","v":29.989477898790582},{"$f":"RAB!H64","v":28.989477898790582},{"$f":"RAB!I64","v":27.989477898790582},{"$f":"RAB!J64","v":26.989477898790582},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D50/D51","v":0},0,0,0,{"$f":"H50/H51","v":0},245.34465620933182,245.34465620933179,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C49","v":"RAB of asset commissioned in year ending 2025"},null,null,{"$f":"IF($C49=D$23,D$24,0)","v":0},{"$f":"IF($C49=E$23,E$24,0)","v":0},{"$f":"IF($C49=F$23,F$24,0)","v":0},0,{"$f":"IF($C49=H$23,H$24,0)","v":6867.0688325574665},0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D50-D52+D53","v":0},0,0,0,{"$f":"H50-H52+H53","v":6867.0688325574665},6621.7241763481343,6376.379520138802,null,{"$f":"L48","v":"n/a"},{"$f":"M48","v":"4.2.1(5)(b)"}]
[{"$f":"\"Assets commissioned in year ending \" & C55","v":"Assets commissioned in year ending 2026"},null,{"$f":"I23","v":2026}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D60","v":0},0,0,{"$f":"G60","v":0},0,7880.5230590525516,null,{"$f":"L50","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D72","v":50},{"$f":"RAB!E72","v":49},{"$f":"RAB!F72","v":31.648828492381874},{"$f":"RAB!G72","v":30.648828492381874},{"$f":"RAB!H72","v":29.648828492381874},{"$f":"RAB!I72","v":28.648828492381874},{"$f":"RAB!J72","v":27.648828492381874},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D56/D57","v":0},0,0,0,{"$f":"H56/H57","v":0},0,285.02195169765997,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C55","v":"RAB of asset commissioned in year ending 2026"},null,null,{"$f":"IF($C55=D$23,D$24,0)","v":0},{"$f":"IF($C55=E$23,E$24,0)","v":0},{"$f":"IF($C55=F$23,F$24,0)","v":0},0,{"$f":"IF($C55=H$23,H$24,0)","v":0},7880.5230590525516,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D56-D58+D59","v":0},0,0,0,{"$f":"H56-H58+H59","v":0},7880.5230590525516,7595.5011073548912,null,{"$f":"L54","v":"n/a"},{"$f":"M54","v":"4.2.1(5)(b)"}]
[{"$f":"\"Assets commissioned in year ending \" & C61","v":"Assets commissioned in year ending 2027"},null,{"$f":"J23","v":2027}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D66","v":0},0,0,{"$f":"G66","v":0},0,0,null,{"$f":"L56","v":"n/a"},"4.2.1(3)(b)adj"]
["Years of remaining life",null,null,{"$f":"RAB!D80","v":51},{"$f":"RAB!E80","v":50},{"$f":"RAB!F80","v":32.308179085973158},{"$f":"RAB!G80","v":31.308179085973158},{"$f":"RAB!H80","v":30.308179085973158},{"$f":"RAB!I80","v":29.308179085973158},{"$f":"RAB!J80","v":28.308179085973158},null,"n/a","4.2.2(3)(b)adj"]
["Adjusted depreciation",null,null,{"$f":"D62/D63","v":0},0,0,0,{"$f":"H62/H63","v":0},0,0,null,"n/a","4.2.2(2)(b)adj"]
[{"$f":"\"RAB of asset commissioned in year ending \" & C61","v":"RAB of asset commissioned in year ending 2027"},null,null,{"$f":"IF($C61=D$23,D$24,0)","v":0},{"$f":"IF($C61=E$23,E$24,0)","v":0},{"$f":"IF($C61=F$23,F$24,0)","v":0},0,{"$f":"IF($C61=H$23,H$24,0)","v":0},0,8310.0314222874204]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D62-D64+D65","v":0},0,0,0,{"$f":"H62-H64+H65","v":0},0,8310.0314222874204,null,{"$f":"L60","v":"n/a"},{"$f":"M60","v":"4.2.1(5)(b)"}]
["Total assets commissioned"]
["Total adjusted depreciation of commissioned assets",null,null,{"$f":"D28+D34+D40+D46+D52+D58+D64","v":0},{"$f":"E28+E34+E40+E46+E52+E58+E64","v":0},261.0607151021905,497.84370545666036,{"$f":"H28+H34+H40+H46+H52+H58+H64","v":715.36629450682562},960.71095071615741,1245.7329024138173,"spec","n/a"]
["Adjusted depreciation of existing assets"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Opening RAB value of existing assets, adjusted depreciation",null,{"$f":"IF(EarlyBaseYear,C10,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C75,D10)","v":387877},{"$f":"D75","v":391822},{"$f":"E75","v":379928.03190580715},361353.69901115843,{"$f":"G75","v":342782.39404859784},324214.82082656486,305651.39858625224,null,"n/a","4.2.1(2)(b)"]
["Disposed assets",null,null,{"$f":"D9","v":280},105.06786362727907,107.79962808158834,110.27901952746485,{"$f":"H9","v":112.48459991801417},114.73429191637445,117.02897775470194]
["Adjusted depreciation of existing assets",null,{"$f":"IF(EarlyBaseYear,C11,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,D71/D17,D11)","v":11347},{"$f":"E71/E17","v":11788.900230565598},18466.533266567094,18461.025943033088,18455.088622114992,18448.687948396262,18441.765346705157,null,"n/a","4.2.2(2)(a)(ii)"]
["Base year commissioned assets",null,null,{"$f":"D6","v":15572}]
["Closing RAB value of existing assets, adjusted depreciation",null,{"$f":"IF(EarlyBaseYear,C71-C72-C73+C74,\"~\")","v":"~"},{"$f":"D71-D72-D73+D74","v":391822},{"$f":"E71-E72-E73","v":379928.03190580715},361353.69901115843,342782.39404859784,324214.82082656486,305651.39858625224,287092.60426179238,null,"n/a","4.2.1(3)(b)adj"]
["Regulatory tax asset value"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Average DV rate",null,{"$f":"IF(EarlyBaseYear,C12/C13,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C78,D12/D13)","v":0.10337581041806394},null,null,null,null,null,null,null,"4.3.3(3)(b)","4.3.5(3)(b)"]
["Opening regulatory tax asset value",null,{"$f":"IF(EarlyBaseYear,C13,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C82,D13)","v":178920},{"$f":"D82","v":175996},{"$f":"E82","v":165376.01451816622},155068.88723920111,{"$f":"G82","v":145200.95798976903},137057.76011665486,130769.82614956361,null,"4.3.3(a)(ii)","4.3.5(3)(a)"]
["Tax depreciation",null,{"$f":"IF(EarlyBaseYear,C12,\"~\")","v":"~"},{"$f":"D79*$D78","v":18496},{"$f":"E79*$D78","v":18193.729130337582},17095.879524524942,16030.371888979789,{"$f":"H79*$D78","v":15010.266705671629},14168.457026143798,13518.436756440469,null,"4.3.3(2)(b)","4.3.5(2)(b)"]
["Value of commissioned assets",null,{"$f":"IF(EarlyBaseYear,C6,\"~\")","v":"~"},{"$f":"D6","v":15572},7573.7436485038106,6788.7522455598373,6162.4426395477321,6867.0688325574665,7880.5230590525516,8310.0314222874204,"simple ref"]
["Closing regulatory tax asset value",null,{"$f":"IF(EarlyBaseYear,C79-C80+C81,\"~\")","v":"~"},{"$f":"D79-D80+D81","v":175996},{"$f":"E79-E80+E81","v":165376.01451816622},155068.88723920111,145200.95798976903,{"$f":"H79-H80+H81","v":137057.76011665486},130769.82614956361,125561.42081541056,null,"4.3.3(3)(c)","4.3.5(3)(c)(i)"]
["Depreciation temporary differences"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Total adjusted depreciation of assets",null,{"$f":"IF(EarlyBaseYear,C68+C73,\"~\")","v":"~"},{"$f":"D68+D73","v":11347},11788.900230565598,18727.593981669284,18958.869648489748,19170.454916621817,19409.398899112421,19687.498249118973]
["Tax depreciation",null,{"$f":"C80","v":"~"},18496,18193.729130337582,17095.879524524942,16030.371888979789,15010.266705671629,14168.457026143798,13518.436756440469,"simple ref"]
["Depreciation temporary differences, deferred tax approach",null,{"$f":"IF(EarlyBaseYear,C85-C86,\"~\")","v":"~"},{"$f":"D85-D86","v":-7149},-6404.8288997719847,1631.7144571443423,2928.497759509959,{"$f":"H85-H86","v":4160.1882109501876},5240.9418729686222,6169.0614926785038,null,"n/a","4.3.5(1)"]
["Deductions for regulatory tax purposes"]
["Amortisation of initial differences in asset values",null,{"$f":"IF(EarlyBaseYear,B8,\"~\")","v":"~"},{"$f":"$B$8","v":2452.34375},2452.34375,2452.34375,2452.34375,{"$f":"$B$8","v":2452.34375},2452.34375,2452.34375,"simple ref","n/a"]
["Notional deductible interest",null,null,null,null,{"$f":"(F20*$D$16*$D$15+F19)/(1+$D$15)^0.5","v":7646.3250368732333},7573.6492388309871,7454.5432824420441,7312.6213227991584,7177.197604860291,null,"4.3.4(1)","4.3.3(2)"]
["Amortisation of revaluations",null,null,null,null,{"$f":"F18-F85","v":4175.7221560846738},4800.7644682334176,5375.7572728284613,5893.7012652691446,6429.2096406694764,null,"n/a","4.3.3(5)"]
["Regulatory tax adjustments",null,null,null,null,{"$f":"F89+F91-F90","v":-1018.2591307885596},-320.54102059756951,{"$f":"H89+H91-H90","v":373.55774038641721},1033.4236924699862,1704.3557858091854,null,"n/a","4.3.3(1)"]
["Deferred tax asset value"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Opening deferred tax",null,{"$f":"IF(EarlyBaseYear,C14,\"~\")","v":"~"},{"$f":"IF(EarlyBaseYear,C98,D14)","v":-33959},{"$f":"D98","v":-36647.376250000001},{"$f":"E98","v":-39127.384591936156},-39357.160793935742,{"$f":"G98","v":-39223.837671272951},-38745.641222206898,-37964.833747775687,"simple ref","n/a","4.3.4(1)(b)"]
["Depreciation temporary differences, deferred tax approach",null,{"$f":"C87","v":"~"},-7149,-6404.8288997719847,1631.7144571443423,2928.497759509959,4160.1882109501876,5240.9418729686222,6169.0614926785038,"simple ref"]
["Amortisation of initial differences in asset values",null,{"$f":"C89","v":"~"},2452.34375,2452.34375,2452.34375,2452.34375,2452.34375,2452.34375,2452.34375,"simple ref"]
["Closing deferred tax",null,{"$f":"IF(EarlyBaseYear,C95+(C96-C97)*C5,\"~\")","v":"~"},{"$f":"D95+(D96-D97)*D5","v":-36647.376250000001},{"$f":"E95+(E96-E97)*E5","v":-39127.384591936156},-39357.160793935742,-39223.837671272951,-38745.641222206898,-37964.833747775687,-36924.152779825708,null,"n/a","4.3.4(2)"]
["Outputs"]
["BBAR year ending in calendar year:",null,{"$f":"C$4","v":2020},{"$f":"D$4","v":2021},{"$f":"E$4","v":2022},2023,2024,{"$f":"H$4","v":2025},2026,2027]
["Opening deferred tax",null,null,null,{"$f":"E95","v":-36647.376250000001},{"$f":"F95","v":-39127.384591936156},-39357.160793935742,{"$f":"H95","v":-39223.837671272951},-38745.641222206898,-37964.833747775687,"simple ref"]
["Closing deferred tax",null,null,null,null,{"$f":"F98","v":-39357.160793935742},-39223.837671272951,{"$f":"H98","v":-38745.641222206898},-37964.833747775687,-36924.152779825708,"simple ref"]
["Regulatory tax adjustments",null,null,null,null,{"$f":"F92","v":-1018.2591307885596},-320.54102059756951,373.55774038641721,1033.4236924699862,1704.3557858091854,"simple ref"]
["Tax depreciation",null,null,null,null,{"$f":"F80","v":17095.879524524942},16030.371888979789,15010.266705671629,14168.457026143798,13518.436756440469,"simple ref"]
["Notional deductible interest",null,null,null,null,{"$f":"F90","v":7646.3250368732333},7573.6492388309871,{"$f":"H90","v":7454.5432824420441},7312.6213227991584,7177.197604860291,"simple ref"]

{"sheet":"BBAR","index":9,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Building blocks allowable revenue","Values, not time series","Early base year","Std base year","Gap year","1st BBAR year","2nd BBAR year","3rd BBAR year","4th BBAR year","5th BBAR year"," ","Spec ref","IM ref"]
["Calculation of BBAR present value, opening investment value, and TCSD allowance."]
["Inputs",null,null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"}]
["Tax payable (payable) or deferred tax (deferred)",{"$f":"'GPB data'!B29","v":"deferred"}]
["Vanilla WACC (67th percentile)",{"$f":"WACC","v":6.1400000000000003E-2}]
["Term credit spread differential allowance",null,{"$f":"'GPB data'!C41","v":"~"},{"$f":"'GPB data'!D41","v":394.71036710604159},null,null,null,null,null,null,null,"GPB data"]
["BBAR year ending in calendar year:",null,null,{"$f":"'GPB data'!D18","v":2021},{"$f":"'GPB data'!E18","v":2022},{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},{"$f":"'GPB data'!J18","v":2027},null,"GPB data"]
["Corporate tax rate",null,null,null,null,{"$f":"'GPB data'!F23","v":0.28000000000000003},{"$f":"'GPB data'!G23","v":0.28000000000000003},{"$f":"'GPB data'!H23","v":0.28000000000000003},{"$f":"'GPB data'!I23","v":0.28000000000000003},{"$f":"'GPB data'!J23","v":0.28000000000000003},null,"GPB data"]
["Other regulated income",null,null,null,null,{"$f":"'GPB data'!F96","v":-106.08440959903018},{"$f":"'GPB data'!G96","v":-108.52435101980787},{"$f":"'GPB data'!H96","v":-110.69483804020403},{"$f":"'GPB data'!I96","v":-112.90873480100811},{"$f":"'GPB data'!J96","v":-115.16690949702829},null,"GPB data"]
[]
["Value of commissioned assets",null,null,null,null,{"$f":"'GPB data'!F77","v":6788.7522455598373},{"$f":"'GPB data'!G77","v":6162.4426395477321},{"$f":"'GPB data'!H77","v":6867.0688325574665},{"$f":"'GPB data'!I77","v":7880.5230590525516},{"$f":"'GPB data'!J77","v":8310.0314222874204},null,"GPB data"]
["Operating expenditure",null,null,null,null,{"$f":"'GPB data'!F55","v":15402.436705517925},{"$f":"'GPB data'!G55","v":15938.212911147304},{"$f":"'GPB data'!H55","v":16028.181170698097},{"$f":"'GPB data'!I55","v":16465.675083121463},{"$f":"'GPB data'!J55","v":16951.960145923575},null,"GPB data"]
["Day prior to start of the regulatory period",{"$f":"'GPB data'!B14","v":"2022-09-30"},null,null,null,null,null,null,null,null,null,"GPB data"]
["TFmid",null,null,null,null,{"$f":"Timing!F30","v":1.0224512667685453},{"$f":"Timing!G30","v":1.0302426898551622},{"$f":"Timing!H30","v":1.0301585961411983},{"$f":"Timing!I30","v":1.0301585961411983},{"$f":"Timing!J30","v":1.0075380897096562},null,"TIMING"]
["TFtax",null,null,null,null,{"$f":"Timing!F31","v":1.0224512667685453},{"$f":"Timing!G31","v":1.0302426898551622},{"$f":"Timing!H31","v":1.0301585961411983},{"$f":"Timing!I31","v":1.0301585961411983},{"$f":"Timing!J31","v":1.0075380897096562},null,"TIMING"]
["TFrev",null,null,null,null,{"$f":"Timing!F32","v":1.0167916310684448},{"$f":"Timing!G32","v":1.0245554640608723},{"$f":"Timing!H32","v":1.0244562975994667},{"$f":"Timing!I32","v":1.0244562975994667},{"$f":"Timing!J32","v":1.0019610038112214},null,"TIMING"]
["Aggregate opening RAB value",null,{"$f":"RAB!C103","v":"~"},{"$f":"RAB!D103","v":434256},{"$f":"RAB!E103","v":451131},{"$f":"RAB!F103","v":473412.53517799027},{"$f":"RAB!G103","v":469483.9829734324},{"$f":"RAB!H103","v":462561.63839816872},{"$f":"RAB!I103","v":454010.14798022818},{"$f":"RAB!J103","v":445542.2011160854},null,"RAB"]
["Closing RAB, 4th BBAR year",{"$f":"RAB!B105","v":436518.77317120263}]
["Total revaluation",null,null,null,null,{"$f":"RAB!F104","v":12293.811315717869},{"$f":"RAB!G104","v":10785.125921439198},{"$f":"RAB!H104","v":9240.1375388703091},{"$f":"RAB!I104","v":9069.3645331025691},{"$f":"RAB!J104","v":8900.2775003729712},null,"RAB"]
["Total depreciation",null,null,null,null,{"$f":"RAB!F102","v":22903.316137753958},{"$f":"RAB!G102","v":23759.634116723166},{"$f":"RAB!H102","v":24546.212189450278},{"$f":"RAB!I102","v":25303.100164381565},{"$f":"RAB!J102","v":26116.707889788449},null,"RAB"]
["Opening deferred tax",null,null,null,{"$f":"Tax!E101","v":-36647.376250000001},{"$f":"Tax!F101","v":-39127.384591936156},{"$f":"Tax!G101","v":-39357.160793935742},{"$f":"Tax!H101","v":-39223.837671272951},{"$f":"Tax!I101","v":-38745.641222206898},{"$f":"Tax!J101","v":-37964.833747775687},null,"TAX"]
["Closing deferred tax",null,null,null,null,{"$f":"Tax!F102","v":-39357.160793935742},{"$f":"Tax!G102","v":-39223.837671272951},{"$f":"Tax!H102","v":-38745.641222206898},{"$f":"Tax!I102","v":-37964.833747775687},{"$f":"Tax!J102","v":-36924.152779825708},null,"TAX"]
["Regulatory tax adjustments",null,null,null,null,{"$f":"Tax!F103","v":-1018.2591307885596},{"$f":"Tax!G103","v":-320.54102059756951},{"$f":"Tax!H103","v":373.55774038641721},{"$f":"Tax!I103","v":1033.4236924699862},{"$f":"Tax!J103","v":1704.3557858091854},null,"TAX"]
["Tax depreciation",null,null,null,null,{"$f":"Tax!F104","v":17095.879524524942},{"$f":"Tax!G104","v":16030.371888979789},{"$f":"Tax!H104","v":15010.266705671629},{"$f":"Tax!I104","v":14168.457026143798},{"$f":"Tax!J104","v":13518.436756440469},null,"TAX"]
["Notional deductible interest",null,null,null,null,{"$f":"Tax!F105","v":7646.3250368732333},{"$f":"Tax!G105","v":7573.6492388309871},{"$f":"Tax!H105","v":7454.5432824420441},{"$f":"Tax!I105","v":7312.6213227991584},{"$f":"Tax!J105","v":7177.197604860291},null,"TAX"]
["Proportion of BBAR year in the regulatory period",null,null,null,null,{"$f":"Timing!F29","v":0.74794520547945209},{"$f":"Timing!G29","v":1},{"$f":"Timing!H29","v":1},{"$f":"Timing!I29","v":1},{"$f":"Timing!J29","v":0.25205479452054796},null,{"$f":"Notes!A6","v":1}]
["Number of BBAR days in the BBAR period",null,null,null,null,{"$f":"Timing!F28","v":273},{"$f":"Timing!G28","v":366},{"$f":"Timing!H28","v":365},{"$f":"Timing!I28","v":365},{"$f":"Timing!J28","v":92},null,"TIMING"]
["Calculations"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$7","v":2021},{"$f":"E$7","v":2022},2023,2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Cumulative number of days from start of regulatory period to end of BBAR period",null,null,null,0,{"$f":"E30+F27","v":273},639,1004,1369,1461,null,{"$f":"Notes!A7","v":2}]
["PV factor from end of each BBAR period",null,null,null,null,{"$f":"(1+WACC)^(-1*F30/365)","v":0.95640946129242843},0.90093587105090478,{"$f":"(1+WACC)^(-1*H30/365)","v":0.848818420059266},0.7997158658934107,0.78779417489908166,null,{"$f":"Notes!A8","v":3}]
["Term credit spread differential allowance"]
[]
["Asset base scaling factor",null,null,{"$f":"IF(EarlyBaseYear,D17/$C$17,D17/$D$17)","v":1},1.0388595667071958,1.0901692438975863,1.0811226165520624,1.0651819166532386,1.0454896374033478,1.0259897413417094,null,{"$f":"Notes!A9","v":4}]
["Term credit spread differential allowance, full BBAR years",null,{"$f":"C6","v":"~"},{"$f":"IF(EarlyBaseYear,$C35*D34,D6)","v":394.71036710604159},{"$f":"IF(EarlyBaseYear,$C35,$D35)*E34","v":410.04864094662054},430.30110246653209,426.73030486590881,420.43834535691678,412.66559858503769,404.96878745201877,null,{"$f":"Notes!A10","v":5}]
["Return on capital"]
["BBAR year ending in calendar year:",null,null,{"$f":"D$7","v":2021},{"$f":"E$7","v":2022},2023,2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Opening investment value (full BBAR year values)",null,null,null,{"$f":"E17+IF($B$4=\"deferred\",E21,0)","v":414483.62375000003},{"$f":"F17+IF($B$4=\"deferred\",F21,0)","v":434285.15058605414},430126.82217949664,423337.8007268958,415264.50675802131,407577.3673683097,null,{"$f":"Notes!A11","v":6}]
["Opening investment value, start of regulatory period",{"$f":"G38-F26*(G38-F38)","v":433237.02397399035},null,null,null,null,null,null,null,null,null,{"$f":"Notes!A12","v":7}]
["Closing investment value, end of 5th BBAR year",{"$f":"B18+IF($B$4=\"deferred\",J22,0)","v":399594.6203913769},null,null,null,null,null,null,null,null,null,{"$f":"Notes!A13","v":7}]
["Closing investment value, end of regulatory period",{"$f":"J38+J26*(B40-J38)","v":405565.2777193294},null,null,null,null,null,null,null,null,null,{"$f":"Notes!A14","v":8}]
["Opening investment value for each BBAR period",null,null,null,null,{"$f":"B39","v":433237.02397399035},{"$f":"G38","v":430126.82217949664},{"$f":"H38","v":423337.8007268958},{"$f":"I38","v":415264.50675802131},{"$f":"J38","v":407577.3673683097},null,{"$f":"Notes!A15","v":9}]
["Value of commissioned assets, after accounting for part year effects",null,null,null,null,{"$f":"F11*F26","v":5077.6146932543443},6162.4426395477321,6867.0688325574665,7880.5230590525516,2094.5832626039528,null,{"$f":"Notes!A16","v":10}]
["Term credit spread differential allowance, after accounting for part year effects",null,null,null,null,{"$f":"F35*F26","v":321.84164650236511},426.73030486590881,420.43834535691678,412.66559858503769,102.07432450845405,null,{"$f":"Notes!A16","v":10}]
["Total revaluation, after accounting for part year effects",null,null,null,null,{"$f":"F19*F26","v":9195.0972306602143},10785.125921439198,9240.1375388703091,9069.3645331025691,2243.3576165323657,null,{"$f":"Notes!A16","v":10}]
["WACC adjusted for full and part years",null,null,null,null,{"$f":"(1+WACC)^(F27/365)-1","v":4.5577276754107166E-2},6.1573295085715518E-2,6.1399999999999899E-2,6.1399999999999899E-2,1.5133002215783398E-2,null,{"$f":"Notes!A$18","v":12}]
["Return on capital, after accounting for part year effects",null,null,null,null,{"$f":"F42*F46+F43*(F$14-1)+F44-F45","v":10986.50703965661},16312.298971264012,{"$f":"H42*H46+H43*(H$14-1)+H44-H45","v":17380.342926712878},17078.207292744301,4042.3750680017365,null,{"$f":"Notes!A19","v":13}]
["Operating expenditure"]
["BBAR year ending in calendar year:",null,null,null,null,{"$f":"F$7","v":2023},2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Operating expenditure, after accounting for part year effects",null,null,null,null,{"$f":"F12*F26","v":11520.178686592859},15938.212911147304,16028.181170698097,16465.675083121463,4272.8228313012851,null,{"$f":"Notes!$A$16","v":10}]
["Building block allowable revenue before tax, after accounting for part year effects, deferred tax approach",null,null,null,null,null,"The next 12 lines are greyed out when a supplier to which a deferred tax approach does not apply."]
["BBAR year ending in calendar year:",null,null,null,null,{"$f":"F$7","v":2023},2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Increase in deferred tax asset, ΔDT",null,null,null,null,{"$f":"F22-F21","v":-229.77620199958619},133.32312266279041,478.1964490660539,780.80747443121072,1040.6809679499784,null,11]
["Increase in deferred tax asset, ΔDT, after accounting for part year effects",null,null,null,null,{"$f":"F53*F26","v":-171.86000861886859},133.32312266279041,478.1964490660539,780.80747443121072,262.30862753807673,null,10]
["Other regulated income, after accounting for part year effects",null,null,null,null,{"$f":"F9*F26","v":-79.345325535712988},-108.52435101980787,-110.69483804020403,-112.90873480100811,-29.028371708840009,null,{"$f":"Notes!A$16","v":10}]
["Depreciation, after accounting for part year effects",null,null,null,null,{"$f":"F20*F26","v":17130.425494813237},23759.634116723166,24546.212189450278,25303.100164381565,6582.8414407138016,null,{"$f":"Notes!A$16","v":10}]
["Regulatory tax adjustments, after accounting for part year effects",null,null,null,null,{"$f":"F23*F26","v":-761.60203480897746},-320.54102059756951,373.55774038641721,1033.4236924699862,429.59104738204127,null,{"$f":"Notes!A$16","v":10}]
["BBAR before tax in revenue date terms, calculation not referencing tax",null,null,null,null,{"$f":"(F47+F56*(1-F8*F15)+F50*(F14-F8*F15)-F55*(F14-F8*F15)+F54*(F15-1)+F57*F8*F15)/(F16-F8*F15)","v":43161.896723082704},{"$f":"(G47+G56*(1-G8*G15)+G50*(G14-G8*G15)-G55*(G14-G8*G15)+G54*(G15-1)+G57*G8*G15)/(G16-G8*G15)","v":61178.419610154779},63774.707720990024,64810.058828301124,16686.770078579902,null,{"$f":"Notes!A$20","v":14}]
["Regulatory tax allowance before considering possibility of tax losses",null,null,null,null,{"$f":"(F58+F55-F50-F56+F57)*F8","v":3827.6966507729367},5894.4220189867419,6569.689633692602,6709.3035907707808,1744.8671750266456,null,{"$f":"Notes!A21","v":15}]
["Regulatory tax allowance",null,null,null,null,{"$f":"IF(AND(F59<0,$B$4=\"deferred\"),#N/A,F59)","v":3827.6966507729367},5894.4220189867419,{"$f":"IF(AND(H59<0,$B$4=\"deferred\"),#N/A,H59)","v":6569.689633692602},6709.3035907707808,1744.8671750266456,null,{"$f":"Notes!A22","v":16}]
["BBAR before tax in BBAR period-end terms, direct simple calculation",null,null,null,null,{"$f":"F47+F56+F50*F14+(F60+F54)*F$15-F55*F$14-F54","v":43886.655369071021},{"$f":"G47+G56+G50*G14+(G60+G54)*G$15-G55*G$14-G54","v":62680.684094192897},65334.400952333563,66395.072914444987,16719.492898300974,null,{"$f":"Notes!A23","v":17}]
["BBAR before tax in revenue date terms",null,null,null,null,{"$f":"F61/F$16","v":43161.896723082697},61178.419610154779,{"$f":"H61/H$16","v":63774.707720990024},64810.058828301117,16686.770078579902,null,{"$f":"Notes!A24","v":18}]
["Difference between the two BBAR calculations (should = 0)",null,null,null,null,{"$f":"F58-F62","v":0},0,{"$f":"H58-H62","v":0},0,0,null,{"$f":"Notes!A25","v":19}]
["Building block allowable revenue before tax, after accounting for part year effects, tax payable approach",null,null,null,null,null,"The next 12 lines are greyed out when a supplier to which a tax payable approach does not apply."]
["BBAR year ending in calendar year:",null,null,null,null,{"$f":"F$7","v":2023},2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Other regulated income, after accounting for part year effects",null,null,null,null,{"$f":"F9*F26","v":-79.345325535712988},-108.52435101980787,-110.69483804020403,-112.90873480100811,-29.028371708840009,null,{"$f":"Notes!$A$16","v":10}]
["Depreciation, after accounting for part year effects",null,null,null,null,{"$f":"F20*F26","v":17130.425494813237},23759.634116723166,24546.212189450278,25303.100164381565,6582.8414407138016,null,{"$f":"Notes!$A$16","v":10}]
["Tax depreciation",null,null,null,null,{"$f":"F24*F26","v":12786.781123822766},16030.371888979789,15010.266705671629,14168.457026143798,3407.3867988836255,null,{"$f":"Notes!$A$16","v":10}]
["Notional deductible interest",null,null,null,null,{"$f":"F25*F26","v":5719.0321508668294},7573.6492388309871,7454.5432824420441,7312.6213227991584,1809.0470675264296,null,{"$f":"Notes!$A$16","v":10}]
["Depreciation temporary differences, tax payable approach",null,null,null,null,{"$f":"F67-F68","v":4343.6443709904706},7729.2622277433766,{"$f":"H67-H68","v":9535.9454837786488},11134.643138237767,3175.4546418301761,null,{"$f":"Notes!A26","v":20},"4.3.3(1)"]
["BBAR before tax in revenue date terms, calculation not referencing tax",null,null,null,null,{"$f":"(F47+F67*(1-F8*F15)+F50*(F14-F8*F15)-F66*(F14-F8*F15)+(F70-F69)*F8*F15)/(F16-F8*F15)","v":42926.634892432965},{"$f":"(G47+G67*(1-G8*G15)+G50*(G14-G8*G15)-G66*(G14-G8*G15)+(G70-G69)*G8*G15)/(G16-G8*G15)","v":61359.543621482604},64424.420660578944,65870.921409895978,17051.16336068145,null,{"$f":"Notes!A28","v":22}]
["Regulatory tax allowance before considering possibility of tax losses",null,null,null,null,{"$f":"(F71+F66-F50-F67+F70-F69)*F8","v":3589.9633295721428},6078.4598648213223,7229.8057058435534,7787.152588048556,2109.2059215531567,null,{"$f":"Notes!A29","v":23},"4.3.1"]
["Regulatory tax allowance",null,null,null,null,{"$f":"IF(AND(F72<0,$B$4=\"payable\"),#N/A,F72)","v":3589.9633295721428},6078.4598648213223,7229.8057058435534,7787.152588048556,2109.2059215531567,null,{"$f":"Notes!A22","v":16}]
["BBAR before tax in BBAR period-end terms, direct simple calculation",null,null,null,null,{"$f":"F47+F67+F50*F14+(F73)*F$15-F66*F$14","v":43647.44310855653},{"$f":"G47+G67+G50*G14+(G73)*G$15-G66*G$14","v":62866.255689671452},66000.003464927286,67481.880267047454,17084.60075701751,null,{"$f":"Notes!A28","v":22}]
["BBAR before tax in revenue date terms",null,null,null,null,{"$f":"F74/F$16","v":42926.634892432965},61359.543621482611,{"$f":"H74/H$16","v":64424.420660578937},65870.921409895964,17051.163360681454,null,{"$f":"Notes!A24","v":18}]
["Difference between the two BBAR calculations (should = 0)",null,null,null,null,{"$f":"F71-F75","v":0},0,{"$f":"H71-H75","v":0},0,0,null,{"$f":"Notes!A25","v":19}]
["Parameters dependent on whether a deferred tax or tax payable approach applied"]
["BBAR before tax in BBAR period-end terms",null,null,null,null,{"$f":"IF($B$4=\"deferred\",F61,F74)","v":43886.655369071021},62680.684094192897,{"$f":"IF($B$4=\"deferred\",H61,H74)","v":65334.400952333563},{"$f":"IF($B$4=\"deferred\",I61,I74)","v":66395.072914444987},16719.492898300974,null,{"$f":"Notes!A30","v":24}]
["BBAR before tax in revenue date terms",null,null,null,null,{"$f":"IF($B$4=\"deferred\",F58,F71)","v":43161.896723082704},61178.419610154779,{"$f":"IF($B$4=\"deferred\",H58,H71)","v":63774.707720990024},64810.058828301124,16686.770078579902,null,{"$f":"Notes!A$30","v":24}]
["Tax allowance in period-end terms",null,null,null,null,{"$f":"IF($B$4=\"deferred\",F60,F73)*F15","v":3913.6332893885069},6072.6851959823971,6767.8222501281543,6911.6467681535287,1758.0201403234307,null,{"$f":"Notes!A$31","v":25}]
["Tax payable",null,null,null,null,{"$f":"IF($B$4=\"deferred\",F54+F60,F73)","v":3655.8366421540682},6027.7451416495323,{"$f":"IF($B$4=\"deferred\",H54+H60,H73)","v":7047.8860827586559},7490.1110652019916,2007.1758025647223,null,{"$f":"Notes!A$32","v":26}]
["Present value of the building block allowable revenue before tax"]
["BBAR year ending in calendar year:","Value",null,null,null,{"$f":"F$7","v":2023},2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["BBAR before tax in BBAR period-end terms",null,null,null,null,{"$f":"F78","v":43886.655369071021},62680.684094192897,65334.400952333563,66395.072914444987,16719.492898300974,null,"simple ref"]
[{"$f":"\"PV at \" & TEXT(B13, \"dd-mmm-yy\") & \"  BBAR before tax for each BBAR period\"","v":"PV at 30-Sep-22  BBAR before tax for each BBAR period"},null,null,null,null,{"$f":"F84*F31","v":41973.612419459678},{"$f":"G84*G31","v":56471.276722468268},55457.042991878378,53097.193226831514,{"$f":"J84*J31","v":13171.519112548071},null,{"$f":"Notes!A33","v":27}]
[{"$f":"\"PV at \" & TEXT(B13, \"dd-mmm-yy\") & \" of total BBAR before tax\"","v":"PV at 30-Sep-22 of total BBAR before tax"},{"$f":"SUM(F85:J85)","v":220170.64447318591},null,null,null,null,null,null,null,null,null,{"$f":"Notes!A34","v":28}]
["Outputs"]
["BBAR year ending in calendar year:","Value",null,null,null,{"$f":"F$7","v":2023},2024,{"$f":"H$7","v":2025},2026,2027,null,"simple ref"]
["Present value of BBAR as at the start of the regulatory period",{"$f":"B86","v":220170.64447318591},null,null,null,null,null,null,null,null,null,"simple ref"]
["Opening investment value at start of regulatory period",{"$f":"B39","v":433237.02397399035},null,null,null,null,null,null,null,null,null,"simple ref"]
["Closing investment value at end of regulatory period",{"$f":"B41","v":405565.2777193294},null,null,null,null,null,null,null,null,null,"simple ref"]
["Term credit spread differential allowance, full BBAR years",null,null,null,null,{"$f":"F35","v":430.30110246653209},426.73030486590881,420.43834535691678,412.66559858503769,404.96878745201877,null,"simple ref"]
["BBAR before tax in revenue date terms",null,null,null,null,{"$f":"F79","v":43161.896723082704},61178.419610154779,63774.707720990024,64810.058828301124,16686.770078579902,null,"simple ref"]
["Opening investment value (full BBAR year values)",null,null,null,{"$f":"E38","v":414483.62375000003},434285.15058605414,430126.82217949664,423337.8007268958,415264.50675802131,407577.3673683097,null,"simple ref"]
["Total capital charge"]

{"sheet":"Rev","index":10,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Revenue growth index",null,null,"Values, not time series",null,"1st revenue year","2nd revenue year","3rd revenue year","4th revenue year",null,null,"Spec ref"]
["Calculation of the normalised profile of the maximum allowable revenue before tax values."]
["Inputs",null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"}]
["Pricing year ending in calendar year:",null,null,null,{"$f":"'GPB data'!E18","v":2022},{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},null,null,"GPB data"]
["Constant price revenue growth",null,null,null,null,null,{"$f":"'GPB data'!G66","v":1.0322534348871322E-2},{"$f":"'GPB data'!H66","v":1.0211894743768438E-2},{"$f":"'GPB data'!I66","v":1.0101002404889125E-2},null,null,"GPB data"]
["Industry-wide X factor",null,null,{"$f":"'GPB data'!B11","v":0},null,null,null,null,null,null,null,"GPB data"]
["Alternative X factor",null,null,{"$f":"'GPB data'!B44","v":-0.03},null,null,null,null,null,null,null,"GPB data"]
[]
["Forecast changes in the CPI element of the price path, no lag",null,null,null,null,null,{"$f":"'GPB data'!G27","v":4.6285303231120345E-2},{"$f":"'GPB data'!H27","v":2.4743735220526197E-2},{"$f":"'GPB data'!I27","v":2.1492154019882248E-2}]
["Total revenue cap (TRC) or weighted average price cap (WAPC)",null,null,{"$f":"'GPB data'!B30","v":"WAPC"},null,null,null,null,null,null,null,"GPB data"]
["Calculations"]
[]
[{"$f":"\"Index of price path with industry-wide X factor of \"&TEXT(D6,\"#0.0%\")","v":"Index of price path with industry-wide X factor of 0.0%"}]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,null,"simple ref"]
["X value applied, i.e. industry-wide X factor",null,null,{"$f":"D6","v":0},null,null,null,null,null,null,null,"simple ref"]
["Index of cumulative CPI minus X changes",null,null,null,null,1,{"$f":"F16*(1+G$9)*(1-$D$15)","v":1.0462853032311203},{"$f":"G16*(1+H$9)*(1-$D$15)","v":1.0721743097393992},1.0952176451404794,null,null,{"$f":"Notes!A37","v":100}]
["Index of constant price growth for weighted average price cap",null,null,null,null,1,{"$f":"F17*(1+G$5)","v":1.0103225343488713},{"$f":"G17*(1+H$5)","v":1.0206398417268994},{"$f":"H17*(1+I$5)","v":1.0309493272227084},null,null,{"$f":"Notes!A38","v":101}]
["Indexed maximum allowable revenue before tax",null,null,null,null,1,{"$f":"IF($D$10=\"WAPC\",G16*G17,IF($D$10=\"TRC_FQ\",G16,#N/A))","v":1.0570856192124429},{"$f":"IF($D$10=\"WAPC\",H16*H17,IF($D$10=\"TRC_FQ\",H16,#N/A))","v":1.094303817796068},{"$f":"IF($D$10=\"WAPC\",I16*I17,IF($D$10=\"TRC_FQ\",I16,#N/A))","v":1.1291138944200161},null,null,{"$f":"Notes!A39","v":102}]
[{"$f":"\"CPI minus X revenues with applicable X factor (\" & IF(ISNUMBER(D7),\"alternate X factor of \" & TEXT(D7,\"#0.0%\"), \"industry-wide X factor of \" & TEXT(D6,\"#0.0%\"))&\")\"","v":"CPI minus X revenues with applicable X factor (alternate X factor of -3.0%)"}]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,null,"simple ref"]
["X value applied, i.e. alternative X factor if applicable",null,null,{"$f":"IF(D7=\"blank\",D6,D7)","v":-0.03}]
["Index of cumulative CPI minus X changes",null,null,null,null,1,{"$f":"F22*(1+G$9)*(1-$D$21)","v":1.077673862328054},{"$f":"G22*(1+H$9)*(1-$D$21)","v":1.1374697252025285},1.1967738917214203,null,null,{"$f":"Notes!A37","v":100}]
["Index of constant price growth for weighted average price cap",null,null,null,null,1,{"$f":"F23*(1+G$5)","v":1.0103225343488713},{"$f":"G23*(1+H$5)","v":1.0206398417268994},{"$f":"H23*(1+I$5)","v":1.0309493272227084},null,null,{"$f":"Notes!A38","v":101}]
["Indexed maximum allowable revenue before tax",null,null,null,null,1,{"$f":"IF($D$10=\"WAPC\",G22*G23,IF($D$10=\"TRC_FQ\",G22,#N/A))","v":1.0887981877888162},{"$f":"IF($D$10=\"WAPC\",H22*H23,IF($D$10=\"TRC_FQ\",H22,#N/A))","v":1.1609469202998484},{"$f":"IF($D$10=\"WAPC\",I22*I23,IF($D$10=\"TRC_FQ\",I22,#N/A))","v":1.2338132385079008},null,null,{"$f":"Notes!A39","v":102}]
["Outputs"]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,null,"simple ref"]
["Indexed maximum allowable revenue before tax—industry wide X factor",null,null,null,null,{"$f":"F18","v":1},{"$f":"G18","v":1.0570856192124429},{"$f":"H18","v":1.094303817796068},{"$f":"I18","v":1.1291138944200161},null,null,"simple ref"]
["Indexed maximum allowable revenue before tax—applicable X factor",null,null,null,null,{"$f":"F24","v":1},{"$f":"G24","v":1.0887981877888162},{"$f":"H24","v":1.1609469202998484},{"$f":"I24","v":1.2338132385079008},null,null,"simple ref"]

{"sheet":"MAR","index":11,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Maximum allowable revenue",null,"Values, not time series",null,null,"1st Revenue year","2nd Revenue year","3rd Revenue year","4th Revenue year",null,"Spec ref"]
["Calculation of starting prices."]
["Inputs",null,null,null,null,null,null,null,{"$f":"GPB_name","v":"Vector"},null,"Simple ref"]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"'GPB data'!F18","v":2023},{"$f":"'GPB data'!G18","v":2024},{"$f":"'GPB data'!H18","v":2025},{"$f":"'GPB data'!I18","v":2026},null,"GPB data"]
["Year in regulatory period",null,null,null,null,1,{"$f":"F5+1","v":2},{"$f":"G5+1","v":3},{"$f":"H5+1","v":4},null,"GPB data"]
["Industry-wide X factor",null,{"$f":"'GPB data'!B11","v":0},null,null,null,null,null,null,null,"GPB data"]
["Alternative X factor",null,{"$f":"'GPB data'!B44","v":-0.03},null,null,null,null,null,null,null,"GPB data"]
["Vanilla WACC (67th percentile)",null,{"$f":"WACC","v":6.1400000000000003E-2},null,null,null,null,null,null,null,"GPB data"]
["TFrev",null,{"$f":"Timing!C27","v":1.0244562975994667},null,null,null,null,null,null,null,"TIMING"]
["Constant price revenue growth in year ending 2022",null,{"$f":"'GPB data'!E66","v":1.4021796044457951E-2},null,null,null,null,null,null,null,"GPB data"]
["Constant price revenue growth in year ending 2023",null,{"$f":"'GPB data'!F66","v":1.5486737211301289E-2},null,null,null,null,null,null,null,"GPB data"]
["PV at 30 Sep 2022 of BBAR before tax over the regulatory period",null,{"$f":"BBAR!B89","v":220170.64447318591},null,null,null,null,null,null,null,"BBAR"]
["Indexed maximum allowable revenue before tax—industry wide X factor",null,null,null,null,{"$f":"Rev!F27","v":1},{"$f":"Rev!G27","v":1.0570856192124429},{"$f":"Rev!H27","v":1.094303817796068},{"$f":"Rev!I27","v":1.1291138944200161},null,"REV"]
["Indexed maximum allowable revenue before tax—applicable X factor",null,null,null,null,{"$f":"Rev!F28","v":1},{"$f":"Rev!G28","v":1.0887981877888162},{"$f":"Rev!H28","v":1.1609469202998484},{"$f":"Rev!I28","v":1.2338132385079008},null,"REV"]
["Total revenue cap (TRC) or weighted avg price cap (WAPC)",null,{"$f":"'GPB data'!B30","v":"WAPC"},null,null,null,null,null,null,null,"GPB data"]
["Calculations"]
[{"$f":"\"CPI minus X revenues with industry-wide X factor of \"&TEXT(C6,\"#0.0%\")","v":"CPI minus X revenues with industry-wide X factor of 0.0%"}]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,"simple ref"]
["PV at 30 Sep 2022 of BBAR before tax over the regulatory period",null,{"$f":"C12","v":220170.64447318591},null,null,null,null,null,null,null,"simple ref"]
[{"$f":"\"Target PV at \" & TEXT(Inputs!B15, \"dd mmm yyyy\") & \" of maximum allowable revenue before tax\"","v":"Target PV at 30 Sep 2022 of maximum allowable revenue before tax"},null,{"$f":"C19","v":220170.64447318591},null,null,null,null,null,null,null,{"$f":"Notes!A42","v":110}]
["Indexed maximum allowable revenue before tax",null,null,null,null,{"$f":"F13","v":1},{"$f":"G13","v":1.0570856192124429},{"$f":"H13","v":1.094303817796068},{"$f":"I13","v":1.1291138944200161},null,"simple ref"]
["Present value of indexed maximum allowable revenue for each year",null,null,null,null,{"$f":"F21/(1+$C$8)^F$5","v":0.94215187488223107},{"$f":"G21/(1+$C$8)^G$5","v":0.93832221410594252},{"$f":"H21/(1+$C$8)^H$5","v":0.91516765956314783},{"$f":"I21/(1+$C$8)^I$5","v":0.88965457927096936},null,{"$f":"Notes!A43","v":111}]
["Present value of indexed revenue",null,{"$f":"SUM(F22:I22)","v":3.6852963278222912},null,null,null,null,null,null,null,{"$f":"Notes!A44","v":112}]
["Maximum allowable revenue before tax in first year of the regulatory period",null,{"$f":"C20/C23","v":59742.996190292455},null,null,null,null,null,null,null,{"$f":"Notes!A45","v":113}]
["Maximum allowable revenue before tax in year-end terms",null,null,null,null,{"$f":"$C24*F21","v":59742.996190292455},{"$f":"$C24*G21","v":63153.462121421922},{"$f":"$C24*H21","v":65376.988817612983},{"$f":"$C24*I21","v":67456.647092741303},null,{"$f":"Notes!A46","v":114}]
["Maximum allowable revenue before tax in revenue-date terms",null,null,null,null,{"$f":"F25/$C$9","v":58316.783576111382},{"$f":"G25/$C$9","v":61645.833277031728},{"$f":"H25/$C$9","v":63816.278908925728},{"$f":"I25/$C$9","v":65846.290613672361},null,{"$f":"Notes!A47","v":115}]
[{"$f":"\"PV at \" & TEXT(Inputs!B15, \"dd mmm yyyy\") & \" of maximum allowable revenue before tax in year-end terms in each year\"","v":"PV at 30 Sep 2022 of maximum allowable revenue before tax in year-end terms in each year"},null,null,null,null,{"$f":"F25/(1+$C$8)^F5","v":56286.97587176603},{"$f":"G25/(1+$C$8)^G5","v":56058.180462598109},{"$f":"H25/(1+$C$8)^H5","v":54674.857998760002},{"$f":"I25/(1+$C$8)^I5","v":53150.630140061759},null,{"$f":"Notes!A48","v":116}]
[{"$f":"\"PV at \" &TEXT(Inputs!B15, \"dd mmm yyyy\") & \" of maximum allowable revenue before tax\"","v":"PV at 30 Sep 2022 of maximum allowable revenue before tax"},null,{"$f":"SUM(F27:I27)","v":220170.64447318591},null,null,null,null,null,null,null,{"$f":"Notes!A49","v":117}]
["Error check for PV equivalence (should = 0)",null,{"$f":"C20-C28","v":0},null,null,null,null,null,null,null,{"$f":"Notes!A50","v":118}]
["ΔD",null,{"$f":"IF(C15=\"WAPC\",(1+$C$10)*(1+$C$11),#N/A)","v":1.0297256851263301},null,null,null,null,null,null,null,{"$f":"Notes!A51","v":119}]
["ANR (industry-wide X-factor) pricing year ending Sep 2023, GDBs only",null,{"$f":"F26/C30","v":56633.31935723919},null,null,null,null,null,null,null,{"$f":"Notes!A52","v":120}]
[]
["Real MAR increases"]
[]
["Nominal MAR - SPA",null,null,null,{"$f":"'GPB data'!B45","v":50702.277198411044},{"$f":"F26","v":58316.783576111382},{"$f":"G26","v":61645.833277031728},63816.278908925728,65846.290613672361]
["Nominal MAR increases %",null,null,null,null,{"$f":"F35/E35-1","v":0.15018075712660428},{"$f":"G35/F35-1","v":5.7085619212442928E-2},{"$f":"H35/G35-1","v":3.5208310383934238E-2},{"$f":"I35/H35-1","v":3.1810248724212453E-2}]
["CPI",null,null,null,null,{"$f":"'GPB data'!F27","v":5.2149479659413522E-2},{"$f":"'GPB data'!G27","v":4.6285303231120345E-2},{"$f":"'GPB data'!H27","v":2.4743735220526197E-2},{"$f":"'GPB data'!I27","v":2.1492154019882248E-2}]
["CPRG",null,null,null,null,{"$f":"'GPB data'!F66","v":1.5486737211301289E-2},{"$f":"'GPB data'!G66","v":1.0322534348871322E-2},{"$f":"'GPB data'!H66","v":1.0211894743768438E-2},{"$f":"'GPB data'!I66","v":1.0101002404889125E-2}]
["Real MAR increases SPA",null,null,null,null,{"$f":"F35/E35/(1+F37)/(1+F38)-1","v":7.6500899479767126E-2},{"$f":"G35/F35/(1+G37)/(1+G38)-1","v":0},0,0]
[{"$f":"\"CPI minus X revenues with applicable X factor (\" & IF(ISNUMBER(C7),\"alternate X factor of \" & TEXT(C7,\"#0.0%\"), \"industry-wide X factor of \" & TEXT(C6,\"#0.0%\"))&\")\"","v":"CPI minus X revenues with applicable X factor (alternate X factor of -3.0%)"}]
["Pricing year ending in calendar year:",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,"simple ref"]
[{"$f":"BBAR!A89","v":"Present value of BBAR as at the start of the regulatory period"},null,{"$f":"C12","v":220170.64447318591},null,null,null,null,null,null,null,"simple ref"]
[{"$f":"\"Target PV at \" & TEXT('GPB data'!B14, \"dd-mmm-yy\") & \" of Maximum Allowable Revenue before tax\"","v":"Target PV at 30-Sep-22 of Maximum Allowable Revenue before tax"},null,{"$f":"C42","v":220170.64447318591},null,null,null,null,null,null,null,{"$f":"Notes!A42","v":110}]
["Indexed maximum allowable revenue before tax",null,null,null,null,{"$f":"F14","v":1},{"$f":"G14","v":1.0887981877888162},{"$f":"H14","v":1.1609469202998484},{"$f":"I14","v":1.2338132385079008},null,"simple ref"]
["Present value of indexed maximum allowable revenue for each year",null,null,null,null,{"$f":"F44/(1+$C$8)^F$5","v":0.94215187488223107},{"$f":"G44/(1+$C$8)^G$5","v":0.9664718805291207},{"$f":"H44/(1+$C$8)^H$5","v":0.97090137003054333},{"$f":"I44/(1+$C$8)^I$5","v":0.97214957944302838},null,{"$f":"Notes!A43","v":111}]
["Present value of indexed revenue",null,{"$f":"SUM(F45:I45)","v":3.8516747048849238},null,null,null,null,null,null,null,{"$f":"Notes!A44","v":112}]
["Maximum allowable revenue before tax in first year of the regulatory period",null,{"$f":"C43/C46","v":57162.315445266533},null,null,null,null,null,null,null,{"$f":"Notes!A45","v":113}]
["Maximum allowable revenue before tax in year-end terms",null,null,null,null,{"$f":"$C47*F44","v":57162.315445266533},{"$f":"$C47*G44","v":62238.22546661886},{"$f":"$C47*H44","v":66362.414073390639},{"$f":"$C47*I44","v":70527.621540134496},null,{"$f":"Notes!A46","v":114}]
["Maximum allowable revenue before tax in revenue-date terms",null,null,null,null,{"$f":"F48/$C$9","v":55797.710043084116},{"$f":"G48/$C$9","v":60752.445577675819},{"$f":"H48/$C$9","v":64778.179634302425},{"$f":"I48/$C$9","v":68843.953329582437},null,{"$f":"Notes!A47","v":115}]
[{"$f":"\"PV at \" & TEXT('GPB data'!B14, \"dd-mmm-yy\") & \" of maximum allowable revenue before tax in year-end terms in each year\"","v":"PV at 30-Sep-22 of maximum allowable revenue before tax in year-end terms in each year"},null,null,null,null,{"$f":"F48/(1+$C$8)^F$5","v":53855.582669367381},{"$f":"G48/(1+$C$8)^G$5","v":55245.770503785548},{"$f":"H48/(1+$C$8)^H$5","v":55498.970379927363},{"$f":"I48/(1+$C$8)^I$5","v":55570.320920105587},null,{"$f":"Notes!A48","v":116}]
[{"$f":"\"PV at \" & TEXT('GPB data'!B14, \"dd-mmm-yy\") & \" of maximum allowable revenue before tax\"","v":"PV at 30-Sep-22 of maximum allowable revenue before tax"},null,{"$f":"SUM(F50:I50)","v":220170.64447318588},null,null,null,null,null,null,null,{"$f":"Notes!A49","v":117}]
["Error check for PV equivalence (should = 0)",null,{"$f":"C43-C51","v":0},null,null,null,null,null,null,null,{"$f":"Notes!A50","v":118}]
["ΔD",null,{"$f":"IF(C15=\"WAPC\",(1+$C$10)*(1+$C$11),#N/A)","v":1.0297256851263301},null,null,null,null,null,null,null,{"$f":"Notes!A51","v":119}]
["ANR (industry-wide X-factor) pricing year ending Sep 2023, GDBs only",null,{"$f":"F49/C53","v":54186.965372470702},null,null,null,null,null,null,null,{"$f":"Notes!A52","v":120}]
["This data block uses the applicable 2022/23 X factor to calculate the maximum allowable revenues for the regulatory period.  These allowed"]
["revenues are PV-equivalent to the corresponding revenues calculated with the industry-wide X factor in the previous data block."]
[]
["Real MAR increases"]
[]
["Nominal MAR - SPA",null,null,null,{"$f":"'GPB data'!B45","v":50702.277198411044},{"$f":"F49","v":55797.710043084116},{"$f":"G49","v":60752.445577675819},64778.179634302425,68843.953329582437]
["Nominal MAR increases %",null,null,null,null,{"$f":"F60/E60-1","v":0.10049712017338663},{"$f":"G60/F60-1","v":8.8798187788816207E-2},6.6264559695452085E-2,6.2764556185938902E-2]
["CPI",null,null,null,null,{"$f":"'GPB data'!F27","v":5.2149479659413522E-2},{"$f":"'GPB data'!G27","v":4.6285303231120345E-2},{"$f":"'GPB data'!H27","v":2.4743735220526197E-2},{"$f":"'GPB data'!I27","v":2.1492154019882248E-2}]
["CPRG",null,null,null,null,{"$f":"'GPB data'!F66","v":1.5486737211301289E-2},{"$f":"'GPB data'!G66","v":1.0322534348871322E-2},{"$f":"'GPB data'!H66","v":1.0211894743768438E-2},{"$f":"'GPB data'!I66","v":1.0101002404889125E-2}]
["Real MAR increases SPA",null,null,null,null,{"$f":"(F60/E60)/(1+F62)/(1+F63)-1","v":2.999996513690717E-2},{"$f":"(G60/F60)/(1+G62)/(1+G63)-1","v":3.0000000000000027E-2},2.9999999999999805E-2,3.0000000000000027E-2]
["Goal-sought number to be equal to zero",null,null,null,null,{"$f":"Real_MAR-AVERAGE($G$64:$I$64)","v":-3.4863092784193084E-8}]
[]
["Outputs"]
["Pricing year ending in calendar year:"]
["Maximum allowable revenue before tax in revenue-date terms for industry wide X factor",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026},null,"simple ref"]
["Maximum allowable revenue before tax in revenue-date terms for applicable X factor",null,null,null,null,{"$f":"F26","v":58316.783576111382},{"$f":"G26","v":61645.833277031728},{"$f":"H26","v":63816.278908925728},{"$f":"I26","v":65846.290613672361},null,"simple ref"]
["Starting price for industry-wide X factor",null,null,null,null,{"$f":"F49","v":55797.710043084116},{"$f":"G49","v":60752.445577675819},{"$f":"H49","v":64778.179634302425},{"$f":"I49","v":68843.953329582437},null,"simple ref"]
["Starting price for applicable X factor",null,null,null,null,{"$f":"F26","v":58316.783576111382},null,null,null,null,"simple ref"]
[{"$f":"\"PV at \" & TEXT('GPB data'!B14, \"dd-mmm-yy\") & \" of MAR before tax over the regulatory period (applicable X )\"","v":"PV at 30-Sep-22 of MAR before tax over the regulatory period (applicable X )"},null,null,null,null,{"$f":"F49","v":55797.710043084116},null,null,null,null,"simple ref"]
["ΔD",null,null,null,null,{"$f":"C43","v":220170.64447318591},null,null,null,null,"simple ref"]
["ANR (industry-wide X-factor) pricing year ending Sep 2023, GDBs only",null,null,null,null,{"$f":"IF(Outputs!B22>4,\"\",C53)","v":1.0297256851263301},null,null,null,null,"simple ref"]
[null,null,null,null,null,{"$f":"IF(Outputs!B22>4,\"\",C54)","v":54186.965372470702},null,null,null,null,"simple ref"]
[]
["DPP3 Real MAR increases",null,null,null,null,{"$f":"F$4","v":2023},{"$f":"G$4","v":2024},{"$f":"H$4","v":2025},{"$f":"I$4","v":2026}]
["Nominal MAR - SPA",null,null,null,{"$f":"IF($F$39<0.1,MAR!E35,MAR!E60)","v":50702.277198411044},{"$f":"IF($F$39<0.1,MAR!F35,MAR!F60)","v":58316.783576111382},{"$f":"IF($F$39<0.1,MAR!G35,MAR!G60)","v":61645.833277031728},{"$f":"IF($F$39<0.1,MAR!H35,MAR!H60)","v":63816.278908925728},{"$f":"IF($F$39<0.1,MAR!I35,MAR!I60)","v":65846.290613672361}]
["Nominal MAR increases %",null,null,null,null,{"$f":"IF($F$39<0.1,MAR!F36,MAR!F61)","v":0.15018075712660428},{"$f":"IF($F$39<0.1,MAR!G36,MAR!G61)","v":5.7085619212442928E-2},{"$f":"IF($F$39<0.1,MAR!H36,MAR!H61)","v":3.5208310383934238E-2},{"$f":"IF($F$39<0.1,MAR!I36,MAR!I61)","v":3.1810248724212453E-2}]
["CPI",null,null,null,null,{"$f":"IF($F$39<0.1,MAR!F37,MAR!F62)","v":5.2149479659413522E-2},{"$f":"IF($F$39<0.1,MAR!G37,MAR!G62)","v":4.6285303231120345E-2},{"$f":"IF($F$39<0.1,MAR!H37,MAR!H62)","v":2.4743735220526197E-2},{"$f":"IF($F$39<0.1,MAR!I37,MAR!I62)","v":2.1492154019882248E-2}]
["CPRG",null,null,null,null,{"$f":"IF($F$39<0.1,MAR!F38,MAR!F63)","v":1.5486737211301289E-2},{"$f":"IF($F$39<0.1,MAR!G38,MAR!G63)","v":1.0322534348871322E-2},{"$f":"IF($F$39<0.1,MAR!H38,MAR!H63)","v":1.0211894743768438E-2},{"$f":"IF($F$39<0.1,MAR!I38,MAR!I63)","v":1.0101002404889125E-2}]
["Real MAR increases SPA",null,null,null,null,{"$f":"IF($F$39<0.1,MAR!F39,MAR!F64)","v":7.6500899479767126E-2},{"$f":"IF($F$39<0.1,MAR!G39,MAR!G64)","v":0},{"$f":"IF($F$39<0.1,MAR!H39,MAR!H64)","v":0},{"$f":"IF($F$39<0.1,MAR!I39,MAR!I64)","v":0}]
["Rate of Change",null,null,null,null,{"$f":"IF($F$39<0.1,MAR!G83,MAR!G83)*-1","v":0}]
["ΔD",null,null,null,null,{"$f":"IFERROR(IF($F$39<0.1,C30,C53),\"\")","v":1.0297256851263301}]
["ANR pricing year ending Sep 2021, GDB only",null,null,null,null,{"$f":"IFERROR(IF($F$39<0.1,C31,C54),\"\")","v":56633.31935723919}]

{"sheet":"Outputs","index":12,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["DPP reset output table"]
["This worksheet uses Excel's data table facility to display the calculated results for all suppliers."]
[]
["GAS DPP3 Final Decision"]
["1, Copy values of blended ADF below from Asset Stranding model, tab \"AS Decision DPP3\" into cells B7:B11 below"]
[null,"ADF from AS workbook"]
["Final X factor and ADF for GasNet",0.81488859839952976]
["Final X factor and ADF for PowerCo",0.83896143833212278]
["Final X factor and ADF for Vector",0.659350593591289]
["Final X factor and ADF for FirstGas Distribution",0.69349352067268055]
["Final X factor and ADF for First Gas Transmission",0.7507305755130802]
[]
["2, Using button, run macro to derive Final X factor and Adjustment Factor ->",null,"Blended ADF","X factor for Blended ADF","Calculation field","X factor 10% cap, 0.5% rounding","Final Adjustment Factor"]
["Final X factor and ADF for GasNet",null,0.81757813302741811,-5.4611444100570145E-2,{"$f":"X_factor_GasNet","v":-5.5E-2},{"$f":"IF(E14>0,MROUND(IF(ABS(E14)>0.1,0.1,ABS(E14)),0.005),MROUND(IF(ABS(E14)>0.1,-0.1,(E14)),-0.005))","v":-5.5E-2},{"$f":"ADF_GasNet","v":0.81488859839952976}]
["Final X factor and ADF for PowerCo",null,0.82858495745860539,-5.2188580372519437E-2,{"$f":"X_factor_PowerCo","v":-0.05},{"$f":"IF(E15>0,MROUND(IF(ABS(E15)>0.1,0.1,ABS(E15)),0.005),MROUND(IF(ABS(E15)>0.1,-0.1,(E15)),-0.005))","v":-0.05},{"$f":"ADF_PowerCo","v":0.83896143833212278}]
["Final X factor and ADF for Vector",null,0.66398419968531996,-2.8767632477019779E-2,{"$f":"X_factor_Vector","v":-0.03},-0.03,{"$f":"ADF_Vector","v":0.659350593591289}]
["Final X factor and ADF for FirstGas Distribution",null,0.6783399438636184,-0.10376833933772329,{"$f":"X_factor_FGD","v":-0.1},-0.1,{"$f":"ADF_FGD","v":0.69349352067268055}]
["Final X factor and ADF for First Gas Transmission",null,0.74508561517779914,-8.6563308202844386E-2,{"$f":"X_factor_FGT","v":-8.5000000000000006E-2},-8.5000000000000006E-2,{"$f":"ADF_FGT","v":0.7507305755130802}]
[]
["Outputs"]
["Chosen supplier",{"$f":"GPB_name","v":"Vector"}]
["Supplier number",{"$f":"Inputs!C4","v":3}]
["tax timing","tax date mid-period"]
[null,"Active GDB outputs",{"$f":"Inputs!B22","v":"GasNet"},{"$f":"Inputs!C22","v":"Powerco"},{"$f":"Inputs!D22","v":"Vector"},{"$f":"Inputs!E22","v":"First Gas distribution"},{"$f":"Inputs!F22","v":"First Gas transmission"}]
["Supplier number",{"$f":"B22","v":3},{"$f":"Inputs!B23","v":1},{"$f":"Inputs!C23","v":2},{"$f":"Inputs!D23","v":3},{"$f":"Inputs!E23","v":4},{"$f":"Inputs!F23","v":5}]
[null,null,0,0,0,0,0]
["PV of BBAR at 30 September 2022",{"$f":"BBAR!B89","v":220170.64447318591},19450.453480849101,235151.99757163052,220170.64447318591,123060.13386219344,607398.98832180479]
["Starting price for industry-wide X factor",{"$f":"MAR!F72","v":58316.783576111382},5255.4925574853805,62036.032919357698,58316.783576111382,33030.059883618269,166426.9880533478]
["Starting price for applicable X factor",{"$f":"MAR!F73","v":55797.710043084116},4852.0403518113271,57632.911093390459,55797.710043084116,28565.852081866513,147227.28121438954]
["PV at 30 September 2022 of MAR (applicable X)",{"$f":"MAR!F74","v":220170.64447318591},19450.453480849101,235151.99757163052,220170.64447318591,123060.13386219344,607398.98832180479]
["MAR (industry-wide X factor), pricing period ending 2023",{"$f":"MAR!F70","v":58316.783576111382},5255.4925574853805,62036.032919357698,58316.783576111382,33030.059883618269,166426.9880533478]
["MAR (industry-wide X factor), pricing period ending 2024",{"$f":"MAR!G70","v":61645.833277031728},5481.1134819682766,65782.0051285714,61645.833277031728,34603.225111084299,170295.50657856854]
["MAR (industry-wide X factor), pricing period ending 2025",{"$f":"MAR!H70","v":63816.278908925728},5597.2796364887399,68268.216642964282,63816.278908925728,35499.261245851041,173743.6485460955]
["MAR (industry-wide X factor), pricing period ending 2026",{"$f":"MAR!I70","v":65846.290613672361},5696.4055479130502,70573.884250384537,65846.290613672361,36297.232791760172,177218.52151701745]
["DPP3 MAR pricing period ending 2023",{"$f":"MAR!F79","v":58316.783576111382},4852.0403518113271,57632.911093390459,58316.783576111382,28565.852081866513,147227.28121438954]
["DPP3 MAR pricing period ending 2024",{"$f":"MAR!G79","v":61645.833277031728},5338.6596192036195,64168.656318669084,61645.833277031728,32919.034204534095,163454.71988581572]
["DPP3 MAR pricing period ending 2025",{"$f":"MAR!H79","v":63816.278908925728},5751.6559853987037,69923.586379332599,63816.278908925728,37148.604807211515,180939.31938394424]
["DPP3 MAR pricing period ending 2026",{"$f":"MAR!I79","v":65846.290613672361},6175.4592209665452,75899.419977248355,65846.290613672361,41782.01630625355,200245.54476221118]
["BBAR before tax, for the BBAR period ending 2023",{"$f":"BBAR!F93","v":43161.896723082704},3798.3417590034305,61700.571135390717,43161.896723082704,31531.562098363262,160646.80980233673]
["BBAR before tax, for the BBAR period ending 2024",{"$f":"BBAR!G93","v":61178.419610154779},5367.0463366906315,65588.348480181477,61178.419610154779,34136.099485076091,170006.5531524299]
["BBAR before tax, for the BBAR period ending 2025",{"$f":"BBAR!H93","v":63774.707720990024},5629.7035767212783,68715.243273812303,63774.707720990024,36278.197653041709,176687.99404902759]
["BBAR before tax, for the BBAR period ending 2026",{"$f":"BBAR!I93","v":64810.058828301124},5773.1813188193619,70747.069298647126,64810.058828301124,37803.548000830568,181403.47351826646]
["ΔD",{"$f":"MAR!F85","v":1.0297256851263301},0.99607102026032623,1.0280839896344838,1.0297256851263301,1.0274419505609997,""]
["ANR 2023 (applicable X-factor)",{"$f":"MAR!F86","v":56633.31935723919},4871.1791158658862,56058.562991415492,56633.31935723919,27802.886641205474,""]
["MAR 2022 Forecast Nominal $",{"$f":"MAR!E60","v":50702.277198411044},4383.9982678933238,51435.568618416459,50702.277198411044,24646.151307304975,131623.38640956243]
["Real MAR %",{"$f":"MAR!F83","v":7.6500899479767126E-2},5.4994798860483085E-2,5.0000042198169004E-2,7.6500899479767126E-2,0.10000000055699099,8.500002871869472E-2]
["Adjustment Factor",{"$f":"RAB!B12","v":0.659350593591289},0.81488859839952976,0.83896143833212278,0.659350593591289,0.69349352067268055,0.7507305755130802]
["Rate of Change",{"$f":"MAR!F84","v":0},-5.4999999999999938E-2,-4.9999999999999822E-2,0,-9.9999999999999867E-2,-8.4999999999999742E-2]
["Real price increase with one-off SPA",{"$f":"MAR!F39","v":7.6500899479767126E-2},0.14271871451506324,0.13021945182642036,7.6500899479767126E-2,0.2719055530446306,0.2264933871494974]
["Implied Rate of change for (applicable X factor)",{"$f":"Real_MAR*-1","v":-2.999996513690717E-2},-5.4994798860483085E-2,-5.0000042198169004E-2,-2.999996513690717E-2,-0.10000000055699099,-8.500002871869472E-2]
["Remaining Asset Life for Existing Assets in 2021 unadjusted",{"$f":"RAB!D5/RAB!D6","v":34.236518448438979},27.029213483146066,23.537782753579943,34.236518448438979,27.801919644738813,24.79594925455509]
["Remaining Asset Life for Existing Assets in 2023 unadjusted",{"$f":"(RAB!D5/RAB!D6)-2","v":32.236518448438979},25.029213483146066,21.537782753579943,32.236518448438979,25.801919644738813,22.79594925455509]
["Remaining Asset Life for Existing Assets in 2023 adjusted /  Transitional Adjusted Asset Life",{"$f":"RAB!B107","v":20.573868761477357},20.025797891122572,17.747292074092464,20.573868761477357,17.280451135888878,16.615077254265273]
["Total depreciation over four disclosure years, starting in 2022/2023",{"$f":"RAB!B106","v":94016.876204780914},5298.0765769339923,95262.002290614153,94016.876204780914,44218.014630959515,219849.05161680069]

{"sheet":"Outputs to Chartbook","index":13,"n_rows":171,"n_cols":8,"rows_kept":171,"cut":false,"hidden":false,"merged":[]}
["Outputs to chartbook"]
[]
[]
["Reasons Paper Charts"]
["Chapter 4 tables"]
[null,"Table 4.2 MAR in each year of the regulatory period ($m, nominal)"]
[null,"Year","2021/2022 forecast MAR","2022/2023","2023/2024","2024/2025","2025/2026"]
[null,"GasNet - Draft",{"$f":"(Outputs!C45)/1000","v":4.3839982678933236},{"$f":"'[5]Outputs to Chartbook'!D8","v":4.8387890143305832},{"$f":"'[5]Outputs to Chartbook'!E8","v":5.2841277471938444},{"$f":"'[5]Outputs to Chartbook'!F8","v":5.6810290577007203},{"$f":"'[5]Outputs to Chartbook'!G8","v":6.093140701897255}]
[null,"GasNet - Final",{"$f":"(C8)","v":4.3839982678933236},{"$f":"(Outputs!$C$35)/1000","v":4.8520403518113273},{"$f":"(Outputs!$C$36)/1000","v":5.3386596192036198},{"$f":"(Outputs!$C$37)/1000","v":5.7516559853987035},{"$f":"(Outputs!$C$38)/1000","v":6.1754592209665455}]
[null,"Powerco - Draft",{"$f":"(Outputs!D45)/1000","v":51.435568618416461},{"$f":"'[5]Outputs to Chartbook'!D9","v":58.875074667292026},{"$f":"'[5]Outputs to Chartbook'!E9","v":66.647731492930163},{"$f":"'[5]Outputs to Chartbook'!F9","v":74.245167016280959},{"$f":"'[5]Outputs to Chartbook'!G9","v":82.474690088078376}]
[null,"Powerco - Final",{"$f":"(C10)","v":51.435568618416461},{"$f":"(Outputs!$D$35)/1000","v":57.632911093390462},{"$f":"(Outputs!$D$36)/1000","v":64.168656318669079},{"$f":"(Outputs!$D$37)/1000","v":69.923586379332605},{"$f":"(Outputs!$D$38)/1000","v":75.899419977248357}]
[null,"Vector - Draft",{"$f":"(Outputs!E45)/1000","v":50.702277198411046},{"$f":"'[5]Outputs to Chartbook'!D10","v":56.85601745141377},{"$f":"'[5]Outputs to Chartbook'!E10","v":62.771439747555824},{"$f":"'[5]Outputs to Chartbook'!F10","v":68.230698461355786},{"$f":"'[5]Outputs to Chartbook'!G10","v":73.989155492156982}]
[null,"Vector - Final",{"$f":"(C12)","v":50.702277198411046},{"$f":"(Outputs!$E$35)/1000","v":58.316783576111384},{"$f":"(Outputs!$E$36)/1000","v":61.645833277031727},{"$f":"(Outputs!$E$37)/1000","v":63.816278908925725},{"$f":"(Outputs!$E$38)/1000","v":65.846290613672366}]
[null,"First Gas distribution - Draft",{"$f":"(Outputs!F45)/1000","v":24.646151307304976},{"$f":"'[5]Outputs to Chartbook'!D11","v":28.249967934966399},{"$f":"'[5]Outputs to Chartbook'!E11","v":32.036118072450918},{"$f":"'[5]Outputs to Chartbook'!F11","v":35.765055397940557},{"$f":"'[5]Outputs to Chartbook'!G11","v":39.830532181585156}]
[null,"First Gas distribution - Final",{"$f":"(C14)","v":24.646151307304976},{"$f":"(Outputs!$F$35)/1000","v":28.565852081866513},{"$f":"(Outputs!$F$36)/1000","v":32.919034204534093},{"$f":"(Outputs!$F$37)/1000","v":37.148604807211512},{"$f":"(Outputs!$F$38)/1000","v":41.782016306253553}]
[null,"First Gas transmission - Draft",{"$f":"(Outputs!G45)/1000","v":131.62338640956244},{"$f":"'[5]Outputs to Chartbook'!D12","v":148.76185123351695},{"$f":"'[5]Outputs to Chartbook'!E12","v":167.03312672078675},{"$f":"'[5]Outputs to Chartbook'!F12","v":187.41116818072274},{"$f":"'[5]Outputs to Chartbook'!G12","v":210.27533069877097}]
[null,"First Gas transmission - Final",{"$f":"(C16)","v":131.62338640956244},{"$f":"(Outputs!$G$35)/1000","v":147.22728121438954},{"$f":"(Outputs!$G$36)/1000","v":163.45471988581573},{"$f":"(Outputs!$G$37)/1000","v":180.93931938394425},{"$f":"(Outputs!$G$38)/1000","v":200.24554476221118}]
[]
[null,"Table 4.3 Starting prices (excluding pass-through and recoverable costs) and rate of change"]
[null,"Supplier","Starting prices($m)","Real price increase from 2022","Rate of change"]
[null,"GasNet - Draft",{"$f":"'[5]Outputs to Chartbook'!C16","v":4.8387890143305832},{"$f":"E21","v":-5.114540505171547E-2},{"$f":"'[5]Outputs to Chartbook'!E16","v":-5.114540505171547E-2}]
[null,"GasNet - Final",{"$f":"(Outputs!$C$35)/1000","v":4.8520403518113273},{"$f":"E22","v":-5.4999999999999938E-2},{"$f":"Outputs!C48","v":-5.4999999999999938E-2}]
[null,"Powerco - Draft",{"$f":"'[5]Outputs to Chartbook'!C17","v":58.875074667292026},-7.4856321772311094E-2,{"$f":"'[5]Outputs to Chartbook'!E17","v":-7.4856321772311094E-2}]
[null,"Powerco - Final",{"$f":"(Outputs!$D$35)/1000","v":57.632911093390462},-4.9999999999999822E-2,{"$f":"Outputs!D48","v":-4.9999999999999822E-2}]
[null,"Vector - Draft",{"$f":"'[5]Outputs to Chartbook'!C18","v":56.85601745141377},-5.2202749200648838E-2,{"$f":"'[5]Outputs to Chartbook'!E18","v":-5.2202749200648838E-2}]
[null,"Vector - Final",{"$f":"(Outputs!$E$35)/1000","v":58.316783576111384},{"$f":"Outputs!E46*-1","v":-7.6500899479767126E-2},{"$f":"Outputs!E48","v":0}]
[null,"First Gas distribution - Draft",{"$f":"'[5]Outputs to Chartbook'!C19","v":28.249967934966399},-0.1,{"$f":"'[5]Outputs to Chartbook'!E19","v":-0.1}]
[null,"First Gas distribution - Final",{"$f":"(Outputs!$F$35)/1000","v":28.565852081866513},-9.9999999999999867E-2,{"$f":"Outputs!F48","v":-9.9999999999999867E-2}]
[null,"First Gas transmission - Draft",{"$f":"'[5]Outputs to Chartbook'!C20","v":148.76185123351695},-0.1,{"$f":"'[5]Outputs to Chartbook'!E20","v":-0.1}]
[null,"First Gas transmission - Final",{"$f":"(Outputs!$G$35)/1000","v":147.22728121438954},-8.4999999999999742E-2,{"$f":"Outputs!G48","v":-8.4999999999999742E-2}]
[]
[null,"Table 4.4 Adjustment Factors to be applied to asset lives for DPP3"]
[null,"Supplier","Adjustment Factor"]
[null,"GasNet",{"$f":"TRANSPOSE(Outputs!$C$47:$G$47)","v":0.81488859839952976}]
[null,"Powerco",0.83896143833212278]
[null,"Vector",0.659350593591289]
[null,"First Gas distribution",0.69349352067268055]
[null,"First Gas transmission",0.7507305755130802]
[]
[null,"Table 4.5 Implied real price increases due to one-off starting price adjustment"]
[null,"Supplier","Implied starting price($m)","Implied real price increase for year 1 of DPP3"]
[null,"GasNet",{"$f":"(Outputs!$C$31)/1000","v":5.2554925574853808},{"$f":"TRANSPOSE(Outputs!$C$49:$G$49)","v":0.14271871451506324}]
[null,"Powerco",{"$f":"(Outputs!$D$31)/1000","v":62.036032919357702},0.13021945182642036]
[null,"Vector",{"$f":"(Outputs!$E$31)/1000","v":58.316783576111384},7.6500899479767126E-2]
[null,"First Gas distribution",{"$f":"(Outputs!$F$31)/1000","v":33.030059883618271},0.2719055530446306]
[null,"First Gas transmission",{"$f":"(Outputs!$G$31)/1000","v":166.4269880533478},0.2264933871494974]
[]
[null,"Table 4.6 Alternative rate of change for each GPB"]
[null,"Supplier","Rate of change (X-factor) as set out in our draft decision","Proposed rate of change (X-factor)"]
[null,"GasNet",{"$f":"'[5]Outputs to Chartbook'!C40","v":-5.114540505171547E-2},{"$f":"TRANSPOSE(Outputs!$C$48:$G$48)","v":-5.4999999999999938E-2}]
[null,"Powerco",{"$f":"'[5]Outputs to Chartbook'!C41","v":-7.4856321772311094E-2},-4.9999999999999822E-2]
[null,"Vector",{"$f":"'[5]Outputs to Chartbook'!C42","v":-5.2202749200648838E-2},0]
[null,"First Gas distribution",{"$f":"'[5]Outputs to Chartbook'!C43","v":-0.1},-9.9999999999999867E-2]
[null,"First Gas transmission",{"$f":"'[5]Outputs to Chartbook'!C44","v":-0.1},-8.4999999999999742E-2]
[]
[null,"Table X1 Starting proces and rates of change"]
[null,"Gas pipeline Business","Starting prices (Maximum allowable revenue in 2022/23 ($m))","Rate of change (Relative to CPI)"]
[null,"GasNet",{"$f":"Outputs!C35/1000","v":4.8520403518113273},{"$f":"(Outputs!C48)/-1","v":5.4999999999999938E-2}]
[null,"Powerco",{"$f":"Outputs!D35/1000","v":57.632911093390462},{"$f":"(Outputs!D48)/-1","v":4.9999999999999822E-2}]
[null,"Vector",{"$f":"Outputs!E35/1000","v":58.316783576111384},{"$f":"(Outputs!E48)/-1","v":0}]
[null,"First Gas distribution",{"$f":"Outputs!F35/1000","v":28.565852081866513},{"$f":"(Outputs!F48)/-1","v":9.9999999999999867E-2}]
[null,"First Gas transmission",{"$f":"Outputs!G35/1000","v":147.22728121438954},{"$f":"(Outputs!G48)/-1","v":8.4999999999999742E-2}]
[null,null,{"$f":"SUM(C58:C62)","v":296.59486831756919}]
[]
["Transmission Determination Tables & Values"]
[]
[null,"Schedule 1: Starting prices"]
[null,null,"Actual net allowable revenue $m","Decimal places"]
[null,"Starting price",{"$f":"Outputs!G35/1000","v":147.22728121438954},3]
[]
[null,"Schedule 2: Rate of change"]
[null,null,"Rate of change / Alternative X factor"]
[null,"Rate of change",{"$f":"Outputs!G48","v":-8.4999999999999742E-2}]
[]
[]
[null,"Schedule 4: Forecast Net Allowable Revenue"]
[null,null,"Forecast net allowable revenue $k","Decimal places"]
[null,"2023-09-30",{"$f":"Outputs!G35","v":147227.28121438954},3]
[null,"2024-09-30",{"$f":"Outputs!G36","v":163454.71988581572},3]
[null,"2025-09-30",{"$f":"Outputs!G37","v":180939.31938394424},3]
[null,"2026-09-30",{"$f":"Outputs!G38","v":200245.54476221118},3]
[]
[]
[]
[]
[]
[null,"Schedule 8: Calculation of Opening Wash-up Account Balance"]
[null,null,"Value","Decimal places",null,null,null,"This is the 67th percentile estimate of post tax WACC, as"]
[null,"Discount rate %",5.67E-2,2,null,null,null,"required by GTB determination Schedule 9."]
[]
["Distribution Determination Tables & Values"]
[]
[null,"Schedule 1: Starting prices"]
[null,"GDB","Maximum allowable revenue $m","Decimal places"]
[null,"GasNet Limited",{"$f":"D9","v":4.8520403518113273},3]
[null,"Powerco Limited",{"$f":"D11","v":57.632911093390462},3]
[null,"Vector Limited",{"$f":"D13","v":58.316783576111384},3]
[null,"First Gas Limited",{"$f":"D15","v":28.565852081866513},3]
[]
[null,"Schedule 2: rate of change"]
[null,null,"Rate of change / Alternative X factor"]
[null,"GasNet Limited",{"$f":"Outputs!C48","v":-5.4999999999999938E-2}]
[null,"Powerco Limited",{"$f":"Outputs!D48","v":-4.9999999999999822E-2}]
[null,"Vector Limited",{"$f":"Outputs!E48","v":0}]
[null,"First Gas Distribution Ltd",{"$f":"Outputs!F48","v":-9.9999999999999867E-2}]
[]
[]
[null,"Schedule 3: Allowable notional revenue for the First Assessment Period"]
[null,"GDB","ΔD","Decimal places"]
[null,"GasNet Limited",{"$f":"TRANSPOSE(Outputs!C43:F43)","v":0.99607102026032623},4]
[null,"Powerco Limited",1.0280839896344838,4]
[null,"Vector Limited",1.0297256851263301,4]
[null,"First Gas Limited",1.0274419505609997,4]
[]
[null,"Schedule 5: Calculation of Wash-up Amount for the first Assessment Period"]
[null,null,"Value","Decimal places"]
[null,"Discount rate %",{"$f":"Inputs!B17","v":4.0399999999999998E-2},2,null,null,null,"Cost of debt"]
[]
["Reasons Paper Charts"]
["Chapter 4 tables (continued)"]
[]
[null,"Table 4.X Unadjusted remaining lives in first year of DPP3, DY2020 versus DY2021 (Existing Assets)"]
[null,"Gas Pipeline Business"," DY20 data","DY21 data"]
[null,"GasNet",26.412269938650308,{"$f":"TRANSPOSE(Outputs!$C$52:$G$52)","v":25.029213483146066}]
[null,"Powerco",17.421781363497615,21.537782753579943]
[null,"Vector",31.873587872593909,32.236518448438979]
[null,"First Gas distribution",21.82628380019365,25.801919644738813]
[null,"First Gas transmission",20.887919735761333,22.79594925455509]
[]
[null,"Table 4.X Adjusted remaining asset lives in first year of DPP3, DY2020 versus DY2021 (Existing Assets)"]
[null,"Gas Pipeline Business"," DY20 data","DY21 data"]
[null,"GasNet",15.764166350405986,{"$f":"TRANSPOSE(Outputs!C53:G53)","v":20.025797891122572}]
[null,"Powerco",14.792225320081798,17.747292074092464]
[null,"Vector",17.922481317788815,20.573868761477357]
[null,"First Gas distribution",18.016847974913674,17.280451135888878]
[null,"First Gas transmission",14.928104175551553,16.615077254265273]
[]
[null,"Table 4.X Adjustment factor for shortening asset lives"]
[]
[null,"Gas Pipeline Business","Adjustment Factor\nDraft","Adjustment Factor\n Final"]
[null,"GasNet",0.63797069690796704,{"$f":"TRANSPOSE(Outputs!C47:G47)","v":0.81488859839952976}]
[null,"Powerco",0.87123767527371776,0.83896143833212278]
[null,"Vector",0.59995207244595439,0.659350593591289]
[null,"First Gas distribution",0.84655634101587696,0.69349352067268055]
[null,"First Gas transmission",0.75050922700114164,0.7507305755130802]
[]
["Transmission Determination Tables & Values"]
[]
[null,"Schedule 9: Transitional Adjusted Asset Life"]
[null,null,"Value","Decimal places"]
[null,"Transitional adjusted asset life",{"$f":"Outputs!G53","v":16.615077254265273},2]
[]
[null,"Schedule 10: Total depreciation"]
[null,null,"Value","Decimal places"]
[null,"Total depreciation, $m",{"$f":"Outputs!G54/1000","v":219.84905161680069},2]
[]
["Distribution Determination Tables & Values"]
[]
[null,"Schedule 6: Transitional Adjusted Asset Life"]
[null,null,"Transitional adjusted asset life","Decimal places"]
[null,{"$f":"B110","v":"GasNet Limited"},{"$f":"TRANSPOSE(Outputs!C53:G53)","v":20.025797891122572},2]
[null,{"$f":"B111","v":"Powerco Limited"},17.747292074092464,2]
[null,{"$f":"B112","v":"Vector Limited"},20.573868761477357,2]
[null,{"$f":"B113","v":"First Gas Limited"},17.280451135888878,2]
[]
[null,"Schedule 7: Total depreciation"]
[null,null,"Total depreciation, $m","Decimal places"]
[null,{"$f":"B161","v":"GasNet Limited"},{"$f":"Outputs!C54/1000","v":5.2980765769339921},2]
[null,{"$f":"B162","v":"Powerco Limited"},{"$f":"Outputs!D54/1000","v":95.262002290614149},2]
[null,"Vector Limited",{"$f":"Outputs!E54/1000","v":94.016876204780914},2]
[null,"First Gas Limited",{"$f":"Outputs!F54/1000","v":44.218014630959516},2]

{"sheet":"Notes","index":14,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Model notes"]
[]
["Ref #","Description","Calculation method","Input methodology reference, rationale, reference or other justification for the calculation method"]
[]
["BBAR sheet"]
[1,"Proportion of BBAR year in the regulatory period","Number of BBAR months in the regulatory period / 12","Standard calculation for a proportion."]
[{"$f":"A6+1","v":2},"Cumulative number of days from start of regulatory period to end of BBAR period","Zero in the gap year, otherwise equals the previous year's value + Number of BBAR days in the BBAR period","Standard calculation for a cumulative value"]
[{"$f":"A7+1","v":3},"PV factor from end of each BBAR period","(1+WACC)^(-1*Cumulative number of days from start of regulatory period to end of BBAR period/365)","Standard present value formula for the present value factor for a period of \"n\" years."]
[4,"Asset base scaling factor","Aggregate opening RAB value in each BBAR period / Aggregate opening RAB value in the base year","IM paragraph 4.4.9(2) sets the TCSD allowance at a × b ÷ c. The asset base scaling factor is the b ÷ c in this formula."]
[5,"Term credit spread differential allowance","Term credit spread differential allowance * Asset base scaling factor","TCSD allowance is calculated according to IM 4.4.9(2) by this formula. See definition of the asset base scaling factor above."]
[6,"Opening investment value (full BBAR year values)","Opening RAB + if the tax allowance is on a deferred tax basis, add the deferred tax balance, otherwise do not add anything to the RAB.","Note that while this is according to the IMs, it is in part used for some calculations not covered by the IMs."]
[7,"Opening investment value at the start of the regulatory period","Opening value at the start of the regulatory period calculated by linear interpolation of the values at the opening and closing of the first BBAR year."]
[{"$f":"A11+1","v":7},{"$f":"BBAR!A40","v":"Closing investment value, end of 5th BBAR year"},"Closing RAB plus, if a deferred tax approach is being applied, the closing deferred tax"]
[{"$f":"A12+1","v":8},"Closing investment value at the end of the regulatory period","Closing value at the end of the regulatory period calculated by linear interpolation of the values at the opening and closing of the last BBAR year."]
[9,"Opening investment value at the start of each BBAR period",{"$f":"\"Opening value at the start of each full 12 month BBAR year, except for the first BBAR period, for which the opening value is the interpolated value as described at Item \" & A12 & \" above\"","v":"Opening value at the start of each full 12 month BBAR year, except for the first BBAR period, for which the opening value is the interpolated value as described at Item 7 above"},"Simple reference, except that the first year formula is different"]
[10,"Pro-rata of an annual value into the value for a part-year by multiplying by the proportion of the length of the part year to a full year","Multiply the annual value by the proportion of BBAR year in the regulatory period"]
[11,"Change in deferred tax","Difference between the closing and opening deferred tax for the full BBAR year","Sign convention adopted is positive value indicates an increase, and positive deferred tax balance is an asset for the supplier. This is implicit in the tax input methodology."]
[12,"WACC adjusted for full and part years","(1+WACC)^(-1*Number of days in the BBAR period/365)-1"]
[13,"Return on capital","Regulatory investment value * WACC plus value of additional assets * (mid-year timing factor -1) plus TCSD less revaluations","See paragraph 34 of Attachment A of the model specification. "]
[14,"BBAR before tax in revenue date terms, calculation not referencing tax, deferred tax approach","BBAR formula per Attachment A, Equation 14 of the model specification","Attachment A to the model specification contains an algebraic derivation of a formula that calculates the BBAR from a number of variables. See Equation 14 for the deferred tax case, and Attachment B Equation 26 for the tax payable case. The variables do not include the tax allowance or the BBAR itself, and so breaks a circularity that could otherwise exist in calculating both the tax allowance and BBAR."]
[15,"Regulatory tax allowance before considering possibility of tax losses","Regulatory net taxable income * corporate tax rate","See Attachment A, Equation 5. Developed as a formula from IM provisions."]
[16,"Regulatory tax allowance","Regulatory tax allowance multiplied by the tax rate, except that if regulatory taxable income is negative (which is not expected to occur), then the #N/A error value shall be returned, which will poison all dependent formulas to all levels with #N/A to alert the workbook user to the tax loss issue.","This approach allows some simplification of the financial model. In effect we assume tax losses arise for no supplier in any BBAR period. In the event of tax losses occurring they will be flagged by the \"poisoning\" of the results. Note that the derivation of the BBAR formula in the attachments to the model specification relies on no tax losses arising."]
[17,"BBAR before tax in period-end terms, direct simple calculation, deferred tax approach","BBAR formula per Attachment A, Equation 10 of the model specification","See Attachment A. Developed as a formula from the NPV=0 equation."]
[18,"BBAR before tax in revenue date terms","BBAR in year end terms divided by the revenue timing factor to determine BBAR in revenue date terms","Formula, as discussed in the model specification, for adjusting from a year-end value to a cash flow date value"]
[19,"Difference between the two BBAR calculations",{"$f":"\"Difference between the BBAR calculated using the formula that does not reference tax and the BBAR formula that does reference tax.\"","v":"Difference between the BBAR calculated using the formula that does not reference tax and the BBAR formula that does reference tax."},"The difference should be zero. This a check value to flag potential errors in the calculation of BBAR."]
[20,"Depreciation temporary differences, tax payable approach",null,"IM reference 4.3.3(1)"]
[21,"BBAR before tax in revenue date terms, calculation not referencing tax, tax payable approach","BBAR formula per Attachment B of the model specification","Attachment B to the model specification contains an algebraic derivation of a formula that calculates the BBAR from a number of variables. See Equation 26. These variables do not include the tax allowance or the BBAR itself, and so breaks a circularity that could otherwise exist in calculating both the tax allowance and BBAR."]
[22,"BBAR before tax in period-end terms, direct simple calculation, tax payable approach","BBAR formula per Attachment B, Equation 24 of the model specification","See Attachment B. Developed as a formula from the NPV=0 equation."]
[23,"Regulatory tax allowance before considering possibility of tax losses","Regulatory tax allowance before considering possibility of tax losses","See Attachment B, Equation 19. Developed as a formula from IM provisions."]
[24,"Formula for selecting between outputs that are dependent upon choice of tax approach","Formula used for four tax parameters that depend upon whether a deferred tax or a tax payable approach is used."]
[25,"Tax allowance in period-end terms","Formula used for tax allowance, according to whether a deferred tax or a tax payable approach is used. Multiplied by the tax timing factor for the BBAR period to produce the BBAR in BBAR period-end terms"]
[26,"Tax payable amount.  selecting between outputs that are dependent upon choice of tax approach and provides formula for one of them. Needs tidying.","Formula for tax payable, that depends upon whether a deferred tax or a tax payable approach is used. If deferred tax, then tax payable is calculated as the tax allowance plus the increase in deferred tax","If the tax payable approach is used, then the tax payable cash flow is the tax allowance. If the deferred tax approach is used then (per Equation 7 of Attachment A of the model specification), tax payable is the tax allowance plus the increase in deferred tax."]
[27,"PV at 30-Sep-22 of each full year's BBAR before tax","BBAR before tax in year-end terms x PV factor from end of each BBAR period to the start of the regulatory period","Present values the BBAR period-end value to the start of the regulatory period "]
[28,"PV at 30-Sep-22 of BBAR before tax","Simple sum of the series of present values for each BBAR"]
[]
["REV sheet"]
[100,"Index of cumulative CPI-X changes","equals 1 for first year of reg period, thereafter equals previous year's value x (1+∆CPI)(1-X)"]
[{"$f":"A37+1","v":101},"Index of constant price growth","equals 1 for first year of reg period, thereafter equals previous year's value x (1+CPRG)"]
[{"$f":"A38+1","v":102},"Indexed maximum allowable revenue before tax","If a WAPC applies, then this index is the index of cumulative CPI-X changes multiplied by the index of constant price revenue growth. If a revenue cap applies, then this index is equal to the index of cumulative CPI-X changes."]
[]
["MAR sheet"]
[110,"PV as at 30 Sep 2022 of maximum allowable revenue before tax","The present value of BBARs plus any additional allowance "]
[{"$f":"A42+1","v":111},"Present value, as at 30-9-22, of the indexed MAR of each assessment year","Each year's index of MAR, expressed as a year-end value divided by the (1+WACC) to the power of the number of years"]
[{"$f":"A43+1","v":112},"Total present value, as at 30-9-22, of all the MAR indices of the 5 pricing years","Simple sum of each of the 5 individual year present values"]
[113,"Formula for calculating the MAR for the first year of the regulatory period","Equal to the total present value of BBAR, plus any 'additional allowance', all divided by the present value of the indexed revenue"]
[114,"Maximum allowable revenue before tax in year-end terms","Indexed MAR scaled up such that the first year MAR equals its calculated value"]
[115,"Maximum allowable revenue before tax in revenue-date terms","Maximum allowable revenue before tax in year-end terms divided by the revenue timing factor"]
[116,"For each assessment year, the PV as at 30 Sep 2022 of maximum allowable revenue before tax in year-end terms","Each year's MAR, expressed as a year-end value divided by the (1+ the discount rate) to the power of the number of years"]
[117,"PV at 30 Sep 2022 of maximum allowable revenue before tax","Simple sum of each of the 5 individual year present values"]
[118,"Error check for PV equivalence (should = 0)","The present value of BBARs plus any additional allowance compared with the present value of MARs, all as at 30-9-22"]
[119,"ΔD","1 plus CPRG for the first assessment year multiplied by the same parameter for the prior year. Not applicable if pure revenue cap applies, in which case #N/A is returned.","∆D is effectively the conversion factor between MAR and allowable notional revenue. Takes into account the change in quantities during the lag period in the WAPC."]
[120,"ANR 2023","MAR for the assessment year ending 2023 divided by ∆D"]
[]
[]
[]
["Ref #","Name used in input methodologies","Name used within the financial model","Comments"]
[null,"Forecast aggregate value of disposed assets","Value of disposed assets"]
[null,"Aggregate closing RAB value for existing assets","Closing RAB value for existing assets"]