{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Index","RFS Inc","DISAGG Inc","DISAGG Opex","DISAGG Aloc1","DISAGG Aloc2","PTS Adj","PTS PriceRedn","PTS PDisc","DISAGG ProvSum","INF RelPartTrans","INF RevRec","Hist Capex by Asset Class ","NCIPAP","Hist Capex - Non-Network"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":32,"defined_names":967,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,1,38,1],[32,1,34,1],[1,1,1,4],[28,1,31,1],[13,1,17,1],[7,1,9,1],[10,1,12,1],[18,1,24,1]]}
[]
[null,"INFORMATION DISCLOSURE REQUIREMENTS"]
[]
[null,null,"TABLE OF CONTENTS"]
[null,null,"for the year ended 30 June 2020"]
[]
[null,"TYPE","PROFORMA STATEMENT","STATEMENT NUMBER","PAGE"]
[null,"Regulatory Financial Statements"]
[null,null,"Income Statement","RFS Inc",2]
[]
[null,"Disaggregation Statements"]
[null,null,"Income Statement","DISAGG Inc",3]
[]
[null,"Workpapers supporting the Disaggregation Statements:"]
[null,null,"Operations and maintenance expenditure","DISAGG Opex",4]
[null,null,"Causal allocations","DISAGG Aloc1",5]
[null,null,"Non-causal allocations","DISAGG Aloc2",6]
[]
[null,"Prescribed Transmission Services"]
[null,null,"Regulatory adjustment journals","PTS Adj",7]
[]
[null,null,"Price reduction/recovery ","PTS PriceRedn",8]
[]
[null,null,"Discount","PTS  Disc",9]
[]
[null,"Provisions Schedules:"]
[null,"Disaggregation Statements","Provisions Summary","DISAGG ProvSum",10]
[]
[null,"Other Information"]
[null,null,"Related Party Transactions","Inf Rel Part Trans",11]
[null,null,"Revenue Reconciliation","Inf Rev Rec",12]
[]
[null,"Non-financial Schedules"]
[null,null,"Current Map of the Network","NFS Curr Map Netw","na"]
[]
[null,"Historic Capital Expenditure (Capex)"]
[null,null,"Historic Capex by Asset Class ","HCE Ass Cls",13]
[null,null,"Historic Capex - Non-Network","HCE Non Netw",18]

