{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Index","Change Log","AER amendments","Input | General","Input | Inflation and Disc Rate","Input | Reported Capex","Calc | CESS Revenue Increments","Output | Models"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":3540,"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":"Index","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"}]
[null,"Index"]
[]
[null,null,"Model index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input | General","Inputs NSP name, regulatory years for the prior and forecast regulatory control period etc."]
[null,null,"Input | Inflation and Disc Rate","Inputs the inflation and discount rate"]
[null,null,"Input | Reported Capex","Inputs the reported capital expenditure from the prior regulatory control period as well as the AER's forecast etc."]
[null,null,"Calc | CESS Revenue Increments","Calculates the CESS payments from the prior regulatory control period"]
[null,null,"Output | Models","Outputs the CESS revenue increments needed as a post tax revenue model input"]
[]
[null,null,"End"]

{"sheet":"Change Log","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!B1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"}]
[null,"Change Log"]
[]
[null,"Model change log"]
[]
[null,null,"Starting model name ---->","AER – CESS model - draft decision - Jemena Electricity determination 2026-31"]
[]
[null,null,"Model changes to above model"]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Input | General'!$A$1)","v":"Input | General"},1,{"$f":"CellReference('Input | General'!D7)","v":"D7"},"Input",null,"Updated determination stage to 'revised proposal'"]
[null,null,{"$f":"SheetName('Input | General'!$A$1)","v":"Input | General"},{"$f":"+D12+1","v":2},{"$f":"CellReference('Input | General'!G15)","v":"G15"},"Input",null,"Updated label to 'actual'"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Input | Inflation and Disc Rate'!$A$1)","v":"Input | Inflation and Disc Rate"},{"$f":"+D13+1","v":3},{"$f":"CellReference('Input | Inflation and Disc Rate'!K8)","v":"K8"},"Input",null,"Updated to actual CPI "]
[null,null,{"$f":"SheetName('Input | Inflation and Disc Rate'!$A$1)","v":"Input | Inflation and Disc Rate"},{"$f":"+D18+1","v":4},{"$f":"CellReference('Input | Inflation and Disc Rate'!L9:P9)","v":"L9:P9"},"Input",null,"Updated inflation forecast to align with PTRM"]
[null,null,{"$f":"SheetName('Input | Inflation and Disc Rate'!$A$1)","v":"Input | Inflation and Disc Rate"},{"$f":"+D19+1","v":5},{"$f":"CellReference('Input | Inflation and Disc Rate'!L14:P14)","v":"L14:P14"},"Input",null,"Updated inflation forecast to align with PTRM"]
[null,null,{"$f":"SheetName('Input | Inflation and Disc Rate'!$A$1)","v":"Input | Inflation and Disc Rate"},{"$f":"+D20+1","v":6},{"$f":"CellReference('Input | Inflation and Disc Rate'!L21:P21)","v":"L21:P21"},"Input",null,"Updated WACC to align with PTRM"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Input | Reported Capex'!$A$1)","v":"Input | Reported Capex"},{"$f":"+D21+1","v":7},{"$f":"CellReference('Input | Reported Capex'!K8:K20)","v":"K8:K20"},"Input",null,"Updated for FY25 audited actuals"]
[null,null,{"$f":"SheetName('Input | Reported Capex'!$A$1)","v":"Input | Reported Capex"},{"$f":"+D26+1","v":8},{"$f":"CellReference('Input | Reported Capex'!L8:L20)","v":"L8:L20"},"Input",null,"Updated for FY26 forecast"]
[null,null,{"$f":"SheetName('Input | Reported Capex'!$A$1)","v":"Input | Reported Capex"},{"$f":"+D27+1","v":9},{"$f":"CellReference('Input | Reported Capex'!H19:J19)","v":"H19:J19"},"Input",null,"Updated for change of treatment from 'as commissioned' to 'as incurred'"]
[]
[null,"End"]

{"sheet":"AER amendments","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["#","Sheet","Reference","Notes"]
[1,"Input | General","D7","Set up data validation and changed project stage to draft decision"]
[2,"Input | Inflation and Disc Rate","K13","Updated estimated CPI with actual"]
[3,"Input | Inflation and Disc Rate","L14","Updated forecast CPI for 2026-31 period"]
[4,"Input | Inflation and Disc Rate","M14:P14","Amended formula to refer to the forecast CPI as at 2026-27"]
[5,"Input | Inflation and Disc Rate","L21:P21","Updated 26-31 real vanilla WACC"]
[6,"Input | Reported Capex","H18,J18","Unrounded actual capex"]
[]
["The AER's draft decision amendments are highlighted in green"]

{"sheet":"Input | General","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"$D$6&\" \"&$D$8&\" \"&D7&\" - \"&\"Capital expenditure sharing scheme model\"","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link or calculation","JEN - RP"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","Jemena Electricity"]
[null,null,"Determination stage","Final decision"]
[null,null,"Determination years","2027-31"]
[null,null,"Base regulatory year","2026-27"]
[]
[null,null,"Regulatory control period details"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS applied in (regulatory years)",{"$f":"IF(LEN(E13)>4,CONCATENATE(LEFT(E13,4)-1&\"–\"&IF(RIGHT(E13,2)=\"00\",\"99\",IF(RIGHT(E13,2)-1<10,\"0\",\"\")&RIGHT(E13,2)-1)),E13-1)","v":"2021–22"},{"$f":"IF(LEN(F13)>4,CONCATENATE(LEFT(F13,4)-1&\"–\"&IF(RIGHT(F13,2)=\"00\",\"99\",IF(RIGHT(F13,2)-1<10,\"0\",\"\")&RIGHT(F13,2)-1)),F13-1)","v":"2022–23"},{"$f":"IF(LEN(G13)>4,CONCATENATE(LEFT(G13,4)-1&\"–\"&IF(RIGHT(G13,2)=\"00\",\"99\",IF(RIGHT(G13,2)-1<10,\"0\",\"\")&RIGHT(G13,2)-1)),G13-1)","v":"2023–24"},{"$f":"IF(LEN(H13)>4,CONCATENATE(LEFT(H13,4)-1&\"–\"&IF(RIGHT(H13,2)=\"00\",\"99\",IF(RIGHT(H13,2)-1<10,\"0\",\"\")&RIGHT(H13,2)-1)),H13-1)","v":"2024–25"},{"$f":"IF(LEN(D9)>4,CONCATENATE(LEFT(D9,4)-1&\"–\"&IF(RIGHT(D9,2)=\"00\",\"99\",IF(RIGHT(D9,2)-1<10,\"0\",\"\")&RIGHT(D9,2)-1)),D9-1)","v":"2025–26"}]
[null,null,"CESS to apply to this year's expenditure (Yes/No)","Yes","Yes","Yes","Yes","Yes"]
[null,null,"Actual or estimate year","Actual","Actual","Actual","Actual","Estimate"]
[]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS revenue increment applied in (regulatory years)",{"$f":"D9","v":"2026-27"},{"$f":"IF(LEN(D18)>4,CONCATENATE(LEFT(D18,4)+1&\"–\"&IF(RIGHT(D18,2)+1>9,\"\",\"0\")&RIGHT(D18,2)+1),D18+1)","v":"2027–28"},{"$f":"IF(LEN(E18)>4,CONCATENATE(LEFT(E18,4)+1&\"–\"&IF(RIGHT(E18,2)+1>9,\"\",\"0\")&RIGHT(E18,2)+1),E18+1)","v":"2028–29"},{"$f":"IF(LEN(F18)>4,CONCATENATE(LEFT(F18,4)+1&\"–\"&IF(RIGHT(F18,2)+1>9,\"\",\"0\")&RIGHT(F18,2)+1),F18+1)","v":"2029–30"},{"$f":"IF(LEN(G18)>4,CONCATENATE(LEFT(G18,4)+1&\"–\"&IF(RIGHT(G18,2)+1>9,\"\",\"0\")&RIGHT(G18,2)+1),G18+1)","v":"2030–31"}]
[]
[]
[null,"End"]

{"sheet":"Input | Inflation and Disc Rate","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"},null,null,null,null,null,"Key:","Input","Internal Link or calculation","AER draft decision","JEN - RP","AER final decision"]
[null,null,"Input | Inflation and Discount rate"]
[]
[null,null,"Input | Inflation"]
[]
[null,null,null,"Source","Unit"]
[null,null,null,null,null,{"$f":"IF(LEN(G7)>4,CONCATENATE(LEFT(G7,4)-1&\"–\"&IF(RIGHT(G7,2)=\"00\",\"99\",IF(RIGHT(G7,2)-1<10,\"0\",\"\")&RIGHT(G7,2)-1)),G7-1)","v":"2020–21"},{"$f":"'Input | General'!D13","v":"2021–22"},{"$f":"'Input | General'!E13","v":"2022–23"},{"$f":"'Input | General'!F13","v":"2023–24"},{"$f":"'Input | General'!G13","v":"2024–25"},{"$f":"'Input | General'!H13","v":"2025–26"},{"$f":"'Input | General'!D18","v":"2026-27"},{"$f":"'Input | General'!E18","v":"2027–28"},{"$f":"'Input | General'!F18","v":"2028–29"},{"$f":"'Input | General'!G18","v":"2029–30"},{"$f":"'Input | General'!H18","v":"2030–31"}]
[null,null,"Actual CPI Inflation Rate","JEN","Per cent",null,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2,2.4246877296105973E-2]
[null,null,"Forecast CPI Inflation Rate","JEN","Per cent",null,null,null,null,null,null,{"$f":"[1]!f","v":2.6597593508804751E-2},{"$f":"+L9","v":2.6597593508804751E-2},{"$f":"+M9","v":2.6597593508804751E-2},2.6597593508804751E-2,2.6597593508804751E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2020–21)"},"JEN","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0086058519793459},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0438898450946643},{"$f":"IF(I7<>\"\",(H10*(1+I8)),\"\")","v":1.1256454388984509},{"$f":"IF(J7<>\"\",(I10*(1+J8)),\"\")","v":1.1712564543889843},{"$f":"IF(K7<>\"\",(J10*(1+K8)),\"\")","v":1.1996557659208262},{"$f":"IF(L7<>\"\",(K10*(1+L9)),\"\")","v":1.2315637223332823},{"$f":"IF(M7<>\"\",(L10*(1+M9)),\"\")","v":1.2643203536000933},{"$f":"IF(N7<>\"\",(M10*(1+N9)),\"\")","v":1.2979482324300569},{"$f":"IF(O7<>\"\",(N10*(1+O9)),\"\")","v":1.3324705319117032},{"$f":"IF(P7<>\"\",(O10*(1+P9)),\"\")","v":1.3679110414819515}]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2,2.4246877296105973E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,null,2.6198992109813357E-2,{"$f":"L14","v":2.6198992109813357E-2},{"$f":"M14","v":2.6198992109813357E-2},2.6198992109813357E-2,2.6198992109813357E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2020–21)"},"AER","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.0086058519793459},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0438898450946643},{"$f":"IF(I7<>\"\",(H15*(1+I13)),\"\")","v":1.1256454388984509},{"$f":"IF(J7<>\"\",(I15*(1+J13)),\"\")","v":1.1712564543889843},{"$f":"IF(K7<>\"\",(J15*(1+K13)),\"\")","v":1.1996557659208262},{"$f":"IF(L7<>\"\",(K15*(1+L14)),\"\")","v":1.2310855378666781},{"$f":"IF(M7<>\"\",(L15*(1+M14)),\"\")","v":1.2633387381597525},{"$f":"IF(N7<>\"\",(M15*(1+N14)),\"\")","v":1.2964369397928215},{"$f":"IF(O7<>\"\",(N15*(1+O14)),\"\")","v":1.3304022809493241},{"$f":"IF(P7<>\"\",(O15*(1+P14)),\"\")","v":1.365257479810793}]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",null,{"$f":"G7","v":"2021–22"},{"$f":"H7","v":"2022–23"},"2023–24","2024–25","2025–26","2026-27","2027–28","2028–29","2029–30","2030–31"]
[null,null,"Real Vanilla WACC","JEN","Per cent",null,{"$f":"'[2]RFM input'!H288","v":2.8504498758880059E-2},{"$f":"'[2]RFM input'!I288","v":2.7262194883109325E-2},{"$f":"'[2]RFM input'!J288","v":2.7897299349873395E-2},{"$f":"'[2]RFM input'!K288","v":2.8472802080846016E-2},{"$f":"'[2]RFM input'!L288","v":2.8671841661771946E-2}]
[null,null,"Forecast Real Vanilla WACC","AER","Per cent",null,null,null,null,null,null,3.4629108194738481E-2,3.526647973707555E-2,3.5877666502399833E-2,3.6783703792802401E-2,3.8359576701234799E-2]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND(G13<>\"\",G20<>\"\"),((1+G20)*(1+G13)-1),\"\")","v":3.7355656235290358E-2},{"$f":"IF(AND(H13<>\"\",H20<>\"\"),((1+H20)*(1+H13)-1),\"\")","v":6.3198841632432945E-2},{"$f":"IF(AND(I13<>\"\",I20<>\"\"),((1+I20)*(1+I13)-1),\"\")","v":0.10840038544899788},{"$f":"IF(AND(J13<>\"\",J20<>\"\"),((1+J20)*(1+J13)-1),\"\")","v":7.014639421409119E-2},{"$f":"IF(AND(K13<>\"\",K20<>\"\"),((1+K20)*(1+K13)-1),\"\")","v":5.3613921584504176E-2},{"$f":"IF(AND(L14<>\"\",L21<>\"\"),((1+L21)*(1+L14)-1),\"\")","v":6.1735348036915605E-2},{"$f":"IF(AND(M14<>\"\",M21<>\"\"),((1+M21)*(1+M14)-1),\"\")","v":6.2389418071261638E-2},{"$f":"IF(AND(N14<>\"\",N21<>\"\"),((1+N21)*(1+N14)-1),\"\")","v":6.3016617313828016E-2},{"$f":"IF(AND(O14<>\"\",O21<>\"\"),((1+O21)*(1+O14)-1),\"\")","v":6.3946391868053176E-2},{"$f":"IF(AND(P14<>\"\",P21<>\"\"),((1+P21)*(1+P14)-1),\"\")","v":6.5563551058379632E-2}]
[]
[null,"End"]

