{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["CoverSheet","TOC & Instructions","AttachmentB","Description","Main","Outputs","alp","aur","ean","inv","fln","hor","nel","tas","ojv","ori","pco","tlc","top","uni","vct","wel"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":2,"defined_names":27,"comments":2,"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":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Electricity Distribution Business"]
["Price-Quality Regulation 1 April 2025 Reset"]
["Existing asset depreciation model"]
["May 2024 draft determination"]
[]
[]
[]
[]
[]
[]
[]
["Published 29 May 2024 v1"]

{"sheet":"TOC & Instructions","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Table of Contents and instructions, as given to EDBs as part of the s53ZD notice to EDBs, 20 March 2024"]
[]
[]
["Worksheet Name","Description",null,"Instructions"]
["Attachment B","This worksheet summarises the requirement for information required for the calculation of depreciation of existing assets as set out in Schedule B, of the Section 53ZD Notice to EDBs issued on 20 March 2024. It includes definitions for the terms used in the table in the 'Template' worksheet."]
["Template","This worksheet collects required information for compliance with the change to the IM determination to require EDBs, when forecasting depreciation for a DPP period, to depreciate existing assets using the weighted average value of the remaining asset life for those assets, as required by of the Section 53ZD Notice to EDBs issued on 20 March 2024.",null,"For each of the disclosure years 2024, 2025, 2026, 2027, 2028, 2029, and 2030, insert the specified information, calculated in accordance with the definitions provided in clause B1 of the  Section 53ZD notice issued on 20 March 2023.\n\nPlease provide this information in aggregate (not by asset class), in the form requested in the \"Template\" tab of this workbook. \n\nIf you are unable to provide any of this information, provide reasons in the space provided in the \"Template\" tab of this workbook.\n"]
[null,null,null,"Step 1: Base year calculations (disclosure year 2024): \nProvide the following information, calculated in accordance with Part 2 the IM determination (“Input Methodologies for Information Disclosure”) for the 2024 disclosure year. \n\nReferences to \"ID Schedule 4\" refer to Schedule 4 of the \"EDB Information Disclosure Requirements Information Templates Schedules 1-10 TIDR 2024\" (29 February 2024), available on our website at:\n https://comcom.govt.nz/__data/assets/excel_doc/0033/344877/EDB-Information-Disclosure-Requirements-Information-Templates-Schedules-1-10-TIDR-2024.xlsx\n\nCell B5: aggregate opening value for existing assets, which is equal to the ‘Total opening RAB value’ provided in line 10 of ID Schedule 4.\n\nCell B6: depreciation for existing assets, which is equal to ‘Total depreciation’ provided in line 12 of ID Schedule 4.\n\nCell B7: revaluation for existing assets, which is equal to ‘Total revaluations’, provided in line 14 of ID Schedule 4, using the revaluation rate provided in Row 13 of the \"Template\" tab of this workbook, ie revaluation rate = 3.80%.\n\nCell B8: aggregate value of disposed assets = 'Asset disposals', line 18 of ID Schedule 4.\n\nCell B9: no input required; forecast aggregate closing RAB value for existing assets will populate automatically. "]
[null,null,null,"Step 2: Forecast calculations (disclosure year 2025 to 2030): \nProvide the following forecast information:\n\nRow 5: no input required; forecast aggregate opening RAB value for existing assets will populate automatically.\n\nRow 6: provide the forecast sum of depreciation for existing assets, calculated in accordance with cl 4.2.2(2)(a)(ii) of the IM determination, where 'remaining asset life for existing assets' means the value determined in accordance with the formula in cl 4.2.2(3)(a)(i) of the IM determination, ie: \naggregate opening RAB value for existing assets for the disclosure year ÷ the sum of depreciation for existing assets for the disclosure year. \n\nRow 7: provide the forecast revaluation for existing assets, calculated in accordance with clause 4.2.3(2)(a) of the IM determination. \nFor this purpose, use the revaluation rate provided in Row 13 of the \"Template\" tab of this workbook.\n\nRow 8: where you have a forecast of assets to be disposed of in the disclosure year in question, provide the forecast aggregate value of disposed assets in Row 8. \nNote, this is equal to the portion of the forecast aggregate opening RAB value for existing assets relating to assets forecast to be disposed of for the disclosure year in question plus the total depreciation on disposed assets for the disclosure year in question.\n\nRow 9: no input required; forecast aggregate closing RAB value for existing assets will populate automatically."]

{"sheet":"AttachmentB","index":2,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Attachment B: Supporting information Information required for the calculation of depreciation of existing assets "]
["This Excel workbook is Attachment B referred to in the Notice issued under s 53ZD of the Commerce Act to all non-exempt EDBs on 20 March 2024."]
["Under the Notice, we require each non-exempt EDB to provide us with the information specified in Schedule B."]
["Note:  Non-exempt EDBs must  use the 'Template' worksheet to respond to clause 8 of the Notice. "]
[]
["Definition of terms "]
[]
["Term","Definitions /Explanation"]
["Act","Act means the Commerce Act 1986"]
["Aggregate opening RAB value for existing assets","Aggregate opening RAB value for existing assets means the amount determined in accordance with clause 4.2.1(2) of the IM determination "]
["Aggregate closing RAB value for existing assets ","Aggregate closing RAB value for existing assets means the amount determined in accordance with clause 4.2.1(3) of the IM determination"]
["Base year ","Base year means the disclosure year 2024"]
["Depreciation ","Depreciation has the same meaning as defined in clause 4.2.2(2)(a)(ii) of the IM determination "]
["Disclosure year ","Disclosure year has the same meaning as defined in the ID determination"]
["Disposed asset  ","Disposed asset  means an asset that, in relation to a disclosure year, is forecast to be sold or transferred."]
["DPP","DPP means default price-quality path"]
["EDB","EDB has the same meaning as defined in the IM determination"]
["Electricity distribution services ","Electricity distribution services has the same meaning as defined in the IM determination"]
["Existing assets ","Existing assets means assets of an EDB for which an aggregate closing RAB value for existing assets is calculated for the base year  "]
["Forecast aggregate value of disposed assets ","Forecast aggregate value of disposed assets means the value of assets forecast to be disposed of by an EDB in the disclosure year in question, and is equal to the portion of the forecast aggregate opening RAB value for existing assets relating to assets forecast to be disposed of for the disclosure year in question plus the total depreciation on disposed assets for the disclosure year in question."]
["Forecast revaluation for existing assets ","Forecast revaluation for existing assets means the value determined in accordance with clause 4.2.3(2)(a) of the IM determination  "]
["ID determination","ID determination means the Electricity Distribution Services Information Disclosure Determination 2012 [2012] NZCC 22, including amendments in effect at the date of the Notice"]
["IM determination","IM determination means the Electricity Distribution Services Input Methodologies Determination 2012 [2012] NZCC 26, including amendments in effect at the date of the Notice"]
["Non-exempt EDB ","Non-exempt EDB means an EDB that is not exempt from default/customised price-quality regulation under section 54G of the Act"]

{"sheet":"Description","index":3,"n_rows":75,"n_cols":3,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Description"]
[null,"General description"]
[null,1,"This model calculates the depreciation of existing assets (as \"existing assets\" are defined in the input methodologies) based on an"]
[null,null,"asset-by-asset calculation provided by EDBs in response to a s53ZD request."]
[null,2,"This model should not be used for any other purposes."]
[null,"High level calculation steps"]
[null,1,"The main calculation steps are set out in Rows 30 to 45."]
[null,2,"There are data integrity checks at Rows 31 and 32 which Electricity Invercargill and OtagoNet have failed.\nThe differences between the calculated closing RAB and the opening RAB of the following year are significant, therefore, for the purposes of the draft decision, the existing asset depreciation based on the DPP3 methodology i.e. the methodology prior to the 2023 IM review) has been applied for these EDBs."]
[null,3,"The rightmost 16 sheets are the 'template' sheets as provided by each of the non-exempt EDBs in response to the s53ZD request."]
[null,4,"The Main sheet contains the few other inputs. There is no separate Inputs sheet."]
[]
[null,"Notes"]
[]
[null,"Location of text describing this workbook"]
[null,1,"This work book is described in:"]
[null,null,"●  This Description sheet"]
[null,null,"●  at numerous cell notes in Column B on the Main sheet"]
[null,null,"●  in the red bold text at Rows 72 & 73 on the Main sheet"]
[]
[null,"Structure of this workbook"]
[]
[null,1,"The rightmost 16 sheets are the 'template' sheets as provided by each of the non-exempt EDBs in response to the s53ZD request."]
[null,2,"The sheets are each named with a three letter code which indicates which EDB provided the response."]
[null,3,"The AttachmentB sheet is a sheet that was included in our s53ZD information request."]
[null,4,"Almost all the calculations are done on the Main sheet. "]
[]
[null,"Structure of the Main sheet"]
[null,1,"The Main sheet starts with Rows 4 to 6 simply drawing in the EDBs' 2024 AMP forecast of 2024 capex, i.e. the value of 2023/24 additional assets. This AMP data was the most up-to-date information on the 2024 additional assets."]
[null,2,"Down to Row 13 is where the \"focus EDB\" is selected. Cell C9 on the Main sheet can be used to select  the name of the EDB that is to have the focus. "]
[null,3,"Down to Row 56 is where the bulk of the calculations are done to determine the depreciation of the assets covered by the s53ZD responses, i.e. the assets in the 2024 opening RAB."]
[null,4,"Beyond Row 56 down to Row64 are the calculation of depreciation of the additional assets. The modelling assumption for these calculations is that as these are all brand new in the base year, then none of them will reach their scheduled life during DPP4. The simple DPP3 depreciation methodology can therefore be used."]
[null,5,"Rows 66 to 71 contain the consolidation of depreciation data to provide the total depreciation of all assets."]
[]
[null,null,"While the broad structure of the Main sheet is covered above, the detail is covered by the numerous"]
[null,null,"cell notes in Column C."]
[]
[null,"Separation of existing assets in the 2024 opening RAB and 2024/25 additional assets"]
[null,1,"The IM defines \"existing assets\" as \"assets of an EDB for which an aggregate closing RAB value for existing assets is calculated for the base year\". 2023/24 is the DPP4 base year."]
[null,2,"This workbook calculates data for existing assets as two separate groups of assets:"]
[null,null,"●  assets that existed in opening RAB of 2023/24"]
[null,null,"●  assets that were additional assets in 2023/24"]
[null,3,"The s53ZD request effectively only requested data on the first of these groups."]
[]
[null,"Suggested approach to reading this workbook"]
[null,1,"Use a two screen display if possible, displaying this Description sheet on one and the 'focus' sheet on the other."]
[null,2,"Select the 'focus' sheet at Main!C9 to display the response to the s53ZD request."]
[null,3,"Note that the response for Alpine is displayed."]
[null,4,"Note that there is a + and - sign in the 'group' control at Row 28 to show or hide the EDB's comments on any information that cannot be supplied."]
[null,5,"Note the comments made by Alpine at Rows 17 to 25 on the 'focus' sheet."]
[null,6,"Hide the grouped rows."]
[null,7,"Note that Row 29 shows the remaining life for each year."]
[null,8,"Note that Row 30 shows the year-on-year change in the remaining life. The year-on-year change in the remaining life is the current key parameter used to consider the feasibility of an EDB's depreciation forecast. The chart that is visible on the 'focus' sheet shows the year-on-year change. "]
[null,9,"Note the 'Next EDB' macro button at cell C9 on the Main sheet. This button can be used to cycle through all the EDBs, with a view to considering whether each shows a feasible result."]
[null,10,"Set cell B11 on the 'admin' sheet to 1 to make Alpine the focus EDB. Then select the 'focus' sheet."]
[null,11,"The year-on-year changes highlighted in yellow in Row 30 are the most instructive. The minimum and maximum values in this range are shown in the box with a black border at J29."]
[null,12,"Cycling through the 16 EDBs will show the results for each EDB. The following are noteworthy:"]
[null,null,"Invercargill: at Row 34 there is nil change in remaining life for Invercargill throughout all DPP4."]
[null,null,"Firstlight: the change each year is close to 1, being in the range 1.00124 to 1.00274."]
[null,null,"OtagoNet: Very similar to Invercargill. All close to nil, being from -0.0000004 to 0.0000014"]
[null,null,"Unison: changes are in a tight range, fairly close to 1, being from 1.035 to 1.039."]
[null,13,"Cycling again through the 16 EDBs will show the results at Rows 31 and 32 "]
[null,null,"The following are noteworthy:"]
[null,null,"All EDBs except Invercargill and OtagoNet: Row 31 indicates that"]
[null,null,"closing RAB is, as expected, opening RAB - depreciation + revaluations - disposals."]
[null,null,"Invercargill and OtagoNet: Note that the template used by Invercargill"]
[null,null,"and OtagoNet is different from the template of other EDBs."]
[null,14,"The results examined so far indicate that 4 EDBs have infeasible results, being:"]
[null,null,"a)  Invercargill"]
[null,null,"b)  Firstlight"]
[null,null,"c)  OtagoNet"]
[null,null,"d)  Unison"]
[null,15,"Further examination of the charts may indicate reasonableness or otherwise of other EDBs' data."]
[]
[null,"Model suite"]
[null,1,"Follow the link \"Model map – EDB DPP draft determination – 29 May 2024\" on the Commission's EDB 2025-2030 default price-quality path determination web page for a graphical depiction of interconnections between the models and data sources."]

{"sheet":"Main","index":4,"n_rows":132,"n_cols":20,"rows_kept":132,"cut":false,"hidden":false,"merged":[[10,0,16,0]]}
[null,"Admin: managing the process for chosing the EDB on which to focus"]
[null,"All $ amounts are in '000 NZD."]
[null,"Inputs"]
[null,"2024 capital expenditure\n forecast (nominal)",null,"Alpine Energy","Aurora Energy","EA Networks","Electricity Invercargill","Firstlight Network","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity","Dummy"]
[null,2024,null,"alp","aur","ean","inv","fln","hor","nel","tas","ori","ojv","pco","tlc","top","uni","vct","wel","dum"]
[null,"2024 capital expenditure\n forecast",null,{"$f":"TRANSPOSE([1]Calculation!$P$304:$P$319)","v":22720},88605.448340000003,14318.551268662459,6017,14996.334243636367,9443.5723670000025,1892,15022,135507,20446.430445700003,255307.40000000002,19438.080000000002,20720,91746.675904595017,358149,53806.666917176321,77777]
[]
[null,"Selection of focus EDB"]
[null,"Select the focus EDB (dropdown at C9)","Vector Lines"]
[null,"Column number of focus EDB",{"$f":"MATCH(C9,D4:S4,0)","v":15}]
["Row number","Focus EDB three letter abbreviation",{"$f":"INDEX(D5:T5,1,C10)","v":"vct"}]
[null,"Factor (1 or 1000) by which s53ZD data is to be scaled",{"$f":"IF(OR(C11=\"alp\",C11=\"ean\",C11=\"hor\",C11=\"nel\",C11=\"tas\",C11=\"uni\"),1,1000)","v":1000}]
[null,"Rem life for 2024 capex assets 31-3-25",44,"years"]
[]
[null,null,null,"B","C","D","E","F","G","H"]
[null,"s53ZD data for the focus EDB, adjusted for consistency of $000s, +/-, allocation adjustment and row order"]
[null,"for the disclosure year ending 31 March",null,2024,2025,2026,2027,2028,2029,2030,2031]
[5,"Forecast aggregate opening RAB value for existing assets",null,{"$f":"INDIRECT($C$11 & \"!\" & D$15 & $A18)/$C$12","v":3891832.6144465031},{"$f":"INDIRECT($C$11 & \"!\" & E$15 & $A18)/$C$12","v":3874339.1517851334},{"$f":"INDIRECT($C$11 & \"!\" & F$15 & $A18)/$C$12","v":3810306.7151196287},{"$f":"INDIRECT($C$11 & \"!\" & G$15 & $A18)/$C$12","v":3726433.1426447015},{"$f":"INDIRECT($C$11 & \"!\" & H$15 & $A18)/$C$12","v":3645766.6630639904},{"$f":"INDIRECT($C$11 & \"!\" & I$15 & $A18)/$C$12","v":3565129.1082280176},{"$f":"INDIRECT($C$11 & \"!\" & J$15 & $A18)/$C$12","v":3483167.0891339425},{"$f":"J18-J19+J20-J21","v":3401145.91768303}]
[6,"Forecast sum of depreciation for existing assets",null,{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & D$15 & $A19)/$C$12","v":155628.63406407277},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & E$15 & $A19)/$C$12","v":153610.60024585112},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & F$15 & $A19)/$C$12","v":149027.07325890579},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & G$15 & $A19)/$C$12","v":144211.86393559948},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & H$15 & $A19)/$C$12","v":142585.88058806822},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & I$15 & $A19)/$C$12","v":142303.82429245117},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & J$15 & $A19)/$C$12","v":140711.73985335164}]
[{"$f":"IF(OR(C11=\"inv\",C11=\"ojv\"),9,7)","v":7},"Forecast revaluation for existing assets",null,{"$f":"INDIRECT($C$11 & \"!\" & D$15 & $A20)/$C$12","v":147258.89952762189},{"$f":"INDIRECT($C$11 & \"!\" & E$15 & $A20)/$C$12","v":100282.17868948651},{"$f":"INDIRECT($C$11 & \"!\" & F$15 & $A20)/$C$12","v":75857.47673670623},{"$f":"INDIRECT($C$11 & \"!\" & G$15 & $A20)/$C$12","v":74249.368797562289},{"$f":"INDIRECT($C$11 & \"!\" & H$15 & $A20)/$C$12","v":72652.313952217271},{"$f":"INDIRECT($C$11 & \"!\" & I$15 & $A20)/$C$12","v":71045.80132556404},{"$f":"INDIRECT($C$11 & \"!\" & J$15 & $A20)/$C$12","v":69394.551140776457}]
[8,"Forecast aggregate value of disposed assets",null,{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & D$15 & $A21)/$C$12","v":10703.982140107641},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & E$15 & $A21)/$C$12","v":10704.015109139802},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & F$15 & $A21)/$C$12","v":10703.975952727773},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & G$15 & $A21)/$C$12","v":10703.98444267348},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & H$15 & $A21)/$C$12","v":10703.988200121834},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & I$15 & $A21)/$C$12","v":10703.9961271877},{"$f":"IF($C$11=\"vct\",-1,1)*INDIRECT($C$11 & \"!\" & J$15 & $A21)/$C$12","v":10703.982738337141}]
[null,"Forecast aggregated value of allocation adjustments",null,{"$f":"IF(C11=\"vct\",vct!B9,0)/$C$12","v":1580.254015188593},0,0,0,0,0,0]
[{"$f":"IF(OR(C11=\"inv\",C11=\"ojv\"),\"n/a\",IF(C11=\"vct\",21,9))","v":21},"Forecast aggregate closing RAB value for existing assets",null,{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),E18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & D$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & D$15 & $A23)/$C$12))","v":3874339.1517851334},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),F18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & E$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & E$15 & $A23)/$C$12))","v":3810306.7151196287},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),G18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & F$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & F$15 & $A23)/$C$12))","v":3726433.1426447015},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),H18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & G$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & G$15 & $A23)/$C$12))","v":3645766.6630639904},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),I18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & H$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & H$15 & $A23)/$C$12))","v":3565129.1082280176},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),J18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & I$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & I$15 & $A23)/$C$12))","v":3483167.0891339425},{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),K18,IF($C$11=\"vct\",INDIRECT($C$11 & \"!\" & J$15 & 10)/$C$12,INDIRECT($C$11 & \"!\" & J$15 & $A23)/$C$12))","v":3401145.9176830305}]
[]
[null,"Revaluation data",null,2024,2025,2026,2027,2028,2029,2030]
[null,"Revaluation rate used for s53ZD",null,{"$f":"alp!B13","v":3.7999999999999999E-2},{"$f":"alp!C13","v":2.6000000000000023E-2},{"$f":"alp!D13","v":2.0000000000000018E-2},{"$f":"alp!E13","v":2.0000000000000018E-2},{"$f":"alp!F13","v":2.0000000000000018E-2},{"$f":"alp!G13","v":2.0000000000000018E-2},{"$f":"alp!H13","v":2.0000000000000018E-2}]
[null,"Revaluation rate updated from CPI model",null,{"$f":"[2]Output!I8","v":4.022988505747116E-2},{"$f":"[2]Output!J8","v":2.6000000000000023E-2},{"$f":"[2]Output!K8","v":2.0000000000000018E-2},{"$f":"[2]Output!L8","v":2.0000000000000018E-2},{"$f":"[2]Output!M8","v":2.0000000000000018E-2},{"$f":"[2]Output!N8","v":2.0000000000000018E-2},{"$f":"[2]Output!O8","v":2.0000000000000018E-2}]
[]
[null,"Calculations",null,2024,2025,2026,2027,2028,2029,2030]
[null,"Closing RAB by formula",null,{"$f":"D18-D19+D20-D21+D22","v":3874339.1517851334},{"$f":"E18-E19+E20-E21+E22","v":3810306.7151196287},3726433.1426447015,3645766.6630639904,3565129.1082280176,3483167.089133943,3401145.91768303]
[null,"Data integrity check: Closing RAB is NOT formula compliant?",{"$f":"C11","v":"vct"},{"$f":"D23<>D30","v":false},{"$f":"E23<>E30","v":false},false,false,false,false,false]
[null,"Data integrity check: opening RAB = previous year closing RAB?",null,null,{"$f":"E18=D23","v":true},{"$f":"F18=E23","v":true},true,true,true,true]
[null,"Data integrity check: implicit revaluation rate in s53ZD returns",null,{"$f":"D20/D18","v":3.7837932438562767E-2},{"$f":"E20/E18","v":2.5883686161878902E-2},1.9908496194203255E-2,1.9925050565878791E-2,1.9927856241671406E-2,1.9927974322611855E-2,1.992283153950871E-2]
[null,"Remaining life per s52ZD",null,{"$f":"D18/D19","v":25.007175818585054},25.221821577315108,25.567882612174472,25.839990143313106,25.56891782010759,25.052939553481401,24.753919557558341]
[null,"Remaining life per DPP3 methodology",null,{"$f":"D34","v":25.007175818585054},{"$f":"D35-1","v":24.007175818585054},{"$f":"E35-1","v":23.007175818585054},22.007175818585054,21.007175818585054,20.007175818585054,19.007175818585054]
[null,"Remaining life applied",null,{"$f":"IF(OR($C$11=\"inv\",$C$11=\"ojv\"),D35,D34)","v":25.007175818585054},25.221821577315108,25.567882612174472,25.839990143313106,25.56891782010759,25.052939553481401,24.753919557558341]
[]
[null,"For assets existing at 31-3-23, values, depreciation etc, adjusted for CPI and using DPP3 depreciation methodology for all EDBs",null,null,null,null,null,null,null,null,null,null,{"$f":"EDBname &\":  s53ZD and DPP3 remaining life\"","v":"Vector Lines:  s53ZD and DPP3 remaining life"}]
[null,"for the disclosure year ending 31 March",null,2024,2025,2026,2027,2028,2029,2030]
[null,"Forecast aggregate opening RAB value for existing assets (6 rows down).",null,{"$f":"D18","v":3891832.6144465031},{"$f":"D45","v":3883648.2309996118},{"$f":"E45","v":3812148.7617041464},3711993.8578413916,3606857.7733586077,3496594.4782117228,3381055.3525593649]
[null,"Forecast sum of depreciation for existing assets",null,{"$f":"D40/D35","v":155628.63406407277},{"$f":"E40/E35","v":161770.30819231566},165693.9031441102,168671.97719693836,171696.46241393476,174767.01908940432,177883.09977400207]
[null,"Forecast revaluation for existing assets",null,{"$f":"D27*D40","v":156567.9787421003},100974.85400599,76242.975234083002,74239.877156827904,72137.155467172212,69931.889564234516,67621.107051187355]
[null,"Forecast aggregate value of disposed assets",null,{"$f":"D21","v":10703.982140107641},10704.015109139802,10703.975952727773,10703.98444267348,10703.988200121834,10703.9961271877,10703.982738337141]
[null,"Forecast aggregated value of allocation adjustments",null,1580.254015188593,0,0,0,0,0,0]
[null,"Forecast aggregate closing RAB value for existing assets",null,{"$f":"D40-D41+D42-D43+D44","v":3883648.2309996118},{"$f":"E40-E41+E42-E43+E44","v":3812148.7617041464},3711993.8578413916,3606857.7733586077,3496594.4782117228,3381055.3525593649,3260089.3770982129]
[]
[null,"asset values, depreciation etc, adjusted for CPI and inv & ojv depreciation methodology"]
[]
[null,"For assets existing at 31-3-23, values, depreciation etc, adjusted for CPI and using s53ZD depreciation except for inv and ojv for which DPP3 depreciation methodology used"]
[null,"for the disclosure year ending 31 March",null,2024,2025,2026,2027,2028,2029,2030]
[null,"Forecast aggregate opening RAB value for existing assets",null,{"$f":"D18","v":3891832.6144465031},{"$f":"D56","v":3883648.2309996118},{"$f":"E56","v":3819939.3813519743},3736230.3710792526,3655659.9802707178,3575096.3835974503,3493192.6423119409]
[null,"Forecast sum of depreciation for existing assets",null,{"$f":"D51/D36","v":155628.63406407277},153979.68854448738,149403.82194703372,144591.01378744593,142972.80807856011,142701.67283027066,141116.74856943343]
[null,"Forecast revaluation for existing assets",null,{"$f":"D27*D51","v":156567.9787421003},100974.85400599,76398.78762703955,74724.607421585111,73113.199605414426,71501.927671949074,69863.852846238879]
[null,"Forecast aggregate value of disposed assets",null,{"$f":"D21","v":10703.982140107641},10704.015109139802,10703.975952727773,10703.98444267348,10703.988200121834,10703.9961271877,10703.982738337141]
[null,"Forecast aggregated value of allocation adjustments",null,{"$f":"D22","v":1580.254015188593},{"$f":"E22","v":0},0,0,0,0,0]
[null,"Forecast aggregate closing RAB value for existing assets",null,{"$f":"D51-D52+D53-D54+D55","v":3883648.2309996118},{"$f":"E51-E52+E53-E54+E55","v":3819939.3813519743},3736230.3710792526,3655659.9802707178,3575096.3835974503,3493192.6423119409,3411235.7638504091]
[]
[null,"Value of additional assets"]
[null,"2024 forecast capital expenditure",{"$f":"INDEX(D6:T6,1,C10)","v":358149},2024,2025,2026,2027,2028,2029,2030]
[null,"opening RAB value for 2024 additional assets",null,{"$f":"C59","v":358149},{"$f":"D64","v":364417.54310344823},{"$f":"E64","v":365417.57264033676},364025.50569694501,362427.3449402267,360615.20821552561,358580.96857943805]
[null,"rem life for 2024 additional assets",null,{"$f":"C13","v":44},{"$f":"D61-1","v":43},{"$f":"E61-1","v":42},41,40,39,38]
[null,"depreciation of 2024 additional assets",null,{"$f":"D60/D61","v":8139.75},{"$f":"E60/E61","v":8474.8265838011212},8700.4183961984945,8878.6708706571953,9060.6836235056671,9246.5438003980926,9436.3412784062639]
[null,"revaluation of 2024 additional assets",null,{"$f":"D60*D27","v":14408.293103448239},9474.8561206896629,7308.3514528067417,7280.5101139389062,7248.5468988045404,7212.3041643105189,7171.6193715887675]
[null,"closing RAB value for 2024 additional assets",null,{"$f":"D60-D62+D63","v":364417.54310344823},{"$f":"E60-E62+E63","v":365417.57264033676},{"$f":"F60-F62+F63","v":364025.50569694501},362427.3449402267,360615.20821552561,358580.96857943805,356316.24667262053]
[]
[null,"Consolidation of depreciation of both assets existing at 31-3-23 and 2024 additional assets"]
[null,"Sum of s53ZD depreciation for assets existing at 31-3-2023",null,{"$f":"D52","v":155628.63406407277},{"$f":"E52","v":153979.68854448738},149403.82194703372,144591.01378744593,142972.80807856011,142701.67283027066,141116.74856943343]
[null,"Sum of DPP3 depreciation for assets existing at 31-3-2023",null,{"$f":"D41","v":155628.63406407277},{"$f":"E41","v":161770.30819231566},165693.9031441102,{"$f":"G41","v":168671.97719693836},171696.46241393476,174767.01908940432,177883.09977400207]
[null,"s53ZD depreciation of 2024 additional assets",null,{"$f":"D62","v":8139.75},8474.8265838011212,8700.4183961984945,8878.6708706571953,9060.6836235056671,9246.5438003980926,9436.3412784062639]
[null,"Total s53ZD depreciation of exising assets, i.e. existing at 31-3-24",null,{"$f":"D67+D69","v":163768.38406407277},{"$f":"E67+E69","v":162454.51512828851},158104.2403432322,153469.68465810313,152033.49170206577,151948.21663066876,150553.0898478397]
[null,"Total DPP3 depreciation of exising assets, i.e. existing at 31-3-24",null,{"$f":"D68+D69","v":163768.38406407277},{"$f":"E68+E69","v":170245.13477611679},174394.32154030868,177550.64806759555,180757.14603744043,184013.56288980242,187319.44105240834]
[]
[null,null,null,null,"Everything above this line is for the focus EDB only, as selected at Main!C9."]
[null,null,null,null,"Everything below this line is for the whole set of 16 non-exempt EDBs."]
[]
[null,"Sum of s53ZD depreciation of assets existing at 31-3-24, with CPI adjustment and adjustment for additional assets added in year ending 2024"]
[null,null,null,{"$f":"D70","v":163768.38406407277},{"$f":"E70","v":162454.51512828851},158104.2403432322,153469.68465810313,152033.49170206577,151948.21663066876,150553.0898478397]
[null,"Alpine Energy",1,13027.853545135305,13479.859078698872,13462.061772778179,13354.634901004923,13426.951619695008,13209.003834363684,12618.687189776738]
[null,"Aurora Energy",2,31109.005953418829,30953.753568618242,30581.756041048393,30121.792175225619,29789.581209452677,29699.956712099272,29842.427278159543]
[null,"EA Networks",3,12986.626456326971,13294.910352511521,13527.545905738114,13586.642148848247,13702.515338635461,13805.967301538047,13960.957660020842]
[null,"Electricity Invercargill",4,4161.0166241409788,4334.7723138869942,4451.9030576567529,4544.5670712913743,4639.3236231935562,4736.2384242805829,4835.3820134948728]
[null,"Firstlight Network",5,8596.7100803956309,8956.3800686989052,9198.774812551248,9390.4342040705742,9586.6199283015048,9787.5602870328948,9993.5532020655228]
[null,"Horizon Energy",6,7716.0536447045451,7855.3485239151132,7779.856388479323,7626.1287731212942,7504.4902482449379,7281.3133738179813,7196.8381042092851]
[null,"Nelson Electricity",7,1779.9681596858034,1773.4558333648442,1757.2087761229825,1689.86429562583,1659.419126870604,1656.4028895475926,1651.7613674200134]
[null,"Network Tasman",8,8610.5090909090904,8368.2193342004957,7952.1418389780847,7100.904206137775,6977.0298682851108,6983.3619475715068,7067.6859510488421]
[null,"Orion NZ",9,58629.704545454544,58324.493712305186,58914.292587821794,57741.444837282463,57207.564350138709,56606.127347645241,56425.174932053509]
[null,"OtagoNet",10,11237.639601038636,11708.545282750283,12026.167506729353,12277.581604549974,12534.791015107283,12797.995703662496,13067.413444735776]
[null,"Powerco",11,122340.36222453513,113234.87556356732,106059.46830123047,102002.25733202472,98175.528751886712,95806.674223211754,94059.588768050395]
[null,"The Lines Company",12,10721.988818269625,11160.956485761504,11453.208605235179,11681.772310157023,11915.086657485581,12153.268099013714,12396.438764021661]
[null,"Top Energy",13,13800.245957671807,13266.010824094265,13337.771960979187,13083.763530304579,13062.154345121011,13184.719584135832,13279.538979928919]
[null,"Unison Networks",14,39298.663055104196,40614.82541990246,41729.134354704984,42610.668394645283,43511.820720998861,44433.209069861085,45375.505881790326]
[null,"Vector Lines",15,163768.38406407277,162454.51512828851,158104.2403432322,153469.68465810313,152033.49170206577,151948.21663066876,150553.0898478397]
[null,"Wellington Electricity",16,33585.679138967382,33132.255427657132,33277.424390637214,31425.729682664256,31142.741432889001,31007.107447227339,30866.765694366663]
[]
[null,"sum of DPP3 depreciation of assets existing at 31-3-24, with CPI adjustment and adjustment for additional assets added in year ending 2024"]
[null,null,null,{"$f":"D71","v":163768.38406407277},{"$f":"E71","v":170245.13477611679},174394.32154030868,177550.64806759555,180757.14603744043,184013.56288980242,187319.44105240834]
[null,"Alpine Energy",1,13027.853545135305,13574.518769954559,13942.898604971801,14234.149616495737,14532.046782121153,14837.252267601603,15150.074506544166]
[null,"Aurora Energy",2,31109.005953418829,32297.687716527078,33049.783894455977,33612.675825394603,34179.466220652954,34746.799620896578,35313.695419620788]
[null,"EA Networks",3,12986.626456326971,13499.706681154712,13834.279642251306,14093.591603596304,14360.007676530564,14629.550265424747,14902.450783325752]
[null,"Electricity Invercargill",4,4161.0166241409788,4334.7723138869942,4451.9030576567529,4544.5670712913743,4639.3236231935562,4736.2384242805829,4835.3820134948728]
[null,"Firstlight Network",5,8596.7100803956309,8955.5999762349547,9197.3783435881633,9388.5070207352146,9583.9660729120405,9783.8957615751024,9988.447568560392]
[null,"Horizon Energy",6,7716.0536447045451,8017.8254341452621,8212.3309678934511,8360.154675487167,8511.0017870001138,8664.9244171247919,8821.987432294105]
[null,"Nelson Electricity",7,1779.9681596858034,1857.7438553909574,1907.8601923567292,1947.5073952718876,1988.0405450702635,2029.4860344789549,2071.8719670564547]
[null,"Network Tasman",8,8610.5090909090904,8936.3899635501202,9177.1505106228415,9351.3653519084455,9533.7861780395669,9721.1749958549899,9913.6326317583225]
[null,"Orion NZ",9,58629.704545454544,61050.51631507367,62667.899004929015,63948.595118042758,65252.807353349817,66575.518640085356,67926.605114614271]
[null,"OtagoNet",10,11237.639601038636,11708.545282750283,12026.167506729353,12277.581604549974,12534.791015107283,12797.995703662496,13067.413444735776]
[null,"Powerco",11,122340.36222453513,126481.44603376335,128824.23232987717,130369.54565138668,131890.70125693074,133380.78202290239,134831.53304199723]
[null,"The Lines Company",12,10721.988818269625,11160.956485761506,11453.208605235181,11681.772310157023,11915.086657485581,12153.268099013718,12396.438764021661]
[null,"Top Energy",13,13800.245957671807,14377.767393337546,14767.25328492376,15075.511297789215,15390.814462121327,15713.396044442079,16043.508414365731]
[null,"Unison Networks",14,39298.663055104196,40833.036322790627,41875.952005341496,42680.510140310529,43498.55079280588,44329.978899164045,45174.657482796611]
[null,"Vector Lines",15,163768.38406407277,170245.13477611679,174394.32154030868,177550.64806759555,180757.14603744043,184013.56288980242,187319.44105240834]
[null,"Wellington Electricity",16,33585.679138967382,34992.616026555675,35941.620824704274,36692.828176160336,37461.308656717418,38247.65029411362,39052.492004391745]
[]
[null,"Depreciation decrease in s53ZD depreciation of assets existing at 31-3-24 relative to DPP3 methodology"]
[null,null,null,2024,2025,2026,2027,2028,2029,2030]
[null,null,null,{"$f":"1-INDEX(D78:D93,$C117)/INDEX(D97:D112,$C117)","v":0},{"$f":"1-INDEX(E78:E93,$C117)/INDEX(E97:E112,$C117)","v":0.1047313332159403},{"$f":"1-INDEX(F78:F93,$C117)/INDEX(F97:F112,$C117)","v":0.17671181591327867},{"$f":"1-INDEX(G78:G93,$C117)/INDEX(G97:G112,$C117)","v":0.21759137210784807},{"$f":"1-INDEX(H78:H93,$C117)/INDEX(H97:H112,$C117)","v":0.25562964017732315},{"$f":"1-INDEX(I78:I93,$C117)/INDEX(I97:I112,$C117)","v":0.2817055593004314},{"$f":"1-INDEX(J78:J93,$C117)/INDEX(J97:J112,$C117)","v":0.3023917577296048}]
[null,{"$f":"INDEX($B$97:$B$112,C117)","v":"Powerco"},11,{"$f":"1-INDEX(D$78:D$93,$C117)/INDEX(D$97:D$112,$C117)","v":0},{"$f":"1-INDEX(E$78:E$93,$C117)/INDEX(E$97:E$112,$C117)","v":0.1047313332159403},{"$f":"1-INDEX(F$78:F$93,$C117)/INDEX(F$97:F$112,$C117)","v":0.17671181591327867},{"$f":"1-INDEX(G$78:G$93,$C117)/INDEX(G$97:G$112,$C117)","v":0.21759137210784807},{"$f":"1-INDEX(H$78:H$93,$C117)/INDEX(H$97:H$112,$C117)","v":0.25562964017732315},{"$f":"1-INDEX(I$78:I$93,$C117)/INDEX(I$97:I$112,$C117)","v":0.2817055593004314},{"$f":"1-INDEX(J$78:J$93,$C117)/INDEX(J$97:J$112,$C117)","v":0.3023917577296048}]
[null,{"$f":"INDEX($B$97:$B$112,C118)","v":"Network Tasman"},8,{"$f":"1-INDEX(D$78:D$93,$C118)/INDEX(D$97:D$112,$C118)","v":0},{"$f":"1-INDEX(E$78:E$93,$C118)/INDEX(E$97:E$112,$C118)","v":6.3579435506629367E-2},{"$f":"1-INDEX(F$78:F$93,$C118)/INDEX(F$97:F$112,$C118)","v":0.13348464430508911},{"$f":"1-INDEX(G$78:G$93,$C118)/INDEX(G$97:G$112,$C118)","v":0.2406558893896058},{"$f":"1-INDEX(H$78:H$93,$C118)/INDEX(H$97:H$112,$C118)","v":0.26817848250506937},{"$f":"1-INDEX(I$78:I$93,$C118)/INDEX(I$97:I$112,$C118)","v":0.28163396394477613},{"$f":"1-INDEX(J$78:J$93,$C118)/INDEX(J$97:J$112,$C118)","v":0.2870740510993407}]
[null,{"$f":"INDEX($B$97:$B$112,C119)","v":"Wellington Electricity"},16,{"$f":"1-INDEX(D$78:D$93,$C119)/INDEX(D$97:D$112,$C119)","v":0},{"$f":"1-INDEX(E$78:E$93,$C119)/INDEX(E$97:E$112,$C119)","v":5.3164376092565524E-2},{"$f":"1-INDEX(F$78:F$93,$C119)/INDEX(F$97:F$112,$C119)","v":7.412566191883696E-2},{"$f":"1-INDEX(G$78:G$93,$C119)/INDEX(G$97:G$112,$C119)","v":0.14354572147475297},{"$f":"1-INDEX(H$78:H$93,$C119)/INDEX(H$97:H$112,$C119)","v":0.16866915359870627},{"$f":"1-INDEX(I$78:I$93,$C119)/INDEX(I$97:I$112,$C119)","v":0.18930686698943733},{"$f":"1-INDEX(J$78:J$93,$C119)/INDEX(J$97:J$112,$C119)","v":0.20960829616467336}]
[null,{"$f":"INDEX($B$97:$B$112,C120)","v":"Nelson Electricity"},7,{"$f":"1-INDEX(D$78:D$93,$C120)/INDEX(D$97:D$112,$C120)","v":0},{"$f":"1-INDEX(E$78:E$93,$C120)/INDEX(E$97:E$112,$C120)","v":4.5371175246533113E-2},{"$f":"1-INDEX(F$78:F$93,$C120)/INDEX(F$97:F$112,$C120)","v":7.8963551332160709E-2},{"$f":"1-INDEX(G$78:G$93,$C120)/INDEX(G$97:G$112,$C120)","v":0.1322937721682379},{"$f":"1-INDEX(H$78:H$93,$C120)/INDEX(H$97:H$112,$C120)","v":0.16529915298485276},{"$f":"1-INDEX(I$78:I$93,$C120)/INDEX(I$97:I$112,$C120)","v":0.1838313437949558},{"$f":"1-INDEX(J$78:J$93,$C120)/INDEX(J$97:J$112,$C120)","v":0.20276861037571736}]
[null,{"$f":"INDEX($B$97:$B$112,C121)","v":"Vector Lines"},15,{"$f":"1-INDEX(D$78:D$93,$C121)/INDEX(D$97:D$112,$C121)","v":0},{"$f":"1-INDEX(E$78:E$93,$C121)/INDEX(E$97:E$112,$C121)","v":4.5761188171829059E-2},{"$f":"1-INDEX(F$78:F$93,$C121)/INDEX(F$97:F$112,$C121)","v":9.3409470292364238E-2},{"$f":"1-INDEX(G$78:G$93,$C121)/INDEX(G$97:G$112,$C121)","v":0.13562869903085073},{"$f":"1-INDEX(H$78:H$93,$C121)/INDEX(H$97:H$112,$C121)","v":0.1589074344503375},{"$f":"1-INDEX(I$78:I$93,$C121)/INDEX(I$97:I$112,$C121)","v":0.17425534159314215},{"$f":"1-INDEX(J$78:J$93,$C121)/INDEX(J$97:J$112,$C121)","v":0.19627621670236639}]
[null,{"$f":"INDEX($B$97:$B$112,C122)","v":"Horizon Energy"},6,{"$f":"1-INDEX(D$78:D$93,$C122)/INDEX(D$97:D$112,$C122)","v":0},{"$f":"1-INDEX(E$78:E$93,$C122)/INDEX(E$97:E$112,$C122)","v":2.0264460927050587E-2},{"$f":"1-INDEX(F$78:F$93,$C122)/INDEX(F$97:F$112,$C122)","v":5.2661611070585312E-2},{"$f":"1-INDEX(G$78:G$93,$C122)/INDEX(G$97:G$112,$C122)","v":8.7800516959107511E-2},{"$f":"1-INDEX(H$78:H$93,$C122)/INDEX(H$97:H$112,$C122)","v":0.1182600549200381},{"$f":"1-INDEX(I$78:I$93,$C122)/INDEX(I$97:I$112,$C122)","v":0.15967952825674181},{"$f":"1-INDEX(J$78:J$93,$C122)/INDEX(J$97:J$112,$C122)","v":0.18421578363801971}]
[null,{"$f":"INDEX($B$97:$B$112,C123)","v":"Top Energy"},13,{"$f":"1-INDEX(D$78:D$93,$C123)/INDEX(D$97:D$112,$C123)","v":0},{"$f":"1-INDEX(E$78:E$93,$C123)/INDEX(E$97:E$112,$C123)","v":7.7324701313394084E-2},{"$f":"1-INDEX(F$78:F$93,$C123)/INDEX(F$97:F$112,$C123)","v":9.6800758838745171E-2},{"$f":"1-INDEX(G$78:G$93,$C123)/INDEX(G$97:G$112,$C123)","v":0.13211809060013247},{"$f":"1-INDEX(H$78:H$93,$C123)/INDEX(H$97:H$112,$C123)","v":0.15130194199478086},{"$f":"1-INDEX(I$78:I$93,$C123)/INDEX(I$97:I$112,$C123)","v":0.16092488556607443},{"$f":"1-INDEX(J$78:J$93,$C123)/INDEX(J$97:J$112,$C123)","v":0.17227961385066437}]
[null,{"$f":"INDEX($B$97:$B$112,C124)","v":"Orion NZ"},9,{"$f":"1-INDEX(D$78:D$93,$C124)/INDEX(D$97:D$112,$C124)","v":0},{"$f":"1-INDEX(E$78:E$93,$C124)/INDEX(E$97:E$112,$C124)","v":4.4651917253243911E-2},{"$f":"1-INDEX(F$78:F$93,$C124)/INDEX(F$97:F$112,$C124)","v":5.9896796872223046E-2},{"$f":"1-INDEX(G$78:G$93,$C124)/INDEX(G$97:G$112,$C124)","v":9.7064685616666257E-2},{"$f":"1-INDEX(H$78:H$93,$C124)/INDEX(H$97:H$112,$C124)","v":0.12329343869675058},{"$f":"1-INDEX(I$78:I$93,$C124)/INDEX(I$97:I$112,$C124)","v":0.14974560463187303},{"$f":"1-INDEX(J$78:J$93,$C124)/INDEX(J$97:J$112,$C124)","v":0.16932143396764943}]
[null,{"$f":"INDEX($B$97:$B$112,C125)","v":"Alpine Energy"},1,{"$f":"1-INDEX(D$78:D$93,$C125)/INDEX(D$97:D$112,$C125)","v":0},{"$f":"1-INDEX(E$78:E$93,$C125)/INDEX(E$97:E$112,$C125)","v":6.9733367981489325E-3},{"$f":"1-INDEX(F$78:F$93,$C125)/INDEX(F$97:F$112,$C125)","v":3.4486145658562228E-2},{"$f":"1-INDEX(G$78:G$93,$C125)/INDEX(G$97:G$112,$C125)","v":6.1789059352836739E-2},{"$f":"1-INDEX(H$78:H$93,$C125)/INDEX(H$97:H$112,$C125)","v":7.6045389819811793E-2},{"$f":"1-INDEX(I$78:I$93,$C125)/INDEX(I$97:I$112,$C125)","v":0.10974056407959965},{"$f":"1-INDEX(J$78:J$93,$C125)/INDEX(J$97:J$112,$C125)","v":0.16708745001049208}]
[null,{"$f":"INDEX($B$97:$B$112,C126)","v":"Aurora Energy"},2,{"$f":"1-INDEX(D$78:D$93,$C126)/INDEX(D$97:D$112,$C126)","v":0},{"$f":"1-INDEX(E$78:E$93,$C126)/INDEX(E$97:E$112,$C126)","v":4.1610847182138366E-2},{"$f":"1-INDEX(F$78:F$93,$C126)/INDEX(F$97:F$112,$C126)","v":7.4676066303162369E-2},{"$f":"1-INDEX(G$78:G$93,$C126)/INDEX(G$97:G$112,$C126)","v":0.10385616629579952},{"$f":"1-INDEX(H$78:H$93,$C126)/INDEX(H$97:H$112,$C126)","v":0.12843632439606933},{"$f":"1-INDEX(I$78:I$93,$C126)/INDEX(I$97:I$112,$C126)","v":0.14524626624209025},{"$f":"1-INDEX(J$78:J$93,$C126)/INDEX(J$97:J$112,$C126)","v":0.15493332194345577}]
[null,{"$f":"INDEX($B$97:$B$112,C127)","v":"EA Networks"},3,{"$f":"1-INDEX(D$78:D$93,$C127)/INDEX(D$97:D$112,$C127)","v":0},{"$f":"1-INDEX(E$78:E$93,$C127)/INDEX(E$97:E$112,$C127)","v":1.5170428030786942E-2},{"$f":"1-INDEX(F$78:F$93,$C127)/INDEX(F$97:F$112,$C127)","v":2.2172006381625753E-2},{"$f":"1-INDEX(G$78:G$93,$C127)/INDEX(G$97:G$112,$C127)","v":3.5970210362750832E-2},{"$f":"1-INDEX(H$78:H$93,$C127)/INDEX(H$97:H$112,$C127)","v":4.578635002888487E-2},{"$f":"1-INDEX(I$78:I$93,$C127)/INDEX(I$97:I$112,$C127)","v":5.6295849766013872E-2},{"$f":"1-INDEX(J$78:J$93,$C127)/INDEX(J$97:J$112,$C127)","v":6.3177066443214858E-2}]
[null,{"$f":"INDEX($B$97:$B$112,C128)","v":"Electricity Invercargill"},4,{"$f":"1-INDEX(D$78:D$93,$C128)/INDEX(D$97:D$112,$C128)","v":0},{"$f":"1-INDEX(E$78:E$93,$C128)/INDEX(E$97:E$112,$C128)","v":0},{"$f":"1-INDEX(F$78:F$93,$C128)/INDEX(F$97:F$112,$C128)","v":0},{"$f":"1-INDEX(G$78:G$93,$C128)/INDEX(G$97:G$112,$C128)","v":0},{"$f":"1-INDEX(H$78:H$93,$C128)/INDEX(H$97:H$112,$C128)","v":0},{"$f":"1-INDEX(I$78:I$93,$C128)/INDEX(I$97:I$112,$C128)","v":0},{"$f":"1-INDEX(J$78:J$93,$C128)/INDEX(J$97:J$112,$C128)","v":0}]
[null,{"$f":"INDEX($B$97:$B$112,C129)","v":"OtagoNet"},10,{"$f":"1-INDEX(D$78:D$93,$C129)/INDEX(D$97:D$112,$C129)","v":0},{"$f":"1-INDEX(E$78:E$93,$C129)/INDEX(E$97:E$112,$C129)","v":0},{"$f":"1-INDEX(F$78:F$93,$C129)/INDEX(F$97:F$112,$C129)","v":0},{"$f":"1-INDEX(G$78:G$93,$C129)/INDEX(G$97:G$112,$C129)","v":0},{"$f":"1-INDEX(H$78:H$93,$C129)/INDEX(H$97:H$112,$C129)","v":0},{"$f":"1-INDEX(I$78:I$93,$C129)/INDEX(I$97:I$112,$C129)","v":0},{"$f":"1-INDEX(J$78:J$93,$C129)/INDEX(J$97:J$112,$C129)","v":0}]
[null,{"$f":"INDEX($B$97:$B$112,C130)","v":"The Lines Company"},12,{"$f":"1-INDEX(D$78:D$93,$C130)/INDEX(D$97:D$112,$C130)","v":0},{"$f":"1-INDEX(E$78:E$93,$C130)/INDEX(E$97:E$112,$C130)","v":0},{"$f":"1-INDEX(F$78:F$93,$C130)/INDEX(F$97:F$112,$C130)","v":0},{"$f":"1-INDEX(G$78:G$93,$C130)/INDEX(G$97:G$112,$C130)","v":0},{"$f":"1-INDEX(H$78:H$93,$C130)/INDEX(H$97:H$112,$C130)","v":0},{"$f":"1-INDEX(I$78:I$93,$C130)/INDEX(I$97:I$112,$C130)","v":0},{"$f":"1-INDEX(J$78:J$93,$C130)/INDEX(J$97:J$112,$C130)","v":0}]
[null,{"$f":"INDEX($B$97:$B$112,C131)","v":"Firstlight Network"},5,{"$f":"1-INDEX(D$78:D$93,$C131)/INDEX(D$97:D$112,$C131)","v":0},{"$f":"1-INDEX(E$78:E$93,$C131)/INDEX(E$97:E$112,$C131)","v":-8.7106666892378115E-5},{"$f":"1-INDEX(F$78:F$93,$C131)/INDEX(F$97:F$112,$C131)","v":-1.5183337152357979E-4},{"$f":"1-INDEX(G$78:G$93,$C131)/INDEX(G$97:G$112,$C131)","v":-2.052704792256943E-4},{"$f":"1-INDEX(H$78:H$93,$C131)/INDEX(H$97:H$112,$C131)","v":-2.7690575793726246E-4},{"$f":"1-INDEX(I$78:I$93,$C131)/INDEX(I$97:I$112,$C131)","v":-3.7454665780312091E-4},{"$f":"1-INDEX(J$78:J$93,$C131)/INDEX(J$97:J$112,$C131)","v":-5.1115385750244435E-4}]
[null,{"$f":"INDEX($B$97:$B$112,C132)","v":"Unison Networks"},14,{"$f":"1-INDEX(D$78:D$93,$C132)/INDEX(D$97:D$112,$C132)","v":0},{"$f":"1-INDEX(E$78:E$93,$C132)/INDEX(E$97:E$112,$C132)","v":5.3439793495438925E-3},{"$f":"1-INDEX(F$78:F$93,$C132)/INDEX(F$97:F$112,$C132)","v":3.506013442220568E-3},{"$f":"1-INDEX(G$78:G$93,$C132)/INDEX(G$97:G$112,$C132)","v":1.636384978427996E-3},{"$f":"1-INDEX(H$78:H$93,$C132)/INDEX(H$97:H$112,$C132)","v":-3.0506598383439609E-4},{"$f":"1-INDEX(I$78:I$93,$C132)/INDEX(I$97:I$112,$C132)","v":-2.3286762877070544E-3},{"$f":"1-INDEX(J$78:J$93,$C132)/INDEX(J$97:J$112,$C132)","v":-4.4460414352938127E-3}]

