{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Index","Input | General","Input | Inflation and Disc Rate","Input | Reported Capex","Calc | CESS Revenue Increments","Output | Models","Lookup | Tables"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy - Capital expenditure sharing scheme model - 2019-24"}]
[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,"Lookup | Tables","Includes the lookup tables used within the CESS model."]
[]
[null,null,"End"]

{"sheet":"Input | General","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,3,6,4]]}
[null,{"$f":"$D$7&\" - \"&\"Capital expenditure sharing scheme model - \"&$D$8","v":"Essential Energy - Capital expenditure sharing scheme model - 2019-24"},null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"Inputs","Value"]
[null,null,"NSP Name","Essential Energy"]
[null,null,"Determination years","2019-24"]
[]
[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)","2014-15","2015-16","2016-17","2017-18","2018-19"]
[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","Estimate","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)","2019-20","2020-21","2021-22","2022-23","2023-24"]
[null,null,"Regulatory control period prior to CESS applied in (regulatory years)","2014-15","2015-16","2016-17","2017-18","2018-19"]
[]
[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 - Capital expenditure sharing scheme model - 2019-24"},null,null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,null,"Input | Inflation and Discount rate"]
[]
[null,null,"Input | Inflation"]
[]
[null,null,null,"Source","Unit"]
[null,null,null,null,null,{"$f":"'Lookup | Tables'!$E$27","v":"2013-14"},{"$f":"'Lookup | Tables'!$E$28","v":"2014-15"},{"$f":"'Lookup | Tables'!$E$29","v":"2015-16"},{"$f":"'Lookup | Tables'!$E$30","v":"2016-17"},{"$f":"'Lookup | Tables'!$E$31","v":"2017-18"},{"$f":"'Lookup | Tables'!$E$32","v":"2018-19"},{"$f":"'Lookup | Tables'!$E$33","v":"2019-20"},{"$f":"'Lookup | Tables'!$E$34","v":"2020-21"},{"$f":"'Lookup | Tables'!$E$35","v":"2021-22"},{"$f":"'Lookup | Tables'!$E$36","v":"2022-23"},{"$f":"'Lookup | Tables'!$E$37","v":"2023-24"}]
[null,null,"Actual CPI Inflation Rate","NSP","Per cent",null,2.4500000000000001E-2,2.4879227053139941E-2,1.5083667216592156E-2,1.2769909449732886E-2]
[null,null,"Forecast CPI Inflation Rate","NSP","Per cent",null,null,null,null,null,1.95E-2,2.5000000000000001E-2,{"$f":"L9","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2013-14)"},"NSP","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0245},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0499887681159419},1.0658264492753624,1.0794369565217392,{"$f":"IF(K7<>\"\",(J10*(1+K9)),\"\")","v":1.1004859771739133},1.127998126603261,1.1561980797683424,1.1851030317625508,1.2147306075566144,1.2450988727455297]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,{"$f":"G8","v":2.4500000000000001E-2},{"$f":"H8","v":2.4879227053139941E-2},{"$f":"I8","v":1.5083667216592156E-2},{"$f":"J8","v":1.2769909449732886E-2}]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,{"$f":"K9","v":1.95E-2},{"$f":"L9","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2013-14)"},"AER","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.0245},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0499887681159419},1.0658264492753624,1.0794369565217392,{"$f":"IF(K7<>\"\",(J15*(1+K14)),\"\")","v":1.1004859771739133},1.127998126603261,1.1561980797683424,1.1851030317625508,1.2147306075566144,1.2450988727455297]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",null,{"$f":"'Lookup | Tables'!$E$28","v":"2014-15"},{"$f":"'Lookup | Tables'!$E$29","v":"2015-16"},{"$f":"'Lookup | Tables'!$E$30","v":"2016-17"},{"$f":"'Lookup | Tables'!$E$31","v":"2017-18"},{"$f":"'Lookup | Tables'!$E$32","v":"2018-19"},{"$f":"'Lookup | Tables'!$E$33","v":"2019-20"},{"$f":"'Lookup | Tables'!$E$34","v":"2020-21"},{"$f":"'Lookup | Tables'!$E$35","v":"2021-22"},{"$f":"'Lookup | Tables'!$E$36","v":"2022-23"},{"$f":"'Lookup | Tables'!$E$37","v":"2023-24"}]
[null,null,"Real Vanilla WACC","AER","Per cent",null,4.2625207328403025E-2,4.1998153371859949E-2,4.1139488559976914E-2,4.0269872885555238E-2,3.9233837485359579E-2,3.7482926829268549E-2,3.6546341463414761E-2,3.555121951219524E-2,3.4556097560975732E-2,3.3619512195122069E-2]
[]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND('Input | Inflation and Disc Rate'!H8<>\"\",G20<>\"\"),((1+G20)*(1+'Input | Inflation and Disc Rate'!H8)-1),\"\")","v":6.8564916592853464E-2},{"$f":"IF(AND(H8<>\"\",H20<>\"\"),((1+H20)*(1+H8)-1),\"\")","v":6.7922262018550894E-2},{"$f":"IF(AND(I8<>\"\",I20<>\"\"),((1+I20)*(1+I8)-1),\"\")","v":5.6843690131468616E-2},{"$f":"IF(AND(J8<>\"\",J20<>\"\"),((1+J20)*(1+J8)-1),\"\")","v":5.3554024965589031E-2},{"$f":"IF(AND(K14<>\"\",K20<>\"\"),((1+K20)*(1+K14)-1),\"\")","v":5.9498897316324184E-2},{"$f":"IF(AND(L14<>\"\",L20<>\"\"),((1+L20)*(1+L14)-1),\"\")","v":6.3420000000000032E-2},6.2460000000000182E-2,6.1439999999999939E-2,6.042000000000014E-2,5.9460000000000068E-2]
[]
[null,"End"]

