{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","Calculations","Outputs"],"not_rendered":{"charts":0,"images":1,"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":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[10,0,10,6],[11,0,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Roma Brisbane Pipeline"]
["Westbound Competitive Tariff"]
[]
["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,"Prudent Discount","2020-21"]
[null,null,null,null,null,null,null,null,null,"DDP 134",0.2195]
["Competitive Westbound"," TJ MDQ/Day",null,null,null,null,null,null,null,"DDP 133",0.1004]
[]
["Westbound","$/GJ MDQ/Day"]
[null,null,null,null,null,null,null,null,null,"Source"]
["Construction Cost","$",8423579,null,null,null,null,null,null,"Proposal Information Plan 37/2021: Cost of construction is $8,423,579 (90% confidence level)"]
[]
["Opex estimate","% of Asset",0.01]
[]
["Opex","$",{"$f":"$C$27*$C$25","v":84235.790000000008},{"$f":"$C$27*$C$25","v":84235.790000000008},84235.790000000008,84235.790000000008,84235.790000000008]
[]
["Reference Tariff","$GJ/MDQ/Day",0.62380000000000002,0.62380000000000002,0.62370000000000003,0.62370000000000003,0.62380000000000002]
[]
[]
["Other inputs",null,"FY2022"]
[]
["CPI",null,2.2498471879899951E-2]
["$FY22 index",null,{"$f":"1*(1+C36)","v":1.0224984718799},{"$f":"C37*(1+FY22Inf)","v":1.0455031249967306},{"$f":"D37*(1+FY22Inf)","v":1.069025347654817},{"$f":"E37*(1+FY22Inf)","v":1.0930767843779292},{"$f":"F37*(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]

{"sheet":"Calculations","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"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"]
[]
["Annual Volumes"]
["Cummulative Volumes"]
[]
["Capex Cost per GJ","$FY2022"]
["Opex cost per GJ","$FY2022"]
["DDP tariff"]
["GJ Cost to Shipper"]
[]
["Reference tariff",null,{"$f":"Inputs!C31","v":0.62380000000000002},{"$f":"Inputs!D31","v":0.62380000000000002},{"$f":"Inputs!E31","v":0.62370000000000003},{"$f":"Inputs!F31","v":0.62370000000000003},{"$f":"Inputs!G31","v":0.62380000000000002}]
[]
["Difference"]
[]
["Discount"]
[]
["Prudent Discount Tariff"]

{"sheet":"Outputs","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,1,2,6]]}
[null,"X Factors"]
[]
[null,"Forecast Reference Tariff (Real)"]
[null,"Service","FY23","FY24","FY25","FY26","FY27"]
[null,"Prudent Discount Tariff"]