{"sheet":"Outputs","index":5,"n_rows":95,"n_cols":17,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Outputs"]
["The data panel immediately below (starting at Row 9) links to the financial model to provide the sum of depreciation of existing assets."]
["Select between s52ZD and DPP3 depreciation using the dropdown at cell G6. The normal setting should always be \"sum of DPP3"]
["depreciation of assets existing at 31-3-24\"."]
[]
["The panel immediately below is the sum of depreciation of existing assets, based on:",null,null,null,null,null,"sum of s53ZD depreciation of assets existing at 31-3-24"]
["s53ZD depreciation has been selected?",null,null,{"$f":"G6=\"sum of s53ZD depreciation of assets existing at 31-3-24\"","v":true}]
[null,null,null,{"$f":"NOT(D7)","v":false},{"$f":"IF(D7,\".\",\"CAUTION!  DPP3 depreciation has been selected.\")","v":"."}]
[null,"Alpine Energy","Aurora Energy","EA Networks","Electricity Invercargill","Firstlight Network","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity"]
[2024,{"$f":"TRANSPOSE(C21:I36)","v":13027.853545135305},31109.005953418829,12986.626456326971,4161.0166241409788,8596.7100803956309,7716.0536447045451,1779.9681596858034,8610.5090909090904,58629.704545454544,11237.639601038636,122340.36222453513,10721.988818269625,13800.245957671807,39298.663055104196,163768.38406407277,33585.679138967382]
[2025,13479.859078698872,30953.753568618242,13294.910352511521,4334.7723138869942,8956.3800686989052,7855.3485239151132,1773.4558333648442,8368.2193342004957,58324.493712305186,11708.545282750283,113234.87556356732,11160.956485761504,13266.010824094265,40614.82541990246,162454.51512828851,33132.255427657132]
[2026,13462.061772778179,30581.756041048393,13527.545905738114,4451.9030576567529,9198.774812551248,7779.856388479323,1757.2087761229825,7952.1418389780847,58914.292587821794,12026.167506729353,106059.46830123047,11453.208605235179,13337.771960979187,41729.134354704984,158104.2403432322,33277.424390637214]
[2027,13354.634901004923,30121.792175225619,13586.642148848247,4544.5670712913743,9390.4342040705742,7626.1287731212942,1689.86429562583,7100.904206137775,57741.444837282463,12277.581604549974,102002.25733202472,11681.772310157023,13083.763530304579,42610.668394645283,153469.68465810313,31425.729682664256]
[2028,13426.951619695008,29789.581209452677,13702.515338635461,4639.3236231935562,9586.6199283015048,7504.4902482449379,1659.419126870604,6977.0298682851108,57207.564350138709,12534.791015107283,98175.528751886712,11915.086657485581,13062.154345121011,43511.820720998861,152033.49170206577,31142.741432889001]
[2029,13209.003834363684,29699.956712099272,13805.967301538047,4736.2384242805829,9787.5602870328948,7281.3133738179813,1656.4028895475926,6983.3619475715068,56606.127347645241,12797.995703662496,95806.674223211754,12153.268099013714,13184.719584135832,44433.209069861085,151948.21663066876,31007.107447227339]
[2030,12618.687189776738,29842.427278159543,13960.957660020842,4835.3820134948728,9993.5532020655228,7196.8381042092851,1651.7613674200134,7067.6859510488421,56425.174932053509,13067.413444735776,94059.588768050395,12396.438764021661,13279.538979928919,45375.505881790326,150553.0898478397,30866.765694366663]
[]
[]
["Data for linking to the financial model:",null,null,null,{"$f":"IF(D8,\"This is not IM compliant for DPP4.\",\".\")","v":"."}]
[null,null,2024,2025,2026,2027,2028,2029,2030]
["Alpine Energy",null,{"$f":"IF($D$7,C40,C59)","v":13027.853545135305},13479.859078698872,13462.061772778179,13354.634901004923,13426.951619695008,13209.003834363684,12618.687189776738]
["Aurora Energy",null,{"$f":"IF($D$7,C41,C60)","v":31109.005953418829},30953.753568618242,30581.756041048393,30121.792175225619,29789.581209452677,29699.956712099272,29842.427278159543]
["EA Networks",null,{"$f":"IF($D$7,C42,C61)","v":12986.626456326971},13294.910352511521,13527.545905738114,13586.642148848247,13702.515338635461,13805.967301538047,13960.957660020842]
["Electricity Invercargill",null,{"$f":"IF($D$7,C43,C62)","v":4161.0166241409788},4334.7723138869942,4451.9030576567529,4544.5670712913743,4639.3236231935562,4736.2384242805829,4835.3820134948728]
["Firstlight Network",null,{"$f":"IF($D$7,C44,C63)","v":8596.7100803956309},8956.3800686989052,9198.774812551248,9390.4342040705742,9586.6199283015048,9787.5602870328948,9993.5532020655228]
["Horizon Energy",null,{"$f":"IF($D$7,C45,C64)","v":7716.0536447045451},7855.3485239151132,7779.856388479323,7626.1287731212942,7504.4902482449379,7281.3133738179813,7196.8381042092851]
["Nelson Electricity",null,{"$f":"IF($D$7,C46,C65)","v":1779.9681596858034},1773.4558333648442,1757.2087761229825,1689.86429562583,1659.419126870604,1656.4028895475926,1651.7613674200134]
["Network Tasman",null,{"$f":"IF($D$7,C47,C66)","v":8610.5090909090904},8368.2193342004957,7952.1418389780847,7100.904206137775,6977.0298682851108,6983.3619475715068,7067.6859510488421]
["Orion NZ",null,{"$f":"IF($D$7,C48,C67)","v":58629.704545454544},58324.493712305186,58914.292587821794,57741.444837282463,57207.564350138709,56606.127347645241,56425.174932053509]
["OtagoNet",null,{"$f":"IF($D$7,C49,C68)","v":11237.639601038636},11708.545282750283,12026.167506729353,12277.581604549974,12534.791015107283,12797.995703662496,13067.413444735776]
["Powerco",null,{"$f":"IF($D$7,C50,C69)","v":122340.36222453513},{"$f":"IF($D$7,D50,D69)","v":113234.87556356732},106059.46830123047,102002.25733202472,98175.528751886712,95806.674223211754,94059.588768050395]
["The Lines Company",null,{"$f":"IF($D$7,C51,C70)","v":10721.988818269625},11160.956485761504,11453.208605235179,11681.772310157023,11915.086657485581,12153.268099013714,12396.438764021661]
["Top Energy",null,{"$f":"IF($D$7,C52,C71)","v":13800.245957671807},13266.010824094265,13337.771960979187,13083.763530304579,13062.154345121011,13184.719584135832,13279.538979928919]
["Unison Networks",null,{"$f":"IF($D$7,C53,C72)","v":39298.663055104196},40614.82541990246,41729.134354704984,42610.668394645283,43511.820720998861,44433.209069861085,45375.505881790326]
["Vector Lines",null,{"$f":"IF($D$7,C54,C73)","v":163768.38406407277},162454.51512828851,158104.2403432322,153469.68465810313,152033.49170206577,151948.21663066876,150553.0898478397]
["Wellington Electricity",null,{"$f":"IF($D$7,C55,C74)","v":33585.679138967382},33132.255427657132,33277.424390637214,31425.729682664256,31142.741432889001,31007.107447227339,30866.765694366663]
[]
["Sum of s53ZD depreciation of assets existing at 31-3-24, with CPI adjustment and adjustment for additional assets added in year ending 2024"]
[null,null,2024,2025,2026,2027,2028,2029,2030,null,null,2025,2026,2027,2028,2029,2030]
[{"$f":"Main!B78","v":"Alpine Energy"},null,{"$f":"Main!D78","v":13027.853545135305},{"$f":"Main!E78","v":13479.859078698872},{"$f":"Main!F78","v":13462.061772778179},{"$f":"Main!G78","v":13354.634901004923},{"$f":"Main!H78","v":13426.951619695008},{"$f":"Main!I78","v":13209.003834363684},{"$f":"Main!J78","v":12618.687189776738},"Alpine Energy",null,13797.43903097102,14039.225010726215,14316.089894526971,14614.846843339421,14921.074523389609,15235.244681010572]
[{"$f":"Main!B79","v":"Aurora Energy"},null,{"$f":"Main!D79","v":31109.005953418829},{"$f":"Main!E79","v":30953.753568618242},{"$f":"Main!F79","v":30581.756041048393},{"$f":"Main!G79","v":30121.792175225619},{"$f":"Main!H79","v":29789.581209452677},{"$f":"Main!I79","v":29699.956712099272},{"$f":"Main!J79","v":29842.427278159543},"Aurora Energy",null,17758.042208909123,18059.852607616915,18404.391707934454,18774.772855210464,19152.737804765304,19538.457669714993]
[{"$f":"Main!B80","v":"EA Networks"},null,{"$f":"Main!D80","v":12986.626456326971},{"$f":"Main!E80","v":13294.910352511521},{"$f":"Main!F80","v":13527.545905738114},{"$f":"Main!G80","v":13586.642148848247},{"$f":"Main!H80","v":13702.515338635461},{"$f":"Main!I80","v":13805.967301538047},{"$f":"Main!J80","v":13960.957660020842},"EA Networks",null,10239.789674882417,10376.965331248561,10535.685476067767,10705.863257685009,10876.746792257029,11048.075230059832]
[{"$f":"Main!B81","v":"Electricity Invercargill"},null,{"$f":"Main!D81","v":4161.0166241409788},{"$f":"Main!E81","v":4334.7723138869942},{"$f":"Main!F81","v":4451.9030576567529},{"$f":"Main!G81","v":4544.5670712913743},{"$f":"Main!H81","v":4639.3236231935562},{"$f":"Main!I81","v":4736.2384242805829},{"$f":"Main!J81","v":4835.3820134948728},"Electricity Invercargill",null,3337.632799009903,3391.5923738515557,3453.3429452405212,3519.6860559695369,3587.1757567922932,3655.8164847396324]
[{"$f":"Main!B82","v":"Firstlight Network"},null,{"$f":"Main!D82","v":8596.7100803956309},{"$f":"Main!E82","v":8956.3800686989052},{"$f":"Main!F82","v":9198.774812551248},{"$f":"Main!G82","v":9390.4342040705742},{"$f":"Main!H82","v":9586.6199283015048},{"$f":"Main!I82","v":9787.5602870328948},{"$f":"Main!J82","v":9993.5532020655228},"Firstlight Network",null,6628.1857494846445,6737.8048420677042,6863.1301769916754,6997.8204433771334,7135.0288005526327,7274.7864072912034]
[{"$f":"Main!B83","v":"Horizon Energy"},null,{"$f":"Main!D83","v":7716.0536447045451},{"$f":"Main!E83","v":7855.3485239151132},{"$f":"Main!F83","v":7779.856388479323},{"$f":"Main!G83","v":7626.1287731212942},{"$f":"Main!H83","v":7504.4902482449379},{"$f":"Main!I83","v":7281.3133738179813},{"$f":"Main!J83","v":7196.8381042092851},"Horizon Energy",null,7251.2862370917992,7365.149527504067,7495.7473078589746,7635.9651562027857,7778.1016617054183,7922.0569177768448]
[{"$f":"Main!B84","v":"Nelson Electricity"},null,{"$f":"Main!D84","v":1779.9681596858034},{"$f":"Main!E84","v":1773.4558333648442},{"$f":"Main!F84","v":1757.2087761229825},{"$f":"Main!G84","v":1689.86429562583},{"$f":"Main!H84","v":1659.419126870604},{"$f":"Main!I84","v":1656.4028895475926},{"$f":"Main!J84","v":1651.7613674200134},"Nelson Electricity",null,1529.3174185977907,1553.5908762100605,1581.3935898621967,1611.2588835789738,1641.60937560092,1672.4439272861669]
[{"$f":"Main!B85","v":"Network Tasman"},null,{"$f":"Main!D85","v":8610.5090909090904},{"$f":"Main!E85","v":8368.2193342004957},{"$f":"Main!F85","v":7952.1418389780847},{"$f":"Main!G85","v":7100.904206137775},{"$f":"Main!H85","v":6977.0298682851108},{"$f":"Main!I85","v":6983.3619475715068},{"$f":"Main!J85","v":7067.6859510488421},"Network Tasman",null,7096.7955391739906,7197.7004432336489,7313.9844543879881,7438.6603564512916,7564.2427283575335,7690.564938721991]
[{"$f":"Main!B86","v":"Orion NZ"},null,{"$f":"Main!D86","v":58629.704545454544},{"$f":"Main!E86","v":58324.493712305186},{"$f":"Main!F86","v":58914.292587821794},{"$f":"Main!G86","v":57741.444837282463},{"$f":"Main!H86","v":57207.564350138709},{"$f":"Main!I86","v":56606.127347645241},{"$f":"Main!J86","v":56425.174932053509},"Orion NZ",null,43748.808167786556,44449.681890935106,45252.224895297775,46114.375643048428,46990.820311103336,47881.527246890488]
[{"$f":"Main!B87","v":"OtagoNet"},null,{"$f":"Main!D87","v":11237.639601038636},{"$f":"Main!E87","v":11708.545282750283},{"$f":"Main!F87","v":12026.167506729353},{"$f":"Main!G87","v":12277.581604549974},{"$f":"Main!H87","v":12534.791015107283},{"$f":"Main!I87","v":12797.995703662496},{"$f":"Main!J87","v":13067.413444735776},"OtagoNet",null,8385.6800610597238,8521.3705678032456,8676.6971450215551,8843.587805451587,9013.3326974436732,9185.9324882385899]
[{"$f":"Main!B88","v":"Powerco"},null,{"$f":"Main!D88","v":122340.36222453513},{"$f":"Main!E88","v":113234.87556356732},{"$f":"Main!F88","v":106059.46830123047},{"$f":"Main!G88","v":102002.25733202472},{"$f":"Main!H88","v":98175.528751886712},{"$f":"Main!I88","v":95806.674223211754},{"$f":"Main!J88","v":94059.588768050395},"Powerco",null,75279.477643903097,76090.017680318851,77040.937173106693,78055.340796710778,79051.860088310917,80025.78160606345]
[{"$f":"Main!B89","v":"The Lines Company"},null,{"$f":"Main!D89","v":10721.988818269625},{"$f":"Main!E89","v":11160.956485761504},{"$f":"Main!F89","v":11453.208605235179},{"$f":"Main!G89","v":11681.772310157023},{"$f":"Main!H89","v":11915.086657485581},{"$f":"Main!I89","v":12153.268099013714},{"$f":"Main!J89","v":12396.438764021661},"The Lines Company",null,9620.2477332893995,9766.4150302410217,9934.2672989684015,10114.391601711077,10296.652711912839,10480.90505064555]
[{"$f":"Main!B90","v":"Top Energy"},null,{"$f":"Main!D90","v":13800.245957671807},{"$f":"Main!E90","v":13266.010824094265},{"$f":"Main!F90","v":13337.771960979187},{"$f":"Main!G90","v":13083.763530304579},{"$f":"Main!H90","v":13062.154345121011},{"$f":"Main!I90","v":13184.719584135832},{"$f":"Main!J90","v":13279.538979928919},"Top Energy",null,9876.8385382317865,10050.065581364219,10247.455771589483,10459.682652758014,10676.64564336997,10898.48942565926]
[{"$f":"Main!B91","v":"Unison Networks"},null,{"$f":"Main!D91","v":39298.663055104196},{"$f":"Main!E91","v":40614.82541990246},{"$f":"Main!F91","v":41729.134354704984},{"$f":"Main!G91","v":42610.668394645283},{"$f":"Main!H91","v":43511.820720998861},{"$f":"Main!I91","v":44433.209069861085},{"$f":"Main!J91","v":45375.505881790326},"Unison Networks",null,30584.122740997769,30991.831495005215,31462.969222032581,31966.721037601357,32470.058928432598,32971.528956035829]
[{"$f":"Main!B92","v":"Vector Lines"},null,{"$f":"Main!D92","v":163768.38406407277},{"$f":"Main!E92","v":162454.51512828851},{"$f":"Main!F92","v":158104.2403432322},{"$f":"Main!G92","v":153469.68465810313},{"$f":"Main!H92","v":152033.49170206577},{"$f":"Main!I92","v":151948.21663066876},{"$f":"Main!J92","v":150553.0898478397},"Vector Lines",null,117620.26571313903,119261.68960990837,121156.02201593328,123188.02428886596,125234.59789541947,127293.37018934517]
[{"$f":"Main!B93","v":"Wellington Electricity"},null,{"$f":"Main!D93","v":33585.679138967382},{"$f":"Main!E93","v":33132.255427657132},{"$f":"Main!F93","v":33277.424390637214},{"$f":"Main!G93","v":31425.729682664256},{"$f":"Main!H93","v":31142.741432889001},{"$f":"Main!I93","v":31007.107447227339},{"$f":"Main!J93","v":30866.765694366663},"Wellington Electricity",null,28291.97846351756,28794.921423753312,29368.308027819963,29985.397663722604,30617.150174348422,31264.146070780316]
[]
["Sum of DPP3 depreciation of assets existing at 31-3-24, with CPI adjustment and adjustment for additional assets added in year ending 2024"]
[null,null,2024,2025,2026,2027,2028,2029,2030]
[{"$f":"Main!B97","v":"Alpine Energy"},null,{"$f":"Main!D97","v":13027.853545135305},{"$f":"Main!E97","v":13574.518769954559},{"$f":"Main!F97","v":13942.898604971801},{"$f":"Main!G97","v":14234.149616495737},{"$f":"Main!H97","v":14532.046782121153},{"$f":"Main!I97","v":14837.252267601603},{"$f":"Main!J97","v":15150.074506544166}]
[{"$f":"Main!B98","v":"Aurora Energy"},null,{"$f":"Main!D98","v":31109.005953418829},{"$f":"Main!E98","v":32297.687716527078},{"$f":"Main!F98","v":33049.783894455977},{"$f":"Main!G98","v":33612.675825394603},{"$f":"Main!H98","v":34179.466220652954},{"$f":"Main!I98","v":34746.799620896578},{"$f":"Main!J98","v":35313.695419620788}]
[{"$f":"Main!B99","v":"EA Networks"},null,{"$f":"Main!D99","v":12986.626456326971},{"$f":"Main!E99","v":13499.706681154712},{"$f":"Main!F99","v":13834.279642251306},{"$f":"Main!G99","v":14093.591603596304},{"$f":"Main!H99","v":14360.007676530564},{"$f":"Main!I99","v":14629.550265424747},{"$f":"Main!J99","v":14902.450783325752}]
[{"$f":"Main!B100","v":"Electricity Invercargill"},null,{"$f":"Main!D100","v":4161.0166241409788},{"$f":"Main!E100","v":4334.7723138869942},{"$f":"Main!F100","v":4451.9030576567529},{"$f":"Main!G100","v":4544.5670712913743},{"$f":"Main!H100","v":4639.3236231935562},{"$f":"Main!I100","v":4736.2384242805829},{"$f":"Main!J100","v":4835.3820134948728}]
[{"$f":"Main!B101","v":"Firstlight Network"},null,{"$f":"Main!D101","v":8596.7100803956309},{"$f":"Main!E101","v":8955.5999762349547},{"$f":"Main!F101","v":9197.3783435881633},{"$f":"Main!G101","v":9388.5070207352146},{"$f":"Main!H101","v":9583.9660729120405},{"$f":"Main!I101","v":9783.8957615751024},{"$f":"Main!J101","v":9988.447568560392}]
[{"$f":"Main!B102","v":"Horizon Energy"},null,{"$f":"Main!D102","v":7716.0536447045451},{"$f":"Main!E102","v":8017.8254341452621},{"$f":"Main!F102","v":8212.3309678934511},{"$f":"Main!G102","v":8360.154675487167},{"$f":"Main!H102","v":8511.0017870001138},{"$f":"Main!I102","v":8664.9244171247919},{"$f":"Main!J102","v":8821.987432294105}]
[{"$f":"Main!B103","v":"Nelson Electricity"},null,{"$f":"Main!D103","v":1779.9681596858034},{"$f":"Main!E103","v":1857.7438553909574},{"$f":"Main!F103","v":1907.8601923567292},{"$f":"Main!G103","v":1947.5073952718876},{"$f":"Main!H103","v":1988.0405450702635},{"$f":"Main!I103","v":2029.4860344789549},{"$f":"Main!J103","v":2071.8719670564547}]
[{"$f":"Main!B104","v":"Network Tasman"},null,{"$f":"Main!D104","v":8610.5090909090904},{"$f":"Main!E104","v":8936.3899635501202},{"$f":"Main!F104","v":9177.1505106228415},{"$f":"Main!G104","v":9351.3653519084455},{"$f":"Main!H104","v":9533.7861780395669},{"$f":"Main!I104","v":9721.1749958549899},{"$f":"Main!J104","v":9913.6326317583225}]
[{"$f":"Main!B105","v":"Orion NZ"},null,{"$f":"Main!D105","v":58629.704545454544},{"$f":"Main!E105","v":61050.51631507367},{"$f":"Main!F105","v":62667.899004929015},{"$f":"Main!G105","v":63948.595118042758},{"$f":"Main!H105","v":65252.807353349817},{"$f":"Main!I105","v":66575.518640085356},{"$f":"Main!J105","v":67926.605114614271}]
[{"$f":"Main!B106","v":"OtagoNet"},null,{"$f":"Main!D106","v":11237.639601038636},{"$f":"Main!E106","v":11708.545282750283},{"$f":"Main!F106","v":12026.167506729353},{"$f":"Main!G106","v":12277.581604549974},{"$f":"Main!H106","v":12534.791015107283},{"$f":"Main!I106","v":12797.995703662496},{"$f":"Main!J106","v":13067.413444735776}]
[{"$f":"Main!B107","v":"Powerco"},null,{"$f":"Main!D107","v":122340.36222453513},{"$f":"Main!E107","v":126481.44603376335},{"$f":"Main!F107","v":128824.23232987717},{"$f":"Main!G107","v":130369.54565138668},{"$f":"Main!H107","v":131890.70125693074},{"$f":"Main!I107","v":133380.78202290239},{"$f":"Main!J107","v":134831.53304199723}]
[{"$f":"Main!B108","v":"The Lines Company"},null,{"$f":"Main!D108","v":10721.988818269625},{"$f":"Main!E108","v":11160.956485761506},{"$f":"Main!F108","v":11453.208605235181},{"$f":"Main!G108","v":11681.772310157023},{"$f":"Main!H108","v":11915.086657485581},{"$f":"Main!I108","v":12153.268099013718},{"$f":"Main!J108","v":12396.438764021661}]
[{"$f":"Main!B109","v":"Top Energy"},null,{"$f":"Main!D109","v":13800.245957671807},{"$f":"Main!E109","v":14377.767393337546},{"$f":"Main!F109","v":14767.25328492376},{"$f":"Main!G109","v":15075.511297789215},{"$f":"Main!H109","v":15390.814462121327},{"$f":"Main!I109","v":15713.396044442079},{"$f":"Main!J109","v":16043.508414365731}]
[{"$f":"Main!B110","v":"Unison Networks"},null,{"$f":"Main!D110","v":39298.663055104196},{"$f":"Main!E110","v":40833.036322790627},{"$f":"Main!F110","v":41875.952005341496},{"$f":"Main!G110","v":42680.510140310529},{"$f":"Main!H110","v":43498.55079280588},{"$f":"Main!I110","v":44329.978899164045},{"$f":"Main!J110","v":45174.657482796611}]
[{"$f":"Main!B111","v":"Vector Lines"},null,{"$f":"Main!D111","v":163768.38406407277},{"$f":"Main!E111","v":170245.13477611679},{"$f":"Main!F111","v":174394.32154030868},{"$f":"Main!G111","v":177550.64806759555},{"$f":"Main!H111","v":180757.14603744043},{"$f":"Main!I111","v":184013.56288980242},{"$f":"Main!J111","v":187319.44105240834}]
[{"$f":"Main!B112","v":"Wellington Electricity"},null,{"$f":"Main!D112","v":33585.679138967382},{"$f":"Main!E112","v":34992.616026555675},{"$f":"Main!F112","v":35941.620824704274},{"$f":"Main!G112","v":36692.828176160336},{"$f":"Main!H112","v":37461.308656717418},{"$f":"Main!I112","v":38247.65029411362},{"$f":"Main!J112","v":39052.492004391745}]
[]
[]
[]
["Depreciation decrease in s53ZD depreciation of assets existing at 31-3-24 relative to DPP3 methodology"]
[null,null,2024,2025,2026,2027,2028,2029,2030]
["Powerco",null,0,0.10473228824960756,0.17670962882790409,0.21759089478667926,0.25563151848008359,0.28171038074345867,0.30240036400652204]
["Network Tasman",null,0,6.3579759606434694E-2,0.13348292337438439,0.24065510241465515,0.26817809166119722,0.28163391987648656,0.28707434378055474]
["Wellington Electricity",null,0,5.3164585700839262E-2,7.4123778493873638E-2,0.14354422925320653,0.16866780272758419,0.18930563210005125,0.20960717527121664]
["Nelson Electricity",null,0,4.5371245834223584E-2,7.8962093781770104E-2,0.13229247274311484,0.16529795137091052,0.18383019704834602,0.20276751967549667]
["Vector Lines",null,0,4.5761464431385845E-2,9.3408266758196135E-2,0.13562801083583154,0.1589072365110753,0.17425570465770257,0.19627737039011783]
["Horizon Energy",null,0,2.0264555226465975E-2,5.2660875563304566E-2,8.7800069471391295E-2,0.11825997098958851,0.1596800068428591,0.18421688490810606]
["Top Energy",null,0,7.7324970949385063E-2,9.6798110546563843E-2,0.13211566279588505,0.1512996339988304,0.16092263777197779,0.17227743716046262]
["Orion NZ",null,0,4.4652149939044539E-2,5.9895358175885094E-2,9.7063504843145965E-2,0.1232924660069048,0.14974487936693825,0.16932094172882228]
["Alpine Energy",null,0,6.973370910139054E-3,3.4485973886944632E-2,6.1789008627873288E-2,7.6045404865168864E-2,0.10974073136410634,0.16708787402079583]
["Aurora Energy",null,0,4.1611190464543868E-2,7.46751027283451E-2,0.10385574364629169,0.12843657534700137,0.14524731565082727,0.15493533063114595]
["EA Networks",null,0,1.5170466471552291E-2,2.2171484118337137E-2,3.5969755402242898E-2,4.5785969611930599E-2,5.6295578302047011E-2,6.3176932414971243E-2]
["Electricity Invercargill",null,0,0,0,0,0,0,0]
["OtagoNet",null,0,0,0,0,0,0,0]
["The Lines Company",null,0,0,0,0,0,0,0]
["Firstlight Network",null,0,-8.7107024469235128E-5,-1.5183020197806485E-4,-2.0526750078797562E-4,-2.7690304096150697E-4,-3.7454430365602143E-4,-5.1115201867601989E-4]
["Unison Networks",null,0,5.3440263485459161E-3,3.5057734107373228E-3,1.6361346459943249E-3,-3.0532781457126568E-4,-2.328952183600963E-3,-4.4463359287096882E-3]

{"sheet":"alp","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"alp",5016164]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March","2024\n$'000","2025\n$'000","2026\n$'000","2027\n$'000","2028\n$'000","2029\n$'000","2030\n$'000"]
["Forecast aggregate opening RAB value for existing assets",293278.38733564003,{"$f":"B9","v":291903.47614562273},{"$f":"C9","v":286564.65825467848},279394.68112005497,272197.77577870549,264802.30018530216,257494.14137446485]
["Forecast sum of depreciation for existing assets",12511.489908771669,12913.308270730438,12881.270299717096,12762.798963750593,12823.431108977449,12594.204814543355,11993.19374475664]
["Forecast revaluation for existing assets*",{"$f":"B5*B13","v":11144.578718754321},{"$f":"C5*C13","v":7589.490379786198},5731.2931650935743,5587.893622401104,5443.9555155741145,5296.0460037060475,5149.8828274893012]
["Forecast aggregate value of disposed assets",8,15,20,22,16,10,7]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":291903.47614562273},286564.65825467848,279394.68112005497,272197.77577870549,264802.30018530216,257494.14137446485,250643.8304571975]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]
["Alpine Energy Limited (Alpine/ we) notes that the table above does not allow for assets commissioned to be added for the disclosure year ending 31 March 2024. The implications of this not being included in the table are:\n- The forecast aggregate closing RAB for the existing assets  (line 9, column B) will be understated due to commissioned assets for the disclosure year 2024 not being added. The opening balance will represent the closing balance as at 31 March 2023 and the depreciation and revaluations will be based on this opening balance. (As defined: \"Existing assets means assets of an EDB for which an aggregate closing RAB value for existing assets is calculated for the base year\"; and base year being \"Disclosure year 2024\").\n- The aggregate opening value of existing assets (line 5, columns C - H), forecast sum of depreciation (line 6, columns C - H), forecast revaluation of existing assets (line 7, columns C - H) and forecast aggregate closing RAB values for existing assets (line 9, columns C - H) will all be understated as it does not take into account the assets commissioned for the disclosure year ended 31 March 2024.  \n- The information we have provides above is therefore based on all assets commissioned up to 31 March 2023. We are in the process of closing our capitalisation processes for the year ended 31 March 2024 and we expect to have assets commissioned in excess of $20 million. This will significantly impact the depreciation and revaluations values for 2025 onwards.\n- We urge the Commerce Commission to advise how the assets commissioned for the disclosure year ended 31 March 2024 will be considered in the draft decision. "]

{"sheet":"aur","index":7,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"aur",5016181]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",736087850.58208382,{"$f":"B9","v":731990567.83307791},{"$f":"C9","v":719228275.4532907},702318418.6820693,685517753.44279313,668633939.729684,651434948.94257987]
["Forecast sum of depreciation for existing assets",29095245.763873372,28783493.989051312,28350456.270468988,27842922.021686289,27462200.18351325,27322138.330044381,27412441.642472517]
["Forecast revaluation for existing assets*",27740963.014867399,18878701.609264173,14269599.499247611,13940256.782410152,13600386.470404141,13266647.542940263,12916762.835517049]
["Forecast aggregate value of disposed assets",2743000,2857500,2829000,2898000,3022000,3143500,3162000]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":731990567.83307791},719228275.4532907,702318418.6820693,685517753.44279313,668633939.729684,651434948.94257987,633777270.13562441]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]
["Please note these are forecast figures derived from assumed asset disposals through the DPP4 period.  At the time of preparing this information request we were yet to calculate the assset disposals figure for RY24."]

{"sheet":"ean","index":8,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"ean",5016228]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",343290,{"$f":"B9","v":342810.42819167004},337993.34662983083,330895.01472155645,323674.27326911531,316175.50080663722,308413.81150766718]
["Forecast sum of depreciation for existing assets",12661.204836584642,12923.412433356514,13144.56489507984,13195.490065986301,13303.428650198401,13399.347655296773,13547.102433791944]
["Forecast revaluation for existing assets*",12943.633028254648,8866.1308715172891,6738.9929868054169,6610.8606135451746,6479.190587720318,6342.6996363267654,6201.5860548734199]
["Forecast aggregate value of disposed assets",{"$f":"(773+1095+976+444+522)/5","v":762},{"$f":"(1095+976+444+522+B8)/5","v":759.8},{"$f":"(976+444+522+B8+C8)/5","v":692.76},{"$f":"(444+522+B8+C8+D8)/5","v":636.11200000000008},{"$f":"(522+B8+C8+D8+E8)/5","v":674.53440000000001},{"$f":"(B8+C8+D8+E8+F8)/5","v":705.04128000000003},{"$f":"(C8+D8+E8+F8+G8)/5","v":693.64953600000001}]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":342810.42819167004},337993.34662983083,330895.01472155645,323674.27326911531,316175.50080663722,308413.81150766718,300374.64559274865]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"inv","index":9,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["EIL: Information required for the calculation of depreciation of existing assets ",null,null,null,null,null,null,"inv"]
[]
[]
["for the year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",107300133.22904368,114818029.51864532,122110220.36421312,126784154.70093577,133488144.46561357,140315309.10795584,145287962.68916106]
["Forecast sum of depreciation for existing assets",4024266.6241409788,4306223.5818030601,4579715.509106108,4755010.3329675961,5006441.9150793049,5262493.1424253741,5448991.3623068258]
["Forecast aggregate value of disposed assets ",100000,100000,100000,100000,100000,100000,100000]
["Forecast depreciation on disposed assets",{"$f":"B7*2%","v":2000},2000,2000,2000,2000,2000,2000]
["Forecast revaluation for existing assets ",6438007.9937426206,4707539.2102644583,3052755.5091053285,2789251.4034205866,2669762.8893122715,2806306.182159117,2905759.2537832214]
[]
[]
[]
[]
["Implicit reval rate",{"$f":"B9/B5","v":0.06},{"$f":"C9/C5","v":4.1000000000000002E-2},{"$f":"D9/D5","v":2.5000000000000001E-2},{"$f":"E9/E5","v":2.1999999999999999E-2},{"$f":"F9/F5","v":0.02},0.02,0.02]

{"sheet":"fln","index":10,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"fln",5013797]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",209446391.42999843,{"$f":"B9","v":209127455.12786725},{"$f":"C9","v":205962402.21040967},201246858.47959748,196253221.0799588,190971569.15071464,185391559.27626333]
["Forecast sum of depreciation for existing assets",8255884.3021311676,8582356.5736021586,8814783.9464204311,8998566.7406306528,9186708.5222433675,9379433.4288656283,9577034.946635725]
["Forecast revaluation for existing assets*",7958948,5437303.6561445901,4119240.2156082252,4024929.3409919809,3925056.5929992073,3819423.5544143235,3707823.356925298]
["Forecast aggregate value of disposed assets",22000,20000,20000,20000,20000,20000,20000]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":209127455.12786725},205962402.21040967,201246858.47959748,196253221.0799588,190971569.15071464,185391559.27626333,179502347.68655291]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"hor","index":11,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"hor",5016145]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",161216,{"$f":"B9","v":159335.283},{"$f":"C9","v":155370.12399999998},150466.55199999997,145641.21099999995,140858.40999999997,136224.93896999996]
["Forecast sum of depreciation for existing assets",7501.4269999999997,7613.6350000000002,7531.518,7372.7420000000002,7246.0146000000004,7017.826,6927.9823999999999]
["Forecast revaluation for existing assets*",6103.7370000000001,4125.8850000000002,3093.3560000000002,2998.058,2899.4425999999999,2806.2749699999999,2715.154]
["Forecast aggregate value of disposed assets",483.02699999999999,477.40899999999999,465.41,450.65699999999998,436.22899999999998,421.92,408.01060000000001]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":159335.283},155370.12399999998,150466.55199999997,145641.21099999995,140858.40999999997,136224.93896999996,131604.09996999995]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"nel","index":12,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"nel",5016152]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",49284.292000000001,{"$f":"B9","v":49517.982936314198},{"$f":"C9","v":49080.592856914998},48354.747256088202,47682.519665188782,47028.184664738459,46364.752194871493]
["Forecast sum of depreciation for existing assets",1736.9681596858034,1724.8576357433701,1707.4574579650935,1639.3225360211875,1607.9853937540981,1603.9961631617318,1598.3644932817472]
["Forecast revaluation for existing assets*",{"$f":"B13*B5","v":1872.8030960000001},{"$f":"C13*C5","v":1287.4675563441704},981.61185713830082,967.09494512176491,953.65039330377647,940.56369329477002,927.29504389743067]
["Forecast aggregate value of disposed assets",-97.855999999999995]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":49517.982936314198},49080.592856914998,48354.747256088202,47682.519665188782,47028.184664738459,46364.752194871493,45693.682745487175]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"tas","index":13,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"tas",5016157]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",209789,{"$f":"B9","v":208606.19999999998},{"$f":"C9","v":206002.49999999997},202144.89999999997,199191.39999999997,196337.79999999996,193456.29999999996]
["Forecast sum of depreciation for existing assets",8269.1,7993.1,7568.5,6711.2,6579.9,6578.3,6654.4]
["Forecast revaluation for existing assets*",7926.8,5421,4099.8,4039.7,3980.3,3925.5,3863.4]
["Forecast aggregate value of disposed assets",840.5,31.6,388.9,282,254,228.7,205.9]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":208606.19999999998},206002.49999999997,202144.89999999997,199191.39999999997,196337.79999999996,193456.29999999996,190459.39999999997]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"ojv","index":14,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["DRAFT Template: Information required for the calculation of depreciation of existing assets DRAFT",null,null,null,null,null,null,"ojv",5016241]
[]
[]
["for the year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",263617441,287888739,302185872,321872304,346155488,369806445,394108772]
["Forecast sum of depreciation for existing assets",10772948,11774649,12359402,13164577,14157759,15125084,16119049]
["Forecast aggregate value of disposed assets ",98183,98183,98183,98183,98183,98183,98183]
["Forecast depreciation on disposed assets",{"$f":"SUM(B7*2%)","v":1963.66},1963.66,1963.66,1963.66,1963.66,1963.66,1963.66]
["Forecast revaluation for existing assets ",15817046,11803438,7554647,7081191,6923110,7396129,7882175]
[]
[]
[]
[]
["Implicit reval rate",{"$f":"B9/B5","v":5.999999825504717E-2},{"$f":"C9/C5","v":4.099999896140432E-2},2.500000066184431E-2,2.2000000969328509E-2]

