{"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":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":"Inputs","index":0,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,6],[24,2,25,6],[22,2,22,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",42.365601021640579,44.338409519465507,47.353107574714684,49.424382271676045,46.488208884303191]
[]
["Demand"]
[]
["Eastbound C&I"," TJ MDQ/Day","Confidential"]
["GPG"," TJ MDQ/Day",6.2,4.0999999999999996,3.5,4.8,6.8]
["Prudent Discount"," TJ MDQ/Day","Confidential"]
["Prudent Discount Volumes","GJ"]
["Westbound"," TJ MDQ/Day",68,64,56,52,52]
["Competitive Westbound"," TJ MDQ/Day",17,16,14,13,13]
["Total Westbound"," TJ MDQ/Day",85,80,70,65,65]
[]
["Set Prices"]
[]
["Westbound","$/GJ MDQ/Day",0.31990000000000002,{"$f":"C33","v":0.31990000000000002},0.31990000000000002,0.31990000000000002,0.31990000000000002]
["Prudent Discount","$/GJ MDQ/Day","Confidential"]
["Prudent Discount","$/GJ"]
[]
["Other inputs",null,"FY2022"]
[]
["CPI",null,1.9993872504847632E-2]
["$FY22 index",null,{"$f":"1*(1+C39)","v":1.0199938725048476},{"$f":"C40*(1+FY22Inf)","v":1.0403874999474354},{"$f":"D40*(1+FY22Inf)","v":1.0611888749770215},{"$f":"E40*(1+FY22Inf)","v":1.0824061500468747},{"$f":"F40*(1+FY22Inf)","v":1.1040476406093749}]
[]
["WACC","nominal vanilla ",4.3637737333490259E-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",41.535152478515734,42.145631827607737,42.010595992500157,43.847765256891698,47.20259774143539]

{"sheet":"Calculations","index":1,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,6],[38,2,40,6],[35,2,35,6],[32,2,33,6],[29,2,30,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.365601021640579},{"$f":"Inputs!D19","v":44.338409519465507},{"$f":"Inputs!E19","v":47.353107574714684},{"$f":"Inputs!F19","v":49.424382271676045},{"$f":"Inputs!G19","v":46.488208884303191},null,{"$f":"NPV(WACC,C16,D16,E16,F16,G16)","v":202.17112171121218}]
[]
["Total Volumes","GJ MDQ/year",81103000,77775000,73146000,71795500,72525500]
["Smoothed Revenue",null,{"$f":"C18*C20/1000000","v":42.365601021640579},{"$f":"D18*D20/1000000","v":43.945562746814296},44.705828697433276,47.464548052287874,51.863451397896355,null,{"$f":"NPV(WACC,C19,D19,E19,F19,G19)","v":202.171097957641}]
["Reference tariff",null,{"$f":"FY22RefTariff*(1-C21/100)*(1+FY22Inf)","v":0.52236786582050698},{"$f":"C20*(1-D21/100)*(1+FY22Inf)","v":0.56503455797896873},{"$f":"D20*(1-E21/100)*(1+FY22Inf)","v":0.61118623981397857},{"$f":"E20*(1-F21/100)*(1+FY22Inf)","v":0.66110756317997477},{"$f":"F20*(1-G21/100)*(1+FY22Inf)","v":0.71510643012314778}]
["\"Vanilla\" X factor",null,11.731215460816765,-6.0476367458237705,{"$f":"D21","v":-6.0476367458237705},-6.0476367458237705,-6.0476367458237705,null,{"$f":"I16-I19","v":2.3753571184670363E-5}]
[]
[null,null,{"$f":"C16-C19","v":0}]
[]
["Eastbound"]
["EastBound Volumes","GJ MDQ/year",50077999.999999993,48495000,47596000,48070499.999999993,48800499.999999993]
["Eastbound Revenues",null,{"$f":"C20*C26/1000000","v":26.159137984559347},{"$f":"D20*D26/1000000","v":27.401350889190088},{"$f":"E20*E26/1000000","v":29.090020270186123},{"$f":"F20*F26/1000000","v":31.779771115842973},{"$f":"G20*G26/1000000","v":34.89755134322467},null,{"$f":"NPV(WACC,C27,D27,E27,F27,G27)","v":130.79008984543032}]
[]
["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.55790442957797581},{"$f":"C42*(1-D44/100)*(1+FY22Inf)","v":0.61706506847483433},{"$f":"D42*(1-E44/100)*(1+FY22Inf)","v":0.68249914957635871},{"$f":"E42*(1-F44/100)*(1+FY22Inf)","v":0.75487191378983354},{"$f":"F42*(1-G44/100)*(1+FY22Inf)","v":0.83491914470872552}]
[null,null,"P0","X1","X2","X3","X4"]
["Eastbound X factor",null,5.7263106900305933,-8.4360251676226703,{"$f":"D44","v":-8.4360251676226703},-8.4360251676226703,-8.4360251676226703,null,3.076559194425954E-5]
[]
["Residual in year 1",null,0]
[]
[]
[]
["Westbound"]
["WestBound Volumes","GJ MDQ/year",{"$f":"Inputs!C29*Inputs!C44*Inputs!C46","v":31025000},{"$f":"Inputs!D29*Inputs!D44*Inputs!D46","v":29280000},{"$f":"Inputs!E29*Inputs!E44*Inputs!E46","v":25550000},{"$f":"Inputs!F29*Inputs!F44*Inputs!F46","v":23725000},{"$f":"Inputs!G29*Inputs!G44*Inputs!G46","v":23725000}]
["Westbound Revenues",null,{"$f":"C51*C20/1000000","v":16.206463037081228},{"$f":"D51*D20/1000000","v":16.544211857624205},{"$f":"E51*E20/1000000","v":15.615808427247151},{"$f":"F51*F20/1000000","v":15.684776936444901},{"$f":"G51*G20/1000000","v":16.965900054671682},null,{"$f":"NPV(WACC,C52,D52,E52,F52,G52)","v":71.381008112210651}]
[]
["Westbound Prudent Discount"]
[{"$f":"Inputs!A34","v":"Prudent Discount"},{"$f":"Inputs!B34","v":"$/GJ MDQ/Day"},{"$f":"Inputs!C33","v":0.31990000000000002},{"$f":"Inputs!D33","v":0.31990000000000002},{"$f":"Inputs!E33","v":0.31990000000000002},{"$f":"Inputs!F33","v":0.31990000000000002},{"$f":"Inputs!G33","v":0.31990000000000002}]
["Prudent Discount Firm Demand",{"$f":"B30","v":"GJ MDQ/year"},{"$f":"Inputs!C28*Inputs!C44*Inputs!C46","v":6205000},{"$f":"Inputs!D28*Inputs!D44*Inputs!D46","v":5856000},{"$f":"Inputs!E28*Inputs!E44*Inputs!E46","v":5110000},{"$f":"Inputs!F28*Inputs!F44*Inputs!F46","v":4745000},{"$f":"Inputs!G28*Inputs!G44*Inputs!G46","v":4745000}]
["Prudent Discount Revenue","$m",{"$f":"C55*C56/1000000","v":1.9849794999999999},{"$f":"D55*D56/1000000","v":1.8733344000000001},1.6346890000000001,1.5179255,1.5179255,null,{"$f":"NPV(WACC,C57,D57,E57,F57,G57)","v":7.5655842464081848}]
[]
["Westbound Reference Tariff"]
["Remaining Building Block Revenue",{"$f":"B57","v":"$m"},{"$f":"C52-C57","v":14.221483537081228},{"$f":"D52-D57","v":14.670877457624204},13.981119427247151,14.166851436444901,15.447974554671681,null,{"$f":"NPV(WACC,C60,D60,E60,F60,G60)","v":63.815423865802458}]
[]
["Non Discount Demand","GJ MDQ/year",{"$f":"Inputs!C27*Inputs!C44*Inputs!C46","v":24820000},{"$f":"Inputs!D27*Inputs!D44*Inputs!D46","v":23424000},{"$f":"Inputs!E27*Inputs!E44*Inputs!E46","v":20440000},{"$f":"Inputs!F27*Inputs!F44*Inputs!F46","v":18980000},{"$f":"Inputs!G27*Inputs!G44*Inputs!G46","v":18980000}]
[]
["Westbound Revenue",{"$f":"B57","v":"$m"},{"$f":"(C62*C66)/1000000","v":14.221483537081236},{"$f":"(D62*D66)/1000000","v":14.658522009090778},{"$f":"(E62*E66)/1000000","v":13.969987381383131},{"$f":"(F62*F66)/1000000","v":14.167633993902056},{"$f":"(G62*G66)/1000000","v":15.473313584417012},null,{"$f":"NPV(WACC,C64,D64,E64,F64,G64)","v":63.8154128707246}]
[]
["Reference Tariff","$/GJ MDQ/Day",{"$f":"FY22RefTariff*(1-Calculations!C69/100)*(1+FY22Inf)","v":0.57298483227563402},{"$f":"C66*(1-Calculations!D69/100)*(1+FY22Inf)","v":0.62579072784711309},{"$f":"D66*(1-Calculations!E69/100)*(1+FY22Inf)","v":0.68346317912833321},{"$f":"E66*(1-Calculations!F69/100)*(1+FY22Inf)","v":0.74645068461022424},{"$f":"F66*(1-Calculations!G69/100)*(1+FY22Inf)","v":0.81524307610205538},null,{"$f":"I60-I64","v":1.0995077857955948E-5}]
[]
[null,null,"P0","X1","X2","X3","X4"]
["Westbound X factors",null,3.1780513050608699,-7.0750868979260382,{"$f":"D69","v":-7.0750868979260382},-7.0750868979260382,-7.0750868979260382]
[]
["Residual in year 1",null,{"$f":"C52-C57-C64","v":0}]
[]
[]
["Proof"]
["Smoothed ",{"$f":"B64","v":"$m"},42.365601021640586,43.847788530829874,44.581177098395408,47.461090779871256,52.113916667065148,null,{"$f":"NPV(WACC,C75,D75,E75,F75,G75)","v":202.17105619697114}]
[{"$f":"A16","v":"Building Block Revenue"},"Forecast Nom",42.365601021640579,44.338409519465507,47.353107574714684,49.424382271676045,46.488208884303191,null,{"$f":"NPV(WACC,C76,D76,E76,F76,G76)","v":202.17112171121218}]
[null,null,null,null,null,null,null,null,{"$f":"I75-I76","v":-6.5514241043729271E-5}]

{"sheet":"Outputs","index":2,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,6],[5,1,5,6],[16,9,16,14],[16,1,16,6],[27,3,30,7],[19,2,22,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":5.7263106900305933},{"$f":"Calculations!D44","v":-8.4360251676226703},{"$f":"Calculations!E44","v":-8.4360251676226703},{"$f":"Calculations!F44","v":-8.4360251676226703},{"$f":"Calculations!G44","v":-8.4360251676226703}]
[null,{"$f":"Calculations!A69","v":"Westbound X factors"},{"$f":"Calculations!C69","v":3.1780513050608699},{"$f":"Calculations!D69","v":-7.0750868979260382},{"$f":"Calculations!E69","v":-7.0750868979260382},{"$f":"Calculations!F69","v":-7.0750868979260382},{"$f":"Calculations!G69","v":-7.0750868979260382}]
[]
[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.55789999999999995},{"$f":"ROUND(Calculations!D42,4)","v":0.61709999999999998},{"$f":"ROUND(Calculations!E42,4)","v":0.6825},{"$f":"ROUND(Calculations!F42,4)","v":0.75490000000000002},{"$f":"ROUND(Calculations!G42,4)","v":0.83489999999999998}]
[null,"Westbound Long Term Firm Service",{"$f":"ROUND(Calculations!C66,4)","v":0.57299999999999995},{"$f":"ROUND(Calculations!D66,4)","v":0.62580000000000002},{"$f":"ROUND(Calculations!E66,4)","v":0.6835},{"$f":"ROUND(Calculations!F66,4)","v":0.74650000000000005},{"$f":"ROUND(Calculations!G66,4)","v":0.81520000000000004}]
[]
[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.54700000000000004},{"$f":"ROUND(D8/Inputs!D$40,4)","v":0.59309999999999996},{"$f":"ROUND(E8/Inputs!E$40,4)","v":0.6431},{"$f":"ROUND(F8/Inputs!F$40,4)","v":0.69740000000000002},{"$f":"ROUND(G8/Inputs!G$40,4)","v":0.75619999999999998}]
[null,"Westbound Long Term Firm Service",{"$f":"ROUND(C9/Inputs!C$40,4)","v":0.56179999999999997},{"$f":"ROUND(D9/Inputs!D$40,4)","v":0.60150000000000003},{"$f":"ROUND(E9/Inputs!E$40,4)","v":0.64410000000000001},{"$f":"ROUND(F9/Inputs!F$40,4)","v":0.68969999999999998},{"$f":"ROUND(G9/Inputs!G$40,4)","v":0.73839999999999995}]
[]
[]
[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!C27","v":68},{"$f":"Inputs!D27","v":64},{"$f":"Inputs!E27","v":56},{"$f":"Inputs!F27","v":52},{"$f":"Inputs!G27","v":52}]
[null,"GPG",null,null,null,null,null,null,null,{"$f":"B21","v":"GPG"},{"$f":"Inputs!C24","v":6.2},{"$f":"Inputs!D24","v":4.0999999999999996},{"$f":"Inputs!E24","v":3.5},{"$f":"Inputs!F24","v":4.8},{"$f":"Inputs!G24","v":6.8}]
[null,{"$f":"Inputs!A25","v":"Prudent Discount"},null,null,null,null,null,null,null,{"$f":"B23","v":"Eastbound"},131,128.4,126.9,126.9,126.9]
[null,"Eastbound",null,null,null,null,null,null,null,{"$f":"B24","v":"Total"},{"$f":"SUM(K20:K22)","v":205.2},{"$f":"SUM(L20:L22)","v":196.5},186.4,183.7,185.7]
[null,"Total",205.2,196.5,186.4,183.7,185.7]
[]
[]
[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.365601021640586,43.847788530829874,44.581177098395408,47.461090779871256,52.113916667065148]
[]
[null,"Eastbound Reference Tariff","$GJ MDQ",{"$f":"Calculations!C42","v":0.55790442957797581},{"$f":"Calculations!D42","v":0.61706506847483433},{"$f":"Calculations!E42","v":0.68249914957635871},{"$f":"Calculations!F42","v":0.75487191378983354},{"$f":"Calculations!G42","v":0.83491914470872552}]
[null,"GPG Volumes","GJ MDQ PA",{"$f":"Inputs!C24*Inputs!C44*Inputs!C46","v":2263000},{"$f":"Inputs!D24*Inputs!D44*Inputs!D46","v":1500600},{"$f":"Inputs!E24*Inputs!E44*Inputs!E46","v":1277500},{"$f":"Inputs!F24*Inputs!F44*Inputs!F46","v":1752000},{"$f":"Inputs!G24*Inputs!G44*Inputs!G46","v":2482000}]
[null,"GPG Revenue",null,{"$f":"D34*D35/1000000","v":1.2625377241349593},{"$f":"E34*E35/1000000","v":0.92596784175333635},{"$f":"F34*F35/1000000","v":0.87189266358379824},{"$f":"G34*G35/1000000","v":1.3225355929597884},{"$f":"H34*H35/1000000","v":2.0722693171670565}]
[]
[null,"Other East bound Revenue","$m",24.896600260424393,26.389964279985758,28.104608053428478,30.452995693009413,33.050408265481082]
[]
[null,"Westbound Revenue","$m",16.206463037081235,16.531856409090778,15.604676381383131,15.685559493902057,16.99123908441701]
[]
[null,"Total Revenue",null,{"$f":"D36+D38+D40","v":42.365601021640586},{"$f":"E36+E38+E40","v":43.847788530829874},{"$f":"F36+F38+F40","v":44.581177098395408},{"$f":"G36+G38+G40","v":47.461090779871256},{"$f":"H36+H38+H40","v":52.113916667065148}]
[]
[]
[null,"Real Revenue ($FY22)"]
[]
[null,"Revenue",null,{"$f":"D27","v":"FY23"},{"$f":"E27","v":"FY24"},"FY25","FY26","FY27"]
[null,"Revenue",null,{"$f":"Inputs!C52*1000000","v":41535152.478515737},{"$f":"Inputs!D52*1000000","v":42145631.827607736},{"$f":"Inputs!E52*1000000","v":42010595.992500156},{"$f":"Inputs!F52*1000000","v":43847765.256891698},{"$f":"Inputs!G52*1000000","v":47202597.741435394}]
[]
[null,"RIN Total",null,41535152.478515729,42145631.827607736,42010595.992500149,43847765.256891705,47202597.741435394]
[]
[null,null,null,{"$f":"D48-D50","v":0},{"$f":"E48-E50","v":0},0,0,0]

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