{"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","Error Checks","Timing","Lookup","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"Example"}]
[null,null,{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple financial model example to highlight key concepts."]
[]
[]
[]
[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":[[2,0,2,2]]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Navigator"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,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,"Error Checks"]
[null,null,null,null,null,"Timing"]
[null,null,null,null,null,"Lookup"]
[null,null,null,null,null,"Change Log"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Style Guide"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,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":"'Error Checks'!E16","v":"Balance Sheet - balances"},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,{"$f":"Currency","v":"US$'000"},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":"2018-07-04"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2018-07-04"},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":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,9,0,10],[11,6,11,13],[12,6,12,13]]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
[{"$f":"Timing!A4","v":"Error Checks:"},null,null,null,null,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":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1),””)","v":"Chapter 10.10 - Taxation.xlsm"}]
[null,null,null,null,"Client Name",null,"Example"]
[]
[]
[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,"Days_in_Year"]
[null,null,null,null,"Months in Month",null,1,null,"Months_in_Month"]
[null,null,null,null,"Months in Quarter",null,3,null,"Months_in_Qtr"]
[null,null,null,null,"Months in Half Yr",null,6,null,"Months_in_Half_Yr"]
[null,null,null,null,"Months in Year",null,12,null,"Months_in_Year"]
[null,null,null,null,"Quarters in Year",null,4,null,"Quarters_in_Year"]
[]
[null,null,null,null,"Rounding Accuracy",null,5,null,"Rounding_Accuracy"]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98,null,"Very_Large_Number"]
[null,null,null,null,"Very Small Number",null,1E-8,null,"Very_Small_Number"]
[]
[null,null,null,null,"Thousand",null,1000,null,"Thousand"]
[]
[]
[null,{"$f":"MAX($B$5:$B34)+1","v":3},"Technical assumptions"]
[]
[null,null,"Model Information"]
[]
[null,null,null,null,"Start Date",null,{"$f":"Model_Start_Date","v":"2020-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,"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,"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":127,"n_cols":14,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"General Assumptions"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
[{"$f":"Timing!A4","v":"Error Checks:"},null,null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2021-06-30"},{"$f":"Timing!K5","v":"2022-06-30"},{"$f":"Timing!L5","v":"2023-06-30"},{"$f":"Timing!M5","v":"2024-06-30"},{"$f":"Timing!N5","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-07-01"},{"$f":"Timing!K6","v":"2021-07-01"},{"$f":"Timing!L6","v":"2022-07-01"},{"$f":"Timing!M6","v":"2023-07-01"},{"$f":"Timing!N6","v":"2024-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2021-06-30"},{"$f":"Timing!K7","v":"2022-06-30"},{"$f":"Timing!L7","v":"2023-06-30"},{"$f":"Timing!M7","v":"2024-06-30"},{"$f":"Timing!N7","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"General Assumptions"}]
[]
[null,null,"Revenue and Related"]
[]
[null,null,null,"Revenue"]
[]
[null,null,null,null,"Revenue First Year",null,{"$f":"Currency","v":"US$'000"},null,null,400]
[null,null,null,null,"Revenue Growth Rate",null,{"$f":"Percentage","v":"%"},null,null,null,0.12,0.1,0.08,0.05]
[]
[null,null,null,"Working Capital"]
[]
[null,null,null,null,"Days Receivable ",null,{"$f":"No_of_Days","v":"# Days"},null,null,60,60,60,60,60]
[]
[]
[null,null,"COGS and Related"]
[]
[null,null,null,"COGS"]
[]
[null,null,null,null,"Gross Margin",null,{"$f":"Percentage","v":"%"},null,null,0.7,0.7,0.7,0.7,0.7]
[]
[null,null,null,{"$f":"D20","v":"Working Capital"}]
[]
[null,null,null,null,"Days Payable",null,{"$f":"No_of_Days","v":"# Days"},null,null,90,90,90,90,90]
[]
[]
[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,"Year",null,"2023-06-30"]
[null,null,null,null,"Amounts",null,{"$f":"Currency","v":"US$'000"},null,null,60,65,70,75,80]
[null,null,null,null,"Growth Rates ",null,{"$f":"Percentage","v":"%"},null,null,null,0.05,0.04,0.03,0.02]
[]
[]
[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]
[]
[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(I54<=0,0,1/I54)","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,{"$f":"E55","v":"Annual Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"IF(I57<=0,0,1/I57)","v":0.25}]
[]
[]
[null,null,"Debt and Related"]
[null,null,"Movements are assumed to occur ar the end of each period."]
[null,null,"Interest is assumed to be paid in the following period."]
[]
[null,null,null,"Debt"]
[]
[null,null,null,null,"Debt Drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,20,20,0,0,0]
[null,null,null,null,"Debt Repayments",null,{"$f":"Currency","v":"US$'000"},null,null,0,0,15,25,10]
[]
[null,null,null,"Interest "]
[]
[null,null,null,null,"Interest Rate",null,{"$f":"Percentage","v":"%"},null,null,0.06,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,0.08]
[]
[null,null,null,"Interest Receivable ",null,null,{"$f":"Percentage","v":"%"}]
[]
[null,null,null,null,"Interest Receivable Rate",null,{"$f":"Percentage","v":"%"},null,null,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,null,"Proportion into Period of Movement ",null,{"$f":"Percentage","v":"%"},null,0.5]
[]
[]
[null,null,"Taxation "]
[]
[null,null,null,"Tax Rate"]
[]
[null,null,null,null,{"$f":"D83","v":"Tax Rate"},null,{"$f":"Percentage","v":"%"},null,0.3]
[]
[null,null,null,"Permanent Differences"]
[]
[null,null,null,null,"Non-Assessable Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,25,25,25,25,25]
[null,null,null,null,"Disallowable Expenses",null,{"$f":"Currency","v":"US$'000"},null,null,40,16,25,30,50]
[]
[null,null,null,"Tax Depreciation (Declining Balance)"]
[]
[null,null,null,null,"Declining Balance Multiplier",null,{"$f":"Multiplier","v":"x"},null,2]
[]
[null,null,null,null,"Remaining Life of Tax Assets",null,{"$f":"No_of_Years","v":"# Year(s)"},null,5]
[null,null,null,null,{"$f":"E55","v":"Annual Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"IF(I96<=0,0,I94/I96)","v":0.4}]
[]
[null,null,null,null,"Tax Asset Life of New Capex",null,{"$f":"No_of_Years","v":"# Year(s)"},null,4]
[null,null,null,null,{"$f":"E58","v":"Annual Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"IF(I99<=0,0,I94/I99)","v":0.5}]
[]
[null,null,null,"DTA"]
[null,null,null,"DTAs are assumed to arise through losses carried forward."]
[]
[null,null,null,null,{"$f":"D102","v":"DTA"},null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I21","v":0}]
[]
[null,null,null,"DTL"]
[null,null,null,"DTLs are assumed to arise through depreciation timing differences."]
[]
[null,null,null,null,{"$f":"D107","v":"DTL"},null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I36","v":0}]
[]
[null,null,null,"Tax Payable and Paid"]
[]
[null,null,null,null,"Payment Delay",null,{"$f":"No_of_Years","v":"# Year(s)"},null,1]
[]
[]
[null,null,"Ordinary Equity and Related "]
[]
[null,null,null,"Ordinary Equity "]
[]
[null,null,null,null,"Equity Issuances ",null,{"$f":"Currency","v":"US$'000"},null,null,15,25,0,10,0]
[null,null,null,null,"Equity Buybacks",null,{"$f":"Currency","v":"US$'000"},null,null,0,0,5,5,20]
[]
[null,null,null,"Dividends"]
[null,null,null,"Dividends are assumed to be paid in the period after they are declared."]
[]
[null,null,null,null,"Dividend Payout Ratio ",null,{"$f":"Percentage","v":"%"},null,null,0.25,0.3,0.35,0.4,0.45]

{"sheet":"Calculations","index":5,"n_rows":283,"n_cols":16,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Calculations"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
[{"$f":"Timing!A4","v":"Error Checks:"},null,null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2021-06-30"},{"$f":"Timing!K5","v":"2022-06-30"},{"$f":"Timing!L5","v":"2023-06-30"},{"$f":"Timing!M5","v":"2024-06-30"},{"$f":"Timing!N5","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-07-01"},{"$f":"Timing!K6","v":"2021-07-01"},{"$f":"Timing!L6","v":"2022-07-01"},{"$f":"Timing!M6","v":"2023-07-01"},{"$f":"Timing!N6","v":"2024-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2021-06-30"},{"$f":"Timing!K7","v":"2022-06-30"},{"$f":"Timing!L7","v":"2023-06-30"},{"$f":"Timing!M7","v":"2024-06-30"},{"$f":"Timing!N7","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Calculations"}]
[]
[null,null,"Revenue and Related "]
[]
[null,null,null,"Revenue"]
[]
[null,null,null,null,"Revenue First Year",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J17","v":400}]
[null,null,null,null,"Revenue Growth Rate",null,{"$f":"Percentage","v":"%"},null,null,null,{"$f":"'General Assumptions'!K18","v":0.12},{"$f":"'General Assumptions'!L18","v":0.1},{"$f":"'General Assumptions'!M18","v":0.08},{"$f":"'General Assumptions'!N18","v":0.05}]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=1,$J17,I19*(1+J18))","v":400},{"$f":"IF(K$9=1,$J17,J19*(1+K18))","v":448.00000000000006},492.80000000000013,532.22400000000016,558.83520000000021]
[]
[null,null,null,"Working Capital"]
[]
[null,null,null,null,"Days Receivable",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"'General Assumptions'!J22","v":60},60,60,60,60]
[]
[null,null,null,null,"Days in Period",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365]
[]
[null,null,null,null,"Closing Receivables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J23/J25*J19","v":65.753424657534239},{"$f":"K23/K25*K19","v":73.643835616438366},{"$f":"L23/L25*L19","v":81.008219178082214},{"$f":"M23/M25*M19","v":87.249836065573788},{"$f":"N23/N25*N19","v":91.863320547945236}]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,"Opening Receivables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I34","v":0},{"$f":"J34","v":65.753424657534239},73.643835616438366,81.008219178082214,87.249836065573788,{"$f":"Balance_Sheet","v":"BS"}]
[null,null,null,null,"Revenue ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J19","v":400},{"$f":"K19","v":448.00000000000006},492.80000000000013,532.22400000000016,558.83520000000021,{"$f":"Income_Statement","v":"IS"}]
[null,null,null,null,"Cash Receipts ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J34-SUM(J31:J32)","v":-334.24657534246575},{"$f":"K34-SUM(K31:K32)","v":-440.10958904109594},-485.43561643835631,-525.98238311250861,-554.22171551762881,{"$f":"Cash_Flow_Statement","v":"CFS"}]
[null,null,null,null,"Closing Receivables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!$I$15","v":0},{"$f":"J27","v":65.753424657534239},{"$f":"K27","v":73.643835616438366},81.008219178082214,87.249836065573788,91.863320547945236,{"$f":"Balance_Sheet","v":"BS"}]
[]
[]
[null,null,"COGS and Related"]
[]
[null,null,null,"COGS"]
[]
[null,null,null,null,"Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J19","v":400},{"$f":"K19","v":448.00000000000006},492.80000000000013,532.22400000000016,558.83520000000021,null,{"$f":"_xlfn.FORMULATEXT(J41)","v":"=J19"}]
[null,null,null,null,"Gross Margin",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"'General Assumptions'!J29","v":0.7},{"$f":"'General Assumptions'!K29","v":0.7},{"$f":"'General Assumptions'!L29","v":0.7},{"$f":"'General Assumptions'!M29","v":0.7},{"$f":"'General Assumptions'!N29","v":0.7},null,{"$f":"_xlfn.FORMULATEXT(J42)","v":"='General Assumptions'!J29"}]
[null,null,null,null,"Gross Profit",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J41*J42","v":280},{"$f":"K41*K42","v":313.60000000000002},344.96000000000009,372.55680000000007,391.18464000000012,null,"=J41*J42"]
[]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J41-J43","v":120},{"$f":"K41-K43","v":134.40000000000003},147.84000000000003,159.66720000000009,167.6505600000001,null,"=J41-J43"]
[]
[null,null,null,"Working Capital"]
[]
[null,null,null,null,"Days Payable",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"'General Assumptions'!J33","v":90},{"$f":"'General Assumptions'!K33","v":90},{"$f":"'General Assumptions'!L33","v":90},{"$f":"'General Assumptions'!M33","v":90},{"$f":"'General Assumptions'!N33","v":90},null,"='General Assumptions'!J33"]
[]
[null,null,null,null,"Days in Period",null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365,null,"=J$8"]
[]
[null,null,null,null,"Closing Payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J49/J51*J45","v":29.589041095890408},{"$f":"K49/K51*K45","v":33.139726027397266},{"$f":"L49/L51*L45","v":36.453698630136991},{"$f":"M49/M51*M45","v":39.262426229508222},{"$f":"N49/N51*N45","v":41.338494246575365},null,"=J49/J51*J45"]
[]
[null,null,null,{"$f":"D29","v":"Control Account"}]
[]
[null,null,null,null,"Opening Payables",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I60","v":0},{"$f":"J60","v":29.589041095890408},{"$f":"K60","v":33.139726027397266},{"$f":"L60","v":36.453698630136991},{"$f":"M60","v":39.262426229508222},{"$f":"Balance_Sheet","v":"BS"},"=I60"]
[null,null,null,null,"COGS",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J45","v":120},{"$f":"K45","v":134.40000000000003},147.84000000000003,159.66720000000009,167.6505600000001,{"$f":"Income_Statement","v":"IS"},"=J45"]
[null,null,null,null,"Cash Payments",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J60-SUM(J57:J58)","v":-90.410958904109592},{"$f":"K60-SUM(K57:K58)","v":-130.84931506849318},-144.52602739726032,-156.85847240062884,-165.57449198293295,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J60-SUM(J57:J58)"]
[null,null,null,null,"Closing Payables",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I27","v":0},{"$f":"J53","v":29.589041095890408},{"$f":"K53","v":33.139726027397266},36.453698630136991,39.262426229508222,41.338494246575365,{"$f":"Balance_Sheet","v":"BS"},"=J53"]
[]
[]
[null,null,{"$f":"'General Assumptions'!C36","v":"Opex and Cash Payments"}]
[null,null,{"$f":"'General Assumptions'!C37","v":"All expenses are assumed to be paid as they are incurred."}]
[]
[null,null,null,{"$f":"'General Assumptions'!D39","v":"Opex"}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E41","v":"Growth Rates Used From"},null,{"$f":"Year","v":"Year"},null,{"$f":"'General Assumptions'!I41","v":"2023-06-30"},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I68)","v":"='General Assumptions'!I41"}]
[null,null,null,null,"Growth Rates Flag",null,{"$f":"Boolean","v":"[1,0]"},null,null,{"$f":"($I68<=J$7)*1","v":0},{"$f":"($I68<=K$7)*1","v":0},1,1,1,null,{"$f":"_xlfn.FORMULATEXT(J69)","v":"=($I68<=J$7)*1"}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E42","v":"Amounts"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J42","v":60},{"$f":"'General Assumptions'!K42","v":65},{"$f":"'General Assumptions'!L42","v":70},{"$f":"'General Assumptions'!M42","v":75},{"$f":"'General Assumptions'!N42","v":80},null,{"$f":"_xlfn.FORMULATEXT(J71)","v":"='General Assumptions'!J42"}]
[null,null,null,null,{"$f":"'General Assumptions'!E43","v":"Growth Rates "},null,{"$f":"Percentage","v":"%"},null,null,null,{"$f":"'General Assumptions'!K43","v":0.05},{"$f":"'General Assumptions'!L43","v":0.04},{"$f":"'General Assumptions'!M43","v":0.03},{"$f":"'General Assumptions'!N43","v":0.02},null,"In cell K72: ='General Assumptions'!K43"]
[]
[null,null,null,null,"Opex",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"(1-J69)*J71+(J69*I74*(1+J72))","v":60},{"$f":"(1-K69)*K71+(K69*J74*(1+K72))","v":65},67.600000000000009,69.628000000000014,71.020560000000017,null,"=(1-J69)*J71+(J69*I74*(1+J72))"]
[]
[null,null,null,{"$f":"D47","v":"Working Capital"}]
[]
[null,null,null,null,{"$f":"E49","v":"Days Payable"},null,{"$f":"No_of_Days","v":"# Days"}]
[]
[null,null,null,null,{"$f":"E51","v":"Days in Period"},null,{"$f":"No_of_Days","v":"# Days"},null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365,null,"=J$8"]
[]
[null,null,null,null,{"$f":"E53","v":"Closing Payables"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J78/J80*J74","v":0},{"$f":"K78/K80*K74","v":0},{"$f":"L78/L80*L74","v":0},{"$f":"M78/M80*M74","v":0},{"$f":"N78/N80*N74","v":0},null,"=J78/J80*J74"]
[]
[null,null,null,{"$f":"D55","v":"Control Account"}]
[]
[null,null,null,null,{"$f":"E57","v":"Opening Payables"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I89","v":0},{"$f":"J89","v":0},0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=I89"]
[null,null,null,null,"Opex",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J74","v":60},{"$f":"K74","v":65},67.600000000000009,69.628000000000014,71.020560000000017,{"$f":"Income_Statement","v":"IS"},"=J74"]
[null,null,null,null,{"$f":"E59","v":"Cash Payments"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J89-SUM(J86:J87)","v":-60},{"$f":"K89-SUM(K86:K87)","v":-65},{"$f":"L89-SUM(L86:L87)","v":-67.600000000000009},{"$f":"M89-SUM(M86:M87)","v":-69.628000000000014},{"$f":"N89-SUM(N86:N87)","v":-71.020560000000017},{"$f":"Cash_Flow_Statement","v":"CFS"},"=J89-SUM(J86:J87)"]
[null,null,null,null,{"$f":"E60","v":"Closing Payables"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J82","v":0},{"$f":"K82","v":0},0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=J82"]
[]
[]
[null,null,{"$f":"'General Assumptions'!C46","v":"Capex and Related"}]
[]
[null,null,null,{"$f":"'General Assumptions'!D48","v":"Capital Expenditure "}]
[]
[null,null,null,null,"Existing Assets",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I20","v":0},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I96)","v":"='Opening Balance Sheet'!I20"}]
[null,null,null,null,{"$f":"'General Assumptions'!E50","v":"Capital Expenditure "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J50","v":150},{"$f":"'General Assumptions'!K50","v":180},{"$f":"'General Assumptions'!L50","v":120},{"$f":"'General Assumptions'!M50","v":90},{"$f":"'General Assumptions'!N50","v":100},null,{"$f":"_xlfn.FORMULATEXT(J97)","v":"='General Assumptions'!J50"}]
[]
[null,null,null,{"$f":"'General Assumptions'!D52","v":"Accounting Depreciation - Straight Line"}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E54","v":"Remaining Life of Existing Assets"},null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I54","v":5},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I101)","v":"='General Assumptions'!I54"}]
[null,null,null,null,{"$f":"'General Assumptions'!E55","v":"Annual Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I55","v":0.2},null,null,null,null,null,null,"='General Assumptions'!I55"]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E57","v":"Economic Life of New Capex"},null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I57","v":4},null,null,null,null,null,null,"='General Assumptions'!I57"]
[null,null,null,null,{"$f":"'General Assumptions'!E58","v":"Annual Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I58","v":0.25},null,null,null,null,null,null,"='General Assumptions'!I58"]
[]
[null,null,null,null,"Depreciation - Existing Assets",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I96*I102","v":0},null,null,null,null,null,null,"=I96*I102"]
[null,null,null,null,"Depreciation - New Assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"$I105*J97","v":37.5},{"$f":"$I105*K97","v":45},30,22.5,25,null,{"$f":"_xlfn.FORMULATEXT(J108)","v":"=$I105*J97"}]
[]
[null,null,null,null,"New Assets - Depreciation Counter",null,{"$f":"Unit","v":"#"},null,null,{"$f":"MIN(J$9,$I104)","v":1},{"$f":"MIN(K$9,$I104)","v":2},3,4,4,null,{"$f":"_xlfn.FORMULATEXT(J110)","v":"=MIN(J$9,$I104)"}]
[]
[null,null,null,null,"Aggregate Depreciation - Existing Assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9<=$I101,$I107,0)","v":0},{"$f":"IF(K$9<=$I101,$I107,0)","v":0},0,0,0,null,"=IF(J$9<=$I101,$I107,0)"]
[null,null,null,null,"Aggregate Depreciation - New Assets ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(OFFSET(J108,0,0,1,-J110))","v":37.5},{"$f":"SUM(OFFSET(K108,0,0,1,-K110))","v":82.5},112.5,135,122.5,null,"=SUM(OFFSET(J108,0,0,1,-J110))"]
[null,null,null,null,"Total Depreciation ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J112:J113)","v":37.5},{"$f":"SUM(K112:K113)","v":82.5},112.5,135,122.5,null,"=SUM(J112:J113)"]
[]
[null,null,null,{"$f":"D84","v":"Control Account"}]
[]
[null,null,null,null,"Opening Net Book Value",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I121","v":0},{"$f":"J121","v":112.5},210,217.5,{"$f":"M121","v":172.5},{"$f":"Balance_Sheet","v":"BS"},"=I121"]
[null,null,null,null,{"$f":"E97","v":"Capital Expenditure "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J97","v":150},{"$f":"K97","v":180},120,90,100,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J97"]
[null,null,null,null,{"$f":"E114","v":"Total Depreciation "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J114","v":-37.5},{"$f":"-K114","v":-82.5},-112.5,-135,-122.5,{"$f":"Income_Statement","v":"IS"},"=-J114"]
[null,null,null,null,"Closing Net Book Value",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I96","v":0},{"$f":"SUM(J118:J120)","v":112.5},{"$f":"SUM(K118:K120)","v":210},217.5,172.5,150,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J118:J120)"]
[]
[]
[null,null,{"$f":"'General Assumptions'!C61","v":"Debt and Related"}]
[null,null,{"$f":"'General Assumptions'!C62","v":"Movements are assumed to occur ar the end of each period."}]
[null,null,{"$f":"'General Assumptions'!C63","v":"Interest is assumed to be paid in the following period."}]
[]
[null,null,null,{"$f":"'General Assumptions'!D65","v":"Debt"}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E67","v":"Debt Drawdowns"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J67","v":20},{"$f":"'General Assumptions'!K67","v":20},{"$f":"'General Assumptions'!L67","v":0},{"$f":"'General Assumptions'!M67","v":0},{"$f":"'General Assumptions'!N67","v":0}]
[null,null,null,null,{"$f":"'General Assumptions'!E68","v":"Debt Repayments"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J68","v":0},{"$f":"'General Assumptions'!K68","v":0},{"$f":"'General Assumptions'!L68","v":15},{"$f":"'General Assumptions'!M68","v":25},{"$f":"'General Assumptions'!N68","v":10}]
[]
[null,null,null,{"$f":"D116","v":"Control Account"}]
[]
[null,null,null,null,"Opening Debt",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I138","v":0},{"$f":"J138","v":20},40,25,0,{"$f":"Balance_Sheet","v":"BS"}]
[null,null,null,null,{"$f":"E130","v":"Debt Drawdowns"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J130","v":20},{"$f":"K130","v":20},0,0,0,{"$f":"Cash_Flow_Statement","v":"CFS"}]
[null,null,null,null,{"$f":"E131","v":"Debt Repayments"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J131","v":0},{"$f":"-K131","v":0},-15,-25,-10,{"$f":"Cash_Flow_Statement","v":"CFS"}]
[null,null,null,null,"Closing Debt",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I35","v":0},{"$f":"SUM(J135:J137)","v":20},{"$f":"SUM(K135:K137)","v":40},25,0,-10,{"$f":"Balance_Sheet","v":"BS"}]
[]
[null,null,null,{"$f":"'General Assumptions'!D70","v":"Interest "}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E72","v":"Interest Rate"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"'General Assumptions'!J72","v":0.06},{"$f":"'General Assumptions'!K72","v":6.5000000000000002E-2},{"$f":"'General Assumptions'!L72","v":7.0000000000000007E-2},{"$f":"'General Assumptions'!M72","v":7.4999999999999997E-2},{"$f":"'General Assumptions'!N72","v":0.08},null,{"$f":"_xlfn.FORMULATEXT(J142)","v":"='General Assumptions'!J72"}]
[]
[null,null,null,null,{"$f":"E135","v":"Opening Debt"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J135","v":0},{"$f":"K135","v":20},40,25,0,null,"=J135"]
[]
[null,null,null,null,"Days in Period",null,{"$f":"Unit","v":"#"},null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365,null,"=J$8"]
[null,null,null,null,"Days in Standard Year",null,{"$f":"Unit","v":"#"},null,null,{"$f":"Days_in_Yr","v":365},{"$f":"Days_in_Yr","v":365},{"$f":"Days_in_Yr","v":365},{"$f":"Days_in_Yr","v":365},{"$f":"Days_in_Yr","v":365},null,"=Days_in_Yr"]
[null,null,null,null,"Proportion of Year",null,{"$f":"Percentage","v":"%"},null,null,{"$f":"MIN(J146/J147,1)","v":1},{"$f":"MIN(K146/K147,1)","v":1},1,1,1,null,"=MIN(J146/J147,1)"]
[]
[null,null,null,null,{"$f":"D140","v":"Interest "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J144*J142*J148","v":0},{"$f":"K144*K142*K148","v":1.3},2.8000000000000003,1.875,0,null,"=J144*J142*J148"]
[]
[null,null,null,{"$f":"D116","v":"Control Account"}]
[]
[null,null,null,null,"Opening Interest Payable",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I157","v":0},{"$f":"J157","v":0},1.3,2.8000000000000007,1.875,{"$f":"Balance_Sheet","v":"BS"},"=I157"]
[null,null,null,null,"Interest Expense",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J150","v":0},{"$f":"K150","v":1.3},2.8000000000000003,1.875,0,{"$f":"Income_Statement","v":"IS"},"=J150"]
[null,null,null,null,"Interest Paid",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J154","v":0},0,-1.3,-2.8000000000000007,-1.875,{"$f":"Cash_Flow_Statement","v":"CFS"},"=-J154"]
[null,null,null,null,"Closing Interest Payable",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I28","v":0},{"$f":"SUM(J154:J156)","v":0},{"$f":"SUM(K154:K156)","v":1.3},2.8000000000000007,1.875,0,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J154:J156)"]
[]
[]
[null,null,"Interest Receivable"]
[]
[null,null,null,null,"Interest Receivable Rate",null,"%",null,null,{"$f":"'General Assumptions'!J76","v":0.01},{"$f":"'General Assumptions'!K76","v":0.01},{"$f":"'General Assumptions'!L76","v":0.01},{"$f":"'General Assumptions'!M76","v":0.01},{"$f":"'General Assumptions'!N76","v":0.01},null,"='General Assumptions'!J76"]
[]
[null,null,null,null,"Proportion into Period of Movement",null,"%",null,{"$f":"'General Assumptions'!I78","v":0.5},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I164)","v":"='General Assumptions'!I78"}]
[]
[null,null,null,null,"Opening Cash Balance",null,"A$'000",null,null,{"$f":"IF(J$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!I$14)","v":0},{"$f":"IF(K$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!J$14)","v":53.835616438356169},{"$f":"IF(L$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!K$14)","v":90.28497687110368},{"$f":"IF(M$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!L$14)","v":194.55981091398831},{"$f":"IF(N$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!M$14)","v":332.01064488952977},null,"=IF(J$9=1,'Opening Balance Sheet'!$I$14,'Balance Sheet'!I$14)"]
[null,null,null,null,"Non-Interest Cash Movement",null,"A$'000",null,null,{"$f":"'Cash Flow Statement'!J22+'Cash Flow Statement'!J26+'Cash Flow Statement'!J35","v":53.835616438356169},{"$f":"'Cash Flow Statement'!K22+'Cash Flow Statement'!K26+'Cash Flow Statement'!K35","v":36.179236918255015},{"$f":"'Cash Flow Statement'!L22+'Cash Flow Statement'!L26+'Cash Flow Statement'!L35","v":103.55305546890085},{"$f":"'Cash Flow Statement'!M22+'Cash Flow Statement'!M26+'Cash Flow Statement'!M35","v":136.02522931316759},{"$f":"'Cash Flow Statement'!N22+'Cash Flow Statement'!N26+'Cash Flow Statement'!N35","v":148.02003956408697},null,"='Cash Flow Statement'!J22+'Cash Flow Statement'!J26+'Cash Flow Statement'!J35"]
[null,null,null,null,"Tax Rate",null,"%",null,null,{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},null,"='General Assumptions'!$I$85"]
[]
[null,null,null,null,"Interest Receivable",null,"A$'000",null,null,{"$f":"(J166+(1-$I$164)*J167)*J162/(1-(1-$I$164)*(1-J168)*J162)","v":0.2701235144925046},{"$f":"(K166+(1-$I$164)*K167)*K162/(1-(1-$I$164)*(1-K168)*K162)","v":0.72177857398377998},1.4256046623738492,2.634946568696158,4.074467282203444,null,"=(J166+(1-$I$164)*J167)*J162/(1-(1-$I$164)*(1-J168)*J162)"]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,"Opening Interest Receivable",null,"A$'000",null,null,{"$f":"I177","v":0},{"$f":"J177","v":0.2701235144925046},0.72177857398377998,1.425604662373849,2.634946568696158,{"$f":"Balance_Sheet","v":"BS"},"=I177"]
[null,null,null,null,"Interest Income",null,"A$'000",null,null,{"$f":"J170","v":0.2701235144925046},{"$f":"K170","v":0.72177857398377998},1.4256046623738492,2.634946568696158,4.074467282203444,{"$f":"Income_Statement","v":"IS"},"=J170"]
[null,null,null,null,"Interest Received",null,"A$'000",null,null,{"$f":"-J174","v":0},{"$f":"-K174","v":-0.2701235144925046},-0.72177857398377998,-1.425604662373849,-2.634946568696158,{"$f":"Cash_Flow_Statement","v":"CFS"},"=-J174"]
[null,null,null,null,"Closing Interest Receivable ",null,"A$'000",null,null,{"$f":"SUM(J174:J176)","v":0.2701235144925046},{"$f":"SUM(K174:K176)","v":0.72177857398377998},1.425604662373849,2.634946568696158,4.074467282203444,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J174:J176)"]
[]
[]
[null,null,"Taxation"]
[]
[null,null,null,{"$f":"'General Assumptions'!D87","v":"Permanent Differences"}]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E89","v":"Non-Assessable Revenue"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J89","v":25},{"$f":"'General Assumptions'!K89","v":25},{"$f":"'General Assumptions'!L89","v":25},{"$f":"'General Assumptions'!M89","v":25},{"$f":"'General Assumptions'!N89","v":25},null,{"$f":"_xlfn.FORMULATEXT(J184)","v":"='General Assumptions'!J89"}]
[null,null,null,null,{"$f":"'General Assumptions'!E90","v":"Disallowable Expenses"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'General Assumptions'!J90","v":40},{"$f":"'General Assumptions'!K90","v":16},{"$f":"'General Assumptions'!L90","v":25},{"$f":"'General Assumptions'!M90","v":30},{"$f":"'General Assumptions'!N90","v":50},null,{"$f":"_xlfn.FORMULATEXT(J185)","v":"='General Assumptions'!J90"}]
[]
[null,null,null,"Accounting Taxable Profit "]
[]
[null,null,null,null,{"$f":"'Income Statement'!D24","v":"NPBT"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"'Income Statement'!J24","v":182.7701235144925},{"$f":"'Income Statement'!K24","v":165.5217785739838},{"$f":"'Income Statement'!L24","v":163.48560466237393},{"$f":"'Income Statement'!M24","v":168.68874656869619},{"$f":"'Income Statement'!N24","v":201.73854728220357},null,"='Income Statement'!J24"]
[null,null,null,null,"Deduct: Non-Assessable Revenue",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J184","v":-25},{"$f":"-K184","v":-25},-25,-25,-25,null,"=-J184"]
[null,null,null,null,"Add: Disallowable Expenses",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J185","v":40},{"$f":"K185","v":16},25,30,50,null,"=J185"]
[null,null,null,null,{"$f":"D187","v":"Accounting Taxable Profit "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J189:J191)","v":197.7701235144925},{"$f":"SUM(K189:K191)","v":156.5217785739838},163.48560466237393,173.68874656869619,226.73854728220357,null,"=SUM(J189:J191)"]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E85","v":"Tax Rate"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},null,"='General Assumptions'!$I$85"]
[]
[null,null,null,null,"Tax Expense / (Credit) ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J194*J192","v":59.331037054347746},{"$f":"K194*K192","v":46.956533572195134},49.045681398712176,52.106623970608858,68.021564184661074,null,"=J194*J192"]
[]
[null,null,null,"Tax Depreciation (Declining Balance)"]
[]
[null,null,null,null,"Capital Expenditure "]
[null,null,null,null,"Existing Assets",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I96","v":0}]
[null,null,null,null,"Capital Expenditure ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J97","v":150},{"$f":"K97","v":180},{"$f":"L97","v":120},{"$f":"M97","v":90},{"$f":"N97","v":100},null,"=J97"]
[]
[null,null,null,null,"Declining Balance Multiplier ",null,{"$f":"Multiplier","v":"x"},null,{"$f":"'General Assumptions'!I94","v":2},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I204)","v":"='General Assumptions'!I94"}]
[]
[null,null,null,null,"Remaining Life of Tax Assets",null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I96","v":5},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I206)","v":"='General Assumptions'!I96"}]
[null,null,null,null,"Annual Rate",null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I97","v":0.4},null,null,null,null,null,null,"='General Assumptions'!I97"]
[]
[null,null,null,null,"Tax Asset Life of New Capex",null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I99","v":4},null,null,null,null,null,null,"='General Assumptions'!I99"]
[null,null,null,null,"Annual Rate",null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I100","v":0.5},null,null,null,null,null,null,"='General Assumptions'!I100"]
[]
[null,null,null,null,"Depreciation - Existing Assets ",null,{"$f":"Currency","v":"US$'000"},{"$f":"I201","v":0},null,{"$f":"($H212-SUM($I212:I212))*IF(J$9=$I206,1,$I207)","v":0},{"$f":"($H212-SUM($I212:J212))*IF(K$9=$I206,1,$I207)","v":0},{"$f":"($H212-SUM($I212:K212))*IF(L$9=$I206,1,$I207)","v":0},{"$f":"($H212-SUM($I212:L212))*IF(M$9=$I206,1,$I207)","v":0},{"$f":"($H212-SUM($I212:M212))*IF(N$9=$I206,1,$I207)","v":0},null,"=($H212-SUM($I212:I212))*IF(J$9=$I206,1,$I207)"]
[null,null,null,null,{"$f":"N(E212)+1","v":1},null,"US$'000",{"$f":"OFFSET($I$202,0,$E213)","v":150},null,{"$f":"IF(J$9>=$E213,($H213-SUM($I213:I213))*IF(J$9=$I$209+$E213-1,1,$I$210),0)","v":75},{"$f":"IF(K$9>=$E213,($H213-SUM($I213:J213))*IF(K$9=$I$209+$E213-1,1,$I$210),0)","v":37.5},{"$f":"IF(L$9>=$E213,($H213-SUM($I213:K213))*IF(L$9=$I$209+$E213-1,1,$I$210),0)","v":18.75},{"$f":"IF(M$9>=$E213,($H213-SUM($I213:L213))*IF(M$9=$I$209+$E213-1,1,$I$210),0)","v":18.75},{"$f":"IF(N$9>=$E213,($H213-SUM($I213:M213))*IF(N$9=$I$209+$E213-1,1,$I$210),0)","v":0},null,"=IF(J$9>=$E213,($H213-SUM($I213:I213))*IF(J$9=$I$209+$E213-1,1,$I$210),0)"]
[null,null,null,null,{"$f":"N(E213)+1","v":2},null,"US$'000",{"$f":"OFFSET($I$202,0,$E214)","v":180},null,{"$f":"IF(J$9>=$E214,($H214-SUM($I214:I214))*IF(J$9=$I$209+$E214-1,1,$I$210),0)","v":0},{"$f":"IF(K$9>=$E214,($H214-SUM($I214:J214))*IF(K$9=$I$209+$E214-1,1,$I$210),0)","v":90},{"$f":"IF(L$9>=$E214,($H214-SUM($I214:K214))*IF(L$9=$I$209+$E214-1,1,$I$210),0)","v":45},{"$f":"IF(M$9>=$E214,($H214-SUM($I214:L214))*IF(M$9=$I$209+$E214-1,1,$I$210),0)","v":22.5},{"$f":"IF(N$9>=$E214,($H214-SUM($I214:M214))*IF(N$9=$I$209+$E214-1,1,$I$210),0)","v":22.5},null,"=IF(J$9>=$E214,($H214-SUM($I214:I214))*IF(J$9=$I$209+$E214-1,1,$I$210),0)"]
[null,null,null,null,3,null,"US$'000",{"$f":"OFFSET($I$202,0,$E215)","v":120},null,{"$f":"IF(J$9>=$E215,($H215-SUM($I215:I215))*IF(J$9=$I$209+$E215-1,1,$I$210),0)","v":0},{"$f":"IF(K$9>=$E215,($H215-SUM($I215:J215))*IF(K$9=$I$209+$E215-1,1,$I$210),0)","v":0},{"$f":"IF(L$9>=$E215,($H215-SUM($I215:K215))*IF(L$9=$I$209+$E215-1,1,$I$210),0)","v":60},{"$f":"IF(M$9>=$E215,($H215-SUM($I215:L215))*IF(M$9=$I$209+$E215-1,1,$I$210),0)","v":30},{"$f":"IF(N$9>=$E215,($H215-SUM($I215:M215))*IF(N$9=$I$209+$E215-1,1,$I$210),0)","v":15},null,"=IF(J$9>=$E215,($H215-SUM($I215:I215))*IF(J$9=$I$209+$E215-1,1,$I$210),0)"]
[null,null,null,null,4,null,"US$'000",{"$f":"OFFSET($I$202,0,$E216)","v":90},null,{"$f":"IF(J$9>=$E216,($H216-SUM($I216:I216))*IF(J$9=$I$209+$E216-1,1,$I$210),0)","v":0},{"$f":"IF(K$9>=$E216,($H216-SUM($I216:J216))*IF(K$9=$I$209+$E216-1,1,$I$210),0)","v":0},{"$f":"IF(L$9>=$E216,($H216-SUM($I216:K216))*IF(L$9=$I$209+$E216-1,1,$I$210),0)","v":0},{"$f":"IF(M$9>=$E216,($H216-SUM($I216:L216))*IF(M$9=$I$209+$E216-1,1,$I$210),0)","v":45},{"$f":"IF(N$9>=$E216,($H216-SUM($I216:M216))*IF(N$9=$I$209+$E216-1,1,$I$210),0)","v":22.5},null,"=IF(J$9>=$E216,($H216-SUM($I216:I216))*IF(J$9=$I$209+$E216-1,1,$I$210),0)"]
[null,null,null,null,5,null,"US$'000",{"$f":"OFFSET($I$202,0,$E217)","v":100},null,{"$f":"IF(J$9>=$E217,($H217-SUM($I217:I217))*IF(J$9=$I$209+$E217-1,1,$I$210),0)","v":0},{"$f":"IF(K$9>=$E217,($H217-SUM($I217:J217))*IF(K$9=$I$209+$E217-1,1,$I$210),0)","v":0},{"$f":"IF(L$9>=$E217,($H217-SUM($I217:K217))*IF(L$9=$I$209+$E217-1,1,$I$210),0)","v":0},{"$f":"IF(M$9>=$E217,($H217-SUM($I217:L217))*IF(M$9=$I$209+$E217-1,1,$I$210),0)","v":0},{"$f":"IF(N$9>=$E217,($H217-SUM($I217:M217))*IF(N$9=$I$209+$E217-1,1,$I$210),0)","v":50},null,"=IF(J$9>=$E217,($H217-SUM($I217:I217))*IF(J$9=$I$209+$E217-1,1,$I$210),0)"]
[null,null,null,null,"Tax Depreciation ",null,"US$'000",{"$f":"SUM(H212:H217)","v":640},{"$f":"SUM(J218:N218)","v":552.5},{"$f":"SUM(J212:J217)","v":75},{"$f":"SUM(K212:K217)","v":127.5},123.75,116.25,110,null,"=SUM(J212:J217)"]
[]
[null,null,null,"Accounting Depreciation "]
[]
[null,null,null,null,{"$f":"D220","v":"Accounting Depreciation "},null,{"$f":"Currency","v":"US$'000"},null,{"$f":"SUM(J222:N222)","v":490},{"$f":"J114","v":37.5},{"$f":"K114","v":82.5},{"$f":"L114","v":112.5},{"$f":"M114","v":135},{"$f":"N114","v":122.5},null,"=J114"]
[]
[null,null,null,"Depreciation Timing Difference"]
[]
[null,null,null,null,{"$f":"E222","v":"Accounting Depreciation "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J222","v":37.5},{"$f":"K222","v":82.5},{"$f":"L222","v":112.5},135,122.5,null,"=J222"]
[null,null,null,null,"Tax Depreciation",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J218","v":-75},{"$f":"-K218","v":-127.5},-123.75,-116.25,-110,null,"=-J218"]
[null,null,null,null,"Depreciation Timing Difference",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J226:J227)","v":-37.5},{"$f":"SUM(K226:K227)","v":-45},-11.25,18.75,12.5,null,"=SUM(J226:J227)"]
[]
[null,null,null,null,"Tax Rate",null,"%",null,null,{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},{"$f":"'General Assumptions'!$I$85","v":0.3},null,"='General Assumptions'!$I$85"]
[]
[null,null,null,null,"Movement in DTLs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-J230*J228","v":11.25},{"$f":"-K230*K228","v":13.5},3.375,-5.625,-3.75,null,"=-J230*J228"]
[]
[null,null,null,null,"Opening DTLs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I236","v":0},{"$f":"J236","v":11.25},24.75,28.125,22.5,null,"=I236"]
[null,null,null,null,"Movement in DTLs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J232","v":11.25},{"$f":"K232","v":13.5},3.375,-5.625,-3.75,null,"=J232"]
[null,null,null,null,"Closing DTLs",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I36","v":0},{"$f":"SUM(J234:J235)","v":11.25},{"$f":"SUM(K234:K235)","v":24.75},28.125,22.5,18.75,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J234:J235)"]
[]
[null,null,null,"Tax Payable and Paid",null,null,{"$f":"Currency","v":"US$'000"}]
[]
[null,null,null,null,{"$f":"E192","v":"Accounting Taxable Profit "},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J192","v":197.7701235144925},{"$f":"K192","v":156.5217785739838},{"$f":"L192","v":163.48560466237393},173.68874656869619,226.73854728220357,null,"=J192"]
[null,null,null,null,{"$f":"E228","v":"Depreciation Timing Difference"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J228","v":-37.5},{"$f":"K228","v":-45},-11.25,18.75,12.5,null,"=J228"]
[null,null,null,null,"Taxable Profit / (Loss) Before Losses",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J240:J241)","v":160.2701235144925},{"$f":"SUM(K240:K241)","v":111.5217785739838},152.23560466237393,192.43874656869619,239.23854728220357,null,"=SUM(J240:J241)"]
[null,null,null,null,"Tax Losses Used",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J263","v":0},{"$f":"K263","v":0},0,0,0,null,"=J263"]
[null,null,null,null,"Taxable Profit / (Loss) after Losses",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J242:J243)","v":160.2701235144925},{"$f":"SUM(K242:K243)","v":111.5217785739838},152.23560466237393,192.43874656869619,239.23854728220357,null,"=SUM(J242:J243)"]
[null,null,null,null,{"$f":"E230","v":"Tax Rate"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"J230","v":0.3},{"$f":"K230","v":0.3},0.3,0.3,0.3,null,"=J230"]
[null,null,null,null,"Tax Payable for Period ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"MAX(J244*J245,0)","v":48.081037054347746},{"$f":"MAX(K244*K245,0)","v":33.456533572195134},45.670681398712176,57.731623970608851,71.771564184661074,null,"=MAX(J244*J245,0)"]
[]
[null,null,null,null,{"$f":"'General Assumptions'!E114","v":"Payment Delay"},null,{"$f":"No_of_Years","v":"# Year(s)"},null,{"$f":"'General Assumptions'!I114","v":1},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I248)","v":"='General Assumptions'!I114"}]
[]
[null,null,null,null,"Opening Tax Payable",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I253","v":0},{"$f":"J253","v":48.081037054347746},33.456533572195127,45.670681398712169,57.731623970608851,null,{"$f":"_xlfn.FORMULATEXT(J250)","v":"=I253"}]
[null,null,null,null,"Tax Payable for Period",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I253","v":0},{"$f":"J246","v":48.081037054347746},{"$f":"K246","v":33.456533572195134},45.670681398712176,57.731623970608851,71.771564184661074,null,"=J246"]
[null,null,null,null,"Tax Paid",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-IF(J$9-$I248<0,0,OFFSET(J251,0,-$I248))","v":0},{"$f":"-IF(K$9-$I248<0,0,OFFSET(K251,0,-$I248))","v":-48.081037054347746},-33.456533572195134,-45.670681398712176,-57.731623970608851,null,"=-IF(J$9-$I248<0,0,OFFSET(J251,0,-$I248))"]
[null,null,null,null,"Closing Tax Payable",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'Opening Balance Sheet'!I30","v":0},{"$f":"SUM(J250:J252)","v":48.081037054347746},{"$f":"SUM(K250:K252)","v":33.456533572195127},45.670681398712169,57.731623970608851,71.771564184661074,null,"=SUM(J250:J252)"]
[]
[null,null,null,"Tax Losses Memorandum"]
[]
[null,null,null,null,"DTA",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"'General Assumptions'!I105","v":0},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I257)","v":"='General Assumptions'!I105"}]
[null,null,null,null,{"$f":"E230","v":"Tax Rate"},null,{"$f":"Percentage","v":"%"},null,{"$f":"'General Assumptions'!I85","v":0.3},null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I258)","v":"='General Assumptions'!I85"}]
[null,null,null,null,"Opening Tax Losses",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"IF(I258<=0,0,I257/I258)","v":0}]
[]
[null,null,null,null,{"$f":"E259","v":"Opening Tax Losses"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I264","v":0},{"$f":"J264","v":0},0,0,0,null,"=I264"]
[null,null,null,null,"Tax Losses Created During the Period",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-MIN(J242,0)","v":0},{"$f":"-MIN(K242,0)","v":0},0,0,0,null,"=-MIN(J242,0)"]
[null,null,null,null,{"$f":"E243","v":"Tax Losses Used"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J242>0,-MAX(MIN(J242,J261),0),0)","v":0},{"$f":"IF(K242>0,-MAX(MIN(K242,K261),0),0)","v":0},0,0,0,null,"=IF(J242>0,-MAX(MIN(J242,J261),0),0)"]
[null,null,null,null,"Closing Tax Losses",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I259","v":0},{"$f":"SUM(J261:J263)","v":0},{"$f":"SUM(K261:K263)","v":0},0,0,0,null,"=SUM(J261:J263)"]
[]
[null,null,null,null,"Movement in Tax Losses",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J262:J263)","v":0},{"$f":"SUM(K262:K263)","v":0},{"$f":"SUM(L262:L263)","v":0},0,0,null,"=SUM(J262:J263)"]
[]
[null,null,null,null,{"$f":"E258","v":"Tax Rate"},null,{"$f":"Percentage","v":"%"},null,null,{"$f":"J230","v":0.3},{"$f":"K230","v":0.3},0.3,0.3,0.3,null,"=J230"]
[]
[null,null,null,null,"Movement in DTAs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J268*J266","v":0},{"$f":"K268*K266","v":0},0,0,0,null,"=J268*J266"]
[]
[null,null,null,null,"Opening DTAs",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I274","v":0},{"$f":"J274","v":0},0,0,0,null,"=I274"]
[null,null,null,null,{"$f":"E270","v":"Movement in DTAs"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J270","v":0},{"$f":"K270","v":0},0,0,0,null,"=J270"]
[null,null,null,null,"Closing DTAs",null,{"$f":"Currency","v":"US$'000"},null,{"$f":"I257","v":0},{"$f":"SUM(J272:J273)","v":0},{"$f":"SUM(K272:K273)","v":0},0,0,0,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J272:J273)"]
[]
[null,null,null,{"$f":"D152","v":"Control Account"}]
[]
[null,null,null,null,{"$f":"E250","v":"Opening Tax Payable"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"I283","v":0},{"$f":"J283","v":48.081037054347746},{"$f":"K283","v":33.456533572195127},45.670681398712169,57.731623970608851,{"$f":"Balance_Sheet","v":"BS"},"=I283"]
[null,null,null,null,{"$f":"E196","v":"Tax Expense / (Credit) "},null,"US$'000",null,null,{"$f":"J196","v":59.331037054347746},{"$f":"K196","v":46.956533572195134},{"$f":"L196","v":49.045681398712176},52.106623970608858,68.021564184661074,{"$f":"Income_Statement","v":"IS"},"=J196"]
[null,null,null,null,{"$f":"E252","v":"Tax Paid"},null,"US$'000",null,null,{"$f":"J252","v":0},{"$f":"K252","v":-48.081037054347746},-33.456533572195134,-45.670681398712176,-57.731623970608851,{"$f":"Cash_Flow_Statement","v":"CFS"},"=J252"]
[null,null,null,null,{"$f":"E270","v":"Movement in DTAs"},null,"US$'000",null,null,{"$f":"J270","v":0},{"$f":"K270","v":0},0,0,0,null,"=J270"]
[null,null,null,null,{"$f":"E232","v":"Movement in DTLs"},null,"US$'000",null,null,{"$f":"-J232","v":-11.25},{"$f":"-K232","v":-13.5},-3.375,5.625,3.75,null,"=-J232"]
[null,null,null,null,{"$f":"E253","v":"Closing Tax Payable"},null,"US$'000",null,{"$f":"I253","v":0},{"$f":"SUM(J278:J282)","v":48.081037054347746},{"$f":"SUM(K278:K282)","v":33.456533572195127},45.670681398712169,57.731623970608851,71.771564184661074,{"$f":"Balance_Sheet","v":"BS"},"=SUM(J278:J282)"]

{"sheet":"Opening Balance Sheet","index":6,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,7,0,8]]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Opening Balance Sheet"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,null,{"$f":"Overall_Error_Check","v":0},null,{"$f":"Model_Start_Date-1","v":"2020-06-30"}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"MAX($B5:$B$5)+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,250]
[null,null,null,"Accounts Receivable",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:K16)","v":310}]
[]
[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(K20:K21)","v":525}]
[]
[null,null,"Total Assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K17+K22","v":835}]
[]
[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(K27:K31)","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(K35:K36)","v":175}]
[]
[null,null,"Total Liabilities",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K32+K37","v":290}]
[]
[null,null,"Net Assets",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K24-K39","v":545}]
[]
[]
[null,null,"Equity "]
[null,null,null,"Ordinary Equity",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,300]
[]
[null,null,null,null,"NPAT",null,{"$f":"Currency","v":"US$'000"},null,null,null,0]
[null,null,null,null,"Dividends Declared ",null,{"$f":"Currency","v":"US$'000"},null,null,null,0]
[null,null,null,"Retained Profits",null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"K41-K45-K47-K48","v":245}]
[null,null,"Total Equity ",null,null,null,{"$f":"Currency","v":"US$'000"},null,null,null,{"$f":"SUM(K45,K47:K49)","v":545}]
[]
[]
[null,null,"Checks"]
[]
[null,null,null,"PF Error Check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(ISERROR(I41-I50),1,0)","v":0}]
[null,null,null,"Balance Check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(I55<>0,0,(ROUND(I41-I50,Rounding_Accuracy)<>0)*1)","v":0}]
[null,null,null,"Insolvency Check",null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"IF(AND(I55=0,I56=0),(I41<0)*1,0)","v":0}]

{"sheet":"Income Statement","index":7,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Income Statement"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2021-06-30"},{"$f":"Timing!K5","v":"2022-06-30"},{"$f":"Timing!L5","v":"2023-06-30"},{"$f":"Timing!M5","v":"2024-06-30"},{"$f":"Timing!N5","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-07-01"},{"$f":"Timing!K6","v":"2021-07-01"},{"$f":"Timing!L6","v":"2022-07-01"},{"$f":"Timing!M6","v":"2023-07-01"},{"$f":"Timing!N6","v":"2024-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2021-06-30"},{"$f":"Timing!K7","v":"2022-06-30"},{"$f":"Timing!L7","v":"2023-06-30"},{"$f":"Timing!M7","v":"2024-06-30"},{"$f":"Timing!N7","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$7:$B10)+1","v":1},{"$f":"A1","v":"Income Statement"}]
[]
[null,null,null,"Revenue",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J32","v":400},{"$f":"Calculations!K32","v":448.00000000000006},{"$f":"Calculations!L32","v":492.80000000000013},{"$f":"Calculations!M32","v":532.22400000000016},{"$f":"Calculations!N32","v":558.83520000000021}]
[null,null,null,"COGS",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J58","v":-120},{"$f":"-Calculations!K58","v":-134.40000000000003},{"$f":"-Calculations!L58","v":-147.84000000000003},{"$f":"-Calculations!M58","v":-159.66720000000009},{"$f":"-Calculations!N58","v":-167.6505600000001}]
[null,null,null,"Gross Profit",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J13:J14)","v":280},{"$f":"SUM(K13:K14)","v":313.60000000000002},344.96000000000009,372.55680000000007,391.18464000000012]
[]
[null,null,null,"Operating Expenditure",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J87","v":-60},{"$f":"-Calculations!K87","v":-65},{"$f":"-Calculations!L87","v":-67.600000000000009},{"$f":"-Calculations!M87","v":-69.628000000000014},{"$f":"-Calculations!N87","v":-71.020560000000017}]
[null,null,null,"EBITDA",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J15+J17","v":220},{"$f":"K15+K17","v":248.60000000000002},277.36000000000007,302.92880000000002,320.16408000000013]
[]
[null,null,null,"Depreciation",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J120","v":-37.5},{"$f":"Calculations!K120","v":-82.5},{"$f":"Calculations!L120","v":-112.5},{"$f":"Calculations!M120","v":-135},{"$f":"Calculations!N120","v":-122.5}]
[null,null,null,"EBIT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J18+J20","v":182.5},{"$f":"K18+K20","v":166.10000000000002},{"$f":"L18+L20","v":164.86000000000007},{"$f":"M18+M20","v":167.92880000000002},{"$f":"N18+N20","v":197.66408000000013}]
[]
[null,null,null,"Interest Expense",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J155+Calculations!J175","v":0.2701235144925046},{"$f":"-Calculations!K155+Calculations!K175","v":-0.57822142601622006},{"$f":"-Calculations!L155+Calculations!L175","v":-1.3743953376261511},{"$f":"-Calculations!M155+Calculations!M175","v":0.75994656869615795},{"$f":"-Calculations!N155+Calculations!N175","v":4.074467282203444}]
[null,null,null,"NPBT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J21+J23","v":182.7701235144925},{"$f":"K21+K23","v":165.5217785739838},{"$f":"L21+L23","v":163.48560466237393},{"$f":"M21+M23","v":168.68874656869619},{"$f":"N21+N23","v":201.73854728220357}]
[]
[null,null,null,"Tax Expense",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J279","v":-59.331037054347746},{"$f":"-Calculations!K279","v":-46.956533572195134},{"$f":"-Calculations!L279","v":-49.045681398712176},{"$f":"-Calculations!M279","v":-52.106623970608858},{"$f":"-Calculations!N279","v":-68.021564184661074}]
[null,null,null,"NPAT",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J24+J26","v":123.43908646014475},{"$f":"K24+K26","v":118.56524500178867},114.43992326366175,116.58212259808732,133.71698309754248]

{"sheet":"Balance Sheet","index":8,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Balance Sheet"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2021-06-30"},{"$f":"Timing!K5","v":"2022-06-30"},{"$f":"Timing!L5","v":"2023-06-30"},{"$f":"Timing!M5","v":"2024-06-30"},{"$f":"Timing!N5","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-07-01"},{"$f":"Timing!K6","v":"2021-07-01"},{"$f":"Timing!L6","v":"2022-07-01"},{"$f":"Timing!M6","v":"2023-07-01"},{"$f":"Timing!N6","v":"2024-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2021-06-30"},{"$f":"Timing!K7","v":"2022-06-30"},{"$f":"Timing!L7","v":"2023-06-30"},{"$f":"Timing!M7","v":"2024-06-30"},{"$f":"Timing!N7","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$9:$B10)+1","v":1},{"$f":"A1","v":"Balance Sheet"}]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C13","v":"Current Assets"}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D14","v":"Cash "},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"IF(J$9=1,'Opening Balance Sheet'!$I$14,I14)+'Cash Flow Statement'!J37","v":53.835616438356169},{"$f":"IF(K$9=1,'Opening Balance Sheet'!$I$14,J14)+'Cash Flow Statement'!K37","v":90.28497687110368},{"$f":"IF(L$9=1,'Opening Balance Sheet'!$I$14,K14)+'Cash Flow Statement'!L37","v":194.55981091398831},{"$f":"IF(M$9=1,'Opening Balance Sheet'!$I$14,L14)+'Cash Flow Statement'!M37","v":332.01064488952977},{"$f":"IF(N$9=1,'Opening Balance Sheet'!$I$14,M14)+'Cash Flow Statement'!N37","v":482.66563102231294}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D15","v":"Accounts Receivable"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J34","v":65.753424657534239},{"$f":"Calculations!K34","v":73.643835616438366},{"$f":"Calculations!L34","v":81.008219178082214},{"$f":"Calculations!M34","v":87.249836065573788},{"$f":"Calculations!N34","v":91.863320547945236}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D16","v":"Other Current Assets"},null,null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D17","v":"Total Current Assets"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J14:J16)","v":119.58904109589041},{"$f":"SUM(K14:K16)","v":163.92881248754205},275.56803009207056,419.26048095510356,574.52895157025819]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C19","v":"Non-Current Assets"}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D20","v":"PP&E"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J121","v":112.5},{"$f":"Calculations!K121","v":210},{"$f":"Calculations!L121","v":217.5},{"$f":"Calculations!M121","v":172.5},{"$f":"Calculations!N121","v":150}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D21","v":"Deferred Tax Assets"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J274","v":0},{"$f":"Calculations!K274","v":0},{"$f":"Calculations!L274","v":0},{"$f":"Calculations!M274","v":0},{"$f":"Calculations!N274","v":0}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D22","v":"Total Non-Current Assets"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J20:J21)","v":112.5},{"$f":"SUM(K20:K21)","v":210},217.5,172.5,150]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C24","v":"Total Assets"},null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J17+J22","v":232.08904109589042},{"$f":"K17+K22","v":373.92881248754202},493.06803009207056,591.7604809551035,724.52895157025819]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C26","v":"Current Liabilities"}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D27","v":"Accounts Payable"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J60+Calculations!J89","v":29.589041095890408},{"$f":"Calculations!K60+Calculations!K89","v":33.139726027397266},{"$f":"Calculations!L60+Calculations!L89","v":36.453698630136991},{"$f":"Calculations!M60+Calculations!M89","v":39.262426229508222},{"$f":"Calculations!N60+Calculations!N89","v":41.338494246575365}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D28","v":"Interest Payable"},null,null,"US$'000",null,null,{"$f":"Calculations!J157-Calculations!J177","v":-0.2701235144925046},{"$f":"Calculations!K157-Calculations!K177","v":0.57822142601622006},{"$f":"Calculations!L157-Calculations!L177","v":1.3743953376261517},{"$f":"Calculations!M157-Calculations!M177","v":-0.75994656869615795},{"$f":"Calculations!N157-Calculations!N177","v":-4.074467282203444}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D29","v":"Dividends Payable"},null,null,"US$'000"]
[null,null,null,{"$f":"'Opening Balance Sheet'!D30","v":"Tax Payable"},null,null,"US$'000",null,null,{"$f":"Calculations!J283","v":48.081037054347746},{"$f":"Calculations!K283","v":33.456533572195127},{"$f":"Calculations!L283","v":45.670681398712169},{"$f":"Calculations!M283","v":57.731623970608851},{"$f":"Calculations!N283","v":71.771564184661074}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D31","v":"Other Current Liabilities"},null,null,"US$'000"]
[null,null,null,{"$f":"'Opening Balance Sheet'!D32","v":"Total Current Liabilities"},null,null,"US$'000",null,null,{"$f":"SUM(J27:J31)","v":77.399954635745644},{"$f":"SUM(K27:K31)","v":67.174481025608614},83.498775366475314,96.234103631420908,109.035591149033]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C34","v":"Non-Current Liabilities "}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D35","v":"Debt"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J138","v":20},{"$f":"Calculations!K138","v":40},{"$f":"Calculations!L138","v":25},{"$f":"Calculations!M138","v":0},{"$f":"Calculations!N138","v":-10}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D36","v":"Deferred Tax Liabilities"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J236","v":11.25},{"$f":"Calculations!K236","v":24.75},{"$f":"Calculations!L236","v":28.125},{"$f":"Calculations!M236","v":22.5},{"$f":"Calculations!N236","v":18.75}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D37","v":"Total Non-Current Liabilities"},null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J35:J36)","v":31.25},{"$f":"SUM(K35:K36)","v":64.75},53.125,22.5,8.75]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C39","v":"Total Liabilities"},null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J32+J37","v":108.64995463574564},{"$f":"K32+K37","v":131.9244810256086},136.62377536647531,118.73410363142091,117.785591149033]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C41","v":"Net Assets"},null,null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J24-J39","v":123.43908646014478},{"$f":"K24-K39","v":242.00433146193342},{"$f":"L24-L39","v":356.44425472559521},{"$f":"M24-M39","v":473.0263773236826},{"$f":"N24-N39","v":606.74336042122513}]
[]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C44","v":"Equity "}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D45","v":"Ordinary Equity"},null,null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Opening Profits",null,"US$'000",null,null,{"$f":"IF(J$9=1,'Opening Balance Sheet'!$I$49,I49)","v":0},{"$f":"IF(K$9=1,'Opening Balance Sheet'!$I$49,J49)","v":123.43908646014475},{"$f":"IF(L$9=1,'Opening Balance Sheet'!$I$49,K49)","v":242.00433146193342},{"$f":"IF(M$9=1,'Opening Balance Sheet'!$I$49,L49)","v":356.44425472559516},{"$f":"IF(N$9=1,'Opening Balance Sheet'!$I$49,M49)","v":473.02637732368248}]
[null,null,null,null,{"$f":"'Opening Balance Sheet'!E47","v":"NPAT"},null,"US$'000",null,null,{"$f":"'Income Statement'!J27","v":123.43908646014475},{"$f":"'Income Statement'!K27","v":118.56524500178867},{"$f":"'Income Statement'!L27","v":114.43992326366175},{"$f":"'Income Statement'!M27","v":116.58212259808732},{"$f":"'Income Statement'!N27","v":133.71698309754248}]
[null,null,null,null,{"$f":"'Opening Balance Sheet'!E48","v":"Dividends Declared "},null,"US$'000"]
[null,null,null,{"$f":"'Opening Balance Sheet'!D49","v":"Retained Profits"},null,null,"US$'000",null,null,{"$f":"SUM(J46:J48)","v":123.43908646014475},{"$f":"SUM(K46:K48)","v":242.00433146193342},{"$f":"SUM(L46:L48)","v":356.44425472559516},473.02637732368248,606.74336042122491]
[null,null,{"$f":"'Opening Balance Sheet'!C50","v":"Total Equity "},null,null,null,"US$'000",null,null,{"$f":"J45+J49","v":123.43908646014475},{"$f":"K45+K49","v":242.00433146193342},356.44425472559516,473.02637732368248,606.74336042122491]
[]
[]
[null,null,{"$f":"'Opening Balance Sheet'!C53","v":"Checks"}]
[]
[null,null,null,{"$f":"'Opening Balance Sheet'!D55","v":"PF Error Check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MIN(SUM($J55:$N55),1)","v":0},{"$f":"IF(ISERROR(J41-J50),1,0)","v":0},{"$f":"IF(ISERROR(K41-K50),1,0)","v":0},{"$f":"IF(ISERROR(L41-L50),1,0)","v":0},{"$f":"IF(ISERROR(M41-M50),1,0)","v":0},{"$f":"IF(ISERROR(N41-N50),1,0)","v":0}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D56","v":"Balance Check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MIN(SUM($J56:$N56),1)","v":0},{"$f":"IF(J55<>0,0,(ROUND(J41-J50,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(K55<>0,0,(ROUND(K41-K50,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(L55<>0,0,(ROUND(L41-L50,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(M55<>0,0,(ROUND(M41-M50,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(N55<>0,0,(ROUND(N41-N50,Rounding_Accuracy)<>0)*1)","v":0}]
[null,null,null,{"$f":"'Opening Balance Sheet'!D57","v":"Insolvency Check"},null,null,{"$f":"Boolean","v":"[1,0]"},null,{"$f":"MIN(SUM($J57:$N57),1)","v":0},{"$f":"IF(AND(J55=0,J56=0),(J41<0)*1,0)","v":0},{"$f":"IF(AND(K55=0,K56=0),(K41<0)*1,0)","v":0},0,0,0]

{"sheet":"Cash Flow Statement","index":9,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Cash Flow Statement"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2021-06-30"},{"$f":"Timing!K5","v":"2022-06-30"},{"$f":"Timing!L5","v":"2023-06-30"},{"$f":"Timing!M5","v":"2024-06-30"},{"$f":"Timing!N5","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-07-01"},{"$f":"Timing!K6","v":"2021-07-01"},{"$f":"Timing!L6","v":"2022-07-01"},{"$f":"Timing!M6","v":"2023-07-01"},{"$f":"Timing!N6","v":"2024-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2021-06-30"},{"$f":"Timing!K7","v":"2022-06-30"},{"$f":"Timing!L7","v":"2023-06-30"},{"$f":"Timing!M7","v":"2024-06-30"},{"$f":"Timing!N7","v":"2025-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$9:$B10)+1","v":1},{"$f":"A1","v":"Cash Flow Statement"}]
[]
[null,null,{"$f":"\"Direct \"&C11","v":"Direct Cash Flow Statement"}]
[]
[null,null,null,"Operating Cash Flow"]
[null,null,null,null,"Cash Receipts",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J33","v":334.24657534246575},{"$f":"-Calculations!K33","v":440.10958904109594},{"$f":"-Calculations!L33","v":485.43561643835631},{"$f":"-Calculations!M33","v":525.98238311250861},{"$f":"-Calculations!N33","v":554.22171551762881}]
[null,null,null,null,null,"Direct Cash Payments ","US$'000",null,null,{"$f":"Calculations!J59","v":-90.410958904109592},{"$f":"Calculations!K59","v":-130.84931506849318},{"$f":"Calculations!L59","v":-144.52602739726032},{"$f":"Calculations!M59","v":-156.85847240062884},{"$f":"Calculations!N59","v":-165.57449198293295}]
[null,null,null,null,null,"Indirect Cash Payments","US$'000",null,null,{"$f":"Calculations!J88","v":-60},{"$f":"Calculations!K88","v":-65},{"$f":"Calculations!L88","v":-67.600000000000009},{"$f":"Calculations!M88","v":-69.628000000000014},{"$f":"Calculations!N88","v":-71.020560000000017}]
[null,null,null,null,"Cash Payments",null,"US$'000",null,null,{"$f":"SUM(J17:J18)","v":-150.41095890410958},{"$f":"SUM(K17:K18)","v":-195.84931506849318},-212.12602739726032,-226.48647240062886,-236.59505198293297]
[null,null,null,null,"Interest Paid",null,"US$'000",null,null,{"$f":"Calculations!J156","v":0},{"$f":"Calculations!K156","v":0},{"$f":"Calculations!L156","v":-1.3},{"$f":"Calculations!M156","v":-2.8000000000000007},{"$f":"Calculations!N156","v":-1.875}]
[null,null,null,null,"Tax Paid",null,"US$'000",null,null,{"$f":"Calculations!J280","v":0},{"$f":"Calculations!K280","v":-48.081037054347746},{"$f":"Calculations!L280","v":-33.456533572195134},{"$f":"Calculations!M280","v":-45.670681398712176},{"$f":"Calculations!N280","v":-57.731623970608851}]
[null,null,null,null,{"$f":"\"Net \"&D15","v":"Net Operating Cash Flow"},null,"US$'000",null,null,{"$f":"SUM(J16,J19:J21)","v":183.83561643835617},{"$f":"SUM(K16,K19:K21)","v":196.17923691825501},238.55305546890085,251.02522931316759,258.02003956408697]
[]
[null,null,null,"Investing Cash Flows"]
[null,null,null,null,"Interest Received ",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J176","v":0},{"$f":"-Calculations!K176","v":0.2701235144925046},{"$f":"-Calculations!L176","v":0.72177857398377998},{"$f":"-Calculations!M176","v":1.425604662373849},{"$f":"-Calculations!N176","v":2.634946568696158}]
[null,null,null,null,"Purchases of Non-Current Assets",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"-Calculations!J119","v":-150},{"$f":"-Calculations!K119","v":-180},{"$f":"-Calculations!L119","v":-120},{"$f":"-Calculations!M119","v":-90},{"$f":"-Calculations!N119","v":-100}]
[null,null,null,null,{"$f":"\"Net \"&D24","v":"Net Investing Cash Flows"},null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"SUM(J25:J26)","v":-150},{"$f":"SUM(K25:K26)","v":-179.7298764855075},-119.27822142601622,-88.574395337626157,-97.365053431303835]
[]
[null,null,null,"Financing Cash Flows"]
[null,null,null,null,"Debt Drawdowns",null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"Calculations!J136","v":20},{"$f":"Calculations!K136","v":20},{"$f":"Calculations!L136","v":0},{"$f":"Calculations!M136","v":0},{"$f":"Calculations!N136","v":0}]
[null,null,null,null,"Debt Repayments",null,"US$'000",null,null,{"$f":"Calculations!J137","v":0},{"$f":"Calculations!K137","v":0},{"$f":"Calculations!L137","v":-15},{"$f":"Calculations!M137","v":-25},{"$f":"Calculations!N137","v":-10}]
[null,null,null,null,"Ordinary Equity Issuances ",null,"US$'000"]
[null,null,null,null,"Ordinary Equity Buybacks",null,"US$'000"]
[null,null,null,null,"Dividends Paid",null,"US$'000"]
[null,null,null,null,{"$f":"\"Net \"&D29","v":"Net Financing Cash Flows"},null,"US$'000",null,null,{"$f":"SUM(J30:J34)","v":20},{"$f":"SUM(K30:K34)","v":20},-15,-25,-10]
[]
[null,null,null,"Net Increase / (Decrease) in Cash Held",null,null,{"$f":"Currency","v":"US$'000"},null,null,{"$f":"J22+J27+J35","v":53.835616438356169},{"$f":"K22+K27+K35","v":36.449360432747511},104.27483404288463,137.45083397554143,150.65498613278314]
[]
[]
[null,null,"Indirect Extract",null,null,null,{"$f":"Currency","v":"US$'000"}]
[]
[null,null,null,"Operating Cash Flow"]
[null,null,null,null,{"$f":"'Income Statement'!D27","v":"NPAT"},null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Add Back: ",null,{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,null,{"$f":"'Income Statement'!D20","v":"Depreciation"},{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,null,{"$f":"'Income Statement'!D23","v":"Interest Expense"},{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,null,{"$f":"'Income Statement'!D26","v":"Tax Expense"},{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Movements in Working Capital:"]
[null,null,null,null,null,"(Inc) / Dec in Current Assets",{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,null,"Inc / (Dec) in Current Liabilities ",{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,"Deduct:"]
[null,null,null,null,null,{"$f":"E20","v":"Interest Paid"},{"$f":"Currency","v":"US$'000"}]
[null,null,null,null,null,{"$f":"E21","v":"Tax Paid"},{"$f":"Currency","v":"US$'000"}]
[null,null,null,{"$f":"\"Net \"&D42","v":"Net Operating Cash Flow"},null,null,{"$f":"Currency","v":"US$'000"}]
[]
[]
[null,null,null,null,{"$f":"'Balance Sheet'!D55","v":"PF Error Check"},null,{"$f":"Boolean","v":"[1,0]"}]
[null,null,null,null,"Reconciliation Check:",null,{"$f":"Boolean","v":"[1,0]"}]

{"sheet":"Error Checks","index":10,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Error Checks"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,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,"Opening Balance Sheet - no errors",null,null,null,{"$f":"'Opening Balance Sheet'!I55","v":0}]
[null,null,null,null,"Opening Balance Sheet - balances",null,null,null,{"$f":"'Opening Balance Sheet'!I56","v":0}]
[null,null,null,null,"Opening Balance Sheet - solvent",null,null,null,{"$f":"'Opening Balance Sheet'!I57","v":0}]
[null,null,null,null,"Balance Sheet - no errors",null,null,null,{"$f":"'Balance Sheet'!I55","v":0}]
[null,null,null,null,"Balance Sheet - balances",null,null,null,{"$f":"'Balance Sheet'!I56","v":0}]
[null,null,null,null,"Balance Sheet - solvent",null,null,null,{"$f":"'Balance Sheet'!I57","v":0}]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I19))","v":0}]

{"sheet":"Timing","index":11,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Timing"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2021-06-30"},{"$f":"K$7","v":"2022-06-30"},{"$f":"L$7","v":"2023-06-30"},{"$f":"M$7","v":"2024-06-30"},{"$f":"N$7","v":"2025-06-30"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2020-07-01"},{"$f":"IF(K$9=1,Model_Start_Date,J$7+1)","v":"2021-07-01"},{"$f":"IF(L$9=1,Model_Start_Date,K$7+1)","v":"2022-07-01"},{"$f":"IF(M$9=1,Model_Start_Date,L$7+1)","v":"2023-07-01"},{"$f":"IF(N$9=1,Model_Start_Date,M$7+1)","v":"2024-07-01"}]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2021-06-30"},{"$f":"EOMONTH(K$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(K$6),Periodicity))","v":"2022-06-30"},{"$f":"EOMONTH(L$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(L$6),Periodicity))","v":"2023-06-30"},{"$f":"EOMONTH(M$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(M$6),Periodicity))","v":"2024-06-30"},{"$f":"EOMONTH(N$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(N$6),Periodicity))","v":"2025-06-30"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":365},{"$f":"K7-K6+1","v":365},365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$9)+1","v":1},{"$f":"N(J$9)+1","v":2},3,4,5]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,"2020-07-01"]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12]
[]
[null,null,null,"Example Reporting Month",null,null,null,6,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 30-Jun-21"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":6}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Lookup","index":12,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))),\"\")","v":"Lookup"}]
[{"$f":"Model_Name","v":"Chapter 10.10 - Taxation.xlsm"}]
["Navigator"]
["Error Checks:",null,null,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,{"$f":"F11","v":"LU_Future_Years"}]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($A$9:$A9))","v":"2022-06-30"},null,"LU_Future_Years",null,{"$f":"_xlfn.FORMULATEXT(D11)","v":"=OFFSET(Timing!$J$7,,ROWS($A$9:$A9))"}]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($A$9:$A10))","v":"2023-06-30"},null,null,null,{"$f":"_xlfn.FORMULATEXT(D12)","v":"=OFFSET(Timing!$J$7,,ROWS($A$9:$A10))"}]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($A$9:$A11))","v":"2024-06-30"},null,null,null,"=OFFSET(Timing!$J$7,,ROWS($A$9:$A11))"]
[null,null,null,{"$f":"OFFSET(Timing!$J$7,,ROWS($A$9:$A12))","v":"2025-06-30"},null,null,null,"=OFFSET(Timing!$J$7,,ROWS($A$9:$A12))"]
[null,null,null,"Actuals Throughout"]

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