{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Coversheet","Modelling inputs","Growth (Residential)","Growth (Non-Residential)","Growth (Impervious Area)","BAICR Charge Lookup","Adopted Charge Revenue Forecast","LGIP Cash Flow Analysis"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Coversheet","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,2,44,4]]}
[null,"Brisbane City Council"]
[null,"Local Government Infrastructure Plan (LGIP)"]
[]
[]
[null,"Anticipated Charges Revenue and Future Cash Flows Model"]
[]
[null,"Version:","LGIP A1a"]
[null,"Date:","Effective 10 December 2021"]
[null,"Author:","Brisbane City Council"]
[]
[]
[null,"Model flow diagram (click to follow)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Admin Access Enabled? -->",null,null,"No"]

{"sheet":"Modelling inputs","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,1,23,1]]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"}]
["Input"]
["Formula",null,"General modelling inputs"]
[]
[null,null,"Model parameters",null,"Value",null,"BCC Comment/Source"]
[]
[null,null,"Modelling timframes"]
[]
[null,null,"Modelling start year:",null,2016,null,"Base values for all costs"]
[null,null,"Modelling end year:",null,2026,null,"N/A"]
[null,null,"Modelling term (years):",null,{"$f":"E12-E11","v":10},null,"N/A"]
[]
[null,null,"Financial inputs"]
[]
[null,null,"Average 10 Year Bond Rate:",null,null,null,"Not used"]
[null,null,"Basic Margin on 10 Yr. Bond Rate:",null,null,null,"Not used"]
[]
[null,null,"Calculated WACC:",null,{"$f":"E18+E17","v":0},null,"Not used"]
[]
[null,null,"Optional WACC over ride:",null,5.91E-2,null,"Corporately endorsed WACC rate"]
[]
[null,null,"Applied WACC:",null,{"$f":"IF(OR(WACC_override=\"\",WACC_override=0),WACC_Calculated,WACC_override)","v":5.91E-2},null,"Defaults to caculated WACC if no override value is entered"]
[]
[null,null,"Charge inputs"]
[]
[null,null,"Adopted Charging Source (Default)",null,"BAICR5",null,"Brisbane Adopted Infrastructure Charges Resolution (No.5) 2015"]
[]
[null,null,"Select charge methodology",null,"Default",null,"Not used"]
[]
[null,null,"Network expenditure inputs"]
[]
[null,null,"Local Roads",null,null,null,"Sourced from LGIP Local Roads network financial model"]
[]
[null,null,"Pathways",null,null,null,"Sourced from LGIP Pathways network financial model"]
[]
[null,null,"Ferry Terminals",null,null,null,"Sourced from LGIP Ferry Terminals network financial model"]
[]
[null,null,"Public Parks",null,null,null,"Sourced from LGIP Public Parks network financial model"]
[]
[null,null,"Land for Community Facilities",null,null,null,"Sourced from LGIP Land for Community Facilities network financial model"]
[]
[null,null,"Stormwater",null,null,null,"Sourced from LGIP Stormwater network financial model"]

