{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AER Under recovery","SAPN Under recovery"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":29,"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":"AER Under recovery","index":0,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,"Under recovery for the 2015-2020 RCP",null,null,null,"AER Final Decision"]
[null,null,"[Under recovery]"]
[null,null,"Used to calculate the under/over recovery for the 2015-2020 RCP"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020]
[null,null,null,null,null,null,null,null,"2015-16","2016-17","2017-18","2018-19","2019-20",null,null,null,{"$f":"I10","v":"2015-16"},{"$f":"J10","v":"2016-17"},"2017-18","2018-19","2019-20"]
[null,null,"Present value, nominal WACC"]
[null,null,"Nominal vanilla WACC",null,null,null,null,null,6.1679999999999999E-2,6.1856401757822851E-2,6.1753980592531385E-2,6.1290228084052739E-2,6.0856782764485799E-2]
[null,null,"Forecast Inflation",null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,null,null,"Cumulative Forecast CPI",{"$f":"I13+1","v":1.0249999999999999},{"$f":"Q13*(1+J13)","v":1.0506249999999999},{"$f":"R13*(1+K13)","v":1.0768906249999999},1.1038128906249998,1.1314082128906247]
[null,null,"Ex ante real vanilla WACC",null,null,null,null,null,3.5785365853658657E-2,3.5957465129583532E-2,3.5857542041494161E-2,3.5405100569807724E-2,3.4982227087303253E-2]
[null,null,"Actual inflation (Dec on Dec)",null,null,null,null,null,1.6885553470919357E-2,1.4760147601476037E-2,1.9090909090909047E-2,1.7841213202497874E-2,1.8404907975460238E-2,null,null,"Cumulative Actual CPI",{"$f":"I15+1","v":1.0168855534709194},{"$f":"Q15*(1+J15)","v":1.0318949343339587},{"$f":"R15*(1+K15)","v":1.0515947467166979},1.0703564727954973,1.0900562851782367]
[null,null,"Ex post nominal vanilla WACC",null,null,null,null,null,{"$f":"(1+I14)*(1+I15)-1","v":5.3275175033176358E-2},{"$f":"(1+J14)*(1+J15)-1","v":5.1248350223747074E-2},5.5633004207740866E-2,5.3877983720027389E-2,5.4030979733082019E-2]
[]
["Over/Under recovery for the 2015-20 Regulatory Control Period (RCP)"]
[]
[null,null,"Capital building bolck costs ESCoSA PLAB ($m) - recovered through tariffs for the 2015-20 RCP"]
[null,null,"PTRM calculations are based on End of Year Cashflows",null,null,null,null,null,{"$f":"I$10","v":"2015-16"},"2016-17","2017-18","2018-19"]
[null,null,"Return on asset",null,null,null,null,null,2.2545809863122646,2.1767584231444967,2.2948765951571399,2.5243566735915897]
[null,null,"Return of asset ",null,null,null,null,null,4.1584435051130457,1.0644729427789046,1.1749248294645149,1.31725725911423]
[null,null,"O&M",null,null,null,null,null,1.8208811905503469E-2,1.7530153349928648E-2,1.8512049991086542E-2,2.051727194137893E-2]
[null,null,"Carry-over amounts",null,null,null,null,null,0,0,0,0]
[null,null,"Tax payable ",null,null,null,null,null,0.85158862653245193,0.14659532180196397,0,0.390097466112445]
[null,null,"Total building block revenue ","With Forecast CPI",null,null,null,null,{"$f":"SUM(I22:I26)","v":7.2828219298632657},{"$f":"SUM(J22:J26)","v":3.4053568410752937},3.4883134746127413,4.2522286707596439]
[]
[]
[null,null,"Capital building bolck costs AER PLAB ($m) - used to determine over or under recovery"]
[null,null,"PTRM calculations are based on End of Year Cashflows",null,null,null,null,null,{"$f":"I$10","v":"2015-16"},"2016-17","2017-18","2018-19"]
[null,null,"Return on asset",null,null,null,null,null,2.3564637597278555,2.37391099051308,2.383881151917012,2.6168526181869556]
[null,null,"Return of asset ",null,null,null,null,null,2.6229773036043613,2.8104586504500437,1.1070545746799691,1.2468942893599477]
[null,null,"O&M",null,null,null,null,null,1.9031654051693107E-2,1.9117887984399836E-2,1.9230021845281352E-2,2.1269053362994658E-2]
[null,null,"Carry-over amounts",null,null,null,null,null,0,0,0,0]
[null,null,"Tax payable ",null,null,null,null,null,0.52747859716166623,0.8104866813674928,0.12095686518679796,0.41833141449926903]
[null,null,"Total building block revenue ","With Forecast CPI",null,null,null,null,{"$f":"SUM(I32:I36)","v":5.5259513145455763},{"$f":"SUM(J32:J36)","v":6.0139742103150162},3.6311226136290604,4.3033473754091673]
[]
[]
[null,null,"2015-20 RCP"]
[null,null,"Over/under-recover ($m)","End of Year Cashflows",null,null,null,null,{"$f":"I37-I27","v":-1.7568706153176894},{"$f":"J37-J27","v":2.6086173692397225},0.14280913901631909,5.1118704649523394E-2]
[]
[null,null,"Cumulative - nominal WACC ($m)","End of Year Cashflows",null,null,null,null,{"$f":"I41","v":-1.7568706153176894},{"$f":"I43*(1+J$16)+J41","v":0.76171003333042209},{"$f":"J43*(1+K$16)+K41","v":0.94689538983609101},{"$f":"K43*(1+L$16)+L41","v":1.0490309088837724},{"$f":"L43*(1+M$16)","v":1.1057110766610481},"Under recovery"]