{"sheet":"ori","index":15,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"ori",5016105]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",1450079000,{"$f":"B9","v":1448825000},{"$f":"C9","v":1430617000},1403103000,1376178000,1349104000,1322157000]
["Forecast sum of depreciation for existing assets",55550000,54993000,55494000,54255000,53652000,52980000,52726000]
["Forecast revaluation for existing assets*",55043000,37612000,28573000,28021000,27479000,26938000,26400000]
["Forecast aggregate value of disposed assets",747000,827000,593000,691000,901000,905000,883000]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":1448825000},1430617000,1403103000,1376178000,1349104000,1322157000,1294948000]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"pco","index":16,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets"]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",2589536807.3477654,{"$f":"B9","v":2548669982.0263667},{"$f":"C9","v":2484753123.3309231},2411843523.6535325,2341678561.7305255,2274084613.0630846,2207662586.2854047]
["Forecast sum of depreciation for existing assets",116537921.31544423,106894272.06402092,99537671.205084354,95334841.457153022,91360528.963126555,88836728.100017056,86929591.808175787]
["Forecast revaluation for existing assets*",97040528.937339768,65307686.890224561,48958345.049340785,47500153.055792972,46096853.817332834,44744974.843984015,43416534.308430411]
["Forecast aggregate value of disposed assets",21369432.943293992,22330273.521646895,22330273.521646895,22330273.521646895,22330273.521646895,22330273.521646895,22330273.521646895]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":2548669982.0263667},2484753123.3309231,2411843523.6535325,2341678561.7305255,2274084613.0630846,2207662586.2854047,2141819255.2640123]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"tlc","index":17,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"tlc",5016125]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",263264167.3916828,{"$f":"B9","v":262751848.62260881},{"$f":"C9","v":258670112.96313596},252650869.59410959,246292863.78741395,239584785.44703096,232514986.94183278]
["Forecast sum of depreciation for existing assets",10280214.272815078,{"$f":"C5/($B$31+C32)","v":10677140.866517816},{"$f":"D5/($B$31+D32)","v":10956502.771146199},11174880.341434998,11397792.75898842,11625351.356995935,11857672.966052908]
["Forecast revaluation for existing assets*",{"$f":"B5*B13","v":10004038.360883946},{"$f":"C5*C13","v":6831548.064187835},5173402.2592627238,5053017.3918821961,4925857.2757482836,4791695.7089406233,4650299.73883666]
["Forecast aggregate value of disposed assets",236142.85714285713,236142.85714285716,236142.85714285716,236142.85714285716,236142.85714285719,236142.85714285716,236142.85714285716]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":262751848.62260881},258670112.96313596,252650869.59410959,246292863.78741395,239584785.44703096,232514986.94183278,225071470.85747364]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]
["Commentary: we believe we have completed this workbook correctly - the formulae remain in place so that the Commission can verify."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Forecast aggregate opening RAB value for existing assets",{"$f":"B5","v":263264167.3916828}]
["Forecast sum of depreciation for existing assets",{"$f":"B6","v":10280214.272815078}]
["Forecast aggregate opening RAB value for existing assets / Forecast sum of depreciation for existing assets",{"$f":"B29/B30","v":25.608821023104216}]
["Year","base",-1,-2,-3,-4,-5,-6]

{"sheet":"top","index":18,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"top",5012753]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",339120862.28217572,{"$f":"B9","v":338649448.60042751},{"$f":"C9","v":334697834.99013269},328574900.72073936,322598589.04389197,316538323.26831084,310245398.90730578]
["Forecast sum of depreciation for existing assets",13329336.866762716,12746212.948945291,12804431.984734438,12540291.408963772,12507975.643330878,12619390.716893354,12702893.130291009]
["Forecast revaluation for existing assets*",12858923.185014479,8795599.3386504389,6682497.7153411135,6564979.732116376,6448709.8677497283,6327466.3558883043,6203595.0564225726]
["Forecast aggregate value of disposed assets",1000,1000,1000,1000,1000,1000,1000]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":338649448.60042751},334697834.99013269,328574900.72073936,322598589.04389197,316538323.26831084,310245398.90730578,303745100.83343738]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"uni","index":19,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"uni",5013907]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",805808,{"$f":"B9","v":796589.57196600025},{"$f":"C9","v":777492.50858247036},752167.99140445236,725477.61965932476,697374.6318118507,667811.24799048877,"$000"]
["Forecast sum of depreciation for existing assets",37213.511329999761,38351.280925774823,39402.191439356997,40233.436093111035,41083.073525584245,41951.672659025928,42839.852370758003,"$000"]
["Forecast revaluation for existing assets*",{"$f":"(B5*0.999+(-B8))*B13","v":30495.083296000001},{"$f":"(C5*0.999+(-C8))*C13","v":20654.217542244911},15505.739026180934,14999.193877667296,14465.337798387771,13903.246000347126,13311.963608731243,"$000"]
["Forecast aggregate value of disposed assets",2500,1400,1428.0647648419429,1456.1295296838859,1485.2521202775638,1514.957162683115,1545.2563059367774,"$000"]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":796589.57196600025},{"$f":"C5-C6+C7-C8","v":777492.50858247036},752167.99140445236,725477.61965932476,697374.6318118507,667811.24799048877,636738.10292252537,"$000"]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]
["Not applicable, all information is provided"]

