{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Read me","Tab 1 - Steps and Assumptions","Tab 2 - Rate Summary","No pymt delay model","Tab 3 - Unlevied Land","Tab 4 - Infrastructure","Tab 5 - Benefit Allocation","Tab 6 - Financial Model","Tab 7 - Bylaw Continuity","Tab 4 - Summary"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":1,"defined_names":54,"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":"Read me","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,2]]}
["HOW TO USE THIS DOCUMENT"]
["Welcome to the model used to determine the Emergency Responce levy rate for the 2024 Off-site Levies Bylaw.\nNote: This model is in DRAFT form for discussion purposes, using the latest information and assumptions available. \n"]
[]
["Emergency responce Levy Tabs 1 - 7"]
["Tab Number","Title","Description "]
["Tab 1","Steps and Assumptions","This tab entails the assumptions and steps to create the financial model. It also provides some details to clarify questions around the assumptions. "]
["Tab 2","Rate Summary","This tab provides a high level summary of the steps that are taken to determine Emergency Responce Levy Rate calculation, and provides a look at the proposed levy rate. "]
["Tab 3","Unlevied Land","This tab describes the remaining unlevied land that is included in the model."]
["Tab 4","Infrastructure","This tab provides details on Emergency Responce projects that need to be built over the model period to support the growth of communities"]
["Tab 5","Benefit Allocation","This tab provides the benefit rate calculation that considers the land that will benefit from infrastructure and then ties back to the future residents/jobs in that land. "]
["Tab 6","Financial Model","This tab provides the detailed forecast data used to calculated benefit."]
["Tab 7","Bylaw Continuity","This sheet shows the continuity of expenditures, developer contributions, investment income, and fund balances for both the 2016 and 2024 Off-site Levies bylaws."]

{"sheet":"Tab 1 - Steps and Assumptions","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[5,0,5,1]]}
["Emergency Responce - Steps and Assumptions"]
["Summary","Frequently Asked Questions"]
["The City will use this financial model to calculate Emergency Responce off-site levy rate per hectare that incorporates investment income, capital cost escalations, and the timing of expenditures and developer contributions through the model period. The levy rate calculated ensures that the off-site levy balance at the end of the model period is zero, i.e. revenues have matched expenditures. It also incorporates, if necessary, any interest costs incurred from the use of alternative funding sources required to deliver infrastructure in a timely manner."]
[]
[]
["Assumptions"]
["Escalation Rate","The escalation factor of 3.58% is a 5-year smoothed average, determined using Non-Residential Building Construction Price Index (CPI) for Calgary."]
["Discount Rate","The discount rate of 4.29% is based on the asset mix of investments held in The City's capital deposits, and the Long term Capital Market assumptions that The City uses in projecting returns from investment portfolios."]
["Gross Developable Land","Gross developable lands are calculated starting with the gross land area and deducting non-developable lands."]
["Unlevied Land","Unlevied land includes all gross developable lands outside the off-site levy Established Area boundary that do not have executed development agreements, as of the end of 2023. "]
["Land Absorption","• All remaining unlevied hectares will sign development agreements within the forecast period (ending 2055).\n• The land absorption from 2023 to 2027 is based on the fall 2022 forecast by Corporate Economics. \n• Remaining unlevied hectares in current and future Area Structure Plans are assumed to follow a decreasing trend over the forecast period, on the expectation of higher densities supporting the same number of people."]
["Benefit Allocation","Benefit calculation considers the land that will benefit from future infrastructure and relates to the forecast residents and jobs in that land. "]
["Payment schedule","This financial model incorporates the current levy payment schedule, where 100% of Emergency Responce levies are paid in year 3 after the development agreement is signed."]
["Investment income on future value of cash flows","Investment income is earned on the off-site levy beginning account balance, plus collections and minus spending through the year. Investment income on collections and spending is multiplied by a cashflow timing factor of 0.5 to reflect the fact that the timing of collection and spending varies throughout the year. If the balance of the off-site levy goes negative then interest is charged on the balance of the shortfall."]
["Expenditures","Expenditures include all currently planned infrastructure for the next 32 years. This list may change as better information becomes available."]

{"sheet":"Tab 2 - Rate Summary","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,19,4]]}
["Emergency Responce - Rate Summary"]
["Proposed 2024 Levy Rate",null,null,null,null,"Figure 1. Off-site Levy rate calculation"]
[null,"The levy rate calculation is being adjusted from the simple formula of Costs x Benefit / Land to the model described in Figure 1 to the right, and in the text below. \n\nThis financial model uses the following inputs: \n• Total unlevied land, and annual land absorption.\n• The off-site levy payment schedule.\n• Total capital costs of new infrastructure being levied for, with the benefit allocations to determine total unlevied costs.\n• Annual expenditures.\n• An escalation factor to calculate the future value of project costs.\n• A discount factor to calculate the discounted value of project costs, future revenue from developer contributions, and annual investment income or interest expense.\n\nThe levy rate is then calculated using Excel's Goal Seek function to find the levy rate that balances all expenditures and revenues over the course of the model to result in an off-site levy balance of $0.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 1","Step 2","Step 3","Step 4","Step 5","Step 6","Step 7","Step 8"]
[null,"Total capital costs","Unlevied capital cost","Future value","Discounted value","Unlevied land absorption","Developer contributions","Investment income","Levy rate"]
[null,"Identify the total capital costs for projects that benefit unlevied lands. Details can be found in Tab 4.","Unlevied capital cost: \n• Apply benefit rates to the capital costs of each project to determine the developer share of costs.","Calculate the future value of capital costs over the model period. Details for this step can be found in Tab 6.","Calculate the discounted value of the capital costs over the model period. Details for this step can be found in Tab 6.","Details on unlevied lands can be found in Tab 3. Remaining unlevied lands are assumed to be fully absorbed within the model period, in the slowly decreasing trend shown on Tab 6.","The levy rate is multiplied by the hectares that are forecast to sign development agreements each year to calculate the yearly contributions from the developers.","The annual investment income is calculated by multiplying the balance of spending and contributions each year by the investment rate of return.","Use Excel's Goal Seek function to calculate the Transportation off-site levy rate which ensures that developer contributions plus investment income are equal to the future value of capital cost/cash outflows by end of the model period."]
[null,"A","B","C","D","E","F","G","H"]
[null,{"$f":"SUM('Tab 4 - Infrastructure'!D12:D19)","v":160250000},{"$f":"SUM('Tab 6 - Financial Model'!G14:G21)","v":147430000},{"$f":"'Tab 6 - Financial Model'!I25","v":282789950.00573504},{"$f":"'Tab 6 - Financial Model'!I26","v":130858966.36676276},{"$f":"'Tab 6 - Financial Model'!E33","v":9069},{"$f":"'Tab 6 - Financial Model'!I34","v":306257313.90739787},{"$f":"'Tab 6 - Financial Model'!I40","v":-23467363.901662819},{"$f":"'Tab 6 - Financial Model'!C3","v":17068.802043170625}]
[null,"Dollars","Dollars","Dollars","Dollars","Hectares","Dollars","Dollars","Dollars"]

{"sheet":"No pymt delay model","index":3,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Escalation Rate",3.5299999999999998E-2]
["Discount",4.2900000000000001E-2]
[]
[null,"Current Cost","Benefit %","Leviable cost","Year Projected project built",null,null,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,31,32,33]
[null,null,null,null,null,null,null,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055]
["Belmont Fire Station ",18000000,0.78804997384493936,{"$f":"B8*C8","v":14184899.529208908},4,null,null,{"$f":"IF($E8=H$6,$D8,0)*(1+$B$3)^H$6","v":0},{"$f":"IF($E8=I$6,$D8,0)*(1+$B$3)^I$6","v":0},0,{"$f":"IF($E8=K$6,$D8,0)*(1+$B$3)^K$6","v":16296379.140321648},{"$f":"IF($E8=L$6,$D8,0)*(1+$B$3)^L$6","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]
["Livingstone Fire station",18000000,0.75614010627916628,{"$f":"B9*C9","v":13610521.913024994},5,null,null,0,0,0,0,16188471.654368239,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]
["Belvedere Fire Station",18000000,0.96178906867958203,17312203.236232478,6,null,null,0,{"$f":"IF($E10=I$6,$D10,0)*(1+$B$3)^I$6","v":0},0,0,0,21318155.508636769,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]
["Glacier Ridge Fire station ",18000000,0.98009181744307283,17641652.71397531,10,null,null,0,0,0,0,0,0,0,0,0,{"$f":"IF($E11=Q$6,$D11,0)*(1+$B$3)^Q$6","v":24957518.896058999},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Nose Creek Fire Station ",18000000,0.97295557579170988,17513200.364250779,10,null,null,0,0,0,0,0,0,0,0,0,24775798.283060335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Haskayne Fire Station ",18000000,0.82351103953530003,14823198.7116354,15,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24942222.02023188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Providence Fire Station ",18000000,0.96531318322648074,17375637.298076652,15,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29237077.075102873,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rangeview Fire Station ",18000000,0.86721009169276275,15609781.65046973,18,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($E15=W$6,$D15,0)*(1+$B$3)^W$6","v":0},0,29146652.31630474,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["South Shepard Fire Station",18000000,0.99369765593636417,17886557.806854554,20,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35797364.23667369,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Westview Fire Station ",18000000,0.98395420191427907,17711175.634457022,20,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35446362.128066324,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Future value of capital projects",null,null,null,{"$f":"SUM(G18:AN18)","v":258106001.25882548},null,null,{"$f":"SUM(H8:H17)","v":0},0,0,16296379.140321648,16188471.654368239,21318155.508636769,0,0,0,49733317.179119334,0,0,0,0,54179299.095334753,0,0,29146652.31630474,0,71243726.364740014,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Dicounted Amount",null,null,null,{"$f":"SUM(H19:AN19)","v":149432782.00432175},null,null,{"$f":"(SUM(H8:H17))/((1+$B$4)^H6)","v":0},0,0,{"$f":"(SUM(K8:K17))/((1+$B$4)^K6)","v":13775914.867892148},13121772.74192884,16568897.877174189,0,0,0,{"$f":"(SUM(Q8:Q17))/((1+$B$4)^Q6)","v":32675387.96317393},0,0,0,0,28853159.099362317,0,0,13684239.487478269,0,30753409.967312083,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"SUM(H20:AN20)","v":10203},null,null,361,290,309,327,321,321,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,321.5,{"$f":"321.5-85","v":236.5}]
[null,null,null,null,{"$f":"E19/E20","v":14645.965108725057},"Contribution",{"$f":"SUM(H21:AN21)","v":306561959.03859919},{"$f":"(($E$25*H20)*(1+$B$4)^0)","v":5287193.4042497473},{"$f":"(($E$25*I20)*(1+$B$4)^H6)","v":4429540.3334479164},{"$f":"(($E$25*J20)*(1+$B$4)^I6)","v":4922228.9401711207},5432425.1381144309,5561522.4852268863,5800111.7998431195,6058358.6156764142,6318262.2002889328,6589315.6486813268,6871997.2900097556,7166805.9737511743,7474261.9500250993,7794907.7876811754,8129309.3317726972,8478056.7021057457,8841765.3346260823,9221077.0674815401,9616661.2736764979,10029216.042317219,10459469.410532627,10908180.648244476,11376141.598054163,11864178.072610687,12373151.311925687,12903959.503207294,13457539.365894886,14034867.804691778,14636963.633513056,15264889.373390762,15919753.127509225,16602710.536679372,12737137.333198259,0]
[null,null,null,null,null,"Income",{"$f":"SUM(H22:AN22)","v":-48455957.779773623},{"$f":"(F25+H21)*$B$4","v":226820.59704231416},{"$f":"(H25+I21)*$B$4","v":426578.48096034501},{"$f":"(I25+J21)*$B$4","v":656042.31932688493},917237.57325111737,496061.71464002505,71682.124438954532,-579887.99913061352,-333711.74590092158,-65346.338471642208,226658.98734934285,-1589720.6728036646,-1337273.8520108648,-1060241.3561706084,-756978.34001727891,-425744.07828368363,-2388988.6975764553,-2095892.1065075274,-1773251.1092359782,-2669461.5979762664,-2335270.2628175984,-5023848.2683301317,-4751334.88448497,-4446193.9117143769,-4106127.4392453115,-3728700.4437013427,-3311333.2539392398,-2851293.6217119559,-2345688.3782056887,-1791454.6555122486,-1185350.6510635784,-523945.91197066102,2.956576645374298E-9,3.0834137834608555E-9]
[]
[]
[null,null,null,null,14645.965108725062,null,null,{"$f":"H21+H22","v":5514014.0012920611},{"$f":"H25+I21+I22-I18","v":10370132.815700322},15948404.075198328,6001687.6462422293,{"$f":"K25+L21+L22-L18","v":-4129199.8082590979},-19575561.392613791,-14097090.776067991,-8112540.3216799796,-1588571.011470295,-44223231.913230531,-38646146.612283021,-32509158.514268786,-25774492.082758218,-18402161.0910028,-64529147.56251549,-58076370.925465859,-50951185.964491844,-72254428.11635606,-64894673.672015108,-128014200.88904008,-122129868.50912574,-115505061.79555655,-108087077.63466023,-99820053.761979848,-90644794.702473894,-80498588.590518251,-69315014.407538429,-57023739.15223106,-43550304.434352547,-28815901.957906902,-12737137.33319819,7.1874447166919706E-8,7.4957860950380559E-8]
[]
[]
[null,null,null,null,null,"Rate/Ha",null,{"$f":"H21/H20","v":14645.965108725062},{"$f":"I21/I20","v":15274.277011889368},15929.54349569942,16612.920911664925,17325.615218775347,18068.884111660809,18844.039240051054,19652.448523449246,20495.538565105217,21374.79716954823,22291.775968121849,23248.093157154275,24245.436353596189,25285.565573165466,26370.316336254262,27501.60290707957,28681.421671793283,29911.854661513211,31195.073226492128,32533.341867908639,33929.022234041913,35384.577287882312,36902.575653532462,38485.696149069008,40136.732513864059,41858.59833870882,43654.332207439438,45527.103059138586,47480.21578037562,49517.117037353732,51641.401358256211,53856.817476525408]
[]
[null,null,null,null,null,"% increase",null,null,{"$f":"(I28-H28)/H28","v":4.2900000000000021E-2},{"$f":"(J28-I28)/I28","v":4.2899999999999862E-2},{"$f":"(K28-J28)/J28","v":4.2900000000000049E-2},{"$f":"(L28-K28)/K28","v":4.2899999999999772E-2}]

{"sheet":"Tab 3 - Unlevied Land","index":4,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,3,13],[4,0,19,13]]}
["Emergency Responce - Unlevied Land"]
["This tab provides background on different benefiting areas: the Established Area, unlevied land, and land that has already been levied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Map 1. Off-Site levy Established Area boundary and Greenfield Area as of the end of 2022"]
[]
[]
["Map 1 to the right illustrates The City's Established Area, and Greenfield Area.\n\nThe Established Area boundary was identified in the 2016 Off-site Levy Bylaw and contains lands that are fully developed, or have executed development agreement to allow future development. The purpose of the boundary is to determine benefiting areas in support of levy rate calculations (established or greenfield) for different parts of the city.\n\nLand shown in green includes both greenfield lands that have already been levied, unlevied, and non-developable land. Non-developable land is excluded from the determination of the number of hectares that have been levied or unlevied. This includes, for example:\n\t• The Transportation Utility Corridor (TUC), or road right-of-way for provincial expressways.\n\t• Environmental Reserve (slopes with a grade greater than 15%, natural water bodies, areas impacted by a 1:100 year flood).\n\t• Landfills.\n\t• Cemeteries."]

{"sheet":"Tab 4 - Infrastructure","index":5,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,2,4,5],[5,2,5,5],[6,2,6,5]]}
[null,"Emergency Responce - Infrastructure"]
[]
[null,"This tab shows the basis of the calculation and assumptions used in assessing infrastructure allocation."]
[]
[null,"Per facility capacity","Number of emergency response stations and their location are determined to meet response time requirement of the City."]
[null,"Capacity allocation","Future greenfield population will be 100% benefitting with existing and future Emergency Responce infrastructure in the green area"]
[null,"Construction year","Determined based on when the new facility will be required as related to the pace of population growth"]
[]
[null,"Future need of facility and cost analysis"]
[]
[null,"Facility","Number of facilities needed","Per facility cost","Year Built - Estimate","Year in numbers"]
[null,"Belvedere Emergency Responce Station",1,27300000,2031,{"$f":"E12-2024+1","v":8}]
[null,"Glacier Ridge Emergency Responce station ",1,22100000,2045,{"$f":"E13-2024+1","v":22}]
[null,"Nose Creek Emergency Responce Station ",1,17750000,2043,20]
[null,"Providence Emergency Responce Station ",1,17750000,2040,17]
[null,"Rangeview Emergency Responce Station ",1,22100000,2037,14]
[null,"South Shepard Emergency Responce Station",1,17750000,2033,10]
[null,"West View Emergency Responce Station ",1,17750000,2048,25]
[null,"Shepard Industrial Station",1,17750000,2053,30]
[]
[null,"Emergency Responce Infrastructure Cost Estimates, 2023"]
[null,"2 Bay Station",null,"Cost ","Notes"]
[null,"Building Construction",null,{"$f":"1100*13000","v":14300000},"13000 square feet"]
[null,"Land (Serviced)",null,{"$f":"1300000*1.5","v":1950000},"1.5 Acres"]
[null,"Apparatus",null,1100000]
[null,"Equipment",null,400000]
[null,"Total Costs",null,{"$f":"SUM(D23:D26)","v":17750000}]
[]
[null,"3 Bay Station ",null,"Cost ","Notes"]
[null,"Building Construction",null,{"$f":"1100*15000","v":16500000},"15000 square feet"]
[null,"Land (Serviced)",null,{"$f":"1300000*2","v":2600000},"2 Acres"]
[null,"Two Apparatus",null,2200000]
[null,"Equipment",null,800000]
[null,"Total Costs",null,{"$f":"SUM(D30:D33)","v":22100000}]
[]
[null,"4 Bay Station ",null,"Cost ","Notes"]
[null,"Building Construction",null,{"$f":"1100*17500","v":19250000},"17500 square feet"]
[null,"Land (Serviced)",null,{"$f":"1300000*2.5","v":3250000},"2.5 Acres"]
[null,"Three Apparatus",null,3600000]
[null,"Equipment",null,{"$f":"400000*3","v":1200000}]
[null,"Total Costs",null,{"$f":"SUM(D37:D40)","v":27300000}]

{"sheet":"Tab 5 - Benefit Allocation","index":6,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,2,4],[12,6,12,7],[12,2,13,2],[12,3,13,3],[12,4,12,5],[12,0,13,0],[12,1,13,1],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,0,10,0],[6,1,10,4]]}
["Emergency Responce - Benefit Allocation"]
[]
["Benefit measurement:","Emergency response facilities benefit is measured using the share of population in benefiting areas."]
["Benefiting Areas include:","Greenfield only: projects that support Area Structure Plans (ASPs) outside the established area boundary.  The service level for the greenfield is comparable with the service level in the established area. 100% of benefit is assigned to the greenfield ASP lands, and is split based on the forecast population in lands that have already signed development agreements and paid off-site levies (levied lands), and lands that have not yet signed development agreements and paid off-site levies (unlevied lands)."]
["Data Source:","Source: Calgary Next 20: Population, Employment and Housing Projections, 2021, by Applications Management Consulting Ltd.\nA buildout forecast of population based on current growth trends."]
["Source Data Details and Assumptions","• The forecast period ends in 2058.\n• Population and job forecasts are assessed by Transportation Zones (TZs). Transportation Zones provide a useful and reasonable geographic division for forecasting.\n• Population densities are assumed to be even throughout TZs. (e.g. where part of a TZ has paid levies, and part has not)."]
["Benefit Allocation Calculation"," Benefit = (Sum of forecast population and jobs in all unlevied lands within future emergency response station coverage area/ (Sum of forecast population and jobs in the coverage area of emergency response station)"]
[]
[]
[]
[]
[]
["#","Project Name / Greenfield Emergency Responce Stations","Primary Benefitting Area (by Planning Policy)","Future Population/Jobs\n (Dispersed/full build out in 60 years)","Previously Levied Land",null,"Unlevied Land (ASP)"]
[null,null,null,null,"Population ","%","Population ","%","Weight of Unlevied Land Population","% x Weight"]
[1,"Belvedere Emergency Responce Station ","Belvedere ASP ",67208.30647548,3221.7081973661325,{"$f":"ROUND(E15/D15,2)","v":0.05},63986.598278113866,{"$f":"ROUND(G15/D15,2)","v":0.95},{"$f":"G15/$G$23","v":0.2404088693040714},{"$f":"H15*I15","v":0.22838842583886781}]
[2,"Glacier Ridge Emergency Responce Station","Glacier Ridge ASP ",55420.313698000005,{"$f":"'[1]Glacier Ridge'!D7","v":0},{"$f":"ROUND(E16/D16,2)","v":0},52735.606973145266,{"$f":"ROUND(G16/D16,2)","v":0.95},{"$f":"G16/$G$23","v":0.19813692219381834},{"$f":"H16*I16","v":0.18823007608412742}]
[3,"Nose Creek Emergency Responce Station","Nose Creek ASP / Keystone Hills ASP",24442.447591679505,239.77783134938079,0.01,24202.669760330125,0.99,9.0933674047351143E-2,9.002433730687763E-2]
[4,"Providence Emergency Responce Station","Providence ASP",41086.661003000001,3052.0691881545617,7.0000000000000007E-2,38034.591814845437,0.93,0.14290263053062577,0.13289944639348197]
[5,"Rangeview Emergency Responce Station","Rangeview ASP /  Ricardo Ranch ASP",61487.015406999999,12290.91784788616,0.2,49196.097559113834,0.8,0.18483836469870193,0.14787069175896156]
[6,"South Shepard Emergency Responce Station","South Shepard ASP",29088.028670999996,872.2900264417367,{"$f":"ROUND(E20/D20,2)","v":0.03},28215.738644558263,0.97,0.10601147750712084,0.10283113318190722]
[7,"West View Emergency Responce Station","West View ASP",5397.45028,27.686858633458158,0.01,5369.7634213665424,0.99,2.0175142722076045E-2,1.9973391294855283E-2]
[8,"Shepard Industrial Station","Shepard Industrial ASP",5575.664137008901,1159.336049169307,0.21,4416.3280878395926,0.79,1.6592918996234295E-2,1.3108406007025094E-2]
["Total",null,null,{"$f":"SUM(D15:D22)","v":289705.88726316841},{"$f":"SUM(E15:E22)","v":20863.785999000735},null,{"$f":"SUM(G15:G22)","v":266157.39453931298},null,"Weighted Average Benefit %:",{"$f":"ROUND(SUM(J15:J22),2)","v":0.92}]

