{"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":5,"defined_names":5,"comments":0,"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":"AusGrid 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":"AusGrid 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","AusGrid"]
[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":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"AusGrid 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.4498886414253906E-2,2.4879227053140163E-2,1.5083667216591934E-2,1.2769909449732886E-2]
[null,null,"Forecast CPI Inflation Rate","TNSP","Per cent",null,null,null,null,null,1.95E-2,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)"},"TNSP","Index",1]
[null,null,"CPI Index","TNSP","Index",null,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0244988864142539},{"$f":"IF(H7<>\"\",(G11*(1+H8)),\"\")","v":1.0499876268250434},1.0658252907696115,1.0794357832219748,{"$f":"IF(K7<>\"\",(J11*(1+K9)),\"\")","v":1.1004847809948033},1.1279969005196733,1.1561968230326649,1.1851017436084814,1.2147292871986934,1.2450975193786606]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,2.3800000000000002E-2,2.3800000000000002E-2,2.3800000000000002E-2,2.3800000000000002E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,2.3800000000000002E-2,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]
[null,null,"CPI Index","AER","Index",null,{"$f":"IF(G7<>\"\",(F16*(1+G14)),\"\")","v":1.0238},{"$f":"IF(H7<>\"\",(G17*(1+H14)),\"\")","v":1.0481664400000001},1.0731128012720001,1.0986528859422737,{"$f":"IF(K7<>\"\",(J17*(1+K15)),\"\")","v":1.1248008246276999},1.1529208452433923,1.181743866374477,1.2112874630338388,1.2415696496096846,1.2726088908499267]
[]
[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,null,4.1998153371859859E-2,4.1148020928013063E-2,4.0262878238657374E-2,3.9396043804811542E-2,3.7900000000000003E-2,3.7400000000000003E-2,3.6999999999999998E-2,3.6600000000000001E-2,3.6356913631938825E-2]
[]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND('Input | Inflation and Disc Rate'!H8<>\"\",G22<>\"\"),((1+G22)*(1+'Input | Inflation and Disc Rate'!H8)-1),\"\")","v":""},{"$f":"IF(AND(H14<>\"\",H22<>\"\"),((1+H22)*(1+H14)-1),\"\")","v":6.6797709422110163E-2},{"$f":"IF(AND(I14<>\"\",I22<>\"\"),((1+I22)*(1+I14)-1),\"\")","v":6.5927343826099882E-2},6.5021134740737452E-2,{"$f":"IF(AND(K15<>\"\",K22<>\"\"),((1+K22)*(1+K15)-1),\"\")","v":6.4133669647365998E-2},6.3847500000000057E-2,6.3334999999999919E-2,6.2924999999999898E-2,6.2514999999999876E-2,6.2265836472737313E-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":"AusGrid 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,{"$f":"'[2]PTRM input'!H71+'[3]PTRM input'!H$71","v":804.62005107925154},{"$f":"'[2]PTRM input'!I71+'[3]PTRM input'!I$71","v":776.15227592254007},{"$f":"'[2]PTRM input'!J71+'[3]PTRM input'!J$71","v":718.20566691304623},{"$f":"'[2]PTRM input'!K71+'[3]PTRM input'!K$71","v":638.87396955924225}]
[null,null,"Total excludable capex","AER","$millions","2013-14",null,null,{"$f":"'[2]PTRM input'!H$139+'[2]PTRM input'!H$105+'[3]PTRM input'!H$105","v":161.42316788359133},{"$f":"'[2]PTRM input'!I$139+'[2]PTRM input'!I$105+'[3]PTRM input'!I$105","v":124.19915548074674},{"$f":"'[2]PTRM input'!J$139+'[2]PTRM input'!J$105+'[3]PTRM input'!J$105","v":124.67338065852012},{"$f":"'[2]PTRM input'!K$139+'[2]PTRM input'!K$105+'[3]PTRM input'!K$105","v":120.57552425814112}]
[]
[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":643.19688319566023},{"$f":"IF(J6=\"\", \"\", J8-J9)","v":651.95312044179332},593.53228625452607,518.29844530110108]
[]
[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,{"$f":"'[4]RFM input'!I$71+'[5]RFM input'!I$71","v":551.54205744000001},{"$f":"'[4]RFM input'!J$71+'[5]RFM input'!J$71","v":574.01887356000009},{"$f":"'[4]RFM input'!K$71+'[5]RFM input'!K$71","v":748.01223466114993},{"$f":"'[4]RFM input'!L$71+'[5]RFM input'!L$71","v":937.36318018747738}]
[null,null,"Total excludable capex","AER","$millions","nominal",null,null,{"$f":"'[4]RFM input'!I$139+'[4]RFM input'!I$105+'[5]RFM input'!I$105","v":247.886500590612},{"$f":"'[4]RFM input'!J$139+'[4]RFM input'!J$105+'[5]RFM input'!J$105","v":140.5819940475532},{"$f":"'[4]RFM input'!K$139+'[4]RFM input'!K$105+'[5]RFM input'!K$105","v":142.60700618064399},{"$f":"'[4]RFM input'!L$139+'[4]RFM input'!L$105+'[5]RFM input'!L$105","v":145.22870473485168}]
[]
[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":303.65555684938801},{"$f":"IF(J15=\"\", \"\", J17-J18)","v":433.43687951244692},{"$f":"IF(K15=\"\", \"\", K17-K18)","v":605.40522848050591},{"$f":"IF(L15=\"\", \"\", L17-L18)","v":792.13447545262568}]
[]
[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'!L11,\"\")","v":0},{"$f":"IF(I26<>\"\",I26/'Input | Inflation and Disc Rate'!M11,\"\")","v":0},{"$f":"IF(J26<>\"\",J26/'Input | Inflation and Disc Rate'!N11,\"\")","v":0},{"$f":"IF(K26<>\"\",K26/'Input | Inflation and Disc Rate'!O11,\"\")","v":0},{"$f":"IF(L26<>\"\",L26/'Input | Inflation and Disc Rate'!P11,\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","AER","$millions","nominal",null,{"$f":"IF(H26<>\"\",H27*'Input | Inflation and Disc Rate'!L17,\"\")","v":0},{"$f":"IF(I26<>\"\",I27*'Input | Inflation and Disc Rate'!M17,\"\")","v":0},{"$f":"IF(J26<>\"\",J27*'Input | Inflation and Disc Rate'!N17,\"\")","v":0},{"$f":"IF(K26<>\"\",K27*'Input | Inflation and Disc Rate'!O17,\"\")","v":0},{"$f":"IF(L26<>\"\",L27*'Input | Inflation and Disc Rate'!P17,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":4,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,2,53,14],[52,2,52,14]]}
[null,{"$f":"'Input | General'!$B$1","v":"AusGrid 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,"Finance Rate (Real WACC):",null,{"$f":"'Input | Inflation and Disc Rate'!H22","v":4.1998153371859859E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":4.1148020928013063E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":4.0262878238657374E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":3.9396043804811542E-2}]
[null,null,"Discount rate:",null,{"$f":"'Input | Inflation and Disc Rate'!H24","v":6.6797709422110163E-2},{"$f":"'Input | Inflation and Disc Rate'!I24","v":6.5927343826099882E-2},{"$f":"'Input | Inflation and Disc Rate'!J24","v":6.5021134740737452E-2},{"$f":"'Input | Inflation and Disc Rate'!K24","v":6.4133669647365998E-2}]
[null,null,"Capex allowance",null,{"$f":"'Input | Reported Capex'!I11*'Input | Inflation and Disc Rate'!G11*(1+'Input | Inflation and Disc Rate'!H8)^0.5","v":667.1012696873172},{"$f":"'Input | Reported Capex'!J11*'Input | Inflation and Disc Rate'!H11*(1+'Input | Inflation and Disc Rate'!I8)^0.5","v":689.68609426480759},{"$f":"'Input | Reported Capex'!K11*'Input | Inflation and Disc Rate'!I11*(1+'Input | Inflation and Disc Rate'!J8)^0.5","v":636.62804176942961},{"$f":"'Input | Reported Capex'!L11*'Input | Inflation and Disc Rate'!J11*(1+'Input | Inflation and Disc Rate'!K9)^0.5","v":564.89838351115543}]
[null,null,"Actual capex",null,{"$f":"'Input | Reported Capex'!I20","v":303.65555684938801},{"$f":"'Input | Reported Capex'!J20","v":433.43687951244692},{"$f":"'Input | Reported Capex'!K20","v":605.40522848050591},{"$f":"'Input | Reported Capex'!L20","v":792.13447545262568}]
[null,null,"Underspend",null,{"$f":"(E10-E11)","v":363.44571283792919},{"$f":"(F10-F11)","v":256.24921475236067},{"$f":"(G10-G11)","v":31.222813288923703},{"$f":"(H10-H11)","v":-227.23609194147025}]
[null,null,"Underspend + 1/2 Nominal WACC",null,{"$f":"E12*(1+E$9)^(0.5)","v":375.38817473156649},{"$f":"F12*(1+F$9)^(0.5)","v":264.5613175710622},32.221899970411918,-234.40960546401598]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*E$8","v":0},{"$f":"$D$12*(1+'Input | Inflation and Disc Rate'!H14)*F$8","v":0},{"$f":"$D$12*(1+'Input | Inflation and Disc Rate'!H14)*(1+'Input | Inflation and Disc Rate'!I14)*G$8","v":0},{"$f":"$D$12*(1+'Input | Inflation and Disc Rate'!H14)*(1+'Input | Inflation and Disc Rate'!I14)*(1+'Input | Inflation and Disc Rate'!J14)*H$8","v":0}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$13*(F$8)","v":15.446480469983122},{"$f":"$E$13*(1+'Input | Inflation and Disc Rate'!I14)*(G$8)","v":15.473926530689385},{"$f":"$E$13*(1+'Input | Inflation and Disc Rate'!I14)*(1+'Input | Inflation and Disc Rate'!J14)*(H$8)","v":15.501133255724518}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$13*G$8","v":10.652000116022442},{"$f":"$F$13*(1+'Input | Inflation and Disc Rate'!J14)*H$8","v":10.670728784383124}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"$G$13*(H$8)","v":1.2694153827086037}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",null,{"$f":"SUM(E14:E18)","v":0},{"$f":"SUM(F14:F18)","v":15.446480469983122},26.125926646711825,{"$f":"SUM(H14:H18)","v":27.441277422816245}]
[null,null,"Discount factor (middle of year)*",null,{"$f":"(1+E$9)^(0.5)*(1+F$9)*(1+G$9)*(1+H$9)","v":1.2477369929817044},{"$f":"(1+F$9)^(0.5)*(1+G$9)*(1+H$9)","v":1.1700871567894346},{"$f":"(1+G$9)^(0.5)*(1+H$9)","v":1.0981844698372714},{"$f":"(1+$H$9)^0.5","v":1.0315685482057728}]
[null,null,"Discount factor (end of year)**",null,{"$f":"F21*(1+F$9)","v":1.2080419453083966},{"$f":"G21*(1+G$9)","v":1.1333248483636629},{"$f":"H21*(1+H$9)","v":1.064133669647366},1]
[null,null,"NPV underspend",null,{"$f":"E12*E20","v":453.4846608484898},299.83391511911498,{"$f":"G12*G20","v":34.288408658524787},{"$f":"H12*H20","v":-234.40960546401598}]
[null,null,"NPV financing benefit",null,{"$f":"E19*E21","v":0},17.505880136395902,{"$f":"G19*G21","v":27.801478195503357},{"$f":"H19*H21","v":27.441277422816245}]
[]
[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$24","v":6.3847500000000057E-2},{"$f":"'Input | Inflation and Disc Rate'!M$24","v":6.3334999999999919E-2},{"$f":"'Input | Inflation and Disc Rate'!N$24","v":6.2924999999999898E-2},{"$f":"'Input | Inflation and Disc Rate'!O$24","v":6.2514999999999876E-2},{"$f":"'Input | Inflation and Disc Rate'!P$24","v":6.2265836472737313E-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+D27)^(0.5)","v":0.96952790019709323},{"$f":"1/((1+E27)^(0.5)*(1+D27))","v":0.9115606473220681},{"$f":"1/((1+F27)^(0.5)*(1+E27)*(1+D27))","v":0.85743104255263192},{"$f":"1/((1+G27)^(0.5)*(1+F27)*(1+E27)*(1+D27))","v":0.80682687679305654},{"$f":"1/((1+H27)^(0.5)*(1+G27)*(1+F27)*(1+E27)*(1+D27))","v":0.75944480342721554}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D28*D29","v":0},{"$f":"E28*E29","v":0},0,0,0]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D22:H22)-SUM(D30:H30)","v":553.19737916211363}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D34)*D33","v":387.23816541347952}]
[null,null,"NSP share",{"$f":"D34*D33","v":165.95921374863408}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D23:H23)","v":72.748635754715508}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D36-D37","v":93.210577993918577}]
[null,null,"Assumed Distribution RAB split",{"$f":"'[4]PTRM input summary'!J$37/('[4]PTRM input summary'!J$37+'[5]PTRM input summary'!J$37)","v":0.87812144554636951}]
[null,null,"Assumed Transmission RAB split",{"$f":"1-D39","v":0.12187855445363049}]
[]
[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'!K22,5,'Calc | CESS Revenue Increments'!$D$38)","v":20.902111861766379},{"$f":"-PMT('Input | Inflation and Disc Rate'!L22,5,'Calc | CESS Revenue Increments'!$D$38)","v":20.814258149612332},{"$f":"-PMT('Input | Inflation and Disc Rate'!M22,5,'Calc | CESS Revenue Increments'!$D$38)","v":20.784931189518119},{"$f":"-PMT('Input | Inflation and Disc Rate'!N22,5,'Calc | CESS Revenue Increments'!$D$38)","v":20.761482281515413},{"$f":"-PMT('Input | Inflation and Disc Rate'!O22,5,'Calc | CESS Revenue Increments'!$D$38)","v":20.738044634815513}]
[null,null,"Distribution CESS Payment Per Year ($2018-19 million)",{"$f":"$D39*D$45","v":18.354592683026208},{"$f":"$D39*E$45","v":18.277446454312884},18.251693821721471,18.23110283272965,18.21052173252933]
[null,null,"Transmission CESS Payment Per Year ($2018-19 million)",{"$f":"$D40*D$45","v":2.5475191787401696},{"$f":"$D40*E$45","v":2.5368116952994488},2.5332373677966471,2.5303794487857609,2.527522902286182]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$4,\" million)\")","v":"Total CESS Payment ($2018-19 million)"},{"$f":"SUM(D45:H45)","v":104.00082811722775}]
[]
[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":"AusGrid 2019-24 Draft decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,{"$f":"[1]Index!$C$13","v":"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'!D44","v":"2019-20"},{"$f":"'Calc | CESS Revenue Increments'!E44","v":"2020-21"},{"$f":"'Calc | CESS Revenue Increments'!F44","v":"2021-22"},{"$f":"'Calc | CESS Revenue Increments'!G44","v":"2022-23"},{"$f":"'Calc | CESS Revenue Increments'!H44","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'!D45","v":20.902111861766379},{"$f":"'Calc | CESS Revenue Increments'!E45","v":20.814258149612332},{"$f":"'Calc | CESS Revenue Increments'!F45","v":20.784931189518119},{"$f":"'Calc | CESS Revenue Increments'!G45","v":20.761482281515413},{"$f":"'Calc | CESS Revenue Increments'!H45","v":20.738044634815513},{"$f":"SUM(J8:N8)","v":104.00082811722775}]
[]
[]
[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":"AusGrid 2019-24 Draft decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,{"$f":"[1]Index!$C$14","v":"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"]