{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Navigator","Style Guide","Model Parameters","General Assumptions","Calculations","Opening Balance Sheet","Income Statement","Balance Sheet","Cash Flow Statement","Timing","Lookup","Template Sheet","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":333,"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":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"Model 10 - Capital Expenditure Completed.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple financial model to demonstrate dynamic arrays."]
[]
[]
[]
[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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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,"General Assumptions"]
[null,null,null,null,null,"Calculations"]
[null,null,null,null,null,"Opening Balance Sheet"]
[null,null,null,null,null,"Income Statement"]
[null,null,null,null,null,"Balance Sheet"]
[null,null,null,null,null,"Cash Flow Statement"]
[null,null,null,null,null,"Timing"]
[null,null,null,null,null,"Lookup"]
[null,null,null,null,null,"Template Sheet"]
[null,null,null,null,null,"Error Checks"]

{"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 10 - Capital Expenditure 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-02-02"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-02"},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":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[11,6,11,13],[12,6,12,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 10 - Capital Expenditure 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,"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 10 - Capital Expenditure Completed.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Limited"]
[]
[]
[null,{"$f":"MAX($B$5:$B15)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]
[]
[]
[null,{"$f":"MAX($B$5:$B34)+1","v":3},"Technical assumptions"]
[]
[null,null,"Model information"]
[]
[null,null,null,null,"Start date",null,{"$f":"Model_Start_Date","v":"2024-07-01"}]
[]
[]
[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,"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"]

{"sheet":"General Assumptions","index":4,"n_rows":75,"n_cols":29,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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":"General Assumptions"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(Timing!J5)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J6)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J7)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J9)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"General Assumptions"}]
[]
[null,null,"Revenue and related"]
[]
[null,null,null,"Sales"]
[]
[null,null,null,null,"Projected sales",null,{"$f":"Unit","v":"#"},null,null,{"$f":"_xlfn.ANCHORARRAY(J$9)*100","v":100},200,300,400,500,600,700,800,900,1000,1100,1200,1300]
[null,null,null,null,"Unit price",null,{"$f":"Currency","v":"US$'000"},null,null,15]
[null,null,null,null,"Inflation",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9)=1,,IF((_xlfn.ANCHORARRAY(J$9)+1)/100<6%,(_xlfn.ANCHORARRAY(J$9)+1)/100,6%))","v":0},0.03,0.04,0.05,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06]
[]
[null,null,null,"Working capital"]
[]
[null,null,null,null,"Days receivable",null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),60,)","v":60},60,60,60,60,60,60,60,60,60,60,60,60]
[]
[]
[null,null,"COGS and related"]
[]
[null,null,null,"COGS"]
[]
[null,null,null,null,"Gross margin (non-inventory)",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),70%,)","v":0.7},0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7]
[]
[null,null,null,"Working capital"]
[]
[null,null,null,null,"Days payable",null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),90,)","v":90},90,90,90,90,90,90,90,90,90,90,90,90]
[]
[]
[null,null,"Purchases and related"]
[]
[null,null,null,"Purchases"]
[]
[null,null,null,null,"Purchases",null,{"$f":"Weight","v":"kg"},null,null,400,775,325,550,1000,1210,1420,1630,1840,2050,2260,2470,2680,2890,3100,3310,3530,3750,4000,4000]
[null,null,null,null,"Price",null,{"$f":"Price_Weight","v":"$/kg"},null,null,{"$f":"_xlfn.TAKE(IF(_xlfn.ANCHORARRAY(J$9),{3990,4750,2800,4160,5000,4569,4712,4855,4998,5141,5284,5427,5570,5713,5856,5999,6142,6285,6428,6571},),,Number_of_Periods)","v":3990},4750,2800,4160,5000,4569,4712,4855,4998,5141,5284,5427,5570]
[null,null,null,null,"Amount used per sale",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),2,)","v":2},2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"Wastage",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9)=1,3%,IF(_xlfn.ANCHORARRAY(J$9)<4,2%,1%))","v":0.03},0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,null,null,null,null,null,null,{"$f":"Model_Start_Date-1","v":"2024-06-30"}]
[null,null,null,null,"Opening inventory balance",null,{"$f":"Weight","v":"kg"},null,13]
[]
[null,null,null,"Working capital"]
[]
[null,null,null,null,"Days payable",null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),30,)","v":30},30,30,30,30,30,30,30,30,30,30,30,30]
[]
[]
[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,"Growth rates used from ",null,{"$f":"Year","v":"Year"},null,"2027-06-30"]
[null,null,null,null,"Amounts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),55+_xlfn.ANCHORARRAY(J$9)*5,)","v":60},65,70,75,80,85,90,95,100,105,110,115,120]
[null,null,null,null,"Growth rates",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9)=1,,IF((7-_xlfn.ANCHORARRAY(J$9))/100>1%,(7-_xlfn.ANCHORARRAY(J$9))/100,1%))","v":0},0.05,0.04,0.03,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[]
[null,null,"Capex and related"]
[]
[null,null,null,"Capital expenditure"]
[]
[null,null,null,null,"Capital expenditure",null,{"$f":"Currency","v":"US$'000"},null,null,150,180,120,90,100,150,180,120,90,100,150,180,120,90,100,150,180,120,90,100]
[]
[null,null,null,"Accounting depreciation - straight line"]
[]
[null,null,null,null,"Remaining life of existing assets",null,{"$f":"No_of_Years","v":"# Year(s)"},null,5]
[null,null,null,null,"Annual rate",null,{"$f":"Percentage","v":"%"},null,{"$f":"IF(I71=0,,1/I71)","v":0.2}]
[]
[null,null,null,null,"Economic life of new capex",null,{"$f":"No_of_Years","v":"# Year(s)"},null,4]
[null,null,null,null,"Annual rate",null,{"$f":"Percentage","v":"%"},null,{"$f":"IF(I74=0,,1/I74)","v":0.25}]