{"sheet":"Input | Reported Capex","index":5,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link or calculation","JEN - RP","AER draft decision","AER final decision"]
[null,"Input | Capex"]
[]
[null,"Input | Capex Allowance"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"IF('Input | General'!D14=\"Yes\",'Input | General'!D13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2022–23"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2023–24"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2024–25"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2025–26"}]
[]
[null,null,"Total capex allowance (includes customer contributions)","JEN","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,180.47612531130528,173.6283024252418,157.37076541279282,148.02600638785643,153.92612793840169]
[null,null,"Customer Contributions","JEN","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,26.190747100968711,26.592801619946645,27.468664070134999,27.349610336302437,26.275659146661422]
[null,null,"Asset Disposals","JEN","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,0.19061951563957624,6.920654008691976E-2,8.1966966186347384E-2,6.303310639010902E-2,8.8323300076591671E-2]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,{"$f":"IF(H6=\"\", \"\", H8-H9-H10)","v":154.09475869469699},{"$f":"IF(I6=\"\", \"\", I8-I9-I10)","v":146.96629426520823},{"$f":"IF(J6=\"\", \"\", J8-J9-J10)","v":129.82013437647149},{"$f":"IF(K6=\"\", \"\", K8-K9-K10)","v":120.61336294516389},{"$f":"IF(L6=\"\", \"\", L8-L9-L10)","v":127.56214549166367}]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"H6","v":"2021–22"},{"$f":"I6","v":"2022–23"},{"$f":"J6","v":"2023–24"},{"$f":"K6","v":"2024–25"},{"$f":"L6","v":"2025–26"}]
[]
[null,null,"Total capex (includes customer contributions)","JEN","$millions","nominal",null,{"$f":"'[2]RFM input'!$H$111-'[2]RFM input'!$H$110","v":180.18806389999997},{"$f":"'[2]RFM input'!I111","v":220.21209787000026},231.66824428999999,{"$f":"'[2]RFM input'!K111","v":324.14237891300206},{"$f":"'[2]RFM input'!L111","v":321.55105782448209}]
[null,null,"Customer Contributions","JEN","$millions","nominal",null,67.317804458227698,71.782318000000004,93.026370999999997,69.430447985916445,141.28489010341622]
[null,null,"Asset Disposals","JEN","$millions","nominal",null,{"$f":"'[2]RFM input'!H165","v":0.41294468000000006},{"$f":"'[2]RFM input'!I165","v":0.27738953000000005},{"$f":"'[2]RFM input'!J165","v":0.23260700000000001},{"$f":"'[2]RFM input'!K165","v":2.8764959999999999E-2},{"$f":"'[2]RFM input'!L165","v":0.3948404524627141}]
[null,null,"Other excludable capex","JEN","$millions","nominal"]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H16=\"\", \"\", H18-H19-H20-H21)","v":112.45731476177228},{"$f":"IF(I16=\"\", \"\", I18-I19-I20-I21)","v":148.15239034000027},{"$f":"IF(J16=\"\", \"\", J18-J19-J20-J21)","v":138.40926628999998},{"$f":"IF(K16=\"\", \"\", K18-K19-K20-K21)","v":254.68316596708564},{"$f":"IF(L16=\"\", \"\", L18-L19-L20-L21)","v":179.87132726860315}]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,{"$f":"H23/'Input | Inflation and Disc Rate'!G15","v":111.49778135936808},{"$f":"I23/'Input | Inflation and Disc Rate'!H15","v":141.92339453840091},{"$f":"J23/'Input | Inflation and Disc Rate'!I15","v":122.95991393652903},{"$f":"K23/'Input | Inflation and Disc Rate'!J15","v":217.44440768093577},{"$f":"L23/'Input | Inflation and Disc Rate'!K15","v":149.93578356249415}]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D18","v":"2026-27"},{"$f":"'Input | General'!E18","v":"2027–28"},{"$f":"'Input | General'!F18","v":"2028–29"},{"$f":"'Input | General'!G18","v":"2029–30"},{"$f":"'Input | General'!H18","v":"2030–31"}]
[]
[null,null,"Capex deferred and re-proposed","JEN","$millions","nominal",null,0,0,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2020–21"},null,{"$f":"IF(H30<>\"\",H30/('Input | Inflation and Disc Rate'!K10*(1+'Input | Inflation and Disc Rate'!L9)^0.5),\"\")","v":0},{"$f":"IF(I30<>\"\",I30/('Input | Inflation and Disc Rate'!L10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":0},{"$f":"IF(J30<>\"\",J30/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(K30<>\"\",K30/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0},{"$f":"IF(L30<>\"\",L30/('Input | Inflation and Disc Rate'!O10*(1+'Input | Inflation and Disc Rate'!P9)^0.5),\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","Calculated","$millions","nominal",null,{"$f":"IF(H30<>\"\",H31*'Input | Inflation and Disc Rate'!K15*(1+'Input | Inflation and Disc Rate'!L14)^0.5,\"\")","v":0},{"$f":"IF(I30<>\"\",I31*'Input | Inflation and Disc Rate'!L15*(1+'Input | Inflation and Disc Rate'!M14)^0.5,\"\")","v":0},{"$f":"IF(J30<>\"\",J31*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(K30<>\"\",K31*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0},{"$f":"IF(L30<>\"\",L31*'Input | Inflation and Disc Rate'!O15*(1+'Input | Inflation and Disc Rate'!P14)^0.5,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":6,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link or calculation"]
[null,"Input | CESS Payments"]
[]
[null,"Calc | NPV of CESS payments"]
[]
[null,null,"Regulatory period 1"]
[null,null,"Year",{"$f":"IF('Input | General'!D14=\"Yes\",'Input | General'!D13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2022–23"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2023–24"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2024–25"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2025–26"}]
[null,null,"Discount rate (Real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G20","v":2.8504498758880059E-2},{"$f":"'Input | Inflation and Disc Rate'!H20","v":2.7262194883109325E-2},{"$f":"'Input | Inflation and Disc Rate'!I20","v":2.7897299349873395E-2},{"$f":"'Input | Inflation and Disc Rate'!J20","v":2.8472802080846016E-2},{"$f":"'Input | Inflation and Disc Rate'!K20","v":2.8671841661771946E-2}]
[null,null,"Discount rate (Nominal, fixed real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G22","v":3.7355656235290358E-2},{"$f":"'Input | Inflation and Disc Rate'!H22","v":6.3198841632432945E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":0.10840038544899788},{"$f":"'Input | Inflation and Disc Rate'!J22","v":7.014639421409119E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":5.3613921584504176E-2}]
[null,null,"Capex allowance",{"$f":"'Input | Reported Capex'!H$12*'Input | Inflation and Disc Rate'!G$15*(1+'Input | Inflation and Disc Rate'!G$20)^0.5","v":157.62040843845728},{"$f":"'Input | Reported Capex'!I$12*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":155.49379718781901},{"$f":"'Input | Reported Capex'!J$12*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":148.15575731448936},{"$f":"'Input | Reported Capex'!K$12*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":143.26622891071835},{"$f":"'Input | Reported Capex'!L$12*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":155.208994977575}]
[null,null,"Actual capex",{"$f":"'Input | Reported Capex'!H23*(1+D$9)^0.5","v":114.53851520482131},{"$f":"'Input | Reported Capex'!I23*(1+E$9)^0.5","v":152.76220213961636},{"$f":"'Input | Reported Capex'!J23*(1+F$9)^0.5","v":145.71810020886846},{"$f":"'Input | Reported Capex'!K23*(1+G$9)^0.5","v":263.46433671792266},{"$f":"'Input | Reported Capex'!L23*(1+H$9)^0.5","v":184.63017848247819}]
[null,null,"Underspend",{"$f":"(D10-D11)","v":43.081893233635967},{"$f":"(E10-E11)","v":2.7315950482026494},{"$f":"(F10-F11)","v":2.4376571056209002},{"$f":"(G10-G11)","v":-120.19810780720431},{"$f":"(H10-H11)","v":-29.421183504903183}]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*$E$8","v":1.1745069692686927},{"$f":"$D$12*$F$8*(1+'Input | Inflation and Disc Rate'!H13)","v":1.2439133589205695},{"$f":"$D$12*$G$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)","v":1.3690052754750586},{"$f":"$D$12*$H$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":1.4344350325663495}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$12*F$8","v":7.6204124762341161E-2},{"$f":"$E$12*G$8*(1+'Input | Inflation and Disc Rate'!I13)","v":8.3867455932086513E-2},{"$f":"$E$12*H$8*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":8.787578765133193E-2}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$12*G$8","v":6.9406928309311847E-2},{"$f":"$F$12*$H$8*(1+'Input | Inflation and Disc Rate'!J13)","v":7.2724138652533535E-2}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"$G$12*$H$8","v":-3.4463011150927563}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",{"$f":"SUM(D13:D17)","v":0},{"$f":"SUM(E13:E17)","v":1.1745069692686927},{"$f":"SUM(F13:F17)","v":1.3201174836829106},{"$f":"SUM(G13:G17)","v":1.522279659716457},{"$f":"SUM(H13:H17)","v":-1.8512661562225414}]
[null,null,"Discount factor (end of year)",{"$f":"E19*(1+E$9)","v":1.3287272929692082},{"$f":"F19*(1+F$9)","v":1.2497448651553114},{"$f":"G19*(1+G$9)","v":1.1275211390774253},{"$f":"H19*(1+H$9)","v":1.0536139215845042},1]
[null,null,"NPV underspend",{"$f":"D12*D19","v":57.244087372317566},{"$f":"E12*E19","v":3.4137968851749365},{"$f":"F12*F19","v":2.7485099164098572},{"$f":"G12*G19","v":-126.64239973378554},{"$f":"H12*H19","v":-29.421183504903183}]
[null,null,"NPV financing benefit",{"$f":"D18*D19","v":0},{"$f":"E18*E19","v":1.4678340539326757},{"$f":"F18*F19","v":1.4884603689181799},{"$f":"G18*G19","v":1.6038950420221807},{"$f":"H18*H19","v":-1.8512661562225414}]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$18","v":"2026-27"},{"$f":"'Input | General'!$E$18","v":"2027–28"},{"$f":"'Input | General'!$F$18","v":"2028–29"},{"$f":"'Input | General'!$G$18","v":"2029–30"},{"$f":"'Input | General'!$H$18","v":"2030–31"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!L$22","v":6.1735348036915605E-2},{"$f":"'Input | Inflation and Disc Rate'!M$22","v":6.2389418071261638E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":6.3016617313828016E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":6.3946391868053176E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":6.5563551058379632E-2}]
[null,null,"Increase in forecast capex in regulatory period 2 attributable to capex deferred in regulatory period 1",{"$f":"'Input | Reported Capex'!H32","v":0},{"$f":"'Input | Reported Capex'!I32","v":0},{"$f":"'Input | Reported Capex'!J32","v":0},{"$f":"'Input | Reported Capex'!K32","v":0},{"$f":"'Input | Reported Capex'!L32","v":0}]
[null,null,"Discount factor (middle of year 5)",{"$f":"1/(1+D25)^(0.5)","v":0.97049178109064171},{"$f":"1/((1+E25)^(0.5)*(1+D25))","v":0.9137804356742929},{"$f":"1/((1+F25)^(0.5)*(1+E25)*(1+D25))","v":0.85986438379106278},{"$f":"1/((1+G25)^(0.5)*(1+F25)*(1+E25)*(1+D25))","v":0.80853730152747705},{"$f":"1/((1+H25)^(0.5)*(1+G25)*(1+F25)*(1+E25)*(1+D25))","v":0.7593648833178781}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D26*D27","v":0},{"$f":"E26*E27","v":0},{"$f":"F26*F27","v":0},{"$f":"G26*G27","v":0},{"$f":"H26*H27","v":0}]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Forecast capex",{"$f":"SUM('Input | Reported Capex'!H12:L12)","v":679.05669577320418}]
[null,null,"Actual capex",{"$f":"SUM('Input | Reported Capex'!H24:L24)","v":743.76128107772797}]
[null,null,"Underspend or Overspend, %",{"$f":"(D31-D32)/D31","v":-9.5285983787919609E-2}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D20:H20)-SUM(D28:H28)","v":-92.657189064786365}]
[null,null,"Consumer share",{"$f":"D35-D37","v":-64.860032345350461}]
[null,null,"NSP share",{"$f":"D34*D35","v":-27.797156719435907}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D21:H21)","v":2.7089233086504949}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D37-D38","v":-30.506080028086402}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D18","v":"2026-27"},{"$f":"'Input | General'!E18","v":"2027–28"},{"$f":"'Input | General'!F18","v":"2028–29"},{"$f":"'Input | General'!G18","v":"2029–30"},{"$f":"'Input | General'!H18","v":"2030–31"}]
[null,null,"Discount factor",{"$f":"1/(1+'Input | Inflation and Disc Rate'!L21)","v":0.96652993046449198},{"$f":"D44/(1+'Input | Inflation and Disc Rate'!M21)","v":0.93360496971751605},{"$f":"E44/(1+'Input | Inflation and Disc Rate'!N21)","v":0.90126952236531599},{"$f":"F44/(1+'Input | Inflation and Disc Rate'!O21)","v":0.86929368109110583},{"$f":"G44/(1+'Input | Inflation and Disc Rate'!P21)","v":0.83717981766274596}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!$F$8,\" million)\")","v":"CESS Payment Per Year ($2025–26 million)"},{"$f":"D39/(SUM(D44:H44))","v":-6.7672817588815661},{"$f":"D45","v":-6.7672817588815661},{"$f":"E45","v":-6.7672817588815661},{"$f":"F45","v":-6.7672817588815661},{"$f":"G45","v":-6.7672817588815661}]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$4,\" million)\")","v":"Total CESS Payment ($ million)"},{"$f":"SUM(D45:H45)","v":-33.836408794407831}]
[]
[]
[null,"End"]