{"sheet":"SAPN Under recovery","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,"Under recovery for the 2015-2020 RCP",null,null,null,"SAPN Revised Proposal"]
[null,null,"[Under recovery]"]
[null,null,"Used to calculate the under/over recovery for the 2015-2020 RCP"]
[]
[]
[]
[]
[]
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,null,null,"2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,null,"Present value, nominal WACC"]
[null,null,"Nominal vanilla WACC",9.7619999999999998E-2,9.7619999999999998E-2,9.7619999999999998E-2,9.7619999999999998E-2,9.7619999999999998E-2,6.1679999999999999E-2,6.1856401757822851E-2,6.1753980592531385E-2,6.1290228084052739E-2,6.0856782764485799E-2]
[null,null,"Forecast Inflation",2.52E-2,2.52E-2,2.52E-2,2.52E-2,2.52E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,"Ex ante real vanilla WACC",7.0639875146313091E-2,7.0639875146313091E-2,7.0639875146313091E-2,7.0639875146313091E-2,7.0639875146313091E-2,3.5785365853658657E-2,3.5957465129583532E-2,3.5857542041494161E-2,3.5405100569807724E-2,3.4982227087303253E-2]
[null,null,"Actual inflation",3.2563025210083918E-2,1.6276703967446737E-2,2.5025025025025016E-2,2.9296875E-2,1.3282732447817747E-2,1.3108614232209881E-2,2.1256931608133023E-2,1.9004524886877761E-2,1.3321492007104752E-2,0]
[null,null,"Ex post nominal vanilla WACC",0.10550314839162356,8.8066363449813778E-2,9.7432664814639303E-2,0.10200627773849025,8.486089815584652E-2,4.9363076642002568E-2,5.7978742114777937E-2,5.5543522478481711E-2,4.9198241341164017E-2,3.4982227087303253E-2]
[]
["Over/Under recovery for the 2015-20 Regulatory Control Period (RCP)"]
[]
[null,null,"Capital building bolck costs ESCoSA PLAB ($m) - recovered through tariffs for the 2015-20 RCP"]
[null,null,null,{"$f":"D$10","v":"2010-11"},{"$f":"E$10","v":"2011-12"},"2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
[null,null,"Return on asset",null,null,null,null,null,2.2545809863122646,2.1767584231444967,2.2948765951571399,2.5243566735915897]
[null,null,"Return of asset ",null,null,null,null,null,4.1584435051130457,1.0644729427789046,1.1749248294645149,1.31725725911423]
[null,null,"O&M",null,null,null,null,null,1.8208811905503469E-2,1.7530153349928648E-2,1.8512049991086542E-2,2.051727194137893E-2]
[null,null,"Carry-over amounts",null,null,null,null,null,0,0,0,0]
[null,null,"Tax payable ",null,null,null,null,null,0.85158862653245193,0.14659532180196397,0,0.390097466112445]
[null,null,"Total building block revenue ",null,null,null,null,null,{"$f":"SUM(I22:I26)","v":7.2828219298632657},{"$f":"SUM(J22:J26)","v":3.4053568410752937},3.4883134746127413,4.2522286707596439]
[]
[]
[null,null,"Capital building bolck costs AER PLAB ($m) - used to determine over or under recovery"]
[null,null,null,{"$f":"D$10","v":"2010-11"},{"$f":"E$10","v":"2011-12"},"2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
[null,null,"Return on asset",null,null,null,null,null,2.3564637597278555,2.37391099051308,2.383881151917012,2.6168526181869556]
[null,null,"Return of asset ",null,null,null,null,null,2.6229773036043613,2.8104586504500437,1.1070545746799691,1.2468942893599477]
[null,null,"O&M",null,null,null,null,null,1.9031654051693107E-2,1.9117887984399836E-2,1.9230021845281352E-2,2.1269053362994658E-2]
[null,null,"Carry-over amounts",null,null,null,null,null,0,0,0,0]
[null,null,"Tax payable ",null,null,null,null,null,0.52747859716166623,0.8104866813674928,0.12095686518679796,0.41833141449926903]
[null,null,"Total building block revenue ",null,null,null,null,null,{"$f":"SUM(I32:I36)","v":5.5259513145455763},{"$f":"SUM(J32:J36)","v":6.0139742103150162},3.6311226136290604,4.3033473754091673]
[]
[]
[null,null,"2015-20 RCP"]
[null,null,"Over/under-recover ($m)",null,null,null,null,null,{"$f":"I37-I27","v":-1.7568706153176894},{"$f":"J37-J27","v":2.6086173692397225},0.14280913901631909,5.1118704649523394E-2]
[]
[null,null,"Cumulative - nominal WACC ($m)",null,null,null,null,null,{"$f":"I41*(1+I$16)^0.5","v":-1.7997105747511752},{"$f":"I43*(1+J$16)+J41*(1+J$16)^0.5","v":0.7791185655415489},{"$f":"J43*(1+K$16)+K41*(1+K$16)^0.5","v":0.96911516151496824},{"$f":"K43*(1+L$16)+L41*(1+L$16)^0.5","v":1.0691550057098862},{"$f":"L43*(1+M$16)+M41*(1+M$16)^0.5","v":1.1065564289111565},{"$f":"M43","v":1.1065564289111565},null,"Under recovery"]