{"sheet":"Calculations","index":5,"n_rows":202,"n_cols":31,"rows_kept":202,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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":"Calculations"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(Timing!J5)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J6)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J7)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J9)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Calculations"}]
[]
[null,null,{"$f":"'General Assumptions'!C13","v":"Revenue and related"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J14),\"\")","v":""}]
[null,null,null,{"$f":"'General Assumptions'!D15","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,{"$f":"'General Assumptions'!E17","v":"Projected sales"},null,{"$f":"Unit","v":"#"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J17)","v":100},200,300,400,500,600,700,800,900,1000,1100,1200,1300,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J17),\"\")","v":"='General Assumptions'!J17#"}]
[null,null,null,null,{"$f":"'General Assumptions'!E18","v":"Unit price"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J18","v":15},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":"='General Assumptions'!J18"}]
[null,null,null,null,{"$f":"'General Assumptions'!E19","v":"Inflation"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY('General Assumptions'!J19)=\"\",\"\",_xlfn.ANCHORARRAY('General Assumptions'!J19))","v":0},0.03,0.04,0.05,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J19),\"\")","v":"=IF('General Assumptions'!J19#=\"\",\"\",'General Assumptions'!J19#)"}]
[null,null,null,null,null,null,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(J20),\"\")","v":""}]
[null,null,null,null,"Price per unit",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.SCAN(J18,_xlfn.ANCHORARRAY(J19),_xlfn.LAMBDA(_xlpm.accumulator,_xlpm.percentage,_xlpm.accumulator*(1+_xlpm.percentage)))","v":15},15.450000000000001,16.068000000000001,16.871400000000001,17.883684000000002,18.956705040000003,20.094107342400005,21.299753782944006,22.577739009920649,23.932403350515887,25.36834755154684,26.890448404639653,28.503875308918033,null,null,null,null,null,null,null,null,"=SCAN(J18,J19#,LAMBDA(accumulator,percentage,accumulator*(1+percentage)))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J17)*_xlfn.ANCHORARRAY(J21)","v":1500},3090,4820.4000000000005,6748.56,8941.8420000000006,11374.023024000002,14065.875139680003,17039.803026355203,20319.965108928584,23932.403350515888,27905.182306701525,32268.538085567583,37055.037901593445,null,null,null,null,null,null,null,null,"=J17#*J21#"]
[null,null,null,null,null,null,null,null,null,null,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,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":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J23)","v":60},60,60,60,60,60,60,60,60,60,60,60,60,null,null,null,null,null,null,null,null,"='General Assumptions'!J23#"]
[null,null,null,null,null,null,null,null,null,null,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":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY(J$8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,null,"Closing receivables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J23)*_xlfn.ANCHORARRAY(J27)/_xlfn.ANCHORARRAY(J29)","v":246.57534246575344},507.94520547945206,792.39452054794538,1106.3213114754099,1469.8918356164384,1869.7024149041099,2312.198653098083,2793.4103321893776,3340.2682370841508,3934.0937014546666,4587.1532558961408,5289.9242763225548,6091.2391071112506,null,null,null,null,null,null,null,null,"=J23#*J27#/J29#"]
[null,null,null,null,null,null,null,null,null,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,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":"OFFSET(_xlfn.ANCHORARRAY(J38),,-1)","v":0},246.57534246575344,507.94520547945206,792.39452054794538,1106.3213114754099,1469.8918356164384,1869.7024149041099,2312.198653098083,2793.4103321893776,3340.2682370841508,3934.0937014546666,4587.1532558961408,5289.9242763225548,null,null,null,null,null,null,null,"BS","=OFFSET(J38#,,-1)"]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J23)","v":1500},3090,4820.4000000000005,6748.56,8941.8420000000006,11374.023024000002,14065.875139680003,17039.803026355203,20319.965108928584,23932.403350515888,27905.182306701525,32268.538085567583,37055.037901593445,null,null,null,null,null,null,null,"IS","=J23#"]
[null,null,null,null,"Cash receipts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J38)-_xlfn.ANCHORARRAY(J35)-_xlfn.ANCHORARRAY(J36)","v":-1253.4246575342465},-2828.6301369863013,-4535.9506849315076,-6434.6332090725355,-8578.2714758589718,-10974.21244471233,-13623.37890148603,-16558.591347263908,-19773.107204033811,-23338.577886145373,-27252.122752260049,-31565.767065141168,-36253.72307080475,null,null,null,null,null,null,null,"CFS","=J38#-J35#-J36#"]
[null,null,null,null,"Closing receivables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$15","v":0},{"$f":"_xlfn.ANCHORARRAY(J31)","v":246.57534246575344},507.94520547945206,792.39452054794538,1106.3213114754099,1469.8918356164384,1869.7024149041099,2312.198653098083,2793.4103321893776,3340.2682370841508,3934.0937014546666,4587.1532558961408,5289.9242763225548,6091.2391071112506,null,null,null,null,null,null,null,"BS","=J31#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},{"$f":"\"Row \"&ROW(J23)","v":"Row 23"},null,{"$f":"_xlfn.ANCHORARRAY(J23)","v":1500},3090,4820.4000000000005,6748.56,8941.8420000000006,11374.023024000002,14065.875139680003,17039.803026355203,20319.965108928584,23932.403350515888,27905.182306701525,32268.538085567583,37055.037901593445,null,null,null,null,null,null,null,null,"=J23#"]
[null,null,null,null,"Gross margin (non-inventory)",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J30)","v":0.7},0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,null,null,null,null,null,null,null,null,"='General Assumptions'!J30#"]
[null,null,null,null,"Gross profit (non-inventory)",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J45)*_xlfn.ANCHORARRAY(J46)","v":1050},2163,3374.28,4723.9920000000002,6259.2893999999997,7961.8161168000006,9846.1125977760021,11927.862118448642,14223.975576250008,16752.682345361121,19533.627614691068,22587.976659897307,25938.526531115411,null,null,null,null,null,null,null,null,"=J45#*J46#"]
[null,null,null,null,null,null,null,null,null,null,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,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J45)-_xlfn.ANCHORARRAY(J47)","v":450},927,1446.1200000000003,2024.5680000000002,2682.5526000000009,3412.2069072000013,4219.7625419040014,5111.9409079065608,6095.9895326785754,7179.7210051547663,8371.5546920104571,9680.5614256702756,11116.511370478034,null,null,null,null,null,null,null,null,"=J45#-J47#"]
[null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"'General Assumptions'!E34","v":"Days payable"},null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J34)","v":90},90,90,90,90,90,90,90,90,90,90,90,90,null,null,null,null,null,null,null,null,"='General Assumptions'!J34#"]
[null,null,null,null,null,null,null,null,null,null,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":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY(J$8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J49)*_xlfn.ANCHORARRAY(J53)/_xlfn.ANCHORARRAY(J55)","v":110.95890410958904},228.57534246575344,356.57753424657545,497.84459016393447,661.4513260273975,841.3660867068495,1040.4893938941375,1257.0346494852199,1503.1207066878681,1770.3421656545997,2064.2189651532635,2380.4659243451497,2741.0575982000632,null,null,null,null,null,null,null,null,"=J49#*J53#/J55#"]
[null,null,null,null,null,null,null,null,null,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,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":"OFFSET(_xlfn.ANCHORARRAY(J64),,-1)","v":0},110.95890410958904,228.57534246575344,356.57753424657545,497.84459016393447,661.4513260273975,841.3660867068495,1040.4893938941375,1257.0346494852199,1503.1207066878681,1770.3421656545997,2064.2189651532635,2380.4659243451497,null,null,null,null,null,null,null,"BS","=OFFSET(J64#,,-1)"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J49)","v":450},927,1446.1200000000003,2024.5680000000002,2682.5526000000009,3412.2069072000013,4219.7625419040014,5111.9409079065608,6095.9895326785754,7179.7210051547663,8371.5546920104571,9680.5614256702756,11116.511370478034,null,null,null,null,null,null,null,"IS","=J49#"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J64)-_xlfn.ANCHORARRAY(J61)-_xlfn.ANCHORARRAY(J62)","v":-339.04109589041093},-809.38356164383561,-1318.1178082191784,-1883.3009440826413,-2518.9458641365377,-3232.2921465205491,-4020.6392347167134,-4895.3956523154784,-5849.9034754759268,-6912.4995461880344,-8077.6778925117933,-9364.3144664783904,-10755.919696623121,null,null,null,null,null,null,null,"CFS","=J64#-J61#-J62#"]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$28","v":0},{"$f":"_xlfn.ANCHORARRAY(J57)","v":110.95890410958904},228.57534246575344,356.57753424657545,497.84459016393447,661.4513260273975,841.3660867068495,1040.4893938941375,1257.0346494852199,1503.1207066878681,1770.3421656545997,2064.2189651532635,2380.4659243451497,2741.0575982000632,null,null,null,null,null,null,null,"BS","=J57#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Purchases 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,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":"'General Assumptions'!E41","v":"Purchases"},null,{"$f":"Weight","v":"kg"},null,null,{"$f":"OFFSET('General Assumptions'!J41,,,,Number_of_Periods)","v":400},775,325,550,1000,1210,1420,1630,1840,2050,2260,2470,2680,null,null,null,null,null,null,null,null,"=OFFSET('General Assumptions'!J41,,,,Number_of_Periods)"]
[null,null,null,null,{"$f":"'General Assumptions'!E42","v":"Price"},null,{"$f":"Price_Weight","v":"$/kg"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J42)","v":3990},4750,2800,4160,5000,4569,4712,4855,4998,5141,5284,5427,5570,null,null,null,null,null,null,null,null,"='General Assumptions'!J42#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Purchases",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J71)","v":400},775,325,550,1000,1210,1420,1630,1840,2050,2260,2470,2680,null,null,null,null,null,null,null,null,"=J71#"]
[null,null,null,null,"Prices",null,{"$f":"Price_Weight","v":"$/kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J72)","v":3990},4750,2800,4160,5000,4569,4712,4855,4998,5141,5284,5427,5570,null,null,null,null,null,null,null,null,"=J72#"]
[null,null,null,null,"Purchases",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J76)*_xlfn.ANCHORARRAY(J77)/Thousand","v":1596},3681.25,910,2288,5000,5528.49,6691.04,7913.65,9196.32,10539.05,11941.84,13404.69,14927.6,null,null,null,null,null,null,null,null,"=J76#*J77#/Thousand"]
[null,null,null,null,null,null,null,null,null,null,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":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J50)","v":30},30,30,30,30,30,30,30,30,30,30,30,30,null,null,null,null,null,null,null,null,"='General Assumptions'!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,"Days in period",null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY(J$8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J78)*_xlfn.ANCHORARRAY(J80)/_xlfn.ANCHORARRAY(J82)","v":131.17808219178082},302.56849315068496,74.794520547945211,187.54098360655738,410.95890410958901,454.39643835616431,549.94849315068495,648.65983606557381,755.86191780821912,866.22328767123292,981.52109589041095,1098.7450819672131,1226.9260273972602,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J84),\"\")","v":"=J78#*J80#/J82#"}]
[null,null,null,null,null,null,null,null,null,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,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":"OFFSET(_xlfn.ANCHORARRAY(J91),,-1)","v":0},131.17808219178082,302.56849315068496,74.794520547945211,187.54098360655738,410.95890410958901,454.39643835616431,549.94849315068495,648.65983606557381,755.86191780821912,866.22328767123292,981.52109589041095,1098.7450819672131,null,null,null,null,null,null,null,{"$f":"Balance_Sheet","v":"BS"},"=OFFSET(J91#,,-1)"]
[null,null,null,null,"Purchases",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J78)","v":1596},3681.25,910,2288,5000,5528.49,6691.04,7913.65,9196.32,10539.05,11941.84,13404.69,14927.6,null,null,null,null,null,null,null,null,"=J78#"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J91)-_xlfn.ANCHORARRAY(J88)-_xlfn.ANCHORARRAY(J89)","v":-1464.8219178082193},-3509.8595890410957,-1137.7739726027398,-2175.2535369413877,-4776.5820794969686,-5485.0524657534243,-6595.4879452054793,-7814.9386570851111,-9089.1179182573542,-10428.688630136985,-11826.542191780822,-13287.466013923198,-14799.419054569953,null,null,null,null,null,null,null,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J91#-J88#-J89#"]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J84)","v":131.17808219178082},302.56849315068496,74.794520547945211,187.54098360655738,410.95890410958901,454.39643835616431,549.94849315068495,648.65983606557381,755.86191780821912,866.22328767123292,981.52109589041095,1098.7450819672131,1226.9260273972602,null,null,null,null,null,null,null,{"$f":"Balance_Sheet","v":"BS"},"=J84#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Inventory 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Referred values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Purchases",null,{"$f":"Weight","v":"kg"},{"$f":"\"Row \"&ROW(J71)","v":"Row 71"},null,{"$f":"_xlfn.ANCHORARRAY(J71)","v":400},775,325,550,1000,1210,1420,1630,1840,2050,2260,2470,2680,null,null,null,null,null,null,null,null,"=J71#"]
[null,null,null,null,"Purchases",null,{"$f":"Currency","v":"US$'000"},{"$f":"\"Row \"&ROW(J78)","v":"Row 78"},null,{"$f":"_xlfn.ANCHORARRAY(J78)","v":1596},3681.25,910,2288,5000,5528.49,6691.04,7913.65,9196.32,10539.05,11941.84,13404.69,14927.6,null,null,null,null,null,null,null,null,"=J78#"]
[null,null,null,null,"Amount used per sale",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J43)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,null,null,null,null,null,null,null,null,"='General Assumptions'!J43#"]
[null,null,null,null,"Wastage",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J44)","v":0.03},0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,null,null,null,null,null,null,null,null,"='General Assumptions'!J44#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Projected sales",null,{"$f":"Unit","v":"#"},{"$f":"\"Row \"&ROW(J17)","v":"Row 17"},null,{"$f":"_xlfn.ANCHORARRAY(J17)","v":100},200,300,400,500,600,700,800,900,1000,1100,1200,1300,null,null,null,null,null,null,null,null,"=J17#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Amount used per sale",null,{"$f":"Weight","v":"kg"},{"$f":"\"Row \"&ROW(J100)","v":"Row 100"},null,{"$f":"_xlfn.ANCHORARRAY(J100)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,null,null,null,null,null,null,null,null,"=J100#"]
[null,null,null,null,"Projected sales",null,{"$f":"Unit","v":"#"},{"$f":"\"Row \"&ROW(J103)","v":"Row 103"},null,{"$f":"_xlfn.ANCHORARRAY(J103)","v":100},200,300,400,500,600,700,800,900,1000,1100,1200,1300,null,null,null,null,null,null,null,null,"=J103#"]
[null,null,null,null,"COGS",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J107)*_xlfn.ANCHORARRAY(J108)","v":200},400,600,800,1000,1200,1400,1600,1800,2000,2200,2400,2600,null,null,null,null,null,null,null,null,"=J107#*J108#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Inventory movement pre-wastage",null,{"$f":"Weight","v":"kg"},null,"Opening balance",{"$f":"_xlfn.ANCHORARRAY(J133)+_xlfn.ANCHORARRAY(J134)","v":200},375,-275,-250,0,10,20,30,40,50,60,70,80,null,null,null,null,null,null,null,null,"=J133#+J134#"]
[null,null,null,null,"Closing inventory balance",null,{"$f":"Weight","v":"kg"},null,{"$f":"I136","v":13},{"$f":"_xlfn.SCAN($I$112,_xlfn.ANCHORARRAY(J$9),_xlfn.LAMBDA(_xlpm.accumulator,_xlpm.period,\n(_xlpm.accumulator+INDEX(_xlfn.ANCHORARRAY(J111),_xlpm.period))*(1-INDEX(_xlfn.ANCHORARRAY(J101),_xlpm.period))))","v":206.60999999999999},569.9778,289.07824399999998,38.687461559999981,38.300586944399981,47.817581074955982,67.139405264206417,96.168011211564348,134.80633109944873,182.95826778845424,240.52868511056968,307.42339825946397,383.54916427686931,null,null,null,null,null,null,null,null,"=SCAN($I$112,J$9#,LAMBDA(accumulator,period,\n(accumulator+INDEX(J111#,period))*(1-INDEX(J101#,period))))"]
[null,null,null,null,"Inventory balance pre-wastage",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"OFFSET(_xlfn.ANCHORARRAY(J112),,-1)+_xlfn.ANCHORARRAY(J111)","v":213},581.61,294.9778,39.078243999999984,38.687461559999981,48.300586944399981,67.817581074955982,97.139405264206417,136.16801121156436,184.80633109944873,242.95826778845424,310.52868511056965,387.42339825946397,null,null,null,null,null,null,null,null,"=OFFSET(J112#,,-1)+J111#"]
[null,null,null,null,"Wastage",null,{"$f":"Percentage","v":"%"},{"$f":"\"Row \"&ROW(J101)","v":"Row 101"},null,{"$f":"_xlfn.ANCHORARRAY(J101)","v":0.03},0.02,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,null,null,null,null,null,null,null,null,"=J101#"]
[null,null,null,null,"Wastage",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J113)*_xlfn.ANCHORARRAY(J114)","v":6.39},11.632200000000001,5.8995560000000005,0.39078243999999984,0.3868746155999998,0.48300586944399981,0.67817581074955979,0.97139405264206424,1.3616801121156437,1.8480633109944873,2.4295826778845426,3.1052868511056966,3.8742339825946397,null,null,null,null,null,null,null,null,"=J113#*J114#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Inventory balance pre-COGS transfer",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J132)+_xlfn.ANCHORARRAY(J133)","v":413},981.61,894.9778,839.07824400000004,1038.68746156,1248.3005869444,1467.817581074956,1697.1394052642065,1936.1680112115644,2184.8063310994485,2442.9582677884541,2710.5286851105698,2987.4233982594642,null,null,null,null,null,null,null,null,"=J132#+J133#"]
[null,null,null,null,"Inventory balance pre-COGS transfer",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J140)+_xlfn.ANCHORARRAY(J141)","v":1596},4479.6750847457624,3511.150507348339,3422.103240420005,5157.7832443098132,5718.6782259099991,6910.1005071959453,8229.724725054908,9662.6554449094056,11211.815545997864,12880.730702512366,14672.900456146413,16591.774574255563,null,null,null,null,null,null,null,null,"=J140#+J141#"]
[null,null,null,null,"COGS",null,{"$f":"Weight","v":"kg"},{"$f":"\"Row \"&ROW(J109)","v":"Row 109"},null,{"$f":"_xlfn.ANCHORARRAY(J109)","v":200},400,600,800,1000,1200,1400,1600,1800,2000,2200,2400,2600,null,null,null,null,null,null,null,null,"=J109#"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J118)*_xlfn.ANCHORARRAY(J119)/_xlfn.ANCHORARRAY(J117)","v":772.88135593220341},1825.4398731658243,2353.9023028381298,3262.7262259656491,4965.6739252088028,5497.4049863181344,6590.8331081505839,7758.678821106012,8983.0942873358035,10263.441099015674,11599.710039738213,12991.916037706453,14440.073649486018,null,null,null,null,null,null,null,null,"=J118#*J119#/J117#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Inventory balance pre-wastage",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J117)-_xlfn.ANCHORARRAY(J119)","v":213},581.61,294.9778,39.078244000000041,38.687461559999974,48.300586944400038,67.817581074956024,97.139405264206516,136.16801121156436,184.80633109944847,242.95826778845412,310.52868511056977,387.42339825946419,null,null,null,null,null,null,null,null,"=J117#-J119#"]
[null,null,null,null,"Inventory balance pre-wastage",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J118)-_xlfn.ANCHORARRAY(J120)","v":823.11864406779659},2654.2352115799381,1157.2482045102092,159.37701445435596,192.10931910101044,221.27323959186469,319.26739904536134,471.04590394889601,679.56115757360203,948.37444698219042,1281.0206627741536,1680.9844184399608,2151.700924769546,null,null,null,null,null,null,null,null,"=J118#-J120#"]
[null,null,null,null,"Wastage",null,{"$f":"Weight","v":"kg"},{"$f":"\"Row \"&ROW(J115)","v":"Row 115"},null,{"$f":"_xlfn.ANCHORARRAY(J115)","v":6.39},11.632200000000001,5.8995560000000005,0.39078243999999984,0.3868746155999998,0.48300586944399981,0.67817581074955979,0.97139405264206424,1.3616801121156437,1.8480633109944873,2.4295826778845426,3.1052868511056966,3.8742339825946397,null,null,null,null,null,null,null,null,"=J115#"]
[null,null,null,null,"Wastage",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J123)*_xlfn.ANCHORARRAY(J124)/_xlfn.ANCHORARRAY(J122)","v":24.693559322033895},53.084704231598764,23.144964090204187,1.5937701445435573,1.9210931910101046,2.2127323959186445,3.1926739904536112,4.7104590394889554,6.7956115757360207,9.483744469821918,12.810206627741543,16.809844184399601,21.517009247695448,null,null,null,null,null,null,null,null,"=J123#*J124#/J122#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Proportion used",null,{"$f":"Percentage","v":"%"},null,"Opening balance",{"$f":"-(_xlfn.ANCHORARRAY(J134)+_xlfn.ANCHORARRAY(J135))/(_xlfn.ANCHORARRAY(J132)+_xlfn.ANCHORARRAY(J133))","v":0.49973365617433413},0.41934393496398775,0.67699953674828572,0.95389290350853129,0.96312597546245871,0.96169385677210628,0.95425902637367443,0.94333523167674427,0.93037467290088471,0.91625881654398866,0.90154204094189705,0.88658175803554595,0.87161205053815483,null,null,null,null,null,null,null,null,"=-(J134#+J135#)/(J132#+J133#)"]
[null,null,null,null,"Closing inventory",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I144","v":0},{"$f":"_xlfn.SCAN(I128,_xlfn.ANCHORARRAY( J$9), _xlfn.LAMBDA(_xlpm.accumulator,_xlpm.period,\n(_xlpm.accumulator+INDEX(_xlfn.ANCHORARRAY(J99),_xlpm.period))*(1-INDEX(_xlfn.ANCHORARRAY(J127),_xlpm.period))))","v":798.42508474576266},2601.150507348339,1134.103240420005,157.78324430981291,190.1882259099994,219.06050719594558,316.07472505490864,466.33544490940585,672.76554599786471,938.89070251236706,1268.2104561464123,1664.174574255562,2130.1839155218508,null,null,null,null,null,null,null,null,"=SCAN(I128, J$9#, LAMBDA(accumulator,period,\n(accumulator+INDEX(J99#,period))*(1-INDEX(J127#,period))))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Inventory at hand (kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,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 inventory",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"OFFSET(_xlfn.ANCHORARRAY(J136),,-1)","v":13},206.61,569.9778,289.07824399999998,38.687461559999974,38.300586944399974,47.817581074955974,67.139405264206417,96.168011211564348,134.8063310994487,182.95826778845421,240.52868511056965,307.42339825946397,null,null,null,null,null,null,null,null,"=OFFSET(J136#,,-1)"]
[null,null,null,null,"Purchases",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"_xlfn.ANCHORARRAY(J98)","v":400},775,325,550,1000,1210,1420,1630,1840,2050,2260,2470,2680,null,null,null,null,null,null,null,null,"=J98#"]
[null,null,null,null,"COGS",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"-_xlfn.ANCHORARRAY(J109)","v":-200},-400,-600,-800,-1000,-1200,-1400,-1600,-1800,-2000,-2200,-2400,-2600,null,null,null,null,null,null,null,null,"=-J109#"]
[null,null,null,null,"Wastage",null,{"$f":"Weight","v":"kg"},null,null,{"$f":"-_xlfn.ANCHORARRAY(J115)","v":-6.39},-11.632200000000001,-5.8995560000000005,-0.39078243999999984,-0.3868746155999998,-0.48300586944399981,-0.67817581074955979,-0.97139405264206424,-1.3616801121156437,-1.8480633109944873,-2.4295826778845426,-3.1052868511056966,-3.8742339825946397,null,null,null,null,null,null,null,null,"=-J115#"]
[null,null,null,null,"Closing inventory",null,{"$f":"Weight","v":"kg"},null,{"$f":"'General Assumptions'!$I$46","v":13},{"$f":"_xlfn.SCAN(I136,_xlfn.ANCHORARRAY(J133)+_xlfn.ANCHORARRAY(J134)+_xlfn.ANCHORARRAY(J135),\n_xlfn.LAMBDA(_xlpm.accumulator,_xlpm.value,_xlpm.accumulator+_xlpm.value))","v":206.61},569.9778,289.07824399999998,38.687461559999974,38.300586944399974,47.817581074955974,67.139405264206417,96.168011211564348,134.8063310994487,182.95826778845421,240.52868511056965,307.42339825946397,383.54916427686931,null,null,null,null,null,null,null,null,"=SCAN(I136,J133#+J134#+J135#,\nLAMBDA(accumulator,value,accumulator+value))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Inventory ($)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,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 inventory",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"OFFSET(_xlfn.ANCHORARRAY(J144),,-1)","v":0},798.42508474576266,2601.150507348339,1134.103240420005,157.78324430981291,190.1882259099994,219.06050719594558,316.07472505490864,466.33544490940585,672.76554599786471,938.89070251236706,1268.2104561464123,1664.174574255562,null,null,null,null,null,null,null,{"$f":"Balance_Sheet","v":"BS"},{"$f":"IFERROR(_xlfn.FORMULATEXT(J140),\"\")","v":"=OFFSET(J144#,,-1)"}]
[null,null,null,null,"Purchases",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J99)","v":1596},3681.25,910,2288,5000,5528.49,6691.04,7913.65,9196.32,10539.05,11941.84,13404.69,14927.6,null,null,null,null,null,null,null,null,"=J99#"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(J120)","v":-772.88135593220341},-1825.4398731658243,-2353.9023028381298,-3262.7262259656491,-4965.6739252088028,-5497.4049863181344,-6590.8331081505839,-7758.678821106012,-8983.0942873358035,-10263.441099015674,-11599.710039738213,-12991.916037706453,-14440.073649486018,null,null,null,null,null,null,null,{"$f":"Income_Statement","v":"IS"},"=-J120#"]
[null,null,null,null,"Wastage",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(J125)","v":-24.693559322033895},-53.084704231598764,-23.144964090204187,-1.5937701445435573,-1.9210931910101046,-2.2127323959186445,-3.1926739904536112,-4.7104590394889554,-6.7956115757360207,-9.483744469821918,-12.810206627741543,-16.809844184399601,-21.517009247695448,null,null,null,null,null,null,null,{"$f":"Income_Statement","v":"IS"},"=-J125#"]
[null,null,null,null,"Closing inventory",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$16","v":0},{"$f":"_xlfn.ANCHORARRAY(J128)","v":798.42508474576266},2601.150507348339,1134.103240420005,157.78324430981291,190.1882259099994,219.06050719594558,316.07472505490864,466.33544490940585,672.76554599786471,938.89070251236706,1268.2104561464123,1664.174574255562,2130.1839155218508,null,null,null,null,null,null,null,{"$f":"Balance_Sheet","v":"BS"},"=J128#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,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,null,null,null,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":"'General Assumptions'!C54","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,{"$f":"'General Assumptions'!D56","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"'General Assumptions'!E58","v":"Growth rates used from "},null,{"$f":"Year","v":"Year"},null,{"$f":"'General Assumptions'!I58","v":"2027-06-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Growth rates flag",null,{"$f":"Boolean","v":"[1,0]"},null,null,{"$f":"($I$152<=_xlfn.ANCHORARRAY(J$7))*1","v":0},0,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,"=($I$152<=J$7#)*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,{"$f":"'General Assumptions'!E59","v":"Amounts"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J59)","v":60},65,70,75,80,85,90,95,100,105,110,115,120,null,null,null,null,null,null,null,null,"='General Assumptions'!J59#"]
[null,null,null,null,{"$f":"'General Assumptions'!E60","v":"Growth rates"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"_xlfn.ANCHORARRAY('General Assumptions'!J60)","v":0},0.05,0.04,0.03,0.02,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,null,null,null,null,null,null,null,null,"='General Assumptions'!J60#"]
[null,null,null,null,null,null,null,null,null,null,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":"D150","v":"Opex"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.SCAN(1,_xlfn.ANCHORARRAY(J$9),_xlfn.LAMBDA(_xlpm.accumulator,_xlpm.period,\n(1-INDEX(_xlfn.ANCHORARRAY(J153),_xlpm.period))*INDEX(_xlfn.ANCHORARRAY(J155),_xlpm.period)\n+INDEX(_xlfn.ANCHORARRAY(J153),_xlpm.period)*_xlpm.accumulator*(1+INDEX(_xlfn.ANCHORARRAY(J156),_xlpm.period))))","v":60},65,67.600000000000009,69.628000000000014,71.020560000000017,71.730765600000012,72.448073256000015,73.172553988560011,73.904279528445613,74.643322323730075,75.389755546967379,76.143653102437057,76.905089633461429,null,null,null,null,null,null,null,null,"=SCAN(1,J$9#,LAMBDA(accumulator,period,\n(1-INDEX(J153#,period))*INDEX(J155#,period)\n+INDEX(J153#,period)*accumulator*(1+INDEX(J156#,period))))"]
[null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"E53","v":"Days payable"},null,{"$f":"No._of_days","v":"Year"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9),,)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"=IF(J$9#,,)"]
[null,null,null,null,null,null,null,null,null,null,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":"Year"},null,null,{"$f":"_xlfn.ANCHORARRAY(J$8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J158)*_xlfn.ANCHORARRAY(J162)/_xlfn.ANCHORARRAY(J164)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"=J158#*J162#/J164#"]
[null,null,null,null,null,null,null,null,null,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,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":"OFFSET(_xlfn.ANCHORARRAY(J173),,-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,"BS","=OFFSET(J173#,,-1)"]
[null,null,null,null,{"$f":"D150","v":"Opex"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J158)","v":60},65,67.600000000000009,69.628000000000014,71.020560000000017,71.730765600000012,72.448073256000015,73.172553988560011,73.904279528445613,74.643322323730075,75.389755546967379,76.143653102437057,76.905089633461429,null,null,null,null,null,null,null,"IS","=J158#"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J173)-_xlfn.ANCHORARRAY(J170)-_xlfn.ANCHORARRAY(J171)","v":-60},-65,-67.600000000000009,-69.628000000000014,-71.020560000000017,-71.730765600000012,-72.448073256000015,-73.172553988560011,-73.904279528445613,-74.643322323730075,-75.389755546967379,-76.143653102437057,-76.905089633461429,null,null,null,null,null,null,null,"CFS","=J173#-J170#-J171#"]
[null,null,null,null,"Closing payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J166)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,"BS","=J166#"]
[]
[]
[null,null,{"$f":"'General Assumptions'!C63","v":"Capex 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,{"$f":"IFERROR(_xlfn.FORMULATEXT(J176),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,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":"'General Assumptions'!D65","v":"Capital expenditure"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Existing assets",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$21","v":0},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(I180),\"\")","v":"='Opening Balance Sheet'!$I$21"}]
[null,null,null,null,{"$f":"'General Assumptions'!E67","v":"Capital expenditure"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"OFFSET('General Assumptions'!J67,,,,MAX(_xlfn.ANCHORARRAY(J$9)))","v":150},180,120,90,100,150,180,120,90,100,150,180,120,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J181),\"\")","v":"=OFFSET('General Assumptions'!J67,,,,MAX(J$9#))"}]
[null,null,null,null,null,null,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(J182),\"\")","v":""}]
[null,null,null,{"$f":"'General Assumptions'!D69","v":"Accounting depreciation - straight line"},null,null,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(J183),\"\")","v":""}]
[null,null,null,null,null,null,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(J184),\"\")","v":""}]
[null,null,null,null,{"$f":"'General Assumptions'!E71","v":"Remaining life of existing assets"},null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I71","v":5},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(I185),\"\")","v":"='General Assumptions'!I71"}]
[null,null,null,null,{"$f":"'General Assumptions'!E72","v":"Annual rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I72","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"='General Assumptions'!I72"]
[null,null,null,null,null,null,null,null,null,null,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":"'General Assumptions'!E74","v":"Economic life of new capex"},null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I74","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"='General Assumptions'!I74"]
[null,null,null,null,{"$f":"'General Assumptions'!E75","v":"Annual rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I75","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"='General Assumptions'!I75"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Depreciation - existing assets",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I180*I186","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=I180*I186"]
[null,null,null,null,"Depreciation - new assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J181)*$I$189","v":37.5},45,30,22.5,25,37.5,45,30,22.5,25,37.5,45,30,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J192),\"\")","v":"=J181#*$I$189"}]
[null,null,null,null,"Aggregate depreciation - existing assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9)>$I$185,,$I$191)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"=IF(J$9#>$I$185,,$I$191)"]
[null,null,null,null,"Aggregate depreciation - new assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.MAP(_xlfn.ANCHORARRAY(J9),_xlfn.LAMBDA(_xlpm.period,\nSUM(OFFSET(INDEX(_xlfn.ANCHORARRAY(J192),_xlpm.period),,,,-MIN(_xlpm.period,$I$188)))))","v":37.5},82.5,112.5,135,122.5,115,130,137.5,135,122.5,115,130,137.5,null,null,null,null,null,null,null,null,"=MAP(J9#,LAMBDA(period,\nSUM(OFFSET(INDEX(J192#,period),,,,-MIN(period,$I$188)))))"]
[null,null,null,null,"Total depreciation",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J193)+_xlfn.ANCHORARRAY(J194)","v":37.5},82.5,112.5,135,122.5,115,130,137.5,135,122.5,115,130,137.5,null,null,null,null,null,null,null,null,"=J193#+J194#"]
[null,null,null,null,null,null,null,null,null,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,{"$f":"IFERROR(_xlfn.FORMULATEXT(J197),\"\")","v":""}]
[null,null,null,null,null,null,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(J198),\"\")","v":""}]
[null,null,null,null,"Opening net book value",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"OFFSET(_xlfn.ANCHORARRAY(J202),,-1)","v":0},112.5,210,217.5,172.5,150,185,235,217.5,172.5,150,185,235,null,null,null,null,null,null,null,"BS",{"$f":"IFERROR(_xlfn.FORMULATEXT(J199),\"\")","v":"=OFFSET(J202#,,-1)"}]
[null,null,null,null,"Capital expenditure",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J181)","v":150},180,120,90,100,150,180,120,90,100,150,180,120,null,null,null,null,null,null,null,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J181#"]
[null,null,null,null,"Depreciation",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(J195)","v":-37.5},-82.5,-112.5,-135,-122.5,-115,-130,-137.5,-135,-122.5,-115,-130,-137.5,null,null,null,null,null,null,null,{"$f":"Income_Statement","v":"IS"},"=-J195#"]
[null,null,null,null,"Closing net book value",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$21","v":0},{"$f":"_xlfn.SCAN(I202,_xlfn.ANCHORARRAY(J200)+_xlfn.ANCHORARRAY(J201),_xlfn.LAMBDA(_xlpm.accumulator,_xlpm.depreciation,_xlpm.accumulator+_xlpm.depreciation))","v":112.5},210,217.5,172.5,150,185,235,217.5,172.5,150,185,235,217.5,null,null,null,null,null,null,null,"BS","=SCAN(I202,J200#+J201#,LAMBDA(accumulator,depreciation,accumulator+depreciation))"]

{"sheet":"Opening Balance Sheet","index":6,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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 10 - Capital Expenditure 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":"2024-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"}]
[null,null,"End Date"]
[null,null,"Number of Days"]
[null,null,"Counter"]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Opening Balance Sheet"}]
[]
[null,null,"Current assets"]
[null,null,null,"Cash",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,2500]
[null,null,null,"Accounts receivable",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,50]
[null,null,null,"Inventory",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,50]
[null,null,null,"Other current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,10]
[null,null,null,"Total current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"SUM(K14:K17)","v":2610}]
[]
[null,null,"Non-current assets"]
[null,null,null,"PP&E",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,450]
[null,null,null,"Deferred tax assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,75]
[null,null,null,"Total non-current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"SUM(K21:K22)","v":525}]
[]
[null,null,"Total assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K18+K23","v":3135}]
[]
[null,null,"Current liabilities"]
[null,null,null,"Accounts payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,30]
[null,null,null,"Interest payable",null,null,"US$'000",null,null,null,20]
[null,null,null,"Dividends payable",null,null,"US$'000",null,null,null,15]
[null,null,null,"Tax payable",null,null,"US$'000",null,null,null,40]
[null,null,null,"Other current liabilities",null,null,"US$'000",null,null,null,10]
[null,null,null,"Total current liabilities",null,null,"US$'000",null,null,null,{"$f":"SUM(K28:K32)","v":115}]
[]
[null,null,"Non-current liabilities"]
[null,null,null,"Debt",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,150]
[null,null,null,"Deferred tax liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,25]
[null,null,null,"Total non-current liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"SUM(K36:K37)","v":175}]
[]
[null,null,"Total liabilities",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K33+K38","v":290}]
[]
[null,null,"Net assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K25-K40","v":2845}]
[]
[]
[null,null,"Equity"]
[null,null,null,"Ordinary equity",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,300]
[null,null,null,null,"Opening retained profits",null,"US$'000",null,null,null,{"$f":"K42-SUM(K46,K48,K49)","v":2520}]
[null,null,null,null,"NPAT",null,"US$'000",null,null,null,25]
[null,null,null,null,"Dividends declared",null,"US$'000",null,null,null,0]
[null,null,null,"Retained profits",null,null,"US$'000",null,null,null,{"$f":"SUM(K47:K49)","v":2545}]
[null,null,null,"Total equity",null,null,"US$'000",null,null,null,{"$f":"K46+K50","v":2845}]
[]
[]
[null,null,"Checks"]
[]
[null,null,null,"PF error check",null,null,"[1,0]",null,{"$f":"IF(ISERROR(I42-I51),1,0)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(HL_Op_BS_Errors),\"\")","v":"=IF(ISERROR(I42-I51),1,0)"}]
[null,null,null,"Balance check",null,null,"[1,0]",null,{"$f":"IF(I56<>0,0,(ROUND(I42-I51,Rounding_Accuracy)<>0)*1)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(HL_Op_BS_Balance),\"\")","v":"=IF(I56<>0,0,(ROUND(I42-I51,Rounding_Accuracy)<>0)*1)"}]
[null,null,null,"Insolvency check",null,null,"[1,0]",null,{"$f":"IF(SUM(I56:I57)<>0,0,(I42<0)*1)","v":0},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(HL_Op_BS_Insolvency),\"\")","v":"=IF(SUM(I56:I57)<>0,0,(I42<0)*1)"}]

{"sheet":"Income Statement","index":7,"n_rows":28,"n_cols":30,"rows_kept":28,"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":"Income Statement"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(Timing!J5)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J6)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J7)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J9)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Income Statement"}]
[]
[null,null,null,"Revenue",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J36)","v":1500},3090,4820.4000000000005,6748.56,8941.8420000000006,11374.023024000002,14065.875139680003,17039.803026355203,20319.965108928584,23932.403350515888,27905.182306701525,32268.538085567583,37055.037901593445,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J13),\"\")","v":"=Calculations!J36#"}]
[null,null,null,"COGS",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(Calculations!J62)+_xlfn.ANCHORARRAY(Calculations!J142)","v":-1222.8813559322034},-2752.4398731658243,-3800.0223028381301,-5287.2942259656493,-7648.2265252088037,-8909.6118935181366,-10810.595650054585,-12870.619729012573,-15079.083820014379,-17443.162104170442,-19971.26473174867,-22672.47746337673,-25556.585019964052,null,null,null,null,null,null,null,"=-Calculations!J62#+Calculations!J142#"]
[null,null,null,"Gross profit",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J13)+_xlfn.ANCHORARRAY(J14)","v":277.11864406779659},337.56012683417566,1020.3776971618704,1461.2657740343511,1293.6154747911969,2464.4111304818653,3255.2794896254181,4169.1832973426299,5240.8812889142046,6489.2412463454457,7933.9175749528549,9596.0606221908529,11498.452881629393,null,null,null,null,null,null,null,"=J13#+J14#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Wastage",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J143)","v":-24.693559322033895},-53.084704231598764,-23.144964090204187,-1.5937701445435573,-1.9210931910101046,-2.2127323959186445,-3.1926739904536112,-4.7104590394889554,-6.7956115757360207,-9.483744469821918,-12.810206627741543,-16.809844184399601,-21.517009247695448,null,null,null,null,null,null,null,"=Calculations!J143#"]
[null,null,null,"Operating expenditure",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(Calculations!J171)","v":-60},-65,-67.600000000000009,-69.628000000000014,-71.020560000000017,-71.730765600000012,-72.448073256000015,-73.172553988560011,-73.904279528445613,-74.643322323730075,-75.389755546967379,-76.143653102437057,-76.905089633461429,null,null,null,null,null,null,null,"=-Calculations!J171#"]
[null,null,null,"EBITDA",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J15)+_xlfn.ANCHORARRAY(J17)+_xlfn.ANCHORARRAY(J18)","v":192.42508474576269},219.47542260257688,929.63273307166617,1390.0440038898075,1220.6738216001868,2390.467632485947,3179.6387423789647,4091.3002843145805,5160.1813978100226,6405.1141795518934,7845.7176127781458,9503.107124904016,11400.030782748237,null,null,null,null,null,null,null,"=J15#+J17#+J18#"]
[null,null,null,null,null,null,null,null,null,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,{"$f":"_xlfn.ANCHORARRAY(Calculations!J201)","v":-37.5},-82.5,-112.5,-135,-122.5,-115,-130,-137.5,-135,-122.5,-115,-130,-137.5,null,null,null,null,null,null,null,"=Calculations!J201#"]
[null,null,null,"EBIT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J19)+_xlfn.ANCHORARRAY(J21)","v":154.92508474576269},136.97542260257688,817.13273307166617,1255.0440038898075,1098.1738216001868,2275.467632485947,3049.6387423789647,3953.8002843145805,5025.1813978100226,6282.6141795518934,7730.7176127781458,9373.107124904016,11262.530782748237,null,null,null,null,null,null,null,"=J19#+J21#"]
[null,null,null,null,null,null,null,null,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 expense",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"NPBT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J22,J24)","v":154.92508474576269},{"$f":"SUM(K22,K24)","v":136.97542260257688},{"$f":"SUM(L22,L24)","v":817.13273307166617},{"$f":"SUM(M22,M24)","v":1255.0440038898075},{"$f":"SUM(N22,N24)","v":1098.1738216001868},{"$f":"SUM(O22,O24)","v":2275.467632485947},{"$f":"SUM(P22,P24)","v":3049.6387423789647},{"$f":"SUM(Q22,Q24)","v":3953.8002843145805},{"$f":"SUM(R22,R24)","v":5025.1813978100226},{"$f":"SUM(S22,S24)","v":6282.6141795518934},{"$f":"SUM(T22,T24)","v":7730.7176127781458},{"$f":"SUM(U22,U24)","v":9373.107124904016},{"$f":"SUM(V22,V24)","v":11262.530782748237},{"$f":"SUM(W22,W24)","v":0},{"$f":"SUM(X22,X24)","v":0},{"$f":"SUM(Y22,Y24)","v":0},{"$f":"SUM(Z22,Z24)","v":0},{"$f":"SUM(AA22,AA24)","v":0},{"$f":"SUM(AB22,AB24)","v":0},{"$f":"SUM(AC22,AC24)","v":0},"=SUM(J22,J24)"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
["w",null,null,"NPAT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J25,J27)","v":154.92508474576269},{"$f":"SUM(K25,K27)","v":136.97542260257688},817.13273307166617,1255.0440038898075,1098.1738216001868,2275.467632485947,3049.6387423789647,3953.8002843145805,5025.1813978100226,6282.6141795518934,7730.7176127781458,9373.107124904016,11262.530782748237,0,0,0,0,0,0,0,"=SUM(J25,J27)"]

{"sheet":"Balance Sheet","index":8,"n_rows":58,"n_cols":30,"rows_kept":58,"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":"Balance Sheet"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(Timing!J5)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J6)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J7)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J9)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Balance Sheet"}]
[]
[null,null,"Current assets"]
["w",null,null,"Cash",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=\"\",,IF(J$9=1,'Opening Balance Sheet'!$I$14,I14))\n+'Cash Flow Statement'!J36","v":-760.43835616438378},{"$f":"IF(K$9=\"\",,IF(K$9=1,'Opening Balance Sheet'!$I$14,J14))\n+'Cash Flow Statement'!K36","v":-2496.0513698630139},{"$f":"IF(L$9=\"\",,IF(L$9=1,'Opening Balance Sheet'!$I$14,K14))\n+'Cash Flow Statement'!L36","v":-603.59246575342468},{"$f":"IF(M$9=\"\",,IF(M$9=1,'Opening Balance Sheet'!$I$14,L14))\n+'Cash Flow Statement'!M36","v":1612.8582622950821},{"$f":"IF(N$9=\"\",,IF(N$9=1,'Opening Balance Sheet'!$I$14,M14))\n+'Cash Flow Statement'!N36","v":2724.5812345205482},{"$f":"IF(O$9=\"\",,IF(O$9=1,'Opening Balance Sheet'!$I$14,N14))\n+'Cash Flow Statement'!O36","v":4759.7183013589056},{"$f":"IF(P$9=\"\",,IF(P$9=1,'Opening Balance Sheet'!$I$14,O14))\n+'Cash Flow Statement'!P36","v":7514.5219496667432},{"$f":"IF(Q$9=\"\",,IF(Q$9=1,'Opening Balance Sheet'!$I$14,P14))\n+'Cash Flow Statement'!Q36","v":11169.606433541501},{"$f":"IF(R$9=\"\",,IF(R$9=1,'Opening Balance Sheet'!$I$14,Q14))\n+'Cash Flow Statement'!R36","v":15839.787964313586},{"$f":"IF(S$9=\"\",,IF(S$9=1,'Opening Balance Sheet'!$I$14,R14))\n+'Cash Flow Statement'!S36","v":21662.534351810209},{"$f":"IF(T$9=\"\",,IF(T$9=1,'Opening Balance Sheet'!$I$14,S14))\n+'Cash Flow Statement'!T36","v":28785.047264230678},{"$f":"IF(U$9=\"\",,IF(U$9=1,'Opening Balance Sheet'!$I$14,T14))\n+'Cash Flow Statement'!U36","v":37442.890195867818},{"$f":"IF(V$9=\"\",,IF(V$9=1,'Opening Balance Sheet'!$I$14,U14))\n+'Cash Flow Statement'!V36","v":47944.369425846031},{"$f":"IF(W$9=\"\",,IF(W$9=1,'Opening Balance Sheet'!$I$14,V14))\n+'Cash Flow Statement'!W36","v":0},{"$f":"IF(X$9=\"\",,IF(X$9=1,'Opening Balance Sheet'!$I$14,W14))\n+'Cash Flow Statement'!X36","v":0},{"$f":"IF(Y$9=\"\",,IF(Y$9=1,'Opening Balance Sheet'!$I$14,X14))\n+'Cash Flow Statement'!Y36","v":0},{"$f":"IF(Z$9=\"\",,IF(Z$9=1,'Opening Balance Sheet'!$I$14,Y14))\n+'Cash Flow Statement'!Z36","v":0},{"$f":"IF(AA$9=\"\",,IF(AA$9=1,'Opening Balance Sheet'!$I$14,Z14))\n+'Cash Flow Statement'!AA36","v":0},{"$f":"IF(AB$9=\"\",,IF(AB$9=1,'Opening Balance Sheet'!$I$14,AA14))\n+'Cash Flow Statement'!AB36","v":0},{"$f":"IF(AC$9=\"\",,IF(AC$9=1,'Opening Balance Sheet'!$I$14,AB14))\n+'Cash Flow Statement'!AC36","v":0},{"$f":"IFERROR(_xlfn.FORMULATEXT(J14),\"\")","v":"=IF(J$9=\"\",,IF(J$9=1,'Opening Balance Sheet'!$I$14,I14))\n+'Cash Flow Statement'!J36"}]
[null,null,null,"Accounts receivable",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J38)","v":246.57534246575344},507.94520547945206,792.39452054794538,1106.3213114754099,1469.8918356164384,1869.7024149041099,2312.198653098083,2793.4103321893776,3340.2682370841508,3934.0937014546666,4587.1532558961408,5289.9242763225548,6091.2391071112506,null,null,null,null,null,null,null,"=Calculations!J38#"]
[null,null,null,"Inventory",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J144)","v":798.42508474576266},2601.150507348339,1134.103240420005,157.78324430981291,190.1882259099994,219.06050719594558,316.07472505490864,466.33544490940585,672.76554599786471,938.89070251236706,1268.2104561464123,1664.174574255562,2130.1839155218508,null,null,null,null,null,null,null,"=Calculations!J144#"]
[null,null,null,"Other current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"Total current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J14:J17)","v":284.56207104713235},{"$f":"SUM(K14:K17)","v":613.04434296477712},1322.9052952145257,2876.9628180803047,4384.6612960469856,6848.4812234589608,10142.795327819735,14429.352210640285,19852.821747395599,26535.518755777241,34640.410976273233,44396.989046445939,56165.792448479129,0,0,0,0,0,0,0,"=SUM(J14:J17)"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,"PP&E",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J202)","v":112.5},210,217.5,172.5,150,185,235,217.5,172.5,150,185,235,217.5,null,null,null,null,null,null,null,"=Calculations!J202#"]
[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,null,null,null,null,null,null,""]
["w",null,null,"Total non-current assets",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J21:J22)","v":112.5},{"$f":"SUM(K21:K22)","v":210},217.5,172.5,150,185,235,217.5,172.5,150,185,235,217.5,0,0,0,0,0,0,0,"=SUM(J21:J22)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,"Total assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J18,J23)","v":397.06207104713235},{"$f":"SUM(K18,K23)","v":823.04434296477712},1540.4052952145257,3049.4628180803047,4534.6612960469856,7033.4812234589608,10377.795327819735,14646.852210640285,20025.321747395599,26685.518755777241,34825.410976273233,44631.989046445939,56383.292448479129,0,0,0,0,0,0,0,"=SUM(J18,J23)"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,""]
[null,null,null,"Accounts payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J64)+_xlfn.ANCHORARRAY(Calculations!J91)+_xlfn.ANCHORARRAY(Calculations!J173)","v":242.13698630136986},531.14383561643842,431.37205479452064,685.38557377049187,1072.4102301369865,1295.7625250630138,1590.4378870448224,1905.6944855507936,2258.9826244960873,2636.5654533258326,3045.7400610436744,3479.2110063123628,3967.9836255973232,null,null,null,null,null,null,null,"=Calculations!J64#+Calculations!J91#+Calculations!J173#"]
[null,null,null,"Interest payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Dividends payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Tax payable",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"Other current liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"Total current liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J28:J32)","v":242.13698630136986},{"$f":"SUM(K28:K32)","v":531.14383561643842},431.37205479452064,685.38557377049187,1072.4102301369865,1295.7625250630138,1590.4378870448224,1905.6944855507936,2258.9826244960873,2636.5654533258326,3045.7400610436744,3479.2110063123628,3967.9836255973232,0,0,0,0,0,0,0,"=SUM(J28:J32)"]
[null,null,null,null,null,null,null,null,null,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,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,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,null,null,null,null,null,null,""]
["w",null,null,"Total non-current liabilities",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J36:J37)","v":0},{"$f":"SUM(K36:K37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"=SUM(J36:J37)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,"Total liabilities",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J33,J38)","v":242.13698630136986},{"$f":"SUM(K33,K38)","v":531.14383561643842},431.37205479452064,685.38557377049187,1072.4102301369865,1295.7625250630138,1590.4378870448224,1905.6944855507936,2258.9826244960873,2636.5654533258326,3045.7400610436744,3479.2110063123628,3967.9836255973232,0,0,0,0,0,0,0,"=SUM(J33,J38)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,"Net assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J25-J40","v":154.92508474576249},{"$f":"K25-K40","v":291.90050734833869},1109.0332404200051,2364.0772443098131,3462.2510659099989,5737.7186983959473,8787.3574407749129,12741.157725089492,17766.339122899513,24048.953302451409,31779.670915229559,41152.778040133577,52415.308822881809,0,0,0,0,0,0,0,"=J25-J40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,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,"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,null,null,null,null,null,""]
["w",null,null,null,"Opening retained profits",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=\"\",,IF(J$9=1,'Opening Balance Sheet'!$I$50,I50))","v":0},{"$f":"IF(K$9=\"\",,IF(K$9=1,'Opening Balance Sheet'!$I$50,J50))","v":154.92508474576269},{"$f":"IF(L$9=\"\",,IF(L$9=1,'Opening Balance Sheet'!$I$50,K50))","v":291.9005073483396},{"$f":"IF(M$9=\"\",,IF(M$9=1,'Opening Balance Sheet'!$I$50,L50))","v":1109.0332404200058},{"$f":"IF(N$9=\"\",,IF(N$9=1,'Opening Balance Sheet'!$I$50,M50))","v":2364.0772443098131},{"$f":"IF(O$9=\"\",,IF(O$9=1,'Opening Balance Sheet'!$I$50,N50))","v":3462.2510659099999},{"$f":"IF(P$9=\"\",,IF(P$9=1,'Opening Balance Sheet'!$I$50,O50))","v":5737.7186983959473},{"$f":"IF(Q$9=\"\",,IF(Q$9=1,'Opening Balance Sheet'!$I$50,P50))","v":8787.3574407749111},{"$f":"IF(R$9=\"\",,IF(R$9=1,'Opening Balance Sheet'!$I$50,Q50))","v":12741.157725089492},{"$f":"IF(S$9=\"\",,IF(S$9=1,'Opening Balance Sheet'!$I$50,R50))","v":17766.339122899513},{"$f":"IF(T$9=\"\",,IF(T$9=1,'Opening Balance Sheet'!$I$50,S50))","v":24048.953302451406},{"$f":"IF(U$9=\"\",,IF(U$9=1,'Opening Balance Sheet'!$I$50,T50))","v":31779.670915229552},{"$f":"IF(V$9=\"\",,IF(V$9=1,'Opening Balance Sheet'!$I$50,U50))","v":41152.778040133569},{"$f":"IF(W$9=\"\",,IF(W$9=1,'Opening Balance Sheet'!$I$50,V50))","v":0},{"$f":"IF(X$9=\"\",,IF(X$9=1,'Opening Balance Sheet'!$I$50,W50))","v":0},{"$f":"IF(Y$9=\"\",,IF(Y$9=1,'Opening Balance Sheet'!$I$50,X50))","v":0},{"$f":"IF(Z$9=\"\",,IF(Z$9=1,'Opening Balance Sheet'!$I$50,Y50))","v":0},{"$f":"IF(AA$9=\"\",,IF(AA$9=1,'Opening Balance Sheet'!$I$50,Z50))","v":0},{"$f":"IF(AB$9=\"\",,IF(AB$9=1,'Opening Balance Sheet'!$I$50,AA50))","v":0},{"$f":"IF(AC$9=\"\",,IF(AC$9=1,'Opening Balance Sheet'!$I$50,AB50))","v":0},"=IF(J$9=\"\",,IF(J$9=1,'Opening Balance Sheet'!$I$50,I50))"]
["w",null,null,null,"NPAT",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'Income Statement'!J28","v":154.92508474576269},{"$f":"'Income Statement'!K28","v":136.97542260257688},{"$f":"'Income Statement'!L28","v":817.13273307166617},{"$f":"'Income Statement'!M28","v":1255.0440038898075},{"$f":"'Income Statement'!N28","v":1098.1738216001868},{"$f":"'Income Statement'!O28","v":2275.467632485947},{"$f":"'Income Statement'!P28","v":3049.6387423789647},{"$f":"'Income Statement'!Q28","v":3953.8002843145805},{"$f":"'Income Statement'!R28","v":5025.1813978100226},{"$f":"'Income Statement'!S28","v":6282.6141795518934},{"$f":"'Income Statement'!T28","v":7730.7176127781458},{"$f":"'Income Statement'!U28","v":9373.107124904016},{"$f":"'Income Statement'!V28","v":11262.530782748237},{"$f":"'Income Statement'!W28","v":0},{"$f":"'Income Statement'!X28","v":0},{"$f":"'Income Statement'!Y28","v":0},{"$f":"'Income Statement'!Z28","v":0},{"$f":"'Income Statement'!AA28","v":0},{"$f":"'Income Statement'!AB28","v":0},{"$f":"'Income Statement'!AC28","v":0},"='Income Statement'!J28"]
["w",null,null,null,"Dividends declared",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"Retained profits",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J47:J49)","v":154.92508474576269},{"$f":"SUM(K47:K49)","v":291.9005073483396},1109.0332404200058,2364.0772443098131,3462.2510659099999,5737.7186983959473,8787.3574407749111,12741.157725089492,17766.339122899513,24048.953302451406,31779.670915229552,41152.778040133569,52415.308822881809,0,0,0,0,0,0,0,"=SUM(J47:J49)"]
["w",null,"Total equity",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J46,J50)","v":154.92508474576269},{"$f":"SUM(K46,K50)","v":291.9005073483396},1109.0332404200058,2364.0772443098131,3462.2510659099999,5737.7186983959473,8787.3574407749111,12741.157725089492,17766.339122899513,24048.953302451406,31779.670915229552,41152.778040133569,52415.308822881809,0,0,0,0,0,0,0,"=SUM(J46,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,"Checks",null,null,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(J54),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"PF error check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MAX(J56:AC56)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(J42)-_xlfn.ANCHORARRAY(J51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(K42)-_xlfn.ANCHORARRAY(K51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(L42)-_xlfn.ANCHORARRAY(L51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(M42)-_xlfn.ANCHORARRAY(M51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(N42)-_xlfn.ANCHORARRAY(N51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(O42)-_xlfn.ANCHORARRAY(O51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(P42)-_xlfn.ANCHORARRAY(P51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(Q42)-_xlfn.ANCHORARRAY(Q51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(R42)-_xlfn.ANCHORARRAY(R51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(S42)-_xlfn.ANCHORARRAY(S51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(T42)-_xlfn.ANCHORARRAY(T51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(U42)-_xlfn.ANCHORARRAY(U51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(V42)-_xlfn.ANCHORARRAY(V51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(W42)-_xlfn.ANCHORARRAY(W51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(X42)-_xlfn.ANCHORARRAY(X51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(Y42)-_xlfn.ANCHORARRAY(Y51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(Z42)-_xlfn.ANCHORARRAY(Z51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(AA42)-_xlfn.ANCHORARRAY(AA51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(AB42)-_xlfn.ANCHORARRAY(AB51)),1,0)","v":0},{"$f":"IF(ISERROR(_xlfn.ANCHORARRAY(AC42)-_xlfn.ANCHORARRAY(AC51)),1,0)","v":0},"=IF(ISERROR(J42#-J51#),1,0)"]
["w",null,null,"Balance check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MAX(J57:AC57)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(J56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(J42)-_xlfn.ANCHORARRAY(J51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(K56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(K42)-_xlfn.ANCHORARRAY(K51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(L56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(L42)-_xlfn.ANCHORARRAY(L51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(M56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(M42)-_xlfn.ANCHORARRAY(M51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(N56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(N42)-_xlfn.ANCHORARRAY(N51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(O56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(O42)-_xlfn.ANCHORARRAY(O51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(P56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(P42)-_xlfn.ANCHORARRAY(P51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Q56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(Q42)-_xlfn.ANCHORARRAY(Q51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(R56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(R42)-_xlfn.ANCHORARRAY(R51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(S56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(S42)-_xlfn.ANCHORARRAY(S51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(T56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(T42)-_xlfn.ANCHORARRAY(T51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(U56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(U42)-_xlfn.ANCHORARRAY(U51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(V56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(V42)-_xlfn.ANCHORARRAY(V51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(W56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(W42)-_xlfn.ANCHORARRAY(W51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(X56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(X42)-_xlfn.ANCHORARRAY(X51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Y56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(Y42)-_xlfn.ANCHORARRAY(Y51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Z56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(Z42)-_xlfn.ANCHORARRAY(Z51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AA56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(AA42)-_xlfn.ANCHORARRAY(AA51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AB56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(AB42)-_xlfn.ANCHORARRAY(AB51),Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AC56)<>0,0,(ROUND(_xlfn.ANCHORARRAY(AC42)-_xlfn.ANCHORARRAY(AC51),Rounding_Accuracy)<>0)*1)","v":0},"=IF(J56#<>0,0,(ROUND(J42#-J51#,Rounding_Accuracy)<>0)*1)"]
["w",null,null,"Insolvency check",null,null,{"$f":"Boolean","v":"[1,0]"},null,0,{"$f":"IF(_xlfn.ANCHORARRAY(J56)+_xlfn.ANCHORARRAY(J57)<>0,0,(_xlfn.ANCHORARRAY(J42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(K56)+_xlfn.ANCHORARRAY(K57)<>0,0,(_xlfn.ANCHORARRAY(K42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(L56)+_xlfn.ANCHORARRAY(L57)<>0,0,(_xlfn.ANCHORARRAY(L42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(M56)+_xlfn.ANCHORARRAY(M57)<>0,0,(_xlfn.ANCHORARRAY(M42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(N56)+_xlfn.ANCHORARRAY(N57)<>0,0,(_xlfn.ANCHORARRAY(N42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(O56)+_xlfn.ANCHORARRAY(O57)<>0,0,(_xlfn.ANCHORARRAY(O42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(P56)+_xlfn.ANCHORARRAY(P57)<>0,0,(_xlfn.ANCHORARRAY(P42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Q56)+_xlfn.ANCHORARRAY(Q57)<>0,0,(_xlfn.ANCHORARRAY(Q42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(R56)+_xlfn.ANCHORARRAY(R57)<>0,0,(_xlfn.ANCHORARRAY(R42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(S56)+_xlfn.ANCHORARRAY(S57)<>0,0,(_xlfn.ANCHORARRAY(S42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(T56)+_xlfn.ANCHORARRAY(T57)<>0,0,(_xlfn.ANCHORARRAY(T42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(U56)+_xlfn.ANCHORARRAY(U57)<>0,0,(_xlfn.ANCHORARRAY(U42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(V56)+_xlfn.ANCHORARRAY(V57)<>0,0,(_xlfn.ANCHORARRAY(V42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(W56)+_xlfn.ANCHORARRAY(W57)<>0,0,(_xlfn.ANCHORARRAY(W42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(X56)+_xlfn.ANCHORARRAY(X57)<>0,0,(_xlfn.ANCHORARRAY(X42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Y56)+_xlfn.ANCHORARRAY(Y57)<>0,0,(_xlfn.ANCHORARRAY(Y42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Z56)+_xlfn.ANCHORARRAY(Z57)<>0,0,(_xlfn.ANCHORARRAY(Z42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AA56)+_xlfn.ANCHORARRAY(AA57)<>0,0,(_xlfn.ANCHORARRAY(AA42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AB56)+_xlfn.ANCHORARRAY(AB57)<>0,0,(_xlfn.ANCHORARRAY(AB42)<0)*1)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(AC56)+_xlfn.ANCHORARRAY(AC57)<>0,0,(_xlfn.ANCHORARRAY(AC42)<0)*1)","v":0},"=IF(J56#+J57#<>0,0,(J42#<0)*1)"]

