Off-Site Levy Bylaw 2020-27 (office consolidation current as of January 13, 2026)

Canmore, Alberta · No. 2020-27 · adopted 2021-01-05 · summary & facts

This is the exact embedded text of the captured official document. Snapshot e3400bf259c7 · verified 2026-10-23 · original document · archived snapshot · unofficial consolidation, the official version is held by the municipal clerk.

(ON CANMORE BYLAW 2020-27 Office Consolidation current as of January 13, 2026 A BYLAW OF THE TOWN OF CANMORE, IN THE PROVINCE OF ALBERTA, TO IMPOSE OFF-SITE LEVIES IN RESPECT OF LAND OR BUILDINGS THAT ARE TO BE SUBDIVIDED, DEVELOPED OR ARE TO UNDERGO A CHANGE IN USE OR INTENSITY OF USE WHEREAS Part 17, Division 6 of the Municipal Government Act, R.S.A. 2000 Chapter M-26, provides that the council of a municipality may pass a bylaw establishing an Off-Site levy; WHEREAS the council for the Town of Canmore deems it desirable to establish an Off-Site levy for the purposes described in the Act; NOW THEREFORE the Council for the Town of Canmore in the Province of Alberta, duly assembled, enacts as follows: TITLE 1 This bylaw shall be known as Off-Site Levy Bylaw 2020-27. PURPOSE AND INTENT 2 This bylaw is intended to: a) impose and provide for the payment of a levy to be known as an Off-Site Levy in respect of Applicable Land; and b) authorize agreements to be entered into in respect to payment of Off-Site Levies to ensure that the developer of each parcel of Applicable Land pays a proportionate share of the costs to provide new or expanded infrastructure required for the zone in which the Applicable Land is located. DEFINITIONS 3 In this bylaw: a) "Act" shall mean the Municipal Government Act, R.S.A. 2000, Chapter M-26. b) "Applicable Land" shall mean land that is to be subdivided or developed. 2025-42 c) Repealed 2025-42 d) "Off-Site levies" mean the levies imposed by this bylaw. e) "Off-Site levy model" means the independent, third-party model employed by the Town to calculate Off-Site levies as further referenced in section 10. 2025-42 Office Consolidation current as of January 13, 2026 Page 1 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 f) "Service Demand Factor(s)" and "SDF(s)" means the relative demand for infrastructure services that result from different development types, with low density residential infrastructure having a baseline factor of one (1.0) with other development types scaled accordingly as further described in section 7. 2025-42 g) "Development" has the same meaning as provided for in Part 17 of the Act. h) "Commercial Unit" is set multiple of hectares of commercial development, with one (1) commercial hectare of development equal to 37commercial units of development. 2025-42 1) "Commercial Development" means all non-residential and non-hotel development. 2025-42 j}) "Hotel Unit" means a unit where sleeping facilities are provided for visitors for periods of up to 30 days and where the total floor area of the unit is 75 square meters or less. k) "Hotel Development" means any development, or relative portion of a development, that is visitor accommodation or other use that provides short-term accommodation to visitors. Tourist homes, as a sub class of residential use, are not considered as hotel or a visitor accommodation use. 2025-42 1) "Residential Unit" means a self-contained room or suite of rooms which normally provide sleeping, washing, sanitary and kitchen facilities, and which is intended for domestic use and includes residential units operated as tourist homes and/or visitor accommodation units that are larger than 75 square meters in size. m) "Residential Development" means development of a dwelling unit, or units, for residential purposes at a range of densities (and may or may not include accessory uses such as home occupations or live work studios): i. Residential - Low Density: <35 units per hectare, ii, Residential - Medium / High Density: 35 and greater units per hectare, n) "Existing Residential Unit" means a residential unit that is existent on a parcel at the time of application for redevelopment or that had existed on the parcel within the previous 5 years from the date of application but has been demolished. 0) "Tourist Home", "Live Work Studio", "Secondary Suite" and "Home Occupation" have the same meaning as the definitions contained in the Town's Land Use Bylaw (2018-22 or current version as updated). 2024-01 Office Consolidation current as of January 13, 2026 Page 2 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 ADMINISTRATION AND ENFORCEMENT 4 Council hereby delegates to the chief administrative officer the duty and authority to enforce and administer this bylaw, to ensure periodic review of the calculation of the levies and to execute on behalf of the Town, written agreements with owners of Applicable Land providing for the payment of Off-Site levies imposed by this bylaw. 2025-42 DIVISION INTO ZONES 5 The Town is hereby divided into sixteen Off-Site Levy Cost Recovery Zones which are indicated in Table 1 below and demonstrated in Schedule 1 of this bylaw. Two additional zones are attributed to the Municipal District of Bighorn (MD). 2025-42 Table 1 Pst angle 2025-42 6 The MD benefits from infrastructure and services provided by the Town of Canmore but does not pay Off-Site Levies to the Town. Fees for Fire, Water and Sanitary infrastructure payable by the MD to the Town, are calculated in separate servicing agreements based on various infrastructure master plans such the 2022 Utility Master Plan. These agreements are factored into the determination of Off-Site levies payable to the Town by the development community, by excluding the relevant project costs in the Off-Site Levy model which are attributable to the MD. 2025-42 Office Consolidation current as of January 13, 2026 Page 3 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 IMPOSITION OF OFF-SITE LEVIES 7 The Town shall distinguish the differential benefit of offsite infrastructure according to four land use development types (Commercial, Hotels, Residential Low Density and Residential Medium /High Density) using SDFs. SDFs are presented as relative to Residential Low Density Development having an SDF of 1.0. SDFs for water and sanitary infrastructure are informed by utility design rates from the 2022 Utility Master Plan (UMP) as indicated in Schedule 7 and Table 2 below. 2025-42 Table 2 merelonmencalnne Service Demand Factors pet Infrastructure Type Redental- Low Dans 2025-42 8 The following Off-Site levy rates are imposed for each Zone for each type of development, with each Zone number from Table 1 being identified with the four possible types of development as follows: a) Type 1 for Commercial, b) Type 2 for Hotel, c) Type 3 for Residential Low Density, d) 'Type 4 for Residential Med / High Density. 2025-42 9 The resulting infrastructure contributions to the total Off-Site levy rates / unit for each Zone and development type is listed in Table 3 below. Table 3 Zone & Dev | Transportation Water Sanitary Storm Fire Total Type ($/Unit) ($/Unit) ($/Unit) | ($/Unit) | ($/Unit) ($/Unit) 1,058 1,879 5806 | - | _1,833 10,576 1,590 49i3| | ota | 747 1,445 4466 | | on | 7,387 1,445 4466; = | 87 | 6,996 1,058 1,877 5,864 1,017 1,833 11,649 1,588 4,962 7,859 1,444 4,510 7,908 1444 4,510 7.420 1,058 1,586 5806] - | 1,833 10,283 Office Consolidation current as of January 13, 2026 Page 4 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 Zone & Dev | Transportation Water Sanitary Storm Fire Total p82 sa | gaa | gous | | ta | 7,208 2 pA 97 220 | too | | | 770 | pat toss | 586 | 5806 | | 833 | 10,283 | 4a Tse | gaa | gos | | ta | 7,208 es ee 2 pA T9720 | too | | | 770 | pt | tose | 586 | ot39 | | 883 | 10,616 | p52 Tae tga | sts | | wt | 7,505 p88 | s29 220 | ra | | 7.388 pA sor? P| | | | 7.026 pst | tose | 586 | ts | | 883 | 10,616 | p82 ase tga | sts | | wt | 7,505 p88 sz9 220 | ara | | 7.388 p84 sor? 0 | aon | | | 7.026 pon Toss | tse | 7272 | | 833 | 12.007 pe | ssa | 569 | ots | | tt | 8690 pos sate | ssa | | | 85 pe | 07 tae | 5594 | | | 80 pt | tose | gan | 5.929 | | 883 | 10,248 re 2 1 eC pS | s29 Tt o99 | aso | | | 7.05 pa sor? to Faso | | | 6743 pet | tose | aan | 5.929 | | 883 | 10,248 pe | sa | 209 | soz | | te | 9 ps sa | to | son | | | 7.05 pe | 97 | to99 son | | | 748 Office Consolidation current as of January 13, 2026 Page 5 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 Zone & Dev | Transportation Water Sanitary Storm Fire Total pT | toss | 93 | 929 | | 833 | 10,754 p12 ase | tos | sor | | wt | 7,622 a Pp Ba Tso? | tase | aso | |p | 7.032 p tat | toss | 852 | 336 | | 833 | 14.079 a 7 ste ae | |e | a MD Bighorn: Subject to Separate Servicing Agreements MD Bighorn: Subject to Separate Servicing Agreements pet | oss] 10535 | 845 | | 833 | 2.85 Re ce ©) ee p83 | 529 | toe | ost | | | 16,030 _| | 4 | s97 | toe | wast | | | 15,669 2025-42 DETERMINATION OF OFF-SITE LEVIES 10. The rates contained in Table 3 were determined in accordance with publicly available Off-Site Levy model. This model includes the full impact of project costs, grants, attribution to development, project zones, infrastructure staging, future development plans, financing costs, front-ending costs, inflation, and reserve interest impacts. 2025-42 10.1 The interest rate methodologies used in the determination of Off-Site Levy rates were determined as of January 1, 2024 and include: a) annual project and levy escalation rates: Bank of Canada median CPI (3.60%), b) interest earned if reserve has a surplus: Bank of Canada prime rate (7.20%), minus 1.75% equal to (5.45%), c) interest charged if reserve has a deficit: Treasury Board of Alberta 25-year lending rate (5.55%). 2025-42 Office Consolidation current as of January 13, 2026 Page 6 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 10.2 The Off-Site Levy rates shall be reviewed following updates to the Utility Master Plan and other master plans for municipal infrastructure, facilities, development, or services intended to be used as inputs into the Off-Site Levy model. 2025-42 10.3 The Off-Site Levy rates have been calculated to include the addition of front ending costs to the actual Town of Canmore reserve balances, as shown in Table 4. Front ending costs reflect the difference between what has been collected in off-site levies, and what the Town spent for development related projects as of Dec 31, 2022. Details of infrastructure and facility reserve balances, front ending balances and cash flows used in rate calculations are shown in Schedule 4. Table 4 Opening Balances | Transportation Water Sanitary Storm Fire as of Dec 31, 2022 ($) ($) ($) ($) ($) Town of Canmore $2,354,477 $2,918,323 $1,341,291 $519,522 $380,923 Reserve Balance Front Ending Costs $641,963 $4,115,443 $16,466,447 $1,070,532 $1,987,692 Opening Balance $1,712,514 ($1,197,120) ($15,125,156) ($551,010) | ($1,606,768) Used for Rate Calculation 2025-42 10.4 Due to the limited availability of future developable land in Canmore, the Off-Site Levy rates have been calculated using all foreseeable development in Canmore at full buildout. Full buildout is assumed to occur within the 25-year financial cash flow projections used by the Off-Site Levy model. The development plan uses Area Structure Plans and other Town of Canmore documents to establish full buildout numbers. 2025-42 11 The following Schedules form part of this bylaw and shall be used in the determination of Off-Site levies: a) Schedule 1 -- Off-Site Levy Cost Recovery Zones, b) Schedule 2 - Summary of Projects and Costs, c) Schedule 3 -- Summary of Project Zones and Staging, d) Schedule 4-- Reserve Balances, Cash Flows and Revisions, e) Schedule 5 -- Pull Build-Out Development Plan, f) Schedule 6 -- Off-Site Levy Project Summary, g) Schedule 7 -- Service Demand Factor. 2025-42 Office Consolidation current as of January 13, 2026 Page 7 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 12 Ifa grant specific to the project is utilized by the Town to pay for any eligible expenses relating to a project contained in the Off-Site levy model, then those funds shall be included in the Off-Site levy model and the Off-Site levies adjusted accordingly. 13 A "secondary suite" shall not count as an additional unit for the purposes of calculating off site levies, with the exception of where these additional units are required to be provided by as part of a land use district. 14 Where a mixed use development is proposed, the developer shall pay Off-Site levy rates for the areas where the development occurs as shown in Table 3. The calculation of Off-Site levy rates is based on the percentage distribution between different types of developments and is calculated as the percentage utilization of total building floor area. Note that one (1) commercial hectare of development is equal to 37 units of commercial development. a) Example 1 A new 4,000 m2? (0.4 Hectare) development site is proposed in Zone 1 which includes commercial development utilizing 25% of the total building floor area and 20 medium/high density residential units: Since the residential density is 20 units [ 0.4 ha = 50 units | hectare, the medium | high density residential rate is applicable. Using Table 3 for Zone 1 commercial rate (Row 1.1) and medium high density residential rate (Row 1.4): Commercial = 0.4 (ha) x 25% Total Floor Area x 37 (Units/ha) x $10,576 / Unit = $39,131 Residential = 20 Med-High Density Residential Units x 6,996 / Unit = $139,920 Total Off-Site Levy = $39,131+ $139,920 = $179,051; and 2025-42 b) Example 2 A new hotel with commercial space is proposed in Zone 1 which includes 100 hotel rooms, a swimming pool, restaurant, coffee shop and banquet rooms. The hotel has a gross floor area (GFA) 9,700 sq. meters. The restaurant and coffee shop use 544 sq. meters (5.6% of the GFA) and the banquet rooms use 465 sq. meters. (4.8% of the GFA): Since the commercial portion only applies to publicly accessible areas, this means that banquet rooms and pools are excluded from the commercial rate. Only the restaurant and coffee shop are included. Using Table 3 for Zone 1 commercial rate (Row 1.1) and hotel rate (Row 1.2): Commercial = 0.97 (ha) x 5.6% Total Floor Area x 37 (Units/ ha) x $10,576 / Unit = $21,256 Hotel = 100 Hotel Units x $7,471 / Unit = $747,100 Total Off-Site Levy = $21,256+ $747,100= $768,356 2025-42 CHANGE OF USE OR INTENSITY OF USE 15 Repealed 2025-42 Office Consolidation current as of January 13, 2026 Page 8 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 16 Where a development is proposed on a site that has previously paid off site levies, additional levies may be collected for infrastructure types that were not previously collected for. For example, a site that paid for water and sanitary levies, will be required to pay for other types of infrastructure that were not previously collected (e.g. road and fire facility) as per current rates in this bylaw. 17 For parcels which have not previously contributed offsite levies but where a unit or units exists on a parcel that is to be redeveloped with one or more units, the total units requiring payment of offsite levies shall be calculated as follows: Total units requiring offsite levies = # new units - # of existing units For example where a single family home (1) is demolished and replaced with a duplex (2) the total units required to pay offsite levies is one (2-1=1). 18 Credit for existing commercial development measured in hectares rather than units may be considered by Town administration when calculating offsite levies owing for commercial parcels which have not previously contributed offsite levies. The calculation will take into consideration existing and new demand for infrastructure. 2025-42 ENACTMENT/TRANSITION 19 If any clause in this bylaw is found to be invalid, it shall be severed from the remainder of the bylaw and shall not invalidate the whole bylaw. 20 Repealed 2025-42 21 Bylaw 2018-06 is repealed. 22 This bylaw comes into force on the date it is passed. FIRST READING: December 1, 2020 SECOND READING: January 5, 2021 THIRD READING: January 5, 2021 DATE IN EFFECT: January 7, 2021 Office Consolidation current as of January 13, 2026 Page 9 of 10 Town of Canmore Off-Site Levy Bylaw 2020-27 OFFICE CONSOLIDATION This document is a consolidation of a bylaw with one or more amending bylaws. Anyone making use of this consolidation is reminded that it has no legislative sanction. Amendments have been included for convenience of reference only. The approved bylaws should be consulted for all purposes of interpreting and applying the law. Bylaws included in this consolidation: 2020-27 Off-Site Levy Bylaw 2025-42 Off-Site Levy Bylaw Amendment Office Consolidation current as of January 13, 2026 Page 10 of 10 Off-site Levy Cost Recovery Zones N Schedule 1 N ian 1 6 ais mis mr \ Harvie 7 ' . "4 1 ¢ N of i \ J 4 ' \ '4 " = mis mis = 19 ° Lu \ a i "s \ e, 1 * \. , i Y % ; \. \ qe ee eee 1 \ 3 'i \ 4 ' \ y ' \) Ze i \ 1: \ e \ 1 Posen) \ f x it f 5 %, \. 2 ; -¥, N . CS \ Q 1 % 17 ' ", Zz * \ ae x D Sy Li Li ee * 6. \, N S ' % AN : ey A YX \ a 1 8 St of \ONI7 1 ? 5 3 @ x . Bo) i : ' : Vy ; 3 1 a eeAS | \ cos) S % 9 \ z o e 4 : os Ls 5 < 10 V6 @ ' 8s Roag \. A é : 'S ) : > a ie ST th ' a \ . -- ~ =, : 4 ~_ % XN = 4 > Peaks. Dr. \ a eee Aree ¥ ae See. | NN ; tus \ \ 1 \ . % aS ri a KX 1 ' . Wu, 1 . Nre! (NS 4 Z na 13 Seters ~ Sx = mem omy Three a >. ~~ LI 1 4 = e Ze sS yy Soy. ee x . Phy | x MR Oy : Ss is 7 ' > 7 1 y 'i ~ : SS 1 %e SSR NSmEcep. me > 15 Siete 1 be. tan" ine - ' 1 8 Sg, 1 Kel : ey ' i : e : A see ee ee eee ee, 1 A ' i : a " : Town Boundary ; : : it _ Off-site Levy Zones : : ir 1 Land Parcels i : a Railroad Town of por Road 0 500 1,000 2,000 Metres CANMORE Le File Name: Offsite_Levy_Zones_11x17 Water Body Date: 10/16/2025 Schedule 2: Summary of Projects and Costs 2023 $79,099,335.68 | $12,601,000.29 | $8,743,171.00 $0.00 $7,514,535.96 | $24,028,050.12 | ($24,282,076.20) $0.00 $276,568,344.30 | $196,541,263.96 | $288,241,599.94 $144,571,072.74 | $31,542,586.08 Developers Future Debenture # i ot " iB Debenture Bi-Annual (2) Debenture # : Remaining Project Total Project Cost Allocation to Totalltevies Infrastructure / Plan Dept Budget . Debenture Grants Contributions Transfer to Transfer to Project Start Debenture Debenture Debenture | Debenture Number Payments Total Project Collected to oe . . . Project Actuals . . . . . . . Reference or Payments . Cost (N.Incl (Incl Debt Future Developer Cost Facility Project # | Project # | Project # Interest Received Received Project Reserve [Jv)(tagguriei-3 Balance (n.incl Interest Amount Start % of Years Used in Approved Budget . . . . Date (Assumes all Number Annual (1) Total Financing) Financing) Development : : Trans to Reserve) Calculated Current Cost installments paid) WATER 39-SOUTH BOW RIVER LOOP (90% Water Dist #1-#10) complete] _--_--[Des: UTI-17-[Des: 7049, d $ 6,103,948 | $ 380,030 $1,002,315.47 ($654,701) | $0 (| ~---#a002793 | $ 2,628,000| 15-Dec-2020 | 1.78900% | 2 | 15 | 30 £#:| 30 ([$ 6103,948/$ = |S 6,483,978 25.6% $1,657,017 $1,002,315.47 WATER 39-SOUTH BOW RIVER LOOP (10% Fire Flow Benefit #9) |COMPLETE| _--_[Des: UTI-17-{Des: 7049, d $ 678,216 | $ 42,226 $142,081.33 ($578,361) | $0 | ~--#a002793 |$ 292,000 15-Dec-2020 | 1.78900% | 2 | 15 | 30 #+| 30 # (|[$ 678,216|$ = |$ 720,442 | 100.0% $720,442 $142,081.33 WATER 46-PUMP HOUSE #2 - CLEAR WELL CAPACITY UPGRADE complete] __--_--[Des: UTI-08-{Des: 1248/4 $ 2,057,590 | $ 427,459 $630,366.00 ($1,854,683) | $0 | #4002305 «| $ 1,868,824] 15-Dec-2017 | 276800% | 2 | 15 | 30 | 30 + # (|$ 2,057,590|$ = ~|$ 2,485,049 100.0% $2,485,049 $630,366.00 WATER PH2 - Replacement and Upgrade FUTURE | _[Des: UTI-12-{Des: 7113, $ 1013,356|$ - ~+([$ 3,687,170/$ ----- _--''|_'$4,415,260.78 $345,000.00 sievaao7_ || ll SoC] k!lCLdTlmwmLm™m™m™CUti<--t'C'<'iY;*é'('CSC*é*dSC(YRNESUNENNNNNNN tf [8 26,787,745 | § 25,769,390 | $ 26,787,745 50.0% $11,550,288 $1,460,260.78 TRANSPORTATION _|40-TRAFFIC SIGNALS MAIN AND 7TH comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 254,732 | $ 7,481 $82,761.49 (179,451) | $0 | _--s#ac01971 «(| $ 240,000 15-Dec-2015 | 112400% | 2 &2| 5s | 1 | «ww £([$ 275,000|$ = ~|$ 262,213 | 100.0% $262,213 $82,761.49 STORM 33-STONEWORKS CREEK DRAINAGE DIVERSION COMPLETE Des: N/A, CqDes: N/A, Cf $ 1,252,765 | $ 281,321 | $ - | : $0.00) $496,185.81 $1,037,901] #4001447 | § 1,300,000| 17-Dec-2012 | 2.62700% 15 $ 1,300,000 $ 1,534,086 100.0% $1,534,086 $496,185.81 [| STORM 37-TEEPEE TOWN STORMWATER MANAGEMENT UPGRADE] FUTURE | _[Des: N/A, CgDes: N/A, Cq $ 197,586 $519,522.31 $184,235.22 $85,442 | so | | [ff ff | ee Jo fs 2,775,000 | $ 2,577,414 | § 2,775,000 50.0% $1,387,500 $703,757.53 SANITARY 03-SANITARY UPGRADE #2 COMPLETE N/A N/A $ 96,617 | $ 65,819 | $ - | : $0.00 $96,215.00 $66,221) $ 96,617 $ 162,436 100.0% $96,215.00 , ; J ($66,221) , , , SANITARY 08-WwrTP PH.2 COMPLETE N/A N/A $ 2,916,420 | $ 44,732 | $ - | : $0.00 $2,883,089.99 $78,062) $ 2,916,420 $ 2,961,152 100.0% $2,883,089.99 916, a 883, ($78,062) 916, 961, 883, SANITARY 20-UMP - STORM WATER COMPLETE 1348 1348 $ 34,299 | $ 29,429 | $ - | : $0.00) $110,363.68 $3,364] $ 84,299 $ 113,728 100.0% $113,728 $110,363.68 z E ( ) J ($3,364) , 7 5, F SANITARY 30-WWTP EXPANSION PHASE 2 comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 8,957,806 | $ 2,169,269|$ 2,853141/$ - | $0.01 $4,065,050.07 (a20gg8a) | so | | | | | #[ [ o@ J[ 0 fs 3,957,806|$ = |$ 11,127,075 100.0% $8,273,934 $4,065,050.08 SANITARY 47b-WWTP SOLIDS HANDLING UPGRADE comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 400,000 | $ 58,800 $101,577.58 ($357,222) | $0_--_--| #4002304 & #4001973 ee ee (OO 400000 |$ = «dS 458,800 100.0% $458,800 $101,577.58 SANITARY 47c-WWTP SOLIDS HANDLING UPGRADE comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 4,862,679 | $ 1,487,334 [$ 1,570,529/$ - | ($0.00) §1,085,115.21 ($3,694,369) | $0 --_--| #4002304 & #4001973 ee ee (OO 4,362,679|$ = ~|$ 6,350,013 | 100.0% $4,779,484 §1,085,115.21 SANITARY 48-WWTP INFLUENT PUMP STATION Ph1 comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 403,019 | $ 25,285 $58,886.29 (155,266) | $0 =| ~=--#aco10a -[$ 167,500 16-Dec-2013 | 2.75600% | 2 | 10 | 2 £«| 2 & '|[§ 403,020/$ = ~|$ 428,304 50.0% $214,152 $58,886.29 SANITARY 49-LIFT STATION #1 PUMP UPGRADE comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 1,123,476 | $ 115,102 ($0.00) $116,022.01 (193,622) | $0 | ---s#aco103«|$ 762,500 | 17-Dec-2013 | 275600% | 2 «| 10 | 2 «| 2 # (S$ 1123476 |$ = $ 1,238,578 25.0% $309,644 $116,022.01 SANITARY 50-WWTP INFLUENT PUMP STATION Ph2 comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 811,621 | $ 28,630 ($0.00) $104,568.84 (315,557) | $0 || --s#a002501 |$ --380,000| 17-Dec-2018 | 268600% | 2 &2| 5s | 1 | ww #£ ([$ si1e21{$ = «sd S 840,251 50.0% [| $420,126 | $104,568.84 SANITARY 52-WWTP-PROCESS & MECHANICAL UPGRADE comPLETE| _--_--_--[Des: N/A, Ces: N/A, Cy $ 525,887 | $ 19,853 $72,308.93 ($200561) | $0 | ~--#a002503-|$ ---263,500| 17-Dec-2018 | 268600% | 2 &2| 5s | 1 | iw ™([$ 527,000|$ = ~|$ 545,740 | 50.0% [$272,870 | $72,308.93 SANITARY 53-WWTP-DEWATERING SYSTEM UPGRADE complete] --_--[Des: UTI-15{Des: 1555, d $ 4,765,236 | $ 944,382 ($0.00) $729,996.77 | __ ($2,424,812) | $0 «(| ~-- #4002663 «| $ 4,500,000| 16-Dec-2019 | 255190% | 2 | 15 | 30 #| 30 + (|$ 5,245,000|$ =| $ 5,709,618 50.0% $2,854,809 $729,996.77 SANITARY 59-LIFT STATION #2 UPGRADE complete] --_--[Des: UTI-17-{Des: 1753, d $ 5,009,355 | $ 249,019 ($0.00) $150,155.72 | _ ($375,682) | $0 | #a002500 /$ --932,500| 17-Dec-2018 | 3.20100% | 2 «| 1 | 30 #+| 30 ($s 5,389,156|$ = | $ 5,258,374 10.0% $525,837 $150,155.72 Schedule 3: Summary of Project Zones and Staging EXPAND . t 1.00 1.00 1.00 100 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 ey 3.00.00 a 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 00) +00 +00 I C7071 GG GG GG GGG GGG 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 00) +00 +00 I C7071 GG GG GG GGG GGG 1.00 100 100 1.00 100 100 100 100 100 100 1.00 100 100 1.00 oo) 005.00 1.00 100 100 1.00 100 100 100 100 100 100 1.00 100 100 1.00 oo) 005.00 1.00 100 1.00 100 1.00 1.00 100 100 100 100 100 100 1.00 1.00 oes rr 1.00 100 100 1.00 100 100 100 100 100 100 1.00 100 100 1.00 oo) 005.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 (NN l00) .co oo (I 3 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 00) +00 +00 I C7071 GG GG GG GGG GGG 1.00 100 1.00 100 1.00 1.00 100 100 100 100 100 100 1.00 1.00 oes rr 1.00 100 100 1.00 100 100 100 100 100 100 1.00 100 100 1.00 oo) 005.00 1.00 4.09 4.00 1.00 1.00 4.00 1.00 1.00 1.00 3.00 3.00 1.00.00 co (MN) 5.00 3.00 I 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 (I I 1.00 OO 9 GO GG GG GG GO |____ WATER __|39-SOUTH BOW RIVER LOOP (10% Fire Flow Benefit #9) [compueve| | |_| | | | ||| | | | | | joo} | | | UT CE 1.00 1.00 1.00 1.00 1.00, 1.00 1.00 1.00 1.00 1.00 1.00 1.00, 1.00 4.00 ORE fos rrr |__ waren |evrWaterUpgrade(Ph.2) fs rurure | | | || ||| | 1.00 i a jz | Et |____WaTER __|Grassi Booster Station Capacity Upgrade (Ph.1) | Future | | | | | | TT | | zy | [oom | | eet Et |___warer [Teepe Town Water Line Upgrade | Furure | | | S| S| S| TTT TT ; | | | joo | | | feo | | fT | fF ft fy pe toy ty [waren |sivenipricuweterinesconing sf oeuereo | | rT dT dT dT ST dT dT CT CT dT CE CT ee ee ee 21% 2.0% os. 03% TM 10% 05% TM 55% 0.2% em | Jom} | | | | | | fT | ft ft | ft ft | Bey tt 1001.00 3.00 1.00 A 003.00 IMI 3.00 3.00 ewe ee ee |____WaTER __|Grassi Booster Station Capacity Upgrade (Ph.2) | Future | | | | | | | TTR | ey | joo} | | | | | | | | | [ | | [| Beery Pt | Tm |____ WATER __|Smith Creek Reservoir and Booster station (Ph.2) | Furure |_| | | TT TT | ee | joo} | | | {| | | f | | f | ft ft Fe ft ft oP tt Tm 100 1.00 100 400 1.00 1.00 1.00 100 100 1.00 1.00 1.00 1.00 4.00 oo) 3.00.00 a 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 1.00 1.00. AO 9 GGG GG GG GO 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 1.00 1.00. AO 9 OGG GG GG GO 1.00 1.00 1.00 1.00 100 100 100 100 100 100 100 1.00 1.00 1.00 (PENN 2.00 2.co [I 0 +> GG GG GG 1.00 1.00 1.00 1.00 100 100 100 100 100 100 100 1.00 1.00 1.00 (4mm 2.oo 2.co I I MN = GG GO 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00.00 (N= oo :.co (I co 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00.00 (FANN oo :.co I I Nc 1.00, 1.00 1.00 1.00, 1.00 1.00 1.00. 1.00.00, 1.00 1.00 1.00 7.00.00 (ESS 1.00.00 Oc |____ STORM __|29-PALLISER STORMWATER STUDY WesTERN BASIN [compteTe| EM! =| S| S| CT | CTC | Tt | | | | | joo} | | cE UT CE [storm [s3STONeWorkscereeK DRAINAGE Diversion | compuere| (ER || | ETT TT 1.00 i a jsooom} | | | | | | fof of ft yop fe yp tt |___sToRM _|37-TEEPEE TOWN STORMWATER MANAGEMENT UPGRADE] FUTURE ||| ||| RP 076 | 25% (A 25° OG GG OG CC 1.00 1.00, 1.00 4.00, 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00.00 3.00 (MRA) oo :.co I 3 I 1s oc | 2.00 | 7.00 | 2.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 4.00 | 1.00 FRY) 100 1.00 i a joo} | | | UT CE 1 oc | 2.00 | 7.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 Fite 100 1.00 i a joo} | | | UT CE CC 00° 100° 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 QRS 2.00 2.00 (I CG GG GG 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00.00 (MR) a00) 3.00 .oo (I Nc 1.00, 1.00 1.00, 1.00 1.00 1.00, 1.00 1.00 1.00 1.00 1.00 1.00. 1.00.00 QMAQ 00) .0o 1.00] I 3 |__sanitary --_|a3uersrarion#a sf comueve| | ||| ||| | | | | | joo} | | | UT CE [__sanitany [is-evTTRUNKsaNiTaRYsewer Ss [compueve| ||| rm cae Oe joo} | | | UT CE 1.00 1.00 4.00 1.00 100 1.00 1.00 100 1.00 1.00 1.00 1.00 1.00.00 (B= 000) .oo oo (I 1 1.00 1.00 1.00 1.00, 1.00 1.00 1.00 100 100 100 1.00 1.00.00 1.00 (N/m 2.00 2.00 (I 7) GG GO GG |___ SANITARY __|21-CENTRALCANMORESWMGMTPLAN sf compteve| ||| EERE EET =| | |] 1.00 J i joo} | | | UT CE |___sanirary --[22-caTcHMENTAREA2saniranvUrG --[compueve| | ||| ||| lc joo} | | | UT CE CECMCCEC MC MCMCMECMECMECRECEECE © fcmere | | [oom | | | | | | Ftttrtrrtttyttrrtttytyrety ty |___ sanitary [as-avrseweruecrave compere] =| | S| S| S| Ct | | Tl joo} | | | UT CE |___ sanitary [26-newiscatcHmentarea2 compere] || | | eT | | EO joo} | | | UT CE [__sanrrany_[27-FORCEMAINFROMNewisTowwre ------=--sfcommuere| || | | ho) | CUT TT | Ez | | | joo} | | | UT CE 1.00 1.00 1.00. 1.00 1.00, 1.00 1.00 1.00 1.00 1.00 1.00 1.00. 1.00 4.00 00) oo 00 |___sanitary _|ai-BvrReueFFORceMAIN Ss fcomueve| | S| S| S| ||| oo) 1.00 i a joo} | | | UT CE |___ SANITARY __|32-PALLISERSANITARYTRUNKLINE Ss fcomueve| ER ||| | TT | | | | joo} | | | UT CE |__sanitary |aaurrsrarion#10 i fcommueve| | | TT TT | Ey | joo} | | | UT CE 1.00 1.00 1.00 1.00 100 100 100 400 100 100 1.00 1.00 1.00 1.00 00) +00 1.00 C7070 GO GG GG GGG GG 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 00) +00 +00 I C7071 GG GG GG GGG GGG 1.00 100 1.00 100 1.00 1.00 100 100 100 100 100 100 1.00 1.00 oes rr 1.00 1.00. 1.00 1.00, 1.001.001.0010, 1.00 1.00 1.00 1.00. 1.00 1.00 00) 0.00 |___ SANITARY __|49-UIFTSTATION#1 PUMP UPGRADE [commueve| | | | | | TT] | | | | | | joo} | | | UT CE 1.00 1.00 1.00 1.00 100 100 100 400 100 1.00 1.00 1.00 1.00 1.00 oo) +00 +00 C079 OO GG GG GGG GG 1.00 1.00 1.00 1.00 100 100 100 100 100 100 1.00 1.00 1.00 1.00 00) +00 +00 I C7071 GG GG GG GGG GGG 1.00 1.00. 1.00. 1.00 1.00 1.00 1.00 1.00 1001.00 1.00 1.00 1.00 _ 1.00 00) +00 5.00 (C1070 GO GG GG GGG GG |___SANTARY __|S9-UIFTSTATION#2UPGRADE sf commueve| =| | | | S| || TT] Ez | | | joo} | | | UT | 1.00 1.00 1.00 1.00 100 100 100 400 100 100 1.00 1.00 1.00 1.00 00) +00 1.00 (0 20> OA GG GG GGG GG 1.00 1.00 1.00, 1.00 1.00, 1.00 1.00 1.00 4.001.001.0010. 1.00 4.00 oo) 3.00.00 a 20 |___ SANITARY BVT Wastewater Upgrade(Ph.2) | rurure | | | S| S| SR || ||| 1.00 i a | oom Fy | | | | | tf fy tt |___ SANITARY [BVT Wastewater Upgrade(Ph.3) | Furure | | | | S| || TTT | | | | joo | | | | Foy oT fy | Ff ft } fF ft ty fe ft ye ty |___sanitary _|isi1-Upgrade(pha) sf rurure | || TTT TT | Ey | joo | | | | Boat fT | fy ft fy ft tf ye tt |___sanitary _|ts8-Capacity Upgrade sf rurure | | | | | TTT | ey | joo | | | | {| | | [ Fey fy | fy ty ft fy tt |__sanitary |isio-Upgrade srr | || TT TT | ey | joo | | | | | | | [ | | [| Bey oy ye tf ye tt [--sanrrany --_awaasivaciesiieraadiion sf oeuereo | TT TT TTT TT TT ee ee ee ee 100 1.00 100 400 1.00 1.00 1.00 100 100 1.00 1.00 1.00 1.00 4.00 oo) 3.00.00 32% 325 33 1.00 1.00 1.00 1.00 100 1.00 100 100 1.00 100 100 100 100 1.00 oo 1.00 i mo 1.00 1.00. 1.00 1.00 1.00 1.00 1.001.001.0000 1.00. 1.00 1.00 _ 1.00 1.00 1.00 A 2c oc Schedule 4: Reserve Balances, Cash Flows Revisions FUTURE ESCALATION Date: 05-Dec-25 Levies & Project Growth [3.600% inflation Target Median CPI Final Dec 5, 2025 Workup ( Rates used in Bylaw) CARRYING CHARGES Input Values Reserve Surplus Click: Bank of Canada Prime Less 1.75% Reserve Deficit Click: Treasury Board of Alberta - Month Rates (25 Yr) SERVICE DEMAND FACTORS CATEGORY TRANSPORTATION _ WATER SANITARY STORM RECREATION FIRE POLICE LIBRARY Commercial [oi] 200 +~| 130 + 130 | 200 | 200 ~~ 200 | 200 | 2.00 | Hotels Residential - Low Density Residential -Medium Density [oa | 075 | 1.00 | 100 | 07s | 075 | 075 | 075_| 075 _| Residential - High Density RESERVE TUNING TRANSPORTATION WATER SANITARY STORM RECREATION FIRE POLICE LIBRARY SUMMARY OF LEVY RATES BY ZONE TRANSPORTATION Project Costs Less: Grants & Project Balance Future Dev OSL Share Less: Receipts & Interest = Off Site Balance =) cm) [52255555] Existing Development Municipal Share OSL Receipts & Int to Dec 31 Cutoff | $3,207,177, | $o ----si|_--$3,207,177_| - Project Act ($3,989,432) I ; (OSL Allocation to 'Financing' Dec 31 Cutoff - Interest Act ($7,481) x (Times) Dev. Adj. Project Start Debt (n.incl Trans to Reserve) + Grants $o Dev % Alloc (Reserve) + Contributions 0] => + (Add) = Front End (Transf. to Oper.) | Year | __--Receipts__-- | Expenditure | Interest | Balance | [2003 | szs0gi3| S| _--Sa0s.sr7| $2,049,308 | TRANSPORTATION | 2024 | $239,226] ($3,969,500)| _($93,292)| _($1,774,223)] $3,000,000 | 2025 | S2a7zs| SO] (S84,714)] (51,611,099) | 2026 | S256 760] SO] (575,166)| _(51,429,505)] 000,000 | 2028 | S275sgo] SO] (S126,757)|__ (52,410,664) | 2030 | $295,779 | (52,321,806)| _($236,937)| (54,506,072) [2031 | $306,27| $0 | _(5233,080)| ($4,432,726) [2082 | __sai7ase| $0] _(228,397)| (54,343,665) s0 | 2033, --=--«|| ~--SsiS32age6| So] ----_--($222,820)| _($4,237,599)] 1 2 3 4 5 6 7 8 9 10 i 12 13 14 #15 16 #17 #18 #19 20 21 22 23 2/25 [2034 | __saa0,r6 | ____ $0] _S216,276)| (54,113,149) | 2035 | $352,992] SO] (5 208,689)] (53,968,845) (900,000) [2036 | $365,700 | $0] _(s199,975)| ($3,803,120) | 2038 | $392,505] SO] (S178,810)| ($3,400,606) [2039 | $406,635 | $0] _(166,165)| ($3,160,136) | 2040 | Saznz7at So] (S152,007)| _($2,890,870)] ($3,000,000) | 04a | $436,439] SO] (5136,221)] (52,590,654) J 2042 | Saszasaf So] (S8.687)| ($2,257,187)] | 2043 | Sa6g.az9] SO] (S99,276)] (51,888,034) (eae 000) | 2044 | Sassz92| SOT (577,852)] (51,480,594) | 2046 | S520g62] SO] (528,374)| ($539,613) WATER Project Costs Less: Grants & Project Balance Future Dev OSL Share Less: Receipts & Interest = Off Site Balance =) comm) [$7072.55 Existing Development Municipal Share OSL Receipts & Int to Dec 31 Cutoff | $8,390,061 | $0 | $8,390,061 | - Project Act ($17,188,415) l 7 OSL Allocation to 'Financing' Dec 31 Cutoff - Interest Act ($4,080,958) x (Times) Dev. Adj. Project Start Debt (n.incl Trans to Reserve) + Grants $4,319,501 Dev % Alloc im (Reserve) + Contributions 0) = + (Add) = Front End (Transf. to Oper.) | Year| Receipts | Expenditure | Interest | Balance | | 2023 | Sa38zes1] SO] Stat | _ $195,642 | WATER | 2025 | $1,483.94] ($30,364)| ($538,570)| ($10,242,537) [2026 | _s1ss7.a17 | ____(9564,685)] _($514,474)| _ (59,784,279) [2028 | $1,550,104 | $0] ($388,280)| (57,384,320) ' [2029 =| ~--s17o9sos] = S| ~----_(514,952)| _($5,989,764)| 2 3 4 5 6 7 8 9 nu 1) 13 14 «15 16 17 18 19 20 2 22 «23 «24 fs [2030 | s1,774,050| $0] _($234,139)| ($4,452,853) [2031 | __$1.834,08[ so] __(S145,302)| (52,763,347) | 2033 | $1,969,292] SO] $57,712] $1,116,650 | [2034 | 2,000,186 | $0 $17,048 | $3,328,884 | | 2035 | $2,913,633] ($19,536,552)| _ ($782,219)] ($14,876,254) [2036 | sz.asarea| $0 | _($704,102)| (513,390,633) fueoooen) [2038 | 2,350,222 | _(s1.101,7e)] _(S651,415)| (512,388,613) | 2039 | $2,434,830] ($1,802,810)| _($652,491)] ($12,409,084) | 2040 | $2,522,484] ($6,513,045)[_($910,180)| ($17,309,826)] [2002 | $2,707,372 | $0] _(s710.667)| (513,515,486) 2003 | __$2,80837[ so] __($584,aan)| ($12,305,090) [2004 | $2,905,811 | $0] _(Sa66,160)| -- ($8,865,239) | 2045 | $3,010,420] SO] (S324,954)] (56,179,972) ($20,000,000) [2086 | _$3.ata.705[ so _(S169,805)] ($3,231,072) en Schedule 4: Reserve Balances, Cash Flows Revisions SANITARY Project Costs Less: Grants & Project Balance Future Dev OSL Share Less: Receipts & Interest = Off Site Balance ---- mms) [ $157,111,000] Existing Development Municipal Share OSL Receipts & Int to Dec 31 Cutoff | $18,347,408 | $O | $18,347,408 | - Project Act ($40,473,169) l 7 OSL Allocation to 'Financing' Dec 31 Cutoff - Interest Act ($8,192,531) x (Times) Dev. Adj. Project Start Debt (n.incl Trans to Reserve) + Grants $4,423,670 Dev % Alloc im (Reserve) + Contributions 0) = + (Add) = Front End (Transf. to Oper.) | Year | _Receipts__| Expenditure | Interest | Balance __| | 2023 | $2,848.25 | ($1,183,458)| _($747,041)| ($14,207,230) SANITARY [2024 | 2,950,968 | __($210,256)] _($66s,692)| (512,736,209) s0 | 2025 | ~----$3,057,203| ~~~ Sof --_--($537,185)] ($10,216,191)] 1 2 3 4 5 6 7 8 9 10 41 12 13 4 15 16 417 #18 #19 20 21 22 23 24 f25 [2026 | $3,167,262 $0] _(s391,216)| _ ($7,420,145) [2023 |__$3521,780 | _($1s,a11,677| _(e1,68,407)| (622,221,554) | 2030 | $3,648,573] ($16,380,897)| __($1,939,940)|($36,893,819)] | 2031 | $3,779,922] ($17,281,132)|__($2,796,924)|($53,191,954)] ($20,000,000) | 2032, | $3,915,999] SO] (S2,734,815)] ($52,010,770) [2033 | __$4056975[ so] _($2,661,a36)| (850,615,223) | 2034 | $4,203,026] S| (S2,575,877)| (S48,988,083)] | 2035 | 94,354,335 | (s910.177)| ($2,527,688)] ($48,071,613) fnennee) | 2036 | S4sazo1| S| ($2,417,609)| ($45,978,131)] | 2038 || S48ai736[ SO] ($2,205,705)| ($41,948,137) ($40,000,000) | 2039 | $5,016,038] SO] ($2,049,732)] ($38,981,834) [2040 | $5,196,616 | $0] _1$1,875,075)| ($35,660,295) | 2041 | $5,383,604] SO] ($1,680,354)| ($31,956,952)] | 20az | 85577507] $0] ($2,464,059)] ($27,843,505) (0.000000) [2003 |__$5,778207[ $0] ($1,224 619)| (523,289,227) [2004 | $5.986,16| $0] _($960,345)| (518,263,856) | 2046 | $6,425,080] SO] (5350,004)| ($6,656,392)] eo sANITARY STORM Project Costs Less: Grants & Project Balance Future Dev OSL Share Less: Receipts & Interest = Off Site Balance =) ET Existing Development Municipal Share OSL Receipts & Int to Dec 31 Cutoff | $1,217,016 | $o | $1,217,016 | - Project Act ($1,546,788) l 7 OSL Allocation to 'Financing' Dec 31 Cutoff - Interest Act ($320,031) x (Times) Dev. Adj. Project Start Debt (n.incl Trans to Reserve) + Grants $o Dev % Alloc i (Reserve) + Contributions 0) = + (Add) = Front End (Transf. to Oper.) | Year | _Receipts__-- | Expenditure | Interest | Balance | P2003 | e560] (5555,000) (56.50) 151073553] STORM [2024 | $52,068 | ($359,363) _($7419)| (51,415,307) s0 | 2025. | --s953a2}--=SSS*=«S |= $73,256)) ($2,393,180) 1 2 3 4 5 6 7 8 9 10 41 12 #13 14 15 #16 417 #18 #19 20 21 22 23 «24 fas | 2029 | St09,877 | (sa78279) _(S92,378)| ($1,756,840) J 2030 | S933] SOT (S9n187)| ($1,734,195)] ($600,000) [2031 | ___s17930[ so] __($89,703)| (52,705,960) | 2032 | S22a76] SOT (S87,900)| _($1,671,691)] ($800,000) [2033 [size sra[ so] _(385,75a)| (52,620.87) [2034 | __sisaiai|______ $0] ($03,236)| (51,582,975) | 2035 | Sa35as2] SO] (S80,315)] ($1,527,439) a [2036 | __$100,74|___ $0] ($76,962)| (51,263,658) (2200000) [2038 | __sisaose| $0 ($68,816)| --_(S1,308,749) | 2039 | Sas6a96| SO] (563,950)] ($1,216,203) ($1,400,000) [2040 | $162,130 $0] ($s8.s01)] ($1,212,572) [2042 | sia | $0) 5a5,677)| 15868, 685) | 2043 | Sasoz7g| SO] (S38,207)| ($726,624) ($1,800,000) [2004 | $186,768 | $0 ($29,962)| ($569,817) | 2046 | S200asa| SO] ($10,920) ($207,674)] estorw FIRE Project Costs Less: Grants & Project Balance Future Dev OSL Share Less: Receipts & Interest = Off Site Balance ---- cms) [$04,575,000] Existing Development Municipal Share OSL Receipts & Int to Dec 31 Cutoff | $380,923 | so | $380,923 | - Project Act ($15,901,532) l 7 OSL Allocation to 'Financing' Dec 31 Cutoff - Interest Act so x (Times) Dev. Adj. Project Start Debt (n.incl Trans to Reserve) + Grants $o Dev % Alloc im (Reserve) + Contributions 0) = + (Add) = Front End (Transf. to Oper.) | Year | _Receipts__ | Expenditure | Interest | Balance | | 2023 | $400,123] ($159,183) _($75,803)| ($1,441,632) FIRE | 2025 | Sa29asi| SO] (S36,333)] ($690,994) [2026 [saan [ $0 _(si3.657)| _5250,737] [2008 | __sarzsza|_____$0| $37,587 | _$727,264] om [2029 |___sasariz[ so | __ $05,508 | $1,288,572 | [2030 | __$s12s22| $0 $98,160.| $1,899,255 | [2031 | __ $30,972 | __(5095266)| $78,205 | $1,513,166 | so [2032 || ~--Ss$550,087| ----_(54,639,932)| __($143,006)| _($2,719,684)| 1 2 3 5 6 7 8 9\ 10 41 12 13 14 #15 16 17 #18 19 20 21 22 23 24 25 | 2033 | $569,891] (54,806,969)| ($386,100)] ($7,342,862) [2034 | $ss0a07| $0) _($374,761)| (S7,77,217 | 2035 | Setteci] SO] (S361,613)] (6,877,169) meee) [2036 | $633,681] $0] _(s346,514)| ($6,550,002) | 2038 | Seaota7] S| (5309,839)| ($5,292,530)] ($4,000,000) | 2039 | S70aei2| SO] (5 287,929)] (55,475,848) [2040 | __$729,578 | $0] 263, 396)| ($5,009,266) | 04a | $756,257] SO] (5236,042)]| ($4,489,050) | 2042 | S7a3aga| So] (5205,659)| ($3,911,227) ($5,000,000) [2003 | __setsea[ so __(s172,02a)| (53,271,560) [2004 | $eao,s09 | ______ $0] (s13401)] (52,505,557) [2006 | S024] $0] ($aa,266)| ($935,035) RECREATION POLICE LIBRARY Schedule 4: Reserve Balances, Cash Flows Revisions REVISIONS, ASSUMPTIONS, NOTES 1)} 25-Jul-25 |Replication model for Town of Canmore 2024 Amendment OSL Bylaw. This model does not use discrete staging over 25 years, rather it only uses an annual average development rate. See note 2) regarding matching of rates. 2)| 16-Sep-25 3)| 28-Aug-25 _|Improved allocation of interest charges per project. Total interest, cash flows etc. remain unchanged. 4)| 29-Aug-25 |Calculations of the Off-Site Levy rates in this model will inherently be the same as the Town's proprietary model (essentially the same results can be generated), however the EXCEL formulas used between the two models will be different because EXCEL uses formulas to not just "CALCULATE" data, but also to "LOCATE" the data. Since the Town's proprietary model uses 75 worksheets and performs a few other functions, it requires 1.25 million formulas to operate. In contrast the rate replication model uses 3 worksheets and only 25,000 formulas (98% less). The same applies to the example calculation shown in the EXAMPLE CALC worksheet, where the mathematical operations applied are the same, but the formulas are different because all data is stored in a single worksheet and only one simple project is used. 5)| 02-Sep-25 _|Replaced word "Operating" to "Financing" in the context of transferring money from reserve in order to fund Project financing. The word "Operating" was a legacy term that does not properly indicate use of collected levy funds. 6)| 08-Sep-25 7)| 08-Sep-25 8)| 08-Sep-25 9)| 16-Sep-25 |Replaced word project "Benefit Areas" to project "Zones" in Example Calculation. 10)| 22-Sep-25 |Replaced word "Areas" to project "Zones" in all worksheets. Renamed "Projects" sheet Column 1 from "Area" to "Infrastructure / Facility". 11)| 08-Oct-25 12)| 08-Oct-25 13)} 08-Oct-25 |Column title for "Total Levies Collected to Date" has been clarified to say "Total Levies Collected to Date (Assumes all installments paid)" to indicate that ALL installments are being recognized in the given year, even though the developer may only have actually paid one or two installments. This is only possible as the remaining balance is typically secured by a letter of credit. 14)} 08-Oct-25 __|Nov 28: Changes below are cancelled and have been reversed back to what is shown in the 2024 Bylaw based on best estimates at time of 2022 year end cutoff. The exception is the Smith Creek Reservoir and Booster Station which has intentionally been pushed out to 2035 as per Note 19. "oa 17) 18) 19) 20) 21) "Intermediate Transfer Pump Capacity Upgrade" project is no longer required. All collected funds ($171,084.43 as of the end of 2022) have been transferred to "WWTP Discharge Limit Upgrade" following decision by BOWDA on Nov 29, 2025 during consultation meeting. Any additional collected amount between 2023 and 2025 will also be credited to the WWTP. 22) "Silvertip Trail Waterline Looping" project is no longer required. Funds collected will be refunded back to the development community. 23) "WWTP Third Clarifier Addition" project is no longer required. Funds collected will be refunded back to the development community. 24) 25) | | Intentionally Left Blank for "Total" ====> 26) 27) Added clarity to Project # Columns to show: Plan Project #s (ie; UMP), Departmental Project Numbers and Budget Project Numbers. " | a All Zones Rate Impact -- Zone 14 Only Rate Impact PO a ~~ 30) Future development " Third Clarifier Removal, increase Zones 13, 14 & 18, - N -- : 31) 13% Influent, UV, Zone 14 / 18 Split, Wetwell DMF -52% Adjustment, -0.4% | 32) Intermediate Po i esr sree 33) Smith Creek -- Cancellation, -0.1% Reservior | | Third Clarifier construction start 3a) Removal, -8% 2035, -0.7% | Grassi Booster (W5) = project zones %'s, -0.5% Grassi Booster --S 35) | | (WS) project zones TC 1s, 00% -- aa ome = Intermediate N\ Silvertip Trail mad eaaris 37) Transfer Pump Waterline Looping a Influent, UV, Wetwell & 18, -9% ' Cancellation, -0.2% Cancellation, -0.9% DMF Adjustment, - , Schedule 5: Full Build-Out Development Plan (25 Years) . Future Full Build- one # . Units [44 [Commercial C--~--~iTSC"'C;SC CztzOOT N p42 Hotels SCSC~--CSCSSSCSCSC~SC«97.00 | A [1.3 |Residential- Low Density [|S _--i [1.4 |Residential- Medium Density [300.00 | [4.5 __|Residential-High Density --s«[ Si | 40.5 |Residential-High Density --=«[ SS _--i [44.4 [Commercial CTC C*d P42 Hotels COC~--"--sSCS~sSC"' CSS C~* [44.3 |Residential-LowDensiy «| SS [44.4 |Residential- Medium Density _[_____--_--_--27.08 | [44.5 __|Residential-High Density --=[ SS _--i [42.4 [Commercial CdECCCSC~CC*d [422 [Hotels COC--"--*~s*~dYSC"'SWCC*d [42.3 |Residential-Low Density --s<[ SS --i [42.4 |Residential- Medium Density [S| [42.5 |Residential- High Density --s«[ SSS _-- [13.3 |Residential-LowDensiy [i [43.5 |Residential-High Density [| [44.4 [Commercial CT SSSCSCSC«*TOS-OD | [442 [Hotels COC~--"--~sYSC"'(CSC C* [44.3 |Residential-Low Density --s«[ SSS _-- [44.4 __|Residential- Medium Density [| ______487.00 | [44.5 |Residential-High Density --s«[ SSS _--i [45.1__|[Commercial CTC C*d [452 [Hotels CSC~"--~*CS*~sYSC"' CSS C* [45.3 |Residential-LowDensiy =| SS | 45.4___|Residential- Medium Density [= --_--| [45.5 |Residential-High Density [S| 46.1 '([Commerciad CCC C=*d [46.2 [Hotels SC~--<"--~C--s~sdTSCSC'CSCC2O5;«OOO'Y [46.3 |Residential-LowDensiy--s=[ SS _--i [46.4 ___|Residential- Medium Density [= _| [46.5 _|Residential- High Density --s«[ SS _-- | _47.3___|Residential-LowDensiy [Si [47.5 __|Residential-High Density --=[ SS _--| [48.4 [Commercial CdTSCSCSCSC*C« BT [482 «(Hotels COC~--"--~*~C*~dTSC"'('CS C* [48.4 __|Residential- Medium Density [426.00 | [48.5 _|Residential- High Density --=<[ SS _--i Schedule 6 Town of Canmore -- Off-Site Levy Project November 27, 2025 Summary "Water_| Linear | Wi | TeeBee Town Waterine Replacement (| Residual Value Galcuiaton __--=«t~--=SC*~*~«tGOUGOD|SC*C*SSC*dS=C"'éOW®SOOOC| CS "Water | Facies | _W2 | Smith Creek Reservoir and Booster Staton | 100% Developer Cost. --=S=~=~*~dCS*~'~*~ésTQTBOCOOO'|SCSC:~SCS*~"'~*'"*sCS*~'~'OHSC"'(TSO®#C#™S™SCSC*~*«d* Water [Facies | W6 | Grassi Storage Reservoir Capacity Upgrade | 100% Developer Gost. ----=S=S=S=~*~--SCS*é'"~*~«S SGWGOSC*C*'CS*C#*'<(']#C#SA"'#('S"N(éS_~SsSs~="'idCS*'"';*éSSCSC*d "Water Facies | _W7 | Grassi Booster Station Capaciy Upgrade (Phase 2) [100% Developer Cost --=--=SSS*dYC*~"'"'*'«SQOODYTSCO™C*'"SS*S*~'(;CT~#C*~«GSOS*~«<'('<'<C*sm CY "Water | Facities | WE | Smith Creek Booster Station Upgrade (Phase 2) | 100% Developer Cost --=s=~=~'iSCS*~'"'*~*~éTQOQOOO*YU;™SCOC*'SS!OW#*#*s;~C'é'CO®™SOC™*~C*~'t*™"'#NNNNNNC._ "Sanitay | Linear | Si | Bow Valley Trail Sewer Upgrade =~ Residual Value Calculation. _--~=~==SC*~*~«wTBOOCGO|SSC*C*C«MSSSC*dC"'sCNM™:~=O~=O«| CS "Sanitary | Facies | _S2__| iftStation 11 Upgrade Phase ___--_--~( 100% Developer Cost. ----SSSSC*dYC=SC*~"'ZOODTCOC*C*'SS#O#*d';#~C*~'"OO*SOC*~*~"'('COCCSC™CO#*@d' "Sanitay | Facies | S8__|Lif'Station 8 Upgrade --=S=S=S~S*S*~*~*S*~si*O0% Developer Cost ----=SSCSC*~*~"'*'"z;CSS*~*«sCOOOOO?Y™SC*'"'CNSS™C#C#*#'"(]#W"#ST<N#CONNG~S=<"'"LSOW#*'éCMS™SSC*'d' "Sanitary | Facies | 5 | LiftStation 11 Upgrade Phase? __--=~=~=~=«i* TOO Developer Cost --SSSS*dY=SSCSC*~*~«éSTOQWODT:COC*'SS*CO#*~«*d;*~C*«'"'(OMSO#*SSO™*C'CNSCOW#C#C*'d' "Sanitary | WWTP |__| infuent ewe --SSS~S~*~*~sCTOON Developer Cost ----=SSSCSCS*~*~*~dC*'"'C;C*'*RGOQODST:CO™*C*'SS*O#*'d'(*#N#"'"'O'N#OOOC*d;~=C'éC#OSNIG*=OC~*C*d' "Sanitay | _WWTP__| | Inlet Screen Upgrade ----=S~S*~S~*~*~S*~*~siOO% Developer Gost ----=SSCS*~*~"'*'"z;CSC*«IOSOOO?Y™C*'"'CNSS#O#*#*s;C(C'C(#SNOMHSCO*~*~*d'C~C;i'SNNNW®"~~=C' "Sanitay | _wwre | -|UV3UpgadeSSS*~*~*~*~*~S*S*~SOOM Developer Cost ----SSSCSCS*~'C"*é'"'*«SOOWGO'SC"C*C*'"'CNCSO#C#C*C*''#'_"'#CW'C&CWQ~--SC*'d(™S("C'CO&N® CS "Sanitary | WWTP__| | WWTP Discharge Limit Upgrade - Phase |__| Incremental Upgrade GostAlocation | __--s07.919,000/ 40% ~--=«|~=S=SC=iDHC«dS=SC('iM! CC site LevyZone Ce: : ae "Water [Linear | Wi | TeePee Town Waterine Replacement =| =| ~SSi| S| S| Sd (id) CCCTCTTC|CUT CPC TCC CT "Water_| Faciies | _W2 | Smith GreekReservoirandBoosterstaon | | | | | | | | | |_| | | | |_| <(m "Water_| Linear | WS | Grassi Booster Staton Waterine Twinning _--(paai@a20%| | ----«|~=S=«=idOmMm Ose) --((Omjosm) | ~--=«dSSMmfomee)| '(oem OSH 6.7% | "Water | Faciities | W7 | GrassiBooster Staton Capacity Ungrade (Phase) | | | | | | | | | | | | ----_- | | iz "Water_| Facies | _W8 | Smith Greek Booster Station Upgrade (Phase) | | | | | | || | | | || ~+i| | | | ie "Sanitary | Linear | 81 | Bowley TralSewer Upgrade --S)~SSiYSd|SCdS CC C'idz | |CSCTCTCTCTCTTCU|C ]T TC UTC "Sanitary | Facies | S2__[LiRStaton 11 Upgrade Phase1 ===] S| S| ST S| S| SS) SCTSCdTSCTCSCdT SCC CCC Cid "Sanitary | Facies | $3 [LitStation Upgrade ----=SSSSCS=~="~*~"--*é~sS*~'(SdT'SCédY'S=SC'(L's~Sd|sSd|sSC| Sd SCdTCCtC'dT|s'(H:*éC*dz TCC|CSCOd 'Sanitary | Facies | S4 _[LitStation 10Upyace ----=SS~=~"--~*~*é~--SC"'('.|SSCédT~SC«dT S| S| Sd] ST SCSCStidYCtédYT(t'ir CU "Sanitary | Facies | 85 | Lit'Staton 11 Upgrade Phase?) Te schedule 7 - Service Demand Factors Overview Not all development types (Residential, Hotel, Commercial) place demand on Town infrastructure and facilities to the same extent. Consequently, specific adjustment factors were developed to more fairly recognize and attribute true utility needs for each development type. These adjustments are called Service Demand Factors (SDF's) and form a critical part of setting the off- site levy rates. A basic representation of how a basic off-site levy rate is calculated is shown below: Town of Canmore Project Cost % Attributable to Growth Divided Adjusted By Cost Future Remaining Unit of Development Units Development Off-Site Levy Rate However, this basic off-site levy rate does not differentiate across various development types (Commercial, Hotel, Residential) and requires additional detail to fairly allocate project costs attributable to growth for these developments. 1|Page When future development projections for the different types of development are combined with weighting factors or Service Demand Factors (SDF), this allows for a more accurate reflection of the intensity that future development places on the Town's infrastructure and facilities: Cost Attributable to Growth Divided By SDF Adjusted a Base Rate Residential Units (x Residential SDF _] Commercial Units [x Commercial SDF ] Adjusted (x Commercial SDF | Commercial Rate Utility Service Demand Factors Utility Service Demand Factors for the impact that Commercial, Hotel and Residential development has on Water and Sanitary infrastructure have been extracted from the 2022 Utility Master Plan (UMP). The following UMP Table 3-18 identifies the water system unit demands for Residential, Hotel and Commercial (ICI / Industrial Commercial and Institutional) development types: Table 3-18 Water System Unit Demands 30 m*/ha/d ICI 810 L/unit/day 2|Page To evaluate the relative impacts, the units of measurement such as L/c/d (Liters/capita/day) must be first converted to a consistent basis such as L/Unit/d (Liters/Unit/Day). Using a standard consistent with the UMP and previous planning directives, Residential development is assumed to have 2.5 people per unit, as follows: e Residential development: 250 x 2.5 people per unit = 625 L/unit/day e Hotel development: = 700 L/unit/day e Commercial development = 810 L/unit/day The following Service Demand Factors (SDF) can now be determined Water and Sanitary infrastructure, relative to the Residential development rate of 625 L/unit/day. e Residential SDF = 625 / 625 = 1.0 e Hotel SDF = 700 / 625 = 1.1 e Commercial SDF = 810/625 = 1.3 The Service Demand Factors can be found in Table 2 of the Off-Site Levy Bylaw. For other infrastructure such as Transportation, Storm or Fire facilities, Service Demand Factors have been determined through consultation and agreements with the development community. 3|Page