{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inputs >>>","Inputs and Assumptions","Outputs >>>","(EGX&EGN) Building Blocks","Energex Smoothed Charges","Ergon Smoothed Charges"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":33,"defined_names":705,"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":"Inputs >>>","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inputs and Assumptions","index":1,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[[30,0,30,8],[26,0,26,8],[38,0,38,8],[45,0,45,8]]}
["Inputs and Assumptions"]
[]
[]
["Inputs"]
[]
["Table 1 - Type 6 meter population (000's) as at July 2018"]
["Network","Electro-mechanical","Electronic","Total"]
["Energex",1353,770.8,{"$f":"Table1[[#This Row],[Electro-mechanical]]+Table1[[#This Row],[Electronic]]","v":2123.8000000000002}]
["Ergon Energy",800,376.8,{"$f":"Table1[[#This Row],[Electro-mechanical]]+Table1[[#This Row],[Electronic]]","v":1176.8}]
["Total",{"$f":"SUBTOTAL(109,B8:B9)","v":2153},{"$f":"SUBTOTAL(109,C8:C9)","v":1147.5999999999999},{"$f":"Table1[[#This Row],[Electro-mechanical]]+Table1[[#This Row],[Electronic]]","v":3300.6}]
[]
[]
["Meter Population (millions)"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Energex Meters",{"$f":"B21/1000000","v":2.0929899999999999},{"$f":"B15*(1-'Inputs and Assumptions'!$B$59)","v":2.0302002999999997},{"$f":"C15*(1-'Inputs and Assumptions'!$B$59)","v":1.9692942909999998},{"$f":"D15*(1-'Inputs and Assumptions'!$B$59)","v":1.9102154622699996},{"$f":"E15*(1-'Inputs and Assumptions'!$B$59)","v":1.8529089984018996},{"$f":"F15*(1-'Inputs and Assumptions'!$B$59)","v":1.7973217284498426},{"$f":"G15*(1-'Inputs and Assumptions'!$B$59)","v":1.7434020765963474},{"$f":"H15*(1-'Inputs and Assumptions'!$B$59)","v":1.6911000142984569}]
["Ergon Meters",{"$f":"B22/1000000","v":1.1484589999999999},{"$f":"B16*(1-'Inputs and Assumptions'!$B$60)","v":1.05658228},{"$f":"C16*(1-'Inputs and Assumptions'!$B$60)","v":0.97205569759999999},{"$f":"D16*(1-'Inputs and Assumptions'!$B$60)","v":0.89429124179200004},{"$f":"E16*(1-'Inputs and Assumptions'!$B$60)","v":0.82274794244864002},{"$f":"F16*(1-'Inputs and Assumptions'!$B$60)","v":0.75692810705274882},{"$f":"G16*(1-'Inputs and Assumptions'!$B$60)","v":0.69637385848852895},{"$f":"H16*(1-'Inputs and Assumptions'!$B$60)","v":0.64066394980944663}]
[]
[]
["Meter Population"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Energex Meters",2092990,{"$f":"B21*(1-'Inputs and Assumptions'!$B$59)","v":2030200.3},{"$f":"C21*(1-'Inputs and Assumptions'!$B$59)","v":1969294.291},{"$f":"D21*(1-'Inputs and Assumptions'!$B$59)","v":1910215.46227},{"$f":"E21*(1-'Inputs and Assumptions'!$B$59)","v":1852908.9984019001},{"$f":"F21*(1-'Inputs and Assumptions'!$B$59)","v":1797321.7284498429},{"$f":"G21*(1-'Inputs and Assumptions'!$B$59)","v":1743402.0765963476},{"$f":"H21*(1-'Inputs and Assumptions'!$B$59)","v":1691100.0142984572}]
["Ergon Meters",1148459,{"$f":"B22*(1-'Inputs and Assumptions'!$B$60)","v":1056582.28},{"$f":"C22*(1-'Inputs and Assumptions'!$B$60)","v":972055.69760000007},{"$f":"D22*(1-'Inputs and Assumptions'!$B$60)","v":894291.24179200013},{"$f":"E22*(1-'Inputs and Assumptions'!$B$60)","v":822747.94244864013},{"$f":"F22*(1-'Inputs and Assumptions'!$B$60)","v":756928.10705274891},{"$f":"G22*(1-'Inputs and Assumptions'!$B$60)","v":696373.85848852899},{"$f":"H22*(1-'Inputs and Assumptions'!$B$60)","v":640663.9498094467}]
[]
[]
["Network Tariff Code Population"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Energex"]
["Primary",1447342,{"$f":"B28*(1-$B$64)","v":1403921.74},{"$f":"C28*(1-$B$64)","v":1361804.0877999999},1320949.9651659997,1281321.4662110198,1242881.8222246892,1205595.3675579485,1169427.5065312099]
["Load Control",720779,{"$f":"B29*(1-$B$64)","v":699155.63},{"$f":"C29*(1-$B$64)","v":678180.96109999996},657835.53226699994,638100.46629898995,618957.45231002022,600388.72874071961,582377.06687849807]
["Solar PV",337758,{"$f":"B30*(1-$B$64)","v":327625.26},{"$f":"C30*(1-$B$64)","v":317796.50219999999},308262.60713399999,299014.72891998,290044.28705238062,281342.95844080922,272902.66968758492]
["Ergon"]
["Primary",800176,{"$f":"B32*(1-$B$65)","v":736161.92},{"$f":"C32*(1-$B$65)","v":677268.96640000003},623087.44908800011,573240.45316096011,527381.2169080833,485190.71955543663,446375.46199100174]
["Load Control",440974,{"$f":"B33*(1-$B$65)","v":405696.08},373240.39360000001,343381.16211200005,315910.66914304008,290637.81561159686,267386.7903626691,245995.84713365557]
["Solar PV",138519,127437.48000000001,117242.48160000001,107863.08307200002,99234.036426240025,91295.313512140827,83991.688431169561,77272.353356676002]
[]
[]
["Customers by Tariff Code"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Energex"]
["Primary (Non-capital)",1352354,{"$f":"B40*(1-$B$69)","v":1311783.3799999999},1272429.8785999999,1234256.9822419998,1197229.2727747399,1161312.3945914977,1126473.0227537528,{"$f":"H40*(1-$B$69)","v":1092678.8320711402}]
["Primary (Capital)",1377896,{"$f":"B41","v":1377896},1377896,1377896,1377896,1377896,1377896,{"$f":"H41","v":1377896}]
["Load Control (Non-capital)",680744,{"$f":"B42*(1-$B$69)","v":660321.67999999993},640512.02959999989,621296.6687119999,602657.76865063992,584578.03559112072,567040.69452338712,{"$f":"H42*(1-$B$69)","v":550029.47368768544}]
["Load Control (Capital)",712568,{"$f":"B43","v":712568},712568,712568,712568,712568,712568,{"$f":"H43","v":712568}]
["Solar PV (Non-capital)",312473,{"$f":"B44*(1-$B$69)","v":303098.81},294005.84570000001,285185.67032899999,276630.10021912999,268331.19721255609,260281.26129617941,{"$f":"H44*(1-$B$69)","v":252472.82345729403}]
["Solar PV (Capital)",311438,{"$f":"B45","v":311438},311438,311438,311438,311438,311438,{"$f":"H45","v":311438}]
["Ergon"]
["Primary (Non-capital)",780055,{"$f":"B47*(1-$B$70)","v":717650.6},{"$f":"C47*(1-$B$70)","v":660238.55200000003},607419.46784000006,558825.91041280003,514119.83757977607,472990.25057339401,435151.0305275225]
["Primary (Capital)",777218,{"$f":"B48","v":777218},{"$f":"C48","v":777218},777218,777218,777218,777218,777218]
["Load Control (Non-capital)",431226,{"$f":"B49*(1-$B$70)","v":396727.92000000004},364989.68640000006,335790.51148800005,308927.27056896006,284213.08892344328,261476.04180956783,240557.95846480242]
["Load Control (Capital)",433510,{"$f":"B50","v":433510},{"$f":"C50","v":433510},433510,433510,433510,433510,433510]
["Solar PV (Non-capital)",137274,126292.08,116188.7136,106893.61651200001,98342.12719104001,90474.757015756812,83236.77645449627,76577.83433813657]
["Solar PV (Capital)",122277,{"$f":"B52","v":122277},{"$f":"C52","v":122277},122277,122277,122277,122277,122277]
[]
[]
[]
["Assumptions"]
[]
["Meter Decline Rate"]
["Energex Meter Decline Rate",0.03]
["Ergon Meter Decline Rate",0.08]
[]
[]
["NTC Decline Rate"]
["Energex NTC Decline Rate",0.03]
["Ergon NTC Decline Rate",0.08]
[]
[]
["Customer Decline Rate"]
["Energex Customer Decline Rate",0.03]
["Ergon Customer Decline Rate",0.08]
[]
[]
["Inflation"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Inflation Assumption (CPI % increase) (constant)",null,null,null,2.4199999999999999E-2,2.4199999999999999E-2,2.4199999999999999E-2,2.4199999999999999E-2,2.4199999999999999E-2]
["Cumulative Inflation Index (CPI end period)",null,null,1,{"$f":"D76*(1+E75)","v":1.0242},{"$f":"E76*(1+F75)","v":1.0489856399999999},1.0743710924879999,1.1003708729262094,1.1269998480510237]
[]
[]
["WACC"]
["Year","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Time Varying Nominal Vanilla WACC",null,null,null,5.4588082695082821E-2,5.4288103460180155E-2,5.3988124225277483E-2,5.3688144990374817E-2,5.3388165755472158E-2]

{"sheet":"Outputs >>>","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"(EGX&EGN) Building Blocks","index":3,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Building Block Components"]
[]
[]
["Energex",null,null,null,null,null,null,null,null,"Ergon"]
[]
["Building Blocks ($m, nominal)",null,null,null,null,null,null,null,null,"Building Blocks ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total"]
["Return on Capital",{"$f":"'[32]Revenue summary'!G7","v":18.504939942994966},{"$f":"'[32]Revenue summary'!H7","v":17.137925702193357},{"$f":"'[32]Revenue summary'!I7","v":15.709394407982799},{"$f":"'[32]Revenue summary'!J7","v":14.230592244665676},{"$f":"'[32]Revenue summary'!K7","v":12.679558889403079},null,{"$f":"SUM(B8:F8)","v":78.262411187239877},null,"Return on Capital",{"$f":"'[33]Revenue summary'!G7","v":4.5144307017850345},{"$f":"'[33]Revenue summary'!H7","v":4.3601650482363343},{"$f":"'[33]Revenue summary'!I7","v":4.1784307910298706},{"$f":"'[33]Revenue summary'!J7","v":3.9514427379047605},{"$f":"'[33]Revenue summary'!K7","v":3.6556481642900049},null,{"$f":"SUM(K8:O8)","v":20.660117443246001}]
["Return of Capital (regulatory depreciation)",{"$f":"'[32]Revenue summary'!G8","v":24.607155421280176},{"$f":"'[32]Revenue summary'!H8","v":26.160920567119},{"$f":"'[32]Revenue summary'!I8","v":27.79356677537114},{"$f":"'[32]Revenue summary'!J8","v":29.523492244234447},{"$f":"'[32]Revenue summary'!K8","v":30.618578347652825},null,{"$f":"SUM(B9:F9)","v":138.70371335565758},null,"Return of Capital (regulatory depreciation)",{"$f":"'[33]Revenue summary'!G8","v":6.1287769994719845},{"$f":"'[33]Revenue summary'!H8","v":6.8572459584276038},{"$f":"'[33]Revenue summary'!I8","v":7.6180114087865594},{"$f":"'[33]Revenue summary'!J8","v":8.3971243342662234},{"$f":"'[33]Revenue summary'!K8","v":8.6574816193005883},null,{"$f":"SUM(K9:O9)","v":37.658640320252964}]
["Operating Expenditure",{"$f":"'[32]Revenue summary'!G9","v":19.676652343189762},{"$f":"'[32]Revenue summary'!H9","v":19.618981058472855},{"$f":"'[32]Revenue summary'!I9","v":19.595241606230999},{"$f":"'[32]Revenue summary'!J9","v":19.584087758251638},{"$f":"'[32]Revenue summary'!K9","v":19.582025637920928},null,98.056988404066175,null,"Operating Expenditure",{"$f":"'[33]Revenue summary'!G9","v":29.584915084352517},{"$f":"'[33]Revenue summary'!H9","v":27.78280094716856},{"$f":"'[33]Revenue summary'!I9","v":26.196117244378161},{"$f":"'[33]Revenue summary'!J9","v":24.763183574206042},{"$f":"'[33]Revenue summary'!K9","v":23.465199862512399},null,131.79221671261769]
["Revenue Adjustments",{"$f":"'[32]Revenue summary'!G10","v":0},{"$f":"'[32]Revenue summary'!H10","v":0},{"$f":"'[32]Revenue summary'!I10","v":0},{"$f":"'[32]Revenue summary'!J10","v":0},{"$f":"'[32]Revenue summary'!K10","v":0},null,0,null,"Revenue Adjustments",{"$f":"'[33]Revenue summary'!G10","v":0},{"$f":"'[33]Revenue summary'!H10","v":0},{"$f":"'[33]Revenue summary'!I10","v":0},{"$f":"'[33]Revenue summary'!J10","v":0},{"$f":"'[33]Revenue summary'!K10","v":0},null,0]
["Net Tax Allowance",{"$f":"'[32]Revenue summary'!G11","v":1.9383059133301579},{"$f":"'[32]Revenue summary'!H11","v":2.0435943560633891},{"$f":"'[32]Revenue summary'!I11","v":2.1519691093816635},{"$f":"'[32]Revenue summary'!J11","v":2.3541926161401534},{"$f":"'[32]Revenue summary'!K11","v":2.3997188157064779},null,10.887780810621843,null,"Net Tax Allowance",{"$f":"'[33]Revenue summary'!G11","v":0.20335516825607258},{"$f":"'[33]Revenue summary'!H11","v":0.21949458878525446},{"$f":"'[33]Revenue summary'!I11","v":0.23816293025378155},{"$f":"'[33]Revenue summary'!J11","v":0.35864879971782637},{"$f":"'[33]Revenue summary'!K11","v":0.36424802548410051},null,1.3839095124970355]
["Annual Revenue Requirement (unsmoothed)",{"$f":"'[32]Revenue summary'!G12","v":64.727053620795061},{"$f":"'[32]Revenue summary'!H12","v":64.961421683848599},{"$f":"'[32]Revenue summary'!I12","v":65.250171898966599},{"$f":"'[32]Revenue summary'!J12","v":65.692364863291914},{"$f":"'[32]Revenue summary'!K12","v":65.279881690683311},null,325.91089375758543,null,"Annual Revenue Requirement (unsmoothed)",{"$f":"'[33]Revenue summary'!G12","v":40.43147795386561},{"$f":"'[33]Revenue summary'!H12","v":39.21970654261775},{"$f":"'[33]Revenue summary'!I12","v":38.230722374448369},{"$f":"'[33]Revenue summary'!J12","v":37.470399446094852},{"$f":"'[33]Revenue summary'!K12","v":36.142577671587091},null,191.49488398861365]
[]
["Unsmoothed Revenue Allocation ($m, nominal)",null,null,null,null,null,null,null,null,"Unsmoothed Revenue Allocation ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total"]
["Non-Capital Revenue (unsmoothed)",{"$f":"B10","v":19.676652343189762},{"$f":"C10","v":19.618981058472855},19.595241606230999,19.584087758251638,19.582025637920928,null,{"$f":"SUM(B17:F17)","v":98.056988404066175},null,"Non-Capital Revenue (unsmoothed)",{"$f":"K10","v":29.584915084352517},{"$f":"L10","v":27.78280094716856},26.196117244378161,24.763183574206042,23.465199862512399,null,{"$f":"SUM(K17:O17)","v":131.79221671261769}]
["Capital Revenue (unsmoothed)",{"$f":"B8+B9+B12","v":45.050401277605303},{"$f":"C8+C9+C12","v":45.342440625375744},45.6549302927356,46.108277105040273,45.697856052762383,null,{"$f":"SUM(B18:F18)","v":227.85390535351931},null,"Capital Revenue (unsmoothed)",{"$f":"K8+K9+K12","v":10.846562869513091},{"$f":"L8+L9+L12","v":11.436905595449192},12.034605130070211,12.70721587188881,12.677377809074693,null,{"$f":"SUM(K18:O18)","v":59.702667275995999}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"B17+B18","v":64.727053620795061},{"$f":"C17+C18","v":64.961421683848599},65.250171898966599,65.692364863291914,65.279881690683311,null,325.91089375758543,null,"Annual Revenue Requirement (unsmoothed)",{"$f":"K17+K18","v":40.43147795386561},{"$f":"L17+L18","v":39.21970654261775},{"$f":"M17+M18","v":38.230722374448376},{"$f":"N17+N18","v":37.470399446094852},{"$f":"O17+O18","v":36.142577671587091},null,191.49488398861365]
[]
["Building Blocks ($m, real 2019-20)",null,null,null,null,null,null,null,null,"Building Blocks ($m, real 2019-20)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total"]
["Return on Capital",{"$f":"B8/'Inputs and Assumptions'!$E$76","v":18.067701565119084},{"$f":"C8/'Inputs and Assumptions'!$F$76","v":16.337617073760285},{"$f":"D8/'Inputs and Assumptions'!$G$76","v":14.621944426672355},{"$f":"E8/'Inputs and Assumptions'!$H$76","v":12.932541740969889},{"$f":"F8/'Inputs and Assumptions'!$I$76","v":11.250719253716372},null,{"$f":"SUM(B23:F23)","v":73.210524060237987},null,"Return on Capital",{"$f":"K8/'Inputs and Assumptions'!$E$76","v":4.4077628410320591},{"$f":"L8/'Inputs and Assumptions'!$F$76","v":4.1565536094815698},{"$f":"M8/'Inputs and Assumptions'!$G$76","v":3.8891876561510719},{"$f":"N8/'Inputs and Assumptions'!$H$76","v":3.5910099359470626},{"$f":"O8/'Inputs and Assumptions'!$I$76","v":3.2436988972198151},null,{"$f":"SUM(K23:O23)","v":19.288212939831581}]
["Return of Capital (regulatory depreciation)",{"$f":"B9/'Inputs and Assumptions'!$E$76","v":24.025732690177872},{"$f":"C9/'Inputs and Assumptions'!$F$76","v":24.939255190489547},{"$f":"D9/'Inputs and Assumptions'!$G$76","v":25.869615228577622},{"$f":"E9/'Inputs and Assumptions'!$H$76","v":26.830492310036167},{"$f":"F9/'Inputs and Assumptions'!$I$76","v":27.168218700830387},null,{"$f":"SUM(B24:F24)","v":128.8333141201116},null,"Return of Capital (regulatory depreciation)",{"$f":"K9/'Inputs and Assumptions'!$E$76","v":5.9839650453739353},{"$f":"L9/'Inputs and Assumptions'!$F$76","v":6.5370255768492731},{"$f":"M9/'Inputs and Assumptions'!$G$76","v":7.0906704974209349},{"$f":"N9/'Inputs and Assumptions'!$H$76","v":7.6311764886467808},{"$f":"O9/'Inputs and Assumptions'!$I$76","v":7.6818835728082817},null,{"$f":"SUM(K24:O24)","v":34.924721181099201}]
["Operating Expenditure",{"$f":"B10/'Inputs and Assumptions'!$E$76","v":19.211728513171025},{"$f":"C10/'Inputs and Assumptions'!$F$76","v":18.702811850191633},{"$f":"D10/'Inputs and Assumptions'!$G$76","v":18.238801977492582},{"$f":"E10/'Inputs and Assumptions'!$H$76","v":17.797715515834945},{"$f":"F10/'Inputs and Assumptions'!$I$76","v":17.375357833264211},null,91.326415689954416,null,"Operating Expenditure",{"$f":"K10/'Inputs and Assumptions'!$E$76","v":28.885876864237957},{"$f":"L10/'Inputs and Assumptions'!$F$76","v":26.485396832666424},{"$f":"M10/'Inputs and Assumptions'!$G$76","v":24.382745801279793},{"$f":"N10/'Inputs and Assumptions'!$H$76","v":22.504397547668145},{"$f":"O10/'Inputs and Assumptions'!$I$76","v":20.82094323534464},null,123.07936028119697]
["Revenue Adjustments",{"$f":"B11/'Inputs and Assumptions'!$E$76","v":0},{"$f":"C11/'Inputs and Assumptions'!$F$76","v":0},{"$f":"D11/'Inputs and Assumptions'!$G$76","v":0},{"$f":"E11/'Inputs and Assumptions'!$H$76","v":0},{"$f":"F11/'Inputs and Assumptions'!$I$76","v":0},null,0,null,"Revenue Adjustments",{"$f":"K11/'Inputs and Assumptions'!$E$76","v":0},{"$f":"L11/'Inputs and Assumptions'!$F$76","v":0},{"$f":"M11/'Inputs and Assumptions'!$G$76","v":0},{"$f":"N11/'Inputs and Assumptions'!$H$76","v":0},{"$f":"O11/'Inputs and Assumptions'!$I$76","v":0},null,0]
["Net Tax Allowance",{"$f":"B12/'Inputs and Assumptions'!$E$76","v":1.892507238166528},{"$f":"C12/'Inputs and Assumptions'!$F$76","v":1.9481623752860804},{"$f":"D12/'Inputs and Assumptions'!$G$76","v":2.003003547310819},{"$f":"E12/'Inputs and Assumptions'!$H$76","v":2.1394537733261365},{"$f":"F12/'Inputs and Assumptions'!$I$76","v":2.1292982602051187},null,10.112425194294682,null,"Net Tax Allowance",{"$f":"K12/'Inputs and Assumptions'!$E$76","v":0.19855025215394706},{"$f":"L12/'Inputs and Assumptions'!$F$76","v":0.20924460775769482},{"$f":"M12/'Inputs and Assumptions'!$G$76","v":0.22167659937894474},{"$f":"N12/'Inputs and Assumptions'!$H$76","v":0.32593447222396377},{"$f":"O12/'Inputs and Assumptions'!$I$76","v":0.32320148588663306},null,1.2786074174011834]
["Annual Revenue Requirement (unsmoothed)",{"$f":"B13/'Inputs and Assumptions'!$E$76","v":63.197670006634503},{"$f":"C13/'Inputs and Assumptions'!$F$76","v":61.927846489727543},{"$f":"D13/'Inputs and Assumptions'!$G$76","v":60.733365180053376},{"$f":"E13/'Inputs and Assumptions'!$H$76","v":59.700203340167135},{"$f":"F13/'Inputs and Assumptions'!$I$76","v":57.923594048016085},null,303.48267906459864,null,"Annual Revenue Requirement (unsmoothed)",{"$f":"K13/'Inputs and Assumptions'!$E$76","v":39.476155002797903},{"$f":"L13/'Inputs and Assumptions'!$F$76","v":37.388220626754958},{"$f":"M13/'Inputs and Assumptions'!$G$76","v":35.584280554230737},{"$f":"N13/'Inputs and Assumptions'!$H$76","v":34.052518444485955},{"$f":"O13/'Inputs and Assumptions'!$I$76","v":32.069727191259368},null,178.57090181952893]
[]
["Unsmoothed Revenue Allocation ($m, real 2019-20)",null,null,null,null,null,null,null,null,"Unsmoothed Revenue Allocation ($m, real 2019-20)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"Total"]
["Non-Capital Revenue (unsmoothed)",{"$f":"B25","v":19.211728513171025},{"$f":"C25","v":18.702811850191633},18.238801977492582,17.797715515834945,17.375357833264211,null,{"$f":"SUM(B32:F32)","v":91.326415689954416},null,"Non-Capital Revenue (unsmoothed)",{"$f":"K25","v":28.885876864237957},{"$f":"L25","v":26.485396832666424},24.382745801279793,22.504397547668145,20.82094323534464,null,{"$f":"SUM(K32:O32)","v":123.07936028119697}]
["Capital Revenue (unsmoothed)",{"$f":"B23+B24+B27","v":43.985941493463486},{"$f":"C23+C24+C27","v":43.225034639535913},42.494563202560798,41.902487824332198,40.548236214751881,null,{"$f":"SUM(B33:F33)","v":212.15626337464428},null,"Capital Revenue (unsmoothed)",{"$f":"K23+K24+K27","v":10.590278138559942},{"$f":"L23+L24+L27","v":10.902823794088539},11.201534752950952,11.548120896817807,11.24878395591473,null,{"$f":"SUM(K33:O33)","v":55.491541538331973}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"B32+B33","v":63.19767000663451},{"$f":"C32+C33","v":61.927846489727543},{"$f":"D32+D33","v":60.733365180053383},{"$f":"E32+E33","v":59.700203340167143},{"$f":"F32+F33","v":57.923594048016092},null,303.48267906459864,null,"Annual Revenue Requirement (unsmoothed)",{"$f":"K32+K33","v":39.476155002797896},{"$f":"L32+L33","v":37.388220626754965},{"$f":"M32+M33","v":35.584280554230745},{"$f":"N32+N33","v":34.052518444485955},{"$f":"O32+O33","v":32.069727191259368},null,178.57090181952893]

{"sheet":"Energex Smoothed Charges","index":4,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,5,3,7]]}
["Energex Smoothed Charges"]
[]
[null,null,null,null,null,{"$f":"IF(ROUND((Energex_Non_Capital_NPV_Difference+Energex_Capital_NPV_Difference),5)<>ROUND(0,5),\"Charges not smoothed. Press button to smooth charges.\", \"Smoothing complete.\")","v":"Charges not smoothed. Press button to smooth charges."}]
[]
["Smoothed Charges"]
[]
["Primary ($, nominal)",null,null,null,null,null,null,"Primary (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B67*1000000/B39*(1-B34)","v":12.255699989150692},{"$f":"B9*(1+C30)*(1-C34)","v":12.552287928888139},{"$f":"C9*(1+D30)*(1-D34)","v":12.856053296767232},{"$f":"D9*(1+E30)*(1-E34)","v":13.167169786549},{"$f":"E9*(1+F30)*(1-F34)","v":13.485815295383485},null,"Non-capital",{"$f":"B9/365*100","v":3.3577260244248475},{"$f":"C9/365*100","v":3.4389829942159285},3.5222063826759542,3.6074437771367123,3.6947439165434206]
["Capital",{"$f":"B68*1000000/B39*(1-B35)","v":24.04140365975428},{"$f":"B10*(1+C30)*(1-C35)","v":24.623205628320335},{"$f":"C10*(1+D30)*(1-D35)","v":25.219087204525685},{"$f":"D10*(1+E30)*(1-E35)","v":25.829389114875205},{"$f":"E10*(1+F30)*(1-F35)","v":26.454460331455184},null,"Capital",{"$f":"B10/365*100","v":6.586685934179255},6.746083733786393,6.9093389601440238,7.0765449629795087,7.2477973510836122]
["Total",{"$f":"B9+B10","v":36.297103648904972},{"$f":"C9+C10","v":37.175493557208476},38.075140501292921,38.996558901424208,39.94027562683867,null,"Total",{"$f":"I9+I10","v":9.9444119586041033},{"$f":"J9+J10","v":10.185066728002322},{"$f":"K9+K10","v":10.431545342819978},{"$f":"L9+L10","v":10.68398874011622},{"$f":"M9+M10","v":10.942541267627032}]
[]
["Load Control ($, nominal)",null,null,null,null,null,null,"Load Control (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B69*1000000/B40*(1-B34)","v":3.6767099967452079},{"$f":"B15*(1+C30)*(1-C34)","v":3.7656863786664418},{"$f":"C15*(1+D30)*(1-D34)","v":3.8568159890301699},{"$f":"D15*(1+E30)*(1-E34)","v":3.9501509359646998},{"$f":"E15*(1+F30)*(1-F34)","v":4.0457445886150456},null,"Non-capital",{"$f":"B15/365*100","v":1.0073178073274542},{"$f":"C15/365*100","v":1.0316948982647784},{"$f":"D15/365*100","v":1.0566619148027863},{"$f":"E15/365*100","v":1.0822331331410135},{"$f":"F15/365*100","v":1.1084231749630262}]
["Capital",{"$f":"B70*1000000/B40*(1-B35)","v":7.2124210979262866},{"$f":"B16*(1+C30)*(1-C35)","v":7.3869616884961031},{"$f":"C16*(1+D30)*(1-D35)","v":7.5657261613577091},{"$f":"D16*(1+E30)*(1-E35)","v":7.748816734462566},{"$f":"E16*(1+F30)*(1-F35)","v":7.9363380994365604},null,"Capital",{"$f":"B16/365*100","v":1.9760057802537769},2.0238251201359185,2.0728016880432079,2.1229634888938538,2.1743392053250852]
["Total",{"$f":"B15+B16","v":10.889131094671495},{"$f":"C15+C16","v":11.152648067162545},{"$f":"D15+D16","v":11.42254215038788},{"$f":"E15+E16","v":11.698967670427265},{"$f":"F15+F16","v":11.982082688051605},null,"Total",{"$f":"I15+I16","v":2.9833235875812312},{"$f":"J15+J16","v":3.055520018400697},{"$f":"K15+K16","v":3.1294636028459939},{"$f":"L15+L16","v":3.2051966220348671},{"$f":"M15+M16","v":3.2827623802881112}]
[]
["Solar PV ($, nominal)",null,null,null,null,null,null,"Solar PV (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B71*1000000/B41*(1-B34)","v":8.5789899924054822},{"$f":"B21*(1+C30)*(1-C34)","v":8.786601550221695},{"$f":"C21*(1+D30)*(1-D34)","v":8.9992373077370598},{"$f":"D21*(1+E30)*(1-E34)","v":9.2170188505842958},{"$f":"E21*(1+F30)*(1-F34)","v":9.4400707067684362},null,"Non-capital",{"$f":"B21/365*100","v":2.3504082170973923},{"$f":"C21/365*100","v":2.4072880959511491},{"$f":"D21/365*100","v":2.4655444678731668},{"$f":"E21/365*100","v":2.5252106439956972},{"$f":"F21/365*100","v":2.5863207415803937}]
["Capital",{"$f":"B72*1000000/B41*(1-B35)","v":16.828982561827996},{"$f":"B22*(1+C30)*(1-C35)","v":17.236243939824234},{"$f":"C22*(1+D30)*(1-D35)","v":17.65336104316798},{"$f":"D22*(1+E30)*(1-E35)","v":18.080572380412644},{"$f":"E22*(1+F30)*(1-F35)","v":18.51812223201863},null,"Capital",{"$f":"B22/365*100","v":4.610680153925478},4.7222586136504745,4.8365372721008164,4.9535814740856559,5.0734581457585293]
["Total",{"$f":"B21+B22","v":25.407972554233478},{"$f":"C21+C22","v":26.022845490045931},{"$f":"D21+D22","v":26.652598350905038},{"$f":"E21+E22","v":27.29759123099694},{"$f":"F21+F22","v":27.958192938787064},null,"Total",{"$f":"I21+I22","v":6.9610883710228704},{"$f":"J21+J22","v":7.1295467096016232},{"$f":"K21+K22","v":7.3020817399739837},{"$f":"L21+L22","v":7.478792118081353},{"$f":"M21+M22","v":7.6597788873389234}]
[]
[]
["Calculations"]
[]
["Inflation"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Inflation Assumption (CPI % increase) (constant)",{"$f":"'Inputs and Assumptions'!E75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!F75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!G75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!H75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!I75","v":2.4199999999999999E-2}]
[]
["X-Factor (used to determine annual metering charges)"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["X-Factor (non-capital)",-8.008305490262245E-2,0,0,0,0]
["X-Factor (capital)",7.4595940182488496E-2,0,0,0,0]
[]
["Network Tariff Code (NTC)",null,null,null,null,null,null,"Customers by Tariff Code"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25",null,"Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary",{"$f":"'Inputs and Assumptions'!E28","v":1320949.9651659997},{"$f":"'Inputs and Assumptions'!F28","v":1281321.4662110198},{"$f":"'Inputs and Assumptions'!G28","v":1242881.8222246892},{"$f":"'Inputs and Assumptions'!H28","v":1205595.3675579485},{"$f":"'Inputs and Assumptions'!I28","v":1169427.5065312099},null,"Primary (Non-capital)",{"$f":"'Inputs and Assumptions'!E40","v":1234256.9822419998},{"$f":"'Inputs and Assumptions'!F40","v":1197229.2727747399},{"$f":"'Inputs and Assumptions'!G40","v":1161312.3945914977},{"$f":"'Inputs and Assumptions'!H40","v":1126473.0227537528},{"$f":"'Inputs and Assumptions'!I40","v":1092678.8320711402}]
["Load Control",{"$f":"'Inputs and Assumptions'!E29","v":657835.53226699994},{"$f":"'Inputs and Assumptions'!F29","v":638100.46629898995},{"$f":"'Inputs and Assumptions'!G29","v":618957.45231002022},{"$f":"'Inputs and Assumptions'!H29","v":600388.72874071961},{"$f":"'Inputs and Assumptions'!I29","v":582377.06687849807},null,"Primary (Capital)",{"$f":"'Inputs and Assumptions'!E41","v":1377896},{"$f":"'Inputs and Assumptions'!F41","v":1377896},{"$f":"'Inputs and Assumptions'!G41","v":1377896},{"$f":"'Inputs and Assumptions'!H41","v":1377896},{"$f":"'Inputs and Assumptions'!I41","v":1377896}]
["Solar PV",{"$f":"'Inputs and Assumptions'!E30","v":308262.60713399999},{"$f":"'Inputs and Assumptions'!F30","v":299014.72891998},{"$f":"'Inputs and Assumptions'!G30","v":290044.28705238062},{"$f":"'Inputs and Assumptions'!H30","v":281342.95844080922},{"$f":"'Inputs and Assumptions'!I30","v":272902.66968758492},null,"Load Control (Non-capital)",{"$f":"'Inputs and Assumptions'!E42","v":621296.6687119999},{"$f":"'Inputs and Assumptions'!F42","v":602657.76865063992},{"$f":"'Inputs and Assumptions'!G42","v":584578.03559112072},{"$f":"'Inputs and Assumptions'!H42","v":567040.69452338712},{"$f":"'Inputs and Assumptions'!I42","v":550029.47368768544}]
["Total",{"$f":"SUM(B39:B41)","v":2287048.1045669997},{"$f":"SUM(C39:C41)","v":2218436.6614299896},{"$f":"SUM(D39:D41)","v":2151883.5615870897},2087327.0547394773,2024707.243097293,null,"Load Control (Capital)",{"$f":"'Inputs and Assumptions'!E43","v":712568},{"$f":"'Inputs and Assumptions'!F43","v":712568},{"$f":"'Inputs and Assumptions'!G43","v":712568},{"$f":"'Inputs and Assumptions'!H43","v":712568},{"$f":"'Inputs and Assumptions'!I43","v":712568}]
[null,null,null,null,null,null,null,"Solar PV (Non-capital)",{"$f":"'Inputs and Assumptions'!E44","v":285185.67032899999},{"$f":"'Inputs and Assumptions'!F44","v":276630.10021912999},{"$f":"'Inputs and Assumptions'!G44","v":268331.19721255609},{"$f":"'Inputs and Assumptions'!H44","v":260281.26129617941},{"$f":"'Inputs and Assumptions'!I44","v":252472.82345729403}]
["Relationships",null,null,null,null,null,null,"Solar PV (Capital)",{"$f":"'Inputs and Assumptions'!E45","v":311438},{"$f":"'Inputs and Assumptions'!F45","v":311438},{"$f":"'Inputs and Assumptions'!G45","v":311438},{"$f":"'Inputs and Assumptions'!H45","v":311438},{"$f":"'Inputs and Assumptions'!I45","v":311438}]
[null,"Factor","Notes:"]
["Primary",1,"Weighted based on meter population"]
["Load Control",0.3,"Cost of Single Phase single element meter only"]
["Solar PV",0.7,"Based on 75% meter replacement vs meter reprogram"]
[]
["Revenue Weights (%)"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary",{"$f":"B39*$B$46/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":0.76175642154449696},{"$f":"C39*$B$46/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":0.76175642154449685},0.76175642154449696,0.76175642154449696,0.76175642154449696]
["Load Control",{"$f":"B40*$B$47/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":0.11380683316681636},{"$f":"C40*$B$47/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":0.11380683316681633},0.11380683316681632,0.11380683316681633,0.11380683316681636]
["Solar PV",{"$f":"B41*$B$48/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":0.1244367452886867},{"$f":"C41*$B$48/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":0.12443674528868667},0.12443674528868669,0.1244367452886867,0.12443674528868671]
[]
["Building Blocks ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Return on Capital",{"$f":"'(EGX&EGN) Building Blocks'!B8","v":18.504939942994966},{"$f":"'(EGX&EGN) Building Blocks'!C8","v":17.137925702193357},{"$f":"'(EGX&EGN) Building Blocks'!D8","v":15.709394407982799},{"$f":"'(EGX&EGN) Building Blocks'!E8","v":14.230592244665676},{"$f":"'(EGX&EGN) Building Blocks'!F8","v":12.679558889403079}]
["Return of Capital (regulatory depreciation)",{"$f":"'(EGX&EGN) Building Blocks'!B9","v":24.607155421280176},{"$f":"'(EGX&EGN) Building Blocks'!C9","v":26.160920567119},{"$f":"'(EGX&EGN) Building Blocks'!D9","v":27.79356677537114},{"$f":"'(EGX&EGN) Building Blocks'!E9","v":29.523492244234447},{"$f":"'(EGX&EGN) Building Blocks'!F9","v":30.618578347652825}]
["Operating Expenditure",{"$f":"'(EGX&EGN) Building Blocks'!B10","v":19.676652343189762},{"$f":"'(EGX&EGN) Building Blocks'!C10","v":19.618981058472855},{"$f":"'(EGX&EGN) Building Blocks'!D10","v":19.595241606230999},{"$f":"'(EGX&EGN) Building Blocks'!E10","v":19.584087758251638},{"$f":"'(EGX&EGN) Building Blocks'!F10","v":19.582025637920928}]
["Revenue Adjustments",{"$f":"'(EGX&EGN) Building Blocks'!B11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!C11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!D11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!E11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!F11","v":0}]
["Net Tax Allowance",{"$f":"'(EGX&EGN) Building Blocks'!B12","v":1.9383059133301579},{"$f":"'(EGX&EGN) Building Blocks'!C12","v":2.0435943560633891},{"$f":"'(EGX&EGN) Building Blocks'!D12","v":2.1519691093816635},{"$f":"'(EGX&EGN) Building Blocks'!E12","v":2.3541926161401534},{"$f":"'(EGX&EGN) Building Blocks'!F12","v":2.3997188157064779}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"'(EGX&EGN) Building Blocks'!B13","v":64.727053620795061},{"$f":"'(EGX&EGN) Building Blocks'!C13","v":64.961421683848599},{"$f":"'(EGX&EGN) Building Blocks'!D13","v":65.250171898966599},{"$f":"'(EGX&EGN) Building Blocks'!E13","v":65.692364863291914},{"$f":"'(EGX&EGN) Building Blocks'!F13","v":65.279881690683311}]
[]
["Unsmoothed Revenue Allocation between Metering Type ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary (Non-Capital)",{"$f":"B60*B52","v":14.988816276923375},{"$f":"C60*C52","v":14.944884805451547},14.926801125262367,14.918304609939158,14.916733776535242]
["Primary (Capital)",{"$f":"(B58+B59+B62)*B52","v":34.317432466372253},{"$f":"(C58+C59+C62)*C52","v":34.539895314880042},34.777936325657727,35.123276171117539,34.810635299007807]
["Load Control (Non-Capital)",{"$f":"B60*B53","v":2.2393374905028436},{"$f":"C60*C53","v":2.2327741042245499},2.2300723923437893,2.2288030082276342,2.228568324843188]
["Load Control (Capital)",{"$f":"(B58+B59+B62)*B53","v":5.1270435022985579},{"$f":"(C58+C59+C62)*C53","v":5.1602795756284126},5.1958430350679894,5.2474370001026553,5.200728279877918]
["Solar PV (Non-Capital)",{"$f":"B60*B54","v":2.4484985757635447},{"$f":"C60*C54","v":2.4413221487967549},2.4383680886248427,2.4369801400848465,2.4367235365424995]
["Solar PV (Capital)",{"$f":"(B58+B59+B62)*B54","v":5.6059253089344967},{"$f":"(C58+C59+C62)*C54","v":5.64226573486728},5.6811509320098859,5.7375639338200815,5.6864924738766627]
["Annual Revenue Requirement (unsmoothed)",{"$f":"SUM(B67:B72)","v":64.727053620795061},{"$f":"SUM(C67:C72)","v":64.961421683848585},65.250171898966599,65.692364863291914,65.279881690683325]
[]
["Unsmoothed Revenue Allocation ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"NPV"]
["Non-Capital Revenue (unsmoothed)",{"$f":"B60","v":19.676652343189762},{"$f":"C60","v":19.618981058472855},19.595241606230999,19.584087758251638,19.582025637920928,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B77:F77)","v":83.851252822008277}]
["Capital Revenue (unsmoothed)",{"$f":"B58+B59+B62","v":45.050401277605303},{"$f":"C58+C59+C62","v":45.342440625375744},45.6549302927356,46.108277105040273,45.697856052762383,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B78:F78)","v":194.72517375310488}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"B77+B78","v":64.727053620795061},{"$f":"C77+C78","v":64.961421683848599},65.250171898966599,65.692364863291914,65.279881690683311,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B79:F79)","v":278.57642657511315}]
[]
["Calculated Revenue Allocation ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"NPV"]
["Non-Capital Revenue (smoothed)",{"$f":"(B9*I39+B15*I41+B21*I43)/1000000","v":19.857615968400289},{"$f":"(C9*J39+C15*J41+C21*J43)/1000000","v":19.728025166590513},19.599280074353342,19.471375172588111,19.344304978211802,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B83:F83)","v":83.850970595622996}]
["Capital Revenue (smoothed)",{"$f":"(B10*I40+B16*I42+B22*I44)/1000000","v":43.507079085158509},{"$f":"(C10*J40+C16*J42+C22*J44)/1000000","v":44.559950399019343},45.638301198675613,46.742748087683559,47.873922591405503,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B84:F84)","v":194.72517375310485}]
["Annual Revenue Requirement (smoothed)",{"$f":"B83+B84","v":63.364695053558798},{"$f":"C83+C84","v":64.287975565609855},{"$f":"D83+D84","v":65.237581273028951},{"$f":"E83+E84","v":66.214123260271663},{"$f":"F83+F84","v":67.218227569617312},null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Energex Smoothed Charges'!B85:F85)","v":278.57614434872784}]
[]
[]
[null,null,null,null,null,"Difference in Final Year Revenue",null,"NPV Difference"]
[null,null,null,null,null,{"$f":"F85/F79-1","v":2.9692852203968334E-2},null,{"$f":"H77-H83","v":2.8222638528063726E-4}]
[null,null,null,null,null,null,null,{"$f":"H78-H84","v":0}]
[]
[]
["Notes"]
["- Values in green cells were sourced from the AER's preliminary decision Energex - Metering Pricing Model - April 2015.xlsx "]
[]
[]
[]
["Return to top"]

{"sheet":"Ergon Smoothed Charges","index":5,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,5,3,7]]}
["Ergon Smoothed Charges"]
[]
[null,null,null,null,null,{"$f":"IF(ROUND((Ergon_Non_Capital_NPV_Difference+Ergon_Capital_NPV_Difference),5)<>ROUND(0, 5),\"Charges not smoothed. Press button to smooth charges.\", \"Smoothing complete.\")","v":"Charges not smoothed. Press button to smooth charges."}]
[]
["Smoothed Charges"]
[]
["Primary ($, nominal)",null,null,null,null,null,null,"Primary (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B67*1000000/B39*(1-B34)","v":39.049188548209649},{"$f":"B9*(1+C30)*(1-C34)","v":39.994178911076325},{"$f":"C9*(1+D30)*(1-D34)","v":40.962038040724373},{"$f":"D9*(1+E30)*(1-E34)","v":41.953319361309902},{"$f":"E9*(1+F30)*(1-F34)","v":42.968589689853601},null,"Non-capital",{"$f":"B9/365*100","v":10.698407821427301},{"$f":"C9/365*100","v":10.957309290705842},11.222476175540924,11.494060098989015,11.772216353384549]
["Capital",{"$f":"B68*1000000/B39*(1-B35)","v":11.74220814931209},{"$f":"B10*(1+C30)*(1-C35)","v":12.026369586525442},{"$f":"C10*(1+D30)*(1-D35)","v":12.317407730519358},{"$f":"D10*(1+E30)*(1-E35)","v":12.615488997597927},{"$f":"E10*(1+F30)*(1-F35)","v":12.920783831339797},null,"Capital",{"$f":"B10/365*100","v":3.2170433285786544},3.2948957771302578,3.3746322549368104,3.4562983555062812,3.5399407757095331]
["Total",{"$f":"B9+B10","v":50.791396697521741},{"$f":"C9+C10","v":52.020548497601766},53.279445771243729,54.56880835890783,55.889373521193399,null,"Total",{"$f":"I9+I10","v":13.915451150005955},{"$f":"J9+J10","v":14.252205067836099},14.597108430477736,14.950358454495296,15.312157129094082]
[]
["Load Control ($, nominal)",null,null,null,null,null,null,"Load Control (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B69*1000000/B40*(1-B34)","v":14.357522052901942},{"$f":"B15*(1+C30)*(1-C34)","v":14.704974086582169},{"$f":"C15*(1+D30)*(1-D34)","v":15.060834459477457},{"$f":"D15*(1+E30)*(1-E34)","v":15.425306653396811},{"$f":"E15*(1+F30)*(1-F34)","v":15.798599074409013},null,"Non-capital",{"$f":"B15/365*100","v":3.9335676857265591},{"$f":"C15/365*100","v":4.0287600237211425},4.1262560162951933,4.2261114118895371,4.3283833080572638]
["Capital",{"$f":"B70*1000000/B40*(1-B35)","v":4.317349955822392},{"$f":"B16*(1+C30)*(1-C35)","v":4.4218298247532939},{"$f":"C16*(1+D30)*(1-D35)","v":4.5288381065123238},{"$f":"D16*(1+E30)*(1-E35)","v":4.6384359886899222},{"$f":"E16*(1+F30)*(1-F35)","v":4.7506861396162181},null,"Capital",{"$f":"B16/365*100","v":1.182835604334902},1.2114602259598066,1.240777563428034,1.2708043804629925,1.3015578464701967]
["Total",{"$f":"B15+B16","v":18.674872008724336},{"$f":"C15+C16","v":19.126803911335465},19.58967256598978,20.063742642086734,20.549285214025232,null,"Total",{"$f":"I15+I16","v":5.1164032900614611},{"$f":"J15+J16","v":5.2402202496809487},5.3670335797232269,5.4969157923525298,5.6299411545274607]
[]
["Solar PV ($, nominal)",null,null,null,null,null,null,"Solar PV (cents per day, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Non-capital",{"$f":"B71*1000000/B41*(1-B34)","v":9.7102925809478862},{"$f":"B21*(1+C30)*(1-C34)","v":9.9452816614068258},{"$f":"C21*(1+D30)*(1-D34)","v":10.18595747761287},{"$f":"D21*(1+E30)*(1-E34)","v":10.432457648571102},{"$f":"E21*(1+F30)*(1-F34)","v":10.684923123666522},null,"Non-capital",{"$f":"B21/365*100","v":2.6603541317665442},{"$f":"C21/365*100","v":2.7247347017552945},2.7906732815377726,2.858207574950987,2.9273761982648003]
["Capital",{"$f":"B72*1000000/B41*(1-B35)","v":2.9199141112866642},{"$f":"B22*(1+C30)*(1-C35)","v":2.9905760327798014},{"$f":"C22*(1+D30)*(1-D35)","v":3.0629479727730726},{"$f":"D22*(1+E30)*(1-E35)","v":3.137071313714181},{"$f":"E22*(1+F30)*(1-F35)","v":3.2129884395060642},null,"Capital",{"$f":"B22/365*100","v":0.79997646884566143},0.81933589939172635,0.83916382815700619,0.85947159279840568,0.88027080534412716]
["Total",{"$f":"B21+B22","v":12.63020669223455},{"$f":"C21+C22","v":12.935857694186627},13.248905450385942,13.569528962285283,13.897911563172586,null,"Total",{"$f":"I21+I22","v":3.4603306006122057},{"$f":"J21+J22","v":3.5440706011470207},3.6298371096947788,3.7176791677493926,3.8076470036089276]
[]
[]
["Calculations"]
[]
["Inflation"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Inflation Assumption (CPI % increase) (constant)",{"$f":"'Inputs and Assumptions'!E75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!F75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!G75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!H75","v":2.4199999999999999E-2},{"$f":"'Inputs and Assumptions'!I75","v":2.4199999999999999E-2}]
[]
["X-Factor (used to determine annual metering charges)"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["X-Factor (non-capital)",-2.4459387425345498E-2,0,0,0,0]
["X-Factor (capital)",0.15974579085737348,0,0,0,0]
[]
["Network Tariff Code (NTC)",null,null,null,null,null,null,"Customers by Tariff Code"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25",null,"Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary",{"$f":"'Inputs and Assumptions'!E32","v":623087.44908800011},{"$f":"'Inputs and Assumptions'!F32","v":573240.45316096011},{"$f":"'Inputs and Assumptions'!G32","v":527381.2169080833},{"$f":"'Inputs and Assumptions'!H32","v":485190.71955543663},{"$f":"'Inputs and Assumptions'!I32","v":446375.46199100174},null,"Primary (Non-capital)",{"$f":"'Inputs and Assumptions'!E47","v":607419.46784000006},{"$f":"'Inputs and Assumptions'!F47","v":558825.91041280003},{"$f":"'Inputs and Assumptions'!G47","v":514119.83757977607},{"$f":"'Inputs and Assumptions'!H47","v":472990.25057339401},{"$f":"'Inputs and Assumptions'!I47","v":435151.0305275225}]
["Load Control",{"$f":"'Inputs and Assumptions'!E33","v":343381.16211200005},{"$f":"'Inputs and Assumptions'!F33","v":315910.66914304008},{"$f":"'Inputs and Assumptions'!G33","v":290637.81561159686},{"$f":"'Inputs and Assumptions'!H33","v":267386.7903626691},{"$f":"'Inputs and Assumptions'!I33","v":245995.84713365557},null,"Primary (Capital)",{"$f":"'Inputs and Assumptions'!E48","v":777218},{"$f":"'Inputs and Assumptions'!F48","v":777218},{"$f":"'Inputs and Assumptions'!G48","v":777218},{"$f":"'Inputs and Assumptions'!H48","v":777218},{"$f":"'Inputs and Assumptions'!I48","v":777218}]
["Solar PV",{"$f":"'Inputs and Assumptions'!E34","v":107863.08307200002},{"$f":"'Inputs and Assumptions'!F34","v":99234.036426240025},{"$f":"'Inputs and Assumptions'!G34","v":91295.313512140827},{"$f":"'Inputs and Assumptions'!H34","v":83991.688431169561},{"$f":"'Inputs and Assumptions'!I34","v":77272.353356676002},null,"Load Control (Non-capital)",{"$f":"'Inputs and Assumptions'!E49","v":335790.51148800005},{"$f":"'Inputs and Assumptions'!F49","v":308927.27056896006},{"$f":"'Inputs and Assumptions'!G49","v":284213.08892344328},{"$f":"'Inputs and Assumptions'!H49","v":261476.04180956783},{"$f":"'Inputs and Assumptions'!I49","v":240557.95846480242}]
["Total",{"$f":"SUM(B39:B41)","v":1074331.6942720001},{"$f":"SUM(C39:C41)","v":988385.15873024019},909314.3460318211,836569.19834927539,769643.66248133336,null,"Load Control (Capital)",{"$f":"'Inputs and Assumptions'!E50","v":433510},{"$f":"'Inputs and Assumptions'!F50","v":433510},{"$f":"'Inputs and Assumptions'!G50","v":433510},{"$f":"'Inputs and Assumptions'!H50","v":433510},{"$f":"'Inputs and Assumptions'!I50","v":433510}]
[null,null,null,null,null,null,null,"Solar PV (Non-capital)",{"$f":"'Inputs and Assumptions'!E51","v":106893.61651200001},{"$f":"'Inputs and Assumptions'!F51","v":98342.12719104001},{"$f":"'Inputs and Assumptions'!G51","v":90474.757015756812},{"$f":"'Inputs and Assumptions'!H51","v":83236.77645449627},{"$f":"'Inputs and Assumptions'!I51","v":76577.83433813657}]
["Relationships",null,null,null,null,null,null,"Solar PV (Capital)",{"$f":"'Inputs and Assumptions'!E52","v":122277},{"$f":"'Inputs and Assumptions'!F52","v":122277},{"$f":"'Inputs and Assumptions'!G52","v":122277},{"$f":"'Inputs and Assumptions'!H52","v":122277},{"$f":"'Inputs and Assumptions'!I52","v":122277}]
[null,"Factor"]
["Primary",1]
["Load Control",0.36767785930241087]
["Solar PV",0.24866822953208562]
[]
["Revenue Weights (%)"]
["Year","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary",{"$f":"B39*$B$46/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":0.8027788894783755},{"$f":"C39*$B$46/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":0.80277888947837539},0.8027788894783755,0.80277888947837561,0.8027788894783755]
["Load Control",{"$f":"B40*$B$47/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":0.16266378913221208},{"$f":"C40*$B$47/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":0.16266378913221208},0.16266378913221208,0.16266378913221211,0.16266378913221208]
["Solar PV",{"$f":"B41*$B$48/SUMPRODUCT(B$39:B$41,$B$46:$B$48)","v":3.4557321389412352E-2},{"$f":"C41*$B$48/SUMPRODUCT(C$39:C$41,$B$46:$B$48)","v":3.4557321389412352E-2},3.4557321389412352E-2,3.4557321389412358E-2,3.4557321389412352E-2]
[]
["Building Blocks ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Return on Capital",{"$f":"'(EGX&EGN) Building Blocks'!K8","v":4.5144307017850345},{"$f":"'(EGX&EGN) Building Blocks'!L8","v":4.3601650482363343},{"$f":"'(EGX&EGN) Building Blocks'!M8","v":4.1784307910298706},{"$f":"'(EGX&EGN) Building Blocks'!N8","v":3.9514427379047605},{"$f":"'(EGX&EGN) Building Blocks'!O8","v":3.6556481642900049}]
["Return of Capital (regulatory depreciation)",{"$f":"'(EGX&EGN) Building Blocks'!K9","v":6.1287769994719845},{"$f":"'(EGX&EGN) Building Blocks'!L9","v":6.8572459584276038},{"$f":"'(EGX&EGN) Building Blocks'!M9","v":7.6180114087865594},{"$f":"'(EGX&EGN) Building Blocks'!N9","v":8.3971243342662234},{"$f":"'(EGX&EGN) Building Blocks'!O9","v":8.6574816193005883}]
["Operating Expenditure",{"$f":"'(EGX&EGN) Building Blocks'!K10","v":29.584915084352517},{"$f":"'(EGX&EGN) Building Blocks'!L10","v":27.78280094716856},{"$f":"'(EGX&EGN) Building Blocks'!M10","v":26.196117244378161},{"$f":"'(EGX&EGN) Building Blocks'!N10","v":24.763183574206042},{"$f":"'(EGX&EGN) Building Blocks'!O10","v":23.465199862512399}]
["Revenue Adjustments",{"$f":"'(EGX&EGN) Building Blocks'!K11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!L11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!M11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!N11","v":0},{"$f":"'(EGX&EGN) Building Blocks'!O11","v":0}]
["Net Tax Allowance",{"$f":"'(EGX&EGN) Building Blocks'!K12","v":0.20335516825607258},{"$f":"'(EGX&EGN) Building Blocks'!L12","v":0.21949458878525446},{"$f":"'(EGX&EGN) Building Blocks'!M12","v":0.23816293025378155},{"$f":"'(EGX&EGN) Building Blocks'!N12","v":0.35864879971782637},{"$f":"'(EGX&EGN) Building Blocks'!O12","v":0.36424802548410051}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"'(EGX&EGN) Building Blocks'!K13","v":40.43147795386561},{"$f":"'(EGX&EGN) Building Blocks'!L13","v":39.21970654261775},{"$f":"'(EGX&EGN) Building Blocks'!M13","v":38.230722374448369},{"$f":"'(EGX&EGN) Building Blocks'!N13","v":37.470399446094852},{"$f":"'(EGX&EGN) Building Blocks'!O13","v":36.142577671587091}]
[]
["Unsmoothed Revenue Allocation between Metering Type ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25"]
["Primary (Non-Capital)",{"$f":"B60*B52","v":23.750145276728553},{"$f":"C60*C52","v":22.303446090966734},21.029689910087221,19.879361009650278,18.837367087015835]
["Primary (Capital)",{"$f":"(B58+B59+B62)*B52","v":8.7073916950451018},{"$f":"(C58+C59+C62)*C52","v":9.1813063729837197},9.6611269416285257,10.201084645996888,10.177131279066783]
["Load Control (Non-Capital)",{"$f":"B60*B53","v":4.8123943887755178},{"$f":"C60*C53","v":4.5192556747724488},4.2611596915222334,4.0280732711569103,3.8169383223809286]
["Load Control (Capital)",{"$f":"(B58+B59+B62)*B53","v":1.7643430154157587},{"$f":"(C58+C59+C62)*C53","v":1.8603704001031638},1.9575944711671787,2.0670038830424202,2.0621503106847108]
["Solar PV (Non-Capital)",{"$f":"B60*B54","v":1.0223754188484433},{"$f":"C60*C54","v":0.96009918142937378},0.9052676427687032,0.85574929339885519,0.81089445311563546]
["Solar PV (Capital)",{"$f":"(B58+B59+B62)*B54","v":0.37482815905223055},{"$f":"(C58+C59+C62)*C54","v":0.39522882236230616},0.41588371727450696,0.43912734284950339,0.43809621932319842]
["Annual Revenue Requirement (unsmoothed)",{"$f":"SUM(B67:B72)","v":40.431477953865603},{"$f":"SUM(C67:C72)","v":39.219706542617743},38.230722374448362,37.470399446094859,36.142577671587091]
[]
["Unsmoothed Revenue Allocation ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"NPV"]
["Non-Capital Revenue (unsmoothed)",{"$f":"B60","v":29.584915084352517},{"$f":"C60","v":27.78280094716856},26.196117244378161,24.763183574206042,23.465199862512399,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B77:F77)","v":113.37930524686971}]
["Capital Revenue (unsmoothed)",{"$f":"B58+B59+B62","v":10.846562869513091},{"$f":"C58+C59+C62","v":11.436905595449192},12.034605130070211,12.70721587188881,12.677377809074693,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B78:F78)","v":50.821879134174104}]
["Annual Revenue Requirement (unsmoothed)",{"$f":"B77+B78","v":40.43147795386561},{"$f":"C77+C78","v":39.21970654261775},38.230722374448376,37.470399446094852,36.142577671587091,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B79:F79)","v":164.20118438104382}]
[]
["Calculated Revenue Allocation ($m, nominal)"]
[null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"NPV"]
["Non-Capital Revenue (smoothed)",{"$f":"(B9*I39+B15*I41+B21*I43)/1000000","v":29.578325292748676},{"$f":"(C9*J39+C15*J41+C21*J43)/1000000","v":27.870591103646539},26.2614546556864,24.745223309685695,23.316533096677684,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B83:F83)","v":113.37920805919255}]
["Capital Revenue (smoothed)",{"$f":"(B10*I40+B16*I42+B22*I44)/1000000","v":11.354908250526409},{"$f":"(C10*J40+C16*J42+C22*J44)/1000000","v":11.629697030189147},11.911135698319725,12.199385182219062,12.494610303628763,null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B84:F84)","v":50.821303763152024}]
["Annual Revenue Requirement (smoothed)",{"$f":"B83+B84","v":40.933233543275087},{"$f":"C83+C84","v":39.500288133835689},{"$f":"D83+D84","v":38.172590354006125},{"$f":"E83+E84","v":36.944608491904759},{"$f":"F83+F84","v":35.811143400306449},null,{"$f":"NPV('Inputs and Assumptions'!$E$81, 'Ergon Smoothed Charges'!B85:F85)","v":164.20051182234457}]
[]
[]
[null,null,null,null,null,"Difference in Final Year Revenue",null,"NPV Difference"]
[null,null,null,null,null,{"$f":"F85/F79-1","v":-9.1701890853566059E-3},null,{"$f":"H77-H83","v":9.7187677155829988E-5}]
[null,null,null,null,null,null,null,{"$f":"H78-H84","v":5.7537102208016222E-4}]
[]
[]
["Notes"]
["- Values in green cells were sourced from the AER's preliminary decision Ergon Energy - Metering Pricing Model - April 2015.xlsx "]
[]
[]
[]
["Return to top"]