{"sheet":"Input | Reported Capex","index":3,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy - Capital expenditure sharing scheme model - 2019-24"},null,null,null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,"Input | Capex"]
[]
[null,"Input | Capex Allowance"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"IF('Input | General'!D$13=\"Yes\", 'Input | General'!D$12, \"\")","v":"2014-15"},{"$f":"IF('Input | General'!E$13=\"Yes\", 'Input | General'!E$12, \"\")","v":"2015-16"},{"$f":"IF('Input | General'!F$13=\"Yes\", 'Input | General'!F$12, \"\")","v":"2016-17"},{"$f":"IF('Input | General'!G$13=\"Yes\", 'Input | General'!G$12, \"\")","v":"2017-18"},{"$f":"IF('Input | General'!H$13=\"Yes\", 'Input | General'!H$12, \"\")","v":"2018-19"}]
[]
[null,null,"Total capex allowance","AER","$millions","2013-14",null,null,492.86192695933846,481.169601830207,455.5948490113085,432.6376594909234]
[null,null,"Total excludable capex","AER","$millions","2013-14",null,null,0,0,0,0]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions","2013-14",null,{"$f":"IF(H6=\"\", \"\", H8-H9)","v":0},{"$f":"IF(I6=\"\", \"\", I8-I9)","v":492.86192695933846},{"$f":"IF(J6=\"\", \"\", J8-J9)","v":481.169601830207},455.5948490113085,432.6376594909234]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"IF('Input | General'!D$13=\"Yes\", 'Input | General'!D$12, \"\")","v":"2014-15"},{"$f":"IF('Input | General'!E$13=\"Yes\", 'Input | General'!E$12, \"\")","v":"2015-16"},{"$f":"IF('Input | General'!F$13=\"Yes\", 'Input | General'!F$12, \"\")","v":"2016-17"},{"$f":"IF('Input | General'!G$13=\"Yes\", 'Input | General'!G$12, \"\")","v":"2017-18"},{"$f":"IF('Input | General'!H$13=\"Yes\", 'Input | General'!H$12, \"\")","v":"2018-19"}]
[]
[null,null,"Total capex","AER","$millions","nominal",null,null,405.30107287032871,400.08420692586094,436.63278993638352,478.73128347017587]
[null,null,"Total excludable capex","AER","$millions","nominal",null,null,0,0,0,0]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H15=\"\", \"\", H17-H18)","v":0},{"$f":"IF(I15=\"\", \"\", I17-I18)","v":405.30107287032871},{"$f":"IF(J15=\"\", \"\", J17-J18)","v":400.08420692586094},{"$f":"IF(K15=\"\", \"\", K17-K18)","v":436.63278993638352},{"$f":"IF(L15=\"\", \"\", L17-L18)","v":478.73128347017587}]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D17","v":"2019-20"},{"$f":"'Input | General'!E17","v":"2020-21"},{"$f":"'Input | General'!F17","v":"2021-22"},{"$f":"'Input | General'!G17","v":"2022-23"},{"$f":"'Input | General'!H17","v":"2023-24"}]
[]
[null,null,"Capex deferred and re-proposed","NSP","$millions","nominal",null,0,0,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions","2013-14",null,{"$f":"IF(H26<>\"\",H26/'Input | Inflation and Disc Rate'!K10,\"\")","v":0},{"$f":"IF(I26<>\"\",I26/'Input | Inflation and Disc Rate'!L10,\"\")","v":0},{"$f":"IF(J26<>\"\",J26/'Input | Inflation and Disc Rate'!M10,\"\")","v":0},{"$f":"IF(K26<>\"\",K26/'Input | Inflation and Disc Rate'!N10,\"\")","v":0},{"$f":"IF(L26<>\"\",L26/'Input | Inflation and Disc Rate'!O10,\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","AER","$millions","nominal",null,{"$f":"IF(H26<>\"\",H27*'Input | Inflation and Disc Rate'!K15,\"\")","v":0},{"$f":"IF(I26<>\"\",I27*'Input | Inflation and Disc Rate'!L15,\"\")","v":0},{"$f":"IF(J26<>\"\",J27*'Input | Inflation and Disc Rate'!M15,\"\")","v":0},{"$f":"IF(K26<>\"\",K27*'Input | Inflation and Disc Rate'!N15,\"\")","v":0},{"$f":"IF(L26<>\"\",L27*'Input | Inflation and Disc Rate'!O15,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":4,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[45,2,45,14],[44,2,44,14]]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy - Capital expenditure sharing scheme model - 2019-24"},null,null,null,null,null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,"Input | CESS Payments"]
[]
[null,"Calc | NPV of CESS payments"]
[]
[null,null,"Regulatory period 1"]
[null,null,"Year",{"$f":"IF('Input | General'!D$13=\"Yes\",'Input | General'!D$12,\"\")","v":"2014-15"},{"$f":"IF('Input | General'!E$13=\"Yes\",'Input | General'!E$12,\"\")","v":"2015-16"},{"$f":"IF('Input | General'!F$13=\"Yes\",'Input | General'!F$12,\"\")","v":"2016-17"},{"$f":"IF('Input | General'!G$13=\"Yes\",'Input | General'!G$12,\"\")","v":"2017-18"},{"$f":"IF('Input | General'!H$13=\"Yes\",'Input | General'!H$12,\"\")","v":"2018-19"}]
[null,null,"Discount rate:",null,{"$f":"'Input | Inflation and Disc Rate'!H22","v":6.7922262018550894E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":5.6843690131468616E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":5.3554024965589031E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":5.9498897316324184E-2}]
[null,null,"Capex allowance (nominal)",null,{"$f":"'Input | Reported Capex'!I11*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":528.25473522647064},{"$f":"'Input | Reported Capex'!J11*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":523.28602377636071},{"$f":"'Input | Reported Capex'!K11*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":501.59026464494968},{"$f":"'Input | Reported Capex'!L11*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":485.36166627972125}]
[null,null,"Actual capex (nominal)",null,{"$f":"'Input | Reported Capex'!I20*(1+E$8)^0.5","v":418.83944297313872},{"$f":"'Input | Reported Capex'!J20*(1+F$8)^0.5","v":411.29817986652716},{"$f":"'Input | Reported Capex'!K20*(1+G$8)^0.5","v":448.17203320651106},{"$f":"'Input | Reported Capex'!L20*(1+H$8)^0.5","v":492.76750678330546}]
[null,null,"Underspend",null,{"$f":"IF(E8<>\"\",(E9-E10),\"\")","v":109.41529225333193},{"$f":"IF(F8<>\"\",(F9-F10),\"\")","v":111.98784390983354},{"$f":"IF(G8<>\"\",(G9-G10),\"\")","v":53.418231438438625},{"$f":"IF(H8<>\"\",(H9-H10),\"\")","v":-7.4058405035842156}]
[null,null,"Year 1 benefit"]
[null,null,"Year 2 benefit",null,null,{"$f":"($E$11+SUM($E13:E13))*F$8","v":6.2195689684924789},{"$f":"($E$11+SUM($E13:F13))*G$8","v":6.1927122447660077},{"$f":"($E$11+SUM($E13:G13))*H$8","v":7.2486062839856036}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"($F$11+SUM($F14:F14))*G$8","v":5.9973997885897132},{"$f":"($F$11+SUM($F14:G14))*H$8","v":7.019991899653971}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"($G$11+SUM($G15:G15))*H$8","v":3.1783258671753001}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",null,{"$f":"SUM(E12:E16)","v":0},{"$f":"SUM(F12:F16)","v":6.2195689684924789},12.190112033355721,17.446924050814875]
[null,null,"Discount factor (end of year)**",null,{"$f":"F18*(1+F$8)","v":1.1796904901713625},{"$f":"G18*(1+G$8)","v":1.1162393277142166},{"$f":"H18*(1+H$8)","v":1.0594988973163242},1]
[null,null,"NPV underspend",null,{"$f":"E11*E18","v":129.07617975057602},{"$f":"F11*F18","v":125.00523559807722},{"$f":"G11*G18","v":56.596557305613928},{"$f":"H11*H18","v":-7.4058405035842156}]
[null,null,"NPV financing benefit",null,{"$f":"E17*E18","v":0},{"$f":"F17*F18","v":6.9425274840622482},{"$f":"G17*G18","v":12.91541025750284},{"$f":"H17*H18","v":17.446924050814875}]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$17","v":"2019-20"},{"$f":"'Input | General'!$E$17","v":"2020-21"},{"$f":"'Input | General'!$F$17","v":"2021-22"},{"$f":"'Input | General'!$G$17","v":"2022-23"},{"$f":"'Input | General'!$H$17","v":"2023-24"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!L$22","v":6.3420000000000032E-2},{"$f":"'Input | Inflation and Disc Rate'!M$22","v":6.2460000000000182E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":6.1439999999999939E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":6.042000000000014E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":5.9460000000000068E-2}]
[null,null,"Increase in forecast capex in regulatory period 2 attributable to capex deferred in regulatory period 1",{"$f":"'Input | Reported Capex'!H28","v":0},{"$f":"'Input | Reported Capex'!I28","v":0},{"$f":"'Input | Reported Capex'!J28","v":0},{"$f":"'Input | Reported Capex'!K28","v":0},{"$f":"'Input | Reported Capex'!L28","v":0}]
[null,null,"Discount factor (middle of year 5)",{"$f":"1/(1+D24)^(0.5)","v":0.9697227580757527},{"$f":"1/((1+E24)^(0.5)*(1+D24))","v":0.91230253537346662},{"$f":"1/((1+F24)^(0.5)*(1+E24)*(1+D24))","v":0.85908248088858052},{"$f":"1/((1+G24)^(0.5)*(1+F24)*(1+E24)*(1+D24))","v":0.8097448277907342},{"$f":"1/((1+H24)^(0.5)*(1+G24)*(1+F24)*(1+E24)*(1+D24))","v":0.76395353588064596}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D25*D26","v":0},{"$f":"E25*E26","v":0},0,0,0]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D19:H19)-SUM(D27:H27)","v":303.27213215068298}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D31)*D30","v":212.29049250547808}]
[null,null,"NSP share",{"$f":"D31*D30","v":90.981639645204893}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D20:H20)","v":37.304861792379967}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D33-D34","v":53.676777852824927}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D17","v":"2019-20"},{"$f":"'Input | General'!E17","v":"2020-21"},{"$f":"'Input | General'!F17","v":"2021-22"},{"$f":"'Input | General'!G17","v":"2022-23"},{"$f":"'Input | General'!H17","v":"2023-24"}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!F4,\" million)\")","v":"CESS Payment Per Year ($2018-19 million)"},{"$f":"-PMT('Input | Inflation and Disc Rate'!L20,5,'Calc | CESS Revenue Increments'!$D$35)","v":11.972129943420057},{"$f":"-PMT('Input | Inflation and Disc Rate'!M20,5,'Calc | CESS Revenue Increments'!$D$35)","v":11.940519210703206},{"$f":"-PMT('Input | Inflation and Disc Rate'!N20,5,'Calc | CESS Revenue Increments'!$D$35)","v":11.906971793330598},{"$f":"-PMT('Input | Inflation and Disc Rate'!O20,5,'Calc | CESS Revenue Increments'!$D$35)","v":11.873464606906946},{"$f":"-PMT('Input | Inflation and Disc Rate'!P20,5,'Calc | CESS Revenue Increments'!$D$35)","v":11.841965240123587}]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!F5,\" million)\")","v":"Total CESS Payment ($ million)"},{"$f":"SUM(D40:H40)","v":59.535050794484391}]
[]
[null,null,"Notes"]
[null,null,"* Capex is assumed to occur mid-year. Hence, a mid-year discount rate is required for capex allowance, actual capex and underspend."]
[null,null,"** The financing benefit is calculated on an end of year basis. Hence, an end of year discount rate is required."]
[]
[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 - Capital expenditure sharing scheme model - 2019-24"},null,null,null,null,null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,"Output models"]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,"$millions","2018-19",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'!D39","v":"2019-20"},{"$f":"'Calc | CESS Revenue Increments'!E39","v":"2020-21"},{"$f":"'Calc | CESS Revenue Increments'!F39","v":"2021-22"},{"$f":"'Calc | CESS Revenue Increments'!G39","v":"2022-23"},{"$f":"'Calc | CESS Revenue Increments'!H39","v":"2023-24"},"Total"]
[]
[null,null,"CESS increments as per NER 6A.5.4(a)(5)","Calc | CESS Revenue Increments",{"$f":"$E$4","v":"$millions"},{"$f":"$F$4","v":"2018-19"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D40","v":11.972129943420057},{"$f":"'Calc | CESS Revenue Increments'!E40","v":11.940519210703206},{"$f":"'Calc | CESS Revenue Increments'!F40","v":11.906971793330598},{"$f":"'Calc | CESS Revenue Increments'!G40","v":11.873464606906946},{"$f":"'Calc | CESS Revenue Increments'!H40","v":11.841965240123587},{"$f":"SUM(J8:N8)","v":59.535050794484391}]
[]
[]
[null,"End"]

{"sheet":"Lookup | Tables","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Essential Energy - Capital expenditure sharing scheme model - 2019-24"},null,null,null,null,null,"Back to Index","Key:","Input","External Link","Internal Link"]
[null,"Lookup | Tables"]
[]
[null,"Unit Denominations"]
[]
[null,null,"Denominations",null,"Ref"]
[null,null,"Dollars",null,"$dollars"]
[null,null,"Thousands",null,"$000"]
[null,null,"Millions",null,"$millions"]
[]
[null,null,"Actual",null,"Actual"]
[null,null,"Estimate",null,"Estimate"]
[null,null,"not applicable",null,"n/a"]
[]
[]
[null,"Years"]
[]
[null,null,{"$f":"B16","v":"Years"},null,"Ref"]
[null,null,"not applicable",null,"n/a"]
[null,null,"nominal",null,"nominal"]
[null,null,"2007-08",null,"2007-08"]
[null,null,"2008-09",null,"2008-09"]
[null,null,"2009-10",null,"2009-10"]
[null,null,"2010-11",null,"2010-11"]
[null,null,"2011-12",null,"2011-12"]
[null,null,"2012-13",null,"2012-13"]
[null,null,"2013-14",null,"2013-14"]
[null,null,"2014-15",null,"2014-15"]
[null,null,"2015-16",null,"2015-16"]
[null,null,"2016-17",null,"2016-17"]
[null,null,"2017-18",null,"2017-18"]
[null,null,"2018-19",null,"2018-19"]
[null,null,"2019-20",null,"2019-20"]
[null,null,"2020-21",null,"2020-21"]
[null,null,"2021-22",null,"2021-22"]
[null,null,"2022-23",null,"2022-23"]
[null,null,"2023-24",null,"2023-24"]
[]
[null,"End"]