{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Mississauga CBC Forecast"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Mississauga CBC Forecast","index":0,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[[88,0,92,0],[93,0,99,0]]}
["PLANNING NUMBERS",null,null,"CIL Rate"]
[null,null,null,10100,null,null,0.1,0.1,0.2,0.2,0.3,0.3]
["Condos/Apartments","Lower","Upper","Current Approach: CIL Rate",null,null,"10% - Lower","10% - Upper","20% - Lower","20% - Upper","30% - Lower","30% - Upper"]
["Downtown Core"]
["10 Year Units Forecast",7100,7100,{"$f":"ROUND($C5*D$2,-3)","v":71710000},null,null,{"$f":"ROUND($C5/$C6*$B7*H$2,-3)","v":21300000},{"$f":"ROUND($C5/$C6*$C7*H$2,-3)","v":28400000},{"$f":"ROUND($C5/$C6*$B7*J$2,-3)","v":42600000},{"$f":"ROUND($C5/$C6*$C7*J$2,-3)","v":56800000},{"$f":"ROUND($C5/$C6*$B7*L$2,-3)","v":63900000},{"$f":"ROUND($C5/$C6*$C7*L$2,-3)","v":85200000}]
["Av. density units/acre",{"$f":"C6","v":500},500]
["Av. land value/acre",15000000,20000000]
["Av. land value/unit",{"$f":"B7/C6","v":30000},{"$f":"C7/C6","v":40000}]
["Av. land value/sq. ft. (700 sq. ft. gross unit)",{"$f":"B8/(700*1.15)","v":37.267080745341623},{"$f":"C8/(700*1.15)","v":49.689440993788828}]
["Charge Per unit",null,null,{"$f":"D5/$C5","v":10100},null,null,{"$f":"G5/$C5","v":3000},4000,6000,8000,9000,12000]
["Major Nodes, Cooksville, Fairview, Hospital, Community Nodes"]
["10 Year Units Forecast",5820,5820,{"$f":"ROUND($C12*D$2,-3)","v":58782000},null,null,{"$f":"ROUND($C12/$C13*$B14*H$2,-3)","v":19954000},{"$f":"ROUND($C12/$C13*$C14*H$2,-3)","v":29931000},{"$f":"ROUND($C12/$C13*$B14*J$2,-3)","v":39909000},{"$f":"ROUND($C12/$C13*$C14*J$2,-3)","v":59863000},{"$f":"ROUND($C12/$C13*$B14*L$2,-3)","v":59863000},{"$f":"ROUND($C12/$C13*$C14*L$2,-3)","v":89794000}]
["Av. density units/acre",{"$f":"C13","v":350},350]
["Av. land value/acre",12000000,18000000]
["Av. land value/unit",{"$f":"ROUND(B14/B13,-2)","v":34300},{"$f":"ROUND(C14/C13,-2)","v":51400}]
["Av. land value/sq. ft. (700 sq. ft. gross unit)",{"$f":"B15/(700*1.15)","v":42.608695652173921},{"$f":"C15/(700*1.15)","v":63.850931677018643}]
["Charge Per unit",null,null,{"$f":"D12/$C12","v":10100},null,null,{"$f":"G12/$C12","v":3428.5223367697595},5142.783505154639,6857.216494845361,10285.738831615121,10285.738831615121,15428.52233676976]
["Neighbourhoods"]
["10 Year Units Forecast",1280,1280,{"$f":"ROUND($C19*D$2,-3)","v":12928000},null,null,{"$f":"ROUND($C19/$C20*$B21*H$2,-3)","v":6400000},{"$f":"ROUND($C19/$C20*$C21*H$2,-3)","v":9600000},{"$f":"ROUND($C19/$C20*$B21*J$2,-3)","v":12800000},{"$f":"ROUND($C19/$C20*$C21*J$2,-3)","v":19200000},{"$f":"ROUND($C19/$C20*$B21*L$2,-3)","v":19200000},{"$f":"ROUND($C19/$C20*$C21*L$2,-3)","v":28800000}]
["Av. density units/acre",{"$f":"C20","v":80},80]
["Av. land value/acre",4000000,6000000]
["Av. land value/unit",{"$f":"B21/C20","v":50000},{"$f":"C21/C20","v":75000}]
["Av. land value/sq. ft. (700 sq. ft. gross unit)",{"$f":"B22/(700*1.15)","v":62.111801242236034},{"$f":"C22/(700*1.15)","v":93.167701863354054}]
["Charge Per unit",null,null,{"$f":"D19/$C19","v":10100},null,null,{"$f":"G19/$C19","v":5000},7500,10000,15000,15000,22500]
[]
[{"$f":"\"Total \"&A3","v":"Total Condos/Apartments"},{"$f":"B5+B12+B19","v":14200},14200,{"$f":"D5+D12+D19","v":143420000},null,null,47654000,67931000,95309000,135863000,142963000,203794000]
[]
["Rows, Stacked, Back-to-Back",{"$f":"B3","v":"Lower"},"Upper","Current Approach: CIL Rate",null,null,"10% - Lower","10% - Upper","20% - Lower","20% - Upper","30% - Lower","30% - Upper"]
["Downtown Core"]
["10 Year Units Forecast",340,340,{"$f":"ROUND($C30*D$2,-3)","v":3434000},null,null,{"$f":"ROUND($C30/$C31*$B32*H$2,-3)","v":3022000},{"$f":"ROUND($C30/$C31*$C32*H$2,-3)","v":4533000},{"$f":"ROUND($C30/$C31*$B32*J$2,-3)","v":6044000},{"$f":"ROUND($C30/$C31*$C32*J$2,-3)","v":9067000},{"$f":"ROUND($C30/$C31*$B32*L$2,-3)","v":9067000},{"$f":"ROUND($C30/$C31*$C32*L$2,-3)","v":13600000}]
["Av. density units/acre",{"$f":"C31","v":45},45]
["Av. land value/acre",4000000,6000000]
["Av. land value/unit",{"$f":"B32/C31","v":88888.888888888891},{"$f":"C32/C31","v":133333.33333333334}]
["Charge Per unit",null,null,{"$f":"D30/$C30","v":10100},null,null,{"$f":"G30/$C30","v":8888.2352941176468},13332.35294117647,17776.470588235294,26667.647058823528,26667.647058823528,40000]
["Major Nodes, Cooksville, Fairview, Hospital, Community Nodes"]
["10 Year Units Forecast",540,540,{"$f":"ROUND($C36*D$2,-3)","v":5454000},null,null,{"$f":"ROUND($C36/$C37*$B38*H$2,-3)","v":4800000},{"$f":"ROUND($C36/$C37*$C38*H$2,-3)","v":7200000},{"$f":"ROUND($C36/$C37*$B38*J$2,-3)","v":9600000},{"$f":"ROUND($C36/$C37*$C38*J$2,-3)","v":14400000},{"$f":"ROUND($C36/$C37*$B38*L$2,-3)","v":14400000},{"$f":"ROUND($C36/$C37*$C38*L$2,-3)","v":21600000}]
["Av. density units/acre",{"$f":"C37","v":45},45]
["Av. land value/acre",4000000,6000000]
["Av. land value/unit",{"$f":"B38/C37","v":88888.888888888891},{"$f":"C38/C37","v":133333.33333333334}]
["Charge Per unit",null,null,{"$f":"D36/$C36","v":10100},null,null,{"$f":"G36/$C36","v":8888.8888888888887},13333.333333333334,17777.777777777777,26666.666666666668,26666.666666666668,40000]
["Neighbourhoods"]
["10 Year Units Forecast",1530,1530,{"$f":"ROUND($C42*D$2,-3)","v":15453000},null,null,{"$f":"ROUND($C42/$C43*$B44*H$2,-3)","v":20400000},{"$f":"ROUND($C42/$C43*$C44*H$2,-3)","v":30600000},{"$f":"ROUND($C42/$C43*$B44*J$2,-3)","v":40800000},{"$f":"ROUND($C42/$C43*$C44*J$2,-3)","v":61200000},{"$f":"ROUND($C42/$C43*$B44*L$2,-3)","v":61200000},{"$f":"ROUND($C42/$C43*$C44*L$2,-3)","v":91800000}]
["Av. density units/acre",{"$f":"C43","v":30},30]
["Av. land value/acre",4000000,6000000]
["Av. land value/unit",{"$f":"B44/C43","v":133333.33333333334},{"$f":"C44/C43","v":200000}]
["Charge Per unit",null,null,{"$f":"D42/$C42","v":10100},null,null,{"$f":"G42/$C42","v":13333.333333333334},20000,26666.666666666668,40000,40000,60000]
[]
[{"$f":"\"Total \"&A28","v":"Total Rows, Stacked, Back-to-Back"},{"$f":"B30+B36+B42","v":2410},2410,24341000,null,null,28222000,42333000,56444000,84667000,{"$f":"K30+K36+K42","v":84667000},127000000]
[]
["Section 37",null,null,{"$f":"ROUND(3000000*10,-3)","v":30000000}]
["DC Impact",null,null,1000000]
["TOTAL HIGH AND MID DENSITY INCL S. 37",{"$f":"B48+B26","v":16610},{"$f":"C48+C26","v":16610},{"$f":"D48+D26+D50+D51","v":198761000},null,null,{"$f":"G48+G26","v":75876000},110264000,151753000,220530000,227630000,330794000]
[]
["Singles/Semis",{"$f":"B28","v":"Lower"},{"$f":"C28","v":"Upper"},"Current Approach: 5%","5% - Lower","5% - Upper",{"$f":"G28","v":"10% - Lower"},"10% - Upper","20% - Lower","20% - Upper","30% - Lower","30% - Upper"]
["Greenfield Development"]
["10 Year Units Forecast",220,220]
["Av. cost per lot (42 ft frontage)",{"$f":"12000*42","v":504000},{"$f":"15000*42","v":630000},{"$f":"0.05*AVERAGE(B57:C57)*C56","v":6237000},{"$f":"ROUND(0.05*B56*B57,-3)","v":5544000},{"$f":"ROUND(0.05*C56*C57,-3)","v":6930000},{"$f":"G$2*$B57*$B56","v":11088000},{"$f":"H$2*$C57*$C56","v":13860000},{"$f":"I$2*$B57*$B56","v":22176000},{"$f":"J$2*$C57*$C56","v":27720000},{"$f":"K$2*$B57*$B56","v":33264000},{"$f":"L$2*$C57*$C56","v":41580000}]
["Charge Per unit",null,null,{"$f":"D57/$C56","v":28350},{"$f":"E57/$C56","v":25200},31500,{"$f":"G57/$C56","v":50400},63000,100800,126000,151200,189000]
[]
["Infill and Severance "]
["10 Year Units Forecast (20% in Port Credit)",870,870]
["Av. cost per lot (42 frontage)",{"$f":"C57","v":630000},{"$f":"26000*42","v":1092000},{"$f":"ROUND(0.05*AVERAGE(B62:C62)*C61,-3)","v":37454000},{"$f":"ROUND(0.05*B61*B62,-3)","v":27405000},{"$f":"ROUND(0.05*C61*C62,-3)","v":47502000},{"$f":"G$2*$B62*$B61","v":54810000},{"$f":"H$2*$C62*$C61","v":95004000},{"$f":"I$2*$B62*$B61","v":109620000},{"$f":"J$2*$C62*$C61","v":190008000},{"$f":"K$2*$B62*$B61","v":164430000},{"$f":"L$2*$C62*$C61","v":285012000}]
["Charge Per unit",null,null,{"$f":"D62/$C61","v":43050.574712643676},{"$f":"E62/$C61","v":31500},54600,{"$f":"G62/$C61","v":63000},{"$f":"H62/$C61","v":109200},{"$f":"I62/$C61","v":126000},{"$f":"J62/$C61","v":218400},{"$f":"K62/$C61","v":189000},{"$f":"L62/$C61","v":327600}]
[]
["TOTAL SINGLES AND SEMIS",{"$f":"B56+B61","v":1090},{"$f":"C56+C61","v":1090},{"$f":"D57+D62","v":43691000},32949000,54432000,65898000,108864000,131796000,217728000,197694000,326592000]
[]
[]
["GRAND TOTAL RESIDENTIAL",{"$f":"B52+B65","v":17700},{"$f":"C52+C65","v":17700},{"$f":"D65+D52","v":242452000},{"$f":"E65+D52","v":231710000},{"$f":"F65+D52","v":253193000},141774000,219128000,283549000,438258000,425324000,657386000]
[]
["NON-RESIDENTIAL ","Lower","Upper","Current Approach: 5%, 2%","5%, 2% - Lower","5%, 2% - Upper",{"$f":"G54","v":"10% - Lower"},"10% - Upper","20% - Lower","20% - Upper","30% - Lower","30% - Upper"]
[]
["\"Other\" Non-Residential Acres 10-Year Forecast (60% of DC forecast, 1.5 FSI)",{"$f":"385779*0.6*10.7639/43560/1.5","v":38.131189881542703},{"$f":"B72","v":38.131189881542703}]
["Av. land value/acre",2000000,6000000,{"$f":"ROUND(AVERAGE(B73:C73)*C72*0.05,-3)","v":7626000},{"$f":"ROUND(B73*B72*0.05,-3)","v":3813000},{"$f":"ROUND(C73*C72*0.05,-3)","v":11439000},{"$f":"ROUND(G$2*$B73*$B72,-3)","v":7626000},{"$f":"ROUND(H$2*$C73*$C72,-3)","v":22879000},{"$f":"ROUND(I$2*$B73*$B72,-3)","v":15252000},{"$f":"ROUND(J$2*$C73*$C72,-3)","v":45757000},{"$f":"ROUND(K$2*$B73*$B72,-3)","v":22879000},{"$f":"ROUND(L$2*$C73*$C72,-3)","v":68636000}]
["Charge Per Acre",null,null,{"$f":"ROUND((D73/$C72),-3)","v":200000},{"$f":"ROUND((E73/$C72),-3)","v":100000},300000,{"$f":"ROUND((G73/$C72),-3)","v":200000},600000,400000,1200000,600000,1800000]
[]
["Non-Res Acres (Chargeable) 10 Year Forecast (60% of DC forecast, 0.5 FSI)",{"$f":"(174840+1078550)*0.6*10.7639/43560/0.5","v":371.66293721763083},{"$f":"B76","v":371.66293721763083}]
["Av. land value/acre",1500000,3000000,{"$f":"ROUND(AVERAGE(B77:C77)*C76*0.02,-3)","v":16725000},{"$f":"ROUND(B77*B76*0.02,-3)","v":11150000},{"$f":"ROUND(C77*C76*0.02,-3)","v":22300000},{"$f":"ROUND(G$2*$B77*$B76,-3)","v":55749000},{"$f":"ROUND(H$2*$C77*$C76,-3)","v":111499000},{"$f":"ROUND(I$2*$B77*$B76,-3)","v":111499000},{"$f":"ROUND(J$2*$C77*$C76,-3)","v":222998000},{"$f":"ROUND(K$2*$B77*$B76,-3)","v":167248000},{"$f":"ROUND(L$2*$C77*$C76,-3)","v":334497000}]
["Charge Per Acre",null,null,{"$f":"ROUND((D77/$C76),-3)","v":45000},{"$f":"ROUND((E77/$C76),-3)","v":30000},{"$f":"ROUND((F77/$C76),-3)","v":60000},{"$f":"ROUND((G77/$C76),-3)","v":150000},{"$f":"ROUND((H77/$C76),-3)","v":300000},{"$f":"ROUND((I77/$C76),-3)","v":300000},{"$f":"ROUND((J77/$C76),-3)","v":600000},{"$f":"ROUND((K77/$C76),-3)","v":450000},{"$f":"ROUND((L77/$C76),-3)","v":900000}]
[]
["GRAND TOTAL NON-RESIDENTIAL",{"$f":"B72+B76","v":409.79412709917352},{"$f":"C72+C76","v":409.79412709917352},{"$f":"D73+D77","v":24351000},{"$f":"E73+E77","v":14963000},33739000,{"$f":"G73+G77","v":63375000},134378000,126751000,268755000,{"$f":"K73+K77","v":190127000},403133000]
[]
["TOTAL ALL USES",null,null,{"$f":"D80+D68","v":266803000},{"$f":"E80+E68","v":246673000},286932000,{"$f":"G80+G68","v":205149000},353506000,410300000,707013000,{"$f":"K80+K68","v":615451000},1060519000]
["% High and Mid rise",null,null,{"$f":"D52/D82","v":0.74497288261376371},null,null,{"$f":"G52/G82","v":0.36985800564467775},0.31191549789819689]
["What if status quo for all uses but 20% CBC for high and mid density res",null,null,{"$f":"D82","v":266803000},{"$nulls":4},{"$f":"I52+$D$65+$D$80","v":219795000},{"$f":"J52+$D$65+$D$80","v":288572000}]
["What if status quo for all uses but 10% for mid density and 30% for high density",null,null,{"$f":"D82","v":266803000},{"$nulls":6},{"$f":"K26+G48+E65+E80","v":219097000},{"$f":"L26+H48+F65+F80","v":334298000}]
[null,null,null,{"$f":"D80+D65+D48+D26","v":235803000},null,null,{"$f":"D86*0.4","v":94321200}]
["Development Type",null,"% of Future Development","# of units (2020-2029) 10 Year",null,null,null,"Finance adjusted forecast "]
["Low Rise",null,null,1425,null,null,null,230]
["Mid Rise – Rows and other multiples",null,null,3156,null,null,null,1220]
[null,null,"DT 14%",441.84000000000003,null,null,null,170.8]
[null,null,"MN 15%",473.4,null,null,null,183]
[null,null,"CN 7%",220.92000000000002,null,null,null,85.4]
[null,null,"NHD 64%",2019.8400000000001,null,null,null,780.80000000000007]
["High Rise - Apartments",null,null,18519,null,null,null,11304]
[null,null,"DT 70%","DT  12,963 (13,000)",null,null,null,7912.7999999999993]
[null,null,"     DT Core – 50%","        9,260  (9,300)",null,null,null,5652]
[null,null,"     DT Non-core – 20%","        3,704  (3,700)",null,null,null,2260.8000000000002]
[null,null,"MN 17%",{"$nulls":4},1921.68]
[null,null,"CN 4%",{"$nulls":4},452.16]
[null,null,"NHD 9%",{"$nulls":4},1017.36]
[null,null,"Source: 2013 Mississauga Growth Forecasts","Source: 2019 DC Background Study"]
[null,null,null,{"$f":"D82-($D$50+$D$51)","v":235803000},{"$f":"E82-($D$50+$D$51)","v":215673000},{"$f":"F82-($D$50+$D$51)","v":255932000}]