{"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":3,"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":"Endeavour Energy 2019-24 Draft 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,"Lookup | Tables","Includes the lookup tables used within the CESS model."]
[]
[null,null,"End"]

{"sheet":"Input | General","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"$D$6&\" \"&$D$8&\" \"&D7&\" - \"&\"Capital expenditure sharing scheme model\"","v":"Endeavour Energy 2019-24 Draft decision - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","Endeavour Energy"]
[null,null,"Determination stage","Draft decision"]
[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)","No","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)","2009-10","2010-11","2011-12","2012-13","2013-14"]
[]
[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":"Endeavour Energy 2019-24 Draft decision - Capital expenditure sharing scheme model"},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,{"$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","TNSP","Per cent",null,2.4879227053140163E-2,1.5083667216591934E-2,1.2769909449732886E-2,1.9486474094452033E-2,1.9638522329714192E-2]
[null,null,"Forecast CPI Inflation Rate","TNSP","Per cent",null,null,null,null,null,null,1.9316698463889059E-2,2.4564867906045951E-2,2.5000000000000355E-2,2.5000000000000355E-2,2.5000000000000355E-2]
[null,null,{"$f":"\"CPI Index (base year \"&$F$7&\")\"","v":"CPI Index (base year 2013-14)"},"TNSP","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0248792270531402},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0403381642512077},{"$f":"IF(I7<>\"\",(H10*(1+I8)),\"\")","v":1.0536231884057969},{"$f":"IF(J7<>\"\",(I10*(1+J8)),\"\")","v":1.0741545893719804},{"$f":"IF(K7<>\"\",(J10*(1+K8)),\"\")","v":1.095249398260927},{"$f":"IF(L7<>\"\",(K10*(1+L9)),\"\")","v":1.1164060006298893},{"$f":"IF(M7<>\"\",(L10*(1+M9)),\"\")","v":1.1438303665648795},{"$f":"IF(N7<>\"\",(M10*(1+N9)),\"\")","v":1.1724261257290018},{"$f":"IF(O7<>\"\",(N10*(1+O9)),\"\")","v":1.2017367788722273},{"$f":"IF(P7<>\"\",(O10*(1+P9)),\"\")","v":1.2317801983440333}]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,{"$f":"G8","v":2.4879227053140163E-2},{"$f":"H8","v":1.5083667216591934E-2},1.2769909449732886E-2,1.9486474094452033E-2,1.9638522329714192E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,null,{"$f":"L9","v":1.9316698463889059E-2},{"$f":"M9","v":2.4564867906045951E-2},2.5000000000000355E-2,2.5000000000000355E-2,2.5000000000000355E-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.0248792270531402},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0403381642512077},{"$f":"IF(I7<>\"\",(H15*(1+I13)),\"\")","v":1.0536231884057969},{"$f":"IF(J7<>\"\",(I15*(1+J13)),\"\")","v":1.0741545893719804},{"$f":"IF(K7<>\"\",(J15*(1+K13)),\"\")","v":1.095249398260927},{"$f":"IF(L7<>\"\",(K15*(1+L14)),\"\")","v":1.1164060006298893},{"$f":"IF(M7<>\"\",(L15*(1+M14)),\"\")","v":1.1438303665648795},{"$f":"IF(N7<>\"\",(M15*(1+N14)),\"\")","v":1.1724261257290018},{"$f":"IF(O7<>\"\",(N15*(1+O14)),\"\")","v":1.2017367788722273},{"$f":"IF(P7<>\"\",(O15*(1+P14)),\"\")","v":1.2317801983440333}]
[]
[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.2254018761887169E-2,4.163547694214853E-2,4.0761033280446446E-2,3.9860233470544681E-2,3.8827966039358675E-2,{"$f":"K20","v":3.8827966039358675E-2},{"$f":"L20","v":3.8827966039358675E-2},3.8827966039358675E-2,3.8827966039358675E-2,3.8827966039358675E-2]
[]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND(G8<>\"\",G20<>\"\"),((1+G20)*(1+G8)-1),\"\")","v":6.8184493141711933E-2},{"$f":"IF(AND(H13<>\"\",H20<>\"\"),((1+H20)*(1+H13)-1),\"\")","v":5.7347159837339845E-2},{"$f":"IF(AND(I13<>\"\",I20<>\"\"),((1+I20)*(1+I13)-1),\"\")","v":5.4051457434248107E-2},{"$f":"IF(AND(J13<>\"\",J20<>\"\"),((1+J20)*(1+J13)-1),\"\")","v":6.0123442971919294E-2},{"$f":"IF(AND(K13<>\"\",K20<>\"\"),((1+K20)*(1+K13)-1),\"\")","v":5.9229012247154156E-2},{"$f":"IF(AND(L14<>\"\",L20<>\"\"),((1+L20)*(1+L14)-1),\"\")","v":5.8894692615196087E-2},{"$f":"IF(AND(M14<>\"\",M20<>\"\"),((1+M20)*(1+M14)-1),\"\")","v":6.434663780222194E-2},{"$f":"IF(AND(N14<>\"\",N20<>\"\"),((1+N20)*(1+N14)-1),\"\")","v":6.4798665190342941E-2},{"$f":"IF(AND(O14<>\"\",O20<>\"\"),((1+O20)*(1+O14)-1),\"\")","v":6.4798665190342941E-2},{"$f":"IF(AND(P14<>\"\",P20<>\"\"),((1+P20)*(1+P14)-1),\"\")","v":6.4798665190342941E-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":"Endeavour Energy 2019-24 Draft decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | Capex"]
[]
[null,"Input | Capex Allowance"]
[]
[null,null,null,"Source","Unit","Basis",null,"n/a","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,"Total capex allowance","AER","$millions","2013-14",null,null,334.89995065584492,282.99461416545427,274.81440514730207,262.56865411632992]
[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":334.89995065584492},{"$f":"IF(J6=\"\", \"\", J8-J9)","v":282.99461416545427},274.81440514730207,262.56865411632992]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,"n/a","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,"Total capex","AER","$millions","nominal",null,null,212.05214638836918,187.94984390621664,338.6881482901432,397.62966211789944]
[null,null,"Total excludable capex","AER","$millions","nominal",null,null,1.6033734286421713,-2.2465642880788308,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":210.44877295972702},{"$f":"IF(J15=\"\", \"\", J17-J18)","v":190.19640819429549},{"$f":"IF(K15=\"\", \"\", K17-K18)","v":338.6881482901432},{"$f":"IF(L15=\"\", \"\", L17-L18)","v":397.62966211789944}]
[]
[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","TNSP","$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*(1+'Input | Inflation and Disc Rate'!L9)^0.5),\"\")","v":0},{"$f":"IF(I26<>\"\",I26/('Input | Inflation and Disc Rate'!L10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":0},{"$f":"IF(J26<>\"\",J26/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(K26<>\"\",K26/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0},{"$f":"IF(L26<>\"\",L26/('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(H26<>\"\",H27*'Input | Inflation and Disc Rate'!K15*(1+'Input | Inflation and Disc Rate'!L14)^0.5,\"\")","v":0},{"$f":"IF(I26<>\"\",I27*'Input | Inflation and Disc Rate'!L15*(1+'Input | Inflation and Disc Rate'!M14)^0.5,\"\")","v":0},{"$f":"IF(J26<>\"\",J27*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(K26<>\"\",K27*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0},{"$f":"IF(L26<>\"\",L27*'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":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Endeavour Energy 2019-24 Draft 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","n/a","2015-16","2016-17","2017-18","2018-19"]
[null,null,"Discount rate:",null,{"$f":"'Input | Inflation and Disc Rate'!H22","v":5.7347159837339845E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":5.4051457434248107E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":6.0123442971919294E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":5.9229012247154156E-2}]
[null,null,"Capex allowance",null,{"$f":"'Input | Reported Capex'!I$11*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":355.58832691871919},{"$f":"'Input | Reported Capex'!J$11*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":304.18584606124347},{"$f":"'Input | Reported Capex'!K$11*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":301.01890189108872},{"$f":"'Input | Reported Capex'!L$11*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":293.10803072138447}]
[null,null,"Actual capex",null,{"$f":"'Input | Reported Capex'!I20*(1+E$8)^0.5","v":216.39897503821726},{"$f":"'Input | Reported Capex'!J20*(1+F$8)^0.5","v":195.26896201179676},{"$f":"'Input | Reported Capex'!K20*(1+G$8)^0.5","v":348.72109428782466},{"$f":"'Input | Reported Capex'!L20*(1+H$8)^0.5","v":409.23588395531129}]
[null,null,"Underspend",null,{"$f":"(E9-E10)","v":139.18935188050193},{"$f":"(F9-F10)","v":108.91688404944671},-47.702192396735938,-116.12785323392683]
[null,null,"Year 1 benefit"]
[null,null,"Year 2 benefit",null,null,{"$f":"($E$11)*F$8","v":7.5233873284695321},{"$f":"($E$11)*G$8","v":8.3685430600857647},{"$f":"($E$11)*H$8","v":8.2440478272036977}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"($F$11)*G$8","v":6.548458066826055},{"$f":"($F$11)*H$8","v":6.4510394592865481}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"($G$11)*H$8","v":-2.8253537376823767}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",null,{"$f":"SUM(E12:E16)","v":0},{"$f":"SUM(F12:F16)","v":7.5233873284695321},14.917001126911821,11.869733548807869]
[null,null,"Discount factor (end of year)",null,{"$f":"F18*(1+F$8)","v":1.1836086190045663},{"$f":"G18*(1+G$8)","v":1.1229135073591983},{"$f":"H18*(1+H$8)","v":1.0592290122471542},1]
[null,null,"NPV underspend",null,{"$f":"E11*E18","v":164.74571655942151},{"$f":"F11*F18","v":122.30424027859932},{"$f":"G11*G18","v":-50.527546134418316},{"$f":"H11*H18","v":-116.12785323392683}]
[null,null,"NPV financing benefit",null,{"$f":"E17*E18","v":0},{"$f":"F17*F18","v":8.4481132522334708},{"$f":"G17*G18","v":15.800520369348494},{"$f":"H17*H18","v":11.869733548807869}]
[]
[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":5.8894692615196087E-2},{"$f":"'Input | Inflation and Disc Rate'!M$22","v":6.434663780222194E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":6.4798665190342941E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":6.4798665190342941E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":6.4798665190342941E-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.97179265941352089},{"$f":"1/((1+E24)^(0.5)*(1+D24))","v":0.91538898492424747},{"$f":"1/((1+F24)^(0.5)*(1+E24)*(1+D24))","v":0.85986522786155217},{"$f":"1/((1+G24)^(0.5)*(1+F24)*(1+E24)*(1+D24))","v":0.80753785290277669},{"$f":"1/((1+H24)^(0.5)*(1+G24)*(1+F24)*(1+E24)*(1+D24))","v":0.75839487717466436}]
[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":120.39455746967568}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D31)*D30","v":84.276190228772961}]
[null,null,"NSP share",{"$f":"D31*D30","v":36.1183672409027}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D20:H20)","v":36.118367170389831}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D33-D34","v":7.0512868433070253E-8}]
[]
[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":1.5786987859101675E-8},{"$f":"-PMT('Input | Inflation and Disc Rate'!M20,5,'Calc | CESS Revenue Increments'!$D$35)","v":1.5786987859101675E-8},{"$f":"-PMT('Input | Inflation and Disc Rate'!N20,5,'Calc | CESS Revenue Increments'!$D$35)","v":1.5786987859101675E-8},{"$f":"-PMT('Input | Inflation and Disc Rate'!O20,5,'Calc | CESS Revenue Increments'!$D$35)","v":1.5786987859101675E-8},{"$f":"-PMT('Input | Inflation and Disc Rate'!P20,5,'Calc | CESS Revenue Increments'!$D$35)","v":1.5786987859101675E-8}]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$4,\" million)\")","v":"Total CESS Payment ($2018-19 million)"},{"$f":"SUM(D40:H40)","v":7.893493929550837E-8}]
[]
[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":"Endeavour Energy 2019-24 Draft 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,"$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":1.5786987859101675E-8},{"$f":"'Calc | CESS Revenue Increments'!E40","v":1.5786987859101675E-8},{"$f":"'Calc | CESS Revenue Increments'!F40","v":1.5786987859101675E-8},{"$f":"'Calc | CESS Revenue Increments'!G40","v":1.5786987859101675E-8},{"$f":"'Calc | CESS Revenue Increments'!H40","v":1.5786987859101675E-8},{"$f":"SUM(J8:N8)","v":7.893493929550837E-8}]
[]
[]
[null,"End"]

{"sheet":"Lookup | Tables","index":6,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"Endeavour Energy 2019-24 Draft decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","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"]