{"sheet":"Tab 6 - Financial Model","index":7,"n_rows":50,"n_cols":45,"rows_kept":50,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,32,2],[33,1,41,2],[35,6,38,6],[44,1,46,4],[2,3,2,5],[3,1,8,8],[23,1,23,4],[24,1,25,2],[30,1,30,2]]}
["Emergency Responce OSL Financial Rate Model"]
[null,null,null,null,null,null,null,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,31,32,33,34,35]
["Emergency Responce Levy Rate",null,17068.802043170625,null,null,null,null,"End Value (CELL AS42):",{"$f":"AS42","v":-2.0023435354232788E-8},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058]
[null,"How to calculate the levy rate: Once all variables have been set, the levy rate can be recalculated by entering running Excel's Goal Seek function (Data --> What-If Analysis --> Goal Seek) to calculate the levy rate in cell C3 by setting cell AS42 to 0 by changing the levy rate in cell C3. The model applies the value in cell C3 to the land absorption in row 29 to ensure that contributions from Development Agreements (in row 34) plus earned investment income offset total spending and ensure that the ending balance is zero (cell AS42), i.e. all revenues and spending have balanced. \nVariables impacting this calculation include: annual expenditures, land absorption rate (row 29), payment schedule (cells I36 to I39), and the escalation and discount rates (cells E25 and E26)."]
[]
[]
[]
[]
[]
["Section 1: Expenditures"]
[]
["#","Project Name",null,"Capital Cost","Benefit Type","Benefit %","Unlevied cost","Previously Levied/ City Share of Cost","Year Projected project start"]
[]
[1,{"$f":"'Tab 4 - Infrastructure'!B12","v":"Belvedere Emergency Responce Station"},null,{"$f":"'Tab 4 - Infrastructure'!D12","v":27300000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},{"$f":"D14*F14","v":25116000},{"$f":"D14-G14","v":2184000},{"$f":"'Tab 4 - Infrastructure'!F12","v":8},null,{"$f":"IF($I14=K$2,$G14,0)*(1+$E$25)^K$2","v":0},0,0,0,0,0,0,33278039.112314623,0,0,{"$f":"IF($I14=U$2,$G14,0)*(1+$E$25)^U$2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($I14=AE$2,$G14,0)*(1+$E$25)^AE$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,{"$f":"'Tab 4 - Infrastructure'!B13","v":"Glacier Ridge Emergency Responce station "},null,{"$f":"'Tab 4 - Infrastructure'!D13","v":22100000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},20332000,1768000,{"$f":"'Tab 4 - Infrastructure'!F13","v":22},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44080858.903129473,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,{"$f":"'Tab 4 - Infrastructure'!B14","v":"Nose Creek Emergency Responce Station "},null,{"$f":"'Tab 4 - Infrastructure'!D14","v":17750000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},16330000,1420000,{"$f":"'Tab 4 - Infrastructure'!F14","v":20},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32999268.91517454,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,{"$f":"'Tab 4 - Infrastructure'!B15","v":"Providence Emergency Responce Station "},null,{"$f":"'Tab 4 - Infrastructure'!D15","v":17750000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},16330000,1420000,{"$f":"'Tab 4 - Infrastructure'!F15","v":17},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29694539.750210252,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,{"$f":"'Tab 4 - Infrastructure'!B16","v":"Rangeview Emergency Responce Station "},null,{"$f":"'Tab 4 - Infrastructure'!D16","v":22100000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},20332000,1768000,{"$f":"'Tab 4 - Infrastructure'!F16","v":14},null,0,0,0,0,0,0,0,0,0,0,0,0,0,33269233.456766434,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,{"$f":"'Tab 4 - Infrastructure'!B17","v":"South Shepard Emergency Responce Station"},null,{"$f":"'Tab 4 - Infrastructure'!D17","v":17750000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},16330000,1420000,{"$f":"'Tab 4 - Infrastructure'!F17","v":10},null,0,0,0,0,0,0,0,0,0,23213747.249955151,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]
[7,{"$f":"'Tab 4 - Infrastructure'!B18","v":"West View Emergency Responce Station "},null,{"$f":"'Tab 4 - Infrastructure'!D18","v":17750000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},16330000,1420000,{"$f":"'Tab 4 - Infrastructure'!F18","v":25},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39344483.804334998,0,0,0,0,0,0,0,0,0,0]
[8,{"$f":"'Tab 4 - Infrastructure'!B19","v":"Shepard Industrial Station"},null,{"$f":"'Tab 4 - Infrastructure'!D19","v":17750000},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$J$23","v":0.92},16330000,1420000,{"$f":"'Tab 4 - Infrastructure'!F19","v":30},null,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,46909778.813849568,0,0,0,0,0]
[]
[null,"Total",null,{"$f":"SUM(D14:D21)","v":160250000},null,null,{"$f":"SUM(G14:G21)","v":147430000},{"$f":"SUM(H14:H21)","v":12820000}]
[null,"Rates used to calculate Future Value and Present Value of Unlevied Cost:"]
[null,"Table: Escalation and Discount Rates. \nSource: City Treasury, March 2023",null,"Escalation Rate",3.5799999999999998E-2,null,null,"Future value of Unlevied Cost",{"$f":"SUM(L25:AS25)","v":282789950.00573504},{"$f":"SUM(J14:J22)","v":0},0,0,0,0,0,0,0,33278039.112314623,0,23213747.249955151,0,0,0,33269233.456766434,0,0,29694539.750210252,0,0,32999268.91517454,0,44080858.903129473,0,0,39344483.804334998,0,0,0,0,46909778.813849568,0,0,0,0,0]
[null,null,null,"Discount Rate",4.2900000000000001E-2,null,null,"Discounted value of Unlevied Cost",{"$f":"SUM(L26:AS26)","v":130858966.36676276},{"$f":"(SUM(J14:J22))/((1+$E$26)^J2)","v":0},0,0,0,0,0,0,0,23780248.475907557,0,15251711.337481674,0,0,0,18477595.269948963,0,0,14539559.583405228,0,0,14244623.314260071,0,17494895.953043502,0,0,13766297.962400032,0,0,0,0,13304034.470315743,0,0,0,0,0]
[]
["Section 2: Land Absorption and Yearly Cash Flows"]
[null,null,null,null,null,null,null,null,"Hectares that sign development agreements (DA's)",290,309,327,321,321,318.48089795918366,315.96179591836733,313.44269387755099,310.92359183673466,308.40448979591832,305.88538775510199,303.36628571428565,300.84718367346932,298.32808163265298,295.80897959183665,293.28987755102031,290.77077551020398,288.25167346938764,285.7325714285713,283.21346938775497,280.69436734693863,278.1752653061223,275.65616326530596,273.13706122448963,270.61795918367329,268.09885714285696,265.57975510204062,263.06065306122429,{"$f":"260.541551020408-34.8","v":225.741551020408},{"$f":"258.022448979592-34.8","v":223.222448979592},{"$f":"255.503346938775-34.8","v":220.70334693877498},{"$f":"252.984244897959-34.8","v":218.18424489795899},{"$f":"250.465142857143-34.8","v":215.665142857143}]
[null,null,null,"Year","Unlevied Hectares",null,null,null,"Cumulative Hectares",null,{"$f":"SUM($K29:K29)","v":309},{"$f":"SUM($K29:L29)","v":636},{"$f":"SUM($K29:M29)","v":957},{"$f":"SUM($K29:N29)","v":1278},{"$f":"SUM($K29:O29)","v":1596.4808979591837},{"$f":"SUM($K29:P29)","v":1912.4426938775509},{"$f":"SUM($K29:Q29)","v":2225.8853877551019},{"$f":"SUM($K29:R29)","v":2536.8089795918368},{"$f":"SUM($K29:S29)","v":2845.2134693877551},{"$f":"SUM($K29:T29)","v":3151.098857142857},{"$f":"SUM($K29:U29)","v":3454.4651428571428},{"$f":"SUM($K29:V29)","v":3755.3123265306122},{"$f":"SUM($K29:W29)","v":4053.640408163265},{"$f":"SUM($K29:X29)","v":4349.4493877551013},{"$f":"SUM($K29:Y29)","v":4642.7392653061215},{"$f":"SUM($K29:Z29)","v":4933.5100408163253},{"$f":"SUM($K29:AA29)","v":5221.7617142857125},{"$f":"SUM($K29:AB29)","v":5507.4942857142842},{"$f":"SUM($K29:AC29)","v":5790.7077551020393},{"$f":"SUM($K29:AD29)","v":6071.4021224489779},{"$f":"SUM($K29:AE29)","v":6349.5773877551001},{"$f":"SUM($K29:AF29)","v":6625.2335510204057},{"$f":"SUM($K29:AG29)","v":6898.3706122448957},{"$f":"SUM($K29:AH29)","v":7168.9885714285692},{"$f":"SUM($K29:AI29)","v":7437.0874285714262},{"$f":"SUM($K29:AJ29)","v":7702.6671836734668},{"$f":"SUM($K29:AK29)","v":7965.7278367346908},{"$f":"SUM($K29:AL29)","v":8191.469387755099},{"$f":"SUM($K29:AM29)","v":8414.6918367346916},{"$f":"SUM($K29:AN29)","v":8635.3951836734668},{"$f":"SUM($K29:AO29)","v":8853.5794285714255},{"$f":"SUM($K29:AP29)","v":9069.2445714285677},{"$f":"SUM($K29:AQ29)","v":9069.2445714285677},{"$f":"SUM($K29:AR29)","v":9069.2445714285677},{"$f":"SUM($K29:AS29)","v":9069.2445714285677}]
[null,"Planned Unlevied Hectares at Jan 1, 2023",null,"Subtotal",{"$f":"9069+290","v":9359}]
[null,"Forecast hectares in executed DA's",null,2023,290]
[null,"Denominator: Unlevied Hectares at Jan 1, 2024",null,"Subtotal",{"$f":"E31-E32","v":9069},null,"Yearly Cash-flow Analysis ($):"]
[null,"Hectares in executed DAs from 2023 to 2027 are per Corporate Economics Fall 2022 forecast. The remaining 7,791 hectares of unlevied land are assumed to be absorbed in a slowly decreasing trend, with approximately 2.54 ha fewer per year. This starts from 318.5 hectares in 2028 and finishes with 216 hectares in 2055. ",null,2024,309,null,null,"Contributions from signed DA's",{"$f":"SUM(K34:AS34)","v":306257313.90739787},null,{"$f":"(($C$3*K29)*(1+$E$26)^J2)","v":5274259.8313397234},5820944.5438190047,5959274.7516341815,6214927.6384792877,6430682.9846980022,6653512.1246471498,6883624.9115320649,7121236.185282385,7366565.8141970485,7619838.730984835,7881284.9626429081,8151139.6535783513,8429643.0813379586,8717040.6642694958,9013582.960393237,9319525.6567154657,9635129.5481660031,9960660.5052891225,10296389.429761665,10642592.196753412,10999549.583082624,11367547.180054056,11746875.289797433,12137828.803851152,12540707.06265858,12955813.694562791,13383456.432799198,11977510.704974743,12351952.103717579,12736477.043995947,13131261.567979062,13536478.26440339,0,0,0]
[null,null,null,2025,327,null,null,"Beginning Account Balance, $",null,null,{"$f":"J42","v":0},0,0,0,5387392.7047219602,11564315.656038454,18147525.992739238,25274292.694152422,-1064672.0658224374,5685883.462274611,-10750595.599776071,-3937809.4495497718,3417837.1759761181,11347746.662589952,-14097954.994907413,-6376775.665041334,1960119.5843610505,-19383257.726804048,-11007875.16839027,-1960683.5310622004,-25910097.01097564,-16847323.499618921,-52079220.02132412,-43442542.760865152,-34070737.923666522,-64109414.495463587,-54860862.612555385,-44816208.386940256,-33929118.49758739,-22150961.782822724,-57346700.039429724,-47572445.16152481,-36996401.582611904,-25573872.733916294,{"$f":"AR42","v":-13258064.745589091}]
[null,null,null,"2026 & 2027",321,null,"Levy payment schedule after a DA is signed.","Year 0",0,null,{"$f":"K34*$I$36","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,0,0,0,0,0]
[null,null,null,"2028 - 2055","Declining",null,null,"Year 1",0,null,null,{"$f":"K34*$I$37","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,0,0,0,0]
[null,null,null,null,null,null,null,"Year 2",0,null,null,null,{"$f":"K34*$I$38","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,0,0,0]
[null,null,null,null,null,null,null,"Year 3",1,null,null,null,null,{"$f":"K34*$I$39","v":5274259.8313397234},5820944.5438190047,5959274.7516341815,6214927.6384792877,6430682.9846980022,6653512.1246471498,6883624.9115320649,7121236.185282385,7366565.8141970485,7619838.730984835,7881284.9626429081,8151139.6535783513,8429643.0813379586,8717040.6642694958,9013582.960393237,9319525.6567154657,9635129.5481660031,9960660.5052891225,10296389.429761665,10642592.196753412,10999549.583082624,11367547.180054056,11746875.289797433,12137828.803851152,12540707.06265858,12955813.694562791,13383456.432799198,11977510.704974743,12351952.103717579,12736477.043995947,13131261.567979062,13536478.26440339]
[null,null,null,null,null,null,null,"Investment Income (Interest Expense), $",{"$f":"SUM(K40:AS40)","v":-23467363.901662819},null,null,null,{"$f":"(((M35+((M36+M37+M38+M39)*$E$48)))-(M25*0.5))*$E$26","v":0},{"$f":"(((N35+((N36+N37+N38+N39)*$E$48)))-(N25*0.5))*$E$26","v":113132.87338223707},355978.40749748977,623935.5850666028,911839.06293389399,508391.36764176248,97043.403449898804,-106356.72362759436,-308450.03505608626,-10919.188671158521,310070.7556290002,-57753.163373840674,-429960.32371227234,-92747.831935574024,-365878.22522434016,-638200.40197945875,-272334.01938739588,-585274.1129049015,-897886.99393240327,-1447427.0483373911,-2005914.9362944441,-1627744.7458839929,-2061739.94751612,-2498323.4068892328,-2093174.5782360188,-1653617.1733057105,-1177656.9797981272,-1669415.8755566254,-2203255.8270698269,-1775908.5248046722,-1313948.1953003376,-815453.57965185819,-278413.51881431928]
[null,null,null,null,null,null,null,"Future value of cash inflows, $",{"$f":"SUM(I34:I40)","v":282789951.00573504}]
[null,null,null,null,null,null,null,"Ending account balance, $",null,null,null,null,{"$f":"M35+M36+M37+M38+M39+M40-M25","v":0},5387392.7047219602,11564315.656038454,18147525.992739238,25274292.694152422,-1064672.0658224374,5685883.462274611,-10750595.599776071,-3937809.4495497718,3417837.1759761181,11347746.662589952,-14097954.994907413,-6376775.665041334,1960119.5843610505,-19383257.726804048,-11007875.16839027,-1960683.5310622004,-25910097.01097564,-16847323.499618921,-52079220.02132412,-43442542.760865152,-34070737.923666522,-64109414.495463587,-54860862.612555385,-44816208.386940256,-33929118.49758739,-22150961.782822724,-57346700.039429724,-47572445.16152481,-36996401.582611904,-25573872.733916294,-13258064.745589091,{"$f":"AS35+AS36+AS37+AS38+AS39+AS40-AS25","v":-2.0023435354232788E-8}]
[]
[]
[null,"Note: Cash flow timing is for inflows, 1=beginning of year; 0.5 is straight line; 0.0 is end of year. This is used to calculate investment income on expenditures within a given year."]
[]
[]
[null,"Cashflow Timing Factor",null,null,0.5]
[]
["End of WP"]

{"sheet":"Tab 7 - Bylaw Continuity","index":8,"n_rows":64,"n_cols":43,"rows_kept":64,"cut":false,"hidden":false,"merged":[[59,0,60,0],[62,0,63,0],[2,0,4,1],[5,0,5,1],[6,0,6,1],[45,0,48,0],[51,0,52,0],[54,0,57,0]]}
["Emergency Responce OSL Continuity"]
[]
["This sheet is for information purposes only. It shows the continuity of expenditures, developer contributions, investment income, and fund balances for both the 2016 and 2024 Off-site Levies bylaws. Any final investment income earned in the final year will be applied to expenditures in that year."]
[]
[]
["Light green references the 2016 bylaw"]
["Light orange references the 2024 bylaw"]
[]
["2024 Levy Rate",null,null,"Year #",null,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,31,32,33,34,35]
[{"$f":"'Tab 6 - Financial Model'!C3","v":17068.802043170625},null,null,"Year",2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058]
[]
["Expenditures ($)"]
["Supports projects in progress.","Committed/Future OSL Expenditures (2016 Bylaw)",null,null,null,null,null,21905626,22962727,16268586,6012101,{"$f":"(17750000-17000000)*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L9","v":863306.26008681732},null,null,{"$f":"17750000*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O9","v":22705428.59327678},{"$f":"(22100000-3500000)*(1+'Tab 6 - Financial Model'!$E$25)^P9","v":24644510.570514891}]
[]
[1,{"$f":"'Tab 6 - Financial Model'!B14","v":"Belvedere Emergency Responce Station"},null,{"$f":"'Tab 6 - Financial Model'!I14","v":8},{"$f":"IF(AND($D15=E$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D15=F$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D15=G$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D15=H$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D15=I$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D15=J$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D15=K$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D15=L$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D15=M$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D15=N$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D15=O$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D15=P$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":36171781.643820241},{"$f":"IF(AND($D15=Q$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D15=R$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D15=S$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D15=T$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D15=U$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D15=V$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D15=W$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D15=X$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D15=Y$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D15=Z$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D15=AA$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D15=AB$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D15=AC$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D15=AD$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D15=AE$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D15=AF$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D15=AG$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D15=AH$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D15=AI$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D15=AJ$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D15=AK$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D15=AL$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D15=AM$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D15=AN$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D15=AO$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D15=AP$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D15=AQ$9,$B15='Tab 6 - Financial Model'!$B14),('Tab 6 - Financial Model'!$D14*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B15,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E15*$D16","v":0},{"$f":"F15*$D16","v":0},0,0,0,0,0,0,0,0,0,33278039.112314623,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,"Remainder: needed from other sources",null,null,{"$f":"E15-E16","v":0},{"$f":"F15-F16","v":0},0,0,0,0,0,0,0,0,0,2893742.5315056182,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]
[2,{"$f":"'Tab 6 - Financial Model'!B15","v":"Glacier Ridge Emergency Responce station "},null,{"$f":"'Tab 6 - Financial Model'!I15","v":22},{"$f":"IF(AND($D18=E$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D18=F$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D18=G$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D18=H$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D18=I$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D18=J$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D18=K$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D18=L$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D18=M$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D18=N$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D18=O$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D18=P$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D18=Q$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D18=R$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D18=S$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D18=T$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D18=U$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D18=V$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D18=W$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D18=X$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D18=Y$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D18=Z$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D18=AA$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D18=AB$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D18=AC$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D18=AD$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":47913977.06861899},{"$f":"IF(AND($D18=AE$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D18=AF$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D18=AG$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D18=AH$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D18=AI$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D18=AJ$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D18=AK$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D18=AL$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D18=AM$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D18=AN$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D18=AO$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D18=AP$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D18=AQ$9,$B18='Tab 6 - Financial Model'!$B15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B18,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E18*$D19","v":0},{"$f":"F18*$D19","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,44080858.903129473,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E18-E19","v":0},{"$f":"F18-F19","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,3833118.1654895172,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,{"$f":"'Tab 6 - Financial Model'!B16","v":"Nose Creek Emergency Responce Station "},null,{"$f":"'Tab 6 - Financial Model'!I16","v":20},{"$f":"IF(AND($D21=E$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D21=F$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D21=G$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D21=H$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D21=I$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D21=J$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D21=K$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D21=L$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D21=M$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D21=N$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D21=O$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D21=P$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D21=Q$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D21=R$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D21=S$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D21=T$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D21=U$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D21=V$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D21=W$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D21=X$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D21=Y$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D21=Z$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D21=AA$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D21=AB$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":35868770.559972323},{"$f":"IF(AND($D21=AC$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D21=AD$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D21=AE$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D21=AF$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D21=AG$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D21=AH$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D21=AI$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D21=AJ$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D21=AK$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D21=AL$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D21=AM$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D21=AN$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D21=AO$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D21=AP$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D21=AQ$9,$B21='Tab 6 - Financial Model'!$B16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B21,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E21*$D22","v":0},{"$f":"F21*$D22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32999268.91517454,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E21-E22","v":0},{"$f":"F21-F22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2869501.6447977833,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,{"$f":"'Tab 6 - Financial Model'!B17","v":"Providence Emergency Responce Station "},null,{"$f":"'Tab 6 - Financial Model'!I17","v":17},{"$f":"IF(AND($D24=E$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D24=F$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D24=G$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D24=H$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D24=I$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D24=J$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D24=K$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D24=L$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D24=M$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D24=N$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D24=O$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D24=P$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D24=Q$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D24=R$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D24=S$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D24=T$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D24=U$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D24=V$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D24=W$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D24=X$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D24=Y$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":32276673.641532883},{"$f":"IF(AND($D24=Z$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D24=AA$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D24=AB$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D24=AC$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D24=AD$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D24=AE$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D24=AF$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D24=AG$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D24=AH$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D24=AI$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D24=AJ$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D24=AK$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D24=AL$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D24=AM$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D24=AN$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D24=AO$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D24=AP$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D24=AQ$9,$B24='Tab 6 - Financial Model'!$B17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B24,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E24*$D25","v":0},{"$f":"F24*$D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29694539.750210255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E24-E25","v":0},{"$f":"F24-F25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2582133.8913226277,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,{"$f":"'Tab 6 - Financial Model'!B18","v":"Rangeview Emergency Responce Station "},null,{"$f":"'Tab 6 - Financial Model'!I18","v":14},{"$f":"IF(AND($D27=E$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D27=F$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D27=G$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D27=H$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D27=I$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D27=J$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D27=K$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D27=L$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D27=M$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D27=N$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D27=O$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D27=P$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D27=Q$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D27=R$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D27=S$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D27=T$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D27=U$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D27=V$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":36162210.279093951},{"$f":"IF(AND($D27=W$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D27=X$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D27=Y$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D27=Z$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D27=AA$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D27=AB$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D27=AC$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D27=AD$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D27=AE$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D27=AF$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D27=AG$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D27=AH$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D27=AI$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D27=AJ$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D27=AK$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D27=AL$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D27=AM$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D27=AN$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D27=AO$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D27=AP$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D27=AQ$9,$B27='Tab 6 - Financial Model'!$B18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B27,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E27*$D28","v":0},{"$f":"F27*$D28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,33269233.456766438,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E27-E28","v":0},{"$f":"F27-F28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2892976.8223275132,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,{"$f":"'Tab 6 - Financial Model'!B19","v":"South Shepard Emergency Responce Station"},null,{"$f":"'Tab 6 - Financial Model'!I19","v":10},{"$f":"IF(AND($D30=E$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D30=F$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D30=G$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D30=H$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D30=I$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D30=J$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D30=K$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D30=L$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D30=M$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D30=N$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D30=O$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D30=P$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D30=Q$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D30=R$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":25232333.967342556},{"$f":"IF(AND($D30=S$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D30=T$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D30=U$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D30=V$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D30=W$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D30=X$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D30=Y$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D30=Z$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D30=AA$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D30=AB$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D30=AC$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D30=AD$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D30=AE$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D30=AF$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D30=AG$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D30=AH$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D30=AI$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D30=AJ$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D30=AK$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D30=AL$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D30=AM$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D30=AN$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D30=AO$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D30=AP$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D30=AQ$9,$B30='Tab 6 - Financial Model'!$B19),('Tab 6 - Financial Model'!$D19*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B30,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E30*$D31","v":0},{"$f":"F30*$D31","v":0},0,0,0,0,0,0,0,0,0,0,0,23213747.249955151,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,"Remainder: needed from other sources",null,null,{"$f":"E30-E31","v":0},{"$f":"F30-F31","v":0},0,0,0,0,0,0,0,0,0,0,0,2018586.7173874043,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]
[7,{"$f":"'Tab 6 - Financial Model'!B20","v":"West View Emergency Responce Station "},null,{"$f":"'Tab 6 - Financial Model'!I20","v":25},{"$f":"IF(AND($D33=E$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D33=F$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D33=G$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D33=H$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D33=I$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D33=J$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D33=K$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D33=L$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D33=M$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D33=N$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D33=O$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D33=P$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D33=Q$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D33=R$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D33=S$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D33=T$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D33=U$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D33=V$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D33=W$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D33=X$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D33=Y$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D33=Z$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D33=AA$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D33=AB$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D33=AC$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D33=AD$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D33=AE$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D33=AF$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D33=AG$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":42765743.265581518},{"$f":"IF(AND($D33=AH$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D33=AI$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D33=AJ$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D33=AK$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D33=AL$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D33=AM$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D33=AN$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D33=AO$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D33=AP$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D33=AQ$9,$B33='Tab 6 - Financial Model'!$B20),('Tab 6 - Financial Model'!$D20*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B33,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E33*$D34","v":0},{"$f":"F33*$D34","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,39344483.804334998,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E33-E34","v":0},{"$f":"F33-F34","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,3421259.4612465203,0,0,0,0,0,0,0,0,0,0]
[8,{"$f":"'Tab 6 - Financial Model'!B21","v":"Shepard Industrial Station"},null,{"$f":"'Tab 6 - Financial Model'!I21","v":30},{"$f":"IF(AND($D36=E$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D36=F$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D36=G$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D36=H$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D36=I$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D36=J$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D36=K$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D36=L$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D36=M$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D36=N$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D36=O$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D36=P$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D36=Q$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D36=R$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D36=S$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D36=T$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D36=U$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D36=V$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D36=W$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D36=X$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D36=Y$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D36=Z$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D36=AA$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D36=AB$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D36=AC$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D36=AD$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D36=AE$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D36=AF$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D36=AG$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D36=AH$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D36=AI$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D36=AJ$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D36=AK$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D36=AL$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":50988890.015053876},{"$f":"IF(AND($D36=AM$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D36=AN$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D36=AO$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D36=AP$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D36=AQ$9,$B36='Tab 6 - Financial Model'!$B21),('Tab 6 - Financial Model'!$D21*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$B$14:$B$21,'Tab 7 - Bylaw Continuity'!B36,'Tab 6 - Financial Model'!$F$14:$F$21)","v":0.92},{"$f":"E36*$D37","v":0},{"$f":"F36*$D37","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,0,0,46909778.813849568,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E36-E37","v":0},{"$f":"F36-F37","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,0,0,4079111.2012043074,0,0,0,0,0]
[null,"TOTAL:"]
[null,"Expenditures from 2024 Bylaw",null,null,{"$f":"E16+E19+E22+E25+E28+E31+E34+E37","v":0},{"$f":"F16+F19+F22+F25+F28+F31+F34+F37","v":0},0,0,0,0,0,0,0,0,0,33278039.112314623,0,23213747.249955151,0,0,0,33269233.456766438,0,0,29694539.750210255,0,0,32999268.91517454,0,44080858.903129473,0,0,39344483.804334998,0,0,0,0,46909778.813849568,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E17+E20+E23+E26+E29+E32+E35+E38","v":0},{"$f":"F17+F20+F23+F26+F29+F32+F35+F38","v":0},0,0,0,0,0,0,0,0,0,2893742.5315056182,0,2018586.7173874043,0,0,0,2892976.8223275132,0,0,2582133.8913226277,0,0,2869501.6447977833,0,3833118.1654895172,0,0,3421259.4612465203,0,0,0,0,4079111.2012043074,0,0,0,0,0]
[null,"Expenditures from 2M2016 Bylaw Balance",null,null,{"$f":"E13","v":0},{"$f":"F13","v":0},{"$f":"G13","v":0},{"$f":"IF(H52=0,0,IF(G63>H41,H41,G63))","v":0},{"$f":"IF(I52=0,0,IF(H63>I41,I41,H63))","v":0},0,0,0,{"$f":"IF(M52=0,0,IF(L63>M41,M41,L63))","v":0},{"$f":"IF(N52=0,0,IF(M63>N41,N41,M63))","v":0},0,2893742.5315056182,{"$f":"IF(Q52=0,0,IF(P63>Q41,Q41,P63))","v":0},{"$f":"IF(R52=0,0,IF(Q63>R41,R41,Q63))","v":2018586.7173874043},0,{"$f":"IF(T52=0,0,IF(S63>T41,T41,S63))","v":0},{"$f":"IF(U52=0,0,IF(T63>U41,U41,T63))","v":0},2892976.8223275132,{"$f":"IF(W52=0,0,IF(V63>W41,W41,V63))","v":0},{"$f":"IF(X52=0,0,IF(W63>X41,X41,W63))","v":0},2582133.8913226277,{"$f":"IF(Z52=0,0,IF(Y63>Z41,Z41,Y63))","v":0},{"$f":"IF(AA52=0,0,IF(Z63>AA41,AA41,Z63))","v":0},{"$f":"IF(AB52=0,0,IF(AA63>AB41,AB41,AA63))","v":2869501.6447977833},{"$f":"IF(AC52=0,0,IF(AB63>AC41,AC41,AB63))","v":0},{"$f":"IF(AD52=0,0,IF(AC63>AD41,AD41,AC63))","v":2123159.979528368},{"$f":"IF(AE52=0,0,IF(AD63>AE41,AE41,AD63))","v":0},{"$f":"IF(AF52=0,0,IF(AE63>AF41,AF41,AE63))","v":0},{"$f":"IF(AG52=0,0,IF(AF63>AG41,AG41,AF63))","v":0},{"$f":"IF(AH52=0,0,IF(AG63>AH41,AH41,AG63))","v":0},{"$f":"IF(AI52=0,0,IF(AH63>AI41,AI41,AH63))","v":0},{"$f":"IF(AJ52=0,0,IF(AI63>AJ41,AJ41,AI63))","v":0},{"$f":"IF(AK52=0,0,IF(AJ63>AK41,AK41,AJ63))","v":0},{"$f":"IF(AL52=0,0,IF(AK63>AL41,AL41,AK63+AL60))","v":0},{"$f":"IF(AM52=0,0,IF(AL63>AM41,AM41,AL63))","v":0},{"$f":"IF(AN52=0,0,IF(AM63>AN41,AN41,AM63))","v":0},{"$f":"IF(AO52=0,0,IF(AN63>AO41,AO41,AN63))","v":0},{"$f":"IF(AP52=0,0,IF(AO63>AP41,AP41,AO63))","v":0},{"$f":"IF(AQ52=0,0,IF(AP63>AQ41,AQ41,AP63))","v":0}]
[null,"Expenditures from Non-OSL City Funding Sources",null,null,0,0,0,0,0,0,0,{"$f":"(L40+L41)-L40-L42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1709958.1859611492,0,0,3421259.4612465203,0,0,0,0,4079111.2012043074,0,0,0,0,0]
[]
["Land Absorption (hectares) and DA Contributions ($)"]
["Land absorption forecast and developer contributions under each bylaw. The contribution values feed into the payment schedule below.",null,null,"Land Absorption (ha's)",262,367,506,{"$f":"'Tab 6 - Financial Model'!J29","v":290},{"$f":"'Tab 6 - Financial Model'!K29","v":309},{"$f":"'Tab 6 - Financial Model'!L29","v":327},{"$f":"'Tab 6 - Financial Model'!M29","v":321},{"$f":"'Tab 6 - Financial Model'!N29","v":321},{"$f":"'Tab 6 - Financial Model'!O29","v":318.48089795918366},{"$f":"'Tab 6 - Financial Model'!P29","v":315.96179591836733},{"$f":"'Tab 6 - Financial Model'!Q29","v":313.44269387755099},{"$f":"'Tab 6 - Financial Model'!R29","v":310.92359183673466},{"$f":"'Tab 6 - Financial Model'!S29","v":308.40448979591832},{"$f":"'Tab 6 - Financial Model'!T29","v":305.88538775510199},{"$f":"'Tab 6 - Financial Model'!U29","v":303.36628571428565},{"$f":"'Tab 6 - Financial Model'!V29","v":300.84718367346932},{"$f":"'Tab 6 - Financial Model'!W29","v":298.32808163265298},{"$f":"'Tab 6 - Financial Model'!X29","v":295.80897959183665},{"$f":"'Tab 6 - Financial Model'!Y29","v":293.28987755102031},{"$f":"'Tab 6 - Financial Model'!Z29","v":290.77077551020398},{"$f":"'Tab 6 - Financial Model'!AA29","v":288.25167346938764},{"$f":"'Tab 6 - Financial Model'!AB29","v":285.7325714285713},{"$f":"'Tab 6 - Financial Model'!AC29","v":283.21346938775497},{"$f":"'Tab 6 - Financial Model'!AD29","v":280.69436734693863},{"$f":"'Tab 6 - Financial Model'!AE29","v":278.1752653061223},{"$f":"'Tab 6 - Financial Model'!AF29","v":275.65616326530596},{"$f":"'Tab 6 - Financial Model'!AG29","v":273.13706122448963},{"$f":"'Tab 6 - Financial Model'!AH29","v":270.61795918367329},{"$f":"'Tab 6 - Financial Model'!AI29","v":268.09885714285696},{"$f":"'Tab 6 - Financial Model'!AJ29","v":265.57975510204062},{"$f":"'Tab 6 - Financial Model'!AK29","v":263.06065306122429},{"$f":"'Tab 6 - Financial Model'!AL29","v":225.741551020408},{"$f":"'Tab 6 - Financial Model'!AM29","v":223.222448979592},{"$f":"'Tab 6 - Financial Model'!AN29","v":220.70334693877498},{"$f":"'Tab 6 - Financial Model'!AO29","v":218.18424489795899},{"$f":"'Tab 6 - Financial Model'!AP29","v":215.665142857143},{"$f":"'Tab 6 - Financial Model'!AQ29","v":0},{"$f":"'Tab 6 - Financial Model'!AR29","v":0},{"$f":"'Tab 6 - Financial Model'!AS29","v":0}]
[null,null,null,"Levy Rates under the 2016 bylaw",19938,20058,22144,22359]
[null,null,null,"Contributions from signed DA's - 2016 Levy",{"$f":"E46*E47","v":5223756},{"$f":"F46*F47","v":7361286},11204864,6484110]
[null,null,null,"Contributions from signed DA's - 2024 Levy",0,0,0,0,{"$f":"'Tab 6 - Financial Model'!K34","v":5274259.8313397234},{"$f":"'Tab 6 - Financial Model'!L34","v":5820944.5438190047},{"$f":"'Tab 6 - Financial Model'!M34","v":5959274.7516341815},{"$f":"'Tab 6 - Financial Model'!N34","v":6214927.6384792877},{"$f":"'Tab 6 - Financial Model'!O34","v":6430682.9846980022},{"$f":"'Tab 6 - Financial Model'!P34","v":6653512.1246471498},{"$f":"'Tab 6 - Financial Model'!Q34","v":6883624.9115320649},{"$f":"'Tab 6 - Financial Model'!R34","v":7121236.185282385},{"$f":"'Tab 6 - Financial Model'!S34","v":7366565.8141970485},{"$f":"'Tab 6 - Financial Model'!T34","v":7619838.730984835},{"$f":"'Tab 6 - Financial Model'!U34","v":7881284.9626429081},{"$f":"'Tab 6 - Financial Model'!V34","v":8151139.6535783513},{"$f":"'Tab 6 - Financial Model'!W34","v":8429643.0813379586},{"$f":"'Tab 6 - Financial Model'!X34","v":8717040.6642694958},{"$f":"'Tab 6 - Financial Model'!Y34","v":9013582.960393237},{"$f":"'Tab 6 - Financial Model'!Z34","v":9319525.6567154657},{"$f":"'Tab 6 - Financial Model'!AA34","v":9635129.5481660031},{"$f":"'Tab 6 - Financial Model'!AB34","v":9960660.5052891225},{"$f":"'Tab 6 - Financial Model'!AC34","v":10296389.429761665},{"$f":"'Tab 6 - Financial Model'!AD34","v":10642592.196753412},{"$f":"'Tab 6 - Financial Model'!AE34","v":10999549.583082624},{"$f":"'Tab 6 - Financial Model'!AF34","v":11367547.180054056},{"$f":"'Tab 6 - Financial Model'!AG34","v":11746875.289797433},{"$f":"'Tab 6 - Financial Model'!AH34","v":12137828.803851152},{"$f":"'Tab 6 - Financial Model'!AI34","v":12540707.06265858},{"$f":"'Tab 6 - Financial Model'!AJ34","v":12955813.694562791},{"$f":"'Tab 6 - Financial Model'!AK34","v":13383456.432799198},{"$f":"'Tab 6 - Financial Model'!AL34","v":11977510.704974743},{"$f":"'Tab 6 - Financial Model'!AM34","v":12351952.103717579},{"$f":"'Tab 6 - Financial Model'!AN34","v":12736477.043995947},{"$f":"'Tab 6 - Financial Model'!AO34","v":13131261.567979062},{"$f":"'Tab 6 - Financial Model'!AP34","v":13536478.26440339},{"$f":"'Tab 6 - Financial Model'!AQ34","v":0},{"$f":"'Tab 6 - Financial Model'!AR34","v":0},{"$f":"'Tab 6 - Financial Model'!AS34","v":0}]
[]
["Yearly Cash Flows ($)"]
["The opening balance takes the closing balance from the prior year.",null,null,"Opening Balance - 2016 Bylaw",null,null,null,{"$f":"G63","v":77871752},{"$f":"H63","v":64172754.0493},{"$f":"I63","v":50989673.288564965},48004791.435744405,50546330.58138784,{"$f":"L63","v":51832943.983963698},54056577.280875742,56375604.446225315,35601657.840365812,9000020.3306586556,9386121.2028439119,7726900.399970552,8058384.4271292882,8404089.1190531347,8764624.5422605146,6185595.7599570528,6450957.8180592107,6727703.9084539507,{"$f":"Y63","v":4378801.7428351268},4566652.3376027541,4762561.7228859123,2035823.165719022,2123159.979528368,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AO63","v":0},0]
[null,null,null,"Opening Balance - 2024 Bylaw",null,null,null,0,{"$f":"H64","v":0},0,0,{"$f":"K64","v":0},5387392.7047219602,11564315.656038454,18147525.992739238,25274292.694152422,-1064672.0658224374,5685883.462274611,-10750595.599776071,-3937809.4495497718,3417837.1759761181,11347746.662589952,-14097954.994907416,-6376775.6650413377,1960119.5843610466,-19383257.726804055,-11007875.168390278,-1960683.5310622081,-25910097.010975648,-16847323.499618929,-52079220.021324128,-43442542.760865159,-34070737.923666529,-64109414.495463595,-54860862.612555392,-44816208.386940263,-33929118.497587398,-22150961.782822732,-57346700.039429724,-47572445.16152481,-36996401.582611904,-25573872.733916294,-13258064.745589091]
[]
["Payment schedule from signed DA's. Payments from DA's signed under the 2016 bylaw are shown in green, from the 2024 bylaw in orange.","Year 0",null,0,null,null,null,{"$f":"$D55*H47*H46","v":0},{"$f":"$D55*A10*I46","v":0},{"$f":"$D55*J49*J46","v":0},{"$f":"$D55*K47*K46","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,0,0,0]
[null,"Year 1",null,0,null,null,null,{"$f":"$D56*G47*G46","v":0},{"$f":"$D56*H47*H46","v":0},{"$f":"$D56*A10*I46","v":0},{"$f":"$D56*J49*J46","v":0},{"$f":"$D56*K47*K46","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,0,0]
[null,"Year 2",null,0,null,null,null,{"$f":"$D57*F48","v":0},{"$f":"$D57*G48","v":0},{"$f":"$D57*H48","v":0},{"$f":"$D57*I49","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,0,0,0]
[null,"Year 3",null,1,null,null,null,{"$f":"$D58*E48","v":5223756},{"$f":"$D58*F48","v":7361286},{"$f":"$D58*G48","v":11204864},{"$f":"$D58*H48","v":6484110},{"$f":"$D58*I49","v":5274259.8313397234},5820944.5438190047,5959274.7516341815,6214927.6384792877,6430682.9846980022,6653512.1246471498,6883624.9115320649,7121236.185282385,7366565.8141970485,7619838.730984835,7881284.9626429081,8151139.6535783513,8429643.0813379586,8717040.6642694958,9013582.960393237,9319525.6567154657,9635129.5481660031,9960660.5052891225,10296389.429761665,10642592.196753412,10999549.583082624,11367547.180054056,11746875.289797433,12137828.803851152,12540707.06265858,12955813.694562791,13383456.432799198,11977510.704974743,12351952.103717579,12736477.043995947,13131261.567979062,13536478.26440339]
[]
["Investment Income: shown for each bylaw separately.",null,null,"Investment Income - 2016 Bylaw",null,null,null,{"$f":"((H52+(SUM(H55:H58)*0.5))-((H42+H13)*0.5))*'Tab 6 - Financial Model'!E26","v":2982872.0493000001},{"$f":"((I52+(SUM(I56:I58)*0.5))-((I42+I13)*0.5))*'Tab 6 - Financial Model'!E26","v":2418360.2392649702},{"$f":"((J52+(SUM(J57:J58)*0.5))-((J42+J13)*0.5))*'Tab 6 - Financial Model'!E26","v":2078840.1471794371},{"$f":"((K52+(SUM(K58)*0.5))-((K42+K13)*0.5))*'Tab 6 - Financial Model'!E26","v":2069530.145643435},{"$f":"(L52-((L42+L13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":2149919.6626626761},{"$f":"(M52-((M42+M13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":2223633.2969120429},{"$f":"(N52-((N42+N13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":2319027.1653495692},{"$f":"(O52-((O42+O13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":1931481.987417279},{"$f":"(P52-((P42+P13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":936615.59231335344},{"$f":"(Q52-((Q42+Q13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":386100.87218525633},{"$f":"(R52-((R42+R13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":359365.91451404401},{"$f":"(S52-((S42+S13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":331484.02715873666},{"$f":"(T52-((T42+T13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":345704.69192384649},{"$f":"(U52-((U42+U13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":360535.42320737947},{"$f":"(V52-((V42+V13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":313948.04002405092},{"$f":"(W52-((W42+W13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":265362.05810215755},{"$f":"(X52-((X42+X13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":276746.09039474017},{"$f":"(Y52-((Y42+Y13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":233231.72570380411},{"$f":"(Z52-((Z42+Z13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":187850.59476762696},{"$f":"(AA52-((AA42+AA13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":195909.38528315816},{"$f":"(AB52-((AB42+AB13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":142763.08763089319},{"$f":"(AC52-((AC42+AC13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":87336.813809346044},{"$f":"(AD52-((AD42+AD13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":45541.781560883494},{"$f":"(AE52-((AE42+AE13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AF52-((AF42+AF13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AG52-((AG42+AG13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AH52-((AH42+AH13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AI52-((AI42+AI13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AJ52-((AJ42+AJ13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AK52-((AK42+AK13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AL52-(AL52*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AM52-((AM42+AM13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AN52-((AN42+AN13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AO52-((AO42+AO13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AP52-((AP42+AP13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AQ52-((AQ42+AQ13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0}]
[null,null,null,"Investment Income - 2024 Bylaw",null,null,null,{"$f":"(H53-(H40*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((I53+(SUM(I55)*0.5))-(I40*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((J53+(SUM(J55:J56)*0.5))-(J40*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((K53+(SUM(K55:K57)*0.5))-(K40*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((L53+(SUM(L55:L58)*0.5))-(L40*0.5))*'Tab 6 - Financial Model'!$E$26","v":113132.87338223707},{"$f":"((M53+(SUM(M55:M58)*0.5))-(M40*0.5))*'Tab 6 - Financial Model'!$E$26","v":355978.40749748977},{"$f":"((N53+(SUM(N55:N58)*0.5))-(N40*0.5))*'Tab 6 - Financial Model'!$E$26","v":623935.5850666028},{"$f":"((O53+(SUM(O55:O58)*0.5))-(O40*0.5))*'Tab 6 - Financial Model'!$E$26","v":911839.06293389399},{"$f":"((P53+(SUM(P55:P58)*0.5))-(P40*0.5))*'Tab 6 - Financial Model'!$E$26","v":508391.36764176248},{"$f":"((Q53+(SUM(Q55:Q58)*0.5))-(Q40*0.5))*'Tab 6 - Financial Model'!$E$26","v":97043.403449898804},{"$f":"((R53+(SUM(R55:R58)*0.5))-(R40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-106356.72362759436},{"$f":"((S53+(SUM(S55:S58)*0.5))-(S40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-308450.03505608626},{"$f":"((T53+(SUM(T55:T58)*0.5))-(T40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-10919.188671158521},{"$f":"((U53+(SUM(U55:U58)*0.5))-(U40*0.5))*'Tab 6 - Financial Model'!$E$26","v":310070.7556290002},{"$f":"((V53+(SUM(V55:V58)*0.5))-(V40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-57753.163373840755},{"$f":"((W53+(SUM(W55:W58)*0.5))-(W40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-429960.32371227251},{"$f":"((X53+(SUM(X55:X58)*0.5))-(X40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-92747.831935574184},{"$f":"((Y53+(SUM(Y55:Y58)*0.5))-(Y40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-365878.22522434039},{"$f":"((Z53+(SUM(Z55:Z58)*0.5))-(Z40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-638200.4019794591},{"$f":"((AA53+(SUM(AA55:AA58)*0.5))-(AA40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-272334.01938739617},{"$f":"((AB53+(SUM(AB55:AB58)*0.5))-(AB40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-585274.11290490185},{"$f":"((AC53+(SUM(AC55:AC58)*0.5))-(AC40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-897886.99393240362},{"$f":"((AD53+(SUM(AD55:AD58)*0.5))-(AD40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1447427.0483373918},{"$f":"((AE53+(SUM(AE55:AE58)*0.5))-(AE40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-2005914.9362944444},{"$f":"((AF53+(SUM(AF55:AF58)*0.5))-(AF40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1627744.7458839929},{"$f":"((AG53+(SUM(AG55:AG58)*0.5))-(AG40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-2061739.9475161205},{"$f":"((AH53+(SUM(AH55:AH58)*0.5))-(AH40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-2498323.4068892333},{"$f":"((AI53+(SUM(AI55:AI58)*0.5))-(AI40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-2093174.578236019},{"$f":"((AJ53+(SUM(AJ55:AJ58)*0.5))-(AJ40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1653617.1733057108},{"$f":"((AK53+(SUM(AK55:AK58)*0.5))-(AK40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1177656.9797981274},{"$f":"((AL53+(SUM(AL55:AL58)*0.5))-(AL40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1669415.8755566257},{"$f":"((AM53+(SUM(AM55:AM58)*0.5))-(AM40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-2203255.8270698269},{"$f":"((AN53+(SUM(AN55:AN58)*0.5))-(AN40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1775908.5248046722},{"$f":"((AO53+(SUM(AO55:AO58)*0.5))-(AO40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-1313948.1953003376},{"$f":"((AP53+(SUM(AP55:AP58)*0.5))-(AP40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-815453.57965185819},{"$f":"((AQ53+(SUM(AQ55:AQ58)*0.5))-(AQ40*0.5))*'Tab 6 - Financial Model'!$E$26","v":-278413.51881431928}]
[]
["Closing Balances = Starting balance + contributions + investment income - expenditures",null,null,"Closing Balance - 2016 Bylaw",null,null,77871752,{"$f":"H52+SUM(H55:H60)-H42-H13","v":64172754.0493},{"$f":"I52+SUM(I56:I60)-I42-I13","v":50989673.288564965},{"$f":"J52+SUM(J57:J60)-J42-J13","v":48004791.435744405},{"$f":"K52+SUM(K58:K60)-K42-K13","v":50546330.58138784},{"$f":"IF(L52-L42-L13>0,L52+L60-L42-L13,0)","v":51832943.983963698},54056577.280875742,56375604.446225315,35601657.840365812,9000020.3306586556,9386121.2028439119,7726900.399970552,8058384.4271292882,8404089.1190531347,8764624.5422605146,6185595.7599570528,6450957.8180592107,6727703.9084539507,4378801.7428351268,4566652.3376027541,4762561.7228859123,2035823.165719022,2123159.979528368,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance - 2024 Bylaw",null,null,null,{"$f":"SUM(H53:H57,H61)-H40","v":0},{"$f":"SUM(I53:I57,I61)-I40","v":0},{"$f":"SUM(J53:J57,J61)-J40","v":0},{"$f":"SUM(K53:K57,K61)-K40","v":0},{"$f":"SUM(L53:L58,L61)-L40","v":5387392.7047219602},11564315.656038454,18147525.992739238,25274292.694152422,-1064672.0658224374,5685883.462274611,-10750595.599776071,-3937809.4495497718,3417837.1759761181,11347746.662589952,-14097954.994907416,-6376775.6650413377,1960119.5843610466,-19383257.726804055,-11007875.168390278,-1960683.5310622081,-25910097.010975648,-16847323.499618929,-52079220.021324128,-43442542.760865159,-34070737.923666529,-64109414.495463595,-54860862.612555392,-44816208.386940263,-33929118.497587398,-22150961.782822732,-57346700.039429724,-47572445.16152481,-36996401.582611904,-25573872.733916294,-13258064.745589091,-2.0023435354232788E-8]

{"sheet":"Tab 4 - Summary","index":9,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,0,23,1],[11,0,11,1],[2,0,2,1],[21,0,21,1],[22,0,22,1]]}
[]
[]
["Assumptions"]
["Escalation Rate","The Escalation factor of 3.58% is a 5 year smoothed average, determined using Non-residential Construction Price Index (CPI) for Calgary from 1981 - 2022, excluding 4 years of hyper inflationary period in Calgary from 2006 -2009."]
["Discount Rate","The discount rate of 4.29% is based on asset mix of the investments held on the capital deposits and the Long term Capital Market assumptions that City uses in projecting returns from investment portfolios"]
["Leviable Ha","Leviable hectares are determined by Corportate economics from 2024 to 2026 and 2027 forward is deterrmined by dividing the planned hectares to the remaining hectares."]
["Development schedule","Assumptions are built around the development schedule of the fire stations which can change based on developing communities."]
["Benefit Rate","Benefit rate calculations consider the land that will benefit from infrastructure and then tie back to the estimated future residents/jobs in that land. "]
["Collection schedule","This financial model considers that we start collecting from developers with the 3 year delay in collections after the DA is signed."]
[]
[]
["Steps to build Financial Model in Tab 3"]
["Step 1:","Multiply the current capital cost to the benefit rate% to calculate the leviable cost."]
["Step 2:","Calculate the future value of leviable costs based on the required infrastructure build timeline."]
["Step 3:","Use the future value calculated above in Step 1 to recalculate the present value of that amount in the required infrastructure built year."]
["Step 4:","Use the present value of future cashflows calculated above in Step 2 to calculate the rate per hectare by dividing it by total hectares."]
["Step 5:","Multiply the rate calculated above in Step 4 by hectares developed each year in order to calculate the OSL contributions for each year."]
["Step 6:","Subtract the required infrastructure's future value of capital cost in the year it starts constructing."]
["Step 7:","Multiply the contributions by discount rate to calculate the investment income earned by The City of Calgary."]
[]
[]
["Summary","Frequently Asked Questions"]
["Using this financial model, The City will charge reasonable rate per hectare and will be able to recoup any interest costs that they incur from using alternative funding sources for the required infrastructure development over the collection cycle."]
["The contributions are based on rate that is escalated each year by discount factor. This is done to offset any opportunity income that The City of Calgary loses by providing payment plan to the developers instead of collecting all the cost upfront."]