{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Scenario Manager","Assumptions","Construction","Operations","Income Statement","Opening Balance Sheet","Balance Sheet","Cash Flow Statement","Lookup","Error Checks","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":75,"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":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"Example"}]
[null,null,{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple example of a Project Finance Model."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Timing"]
[null,null,null,null,null,"Scenario Manager"]
[null,null,null,null,null,"Assumptions"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Operations"]
[null,null,null,null,null,"Income Statement"]
[null,null,null,null,null,"Opening Balance Sheet"]
[null,null,null,null,null,"Balance Sheet"]
[null,null,null,null,null,"Cash Flow Statement"]
[null,null,null,null,null,"Lookup"]
[null,null,null,null,null,"Error Checks"]
[null,null,null,null,null,"Change Log"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"Days_in_Year","v":365},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2024-03-19"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2024-03-19"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"Model 08 - Opex Completed.xlsm"}]
[null,null,null,null,"Client Name",null,"Example"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365,null,"Days_in_Year"]
[null,null,null,null,"Months in Month",null,1,null,"Months_in_Month"]
[null,null,null,null,"Months in Quarter",null,3,null,"Months_in_Qtr"]
[null,null,null,null,"Months in Half Yr",null,6,null,"Months_in_Half_Yr"]
[null,null,null,null,"Months in Year",null,12,null,"Months_in_Year"]
[null,null,null,null,"Quarters in Year",null,4,null,"Quarters_in_Year"]
[]
[null,null,null,null,"Rounding Accuracy",null,5,null,"Rounding_Accuracy"]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98,null,"Very_Large_Number"]
[null,null,null,null,"Very Small Number",null,1E-8,null,"Very_Small_Number"]
[]
[null,null,null,null,"Thousand",null,1000,null,"Thousand"]
[]
[]
[null,{"$f":"MAX($B$5:$B33)+1","v":3},"Technical Assumptions"]
[]
[null,null,"Units"]
[]
[null,null,null,null,"Unit",null,"#",null,"Unit"]
[null,null,null,null,"Currency",null,"US$'000",null,"Currency"]
[null,null,null,null,"Dollars",null,"$",null,"Dollars"]
[null,null,null,null,"Megawatt Hour",null,"MWh",null,"Megawatt_Hours"]
[null,null,null,null,"Dollars per Megawatt Hour",null,"$/MWh",null,"Dollars_per_Megawatt_Hour"]
[null,null,null,null,"Boolean",null,"[1,0]",null,"Boolean"]
[null,null,null,null,"Percentage",null,"%",null,"Percentage"]
[null,null,null,null,"No of Days",null,"# Days",null,"No_of_Days"]
[null,null,null,null,"Year",null,"Year",null,"Year"]
[null,null,null,null,"No of Years",null,"# Year(s)",null,"No_of_Years"]
[null,null,null,null,"Multiplier",null,"x",null,"Multiplier"]
[null,null,null,null,"Weight",null,"kg",null,"Weight"]
[null,null,null,null,"Price / Weight",null,"$/kg",null,"Price_Weight"]
[]
[]
[null,null,"Financial Statement Abbreviations"]
[]
[null,null,null,null,"Income Statement",null,"IS",null,"Income_Statement"]
[null,null,null,null,"Balance Sheet",null,"BS",null,"Balance_Sheet"]
[null,null,null,null,"Cash Flow Statement",null,"CFS",null,"Cash_Flow_Statement"]
[]
[]
[null,null,"Tax Depreciation"]
[]
[null,null,null,null,"Declining Balance Multiple",null,2,null,"Declining_Balance_Multiple"]

{"sheet":"Timing","index":4,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Timing"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2024-06-30"},{"$f":"K$7","v":"2025-06-30"},"2026-06-30","2027-06-30","2028-06-30","2029-06-30","2030-06-30","2031-06-30","2032-06-30","2033-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$11=1,Model_Start_Date,I$7+1)","v":"2023-07-01"},"2024-07-01","2025-07-01","2026-07-01","2027-07-01","2028-07-01","2029-07-01","2030-07-01","2031-07-01","2032-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2024-06-30"},"2025-06-30","2026-06-30","2027-06-30","2028-06-30","2029-06-30","2030-06-30","2031-06-30","2032-06-30","2033-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":366},{"$f":"K7-K6+1","v":365},365,365,366,365,365,365,366,365]
[null,null,"Construction period",null,null,null,null,null,null,{"$f":"IF(J$11<=ConstructionPeriod,J$11,)","v":1},2,3,0,0,0,0,0,0,0]
[null,null,"Operations period",null,null,null,null,null,null,{"$f":"IF(J$11<=ConstructionPeriod,,J$11-ConstructionPeriod)","v":0},0,0,1,2,3,4,5,6,7]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$11)+1","v":1},{"$f":"N(J$11)+1","v":2},3,4,5,6,7,8,9,10]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Timing"}]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,"2023-07-01"]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12]
[]
[null,null,null,"Example Reporting Month",null,null,null,6,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 30-Jun-24"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":6}]
[]
[null,null,null,"Months per Year",null,null,null,12]
[]
[null,null,null,"Construction year(s)",null,null,null,3]

