{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions & Inputs",">>>","Model Inputs","Disclaimer","Model"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":2910,"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":"Instructions & Inputs","index":0,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,1,38,12],[1,1,1,12],[3,1,3,12],[4,1,4,12],[37,1,37,12],[9,1,9,12],[5,1,5,12],[6,1,6,12],[11,8,11,9],[15,8,15,10],[13,8,13,9],[11,1,11,6]]}
[]
[null,"Whole-of-life costs model for sports fields"]
[]
[null,"Introduction"]
[null,"The Sport NZ Guidance Document for Sports Field Development highlights the importance of understanding the project's lifecycle costs. This includes the initial construction cost, ongoing maintenance cots, and future renewals. It is essential that ongoing maintenance costs and future renewals are effectively managed over time to optimise field performance and desired use outcomes. Therefore, it is crucial to understand your budget, which is aligned with performance expectations. "]
[]
[null,"The calculator has been designed for independent and customised use to suit the specific settings, conditions and costs of each sports field project. The customisable inputs are highlighted below."]
[]
[null,"More information can be found here:"]
[null,"Sport NZ's Guidance Document for Sports Field Development"]
[]
[null,"Key inputs (editable values in the model)",null,null,null,null,null,null,"Key outputs"]
[]
[null,"Financial Assumptions",null,null,null,null,null,null,"Annual Use Hours (by field type)"]
[null,"- Inflation"]
[null,"- Forward Risk Free Discount Rate",null,null,null,null,null,null,"Cost per Hour of Play (by field type)"]
[]
[null,"Construction Cost Input Assumptions",null,null,null,null,null,null,"End User Cost (for summer and winter activity)"]
[null,"- i.e. earthworks, construction, floodlights, project costs, other"]
[]
[null,"Maintenance Cost Assumptions"]
[null,"- Field of play costs, power, insurance, other"]
[]
[null,"Lifecycle Capex Assumptions"]
[null,"- Renewal periods can be added or amended"]
[]
[null,"Operational Assumptions"]
[null,"- Winter and summer activity hours and weeks"]
[]
[null,"Cost Recovery/Contribution"]
[null,"- Percentage return or contribution against whole-of-life and maintenance costs"]
[]
[null,"Note 1: all yellow shaded cells are editable values"]
[null,"Note 2: more input rows can be added to the model as needed."]
[null,"Click here for more detailed information on model inputs and outputs:",null,null,null,"Sport NZ's Guidance Document for Sports Field Development"]
[]
[]
[null,"Acknowledgements"]
[null,"Sport NZ and Visitor Solutions would like to acknowledge and thank the State Government of Victoria for the initial base model (utilised in the 2013 model), the expertise of Deloitte and New Zealand Sports Turf Institute, and the inputs received from a range of contractors, suppliers and councils."]
[]
[null,"For further informationl please contact:"]
[null,"Mark Bowater, Spaces and Places Consultant"]
[null,"Sport New Zealand"]
[null,"mark.bowater@sportnz.org.nz"]

{"sheet":">>>","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Model Inputs","index":2,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,null,"Whole-of-Life cost model for soil, sand-carpet, hybrid and artificial sports fields"]
[null,null,"Financial assumptions"]
[null,null,null,null,null,null,null,null,null,"Commentary:","Graphical outputs"]
[null,null,"Cost input assumptions:",null,null,null,null,null,null,null,"Graphical Output (change field type here)"]
[null,null,"Inflation ","%",null,1.9E-2,"CPI Forecast | The Treasury New Zealand",null,null,"The overall general upward price movement of goods and services in an economy, usually as measured by the Consumer Price Index. ","Soil"]
[null,null,"Forward Risk Free Discount Rate (nominal)","%",null,5.9900000000000002E-2,"Discount Rate | The Treasury New Zealand",null,null,"A rate which reflects the difference in value of cash an investor would want in a years time in lieu of an equivalent cash payment today ( i.e. compound interest)"]
[]
[null,null,"Modelling to include inflation?","Yes/No",null,"Yes",null,null,null,"Real discount rate includes allowance for discount rate and  inflation. Only change if necessary "]
[null,null,"Modelled discount rate:","%",null,{"$f":"IF(F8=\"Yes\",F6,F6-F5)","v":5.9900000000000002E-2},null,null,null,"The discount rate which also takes into account inflation"]
[]
[null,null,"Input assumptions (GST exclusive):"]
[null,null,null,null,null,null,null,null,null,"Commentary:"]
[]
[null,null,"Construction cost input assumptions:",null,null,"Soil","Sand-Carpet","Hybrid","Artificial"]
[null,null,"Earthworks","NZ$",null,80000,85000,85000,85000]
[null,null,"Construction","NZ$",null,106000,428000,878000,2608000]
[null,null,"Floodlights","NZ$",null,null,280000,280000,280000]
[null,null,"Other (i.e. fencing, surrounds…)","NZ$",null,null,null,null,531000]
[null,null,"Project Costs (i.e. P&G, professional fees)","NZ$",null,67000,167000,212000,170000]
[null,null,"Total","NZ$",null,{"$f":"SUM(F15:F19)","v":253000},{"$f":"SUM(G15:G19)","v":960000},1455000,{"$f":"SUM(I15:I19)","v":3674000},"Capital costs can be estimated based on past experience.  Past costs will need to be indexed to present date rates"]
[]
[null,null,"Maintenance cost assumptions (annual):"]
[null,null,"Field of Play Costs","NZ$",null,20000,90000,90000,42000]
[null,null,"Power (i.e. for floodlights)","NZ$"]
[null,null,"Insurance","NZ$",null,null,null,null,7000]
[null,null,"Other","NZ$"]
[null,null,"Total ","NZ$",null,{"$f":"SUM(F23:F26)","v":20000},{"$f":"SUM(G23:G26)","v":90000},{"$f":"SUM(H23:H26)","v":90000},49000,"Maintenance costs can be estimated based on past experience.  Past costs will need to be indexed to present date rates"]
[]
[null,null,"Lifecycle capex assumptions:",null,null,null,null,null,null,"Renewal cost should include all remediation costs including  disposal of old carpet and drainage replacement"]
[null,null,"Renewal cost - 3 Years","NZ$",3,null,null,87000]
[null,null,"Renewal cost - 10 Years","NZ$",10,null,250000,null,1000000]
[null,null,"Renewal cost - 15 Years","NZ$",15]
[null,null,"Renewal cost - 20 Years","NZ$",20,null,null,1400000,250000]
[null,null,"Total","NZ$",null,{"$f":"SUM(Model!E19:AI22)","v":0},{"$f":"(SUM(Model!E44:AI47))*-1","v":1105753.4339091908},{"$f":"(SUM(Model!E69:AI72))*-1","v":3242426.41695377},{"$f":"(SUM(Model!E94:AI97))*-1","v":4787283.9730542507},"With inflation factored in against renewal periods over 30-years"]
[]
[null,null,"Operational assumptions:"]
[null,null,null,null,null,null,null,null,null,"Commentary:"]
[]
[null,null,"Winter game hours:",null,null,"Soil","Sand-Carpet","Hybrid","Artificial"]
[null,null,"Weeks in use games annually","Weeks",null,22,22,22,25,"Insert appropriate weeks depending on use. "]
[null,null,"No game days per week","No#",null,1,1,2,2,"Insert likely daily capacity of natural for each field type - see input assumptions on instructions page"]
[null,null,"Hours of use games daily","Hrs/Day",null,2,4,4,8,"Use past records to understand the typical achieved."]
[null,null,"Winter training hours:"]
[null,null,"Weeks in use training annually","Weeks",null,22,22,22,25,"Insert appropriate weeks depending on summer/winter use / all year round"]
[null,null,"Hours of use training weekly","Hr/Week",null,6,14,18,29,"Use past records to understand the typical achieved.  This should include a fair representation of down time etc"]
[]
[null,null,"Summer game hours:"]
[null,null,"Weeks in use games annually","Weeks",null,22,22,22,25,"Insert appropriate weeks depending on use. "]
[null,null,"No game days per week","No#",null,1,1,2,2,"Insert likely daily capacity of natural for each field type - see input assumptions on instructions page"]
[null,null,"Hours of use games daily","Hrs/Day",null,4,4,4,8,"Use past records to understand the typical achieved."]
[null,null,"Summer training hours:"]
[null,null,"Weeks in use training annually","Weeks",null,22,22,22,25,"Insert appropriate weeks depending on summer/winter use / all year round"]
[null,null,"Hours of use training weekly","Hr/Week",null,7,14,18,29,"Use past records to understand the typical achieved.  This should include a fair representation of down time etc"]
[]
[null,null,"Calculated outputs:"]
[null,null,null,null,null,null,null,null,null,"Commentary:"]
[null,null,null,null,null,"Soil","Sand-Carpet","Hybrid","Artificial"]
[null,null,"No. of game hours per annum","No#",null,{"$f":"(F40*F42*F41)+(F48*F49*F50)","v":132},{"$f":"(G40*G42*G41)+(G48*G49*G50)","v":176},{"$f":"(H40*H42*H41)+(H48*H49*H50)","v":352},{"$f":"(I40*I42*I41)+(I48*I49*I50)","v":800},"= Weeks in use games annually x hours of use games daily x number of game days per week"]
[null,null,"Training hours per annum","Hrs",null,{"$f":"(F44*F45)+(F52*F53)","v":286},{"$f":"(G44*G45)+(G52*G53)","v":616},792,1450,"= Weeks in use training annually x hours of use training daily x number of training days per week"]
[null,null,"Annual use hours","Hrs",null,{"$f":"F58+F59","v":418},{"$f":"G58+G59","v":792},{"$f":"H58+H59","v":1144},{"$f":"I58+I59","v":2250},"Annual use hours ( games and training)"]
[]
[null,null,"Lifecycle cost discounted","NZ$",null,{"$f":"-Model!AJ36","v":598264.48138382449},{"$f":"-Model!AJ61","v":2872928.7671938101},{"$f":"-Model!AJ86","v":4127012.4911374655},{"$f":"-Model!AJ111","v":6070648.0816935506},"Undiscounted cost including capital cost and on-going maintenance costs"]
[null,null,"Lifecycle revenue discounted","NZ$",null,{"$f":"Model!AJ37","v":598264.48138382414},{"$f":"Model!AJ62","v":2872928.7671938096},{"$f":"Model!AJ87","v":4127012.4911374669},{"$f":"Model!AJ112","v":6070648.0816935534},"Undiscounted revenue (should be equal to costs when targeted NPV set to 0)"]
[null,null,"Un-discounted net cashflow over 30 yrs","NZ$",null,{"$f":"Model!AJ31","v":343441.04995957762},{"$f":"Model!AJ56","v":1044317.9348960379},{"$f":"Model!AJ81","v":1369115.3591485838},{"$f":"Model!AJ106","v":3855931.1921399073},"Undiscounted net cashflow for each surface type based on the defined surface inputs listed in the table above"]
[null,null,"Cost per hour of play to achieve target NPV","$/Hr (GST Excl)",null,82.907731164016809,210.12502053930302,208.9718807382051,156.28979866519381,"Total cost per hour of play to achieve targeted NPV (model is currently set as zero for break even)"]
[]
[null,null,"GST inclusive price","$/Hr (GST Incl)",null,{"$f":"SoilHrRate*1.15","v":95.343890838619316},{"$f":"SandHrRate*1.15","v":241.64377362019846},{"$f":"ArtificialHrRate*1.15","v":240.31766284893584},{"$f":"OtherHrRate*1.15","v":179.73326846497287}]
[]
[null,null,"Cost Recovery/Contribution Percentage:"]
[null,null,null,null,null,null,null,null,null,"Commentary:"]
[]
[null,null,"Based on Whole-of-Life costs (30-year period):"]
[null,null,"Whole-of-Life Cost Recovery/Contribution %",0.03,null,{"$f":"$D$73*F67","v":2.8603167251585795},{"$f":"$D$73*G67","v":7.2493132086059537},7.2095298854680747,5.3919980539491856,"Include a cost recovery % target and apply this against the cost per hour (i.e. ask the question - how much do we want to subsidise and absorb by ourselves or rely on funding?)"]
[null,null,"Annual Winter Cost for Field Use (GST Incl.)","NZ$",null,{"$f":"((F40*F41*F42)+(F44*F45))*F73","v":503.41574362790999},{"$f":"((G40*G41*G42)+(G44*G45))*G73","v":2870.7280306079579},{"$f":"((H40*H41*H42)+(H44*H45))*H73","v":4123.8510944877389},{"$f":"((I40*I41*I42)+(I44*I45))*I73","v":6065.9978106928338},"Indicative annual cost for a club who is based at the field during the winter season (assumes all hours are allocated to one user)"]
[null,null,"Annual Summer Cost for Field Use (GST Incl.)","NZ$",null,{"$f":"((F48*F49*F50)+(F52*F53))*F73","v":692.19664748837624},{"$f":"((G48*G49*G50)+(G52*G53))*G73","v":2870.7280306079579},{"$f":"((H48*H49*H50)+(H52*H53))*H73","v":4123.8510944877389},{"$f":"((I48*I49*I50)+(I52*I53))*I73","v":6065.9978106928338},"Indicative annual cost for a club who is based at the field during the summer season (assumes all hours are allocated to one user)"]
[]
[null,null,"Based on annual maintenance costs (Year 1 cost only):"]
[null,null,"Annual Maintenance Cost Recovery/Contribution %",0.03,null,{"$f":"(F27/F60)*$D$78","v":1.4354066985645932},{"$f":"(G27/G60)*$D$78","v":3.4090909090909092},{"$f":"(H27/H60)*$D$78","v":2.36013986013986},{"$f":"(I27/I60)*$D$78","v":0.65333333333333332},"Include a cost recovery % target and apply this against the annual maintenance cost per hour (i.e. ask the question - how much do we want to subsidise and absorb by ourselves or rely on funding?)"]
[null,null,"Annual Winter Cost for Field Use (GST Incl.)","NZ$",null,{"$f":"((F40*F41*F42)+(F44*F45))*F78","v":252.63157894736841},{"$f":"((G40*G41*G42)+(G44*G45))*G78","v":1350},{"$f":"((H40*H41*H42)+(H44*H45))*H78","v":1350},{"$f":"((I40*I41*I42)+(I44*I45))*I78","v":735},"Indicative annual cost for a club who is based at the field during the winter season (assumes all hours are allocated to one user)"]
[null,null,"Annual Summer Cost for Field Use (GST Incl.)","NZ$",null,{"$f":"((F48*F49*F50)+(F52*F53))*F78","v":347.36842105263156},{"$f":"((G48*G49*G50)+(G52*G53))*G78","v":1350},{"$f":"((H48*H49*H50)+(H52*H53))*H78","v":1350},{"$f":"((I48*I49*I50)+(I52*I53))*I78","v":735},"Indicative annual cost for a club who is based at the field during the summer season (assumes all hours are allocated to one user)"]
[]
[]
[null,null,"Annual Winter Cost for Field Use (GST Incl.)",null,null,{"$f":"((F51*F52*F53)+(F56*F57))*F78","v":{"$error":"#VALUE!"}},{"$f":"((G51*G52*G53)+(G56*G57))*G78","v":{"$error":"#VALUE!"}},{"$f":"((H51*H52*H53)+(H56*H57))*H78","v":{"$error":"#VALUE!"}},{"$f":"((I51*I52*I53)+(I56*I57))*I78","v":{"$error":"#VALUE!"}},"Indicative annual cost for a club who is based at the field during the winter season (assumes all hours are allocated to one user)"]
[]
[null,null,"Annual Summer Cost for Field Use (GST Incl.)",null,null,{"$f":"((F60*F61*F62)+(F64*F65))*F78","v":40871652.977133483},{"$f":"((G60*G61*G62)+(G64*G65))*G78","v":748081798.36224711},{"$f":"((H60*H61*H62)+(H64*H65))*H78","v":675251618.16597497},{"$f":"((I60*I61*I62)+(I64*I65))*I78","v":393726570.32843935},"Indicative annual cost for a club who is based at the field during the summer season (assumes all hours are allocated to one user)"]
[null,null,"Total Costs Over 30-Years","NZ$",null,{"$f":"F20+F34+F87","v":1066952.21260995},{"$f":"G20+G34+G87","v":5728538.390653966},{"$f":"H20+H34+H87","v":8360211.3736985456},{"$f":"I20+I34+I87","v":10455466.893948628},"Total costs over 30-years"]
[null,null,"Total Maintenance Costs Over 30-Years","NZ$",null,{"$f":"(SUM(Model!E17:AI17))*-1","v":813952.21260994987},{"$f":"(SUM(Model!E42:AI42))*-1","v":3662784.9567447747},{"$f":"SUM(Model!E67:AI67)*-1","v":3662784.9567447747},{"$f":"SUM(Model!E92:AI92)*-1","v":1994182.9208943774},"Maintenance over 30-years (includes inflation)"]