{"sheet":"vct","index":20,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,0,26,7]]}
["Template: Information required for the calculation of depreciation of existing assets"]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",3891832614.4465032,{"$f":"B10","v":3874339151.7851334},{"$f":"C10","v":3810306715.1196289},3726433142.6447015,3645766663.0639906,3565129108.2280178,3483167089.1339426]
["Forecast sum of depreciation for existing assets",-155628634.06407276,-153610600.24585113,-149027073.2589058,-144211863.93559948,-142585880.58806822,-142303824.29245117,-140711739.85335165]
["Forecast revaluation for existing assets*",147258899.5276219,100282178.6894865,75857476.736706227,74249368.797562286,72652313.952217266,71045801.325564042,69394551.140776455]
["Forecast aggregate value of disposed assets",-10703982.140107641,-10704015.109139802,-10703975.952727772,-10703984.44267348,-10703988.200121833,-10703996.127187701,-10703982.738337141]
["Forecast aggregated value of allocation adjustments",1580254.015188593]
["Forecast aggregate closing RAB value for existing assets",{"$f":"SUM(B5:B9)","v":3874339151.7851334},{"$f":"SUM(C5:C8)","v":3810306715.1196289},3726433142.6447015,3645766663.0639906,3565129108.2280178,3483167089.1339426,3401145917.6830306]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[null,{"$f":"B5/B6","v":-25.007175818585058},{"$f":"C5/C6","v":-25.221821577315108},-25.567882612174472,-25.839990143313109,-25.568917820107593,-25.052939553481405,-24.753919557558337]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]