{"sheet":"Cash Flow Statement","index":9,"n_rows":36,"n_cols":30,"rows_kept":36,"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":"Cash Flow Statement"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(Timing!J5)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J6)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J7)","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J8)","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(Timing!J9)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Cash Flow Statement"}]
[]
[null,null,"Direct Cash Flow Statement"]
[]
[null,null,null,"Operating cash flow",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J15),\"\")","v":""}]
[null,null,null,null,"Cash receipts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(Calculations!J37)","v":1253.4246575342465},2828.6301369863013,4535.9506849315076,6434.6332090725355,8578.2714758589718,10974.21244471233,13623.37890148603,16558.591347263908,19773.107204033811,23338.577886145373,27252.122752260049,31565.767065141168,36253.72307080475,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(J16),\"\")","v":"=-Calculations!J37#"}]
[null,null,null,null,null,"Direct cash payments",{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J63)+_xlfn.ANCHORARRAY(Calculations!J90)","v":-1803.8630136986303},-4319.2431506849316,-2455.8917808219185,-4058.554481024029,-7295.5279436335059,-8717.3446122739733,-10616.127179922192,-12710.33430940059,-14939.021393733281,-17341.18817632502,-19904.220084292614,-22651.78048040159,-25555.338751193074,null,null,null,null,null,null,null,"=Calculations!J63#+Calculations!J90#"]
[null,null,null,null,null,"Indirect cash payments",{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(Calculations!J172)","v":-60},-65,-67.600000000000009,-69.628000000000014,-71.020560000000017,-71.730765600000012,-72.448073256000015,-73.172553988560011,-73.904279528445613,-74.643322323730075,-75.389755546967379,-76.143653102437057,-76.905089633461429,null,null,null,null,null,null,null,"=Calculations!J172#"]
[null,null,null,null,"Cash payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J17)+_xlfn.ANCHORARRAY(J18)","v":-1863.8630136986303},-4384.2431506849316,-2523.4917808219184,-4128.1824810240287,-7366.5485036335058,-8789.0753778739727,-10688.575253178193,-12783.50686338915,-15012.925673261727,-17415.831498648749,-19979.609839839581,-22727.924133504028,-25632.243840826537,null,null,null,null,null,null,null,"=J17#+J18#"]
[null,null,null,null,"Interest paid",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Tax paid",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,null,"Net operating cash flow",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J16,J19:J21)","v":-610.43835616438378},{"$f":"SUM(K16,K19:K21)","v":-1555.6130136986303},2012.4589041095892,2306.4507280485068,1211.722972225466,2185.137066838357,2934.8036483078376,3775.084483874758,4760.1815307720844,5922.7463874966234,7272.5129124204686,8837.8429316371403,10621.479229978213,0,0,0,0,0,0,0,"=SUM(J16,J19:J21)"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,""]
[null,null,null,null,"Purchases of non-current assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-_xlfn.ANCHORARRAY(Calculations!J200)","v":-150},-180,-120,-90,-100,-150,-180,-120,-90,-100,-150,-180,-120,null,null,null,null,null,null,null,"=-Calculations!J200#"]
[null,null,null,null,"Net investing cash flows",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"_xlfn.ANCHORARRAY(J25)","v":-150},-180,-120,-90,-100,-150,-180,-120,-90,-100,-150,-180,-120,null,null,null,null,null,null,null,"=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,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,null,null,null,null,""]
[null,null,null,null,"Debt drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,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 repayments",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Ordinary equity issuances",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Ordinary equity buybacks",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Dividends paid",null,{"$f":"Currency","v":"US$'000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,null,"Net financing cash flows",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J29:J33)","v":0},{"$f":"SUM(K29:K33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"=SUM(J29:J33)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["w",null,null,"Net increase / (decrease) in cash held",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J22,J26,J34)","v":-760.43835616438378},{"$f":"SUM(K22,K26,K34)","v":-1735.6130136986303},1892.4589041095892,2216.4507280485068,1111.722972225466,2035.137066838357,2754.8036483078376,3655.084483874758,4670.1815307720844,5822.7463874966234,7122.5129124204686,8657.8429316371403,10501.479229978213,0,0,0,0,0,0,0,"=SUM(J22,J26,J34)"]

{"sheet":"Timing","index":10,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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 10 - Capital Expenditure 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":"_xlfn.ANCHORARRAY(J$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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(_xlfn.ANCHORARRAY(J$9)=1,Model_Start_Date,OFFSET(_xlfn.ANCHORARRAY(J7),,-1)+1)","v":"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","2033-07-01","2034-07-01","2035-07-01","2036-07-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(Model_Start_Date,\nMOD(Periodicity+Reporting_Month_Factor\n-MONTH(Model_Start_Date),Periodicity)+Periodicity*(_xlfn.ANCHORARRAY(J$9)-1))","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","2034-06-30","2035-06-30","2036-06-30","2037-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(J7)-_xlfn.ANCHORARRAY(J6)+1","v":365},365,365,366,365,365,365,366,365,365,365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"_xlfn.SEQUENCE(1,Number_of_Periods)","v":1},2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Number of Periods",null,null,null,13,null,null,"Number_of_Periods"]
[]
[null,null,null,"Model Start Date",null,null,null,"2024-07-01",null,null,"Model_Start_Date"]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12,null,null,"Periodicity"]
[]
[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-25"},null,"Example_Reporting_Month"]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":6},null,null,"Reporting_Month_Factor"]

