{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inputs","Calculations","Outputs","Proof Prudent Discount"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":6,"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":"Inputs","index":0,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Roma Brisbane Pipeline"]
["Reference Tariff Model"]
[]
["Item","Dollars","FY2023","FY2024","FY2025","FY2026","FY2027"]
[]
[]
["Building Block Revenue"]
[]
["Building Block Revenue from PTRM","Forecast Nom",42.715671422421281,45.714675874592892,48.682331847758178,50.858761787677039,48.77354110882888,null,null,null,null,null,null,null,null,null,{"$f":"Q22-38","v":-38}]
[]
["Demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-23","2023-24","2024-25","2025-26","2026-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastbound (non GPG)"]
["Eastbound C&I"," TJ MDQ/Day",null,null,null,null,null,null,null,null,null,null,null,null,"GPG"]
["GPG"," TJ MDQ/Day",null,null,null,null,null,null,null,null,null,null,null,null,"Total Eastbound",135.30000000000001,114.80000000000001,113.30000000000001,113.30000000000001,113.30000000000001]
["Prudent Discount"," TJ MDQ/Day",0,{"$f":"C25","v":0},0,0,0,null,null,null,null,null,null,null,"Westbound",93.7,93.7,92.7,87.7,87.7]
["Prudent Discount Volumes","GJ",0,{"$f":"C26","v":0},0,0,0,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P24:P25)","v":229},{"$f":"SUM(Q24:Q25)","v":208.5},206,201,201]
["Westbound"," TJ MDQ/Day"]
["Competitive Westbound"," TJ MDQ/Day"]
["Total Westbound"," TJ MDQ/Day",{"$f":"P25","v":93.7},{"$f":"Q25","v":93.7},92.7,87.7,87.7]
[]
["Set Prices"]
[]
["Westbound","$/GJ MDQ/Day",null,null,null,null,null,null,null,null,null,null,null,null,"Darling Downs","2020-21"]
["Prudent Discount","$/GJ MDQ/Day",0,{"$f":"C34","v":0},0,0,0,null,null,null,null,null,null,null,"DDP 134",0.2195]
["Prudent Discount","$/GJ",0,{"$f":"C35","v":0},0,0,0,null,null,null,null,null,null,null,"DDP 133",0.1004]
[]
["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]
[]
["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",49.081384816736858,44.581551097488024,43.747187014358566,41.875222879533389,41.422701536049679]

{"sheet":"Calculations","index":1,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,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":42.715671422421281},{"$f":"Inputs!D19","v":45.714675874592892},{"$f":"Inputs!E19","v":48.682331847758178},{"$f":"Inputs!F19","v":50.858761787677039},{"$f":"Inputs!G19","v":48.77354110882888},null,{"$f":"NPV(WACC,C16,D16,E16,F16,G16)","v":208.18600420472401}]
[]
["Total Volumes","GJ MDQ/year",80263499.999999985,72980400,71868500,70043500,70043500]
["Smoothed Revenue",null,{"$f":"C18*C20/1000000","v":49.616125060921682},{"$f":"D18*D20/1000000","v":46.128959299899812},46.448176159618178,46.287166058357393,47.328556562321609,null,{"$f":"NPV(WACC,C19,D19,E19,F19,G19)","v":208.18600420472393}]
["Reference tariff",null,{"$f":"FY22RefTariff*(1-C21/100)*(1+FY22Inf)","v":0.61816548070943445},{"$f":"C20*(1-D21/100)*(1+FY22Inf)","v":0.63207325939430048},{"$f":"D20*(1-E21/100)*(1+FY22Inf)","v":0.64629394184681987},{"$f":"E20*(1-F21/100)*(1+FY22Inf)","v":0.66083456792361028},{"$f":"F20*(1-G21/100)*(1+FY22Inf)","v":0.67570233586730544}]
["\"Vanilla\" X factor",null,-4.2006284924038138,0,{"$f":"D21","v":0},0,0,null,{"$f":"I16-I19","v":0}]
[]
[null,null,{"$f":"C16-C19","v":-6.9004536385004016}]
[]
["Eastbound"]
["EastBound Volumes","GJ MDQ/year",46062999.999999993,38686200.000000007,38033000,38033000,38033000]
["Eastbound Revenues",null,{"$f":"C20*C26/1000000","v":28.474556537918676},{"$f":"D20*D26/1000000","v":24.452512527579792},{"$f":"E20*E26/1000000","v":24.5804974902601},{"$f":"F20*F26/1000000","v":25.133521121838669},{"$f":"G20*G26/1000000","v":25.69898694004123},null,{"$f":"NPV(WACC,C27,D27,E27,F27,G27)","v":113.40227034557297}]
[]
["Eastbound Prudent Discount "]
["Prudent Discount Firm Demand",{"$f":"B18","v":"GJ MDQ/year"},{"$f":"Inputs!C25*Inputs!C44*Inputs!C46","v":0},{"$f":"Inputs!D25*Inputs!D44*Inputs!D46","v":0},{"$f":"Inputs!E25*Inputs!E44*Inputs!E46","v":0},{"$f":"Inputs!F25*Inputs!F44*Inputs!F46","v":0},{"$f":"Inputs!G25*Inputs!G44*Inputs!G46","v":0}]
["Prudent Discount Volume Revenue",{"$f":"Inputs!B26","v":"GJ"},{"$f":"Inputs!C26","v":0},{"$f":"Inputs!D26","v":0},{"$f":"Inputs!E26","v":0},{"$f":"Inputs!F26","v":0},{"$f":"Inputs!G26","v":0}]
[]
["Prudent Discount Firm Tariff",{"$f":"Inputs!B34","v":"$/GJ MDQ/Day"},{"$f":"Inputs!C34","v":0},{"$f":"Inputs!D34","v":0},{"$f":"Inputs!E34","v":0},{"$f":"Inputs!F34","v":0},{"$f":"Inputs!G34","v":0}]
["Prudent Discount Volume tariff",{"$f":"Inputs!B35","v":"$/GJ"},{"$f":"Inputs!C35","v":0},{"$f":"Inputs!D35","v":0},{"$f":"Inputs!E35","v":0},{"$f":"Inputs!F35","v":0},{"$f":"Inputs!G35","v":0}]
[]
["Prudent Discount Revenue","$m",{"$f":"(C30*C33+C31*C34)/1000000","v":0},{"$f":"(D30*D33+D31*D34)/1000000","v":0},0,0,0,null,{"$f":"NPV(WACC,C36,D36,E36,F36,G36)","v":0}]
[]
["Eastbound Reference Tariff"]
["Reference Revenue Eastbound",{"$f":"B36","v":"$m"},{"$f":"C27-C36","v":28.474556537918676},{"$f":"D27-D36","v":24.452512527579792},{"$f":"E27-E36","v":24.5804974902601},{"$f":"F27-F36","v":25.133521121838669},{"$f":"G27-G36","v":25.69898694004123},null,{"$f":"NPV(WACC,C39,D39,E39,F39,G39)","v":113.40227034557297}]
["Non Discount Demand",{"$f":"B30","v":"GJ MDQ/year"},46062999.999999993,38686200.000000007,38033000,38033000,38033000]
["Eastbound smoothed reference service",{"$f":"B39","v":"$m"},28.474556537918669,24.452512527579788,24.580497490260093,25.133521121838665,25.698986940041223,null,{"$f":"NPV(WACC,C41,D41,E41,F41,G41)","v":113.40227034557296}]
["Eastbound reference tariff",null,{"$f":"FY22RefTariff*(1-C45/100)*(1+FY22Inf)","v":0.61816548070943433},{"$f":"C42*(1-D45/100)*(1+FY22Inf)","v":0.63207325939430037},{"$f":"D42*(1-E45/100)*(1+FY22Inf)","v":0.64629394184681976},{"$f":"E42*(1-F45/100)*(1+FY22Inf)","v":0.66083456792361017},{"$f":"F42*(1-G45/100)*(1+FY22Inf)","v":0.67570233586730533}]
[]
[null,null,"P0","X1","X2","X3","X4"]
["Eastbound X factor",null,-4.2006284924037827,0,{"$f":"D45","v":0},0,0,null,{"$f":"I39-I41","v":0}]
[]
["Residual in year 1",null,{"$f":"C27-C41-C36","v":7.1054273576010019E-15},{"$f":"D27-D41-D36","v":3.5527136788005009E-15},7.1054273576010019E-15,3.5527136788005009E-15,7.1054273576010019E-15]
[]
[]
[]
["Westbound"]
["WestBound Volumes","GJ MDQ/year",{"$f":"Inputs!C29*Inputs!C44*Inputs!C46","v":34200500},{"$f":"Inputs!D29*Inputs!D44*Inputs!D46","v":34294200.000000007},{"$f":"Inputs!E29*Inputs!E44*Inputs!E46","v":33835500},{"$f":"Inputs!F29*Inputs!F44*Inputs!F46","v":32010500},{"$f":"Inputs!G29*Inputs!G44*Inputs!G46","v":32010500}]
["Westbound Revenues",null,{"$f":"C52*C20/1000000","v":21.141568523003013},{"$f":"D52*D20/1000000","v":21.676446772320023},{"$f":"E52*E20/1000000","v":21.867678669358074},{"$f":"F52*F20/1000000","v":21.153644936518727},{"$f":"G52*G20/1000000","v":21.629569622280382},null,{"$f":"NPV(WACC,C53,D53,E53,F53,G53)","v":94.783733859150985}]
[]
["Westbound Prudent Discount"]
[{"$f":"Inputs!A34","v":"Prudent Discount"},{"$f":"Inputs!B34","v":"$/GJ MDQ/Day"}]
["Prudent Discount Firm Demand",{"$f":"B30","v":"GJ MDQ/year"}]
["Prudent Discount Revenue","$m"]
[]
["Westbound Reference Tariff"]
["Remaining Building Block Revenue",{"$f":"B58","v":"$m"}]
["Non Discount Demand","GJ MDQ/year"]
["Westbound Revenue",{"$f":"B58","v":"$m"}]
["Westbound Reference Tariff","$/GJ MDQ/Day",0.63780764056222305,0.65215733782819751,0.66682988135459564,0.68183253468892902,0.69717272479742876,null,1.1352283760857063E-4]
[]
[null,null,"P0","X1","X2","X3","X4"]
["Westbound X factors",null,-7.5115953216416962,0,{"$f":"D67","v":0},0,0]
[]
["Residual in year 1",null,-0.5695159119410711,-0.48119168972534254,-0.31867564732679909,0.51433208808794717,1.0316730061735164]
[]
[]
["Proof"]
["Smoothed ",{"$f":"B63","v":"$m"},50.185640972862757,46.610150989625154,46.766851806944963,45.772833970269446,46.296883556148089,null,{"$f":"NPV(WACC,C73,D73,E73,F73,G73)","v":208.18589068188632}]
[{"$f":"A16","v":"Building Block Revenue"},"Forecast Nom",42.715671422421281,45.714675874592892,48.682331847758178,50.858761787677039,48.77354110882888,null,{"$f":"NPV(WACC,C74,D74,E74,F74,G74)","v":208.18600420472401}]
[null,null,null,null,null,null,null,null,{"$f":"I73-I74","v":-1.1352283769383575E-4}]

{"sheet":"Outputs","index":2,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[23,9,23,14],[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!C66","v":"P0"},{"$f":"Calculations!D66","v":"X1"},{"$f":"Calculations!E66","v":"X2"},{"$f":"Calculations!F66","v":"X3"},{"$f":"Calculations!G66","v":"X4"}]
[null,{"$f":"Calculations!A45","v":"Eastbound X factor"},{"$f":"Calculations!C45","v":-4.2006284924037827},{"$f":"Calculations!D45","v":0},{"$f":"Calculations!E45","v":0},{"$f":"Calculations!F45","v":0},{"$f":"Calculations!G45","v":0}]
[null,{"$f":"Calculations!A67","v":"Westbound X factors"},{"$f":"Calculations!C67","v":-7.5115953216416962},{"$f":"Calculations!D67","v":0},{"$f":"Calculations!E67","v":0},{"$f":"Calculations!F67","v":0},{"$f":"Calculations!G67","v":0}]
[]
[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.61819999999999997},{"$f":"ROUND(Calculations!D42,4)","v":0.6321},{"$f":"ROUND(Calculations!E42,4)","v":0.64629999999999999},{"$f":"ROUND(Calculations!F42,4)","v":0.66080000000000005},{"$f":"ROUND(Calculations!G42,4)","v":0.67569999999999997}]
[null,"Westbound Long Term Firm Service",0.63780000000000003,0.6522,0.66679999999999995,0.68179999999999996,0.69720000000000004]
[]
[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.60460000000000003},{"$f":"ROUND(D8/Inputs!D$40,4)","v":0.60460000000000003},{"$f":"ROUND(E8/Inputs!E$40,4)","v":0.60460000000000003},{"$f":"ROUND(F8/Inputs!F$40,4)","v":0.60450000000000004},{"$f":"ROUND(G8/Inputs!G$40,4)","v":0.60460000000000003}]
[null,"Westbound Long Term Firm Service",{"$f":"ROUND(C9/Inputs!C$40,4)","v":0.62380000000000002},{"$f":"ROUND(D9/Inputs!D$40,4)","v":0.62380000000000002},{"$f":"ROUND(E9/Inputs!E$40,4)","v":0.62370000000000003},{"$f":"ROUND(F9/Inputs!F$40,4)","v":0.62370000000000003},{"$f":"ROUND(G9/Inputs!G$40,4)","v":0.62380000000000002}]
[]
[]
[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,{"$f":"Inputs!A27","v":"Westbound"},null,null,null,null,null,null,null,{"$f":"B20","v":"Westbound"},93.7,93.7,92.7,87.7,87.7]
[null,{"$f":"Inputs!A28","v":"Competitive Westbound"},null,null,null,null,null,null,null,{"$f":"B24","v":"Eastbound"},126.19999999999999,105.7,104.2,104.2,104.2]
[null,"GPG",null,null,null,null,null,null,null,{"$f":"B25","v":"Total"},{"$f":"SUM(K20:K21)","v":219.89999999999998},{"$f":"SUM(L20:L21)","v":199.4},{"$f":"SUM(M20:M21)","v":196.9},{"$f":"SUM(N20:N21)","v":191.9},{"$f":"SUM(O20:O21)","v":191.9}]
[null,{"$f":"Inputs!A25","v":"Prudent Discount"}]
[null,"Eastbound",null,null,null,null,null,null,null,"Demand (Public)"]
[null,"Total",219.89999999999998,199.4,196.9,191.9,191.9]
[null,null,null,null,null,null,null,null,null,"Component","FY23","FY24","FY25","FY26","FY27"]
[null,null,null,null,null,null,null,null,null,{"$f":"J21","v":"Eastbound"},{"$f":"K21","v":126.19999999999999},{"$f":"L21","v":105.7},104.2,104.2,104.2]
[null,"Revenue",null,"FY23","FY24","FY25","FY26","FY27"]
[null,"Eastbound Prudent Discount Revenue",{"$f":"Calculations!B36","v":"$m"},{"$f":"Calculations!C36","v":0},{"$f":"Calculations!D36","v":0},{"$f":"Calculations!E36","v":0},{"$f":"Calculations!F36","v":0},{"$f":"Calculations!G36","v":0}]
[null,{"$f":"Calculations!A41","v":"Eastbound smoothed reference service"},{"$f":"Calculations!B41","v":"$m"},{"$f":"Calculations!C41","v":28.474556537918669},{"$f":"Calculations!D41","v":24.452512527579788},{"$f":"Calculations!E41","v":24.580497490260093},{"$f":"Calculations!F41","v":25.133521121838665},{"$f":"Calculations!G41","v":25.698986940041223}]
[null,"Westbound Prudent Discount Revenue",{"$f":"Calculations!B58","v":"$m"}]
[null,{"$f":"Calculations!A63","v":"Westbound Revenue"},{"$f":"Calculations!B63","v":"$m"}]
[null,"Total \"smoothed\" Revenue","$m",50.185640972862757,46.610150989625154,46.766851806944963,45.772833970269446,46.296883556148089]
[]
[null,"Eastbound Reference Tariff","$GJ MDQ",0.61816548070943433,0.63207325939430037,0.64629394184681976,0.66083456792361017,0.67570233586730533]
[null,"GPG Volumes","GJ MDQ PA"]
[null,"GPG Revenue"]
[]
[null,"Other East bound Revenue","$m",21.705644524150365,17.512348139430372,17.503578827037416,17.897382603075133,18.300046362294232]
[]
[null,"Westbound Revenue","$m",21.711084434944084,22.157638462045366,22.18635431668487,20.63931284843078,20.597896616106866]
[]
[null,"Total Revenue",null,50.185640972862757,46.610150989625154,46.766851806944963,45.772833970269446,46.296883556148089]
[]
[]
[null,"Real Revenue ($FY22)"]
[]
[null,"Revenue",null,{"$f":"D28","v":"FY23"},{"$f":"E28","v":"FY24"},"FY25","FY26","FY27"]
[null,"Revenue",null,49081384.816736855,44581551.097488023,43747187.014358565,41875222.879533388,41422701.536049679]
[]
[null,"RIN Total",null,41535152.478515729,42145631.827607736,42010595.992500149,43847765.256891705,47202597.741435394]
[]
[null,null,null,{"$f":"D49-D51","v":7546232.3382211253},{"$f":"E49-E51","v":2435919.2698802873},1736591.0218584165,-1972542.3773583174,-5779896.2053857148]

{"sheet":"Proof Prudent Discount","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Outputs!C7","v":"FY23"},{"$f":"Outputs!D7","v":"FY24"},{"$f":"Outputs!E7","v":"FY25"},{"$f":"Outputs!F7","v":"FY26"},{"$f":"Outputs!G7","v":"FY27"},"NPV"]
[null,"East bound Revenue",{"$f":"Calculations!C27","v":28.474556537918676},{"$f":"Calculations!D27","v":24.452512527579792},{"$f":"Calculations!E27","v":24.5804974902601},{"$f":"Calculations!F27","v":25.133521121838669},{"$f":"Calculations!G27","v":25.69898694004123},113.40227034557297]
[null,"Westbound Revenue",{"$f":"Calculations!C53","v":21.141568523003013},{"$f":"Calculations!D53","v":21.676446772320023},{"$f":"Calculations!E53","v":21.867678669358074},{"$f":"Calculations!F53","v":21.153644936518727},{"$f":"Calculations!G53","v":21.629569622280382},94.783733859150985]
[]
[null,"Eastbound Demand without Prudent volumes",46062999.999999993,38686200.000000007,38033000,38033000,38033000]
[null,"Westbound Demand without Prudent volumes",26900500,26974200,26535500,24710500,24710500]
[]
[null,"Eastbound prudent Discount Proof"]
[null,"Volumes less prudent discount",{"$f":"C6","v":46062999.999999993},{"$f":"D6","v":38686200.000000007},38033000,38033000,38033000]
[null,"Revenue",{"$f":"C10*C12/1000000","v":28.474556537918676},{"$f":"D10*D12/1000000","v":24.452512527579792},{"$f":"E10*E12/1000000","v":24.5804974902601},25.133521121838669,25.69898694004123,113.40227034557297]
[null,"Reference Tariff",0.61816548070943445,0.63207325939430048,0.64629394184681987,0.66083456792361028,0.67570233586730544,{"$f":"H3-H11","v":0}]
[null,"X factor",-4.2006284924038177E-2,0,{"$f":"D13","v":0},{"$f":"E13","v":0},0]
[]
[null,"Proposed Eastbound Long Term Firm Charge",{"$f":"Outputs!C8","v":0.61819999999999997},{"$f":"Outputs!D8","v":0.6321},{"$f":"Outputs!E8","v":0.64629999999999999},{"$f":"Outputs!F8","v":0.66080000000000005},{"$f":"Outputs!G8","v":0.67569999999999997}]
[null,"Difference",{"$f":"C12-C15","v":-3.4519290565526717E-5},{"$f":"D12-D15","v":-2.674060569951564E-5},-6.0581531801107147E-6,3.4567923610229201E-5,2.3358673054696411E-6,-3.19223926160818E-5]
[]
[null,"Westbound prudent Discount Proof"]
[null,"Volumes less prudent discount"]
[null,"Revenue"]
[null,"Reference Tariff"]
[null,"X factor"]
[]
[null,"Proposed Eastbound Long Term Firm Charge",0.63780000000000003,0.6522,0.66679999999999995,0.68179999999999996,0.69720000000000004,"Total"]
[null,"Difference"]