{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Operations","Income Statement","Opening Balance Sheet","Balance Sheet","Cash Flow Statement","Error Checks","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":57,"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 03 - Financial Statements Added.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":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"Model 03 - Financial Statements Added.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,"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,"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":[[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],[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],[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],[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],[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],[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]]}
[{"$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 03 - Financial Statements Added.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 03 - Financial Statements Added.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 03 - Financial Statements Added.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 03 - Financial Statements Added.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":"Operations","index":5,"n_rows":15,"n_cols":19,"rows_kept":15,"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 03 - Financial Statements Added.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,"Data (do not change once modelling has commenced)"]

{"sheet":"Income Statement","index":6,"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 03 - Financial Statements Added.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,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"COGS",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"EBITDA",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J17+J19","v":0},{"$f":"K17+K19","v":0},0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,null,"=J26+J28"]

{"sheet":"Opening Balance Sheet","index":7,"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 03 - Financial Statements Added.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":8,"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 03 - Financial Statements Added.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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J16),\"\")","v":""}]
[null,null,null,null,"Net cash flow",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Cash",null,null,"US$'000",null,null,{"$f":"SUM(J16:J17)","v":0},{"$f":"SUM(K16:K17)","v":0},0,0,0,0,0,0,0,0,null,"=SUM(J16:J17)"]
[null,null,null,"Accounts receivable",null,null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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":0},{"$f":"SUM(K18:K20)","v":0},0,0,0,0,0,0,0,0,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":0},0,0,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,""]
[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,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Convertible debt",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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":0},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":0},0,0,0,0,0,0,0,0,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":0},{"$f":"K33-K50","v":0},0,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Opening retained profits",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"NPAT",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,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,0,0,0,0,0,0,0,null,"=SUM(J57:J59)"]
[null,null,null,"Total equity",null,null,"US$'000",null,null,{"$f":"J56+J60","v":0},0,0,0,0,0,0,0,0,0,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":9,"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 03 - Financial Statements Added.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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J18),\"\")","v":""}]
[null,null,null,null,null,"Direct cash payments","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":""}]
[null,null,null,null,null,"Indirect cash payments","US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Cash payments",null,"US$'000",null,null,{"$f":"SUM(J19:J20)","v":0},{"$f":"SUM(K19:K20)","v":0},0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Debt repayments",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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,null,null,null,null,null,null,null,null,null,null,null,""]
[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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J46),\"\")","v":""}]
[null,null,null,null,"Ordinary equity issuances",null,"US$'000",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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":0},0,0,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":0},0,0,0,0,0,0,0,0,0,null,"=J24+J29+J49"]

{"sheet":"Error Checks","index":10,"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 03 - Financial Statements Added.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":11,"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 03 - Financial Statements Added.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"]