{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Changelog","Inputs","Calculations","Outputs","Proof Prudent Discount"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Changelog","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["No.","Sheet","Cell","Changes"]
[1,"Inputs","C19:G19","Updated nominal building block revenue from PTRM"]
[2,"Inputs","C24:G24","Revised GPG demand"]
[3,"Inputs","C27:G27","Revised westbound demand"]
[4,"Inputs","C28:G28","Removed competitve westbound demand"]
[5,"Inputs","C33:G33","Removed westbound set prices"]
[6,"Inputs","C39","Updated forecast inflation"]
[7,"Inputs","C42:G43","Expanded WACC section to allow for annual changes in the WACC and formed an index"]
[8,"Inputs","C52:G52","Updated real smoothed revenue from PTRM"]
[9,"Calculations","C21:G21\nC44:G44\nC69:G69","Updated X factors"]
[10,"Calculations","I16, I19, I27, I52, I57, I60, I64, I75, I76","Updated formula to take into account annual changes in the WACC"]
[]
["AER amendments are highligted in green"]

{"sheet":"Inputs","index":1,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,6],[22,2,22,6],[24,2,25,6],[33,2,34,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Roma Brisbane Pipeline"]
["Reference Tariff Model"]
[]
["Item","Dollars","FY2023","FY2024","FY2025","FY2026","FY2027"]
[]
[]
["Building Block Revenue"]
[]
["Building Block Revenue from PTRM","Forecast Nom",40.03600246380401,41.620069903648641,43.977482901288347,45.597225958129016,42.522282905884488]
[]
["Demand"]
[]
["Eastbound C&I"," TJ MDQ/Day","Confidential"]
["GPG"," TJ MDQ/Day",17.927501282320858,17.816501282320861,17.701501282320859,17.712501282320858,17.820501282320858]
["Prudent Discount"," TJ MDQ/Day","Confidential"]
["Prudent Discount Volumes","GJ"]
["Westbound"," TJ MDQ/Day",114.32291666666667,114.32291666666667,114.32291666666667,114.32291666666667,114.32291666666667]
["Competitive Westbound"," TJ MDQ/Day"]
["Total Westbound"," TJ MDQ/Day",{"$f":"SUM(C27:C28)","v":114.32291666666667},{"$f":"SUM(D27:D28)","v":114.32291666666667},114.32291666666667,114.32291666666667,114.32291666666667]
[]
["Set Prices"]
[]
["Westbound","$/GJ MDQ/Day"]
["Prudent Discount","$/GJ MDQ/Day","Confidential"]
["Prudent Discount","$/GJ"]
[]
["Other inputs",null,"FY2022"]
[]
["CPI",null,2.2498471879899951E-2]
["$FY22 index",null,{"$f":"1*(1+C39)","v":1.0224984718799},{"$f":"C40*(1+FY22Inf)","v":1.0455031249967306},{"$f":"D40*(1+FY22Inf)","v":1.069025347654817},{"$f":"E40*(1+FY22Inf)","v":1.0930767843779292},{"$f":"F40*(1+FY22Inf)","v":1.1176693416738275}]
[]
["WACC","nominal vanilla ",4.331650335119043E-2,4.202786956018624E-2,4.0739235769182043E-2,3.9450601978177846E-2,3.8161968187173656E-2]
["index",null,{"$f":"1*(1+C42)","v":1.0433165033511904},{"$f":"C43*(1+D42)","v":1.087164873264024},{"$f":"D43*(1+E42)","v":1.1314551393559},1.1760917257147936,1.2209737007367196]
["Days in Year","days",365,366,365,365,365]
[]
["Terajoule","GJ",1000,1000,1000,1000,1000]
[]
["FY 2022 Forecast Revenue","$FY22",42.354600000000005]
[]
["Reference tariff","$FY22",0.58019200995573394]
[]
["Real Revenue from PTRM","$FY22",41.19114797972923,40.481316872387644,39.734867200978954,39.357717921728025,39.000054375748761]

{"sheet":"Calculations","index":2,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[38,2,40,6],[10,0,10,6],[11,0,11,6],[29,2,30,6],[32,2,33,6],[35,2,35,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Roma Brisbane Pipeline"]
["Reference Tariff Model"]
[]
["Item","Dollars","FY2023","FY2024","FY2025","FY2026","FY2027",null,"NPV"]
[]
["Building Block Revenue",{"$f":"Inputs!B19","v":"Forecast Nom"},{"$f":"Inputs!C19","v":40.03600246380401},{"$f":"Inputs!D19","v":41.620069903648641},{"$f":"Inputs!E19","v":43.977482901288347},{"$f":"Inputs!F19","v":45.597225958129016},{"$f":"Inputs!G19","v":42.522282905884488},null,{"$f":"(C16/Inputs!C$43+D16/Inputs!D$43+E16/Inputs!E$43+F16/Inputs!F$43+G16/Inputs!G$43)","v":189.12164708982129}]
[]
["Total Volumes","GJ MDQ/year",96305402.551380441,95577026.969329447,94726412.551380455,94730427.551380441,94769847.551380441]
["Smoothed Revenue",null,{"$f":"C18*C20/1000000","v":41.941632436346175},{"$f":"D18*D20/1000000","v":42.241699159063806},42.48661538970098,43.11850807654961,43.776152966809207,null,{"$f":"(C19/Inputs!C$43+D19/Inputs!D$43+E19/Inputs!E$43+F19/Inputs!F$43+G19/Inputs!G$43)","v":189.12164708982124}]
["Reference tariff",null,{"$f":"FY22RefTariff*(1-C21/100)*(1+FY22Inf)","v":0.43550653779749954},{"$f":"C20*(1-D21/100)*(1+FY22Inf)","v":0.44196498362121178},{"$f":"D20*(1-E21/100)*(1+FY22Inf)","v":0.44851920647428567},{"$f":"E20*(1-F21/100)*(1+FY22Inf)","v":0.45517062670452685},{"$f":"F20*(1-G21/100)*(1+FY22Inf)","v":0.46192068572312012}]
["\"Vanilla\" X factor",null,26.589147457780911,0.75,{"$f":"D21","v":0.75},0.75,0.75,null,{"$f":"I16-I19","v":0}]
[]
[null,null,{"$f":"C16-C19","v":-1.9056299725421653}]
[]
["Eastbound"]
["EastBound Volumes","GJ MDQ/year",54577537.968047112,53734839.469329439,52998547.96804712,53002562.968047112,53041982.968047112]
["Eastbound Revenues",null,{"$f":"C20*C26/1000000","v":23.768874601975778},{"$f":"D20*D26/1000000","v":23.748917445950632},{"$f":"E20*E26/1000000","v":23.770866678917859},{"$f":"F20*F26/1000000","v":24.125209803112149},{"$f":"G20*G26/1000000","v":24.501189144714381},null,{"$f":"(C27/Inputs!C$43+D27/Inputs!D$43+E27/Inputs!E$43+F27/Inputs!F$43+G27/Inputs!G$43)","v":106.21592467204223}]
[]
["Eastbound Prudent Discount "]
["Prudent Discount Firm Demand",{"$f":"B18","v":"GJ MDQ/year"},"Confidential"]
["Prudent Discount Volume Revenue",{"$f":"Inputs!B26","v":"GJ"}]
[]
["Prudent Discount Firm Tariff",{"$f":"Inputs!B34","v":"$/GJ MDQ/Day"},"Confidential"]
["Prudent Discount Volume tariff",{"$f":"Inputs!B35","v":"$/GJ"}]
[]
["Prudent Discount Revenue","$m","confidential",null,null,null,null,null,"Confidential"]
[]
["Eastbound Prudent Discount "]
["Reference Revenue Eastbound",{"$f":"B36","v":"$m"},"Confidential",null,null,null,null,null,"Confidential"]
["Non Discount Demand",{"$f":"B30","v":"GJ MDQ/year"}]
["Eastbound smoothed reference service",{"$f":"B39","v":"$m"},null,null,null,null,null,null,"Confidential"]
["Eastbound reference tariff",null,{"$f":"FY22RefTariff*(1-C44/100)*(1+FY22Inf)","v":0.44181097737746727},{"$f":"C42*(1-D44/100)*(1+FY22Inf)","v":0.44836291635901371},{"$f":"D42*(1-E44/100)*(1+FY22Inf)","v":0.4550120188485216},{"$f":"E42*(1-F44/100)*(1+FY22Inf)","v":0.46175972575490454},{"$f":"F42*(1-G44/100)*(1+FY22Inf)","v":0.46860749935537105}]
[null,null,"P0","X1","X2","X3","X4"]
["Eastbound X factor",null,25.526444044172145,0.75,{"$f":"D44","v":0.75},0.75,0.75,null,0]
[]
["Residual in year 1",null,-0.17513139151520019,-8.1513592911015564E-2,8.5575937037569716E-3,9.7019889748808374E-2,0.18654229212612439]
[]
[]
[]
["Westbound"]
["WestBound Volumes","GJ MDQ/year",{"$f":"Inputs!C29*Inputs!C44*Inputs!C46","v":41727864.583333336},{"$f":"Inputs!D29*Inputs!D44*Inputs!D46","v":41842187.5},{"$f":"Inputs!E29*Inputs!E44*Inputs!E46","v":41727864.583333336},{"$f":"Inputs!F29*Inputs!F44*Inputs!F46","v":41727864.583333336},{"$f":"Inputs!G29*Inputs!G44*Inputs!G46","v":41727864.583333336}]
["Westbound Revenues",null,{"$f":"C51*C20/1000000","v":18.172757834370401},{"$f":"D51*D20/1000000","v":18.492781713113175},{"$f":"E51*E20/1000000","v":18.715748710783117},{"$f":"F51*F20/1000000","v":18.993298273437464},{"$f":"G51*G20/1000000","v":19.274963822094833},null,{"$f":"(C52/Inputs!C$43+D52/Inputs!D$43+E52/Inputs!E$43+F52/Inputs!F$43+G52/Inputs!G$43)","v":82.905722417779003}]
[]
["Westbound Prudent Discount"]
[{"$f":"Inputs!A34","v":"Prudent Discount"},{"$f":"Inputs!B34","v":"$/GJ MDQ/Day"},{"$f":"Inputs!C33","v":0},{"$f":"Inputs!D33","v":0},{"$f":"Inputs!E33","v":0},{"$f":"Inputs!F33","v":0},{"$f":"Inputs!G33","v":0}]
["Prudent Discount Firm Demand",{"$f":"B30","v":"GJ MDQ/year"},{"$f":"Inputs!C28*Inputs!C44*Inputs!C46","v":0},{"$f":"Inputs!D28*Inputs!D44*Inputs!D46","v":0},{"$f":"Inputs!E28*Inputs!E44*Inputs!E46","v":0},{"$f":"Inputs!F28*Inputs!F44*Inputs!F46","v":0},{"$f":"Inputs!G28*Inputs!G44*Inputs!G46","v":0}]
["Prudent Discount Revenue","$m",{"$f":"C55*C56/1000000","v":0},{"$f":"D55*D56/1000000","v":0},0,0,0,null,{"$f":"(C57/Inputs!C$43+D57/Inputs!D$43+E57/Inputs!E$43+F57/Inputs!F$43+G57/Inputs!G$43)","v":0}]
[]
["Westbound Reference Tariff"]
["Remaining Building Block Revenue",{"$f":"B57","v":"$m"},{"$f":"C52-C57","v":18.172757834370401},{"$f":"D52-D57","v":18.492781713113175},18.715748710783117,18.993298273437464,19.274963822094833,null,{"$f":"(C60/Inputs!C$43+D60/Inputs!D$43+E60/Inputs!E$43+F60/Inputs!F$43+G60/Inputs!G$43)","v":82.905722417779003}]
[]
["Non Discount Demand","GJ MDQ/year",{"$f":"Inputs!C27*Inputs!C44*Inputs!C46","v":41727864.583333336},{"$f":"Inputs!D27*Inputs!D44*Inputs!D46","v":41842187.5},{"$f":"Inputs!E27*Inputs!E44*Inputs!E46","v":41727864.583333336},{"$f":"Inputs!F27*Inputs!F44*Inputs!F46","v":41727864.583333336},{"$f":"Inputs!G27*Inputs!G44*Inputs!G46","v":41727864.583333336}]
[]
["Westbound Revenue",{"$f":"B57","v":"$m"},{"$f":"(C62*C66)/1000000","v":18.172757834370394},{"$f":"(D62*D66)/1000000","v":18.492781713113168},{"$f":"(E62*E66)/1000000","v":18.715748710783114},{"$f":"(F62*F66)/1000000","v":18.99329827343746},{"$f":"(G62*G66)/1000000","v":19.274963822094829},null,{"$f":"(C64/Inputs!C$43+D64/Inputs!D$43+E64/Inputs!E$43+F64/Inputs!F$43+G64/Inputs!G$43)","v":82.905722417778975}]
[]
["Westbound Reference Tariff","$/GJ MDQ/Day",{"$f":"FY22RefTariff*(1-Calculations!C69/100)*(1+FY22Inf)","v":0.43550653779749937},{"$f":"C66*(1-Calculations!D69/100)*(1+FY22Inf)","v":0.44196498362121162},{"$f":"D66*(1-Calculations!E69/100)*(1+FY22Inf)","v":0.44851920647428556},{"$f":"E66*(1-Calculations!F69/100)*(1+FY22Inf)","v":0.45517062670452674},{"$f":"F66*(1-Calculations!G69/100)*(1+FY22Inf)","v":0.46192068572312001},null,{"$f":"I60-I64","v":0}]
[]
[null,null,"P0","X1","X2","X3","X4"]
["Westbound X factors",null,26.589147457780932,0.75,0.75,0.75,0.75]
[]
["Residual in year 1",null,{"$f":"C52-C57-C64","v":0},{"$f":"D52-D57-D64","v":0},0,0,0]
[]
[]
["Proof"]
["Smoothed ",{"$f":"B64","v":"$m"},42.117885864251967,42.323343294064159,42.477580223544514,43.021007746336061,43.589165099386591,null,{"$f":"(C75/Inputs!C$43+D75/Inputs!D$43+E75/Inputs!E$43+F75/Inputs!F$43+G75/Inputs!G$43)","v":189.12164708982118}]
[{"$f":"A16","v":"Building Block Revenue"},"Forecast Nom",40.03600246380401,41.620069903648641,43.977482901288347,45.597225958129016,42.522282905884488,null,{"$f":"(C76/Inputs!C$43+D76/Inputs!D$43+E76/Inputs!E$43+F76/Inputs!F$43+G76/Inputs!G$43)","v":189.12164708982129}]
[null,null,null,null,null,null,null,null,{"$f":"I75-I76","v":0}]

{"sheet":"Outputs","index":3,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[19,2,23,6],[28,3,31,7],[0,1,0,6],[5,1,5,6],[16,9,16,14],[16,1,16,6],[10,1,10,6]]}
[null,"X Factors"]
[null,"Reference Service",{"$f":"Calculations!C68","v":"P0"},{"$f":"Calculations!D68","v":"X1"},{"$f":"Calculations!E68","v":"X2"},{"$f":"Calculations!F68","v":"X3"},{"$f":"Calculations!G68","v":"X4"}]
[null,{"$f":"Calculations!A44","v":"Eastbound X factor"},{"$f":"Calculations!C44","v":25.526444044172145},{"$f":"Calculations!D44","v":0.75},{"$f":"Calculations!E44","v":0.75},{"$f":"Calculations!F44","v":0.75},{"$f":"Calculations!G44","v":0.75}]
[null,{"$f":"Calculations!A69","v":"Westbound X factors"},{"$f":"Calculations!C69","v":26.589147457780932},{"$f":"Calculations!D69","v":0.75},{"$f":"Calculations!E69","v":0.75},{"$f":"Calculations!F69","v":0.75},{"$f":"Calculations!G69","v":0.75}]
[]
[null,"Forecast Reference Tariff (Nominal)"]
[null,"Service","FY23","FY24","FY25","FY26","FY27"]
[null,"Eastbound Long Term Firm Service",{"$f":"ROUND(Calculations!C42,4)","v":0.44180000000000003},{"$f":"ROUND(Calculations!D42,4)","v":0.44840000000000002},{"$f":"ROUND(Calculations!E42,4)","v":0.45500000000000002},{"$f":"ROUND(Calculations!F42,4)","v":0.46179999999999999},{"$f":"ROUND(Calculations!G42,4)","v":0.46860000000000002}]
[null,"Westbound Long Term Firm Service",{"$f":"ROUND(Calculations!C66,4)","v":0.4355},{"$f":"ROUND(Calculations!D66,4)","v":0.442},{"$f":"ROUND(Calculations!E66,4)","v":0.44850000000000001},{"$f":"ROUND(Calculations!F66,4)","v":0.45519999999999999},{"$f":"ROUND(Calculations!G66,4)","v":0.46189999999999998}]
[]
[null,"Forecast Reference Tariff (Real)"]
[null,"Service","FY23","FY24","FY25","FY26","FY27"]
[null,"Eastbound Long Term Firm Service",{"$f":"ROUND(C8/Inputs!C$40,4)","v":0.43209999999999998},{"$f":"ROUND(D8/Inputs!D$40,4)","v":0.4289},{"$f":"ROUND(E8/Inputs!E$40,4)","v":0.42559999999999998},{"$f":"ROUND(F8/Inputs!F$40,4)","v":0.42249999999999999},{"$f":"ROUND(G8/Inputs!G$40,4)","v":0.41930000000000001}]
[null,"Westbound Long Term Firm Service",{"$f":"ROUND(C9/Inputs!C$40,4)","v":0.4259},{"$f":"ROUND(D9/Inputs!D$40,4)","v":0.42280000000000001},{"$f":"ROUND(E9/Inputs!E$40,4)","v":0.41949999999999998},{"$f":"ROUND(F9/Inputs!F$40,4)","v":0.41639999999999999},{"$f":"ROUND(G9/Inputs!G$40,4)","v":0.4133}]
[]
[]
[null,"Demand (Confidential)",null,null,null,null,null,null,null,"Demand (Public)"]
[]
[null,"Component (TJ MDW/Day)","FY23","FY24","FY25","FY26","FY27",null,null,"Component","FY23","FY24","FY25","FY26","FY27"]
[null,"Westbound","Confidential",null,null,null,null,null,null,{"$f":"B20","v":"Westbound"},{"$f":"Inputs!C29","v":114.32291666666667},{"$f":"Inputs!D29","v":114.32291666666667},{"$f":"Inputs!E29","v":114.32291666666667},{"$f":"Inputs!F29","v":114.32291666666667},{"$f":"Inputs!G29","v":114.32291666666667}]
[null,"Competitive",null,null,null,null,null,null,null,{"$f":"B22","v":"GPG"},{"$f":"Inputs!C24","v":17.927501282320858},{"$f":"Inputs!D24","v":17.816501282320861},{"$f":"Inputs!E24","v":17.701501282320859},{"$f":"Inputs!F24","v":17.712501282320858},{"$f":"Inputs!G24","v":17.820501282320858}]
[null,"GPG",null,null,null,null,null,null,null,{"$f":"B24","v":"Eastbound"},131.6,129,127.5,127.5,127.5]
[null,{"$f":"Inputs!A25","v":"Prudent Discount"},null,null,null,null,null,null,null,{"$f":"B25","v":"Total"},{"$f":"SUM(K20:K22)","v":263.85041794898751},{"$f":"SUM(L20:L22)","v":261.13941794898756},259.52441794898755,259.53541794898752,259.64341794898752]
[null,"Eastbound"]
[null,"Total",263.85041794898751,261.13941794898756,259.52441794898755,259.53541794898752,259.64341794898752]
[]
[]
[null,"Revenue",null,"FY23","FY24","FY25","FY26","FY27"]
[null,"Eastbound Prudent Discount Revenue",{"$f":"Calculations!B36","v":"$m"},"Confidential"]
[null,{"$f":"Calculations!A41","v":"Eastbound smoothed reference service"},{"$f":"Calculations!B41","v":"$m"}]
[null,"Westbound Prudent Discount Revenue",{"$f":"Calculations!B57","v":"$m"}]
[null,{"$f":"Calculations!A64","v":"Westbound Revenue"},{"$f":"Calculations!B64","v":"$m"}]
[null,"Total \"smoothed\" Revenue","$m",42.116329369063649,42.323162205343984,42.478242714735458,43.021674216049433,43.589783203942574]
[]
[null,"Eastbound Reference Tariff","$GJ MDQ",{"$f":"Calculations!C42","v":0.44181097737746727},{"$f":"Calculations!D42","v":0.44836291635901371},{"$f":"Calculations!E42","v":0.4550120188485216},{"$f":"Calculations!F42","v":0.46175972575490454},{"$f":"Calculations!G42","v":0.46860749935537105}]
[null,"GPG Volumes","GJ MDQ PA",{"$f":"Inputs!C24*Inputs!C44*Inputs!C46","v":6543537.9680471132},{"$f":"Inputs!D24*Inputs!D44*Inputs!D46","v":6520839.4693294344},{"$f":"Inputs!E24*Inputs!E44*Inputs!E46","v":6461047.9680471132},{"$f":"Inputs!F24*Inputs!F44*Inputs!F46","v":6465062.9680471132},{"$f":"Inputs!G24*Inputs!G44*Inputs!G46","v":6504482.9680471132}]
[null,"GPG Revenue",null,{"$f":"D35*D36/1000000","v":2.8910069051694616},{"$f":"E35*E36/1000000","v":2.9237026015775087},{"$f":"F35*F36/1000000","v":2.9398544798182553},{"$f":"G35*G36/1000000","v":2.9853057031136245},{"$f":"H35*H36/1000000","v":3.0480494982561597}]
[]
[null,"Other East bound Revenue","$m",21.05256462952379,20.906677890653306,20.822639524134086,21.043070239498345,21.266769883591586]
[]
[null,"Westbound Revenue","$m",18.172757834370394,18.492781713113168,18.715748710783114,18.99329827343746,19.274963822094829]
[]
[null,"Total Revenue",null,{"$f":"D37+D39+D41","v":42.116329369063649},{"$f":"E37+E39+E41","v":42.323162205343984},{"$f":"F37+F39+F41","v":42.478242714735458},{"$f":"G37+G39+G41","v":43.021674216049433},{"$f":"H37+H39+H41","v":43.589783203942574}]
[]
[]
[null,"Real Revenue ($FY22)"]
[]
[null,"Revenue",null,{"$f":"D28","v":"FY23"},{"$f":"E28","v":"FY24"},"FY25","FY26","FY27"]
[null,"Revenue",null,{"$f":"Inputs!C52*1000000","v":41191147.979729228},{"$f":"Inputs!D52*1000000","v":40481316.872387648},{"$f":"Inputs!E52*1000000","v":39734867.200978957},{"$f":"Inputs!F52*1000000","v":39357717.921728022},{"$f":"Inputs!G52*1000000","v":39000054.375748761}]
[]
[null,"RIN Total",null,41535152.478515729,42145631.827607736,42010595.992500149,43847765.256891705,47202597.741435394]
[]
[null,null,null,{"$f":"D49-D51","v":-344004.49878650159},{"$f":"E49-E51","v":-1664314.9552200884},-2275728.7915211916,-4490047.3351636827,-8202543.3656866327]

{"sheet":"Proof Prudent Discount","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,24,7]]}
[]
[null,"Confidential"]