{"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":0,"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 2022-26 True-Up for Previous Period - 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":"Jemena Electricity 2022-26 True-Up for Previous Period - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","Jemena Electricity"]
[null,null,"Determination stage","True-Up for Previous Period"]
[null,null,"Determination years","2022-26"]
[null,null,"Base regulatory year","2021-2022"]
[]
[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)","CY16","CY17","CY18","CY19","CY20"]
[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","Actual"]
[]
[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":"2021-2022"},{"$f":"IF(LEN(D18)>4,CONCATENATE(LEFT(D18,4)+1&\"–\"&IF(RIGHT(D18,2)+1>9,\"\",\"0\")&RIGHT(D18,2)+1),D18+1)","v":"2022–23"},{"$f":"IF(LEN(E18)>4,CONCATENATE(LEFT(E18,4)+1&\"–\"&IF(RIGHT(E18,2)+1>9,\"\",\"0\")&RIGHT(E18,2)+1),E18+1)","v":"2023–24"},{"$f":"IF(LEN(F18)>4,CONCATENATE(LEFT(F18,4)+1&\"–\"&IF(RIGHT(F18,2)+1>9,\"\",\"0\")&RIGHT(F18,2)+1),F18+1)","v":"2024–25"},{"$f":"IF(LEN(G18)>4,CONCATENATE(LEFT(G18,4)+1&\"–\"&IF(RIGHT(G18,2)+1>9,\"\",\"0\")&RIGHT(G18,2)+1),G18+1)","v":"2025–26"}]
[]
[]
[null,"End"]

{"sheet":"Input | Inflation and Disc Rate","index":2,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2022-26 True-Up for Previous Period - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,null,"Input | Inflation and Discount rate"]
[]
[null,null,"Input | Inflation"]
[]
[null,null,null,"Source","Unit"]
[null,null,null,null,null,"CY15",{"$f":"'Input | General'!D13","v":"CY16"},{"$f":"'Input | General'!E13","v":"CY17"},{"$f":"'Input | General'!F13","v":"CY18"},{"$f":"'Input | General'!G13","v":"CY19"},{"$f":"'Input | General'!H13","v":"CY20"},"HY21",{"$f":"'Input | General'!D18","v":"2021-2022"},{"$f":"'Input | General'!E18","v":"2022–23"},{"$f":"'Input | General'!F18","v":"2023–24"},{"$f":"'Input | General'!G18","v":"2024–25"},{"$f":"'Input | General'!H18","v":"2025–26"}]
[null,null,"Actual CPI Inflation Rate","JEN","Per cent",null,1.5037593984962294E-2,1.0232558139534831E-2,1.9337016574585641E-2,2.0776874435411097E-2,1.5929203539823078E-2,1.2195121951219523E-2]
[null,null,"Forecast CPI Inflation Rate","JEN","Per cent",null,null,null,null,null,null,null,2.3650000000000001E-2,2.3650000000000001E-2,2.3650000000000001E-2,2.3650000000000001E-2,2.3650000000000001E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year CY15)"},"JEN","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0150375939849623},1.025424025179227,1.0452526665500961,1.066969749956286,1.0839657282741739,1.09718482252142,{"$f":"IF(M7<>\"\",(L10*(1+M9)),\"\")","v":1.1231332435740515},{"$f":"IF(N7<>\"\",(M10*(1+N9)),\"\")","v":1.1496953447845777},{"$f":"IF(O7<>\"\",(N10*(1+O9)),\"\")","v":1.1768856396887328},{"$f":"IF(P7<>\"\",(O10*(1+P9)),\"\")","v":1.2047189850673714},{"$f":"IF(Q7<>\"\",(P10*(1+Q9)),\"\")","v":1.2332105890642147}]
[]
[]
[null,null,"Actual CPI Inflation Rate","JEN","Per cent",null,1.5108593012275601E-2,1.0232558139534831E-2,1.9337016574585641E-2,2.0776874435411097E-2,1.5929203539823078E-2,1.2195121951219523E-2]
[null,null,"Forecast CPI Inflation Rate","JEN","Per cent",null,null,null,null,null,null,null,1.9993872504847632E-2,1.9993872504847632E-2,1.9993872504847632E-2,1.9993872504847632E-2,1.9993872504847632E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year CY15)"},"JEN","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.0151085930122756},1.0254957507082152,1.0453257790368271,1.0670443814919734,1.0840415486307837,1.0972615675165249,{"$f":"IF(M7<>\"\",(L15*(1+M14)),\"\")","v":1.1192000754019196},{"$f":"IF(N7<>\"\",(M15*(1+N14)),\"\")","v":1.1415772190169213},{"$f":"IF(O7<>\"\",(N15*(1+O14)),\"\")","v":1.1644017683883843},{"$f":"IF(P7<>\"\",(O15*(1+P14)),\"\")","v":1.1876826688899607},{"$f":"IF(Q7<>\"\",(P15*(1+Q14)),\"\")","v":1.2114290447479636}]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",{"$f":"F7","v":"CY15"},{"$f":"G7","v":"CY16"},{"$f":"H7","v":"CY17"},"CY18","CY19","CY20",{"$f":"L7","v":"HY21"},"2021-2022","2022–23","2023–24","2024–25","2025–26"]
[null,null,"Real Vanilla WACC","JEN","Per cent",null,3.9328628706946089E-2,3.8730571453602369E-2,3.821466541215579E-2,3.7669116070430331E-2,3.6561951019833616E-2,1.2022316999911542E-2]
[null,null,"Forecast Real Vanilla WACC","JEN","Per cent",null,null,null,null,null,null,null,2.8504498758880059E-2,2.6413525074088631E-2,2.4322551389297196E-2,2.2231577704505769E-2,2.0140604019714337E-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.5031421964085947E-2},4.9359442417313604E-2,5.8290639605208527E-2,5.9228637000529716E-2,5.3073557319264664E-2,2.4364052573081274E-2,{"$f":"IF(AND(M14<>\"\",M21<>\"\"),((1+M21)*(1+M14)-1),\"\")","v":4.9068286577727216E-2},{"$f":"IF(AND(N14<>\"\",N21<>\"\"),((1+N21)*(1+N14)-1),\"\")","v":4.6935506231671198E-2},{"$f":"IF(AND(O14<>\"\",O21<>\"\"),((1+O21)*(1+O14)-1),\"\")","v":4.480272588561518E-2},{"$f":"IF(AND(P14<>\"\",P21<>\"\"),((1+P21)*(1+P14)-1),\"\")","v":4.2669945539558718E-2},{"$f":"IF(AND(Q14<>\"\",Q21<>\"\"),((1+Q21)*(1+Q14)-1),\"\")","v":4.05371651935027E-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":"Jemena Electricity 2022-26 True-Up for Previous Period - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","AER Final Decision","Input"]
[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":"CY16"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"CY17"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"CY18"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"CY19"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"CY20"}]
[]
[null,null,"Total capex allowance","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"CY15"},null,167.75306659435577,203.84213764546377,169.31656060080007,168.49436086174802,153.12204666426095]
[null,null,"Customer Contributions","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"CY15"},null,29.65752003697375,31.882176868159537,29.212231401211675,30.286585667854329,32.201525604863882]
[null,null,"Asset Disposals","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"CY15"},null,3.6939242307692308,0.16287384615384617,0.1651246153846154,0.25776423076923077,0.16896115384615379]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"CY15"},null,{"$f":"IF(H6=\"\", \"\", H8-H9-H10)","v":134.4016223266128},{"$f":"IF(I6=\"\", \"\", I8-I9-I10)","v":171.79708693115037},{"$f":"IF(J6=\"\", \"\", J8-J9-J10)","v":139.93920458420376},{"$f":"IF(K6=\"\", \"\", K8-K9-K10)","v":137.95001096312447},{"$f":"IF(L6=\"\", \"\", L8-L9-L10)","v":120.75155990555091}]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"H6","v":"CY16"},{"$f":"I6","v":"CY17"},{"$f":"J6","v":"CY18"},{"$f":"K6","v":"CY19"},{"$f":"L6","v":"CY20"}]
[]
[null,null,"Total capex","AER","$millions","nominal",null,120.46736619385238,155.9191644780505,149.71881501999999,145.23598082000001,147.055543]
[null,null,"Customer Contributions","AER","$millions","nominal",null,12.874707940000002,24.226373509999995,24.511393379999998,47.40634734999999,36.772136990000021]
[null,null,"Asset Disposals","AER","$millions","nominal",null,0.13893908999999999,0.2198215,0.34981207000000003,0.43762409999999996,3.5233368399999998]
[null,null,"Other excludable capex","AER","$millions","nominal"]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H16=\"\", \"\", H18-H19-H20-H21)","v":107.45371916385238},{"$f":"IF(I16=\"\", \"\", I18-I19-I20-I21)","v":131.47296946805051},{"$f":"IF(J16=\"\", \"\", J18-J19-J20-J21)","v":124.85760956999999},{"$f":"IF(K16=\"\", \"\", K18-K19-K20-K21)","v":97.392009370000025},{"$f":"IF(L16=\"\", \"\", L18-L19-L20-L21)","v":106.76006916999998}]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D18","v":"2021-2022"},{"$f":"'Input | General'!E18","v":"2022–23"},{"$f":"'Input | General'!F18","v":"2023–24"},{"$f":"'Input | General'!G18","v":"2024–25"},{"$f":"'Input | General'!H18","v":"2025–26"}]
[]
[null,null,"Capex deferred and re-proposed","JEN","$millions","nominal",null,8.6070710628181182,0,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"CY15"},null,{"$f":"IF(H29<>\"\",H29/('Input | Inflation and Disc Rate'!K10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":7.8480921170339526},{"$f":"IF(I29<>\"\",I29/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(J29<>\"\",J29/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0},{"$f":"IF(K29<>\"\",K29/('Input | Inflation and Disc Rate'!O10*(1+'Input | Inflation and Disc Rate'!P9)^0.5),\"\")","v":0},{"$f":"IF(L29<>\"\",L29/('Input | Inflation and Disc Rate'!P10*(1+'Input | Inflation and Disc Rate'!Q9)^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'!M14)^0.5,\"\")","v":8.5922875216151908},{"$f":"IF(I29<>\"\",I30*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(J29<>\"\",J30*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0},{"$f":"IF(K29<>\"\",K30*'Input | Inflation and Disc Rate'!O15*(1+'Input | Inflation and Disc Rate'!P14)^0.5,\"\")","v":0},{"$f":"IF(L29<>\"\",L30*'Input | Inflation and Disc Rate'!P15*(1+'Input | Inflation and Disc Rate'!Q14)^0.5,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":4,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Jemena Electricity 2022-26 True-Up for Previous Period - 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":"CY16"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"CY17"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"CY18"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"CY19"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"CY20"}]
[null,null,"Discount rate (Real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G20","v":3.9328628706946089E-2},{"$f":"'Input | Inflation and Disc Rate'!H20","v":3.8730571453602369E-2},{"$f":"'Input | Inflation and Disc Rate'!I20","v":3.821466541215579E-2},{"$f":"'Input | Inflation and Disc Rate'!J20","v":3.7669116070430331E-2},{"$f":"'Input | Inflation and Disc Rate'!K20","v":3.6561951019833616E-2}]
[null,null,"Discount rate (Nominal, fixed real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G22","v":5.5031421964085947E-2},{"$f":"'Input | Inflation and Disc Rate'!H22","v":4.9359442417313604E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":5.8290639605208527E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":5.9228637000529716E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":5.3073557319264664E-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":139.08921635916488},{"$f":"'Input | Reported Capex'!I$12*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":179.55649427616444},{"$f":"'Input | Reported Capex'!J$12*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":149.05091328672162},{"$f":"'Input | Reported Capex'!K$12*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":149.94557994179439},{"$f":"'Input | Reported Capex'!L$12*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":133.27120035226173}]
[null,null,"Actual capex",{"$f":"'Input | Reported Capex'!H23*(1+D$9)^0.5","v":110.37078946234494},{"$f":"'Input | Reported Capex'!I23*(1+E$9)^0.5","v":134.67860504623616},{"$f":"'Input | Reported Capex'!J23*(1+F$9)^0.5","v":128.44508587680991},{"$f":"'Input | Reported Capex'!K23*(1+G$9)^0.5","v":100.23472034908754},{"$f":"'Input | Reported Capex'!L23*(1+H$9)^0.5","v":109.55651285942572}]
[null,null,"Underspend",{"$f":"(D10-D11)","v":28.718426896819935},{"$f":"(E10-E11)","v":44.877889229928286},{"$f":"(F10-F11)","v":20.605827409911711},{"$f":"(G10-G11)","v":49.710859592706854},{"$f":"(H10-H11)","v":23.714687492836006}]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*$E$8","v":1.1122810849623406},{"$f":"$D$12*$F$8*(1+'Input | Inflation and Disc Rate'!H13)","v":1.108694950211736},{"$f":"$D$12*$G$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)","v":1.1140001079470525},{"$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.1037227356763435}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$12*F$8","v":1.7149935213254994},{"$f":"$E$12*G$8*(1+'Input | Inflation and Disc Rate'!I13)","v":1.7231998463781573},{"$f":"$E$12*H$8*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":1.7073022120855588}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$12*G$8","v":0.7762033044312191},{"$f":"$F$12*$H$8*(1+'Input | Inflation and Disc Rate'!J13)","v":0.76904232638419223}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"$G$12*$H$8","v":1.8175260135823741}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",{"$f":"SUM(D13:D17)","v":0},{"$f":"SUM(E13:E17)","v":1.1122810849623406},{"$f":"SUM(F13:F17)","v":2.8236884715372357},{"$f":"SUM(G13:G17)","v":3.6134032587564291},{"$f":"SUM(H13:H17)","v":5.3975932877284691}]
[null,null,"Discount factor (end of year)",{"$f":"E19*(1+E$9)","v":1.2387328395097892},{"$f":"F19*(1+F$9)","v":1.1804657102586635},{"$f":"G19*(1+G$9)","v":1.1154456687805838},{"$f":"H19*(1+H$9)","v":1.0530735573192647},1]
[null,null,"NPV underspend",{"$f":"D12*D19","v":35.574458496152062},{"$f":"E12*E19","v":52.976809384716923},{"$f":"F12*F19","v":22.984680936026255},{"$f":"G12*G19","v":52.349191748690295},{"$f":"H12*H19","v":23.714687492836006}]
[null,null,"NPV financing benefit",{"$f":"D18*D19","v":0},{"$f":"E18*E19","v":1.3130096809673462},{"$f":"F18*F19","v":3.1496710755618764},{"$f":"G18*G19","v":3.8051794237276559},{"$f":"H18*H19","v":5.3975932877284691}]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$18","v":"2021-2022"},{"$f":"'Input | General'!$E$18","v":"2022–23"},{"$f":"'Input | General'!$F$18","v":"2023–24"},{"$f":"'Input | General'!$G$18","v":"2024–25"},{"$f":"'Input | General'!$H$18","v":"2025–26"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!M$22","v":4.9068286577727216E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":4.6935506231671198E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":4.480272588561518E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":4.2669945539558718E-2},{"$f":"'Input | Inflation and Disc Rate'!Q$22","v":4.05371651935027E-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":8.5922875216151908},{"$f":"'Input | Reported Capex'!I31","v":0},{"$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)*(1+'Input | Inflation and Disc Rate'!$L$22))","v":0.95311167883327064},{"$f":"1/((1+E25)^(0.5)*(1+D25)*(1+'Input | Inflation and Disc Rate'!$L$22))","v":0.90945653393310344},{"$f":"1/((1+F25)^(0.5)*(1+E25)*(1+D25)*(1+'Input | Inflation and Disc Rate'!$L$22))","v":0.86957057314072816},{"$f":"1/((1+G25)^(0.5)*(1+F25)*(1+E25)*(1+D25)*(1+'Input | Inflation and Disc Rate'!$L$22))","v":0.83313284902662577},{"$f":"1/((1+H25)^(0.5)*(1+G25)*(1+F25)*(1+E25)*(1+D25)*(1+'Input | Inflation and Disc Rate'!$L$22))","v":0.79985641500795235}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D26*D27","v":8.1894095847448174},{"$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,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D20:H20)-SUM(D28:H28)","v":179.41041847367669}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D32)*D31","v":125.58729293157367}]
[null,null,"NSP share",{"$f":"D32*D31","v":53.823125542103007}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D21:H21)","v":13.665453467985348}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D34-D35","v":40.157672074117656}]
[null,null,"NPV of CESS payments (post-adjustment) as at 30 June 2021",{"$f":"D36*(1+'Input | Inflation and Disc Rate'!L22)","v":41.136075707744013}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D18","v":"2021-2022"},{"$f":"'Input | General'!E18","v":"2022–23"},{"$f":"'Input | General'!F18","v":"2023–24"},{"$f":"'Input | General'!G18","v":"2024–25"},{"$f":"'Input | General'!H18","v":"2025–26"}]
[null,null,"Discount factor",{"$f":"1/(1+'Input | Inflation and Disc Rate'!M21)","v":0.97228548947206639},{"$f":"D42/(1+'Input | Inflation and Disc Rate'!N21)","v":0.94726488468854186},{"$f":"E42/(1+'Input | Inflation and Disc Rate'!O21)","v":0.92477206852837379},{"$f":"F42/(1+'Input | Inflation and Disc Rate'!P21)","v":0.90466004836694225},{"$f":"G42/(1+'Input | Inflation and Disc Rate'!Q21)","v":0.88679937334350001}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!$F$8,\" million)\")","v":"CESS Payment Per Year ($2020–21 million)"},{"$f":"D37/(SUM(D42:H42))","v":8.8736003787514885},{"$f":"D43","v":8.8736003787514885},{"$f":"E43","v":8.8736003787514885},{"$f":"F43","v":8.8736003787514885},{"$f":"G43","v":8.8736003787514885}]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$8,\" million)\")","v":"Total CESS Payment ($2020–21 million)"},{"$f":"SUM(D43:H43)","v":44.368001893757445}]
[]
[]
[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":"Jemena Electricity 2022-26 True-Up for Previous Period - 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'!D41","v":"2021-2022"},{"$f":"'Calc | CESS Revenue Increments'!E41","v":"2022–23"},{"$f":"'Calc | CESS Revenue Increments'!F41","v":"2023–24"},{"$f":"'Calc | CESS Revenue Increments'!G41","v":"2024–25"},{"$f":"'Calc | CESS Revenue Increments'!H41","v":"2025–26"},"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":"2020–21"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D43","v":8.8736003787514885},{"$f":"'Calc | CESS Revenue Increments'!E43","v":8.8736003787514885},{"$f":"'Calc | CESS Revenue Increments'!F43","v":8.8736003787514885},{"$f":"'Calc | CESS Revenue Increments'!G43","v":8.8736003787514885},{"$f":"'Calc | CESS Revenue Increments'!H43","v":8.8736003787514885},{"$f":"SUM(J8:N8)","v":44.368001893757445}]
[]
[]
[null,"End"]