{"sheet":"RFS Inc","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,7],[1,0,1,7],[38,0,38,7]]}
[]
["INCOME STATEMENT - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["TransGrid Account Reference",null,"Description","Disaggregation Statement  -  Prescribed Transmission Services","Journal number","Regulatory adjustments","Regulatory financial statements","Support reference"]
[null,null,null,"$'000",null,"$'000","$'000"]
[null,null,null,null,null,"Dr/(Cr)"]
[]
[null,"Network charges",null,741364,2,-19193,760557,"Inf Rev Rec / Regulatory Adjustments"]
[null,"Rebates under ENA COVID-19 Network Relief Package ",null,-3442,null,null,-3442,"Disagg Inc"]
[null,"Other revenue",null,428,null,null,428,"Disagg Inc"]
[]
[null,"Total Revenue",null,738350,null,-19193,757543]
[]
[]
[null,"Opex costs "]
[null,"-","Network operations",-20568,null,null,-20568,"Disagg Inc"]
[null,"-","Network maintenance",-50075,null,null,-50075,"Disagg Inc"]
[null,"-","Other controllable costs ",-78372,3,832,-79204,"Regulatory Adjustments"]
[null,"-","Network support pass-through costs ",-1234,null,null,-1234,"Disagg Inc"]
[null,"-","Bushfire remediation costs",-9273,null,null,-9273,"Disagg Inc"]
[null,"-","Defined benefit superannuation adjustment",-1098,null,null,-1098,"Disagg Inc"]
[]
[null,"Depreciation",null,-315107,"1, 3",-40415,-274692,"Regulatory Adjustments"]
[null,"Net Loss on Disposal of Property, Plant and Equipment",null,-712,null,null,-712,"Disagg Inc"]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,261911,null,-58776,320687]
[]
[]
[]
[null,"Taxation"]

{"sheet":"DISAGG Inc","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,0,48,9],[1,0,1,9],[4,0,4,9],[45,0,45,9],[46,0,46,9],[47,0,47,9]]}
[]
["DISAGGREGATION STATEMENT - INCOME"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["Account code or reference to Account Code",null,"Description","Audited financial statements",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Workpaper reference"]
[null,null,null,"$'000",null,"$'000","$'000","$'000","$'000"]
[]
[null,"Network charges",null,741364,null,741364,null,null,null,"Regulatory Income Statement WS"]
[null,"Rebates under ENA COVID-19 Network Relief Package ",null,-3442,null,-3442,null,null,null,"Regulatory Income Statement WS"]
[null,"External project work",null,0,null,0,null,null,null,"Regulatory Income Statement WS"]
[null,"Other revenue ",null,428,null,428,null,null,null,"Regulatory Income Statement WS"]
[null,"Total Revenue",null,738350,null,738350]
[]
[null,"Opex costs "]
[null,"-","Network operations ",-20568,null,-20568,null,null,null,"DISAGG Opex"]
[null,"-","Network maintenance",-50075,null,-50075,null,null,null,"DISAGG Opex"]
[null,"-","Other controllable costs",-78372,null,-78372,null,null,null,"DISAGG Opex"]
[null,"-","Network support pass-through costs ",-1234,null,-1234,null,null,null,"DISAGG Opex"]
[null,"-","Bushfire remediation costs",-9273,null,-9273,null,null,null,"DISAGG Opex"]
[null,"-","Defined benefit superannuation adjustment",-1098,null,-1098,null,null,null,"DISAGG Opex"]
[]
[null,"Depreciation ",null,-315107,null,-315107,null,null,null,"Regulatory Income Statement WS"]
[null,"Net Loss on Disposal of Property, Plant and Equipment",null,-712,null,-712,null,null,null,"Regulatory Income Statement WS"]
[null,"Earnings before Interest and Tax (EBIT)",null,261911,null,261911]
[]
[null,"Interest and dividend income",null,0,null,null,null,null,null,"Regulatory Income Statement WS"]
[null,"Finance charges",null,0,null,null,null,null,null,"Regulatory Income Statement WS"]
[]
[null,"Profit(loss) before Income Tax Expense ",null,261911,null,261911]
[]
[null,"Australian income tax expense",null,0,null,null,null,null,null,"Regulatory Income Statement WS"]
[null,"Deferred income tax",null,0,null,null,null,null,null,"Regulatory Income Statement WS"]
[]
[null,"Profit(loss) after income tax expense",null,261911,null,261911]
[]
[null,"Distribution to security holders",null,null,null,null,null,null,null,"Regulatory Income Statement WS"]
[]
[null,"Retained Profit(Loss)"]
[]
[]
["Note:"]
["1. The regulatory accounts for the year ended 30 June 2020 have been prepared based on: \n• Audited NSW Electricity Networks Obligor Group Financial Report approved by the Board of NSW Electricity Networks Operations Intermediate Pty Limited as Trustee for NSW Electricity Networks Operations Intermediate Trust and the Board of NSW Electricity Networks Assets Holdings Pty Limited as Trustee for NSW Electricity Networks Assets Holdings Trust, for the year ended 30 June 2020; and\n• Supporting information for the audited NSW Electricity Networks Obligor Group Financial Report for the same period ended 30 June 2020.    \n   \n\n \n\n \n"]
["2. Defined Benefit Superannuation Adjustment relates to an adjustment made to reverse out the Defined Benefit superannuation cash contribution in Prescribed Opex and added back the Defined Benefit superannuation accounting expense for compliance with Australian Accounting Standard AASB 119."]
["3. Bushfire remediation costs relate to operating expenditure incurred for the year ended 30 June 2020 on rectifications and remediation work in relation to the November and December 2019 bushfires in NSW."]
["4. Rebates provided under the ENA COVID-19 Network Relief Package has been recognised as a reduction to TransGrid's prescribed transmission network charges.  The rebates related to the period April 2020 to June 2020, and the amount recognised in TransGrid's"]
["accounts for FY2019/20 is an estimate pending finalisation of the claims by the NSW distributors that signed up to the ENA COVID-19 Network Relief Package.  "]

{"sheet":"DISAGG Opex","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,4,12],[1,0,1,12]]}
[]
["OPERATIONS AND MAINTENANCE EXPENDITURE"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["Account code or reference to account code",null,null,"Account Heading",null,null,"Ticks to indicate which rows are intersegmental costs",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,null,null,null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,null,null,"Directly Attributed Costs"]
[null,null,null,"Network operations ",null,null,null,null,-20568]
[null,null,null,"Network maintenance",null,null,null,null,-50075]
[null,null,null,"Other controllable costs",null,null,null,null,-78372]
[null,null,null,"Network support pass-through costs ",null,null,null,null,-1234]
[null,null,null,"Bushfire remediation costs",null,null,null,null,-9273]
[null,null,null,"Defined benefit superannuation adjustment",null,null,null,null,-1098]
[]
[null,null,null,null,null,null,"Subtotal of Directly Attributed costs",null,-160620]
[]
[]
[]
[null,null,null,"Allocated Costs",null,null,null,null,"NIL"]
[]
[]
[]
[null,null,null,"Other costs",null,null,null,null,"NIL"]
[]
[]
[null,null,null,null,null,null,"Subtotal of Allocated costs",null,"NIL"]
[]
[]
[null,null,null,null,null,null,"Total Opex Costs per DISAGG FPerf",null,-160620]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Total"]
[]
[]
["Explanation of opex costs required by the Commission (for example, bushfire costs, insurance etc)"]
[]
[null,"Bushfire remediation costs relate to operating expenditure incurred for the year ended 30 June 2020 on rectifications and remediation work in relation to "]
[null,"the November and December 2019 bushfires in NSW."]

{"sheet":"DISAGG Aloc1","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,31,6],[33,1,33,6],[1,0,1,7],[4,10,4,11],[4,0,4,7],[8,0,8,7],[29,1,29,6]]}
[]
["CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["A copy of this workpaper is to be produced for each Causal basis that has been used to allocate costs between Business Segments."]
[]
[null,"1.   Causal basis of allocation …………NIL………………………………………………….."]
[]
[null,"2.  Complete the table set out below to indicate: "]
[null,"-   the Account Headings and the amounts subject to this Causal basis; and"]
[null,"-   the description and quanta of allocator that has been used"]
[]
["Account code or reference to account code","Account Heading",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[null,"For each Account Heading that has been "]
[null,"allocated on this basis, provide the following information",null,"NIL"]
[]
[null,"Numeric quantity of allocator  (eg no of man-hours)"]
[null,"Corresponding cost allocation",null,"N/A"]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[null,"TransGrid's General Ledger has been structured so that prescribed, non-regulated and negotiated costs are separated into different cost centres and account numbers. Where appropriate, costs are ring fenced for regulatory reporting purposes. "]
[]
[null,"TransGrid uses direct labour as the cost driver to allocate support costs that are not directly attributable to a category of Transmission Service."]
[]
[null,"By ensuring that costing is correctly allocated in this way, the need to further allocate costs on an arbitrary process is negated."]

{"sheet":"DISAGG Aloc2","index":5,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,6],[45,1,45,8],[17,1,17,2],[4,9,4,10],[8,0,8,8],[12,1,12,8],[4,0,4,7],[14,1,14,2],[28,1,28,6],[30,1,30,6],[32,1,32,6]]}
[]
["NON-CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["A copy of this workpaper is to be produced for each Non-causal basis that has been used to\n allocate costs between Business Segments."]
[]
[null,"1.   Non-causal basis of allocation ………NIL………………………………"]
[]
[null,"2.  Complete the table set out below to indicate the Account Headings and the \namounts subject to this non-causal basis."]
[null,"     "]
["Account code or reference to account code","Account Heading",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,"(List all Account Headings that \nhave been allocated on this basis)",null,"NIL"]
[]
[]
[]
[]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[null,"TransGrid's General Ledger has been structured so that prescribed, non-regulated and negotiated costs are separated into different cost centres and account numbers. Where appropriate, costs are ring fenced for regulatory reporting purposes. "]
[]
[null,"TransGrid used direct labour as the cost driver to allocate support costs that are not directly attributable to a category of Transmission Service."]
[]
[null,"By ensuring that costing is correctly allocated in this way, the need to further allocate costs on an arbitrary process is negated."]
[]
[]
[null,"4.   Explain why no causal basis could be established:"]
[]
[]
[null,"Not applicable"]
[]
[]
[]
[]
[]
[]
[null,"5.  Explain the reasons for choosing this non-causal basis and why it was \npreferred over others:"]
[]
[]
[null,"Not applicable"]
[]
[]
[]
[]
[]
[]
[null,"6.  Date on which the Commission/AER granted approval:"]
[]
[null,"Not applicable"]

{"sheet":"PTS Adj","index":6,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,0,4,5],[1,0,1,4],[13,1,14,2]]}
[]
["REGULATORY ADJUSTMENT JOURNALS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["Journal","Account Debited",null,"Amount",null,"Supporting"]
["number",null,"Account Credited","Debit","Credit","Statement"]
[null,null,null,"$'000","$'000","No."]
[1,"Dr","Reserves",40001]
[null,"Cr","Depreciation",null,40001]
[null,"(Adjustment for Straight line depreciation for prescribed property, plant and equipment and intangible assets)"]
[]
[]
[]
[]
[]
[2,"Dr ","Deferred Revenue",19193]
[null,"Cr ","Network charges",null,19193]
[null,"(Adjust Statutory Prescribed Revenue to regulatory revenue)"]
[]
[]
[]
[]
[]
[3,"Dr","Lease liabilities",4314]
[null,"Dr","Other controllable costs ",832]
[null,"Cr","Right-of-use assets",null,4573]
[null,"Cr","Depreciation",null,414]
[null,"Cr","Finance charges",null,159]
[null,"(Reverse the accounting impacts under AASB 16 Leases for operating leases relating to the provision of prescribed transmission network services)"]
[null,"AASB 16 Leases came into effect from 1 July 2019, whereby operating lease payments are no longer recognised as operating expenses in the Income Statement"]
[null,"for statutory financial reporting, but instead applied as a reduction to the lease liability recognised on the Balance Sheet.  A depreciation charge relating to a"]
[null,"right-of-use asset and interest expense relating to the lease liability are recognised in the Income Statement under AASB 16."]
[null,"This regulatory adjustment has been made to reverse the statutory accounting impacts of AASB 16 for prescribed operating leases, thereby ensuring the "]
[null,"associated operating lease expenses incurred for the provision of prescribed transmission network services are still recognised in Prescribed Opex for regulatory "]
[null,"purposes.  This treatment is consistent with the basis applied for the Prescribed Opex allowance in TransGrid's Transmission Determination for 2018 to 2023."]
[null,"The $832k adjustment for 'Other controllable costs' comprised the prescribed operating lease payments made for the year ended 30 June 2020."]

{"sheet":"PTS PriceRedn","index":7,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,9,4,10],[1,0,1,3],[4,0,4,3]]}
[]
["PRICE REDUCTION/RECOVERY - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
[null,"$Customer TUOS","$Common service"]
[null,"general charges","charges"]
["Reduction in prices payable"]
["       by transmission customers"]
[]
[]
[]
[]
[]
[]
["*Recovery of  above reduction in prices"]
["     from other transmission customers"]
[]
[]
[]
[]
[]
[]
["Note:"]
["Each instance of a price reduction/recovery should be detailed."]
["*The amount of any reduction in a transmission customer's Customer TUOS non-locational charges "]
["and/or common service charges recovered from other transmission customers under clause 6A.26.1"]
["of the Rules. "]

{"sheet":"PTS PDisc","index":8,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5],[21,1,21,2],[21,3,21,5],[11,3,11,5],[13,3,13,5],[14,3,14,5],[12,3,12,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5]]}
[]
["PRUDENT DISCOUNTS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
[]
[]
[]
[null,"Number of discounts recovered in previous year"]
["For each discount recovered:"]
[null,"Date of AER approval, if given"]
[null,"Expiry date"]
[null,"Party receiving the discount"]
[null,"Beneficiary of discount"]
[null,"Amount of discount offered in previous year"]
[null,"Amount recovered from the other custumers in previous year"]
[null,"Load subject to discount (max, min, average)"]
["For each discount approved by the AER:"]
[null,"Compliance with conditions - for each condition imposed provide information demonstrating that the condition has been met."]

{"sheet":"DISAGG ProvSum","index":9,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,6],[4,0,4,6],[4,8,4,9],[32,0,32,7]]}
[]
["SUMMARY OF PROVISIONS"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
[null,null,null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Amount set aside to provisions",null,40630]
[]
[null,"Expenditure incurred debited to provisions",null,-20805]
[]
[null,"Net movement in provisions",null,19825]
[]
[null,"Balance at start of period",null,116905]
[]
[null,"Balance at end of period",null,136730]
[]
[]
["Comprising:"]
[]
[null,"Current provisions",null,69204]
[null,"Non-current provision",null,67526]
[]
[null,null,"Total per balance sheet",136730]
[]
[]
["Note:"]
["The basis of attribution of provisions to the Prescribed Services Segment, should follow the attribution of the "]
["expenses to which they relate. Taxation, interest and dividend provisions should be attributed  to the Not Allocated Segment."]
[]
["All non-regulated and negotiated provisions are deemed Current Provisions based on the fact that all employees are engaged by prescribed services segment "]
["and oncosts for those who work partially on non-prescribed projects are allocated back to non-presribed services segment based on labour time."]
[]
["The amounts included under Not Allocated relate to Contingent Projects and are deemed Current Provisions until such time as the relevant Contingent Project"]
["is approved by the AER.  Once the AER provides the Contingent Project Approval, the relevant provision amounts relating to the Contingent Project will be treated "]
["as part of the 'Prescribed Transmission Services' provisions."]

{"sheet":"INF RelPartTrans","index":10,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,1,4],[42,0,42,4],[4,0,4,4],[21,0,21,4]]}
[]
["RELATED PARTY TRANSACTIONS"]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
["Details of related party","Description of transaction","Prescribed","Procurement process","Monetary value of transaction"]
[null,null,null,null,"$'000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Balances with related parties at regulatory accounting date"]
[null,null,null,null,"$'000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Commitments with related parties at regulatory accounting period"]
["Value of commitments with related parties that are expected to result in related party transactions in future regulatory accounting periods:"]
[null,null,"Recognised as liabilities","Not recognised as liabilities","Total"]
[null,null,"$'000","$'000","$'000"]
[]
[null,"Payable:"]
[null,"Not later than one year"]
[null,"Later than one year and not later than five years"]
[null,"Later than five years"]
[null,"Total commitments"]

{"sheet":"INF RevRec","index":11,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5]]}
[]
["REVENUE RECONCILIATION "]
[]
[]
[]
[]
["for the period ended: 30 June 2020"]
[]
[null,"Description",null,"Unit type","Unit"]
[]
[]
[null,"CPI (March Tx)",null,"CPI – All Groups Weighted Average of 8 \nCapital Cities (ABS)",112.1,"December 2017 CPI"]
[null,"CPI (March Tx+1)",null,"As above",114.1,"December 2018 CPI"]
[null,"Change in CPI",null,"Per cent",1.7999999999999999E-2]
[null,"X-factor",null,"Per cent",-9.7000000000000003E-3,"Updated X-factor for 2019/20 as per the AER's 'Updated return on debt for 2019-20 network prices' letter."]
[null,"AR (Tx) 2018/19",null,734275785.41999996,null,"As per AER's Final Decision on TransGrid's Transmission Determination 2018 to 2023;\nPublished PTRM [D18-55349 AER - Final decision TransGrid - Post-tax revenue model - May 2018]."]
[null,"AR 2019/20",null,754731282.88999999,null,"Escalated using updated CPI and X-factor as per AER's published PTRM."]
[null,"AER FY14 to FY18 CPI adjustment",null,-10800000,null,"On 16 May 2018, the AER advised by letter a revocation and substitution of TransGrid’s transmission determination for the 2014-18 regulatory period. The AER has also advised that the adjustments to the 2017/18 MAR from this change are to be included in the transmission price calculations for FY2019/20.  "]
[null,"Net AR (Tx+1) (Adjusted MAR 2019/20)",null,743931282.88999999]
[null,"S-factor (Tx) 2018",null,16626168,null,"Incentive payment for 2018 Calendar Year"]
[null,"Prescribed Revenue Tx+1 (2019/20)",null,760557450.88999999]

{"sheet":"Hist Capex by Asset Class ","index":12,"n_rows":115,"n_cols":12,"rows_kept":115,"cut":false,"hidden":false,"merged":[[103,1,103,2],[104,1,104,2],[48,1,48,2],[49,1,49,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[66,0,66,2],[59,0,59,11],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[1,1,1,15],[16,1,16,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[11,0,11,11],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[27,1,27,2],[12,0,12,2],[13,0,13,2],[14,1,14,2],[15,1,15,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[37,0,37,11],[33,0,33,11],[38,0,38,2],[39,0,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[65,0,65,11],[67,0,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[78,1,78,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[93,0,93,2],[94,0,94,2],[87,0,87,11],[92,0,92,11],[86,0,86,12],[114,0,114,11],[95,1,95,2],[96,1,96,2],[97,1,97,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[98,1,98,2],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2]]}
[]
[null,"HISTORIC CAPEX by asset class"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Actual Gross Capital Expenditure – As Incurred ($m Nominal)"]
[null,null,null,"Year"," Year-1","Year 1 ","Year 2","Year 3","Year 4","Year 5"]
["Asset Class"]
[null,"Transmission Lines (2014-18)",null,null,88.217805303976775]
[null,"Underground Cables (2014-18)",null,null,6.702369984108629E-2]
[null,"Substations (2014-18)",null,null,86.27923169620135]
[null,"Secondary Systems (2014-18)",null,null,8.4982627718969557]
[null,"Communications (short life) (2014-18)",null,null,12.981383322975848]
[null,"Business IT (2014-18)",null,null,20.868590631645628]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2014-18)",null,null,9.9947586690407189]
[null,"Transmission Line Life Extension (2014-18)",null,null,2.3376247631291176]
[null,"Transmission Lines (2019-23)",null,null,null,57.588070130762191,26.361566585267326]
[null,"Underground Cables (2019-23)",null,null,null,0,0]
[null,"Substations (2019-23)",null,null,null,88.811824612353092,101.94400353383558]
[null,"Secondary Systems (2019-23)",null,null,null,15.340253553146674,36.19714209605975]
[null,"Communications (short life) (2019-23)",null,null,null,10.794685057914558,18.831327742517896]
[null,"Business IT (2019-23)",null,null,null,20.22340472226815,19.150368427728104]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2019-23)",null,null,null,9.943557204102607,9.8882701557943324]
[null,"Transmission Line Life Extension (2019-23)",null,null,null,8.777595297925922,83.774104461642523]
[null,"Land and Easements ",null,null,-0.27537111253705199,0.32226393002370535,0.10328026673721274,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",228.96930974617044,211.80165450849691,296.25006326958271,0,0,0,508.05171777807959,737.02102752425003]
[]
["Notes: \n - Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual capex is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n - Capex should be adjusted for any movements in capitalised provisions and be net of customer contributions. Where relevant please note the amount of any customer contributions excluded. \n- TNSPs are to update capex as incurred for previous years of the regulatory control period to reflect any movements that may have occurred (e.g. due to the final commissioning of assets). When this information is updated TNSPs must also note the reason for the movement.\n- Where capex related to Network Capability Incentive Parameter Action Plan (NCIPAP) projects has been incurred and reported across asset classes, the total amount for each project should be noted.\n- The Year 1 capex as incurred for Substations 2019-23 has been restated to include $1.64 million (nominal dollars) of capital expenditure in FY19 for the QNI Minor Upgrade project.  This project was approved by the AER on 28 April 2020.  The treatment of the FY19 capex for this project is consistent with how the project costs have been reflected in the AER’s Final Decision and revised PTRM for the approved project.  "]
[]
[]
[]
["Actual Asset Disposal – As Incurred ($m Nominal)**"]
[null,null,null,"Year","Year -1","Year 1 ","Year 2 ","Year 3","Year 4 ","Year 5"]
["Asset Class"]
[null,"Transmission Lines (2014-18)"]
[null,"Underground Cables (2014-18)"]
[null,"Substations (2014-18)"]
[null,"Secondary Systems (2014-18)"]
[null,"Communications (short life) (2014-18)"]
[null,"Business IT (2014-18)"]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2014-18)",null,null,4.6706901645454542]
[null,"Transmission Line Life Extension (2014-18)"]
[null,"Transmission Lines (2019-23)"]
[null,"Underground Cables (2019-23)"]
[null,"Substations (2019-23)"]
[null,"Secondary Systems (2019-23)"]
[null,"Communications (short life) (2019-23)"]
[null,"Business IT (2019-23)",null,null,null,9.6229499999999999E-3]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2019-23)",null,null,null,3.3192891327272731,2.1376767972727273]
[null,"Transmission Line Life Extension (2019-23)"]
[null,"Land and Easements ",null,null,0.82630086000000003,0.85253604999999988,2.7393439999999998E-2,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",5.4969910245454541,4.1814481327272723,2.1650702372727273,0,0,0,6.3465183700000001,11.843509394545455]
["** Net Proceeds from disposal"]
["Notes: \n- Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual disposal is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n"]
[]
[]
[]
[]
[]
["Actual Gross Capital Expenditure – As Commissioned ($m Nominal)*"]
[null,null,null,"Year"," Year -1","Year 1","Year 2","Year 3","Year 4 ","Year 5"]
["Asset Class"]
[null,"Transmission Lines (2014-18)",null,null,56.454817350837203]
[null,"Underground Cables (2014-18)",null,null,6.702369984108629E-2]
[null,"Substations (2014-18)",null,null,126.56203677738846]
[null,"Secondary Systems (2014-18)",null,null,10.821491152245191]
[null,"Communications (short life) (2014-18)",null,null,2.8390149453798652]
[null,"Business IT (2014-18)",null,null,16.027991553031114]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2014-18)",null,null,9.8931140548340846]
[null,"Transmission Line Life Extension (2014-18)",null,null,2.4660003877331755]
[null,"Transmission Lines (2019-23)",null,null,null,87.014169359785555,27.309297130367472]
[null,"Underground Cables (2019-23)",null,null,null,0,0]
[null,"Substations (2019-23)",null,null,null,103.2650855449956,77.23402663002166]
[null,"Secondary Systems (2019-23)",null,null,null,16.528220974459106,29.913803931734069]
[null,"Communications (short life) (2019-23)",null,null,null,12.138080019170168,5.3973224798546831]
[null,"Business IT (2019-23)",null,null,null,18.672804498378834,16.451320556133862]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2019-23)",null,null,null,9.943557204102607,9.8882701557943324]
[null,"Transmission Line Life Extension (2019-23)",null,null,null,8.7814925084807651,41.48000570845803]
[null,"Land and Easements ",null,null,0.65534164871942291,1.9641749632084569,3.4177036524588593,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",225.78683157000961,258.30758507258111,211.091750244823,0,0,0,469.39933531740411,695.18616688741372]
["* As Commissioned ($m Nominal) is calculated as the total project costs as-incurred in each year inflated to the dollars of the commissioning year using CPI. This is necessary to ensure the full project amount in the RAB is depreciated in line with methodology for calculating the RAB."]
["Notes: \n - Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual capex is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n -  Capex should be adjusted for any movements in capitalised provisions and be net of customer contributions. Where relevant please note the amount of any customer contributions excluded.\n- Where capex related to Network Capability Incentive Parameter Action Plan (NCIPAP) projects has been incurred and reported across asset classes, the total amount for each project should be noted.\n "]
[]
[]
[]
[]
["Actual Asset Disposal – As De-Commissioned ($m Nominal)**"]
[null,null,null,"Year"," Year -1","Year 1 ","Year 2 ","Year 3","Year 4 ","Year 5"]
["Asset Class"]
[null,"Transmission Lines (2014-18)",null,null,0,0,0]
[null,"Underground Cables (2014-18)",null,null,0,0,0]
[null,"Substations (2014-18)",null,null,0,0,0]
[null,"Secondary Systems (2014-18)",null,null,0,0,0]
[null,"Communications (short life) (2014-18)",null,null,0,0,0]
[null,"Business IT (2014-18)",null,null,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2014-18)",null,null,4.6706901645454542,0,0]
[null,"Transmission Line Life Extension (2014-18)",null,null,0,0,0]
[null,"Transmission Lines (2019-23)",null,null,0,0,0]
[null,"Underground Cables (2019-23)",null,null,null,null,0]
[null,"Substations (2019-23)",null,null,0,0,0]
[null,"Secondary Systems (2019-23)",null,null,0,0,0]
[null,"Communications (short life) (2019-23)",null,null,0,0,0]
[null,"Business IT (2019-23)",null,null,0,9.6229499999999999E-3,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant (2019-23)",null,null,0,3.3192891327272731,2.1376767972727273]
[null,"Transmission Line Life Extension (2019-23)",null,null,0,0,0]
[null,"Land and Easements ",null,null,0.82630086000000003,0.85253604999999988,2.7393439999999998E-2,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",5.4969910245454541,4.1814481327272723,2.1650702372727273,0,0,0,6.3465183700000001,11.843509394545455]
["** Net Proceeds from disposal"]
["Notes: \n- Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual disposal is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n"]

{"sheet":"NCIPAP","index":13,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,5,2],[46,0,46,2],[63,0,63,2],[65,0,65,2]]}
[]
["HISTORIC CAPEX by asset class"]
[]
["for the year ended 30 June 2020"]
[]
["NCIPAP - As-incurred Capex"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NCIPAP - As-commissioned Capex*"]

{"sheet":"Hist Capex - Non-Network","index":14,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,15],[10,4,11,4],[10,8,11,10],[14,5,15,11]]}
[]
[null,"HISTORIC CAPEX - NON-NETWORK- by project"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$M nominal"]
[null,null,null,null,null,"Yearly expenditure by project (inclusive of FDC)"]
[]
["Project ID","Project Description"," Commissioning Date","Category^",null,"Any Part Year","Year 1","Year 2","Year 3","Year 4","Year 5","TOTAL",null,"REASON FOR PROJECT","Reg Test / Business Case (Y/N)","Reg Test / Business Case Cost Estimate*","Reason for Variance from Cost Estimate / Expected Commissioning Date"]