{"sheet":"Output | Models","index":7,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,19]]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2027-31 Final decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Output | Models"]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,null,null,null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[null,null,"Revenue Adjustments","Source","Unit","Basis",null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D43","v":"2026-27"},{"$f":"'Calc | CESS Revenue Increments'!E43","v":"2027–28"},{"$f":"'Calc | CESS Revenue Increments'!F43","v":"2028–29"},{"$f":"'Calc | CESS Revenue Increments'!G43","v":"2029–30"},{"$f":"'Calc | CESS Revenue Increments'!H43","v":"2030–31"},"Total"]
[]
[null,null,"CESS increments as per NER 6A.5.4(a)(5)","Calc | CESS Revenue Increments","$millions",{"$f":"IF(LEN(J6)>4,CONCATENATE(LEFT(J6,4)-1&\"–\"&IF(RIGHT(J6,2)=\"00\",\"99\",IF(RIGHT(J6,2)-1<10,\"0\",\"\")&RIGHT(J6,2)-1)),J6-1)","v":"2025–26"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D45","v":-6.7672817588815661},{"$f":"'Calc | CESS Revenue Increments'!E45","v":-6.7672817588815661},{"$f":"'Calc | CESS Revenue Increments'!F45","v":-6.7672817588815661},{"$f":"'Calc | CESS Revenue Increments'!G45","v":-6.7672817588815661},{"$f":"'Calc | CESS Revenue Increments'!H45","v":-6.7672817588815661},{"$f":"SUM(J8:N8)","v":-33.836408794407831}]
[]
[]
[null,"End"]