{"sheet":"Scenario Manager","index":5,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Scenario Manager"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Scenario Manager"}]
[]
[null,null,"Assumptions"]
[]
[null,null,null,null,null,null,null,"Scenario"]
[null,null,null,null,"Scenario Selection",null,{"$f":"Unit","v":"#"},1]
[]
[null,null,null,null,null,null,null,{"$f":"\"Scenario \"&TEXT(Active_Scenario,\"0\")","v":"Scenario 1"},null,{"$f":"N(I20)+1","v":1},{"$f":"N(J20)+1","v":2},3,4,5,6,7,8,9,10]
[null,null,null,null,"Construction cost sensitivity",null,{"$f":"Percentage","v":"%"},{"$f":"IF(Active_Scenario>0,OFFSET($I21,,Active_Scenario),J21)","v":0},null,0,0.1,-0.1,0,0,0,0,0,0,0]
[null,null,null,null,"Generation profile in use",null,null,{"$f":"IF(Active_Scenario>0,OFFSET($I22,,Active_Scenario),J22)","v":"P90"},null,"P90","P50","P10","P90","P90","P90","P90","P90","P90","P90"]
[null,null,null,null,"Electricity sales price sensitivity",null,{"$f":"Percentage","v":"%"},0,null,0,0.1,-0.1,0,0,0,0,0,0,0]
[null,null,null,null,"COGS sensitivity",null,{"$f":"Percentage","v":"%"},0,null,0,0.1,-0.1,0,0,0,0,0,0,0]
[null,null,null,null,"Loan term",null,{"$f":"No_of_Years","v":"# Year(s)"},6,null,6,7,6,6,6,6,6,6,6,6]
[null,null,null,null,"Debt margin",null,{"$f":"Percentage","v":"%"},0.03,null,0.03,0.02,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,"Post Tax Cost of Equity",null,"%",0.15,null,0.15,0.14000000000000001,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,null,null,null,"Pre-Tax Cost of Debt",null,"%",0.08,null,0.08,7.4999999999999997E-2,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,null,null,null,"Debt as a Proportion of Debt + Equity",null,"%",0.3,null,0.3,0.35,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,null,null,"Growth Rate",null,"%",0.02,null,0.02,0.03,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[]
[null,null,"Scenario results"]
[]
[null,null,null,null,null,null,null,{"$f":"H20","v":"Scenario 1"},null,{"$f":"J20","v":1},2,3,4,5,6,7,8,9,10]
[null,null,null,null,"Closing cash balance",null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Equity Value",null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Enterprise Value",null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Minimum DSCR",null,"x"]
[null,null,null,null,"Minimum LLCR",null,"x"]
[null,null,null,null,"Minimum PLCR",null,"x"]

{"sheet":"Assumptions","index":6,"n_rows":201,"n_cols":21,"rows_kept":201,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Assumptions"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},"Construction"]
[]
[null,null,"Construction costs"]
[]
[null,null,null,"Construction costs"]
[]
[null,null,null,null,"Modules",null,{"$f":"Currency","v":"US$'000"},null,null,1000,2000,3000,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":""}]
[null,null,null,null,"Inverters",null,"US$'000",null,null,1000,2000,3000,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J20),\"\")","v":""}]
[null,null,null,null,"Racking and mounting",null,"US$'000",null,null,1000,2000,3000,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Grid connection",null,"US$'000",null,null,1000,2000,3000,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Other hardware",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Installation",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Other",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total",null,"US$'000",null,null,{"$f":"SUM(J19:J25)","v":4000},{"$f":"SUM(K19:K25)","v":8000},12000,0,0,0,0,0,0,0,null,"=SUM(J19:J25)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Construction cost sensitivity",null,{"$f":"Percentage","v":"%"},null,{"$f":"'Scenario Manager'!$H$21","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I28),\"\")","v":"='Scenario Manager'!$H$21"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Modules in use",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J19*(1+$I$28)*(J$9>0)","v":1000},{"$f":"K19*(1+$I$28)*(K$9>0)","v":2000},3000,0,0,0,0,0,0,0,null,"=J19*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Inverters in use",null,"US$'000",null,null,{"$f":"J20*(1+$I$28)*(J$9>0)","v":1000},2000,3000,0,0,0,0,0,0,0,null,"=J20*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Racking and mounting in use",null,"US$'000",null,null,1000,2000,3000,0,0,0,0,0,0,0,null,"=J21*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Grid connection in use",null,"US$'000",null,null,1000,2000,3000,0,0,0,0,0,0,0,null,"=J22*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Other hardware in use",null,"US$'000",null,null,0,0,0,0,0,0,0,0,0,0,null,"=J23*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Installation in use",null,"US$'000",null,null,0,0,0,0,0,0,0,0,0,0,null,"=J24*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Other in use",null,"US$'000",null,null,0,0,0,0,0,0,0,0,0,0,null,"=J25*(1+$I$28)*(J$9>0)"]
[null,null,null,null,"Total in use",null,"US$'000",null,null,{"$f":"SUM(J30:J36)","v":4000},{"$f":"SUM(K30:K36)","v":8000},12000,0,0,0,0,0,0,0,null,"=SUM(J30:J36)"]
[]
[]
[]
[null,null,"Debt"]
[]
[null,null,null,"Funding"]
[]
[null,null,null,null,"Initial equity",null,{"$f":"Currency","v":"US$'000"},null,6000]
[null,null,null,null,"Debt limit",null,{"$f":"Currency","v":"US$'000"},null,16000]
[]
[null,null,null,"Debt terms"]
[]
[null,null,null,null,"Margin",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,3.5000000000000003E-2]
[null,null,null,null,"Establishment fee",null,{"$f":"Percentage","v":"%"},null,0.02]
[null,null,null,null,"Commitment fee",null,{"$f":"Percentage&\" of margin\"","v":"% of margin"},null,0.5]
[]
[]
[null,{"$f":"MAX($B$12:$B54)+1","v":2},"Operations"]
[]
[null,null,"Generation"]
[]
[null,null,null,"Expected generation"]
[]
[null,null,null,null,"Annual generation"]
[null,null,null,null,"P10",null,null,null,null,null,null,null,65000,65000,65000,65000,65000,65000,65000]
[null,null,null,null,"P50",null,null,null,null,null,null,null,60000,60000,60000,60000,60000,60000,60000]
[null,null,null,null,"P90",null,null,null,null,null,null,null,55000,55000,55000,55000,55000,55000,55000]
[null,null,null,null,"Annual generation in use",null,{"$f":"Megawatt_Hours","v":"MWh"},null,{"$f":"'Scenario Manager'!$H$22","v":"P90"},{"$f":"IFERROR(INDEX(J62:J64,MATCH($I65,LU_Gen_Profiles,0)),J63)","v":0},0,0,55000,55000,55000,55000,55000,55000,55000,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J65),\"\")","v":"=IFERROR(INDEX(J62:J64,MATCH($I65,LU_Gen_Profiles,0)),J63)"}]
[]
[null,null,null,null,"Annual degradation",null,{"$f":"Percentage","v":"%"},null,0.02]
[]
[null,null,"Revenue and related"]
[]
[null,null,null,"Sales"]
[]
[null,null,null,null,"Electricity sales price",null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,null,null,null,100,103,106,109,112,115,118]
[]
[null,null,null,null,"Electricity sales price sensitivity",null,{"$f":"Percentage","v":"%"},null,{"$f":"'Scenario Manager'!$H$23","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I75),\"\")","v":"='Scenario Manager'!$H$23"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I76),\"\")","v":""}]
[null,null,null,null,"Electricity sales price in use",null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,{"$f":"J73*(1+$I75)","v":0},{"$f":"K73*(1+$I75)","v":0},0,100,103,106,109,112,115,118,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J77),\"\")","v":"=J73*(1+$I75)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days receivable",null,{"$f":"No_of_Days","v":"# Days"},null,null,60,60,60,60,60,60,60,60,60,60,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"COGS and related",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"COGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Cost per MWh",null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,null,null,null,20,20,20,20,20,20,20,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"COGS sensitivity",null,{"$f":"Percentage","v":"%"},null,{"$f":"'Scenario Manager'!$H$24","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I90),\"\")","v":"='Scenario Manager'!$H$24"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Cost per MWh in use",null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,{"$f":"J88*(1+$I90)","v":0},{"$f":"K88*(1+$I90)","v":0},0,20,20,20,20,20,20,20,null,"=J88*(1+$I90)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days payable",null,{"$f":"No_of_Days","v":"# Days"},null,null,90,90,90,90,90,90,90,90,90,90,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,"Opex and cash payments"]
[null,null,"All expenses are assumed to be paid as they are incurred"]
[]
[null,null,null,"Opex"]
[]
[null,null,null,null,"Projected costs",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,200,225,250,275,300,325,350]
[]
[]
[null,null,"Capex and related"]
[]
[null,null,null,"Capital expenditure"]
[]
[null,null,null,null,"Capital expenditure",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,500,1000]
[]
[null,null,null,"Accounting depreciation - straight line"]
[null,null,null,null,null,null,null,null,"Remaining life","Depreciation rate"]
[null,null,null,null,"Construction assets",null,null,null,10,{"$f":"IF(I115=0,,1/I115)","v":0.1}]
[null,null,null,null,"Capital expenditure",null,null,null,4,{"$f":"IF(I116=0,,1/I116)","v":0.25}]
[]
[null,null,null,"MRA"]
[]
[null,null,null,null,"MRA hold-back",null,{"$f":"No_of_Years","v":"# Year(s)"},null,4]
[]
[]
[null,null,"Debt and related"]
[null,null,"Movements are assumed to occur at the end of each period"]
[]
[null,null,null,"Interest"]
[]
[null,null,null,null,"BBSW",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,null,2E-3,1.5E-3,3.0000000000000001E-3,5.0000000000000001E-3,7.4999999999999997E-3,1.0999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[]
[null,null,null,"Terms"]
[]
[null,null,null,null,"Loan term",null,{"$f":"No_of_Years","v":"# Year(s)"}]
[null,null,null,null,"Margin",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."}]
[]
[null,null,null,null,"Repayment method",null,"Selection",null,"Annuity"]
[]
[null,null,null,"Interest receivable"]
[]
[null,null,null,null,"Interest receivable?",null,"Selection",null,"No"]
[null,null,null,null,"Interest receivable rate",null,{"$f":"Percentage","v":"%"},null,null,null,null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,"DSCR sculpting target"]
[]
[null,null,null,null,"DSCR sculpting",null,"x",null,1.5]
[]
[null,null,null,"DSRA"]
[]
[null,null,null,null,"DSRA hold-back",null,{"$f":"No_of_Years","v":"# Year(s)"},null,1]
[null,null,null,null,"Initial DSRA funding",null,{"$f":"Currency","v":"US$'000"},null,5500]
[]
[null,null,null,"Working capital facility"]
[]
[null,null,null,null,"Facility limit",null,{"$f":"Currency","v":"US$'000"},null,500]
[null,null,null,null,"Interest rate",null,{"$f":"Percentage","v":"%"},null,0.1]
[]
[null,null,null,"DSCR Inputs"]
[]
[null,null,null,null,"Lock-up ratio",null,"x",null,1.1499999999999999]
[null,null,null,null,"Lock-up periods",null,{"$f":"Unit","v":"#"},null,2]
[]
[]
[null,null,null,null,"Cash sweep?",null,"Selection",null,"No"]
[null,null,null,null,"Cash sweep ratio",null,"x",null,1.3]
[null,null,null,null,"Excess sweep %",null,{"$f":"Percentage","v":"%"},null,0.35]
[]
[]
[null,null,"Convertible debt"]
[null,null,"Movements are assumed to occur at the end of each period"]
[]
[null,null,null,"Terms"]
[]
[null,null,null,null,"Loan term",null,{"$f":"No_of_Years","v":"# Year(s)"},null,5]
[null,null,null,null,"Margin",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,0.02]
[]
[null,null,null,"Repayment"]
[]
[null,null,null,null,"Portion of cash to sweep",null,{"$f":"Percentage","v":"%"},null,1]
[]
[]
[null,null,"Taxation"]
[]
[null,null,null,"Tax rate"]
[]
[null,null,null,null,"Tax rate",null,{"$f":"Percentage","v":"%"},null,0.3]
[]
[null,null,null,"Permanent differences"]
[]
[null,null,null,null,"Non-assessable revenue",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,25,25,25,25,25,25,25]
[null,null,null,null,"Disallowable expenses",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,30,30,30,30,30,30,30]
[]
[null,null,null,"Tax payable and paid"]
[]
[null,null,null,null,"Payment delay",null,{"$f":"No_of_Years","v":"# Year(s)"},null,1]
[]
[]
[null,null,"Ordinary equity and related"]
[]
[null,null,null,"Dividends"]
[null,null,null,"Dividends are assumed to be paid in the period after they are declared"]
[]
[null,null,null,null,"Dividend payout ratio",null,{"$f":"Percentage","v":"%"},null,null,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Construction","index":7,"n_rows":110,"n_cols":21,"rows_kept":110,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Construction"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Construction"}]
[]
[null,null,"Construction"]
[]
[null,null,null,"Construction costs"]
[]
[null,null,null,null,"Modules in use",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Assumptions!J30","v":1000},{"$f":"Assumptions!K30","v":2000},{"$f":"Assumptions!L30","v":3000},{"$f":"Assumptions!M30","v":0},{"$f":"Assumptions!N30","v":0},{"$f":"Assumptions!O30","v":0},{"$f":"Assumptions!P30","v":0},{"$f":"Assumptions!Q30","v":0},{"$f":"Assumptions!R30","v":0},{"$f":"Assumptions!S30","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":"=Assumptions!J30"}]
[null,null,null,null,"Inverters in use",null,"US$'000",null,null,{"$f":"Assumptions!J31","v":1000},{"$f":"Assumptions!K31","v":2000},{"$f":"Assumptions!L31","v":3000},{"$f":"Assumptions!M31","v":0},{"$f":"Assumptions!N31","v":0},{"$f":"Assumptions!O31","v":0},{"$f":"Assumptions!P31","v":0},{"$f":"Assumptions!Q31","v":0},{"$f":"Assumptions!R31","v":0},{"$f":"Assumptions!S31","v":0},null,"=Assumptions!J31"]
[null,null,null,null,"Racking and mounting in use",null,"US$'000",null,null,{"$f":"Assumptions!J32","v":1000},{"$f":"Assumptions!K32","v":2000},{"$f":"Assumptions!L32","v":3000},{"$f":"Assumptions!M32","v":0},{"$f":"Assumptions!N32","v":0},{"$f":"Assumptions!O32","v":0},{"$f":"Assumptions!P32","v":0},{"$f":"Assumptions!Q32","v":0},{"$f":"Assumptions!R32","v":0},{"$f":"Assumptions!S32","v":0},null,"=Assumptions!J32"]
[null,null,null,null,"Grid connection in use",null,"US$'000",null,null,{"$f":"Assumptions!J33","v":1000},{"$f":"Assumptions!K33","v":2000},{"$f":"Assumptions!L33","v":3000},{"$f":"Assumptions!M33","v":0},{"$f":"Assumptions!N33","v":0},{"$f":"Assumptions!O33","v":0},{"$f":"Assumptions!P33","v":0},{"$f":"Assumptions!Q33","v":0},{"$f":"Assumptions!R33","v":0},{"$f":"Assumptions!S33","v":0},null,"=Assumptions!J33"]
[null,null,null,null,"Other hardware in use",null,"US$'000",null,null,{"$f":"Assumptions!J34","v":0},{"$f":"Assumptions!K34","v":0},{"$f":"Assumptions!L34","v":0},{"$f":"Assumptions!M34","v":0},{"$f":"Assumptions!N34","v":0},{"$f":"Assumptions!O34","v":0},{"$f":"Assumptions!P34","v":0},{"$f":"Assumptions!Q34","v":0},{"$f":"Assumptions!R34","v":0},{"$f":"Assumptions!S34","v":0},null,"=Assumptions!J34"]
[null,null,null,null,"Installation in use",null,"US$'000",null,null,{"$f":"Assumptions!J35","v":0},{"$f":"Assumptions!K35","v":0},{"$f":"Assumptions!L35","v":0},{"$f":"Assumptions!M35","v":0},{"$f":"Assumptions!N35","v":0},{"$f":"Assumptions!O35","v":0},{"$f":"Assumptions!P35","v":0},{"$f":"Assumptions!Q35","v":0},{"$f":"Assumptions!R35","v":0},{"$f":"Assumptions!S35","v":0},null,"=Assumptions!J35"]
[null,null,null,null,"Other in use",null,"US$'000",null,null,{"$f":"Assumptions!J36","v":0},{"$f":"Assumptions!K36","v":0},{"$f":"Assumptions!L36","v":0},{"$f":"Assumptions!M36","v":0},{"$f":"Assumptions!N36","v":0},{"$f":"Assumptions!O36","v":0},{"$f":"Assumptions!P36","v":0},{"$f":"Assumptions!Q36","v":0},{"$f":"Assumptions!R36","v":0},{"$f":"Assumptions!S36","v":0},null,"=Assumptions!J36"]
[null,null,null,null,"Total",null,"US$'000",null,null,{"$f":"SUM(J19:J25)","v":4000},{"$f":"SUM(K19:K25)","v":8000},12000,0,0,0,0,0,0,0,null,"=SUM(J19:J25)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Construction costs applied",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J26","v":4000},{"$f":"K26","v":8000},12000,0,0,0,0,0,0,0,null,"=J26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Funding costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Interest during construction",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J80+J110","v":0},{"$f":"K80+K110","v":0},261.44000000000005,0,0,0,0,0,0,0,null,"=J80+J110"]
[null,null,null,null,"Establishment fees",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J86","v":320},{"$f":"K86","v":0},0,0,0,0,0,0,0,0,null,"=J86"]
[null,null,null,null,"Commitment fees",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J92","v":280},{"$f":"K92","v":280},159.60000000000002,0,0,0,0,0,0,0,null,"=J92"]
[null,null,null,null,"Total",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J32:J34)","v":600},{"$f":"SUM(K32:K34)","v":280},421.04000000000008,0,0,0,0,0,0,0,null,"=SUM(J32:J34)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Cost waterfall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Construction costs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J28+J35","v":4600},{"$f":"K28+K35","v":8280},12421.04,0,0,0,0,0,0,0,null,"=J28+J35"]
[null,null,null,null,"DSRA initial funding",null,"US$'000",null,{"$f":"Assumptions!I149","v":5500},{"$f":"IF(J$9=MAX($J$9:$S$9),$I40,0)","v":0},{"$f":"IF(K$9=MAX($J$9:$S$9),$I40,0)","v":0},5500,0,0,0,0,0,0,0,null,"=IF(J$9=MAX($J$9:$S$9),$I40,0)"]
[null,null,null,null,"Less: Equity funding",null,"US$'000",null,null,{"$f":"-MIN(SUM(J39:J40),J58)","v":-4600},{"$f":"-MIN(SUM(K39:K40),K58)","v":-1400},0,0,0,0,0,0,0,0,null,"=-MIN(SUM(J39:J40),J58)"]
[null,null,null,null,"Costs remaining after equity",null,"US$'000",null,null,{"$f":"SUM(J39:J41)","v":0},{"$f":"SUM(K39:K41)","v":6880},17921.04,0,0,0,0,0,0,0,null,"=SUM(J39:J41)"]
[null,null,null,null,"Less: Debt funding",null,"US$'000",null,null,{"$f":"-MIN(J42,J72)","v":0},{"$f":"-MIN(K42,K72)","v":-6880},-9120,0,0,0,0,0,0,0,null,"=-MIN(J42,J72)"]
[null,null,null,null,"Costs remaining after debt",null,"US$'000",null,null,{"$f":"SUM(J42:J43)","v":0},{"$f":"SUM(K42:K43)","v":0},8801.0400000000009,0,0,0,0,0,0,0,null,"=SUM(J42:J43)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Equity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening balance",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I54","v":0},{"$f":"J54","v":4600},6000,0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=I54"]
[null,null,null,null,"Equity funding",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J41","v":4600},{"$f":"-K41","v":1400},0,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=-J41"]
[null,null,null,null,"Transfer to operations",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=MAX($J$9:$S$9),-SUM(J51:J52),0)","v":0},{"$f":"IF(K$9=MAX($J$9:$S$9),-SUM(K51:K52),0)","v":0},-6000,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=IF(J$9=MAX($J$9:$S$9),-SUM(J51:J52),0)"]
[null,null,null,null,"Closing balance",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$56","v":0},{"$f":"SUM(J51:J53)","v":4600},6000,0,0,0,0,0,0,0,{"$f":"SUM(S51:S53)","v":0},{"$f":"Balance_Sheet","v":"BS"},"=SUM(J51:J53)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Initial equity",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"Assumptions!$I$45","v":6000},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Limit remaining (before drawdown)",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=0,0,MAX($I56-J51,0))","v":6000},{"$f":"IF(K$9=0,0,MAX($I56-K51,0))","v":1400},0,0,0,0,0,0,0,0,null,"=IF(J$9=0,0,MAX($I56-J51,0))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Debt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening balance",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I68","v":0},{"$f":"J68","v":0},6880,0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=I68"]
[null,null,null,null,"Debt drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J43","v":0},{"$f":"-K43","v":6880},9120,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=-J43"]
[null,null,null,null,"Refinancing at completion",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=MAX($J$9:$S$9),-SUM(J65:J66),0)","v":0},{"$f":"IF(K$9=MAX($J$9:$S$9),-SUM(K65:K66),0)","v":0},-16000,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=IF(J$9=MAX($J$9:$S$9),-SUM(J65:J66),0)"]
[null,null,null,null,"Closing balance",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$44","v":0},{"$f":"SUM(J65:J67)","v":0},{"$f":"SUM(K65:K67)","v":6880},{"$f":"SUM(L65:L67)","v":0},0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J65:J67)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Debt limit",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"Assumptions!$I$46","v":16000},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Limit remaining (before drawdown)",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=0,0,MAX($I70-J65,0))","v":16000},{"$f":"IF(K$9=0,0,MAX($I70-K65,0))","v":16000},9120,0,0,0,0,0,0,0,null,"=IF(J$9=0,0,MAX($I70-J65,0))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"BBSW",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,null,{"$f":"Assumptions!J128","v":2E-3},{"$f":"Assumptions!K128","v":1.5E-3},{"$f":"Assumptions!L128","v":3.0000000000000001E-3},{"$f":"Assumptions!M128","v":5.0000000000000001E-3},{"$f":"Assumptions!N128","v":7.4999999999999997E-3},{"$f":"Assumptions!O128","v":1.0999999999999999E-2},{"$f":"Assumptions!P128","v":1.4E-2},{"$f":"Assumptions!Q128","v":1.4999999999999999E-2},{"$f":"Assumptions!R128","v":1.4999999999999999E-2},{"$f":"Assumptions!S128","v":1.4999999999999999E-2},null,"=Assumptions!J128"]
[null,null,null,null,"Margin",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,{"$f":"Assumptions!$I$50","v":3.5000000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"All-in rate",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,null,{"$f":"($I77+J76)*MIN(J$8,Days_in_Year)/Days_in_Year","v":3.7000000000000005E-2},3.6500000000000005E-2,3.8000000000000006E-2,0.04,4.2500000000000003E-2,4.5999999999999999E-2,4.9000000000000002E-2,0.05,0.05,0.05,null,"=($I77+J76)*MIN(J$8,Days_in_Year)/Days_in_Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Interest",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J65*J78","v":0},{"$f":"K65*K78","v":0},261.44000000000005,0,0,0,0,0,0,0,null,"=J65*J78"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Establishment fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J83),\"\")","v":""}]
[null,null,null,null,"Establishment fee",null,{"$f":"Percentage","v":"%"},null,{"$f":"Assumptions!$I$51","v":0.02},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Establishment fee",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=1,$I70*$I84,0)","v":320},{"$f":"IF(K$9=1,$I70*$I84,0)","v":0},0,0,0,0,0,0,0,0,null,"=IF(J$9=1,$I70*$I84,0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Commitment fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Commitment fee",null,{"$f":"Percentage&\" of margin\"","v":"% of margin"},null,{"$f":"Assumptions!$I$52","v":0.5},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Commitment fee",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"$I90*$I77*J72","v":280},{"$f":"$I90*$I77*K72","v":280},159.60000000000002,0,0,0,0,0,0,0,null,"=$I90*$I77*J72"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Convertible debt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening balance",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I102","v":0},{"$f":"J102","v":0},0,0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=I102"]
[null,null,null,null,"Debt drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J44","v":0},{"$f":"K44","v":0},8801.0400000000009,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J44"]
[null,null,null,null,"Transfer to operations",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=MAX($J$9:$S$9),-SUM(J99:J100),0)","v":0},{"$f":"IF(K$9=MAX($J$9:$S$9),-SUM(K99:K100),0)","v":0},-8801.0400000000009,0,0,0,0,0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"},"=IF(J$9=MAX($J$9:$S$9),-SUM(J99:J100),0)"]
[null,null,null,null,"Closing balance",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$45","v":0},{"$f":"SUM(J99:J101)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R99:R101)","v":0},{"$f":"SUM(S99:S101)","v":0},{"$f":"Balance_Sheet","v":"BS"},"=SUM(J99:J101)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"BBSW",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,null,{"$f":"Assumptions!J128","v":2E-3},{"$f":"Assumptions!K128","v":1.5E-3},{"$f":"Assumptions!L128","v":3.0000000000000001E-3},{"$f":"Assumptions!M128","v":5.0000000000000001E-3},{"$f":"Assumptions!N128","v":7.4999999999999997E-3},{"$f":"Assumptions!O128","v":1.0999999999999999E-2},{"$f":"Assumptions!P128","v":1.4E-2},{"$f":"Assumptions!Q128","v":1.4999999999999999E-2},{"$f":"Assumptions!R128","v":1.4999999999999999E-2},{"$f":"Assumptions!S128","v":1.4999999999999999E-2},null,"=Assumptions!J128"]
[null,null,null,null,"Margin",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,{"$f":"Assumptions!$I$173","v":0.02},null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"All-in rate",null,{"$f":"Percentage&\" p.a.\"","v":"% p.a."},null,null,{"$f":"($I107+J106)*MIN(J$8,Days_in_Year)/Days_in_Year","v":2.1999999999999999E-2},2.1500000000000002E-2,2.3E-2,2.5000000000000001E-2,2.75E-2,3.1E-2,3.4000000000000002E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,null,"=($I107+J106)*MIN(J$8,Days_in_Year)/Days_in_Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Interest",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J99*J108","v":0},{"$f":"K99*K108","v":0},0,0,0,0,0,0,0,0,null,"=J99*J108"]

{"sheet":"Operations","index":8,"n_rows":96,"n_cols":21,"rows_kept":96,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Operations"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Operations"}]
[]
[null,null,{"$f":"Assumptions!C57","v":"Generation"}]
[]
[null,null,null,{"$f":"Assumptions!D59","v":"Expected generation"}]
[]
[null,null,null,null,{"$f":"Assumptions!E65","v":"Annual generation in use"},null,{"$f":"Megawatt_Hours","v":"MWh"},null,null,{"$f":"Assumptions!J65","v":0},{"$f":"Assumptions!K65","v":0},{"$f":"Assumptions!L65","v":0},{"$f":"Assumptions!M65","v":55000},{"$f":"Assumptions!N65","v":55000},{"$f":"Assumptions!O65","v":55000},{"$f":"Assumptions!P65","v":55000},{"$f":"Assumptions!Q65","v":55000},{"$f":"Assumptions!R65","v":55000},{"$f":"Assumptions!S65","v":55000},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":"=Assumptions!J65"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"Assumptions!E67","v":"Annual degradation"},null,{"$f":"Percentage","v":"%"},null,{"$f":"Assumptions!$I$67","v":0.02},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I21),\"\")","v":"=Assumptions!$I$67"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Adjusted generation",null,{"$f":"Megawatt_Hours","v":"MWh"},null,null,{"$f":"IF(J$10=0,,J19*((1-$I21)^(J$10-1)))","v":0},{"$f":"IF(K$10=0,,K19*((1-$I21)^(K$10-1)))","v":0},0,55000,53900,52821.999999999993,51765.56,50730.248799999994,49715.643823999992,48721.330947519986,null,"=IF(J$10=0,,J19*((1-$I21)^(J$10-1)))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"Assumptions!C69","v":"Revenue and related"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"Assumptions!D71","v":"Sales"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"Assumptions!E77","v":"Electricity sales price in use"},null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,{"$f":"Assumptions!J77","v":0},{"$f":"Assumptions!K77","v":0},{"$f":"Assumptions!L77","v":0},{"$f":"Assumptions!M77","v":100},{"$f":"Assumptions!N77","v":103},{"$f":"Assumptions!O77","v":106},{"$f":"Assumptions!P77","v":109},{"$f":"Assumptions!Q77","v":112},{"$f":"Assumptions!R77","v":115},{"$f":"Assumptions!S77","v":118},null,"=Assumptions!J77"]
[null,null,null,null,{"$f":"E23","v":"Adjusted generation"},null,{"$f":"Megawatt_Hours","v":"MWh"},{"$f":"\"Row \"&ROW(J23)","v":"Row 23"},null,{"$f":"J23","v":0},{"$f":"K23","v":0},0,55000,53900,52821.999999999993,51765.56,50730.248799999994,49715.643823999992,48721.330947519986,null,"=J23"]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J30*J31/Thousand","v":0},0,0,5500,5551.7,5599.1319999999987,5642.4460399999998,5681.7878655999993,5717.2990397599988,5749.1170518073577,null,"=J30*J31/Thousand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days receivable",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"Assumptions!J81","v":60},{"$f":"Assumptions!K81","v":60},{"$f":"Assumptions!L81","v":60},{"$f":"Assumptions!M81","v":60},{"$f":"Assumptions!N81","v":60},{"$f":"Assumptions!O81","v":60},{"$f":"Assumptions!P81","v":60},{"$f":"Assumptions!Q81","v":60},{"$f":"Assumptions!R81","v":60},{"$f":"Assumptions!S81","v":60},null,"=Assumptions!J81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days in period",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":366},{"$f":"K$8","v":365},365,365,366,365,365,365,366,365,null,"=J$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Closing receivables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J32*J36/J38","v":0},{"$f":"K32*K36/K38","v":0},0,904.10958904109589,910.11475409836066,920.40526027397243,927.52537643835615,933.99252585205477,937.26213766557362,945.06033728340117,null,"=J32*J36/J38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening receivables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I47","v":0},{"$f":"J47","v":0},0,0,904.10958904109589,910.11475409836066,920.40526027397243,927.52537643835615,933.99252585205477,937.26213766557362,{"$f":"Balance_Sheet","v":"BS"},"=I47"]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J32","v":0},{"$f":"K32","v":0},0,5500,5551.7,5599.1319999999987,5642.4460399999998,5681.7878655999993,5717.2990397599988,5749.1170518073577,{"$f":"Income_Statement","v":"IS"},"=J32"]
[null,null,null,null,"Cash receipts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J47-SUM(J44:J45)","v":0},{"$f":"K47-SUM(K44:K45)","v":0},0,-4595.8904109589039,-5545.6948349427348,-5588.8414938243877,-5635.3259238356159,-5675.3207161863011,-5714.0294279464797,-5741.3188521895299,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J47-SUM(J44:J45)"]
[null,null,null,null,"Closing receivables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$19","v":0},{"$f":"J40","v":0},{"$f":"K40","v":0},0,904.10958904109589,910.11475409836066,920.40526027397243,927.52537643835615,933.99252585205477,937.26213766557362,945.06033728340117,{"$f":"Balance_Sheet","v":"BS"},"=J40"]
[]
[]
[null,null,"COGS and related",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J50),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"COGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"E23","v":"Adjusted generation"},null,{"$f":"Megawatt_Hours","v":"MWh"},{"$f":"\"Row \"&ROW(J23)","v":"Row 23"},null,{"$f":"J23","v":0},{"$f":"K23","v":0},0,55000,53900,52821.999999999993,51765.56,50730.248799999994,49715.643823999992,48721.330947519986,null,"=J23"]
[null,null,null,null,{"$f":"Assumptions!E92","v":"Cost per MWh in use"},null,{"$f":"Dollars_per_Megawatt_Hour","v":"$/MWh"},null,null,{"$f":"Assumptions!J92","v":0},{"$f":"Assumptions!K92","v":0},{"$f":"Assumptions!L92","v":0},{"$f":"Assumptions!M92","v":20},{"$f":"Assumptions!N92","v":20},{"$f":"Assumptions!O92","v":20},{"$f":"Assumptions!P92","v":20},{"$f":"Assumptions!Q92","v":20},{"$f":"Assumptions!R92","v":20},{"$f":"Assumptions!S92","v":20},null,"=Assumptions!J92"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J54*J55/Thousand","v":0},0,0,1100,1078,1056.4399999999998,1035.3111999999999,1014.6049759999999,994.31287647999989,974.42661895039964,null,"=J54*J55/Thousand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"Assumptions!E96","v":"Days payable"},null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"Assumptions!J96","v":90},{"$f":"Assumptions!K96","v":90},{"$f":"Assumptions!L96","v":90},{"$f":"Assumptions!M96","v":90},{"$f":"Assumptions!N96","v":90},{"$f":"Assumptions!O96","v":90},{"$f":"Assumptions!P96","v":90},{"$f":"Assumptions!Q96","v":90},{"$f":"Assumptions!R96","v":90},{"$f":"Assumptions!S96","v":90},null,"=Assumptions!J96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days in period",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":366},{"$f":"K$8","v":365},365,365,366,365,365,365,366,365,null,"=J$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J56*J60/J62","v":0},{"$f":"K56*K60/K62","v":0},0,271.23287671232879,265.08196721311475,260.49205479452053,255.2822136986301,250.17656942465752,244.50316634754094,240.26957727544101,null,"=J56*J60/J62"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I71","v":0},{"$f":"J71","v":0},0,0,271.23287671232879,265.08196721311475,260.49205479452053,255.2822136986301,250.17656942465752,244.50316634754094,{"$f":"Balance_Sheet","v":"BS"},"=I71"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J56","v":0},{"$f":"K56","v":0},0,1100,1078,1056.4399999999998,1035.3111999999999,1014.6049759999999,994.31287647999989,974.42661895039964,{"$f":"Income_Statement","v":"IS"},"=J56"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J71-SUM(J68:J69)","v":0},{"$f":"K71-SUM(K68:K69)","v":0},0,-828.76712328767121,-1084.1509094992141,-1061.029912418594,-1040.5210410958903,-1019.7106202739725,-999.98627955711652,-978.66020802249955,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J71-SUM(J68:J69)"]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$36","v":0},{"$f":"J64","v":0},{"$f":"K64","v":0},0,271.23287671232879,265.08196721311475,260.49205479452053,255.2822136986301,250.17656942465752,244.50316634754094,240.26957727544101,{"$f":"Balance_Sheet","v":"BS"},"=J64"]
[]
[]
[null,null,"Opex and cash payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J74),\"\")","v":""}]
[null,null,{"$f":"Assumptions!C100","v":"All expenses are assumed to be paid as they are incurred"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"Assumptions!D102","v":"Opex"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"Assumptions!E104","v":"Projected costs"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Assumptions!J104","v":0},{"$f":"Assumptions!K104","v":0},{"$f":"Assumptions!L104","v":0},{"$f":"Assumptions!M104","v":200},{"$f":"Assumptions!N104","v":225},{"$f":"Assumptions!O104","v":250},{"$f":"Assumptions!P104","v":275},{"$f":"Assumptions!Q104","v":300},{"$f":"Assumptions!R104","v":325},{"$f":"Assumptions!S104","v":350},null,"=Assumptions!J104"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"D77","v":"Opex"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$10=0,,J79)","v":0},{"$f":"IF(K$10=0,,K79)","v":0},0,200,225,250,275,300,325,350,null,"=IF(J$10=0,,J79)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"E60","v":"Days payable"},null,{"$f":"No_of_Days","v":"# Days"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Days in period",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":366},{"$f":"K$8","v":365},365,365,366,365,365,365,366,365,null,"=J$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J81*J85/J87","v":0},{"$f":"K81*K85/K87","v":0},0,0,0,0,0,0,0,0,null,"=J81*J85/J87"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Control account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I96","v":0},{"$f":"J96","v":0},0,0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=I96"]
[null,null,null,null,{"$f":"D77","v":"Opex"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J81","v":0},{"$f":"K81","v":0},0,200,225,250,275,300,325,350,{"$f":"Income_Statement","v":"IS"},"=J81"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J96-SUM(J93:J94)","v":0},{"$f":"K96-SUM(K93:K94)","v":0},0,-200,-225,-250,-275,-300,-325,-350,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J96-SUM(J93:J94)"]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J89","v":0},{"$f":"K89","v":0},0,0,0,0,0,0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=J89"]

{"sheet":"Income Statement","index":9,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Income Statement"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Income Statement"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(C13),\"\")","v":"=A1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J14),\"\")","v":""}]
[null,null,null,"Revenue",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Operations!J45","v":0},{"$f":"Operations!K45","v":0},{"$f":"Operations!L45","v":0},{"$f":"Operations!M45","v":5500},{"$f":"Operations!N45","v":5551.7},{"$f":"Operations!O45","v":5599.1319999999987},{"$f":"Operations!P45","v":5642.4460399999998},{"$f":"Operations!Q45","v":5681.7878655999993},{"$f":"Operations!R45","v":5717.2990397599988},{"$f":"Operations!S45","v":5749.1170518073577},null,"=Operations!J45"]
[null,null,null,"COGS",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Operations!J69","v":0},{"$f":"-Operations!K69","v":0},{"$f":"-Operations!L69","v":0},{"$f":"-Operations!M69","v":-1100},{"$f":"-Operations!N69","v":-1078},{"$f":"-Operations!O69","v":-1056.4399999999998},{"$f":"-Operations!P69","v":-1035.3111999999999},{"$f":"-Operations!Q69","v":-1014.6049759999999},{"$f":"-Operations!R69","v":-994.31287647999989},{"$f":"-Operations!S69","v":-974.42661895039964},null,"=-Operations!J69"]
[null,null,null,"Gross Profit",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J15:J16)","v":0},{"$f":"SUM(K15:K16)","v":0},0,4400,4473.7,4542.6919999999991,4607.1348399999997,4667.1828895999997,4722.9861632799984,4774.6904328569581,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J17),\"\")","v":"=SUM(J15:J16)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J18),\"\")","v":""}]
[null,null,null,"Operating expenditure",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Operations!J94","v":0},{"$f":"-Operations!K94","v":0},{"$f":"-Operations!L94","v":0},{"$f":"-Operations!M94","v":-200},{"$f":"-Operations!N94","v":-225},{"$f":"-Operations!O94","v":-250},{"$f":"-Operations!P94","v":-275},{"$f":"-Operations!Q94","v":-300},{"$f":"-Operations!R94","v":-325},{"$f":"-Operations!S94","v":-350},null,"=-Operations!J94"]
[null,null,null,"EBITDA",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J17+J19","v":0},{"$f":"K17+K19","v":0},0,4200,4248.7,4292.6919999999991,4332.1348399999997,4367.1828895999997,4397.9861632799984,4424.6904328569581,null,"=J17+J19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Depreciation",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"EBIT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J20+J22","v":0},{"$f":"K20+K22","v":0},0,4200,4248.7,4292.6919999999991,4332.1348399999997,4367.1828895999997,4397.9861632799984,4424.6904328569581,null,"=J20+J22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Interest Expense",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"NPBT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J23+J25","v":0},{"$f":"K23+K25","v":0},0,4200,4248.7,4292.6919999999991,4332.1348399999997,4367.1828895999997,4397.9861632799984,4424.6904328569581,null,"=J23+J25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Tax Expense",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"NPAT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J26+J28","v":0},{"$f":"K26+K28","v":0},0,4200,4248.7,4292.6919999999991,4332.1348399999997,4367.1828895999997,4397.9861632799984,4424.6904328569581,null,"=J26+J28"]

{"sheet":"Opening Balance Sheet","index":10,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Opening Balance Sheet"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Model_Start_Date-1","v":"2023-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"}]
[null,null,{"$f":"Timing!C7","v":"End Date"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"}]
[null,null,{"$f":"Timing!C9","v":"Construction period"}]
[null,null,{"$f":"Timing!C10","v":"Operations period"}]
[null,null,{"$f":"Timing!C11","v":"Counter"}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Opening Balance Sheet"},null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(C13),\"\")","v":"=A1"}]
[]
[null,null,{"$f":"'Balance Sheet'!C15","v":"Current assets"}]
[null,null,null,null,{"$f":"'Balance Sheet'!E16","v":"Opening cash"},null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I16),\"\")","v":""}]
[null,null,null,null,{"$f":"'Balance Sheet'!E17","v":"Net cash flow"},null,"US$'000",null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D18","v":"Cash"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D19","v":"Accounts receivable"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D20","v":"Other current assets"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D21","v":"Total current assets"},null,null,"US$'000",null,{"$f":"SUM(I16:I20)","v":0},null,"=SUM(I16:I20)"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C23","v":"Non-current assets"},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D24","v":"PP&E"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D25","v":"Deferred tax assets"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D26","v":"Total non-current assets"},null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"SUM(I24:I25)","v":0},null,"=SUM(I24:I25)"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C28","v":"Reserve accounts"},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D29","v":"DSRA"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D30","v":"MRA"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D31","v":"Total reserve accounts"},null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"SUM(I29:I30)","v":0},null,"=SUM(I29:I30)"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C33","v":"Total assets"},null,null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I21+I26+I31","v":0},null,"=I21+I26+I31"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C35","v":"Current liabilities"},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D36","v":"Accounts payable"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D37","v":"Dividends payable"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D38","v":"Interest payable"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D39","v":"Tax payable"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D40","v":"Other current liabilities"},null,null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D41","v":"Total current liabilities"},null,null,"US$'000",null,{"$f":"SUM(I36:I40)","v":0},null,"=SUM(I36:I40)"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C43","v":"Non-current liabilities"},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D44","v":"Debt"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D45","v":"Convertible debt"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D46","v":"Working capital facility"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D47","v":"Deferred tax liabilities"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D48","v":"Total non-current liabilities"},null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"SUM(I44:I47)","v":0},null,"=SUM(I44:I47)"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C50","v":"Total liabilities"},null,null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I41+I48","v":0},null,"=I41+I48"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C52","v":"Net assets"},null,null,null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I33-I50","v":0},null,"=I33-I50"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"'Balance Sheet'!C55","v":"Equity"},null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D56","v":"Ordinary equity"},null,null,{"$f":"Currency","v":"US$'000"},null,0,null,""]
[null,null,null,null,{"$f":"'Balance Sheet'!E57","v":"Opening retained profits"},null,"US$'000",null,{"$f":"I52-SUM(I56,I58,I59)","v":0},null,"=I52-SUM(I56,I58,I59)"]
[null,null,null,null,{"$f":"'Balance Sheet'!E58","v":"NPAT"},null,"US$'000",null,0,null,""]
[null,null,null,null,{"$f":"'Balance Sheet'!E59","v":"Dividends declared"},null,"US$'000",null,0,null,""]
[null,null,null,{"$f":"'Balance Sheet'!D60","v":"Retained profits"},null,null,"US$'000",null,{"$f":"SUM(I57:I59)","v":0},null,"=SUM(I57:I59)"]
[null,null,null,{"$f":"'Balance Sheet'!D61","v":"Total equity"},null,null,"US$'000",null,{"$f":"I56+I60","v":0},null,"=I56+I60"]
[]
[]
[null,null,{"$f":"'Balance Sheet'!C64","v":"Checks"},null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I64),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I65),\"\")","v":""}]
[null,null,null,{"$f":"'Balance Sheet'!D66","v":"PF error check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(ISERROR(I52-I61),1,0)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I66),\"\")","v":"=IF(ISERROR(I52-I61),1,0)"}]
[null,null,null,{"$f":"'Balance Sheet'!D67","v":"Balance check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(I66<>0,,(ROUND(I52-I61,Rounding_Accuracy)<>0)*1)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I67),\"\")","v":"=IF(I66<>0,,(ROUND(I52-I61,Rounding_Accuracy)<>0)*1)"}]
[null,null,null,{"$f":"'Balance Sheet'!D68","v":"Insolvency check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(SUM(I66:I67)<>0,,(I52<0)*1)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I68),\"\")","v":"=IF(SUM(I66:I67)<>0,,(I52<0)*1)"}]

