This is the exact embedded text of the captured official document.
Snapshot d40d0b27d04d · verified 2026-10-22 ·
original document ·
archived snapshot ·
unofficial consolidation, the official version is held by the municipal clerk.
mt 1 City of
# Brooks
CITY OF BROOKS
BYLAW NO. 23/18
A BYLAW OF THE CITY OF BROOKS IN THE PROVINCE OF ALBERTA TO
AMEND BYLAW 21/24 BEING A BYLAW TO ESTABLISH OFF-SITE LEVIES
FOR LAND THAT IS TO BE SUBDIVIDED OR DEVELOPED WITHIN THE CITY
OF BROOKS.
WHEREAS, it is desirable to amend Bylaw 21/24 being the Off-Site Levy
Bylaw;
NOW, THEREFORE the Council of the City of Brooks in the Province of
Alberta hereby enacts as follows:
1. That Subsection 233 be deleted in its entirety and replaced with the
following:
233. "Report" means the City of Brooks: Offsite Levy Update, August 28,
2023, attached as Schedule "B" of this Bylaw;
2. That Schedule "B" of Bylaw No. 21/24 be deleted in its entirety and replaced
with the attached Schedule "B'.
3. That this Bylaw take effect upon final passing thereof.
Read a first time this 4'° day of December, 2023.
Read a second time this 4" day of December, 2023.
Read a third time and finally passed this 4'° day of December, 2023.
or
"> 4 --S
Chief nia Officer
Brooks
CITY OF BROOKS
City of Brooks 2023 Offsite Levy Update
TABLE OF CONTENTS
1.1 Background.........ecceceseeeeseteeesesessssseetsssssssssssssssees 003
1.2 Methodology...........cccccccccesssesssssssessssssssssssssssssssssssstsstsees O03
2.1 Offsite Infrastructure COStS..........ccceeseseeeeseeseessssessesseee, OO4
2.2 Offsite Levy Areas and Forecasted Development..............005
2.3 Offsite Levy Collections...............cccccssessssssssssssssttsttetteeesees, OOS
2.4 Offsite Levy RESErVES.............cccccseeeseessseessssssssssssssssstteesees OOS
2.5 Interest Rates/Financing ASSUMPTIONS.............:0cceeeseeeeees O06
APPENDIX A: OFFSITE LEVY ARES AND LAND STAGING.................0200+2,008
APPENDIX B: TRANSPORTATION OFFSITE INFRASTUCTURE...................011
APPENDIX C: WATER OFFSITE INFRASTUCTURE.............ccssseccsssecessseeeeees O15
APPENDIX D: SANITARY SEWER OFFSITE INFRASTUCTURE.................... 020
APPENDIX E: STORMWATER OFFSITE INFRASTUCTURE...............0se0e000. O25
City of Brooks 2023 Offsite Levy Update
1. INTRODUCTION
1.1 Background
The City of Brooks updated their Offsite Levy Bylaw in 2021 using the CORVUS Offsite Levy Model. The
calculated rates were based on information as at December 31, 2020 and are reflected in the City of
Brooks 2021 Offsite Levy Update which forms a part of Bylaw 21/24. Offsite levy (OSL) rates are
dependent on scheduled projects, anticipated development, interest rates/financing assumptions over
the next 25 years. Because these factors can change from year to year, this model should be updated
periodically so that the rates correctly reflect the developers share of costs for future projects that need
to be done to accommodate anticipated developments.
As an update to Bylaw 21/24 was not prepared for 2022, this update reflects changes based on what
actually happened in 2021 & 2022, as well as any changes to assumptions in the future.
1.2 Methodology
The City has various infrastructure capital/master plans, and these plans have been used as a starting
point for developing key information for Bylaw 21/24. For this update, City staff reviewed and revised
assumptions and information which had changed since the adoption of Bylaw 21/24. As a result, very
few changes have been made regarding the scheduled projects, the staging of developable land,
benefits to existing development, future development and benefiting areas.
OSL rates within the CORVUS model are forecasted using a rolling 25-year review period. During this
review, a cut-off date of December 31°, 2022 was established, therefore the review period stems from
2023-2047. The cut-off date coincides with the City's most recent year-end when the update was
prepared. Actual information regarding project expenditures and OSL receipts, up to the cut-off date,
were gathered and used to update the model. Beyond the cut-off date, all financial details are
estimates. When the City completes its next update, information from January 1', 2023 up to the new
cut-off date will be converted from estimates to actuals, and the rolling 25-year review period will move
further out.
Costs that benefit development prior to and within the 25-year review period are included in rates.
Costs that benefit development beyond the review period (called "financial oversizing") are excluded
from the rates. In future years, when rates are updated and the rolling 25-year period moves further
out, offsite infrastructure costs beyond 2047 will gradually be included in rates.
2. KEY FINDINGS
The following provides a summary of key findings pertaining to the updating of the City's OSL rates anda
further breakdown of each of the key findings is provided in Appendices B (Transportation), C (Water), D
(Sanitary Sewer), and E (Stormwater).
003
City of Brooks 2023 Offsite Levy Update
2.1 Offsite Infrastructure Costs
Offsite infrastructure costs to be included in the offsite levy bylaw total approximately $100.26 million.
Special ear-marked grants and contributions, which are deducted from offsite infrastructure costs when
determining the amounts that benefit developers, totaled approximately $36.79 million.
The share of costs which benefits existing/residual development (the City's share) totals approximately
$38.93 million, and the share of costs which benefits future development (the developer's share) is
approximately $24.54 million. However, $5.32 million of this cost is beyond the 25-year review period
(financial oversizing) and approximately $19.22 million is within the 25-year review period and included
in the new rates.
Developer Cost
- . Other Developer
smn i RE) TEE | tem
ontributions Costs (Financial
Share of Costs Oversizi (In Rates)
ersizing)
Transportation $ 3,561,170 $ 1,241,355 $ - § 187,293 § 579.079 $ 5,568,897
Water $ 9598.901 $ 16,090,155 $ - $ 3,778,880 $ 6,669,044 $ 36,136,980
Sanitary $ 22,834,340 $ 19,519,593 $ - $ 807,027 $ 11,122,854 $ 54,283,814
Stormwater $ 792,779 $ 2,077,826 § -__§$ 547.016 $ 853.239 $ 4,270,860
Total $ 36,787,190 $ 38,928,929 $ - $5,320,217 $ 19,224.215 $ 100,260,551
Project updates - In this update there were no new projects scheduled for the 25-year period. There
were however, adjustments to the project cost estimates for the following Sanitary Sewer projects
based on actual costs:
Sewer Main - Old lagoon to Hort Lift station -- This project was completed in 2022 with actual costs
totaling $4,491,726. It has been determined that the developers share is 39.7% of project costs after the
designated special grants of $3,292,623 is deducted.
Sewer Main -- 7th East to Old Lagoon -- This project began in 2022. The total project costs are estimated
to be $4,133,000 and we anticipate special grants $1,239,900, therefore developers will be responsible
for 40.8% of the reduced project cost estimate or $1,179,605. the design portion of this project is
expected to be complete at the end of 2023.
Meadowbrook Lift Station -- A portion of this project was budgeted and completed in 2021 & 2022 for
$196,378. As the model anticipates a wider scope to the Meadowbrook Lift station retrofit to be done in
2025, the cost estimate has been reduced by the work completed. In the OSL model, this project has an
estimated remaining cost of $1,195,290 and 34.08% is the responsibility of future developers.
In addition to these changes, the City had assumed in the 10-year Capital plan (2023 -- 2032) that several
special ear-marked grants would need to be secured before some of the projects would proceed. The
assumption that the City will be receiving these grants was added to the model to stay consistent with
the 10-year Capital plan and reduce the estimated share of costs for future developers.
City of Brooks 2023 Offsite Levy Update
2.2 Offsite Levy Areas and Forecasted Development
In this update, the anticipated development remained the same for each year as in the original model
prepared for 2021. The original assumptions were prepared by the Manager of Planning & Development
and based on a combination of all of the assumptions used in the City's master plans. The City is parsed
into 25 offsite levy areas reflecting the current planning assumptions including the anticipated pace of
development in the community.
As the model is always done based on the next 25 years, it was assumed for the two final years that
were added in this update (2046 & 2047) that the development rate for each year would be the rate
that was used in 2045. As the anticipated development gradually increases from year to year, the total
anticipated development in the 25-year period increased from 181.77 ha (in the previous model) to
186.73 ha in this model.
In the original model (2021), it was assumed that 12.24 ha would be developed in 2021 & 2022. The
actual amount of development for those two years was 1.02 ha.
2.3 Offsite Levy Collections
Before allocating infrastructure costs to benefiting lands, OSL costs must be reduced by the total levies
collected to date. Up to December 31, 2022, the City collected approximately $6.16 million.
| Levies Collected To Date
Transportation $ 644,505
Water $ 2,527,596
Sanitary $ 2,613,098
Stormwater $ 379,385
Total $ 6,164,583
2.4 Offsite Levy Reserves
The reserve balances have been updated for the period of January 1, 2021 -- December 31, 2022 and are
as follows:
| Reserve Balance
Transportation $ 184,559
Water $ (463,819)
Sanitary $ 1,002,723
Stormwater $ 386,997
Total $ 1,110,461
In 2022, several industrial lots were returned to the City of Brooks as the terms of the sale were not
met. The City had paid the offsite levies for these lands in 2018 and added the OSL receipts to the
appropriate reserves. In 2022, when the land was returned, the money was taken back out of reserves
and returned to the City. When these lands are sold/developed, the current charges (OSL model) will be
used for the offsite levies.
City of Brooks 2023 Offsite Levy Update
2.5 Interest Rates/Financing Assumptions
With interest rates increasing and the persistence of high inflation, many financing assumptions were
updated in this model which have a definite impact on the OSL charges. The basis for each assumption
has remained consistent and are as follows:
Offsite Levy charging rates - went from 2% to 5.11%. This is the rate that is applied to a reserve that is in
a negative balance. If the City has paid for projects and is waiting to collect from developers, the reserve
may be in a negative balance and therefore this charge is added on as interest to the developer's
portion. The rate is based on the 20-year lending rate from Loans to Local Authorities. Only the City's
Water Reserve is in a negative balance (as illustrated below).
Offsite Levy earning rates - went from 1% to 5.6%. This is the rate that is applied to all reserves with a
positive balance. If the City has collected OSL receipts from developers and not done or completed the
project in which they collected for, the reserve would be in a positive balance and be subject to earn
interest. The rate is based on the Credit Union 1-year GIC rate.
Construction Price Index - went from 3% per year to 4.8% for years 2023, 2024 & 2025, and then back
down to 3% per year for the remaining 25-year period. This represents construction inflation and is
applied to the cost estimates of each project in the OSL model. The rate is consistent with the Building
Consumer Price Index for Alberta in the 2™ Quarter of 2023.
3. RATE UPDATES
Based on the above updates, assumptions and adjustments, the rates required for future development
to pay for its share of the $100.26 million offsite infrastructure costs contained in the City's capital plans
would be approximately $81,414 per net hectare on a weighted average basis, as shown in the tables
below. This represents a weighted average increase of 2% over the rates in Bylaw 21/24.
Current
Transportation Sanitary
ign SS 35,026 | $ 81.720 $116,746
tow CS S19, 926] 80,764]/S S56 164 |
Weighted Average = TS O'S 23.636 | $ 65,385 | $ 2,393 | $ 81.414
Previous
Transportation Sanitary
High CSC CdS 38,943 | $ 63,739 | $ 13,507 |$ 102,682
a 0 21,751 | $ 29.092|$ ss - «dS 59,322
[Weighted Average ----("<assdT SC - CdS 25.976 | $ 50,143 | $ 3,704 | $ 79,823
Charges Charges
n/a 10.1% 28.2% 6.4% 13.7%
na 8.4% 5.7% na 5.3%
nia -9.0% 10.5% -35.4% 2.0%
006
City of Brooks 2023 Offsite Levy Update
City of Brooks Proposed Offsite Levy Rates per hectare based on development area:
evies Levies Levies Levies
1.0 $ - $ 35.026 §$ 47,779 §$ : $ 82,805
2.0 $ - $ 19.926 § 55.589 $ 5474 § 80.989
3.0 $ - $ 19.926 § 55.589 $ 5474 § 80.989
4.0 $ - $ 19.926 § 47.779 § 5474 § 73,179
5.0 $ - $ 19.926 § 47.779 § 5474 § 73,179
6.0 $ - $ 19.926 § 47.779 § 5474 § 73,179
7.0 $ - $ 19.926 §$ 30,764 § 5474 § 56.164
8.0 $ - $ 19.926 § 47.779 § 5474 § 73,179
9.0 $ - $ 19.926 §$ 47,779 § - $ 67,705
100 § - $ 19.926 § 66.936 $ 12.644 § 99 506
11.0 § - $ 19.926 § 66.936 §$ - $ 86.862
120 § - $ 19.926 § 66.936 §$ 12.644 § 99.506
13.0 § - $ 19.926 §$ 66.936 $ 5474 § 92.336
140 § - $ 19.926 § 66.936 $ : $ 86,862
150 § - $ 19.926 § 66.936 §$ : $ 86,862
160 § - $ 19.926 § 66.936 $ - $ 86,862
170 § - $ 19.926 § 66.936 $ 5474 § 92.336
180 § - $ 19.926 § 66.936 §$ 5474 § 92.336
190 § - $ 35.026 § 61.179 § - $ 96.205
200 § - $ 35.026 §$ 60.135 §$ - $ 95.161
21.0 § - $ 35.026 §$ 66.783 §$ : $ 101,809
220 §$ - $ 35.026 §$ 61,179 §$ : $ 96.205
23.0 §$ - $ 35.026 §$ 81,720 § - $ 116,746
240 § - $ 33,482 § 76.116 § - $ 109,599
250 § - $ 19.926 § 76.116 §$ - $ 96.042
4. RECOMMENDATION
It is recommended that the City of Brooks implement the offsite levy rates outlined in section 3 to be
effective January 1, 2024.
It is also recommended that the CORVUS Offsite Levy Model be updated annually and depending on the
degree of change throughout the year, a recommendation to update the OSL rates in the Bylaw may or
may not occur following each Model update.
007
City of Brooks 2023 Offsite Levy Update
APPENDIX A: OFFSITE LEVY AREAS AND LAND STAGING
The City is Parsed into 25 offsite levy areas, as shown in the map below.
¥ <r -- ss oo 3 [a : Wi : uv: r at a -- ;
ei 3. RNS) ae
: j Al 4 F ' ) ¥> =H Li Dy 4 Ne] ome --| t i: ) , oy
a) RD eR PC =
Sy °c ef. OC 8 Fac \" arg
: . - j =) O=! sy SS * = Age . ~\ =
VY on WB OB - J. of yt ' Ls \ ~
ae" i or me . eee
2 ee "re = BS oN
, ' ; Se wad ' i, A, wy . IS _ - eens
Total net development area, the amount of land available for development in all offsite levy areas, is
approximately 1675 ha. There have been no changes to the net development area since it was
established in Bylaw 21/24.
008
City of Brooks 2023 Offsite Levy Update
Offsite Levy Net Development Area
Arterial
Development Environment Right of Way Net
Area al Reserves and Other |Development
Location (ha) Deductions Area (ha.)
ha.
it |SeeMap | tt tt 197.19 |
_ 21 |SeeMap | 2783] aS] 85 TBO] 244.38 |
_ 31 |SeeMap [HOt FTO BET
_ 41 |SeeMap | 8TH] S38] 75.56 |
_ 51 |SeeMap | ES 92.28 |
_ 61 |SeeMap [BT BT 182 |
_ 71 |SeeMap | 82 O] ROY E283 |
_ 81 |SeeMap | BT BT] BOS] 42 |
_ 31 SeeMap | 23238] 2B 209.14 |
_ 1 |SeeMap [BET ETB] 32.10
_ ii |SeeMap | BT TB] BB] 2.92 |
_ 21 |SeeMap | TY TY O43.
_ 131 |SeeMap | OT
_ 41 |SeeMap | 8383] 88ST 28.26 |
_ 51 |SeeMap | BBB O29] 3] 58.91
_ 1 |SeeMap | HE. 88 |
_ ii |SeeMap |B TES] 183] 105.06 |
_ 181 |SeeMap | 3788 TBS] BS] 24.09 |
_ 191 |SeeMap | tS tT
_ 201 |SeeMap | 2 A881
_ 21 |SeeMap | BHT BT 84.33 |
_ 221 |SeeMap | ZT ZO BES |
231 |SeeMap | BZ] BATE 18.85 |
_ 241 |SeeMap | 92] ATO |
_ 251 |SeeMap | HTS] B] 8.20
| 1923.07] = 23.20] =6189988] 189.99 | 35.05 | 1.674.844 |
Of the 1675 ha. of net land available across all offsite levy areas, approximately 1,010.20 ha. (60%) have
been developed to date, and staff estimate that approximately 187 ha. (11%) will develop during the
next 25-years as shown in the tables below.
Summary of Anticipated Development during the 25 Year Rate Planning Period
Developed To Date 1,010.20 60.3%
Developed In Next 25 Years 186.74 11.1%
Developed Beyond 25 Years 477.90 28.5%
Net Development Area 1,674.84
009
Anticipated Development during the 25 Year Rate Planning Period
Area
Next 25 years
et ha.'
L11 [24.016 [ 0.80 0.82] 083] 084] 085] 06] oss] 089] 090] 092] 093] 0.94] 096| 097[ 099] 1.00] 1.01] 1.03] 1.04] 1.06] 1.08] 1.09] 1.11] 1.11] 1.11 |
(21 [22486 075[ 076] 078] 079] 080] 081] 082] 0.83] 0285] 026] 087] 088] 0.901 0.91] 092] 094] 095] 096] 098] 0.99] 1.01] 1.02] 1.04] 1.04 | 1.04 |
31] 13.023 [ 0.44[ 0.44] 045] 046] 046] 047] 048] 0.48] 0.49] 0.50] 050] 0.51] 052] 053] 053] 054] 055] 056] 057] 057] 058] 059] 060] 0.60] 0.60 |
141] 0313{ 0.01[ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01[ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01 0.01] 0.01] 0.01 | 0.01 |
[51] o6s9{ 0.02[ 0.02] 0.02] 0.02] 0.02] 0.02] 0.02] 0.02] 0.02] 0.03] 0.03] 0.03] 0.03[ 0.03] 0.03] 0.03] 0.03] 0.03] 0.03] 0.03] 0.03] 0.03] 0.03] 0.03 | 0.03 |
161] 0.251{ 0.01[ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01[ 0.01{ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01 |
[71] 1.241{ 0.04[ 0.04] 0.04] 0.04] 0.04] 0.04] 0.05] 0.05] 0.05] 0.05] 0.05| 0.05] 0.05| 0.05| 005] 0.05] 0.05] 0.05] 0.05] 0.05] 0.06] 0.06] 0.06] 0.06 | 0.06 |
(31 [9121 { 031[ 031] 031] 032] 032] 033] 033] 034] 034] 035] 035] 036] 036] 037[ 037] 038] 039] 039] o40] 040] 0.41] 0.41/ 0.42] 0.42 | 0.42 |
(91 [53.640 [ 1.80[ 182] 1.85] 1.88] 190] 193] 196] 199] 202] 205] 208] 211 | 214[ 217 [ 220] 223] 227] 230] 233] 237] 240] 244] 247 | 2.47 | 2.47 |
[101] 0.104 [ 0.00[ 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00[ 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00 | 0.00 |
Le OC a a
ae A A A OS Oe
113.1] 0.238 { 0.01[ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01[ 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01] 0.01 | 0.01 |
1141] 0.017 [ 0.00[ 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00{ 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00] 0.00 |
1151] 1.818 [ 0.06[ 0.06] 0.06] 0.06] 0.06] 0.07] 0.07] 0.07] 0.07] 0.07] 0.07] 0.07] 0.07| 0.07| 0.07] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08 |
[161] 1.122[ 0.04[ 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04 005 00s] oos] oos| 00s] 005] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05 |
Li7z1[ 2.037 [ oo7[ 007] 007] oo7] oo7| oo7| 007] oos| oos] 0.08] 0.08] 0.08] 0.08 |[ 008] 0.08] 0.08] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09 | 0.09 |
L181] 32.045 [ 1.07[ 1.09] 1.11] 1.12] 1.14] 1.15] 1.17] 1.19] 1.21] 1.22] 1.24 | 1.26 | 1.28 [ 1.301 1.31] 1.33] 1.35] 137] 139] 1.41] 1.43] 1.46] 1.48] 1.48 | 1.48 |
L191] 12983 [ 0.43[ 044] 045] 045] 046] 047] 047] 048] 049] 050] 050] 0.51] 052[ 053] 053] 054] 055] 056] 056] 057] 058] 059] 060] 060] 0.60 |
1201] 2.202 [ 0.07[ 0.07] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.08] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09] 0.09] 0.10] 0.10] 0.10] 0.10] 0.10] 0.10 | 0.10 |
L211] 1.417{[ 0.05[ 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.06] 0.06 | 0.06] 0.06] 0.06] 0.06] 0.06] 0.06] 0.06] 0.06] 0.06] 0.07] 0.07 | 0.07 |
[221] 1.509 0.05 0.05] 0.05] 0.05] 0.05] 0.05] 0.06] 0.06] 0.06] 0.06] 0.06] 0.06] 0.06| 0.06] 0.06] 0.06] 0.06] 0.06] 0.07] 0.07] 0.07] 0.07] 0.07] 0.07 | 0.07 |
1231] 2.797 | 0.09[ 0.10] 0.10] 010] 010] 0.10] 0.10] 0.10] 0.11] 0.11] 0.11] 0.11] 0.11 [ 0.11] 0.11] 012] 0.12] 0.12] 0.12] 0.12] 0.13] 0.13] 0.13] 0.13 | 0.13 |
1241] 1.055 0.04[ 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04] 0.04[ 0.04[ 0.04] 0.04] 0.04] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05] 0.05 |
1251] 2643 [ 0.09[ 0.09] 009] oo9] oo9] 010] 010] 010] 010] 010] 010] 0.10] 0.11 [ 011 [ 011] 011] 0.11] 0.11] 0.11] 0142] 012] 0.12] 0.12] 0.12] 0.12 |
| s«[email protected] | 6.26[ 635[ 644[ 653] 663] 673] 682] 692] 7.02] 7.13] 7.23] 7.34[ 7.44 [ 7.55[ 766[ 777| 7.89] 8.00] 812] 824] 326] 848] s60] 860] 360 |
010
City of Brooks 2023 Offsite Levy Update
APPENDIX B: TRANSPORTATION OFFSITE INFRASTRUCTURE
B.1 Transportation Offsite Infrastructure
The estimated cost of Transportation offsite infrastructure required to support future growth is
approximately $5.57 million as outlined in the table below. These costs represent the "gross" costs, of
which only a portion will go to support development during the 25-year review period.
Summary of Transportation Offsite Infrastructure
Future Estimated Cost of r
woe _
ompleted Work Cost
Interest Completed
1 Cassils Road $ 1,732,070] $ - $ - $ 1,732,070
2 |Cassils Road and 2nd Street West $ 3051.427/$ = - [$s - $3,051,427 |
4 |2nd Street West (South) Capacity Improvements $ -[s Ss 785,400] $ 785,400 |
100 [Unallocated Offsite Levies Collected to Dec 31, 2020 $ -|s ss - [Se
$ 47a34o7($ TS 785,400 $ 5,568,897 |
B.2 Transportation Offsite Infrastructure Grants & Contributions
The MGA enables the City to allocate the cost of offsite infrastructure to development, other than those
costs that have been provided by way of special ear-marked grant or contribution. The City of Brooks
has/will receive $3.56 million in special ear-marked grants or contributions for transportation offsite
levy infrastructure as shown in the table below. The total reduced transportation offsite infrastructure
cost is $2.01 million.
Special Grants and Contributions for Transportation Offsite Infrastructure
Developer Other
r Special Provincial Agreement a c
Project Description oth Grants Contributions cone euners Swanpeatans
os (Historic & Future)| (Historic & ( Future) °
Future)
1 Cassils Road $ 1,732,070 | $ 1,178,585 | $ - $ - $ 553,485
Cassils Road_and 2nd Street West |$_3.051.427[$ 2.382585/$ TS S088, 842 |
2nd Street West (South) Capacity Improvements is 7a54oo{s S| SS 785,400 |
| 100 [Unallocated Offsite Levies CollectedtoDec 31,2020, [s_- [S S| Se
is 5s688o7[$ 3.561t70/$ | TSS 2,007,727
011
City of Brooks 2023 Offsite Levy Update
B.3 Year of Construction
The City anticipates construction of transportation offsite infrastructure as outlined in the table below.
There has been no changes to this schedule in this update.
Forecast Year of Construction
Item Project Description
| 4 |Cassils Road 2006
Cassils Road and 2nd Street West 2006
2nd Street West (South) Capacity Improvements 2038
B.4 Transportation Offsite Infrastructure Benefiting Parties
The table below outlines the allocation of transportation offsite levy infrastructure costs to the
benefiting parties.
Allocation of Transportation Infrastructure to Benefiting Parties
Other Developer Share
Item Project Description sae Stakeholder e inanctal eee
Share Oversizi
ersizing %)
1 |CassisRoad 8B | 284% 87 18%
2__|CassilsRoad and2ndStreetWest SS R.842[ 284% P87 18%
4 [2nd Street West (South) Capacity Improvements |S 785,400[ 60.26% | | 28.85% 15.90%
100 [Unallocated Offsite Levies CollectedtoDec 31,2020 [s TT 100.00%
B.5 Existing Receipts & Adjusted Levy Cost
The adjusted offsite levy costs for transportation is approximately $.58 million. However existing offsite
levies have been collected from previous developers, resulting in an adjusted offsite levy costs of $(0.07)
million.
Offsite Levy Funds Applied to Date
. Offsite Levy .
Offsite Levy Adjusted
on) meme rn RE
to Dec 31, 2020 evan' Cost
2021
_ 1 |CassiisRoad CS THIS CCS 2S 205,449 |
__2 |CassilsRoad and2ndStreetWest_ S24 42/$ S738 248,269 |
__4 [2nd Street West (South) Capacity Improvements | S$ 124.862/$ SS 124,752 |
_ 100 [Unallocated Offsite Levies CollectedtoDec 31,2020, |S - = [Sa3g97/S TS (643,897)
$ 579,079 | $ 643,897 [$ 608 | $ (65,426)
012
City of Brooks 2023 Offsite Levy Update
B.6 Transportation Infrastructure Benefiting Areas
Net developer costs for each project have been allocated to multiple benefiting offsite levy areas as
shown in the table below. Allocations are denoted with a "1" below applicable area numbers.
Transportation Allocations to Benefiting Areas
92929229 29 SE SuSE
2 |Cassils Road and 2nd Street West $248,269) 1 a Pata tata ta tata fa fa fa faa fa a ta fafa fafa fafa fais]
3 [Young Road and CP Rail Crossing Improvements |$ - | 4] 4/4] a}atatatatatatatatatatatatatatatatatat ata [a |
4 [2nd Street West (South) Capacity Improvements |$ 124.7521) 1/4 /4/4[a[a[a[alalalalalalatatatata{1f1f[1[1[1fiafi]
ima Aa ee ED
B.7 Account Balance
At December 31st, 2022 the transportation account Balance was in a surplus of $184,559.32. This
amount takes into consideration expenditures and front-ending obligations up to the end of 2022. It also
reflects $9,455.81 of transportation offsite levies that were returned to the City when a sale of industrial
lands was reversed due to the terms of the sale not being met.
B.8 Development and Transportation Staging Impacts
Transportation offsite infrastructure will be constructed in staged fashion over the 25-year review
period.
To compensate parties for capital they provide in front-ending offsite infrastructure construction, a
5.11% interest allowance interest allowance is charged to the account when it is forecasted to be ina
negative balance. Further, a 5.60% interest credit is provided to the account when it is forecast to be in
a positive balance. The graph and table below outline the forecast transportation levy account balances
over the 25-year development period.
Anticipated Transportation Offsite Levy Account Balances
Transportation Reserve
$600,000
$500,000
--~e-- Reserve Balance
$400,000
oe $300,000
$200,000
$100,000
$-
se) ice} fo?) N Ww ioe] = vt ~
N N N Se) Year Se] + x t
oO oO So oO oO oO oO oO
N N N N N N N N N
013
City of Brooks 2023 Offsite Levy Update
Anticipated Transportation Offsite Levy Account Balances
Reserve Balance [$ __ 184,559 |
Year Receipts Expenditure Interest Balance
2023 $ - $ - $ 10,335 | $ 194 895
2024 $ - $ - $ 10.914 $ 205,809
2025 $ - $ - $ 11.525 $ 217,334
2026 $ - $ - $ 12.171 $ 229 505
2027 $ - $ - $ 12,852 $ 242 357
2028 $ - $ - $ 13,572 $ 255,929
2029 $ - $ - $ 14.332 $ 270,261
2030 $ - $ - $ 15.135 $ 285,396
2031 $ - $ - $ 15.982 $ 301,378
2032 $ - $ - $ 16,877 $ 318,255
2033 $ - $ - $ 17,822 $ 336,077
2034 $ - $ - $ 18.820 $ 354 898
2035 $ - $ - $ 19.874 $ 374,772
2036 $ - $ - $ 20,987 $ 395,759
2037 $ - $ - $ 22,163 $ 417,922
2038 $ - $ - $ 23,404 $ 441,325
2039 $ - $ - $ 24.714 $ 466,039
2040 $ - $ 10,869 $ 25.490 $ 480,659
2041 $ - $ 55,977 $ 23,782 $ 448 464
2042 $ - $ 80,719 $ 20,594 $ 388,339
2043 $ - $ 59 386 $ 18.421 $ 347,374
2044 $ - $ 24467 $ 18,083 $ 340,989
2045 $ - $ - $ 19.095 $ 360,085
2046 $ - $ - $ 20,165 $ 380,249
2047 $ - $ - $ 21,294 $ 401,543
014
City of Brooks 2023 Offsite Levy Update
APPENDIX C: WATER OFFSITE INFRASTRUCTURE
C.1 Water Offsite Infrastructure
The estimated cost of water offsite infrastructure required to support future growth is approximately
$36.14 million as outlined in the table below. These costs represent the "gross" costs, of which only a
portion will go to support development during the 25-year review period.
Summary of Water Offsite Infrastructure
Estimated Cost of
F Caer Cost of Future Debenture Total Project
Item Project Description Completed Work Interest Work Yet to be Estimated Cost
Completed
1 |RawWaterIntake CCS BATS dS CS 1,222,871
2 _[WaterTreatment Plant Ci' ~~ h1450000/8 == - [SC - CS 1,450,000 |
3 [WaterTreatment PlantUpgrade CS 2798G|S CC TSC CdS 727.986]
4 [300mm Diameter MaintoFairviewResevior --s| $_--Ss175.000/$ = - [SC «CTS (175,000 |
5 _|WaterResewior CC Ci("'"'('C;CCOCS~O1S34.000/ = [S$ - CS 1.534.000]
6 [Upgrade Filters at Water Treatment Plant ss | S$ 479.050/$ ss - [SC - SCS 479.050]
7 [Water Supply, Treatment & Storage - NRSC $ 6,708,047 S| $ 6,708,047
Contribution and Fairview Reservoir Upgrade
8 _|EastSectorWaterMains Citi' SS 46 026/S CK (SCC SS 16,026 |
10__|Industrial MainLoop-Phase1 CC STCC~";'C*dWSOC"'(®'CNSCT *ULS~----«G 164.000 6,164,000 |
11 Industrial MainLoop-Phase2_-- CCC SC<"<;'"CCdSOC"'('#$TCS N= *LS~----C«G.031,000/$ 6,031,000 |
12___|Industrial MainLoop-Phase3_ tC SC" *dSOCOC"'(#SCNS *LS~----7,045,000/$ 7,045,000 |
13 [Southeast Main Loop - Phase 1 $ -|[$ ss - *[S _--1,186,000]$ 1,186,000 |
14 __ [Southeast Main Loop - Phase 2 $ -[$ TS 1,350,000]$ 1,350,000 |
15 [Southeast Main Loop - Phase 3 $ -|$ ss - '|S 1,648,000]S 1,648,000 |
100 |Unallocated Offsite Levies Collected to Dec 31, 2020 $ -[$ -- - [se IS F
$ 12,712,980[/$ -- -_--~<([$ 23,424,000 | $ 36,136,980
C.2 Water Offsite Infrastructure Grants & Contributions
The MGA enables the City to allocate the cost of offsite infrastructure to development, other than those
costs that have been provided by way of special ear-marked grant or contribution. The City of Brooks
has/will receive $9.60 million in special ear-marked grants or contributions for water offsite levy
infrastructure as shown in the table below. The total reduced water offsite infrastructure cost is $26.54
million.
015
City of Brooks 2023 Offsite Levy Update
Special Grants and Contributions for Water Offsite Infrastructure
Special Pate Other
Total Project {Provincial Grants Contributions | Reduced Project
Ti a coe Estimated Cost | (Historica | Contributions | "(iscica | Estimated Cost
(Historic &
Future) Futu Future)
re
| _1__ [Raw Water Intake is 1.222871[$ 368.738 [S$ 613.673 [S$ = [8 (240,460
Water Treatment Plant Is 1.450,000[$ 127.630 [s tos.e66 {S$ TS 226.704 |
| 3 [Water Treatment Plant Upgrade [s7a7.986[s 363.993 [S$ SS 363.993 |
300mm Diameter Main to Fairview Reservior [s175.000[s a7.s00 [SSCS 87.500
| 5 [Water Resenior Is 1534,000[$ e700 [SSC C«dCTSS767.000 |
|__6 [Upgrade Filters at Water Treatment Plant Is 4790s0[s 1.s80.876[$ TS TS (1,101,826)|
Contribution and Fairview Reservoir Upgrade
| 8 [East Sector Water Mains [s446.026[$ aaa [Ss SC CS 142,201
| 10 [industrial Main Loop - Phase 1 Is 6.164,000[$ 3.638.400Js TS TS 2.525.600 |
industrial Main Loop - Phase 2 [Is 6.03t000[$ = SS 6.031.000 |
Industrial Main Loop - Phase 3 is 7.045000/$ (dT ShLLCCCCCdSSC(:C'"'CS)SNCN~ *CS ~~ (7,045,000
| 13 [Southeast Main Loop - Phase 1 Is 1.186,000[$ sateooys TS TS 504.400 |
| 14 [Southeast Main Loop - Phase 2 is 1350000/s TSS 1,350,000]
| 15 [Southeast Main Loop - Phase 3 Is 4648.000[$ SS 1.648.000 |
Unallocated Offsite Levies CollectedtoDec 31,2020 [$= [SC TS SS
[$36,136,980 [$ 7,889,562[$ 1,709339/$ TS 26,538,079 |
C.3 Year of Construction
The City anticipates construction of water offsite infrastructure as outlined in the table below. There
have been no changes to this schedule in this update.
Forecast Year of Construction
. A Construction Start
Project Description
Year
Raw Water Intake 2006
Water Treatment Plant 2006
Water Treatment Plant Upgrade 2006
300mm Diameter Main to Fairview Reservior 2006
Water Reservior 2006
| 6 |Upgrade Filters at Water Treatment Plant 2006
7 Water Supply, Treatment & Storage - NRSC
Contribution and Fairview Reservoir Upgrade 2010
| 8 [East Sector Water Mains 2006
Industrial Main Loop - Phase 1 2029
Industrial Main Loop - Phase 2 2033
Industrial Main Loop - Phase 3 2039
| 13 [Southeast Main Loop - Phase 1 2025
Southeast Main Loop - Phase 2 2036
Southeast Main Loop - Phase 3 2042
Unallocated Offsite Levies Collected to Dec 31, 2020
016
City of Brooks 2023 Offsite Levy Update
C.4 Water Offsite Infrastructure Benefiting Parties
The table below outlines the allocation of water offsite levy infrastructure costs to the benefiting
parties.
Allocation of Water Infrastructure to Benefiting Parties
Other Developer Share
Reduced Project Beyond 25 Yrs_| OSL/ Developer
watt hn Estimated Cost Stakeholder (Financial Share %
are ee
Oversizing %)
1 |RawWaterIntake Ci' 40AGO 723% =| TT THC
| 2 |WaterTreatment Plant CSG 7047 23% TCC 2TH
|__3 _|WaterTreatment Plant Upgrade CS 863.993] 77.23% | Cd 2TH
___4 [300mm Diameter MaintoFaiviewResewion --ss|S 857.500 77.28% =~] CT Ci'dCS (STM
| 5 [WaterResewior -- Ct--"'C;SCOC*iSSTCC"'é'«OOOT =--77-23% =~ | CT C"(tt:C"'"'LS O22 T7%H OY
|__6 [Upgrade Filters at Water Treatment Plant |S (1.101.826)| 77.23% =| TCH
Eaten eet ee Te
Contribution and Fairview Reservoir Upgrade
___8 |EastSectorWaterMains_--"('(C'dS 142 201 56% | CT C"(sC*dT:C( ($e |
| 10 [industrialMainLoop-Phaset1 CS 2.525.600] 00.26% =| | 80.21%
| 11 [Industrial MainLoop-Phase2_ CC SS G031.000] 60.26% =| C18. 90% ~~] 23.85%
| 12 [Industrial MainLoop-Phase3_ Csi SS7,045,000] ~-- 60.26% =~ | CTC | 14.31%
__13 [Southeast MainLoop-Phase1 iC' SS 50K AOO[ 054% =| CT 8H | 36.30%
__14 [Southeast MainLoop-Phase2_-- Ci' SS 1,350,000 054% =| CTC 252% | 18.94%
| 15 [SoutheastMainLoop-Phase3_ CS 1.648.000] 60.54% =| CT 2999% | ATH
| 100 [Unallocated Offsite Levies CollectedtoDec 31.2020 |S = | t--"C~d CC CST 100.00%
$26,538,079
C.5 Existing Receipts & Adjusted Levy Cost
The adjusted offsite levy costs for water is approximately $6.67 million. However existing offsite levies
have been collected from previous developers, resulting in an adjusted offsite levy costs of $4.14
million.
Offsite Levy Funds Applied to Date
: Offsite Levy .
Offsite Levy Adjusted
Project Description ass. ae Funds Collected rans coterie Developer (Levy)
to Dec 31, 2020 ng wan! Cost
2021
|___1___|Raw Water Intake $ 54753|$ = - *|S 203 | $ 54,550
| 2. [Water Treatment Plant $ 51621/$ = - {§$ 191|$ 51,429
| 3 [Water Treatment Plant Upgrade $ 62.881/$ - {$ 307 | $ 82.574
300mm Diameter Main to Fairview Reservior $ 19924/$ =#-|[$ 74/5 19.850
| 5 |Water Reservior $ 174.646|$ [SATS 173,998
| 6 [Upgrade Filters at Water Treatment Plant $ 250,886)/$ -- -:*'|$ 930)| $ 249.956
| 7 (ate Supply, Treatment & Storage - NRSC $ 2,666,093 | $ 1,735,245 | $ 3.451|$ 927,397
Contribution and Fairview Reservoir Upgrade
| 8 [East Sector Water Mains $ 66,038/5 = - [$s 952 | $ 65,086
| 10 [Industrial Main Loop - Phase 1 $ 762,882/$ ----s_ -:*{$ 6.176 |$ 756.706
| 11 [Industrial Main Loop - Phase 2 $ 1438.201/$ - *[$ 4621/5 1,433,581
| 12 [Industrial Main Loop - Phase 3 $ 1,008.005/$ = - {$ 2,906 | $ 1,005,099
| 13 [Southeast Main Loop - Phase 1 $ 183.113/$ -- -:*'{$ 5,536 | $ 177,578
Southeast Main Loop - Phase 2 $ 255701[/$ ss -:*C[S 3,001 | $ 252,700
Southeast Main Loop - Phase 3 $ 156.072/$ = _---:*{S 1,465 |$ 154,607
Unallocated Offsite Levies Collected to Dec 31,2020 [$ === -_~*<X[$ 763,751/$ ---- -_~*<{$ 763,751
$ 6,669,044 | $ 2,498,996 [$ 28,600 | $ 4,141,448
017
City of Brooks 2023 Offsite Levy Update
C.6 Water Infrastructure Benefiting Areas
Net developer costs for each project have been allocated to multiple benefiting offsite levy areas as
shown in the table below. Allocations are denoted with a "1" below applicable area numbers.
Water Allocations to Benefiting Areas
Toe EEE EERE EEE EEEEE EEE
1_|Raw Water Intake $ 54,550 | 1 1 1 1 1 1 1 1 1 1 1 1 1
2 |Water Treatment Plant iS
3 Water Treatment Plant Upgrade SSSCSCSCSC~SS mse at [a [i
FN
§ [WaterResenor «SS ecw
6 Upgrade Fiters at Water TreatmentPiant «dS rns [tpt ttt [t [4 [ 4 [4 [t[ 4 [tit is [ssf tis [ tis [4s] ss]
7 |Water Supply, Treaiment & Storage - NRSC Contnbuton and FaviewResenor [8 oz7s07(4[4|4]/4[4[1[1]4]/4[4[1| 4/4] 4[1[1|4[4[4[ 1] 1] 4/411] 4]
@ least SectorWaterWans SO TP a
10 [Industral Main Loop-Phaset_----------S--~*S rrr AAP Tat [a [tai [s[ a [aia [ tat l ass [sls [oo]
14 [Industral Main Loop=Phase2-------- SS S--~*S tass atP[t [tpt [tis [t[ 4s [tis [t [st [sists [tls [ss]
12 [Industral Main Loop= Phase 3 SSSSCSC~S OCT AE a]
13 [Southeast an Loop-Phase1 Stree aa
14 [SoutheastWan Loop Phase? iS sro
16 [Southeast Wan Loop -Phase3---- iS taco a
10 none Cee Lvs Colin De 2020 7 TT
C.7 Account Balance
At December 31st, 2022 the Water account Balance was in a deficit of $463,933.86. This amount takes
into consideration expenditures and front-ending obligations up to the end of 2022. It also reflects
$109,939.35 of water offsite levies that were returned to the City when a sale of industrial lands was
reversed due to the terms of the sale not being met.
C.8 Development and Water Staging Impacts
Water offsite infrastructure will be constructed in staged fashion over the 25-year review period.
To compensate parties for capital they provide in front-ending offsite infrastructure construction, a
5.11% interest allowance interest allowance is charged to the account when it is forecasted to be ina
negative balance. Further, a 5.60% interest credit is provided to the account when it is forecast to be in
a positive balance. The graph and table below outline the forecast water levy account balances over the
25-year development period.
Anticipated Water Offsite Levy Account Balances
Water Reserve
eos ge des ese of
$(500,000) 5 --S--_S--_8_ 38 =--S 2/3
° ROR RRR S| RR SOW
soonuy LC
$(2,500,000)
Year
018
City of Brooks 2023 Offsite Levy Update
Anticipated Water Offsite Levy Account Balances
Opening Balance
Year Receipts Expenditure Interest Balance
2023 $ 147,851 $ - $ (16,146) $ (332,114)
2024 $ 157,208 $ - $ (8,938) $ (183,844)
2025 $ 167,166 $ 20,111 $ (1,880) $ (38,669)
2026 $ 177,741 $ 168,614 $ (1,510) $ (31,051)
2027 $ 185,748 §$ 21,709 $ 7,447 $ 140,436
2028 $ 194.112 $ - $ 18,735 $ 353,283
2029 $ 202,861 $ 95,952 §$ 25,771 §$ 485 962
2030 $ 211,998 $ 790,642 $ (4,736) $ (97,418)
2031 $ 221,541 §$ 101,795 §$ 1,250 $ 23,578
2032 $ 231,520 $ - $ 14,286 $ 269 384
2033 $ 241,941 §$ 203,594 $ 17,233 $ 324 964
2034 $ 252,837 §$ 1,677,611 $ (56,200) $ (1,156,011)
2035 $ 264,228 $ 215,992 $ (56,607) $ (1,164,383)
2036 $ 276,137 §$ 39,554 $ (47,411) $ (975,210)
2037 $ 288,570 $ 325,923 $ (51,742) $ (1,064,306)
2038 $ 301,565 $ 41,963 $ (41,120) $ (845,824)
2039 $ 315.148 $ 170,385 $ (35,824) $ (736,884)
2040 $ 329,344 $ 1,403,969 $ (92,568) $ (1,904,077)
2041 $ 344.179 $ 180,761 $ (88,948) $ (1,829,607)
2042 $ 359.663 $ 28,827 $ (76,587) $ (1,575,359)
2043 $ 375,880 $ 237,538 $ (73,432) $ (1,510,448)
2044 $ 392,804 $ 30,583 $ (58,674) $ (1,206,902)
2045 $ 410,486 $ - $ (40,697) $ (837,113)
2046 $ 422.800 $ - $ (21,171) $ (435,484)
2047 $ 435,484 $ - $ - $ 0
019
City of Brooks 2023 Offsite Levy Update
APPENDIX D: SANITARY SEWER OFFSITE INFRASTRUCTURE
D.1 Sanitary Sewer Offsite Infrastructure
The estimated cost of sanitary sewer offsite infrastructure required to support future growth is
approximately $54.28 million as outlined in the table below. These costs represent the "gross" costs, of
which only a portion will go to support development during the 25-year review period.
Summary of Sanitary Sewer Offsite Infrastructure
Future Estimated Cost of .
. _-- Cost of Total Project
Item Project Description Completed Work Debenture Work Yet to be eer Cnet
Interest Completed
9 Eastbrook Sanitary Sewer Pump Station Upgrade $ 1536939/$ =- [$ - [$s 1,536,839
10 [Main Trunk (Old Lagoons to Hort Lift Station) $ 4491726[/$ = - ~*'[$ ss - sid 4,491,726
14 Main Trunk (7th Street East to Old Lagoons) $ 37,440/$ ss | sd 4.095.560 | $ 4,133,000
12 South Industrial Trunk Main Upsize $ -|[$ si - ~--iSS 1,716,000 | $ 1,716,000
13 |Eastbrook Lift Station and Forcemain Upgrades $ -[s ss - dS 1,729,000 | $ 1,729,000
14 Parkland Lift Station Upgrades $ 2 eee 329,000 | $ 329,000
15 [Meadowbrook Lift Station Upgrades $ 196,743/$ ss - =i 1,195,290 | $ 1,392,033
16 Wastewater Treatment Upgrades $ -ls ss YS 30,200,000 | $ 30,200,000
100 _[Unallocated Offsite Levies Collected to Dec 31, 2020 $ -|[$ - [$s fg
S$ 15,018,964/$ - |$ 39,264850|$ 54,283,814
D.2 Sanitary Sewer Offsite Infrastructure Grants & Contributions
The MGA enables the City to allocate the cost of offsite infrastructure to development, other than those
costs that have been provided by way of special ear-marked grant or contribution. The City of Brooks
has/will receive $22.83 million in special ear-marked grants or contributions for sanitary sewer offsite
levy infrastructure as shown in the table below. The total reduced sanitary sewer offsite infrastructure
cost is $31.45 million.
Special Grants and Contributions for Sanitary Sewer Offsite Infrastructure
Special Aoi Other
It P Descripti Total Project |Provincial Grants Cc o ributi n Contributions | Reduced Project
em (ie EB OE eT Estimated Cost | (Historic & contributions (Historic & | Estimated Cost
Future) (Historic = Future)
Future)
1 Peeberoee ese ein: arene Seneneferemen |&Zeere same
2 [Modification and Expansion Wastewater Treatment Facility [| $_4.283,941[$ 1,523.849[$ 2.075,000/$ = [S685,092 |
3 [Pump Station Modifications andForcemain LS 1,156,261 [8 578126/s TS 878,125 |
4 |East Sector SanitarySewerUpgrade Sat TS teo77e[S TS S185 |
5 |Cassils Road East SanitarySewerMain LS 153.225/8 eet2;S TS 76,613
9 |Eastbrook Sanitary Sewer Pump Station Upgrade SS 1536,830/8 TS SS 1536.89 |
10 [Main Trunk (Old Lagoons to Hort Lift Station) TS 4 491,726[$ 3.202623]$ TS 1,199,103 |
11 [Main Trunk (7th Street Eastto OldLagoons) LS 4.133,000[$ 1.239.900]$ TS 2.893.100]
12 [South industrial TrunkMainUpsize S17 16,0001$ 999,6007$ TS 716,400 |
13 [Eastbrook Lift Station andForcemain Upgrades S 1,729,000 1,022.400]$ TS 706,600]
14 [Parkland Lift Station Upgrades S000 SS 329,000
15 [Meadowbrook Lift Station Upgrades SS 1302,093/8 SS 1,392,033 |
16 |WastewaterTreatmentUpgrades LS 30,200,000 9. 060,000/$ TS 21,140,000]
100 [Unallocated Offsite Levies CollectedtoDec 31,2020 |S TS SS
$ 54,283,814 | $ 20,759,340 | $ 2,075,000 | $ : $ 31,449,474
020
City of Brooks 2023 Offsite Levy Update
D.3 Year of Construction
The City anticipates construction of sanitary sewer offsite infrastructure as outlined in the table below.
There have been no changes to this schedule in this update.
Forecast Year of Construction
Construction
Project Description
~ | : --_
1 New Sewage Treatment Facility, Pumping Station and Forcemain
2006
Modification and Expansion Wastewater Treatment Facility
Pump Station Modifications and Forcemain
East Sector Sanitary Sewer Upgrade
Cassils Road East Sanitary Sewer Main
| 9 |Eastbrook Sanitary Sewer Pump Station Upgrade 2012
| 10 [Main Trunk (Old Lagoons to Hort Lift Station) 2016
| 44 |Main Trunk (7th Street East to Old Lagoons) 2022
South Industrial Trunk Main Upsize 2029
Eastbrook Lift Station and Forcemain Upgrades 2026
Parkland Lift Station Upgrades 2023
Meadowbrook Lift Station Upgrades 2025
Wastewater Treatment Upgrades 2025
D.4 Sanitary Sewer Offsite Infrastructure Benefiting Parties
The table below outlines the allocation of sanitary sewer offsite levy infrastructure costs to the
benefiting parties.
Allocation of Sanitary Sewer Infrastructure to Benefiting Parties
Reduced Project omer See 5 | OSL/ Devel
roj yon: rs veloper
Pee eae Estimated Cost Stakeholder (Financial Share %
re _
Oversizing %)
| ti New Sewage Treatment Facility, Pumping Station and Forcemain a ee ee ee eee
Modification and Expansion Wastewater Treatment Facility is 685092] 77.23% | 000% 22.77%
Pump Station Modifications and Forcemain is 878126] 77.23% fT 000% 22.77%
East Sector Sanitary Sewer Upgrade is 51,835] 62.08% TT 000% 87.92%
Cassils Road East Sanitary Sewer Main is 76.613 74.60% TT 000% 25.40%
|__9 __[Eastbrook Sanitary Sewer Pump Station Upgrade is 1.636,839[ 70.69% | | 000% 29.31%
Main Trunk (Old Lagoons to Hort Lift Station) is 1,199,t03] 60.26% TT 000% 9.74%
Main Trunk (7th Street East to Old Lagoons) is 2.893400] 59.23% fT 0000% 40.77%
South Industrial Trunk Main Upsize is 716.400] 58.09% | | 10.06% | 1.85%
[13 |Eastbrook Lift Station and Forcemain Upgrades rs _7oeeo0| _7060% | ----~*i| 382% ~*| 25 79% --*«|
Parkland Lift Station Upgrades is 329,000] 75.75% TT 000% 24.25%
Meadowbrook Lift Station Upgrades [s_ 1,392,033 65.92% | T278% 31.35%
[16 __|Wastewater Treatment Upgrades [s_21,140,000| 60.26% | ----*'| 318% | 36.57% |
|__100 [Unallocated Offsite Levies Collected to Dec 31, 2020 is 0.00% | 100.00%
021
City of Brooks 2023 Offsite Levy Update
D.5 Existing Receipts & Adjusted Levy Cost
The adjusted offsite levy costs for sanitary sewer is approximately $11.12 million. However existing
offsite levies have been collected from previous developers, resulting in an adjusted offsite levy costs of
$8.51 million.
Offsite Levy Funds Applied to Date
. Offsite Levy .
Offsite Levy Adjusted
Project Description OSL / Developer | -- nds Collected | Funds Collected | oper (Levy)
Cost Starting Jan 1,
to Dec 31, 2020 Cost
2021
1 New Sewage Treatment Facility, Pumping Station and Forcemain ad ee i Da
2 Modification and Expansion Wastewater Treatment Facility i$ ii55995/$ = - «SS 71S 155,459 |
3___|Pump Station Modifications and Forcemain is 13639]$ TSS 131,186 |
4 |East Sector Sanitary Sewer Upgrade Is stges6{sS- S 4S 19,233 |
5 __|Cassils Road East Sanitary Sewer Main [ss tg4eofs_ | SC S19,460 |
9 [Eastbrook Sanitary Sewer Pump Station Upgrade
10___[Main Trunk (Old Lagoons to Hort Lift Station) [ss 476,ss0[$_ STS 471,023 |
11___ [Main Trunk (7th Street East to Old Lagoons) [$s 1i79605]$ S100 1,178,006 |
12 [South Industrial Trunk Main Upsize is ssasigi fs C-SI 228,191 |
13 [Eastbrook Lift Station and Forcemain Upgrades [$s taz2a5{ Ss - CS39[8 180,506 |
14 [Parkland Lift Station Upgrades [ss 7g7eg]$_-- CC CdS CdS 79,769 |
15 [Meadowbrook Lift Station Upgrades [ss 4ae4ei{s CdS BGS 428,845
16 [Wastewater Treatment Upgrades [$s 77aaee6]$ S24 2778 7,705,589 |
100 [Unallocated Offsite Levies Collected to Dec 31, 2020 i$ si a - St 695[$ TS (2,511,695)
($11,122,854 | $ 2,569,024 [$ 44,074 | $ 8,509,756
D.6 Sanitary Sewer Infrastructure Benefiting Areas
Net developer costs for each project have been allocated to multiple benefiting offsite levy areas as
shown in the table below. Allocations are denoted with a "1" below applicable area numbers.
Sanitary Sewer Allocations to Benefiting Areas
Developer . . : . :
1 /$ 32,843) 1 1 1 1
2{[s 155459) 4] a[1[ a> atraftraltatatratatatatraf~satatataftatastatia{ 1] af]
3[s 131,188) 7[ 1], 1] a} a[r1{ 1} aftratra{ a> afatra{ a aftrata{ a> af rat7{ 1] 1] 1]
4{[s_ 19233) | [ [ [| | [-- [| | | [-- [| | JT [ | fT [ [at fatafa] af 1]
5[s i940) [ [| [| | [| [| [| | [ [| [| [| [ [| | Jf [ Jf | fat [at fT |
g9{[s_ 403702; [ | [| | [| [| [| | [t]{afafatra{atafratra]{ | | fT {| | fT |
to[s 471023; 4], af afra{tataftatatatataf~alatatatsatafatatsataftat--iaf[1] 1]
11 [$s 1178000) 1] a4; a[1{[ a1} afraftra{a{aftratra{a>aftrtra{afaft {[ | | [ J | f
i2{[s 228191; [at alt {| | | [| | | [| [-- [| | [| [ [| | fT | | J JT [ JT f
i3[s 190506; [| | [ | [| | [ | [afafta{af>aftaftataftayt [| | | [ [ 7 f
14[s_7a7eo) | | [ {| [| | [ | [| [| [ [| | J [ | | fT [| [| J [1]f1] 1]
1 [s 428845) | | [ [| [| | [ [| [| [| [-- [| [| fT [ [| | [aftataftatafsa] 1]
16 [|S 7,705,589) 1/14] 4a[1]{[ 1] a} raf[r1{a1{afratra{a>aftrata{afafr{a7]{afaf[rz{1] 1]
1oos (2,511,695) 74] a1[1[ af atraftraltataftratafafaftr{[ +a afatra{[ a> aftaf[ra[ 1] 1] 1]
$__ 8,509,756
022
City of Brooks 2023 Offsite Levy Update
D.7 Account Balance
At December 31st, 2022 the Sanitary account Balance was in a surplus of $1,002,723.29. This amount
takes into consideration expenditures and front-ending obligations up to the end of 2022. It also reflects
$121,848.53 of sanitary sewer offsite levies that were returned to the City when a sale of industrial
lands was reversed due to the terms of the sale not being met.
D.8 Development and Sanitary Sewer Staging Impacts
Sanitary Sewer offsite infrastructure will be constructed in staged fashion over the 25-year review
period.
To compensate parties for capital they provide in front-ending offsite infrastructure construction, a
5.11% interest allowance interest allowance is charged to the account when it is forecasted to be ina
negative balance. Further, a 5.60% interest credit is provided to the account when it is forecast to be in
a positive balance. The graph and table below outline the forecast Sanitary Sewer levy account balances
over the 25-year development period.
Anticipated Sanitary Sewer Offsite Levy Account Balances
Sanitary Reserve
a
a Ca
$-
lo mo wig oo = =
$(1,000,000) e--\s--e--_a---_3-_#- 335 = A
s3.00000) M&W SSN NN
seooovn, L&C
ee a
sie000000) |)
57,000.00) |. a
seooo00, LN eS Reserve
ss-oo0o0, L__ Cd Petanee
$(9,000,000)
Year
023
City of Brooks 2023 Offsite Levy Update
Anticipated Sanitary Sewer Offsite Levy Account Balances
Opening Balance
Year Receipts Expenditure Interest Balance
2023 $ 346,459 $ 951.661 $ 22,261 $ 419.783
2024 $ 368,386 $ 190.501 $ 33,469 $ 631,137
2025 $ 391,722 $ 905.672 $ 6,562 $ 123,749
2026 $ 416,502 $ 3,921,493 $ (172,781) $ (3,554,023)
2027 $ 435,265 $ 3,890,261 $ (358,161) $ (7,367,180)
2028 $ 454864 $ 966,164 $ (402,590) $ (8,281,070)
2029 $ 475,365 $ 28,701 $ (400,338) $ (8,234,744)
2030 $ 496.776 $ 118.247 $ (401,453) $ (8,257,668)
2031 $ 519.138 $ 121,795 $ (401,663) $ (8,261,987)
2032 $ 542,522 $ 31,362 $ (396,067) $ (8,146,895)
2033 $ 566,941 $ - $ (387,336) $ (7,967,289)
2034 $ 592.473 $ - $ (376,853) $ (7,751,669)
2035 $ 619.166 $ - $ (364,471) $ (7,496,973)
2036 $ 647,072 $ - $ (350,030) $ (7,199,931)
2037 $ 676,207 $ - $ (333,362) $ (6,857,087)
2038 $ 706,659 $ - $ (314,287) $ (6,464,714)
2039 $ 738,488 $ - $ (292.610) $ (6,018,836)
2040 $ 771,753 $ - $ (268,126) $ (5,515,208)
2041 $ 806,516 $ - $ (240.614) $ (4,949,306)
2042 $ 842 800 $ - $ (209.842) $ (4,316,349)
2043 $ 880,800 $ - $ (175,557) $ (3,611,105)
2044 $ 920.459 $ - $ (137,492) $ (2,828,138)
2045 $ 961,893 $ - $ (95,365) $ (1,961,611)
2046 $ 990,750 $ - $ (49.611) $ (1,020,472)
2047 $ 1,020,472 $ - $ - $ (0)
024
City of Brooks 2023 Offsite Levy Update
APPENDIX E: STORMWATER OFFSITE INFRASTRUCTURE
E.1 Stormwater Offsite Infrastructure
The estimated cost of stormwater offsite infrastructure required to support future growth is
approximately $4.27 million as outlined in the table below. These costs represent the "gross" costs, of
which only a portion will go to support development during the 25-year review period.
Summary of Stormwater Offsite Infrastructure
Future Estimated Cost .
Item Project Description Completed Wo 'k| Debenture --_|of Work Yet to be eetnmted eae '
Interest Completed
13
14 [Marshall Drain Channel Upgrades-Phase2_ | S$ SS 881,010] $ 881,010 |
15 [Marshall Drain Channel Upgrades-Phase3_ | S$ SS 463.455] $463,455 |
16 [Marshall Drain Channel Upgrades-Phase4 | S$ SS 272,510] $1,272,510 |
17 |Greenbrook Pond OverflowChannel SS S524 340] $524,340 |
100 [Unallocated Offsite Levies CollectedtoDec 31,2020 | $ GS - -
$ - [$= S$ 4,270,860|$ 4,270,860 |
E.2 Stormwater Offsite Infrastructure Grants & Contributions
The MGA enables the City to allocate the cost of offsite infrastructure to development, other than those
costs that have been provided by way of special ear-marked grant or contribution. The City of Brooks
has/will receive $.79 million in special ear-marked grants or contributions for stormwater offsite levy
infrastructure as shown in the table below. The total reduced stormwater offsite infrastructure cost is
$3.48 million.
Special Grants and Contributions for Stormwater Offsite Infrastructure
Special Provincial elope Other
item Project Description Total Project Grants Contributions | Contributions | Reduced Project
ro) P Estimated Cost | (Historic & Historic & (Historic & | Estimated Cost
Future) ( Fu oric Future)
uture)
13_|Marshall Drain Channel Upgrades - Phase 1 I$ 1t29545[$ 362273)$ = TS 77,272 |
14 |Marshall Drain Channel Upgrades - Phase 2 i$ satoro|$ ss 44nsogY gS 440,504 |
15 |Marshall Drain Channel Upgrades - Phase 3 is 4e3.a55{$ 0 TS 463.455 |
16 [Marshall Drain Channel Upgrades - Phase 4 [gs t27asto[$ = SS 8.272.510 |
17 |Greenbrook Pond Overflow Channel [gs 5aaz4ot gS 524,340 |
100 [Unallocated Offsite Levies Collected to Dec 31, 2020 Is GE
[S$ 4,270,860[$ 79z779[/$ = TS TS 3,478,081 |
E.3 Year of Construction
The City anticipates construction of stormwater offsite infrastructure as outlined in the table below.
There have been no changes to this schedule in this update.
025
City of Brooks 2023 Offsite Levy Update
Forecast Year of Construction
Construction
Project Description
- ° P Start Year
13 |Marshall Drain Channel Upgrades - Phase 1 2024
Marshall Drain Channel Upgrades - Phase 2 2029
Marshall Drain Channel Upgrades - Phase 3 2034
Marshall Drain Channel Upgrades - Phase 4 2039
Greenbrook Pond Overflow Channel 2027
E.4 Stormwater Offsite Infrastructure Benefiting Parties
The table below outlines the allocation of stormwater offsite levy infrastructure costs to the benefiting
parties.
Allocation of Stormwater Infrastructure to Benefiting Parties
Other Developer Share
Item Project Description eee eet Muni Share % | Stakeholder oetcinancial, ns OS te eeer
HENS Oversizing %)
13 [Marshall Drain Channel Upgrades - Phase 1 [$s 777.272|_ 52.68% | | 189% | 45.43%
14 [Marshall Drain Channel Upgrades - Phase 2 [g_4a050a] 52.68% | 11:36% | 35.96%
15 Marshall Drain Channel Upgrades - Phase 3 [s_463.455| 52.68% | 20.82% | 26.50%
16 [Marshall Drain Channel Upgrades - Phase 4 [$1,272,510 | 52.68% =| | 028% 17.04%
17_|Greenbrook Pond Overflow Channel [$524,340] 99.51% fT 008% TI
100 |Unallocated Offsite Levies Collected to Dec 31, 2020 igs ef 000% | 10000% |
E.5 Existing Receipts & Adjusted Levy Cost
The adjusted offsite levy costs for stormwater is approximately $.85 million. However existing offsite
levies have been collected from previous developers, resulting in an adjusted offsite levy costs of $.47
million.
Offsite Levy Funds Applied to Date
; Offsite Levy .
Offsite Levy Adjusted
Project Description Ost! eae oPer Funds Collected Mend Collected Developer (Levy)
to Dec 31, 2020 g wan; Cost
2021
Marshall Drain Channel Upgrades - Phase 1 iss 353.090|$ = S896 | $352,694 |
Marshall Drain Channel Upgrades - Phase 2 i$ 58.4ta{ $C - TS $158,180 |
Marshall Drain Channel Upgrades - Phase 3 I$ taaetitg TSS 122,722 |
Marshall Drain Channel Upgrades - Phase 4 i$ 2t6.773[$ = S142 $216,631 |
Greenbrook Pond Overflow Channel I$ tam {SoC TS 7 |
Unallocated Offsite Levies Collected to Dec 31, 2020 igs (sw - od 8785201 = ~Sd 878,520)!
[$ -853,239/$ --378,5207$ 865 | $473,854 |
026
City of Brooks 2023 Offsite Levy Update
E.6 Stormwater Infrastructure Benefiting Areas
Net developer costs for each project have been allocated to multiple benefiting offsite levy areas as
shown in the table below. Allocations are denoted with a "1" below applicable area numbers.
Stormwater Allocations to Benefiting Areas
Tee EE EE ELEC PEEEE ECE EP PPPPET
13 |$ 352,694 1 4 1 1 | 1
14{sisgteo; [a tatatatatatay to fT ft fat ft ot fatat ft tT ft ft ft tf
is {$122722) [atatatatatatay tot tT fat tt tatat ty tT ty tt
1e{s 216631; [atatatatatatay | fT ft fat ft tT ftatat tT tT tf fT ft tf
wi[s 2t4a7; oT TT a
100 s_Gres2y/ 4] at at atatatatatstatatatatst stata tata t stata tas ys
E.7 Account Balance
At December 31st, 2022 the Stormwater account balance was in a surplus of $386,997.23. This amount
takes into consideration expenditures and front-ending obligations up to the end of 2022.
E.8 Development and Stormwater Staging Impacts
Stormwater offsite infrastructure will be constructed in staged fashion over the 25-year review period.
To compensate parties for capital they provide in front-ending offsite infrastructure construction, a
5.11% interest allowance interest allowance is charged to the account when it is forecasted to be ina
negative balance. Further, a 5.60% interest credit is provided to the account when it is forecast to be in
a positive balance. The graph and table below outline the forecast Stormwater levy account balances
over the 25-year development period.
Anticipated Stormwater Offsite Levy Account Balances
Storm Reserve
$300,000
$200,000 Balance
° \-- =
5 NDF"
si100.00) &@ @& 2 2 9 gle ser
of _& & & & & \S.ek
$(300 000)
Year
027
City of Brooks 2023 Offsite Levy Update
Anticipated Stormwater Offsite Levy Account Balances
Opening Balance $ 386 997
Year Receipts Expenditure Interest Balance
2023 $ 14.973 $ - $ 22.510 $ 424 480
2024 $ 15.920 $ 37,004 $ 22,590 $ 425,987
2025 $ 16,929 $ 310,240 $ 7,430 $ 140,105
2026 $ 18,000 $ 40.641 $ 6,578 $ 124 041
2027 $ 18.811 $ 255 $ 7,985 $ 150,583
2028 $ 19.658 $ 2,097 $ 9416 $ 177,559
2029 $ 20,543 $ 20,195 $ 9963 $ 187,870
2030 $ 21,469 $ 164,183 $ 2,529 $ 47 685
2031 $ 22,435 $ 21,139 $ 2,743 $ 51,725
2032 $ 23,446 $ - $ 4210 $ 79,380
2033 $ 24501 $ - $ 5817 $ 109 698
2034 $ 25,604 $ 17,907 $ 6,574 $ 123,970
2035 $ 26,758 $ 147,552 $ 178 $ 3,354
2036 $ 27,964 $ 18,997 $ 690 $ 13,010
2037 $ 29.223 $ - $ 2,365 $ 44 599
2038 $ 30,539 $ - $ 4208 $ 79,345
2039 $ 31,915 $ 36,641 $ 4179 $ 78,797
2040 $ 33,352 $ 301,926 $ (9.698) $ (199,474)
2041 $ 34,855 $ 38,873 $ (10,398) $ (213,890)
2042 $ 36,423 $ - §$ (9,069) $ (186,536)
2043 $ 38,065 $ - $ (7,587) $ (156,058)
2044 $ 39,779 $ - $ (5,942) $ (122,222)
2045 $ 41,569 $ - §$ (4,121) $ (84,773)
2046 $ 42.816 $ - $ (2,144) $ (44.101)
2047 $ 44101 $ - $ (0) $ (0)
028