{"sheet":"Growth (Residential)","index":2,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"},null,null,"Input"]
[null,null,null,"Formula"]
[1.1000000000000001,"Anticipated Residential Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2016,2021,2026]
[null,"Attached Dwelling","Number of dwellings: 1 or 2 bedroom dwelling",98722,120784,136797]
[null,"Attached Dwelling","Number of dwellings: 3 or more bedroom dwelling",45200,52988,58110]
[null,"Detached Dwelling","Number of dwellings: 1 or 2 bedroom dwelling",28101,28285,28513]
[null,"Detached Dwelling","Number of dwellings: 3 or more bedroom dwelling",281996,284884,290495]
[null,"Short term accommodation","Number of bedrooms: Bedroom that is not within a suite",10909,11835,12468]
[null,"Short term accommodation","Number of suites: Suite with 1 or 2 bedrooms",5615,6219,6739]
[null,"Short term accommodation","Number of suites: Suite with 3 or more bedrooms",1685,1858,2006]
[null,"Long term accommodation","Number of bedrooms: Bedroom that is not within a suite",510,534,556]
[null,"Long term accommodation","Number of suites: Suite with 1 or 2 bedrooms",1673,1752,1823]
[null,"Long term accommodation","Number of suites: Suite with 3 or more bedrooms",341,357,372]
[]
[1.2,"Anticipated Residential Growth - Annualised"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,"Charge Code","Applied Charge"]
[null,{"$f":"B8","v":"Attached Dwelling"},{"$f":"C8","v":"Number of dwellings: 1 or 2 bedroom dwelling"},{"$f":"D8","v":98722},{"$f":"($E8-$D8)/5","v":4412.3999999999996},4412.3999999999996,4412.3999999999996,4412.3999999999996,4412.3999999999996,{"$f":"($F8-$E8)/5","v":3202.6},3202.6,3202.6,3202.6,3202.6,null,"B11",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P22,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P22,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":10000}]
[null,{"$f":"B9","v":"Attached Dwelling"},"Number of dwellings: 3 or more bedroom dwelling",45200,1557.6,1557.6,1557.6,1557.6,1557.6,1024.4000000000001,1024.4000000000001,1024.4000000000001,1024.4000000000001,1024.4000000000001,null,"B12",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P23,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P23,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14000}]
[null,{"$f":"B10","v":"Detached Dwelling"},"Number of dwellings: 1 or 2 bedroom dwelling",28101,36.799999999999997,36.799999999999997,36.799999999999997,36.799999999999997,36.799999999999997,45.6,45.6,45.6,45.6,45.6,null,"B31",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P24,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P24,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":10000}]
[null,{"$f":"B11","v":"Detached Dwelling"},"Number of dwellings: 3 or more bedroom dwelling",281996,577.6,577.6,577.6,577.6,577.6,1122.2,1122.2,1122.2,1122.2,1122.2,null,"B32",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P25,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P25,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14000}]
[null,{"$f":"B12","v":"Short term accommodation"},"Number of bedrooms: Bedroom that is not within a suite",10909,185.2,185.2,185.2,185.2,185.2,126.6,126.6,126.6,126.6,126.6,null,"C01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P26,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P26,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":4000}]
[null,{"$f":"B13","v":"Short term accommodation"},"Number of suites: Suite with 1 or 2 bedrooms",5615,120.8,120.8,120.8,120.8,120.8,104,104,104,104,104,null,"C02",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P27,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P27,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":4000}]
[null,{"$f":"B14","v":"Short term accommodation"},"Number of suites: Suite with 3 or more bedrooms",1685,34.6,34.6,34.6,34.6,34.6,29.6,29.6,29.6,29.6,29.6,null,"C03",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P28,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P28,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":6000}]
[null,{"$f":"B15","v":"Long term accommodation"},"Number of bedrooms: Bedroom that is not within a suite",510,4.8,4.8,4.8,4.8,4.8,4.4000000000000004,4.4000000000000004,4.4000000000000004,4.4000000000000004,4.4000000000000004,null,"D01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P29,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P29,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":8000}]
[null,{"$f":"B16","v":"Long term accommodation"},"Number of suites: Suite with 1 or 2 bedrooms",1673,15.8,15.8,15.8,15.8,15.8,14.2,14.2,14.2,14.2,14.2,null,"D02",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P30,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P30,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":8000}]
[null,{"$f":"B17","v":"Long term accommodation"},"Number of suites: Suite with 3 or more bedrooms",341,3.2,3.2,3.2,3.2,3.2,3,3,3,3,3,null,"D03",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P31,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP('Growth (Residential)'!P31,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":12000}]
[]
[1.3,"Anticipated Revenue - Applied Charge (3)"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,{"$f":"B8","v":"Attached Dwelling"},{"$f":"C8","v":"Number of dwellings: 1 or 2 bedroom dwelling"},"N/A",{"$f":"E22*$Q22","v":44124000},44124000,44124000,44124000,44124000,32026000,32026000,32026000,32026000,32026000]
[null,{"$f":"B9","v":"Attached Dwelling"},"Number of dwellings: 3 or more bedroom dwelling","N/A",{"$f":"E23*$Q23","v":21806400},21806400,21806400,21806400,21806400,14341600.000000002,14341600.000000002,14341600.000000002,14341600.000000002,14341600.000000002]
[null,{"$f":"B10","v":"Detached Dwelling"},"Number of dwellings: 1 or 2 bedroom dwelling","N/A",{"$f":"E24*$Q24","v":368000},368000,368000,368000,368000,456000,456000,456000,456000,456000]
[null,{"$f":"B11","v":"Detached Dwelling"},"Number of dwellings: 3 or more bedroom dwelling","N/A",{"$f":"E25*$Q25","v":8086400},8086400,8086400,8086400,8086400,15710800,15710800,15710800,15710800,15710800]
[null,{"$f":"B12","v":"Short term accommodation"},"Number of bedrooms: Bedroom that is not within a suite","N/A",{"$f":"E26*$Q26","v":740800},740800,740800,740800,740800,506400,506400,506400,506400,506400]
[null,{"$f":"B13","v":"Short term accommodation"},"Number of suites: Suite with 1 or 2 bedrooms","N/A",{"$f":"E27*$Q27","v":483200},483200,483200,483200,483200,416000,416000,416000,416000,416000]
[null,{"$f":"B14","v":"Short term accommodation"},"Number of suites: Suite with 3 or more bedrooms","N/A",{"$f":"E28*$Q28","v":207600},207600,207600,207600,207600,177600,177600,177600,177600,177600]
[null,{"$f":"B15","v":"Long term accommodation"},"Number of bedrooms: Bedroom that is not within a suite","N/A",{"$f":"E29*$Q29","v":38400},38400,38400,38400,38400,35200,35200,35200,35200,35200]
[null,{"$f":"B16","v":"Long term accommodation"},"Number of suites: Suite with 1 or 2 bedrooms","N/A",{"$f":"E30*$Q30","v":126400},126400,126400,126400,126400,113600,113600,113600,113600,113600]
[null,{"$f":"B17","v":"Long term accommodation"},"Number of suites: Suite with 3 or more bedrooms","N/A",{"$f":"E31*$Q31","v":38400},38400,38400,38400,38400,36000,36000,36000,36000,36000]
[null,"Total","N/A","N/A",{"$f":"SUM(E36:E45)","v":76019600},76019600,76019600,76019600,76019600,63819200,63819200,63819200,63819200,63819200]
[]
["Notes:"]
["(1) Attached and detached dwellings growth figures are based on the predicted residential dwelling supply. Short and long term accommodation growth figures are based on land use counts and growth rates sourced from LGIP planning assumptions."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) As it is Councils current proactice not to index charges, no indexation has been applied"]

{"sheet":"Growth (Non-Residential)","index":3,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"},null,null,"Input"]
[null,null,null,"Formula"]
[2.1,"Anticipated Non Residential Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2016,2021,2026]
[null,"Food Services, Arts & Recreation","m2 GFA",1329423,1450071,1541614]
[null,"Community - Education","m2 GFA",3341563,3754708,4194896]
[null,"Community - Health","m2 GFA",1710389,1902219,2068717]
[null,"Community - Other","m2 GFA",1016836,1132432,1253052]
[null,"Industry - General","m2 GFA",549703,587701,630370]
[null,"Industry - Heavy","m2 GFA",350643,391639,447057]
[null,"Industry - Light","m2 GFA",6559591,6854829,7153262]
[null,"Industry - Other","m2 GFA",128868,135382,143945]
[null,"Office","m2 GFA",6128313,6616538,7170238]
[null,"Retail","m2 GFA",3590588,3836609,4126138]
[null,"Showroom, Retail Warehouse & Bulky Goods","m2 GFA",921490,978076,1028868]
[null,"Warehouse, Bulk Stores & Logistics","m2 GFA",8403730,9052226,9897985]
[null,"Rural","m2 GFA",4666,5149,5260]
[]
[2.2000000000000002,"Anticipated Non Residential Growth - Annualised"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,"Charge Code","Applied Charge"]
[null,{"$f":"B8","v":"Food Services, Arts & Recreation"},{"$f":"C8","v":"m2 GFA"},{"$f":"D8","v":1329423},{"$f":"($E8-$D8)/5","v":24129.599999999999},{"$f":"($E8-$D8)/5","v":24129.599999999999},24129.599999999999,{"$f":"($E8-$D8)/5","v":24129.599999999999},24129.599999999999,{"$f":"($F8-$E8)/5","v":18308.599999999999},18308.599999999999,{"$f":"($F8-$E8)/5","v":18308.599999999999},18308.599999999999,18308.599999999999,null,"G02",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P25,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P25,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":144}]
[null,{"$f":"B9","v":"Community - Education"},"m2 GFA",{"$f":"D9","v":3341563},{"$f":"($E9-$D9)/5","v":82629},82629,82629,82629,82629,88037.6,88037.6,{"$f":"($F9-$E9)/5","v":88037.6},88037.6,88037.6,null,"J03",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P26,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P26,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":104}]
[null,{"$f":"B10","v":"Community - Health"},"m2 GFA",1710389,{"$f":"($E10-$D10)/5","v":38366},38366,38366,38366,38366,33299.599999999999,33299.599999999999,{"$f":"($F10-$E10)/5","v":33299.599999999999},33299.599999999999,33299.599999999999,null,"S03",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P27,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P27,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":104}]
[null,{"$f":"B11","v":"Community - Other"},"m2 GFA",1016836,{"$f":"($E11-$D11)/5","v":23119.200000000001},23119.200000000001,23119.200000000001,23119.200000000001,23119.200000000001,24124,24124,{"$f":"($F11-$E11)/5","v":24124},24124,24124,null,"E02",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P28,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P28,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":34}]
[null,{"$f":"B12","v":"Industry - General"},"m2 GFA",549703,{"$f":"($E12-$D12)/5","v":7599.6},7599.6,7599.6,7599.6,7599.6,8533.7999999999993,8533.7999999999993,{"$f":"($F12-$E12)/5","v":8533.7999999999993},8533.7999999999993,8533.7999999999993,null,"N02",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P29,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P29,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14}]
[null,{"$f":"B13","v":"Industry - Heavy"},"m2 GFA",350643,{"$f":"($E13-$D13)/5","v":8199.2000000000007},8199.2000000000007,8199.2000000000007,8199.2000000000007,8199.2000000000007,11083.6,11083.6,{"$f":"($F13-$E13)/5","v":11083.6},11083.6,11083.6,null,"P01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P30,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P30,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":30}]
[null,{"$f":"B14","v":"Industry - Light"},"m2 GFA",6559591,{"$f":"($E14-$D14)/5","v":59047.6},59047.6,59047.6,59047.6,59047.6,59686.6,59686.6,{"$f":"($F14-$E14)/5","v":59686.6},59686.6,59686.6,null,"N01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P31,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P31,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14}]
[null,{"$f":"B15","v":"Industry - Other"},"m2 GFA",128868,{"$f":"($E15-$D15)/5","v":1302.8},1302.8,1302.8,1302.8,1302.8,1712.6,1712.6,{"$f":"($F15-$E15)/5","v":1712.6},1712.6,1712.6,null,"N01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P32,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P32,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14}]
[null,{"$f":"B16","v":"Office"},"m2 GFA",6128313,{"$f":"($E16-$D16)/5","v":97645},97645,97645,97645,97645,110740,110740,{"$f":"($F16-$E16)/5","v":110740},110740,110740,null,"H01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P33,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P33,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":104}]
[null,{"$f":"B17","v":"Retail"},"m2 GFA",3590588,{"$f":"($E17-$D17)/5","v":49204.2},49204.2,49204.2,49204.2,49204.2,57905.8,57905.8,{"$f":"($F17-$E17)/5","v":57905.8},57905.8,57905.8,null,"G05",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P34,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P34,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":144}]
[null,{"$f":"B18","v":"Showroom, Retail Warehouse & Bulky Goods"},"m2 GFA",921490,{"$f":"($E18-$D18)/5","v":11317.2},11317.2,11317.2,11317.2,11317.2,10158.4,10158.4,{"$f":"($F18-$E18)/5","v":10158.4},10158.4,10158.4,null,"F06",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P35,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P35,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":104}]
[null,{"$f":"B19","v":"Warehouse, Bulk Stores & Logistics"},"m2 GFA",8403730,{"$f":"($E19-$D19)/5","v":129699.2},129699.2,129699.2,129699.2,129699.2,169151.8,169151.8,{"$f":"($F19-$E19)/5","v":169151.8},169151.8,169151.8,null,"N05",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P36,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P36,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":14}]
[null,{"$f":"B20","v":"Rural"},"m2 GFA",4666,{"$f":"($E20-$D20)/5","v":96.6},96.6,96.6,96.6,96.6,22.2,22.2,{"$f":"($F20-$E20)/5","v":22.2},22.2,22.2,null,"Q01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P37,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P37,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":0}]
[]
[2.2999999999999998,"Anticipated Revenue - Applied Charge (3)"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,{"$f":"B8","v":"Food Services, Arts & Recreation"},{"$f":"C8","v":"m2 GFA"},"N/A",{"$f":"E25*$Q25","v":3474662.4},{"$f":"F25*$Q25","v":3474662.4},3474662.4,{"$f":"H25*$Q25","v":3474662.4},3474662.4,2636438.4,2636438.4,2636438.4,2636438.4,2636438.4]
[null,{"$f":"B9","v":"Community - Education"},"m2 GFA","N/A",{"$f":"E26*$Q26","v":8593416},8593416,8593416,8593416,8593416,9155910.4000000004,9155910.4000000004,9155910.4000000004,9155910.4000000004,9155910.4000000004]
[null,{"$f":"B10","v":"Community - Health"},"m2 GFA","N/A",3990064,3990064,3990064,3990064,3990064,3463158.4,3463158.4,3463158.4,3463158.4,3463158.4]
[null,{"$f":"B11","v":"Community - Other"},"m2 GFA","N/A",786052.8,786052.8,786052.8,786052.8,786052.8,820216,820216,820216,820216,820216]
[null,{"$f":"B12","v":"Industry - General"},"m2 GFA","N/A",106394.40000000001,106394.40000000001,106394.40000000001,106394.40000000001,106394.40000000001,119473.19999999998,119473.19999999998,119473.19999999998,119473.19999999998,119473.19999999998]
[null,{"$f":"B13","v":"Industry - Heavy"},"m2 GFA","N/A",245976.00000000003,245976.00000000003,245976.00000000003,245976.00000000003,245976.00000000003,332508,332508,332508,332508,332508]
[null,{"$f":"B14","v":"Industry - Light"},"m2 GFA","N/A",826666.4,826666.4,826666.4,826666.4,826666.4,835612.4,835612.4,835612.4,835612.4,835612.4]
[null,{"$f":"B15","v":"Industry - Other"},"m2 GFA","N/A",18239.2,18239.2,18239.2,18239.2,18239.2,23976.399999999998,23976.399999999998,23976.399999999998,23976.399999999998,23976.399999999998]
[null,{"$f":"B16","v":"Office"},"m2 GFA","N/A",10155080,10155080,10155080,10155080,10155080,11516960,11516960,11516960,11516960,11516960]
[null,{"$f":"B17","v":"Retail"},"m2 GFA","N/A",7085404.7999999998,7085404.7999999998,7085404.7999999998,7085404.7999999998,7085404.7999999998,8338435.2000000002,8338435.2000000002,8338435.2000000002,8338435.2000000002,8338435.2000000002]
[null,{"$f":"B18","v":"Showroom, Retail Warehouse & Bulky Goods"},"m2 GFA","N/A",1176988.8,1176988.8,1176988.8,1176988.8,1176988.8,1056473.5999999999,1056473.5999999999,1056473.5999999999,1056473.5999999999,1056473.5999999999]
[null,{"$f":"B19","v":"Warehouse, Bulk Stores & Logistics"},"m2 GFA","N/A",1815788.8,1815788.8,1815788.8,1815788.8,1815788.8,2368125.1999999997,2368125.1999999997,2368125.1999999997,2368125.1999999997,2368125.1999999997]
[null,{"$f":"B20","v":"Rural"},"m2 GFA","N/A",0,0,0,0,0,0,0,0,0,0]
[null,"Total","N/A","N/A",{"$f":"SUM(E42:E54)","v":38274733.599999987},{"$f":"SUM(F42:F54)","v":38274733.599999987},38274733.599999987,38274733.599999987,38274733.599999987,40667287.200000003,40667287.200000003,40667287.200000003,40667287.200000003,40667287.200000003]
[]
["Notes:"]
["(1) Growth figures are based on land use counts and growth rates sourced from LGIP planning assumptions."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) As it is Councils current proactice not to index charges, no indexation has been applied"]

{"sheet":"Growth (Impervious Area)","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"},null,null,"Input"]
[null,null,null,"Formula"]
[3.1,"Anticipated Impervious Area Growth - Census Year"]
[]
[null,"Development type(1)","Unit of demand(2)",2016,2021,2026]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2",50334875.407358818,52236427.725723013,54436481.207498044]
[]
[3.2,"Anticipated Non Residential Growth - Annualised"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,"Charge Code","Applied Charge"]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2",{"$f":"D8","v":50334875.407358818},{"$f":"($E8-$D8)/5","v":380310.46367283911},{"$f":"($E8-$D8)/5","v":380310.46367283911},380310.46367283911,380310.46367283911,380310.46367283911,{"$f":"($F8-$E8)/5","v":440010.69635500608},{"$f":"($F8-$E8)/5","v":440010.69635500608},440010.69635500608,440010.69635500608,440010.69635500608,null,"W01",{"$f":"IFERROR(IF('Modelling inputs'!$E$30=\"Default\",VLOOKUP(P13,'BAICR Charge Lookup'!A:F,6,FALSE),IF('Modelling inputs'!$E$30=\"Alternate charge\",VLOOKUP(P13,'BAICR Charge Lookup'!A:G,7,FALSE))),0)","v":10}]
[]
[2.2999999999999998,"Anticipated Revenue - Applied Charge (3)"]
[]
[null,"Development type","Unit of demand",2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Non-residential Stormwater Impervious Area","Impervious area in m2","N/A",{"$f":"E13*$Q13","v":3803104.6367283911},{"$f":"F13*$Q13","v":3803104.6367283911},3803104.6367283911,3803104.6367283911,3803104.6367283911,4400106.963550061,4400106.963550061,4400106.963550061,4400106.963550061,4400106.963550061]
[]
["Notes:"]
["(1) Growth figures are based on impervious area in non-residential city plan zones. Growth in centre, mixed use and residential zones have been excluded."]
["(2) Unit of demand is based on the current Adopted Infrastructure Charge Resolution."]
["(3) As it is Councils current proactice not to index charges, no indexation has been applied"]

{"sheet":"BAICR Charge Lookup","index":5,"n_rows":141,"n_cols":7,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"}]
[]
["Charges categories, sub-categories, demand units, and applied adopted charge (AAC) rate - Lookup table"]
["Brisbane Adopted Infrastructure Charges Resolution (No.5) 2015"]
[]
["4.1 Reconfiguration of a Lot"]
["Code","Category","Sub Category","Demand Unit",null,"AICR5 Charge","Alt. Charge"]
["A01","01 Residential (Reconfiguration of a Lot)","Residential Lot","Number of residential lots",null,14000,0]
["A02","02 Non-Residential (Reconfiguration of a Lot)","Non-Residential Lot","Number of non-residential lots",null,14000,0]
[]
["4.2 Material Change of Use (Residential - Transport, Community Purposes, and Waterways)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR5 Charge","Alt. Charge"]
["B01","01 Residential (Material Change of Use/Building Work)","Caretaker's accommodation - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10000,0]
["B02","01 Residential (Material Change of Use/Building Work)","Caretaker's accommodation - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,14000,0]
["B11","01 Residential (Material Change of Use/Building Work)","Dwelling house - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10000,0]
["B12","01 Residential (Material Change of Use/Building Work)","Dwelling house - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,14000,0]
["B21","01 Residential (Material Change of Use/Building Work)","Dual occupancy - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10000,0]
["B22","01 Residential (Material Change of Use/Building Work)","Dual occupancy - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,14000,0]
["B31","01 Residential (Material Change of Use/Building Work)","Multiple dwelling - 1 or 2 bedroom dwelling","Number of dwellings: 1 or 2 bedroom dwelling",null,10000,0]
["B32","01 Residential (Material Change of Use/Building Work)","Multiple dwelling - 3 or more bedroom dwelling","Number of dwellings: 3 or more bedroom dwelling",null,14000,0]
["C01","02 Residential Accommodation (short term)","Hotel (residential component) - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,4000,0]
["C02","02 Residential Accommodation (short term)","Hotel (residential component) - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,4000,0]
["C03","02 Residential Accommodation (short term)","Hotel (residential component) - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,6000,0]
["C11","02 Residential Accommodation (short term)","Short-term accommodation - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,4000,0]
["C12","02 Residential Accommodation (short term)","Short-term accommodation - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,4000,0]
["C13","02 Residential Accommodation (short term)","Short-term accommodation - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,6000,0]
["C21","02 Residential Accommodation (short term)","Tourist Park - 1 or 2 tent or caravan sites","Number of sites: 1 or 2 tent or caravan site",null,4000,0]
["C22","02 Residential Accommodation (short term)","Tourist Park - 3 or more tent or caravan sites","Number of sites: 3 or more tent or caravan site",null,6000,0]
["C23","02 Residential Accommodation (short term)","Tourist Park - 1 or 2 bedroom cabin","Number of cabins: 1 or 2 bedroom cabin",null,4000,0]
["C24","02 Residential Accommodation (short term)","Tourist Park - 3 or more bedroom cabin","Number of cabins: 3 or more bedroom cabin",null,6000,0]
["D01","03 Residential Accommodation (long term)","Community residence - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,8000,0]
["D02","03 Residential Accommodation (long term)","Community residence - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,8000,0]
["D03","03 Residential Accommodation (long term)","Community residence - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,12000,0]
["D11","03 Residential Accommodation (long term)","Hostel - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,8000,0]
["D12","03 Residential Accommodation (long term)","Hostel - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,8000,0]
["D13","03 Residential Accommodation (long term)","Hostel - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,12000,0]
["D21","03 Residential Accommodation (long term)","On-site student accommodation ancillary to educational establishment - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,4000,0]
["D22","03 Residential Accommodation (long term)","On-site student accommodation ancillary to educational establishment - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null," N/A ",0]
["D23","03 Residential Accommodation (long term)","On-site student accommodation ancillary to educational establishment - Suite with 1 bedroom","Number of suites: Suite with 1 bedroom",null,4000,0]
["D24","03 Residential Accommodation (long term)","On-site student accommodation ancillary to educational establishment - Suite with 2 bedrooms","Number of suites: Suite with 2 bedrooms",null,8000,0]
["D25","03 Residential Accommodation (long term)","On-site student accommodation ancillary to educational establishment - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,12000,0]
["D31","03 Residential Accommodation (long term)","Relocatable home park - 1 or 2 bedroom relocatable dwelling site","Number of sites: 1 or 2 bedroom relocatable dwelling site",null,8000,0]
["D32","03 Residential Accommodation (long term)","Relocatable home park - 3 or more bedroom relocatable dwelling site","Number of sites: 3 or more bedroom relocatable dwelling site",null,12000,0]
["D41","03 Residential Accommodation (long term)","Retirement facility - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,8000,0]
["D42","03 Residential Accommodation (long term)","Retirement facility - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null,8000,0]
["D43","03 Residential Accommodation (long term)","Retirement facility - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,12000,0]
["D51","03 Residential Accommodation (long term)","Rooming accommodation (off-site student accommodation) - Bedroom that is not within a suite","Number of bedrooms: Bedroom that is not within a suite",null,4000,0]
["D52","03 Residential Accommodation (long term)","Rooming accommodation (off-site student accommodation) - Suite with 1 or 2 bedrooms","Number of suites: Suite with 1 or 2 bedrooms",null," N/A ",0]
["D53","03 Residential Accommodation (long term)","Rooming accommodation (off-site student accommodation) - Suite with 1 bedroom","Number of suites: Suite with 1 bedroom",null,4000,0]
["D54","03 Residential Accommodation (long term)","Rooming accommodation (off-site student accommodation) - Suite with 2 bedrooms","Number of suites: Suite with 2 bedrooms",null,8000,0]
["D55","03 Residential Accommodation (long term)","Rooming accommodation (off-site student accommodation) - Suite with 3 or more bedrooms","Number of suites: Suite with 3 or more bedrooms",null,12000,0]
[]
["4.3 Material Change of Use (Non-Residential - Transport, and Community Purposes)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR5 Charge","Alt. Charge"]
["E01","04 Non-Residential Places of assembly","Club","m2 GFA",null,34,0]
["E02","04 Non-Residential Places of assembly","Community use","m2 GFA",null,34,0]
["E03","04 Non-Residential Places of assembly","Function facility","m2 GFA",null,34,0]
["E04","04 Non-Residential Places of assembly","Funeral parlour","m2 GFA",null,34,0]
["E05","04 Non-Residential Places of assembly","Place of worship","m2 GFA",null,34,0]
["F01","05 Non-Residential Commercial (bulk goods)","Agricultural supplies store","m2 GFA",null,104,0]
["F02","05 Non-Residential Commercial (bulk goods)","Bulk landscape supplies","m2 GFA",null,104,0]
["F03","05 Non-Residential Commercial (bulk goods)","Garden centre","m2 GFA",null,104,0]
["F04","05 Non-Residential Commercial (bulk goods)","Hardware and trade supplies","m2 GFA",null,104,0]
["F05","05 Non-Residential Commercial (bulk goods)","Outdoor sales","m2 GFA",null,104,0]
["F06","05 Non-Residential Commercial (bulk goods)","Showroom","m2 GFA",null,104,0]
["G01","06 Non-Residential Commercial (retail)","Adult store","m2 GFA",null,144,0]
["G02","06 Non-Residential Commercial (retail)","Food and drink outlet","m2 GFA",null,144,0]
["G03","06 Non-Residential Commercial (retail)","Service industry","m2 GFA",null,144,0]
["G04","06 Non-Residential Commercial (retail)","Service station","m2 GFA",null,144,0]
["G05","06 Non-Residential Commercial (retail)","Shop","m2 GFA",null,144,0]
["G06","06 Non-Residential Commercial (retail)","Shopping centre","m2 GFA",null,144,0]
["H01","07 Non-Residential Commercial (office)","Office","m2 GFA",null,104,0]
["H02","07 Non-Residential Commercial (office)","Sales Office","m2 GFA",null,104,0]
["J01","08 Non-Residential Education facility except an educational establishment for the Flying Start for Children program","Child care centre","m2 GFA",null,104,0]
["J02","08 Non-Residential Education facility except an educational establishment for the Flying Start for Children program","Community care centre","m2 GFA",null,104,0]
["J03","08 Non-Residential Education facility except an educational establishment for the Flying Start for Children program","Educational establishment except an educational establishment for the Flying Start for Children program","m2 GFA",null,104,0]
["K01","09 Non-Residential Educational establishment for the Flying Start for Children program","Educational establishment for the Flying Start for Queensland Children program","m2 GFA",null,0,0]
["L01","10 Non-Residential Entertainment","Hotel (non-residential component)","m2 GFA",null,140,0]
["L02","10 Non-Residential Entertainment","Nightclub","m2 GFA",null,140,0]
["L03","10 Non-Residential Entertainment","Theatre","m2 GFA",null,140,0]
["M01","11 Non-Residential Indoor sport and recreational facility","Indoor sport and recreation (facility only)","m2 GFA",null,140,0]
["M02","11 Non-Residential Indoor sport and recreational facility","Indoor sport and recreation (court areas)","m2 GFA",null,15,0]
["N01","12 Non-Residential Industry","Low impact industry","m2 GFA",null,14,0]
["N02","12 Non-Residential Industry","Medium impact industry","m2 GFA",null,14,0]
["N03","12 Non-Residential Industry","Research and technology industry","m2 GFA",null,14,0]
["N04","12 Non-Residential Industry","Rural industry","m2 GFA",null,14,0]
["N05","12 Non-Residential Industry","Warehouse","m2 GFA",null,14,0]
["N06","12 Non-Residential Industry","Waterfront and marine industry","m2 GFA",null,14,0]
["P01","13 Non-Residential High impact industry","High impact industry","m2 GFA",null,30,0]
["P02","13 Non-Residential High impact industry","Noxious and hazardous industries","m2 GFA",null,30,0]
["Q01","14 Non-Residential Low impact rural","Animal husbandry","m2 GFA",null,0,0]
["Q02","14 Non-Residential Low impact rural","Cropping","m2 GFA",null,0,0]
["Q03","14 Non-Residential Low impact rural","Permanent plantations","m2 GFA",null,0,0]
["Q04","14 Non-Residential Low impact rural","Wind farms","m2 GFA",null,0,0]
["R01","15 Non-Residential High impact rural","Aquaculture","m2 GFA",null,10,0]
["R02","15 Non-Residential High impact rural","Intensive animal industries","m2 GFA",null,10,0]
["R03","15 Non-Residential High impact rural","Intensive horticulture","m2 GFA",null,10,0]
["R04","15 Non-Residential High impact rural","Wholesale nursery","m2 GFA",null,10,0]
["R05","15 Non-Residential High impact rural","Winery","m2 GFA",null,10,0]
["S01","16 Non-Residential Essential services","Correctional facility","m2 GFA",null,104,0]
["S02","16 Non-Residential Essential services","Emergency services","m2 GFA",null,104,0]
["S03","16 Non-Residential Essential services","Health care services","m2 GFA",null,104,0]
["S04","16 Non-Residential Essential services","Hospital","m2 GFA",null,104,0]
["S05","16 Non-Residential Essential services","Residential care facility","m2 GFA",null,104,0]
["S06","16 Non-Residential Essential services","Veterinary services","m2 GFA",null,104,0]
["T01","17 Non-Residential Minor uses","Advertising device","m2 GFA",null,0,0]
["T02","17 Non-Residential Minor uses","Cemetery","m2 GFA",null,0,0]
["T03","17 Non-Residential Minor uses","Home based business","m2 GFA",null,0,0]
["T04","17 Non-Residential Minor uses","Landing","m2 GFA",null,0,0]
["T05","17 Non-Residential Minor uses","Market","m2 GFA",null,0,0]
["T06","17 Non-Residential Minor uses","Outdoor lighting","m2 GFA",null,0,0]
["T07","17 Non-Residential Minor uses","Park","m2 GFA",null,0,0]
["T08","17 Non-Residential Minor uses","Roadside stalls","m2 GFA",null,0,0]
["T09","17 Non-Residential Minor uses","Telecommunications facility","m2 GFA",null,0,0]
["T10","17 Non-Residential Minor uses","Temporary use","m2 GFA",null,0,0]
["U01","Other uses","Brothel","m2 GFA",null," User Defined ",0]
["U02","Other uses","Car wash","m2 GFA",null," User Defined ",0]
["U03","Other uses","Environment Facility","m2 GFA",null," User Defined ",0]
["U04","Other uses","Major electricity infrastructure","m2 GFA",null," User Defined ",0]
["U05","Other uses","Nature-based tourism","m2 GFA",null," User Defined ",0]
["U06","Other uses","Substation","m2 GFA",null," User Defined ",0]
["U07","Other uses","Transport depot","m2 GFA",null," User Defined ",0]
["U08","Other uses","Other","m2 GFA",null," User Defined ",0]
["V01","Specialised uses","Air services","m2 GFA",null," User Defined ",0]
["V02","Specialised uses","Animal keeping","m2 GFA",null," User Defined ",0]
["V03","Specialised uses","Car park","m2 GFA",null," User Defined ",0]
["V04","Specialised uses","Crematorium","m2 GFA",null," User Defined ",0]
["V05","Specialised uses","Extractive industry","m2 GFA",null," User Defined ",0]
["V06","Specialised uses","Major sport, recreation and entertainment facility","m2 GFA",null," User Defined ",0]
["V07","Specialised uses","Motor sport","m2 GFA",null," User Defined ",0]
["V08","Specialised uses","Non-resident workforce accommodation","m2 GFA",null," User Defined ",0]
["V09","Specialised uses","Outdoor sport and recreation","m2 GFA",null," User Defined ",0]
["V10","Specialised uses","Port services","m2 GFA",null," User Defined ",0]
["V11","Specialised uses","Tourist attraction","m2 GFA",null," User Defined ",0]
["V12","Specialised uses","Utility installation","m2 GFA",null," User Defined ",0]
[]
["4.4 Material Change of Use (Non-Residential - Waterways)"]
["Code","Category","Sub Category","Demand Unit",null,"AICR5 Charge","Alt. Charge"]
["W01","18 Non-Residential Stormwater","Stormwater impervious area","Impervious area in m2",null,10,0]

{"sheet":"Adopted Charge Revenue Forecast","index":6,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"},null,null,null,null,null,null,null,"Input"]
[null,null,null,null,null,null,null,null,"Formula"]
[5.0999999999999996,"Anticipated infrastructure charges revenue ($'000)"]
[null,{"$f":"IF('Modelling inputs'!E30=\"Default\",\"Brisbane Adopted Infrastructure Charge Resolution (No.5) 2015\",IF('Modelling inputs'!E30=\"Alternate charge\",\"Alternate charging scenario: \"&'Modelling inputs'!G30,\"ERROR\"))","v":"Brisbane Adopted Infrastructure Charge Resolution (No.5) 2015"}]
[]
[null,null,null,"Model year",null,0,1,2,3,4,5,6,7,8,9,10]
[null,"Development type",null,"2016 NPV",null,"2016 (1)",2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Residential",null,{"$f":"F10+NPV(WACC,G10:P10)","v":523242.82341587829},null,0,{"$f":"HLOOKUP(G9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":76019.600000000006},{"$f":"HLOOKUP(H9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":76019.600000000006},{"$f":"HLOOKUP(I9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":76019.600000000006},{"$f":"HLOOKUP(J9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":76019.600000000006},{"$f":"HLOOKUP(K9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":76019.600000000006},{"$f":"HLOOKUP(L9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":63819.199999999997},{"$f":"HLOOKUP(M9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":63819.199999999997},{"$f":"HLOOKUP(N9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":63819.199999999997},{"$f":"HLOOKUP(O9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":63819.199999999997},{"$f":"HLOOKUP(P9,'Growth (Residential)'!$E$35:$N$46,12,FALSE)/1000","v":63819.199999999997}]
[null,"Non-residential",null,{"$f":"F11+NPV(WACC,G11:P11)","v":290492.16200997325},null,0,{"$f":"HLOOKUP(G9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":38274.733599999985},{"$f":"HLOOKUP(H9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":38274.733599999985},{"$f":"HLOOKUP(I9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":38274.733599999985},{"$f":"HLOOKUP(J9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":38274.733599999985},{"$f":"HLOOKUP(K9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":38274.733599999985},{"$f":"HLOOKUP(L9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":40667.287200000006},{"$f":"HLOOKUP(M9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":40667.287200000006},{"$f":"HLOOKUP(N9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":40667.287200000006},{"$f":"HLOOKUP(O9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":40667.287200000006},{"$f":"HLOOKUP(P9,'Growth (Non-Residential)'!$E$41:$N$55,15,FALSE)/1000","v":40667.287200000006}]
[null,"Non-residential (Stormwater)",null,{"$f":"F12+NPV(WACC,G12:P12)","v":30002.748437234364},null,0,{"$f":"HLOOKUP(G9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":3803.1046367283911},{"$f":"HLOOKUP(H9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":3803.1046367283911},{"$f":"HLOOKUP(I9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":3803.1046367283911},{"$f":"HLOOKUP(J9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":3803.1046367283911},{"$f":"HLOOKUP(K9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":3803.1046367283911},{"$f":"HLOOKUP(L9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":4400.1069635500608},{"$f":"HLOOKUP(M9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":4400.1069635500608},{"$f":"HLOOKUP(N9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":4400.1069635500608},{"$f":"HLOOKUP(O9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":4400.1069635500608},{"$f":"HLOOKUP(P9,'Growth (Impervious Area)'!$E$17:$N$18,2,FALSE)/1000","v":4400.1069635500608}]
[null,"Total revenue",null,843737.73386308574,null,0,{"$f":"SUM(G10:G12)","v":118097.43823672837},{"$f":"SUM(H10:H12)","v":118097.43823672837},118097.43823672837,118097.43823672837,118097.43823672837,108886.59416355006,108886.59416355006,108886.59416355006,108886.59416355006,108886.59416355006]
[]
[null,"Notes:"]
[null,"(1) Optional: Enter expected charges revenue for base year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Yes"]

{"sheet":"LGIP Cash Flow Analysis","index":7,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Local Government Infrastructure Plan"]
["Brisbane City Council",null,null,null,"Input"]
[{"$f":"Coversheet!C8","v":"Effective 10 December 2021"},null,null,null,"Formula"]
[]
[6.1,"LGIP Summary Cash Flow Projections ($,000's)"]
[null,{"$f":"IF('Modelling inputs'!E30=\"Default\",\"Brisbane Adopted Infrastructure Charge Resolution (No.5) 2015\",IF('Modelling inputs'!E30=\"Alternate charge\",\"Alternate charging scenario: \"&'Modelling inputs'!G30,\"ERROR\"))","v":"Brisbane Adopted Infrastructure Charge Resolution (No.5) 2015"}]
[]
[null,"Cost Category","Sub-category",null,"2016 NPV",null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Anticipated Cost (Cap X in $'000)","Local Roads",null,1278877.72,null,null,86733.148400000005,86733.148400000005,86733.148400000005,86733.148400000005,86733.148400000005,289329.9032,289329.9032,289329.9032,289329.9032,289329.9032]
[null,null,"Pathway",null,226868.679,null,null,7176.8486000000003,7176.8486000000003,7176.8486000000003,7176.8486000000003,7176.8486000000003,62265.537200000006,62265.537200000006,62265.537200000006,62265.537200000006,62265.537200000006]
[null,null,"Ferry Terminals",null,101255.84699999999,null,null,12006.985400000001,12006.985400000001,12006.985400000001,12006.985400000001,12006.985400000001,16058.738800000001,16058.738800000001,16058.738800000001,16058.738800000001,16058.738800000001]
[null,null,"Public Parks",null,462221.967,null,null,44899.841999999997,44899.841999999997,44899.841999999997,44899.841999999997,44899.841999999997,86513.001199999999,86513.001199999999,86513.001199999999,86513.001199999999,86513.001199999999]
[null,null,"Land for Community Facilities",null,30574.798999999999,null,null,248.71480000000003,248.71480000000003,248.71480000000003,248.71480000000003,248.71480000000003,9348.8858,9348.8858,9348.8858,9348.8858,9348.8858]
[null,null,"Stormwater",null,115902.423,null,null,12029.4352,12029.4352,12029.4352,12029.4352,12029.4352,20666,20666,20666,20666,20666]
[null,null,"Total Network Costs",null,{"$f":"SUM(E9:E14)","v":2215701.4350000001},null,{"$f":"SUM(G9:G14)","v":0},{"$f":"SUM(H9:H14)","v":163094.97440000001},163094.97440000001,163094.97440000001,163094.97440000001,163094.97440000001,484182.0662,484182.0662,484182.0662,484182.0662,484182.0662]
[null,"Anticipated Charges Revenue ($'000)","Residential",null,{"$f":"G16+NPV(WACC,H16:Q16)","v":523242.82341587829},null,{"$f":"'Adopted Charge Revenue Forecast'!F10","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G10","v":76019.600000000006},{"$f":"'Adopted Charge Revenue Forecast'!H10","v":76019.600000000006},{"$f":"'Adopted Charge Revenue Forecast'!I10","v":76019.600000000006},{"$f":"'Adopted Charge Revenue Forecast'!J10","v":76019.600000000006},{"$f":"'Adopted Charge Revenue Forecast'!K10","v":76019.600000000006},{"$f":"'Adopted Charge Revenue Forecast'!L10","v":63819.199999999997},{"$f":"'Adopted Charge Revenue Forecast'!M10","v":63819.199999999997},{"$f":"'Adopted Charge Revenue Forecast'!N10","v":63819.199999999997},{"$f":"'Adopted Charge Revenue Forecast'!O10","v":63819.199999999997},{"$f":"'Adopted Charge Revenue Forecast'!P10","v":63819.199999999997}]
[null,null,"Non-residential",null,290492.16200997325,null,{"$f":"'Adopted Charge Revenue Forecast'!F11","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G11","v":38274.733599999985},{"$f":"'Adopted Charge Revenue Forecast'!H11","v":38274.733599999985},{"$f":"'Adopted Charge Revenue Forecast'!I11","v":38274.733599999985},{"$f":"'Adopted Charge Revenue Forecast'!J11","v":38274.733599999985},{"$f":"'Adopted Charge Revenue Forecast'!K11","v":38274.733599999985},{"$f":"'Adopted Charge Revenue Forecast'!L11","v":40667.287200000006},{"$f":"'Adopted Charge Revenue Forecast'!M11","v":40667.287200000006},{"$f":"'Adopted Charge Revenue Forecast'!N11","v":40667.287200000006},{"$f":"'Adopted Charge Revenue Forecast'!O11","v":40667.287200000006},{"$f":"'Adopted Charge Revenue Forecast'!P11","v":40667.287200000006}]
[null,null,"Non-residential (Stormwater component)",null,30002.748437234364,null,{"$f":"'Adopted Charge Revenue Forecast'!F12","v":0},{"$f":"'Adopted Charge Revenue Forecast'!G12","v":3803.1046367283911},{"$f":"'Adopted Charge Revenue Forecast'!H12","v":3803.1046367283911},{"$f":"'Adopted Charge Revenue Forecast'!I12","v":3803.1046367283911},{"$f":"'Adopted Charge Revenue Forecast'!J12","v":3803.1046367283911},{"$f":"'Adopted Charge Revenue Forecast'!K12","v":3803.1046367283911},{"$f":"'Adopted Charge Revenue Forecast'!L12","v":4400.1069635500608},{"$f":"'Adopted Charge Revenue Forecast'!M12","v":4400.1069635500608},{"$f":"'Adopted Charge Revenue Forecast'!N12","v":4400.1069635500608},{"$f":"'Adopted Charge Revenue Forecast'!O12","v":4400.1069635500608},{"$f":"'Adopted Charge Revenue Forecast'!P12","v":4400.1069635500608}]
[null,null,"Total revenue",null,843737.73386308574,null,{"$f":"SUM(G16:G18)","v":0},{"$f":"SUM(H16:H18)","v":118097.43823672837},118097.43823672837,118097.43823672837,118097.43823672837,118097.43823672837,108886.59416355006,108886.59416355006,108886.59416355006,108886.59416355006,108886.59416355006]
[null,"Annual Cash Flow ($'000)","N/A",null,-1379275.4069594515,null,{"$f":"G19-G15","v":0},{"$f":"H19-H15","v":-44997.536163271638},-44997.536163271638,-44997.536163271638,-44997.536163271638,-44997.536163271638,-375295.47203644994,-375295.47203644994,-375295.47203644994,-375295.47203644994,-375295.47203644994]
[null,"Cumulative Cash Flow ($'000)","N/A",null,"N/A",null,{"$f":"G20","v":0},{"$f":"H20+G21","v":-44997.536163271638},{"$f":"I20+H21","v":-89995.072326543275},-134992.60848981491,-179990.14465308655,-224987.68081635819,-600283.15285280813,-975578.62488925806,-1350874.096925708,-1726169.5689621579,-2101465.0409986079]
[null,"Additional funding required","N/A",null,"N/A",null,{"$f":"G20","v":0},{"$f":"H20+G22","v":-44997.536163271638},{"$f":"I20+H22","v":-89995.072326543275},-134992.60848981491,-179990.14465308655,-224987.68081635819,-600283.15285280813,-975578.62488925806,-1350874.096925708,-1726169.5689621579,-2101465.0409986079]