{"sheet":"Balance Sheet","index":11,"n_rows":68,"n_cols":21,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Balance Sheet"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Balance Sheet"}]
[]
[null,null,"Current assets"]
[null,null,null,null,"Opening cash",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$11=1,'Opening Balance Sheet'!$I$18,I18)","v":0},{"$f":"IF(K$11=1,'Opening Balance Sheet'!$I$18,J18)","v":4600},{"$f":"IF(L$11=1,'Opening Balance Sheet'!$I$18,K18)","v":12880},{"$f":"IF(M$11=1,'Opening Balance Sheet'!$I$18,L18)","v":0},{"$f":"IF(N$11=1,'Opening Balance Sheet'!$I$18,M18)","v":3567.1232876712329},{"$f":"IF(O$11=1,'Opening Balance Sheet'!$I$18,N18)","v":7803.6672131147534},{"$f":"IF(P$11=1,'Opening Balance Sheet'!$I$18,O18)","v":12081.478794520546},{"$f":"IF(Q$11=1,'Opening Balance Sheet'!$I$18,P18)","v":16401.283677260271},{"$f":"IF(R$11=1,'Opening Balance Sheet'!$I$18,Q18)","v":20756.8937731726},{"$f":"IF(S$11=1,'Opening Balance Sheet'!$I$18,R18)","v":25145.936921561963},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J16),\"\")","v":"=IF(J$11=1,'Opening Balance Sheet'!$I$18,I18)"}]
[null,null,null,null,"Net cash flow",null,"US$'000",null,null,{"$f":"'Cash Flow Statement'!J51","v":4600},{"$f":"'Cash Flow Statement'!K51","v":8280},{"$f":"'Cash Flow Statement'!L51","v":-12880},{"$f":"'Cash Flow Statement'!M51","v":3567.1232876712329},{"$f":"'Cash Flow Statement'!N51","v":4236.5439254435205},{"$f":"'Cash Flow Statement'!O51","v":4277.8115814057937},{"$f":"'Cash Flow Statement'!P51","v":4319.8048827397251},{"$f":"'Cash Flow Statement'!Q51","v":4355.6100959123287},{"$f":"'Cash Flow Statement'!R51","v":4389.0431483893626},{"$f":"'Cash Flow Statement'!S51","v":4412.6586441670306},null,"='Cash Flow Statement'!J51"]
[null,null,null,"Cash",null,null,"US$'000",null,null,{"$f":"SUM(J16:J17)","v":4600},{"$f":"SUM(K16:K17)","v":12880},0,3567.1232876712329,7803.6672131147534,12081.478794520546,16401.283677260271,20756.8937731726,25145.936921561963,29558.595565728992,null,"=SUM(J16:J17)"]
[null,null,null,"Accounts receivable",null,null,"US$'000",null,null,{"$f":"Operations!J47","v":0},{"$f":"Operations!K47","v":0},{"$f":"Operations!L47","v":0},{"$f":"Operations!M47","v":904.10958904109589},{"$f":"Operations!N47","v":910.11475409836066},{"$f":"Operations!O47","v":920.40526027397243},{"$f":"Operations!P47","v":927.52537643835615},{"$f":"Operations!Q47","v":933.99252585205477},{"$f":"Operations!R47","v":937.26213766557362},{"$f":"Operations!S47","v":945.06033728340117},null,"=Operations!J47"]
[null,null,null,"Other current assets",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Total current assets",null,null,"US$'000",null,null,{"$f":"SUM(J18:J20)","v":4600},{"$f":"SUM(K18:K20)","v":12880},0,4471.232876712329,8713.7819672131136,13001.884054794518,17328.809053698627,21690.886299024656,26083.199059227536,30503.655903012394,null,"=SUM(J18:J20)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Non-current assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"PP&E",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Deferred tax assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Total non-current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J24:J25)","v":0},{"$f":"SUM(K24:K25)","v":0},0,0,0,0,0,0,0,0,null,"=SUM(J24:J25)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Reserve accounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"DSRA",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"MRA",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Total reserve accounts",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J29:J30)","v":0},0,0,0,0,0,0,0,0,0,null,"=SUM(J29:J30)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Total assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J21+J26+J31","v":4600},12880,0,4471.232876712329,8713.7819672131136,13001.884054794518,17328.809053698627,21690.886299024656,26083.199059227536,30503.655903012394,null,"=J21+J26+J31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Current liabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Accounts payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Operations!J71+Operations!J96","v":0},{"$f":"Operations!K71+Operations!K96","v":0},{"$f":"Operations!L71+Operations!L96","v":0},{"$f":"Operations!M71+Operations!M96","v":271.23287671232879},{"$f":"Operations!N71+Operations!N96","v":265.08196721311475},{"$f":"Operations!O71+Operations!O96","v":260.49205479452053},{"$f":"Operations!P71+Operations!P96","v":255.2822136986301},{"$f":"Operations!Q71+Operations!Q96","v":250.17656942465752},{"$f":"Operations!R71+Operations!R96","v":244.50316634754094},{"$f":"Operations!S71+Operations!S96","v":240.26957727544101},null,"=Operations!J71+Operations!J96"]
[null,null,null,"Dividends payable",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Interest payable",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Tax payable",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Other current liabilities",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Total current liabilities",null,null,"US$'000",null,null,{"$f":"SUM(J36:J40)","v":0},{"$f":"SUM(K36:K40)","v":0},0,271.23287671232879,265.08196721311475,260.49205479452053,255.2822136986301,250.17656942465752,244.50316634754094,240.26957727544101,null,"=SUM(J36:J40)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Non-current liabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Debt",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Construction!J68","v":0},{"$f":"Construction!K68","v":6880},{"$f":"Construction!L68","v":0},{"$f":"Construction!M68","v":0},{"$f":"Construction!N68","v":0},{"$f":"Construction!O68","v":0},{"$f":"Construction!P68","v":0},{"$f":"Construction!Q68","v":0},{"$f":"Construction!R68","v":0},{"$f":"Construction!S68","v":0},null,"=Construction!J68"]
[null,null,null,"Convertible debt",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Construction!J102","v":0},{"$f":"Construction!K102","v":0},{"$f":"Construction!L102","v":0},{"$f":"Construction!M102","v":0},{"$f":"Construction!N102","v":0},{"$f":"Construction!O102","v":0},{"$f":"Construction!P102","v":0},{"$f":"Construction!Q102","v":0},{"$f":"Construction!R102","v":0},{"$f":"Construction!S102","v":0},null,"=Construction!J102"]
[null,null,null,"Working capital facility",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Deferred tax liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Total non-current liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J44:J47)","v":0},{"$f":"SUM(K44:K47)","v":6880},0,0,0,0,0,0,0,0,null,"=SUM(J44:J47)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Total liabilities",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J41+J48","v":0},{"$f":"K41+K48","v":6880},0,271.23287671232879,265.08196721311475,260.49205479452053,255.2822136986301,250.17656942465752,244.50316634754094,240.26957727544101,null,"=J41+J48"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Net assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J33-J50","v":4600},{"$f":"K33-K50","v":6000},0,4200,8448.6999999999989,12741.391999999998,17073.526839999999,21440.709729599999,25838.695892879994,30263.386325736952,null,"=J33-J50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Equity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Ordinary equity",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Construction!J54","v":4600},{"$f":"Construction!K54","v":6000},{"$f":"Construction!L54","v":0},{"$f":"Construction!M54","v":0},{"$f":"Construction!N54","v":0},{"$f":"Construction!O54","v":0},{"$f":"Construction!P54","v":0},{"$f":"Construction!Q54","v":0},{"$f":"Construction!R54","v":0},{"$f":"Construction!S54","v":0},null,"=Construction!J54"]
[null,null,null,null,"Opening retained profits",null,"US$'000",null,null,{"$f":"IF(J$11=1,'Opening Balance Sheet'!$I$60,I60)","v":0},{"$f":"IF(K$11=1,'Opening Balance Sheet'!$I$60,J60)","v":0},{"$f":"IF(L$11=1,'Opening Balance Sheet'!$I$60,K60)","v":0},{"$f":"IF(M$11=1,'Opening Balance Sheet'!$I$60,L60)","v":0},{"$f":"IF(N$11=1,'Opening Balance Sheet'!$I$60,M60)","v":4200},{"$f":"IF(O$11=1,'Opening Balance Sheet'!$I$60,N60)","v":8448.7000000000007},{"$f":"IF(P$11=1,'Opening Balance Sheet'!$I$60,O60)","v":12741.392},{"$f":"IF(Q$11=1,'Opening Balance Sheet'!$I$60,P60)","v":17073.526839999999},{"$f":"IF(R$11=1,'Opening Balance Sheet'!$I$60,Q60)","v":21440.709729599999},{"$f":"IF(S$11=1,'Opening Balance Sheet'!$I$60,R60)","v":25838.695892879998},null,"=IF(J$11=1,'Opening Balance Sheet'!$I$60,I60)"]
[null,null,null,null,"NPAT",null,"US$'000",null,null,{"$f":"'Income Statement'!J29","v":0},{"$f":"'Income Statement'!K29","v":0},{"$f":"'Income Statement'!L29","v":0},{"$f":"'Income Statement'!M29","v":4200},{"$f":"'Income Statement'!N29","v":4248.7},{"$f":"'Income Statement'!O29","v":4292.6919999999991},{"$f":"'Income Statement'!P29","v":4332.1348399999997},{"$f":"'Income Statement'!Q29","v":4367.1828895999997},{"$f":"'Income Statement'!R29","v":4397.9861632799984},{"$f":"'Income Statement'!S29","v":4424.6904328569581},null,"='Income Statement'!J29"]
["w",null,null,null,"Dividends declared",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Retained profits",null,null,"US$'000",null,null,{"$f":"SUM(J57:J59)","v":0},{"$f":"SUM(K57:K59)","v":0},0,4200,8448.7000000000007,12741.392,17073.526839999999,21440.709729599999,25838.695892879998,30263.386325736956,null,"=SUM(J57:J59)"]
[null,null,null,"Total equity",null,null,"US$'000",null,null,{"$f":"J56+J60","v":4600},6000,0,4200,8448.7000000000007,12741.392,17073.526839999999,21440.709729599999,25838.695892879998,30263.386325736956,null,"=J56+J60"]
[]
[]
[null,null,"Checks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J64),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"PF error check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MAX(J66:S66)","v":0},{"$f":"IF(ISERROR(J52-J61),1,0)","v":0},{"$f":"IF(ISERROR(K52-K61),1,0)","v":0},0,0,0,0,0,0,0,0,null,"=IF(ISERROR(J52-J61),1,0)"]
[null,null,null,"Balance check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MAX(J67:S67)","v":0},{"$f":"IF(J66<>0,,(ROUND(J52-J61,Rounding_Accuracy)<>0)*1)","v":0},0,0,0,0,0,0,0,0,0,null,"=IF(J66<>0,,(ROUND(J52-J61,Rounding_Accuracy)<>0)*1)"]
[null,null,null,"Insolvency check",null,null,{"$f":"Boolean","v":"[1,0]"},null,0,{"$f":"IF(SUM(J66:J67)<>0,,(J52<0)*1)","v":0},{"$f":"IF(SUM(K66:K67)<>0,,(K52<0)*1)","v":0},0,0,0,0,0,0,0,0,null,"=IF(SUM(J66:J67)<>0,,(J52<0)*1)"]

{"sheet":"Cash Flow Statement","index":12,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Cash Flow Statement"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2024-06-30"},{"$f":"Timing!K5","v":"2025-06-30"},{"$f":"Timing!L5","v":"2026-06-30"},{"$f":"Timing!M5","v":"2027-06-30"},{"$f":"Timing!N5","v":"2028-06-30"},{"$f":"Timing!O5","v":"2029-06-30"},{"$f":"Timing!P5","v":"2030-06-30"},{"$f":"Timing!Q5","v":"2031-06-30"},{"$f":"Timing!R5","v":"2032-06-30"},{"$f":"Timing!S5","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2023-07-01"},{"$f":"Timing!K6","v":"2024-07-01"},{"$f":"Timing!L6","v":"2025-07-01"},{"$f":"Timing!M6","v":"2026-07-01"},{"$f":"Timing!N6","v":"2027-07-01"},{"$f":"Timing!O6","v":"2028-07-01"},{"$f":"Timing!P6","v":"2029-07-01"},{"$f":"Timing!Q6","v":"2030-07-01"},{"$f":"Timing!R6","v":"2031-07-01"},{"$f":"Timing!S6","v":"2032-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2024-06-30"},{"$f":"Timing!K7","v":"2025-06-30"},{"$f":"Timing!L7","v":"2026-06-30"},{"$f":"Timing!M7","v":"2027-06-30"},{"$f":"Timing!N7","v":"2028-06-30"},{"$f":"Timing!O7","v":"2029-06-30"},{"$f":"Timing!P7","v":"2030-06-30"},{"$f":"Timing!Q7","v":"2031-06-30"},{"$f":"Timing!R7","v":"2032-06-30"},{"$f":"Timing!S7","v":"2033-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":366},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":365},{"$f":"Timing!N8","v":366},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":365},{"$f":"Timing!R8","v":366},{"$f":"Timing!S8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Construction period"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":0},{"$f":"Timing!N9","v":0},{"$f":"Timing!O9","v":0},{"$f":"Timing!P9","v":0},{"$f":"Timing!Q9","v":0},{"$f":"Timing!R9","v":0},{"$f":"Timing!S9","v":0}]
[null,null,{"$f":"Timing!C10","v":"Operations period"},null,null,null,null,null,null,{"$f":"Timing!J10","v":0},{"$f":"Timing!K10","v":0},{"$f":"Timing!L10","v":0},{"$f":"Timing!M10","v":1},{"$f":"Timing!N10","v":2},{"$f":"Timing!O10","v":3},{"$f":"Timing!P10","v":4},{"$f":"Timing!Q10","v":5},{"$f":"Timing!R10","v":6},{"$f":"Timing!S10","v":7}]
[null,null,{"$f":"Timing!C11","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J11","v":1},{"$f":"Timing!K11","v":2},{"$f":"Timing!L11","v":3},{"$f":"Timing!M11","v":4},{"$f":"Timing!N11","v":5},{"$f":"Timing!O11","v":6},{"$f":"Timing!P11","v":7},{"$f":"Timing!Q11","v":8},{"$f":"Timing!R11","v":9},{"$f":"Timing!S11","v":10}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},{"$f":"A1","v":"Cash Flow Statement"}]
[]
[null,null,"Direct Cash Flow Statement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J15),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Operating cash flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Cash receipts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Operations!J46","v":0},{"$f":"-Operations!K46","v":0},{"$f":"-Operations!L46","v":0},{"$f":"-Operations!M46","v":4595.8904109589039},{"$f":"-Operations!N46","v":5545.6948349427348},{"$f":"-Operations!O46","v":5588.8414938243877},{"$f":"-Operations!P46","v":5635.3259238356159},{"$f":"-Operations!Q46","v":5675.3207161863011},{"$f":"-Operations!R46","v":5714.0294279464797},{"$f":"-Operations!S46","v":5741.3188521895299},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J18),\"\")","v":"=-Operations!J46"}]
[null,null,null,null,null,"Direct cash payments","US$'000",null,null,{"$f":"Operations!J70","v":0},{"$f":"Operations!K70","v":0},{"$f":"Operations!L70","v":0},{"$f":"Operations!M70","v":-828.76712328767121},{"$f":"Operations!N70","v":-1084.1509094992141},{"$f":"Operations!O70","v":-1061.029912418594},{"$f":"Operations!P70","v":-1040.5210410958903},{"$f":"Operations!Q70","v":-1019.7106202739725},{"$f":"Operations!R70","v":-999.98627955711652},{"$f":"Operations!S70","v":-978.66020802249955},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":"=Operations!J70"}]
[null,null,null,null,null,"Indirect cash payments","US$'000",null,null,{"$f":"Operations!J95","v":0},{"$f":"Operations!K95","v":0},{"$f":"Operations!L95","v":0},{"$f":"Operations!M95","v":-200},{"$f":"Operations!N95","v":-225},{"$f":"Operations!O95","v":-250},{"$f":"Operations!P95","v":-275},{"$f":"Operations!Q95","v":-300},{"$f":"Operations!R95","v":-325},{"$f":"Operations!S95","v":-350},null,"=Operations!J95"]
[null,null,null,null,"Cash payments",null,"US$'000",null,null,{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},0,-1028.7671232876712,-1309.1509094992141,-1311.029912418594,-1315.5210410958903,-1319.7106202739724,-1324.9862795571166,-1328.6602080224995,null,"=SUM(J19:J20)"]
[null,null,null,null,"Interest paid",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Tax paid",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Net Operating cash flow",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J18,J21:J23)","v":0},{"$f":"SUM(K18,K21:K23)","v":0},0,3567.1232876712329,4236.5439254435205,4277.8115814057937,4319.8048827397251,4355.6100959123287,4389.0431483893626,4412.6586441670306,null,"=SUM(J18,J21:J23)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Investing cash flows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Interest received ",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Purchases of Non-Current Assets",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Net Investing cash flows",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J27:J28)","v":0},{"$f":"SUM(K27:K28)","v":0},0,0,0,0,0,0,0,0,null,"=SUM(J27:J28)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Financing cash flows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Transfer to MRA",{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Transfer from MRA","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Initial transfer to DSRA","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Transfer to DSRA","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Transfer from DSRA (Cashflow)","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Transfer from DSRA (Target)","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Reserve account movement",null,"US$'000",null,null,{"$f":"SUM(J32:J37)","v":0},0,0,0,0,0,0,0,0,0,null,"=SUM(J32:J37)"]
[null,null,null,null,"Working capital facility drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Working capital facility repayments",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Debt drawdowns",null,"US$'000",null,null,{"$f":"Construction!J66","v":0},{"$f":"Construction!K66","v":6880},{"$f":"Construction!L66","v":9120},{"$f":"Construction!M66","v":0},{"$f":"Construction!N66","v":0},{"$f":"Construction!O66","v":0},{"$f":"Construction!P66","v":0},{"$f":"Construction!Q66","v":0},{"$f":"Construction!R66","v":0},{"$f":"Construction!S66","v":0},null,"=Construction!J66"]
[null,null,null,null,"Debt repayments",null,"US$'000",null,null,{"$f":"Construction!J67","v":0},{"$f":"Construction!K67","v":0},{"$f":"Construction!L67","v":-16000},{"$f":"Construction!M67","v":0},{"$f":"Construction!N67","v":0},{"$f":"Construction!O67","v":0},{"$f":"Construction!P67","v":0},{"$f":"Construction!Q67","v":0},{"$f":"Construction!R67","v":0},{"$f":"Construction!S67","v":0},null,"=Construction!J67"]
[null,null,null,null,"Cash sweep repayments",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Convertible debt drawdowns",null,"US$'000",null,null,{"$f":"Construction!J100","v":0},{"$f":"Construction!K100","v":0},{"$f":"Construction!L100","v":8801.0400000000009},{"$f":"Construction!M100","v":0},{"$f":"Construction!N100","v":0},{"$f":"Construction!O100","v":0},{"$f":"Construction!P100","v":0},{"$f":"Construction!Q100","v":0},{"$f":"Construction!R100","v":0},{"$f":"Construction!S100","v":0},null,"=Construction!J100"]
[null,null,null,null,"Convertible debt interest paid",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J45),\"\")","v":""}]
[null,null,null,null,"Convertible debt repayments",null,"US$'000",null,null,{"$f":"Construction!J101","v":0},{"$f":"Construction!K101","v":0},{"$f":"Construction!L101","v":-8801.0400000000009},{"$f":"Construction!M101","v":0},{"$f":"Construction!N101","v":0},{"$f":"Construction!O101","v":0},{"$f":"Construction!P101","v":0},{"$f":"Construction!Q101","v":0},{"$f":"Construction!R101","v":0},{"$f":"Construction!S101","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J46),\"\")","v":"=Construction!J101"}]
[null,null,null,null,"Ordinary equity issuances",null,"US$'000",null,null,{"$f":"SUM(Construction!J52:J53)","v":4600},{"$f":"SUM(Construction!K52:K53)","v":1400},{"$f":"SUM(Construction!L52:L53)","v":-6000},{"$f":"SUM(Construction!M52:M53)","v":0},{"$f":"SUM(Construction!N52:N53)","v":0},{"$f":"SUM(Construction!O52:O53)","v":0},{"$f":"SUM(Construction!P52:P53)","v":0},{"$f":"SUM(Construction!Q52:Q53)","v":0},{"$f":"SUM(Construction!R52:R53)","v":0},{"$f":"SUM(Construction!S52:S53)","v":0},null,"=SUM(Construction!J52:J53)"]
[null,null,null,null,"Dividends paid",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Net Financing cash flows",null,"US$'000",null,null,{"$f":"SUM(J38:J48)","v":4600},8280,-12880,0,0,0,0,0,0,0,null,"=SUM(J38:J48)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Net increase / (decrease) in cash held",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J24+J29+J49","v":4600},8280,-12880,3567.1232876712329,4236.5439254435205,4277.8115814057937,4319.8048827397251,4355.6100959123287,4389.0431483893626,4412.6586441670306,null,"=J24+J29+J49"]

{"sheet":"Lookup","index":13,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Lookup"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1&\" Assumptions\"","v":"Lookup Assumptions"}]
[]
[null,null,"Year Lookups"]
[]
[null,null,null,"LU_Future_Years",null,"LU_Future_Years"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C11))","v":"2025-06-30"},null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(D11),\"\")","v":"=OFFSET(Timing!$J$7,,ROWS($C$11:$C11))"}]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C12))","v":"2026-06-30"},null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(D12),\"\")","v":"=OFFSET(Timing!$J$7,,ROWS($C$11:$C12))"}]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C13))","v":"2027-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C13))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C14))","v":"2028-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C14))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C15))","v":"2029-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C15))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C16))","v":"2030-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C16))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C17))","v":"2031-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C17))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C18))","v":"2032-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C18))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($C$11:$C19))","v":"2033-06-30"},null,null,"=OFFSET(Timing!$J$7,,ROWS($C$11:$C19))"]
[null,null,null,"Actuals Throughout",null,"Actuals_Throughout"]
[]
[]
[null,null,"Debt lookups"]
[]
[null,null,null,"LU_Repayment",null,"LU_Repayment"]
[null,null,null,"Annuity",null,"Annuity"]
[null,null,null,"DSCR Sculpted",null,"DSCR_Sculpted"]
[]
[]
[null,null,"Generation profile lookups"]
[]
[null,null,null,"LU_Gen_Profiles",null,"LU_Gen_Profiles"]
[null,null,null,"P10"]
[null,null,null,"P50"]
[null,null,null,"P90"]
[]
[]
[null,null,"Timing of Discount Rates"]
[]
[null,null,null,"LU_Timing",null,"LU_Timing"]
[null,null,null,"Start",null,"Start"]
[null,null,null,"Middle",null,"Middle"]
[null,null,null,"End",null,"End"]
[]
[]
[null,null,"Yes or No"]
[]
[null,null,null,"LU_Yes_or_No",null,"LU_Yes_or_No"]
[null,null,null,"Yes",null,"Yes"]
[null,null,null,"No",null,"No"]