{"sheet":"Lookup","index":11,"n_rows":23,"n_cols":7,"rows_kept":23,"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":"Lookup"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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":"Lookup"}]
[]
[null,null,"Year Lookups"]
[]
[null,null,null,"LU_Future_Years"]
[null,null,null,{"$f":"IF(_xlfn.SEQUENCE(Number_of_Periods)=1,\n\"Actuals Throughout\",TRANSPOSE(_xlfn.ANCHORARRAY(Timing!J7)))","v":"Actuals Throughout"},null,"LU_Future_Years",{"$f":"_xlfn.FORMULATEXT(D11)","v":"=IF(SEQUENCE(Number_of_Periods)=1,\n\"Actuals Throughout\",TRANSPOSE(Timing!J7#))"}]
[null,null,null,"2026-06-30"]
[null,null,null,"2027-06-30"]
[null,null,null,"2028-06-30"]
[null,null,null,"2029-06-30"]
[null,null,null,"2030-06-30"]
[null,null,null,"2031-06-30"]
[null,null,null,"2032-06-30"]
[null,null,null,"2033-06-30"]
[null,null,null,"2034-06-30"]
[null,null,null,"2035-06-30"]
[null,null,null,"2036-06-30"]
[null,null,null,"2037-06-30"]

{"sheet":"Template Sheet","index":12,"n_rows":10,"n_cols":9,"rows_kept":10,"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":"Template Sheet"}]
[{"$f":"Model_Name","v":"Model 10 - Capital Expenditure 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},"First Section"]
[]
[null,null,"Heading"]
[]
[null,null,null,"Sub Heading"]

{"sheet":"Error Checks","index":13,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,8,0,9],[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 10 - Capital Expenditure 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,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MAX(I12:I24)","v":0}]