{"sheet":"wel","index":21,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,25,7]]}
["Template: Information required for the calculation of depreciation of existing assets",null,null,null,null,null,null,"wel",5016218]
["See the \"TOC & Instructions\" tab for instructions on completing this template"]
[]
["for the disclosure year ending 31 March",2024,2025,2026,2027,2028,2029,2030]
["Forecast aggregate opening RAB value for existing assets",803430166.15239108,{"$f":"B9","v":801567181.77447295},790600307.80283689,774499538.12185574,759951852.74740028,745423724.9285748,730769102.45982146]
["Forecast sum of depreciation for existing assets",32362800.345395193,31786779.95104618,31896963.830881886,30022186.146130241,29711965.836718507,29548188.492826175,29379130.784017988]
["Forecast revaluation for existing assets*",{"$f":"(B5*0.999)*B13","v":30499815.967477072},20819905.979410179,15796194.149900695,15474500.771674693,15183838.01789307,14893566.024072938,14600766.667147247,"  "]
["Forecast aggregate value of disposed assets",0,0,0,0,0,0,0]
["Forecast aggregate closing RAB value for existing assets",{"$f":"B5-B6+B7-B8","v":801567181.77447295},790600307.80283689,774499538.12185574,759951852.74740028,745423724.9285748,730769102.45982146,715990738.3429507]
[]
["* for the purpose of calculating forecast revaluation for existing assets, use the following revaluation rate"]
[null,2024,2025,2026,2027,2028,2029,2030]
["Revaluation rate",3.7999999999999999E-2,2.6000000000000023E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[]
["If your EDB is unable to provide any of the information requested in rows 5 to 8 of this template, please provide reasons in the space below:"]
["We note that the revaluation for the depreciation calculation is at an asset level, while the RAB revaluation (as per IM clause 4.2.3(2)(a)) is at an aggregated RAB level. The sum of the asset-level revaluations is different to the RAB-level revaluations. The difference isn't material but the calculation methods are inconsistent. "]
[]
[null,null,null,null,null,null,null,null,null," "]