{"sheet":"Error Checks","index":14,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Balance Sheet has no errors",null,null,null,{"$f":"HL_BS_Errors","v":0}]
[null,null,null,null,"Balance Sheet balances",null,null,null,{"$f":"HL_BS_Balance","v":0}]
[null,null,null,null,"Insolvency Check for Balance Sheet",null,null,null,{"$f":"HL_BS_Insolvency","v":0}]
[null,null,null,null,"Opening Balance Sheet has no errors",null,null,null,{"$f":"HL_Op_BS_Errors","v":0}]
[null,null,null,null,"Opening Balance Sheet balances",null,null,null,{"$f":"HL_Op_BS_Balance","v":0}]
[null,null,null,null,"Insolvency Check for Opening Balance Sheet",null,null,null,{"$f":"HL_Op_BS_Insolvency","v":0}]
[null,null,null,null,"Cash Flow Statement has no errors"]
[null,null,null,null,"Cash Flow Statement reconciles"]
[null,null,null,null,"Cash Flow Waterfall reconciles"]
[null,null,null,null,"Construction sources and uses of funds reconciles"]
[null,null,null,null,"Operations sources and uses of funds reconciles"]
[null,null,null,null,"DSRA balance is met"]
[null,null,null,null,"DSRA is solved"]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]

{"sheet":"Change Log","index":15,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Change Log"}]
[{"$f":"Model_Name","v":"Model 08 - Opex Completed.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Change Log"}]
[]
[null,null,"Summary"]
[]
[null,null,null,null,null,"Date","Model Version ","Details of change","Worksheet Reference","Row, column, cell reference","Author"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","I changed it","Change Log","F11","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","So did I.","Timing","A4","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","And me.","Navigator","B9","Dave"]