{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Index","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":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy 2024-29 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":"Input | General","index":1,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"$D$6&\" \"&$D$8&\" \"&D7&\" - \"&\"Capital expenditure sharing scheme model\"","v":"Essential Energy 2024-29 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","Essential Energy"]
[null,null,"Determination stage","Final Decision"]
[null,null,"Determination years","2024-29"]
[null,null,"Base regulatory year","2024-25"]
[]
[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":"2019–20"},"2020–21","2021–22",{"$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":"2022–23"},{"$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":"2023–24"}]
[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":"2024-25"},{"$f":"IF(LEN(D18)>4,CONCATENATE(LEFT(D18,4)+1&\"–\"&IF(RIGHT(D18,2)+1>9,\"\",\"0\")&RIGHT(D18,2)+1),D18+1)","v":"2025–26"},{"$f":"IF(LEN(E18)>4,CONCATENATE(LEFT(E18,4)+1&\"–\"&IF(RIGHT(E18,2)+1>9,\"\",\"0\")&RIGHT(E18,2)+1),E18+1)","v":"2026–27"},"2027–28","2028–29"]
[]
[]
[null,"End"]

{"sheet":"Input | Inflation and Disc Rate","index":2,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy 2024-29 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,"Key:","Input","Internal Link","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":"2018–19"},{"$f":"'Input | General'!D13","v":"2019–20"},{"$f":"'Input | General'!E13","v":"2020–21"},{"$f":"'Input | General'!F13","v":"2021–22"},{"$f":"'Input | General'!G13","v":"2022–23"},{"$f":"'Input | General'!H13","v":"2023–24"},{"$f":"'Input | General'!D18","v":"2024-25"},{"$f":"'Input | General'!E18","v":"2025–26"},{"$f":"'Input | General'!F18","v":"2026–27"},{"$f":"'Input | General'!G18","v":"2027–28"},{"$f":"'Input | General'!H18","v":"2028–29"}]
[null,null,"Actual CPI Inflation Rate","DNSP","Per cent",null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.1000000000000002E-2]
[null,null,"Forecast CPI Inflation Rate","DNSP","Per cent",null,null,null,null,null,null,2.7997811278454687E-2,{"$f":"L9","v":2.7997811278454687E-2},2.7997811278454687E-2,2.7997811278454687E-2,2.7997811278454687E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2018–19)"},"DNSP","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0184049079754602},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0271691498685365},{"$f":"IF(I7<>\"\",(H10*(1+I8)),\"\")","v":1.0631025416301489},{"$f":"IF(J7<>\"\",(I10*(1+J8)),\"\")","v":1.1463628396143735},{"$f":"IF(K7<>\"\",(J10*(1+K8)),\"\")","v":1.1933637160385626},{"$f":"IF(L7<>\"\",(K10*(1+L9)),\"\")","v":1.2267752881467657},1.2611223111453707,1.2964309756118673,1.3327282054025913,1.3700416781829265]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,null,2.6597593508804751E-2,{"$f":"L14","v":2.6597593508804751E-2},2.6597593508804751E-2,2.6597593508804751E-2,2.6597593508804751E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2018–19)"},"AER","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.0184049079754602},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0271691498685365},{"$f":"IF(I7<>\"\",(H15*(1+I13)),\"\")","v":1.0631025416301489},{"$f":"IF(J7<>\"\",(I15*(1+J13)),\"\")","v":1.1463628396143735},{"$f":"IF(K7<>\"\",(J15*(1+K13)),\"\")","v":1.1928133216476775},{"$f":"IF(L7<>\"\",(K15*(1+L14)),\"\")","v":1.2245392855087496},1.2571090836602734,1.2905451600636955,1.3248705556358249,1.3601089241264108]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",null,{"$f":"G7","v":"2019–20"},{"$f":"H7","v":"2020–21"},"2021–22","2022–23","2023–24","2024-25","2025–26","2026–27","2027–28","2028–29"]
[null,null,"Real Vanilla WACC","AER","Per cent",null,3.2529897471437197E-2,3.0527897231024559E-2,2.8199847821049673E-2,2.6199183252718861E-2,2.5987255679290389E-2]
[null,null,"Forecast Real Vanilla WACC","AER","Per cent",null,null,null,null,null,null,3.1744391743969126E-2,3.2216902777486921E-2,3.2944718000490661E-2,3.3698827817555975E-2,3.458409821649968E-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":5.1533515216310333E-2},{"$f":"IF(AND(H13<>\"\",H20<>\"\"),((1+H20)*(1+H13)-1),\"\")","v":3.9396467775181465E-2},{"$f":"IF(AND(I13<>\"\",I20<>\"\"),((1+I20)*(1+I13)-1),\"\")","v":6.4169296422297961E-2},{"$f":"IF(AND(J13<>\"\",J20<>\"\"),((1+J20)*(1+J13)-1),\"\")","v":0.10656927592296483},{"$f":"IF(AND(K13<>\"\",K20<>\"\"),((1+K20)*(1+K13)-1),\"\")","v":6.7560133776386921E-2},{"$f":"IF(AND(L14<>\"\",L21<>\"\"),((1+L21)*(1+L14)-1),\"\")","v":5.9186309680564042E-2},5.9671388370480027E-2,6.0418561726934605E-2,6.1192729050375316E-2,6.2101545511535461E-2]
[]
[null,"End"]

{"sheet":"Input | Reported Capex","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy 2024-29 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link","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":"2019–20"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2020–21"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2022–23"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2023–24"}]
[]
[null,null,"Total capex allowance","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2018–19"},null,630.24692282755154,509.96298388665554,524.20584639478625,493.33568537240893,477.441414679758]
[null,null,"Customer Contributions","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2018–19"},null,89.704585249134524,89.490377460426515,89.371265388607213,89.308328182299618,89.293564878038694]
[null,null,"Asset Disposals","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2018–19"},null,5.1453257363461296,5.3057416200706413,6.2792177262394295,8.0216658212559651,6.8243244903592952]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2018–19"},null,{"$f":"IF(H6=\"\", \"\", H8-H9-H10)","v":535.39701184207092},{"$f":"IF(I6=\"\", \"\", I8-I9-I10)","v":415.1668648061584},428.55536327993963,396.00569136885338,381.32352531136002]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"H6","v":"2019–20"},{"$f":"I6","v":"2020–21"},"2021–22","2022–23","2023–24"]
[]
[null,null,"Total capex","AER","$millions","nominal",null,550.80912629886643,501.0999856821831,574.79164747163941,707.57770121470003,749.04237836266941]
[null,null,"Customer Contributions","AER","$millions","nominal",null,79.501779899999988,92.853393999999994,141.794184,205.67101718470002,201.91921953791919]
[null,null,"Asset Disposals","AER","$millions","nominal",null,2.9546770000000002,3.7272509999999999,2.394703986662396,4.8539067500000002,3.6480005728078222]
[null,null,"Other excludable capex","AER","$millions","nominal",null,0,0,0,0,0]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H16=\"\", \"\", H18-H19-H20-H21)","v":468.35266939886645},{"$f":"IF(I16=\"\", \"\", I18-I19-I20-I21)","v":404.5193406821831},430.60275948497701,497.05277727999999,543.47515825194239]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D18","v":"2024-25"},{"$f":"'Input | General'!E18","v":"2025–26"},{"$f":"'Input | General'!F18","v":"2026–27"},{"$f":"'Input | General'!G18","v":"2027–28"},{"$f":"'Input | General'!H18","v":"2028–29"}]
[]
[null,null,"Capex deferred and re-proposed","DNSP","$millions","nominal",null,0,20.844643221385535,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2018–19"},null,{"$f":"IF(H29<>\"\",H29/('Input | Inflation and Disc Rate'!K10*(1+'Input | Inflation and Disc Rate'!L9)^0.5),\"\")","v":0},{"$f":"IF(I29<>\"\",I29/('Input | Inflation and Disc Rate'!L10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":16.758430862641088},{"$f":"IF(J29<>\"\",J29/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(K29<>\"\",K29/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0},{"$f":"IF(L29<>\"\",L29/('Input | Inflation and Disc Rate'!O10*(1+'Input | Inflation and Disc Rate'!P9)^0.5),\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","AER","$millions","nominal",null,{"$f":"IF(H29<>\"\",H30*'Input | Inflation and Disc Rate'!K15*(1+'Input | Inflation and Disc Rate'!L14)^0.5,\"\")","v":0},{"$f":"IF(I29<>\"\",I30*'Input | Inflation and Disc Rate'!L15*(1+'Input | Inflation and Disc Rate'!M14)^0.5,\"\")","v":20.792475366275998},{"$f":"IF(J29<>\"\",J30*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(K29<>\"\",K30*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0},{"$f":"IF(L29<>\"\",L30*'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":4,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy 2024-29 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[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":"2019–20"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2020–21"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2022–23"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2023–24"}]
[null,null,"Discount rate (Real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G20","v":3.2529897471437197E-2},{"$f":"'Input | Inflation and Disc Rate'!H20","v":3.0527897231024559E-2},{"$f":"'Input | Inflation and Disc Rate'!I20","v":2.8199847821049673E-2},{"$f":"'Input | Inflation and Disc Rate'!J20","v":2.6199183252718861E-2},{"$f":"'Input | Inflation and Disc Rate'!K20","v":2.5987255679290389E-2}]
[null,null,"Discount rate (Nominal, fixed real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G22","v":5.1533515216310333E-2},{"$f":"'Input | Inflation and Disc Rate'!H22","v":3.9396467775181465E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":6.4169296422297961E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":0.10656927592296483},{"$f":"'Input | Inflation and Disc Rate'!K22","v":6.7560133776386921E-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":554.04845031342973},{"$f":"'Input | Reported Capex'!I$12*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":432.90692012597344},{"$f":"'Input | Reported Capex'!J$12*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":461.97753650273631},{"$f":"'Input | Reported Capex'!K$12*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":459.87453269374419},{"$f":"'Input | Reported Capex'!L$12*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":460.71999762618623}]
[null,null,"Actual capex",{"$f":"'Input | Reported Capex'!H23*(1+D$9)^0.5","v":480.26900495277209},{"$f":"'Input | Reported Capex'!I23*(1+E$9)^0.5","v":412.41068527430025},{"$f":"'Input | Reported Capex'!J23*(1+F$9)^0.5","v":444.20369915080431},{"$f":"'Input | Reported Capex'!K23*(1+G$9)^0.5","v":522.86769326948763},{"$f":"'Input | Reported Capex'!L23*(1+H$9)^0.5","v":561.53375969769036}]
[null,null,"Underspend",{"$f":"(D10-D11)","v":73.779445360657633},{"$f":"(E10-E11)","v":20.496234851673194},{"$f":"(F10-F11)","v":17.773837351932002},-62.993160575743445,-100.81376207150413]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*$E$8","v":2.2523313257321478},{"$f":"$D$12*$F$8*(1+'Input | Inflation and Disc Rate'!H13)","v":2.098474201470411},{"$f":"$D$12*$G$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)","v":2.0177985773374654},{"$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":2.1582284906079585}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$12*F$8","v":0.57799070372167871},{"$f":"$E$12*G$8*(1+'Input | Inflation and Disc Rate'!I13)","v":0.55576991076024351},{"$f":"$E$12*H$8*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":0.59444905408157311}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$12*G$8","v":0.46566002188728584},{"$f":"$F$12*$H$8*(1+'Input | Inflation and Disc Rate'!J13)","v":0.4980679129531298}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"$G$12*$H$8","v":-1.6370193699284403}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",{"$f":"SUM(D13:D17)","v":0},{"$f":"SUM(E13:E17)","v":2.2523313257321478},{"$f":"SUM(F13:F17)","v":2.6764649051920895},3.0392285099849947,1.613726087714221]
[null,null,"Discount factor (end of year)",{"$f":"E19*(1+E$9)","v":1.3066609620428389},{"$f":"F19*(1+F$9)","v":1.2571343106829433},{"$f":"G19*(1+G$9)","v":1.1813292442371599},{"$f":"H19*(1+H$9)","v":1.0675601337763869},1]
[null,null,"NPV underspend",{"$f":"D12*D19","v":96.404721053943973},{"$f":"E12*E19","v":25.7665200718539},{"$f":"F12*F19","v":20.996753846152036},-67.248986931238093,-100.81376207150413]
[null,null,"NPV financing benefit",{"$f":"D18*D19","v":0},{"$f":"E18*E19","v":2.8314829886038835},{"$f":"F18*F19","v":3.1617862636778531},3.2445591946965902,1.613726087714221]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$18","v":"2024-25"},{"$f":"'Input | General'!$E$18","v":"2025–26"},{"$f":"'Input | General'!$F$18","v":"2026–27"},{"$f":"'Input | General'!$G$18","v":"2027–28"},{"$f":"'Input | General'!$H$18","v":"2028–29"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!L$22","v":5.9186309680564042E-2},{"$f":"'Input | Inflation and Disc Rate'!M$22","v":5.9671388370480027E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":6.0418561726934605E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":6.1192729050375316E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":6.2101545511535461E-2}]
[null,null,"Increase in forecast capex in regulatory period 2 attributable to capex deferred in regulatory period 1",{"$f":"'Input | Reported Capex'!H31","v":0},{"$f":"'Input | Reported Capex'!I31","v":20.792475366275998},{"$f":"'Input | Reported Capex'!J31","v":0},{"$f":"'Input | Reported Capex'!K31","v":0},{"$f":"'Input | Reported Capex'!L31","v":0}]
[null,null,"Discount factor (middle of year 5)",{"$f":"1/(1+D25)^(0.5)","v":0.97165887235947235},{"$f":"1/((1+E25)^(0.5)*(1+D25))","v":0.91715351976296478},{"$f":"1/((1+F25)^(0.5)*(1+E25)*(1+D25))","v":0.86520251339120036},{"$f":"1/((1+G25)^(0.5)*(1+F25)*(1+E25)*(1+D25))","v":0.81560894283764629},{"$f":"1/((1+H25)^(0.5)*(1+G25)*(1+F25)*(1+E25)*(1+D25))","v":0.76824868537531232}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D26*D27","v":0},{"$f":"E26*E27","v":19.069891966764771},0,0,{"$f":"H26*H27","v":0}]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D20:H20)-SUM(D28:H28)","v":-43.964645997557071}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D32)*D31","v":-30.775252198289948}]
[null,null,"NSP share",{"$f":"D32*D31","v":-13.189393799267121}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D21:H21)","v":10.851554534692548}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D34-D35","v":-24.040948333959669}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D18","v":"2024-25"},{"$f":"'Input | General'!E18","v":"2025–26"},{"$f":"'Input | General'!F18","v":"2026–27"},{"$f":"'Input | General'!G18","v":"2027–28"},{"$f":"'Input | General'!H18","v":"2028–29"}]
[null,null,"Discount factor",{"$f":"1/(1+'Input | Inflation and Disc Rate'!L21)","v":0.96923230986474163},{"$f":"D41/(1+'Input | Inflation and Disc Rate'!M21)","v":0.9389812424663202},{"$f":"E41/(1+'Input | Inflation and Disc Rate'!N21)","v":0.90903339365918912},{"$f":"F41/(1+'Input | Inflation and Disc Rate'!O21)","v":0.87939868866682136},{"$f":"G41/(1+'Input | Inflation and Disc Rate'!P21)","v":0.85000213146790127}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!$F$8,\" million)\")","v":"CESS Payment Per Year ($2023–24 million)"},{"$f":"D36/(SUM(D41:H41))","v":-5.2876205878709053},{"$f":"D42","v":-5.2876205878709053},{"$f":"E42","v":-5.2876205878709053},-5.2876205878709053,-5.2876205878709053]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$8,\" million)\")","v":"Total CESS Payment ($2023–24 million)"},{"$f":"SUM(D42:H42)","v":-26.438102939354525}]
[]
[]
[null,"End"]

{"sheet":"Output | Models","index":5,"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":"Essential Energy 2024-29 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'!D40","v":"2024-25"},{"$f":"'Calc | CESS Revenue Increments'!E40","v":"2025–26"},{"$f":"'Calc | CESS Revenue Increments'!F40","v":"2026–27"},{"$f":"'Calc | CESS Revenue Increments'!G40","v":"2027–28"},{"$f":"'Calc | CESS Revenue Increments'!H40","v":"2028–29"},"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":"2023–24"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D42","v":-5.2876205878709053},{"$f":"'Calc | CESS Revenue Increments'!E42","v":-5.2876205878709053},{"$f":"'Calc | CESS Revenue Increments'!F42","v":-5.2876205878709053},{"$f":"'Calc | CESS Revenue Increments'!G42","v":-5.2876205878709053},{"$f":"'Calc | CESS Revenue Increments'!H42","v":-5.2876205878709053},{"$f":"SUM(J8:N8)","v":-26.438102939354525}]
[]
[]
[null,"End"]