{"sheet":"Disclaimer","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,35,11]]}
[]
[null,"DISCLAIMER\n\nThis financial model (\"the Model\") and the accompanying assumptions have been prepared by Sport NZ with assistance from Visitor Solutions. The Model has been developed as a general planning and decision-support tool to assist organisations in assessing the potential financial performance of sport and recreation facility projects.\n\nThe Model is made publicly available for information and planning purposes only. While reasonable care has been taken in its preparation, Sport NZ and Visitor Solutions make no representation or warranty, express or implied, as to the accuracy, completeness, reliability or suitability of the Model or the assumptions contained within it for any particular purpose.\n\nThe Model includes forecasts and financial projections that are based on assumptions and estimates. Forecasts are inherently uncertain and involve future events and circumstances, many of which are beyond the control of Sport NZ, Visitor Solutions and the organisations using the Model. Actual results are likely to differ from those forecast, and such differences may be material.\n\nUsers are responsible for reviewing, validating and adapting the assumptions and inputs to reflect their own circumstances. The outputs generated by the Model should not be relied upon as the sole basis for investment, funding or business decisions and do not constitute financial, legal, accounting or professional advice. Users should obtain independent professional advice where appropriate.\n\nTo the fullest extent permitted by law, Sport NZ and Visitor Solutions, including their respective affiliates, directors, employees and agents, accept no liability for any loss, damage, cost or expense arising directly or indirectly from the use of, or reliance on, the Model or any outputs it produces.\n\nJune 2026"]

{"sheet":"Model","index":4,"n_rows":126,"n_cols":36,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Do not edit: The following sheet is for reference only.  This sheet includes all the workings that are represented in the Model inputs sheet."]
[]
[null,"Year",null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,"Total"]
[]
[null,"Inflation Rate","%",{"$f":"'Model Inputs'!F5*IF('Model Inputs'!F8=\"No\",0,1)","v":1.9E-2}]
[null,"Capex Timing","Flag:",null,1]
[null,"Replacement Cycle:"]
[null,{"$f":"'Model Inputs'!E30","v":3},"Flag:",null,null,{"$f":"IF(MOD(F$4,$B9)=0,1,0)","v":0},{"$f":"IF(MOD(G$4,$B9)=0,1,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1]
[null,{"$f":"'Model Inputs'!E31","v":10},"Flag:",null,null,{"$f":"IF(MOD(F$4,$B10)=0,1,0)","v":0},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1]
[null,{"$f":"'Model Inputs'!E32","v":15},"Flag:",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,{"$f":"'Model Inputs'!E33","v":20},"Flag:",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0]
[]
[null,"SOIL"]
[null,"COSTS:"]
[null,"Construction","NZ$:",{"$f":"'Model Inputs'!$F$20","v":253000},{"$f":"-$D16*E$7","v":-253000},{"$f":"-$D16*F$7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E16:AI16)","v":-253000}]
[null,"Maintenance","NZ$:",{"$f":"'Model Inputs'!$F$27","v":20000},null,{"$f":"-$D17*(1+$D$6)^F$4","v":-20379.999999999996},{"$f":"-$D17*(1+$D$6)^G$4","v":-20767.219999999998},-21161.797179999998,-21563.871326419998,-21973.584881621973,-22391.082994372791,-22816.513571265874,-23250.027329119923,-23691.7778483732,-24141.921627492291,-24600.618138414644,-25068.029883044521,-25544.322450822361,-26029.664577387994,-26524.228204358362,-27028.188540241168,-27541.724122505751,-28065.016880833355,-28598.25220156919,-29141.618993399003,-29695.309754273581,-30259.520639604783,-30834.45153175727,-31420.30611086066,-32017.291926967006,-32625.62047357938,-33245.50726257739,-33877.171900566354,-34520.838166677109,-35176.73409184398,{"$f":"SUM(E17:AI17)","v":-813952.21260994987}]
[null,"Replacement costs:"]
[null,{"$f":"'Model Inputs'!C30","v":"Renewal cost - 3 Years"},"NZ$:",{"$f":"'Model Inputs'!F30","v":0},null,{"$f":"-$D19*F$9*(1+$D$6)^F$4","v":0},{"$f":"-$D19*G$9*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E19:AI19)","v":0}]
[null,{"$f":"'Model Inputs'!C31","v":"Renewal cost - 10 Years"},"NZ$:",{"$f":"'Model Inputs'!F31","v":0},null,{"$f":"-$D20*F$10*(1+$D$6)^F$4","v":0},{"$f":"-$D20*G$10*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C32","v":"Renewal cost - 15 Years"},"NZ$:",{"$f":"'Model Inputs'!F32","v":0},null,{"$f":"-$D21*F$11*(1+$D$6)^F$4","v":0},{"$f":"-$D21*G$11*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C33","v":"Renewal cost - 20 Years"},"NZ$:",{"$f":"'Model Inputs'!F33","v":0},null,{"$f":"-$D22*F$12*(1+$D$6)^F$4","v":0},{"$f":"-$D22*G$12*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Cash Outflows","NZ$:",null,{"$f":"SUM(E16:E22)","v":-253000},{"$f":"SUM(F16:F22)","v":-20379.999999999996},-20767.219999999998,-21161.797179999998,-21563.871326419998,-21973.584881621973,-22391.082994372791,-22816.513571265874,-23250.027329119923,-23691.7778483732,-24141.921627492291,-24600.618138414644,-25068.029883044521,-25544.322450822361,-26029.664577387994,-26524.228204358362,-27028.188540241168,-27541.724122505751,-28065.016880833355,-28598.25220156919,-29141.618993399003,-29695.309754273581,-30259.520639604783,-30834.45153175727,-31420.30611086066,-32017.291926967006,-32625.62047357938,-33245.50726257739,-33877.171900566354,-34520.838166677109,-35176.73409184398,-1066952.21260995]
[]
[null,"Revenue:"]
[null,"Game revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^F$4","v":11151.753103409572},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^G$4","v":11363.636412374353},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^H$4","v":11579.545504209465},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^I$4","v":11799.556868789445},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^J$4","v":12023.748449296443},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^K$4","v":12252.199669833077},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^L$4","v":12484.991463559905},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^M$4","v":12722.206301367542},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^N$4","v":12963.928221093523},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^O$4","v":13210.242857294301},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^P$4","v":13461.237471582892},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^Q$4","v":13717.000983542965},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^R$4","v":13977.624002230279},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^S$4","v":14243.198858272657},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^T$4","v":14513.819636579838},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^U$4","v":14789.582209674852},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^V$4","v":15070.584271658674},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^W$4","v":15356.925372820187},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^X$4","v":15648.706954903771},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^Y$4","v":15946.032387046942},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^Z$4","v":16249.007002400833},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AA$4","v":16557.738135446452},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AB$4","v":16872.335160019931},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AC$4","v":17192.909528060311},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AD$4","v":17519.574809093454},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AE$4","v":17852.446730466228},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AF$4","v":18191.643218345085},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AG$4","v":18537.28443949364},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AH$4","v":18889.492843844015},{"$f":"'Model Inputs'!$F$58*'Model Inputs'!$F$65*(1+$D$6)^AI$4","v":19248.393207877059},{"$f":"SUM(E27:AI27)","v":445387.34607458755}]
[null,"Training revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^F$4","v":24162.13172405407},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^G$4","v":24621.212226811098},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^H$4","v":25089.015259120508},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^I$4","v":25565.706549043796},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^J$4","v":26051.454973475626},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^K$4","v":26546.432617971666},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^L$4","v":27050.814837713126},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^M$4","v":27564.780319629674},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^N$4","v":28088.511145702632},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^O$4","v":28622.192857470982},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^P$4","v":29166.014521762932},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^Q$4","v":29720.168797676422},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^R$4","v":30284.852004832272},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^S$4","v":30860.264192924089},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^T$4","v":31446.609212589647},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^U$4","v":32044.094787628848},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^V$4","v":32652.932588593794},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^W$4","v":33273.33830777707},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^X$4","v":33905.531735624842},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^Y$4","v":34549.736838601704},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^Z$4","v":35206.181838535136},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AA$4","v":35875.099293467312},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AB$4","v":36556.726180043181},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AC$4","v":37251.303977464006},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AD$4","v":37959.078753035814},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AE$4","v":38680.301249343494},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AF$4","v":39415.226973081022},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AG$4","v":40164.116285569551},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AH$4","v":40927.234494995369},{"$f":"'Model Inputs'!$F$59*'Model Inputs'!$F$65*(1+$D$6)^AI$4","v":41704.851950400291},965005.91649493994]
[null,"Total Revenue","NZ$:",null,{"$f":"SUM(E27:E28)","v":0},{"$f":"SUM(F27:F28)","v":35313.88482746364},35984.848639185453,36668.560763329973,37365.263417833237,38075.203422772072,38798.632287804743,39535.806301273027,40286.986620997217,41052.439366796156,41832.435714765285,42627.251993345824,43437.169781219389,44262.476007062549,45103.463051196748,45960.428849169482,46833.676997303701,47723.516860252465,48630.263680597258,49554.238690528611,50495.769225648648,51455.188840935967,52432.837428913765,53429.061340063112,54444.213505524312,55478.653562129271,56532.747979809719,57606.870191426104,58701.400725063191,59816.727338839381,60953.24515827735,1410393.2625695276]
[]
[null,"Net Cash flow","NZ$:",null,{"$f":"E29+E24","v":-253000},14933.884827463644,15217.628639185456,15506.763583329976,15801.39209141324,16101.618541150099,16407.549293431952,16719.292730007153,17036.959291877294,17360.661518422956,17690.514087272993,18026.63385493118,18369.139898174868,18718.153556240188,19073.798473808754,19436.200644811121,19805.488457062533,20181.792737746713,20565.246799763903,20955.986488959421,21354.150232249645,21759.879086662386,22173.316789308981,22594.609808305842,23023.907394663653,23461.361635162266,23907.127506230339,24361.362928848714,24824.228824496837,25295.889172162271,25776.51106643337,343441.04995957762]
[null,"Cumulative Cash Flow","NZ$:",null,{"$f":"E31","v":-253000},{"$f":"E32+F31","v":-238066.11517253635},{"$f":"F32+G31","v":-222848.48653335089},-207341.72295002092,-191540.33085860769,-175438.7123174576,-159031.16302402565,-142311.8702940185,-125274.91100214121,-107914.24948371825,-90223.735396445249,-72197.101541514072,-53827.961643339208,-35109.808087099023,-16036.009613290269,3400.1910315208515,23205.679488583384,43387.472226330094,63952.719026093997,84908.705515053414,106262.85574730305,128022.73483396544,150196.05162327443,172790.66143158026,195814.56882624392,219275.93046140618,243183.05796763653,267544.42089648522,292368.64972098207,317664.53889314434,343441.04995957774]
[null,"Discounted cashflow","NZ$:",null,{"$f":"E31/(1+'Model Inputs'!$F$9)^E$4","v":-253000},{"$f":"F31/(1+'Model Inputs'!$F$9)^F4","v":14089.899827779642},{"$f":"G31/(1+'Model Inputs'!$F$9)^G4","v":13546.191078882401},{"$f":"H31/(1+'Model Inputs'!$F$9)^H4","v":13023.463260101104},{"$f":"I31/(1+'Model Inputs'!$F$9)^I4","v":12520.906747846984},{"$f":"J31/(1+'Model Inputs'!$F$9)^J4","v":12037.743160728449},{"$f":"K31/(1+'Model Inputs'!$F$9)^K4","v":11573.22415396008},{"$f":"L31/(1+'Model Inputs'!$F$9)^L4","v":11126.630260293721},{"$f":"M31/(1+'Model Inputs'!$F$9)^M4","v":10697.269775676294},{"$f":"N31/(1+'Model Inputs'!$F$9)^N4","v":10284.477687908426},{"$f":"O31/(1+'Model Inputs'!$F$9)^O4","v":9887.614646644668},{"$f":"P31/(1+'Model Inputs'!$F$9)^P4","v":9506.0659731398391},{"$f":"Q31/(1+'Model Inputs'!$F$9)^Q4","v":9139.2407082078425},{"$f":"R31/(1+'Model Inputs'!$F$9)^R4","v":8786.5706969183793},{"$f":"S31/(1+'Model Inputs'!$F$9)^S4","v":8447.5097086138576},{"$f":"T31/(1+'Model Inputs'!$F$9)^T4","v":8121.5325908835939},{"$f":"U31/(1+'Model Inputs'!$F$9)^U4","v":7808.1344561849046},{"$f":"V31/(1+'Model Inputs'!$F$9)^V4","v":7506.8298998513201},{"$f":"W31/(1+'Model Inputs'!$F$9)^W4","v":7217.1522482767205},{"$f":"X31/(1+'Model Inputs'!$F$9)^X4","v":6938.6528361109322},{"$f":"Y31/(1+'Model Inputs'!$F$9)^Y4","v":6670.9003113473327},{"$f":"Z31/(1+'Model Inputs'!$F$9)^Z4","v":6413.4799672260879},{"$f":"AA31/(1+'Model Inputs'!$F$9)^AA4","v":6165.9930999182807},{"$f":"AB31/(1+'Model Inputs'!$F$9)^AB4","v":5928.0563909960611},{"$f":"AC31/(1+'Model Inputs'!$F$9)^AC4","v":5699.3013137324142},{"$f":"AD31/(1+'Model Inputs'!$F$9)^AD4","v":5479.3735623109069},{"$f":"AE31/(1+'Model Inputs'!$F$9)^AE4","v":5267.9325030614309},{"$f":"AF31/(1+'Model Inputs'!$F$9)^AF4","v":5064.6506468719672},{"$f":"AG31/(1+'Model Inputs'!$F$9)^AG4","v":4869.2131419591778},{"$f":"AH31/(1+'Model Inputs'!$F$9)^AH4","v":4681.3172862122847},{"$f":"AI31/(1+'Model Inputs'!$F$9)^AI4","v":4500.672058354864},{"$f":"SUM(E33:AI33)","v":0}]
[]
[null,"Net Present Value","NZ$:",null,{"$f":"AJ33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:AI35)","v":0}]
[null,"Discounted costs","NZ$:",null,{"$f":"E24/(1+'Model Inputs'!$F$9)^E$4","v":-253000},{"$f":"F24/(1+'Model Inputs'!$F$9)^F$4","v":-19228.229078214921},{"$f":"G24/(1+'Model Inputs'!$F$9)^G$4","v":-18486.239674215496},{"$f":"H24/(1+'Model Inputs'!$F$9)^H$4","v":-17772.882562530038},{"$f":"I24/(1+'Model Inputs'!$F$9)^I$4","v":-17087.052864626952},{"$f":"J24/(1+'Model Inputs'!$F$9)^J$4","v":-16427.688337630778},{"$f":"K24/(1+'Model Inputs'!$F$9)^K$4","v":-15793.767729074212},{"$f":"L24/(1+'Model Inputs'!$F$9)^L$4","v":-15184.309195137863},{"$f":"M24/(1+'Model Inputs'!$F$9)^M$4","v":-14598.368779927803},{"$f":"N24/(1+'Model Inputs'!$F$9)^N$4","v":-14035.038953435636},{"$f":"O24/(1+'Model Inputs'!$F$9)^O$4","v":-13493.447205916511},{"$f":"P24/(1+'Model Inputs'!$F$9)^P$4","v":-12972.754696508089},{"$f":"Q24/(1+'Model Inputs'!$F$9)^Q$4","v":-12472.154953997302},{"$f":"R24/(1+'Model Inputs'!$F$9)^R$4","v":-11990.87262772266},{"$f":"S24/(1+'Model Inputs'!$F$9)^S$4","v":-11528.162286677414},{"$f":"T24/(1+'Model Inputs'!$F$9)^T$4","v":-11083.307264953564},{"$f":"U24/(1+'Model Inputs'!$F$9)^U$4","v":-10655.61855173854},{"$f":"V24/(1+'Model Inputs'!$F$9)^V$4","v":-10244.43372414527},{"$f":"W24/(1+'Model Inputs'!$F$9)^W$4","v":-9849.1159212227831},{"$f":"X24/(1+'Model Inputs'!$F$9)^X$4","v":-9469.0528575582739},{"$f":"Y24/(1+'Model Inputs'!$F$9)^Y$4","v":-9103.6558749428059},{"$f":"Z24/(1+'Model Inputs'!$F$9)^Z$4","v":-8752.3590306318692},{"$f":"AA24/(1+'Model Inputs'!$F$9)^AA$4","v":-8414.6182207886341},{"$f":"AB24/(1+'Model Inputs'!$F$9)^AB$4","v":-8089.9103377522561},{"$f":"AC24/(1+'Model Inputs'!$F$9)^AC$4","v":-7777.7324598259738},{"$f":"AD24/(1+'Model Inputs'!$F$9)^AD$4","v":-7477.6010723300915},{"$f":"AE24/(1+'Model Inputs'!$F$9)^AE$4","v":-7189.0513187134284},{"$f":"AF24/(1+'Model Inputs'!$F$9)^AF$4","v":-6911.6362805632452},{"$f":"AG24/(1+'Model Inputs'!$F$9)^AG$4","v":-6644.9262853985701},{"$f":"AH24/(1+'Model Inputs'!$F$9)^AH$4","v":-6388.5082411747717},{"$f":"AI24/(1+'Model Inputs'!$F$9)^AI$4","v":-6141.9849964686227},{"$f":"SUM(E36:AI36)","v":-598264.48138382449}]
[null,"Discounted revenues","NZ$:",null,{"$f":"E29/(1+'Model Inputs'!$F$9)^E$4","v":0},{"$f":"F29/(1+'Model Inputs'!$F$9)^F$4","v":33318.128905994563},{"$f":"G29/(1+'Model Inputs'!$F$9)^G$4","v":32032.430753097895},{"$f":"H29/(1+'Model Inputs'!$F$9)^H$4","v":30796.345822631141},{"$f":"I29/(1+'Model Inputs'!$F$9)^I$4","v":29607.959612473936},{"$f":"J29/(1+'Model Inputs'!$F$9)^J$4","v":28465.431498359227},{"$f":"K29/(1+'Model Inputs'!$F$9)^K$4","v":27366.99188303429},{"$f":"L29/(1+'Model Inputs'!$F$9)^L$4","v":26310.939455431584},{"$f":"M29/(1+'Model Inputs'!$F$9)^M$4","v":25295.638555604099},{"$f":"N29/(1+'Model Inputs'!$F$9)^N$4","v":24319.51664134406},{"$f":"O29/(1+'Model Inputs'!$F$9)^O$4","v":23381.061852561179},{"$f":"P29/(1+'Model Inputs'!$F$9)^P$4","v":22478.820669647928},{"$f":"Q29/(1+'Model Inputs'!$F$9)^Q$4","v":21611.395662205145},{"$f":"R29/(1+'Model Inputs'!$F$9)^R$4","v":20777.443324641037},{"$f":"S29/(1+'Model Inputs'!$F$9)^S$4","v":19975.671995291272},{"$f":"T29/(1+'Model Inputs'!$F$9)^T$4","v":19204.839855837159},{"$f":"U29/(1+'Model Inputs'!$F$9)^U$4","v":18463.753007923446},{"$f":"V29/(1+'Model Inputs'!$F$9)^V$4","v":17751.26362399659},{"$f":"W29/(1+'Model Inputs'!$F$9)^W$4","v":17066.268169499504},{"$f":"X29/(1+'Model Inputs'!$F$9)^X$4","v":16407.705693669206},{"$f":"Y29/(1+'Model Inputs'!$F$9)^Y$4","v":15774.556186290138},{"$f":"Z29/(1+'Model Inputs'!$F$9)^Z$4","v":15165.838997857956},{"$f":"AA29/(1+'Model Inputs'!$F$9)^AA$4","v":14580.611320706916},{"$f":"AB29/(1+'Model Inputs'!$F$9)^AB$4","v":14017.966728748317},{"$f":"AC29/(1+'Model Inputs'!$F$9)^AC$4","v":13477.033773558387},{"$f":"AD29/(1+'Model Inputs'!$F$9)^AD$4","v":12956.974634640997},{"$f":"AE29/(1+'Model Inputs'!$F$9)^AE$4","v":12456.98382177486},{"$f":"AF29/(1+'Model Inputs'!$F$9)^AF$4","v":11976.286927435212},{"$f":"AG29/(1+'Model Inputs'!$F$9)^AG$4","v":11514.139427357748},{"$f":"AH29/(1+'Model Inputs'!$F$9)^AH$4","v":11069.825527387056},{"$f":"AI29/(1+'Model Inputs'!$F$9)^AI$4","v":10642.657054823487},{"$f":"SUM(E37:AI37)","v":598264.48138382414}]
[]
[null,"SAND-CARPET"]
[null,"COSTS"]
[null,"Construction","NZ$:",{"$f":"'Model Inputs'!$G$20","v":960000},{"$f":"-$D41*E$7","v":-960000},{"$f":"-$D41*F$7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E41:AI41)","v":-960000}]
[null,"Maintenance","NZ$:",{"$f":"'Model Inputs'!G27","v":90000},null,{"$f":"-$D42*(1+$D$6)^F$4","v":-91709.999999999985},{"$f":"-$D42*(1+$D$6)^G$4","v":-93452.489999999991},-95228.087309999988,-97037.420968889986,-98881.131967298876,-100759.87347467757,-102674.31107069644,-104625.12298103966,-106613.0003176794,-108638.64732371531,-110702.78162286591,-112806.13447370034,-114949.45102870063,-117133.49059824596,-119359.02691961263,-121626.84843108527,-123937.75855127588,-126292.5759637501,-128692.13490706137,-131137.28547029552,-133628.89389423112,-136167.84287822153,-138755.03189290772,-141391.37749887296,-144077.81367135153,-146815.29213110721,-149604.78268159824,-152447.27355254858,-155343.77175004699,-158295.30341329792,{"$f":"SUM(E42:AI42)","v":-3662784.9567447747}]
[null,"Replacement costs:"]
[null,{"$f":"'Model Inputs'!C30","v":"Renewal cost - 3 Years"},"NZ$:",{"$f":"'Model Inputs'!G30","v":0},null,{"$f":"-$D44*F$9*(1+$D$6)^F$4","v":0},{"$f":"-$D44*G$9*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E44:AI44)","v":0}]
[null,{"$f":"'Model Inputs'!C31","v":"Renewal cost - 10 Years"},"NZ$:",{"$f":"'Model Inputs'!G31","v":250000},null,{"$f":"-$D45*F$10*(1+$D$6)^F$4","v":0},{"$f":"-$D45*G$10*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,-301774.02034365362,0,0,0,0,0,0,0,0,0,-364270.23741748754,0,0,0,0,0,0,0,0,0,-439709.17614804977,-1105753.4339091908]
[null,{"$f":"'Model Inputs'!C32","v":"Renewal cost - 15 Years"},"NZ$:",{"$f":"'Model Inputs'!G32","v":0},null,{"$f":"-$D46*F$11*(1+$D$6)^F$4","v":0},{"$f":"-$D46*G$11*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C33","v":"Renewal cost - 20 Years"},"NZ$:",{"$f":"'Model Inputs'!G33","v":0},null,{"$f":"-$D47*F$12*(1+$D$6)^F$4","v":0},{"$f":"-$D47*G$12*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total costs","NZ$:",null,{"$f":"SUM(E41:E48)","v":-960000},{"$f":"SUM(F41:F48)","v":-91709.999999999985},-93452.489999999991,-95228.087309999988,-97037.420968889986,-98881.131967298876,-100759.87347467757,-102674.31107069644,-104625.12298103966,-106613.0003176794,-410412.66766736895,-110702.78162286591,-112806.13447370034,-114949.45102870063,-117133.49059824596,-119359.02691961263,-121626.84843108527,-123937.75855127588,-126292.5759637501,-128692.13490706137,-495407.52288778307,-133628.89389423112,-136167.84287822153,-138755.03189290772,-141391.37749887296,-144077.81367135153,-146815.29213110721,-149604.78268159824,-152447.27355254858,-155343.77175004699,-598004.47956134775,{"$f":"SUM(E49:AI49)","v":-5728538.3906539641}]
[]
[null,"Revenue:"]
[null,"Game revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^F$4","v":37684.66168360076},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^G$4","v":38400.670255589168},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^H$4","v":39130.282990445368},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^I$4","v":39873.758367263828},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^J$4","v":40631.359776241829},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^K$4","v":41403.355611990431},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^L$4","v":42190.019368618247},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^M$4","v":42991.629736621988},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^N$4","v":43808.470701617807},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^O$4","v":44640.831644948543},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^P$4","v":45489.007446202566},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^Q$4","v":46353.298587680409},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^R$4","v":47234.011260846324},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^S$4","v":48131.457474802417},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^T$4","v":49045.95516682366},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^U$4","v":49977.828314993305},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^V$4","v":50927.407052978175},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^W$4","v":51895.027786984756},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^X$4","v":52881.033314937471},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^Y$4","v":53885.772947921279},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^Z$4","v":54909.602633931776},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AA$4","v":55952.885083976485},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AB$4","v":57015.989900572029},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AC$4","v":58099.293708682897},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AD$4","v":59203.180289147866},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AE$4","v":60328.040714641676},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AF$4","v":61474.273488219871},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AG$4","v":62642.284684496037},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AH$4","v":63832.488093501452},{"$f":"'Model Inputs'!$G58*'Model Inputs'!$G$65*(1+$D$6)^AI$4","v":65045.305367277993},{"$f":"SUM(E52:AI52)","v":1505079.1834555564}]
[null,"Training revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^F$4","v":131896.31589260264},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^G$4","v":134402.34589456208},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^H$4","v":136955.99046655878},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^I$4","v":139558.1542854234},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^J$4","v":142209.7592168464},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^K$4","v":144911.74464196651},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^L$4","v":147665.06779016386},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^M$4","v":150470.70407817696},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^N$4","v":153329.64745566231},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^O$4","v":156242.91075731989},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^P$4","v":159211.52606170898},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^Q$4","v":162236.54505688141},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^R$4","v":165319.03941296213},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^S$4","v":168460.10116180844},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^T$4","v":171660.84308388279},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^U$4","v":174922.39910247657},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^V$4","v":178245.92468542361},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^W$4","v":181632.59725444665},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^X$4","v":185083.61660228114},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^Y$4","v":188600.20531772447},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^Z$4","v":192183.60921876121},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AA$4","v":195835.0977939177},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AB$4","v":199555.96465200209},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AC$4","v":203347.52798039015},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AD$4","v":207211.13101201752},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AE$4","v":211148.14250124586},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AF$4","v":215159.95720876954},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AG$4","v":219247.99639573612},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AH$4","v":223413.70832725507},{"$f":"'Model Inputs'!$G59*'Model Inputs'!$G$65*(1+$D$6)^AI$4","v":227658.56878547298},5267777.1420944463]
[null,"Total Revenue","NZ$:",null,{"$f":"SUM(E52:E53)","v":0},169580.97757620341,172803.01615015126,176086.27345700416,179431.91265268723,182841.11899308822,186315.10025395695,189855.08715878212,193462.33381479894,197138.11815728011,200883.74240226843,204700.53350791155,208589.84364456183,212553.05067380844,216591.55863661086,220706.79825070646,224900.22741746987,229173.33173840179,233527.6250414314,237964.6499172186,242485.97826564574,247093.211852693,251787.98287789419,256571.95455257411,261446.82168907305,266414.31130116538,271476.18321588752,276634.2306969894,281890.28108023218,287246.19642075652,292703.87415275094,6772856.325550002]
[]
[null,"Net Cash flow","NZ$:",null,{"$f":"E54+E49","v":-960000},77870.977576203426,79350.526150151272,80858.186147004177,82394.491683797241,83959.987025789349,85555.226779279372,87180.77608808568,88837.21083375928,90525.117839600716,-209528.92526510052,93997.75188504564,95783.70917086149,97603.59964510781,99458.068038364901,101347.77133109383,103273.3789863846,105235.5731871259,107235.04907768129,109272.51501015724,-252921.54462213733,113464.31795846188,115620.13999967265,117816.92265966639,120055.4441902001,122336.49762981385,124660.89108478031,127029.44801539116,129443.0075276836,131902.42467070953,-305300.60540859681,{"$f":"SUM(E56:AI56)","v":1044317.9348960379}]
[null,"Cumulative Cash Flow","NZ$:",null,{"$f":"E56","v":-960000},{"$f":"E57+F56","v":-882129.02242379659},{"$f":"F57+G56","v":-802778.49627364532},{"$f":"G57+H56","v":-721920.31012664118},{"$f":"H57+I56","v":-639525.81844284397},{"$f":"I57+J56","v":-555565.83141705464},{"$f":"J57+K56","v":-470010.60463777528},{"$f":"K57+L56","v":-382829.82854968961},{"$f":"L57+M56","v":-293992.61771593033},{"$f":"M57+N56","v":-203467.49987632962},{"$f":"N57+O56","v":-412996.42514143011},{"$f":"O57+P56","v":-318998.67325638444},{"$f":"P57+Q56","v":-223214.96408552295},{"$f":"Q57+R56","v":-125611.36444041514},{"$f":"R57+S56","v":-26153.29640205024},{"$f":"S57+T56","v":75194.474929043587},{"$f":"T57+U56","v":178467.85391542819},{"$f":"U57+V56","v":283703.42710255412},{"$f":"V57+W56","v":390938.47618023539},{"$f":"W57+X56","v":500210.99119039264},{"$f":"X57+Y56","v":247289.44656825531},{"$f":"Y57+Z56","v":360753.76452671719},{"$f":"Z57+AA56","v":476373.90452638984},{"$f":"AA57+AB56","v":594190.82718605618},{"$f":"AB57+AC56","v":714246.27137625625},{"$f":"AC57+AD56","v":836582.7690060701},{"$f":"AD57+AE56","v":961243.66009085043},{"$f":"AE57+AF56","v":1088273.1081062416},{"$f":"AF57+AG56","v":1217716.1156339252},{"$f":"AG57+AH56","v":1349618.5403046347},{"$f":"AH57+AI56","v":1044317.9348960379}]
[null,"Discounted cashflow","NZ$:",null,{"$f":"E56/(1+'Model Inputs'!$F$9)^E4","v":-960000},{"$f":"F56/(1+'Model Inputs'!$F$9)^F$4","v":73470.117535808487},{"$f":"G56/(1+'Model Inputs'!$F$9)^G$4","v":70635.012519095035},{"$f":"H56/(1+'Model Inputs'!$F$9)^H$4","v":67909.310082986936},{"$f":"I56/(1+'Model Inputs'!$F$9)^I$4","v":65288.788540960159},{"$f":"J56/(1+'Model Inputs'!$F$9)^J$4","v":62769.389115235746},{"$f":"K56/(1+'Model Inputs'!$F$9)^K$4","v":60347.209650368175},{"$f":"L56/(1+'Model Inputs'!$F$9)^L$4","v":58018.498569417083},{"$f":"M56/(1+'Model Inputs'!$F$9)^M$4","v":55779.649063341807},{"$f":"N56/(1+'Model Inputs'!$F$9)^N$4","v":53627.193504618648},{"$f":"O56/(1+'Model Inputs'!$F$9)^O$4","v":-117110.29199752807},{"$f":"P56/(1+'Model Inputs'!$F$9)^P$4","v":49568.257609095643},{"$f":"Q56/(1+'Model Inputs'!$F$9)^Q$4","v":47655.490615783041},{"$f":"R56/(1+'Model Inputs'!$F$9)^R$4","v":45816.534519749868},{"$f":"S56/(1+'Model Inputs'!$F$9)^S$4","v":44048.54106578463},{"$f":"T56/(1+'Model Inputs'!$F$9)^T$4","v":42348.771908703209},{"$f":"U56/(1+'Model Inputs'!$F$9)^U$4","v":40714.594372080915},{"$f":"V56/(1+'Model Inputs'!$F$9)^V$4","v":39143.477370648594},{"$f":"W56/(1+'Model Inputs'!$F$9)^W$4","v":37632.98749003766},{"$f":"X56/(1+'Model Inputs'!$F$9)^X$4","v":36180.785217802026},{"$f":"Y56/(1+'Model Inputs'!$F$9)^Y$4","v":-79011.077116905595},{"$f":"Z56/(1+'Model Inputs'!$F$9)^Z$4","v":33442.333356880074},{"$f":"AA56/(1+'Model Inputs'!$F$9)^AA$4","v":32151.842334805911},{"$f":"AB56/(1+'Model Inputs'!$F$9)^AB$4","v":30911.149485014823},{"$f":"AC56/(1+'Model Inputs'!$F$9)^AC$4","v":29718.333168440524},{"$f":"AD56/(1+'Model Inputs'!$F$9)^AD$4","v":28571.545899274344},{"$f":"AE56/(1+'Model Inputs'!$F$9)^AE$4","v":27469.011483498965},{"$f":"AF56/(1+'Model Inputs'!$F$9)^AF$4","v":26409.02226784173},{"$f":"AG56/(1+'Model Inputs'!$F$9)^AG$4","v":25389.936494886988},{"$f":"AH56/(1+'Model Inputs'!$F$9)^AH$4","v":24410.175760250804},{"$f":"AI56/(1+'Model Inputs'!$F$9)^AI$4","v":-53306.589887978211},{"$f":"SUM(E58:AI58)","v":-6.5483618527650833E-11}]
[]
[null,"Net Present Value","NZ$:",null,{"$f":"AJ58","v":-6.5483618527650833E-11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6.5483618527650833E-11]
[null,{"$f":"B36","v":"Discounted costs"},"NZ$:",null,{"$f":"E49/(1+'Model Inputs'!$F$9)^E$4","v":-960000},{"$f":"F49/(1+'Model Inputs'!$F$9)^F$4","v":-86527.030851967153},{"$f":"G49/(1+'Model Inputs'!$F$9)^G$4","v":-83188.078533969732},{"$f":"H49/(1+'Model Inputs'!$F$9)^H$4","v":-79977.971531385163},{"$f":"I49/(1+'Model Inputs'!$F$9)^I$4","v":-76891.737890821285},{"$f":"J49/(1+'Model Inputs'!$F$9)^J$4","v":-73924.597519338495},{"$f":"K49/(1+'Model Inputs'!$F$9)^K$4","v":-71071.95478083397},{"$f":"L49/(1+'Model Inputs'!$F$9)^L$4","v":-68329.391378120388},{"$f":"M49/(1+'Model Inputs'!$F$9)^M$4","v":-65692.659509675126},{"$f":"N49/(1+'Model Inputs'!$F$9)^N$4","v":-63157.675290460364},{"$f":"O49/(1+'Model Inputs'!$F$9)^O$4","v":-229388.60250058069},{"$f":"P49/(1+'Model Inputs'!$F$9)^P$4","v":-58377.396134286406},{"$f":"Q49/(1+'Model Inputs'!$F$9)^Q$4","v":-56124.697292987854},{"$f":"R49/(1+'Model Inputs'!$F$9)^R$4","v":-53958.926824751965},{"$f":"S49/(1+'Model Inputs'!$F$9)^S$4","v":-51876.730290048363},{"$f":"T49/(1+'Model Inputs'!$F$9)^T$4","v":-49874.882692291045},{"$f":"U49/(1+'Model Inputs'!$F$9)^U$4","v":-47950.283482823434},{"$f":"V49/(1+'Model Inputs'!$F$9)^V$4","v":-46099.951758653719},{"$f":"W49/(1+'Model Inputs'!$F$9)^W$4","v":-44321.021645502529},{"$f":"X49/(1+'Model Inputs'!$F$9)^X$4","v":-42610.737859012232},{"$f":"Y49/(1+'Model Inputs'!$F$9)^Y$4","v":-154762.1498740277},{"$f":"Z49/(1+'Model Inputs'!$F$9)^Z$4","v":-39385.61563784341},{"$f":"AA49/(1+'Model Inputs'!$F$9)^AA$4","v":-37865.781993548859},{"$f":"AB49/(1+'Model Inputs'!$F$9)^AB$4","v":-36404.596519885155},{"$f":"AC49/(1+'Model Inputs'!$F$9)^AC$4","v":-34999.796069216878},{"$f":"AD49/(1+'Model Inputs'!$F$9)^AD$4","v":-33649.204825485416},{"$f":"AE49/(1+'Model Inputs'!$F$9)^AE$4","v":-32350.730934210427},{"$f":"AF49/(1+'Model Inputs'!$F$9)^AF$4","v":-31102.3632625346},{"$f":"AG49/(1+'Model Inputs'!$F$9)^AG$4","v":-29902.168284293559},{"$f":"AH49/(1+'Model Inputs'!$F$9)^AH$4","v":-28748.287085286473},{"$f":"AI49/(1+'Model Inputs'!$F$9)^AI$4","v":-104413.74493996659},{"$f":"SUM(E61:AI61)","v":-2872928.7671938101}]
[null,{"$f":"B37","v":"Discounted revenues"},"NZ$:",null,{"$f":"E54/(1+'Model Inputs'!$F$9)^E$4","v":0},{"$f":"F54/(1+'Model Inputs'!$F$9)^F$4","v":159997.14838777564},{"$f":"G54/(1+'Model Inputs'!$F$9)^G$4","v":153823.09105306477},{"$f":"H54/(1+'Model Inputs'!$F$9)^H$4","v":147887.2816143721},{"$f":"I54/(1+'Model Inputs'!$F$9)^I$4","v":142180.52643178144},{"$f":"J54/(1+'Model Inputs'!$F$9)^J$4","v":136693.98663457425},{"$f":"K54/(1+'Model Inputs'!$F$9)^K$4","v":131419.16443120214},{"$f":"L54/(1+'Model Inputs'!$F$9)^L$4","v":126347.88994753746},{"$f":"M54/(1+'Model Inputs'!$F$9)^M$4","v":121472.30857301693},{"$f":"N54/(1+'Model Inputs'!$F$9)^N$4","v":116784.868795079},{"$f":"O54/(1+'Model Inputs'!$F$9)^O$4","v":112278.31050305262},{"$f":"P54/(1+'Model Inputs'!$F$9)^P$4","v":107945.65374338205},{"$f":"Q54/(1+'Model Inputs'!$F$9)^Q$4","v":103780.18790877089},{"$f":"R54/(1+'Model Inputs'!$F$9)^R$4","v":99775.461344501833},{"$f":"S54/(1+'Model Inputs'!$F$9)^S$4","v":95925.271355833},{"$f":"T54/(1+'Model Inputs'!$F$9)^T$4","v":92223.654600994254},{"$f":"U54/(1+'Model Inputs'!$F$9)^U$4","v":88664.877854904349},{"$f":"V54/(1+'Model Inputs'!$F$9)^V$4","v":85243.429129302313},{"$f":"W54/(1+'Model Inputs'!$F$9)^W$4","v":81954.009135540182},{"$f":"X54/(1+'Model Inputs'!$F$9)^X$4","v":78791.523076814265},{"$f":"Y54/(1+'Model Inputs'!$F$9)^Y$4","v":75751.072757122107},{"$f":"Z54/(1+'Model Inputs'!$F$9)^Z$4","v":72827.948994723483},{"$f":"AA54/(1+'Model Inputs'!$F$9)^AA$4","v":70017.624328354766},{"$f":"AB54/(1+'Model Inputs'!$F$9)^AB$4","v":67315.746004899978},{"$f":"AC54/(1+'Model Inputs'!$F$9)^AC$4","v":64718.129237657406},{"$f":"AD54/(1+'Model Inputs'!$F$9)^AD$4","v":62220.75072475976},{"$f":"AE54/(1+'Model Inputs'!$F$9)^AE$4","v":59819.742417709393},{"$f":"AF54/(1+'Model Inputs'!$F$9)^AF$4","v":57511.385530376334},{"$f":"AG54/(1+'Model Inputs'!$F$9)^AG$4","v":55292.104779180547},{"$f":"AH54/(1+'Model Inputs'!$F$9)^AH$4","v":53158.46284553728},{"$f":"AI54/(1+'Model Inputs'!$F$9)^AI$4","v":51107.155051988389},{"$f":"SUM(E62:AI62)","v":2872928.7671938096}]
[]
[null,"HYBRID"]
[null,"COSTS"]
[null,"Construction","NZ$:",{"$f":"'Model Inputs'!H20","v":1455000},{"$f":"-$D66*E$7","v":-1455000},{"$f":"-$D66*F$7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E66:AI66)","v":-1455000}]
[null,"Maintenance","NZ$:",{"$f":"'Model Inputs'!H27","v":90000},null,{"$f":"-$D67*(1+$D$6)^F$4","v":-91709.999999999985},{"$f":"-$D67*(1+$D$6)^G$4","v":-93452.489999999991},-95228.087309999988,-97037.420968889986,-98881.131967298876,-100759.87347467757,-102674.31107069644,-104625.12298103966,-106613.0003176794,-108638.64732371531,-110702.78162286591,-112806.13447370034,-114949.45102870063,-117133.49059824596,-119359.02691961263,-121626.84843108527,-123937.75855127588,-126292.5759637501,-128692.13490706137,-131137.28547029552,-133628.89389423112,-136167.84287822153,-138755.03189290772,-141391.37749887296,-144077.81367135153,-146815.29213110721,-149604.78268159824,-152447.27355254858,-155343.77175004699,-158295.30341329792,{"$f":"SUM(E67:AI67)","v":-3662784.9567447747}]
[null,"Replacement costs"]
[null,{"$f":"'Model Inputs'!C30","v":"Renewal cost - 3 Years"},"NZ$:",{"$f":"'Model Inputs'!H30","v":87000},null,{"$f":"-$D69*F$9*(1+$D$6)^F$4","v":0},{"$f":"-$D69*G$9*(1+$D$6)^G$4","v":0},-92053.817732999989,0,0,-97401.211025521654,0,0,-103059.23364042342,0,0,-109045.92999124367,0,0,-115380.39268895888,0,0,-122082.8234316251,0,0,-129174.59743109008,0,0,-136678.33158224387,0,0,-144617.95659221165,0,0,-153018.79329952132,{"$f":"SUM(E69:AI69)","v":-1202513.0874158398}]
[null,{"$f":"'Model Inputs'!C31","v":"Renewal cost - 10 Years"},"NZ$:",{"$f":"'Model Inputs'!H31","v":0},null,{"$f":"-$D70*F$10*(1+$D$6)^F$4","v":0},{"$f":"-$D70*G$10*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C32","v":"Renewal cost - 15 Years"},"NZ$:",{"$f":"'Model Inputs'!H32","v":0},null,{"$f":"-$D71*F$11*(1+$D$6)^F$4","v":0},{"$f":"-$D71*G$11*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C33","v":"Renewal cost - 20 Years"},"NZ$:",{"$f":"'Model Inputs'!H33","v":1400000},null,{"$f":"-$D72*F$12*(1+$D$6)^F$4","v":0},{"$f":"-$D72*G$12*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-2039913.3295379302,0,0,0,0,0,0,0,0,0,0,-2039913.3295379302]
[]
[null,"Total costs","NZ$:",null,{"$f":"SUM(E66:E73)","v":-1455000},{"$f":"SUM(F66:F73)","v":-91709.999999999985},-93452.489999999991,-187281.90504299998,-97037.420968889986,-98881.131967298876,-198161.08450019924,-102674.31107069644,-104625.12298103966,-209672.23395810282,-108638.64732371531,-110702.78162286591,-221852.06446494401,-114949.45102870063,-117133.49059824596,-234739.41960857151,-121626.84843108527,-123937.75855127588,-248375.39939537522,-128692.13490706137,-2171050.6150082257,-262803.4913253212,-136167.84287822153,-138755.03189290772,-278069.70908111683,-144077.81367135153,-146815.29213110721,-294222.73927380989,-152447.27355254858,-155343.77175004699,-311314.09671281924,-8360211.3736985447]
[]
[null,"REVENUE"]
[null,"Game revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^F$4","v":74955.705958225313},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^G$4","v":76379.864371431584},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^H$4","v":77831.081794488782},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^I$4","v":79309.872348584075},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^J$4","v":80816.759923207152},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^K$4","v":82352.278361748104},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^L$4","v":83916.971650621315},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^M$4","v":85511.394111983114},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^N$4","v":87136.110600110784},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^O$4","v":88791.696701512876},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^P$4","v":90478.738938841634},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^Q$4","v":92197.834978679603},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^R$4","v":93949.593843274502},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^S$4","v":95734.63612629674},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^T$4","v":97553.594212696378},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^U$4","v":99407.112502737597},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^V$4","v":101295.8476402896},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^W$4","v":103220.46874545509},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^X$4","v":105181.65765161875},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^Y$4","v":107180.1091469995},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^Z$4","v":109216.53122079247},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AA$4","v":111291.64531398755},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AB$4","v":113406.18657495329},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AC$4","v":115560.90411987741},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AD$4","v":117756.56129815507},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AE$4","v":119993.93596282},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AF$4","v":122273.82074611359},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AG$4","v":124597.02334028973},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AH$4","v":126964.36678375521},{"$f":"'Model Inputs'!$H58*'Model Inputs'!$H$65*(1+$D$6)^AI$4","v":129376.68975264659},{"$f":"SUM(E77:AI77)","v":2993638.9947221945}]
[null,"Training revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^F$4","v":168650.33840600695},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^G$4","v":171854.69483572108},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^H$4","v":175119.93403759977},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^I$4","v":178447.21278431415},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^J$4","v":181837.70982721608},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^K$4","v":185292.62631393323},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^L$4","v":188813.18621389795},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^M$4","v":192400.63675196198},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^N$4","v":196056.24885024925},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^O$4","v":199781.31757840398},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^P$4","v":203577.16261239367},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^Q$4","v":207445.12870202912},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^R$4","v":211386.58614736763},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^S$4","v":215402.93128416766},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^T$4","v":219495.58697856683},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^U$4","v":223666.00313115958},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^V$4","v":227915.6571906516},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^W$4","v":232246.05467727396},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^X$4","v":236658.72971614217},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^Y$4","v":241155.24558074886},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^Z$4","v":245737.19524678306},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AA$4","v":250406.20195647198},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AB$4","v":255163.91979364489},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AC$4","v":260012.03426972416},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AD$4","v":264952.26292084891},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AE$4","v":269986.35591634503},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AF$4","v":275116.09667875554},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AG$4","v":280343.30251565186},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AH$4","v":285669.82526344922},{"$f":"'Model Inputs'!$H59*'Model Inputs'!$H$65*(1+$D$6)^AI$4","v":291097.55194345483},6735687.738124935]
[null,"Total revenue","NZ$:",null,{"$f":"SUM(E77:E78)","v":0},{"$f":"SUM(F77:F78)","v":243606.04436423228},248234.55920715266,252951.01583208854,257757.08513289824,262654.46975042322,267644.90467568132,272730.15786451928,277912.03086394508,283192.35945036006,288573.01427991688,294055.90155123529,299642.96368070872,305336.17999064212,311137.5674104644,317049.1811912632,323073.11563389719,329211.50483094121,335466.52342272905,341840.38736776094,348335.35472774837,354953.72646757553,361697.84727045952,368570.10636859818,375572.93838960154,382708.82421900396,389980.29187916504,397389.91742486914,404940.32585594157,412634.19204720441,420474.24169610144,{"$f":"SUM(E79:AI79)","v":9729326.7328471318}]
[]
[null,"Net Cash flow","NZ$:",null,{"$f":"E79+E74","v":-1455000},{"$f":"F79+F74","v":151896.04436423228},{"$f":"G79+G74","v":154782.06920715267},{"$f":"H79+H74","v":65669.110789088561},160719.66416400825,163773.33778312436,69483.820175482077,170055.84679382283,173286.90788290542,73520.125492257241,179934.36695620156,183353.11992836939,77790.899215764715,190386.7289619415,194004.07681221844,82309.761582691688,201446.26720281193,205273.74627966533,87091.124027353828,213148.25246069959,-1822715.2602804773,92150.235142254329,225530.00439223798,229815.07447569046,97503.229308484704,238631.01054765243,243164.99974805783,103167.17815105926,252493.05230339299,257290.42029715743,109160.1449832822,{"$f":"SUM(E81:AI81)","v":1369115.3591485838}]
[null,"Cumulative Cash Flow","NZ$:",null,{"$f":"E81","v":-1455000},{"$f":"E82+F81","v":-1303103.9556357677},{"$f":"F82+G81","v":-1148321.8864286151},{"$f":"G82+H81","v":-1082652.7756395265},{"$f":"H82+I81","v":-921933.11147551832},{"$f":"I82+J81","v":-758159.77369239391},{"$f":"J82+K81","v":-688675.95351691183},{"$f":"K82+L81","v":-518620.106723089},{"$f":"L82+M81","v":-345333.19884018356},{"$f":"M82+N81","v":-271813.07334792631},{"$f":"N82+O81","v":-91878.706391724758},{"$f":"O82+P81","v":91474.413536644628},{"$f":"P82+Q81","v":169265.31275240934},{"$f":"Q82+R81","v":359652.04171435081},{"$f":"R82+S81","v":553656.11852656922},{"$f":"S82+T81","v":635965.88010926091},{"$f":"T82+U81","v":837412.1473120728},{"$f":"U82+V81","v":1042685.8935917381},{"$f":"V82+W81","v":1129777.017619092},{"$f":"W82+X81","v":1342925.2700797915},{"$f":"X82+Y81","v":-479789.9902006858},{"$f":"Y82+Z81","v":-387639.75505843147},{"$f":"Z82+AA81","v":-162109.75066619349},{"$f":"AA82+AB81","v":67705.323809496971},{"$f":"AB82+AC81","v":165208.55311798168},{"$f":"AC82+AD81","v":403839.56366563414},{"$f":"AD82+AE81","v":647004.56341369194},{"$f":"AE82+AF81","v":750171.74156475114},{"$f":"AF82+AG81","v":1002664.7938681442},{"$f":"AG82+AH81","v":1259955.2141653015},{"$f":"AH82+AI81","v":1369115.3591485838}]
[null,"Discounted cashflow","NZ$:",null,{"$f":"E81/(1+'Model Inputs'!$F$9)^E4","v":-1455000},{"$f":"F81/(1+'Model Inputs'!$F$9)^F4","v":143311.67502993892},{"$f":"G81/(1+'Model Inputs'!$F$9)^G4","v":137781.48585291795},{"$f":"H81/(1+'Model Inputs'!$F$9)^H4","v":55152.659488831065},{"$f":"I81/(1+'Model Inputs'!$F$9)^I4","v":127353.07850732864},{"$f":"J81/(1+'Model Inputs'!$F$9)^J4","v":122438.7083677402},{"$f":"K81/(1+'Model Inputs'!$F$9)^K4","v":49011.08700531011},{"$f":"L81/(1+'Model Inputs'!$F$9)^L4","v":113171.56541437101},{"$f":"M81/(1+'Model Inputs'!$F$9)^M4","v":108804.43924638552},{"$f":"N81/(1+'Model Inputs'!$F$9)^N4","v":43553.414680365975},{"$f":"O81/(1+'Model Inputs'!$F$9)^O4","v":100569.24707636508},{"$f":"P81/(1+'Model Inputs'!$F$9)^P4","v":96688.426050397218},{"$f":"Q81/(1+'Model Inputs'!$F$9)^Q4","v":38703.486215565783},{"$f":"R81/(1+'Model Inputs'!$F$9)^R4","v":89370.270884515179},{"$f":"S81/(1+'Model Inputs'!$F$9)^S4","v":85921.602067478991},{"$f":"T81/(1+'Model Inputs'!$F$9)^T4","v":34393.625763487536},{"$f":"U81/(1+'Model Inputs'!$F$9)^U4","v":79418.366450599307},{"$f":"V81/(1+'Model Inputs'!$F$9)^V4","v":76353.727156487104},{"$f":"W81/(1+'Model Inputs'!$F$9)^W4","v":30563.693579703569},{"$f":"X81/(1+'Model Inputs'!$F$9)^X4","v":70574.665011723846},{"$f":"Y81/(1+'Model Inputs'!$F$9)^Y4","v":-569404.61994781112},{"$f":"Z81/(1+'Model Inputs'!$F$9)^Z4","v":27160.246833461246},{"$f":"AA81/(1+'Model Inputs'!$F$9)^AA4","v":62715.761657163275},{"$f":"AB81/(1+'Model Inputs'!$F$9)^AB4","v":60295.651597933167},{"$f":"AC81/(1+'Model Inputs'!$F$9)^AC4","v":24135.793867021748},{"$f":"AD81/(1+'Model Inputs'!$F$9)^AD4","v":55731.993337619358},{"$f":"AE81/(1+'Model Inputs'!$F$9)^AE4","v":53581.376744064648},{"$f":"AF81/(1+'Model Inputs'!$F$9)^AF4","v":21448.13149760052},{"$f":"AG81/(1+'Model Inputs'!$F$9)^AG4","v":49525.908628260753},{"$f":"AH81/(1+'Model Inputs'!$F$9)^AH4","v":47614.775820546936},{"$f":"AI81/(1+'Model Inputs'!$F$9)^AI4","v":19059.75611462778},{"$f":"SUM(E83:AI83)","v":9.8953023552894592E-10}]
[]
[null,"Net Present Value","NZ$:",null,{"$f":"AJ83","v":9.8953023552894592E-10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8953023552894592E-10]
[null,{"$f":"B36","v":"Discounted costs"},"NZ$:",null,{"$f":"E74/(1+'Model Inputs'!$F$9)^E$4","v":-1455000},{"$f":"F74/(1+'Model Inputs'!$F$9)^F$4","v":-86527.030851967153},{"$f":"G74/(1+'Model Inputs'!$F$9)^G$4","v":-83188.078533969732},{"$f":"H74/(1+'Model Inputs'!$F$9)^H$4","v":-157290.01067839083},{"$f":"I74/(1+'Model Inputs'!$F$9)^I$4","v":-76891.737890821285},{"$f":"J74/(1+'Model Inputs'!$F$9)^J$4","v":-73924.597519338495},{"$f":"K74/(1+'Model Inputs'!$F$9)^K$4","v":-139774.8444023068},{"$f":"L74/(1+'Model Inputs'!$F$9)^L$4","v":-68329.391378120388},{"$f":"M74/(1+'Model Inputs'!$F$9)^M$4","v":-65692.659509675126},{"$f":"N74/(1+'Model Inputs'!$F$9)^N$4","v":-124210.09473790538},{"$f":"O74/(1+'Model Inputs'!$F$9)^O$4","v":-60720.5124266243},{"$f":"P74/(1+'Model Inputs'!$F$9)^P$4","v":-58377.396134286406},{"$f":"Q74/(1+'Model Inputs'!$F$9)^Q$4","v":-110378.57134287612},{"$f":"R74/(1+'Model Inputs'!$F$9)^R$4","v":-53958.926824751965},{"$f":"S74/(1+'Model Inputs'!$F$9)^S$4","v":-51876.730290048363},{"$f":"T74/(1+'Model Inputs'!$F$9)^T$4","v":-98087.269294839047},{"$f":"U74/(1+'Model Inputs'!$F$9)^U$4","v":-47950.283482823434},{"$f":"V74/(1+'Model Inputs'!$F$9)^V$4","v":-46099.951758653719},{"$f":"W74/(1+'Model Inputs'!$F$9)^W$4","v":-87164.675902821647},{"$f":"X74/(1+'Model Inputs'!$F$9)^X$4","v":-42610.737859012232},{"$f":"Y74/(1+'Model Inputs'!$F$9)^Y$4","v":-678222.36268323893},{"$f":"Z74/(1+'Model Inputs'!$F$9)^Z$4","v":-77458.377421092038},{"$f":"AA74/(1+'Model Inputs'!$F$9)^AA$4","v":-37865.781993548859},{"$f":"AB74/(1+'Model Inputs'!$F$9)^AB$4","v":-36404.596519885155},{"$f":"AC74/(1+'Model Inputs'!$F$9)^AC$4","v":-68832.932269459867},{"$f":"AD74/(1+'Model Inputs'!$F$9)^AD$4","v":-33649.204825485416},{"$f":"AE74/(1+'Model Inputs'!$F$9)^AE$4","v":-32350.730934210427},{"$f":"AF74/(1+'Model Inputs'!$F$9)^AF$4","v":-61167.981082984719},{"$f":"AG74/(1+'Model Inputs'!$F$9)^AG$4","v":-29902.168284293559},{"$f":"AH74/(1+'Model Inputs'!$F$9)^AH$4","v":-28748.287085286473},{"$f":"AI74/(1+'Model Inputs'!$F$9)^AI$4","v":-54356.567218747317},{"$f":"SUM(E86:AI86)","v":-4127012.4911374655}]
[null,{"$f":"B37","v":"Discounted revenues"},"NZ$:",null,{"$f":"E79/(1+'Model Inputs'!$F$9)^E$4","v":0},{"$f":"F79/(1+'Model Inputs'!$F$9)^F$4","v":229838.70588190609},{"$f":"G79/(1+'Model Inputs'!$F$9)^G$4","v":220969.56438688768},{"$f":"H79/(1+'Model Inputs'!$F$9)^H$4","v":212442.67016722189},{"$f":"I79/(1+'Model Inputs'!$F$9)^I$4","v":204244.81639814991},{"$f":"J79/(1+'Model Inputs'!$F$9)^J$4","v":196363.30588707869},{"$f":"K79/(1+'Model Inputs'!$F$9)^K$4","v":188785.93140761691},{"$f":"L79/(1+'Model Inputs'!$F$9)^L$4","v":181500.9567924914},{"$f":"M79/(1+'Model Inputs'!$F$9)^M$4","v":174497.09875606064},{"$f":"N79/(1+'Model Inputs'!$F$9)^N$4","v":167763.50941827137},{"$f":"O79/(1+'Model Inputs'!$F$9)^O$4","v":161289.75950298939},{"$f":"P79/(1+'Model Inputs'!$F$9)^P$4","v":155065.82218468364},{"$f":"Q79/(1+'Model Inputs'!$F$9)^Q$4","v":149082.05755844191},{"$f":"R79/(1+'Model Inputs'!$F$9)^R$4","v":143329.19770926714},{"$f":"S79/(1+'Model Inputs'!$F$9)^S$4","v":137798.33235752737},{"$f":"T79/(1+'Model Inputs'!$F$9)^T$4","v":132480.8950583266},{"$f":"U79/(1+'Model Inputs'!$F$9)^U$4","v":127368.64993342274},{"$f":"V79/(1+'Model Inputs'!$F$9)^V$4","v":122453.67891514083},{"$f":"W79/(1+'Model Inputs'!$F$9)^W$4","v":117728.36948252522},{"$f":"X79/(1+'Model Inputs'!$F$9)^X$4","v":113185.40287073608},{"$f":"Y79/(1+'Model Inputs'!$F$9)^Y$4","v":108817.74273542792},{"$f":"Z79/(1+'Model Inputs'!$F$9)^Z$4","v":104618.62425455329},{"$f":"AA79/(1+'Model Inputs'!$F$9)^AA$4","v":100581.54365071213},{"$f":"AB79/(1+'Model Inputs'!$F$9)^AB$4","v":96700.248117818322},{"$f":"AC79/(1+'Model Inputs'!$F$9)^AC$4","v":92968.726136481608},{"$f":"AD79/(1+'Model Inputs'!$F$9)^AD$4","v":89381.198163104767},{"$f":"AE79/(1+'Model Inputs'!$F$9)^AE$4","v":85932.107678275075},{"$f":"AF79/(1+'Model Inputs'!$F$9)^AF$4","v":82616.112580585235},{"$f":"AG79/(1+'Model Inputs'!$F$9)^AG$4","v":79428.076912554316},{"$f":"AH79/(1+'Model Inputs'!$F$9)^AH$4","v":76363.062905833416},{"$f":"AI79/(1+'Model Inputs'!$F$9)^AI$4","v":73416.323333375098},{"$f":"SUM(E87:AI87)","v":4127012.4911374669}]
[]
[null,"ARTIFICIAL"]
[null,"COSTS"]
[null,"Construction","NZ$:",{"$f":"'Model Inputs'!I20","v":3674000},{"$f":"-$D91*E$7","v":-3674000},{"$f":"-$D91*F$7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E91:AI91)","v":-3674000}]
[null,"Maintenance","NZ$:",{"$f":"'Model Inputs'!I27","v":49000},null,{"$f":"-$D92*(1+$D$6)^F$4","v":-49930.999999999993},{"$f":"-$D92*(1+$D$6)^G$4","v":-50879.688999999991},-51846.403090999993,-52831.484749728988,-53835.282959973832,-54858.153336213341,-55900.458249601397,-56962.566956343813,-58044.85572851434,-59147.707987356116,-60271.514439115883,-61416.673213459071,-62583.590004514786,-63772.678214600579,-64984.35910067799,-66219.061923590867,-67477.224100139094,-68759.291358041723,-70065.717893844514,-71396.966533827552,-72753.50889797027,-74135.825567031716,-75544.406252805318,-76979.749971608617,-78442.365221069165,-79932.770160269487,-81451.492793314595,-82999.071156387567,-84576.05350835892,-86182.998525017756,{"$f":"SUM(E92:AI92)","v":-1994182.9208943774}]
[null,"Replacement costs"]
[null,{"$f":"'Model Inputs'!C30","v":"Renewal cost - 3 Years"},"NZ$:",{"$f":"'Model Inputs'!I30","v":0},null,{"$f":"-$D94*F$9*(1+$D$6)^F$4","v":0},{"$f":"-$D94*G$9*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E94:AI94)","v":0}]
[null,{"$f":"'Model Inputs'!C31","v":"Renewal cost - 10 Years"},"NZ$:",{"$f":"'Model Inputs'!I31","v":1000000},null,{"$f":"-$D95*F$10*(1+$D$6)^F$4","v":0},{"$f":"-$D95*G$10*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,-1207096.0813746145,0,0,0,0,0,0,0,0,0,-1457080.9496699502,0,0,0,0,0,0,0,0,0,-1758836.7045921991,-4423013.7356367633]
[null,{"$f":"'Model Inputs'!C32","v":"Renewal cost - 15 Years"},"NZ$:",{"$f":"'Model Inputs'!I32","v":0},null,{"$f":"-$D96*F$11*(1+$D$6)^F$4","v":0},{"$f":"-$D96*G$11*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Model Inputs'!C33","v":"Renewal cost - 20 Years"},"NZ$:",{"$f":"'Model Inputs'!I33","v":250000},null,{"$f":"-$D97*F$12*(1+$D$6)^F$4","v":0},{"$f":"-$D97*G$12*(1+$D$6)^G$4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-364270.23741748754,0,0,0,0,0,0,0,0,0,0,-364270.23741748754]
[]
[null,"Total costs","NZ$:",null,{"$f":"SUM(E91:E98)","v":-3674000},{"$f":"SUM(F91:F98)","v":-49930.999999999993},-50879.688999999991,-51846.403090999993,-52831.484749728988,-53835.282959973832,-54858.153336213341,-55900.458249601397,-56962.566956343813,-58044.85572851434,-1266243.7893619705,-60271.514439115883,-61416.673213459071,-62583.590004514786,-63772.678214600579,-64984.35910067799,-66219.061923590867,-67477.224100139094,-68759.291358041723,-70065.717893844514,-1892748.1536212652,-72753.50889797027,-74135.825567031716,-75544.406252805318,-76979.749971608617,-78442.365221069165,-79932.770160269487,-81451.492793314595,-82999.071156387567,-84576.05350835892,-1845019.7031172169,-10455466.893948628]
[]
[null,"REVENUE"]
[null,"Game revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^F$4","v":127407.44387186598},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^G$4","v":129828.18530543143},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^H$4","v":132294.92082623462},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^I$4","v":134808.52432193307},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^J$4","v":137369.88628404977},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^K$4","v":139979.91412344674},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^L$4","v":142639.53249179223},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^M$4","v":145349.68360913626},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^N$4","v":148111.32759770984},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^O$4","v":150925.44282206634},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^P$4","v":153793.0262356856},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^Q$4","v":156715.09373416362},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^R$4","v":159692.68051511268},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^S$4","v":162726.84144489985},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^T$4","v":165818.65143235296},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^U$4","v":168969.20580956765},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^V$4","v":172179.62071994942},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^W$4","v":175451.03351362844},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^X$4","v":178784.60315038738},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^Y$4","v":182181.51061024473},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^Z$4","v":185642.95931183937},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AA$4","v":189170.17553876434},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AB$4","v":192764.40887400083},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AC$4","v":196426.93264260684},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AD$4","v":200159.04436281635},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AE$4","v":203962.06620570985},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AF$4","v":207837.34546361835},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AG$4","v":211786.25502742705},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AH$4","v":215810.19387294815},{"$f":"'Model Inputs'!$I58*'Model Inputs'!$I$65*(1+$D$6)^AI$4","v":219910.58755653421},{"$f":"SUM(E102:AI102)","v":5088497.0972759249}]
[null,"Training revenue","NZ$:",null,null,{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^F$4","v":230925.99201775709},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^G$4","v":235313.58586609448},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^H$4","v":239784.54399755027},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^I$4","v":244340.45033350372},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^J$4","v":248982.91888984025},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^K$4","v":253713.59434874725},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^L$4","v":258534.15264137342},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^M$4","v":263446.30154155951},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^N$4","v":268451.78127084911},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^O$4","v":273552.36511499522},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^P$4","v":278749.86005218013},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^Q$4","v":284046.10739317152},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^R$4","v":289442.98343364173},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^S$4","v":294942.40011888102},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^T$4","v":300546.30572113971},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^U$4","v":306256.68552984134},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^V$4","v":312075.56255490833},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^W$4","v":318004.99824345153},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^X$4","v":324047.09321007715},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^Y$4","v":330203.98798106855},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^Z$4","v":336477.86375270883},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AA$4","v":342870.94316401036},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AB$4","v":349385.49108412652},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AC$4","v":356023.81541472493},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AD$4","v":362788.26790760463},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AE$4","v":369681.24499784911},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AF$4","v":376705.18865280825},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AG$4","v":383862.58723721153},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AH$4","v":391155.97639471851},{"$f":"'Model Inputs'!$I59*'Model Inputs'!$I$65*(1+$D$6)^AI$4","v":398587.93994621828},9222900.9888126105]
[null,"Total revenue","NZ$:",null,{"$f":"SUM(E102:E103)","v":0},{"$f":"SUM(F102:F103)","v":358333.43588962307},{"$f":"SUM(G102:G103)","v":365141.77117152594},372079.46482378489,379148.97465543682,386352.80517389002,393693.50847219396,401173.68513316568,408795.98515069578,416563.10886855895,424477.80793706153,432542.88628786569,440761.20112733514,449135.66394875443,457669.24156378087,466364.95715349267,475225.89133940899,484255.18327485776,493456.03175708,502831.69636046456,512385.49859131326,522120.8230645482,532041.11870277463,542149.89995812741,552450.74805733177,562947.31227042095,573643.31120355893,584542.5341164266,595648.84226463852,606966.17026766669,618498.52750275249,{"$f":"SUM(E104:AI104)","v":14311398.086088542}]
[]
[null,"Net Cash flow","NZ$:",null,{"$f":"E104+E99","v":-3674000},{"$f":"F104+F99","v":308402.43588962307},{"$f":"G104+G99","v":314262.08217152592},{"$f":"H104+H99","v":320233.0617327849},326317.48990570783,332517.52221391618,338835.35513598064,345273.22688356426,351833.41819435195,358518.25314004463,-841765.98142490897,372271.37184874981,379344.52791387605,386552.07394423964,393896.56334918027,401380.59805281466,409006.82941581809,416777.95917471865,424696.7403990383,432765.97846662003,-1380362.6550299521,449367.31416657794,457905.29313574289,466605.49370532209,475470.99808572314,484504.94704935176,493710.54104328947,503091.04132311197,512649.77110825095,522390.1167593078,-1226521.1756144646,{"$f":"SUM(E106:AI106)","v":3855931.1921399073}]
[null,"Cumulative Cash Flow","NZ$:",null,{"$f":"E106","v":-3674000},{"$f":"E107+F106","v":-3365597.5641103769},{"$f":"F107+G106","v":-3051335.4819388511},{"$f":"G107+H106","v":-2731102.4202060662},{"$f":"H107+I106","v":-2404784.9303003582},{"$f":"I107+J106","v":-2072267.4080864419},{"$f":"J107+K106","v":-1733432.0529504614},{"$f":"K107+L106","v":-1388158.8260668973},{"$f":"L107+M106","v":-1036325.4078725453},{"$f":"M107+N106","v":-677807.15473250067},{"$f":"N107+O106","v":-1519573.1361574098},{"$f":"O107+P106","v":-1147301.7643086598},{"$f":"P107+Q106","v":-767957.23639478371},{"$f":"Q107+R106","v":-381405.16245054407},{"$f":"R107+S106","v":12491.400898636202},{"$f":"S107+T106","v":413871.99895145086},{"$f":"T107+U106","v":822878.8283672689},{"$f":"U107+V106","v":1239656.7875419876},{"$f":"V107+W106","v":1664353.5279410258},{"$f":"W107+X106","v":2097119.5064076458},{"$f":"X107+Y106","v":716756.8513776937},{"$f":"Y107+Z106","v":1166124.1655442717},{"$f":"Z107+AA106","v":1624029.4586800146},{"$f":"AA107+AB106","v":2090634.9523853366},{"$f":"AB107+AC106","v":2566105.9504710599},{"$f":"AC107+AD106","v":3050610.8975204118},{"$f":"AD107+AE106","v":3544321.4385637012},{"$f":"AE107+AF106","v":4047412.4798868131},{"$f":"AF107+AG106","v":4560062.2509950642},{"$f":"AG107+AH106","v":5082452.3677543718},{"$f":"AH107+AI106","v":3855931.1921399073}]
[null,"Discounted cashflow","NZ$:",null,{"$f":"E106/(1+'Model Inputs'!$F$9)^E29","v":-3674000},{"$f":"F106/(1+'Model Inputs'!$F$9)^F4","v":290973.14453214745},{"$f":"G106/(1+'Model Inputs'!$F$9)^G4","v":279744.91393363354},{"$f":"H106/(1+'Model Inputs'!$F$9)^H4","v":268949.96442907117},{"$f":"I106/(1+'Model Inputs'!$F$9)^I4","v":258571.57633099679},{"$f":"J106/(1+'Model Inputs'!$F$9)^J4","v":248593.67514037708},{"$f":"K106/(1+'Model Inputs'!$F$9)^K4","v":239000.80664972565},{"$f":"L106/(1+'Model Inputs'!$F$9)^L4","v":229778.11300695388},{"$f":"M106/(1+'Model Inputs'!$F$9)^M4","v":220911.30970288324},{"$f":"N106/(1+'Model Inputs'!$F$9)^N4","v":212386.66344677613},{"$f":"O106/(1+'Model Inputs'!$F$9)^O4","v":-470481.38940020814},{"$f":"P106/(1+'Model Inputs'!$F$9)^P4","v":196311.53820420231},{"$f":"Q106/(1+'Model Inputs'!$F$9)^Q4","v":188736.16136435713},{"$f":"R106/(1+'Model Inputs'!$F$9)^R4","v":181453.10730283975},{"$f":"S106/(1+'Model Inputs'!$F$9)^S4","v":174451.09570864585},{"$f":"T106/(1+'Model Inputs'!$F$9)^T4","v":167719.28156157193},{"$f":"U106/(1+'Model Inputs'!$F$9)^U4","v":161247.23833497663},{"$f":"V106/(1+'Model Inputs'!$F$9)^V4","v":155024.9418467225},{"$f":"W106/(1+'Model Inputs'!$F$9)^W4","v":149042.75473328636},{"$f":"X106/(1+'Model Inputs'!$F$9)^X4","v":143291.41152299158},{"$f":"Y106/(1+'Model Inputs'!$F$9)^Y4","v":-431216.487898683},{"$f":"Z106/(1+'Model Inputs'!$F$9)^Z4","v":132445.96883353332},{"$f":"AA106/(1+'Model Inputs'!$F$9)^AA4","v":127335.07146086462},{"$f":"AB106/(1+'Model Inputs'!$F$9)^AB4","v":122421.39618701865},{"$f":"AC106/(1+'Model Inputs'!$F$9)^AC4","v":117697.33249794506},{"$f":"AD106/(1+'Model Inputs'!$F$9)^AD4","v":113155.56355826584},{"$f":"AE106/(1+'Model Inputs'!$F$9)^AE4","v":108789.05487864222},{"$f":"AF106/(1+'Model Inputs'!$F$9)^AF4","v":104591.04342045139},{"$f":"AG106/(1+'Model Inputs'!$F$9)^AG4","v":100555.0271208981},{"$f":"AH106/(1+'Model Inputs'!$F$9)^AH4","v":96674.754822337185},{"$f":"AI106/(1+'Model Inputs'!$F$9)^AI4","v":-214155.03323322305},{"$f":"SUM(E108:AI108)","v":6.9849193096160889E-10}]
[]
[null,"Net Present Value","NZ$:",null,{"$f":"AJ108","v":6.9849193096160889E-10},null,null,null,null,null,null,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":"SUM(E110:AI110)","v":6.9849193096160889E-10}]
[null,{"$f":"B61","v":"Discounted costs"},"NZ$:",null,{"$f":"E99/(1+'Model Inputs'!$F$9)^E$4","v":-3674000},{"$f":"F99/(1+'Model Inputs'!$F$9)^F$4","v":-47109.161241626556},{"$f":"G99/(1+'Model Inputs'!$F$9)^G$4","v":-45291.28720182796},{"$f":"H99/(1+'Model Inputs'!$F$9)^H$4","v":-43543.562278198595},{"$f":"I99/(1+'Model Inputs'!$F$9)^I$4","v":-41863.279518336029},{"$f":"J99/(1+'Model Inputs'!$F$9)^J$4","v":-40247.836427195405},{"$f":"K99/(1+'Model Inputs'!$F$9)^K$4","v":-38694.730936231826},{"$f":"L99/(1+'Model Inputs'!$F$9)^L$4","v":-37201.557528087767},{"$f":"M99/(1+'Model Inputs'!$F$9)^M$4","v":-35766.003510823117},{"$f":"N99/(1+'Model Inputs'!$F$9)^N$4","v":-34385.845435917312},{"$f":"O99/(1+'Model Inputs'!$F$9)^O$4","v":-707731.30595032091},{"$f":"P99/(1+'Model Inputs'!$F$9)^P$4","v":-31783.249006444821},{"$f":"Q99/(1+'Model Inputs'!$F$9)^Q$4","v":-30556.779637293388},{"$f":"R99/(1+'Model Inputs'!$F$9)^R$4","v":-29377.637937920517},{"$f":"S99/(1+'Model Inputs'!$F$9)^S$4","v":-28243.997602359665},{"$f":"T99/(1+'Model Inputs'!$F$9)^T$4","v":-27154.102799136235},{"$f":"U99/(1+'Model Inputs'!$F$9)^U$4","v":-26106.265451759427},{"$f":"V99/(1+'Model Inputs'!$F$9)^V$4","v":-25098.862624155914},{"$f":"W99/(1+'Model Inputs'!$F$9)^W$4","v":-24130.334006995821},{"$f":"X99/(1+'Model Inputs'!$F$9)^X$4","v":-23199.17950101777},{"$f":"Y99/(1+'Model Inputs'!$F$9)^Y$4","v":-591282.44907753519},{"$f":"Z99/(1+'Model Inputs'!$F$9)^Z$4","v":-21443.279625048075},{"$f":"AA99/(1+'Model Inputs'!$F$9)^AA$4","v":-20615.814640932153},{"$f":"AB99/(1+'Model Inputs'!$F$9)^AB$4","v":-19820.28032749303},{"$f":"AC99/(1+'Model Inputs'!$F$9)^AC$4","v":-19055.444526573636},{"$f":"AD99/(1+'Model Inputs'!$F$9)^AD$4","v":-18320.122627208726},{"$f":"AE99/(1+'Model Inputs'!$F$9)^AE$4","v":-17613.175730847903},{"$f":"AF99/(1+'Model Inputs'!$F$9)^AF$4","v":-16933.50888737995},{"$f":"AG99/(1+'Model Inputs'!$F$9)^AG$4","v":-16280.069399226495},{"$f":"AH99/(1+'Model Inputs'!$F$9)^AH$4","v":-15651.845190878192},{"$f":"AI99/(1+'Model Inputs'!$F$9)^AI$4","v":-322147.11306477932},{"$f":"SUM(E111:AI111)","v":-6070648.0816935506}]
[null,{"$f":"B62","v":"Discounted revenues"},"NZ$:",null,{"$f":"E104/(1+'Model Inputs'!$F$9)^E$4","v":0},{"$f":"F104/(1+'Model Inputs'!$F$9)^F$4","v":338082.30577377399},{"$f":"G104/(1+'Model Inputs'!$F$9)^G$4","v":325036.20113546151},{"$f":"H104/(1+'Model Inputs'!$F$9)^H$4","v":312493.52670726978},{"$f":"I104/(1+'Model Inputs'!$F$9)^I$4","v":300434.85584933282},{"$f":"J104/(1+'Model Inputs'!$F$9)^J$4","v":288841.51156757248},{"$f":"K104/(1+'Model Inputs'!$F$9)^K$4","v":277695.53758595744},{"$f":"L104/(1+'Model Inputs'!$F$9)^L$4","v":266979.67053504166},{"$f":"M104/(1+'Model Inputs'!$F$9)^M$4","v":256677.31321370637},{"$f":"N104/(1+'Model Inputs'!$F$9)^N$4","v":246772.50888269342},{"$f":"O104/(1+'Model Inputs'!$F$9)^O$4","v":237249.91655011274},{"$f":"P104/(1+'Model Inputs'!$F$9)^P$4","v":228094.78721064713},{"$f":"Q104/(1+'Model Inputs'!$F$9)^Q$4","v":219292.94100165053},{"$f":"R104/(1+'Model Inputs'!$F$9)^R$4","v":210830.74524076027},{"$f":"S104/(1+'Model Inputs'!$F$9)^S$4","v":202695.0933110055},{"$f":"T104/(1+'Model Inputs'!$F$9)^T$4","v":194873.38436070815},{"$f":"U104/(1+'Model Inputs'!$F$9)^U$4","v":187353.50378673608},{"$f":"V104/(1+'Model Inputs'!$F$9)^V$4","v":180123.80447087844},{"$f":"W104/(1+'Model Inputs'!$F$9)^W$4","v":173173.08874028217},{"$f":"X104/(1+'Model Inputs'!$F$9)^X$4","v":166490.59102400937},{"$f":"Y104/(1+'Model Inputs'!$F$9)^Y$4","v":160065.96117885222},{"$f":"Z104/(1+'Model Inputs'!$F$9)^Z$4","v":153889.24845858139},{"$f":"AA104/(1+'Model Inputs'!$F$9)^AA$4","v":147950.88610179679},{"$f":"AB104/(1+'Model Inputs'!$F$9)^AB$4","v":142241.67651451167},{"$f":"AC104/(1+'Model Inputs'!$F$9)^AC$4","v":136752.7770245187},{"$f":"AD104/(1+'Model Inputs'!$F$9)^AD$4","v":131475.68618547457},{"$f":"AE104/(1+'Model Inputs'!$F$9)^AE$4","v":126402.23060949011},{"$f":"AF104/(1+'Model Inputs'!$F$9)^AF$4","v":121524.55230783134},{"$f":"AG104/(1+'Model Inputs'!$F$9)^AG$4","v":116835.0965201246},{"$f":"AH104/(1+'Model Inputs'!$F$9)^AH$4","v":112326.60001321537},{"$f":"AI104/(1+'Model Inputs'!$F$9)^AI$4","v":107992.07983155626},{"$f":"SUM(E112:AI112)","v":6070648.0816935534}]
[]
[null,"GRAPHICAL OUTPUT"]
[]
[null,"Net Cash Flow","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),E31,E56,E81,E106)","v":-253000},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),F31,F56,F81,F106)","v":14933.884827463644},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),G31,G56,G81,G106)","v":15217.628639185456},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),H31,H56,H81,H106)","v":15506.763583329976},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),I31,I56,I81,I106)","v":15801.39209141324},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),J31,J56,J81,J106)","v":16101.618541150099},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),K31,K56,K81,K106)","v":16407.549293431952},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),L31,L56,L81,L106)","v":16719.292730007153},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),M31,M56,M81,M106)","v":17036.959291877294},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),N31,N56,N81,N106)","v":17360.661518422956},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),O31,O56,O81,O106)","v":17690.514087272993},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),P31,P56,P81,P106)","v":18026.63385493118},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Q31,Q56,Q81,Q106)","v":18369.139898174868},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),R31,R56,R81,R106)","v":18718.153556240188},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),S31,S56,S81,S106)","v":19073.798473808754},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),T31,T56,T81,T106)","v":19436.200644811121},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),U31,U56,U81,U106)","v":19805.488457062533},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),V31,V56,V81,V106)","v":20181.792737746713},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),W31,W56,W81,W106)","v":20565.246799763903},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),X31,X56,X81,X106)","v":20955.986488959421},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Y31,Y56,Y81,Y106)","v":21354.150232249645},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Z31,Z56,Z81,Z106)","v":21759.879086662386},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AA31,AA56,AA81,AA106)","v":22173.316789308981},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AB31,AB56,AB81,AB106)","v":22594.609808305842},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AC31,AC56,AC81,AC106)","v":23023.907394663653},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AD31,AD56,AD81,AD106)","v":23461.361635162266},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AE31,AE56,AE81,AE106)","v":23907.127506230339},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AF31,AF56,AF81,AF106)","v":24361.362928848714},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AG31,AG56,AG81,AG106)","v":24824.228824496837},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AH31,AH56,AH81,AH106)","v":25295.889172162271},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AI31,AI56,AI81,AI106)","v":25776.51106643337}]
[null,"Discounted Cash Flow","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),E33,E58,E83,E108)","v":-253000},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),F33,F58,F83,F108)","v":14089.899827779642},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),G33,G58,G83,G108)","v":13546.191078882401},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),H33,H58,H83,H108)","v":13023.463260101104},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),I33,I58,I83,I108)","v":12520.906747846984},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),J33,J58,J83,J108)","v":12037.743160728449},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),K33,K58,K83,K108)","v":11573.22415396008},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),L33,L58,L83,L108)","v":11126.630260293721},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),M33,M58,M83,M108)","v":10697.269775676294},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),N33,N58,N83,N108)","v":10284.477687908426},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),O33,O58,O83,O108)","v":9887.614646644668},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),P33,P58,P83,P108)","v":9506.0659731398391},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Q33,Q58,Q83,Q108)","v":9139.2407082078425},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),R33,R58,R83,R108)","v":8786.5706969183793},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),S33,S58,S83,S108)","v":8447.5097086138576},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),T33,T58,T83,T108)","v":8121.5325908835939},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),U33,U58,U83,U108)","v":7808.1344561849046},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),V33,V58,V83,V108)","v":7506.8298998513201},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),W33,W58,W83,W108)","v":7217.1522482767205},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),X33,X58,X83,X108)","v":6938.6528361109322},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Y33,Y58,Y83,Y108)","v":6670.9003113473327},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Z33,Z58,Z83,Z108)","v":6413.4799672260879},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AA33,AA58,AA83,AA108)","v":6165.9930999182807},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AB33,AB58,AB83,AB108)","v":5928.0563909960611},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AC33,AC58,AC83,AC108)","v":5699.3013137324142},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AD33,AD58,AD83,AD108)","v":5479.3735623109069},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AE33,AE58,AE83,AE108)","v":5267.9325030614309},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AF33,AF58,AF83,AF108)","v":5064.6506468719672},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AG33,AG58,AG83,AG108)","v":4869.2131419591778},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AH33,AH58,AH83,AH108)","v":4681.3172862122847},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AI33,AI58,AI83,AI108)","v":4500.672058354864}]
[null,"Cumulative Cash Flow","NZ$:",null,{"$f":"E116","v":-253000},{"$f":"E118+F116","v":-238066.11517253635},{"$f":"F118+G116","v":-222848.48653335089},-207341.72295002092,-191540.33085860769,-175438.7123174576,-159031.16302402565,-142311.8702940185,-125274.91100214121,-107914.24948371825,-90223.735396445249,-72197.101541514072,-53827.961643339208,-35109.808087099023,-16036.009613290269,3400.1910315208515,23205.679488583384,43387.472226330094,63952.719026093997,84908.705515053414,106262.85574730305,128022.73483396544,150196.05162327443,172790.66143158026,195814.56882624392,219275.93046140618,243183.05796763653,267544.42089648522,292368.64972098207,317664.53889314434,343441.04995957774]
[null,"Cumulative Discounted Cash Flow","NZ$:",null,{"$f":"E117","v":-253000},{"$f":"E119+F117","v":-238910.10017222035},{"$f":"F119+G117","v":-225363.90909333795},-212340.44583323685,-199819.53908538987,-187781.79592466142,-176208.57177070132,-165081.9415104076,-154384.6717347313,-144100.19404682287,-134212.57940017819,-124706.51342703836,-115567.27271883051,-106780.70202191213,-98333.192313298277,-90211.659722414683,-82403.525266229772,-74896.695366378452,-67679.543118101734,-60740.890281990803,-54069.989970643473,-47656.510003417388,-41490.516903499105,-35562.460512503043,-29863.159198770627,-24383.785636459721,-19115.85313339829,-14051.202486526323,-9181.9893445671441,-4500.6720583548595,0]
[]
[null,"Revenue","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),E29,E54,E79,E104)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),F29,F54,F79,F104)","v":35313.88482746364},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),G29,G54,G79,G104)","v":35984.848639185453},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),H29,H54,H79,H104)","v":36668.560763329973},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),I29,I54,I79,I104)","v":37365.263417833237},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),J29,J54,J79,J104)","v":38075.203422772072},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),K29,K54,K79,K104)","v":38798.632287804743},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),L29,L54,L79,L104)","v":39535.806301273027},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),M29,M54,M79,M104)","v":40286.986620997217},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),N29,N54,N79,N104)","v":41052.439366796156},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),O29,O54,O79,O104)","v":41832.435714765285},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),P29,P54,P79,P104)","v":42627.251993345824},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Q29,Q54,Q79,Q104)","v":43437.169781219389},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),R29,R54,R79,R104)","v":44262.476007062549},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),S29,S54,S79,S104)","v":45103.463051196748},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),T29,T54,T79,T104)","v":45960.428849169482},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),U29,U54,U79,U104)","v":46833.676997303701},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),V29,V54,V79,V104)","v":47723.516860252465},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),W29,W54,W79,W104)","v":48630.263680597258},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),X29,X54,X79,X104)","v":49554.238690528611},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Y29,Y54,Y79,Y104)","v":50495.769225648648},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Z29,Z54,Z79,Z104)","v":51455.188840935967},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AA29,AA54,AA79,AA104)","v":52432.837428913765},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AB29,AB54,AB79,AB104)","v":53429.061340063112},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AC29,AC54,AC79,AC104)","v":54444.213505524312},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AD29,AD54,AD79,AD104)","v":55478.653562129271},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AE29,AE54,AE79,AE104)","v":56532.747979809719},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AF29,AF54,AF79,AF104)","v":57606.870191426104},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AG29,AG54,AG79,AG104)","v":58701.400725063191},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AH29,AH54,AH79,AH104)","v":59816.727338839381},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AI29,AI54,AI79,AI104)","v":60953.24515827735}]
[null,"Opex","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),E17,E42,E67,E92)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),F17,F42,F67,F92)","v":-20379.999999999996},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),G17,G42,G67,G92)","v":-20767.219999999998},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),H17,H42,H67,H92)","v":-21161.797179999998},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),I17,I42,I67,I92)","v":-21563.871326419998},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),J17,J42,J67,J92)","v":-21973.584881621973},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),K17,K42,K67,K92)","v":-22391.082994372791},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),L17,L42,L67,L92)","v":-22816.513571265874},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),M17,M42,M67,M92)","v":-23250.027329119923},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),N17,N42,N67,N92)","v":-23691.7778483732},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),O17,O42,O67,O92)","v":-24141.921627492291},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),P17,P42,P67,P92)","v":-24600.618138414644},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Q17,Q42,Q67,Q92)","v":-25068.029883044521},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),R17,R42,R67,R92)","v":-25544.322450822361},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),S17,S42,S67,S92)","v":-26029.664577387994},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),T17,T42,T67,T92)","v":-26524.228204358362},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),U17,U42,U67,U92)","v":-27028.188540241168},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),V17,V42,V67,V92)","v":-27541.724122505751},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),W17,W42,W67,W92)","v":-28065.016880833355},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),X17,X42,X67,X92)","v":-28598.25220156919},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Y17,Y42,Y67,Y92)","v":-29141.618993399003},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Z17,Z42,Z67,Z92)","v":-29695.309754273581},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AA17,AA42,AA67,AA92)","v":-30259.520639604783},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AB17,AB42,AB67,AB92)","v":-30834.45153175727},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AC17,AC42,AC67,AC92)","v":-31420.30611086066},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AD17,AD42,AD67,AD92)","v":-32017.291926967006},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AE17,AE42,AE67,AE92)","v":-32625.62047357938},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AF17,AF42,AF67,AF92)","v":-33245.50726257739},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AG17,AG42,AG67,AG92)","v":-33877.171900566354},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AH17,AH42,AH67,AH92)","v":-34520.838166677109},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AI17,AI42,AI67,AI92)","v":-35176.73409184398}]
[null,"Capex","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),E16,E41,E66,E91)","v":-253000},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),F16,F41,F66,F91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),G16,G41,G66,G91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),H16,H41,H66,H91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),I16,I41,I66,I91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),J16,J41,J66,J91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),K16,K41,K66,K91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),L16,L41,L66,L91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),M16,M41,M66,M91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),N16,N41,N66,N91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),O16,O41,O66,O91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),P16,P41,P66,P91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Q16,Q41,Q66,Q91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),R16,R41,R66,R91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),S16,S41,S66,S91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),T16,T41,T66,T91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),U16,U41,U66,U91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),V16,V41,V66,V91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),W16,W41,W66,W91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),X16,X41,X66,X91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Y16,Y41,Y66,Y91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),Z16,Z41,Z66,Z91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AA16,AA41,AA66,AA91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AB16,AB41,AB66,AB91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AC16,AC41,AC66,AC91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AD16,AD41,AD66,AD91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AE16,AE41,AE66,AE91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AF16,AF41,AF66,AF91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AG16,AG41,AG66,AG91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AH16,AH41,AH66,AH91)","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),AI16,AI41,AI66,AI91)","v":0}]
[null,"Lifecycle Capex","NZ$:",null,{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(E19:E22),SUM(E44:E47),SUM(E69:E72),SUM(E94:E97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(F19:F22),SUM(F44:F47),SUM(F69:F72),SUM(F94:F97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(G19:G22),SUM(G44:G47),SUM(G69:G72),SUM(G94:G97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(H19:H22),SUM(H44:H47),SUM(H69:H72),SUM(H94:H97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(I19:I22),SUM(I44:I47),SUM(I69:I72),SUM(I94:I97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(J19:J22),SUM(J44:J47),SUM(J69:J72),SUM(J94:J97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(K19:K22),SUM(K44:K47),SUM(K69:K72),SUM(K94:K97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(L19:L22),SUM(L44:L47),SUM(L69:L72),SUM(L94:L97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(M19:M22),SUM(M44:M47),SUM(M69:M72),SUM(M94:M97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(N19:N22),SUM(N44:N47),SUM(N69:N72),SUM(N94:N97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(O19:O22),SUM(O44:O47),SUM(O69:O72),SUM(O94:O97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(P19:P22),SUM(P44:P47),SUM(P69:P72),SUM(P94:P97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(Q19:Q22),SUM(Q44:Q47),SUM(Q69:Q72),SUM(Q94:Q97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(R19:R22),SUM(R44:R47),SUM(R69:R72),SUM(R94:R97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(S19:S22),SUM(S44:S47),SUM(S69:S72),SUM(S94:S97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(T19:T22),SUM(T44:T47),SUM(T69:T72),SUM(T94:T97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(U19:U22),SUM(U44:U47),SUM(U69:U72),SUM(U94:U97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(V19:V22),SUM(V44:V47),SUM(V69:V72),SUM(V94:V97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(W19:W22),SUM(W44:W47),SUM(W69:W72),SUM(W94:W97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(X19:X22),SUM(X44:X47),SUM(X69:X72),SUM(X94:X97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(Y19:Y22),SUM(Y44:Y47),SUM(Y69:Y72),SUM(Y94:Y97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(Z19:Z22),SUM(Z44:Z47),SUM(Z69:Z72),SUM(Z94:Z97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AA19:AA22),SUM(AA44:AA47),SUM(AA69:AA72),SUM(AA94:AA97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AB19:AB22),SUM(AB44:AB47),SUM(AB69:AB72),SUM(AB94:AB97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AC19:AC22),SUM(AC44:AC47),SUM(AC69:AC72),SUM(AC94:AC97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AD19:AD22),SUM(AD44:AD47),SUM(AD69:AD72),SUM(AD94:AD97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AE19:AE22),SUM(AE44:AE47),SUM(AE69:AE72),SUM(AE94:AE97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AF19:AF22),SUM(AF44:AF47),SUM(AF69:AF72),SUM(AF94:AF97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AG19:AG22),SUM(AG44:AG47),SUM(AG69:AG72),SUM(AG94:AG97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AH19:AH22),SUM(AH44:AH47),SUM(AH69:AH72),SUM(AH94:AH97))","v":0},{"$f":"CHOOSE(MATCH('Model Inputs'!$K$5,'Model Inputs'!$F$14:$I$14,0),SUM(AI19:AI22),SUM(AI44:AI47),SUM(AI69:AI72),SUM(AI94:AI97))","v":0}]
[null,null,"NZ$:",null,{"$f":"SUM(E121:E124)","v":-253000},{"$f":"SUM(F121:F124)","v":14933.884827463644},15217.628639185456,15506.763583329976,15801.39209141324,16101.618541150099,16407.549293431952,16719.292730007153,17036.959291877294,17360.661518422956,17690.514087272993,18026.63385493118,18369.139898174868,18718.153556240188,19073.798473808754,19436.200644811121,19805.488457062533,20181.792737746713,20565.246799763903,20955.986488959421,21354.150232249645,21759.879086662386,22173.316789308981,22594.609808305842,23023.907394663653,23461.361635162266,23907.127506230339,24361.362928848714,24824.228824496837,25295.889172162271,25776.51106643337]
[null,"Check",null,null,{"$f":"E116-E125","v":0},{"$f":"F116-F125","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]