Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2022 Capital Funds Book
City of St. Anthony Village 3301 Silver Lake Road St. Anthony, Minnesota 55418 www.savmn.com City of St. Anthony CAPITAL FUNDS 2022-2026 & 2027-2038 INDEX: Fund Summaries: Buildings Improvement Capital Equipment Park Improvement Utilities Infrastructure Stormwater Streets Improvement & Debt Service APPENDIX: Sources & Uses Management Summary Overview The Capital Equipment, Building and Parks Improvement Funds have been long standing capital funds used by the City. The Stormwater Fund has funded stormwater improvement since the 2015 retirement stormwater bonds. The Utilities Infrastructure Fund was established during 2016 for the replacement of water, sanitary sewer, and fiber optic infrastructure. Lastly, the Street Improvement and Debt Service Plan is the combined activity of the annual street improvement funds and their related debt service funds. Notable updates by Fund Buildings Improvement Fund In 2020 the City Hall / Community Center’s five roof top HVAC units were scheduled for replacement during the timeframe of 2020-2022. In 2020 the “City Hall” unit along with ductwork was replaced. The extreme heat experienced in the Summer of 2021 challenged the remaining aged equipment to the point it was difficult to keep the units operational. o The HVAC unit for the Police department area failed in early summer. It was more economical to move up the replacement of this unit than to repair the unit. Originally this unit was to be replaced in 2022 at a cost slightly higher than the 2021 replacement cost of $33,200 o The HVAC unit for the Community Services office and classroom areas also required summer time repairs in 2021 and its replacement date was extended from 2021 to 2022. Originally this unit was to be replaced in 2021 at a cost $64,000. The 2022 replacement project now includes the replacement of the existing ductwork as well. The ductwork’s condition was such that replacement was necessary for the system’s efficiency. This additional cost is mitigated by future energy savings. The 2022 estimated replacement cost including ductwork is $98,700 o The HVAC unit for the Community Services Multi-purpose room and Cafeteria areas also experienced outages similar to the PD unit. Originally this unit was to be replaced in 2022. The replacement is now planned for fall of 2021. The price to repair the unit to provide heat for one winter season is not economical. The 2021 project now includes the replacement of the existing ductwork as well. The 2021 estimated replacement cost including ductwork is $74,800. o The prior budget had noted the need replace the HVAC controls in connection with the new roof top units with the costs to be determined. The costs to install new controls to match the roof top units in place by the end of 2021 will be $54,560 and $26,300 in 2022. The new controls are necessary to reduce the current strain being put on the newer boiler system that reacts to the inefficiencies of the out dated controls systems. It will also provide for greater energy savings as well. o The Gym roof top unit will be replaced in 2023 or later. The controls for that unit do not need replacement. The GPS' NPBI technology installed in HVAC units in 2020 will be transferred to the replacement units. The current age of buildings ranges from 12-25 years. Roof replacements become a factor after 20-25 years. This makes completing the installations of HVAC units in the upcoming years important. Future roof replacements will not be damaged by subsequent replacements of HVAC units. The 2022 placeholder for the replacing the City Hall reader sign was extended to 2024 to alleviate the added HVAC costs. Cost of sign repairs are minor in amount. Software and hardware to manage the sign’s messaging is outdated. Replacement parts availability may be the determining factor for replacement. The painting of the City Hall main entrance doors along with added door security features has been proposed for the 2022 budget at a cost of $26,500. Certain other entrance doors will be painted as well. Lastly it has been several years since the last professional evaluation of the City building’s major components. Staff has proposed seeking out an evaluation of this type to ensure that the existing plan’s replacement items, costs and timing are reasonably accurate and complete. A placeholder of $15,000 has been added to the 2022 budget for this purpose. Future considerations for Building Improvement Fund: Renewal of Community Center Lease in 2028. Explorer the feasibility of measuring power usage within the City Hall / Community Services building by HVAC zones to ensure conservation efforts. Review adequacy of building improvement levy in connection with results of "Sebesta Type" evaluation of City Buildings. Capital Equipment Fund Two squads were scheduled for replacement in 2020. Due to COVID uncertainties only one squad was replaced in 2020 and the other added to the 2021 replacement schedule. Squad mileage is still used as the main factor for replacement. Currently the replacement cycle appears to be 3-4 years. That cycle is reflected in the Police CIP plan. As in past years, certain of the retiring squads are assigned to other purposes until their full useful life has been met. In 2021 squad 706, a 2017 Dodge Durango, was repurposed for the PD Reserve vehicle. Then the 2016 Ford Explorer PD Reserve vehicle was repurposed to replace the Fire Department’s 2006 Ford Explorer Code enforcement / Inspections vehicle. Police Body cameras are due for replacement in 2022 at an estimated cost of 10,562. Facility video cameras are scheduled for replacement in 2023 for $32,000 The Police Department’s current records management system was budgeted to be replaced over 2022-2023 at a cost of $65,000. The St Anthony Police are part of a group of four police departments working together to secure a replacement of the existing software. The group is likely to move ahead with the purchase in 2022 given discounts offer by the software vendor. To be conservative, the $62,644 cost reflected in the 2022 budget assumes the least favorable cost sharing arrangement. Due to turn over the Fire Department will be purchasing new paid on call fire fighter’s turnout gear sets in 2022 for an estimated cost of $14,478. Significant purchases for fleet replacements and self-contained breathing apparatus (SCBA) equipment are reflected as occurring in 2022-2026. Public Works – Streets Division: In 2022 fleet replacements will include a Sedan and F450 Mini-Dump Ford truck, combined cost estimated at $89,950. Significant purchases for fleet replacements, a plow truck and an aerial truck are reflected as occurring in 2024- 2026. The priority and timing of these purchases will be evaluated year to year. Public Works – Parks Division: In 2022 fleet replacements will be F350 Mini-Dump Ford truck at an estimated at $53,000. The 2023 replacement of a 1999 4500 Tractor is the substantial item within the parks division’s capital equipment plan. Administration and Finance – 2021 purchases included Fiber and Ethernet switches and Council Chamber audience chairs. CARES Funds supported the 2020 costs in developing the Liquor store’s curbside pick-up software. The project costs extended beyond the CARES reimbursement period, therefore the 2021 remaining costs are reflected here. 2022 costs include replacing the majority of Finance and Administration desktop and laptop computers and installing glass cubicle partitions vs plexiglass. Purchases for Election equipment, office furniture and replacing financial software are slated for 2025- 2026. The priority and timing of these replacements will be evaluated year to year. Future considerations for Capital Improvement Fund: Revising annual scheduled increases in Capital Improvement levy by $30,000 vs $25,000 starting in 2023 to $238,000 and topping out at a $600,000 levy in 2037. This structure is reflected in the 2022 plan. Evaluate future fleet replacements for the opportunities for the use of electric vehicles vs gasoline or diesel powered if functionally reasonable. Developing a General Fund balance policy which transfers excess fund balance to Capital Funds. The transfer is most likely to occur when large building permits or other one-time monies are received by the General Fund. These transfers would alleviate the potential shortfalls in capital funds and ease pressure to increase capital levies. Completed in 2021. Phasing out the use of Minnesota State Aid for streets (MSA) as a CIP source and converting that amount to levy. Then available MSA dollars would reallocated to the debt levy reduction to negate levy impact. Eventually MSA dollars could be used to reduce debt financing vs reducing debt levy. Thus, lowering the total debt reflected in the City’s financial statements. Targeting 2023 CIP process to review and possibly implement this change. Parks Improvement Fund The Tennis Courts mill and overlay project was completed in 2021, funded by interfund loan proceeds. The results of the WSB Parks Evaluation study will inform the items and timing of future capital expenditures. Future considerations for Park Improvement Fund: The Park improvement fund’s revenue source is Park Dedication fees. Allowed uses of park dedication fees are limited in scope. Also, dedication fees are insufficient to add any new amenities in the City Parks. Therefore, the City has been reliant on debt financing for significant additions and improvements. In order to fund the replacement of existing park amenities initiating a Parks capital improvement levy should be considered. Levy phase-in implemented in 2021. As mentioned earlier, develop a General Fund balance policy that transfers excess fund balance to Capital Funds. The calculation of excess funds would be performed annually upon completion of the City audit. If excess funds exist the City Council would determine the distribution of the dollars to specific capital funds. Implemented in 2021. Based on WSB’s Parks Evaluation findings, consider additional interfund loan to finance priority needs. Utilities Infrastructure Fund (pages 24-26) Mandated Water System Risk analysis and response plan completed in 2021. The 2006 water utility van was replaced in 2021. No significant Water/Sewer equipment purchases are scheduled for 2022. Water infrastructure improvements for 2022 including the water tower rehab and painting project. These costs will be fully funded with American rescue act funds. Funding proceeds and costs have been excluded from this budget as they will be tracked separately. Significant purchases for Water treatment plant components are reflected as occurring in 2022- 2025. Staff has proposed a 2022 Plant components assessment be performed by a third-party subject matter expert. A placeholder of $35,000 has been included in the capital budget. The amount reflects the complexities of three separate water treatment processes employed by the City. A place holder of $100,000 to complete the planned Fiber connections and to upgrade lift station SCADA systems has been included in the 2022 plan. The intended outcome of this project is the ability to perform many routines remotely, monitor utilities systems and monitor security at park shelters. Prior to contracting for further installations, the needs and matching results will be fully vetted as producing time and cost savings. Future considerations for Utilities Infrastructure Fund: The Utilities Infrastructure currently has a sufficient fund balance to support the programmed equipment replacement through the 2030’s. Water and Sewer operating fund transfers are projected to begin in 2024 to support future capital needs. Annual adjustments to water and sewer rates will ensure that operating transfers are available. Connection fees are planned to an additional revenue sources for Utilities Infrastructure fund. Connection fees have been included in the Utilities Infrastructure fund for 2021 and prospectively. The 2022 Plant components assessment will aid in informing the necessary capital expenditure items and timing of the same. Stormwater Fund A placeholder for an Industrial Park flooding mitigation has moved to 2030, anticipating that redevelopment will not occur until a later date. At the current time the City Engineer is assessing the scope of work required for Harding Pond stormwater maintenance project proposed for 2022. Harding Pond was a flood mitigation project built in the early 2000’s in response to a July 1999 flood event. At that time Harding Pond was designed to accommodate a 100-year flood event. Maintenance needs are evaluated at approximately the 20-year mark to determine if the existing flood capacity, given silt build-up, is still adequate. The $272,000 project anticipates addressing a capacity issue. The project cost maybe revised based on further Engineer findings. Updated cost estimates and timing needs for the remaining ponds will be developed by the City Engineer in late 2021 or early 2022. The remaining ponds are not considered due for maintenance until 2025 or later. Equipment replacement: The Street Sweeper was replaced as in 2021. A repair of a failed stormwater pipe along 33rd Ave was completed as part of the 2021 street project. This project will resolve localized minor flooding during heavy rains that has occurred over the last several years. The 2021 replacement of lighting at Water re-use was deferred to 2022. LED lighting will be installed for energy savings. Fountains/recycling pumps are also due for replacement. Future considerations for Storm Water Fund: The Storm Water fund currently has a sufficient fund balance to support the scheduled replacement throughout 2022-2038 time-frame. Stormwater fund transfers have been used to support the debt levy reduction program as needed in prior years. This support is also planned to occur again in 2024-2029, as long as future pond maintenance costs are fully addressed. The stormwater rates have been adjusted over time to support maintenance costs and capital needs. Continuing rate management will ensure sustainability. Street Improvement and Debt Service Plan Plan reflects the 2022 street improvement schedule. Plan has updated projections for future bond interest rates. Annual street improvements include a mixture of street, utility and storm water reconstruction, alley improvements and mill and overlays. The street improvement schedule and 2022 debt levy reduction program were presented to the City Council at the 3/9/21 council work session and approved at the 7/13/21 City Council meeting. The Street Improvement schedule was revised in 2022 to provide for an off year every third year, rather than a project scheduled every year. This approach will allow the City to transition to using levy dollars vs 100% debt financing to support the street improvement costs. Summary The proposed 2022 Capital Funds budgets align revenue sources with appropriate needs to ensure sustainability. The budgets as presented are intended to support the Cities present level of services and maintain the City’s infrastructure for current and future community members. Fiscal Year 2022 SOURCES 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Community Center Fund Transfer (1)60,000$ 60,000$ 105,000$ 109,200$ 113,568$ 118,111$ 120,000$ 720,000$ 720,000$ Reimbursement for Liquor Stores - - - 4,500 110,000 82,960 21,600 66,460 36,000 GF Excess Fund balance Transfer (2) - 159,694 - - - - - - - Building Improvement Levy (3) 78,000 78,000 88,000 93,000 98,000 103,000 108,000 729,000 750,000 TOTAL 138,000$ 297,694$ 193,000$ 206,700$ 321,568$ 304,071$ 249,600$ 1,515,460$ 1,506,000$ USES City Hall/Community Center 64,000$ 175,142$ 174,050$ 75,000$ 71,000$ 196,000$ 182,500$ 427,573$ 237,778$ Fire Station - - - 30,000 31,000 47,672 47,880 144,865 137,500 Public Works - - - 7,500 25,861 40,640 35,000 388,505 245,500 Park Shelters 22,000 - - 22,000 14,000 31,950 15,000 73,180 81,000 Liquor Stores - - - 4,500 110,000 82,960 21,600 66,460 36,000 TOTAL 86,000$ 175,142$ 174,050$ 139,000$ 251,861$ 399,222$ 301,980$ 1,100,583$ 737,778$ NET CHANGE 52,000 122,552 18,950 67,700 69,707 (95,151) (52,380) 414,878 768,222 BEGINNING CASH BALANCE 457,272 457,272 579,824 598,774 666,474 736,181 641,030 588,650 1,003,527 ENDING CASH BALANCE 509,272$ 579,824$ 598,774$ 666,474$ 736,181$ 641,030$ 588,650$ 1,003,527$ 1,771,749$ (1) Community Center fund transfer paused for 2020, School District rent reformulated in 2020. (2) Transfer of 2020 Excess GF fund balance (3) Additional Building Improvement Levy of $5,000 annually, paused for 2021, on schedule for 2022. Tops out at $125,000 in 2030. BUILDINGS IMPROVEMENT PLAN 2022 - 2038 BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACE D DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2021 EST ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 City Hall 1996 Building Components PARTIAL 2018 Metal Door Frame & Replacement PD and EE Entrances 2018 Multi.Internal -$ -$ -$ -$ -$ -$ -$ -$ 28,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2022 Front Entr. Doors paint / security controls Main Entry set & EE interior Multi.Internal - - 26,500 Council Chamber Doors change-out NA 1 Internal - - - - - - - - - - - - - - - - - - - 2016 Security upgrades - Cameras 2016 7 Internal - - - - - - - - 24,313 - - - - - - - - - 30,391 2016 Security upgrades -Control Server 2016 1 Internal - - - - - - - - 17,500 - - - - - - - - - 21,875 2017 Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - 24,410 - - - - - - - - - 30,513 2016 Replacement of Fire Alarm Panel 2016 1 Internal - - - - - - - - - - 25,000 - - - - - - - - 2015 Parking Lot LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - 15,000 - - - 2015 Building LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - 25,000 - - - 2015 Boilers/Fans etc Replaced in 2015-130K 2 Sebesta - - 7,500 - - - 7,500 - - - 7,500 - 160,850 - 7,500 - - - 7,500 2021 RTU-3 (Comm. Services -Adm/Classrooms )Poor -Replace Spring 22 1 Sebesta 64,000 - 98,750 - - - - - - - - - - - - - - - - 2020 RTU-4 & DUCKWORK (City) Replaced in 2020 1 Sebesta - - - - - - - - - - - - - - - - - - - RTU-4 & DUCKWORK (City) Replaced in 2020 - - - - - - - - - - - - - - - - - - - RTU-1 (Gym)FAIR -Replace 2023+1 Sebesta - - - 75,000 - - - - - - - - - - - - - - - RTU-2 (Multi-purpose)Replace in Fall 2021 1 Sebesta - 76,200 - - - - - - - - - - - - - - - - 2021 RTU-5 (Police)Replaced in 2021 1 Sebesta - 33,200 - - - - - - - - - - - - - - - - - 2021 HAVC Controls RTU-3 -(Comm services)update with RTU Units 1 TBD - - 26,300 - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-4 (City)update with RTU Units 1 TBD - 24,800 - - - - - - - - - - - - - - - - - HVAC Controls RTU-1 (Gym)update with RTU Units 1 not required - - - - - - - - - - - - - - - - - - - HVAC Controls RTU-2 (Multi-purpose)update with RTU Units 1 TBD - 12,930 - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-5 (Police)update with RTU Units 1 TBD - 17,360 - - - - - - - - - - - - - - - - - Domestic Water Heaters Fair 2 Sebesta - - - - - 16,000 - - - - - - - - - - 15,000 - - Relamp & Reballast (LED-PD/City Hall) Done 2015/2021 Multi.Sebesta - 10,652 - - - - - - - - - - - - - 25,000 - - - Roof Poor - Fair 1 Sebesta - - - - - 180,000 - - - - - - - - - - - - - Acoustic panels/overflow AV 2017 1 Internal - - - - - - - - - - - - - 15,000 - - - - - Community Service VCF Tiles 2017 1 Sebesta - - - - - - - - - - - - - 15,000 - - - - - Overhead garage doors 25 years 2 Internal - - - - 15,000 - - - - - - - - - - - - 30,000 - Outdoor sign Fair 1 Internal - - - - 56,000 - - - - - - - - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - 140,000 - - - - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - - 175,000 - - - - - - - - - - - - "Sebesta Type" evaluation of City Buildings - - 15,000 - - - - - - - - - - - - - - - - TOTAL 64,000$ 175,142$ 174,050$ 75,000$ 71,000$ 196,000$ 182,500$ -$ 94,223$ -$ 32,500$ 140,000$ 160,850$ 30,000$ 7,500$ 65,000$ 15,000$ 30,000$ 90,278$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - - 12,500 - - - - - 15,000 - - - - - - - 20,000 - Security upgrades -Cameras 2016 4 Internal - - - - - - - - 8,360 - - - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - 7,005 - - - - - - - - - - Rooftop Units Fair - Good Multi.Sebesta - - - - 31,000 - - - - - - - - - - - - - - Makeup Air Unit Fair 2 Sebesta - - - 17,500 - - - - - - - - 20,000 - - - - - - Domestic Water Heaters 2016 1 Sebesta - - - - - - 12,880 - - - - - - - - - 15,000 - - Relamp & Reballast Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - 35,000 - - - Roof Fair 1 Sebesta - - - - - 47,672 - - - - - - - - - - - - - Exterior Paint 2020 1 Internal - - - - - - - - - - - 4,500 - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - - - - 67,500 - - - STATION APPARATUS FLOOR 25 years 1 Internal - - - - - - - - - - 30,000 - - - - - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - - 35,000 - - - - - - - - - - - - Overhead garage doors 25 years 3 Internal - - - - - - - - - - 60,000 - - - - - - - - TOTAL -$ -$ -$ 30,000$ 31,000$ 47,672$ 47,880$ -$ 15,365$ 15,000$ 90,000$ 4,500$ 20,000$ -$ -$ 102,500$ 15,000$ 20,000$ -$ Public Works 2004 Building Components Metal Door Frame & Replacement Fair Internal - - - 7,500 - - - - - 9,000 - - - - - - - - - Security upgrades -Cameras 2016 3 Internal - - - - - - - - 6,990 - - - - - - - - 8,500 - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - 17,515 - - - - - - - - 22,000 - Rooftop Unit 2017 1 Sebesta - - - - - - 35,000 - - - - - - - - - - - - Makeup Air Unit Good 3 Sebesta - - - - - 19,250 - - - - - - - - - - - - - Air Handling Unit Good 1 Sebesta - - - - - 8,050 - - - - - - - - - - - - - Exhaust Fans Good 6 Sebesta - - - - - 13,340 - - - - - - - - - - - - - Domestic Water Heaters Good 2 Sebesta - - - - 25,861 - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - 210,000 - - - - - - - - - - - Overhead garage doors/Shop fixtures 25 years 7 Internal - - - - - - - - - 105,000 - - - - - - - - - Exterior Paint 2020 Internal - - - - - - - - - - - - - - - - - - - Tuck pointing -brick 30 years Internal - - - - - - - - - - - - - - - - - 75,000 - Parking Lot mill and overlay 30 years Internal - - - - - - - - - - - - - - 140,000 - - - - Rehab salt storage 25 years Internal - - - - - - - - - 40,000 - - - - - - - - - TOTAL -$ -$ -$ 7,500$ 25,861$ 40,640$ 35,000$ 210,000$ 24,505$ 154,000$ -$ -$ -$ -$ 140,000$ -$ -$ 105,500$ -$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACE D DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2021 EST ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Central Park Pavilion 2003 Roof 2018 - - - - - - - - - - - - - - - - - - - Security upgrades -Cameras 2016/2019 - - - - - - - - 8,360 - - - - - - - - - 10,000 Security upgrades - Entrance controls 2016/2019 - - - - - - - - 7,005 - - - - - - - - - 8,000 Other Technology 2019 1 Internal - - - - - 1,950 - - - - - 1,950 - - - - - - - HVAC 2020 - - - - - - - - - - - - - - - - - - - Domestic water heaters Fair - - - - - - - - - - - - - 5,000 - - - - - Exterior updates 2019 - - - - - - - - - 12,000 - - - - - - - - - Interior updates 2018 - - - - - - - - - 8,500 - - - - - - - - - Parking Lot mill and overlay 30 years - - - - - - 15,000 - - - - - - - - - - - - -$ -$ -$ -$ -$ 1,950$ 15,000$ -$ 15,365$ 20,500$ -$ 1,950$ -$ 5,000$ -$ -$ -$ -$ 18,000$ Emerald Park Pavilion 2009 - - - - - - - - - - - - - - - - - - - Roof Fair - - - - - 25,000 - - - - - - - - - - - - - Security upgrades -Cameras 2016 - - - - - - - - 8,360 - - - - - - - - - 10,000 Security upgrades - Entrance controls 2016 - - - - - - - - 7,005 - - - - - - - - - 8,000 HVAC Fair - - - - 14,000 - - - - - - - - - - - - - - Domestic water heaters Fair - - - - - 5,000 - - - - - - - 5,000 - - - - - Exterior updates Fair 10,000 - - 10,000 - - - - - - - - - - - - 15,000 - - Interior updates Fair 12,000 - - 12,000 - - - - - - - - - - - - 20,000 - - Parking Lot mill and overlay 30 years - - - - - - - - - - - 20,000 - - - - - - - 22,000$ -$ -$ 22,000$ 14,000$ 30,000$ -$ -$ 15,365$ -$ -$ 20,000$ -$ 5,000$ -$ -$ 35,000$ -$ 18,000$ Park Shelters 22,000$ -$ -$ 22,000$ 14,000$ 31,950$ 15,000$ -$ 30,730$ 20,500$ -$ 21,950$ -$ 10,000$ -$ -$ 35,000$ -$ 36,000$ TOTAL IMPROVEMENTS GOVERMENTAL 86,000$ 175,142$ 174,050$ 134,500$ 141,861$ 316,262$ 280,380$ 210,000$ 164,823$ 189,500$ 122,500$ 166,450$ 180,850$ 40,000$ 147,500$ 167,500$ 65,000$ 155,500$ 126,278$ Marketplace Liquor 2005 Building Components Rooftop Unit Fair 2 Sebesta - - - - 35,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - - 10,800 - 2,925 - - - - - - 12,000 - - - Security upgrades - Entrance controls 2017 1 Internal - - - - - - - - 5,915 - - - - - - - - 6,000 - Other Technology 2019 1 Internal - - - - - 1,890 - - - - - 1,890 - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - 5,500 - - - - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta - - - - -- - 15,000 - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - 15,000 - - - - - - - - Roof Fair 1 Sebesta - - - - - 36,398 - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ 40,500$ 38,288$ 10,800$ 15,000$ 8,840$ -$ 15,000$ 1,890$ -$ -$ -$ 12,000$ -$ 6,000$ -$ Silver Lake Liquor 2005 Building Components Rooftop Units Good 1 Sebesta - - - - 64,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - - 10,800 - 2,925 - - - - - - 12,000 - - - Security upgrades - Entrance controls 2017 Internal - - - - - - - - 5,915 - - - - - - - - 6,000 - Other Technology 2019 1 Internal - - - - - 1,890 - - - - - 1,890 - - - - - - - Exhaust Fans Good 1 Sebesta - - - - - - - - - - - - - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - 5,500 - - - - - - - - - - - - - - Finish Walk-In Cooler Refrigeration place Good 1 Sebesta - - - 4,500 - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - 15,000 - - - - - - - - Roof Fair 1 Sebesta - - - - - 42,782 - - - - - - - - - - - - - TOTAL -$ -$ -$ 4,500$ 69,500$ 44,672$ 10,800$ -$ 8,840$ -$ 15,000$ 1,890$ -$ -$ -$ 12,000$ -$ 6,000$ -$ TOTAL IMPROVEMENTS ENTERPRISE -$ -$ -$ 4,500$ 110,000$ 82,960$ 21,600$ 15,000$ 17,680$ -$ 30,000$ 3,780$ -$ -$ -$ 24,000$ -$ 12,000$ -$ COMBINED TOTAL IMPROVEMENTS 86,000$ 175,142$ 174,050$ 139,000$ 251,861$ 399,222$ 301,980$ 225,000$ 182,503$ 189,500$ 152,500$ 170,230$ 180,850$ 40,000$ 147,500$ 191,500$ 65,000$ 167,500$ 126,278$ Buildings 1996 St. Anthony Community Center St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Fire Station 2004 St. Anthony Public Works Facility Buildings 2005 St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Village Liquor Store Silver Lake Village Fiscal Year 2022 SOURCES 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Capital Improvement Levy 283,200$ 283,200$ 308,200$ 338,200$ 368,200$ 398,200$ 428,200$ 3,191,000$ 3,600,000$ MSA/Revolving Funds 90,000 90,000 90,000 90,000 90,000 90,000 90,000 540,000 540,000 Trade/Sale of Equipment 20,000 20,000 20,000 20,000 20,000 20,000 20,000 120,000 120,000 Donations/Grants - 14,950 - - - - - - 33,000 GF Excess Fund balance Transfer (1)- 125,000 140,000 - - - - - - Interest / Equipment note proceeds 7,250 7,250 3,500 2,500 626,350 1,500 1,500 754,000 12,000 TOTAL 400,450$ 540,400$ 561,700$ 450,700$ 1,104,550$ 509,700$ 539,700$ 4,605,000$ 4,305,000$ Uses Police 194,152$ 221,246$ 112,816$ 191,767$ 176,591$ 123,069$ 164,153$ 979,747$ 1,237,323$ Fire 96,823 126,012 91,942 83,490 241,180 313,482 199,053 2,061,054 1,448,787 Administration/Finance 20,550 52,092 33,116 17,000 65,525 50,618 40,000 124,403 103,012 Streets 21,612 31,700 128,039 45,357 64,093 75,522 - 175,518 348,908 Parks 33,927 23,577 78,607 65,757 4,352 16,479 144,244 282,175 405,124 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 367,065 454,626 444,520 403,371 551,741 579,170 547,449 3,622,896 3,543,153 NET CHANGE BEFORE BIG TICKET ITEMS BELOW 33,385$ 85,774$ 117,180$ 47,329$ 552,809$ (69,470)$ (7,749)$ 982,104$ 761,847$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines* - - - - 591,701 - - - - SCBA COMPLETE PACK - - - 277,200 - - - - - Dump Trucks (moved 1 DT to utility fund) - - - - 220,000 - - 270,108 331,870 2008 F750 High Ranger Aerial Truck - - - - - - 190,103 - - 1991 FIRE UTILITY TRUCK (rebuild vs replace) - - 105,000 - - - - - - 1999 Parks 4500 Tractor - - - 71,241 - - - - - SIGNIFICANT ITEMS - - 105,000 348,441 811,701 - 190,103 270,108 331,870 NET CHANGE 33,385$ 85,774$ 12,180$ (301,112)$ (258,892)$ (69,470)$ (197,853)$ 711,996$ 429,977$ BEGINNING CASH BALANCE 734,967$ 734,967$ 820,741$ 832,920$ 531,808$ 272,916$ 203,446$ 5,593$ 717,589$ ENDING CASH BALANCE 768,352$ 820,741$ 832,920$ 531,808$ 272,916$ 203,446$ 5,593$ 717,589$ 1,147,566$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE (1) 2021 Transfer based on Audited 2020 General Fund results and Fund balance policy, 2022 Transfer based on estimated General Fund operating result and Fund balance policy. CAPITAL EQUIPMENT 2022 - 2038 Fiscal Year 2022 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Police Department Squads 131,641 133,553 49,387 37,129 126,241 52,394 94,539 467,378 575,612 Unmarked - - 32,630 33,446 34,282 - - 116,579 135,231 Retired to Other Services 820 820 845 - 896 923 951 4,252 6,321 Technology 8,327 8,327 13,819 79,472 3,456 46,102 33,648 192,878 214,327 Specialty Equipment 12,767 12,929 8,636 9,817 10,111 8,569 19,689 101,455 114,740 Investigative Equipment 7,512 2,388 - - 965 3,955 - 11,008 8,810 General Equipment 33,086 63,230 7,500 31,902 640 11,125 15,326 86,197 182,282 TOTAL PD 194,152$ 221,246$ 112,816$ 191,767$ 176,591$ 123,069$ 164,153$ 979,747$ 1,237,323$ Fire Department Apparatus - - 105,000 - 591,701 65,000 9,000 769,159 - Station Based Equipment - - - - 1,920 13,183 - 112,966 69,774 Protective Gear - 19,140 14,478 277,200 51,197 6,592 9,777 117,454 98,215 Technology 11,126 17,296 9,015 10,340 6,640 7,796 679 52,715 54,656 Protective Equipment/Tools 10,000 14,500 2,650 4,000 27,855 62,643 10,100 73,561 54,085 Office Furniture 8,247 7,626 - 5,000 - 6,500 14,529 43,768 39,503 Debt Service Payments 67,450 67,450 65,800 64,150 153,568 151,768 154,968 891,431 1,132,553 TOTAL FD 96,823$ 126,012$ 196,942$ 360,690$ 832,881$ 313,482$ 199,053$ 2,061,054$ 1,448,787$ Administration/Finance Computer Hardware 10,550 11,550 18,464 12,000 10,525 15,618 - 87,932 48,012 Computer Software - 34,542 - - 55,000 - - 7,500 - Furniture and Equipment - - 5,000 - - 35,000 40,000 - 50,000 Council Chambers 10,000 6,000 9,652 5,000 - - - 28,971 5,000 TOTAL AF 20,550$ 52,092$ 33,116$ 17,000$ 65,525$ 50,618$ 40,000$ 124,403$ 103,012$ DEPARTMENTAL SUMMARIES 2022-2038 Fiscal Year 2022 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 DEPARTMENTAL SUMMARIES 2022-2038 PUBLIC WORKS Streets Department Fleet replacements - - 89,950 39,144 60,797 41,527 - 125,889 201,850 Plows/Dump trucks - - - - 220,000 - - 277,938 331,870 Heavy Equipment 5,051 7,500 - - - 32,105 190,103 - 71,426 Speciality Equipment 16,561 24,200 38,088 6,213 3,296 1,890 - 41,799 75,633 TOTAL 21,612$ 31,700$ 128,039$ 45,357$ 284,093$ 75,522$ 190,103$ 445,626$ 680,778$ Parks Department Fleet replacements - - 53,000 - - - 48,252 111,580 77,557 Heavy Equipment 5,857 - 5,857 73,727 - 13,183 63,151 46,073 40,707 Mowers 18,571 10,082 - 45,744 1,280 - 4,074 64,416 187,053 Field Maintenance 4,685 4,685 18,906 - - - 20,368 27,605 27,373 Rink Maintenance 586 - - 12,029 640 - 679 4,488 30,697 Speciality Equipment 4,228 8,809 845 5,499 2,432 3,296 7,720 28,013 41,735 TOTAL 33,927$ 23,577$ 78,607$ 136,998$ 4,352$ 16,479$ 144,244$ 282,175$ 405,124$ TOTAL PW 55,539$ 55,277$ 206,646$ 182,355$ 288,445$ 92,002$ 334,347$ 727,801$ 1,085,901$ GRAND TOTAL 367,065$ 454,626$ 549,520$ 751,812$ 1,363,442$ 579,170$ 737,553$ 3,893,004$ 3,875,023$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.092727 0 1.12550881 1.159274 1.1940523 1.229873865 1.2667701 1.304773 1.3439164 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.17131932 0 1.206458904 1.242653 1.2799323 1.318330219 1.3578801 1.398617 1.440575 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Active Squads 1674 711 2020 DODGE DODGE DURANGO SUV - PATROL 3-4 1 37,433 - - 38,243 - - - 43,043 - - - 48,445 - - - 54,526 - - TBD 706/714 2021 DODGE DODGE DURANGO - PATROL 3-4 1 39,876 50,523 52,435 - 50,868 - - - 57,253 - - - 64,439 - - - 72,526 - - TBD 707/712 2021 DODGE DODGE CHARGER - PATROL (3)3-4 1 39,377 40,559 40,559 - 37,129 - - 41,789 - - - 47,034 - - - 52,938 - - - TBD 708/713 2021 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 40,559 40,559 - - 52,394 - - - 58,970 - - - 66,372 - - - 74,702 - 1629 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3-4 1 43,335 - - 49,387 - - 53,966 - - - 60,740 - - - 68,363 - - - 76,943 1630 710 2018 DODGE DODGE CHARGER - PATROL 3-4 1 32,989 - - 37,129 - - 40,572 - - - 45,664 - - - 51,396 - - - 57,846 131,641 133,553 49,387 37,129 126,241 52,394 94,539 41,789 100,296 58,970 106,404 47,034 112,884 66,372 119,759 52,938 127,052 74,702 134,789 Unmarked 1557 6903 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - 32,630 - - - - 37,841 - - - - - 43,896 - - - - - 1600 6901 2017 CHEV CHEV IMPALA - CHIEF 6 1 23,000 - - - 33,446 - - - - 38,787 - - - - - 44,993 - - - - 1631 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 31,191 - - - - 34,282 - - - - 39,951 - - - - - 46,343 - - - - - 32,630 33,446 34,282 - - 37,841 38,787 39,951 - - - 43,896 44,993 46,343 - - - Retired To Other Services (1) 1558 702 2015 FORD FORD INTERCEPTOR SUV - CSO 7 1 700 - - 845 - - - 951 - - - 1,070 - - - 1,204 - - - 1,355 1577 698/706 2016 FORD FORD EXPLORER SUV - RESERVE 7 1 700 - - - - 896 - - - 1,008 - - - 1,135 - - - 1,277 - - 1482 UM 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 820 820 - - - 923 - - - 1,039 - - - 1,169 - - - 1,316 - 820 820 845 - 896 923 951 - 1,008 1,039 1,070 - 1,135 1,169 1,204 - 1,277 1,316 1,355 Technology NA NA 2018 VARIOUS SQUAD COMPUTERS 5 9 4,550 3,519 3,519 - 47,472 - 3,960 - - 55,033 - 4,729 - 63,799 - - - - 73,960 1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 13,000 - - - - - - - - - - 19,868 - - - - - - - - NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies varies 4,808 4,808 10,562 32,000 - 42,142 29,982 12,244 5,913 - - 34,757 51,829 14,203 - 7,273 40,293 - - NA NA VARIOUS VARIOUS PORTABLE/SQUAD RADIOS (2) varies varies varies - - 3,257 - 3,456 - 3,666 - - - 4,126 - 4,378 - 4,644 - 4,927 - 5,227 8,327 8,327 13,819 79,472 3,456 46,102 33,648 12,244 60,947 - 23,994 39,486 56,207 78,002 4,644 7,273 45,220 - 79,187 Specialty Equipment NA NA ~ 2005 VARIOUS REDMAN SUIT & TASER SUIT 15 1 ea 1,000 - - - - - 1,318 1,358 - - - - - - - - - - - - NA NA VARIOUS VARIOUS BULLET RESISTANT SHIELDS 5 2 2,500 - - - - 6,789 - - - - 7,871 - - - - - - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS)5 10 500 586 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 968 NA NA VARIOUS VARIOUS SAFETY GEAR CIVIL UNREST- 12 sets total 10 6/6 1,000 - - - - - - - - 8,643 - - - - 10,020 - - - - - NA NA VARIOUS VARIOUS TASERS/BATTERIES 5 23 1,500 3,514 3,514 3,619 3,728 3,840 3,955 4,074 4,196 4,322 4,451 4,585 4,722 4,864 5,010 5,160 5,315 5,475 5,639 5,808 NA NA VARIOUS VARIOUS FIREARMS 15 23+varies 2,343 1,512 2,413 2,485 2,560 2,637 2,716 2,797 2,881 2,968 3,057 3,148 3,243 3,340 3,440 3,543 3,650 3,759 3,872 NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 - - - - - - - 20,700 - - - - - - - 36,675 - - - NA NA VARIOUS VARIOUS SQUAD RADAR 4 7 1,200 2,811 2,811 - 2,982 3,072 - - 3,357 3,457 - - 3,778 3,891 - - 4,252 4,380 - - NA NA VARIOUS VARIOUS HAND HELD RADAR 10 2 3,000 - 992 2,000 - - - - - - - - - - - - - - - - NA NA 2014 VARIOUS BIKES 10 2 1,500 3,514 3,514 - - - - 4,074 - - - - - - - - - - - - 12,767 12,929 8,636 9,817 10,111 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 14,417 10,338 10,648 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.092727 0 1.12550881 1.159274 1.1940523 1.229873865 1.2667701 1.304773 1.3439164 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.17131932 0 1.206458904 1.242653 1.2799323 1.318330219 1.3578801 1.398617 1.440575 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP 5-7 7 500 4,100 - - 965 - - 4,895 - - 1,528 - - 1,670 - - 1,825 - - NA NA VARIOUS VARIOUS BOSCH SYSTEM 5 16 5,600 - - 5,000 - - - - - - - - - - - - - - - - NA NA ~2007 VARIOUS SURVEILLANCE EQUIPMENT (NIGHT VISION)10-15 1 3,000 3,412 2,388 - - - 3,955 - - - - 4,585 - - - - 5,315 - - - 7,512 2,388 - - 965 3,955 - 4,895 - - 6,113 - - 1,670 - 5,315 1,825 - - Administrative Equipment 1583 NA 2016 VARIOUS COPIER 1 7 11,250 - - - 13,573 - - - - 16,206 - - - - - 19,351 - - - - NA NA VARIOUS VARIOUS OFFICE COMPUTERS -18 / PRINTERS-2 6 20 750 - - - 17,708 - 2,966 - - 20,528 - 3,439 - - 23,798 - 3,986 - - 27,588 NA NA VARIOUS VARIOUS SCOUT UNIT 10 2 3,000 - - - - - - 8,147 - - - - - - - - - - - - NA NA VARIOUS VARIOUS MAIN OFFICE FURN/CHAIRS/FLOOR&DESK MATS 15 30+250 586 586 7,500 621 640 659 679 699 720 742 764 787 811 835 860 886 912 14,097 968 NA NA 2014 VARIOUS FRONT OFFICE FURNITURE / LOCKER ROOM 10-15 NA EST - - - - - 7,500 - - - - 35,000 - - - - 7,500 - - - NA NA VARIOUS VARIOUS FITNESS EQUIPMENT/CARPET 10-15 6-8 VAR - - - - - - 6,500 - - - - 6,500 - - - - 6,500 - - 1483 NA 2011 LETG RECORDS RETENTION MGMT SYSTEM 10-15 1 65K 32,500 62,644 - - - - - - - - - - - - 75,000 - - - 33,086 63,230 7,500 31,902 640 11,125 15,326 699 37,455 742 39,203 7,287 811 24,633 20,211 87,372 7,412 14,097 28,556 TOTAL POLICE 194,152 221,246 112,816 191,767 176,591 123,069 164,153 129,218 258,517 108,862 185,190 114,114 183,845 234,946 200,272 249,912 197,204 100,453 254,536 960,054 1,166,632 1,237,323 FOOTNOTES (1)EXTENDING LIFE OF ACTIVE/UNMARKED OFFICER VEHICLES WITH BUILD-UP/TEAR DOWN COSTS, ALSO REPLACES FIRE DEPARTMENT INSPECTION VEHICLE (2)PORTABLE RADIOS LEASED RATHER THAN PURCHASED IN 2018 (3)2020 SQUAD PURCHASE DEFERRED TO 2021 Police Department 1 2016 Ford Explorer (1) 2015, 2018 , 2020 Ford & Dodge SUV (3) 2017-2020 Dodge Charger (3) 2018 Ford Taurus 2016, 2017 Chevrolet Impala (3) 2011 Ford Fusion (1) FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.17131932 0 1.2064589 1.24265267 1.27993225 1.31833022 1.35788013 1.39861653 1.44057502 1.48379228 1.52830604 1.57415523 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.092727 0 1.12550881 1.15927407 1.1940523 1.22987387 1.26677008 1.30477318 1.34391638 1.38423387 1.42576089 1.46853371 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 ASSET REPLACEMENT PROGRAM 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Apparatus 1636 2018 CUSTOM FIRE ENGINE - 14 495,540 - - - - - - - - - - - - - - - - - - - 1154 1999 TOYNE ENGINE - 11 425,000 - - - - 591,701 - - - - - - - - - - - - - - 1288 2000 HME ENGINE - 12 425,000 - - - - - - - - 665,964 - - - - - - - - - - 1156 1991 ROAD RESCUE UTILITY TRUCK (rebuild vs replace) 150,000 - - 105,000 - - - - - - - - - - - - - - - - 1575 2016 FORD RESCUE - F350 80,000 - - - - - - - 103,195 - - - - - - - - - - - 1487 2011 FORD CHIEF VEHICLE 150 46,897 - - - - - 65,000 - - - - - - - - - - - - - 1385 2013 FORD INSPECTIONS VEHICLE (1) - - - - - - - - - - - - - - - - - - - 2006 BOAT - MOTOR REPLACEMENT 8,000 - - - - - - 9,000 - - - - - - - - - - - - - - 105,000 - 591,701 65,000 9,000 103,195 665,964 - - - - - - - - - - Station Based Equipment 1390 2006 COMPRESSOR (SCBA) 40,000 - - - - - - - - - - 62,966 - - - - - - - 2007 POWER WASHER 1,500 - - - - 1,920 - - - - - - - - - - - - - - 2003 TO WASHER DRYER 10,000 - - - - - 13,183 - - - - - - - - - - - - - 2003 STATION PAGING SYSTEM 50,000 - - - - - - - 50,000 - - - - - - - - - - - 1389 2006 STATION STANDBY GENERATOR 40,985 - - - - - - - - - - - - - - - 69,774 - - - - - - 1,920 13,183 - 50,000 - - - 62,966 - - - - 69,774 - - Protective Gear Various TURNOUT GEAR/ HELMENTS 2,000 - 5,795 - - 51,197 - - - - - 21,396 - - 66,801 - - - - - Various ROOKIE TURN OUT GEAR 2,000 - - 14,478 - - - - 16,783 - - - - 19,457 - - - - 22,555 - 2021 VESTS -CIVIL UNREST 890 - 13,345 Dated EMS COATS / PANTS 225 - - - - - - 9,777 - - - - - - - - - - - - 2001/2004 SCBA COMPLETE PACK 7,700 - - - 277,200 - - - - - - - - - - - - - - - Various SCBA BOTTLES/FACEPIECE 800 - - - - - - - - - - - 59,818 - - - - - - 2005 ICE RESCUE EQUIPMENT 1,250 - - - - - 6,592 - - - - - - - - - 8,859 - - - - 19,140 14,478 277,200 51,197 6,592 9,777 16,783 - - 21,396 59,818 19,457 66,801 - 8,859 - 22,555 - Technology 1501 Various PAGERS/BATTERIES 600 4,920 4,920 - 5,219 - 5,537 - 5,874 - 6,232 - 6,611 - 7,014 - 7,441 - 7,894 - 2018 NETWORK SWITCH 2,500 - - 2,500 - - - - 2,500 - - - - - 2,500 - - - - - 2019 WIFI ROUTER 1,600 - - - - - 1,600 - - - - - 1,600 - - - - - 1,600 - 2006 VEHICLE COMPUTERS 2,000 - - - - 6,000 - - - - 6,956 - - - - 8,063 - - - - Various OFFICE COMPUTERS 700 - - 5,912 - - - - 5,874 - - - - 6,810 - - - - 7,894 - 2021 CODE ENF SW - 6,170 2014 RADIOS/BATTERIES 2,500 5,621 5,621 - - - - - - - - - - - - - - - - - 2008 EOC TECHNOLOGY Various - - - 4,500 - - - 5,734 - - - - - 6,847 - - - - - Various OTHER BATTERIES 500 586 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 968 11,126 17,296 9,015 10,340 6,640 7,796 679 20,682 720 13,929 764 8,999 7,620 17,196 8,924 8,327 912 18,329 968 FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.17131932 0 1.2064589 1.24265267 1.27993225 1.31833022 1.35788013 1.39861653 1.44057502 1.48379228 1.52830604 1.57415523 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.092727 0 1.12550881 1.15927407 1.1940523 1.22987387 1.26677008 1.30477318 1.34391638 1.38423387 1.42576089 1.46853371 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 ASSET REPLACEMENT PROGRAM 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Protective Equipment/Tools 2017 DEFIBRILLATOR 1,700 - - - - 6,528 4,482 - - - - - 8,028 5,513 - - - - - 9,874 2017 DEFIBRILLATOR FOR POLICE DEPT 1,700 - - - - 6,528 6,723 - - - - - 8,028 8,269 - - - - - 9,211 Various HOSE REPLACEMENT 100-425 - - 2,650 - 2,800 - 2,800 - 3,000 - 3,000 - 3,250 - 3,250 - 3,500 - 3,750 Various HOSE APPLIANCES 150 3,000 3,000 - - - - - - - - - 4,722 - - - - - - - 1468 Various THERMAL IMAGER 6K-12K - - - - 12,000 - - - - 12,000 - - - - 12,000 - - - - 2021 NOZZLE REPLACEMENT & ACESSORIES 500 7,000 11,500 - - - - 7,300 - - - - 7,500 - - - - 7,700 - - 2013 LUCAS DEVICE 16,500 - - - - - 20,293 - - - - - - - - - - - - - Various FANS AND BLOWERS 2,400 - - - - - - - - - - - - - - 3,000 - - - - Various SAWS (CHAIN AND CUT OFF) 1,650 - - - 4,000 - - - 4,500 - - - - 5,000 - - - - - - Various GAS MONITOR/ CARBON MNX DTC 600 - - - - - 1,350 - - 750 - - - - - 1,800 - - - - 1290 Various OUTDOOR WARNING SIRENS 22,600 - - - - 29,794 - - - - - - - - - - - - - 10,000 14,500 2,650 4,000 27,855 62,643 10,100 4,500 3,750 12,000 3,000 28,279 22,032 - 20,050 - 11,200 - 22,835 Office Furniture 2004 OFFICE CHAIRS/FURNITURE 315 - - - 5,000 - - - 6,000 - - - - 6,000 - - - - - 6,500 2004 TRAINING ROOM CHAIRS 85 - - - - - - - - - - 10,000 - - - - - - - - 2004 DAY ROOM/KITCHEN/APPLIANCES 600 2,047 2,047 - - - - - - - 2,671 2,751 - - - - - - - - 2014 COPIER 6,200 6,200 5,579 - - - - 8,419 - - - - - 10,053 - - - - - 12,003 2003 FITNESS EQUIPMENT 4,500 - - - - - 6,500 6,110 6,294 - - - - - - - 6,800 7,000 7,200 - 8,247 7,626 - 5,000 - 6,500 14,529 12,294 - 2,671 12,751 - 16,053 - - 6,800 7,000 7,200 18,503 29,373 58,562 131,142 296,540 679,313 161,714 44,085 207,454 670,435 28,600 37,911 160,062 65,161 83,997 28,974 23,986 88,887 48,084 42,306 FIRE ENGINE DEBT SERVICE 67,450 67,450 65,800 64,150 153,568 151,768 154,968 153,018 86,068 86,068 188,759 188,759 188,759 188,759 188,759 188,759 188,759 188,759 188,759 96,823 126,012 196,942 360,690 832,881 313,482 199,053 360,472 756,503 114,668 226,670 348,820 253,920 272,756 217,732 212,745 277,646 236,843 231,065 500,000 29,373 58,562 131,142 296,540 241,180 161,714 44,085 207,454 670,435 (471,400) 1,970,848 160,062 65,161 83,997 28,974 23,986 1,583,619 1,471,642 1,448,787 FOOTNOTES (1) REPLACED 2006 SUV WITH RETIRING 2013 POLICE RESERVE SUV IN 2021 (2)2020 COPIER PURCHASE DEFERRED TO 2021 Fire Department 2016 Rescue 11 1999 Engine 11 2 2000 Engine 12 1991 Utility 11 2011 Staff Vehicle 2018 Engine 14 5 6 7 8 Fire Department 2006 Inspections Vehicle 2006 Boat and Motor 2006 Compressor FIXED ASSET SCHEDULE ADMINISTRATION/FINANCE ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 / 2017 NETWORK ACCESS DEVICES (METRO I-NET ) 7 5 1,500 10,550 10,350 5,486 - 7,325 15,618 - - 11,903 6,309 - 8,424 17,961 - - 13,688 7,255 - 9,687 UNASSIGNED 2018 WIFI ROUTERS 6 4 800 - - - - 3,200 - - - - - 3,200 - - - - - 3,200 - - UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 - - - 12,000 - - - - - - - 13,000 - - - - - - - NA VARIOUS COMPUTER EQUIPMENT 6 14 900 - 1,200 12,978 - - - - 13,367 - - - - 13,768 - - - - 14,181 - 10,550 11,550 18,464 12,000 10,525 15,618 - 13,367 11,903 6,309 3,200 21,424 31,729 - - 13,688 10,455 14,181 9,687 Computer Software 1532/1639 2012 FINANCIAL SOFTWARE (CIVIC) 15 1 55,000 - 2,000 - - 55,000 - - - - - - - - - - - - - - UNASSIGNED 2014 LASERFICHE 15 1 7,000 - - - - - - - - 7,500 - - - - - - - - - - 2020/2021 LQ SOFTWARE CURBSIDE PICK UP - 32,542 - - - - - - - - - - - - - - - - - 1641 2018 POS LIQUOR CC SYSTEM MP 15 1 9,030 - - - - - - - - - - - - - - - - - - - 1642 2018 POS LIQUOR CC SYSTEM SLV 15 1 9,030 - - - - - - - - - - - - - - - - - - - - 34,542 - - 55,000 - - - 7,500 - - - - - - - - - - Furniture and Equipment 1581RC NA ELECTION MACHINES & EQUIPMENT 10 2 10,000 - - - - - 35,000 - - - - - - - - - 40,000 - - - 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS - - 5,000 - - - 40,000 - - - - - - 10,000 - - - - - - - 5,000 - - 35,000 40,000 - - - - - - 10,000 - 40,000 - - - Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS - - - 5,000 - - - - 5,000 - - - - 5,000 - - - - - MULTIPLE VARIOUS COUNCIL CHAMBERS CAMERAS (1) 10 5 8,200 - - - - - - - - - - - - - - - - - - - NA VARIOUS COUNCIL CHAMBERS COMPUTER/MONITORS 7-10 4 1,750-8,000 - - 9,652 - - - - - - - - - 12,971 - - - - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS 10,000 6,000 - - - - - - - 11,000 - - - - - - - - - 10,000 6,000 9,652 5,000 - - - - 5,000 11,000 - - 12,971 5,000 - - - - - TOTAL ADMIN/FINANCE 20,550 52,092 33,116 17,000 65,525 50,618 40,000 13,367 24,403 17,309 3,200 21,424 44,700 15,000 - 53,688 10,455 14,181 9,687 (1) ALL BROADCAST EQUIPMENT NOW INCLUDED IN A/V UPGRADES ESTIMATED ACTUAL FIXED ASSET SCHEDULE PUBLIC WORKS STREETS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2015 1536 2014 CHEVY 5 PW DIRECTOR - SEDAN 10 1 22,000 - - 32,643 - - - - - - - - - 52,927 - - - - - - 1464 2010 FORD 1 F150 PICKUP 15 1 31,500 - - - - - 41,527 - - - - - - - - - - - - - 1409 2007 FORD 2 F150 4X4 15 1 31,500 - - - 39,144 - - - - - - - - - - - - - - 60,984 1657 2020 FORD 6 F150 PICKUP 4X4 15 1 31,500 - - - - - - - - - - - - - - 54,184 - - - - 1601 2017 FORD 8 F350 PICKUP 4X4 15 1 45,000 - - - - - - - - - - - - 72,962 - - - - - - 1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - 60,797 - - - - - - - - - - - - - - 1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - 57,307 - - - - - - - - - - - - - 86,682 - - 256,500 - - 89,950 39,144 60,797 41,527 - - - - - - 125,889 - 54,184 - 86,682 - 60,984 1508 2013 IHC 14 7400 DUMP TRUCK 15-25 1 181,859 - - - - - - - - - - - - - - - - 331,870 - - 1186 2003 STERLING 11 M8500 DUMP TRUCK 15-25 1 187,500 - - - - - - - - 270,108 - - - - - - - - - - 1181 1995 FORD 12 L8000 DUMP TRUCK 15-25 1 187,500 - - - - 220,000 - - - - - - - - - - - - - - 1582 2016 WESTERN 8 FT PLOW BLADE 15 1 6,682 - - - - - - - - - - 7,830 - - - - - - - - 563,541 - - - - 220,000 - - - 270,108 - 7,830 - - - - - 331,870 - - 1450 2010 VERMEER BRANCH CHIPPER 15 1 32,105 - - - - - 32,105 - - - - - - - - - - - - - 1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - - 190,103 - - - - - - - - - - - - 1670 2021 BOBCAT BOBCAT 20 1 6,000 5,051 7,500 - - - - - - - - - - - - - - - 71,426 - 1669 2020 JOHN DEERE 524L 524L FRONT END LOADER 20 1 160,000 - - - - - - - - - - - - - - - - - - - 338,105 5,051 7,500 - - - 32,105 190,103 - - - - - - - - - - 71,426 - 2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - - - 2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - - - 6,429 - - - - - - - - - - 1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - 6,213 - - - - - - - - - - - - - - - 1656 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - - - - - - - - - 1671 2020 WACKER NEUSON WACKER NEUSON RD12A-90 ROLLER 15-20 1 15,000 - - - - - - - - - - - - - - - - - - - 1672 2020 STEPP SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 - - - - - - - - - - - - - - - - - - - 1997 WHACKER WP 1550AW VIBROPLATE 15-20 1 3,000 - - 3,619 - - - - - - - - - - - - - - - - 2018 ERSKINE 1600 2418 - 61" SNOWBLOWER (1) 15-20 1 5,000 - - - - - - - - - - - - - - - - 8,000 - - 1999 BOBCAT 70" ANGLE BROOM 15-20 1 10,000 - - 11,372 - - - - - - - - - - - - - - - - 1183 2021 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 16,561 16,561 - - - - - - - - - - - - - - - - - 1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 - - 18,097 - - - - - - - - - - - - - - - - 2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - - - - 3,542 - - - - - - - 1579 2016 GRACO LINELAZER STREETS PAINTER 3900 13 1 10,000 - - - - - - - - - 14,838 - - - - - - - - - **NEW CADLINK VINYL CUTTER/PRINTER 15 1 7,500 - - - - - - - - - - - - - 11,344 - - - - - NETWORK SWITCH 6 1 1,290 - - - - - 1,290 - - - - - 1,290 - - - - - 1,290 - WIFI ROUTER 6 1 600 - - - - - 600 - - - - - 600 - - - - - 600 - GARAGE & OFFICE COMPUTERS 6 4 800 - - - - 3,296 - - - - - - - - - - - - - - 1675 2020 GASBOY GAS PUMPS 15-20 2 15,270 - - - - - - - - - - - - - - - 45,000 - - - WELDER 25 1 5,000 - - 5,000 - - - - 6,993 - - - - 8,107 - - - - 9,398 - PW SUPER OFFICE BUILD-OUT / COMPUTER 6,650 RADIOS 989 269,360 16,561 24,200 38,088 6,213 3,296 1,890 - 6,993 6,429 14,838 - 5,432 8,107 11,344 - 45,000 8,000 11,288 - TOTAL STREETS 21,612 31,700 128,039 45,357 284,093 75,522 190,103 6,993 276,537 14,838 7,830 5,432 133,996 11,344 54,184 45,000 426,551 82,714 60,984 - - - - 270,108 - - ####### 501,733 753,789 680,778 21,612 31,700 128,039 45,357 284,093 75,522 190,103 6,993 6,429 14,838 7,830 5,432 133,996 11,344 54,184 45,000 426,551 82,714 60,984 FOOTNOTES (1) REPLACEMENT MADE RETAINED FOR BACKUP (2)NOT SCHEDULED FOR REPLACEMENT Specialty Equipment Fleet Plows/Dump Trucks Heavy Equipment 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL — ϮϬϭϰŚĞǀƌŽůĞƚDĂůŝďƵ ϮϬϭϬ&ŽƌĚ&ϭϱϬWŝĐŬƵƉ ϮϬϭϵ&ŽƌĚ&ϭϱϬϰdžϰ ϮϬϬϴ&ŽƌĚ&ϰϱϬ DŝŶŝƵŵƉϮdŽŶϰdžϰ ϮϬϬϲ&ŽƌĚ&ϰϱϬ DŝŶŝƵŵƉϮdŽŶϰdžϰ ϮϬϭϳ&ŽƌĚ&ϯϱϬWŝĐŬƵƉ — ϮϬϬϰ&ŽƌĚ&ϭϱϬWŝĐŬƵƉϰdžϰ — Ȁ ϮϬϬϯ^ƚĞƌůŝŶŐDϴϱϬϬĐƚĞƌƌĂ ϮϬϭϯ/ŶƚĞƌŶĂƟŽŶĂůϳϰϬϬ ƵŵƉdƌƵĐŬ ϭϵϵϱ&ŽƌĚ>ϴϬϬϬƵŵƉdƌƵĐŬ ϮϬϭϴ/ŶƚĞƌŶĂƟŽŶĂůϳϱϬϬ ƵŵƉdƌƵĐŬ — ϮϬϭϭsĞƌŵĞĞƌϭϱϬϬŚŝƉƉĞƌ ϮϬϬϴ&ŽƌĚ&ϳϱϬ ,ŝŐŚZĂŶŐĞƌĞƌŝĂůdƌƵĐŬ ϮϬϮϬŽďĐĂƚZĞƉůĂĐĞŵĞŶƚ WƌŽŐƌĂŵ ϮϬϮϬ:ŽŚŶĞĞƌĞϱϮϰ>&ƌŽŶƚ ŶĚ>ŽĂĚĞƌ — ϮϬϭϵ^ƚĞƉƉƌĂĐŬ^ĞĂůĞƌ ϮϬϮϬ^ƚĞƉƉ^W,-Ϯ͘Ϭ ƐƉŚĂůƚ,ŽƚŽdž ϭϵϵϴdŽǁŵĂƐƚĞƌd-ϱd ^ŝŶŐůĞdžĞůdƌĂŝůĞƌ ϭϵϵϵdŽǁŵĂƐƚĞƌd-ϭϬ ddĂŶĚĞŵdžĞůdƌĂŝůĞƌ ϮϬϭϲ^ƚƌĞĞƚƐWĂŝŶƚĞƌdƌĂŝůĞƌ ϮϬϭϲ>ŝŶĞůĂnjĞƌ^ƚƌĞĞƚƐWĂŝŶƚĞƌ ϯϵϬϬ — ϭϵϵϮ>ĞƌŽLJYϭϴϱŝƌŽŵƉƌĞƐƐŽƌ ϮϬϮϬtĂĐŬĞƌEĞƵƐŽŶZŽůůĞƌ FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 1379 2006 FORD 20 F350 MINI DUMP 1 TON 4X4 15 1 42,500 - - 53,000 - - - - - - - - - - - - - 77,557 - - 1516 2014 FORD 18 F250 CREW CAB FLATBED 15 1 37,500 - - - - - - - - - 55,642 - - - - - - - - - 1462 2011 FORD 21 F250 PICKUP 4X4 15 1 34,500 - - - - - - 48,252 - - - - - - - - - - - - 1604 2017 FORD 22 F250 PICKUP 4X4 15 1 34,500 - - - - - - - - - - - - 55,938 - - - - - - 149,000 - - 53,000 - - - 48,252 - - 55,642 - - 55,938 - - - 77,557 - - 1562 2015 BOBCAT BOBCAT 3400G UTIL VEH (ATV) 10 1 10,000 - - - - - 13,183 - - - - - - - - - 17,717 - - - 1188 1999 JOHN DEERE 38 4500 TRACTOR 15-25 1 35,000 - - - 43,493 - - - - - - - - - - - - - - - 1999 JOHN DEERE 20" PTO AUGER (W/ TRACTOR) 15-25 1 8,000 - - - 9,652 - - - - - - - - - - - - - - - 1999 JOHN DEERE 72" FLAIL MOWER (W/ TRACTOR) 15-25 1 15,000 - - - 18,097 - - - - - - - - - - - - - - - 1488 2011 BOBCAT 36 TOOL CAT 5600 (V-Blade, Snblw, BF Drag) 15 1 46,507 - - - - - - 63,151 - - - - - - - - - - - - 2012 MB HT HYDRAULIC TRACTOR SWEEPER 15 1 15,000 - - - - - - - 20,979 - - - - - - - - - - - 1634 2020 GIANT-VAC 2501 LEAF VACCUM ATTACHMENT 10 1 6,320 - - - - - - - - - - - - 10,247 - - - - - - N/A 2020 TRAC VAC 1070 LEAF MOWER ATTACHMENT 10 1 4,395 - - - - - - - 6,147 - - - - 7,126 - - - - - - 2019 BIG TEX TRAILER 15 1 7,000 - - - - - - - - - - - - - - 12,041 - - - - 2006 CARRY-ON TRAILER 5X8 2000 LBS 15 1 5,000 5,857 - 5,857 - - - - - - - - - - - - - 9,124 - - 2001 TRAFFIC CT JR ROAD COUNTER 15 1 1,000 - - - - - - - - - - - 1,574 - - - - - - - 2000 HONDA 1400W GENERATOR 15 1 1,000 - - - - - - - - - - - - - - - - 1,825 - - 1974 VERMEER TREE SPADE 25+ 1 VARIES - - - - - - - - - - - - - - - - - - - 1974 GIBSON CEMENT MIXER 25+ 1 2,000 - - - 2,485 - - - - - - - - - - - - - - - 156,222 5,857 - 5,857 73,727 - 13,183 63,151 27,126 - - - 1,574 17,373 - 12,041 17,717 10,949 - - TBD 2021 TORO 47 GRANDSTAND MOWER (SPRD., VAC ) 15 1 17,500 18,571 10,082 - - - - - - - - - - - - - - 31,935 - - 1491 2011 TORO 45 GROUNDSMASTER 360 (BLW, SWP, CAB) 15 1 37,916 - - - 45,744 - - - - - - - - - - - - - - 53,030 1578 2016 TORO ZERO TURN MOWER 5000 MYRIDE 60" 15 1 25,000 - - - - - - - - - - - 39,354 - - - - - - - 1673 2020 VENTRAC 4500Z KUBOTA SLOPE MOWER 15 1 55,000 - - - - - - - - - - - - - - - - 100,368 - - 1606 2017 TORO 48 Z MASTER G3 MOWER 15 1 15,000 - - - - - - - - - - - - 24,321 - - - - - - 2014 TORO LAWN MOWER 10 1 500 - - - - 640 - - - - - - - - - 860 - - - - 2014 TORO LAWN MOWER 10 1 500 - - - - 640 - - - - - - - - - 860 - - - - 2005 HONDA PUSH MOWER 10 1 500 - - - - - - - - - 742 - - - - - - - - - 1975 JERRI JERRI SICLE MOWER 25+ 1 3,000 - - - - - - 4,074 - - - - - - - - - - - - 163,416 18,571 10,082 - 45,744 1,280 - 4,074 - - 742 - 39,354 24,321 - 1,720 - 132,304 - 53,030 1580 2016 GRACO LINELAZER FIELD PAINTER 10 1 15,000 - - - - - - 20,368 - - - - - - - - - 27,373 - - 1999 INFIELD BLUES BALL FIELD DRAG/SCARIFIER/GROOMER 15 1 4,000 4,685 4,685 - - - - - - - - - 6,297 - - - - - - - 2002 RYAN SOD CUTTER 20 1 5,000 - - 6,032 - - - - - - - - - - - - - - - - 1999 JOHN DEERE 3 PT POST HOLE AUGER HAND 15 1 2,000 - - - - - - - - - - - - 3,243 - - - - - - 2012 LAND PRIDE CA 1572 AIRATOR 10 1 2,500 - - 3,016 - - - - - - - - - 4,053 - - - - - - 1490 2012 LAND PRIDE OS 1548 SLIT SEEDER 10 1 8,171 - - 9,857 - - - - - - - - - 13,248 - - - - - - 39,171 4,685 4,685 18,906 - - - 20,368 - - - 764 6,297 20,544 - - - 27,373 - - 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Fleet Field Maintenance Mowers Heavy Equipment FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL NA SHOP MADE RINK ICE SHAVER (1) 10 1 5,000 - - - - - - - - - - - - - - - - - - - NA LITTLE WONDER SHO WALK BLOWER 5HP 5 1 500 586 - - - - - 679 - - - - 787 - - - - 912 - - 1633 2018 ES1600 SNOWBLOWER 15 1 5,786 - - - - - - - - - - - - - 9,663 - - - - - NA TORO CCR POWERLITE 20" SNOWBLOWER 5 1 500 - - - - 640 - - - - 742 - - - - 860 - - - - NA MB MCD-WB WALK BEHIND BROOM 10 1 1,800 - - - - - - - - - 2,671 - - - - 3,096 - - - - NA STIHL KW 85 PADDLE BROOM 5 1 200 - - - 249 - - - - 288 - - - - 334 - - - - - NA JOHN DEERE ICE RINK BROOM 10 1 9,480 - - - 11,780 - - - - - - - - - 15,832 - - - - - 23,266 586 - - 12,029 640 - 679 - 288 3,413 - 787 - 25,829 3,956 - 912 - - 2021 VARIOUS WEED WHIPS -Electric 5 4 VARIES 305 1,500 - 2,037 - - - - 2,361 - - - - 2,737 2,819 2,904 NA VARIOUS CHAIN SAWS 5 5 VARIES 586 96 - - - - 679 - - - - 787 - - - - 912 940 968 2021 STIHL LEAF BLOWERS- ELECTRIC 5 5 VARIES 234 2,500 - - - - 3,935 - - - - 365 376 387 2021 STIHL BACKPACK LEAF BLOWERS -ELECTRIC 5 2 300 - 600 - - - 791 - - - - 917 - - - - 1,063 - - - NA BROYHILL WEED SPRAYER 5 1 2,500 - - - 3,107 - - - - 3,601 - - - - 4,175 - - - - - NA EARTHWAY FERTILIZER SPREADER 5 1 400 - - - - - 527 - - - - 611 - - - - - - - - NA VARIOUS EDGERS 5 3 VARIES 586 586 - 186 - - 679 - 216 - - 787 - 251 - - 912 940 968 2021 VARIOUS TRIMMERS - ELECTRIC 5 4 VARIES 176 1,185 - - - - 1,609 - - - - 1,865 - - - - 274 282 290 NA STIHL FS 86 BRUSH CUTTER 5 1 200 - - 241 - - - - 280 - - - - 324 - - - - - - NA NA WHEEL BLOWER 5 1 275 - - - 342 - - - - 396 - - - - 459 - - - - - NA STIHL HT75 POLE PRUNER 14' 5 1 400 - - - - 512 - - - - 594 - - - - 688 - - - - NA SHOP MADE SIGN PAINTING TRAILER 10 2 1,500 - - - - - 1,977 - - - - 2,292 - - - - 2,658 - - - NA NA TRAFFIC WARNING SIGNS 5 MLTP 2,000 2,343 2,343 - - - - 2,716 - - - - 3,148 - - - - 3,650 3,759 3,872 NA NA TRAFFIC WARNING CONES 5 MLTP 500 - - 603 - - - - 699 - - - - 811 - - - - - - NA NA TRAFFIC WARNING BLINKER BARRICADE 5 MLTP 1,500 - - - 1,864 - - - - 2,161 - - - - 2,505 - - - - - NA NA TRAFFIC WARNING BARRICADES 5 MLTP 1,500 - - - - 1,920 - - - - 2,226 - - - - 2,580 - - - - NA NA EVENT BARRICADES 5 MLTP 1,500 - - - - - - - - - - - - - - - - - - - PARK SIGNAGE 3,200 - 3,200 - - - - 4,345 - - - - 5,037 - - - - 5,840 - - 18,985 4,228 8,809 845 5,499 2,432 3,296 7,720 979 6,375 2,819 3,821 12,884 1,135 7,390 3,268 3,721 8,851 9,116 9,390 TOTAL PARKS 33,927 23,577 78,607 136,998 4,352 16,479 144,244 28,105 6,663 62,616 4,585 60,896 119,310 33,218 20,985 21,438 257,946 9,116 62,419 FOOTNOTES 307,109 462,015 405,124 (1) NOT SCHEDULED FOR REPLACEMENT 33,927 23,577 78,607 136,998 4,352 16,479 144,244 28,105 6,663 62,616 4,585 (246,212) 119,310 33,218 20,985 21,438 257,946 (452,898) (342,704) Parkland/Sidewalks/Trees Rink Maintenance - ϮϬϭϰ&ŽƌĚ&ϮϱϬ&ůĂƚďĞĚ ϮϬϭϳ&ŽƌĚ&ϮϱϬWĂƌŬhƟůŝƚLJϰdžϰ ϮϬϬϲ&ŽƌĚ&ϯϱϬ DŝŶŝƵŵƉϭdŽŶϰdžϰ ϮϬϭϭ&ŽƌĚ&ϮϱϬWŝĐŬƵƉϰdžϰ - ϮϬϭϱŽďĐĂƚϯϰϬϬ'hds ϮϬϭϴ ĐŚŽĞĂƌĐĂƚdŽǁĞŚŝŶĚ sĂĐƵƵŵĞďƌŝƐ>ŽĂĚĞƌ ϮϬϭϭŽďĐĂƚdŽŽůĂƚϱϲϬϬ ϮϬϭϮ,LJĚƌĂƵůŝĐdƌĂĐƚŽƌ^ǁĞĞƉĞƌ ^ŝĚĞǁĂůŬƐĂŶĚ/ĐĞZŝŶŬƐ ϮϬϭϵŝŐdĞdžϭϴ͛dĂŶĚĞŵ WĂƌŬhƟůŝƚLJdƌĂŝůĞƌ - ϮϬϮϬdƌĂĐ-sĂĐDŽǁĞƌ ƩĂĐŚŵĞŶƚ ϭϵϵϵ:ŽŚŶĞĞƌĞϰϱϬϬdƌĂĐƚŽƌ ϮϬϮϬ'ŝĂŶƚ-sĂĐ>ĞĂĨĂŶĚ ĞďƌŝƐdƌƵĐŬ>ŽĂĚĞƌ ϭϵϳϰsĞƌŵĞĞƌdƌĞĞ^ƉĂĚĞ - ϮϬϮϭdŽƌŽ'ƌĂŶĚƐƚĂŶĚDŽǁĞƌ ϮϬϭϭdŽƌŽ'ƌŽƵŶĚƐDĂƐƚĞƌϯϲϬ ϮϬϮϬsĞŶƚƌĂĐϰϱϬϬ ^ůŽƉĞDŽǁĞƌ ϮϬϭϳdŽƌŽDĂƐƚĞƌ 'ϯϱϬϬϬDŽǁĞƌ ϮϬϭϲdŽƌŽĞƌŽdƵƌŶDŽǁĞƌ ϱϬϬϬDzZ/ ϲϬ͟ - ϮϬϭϲ>ŝŶĞůĂnjĞƌ&ŝĞůĚWĂŝŶƚĞƌ Fiscal Year 2022 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 SOURCES Park Dedication Fees 7,500$ 259,000$ 25,000$ 1,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ Park improvement levy - - 5,000 10,000 15,000 20,000 25,000 250,000 300,000 Interfund Loans / Transfers - 180,000 - - - - - - - Donations 850 850 900 900 900 900 900 5,795 5,853 TOTAL 8,350$ 439,850$ 30,900$ 12,400$ 17,400$ 22,400$ 27,400$ 264,795$ 314,853$ USES Central Park -PD Fee 1,200 - - - - - - - - Central Park -PI Levy - - Emerald Park -PD Fee 1,200 - - - - - - - - Emerald Park -PI Levy - - Salo Park -PD Fee - - - - - - - - - Salo Park - PI Levy - - Silver Point Park -PD Fee 1,200 2,521 - - - - - - - Silver Point Park -PI Levy - - Trillium Park -PD Fee - - - - - - - - - Trillium Park -PI Levy - - Water Tower Park -PD Fee - - - - - - - - - Water Tower Park -PI Levy - 171,222 WSB Park Evaluation study - 7,700 Interfund loan payments - 4,500 4,613 4,728 14,848 17,098 118,686 76,885 TOTAL 3,600 181,443 - - - - - - - NET CHANGE -PD Fee 3,900$ 256,479$ 25,000$ 1,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ NET CHANGE -PD Levy 850 1,078 500 5,387 10,272 5,152 7,902 131,314 223,115 BEG. CASH BAL. -PD Fee 65,913 65,913 322,392 347,392 348,892 350,392 351,892 353,392 362,392 BEG. CASH BAL. -PI Levy - - 1,078 1,578 6,965 17,237 22,389 30,291 161,605 END CASH BAL. -PD Fee 69,813$ 322,392$ 347,392$ 348,892$ 350,392$ 351,892$ 353,392$ 362,392$ 371,392$ END CASH BAL. -PI Levy 850$ 1,078$ 1,578$ 6,965$ 17,237$ 22,389$ 30,291$ 161,605$ 384,720$ PARK IMPROVEMENT 2022 - 2038 PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2021 Est Actual 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Central Park 2003 Park Amenities LEVY Signage -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ LEVY Ballfields - multi-use - - - - - - - - - - - - - - - - - - - LEVY Ballfields - soccer - - - - - - - - - - - - - - - - - - - LEVY Batting Cages - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment 1,200 - - - - - - - - - - - - - - - - - - PD Skateboard Park - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - - - TOTAL 1,200$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Emerald Park 2009 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - - LEVY Ballfields - multi-use - - - - - - - - - - - - - - - - - - - LEVY Ballfields - soccer - - - - - - - - - - - - - - - - - - - LEVY Basketball Half-Court - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment 1,200 - - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - - - TOTAL 1,200$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Salo Park 2006 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - - LEVY Amphitheater - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2021 Est Actual 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Silver Point Park 1998 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - - LEVY Ballfields - multi-use - - - - - - - - - - - - - - - - - - - LEVY Basketball Full-Court - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment 1,200 2,521 - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - - LEVY Drinking Fountains - - - - - - - - - - - - - - - - - - - PD New hockey rink - - - - - - - - - - - - - - - - - - - TOTAL 1,200$ 2,521$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Trillium Park 1980 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - - LEVY Fountain - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Water Tower Park 2004 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - - LEVY Basketball Half-Court REMOVED - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment - - - - - - - - - - - - - - - - - - - LEVY Tennis Courts / Repairs Resurface 180,000 171,222 - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - - TOTAL 180,000$ 171,222$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL PARK IMPROVEMENTS 183,600$ 173,743$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS Parks Park Amenities Amphitheater Ballfields - multi-use Ballfields - soccer Basketball Courts Batting Cages Off-Street Parking Picnic Area Play Equipment Shelter Skateboard Park Skating Rink - general Skating Rink - hockey Tennis Courts Walking Paths Splash Pads Central Park—2003 X X 1/2 X X X X X X X X X X Emerald Park —2009 X X 1/2 X X X X X X X X Salo Park—2006 X X Silver Point Park— 1998 X X X X X X X X X Trillium Park—1980 X Water Tower Park— 2004 X X X X X Fiscal Year 2022 SOURCES 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Interfund Loan collections (1)45,766 45,766 204,767 198,076 191,385 179,074 172,679 166,283 - Utility Fund Transfer (2)- - - - 25,000 35,000 35,000 225,000 1,350,000 Connection fees 255,000 521,900 40,000 300,000 - - - - - Interest and other income 17,900 17,900 16,000 15,000 16,100 15,000 15,000 65,000 62,700 TOTAL 318,666$ 585,566$ 260,767$ 513,076$ 232,485$ 229,074$ 222,679$ 456,283$ 1,412,700$ USES Water Infrastructure 33,843 22,843 52,500 197,675 43,450 72,100 97,500 1,335,536 294,424 Water Equipment 40,212 41,174 905 191,933 2,200 43,781 11,949 24,390 342,825 Sewer Infrastructure 15,000 - - - - 10,000 - 15,000 60,000 Sewer Equipment 5,073 5,073 905 1,933 2,200 43,781 11,949 137,886 342,825 Fiber Infrastructure - - 115,000 - - - - 22,000 29,000 TOTAL 94,128$ 69,089$ 169,310$ 391,542$ 47,850$ 169,661$ 121,399$ 1,534,812$ 1,069,073$ NET CHANGE 224,538$ 516,477$ 91,457$ 121,535$ 184,635$ 59,413$ 101,280$ (1,078,529)$ 343,627$ BEGINNING CASH BALANCE 3,229,706 3,229,706 3,746,183 3,837,640 3,959,175 4,143,810 4,203,223 4,304,503 3,225,974 ENDING CASH BALANCE 3,454,244$ 3,746,183$ 3,837,640$ 3,959,175$ 4,143,810$ 4,203,223$ 4,304,503$ 3,225,974$ 3,569,601$ (1) Principal collection of $959,326 estimated to begin 2022. (2) Utility Fund Transfer available after retirement of Water Bonds in 2024 UTILITIES INFRASTRUCTURE 2022 - 2038 UTILITES INFRASTRUCTURE PLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM 1.092727 0 1.12550881 1.159274074 1.194052297 1.229873865 1.266770081 1.304773184 1.343916379 1.384233871 1.425760887 1.468533713 1.512589725 1.557967417 DEPT PURPOSE DESCRIPTION 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Plant Facilities AOP Plant Electrical Panels serviced - placeholder - - - - - - - - - - 175,000 - - - - - - - - Peroxide Equipment - placeholders - - - - - - - 25,000 - - - - - - 15,000 - - - GAC / Iron plants - - - - - - - - - - - - - - - - - - - Metal Door Frame & Replacement - - 15,000 - - - - - - - - - - - - - - - - Security upgrades -Cameras - - - - - - - - - - - - - 15,000 - - - - - Security upgrades - Entrance controls / Fiber - - - - - - - - - - - - - - - - - - - Reznor Heating Units - - - - - - - - 24,190 - - - - - - 27,000 - - - Dehumidifier - - - 102,500 - - - - - - - - - - - - - - - Domestic Water Heaters - - - - 3,450 - - - - - - - - - 5,000 - - - - Dehumidifier - - - - - - - 77,900 - - - - - - - - - - - Boiler - - - - - 27,600 - - - - - - - - - 29,000 - - - Relamp & Reballast 5,343 5,343 - - - - - - - - - 7,000 - - - - - - - Flow meters- GAC & Iron - - - - - - - - - 18,492 - - - - - - 20,000 - - Chorine booster pump -GAC - - - 5,796 - - - - - - - 6,000 - - - - - - - GAC Roof 2016 / Iron plant roof 2026/AOP roof 2041 - - - - - - 95,000 - - - - - - - - - - - - Production Well No. 3 Well casing - - - - - - - 80,000 - - - - - - - - - - - Well No. 3 Pump restoration - - - - - - - - - 102,730 - - - - - - - - Well No. 4 Pump restoration - - - 86,878 - - - - - - - - - 108,894 - - - - - Well No. 5 Pump restoration - - - - - - - - 100,716 - - - - - - - - - - Retro fit Well No. 5 for mobile Generator - - - - - - - - - - - 300,000 - - - - - - - Add permanent generator Well No. 4 - - - - - - - - 275,000 - - - - - - - - - - Central Park water re-use - - - - - - - - - - - - - - - - - 45,000 - Wellhouse 3, 4, 5 maintenance, roofs in 2024 - - - - 37,500 - - - - - - - - - - - - - - Storage - Ground Storage and Tower Cleaning & Inspection (2)11,000 - - - 12,000 - - - - 13,500 - - - 14,500 - - - - Tower Painting (last painted in 2000) (2)- - - - - - - - - - - - - - - - - - - Distribution System - - Watermains (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - Meter reading software upgrade / Customer portal - - - - - - - - - 80,000 - - - - - - - - - Mandates - - Wellhead Protection Plan Documentation (MDHS)- - - - - 30,000 - - - - 35,000 - - Water System Risk anaylsis and response plan 15,000 15,000 - - - - - - - - - - - - - - - - - Plant Components Assessment - - 35,000 - - - - - - - - - - - - - - - - Education/Public Awareness 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 1,001 Update Inventory of Potential Contamination Sources 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 1,001 Annual Well Sampling 500 500 500 500 500 500 500 500 500 500 501 502 503 503 503 503 503 503 503 33,843 22,843 52,500 197,675 43,450 72,100 97,500 185,400 402,406 203,722 226,001 315,502 2,505 126,399 22,005 73,505 22,505 47,505 2,505 Lift Stations Lift Stations - SCADA system/Fiber (1)15,000 - - - - - - - - - - - - 60,000 - - - - - Foss Road Lift Station Pump Replacement/re-hab - - - - - 10,000 - - - - - - - - - - - - - Harding Lift Station Pump Replacement/re-hab - - - - - - - 15,000 - - - - - - - - - - - Collection System Collection System (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - 15,000 - - - - 10,000 - 15,000 - - - - - 60,000 - - - - - FIBER Backbone Complete Fiber Installs, Lift Stations SCADA Connections (1)- - 100,000 - - - - - - - - - - - - - - - - Network switch City Hall - - 15,000 - - - - - - 22,000 - - - - - 29,000 - - - - - 115,000 - - - - - - 22,000 - - - - - 29,000 - - - TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 48,843$ 22,843$ 167,500$ 197,675$ 43,450$ 82,100$ 97,500$ 200,400$ 402,406$ 225,722$ 226,001$ 315,502$ 2,505$ 186,399$ 22,005$ 102,505$ 22,505$ 47,505$ 2,505$ ASSET REPLACEMENT PRORGRAM SEWER UTILITY WATER UTILITY UTILITES INFRASTRUCTURE EQUIPMENT 1.1713193 0 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.3986165 1.440575 1.4837923 1.528306 1.5741552 1.6213799 1.6700213 1.7201219 1.7717256 1.8248773 1.8796237 1.9360124 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 1403 2006 SPRINTER 4 W WATER UTILITY VAN 15 1 30,000 35,140 36,101 - - - - - - - - - - - - - - - - - 1561 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 1 51,750 - - - - - 68,224 - - - - - - - - - - 94,437 - - 81,750 35,140 36,101 - - - 68,224 - 1,000 - - - - - - - - 94,437 - - - 1438 1999 STERLING 19 S STERLING VACTOR/JETTER 15 1 225,000 - - - - - - - - - - - - - - - - - - - 1644 2018 FORD 15 D L8000 DUMP TRUCK 15-25 187,500 - - - - - - - - - - - - - - - - - 384,110 - 2007 ZIEGLER CAT S GENERATOR 200KW - FOSS RD LS 25-30 1 70,000 - - - - - - - - - - - - 113,497 - - - - - - 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 1 150,000 - - - 190,000 - - - - - - - - - - - - - - - 1517 2013 CASE 590 D BACKHOE 20-25 104,963 - - - - - - - - - - - - - 175,290 - - - - - 737,463 - - - 190,000 - - - - - - - - 113,497 175,290 - - - 384,110 - 1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 1 5,000 - - - - - - - 6,993 - - - - - - - - - - - 1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 1 5,000 - - - - - - - 6,993 - - - - - - - - - - - 1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 1 1,100 1,288 1,288 - - - - 1,494 - - - - - - - - - 2,007 2,068 - 2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 2 1,500 - - 1,810 - - - - 2,098 - - - - 2,432 2,505 - - - - - EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 1 1,100 - - - 1,367 - - - - 1,585 - - - - - - - 2,007 - - 1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 1 1,500 1,706 1,706 - - - 1,977 - - - - 2,292 - - - - - 2,737 - - 1209 2005 INGERSOL RAND D ROTO HAMMER 10 1 250 - - - - - - - - - 371 - - - - - - - - - 1417 2005 HONDA D EG1500W GENERATOR 10 1 500 - - - - - - - - - 742 - - - - - - - - - EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 1 1,000 - - - - 1,280 - - - - - 1,528 - - - - - - - - EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 1 1,000 1,137 1,137 - - - 1,318 - - - - - 1,574 - - - - - - 1,936 EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 1 2,000 2,343 2,343 - - - - - - - 2,968 - - - - 3,440 - - - - EST 2005 NA D 12V POWER VENT 5-10 1 1,500 - - - - 1,920 - - - - - 2,433 - - - - - - - 2,904 1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 1 1,500 - - - - - - 2,037 - - - - - - 2,505 - - - - - 2018 HACH WATER TESTING EQUIPMENT 5-10 3,445 - - - - - 4,542 - - - - - - 5,586 - - - - - - EST 2005 STIHL D TS460 PARTNER SAW 5-10 1 1,000 1,171 1,171 - - - - - - - 1,484 - - 1,001 1,001 - - - - - 32,395 7,645 7,645 1,810 1,367 3,200 7,837 3,530 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - 6,752 2,068 4,840 2016 RTA D RTA FLEET SOFTWARE (SHOP) 15-20 1 6,000 - - - - - 9,000 - - - - - - - - - - - - - D NETWORK SWITCHES 7-10 10 1,000 - - - - 1,200 - - - - - - 1,200 - - - - - - 1,200 D COMPUTERS/PRINTERS 7-10 10 1,000 2,500 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 1442 2009 SENSUS D COMPUTER SOFTWARE 20 1 15,000 - - - - - - 20,368 - - - - - - - - - - 23,000 2,500 2,500 - 2,500 1,200 11,500 20,368 2,500 - 2,500 - 3,700 - 2,500 - 2,500 - 2,500 1,200 TOTAL UTILITY 874,608 45,285 46,246 1,810 193,867 4,400 87,561 23,899 19,584 1,585 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 6,040 EQUIPMENT SPECIFIC TO WATER 180,000 35,140 36,101 0 190,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT SPECIFIC TO SEWER 295,000 0 0 0 0 0 0 0 0 0 0 0 0 113,497 0 0 0 0 0 0 DUAL PURPOSE EQUIPMENT 399,608 10,145 10,145 1,810 3,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 9,019 183,802 3,440 2,500 101,189 388,678 6,040 874,608 45,285 46,246 1,810 193,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 6,040 ASSET REPLACEMENT PRORGRAM Technology Reassigned from Capital Equipment Fund 3% AVERAGE ANNUAL INFLATION Fleet Reassigned from Capital Equipment Fund Heavy Equipment Reassigned from Capital Equipment Fund Specialty Equipment Reassigned from Capital Equipment Fund ϭϵϱϯtĂƚĞƌdŽǁĞƌ ϮϬϬϳ&ŽƐƐ>ŝŌ^ƚĂƟŽŶ ϮϬϬϭ,ĂƌĚŝŶŐ>ŝŌ^ƚĂƟŽŶ ϭϵϱϯ^ƚ͘ŶƚŚŽŶLJtĂƚĞƌ dƌĞĂƚŵĞŶƚ&ĂĐŝůŝƚLJ͕ϭϵϵϭ'͕ ϮϬϭϳKW ϭϵϱϳtĞůůηϯ ϭϵϱϵtĞůůηϰ ϭϵϲϭtĞůůηϱ ϮϬϮϬsĂĐƚŽƌͬ:ĞƩĞƌ ϮϬϭϱ&ŽƌĚ&ϯϱϬhƟůŝƚLJϰdžϰ ϮϬϬϰ&ƌĞŝŐŚƚůŝŶĞƌDϮtĂƚĞƌ dĂŶŬĞƌͬ&ůƵƐŚĞƌ ϮϬϮϭdƌĂŶƐŝƚhƟůŝƚLJsĂŶ ϭϵϵϵKŶĂŶϰϬϬ<'ĞŶ^Ğƚ ϭϵϵϮKŶĂŶϯϳϱ<'ĞŶ^Ğƚ ϮϬϭϯĂƐĞϱϵϬ>ŽĂĚĞƌͬĂĐŬŚŽĞ Fiscal Year 2022 SOURCES 2021 EST. ACTUAL 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Stormwater fees UB 215,502$ 215,502$ 219,812$ 224,208$ 228,692$ 233,266$ 237,931$ 1,413,592$ 1,427,728$ Grants-Industrial Park Flooding (1)- - - - - - - 250,000 - Interest 2,600 2,600 1,900 2,400 2,700 4,000 4,000 55,000 72,000 TOTAL 218,102$ 218,102$ 221,712$ 226,608$ 231,392$ 237,266$ 241,931$ 1,718,592$ 1,499,728$ USES Stormwater Maintenance 50,000$ 35,500$ 272,000$ -$ 25,000$ 85,000$ 75,000$ 150,000$ 330,000$ Flood Improvements (1)- - - - - - - 850,000 - Water Quality 293,825 255,673 59,985 66,183 47,422 38,702 75,025 365,578 741,221 Mandates 7,000 12,450 13,850 14,330 14,825 15,336 15,864 117,265 146,214 Annual Reconstruction - - - - 50,000 50,000 75,000 250,000 - TOTAL 350,825 303,623 345,835 80,513 137,247 189,038 240,888 1,732,843 1,217,435 NET CHANGE (132,723)$ (85,521)$ (124,123)$ 146,095$ 94,145$ 48,228$ 1,043$ (14,251)$ 282,294$ BEGINNING CASH BALANCE 321,931 321,931 236,410 112,287 258,381 352,527 400,755 401,798 387,547 ENDING CASH BALANCE 189,208$ 236,410$ 112,287$ 258,381$ 352,527$ 400,755$ 401,798$ 387,547$ 669,841$ (1) Currently project on hold to complete with a future redevelopment, budget includes 2030 placeholder costs of 850k and 250k in grant revenues. $592,399.00 STORMWATER 2022 - 2038 STORMWATER CAPITAL PLAN Improvement Type Location Potential Financial Sources 2021 Est.Actual 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Stormwater Pond Maintenance Ramsey County Foss Rd Ditch Contribution SAV, Ramsey - - - - 25,000 25,000 - - - - - - - - - - - - - 33rd and Stinson (Included in 2021 Street Imp) SAV - 30,000 - - - - - - - - - - - - - - - - - Mirror Lake SAV - - - - - - - - - - - - 150,000 - - - - - - Silver Lake Ramsey, CH, SAV - - - - - - - - - - - - - - - - - - - Harding Pond SAV 50,000 5,500 272,000 - - - - - - - - - - - - - - 200,000 - Salo Pond SAV - - - - - 60,000 - - - - - - - - 60,000 - - - - Central Park Rain Garden SAV - - - - - - 75,000 - - - - - - - - 70,000 - - - 50,000 35,500 272,000 - 25,000 85,000 75,000 - - - - - 150,000 - 60,000 70,000 - 200,000 - Flood Improvements Industrial Park Flood Improvements SAV/MWMO - - - - - - - - - 850,000 - - - - - - - - - - - - - - - - - - 850,000 - - - - - - - - Water Quality Street Sweeper SAV 235,000 218,598 - - - - - - - - - - - - - - 350,000 - - Salo Pond Treatment System SAV 24,000 22,500 24,960 25,958 26,997 28,077 29,200 30,368 31,582 32,846 34,159 35,526 36,947 38,425 39,962 41,560 43,223 44,952 46,750 Regional Stormwater Treatment system MWMO 1,575 1,575 1,675 1,775 1,875 1,975 2,075 2,175 2,275 2,375 2,475 2,575 2,675 2,775 2,875 2,975 3,075 3,175 3,275 Clean Streets maintenance costs SAV 8,250 7,500 8,350 8,450 8,550 8,650 8,750 8,850 8,950 9,050 9,150 9,250 9,350 9,450 9,550 9,650 9,750 9,850 9,950 Silver Lake Delisting / Weed mgmt CO-OP - - - - 10,000 - - - - 10,000 - - - - 10,000 - - - - Water Re-use Maintenance SAV 25,000 5,500 25,000 30,000 - - 35,000 - - 40,000 - - 45,000 - - 50,000 - - - 293,825 255,673 59,985 66,183 47,422 38,702 75,025 41,393 42,807 94,271 45,784 47,351 93,972 50,650 62,387 104,185 406,048 57,977 59,975 Mandates SWIPP Stormwater Management Plan update SAV - - - - - - - 10,000 - - - - - - - - - 15,000 MS4 MS4-Engineer costs SAV 2,750 11,200 9,500 9,880 10,275 10,686 11,114 11,558 12,021 12,501 13,001 13,521 14,062 14,625 15,210 15,818 16,451 17,109 17,793 Internal SW Education / Green Step Program SAV 4,250 1,250 4,350 4,450 4,550 4,650 4,750 4,850 4,950 5,050 5,150 5,250 5,350 5,450 5,550 5,650 5,750 5,850 5,950 7,000 12,450 13,850 14,330 14,825 15,336 15,864 16,408 26,971 17,551 18,151 18,771 19,412 20,076 20,761 21,469 22,202 22,961 38,745 Annual Reconstruction (1) Internal use for debt levy reduction - - - - 50,000 50,000 75,000 50,000 50,000 150,000 - - - - - - - - - Contribution to streets reconstruction 2024-2037 - - - - - - - - - - - - - - - - - - - - - - - 50,000 50,000 75,000 50,000 50,000 150,000 - - - - - - - - - TOTAL STORMWATER CAPITAL PLAN 350,825 303,623 345,835 80,513 137,247 189,038 240,888 107,801 119,778 261,822 913,936 66,122 263,384 70,726 143,148 195,654 428,250 280,938 98,720 (1) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan ϮϬϬϰ-ϮϬϬϱ^ĂůŽWŽŶĚ EŽƌƚŚ ϮϬϬϰ-ϮϬϬϱ^ĂůŽWŽŶĚ ^ŽƵƚŚ ϮϬϬϯ,ĂƌĚŝŶŐWŽŶĚ ϭϵϲϮDŝƌƌŽƌ>ĂŬĞ ϮϬϭϱ^ŝůǀĞƌ>ĂŬĞ^ƚŽƌŵǁĂƚĞƌ dƌĞĂƚŵĞŶƚ&ĂĐŝůŝƚLJĂƚ^ĂůŽWŽŶĚ ϮϬϭϲ^ƚ͘ŶƚŚŽŶLJZĞŐŝŽŶĂů ^ƚŽƌŵǁĂƚĞƌdƌĞĂƚŵĞŶƚ^LJƐƚĞŵ ϮϬϭϰĞŶƚƌĂůWĂƌŬZĂŝŶ'ĂƌĚĞŶ ϮϬϬϴtĂƚĞƌZĞƵƐĞ&ŽƵŶƚĂŝŶ ϮϬϮϭ ůŐŝŶWĞůŝĐĂŶ ^ƚƌĞĞƚ^ǁĞĞƉĞƌ Fiscal Year 2022 SOURCES 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027-2032 2033-2038 Bond Proceeds 2,165,000$ 2,165,000$ 2,083,000$ -$ 2,333,000$ 2,303,000$ -$ 8,721,000$ 7,411,000$ Road Improvement Levy (1)1,913,699 1,913,699 1,985,860 1,976,110 2,076,413 2,027,411 2,060,165 10,731,080 8,318,303 Prepaid Assessments 162,168 162,168 137,330 - 264,330 163,532 - 795,781 1,010,468 MSA Funds / SW funds - - - - 50,000 50,000 75,000 400,000 300,000 Grant Funding - - - - - - - - - Debt Levy Reduction Funding 475,821 475,821 341,989 321,060 50,000 50,000 75,000 250,000 - Infrastructure levy 60,000 60,000 65,000 65,000 250,000 400,000 500,000 4,900,000 6,800,000 Miscellaneous - - - - - - - - - TOTAL 4,776,687$ 4,776,687$ 4,613,179$ 2,362,170$ 5,023,743$ 4,993,943$ 2,710,165$ 25,797,861$ 23,839,771$ USES Streets/Utilities Reconstruction 2,392,120$ 2,392,120$ 2,197,597$ 436,517$ 2,023,469$ 2,424,702$ 479,709$ 12,452,318 11,874,683 Sidewalks/Street Lights - - - - - - - 492,239 1,723,111 Road Improvement debt 2,389,519 2,389,519 2,327,849 2,297,170 2,126,413 2,077,471 2,015,305 11,801,781 10,009,372 Miscellaneous 50,000 50,000 55,000 - 70,000 - 150,000 180,000 TOTAL 4,831,639$ 4,831,639$ 4,525,446$ 2,788,686$ 4,149,882$ 4,572,173$ 2,495,014$ 24,896,338$ 23,787,166$ NET CHANGE (54,952)$ (54,952)$ 87,733$ (426,517)$ 873,861$ 421,770$ 215,151$ 901,524$ 52,605$ BEGINNING ACTIVITY 375,000 375,000 320,048 407,781 (18,736) 855,125 1,276,895 1,492,047 2,393,570 CUMULATIVE ACTIVITY 320,048$ 320,048$ 407,781$ (18,736)$ 855,125$ 1,276,895$ 1,492,047$ 2,393,570$ 2,446,175$ (1) PER 2022 DEBT LEVY PROGRAM SEE EXHIBIT C STREETS IMPROVEMENT PLAN 2022 - 2038 STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2021 Est. Actual 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Annual Street / Utility Program SEE EXHIBT A FOR DETAIL OF TYPE OF IMPROVEMENTS BY YEAR, 2020 Debt Levy/Assmts/Grants & Aids 2,930,000 586,000 586,000 - - - - - SEE EXHBIT B FOR STREET MAP FOR YEAR OF STREET IMPROVEMENT 2021 Debt Levy/Assmts/Grants & Aids 2,257,650 1,806,120 1,806,120 451,530 - - - - - - - - - - - - - 2022 Debt Levy/Assmts/Grants & Aids 2,182,584 - 1,746,067 436,517 - - - - - - - - - - - - 2023 OFF YEAR - - - - - - - - - - - - - - - - 2024 Debt Levy/Assmts/Grants & Aids 2,529,336 - - - 2,023,469 505,867 - - - - - - - - - - 2025 Debt Levy/Assmts/Grants & Aids 2,398,544 - - - - 1,918,835 479,709 - - - - - - - - - 2026 OFF YEAR - - - - - - - - - - - - - - - - 900000 FB LEVY 2027 Debt Levy/Assmts/Grants & Aids 2,331,804 - - - - - - 1,865,443 466,361 - - - - - - - - 2028 Debt Levy/Assmts/Grants & Aids 2,968,166 - - - - - - - 2,374,533 593,633 - - - - - - - - 2029 OFF YEAR - - - - - - - - - - - - - - - - - - 2030 Debt Levy/Assmts/Grants & Aids 2,700,097 - - - - - - - - - 2,160,078 540,019 - - - - - - 2,600,000 FB LEVY 2031 Debt Levy/Assmts/Grants & Aids 4,452,251 - - - - - - - - - - 3,561,801 890,450 - - - - - 2032 OFF YEAR - - - - - - - - - - - - - - - - - - 2033 Debt Levy/Assmts/Grants & Aids 3,296,902 - - - - - - - - - - - - 2,637,522 659,380 - - - 2034 Debt Levy/Assmts/Grants & Aids 3,421,261 - - - - - - - - - - - - - 2,737,009 684,252 - - 2035 OFF YEAR - - - - - - - - - - - - - - - - 2036 Debt Levy/Assmts/Grants & Aids 2,570,530 - - - - - - - - - - - - - - - 2,056,424 514,106 2037 Debt Levy/Assmts/Grants & Aids 2,585,990 - - - - - - - - - - - - - - - - 2,068,792 517,198 2038 OFF YEAR - - - - - - - - - - - - - - - - - - - TOTAL 21,416,284 2,392,120 2,392,120 2,197,597 436,517 2,023,469 2,424,702 479,709 1,865,443 2,840,894 593,633 2,160,078 4,101,820 890,450 2,637,522 3,396,389 684,252 2,056,424 2,582,898 517,198 Sidewalks / Intersections / Signals / Lighting Sidewalk / Lighting Stinson South of 37th Debt Levy 299,785 - - - - - - - - - - - - 401,400 222,355 - - - Sidewalk / Lighting Stinson Boulevard South of 33rd Debt Levy 374,731 - - - - - - - - - - - - - - - 294,871 303,717 Street lighting 37th Avenue NE (County Road D) Debt Levy 327,890 - - - - - - - - - - 291,841 200,398 - - - - - Street lighting 33rd Avenue NE (County Road C2) Debt Levy 368,876 - - - - - - - - - - - - - - 500,768 - - TOTAL SIDEWALKS/LIGHTING ETC.1,371,282 - - - - - - - - - - 291,841 200,398 401,400 222,355 500,768 294,871 303,717 - TOTAL STREETS IMPROVEMENT PLAN 22,787,566 2,392,120 2,392,120 2,197,597 436,517 2,023,469 2,424,702 479,709 1,865,443 2,840,894 593,633 2,160,078 4,393,662 1,090,848 3,038,922 3,618,745 1,185,020 2,351,295 2,886,615 517,198 ANNUAL STREET PROGRAM DETAILED COSTS EXHIBIT A BASE BASE Inflation PROJECTED PROJECTED Year Road From To Street Length Improvement COST PER FT Cost Factor COST PER FT Cost Est Assessments net city cost PP SA Bond size Bond A/R SA 2021 Skycroft Drive 33rd Avenue 32nd Avenue 600 Reconstruct 1,167.23 700,340 1,167.23 700,340 122,880 577,460 36,864 663,476 540,560 Total assessed 540,560 2021 Croft Drive 33rd Avenue 32nd Avenue 600 Reconstruct 1,167.23 700,340 1,167.23 700,340 122,880 577,460 36,864 663,476 162,168 PP Sa 2021 29th Avenue Stinson Boulevard Silver Lake Road 1947 Mill / Overlay 149.91 291,875 149.91 291,875 92,009 199,866 27,603 264,272 2,165,000 2021 St. Anthony Boulevard Stinson Boulevard Kenzie Terrace 1948 Mill / Overlay 149.91 292,025 149.91 292,025 119,891 172,134 35,967 256,057 2,164,390 378,392 Bond size / bond sa 2021 2021 31st Avenue Rankin Road Croft Drive 840 Mill / Overlay 137.88 115,819 137.88 116,054 38,446 77,608 11,534 104,285 2,257,650 total cost 2,257,650 2021 Croft Drive Rankin Road 31st Avenue 1030 Mill / Overlay 137.88 142,016 137.88 142,016 44,454 97,563 13,336 128,680 0 2,164,390 15,000 2022 Rankin Road 31st Avenue 33rd Avenue 1310 Reconstruct 1,167.23 1,529,076 1.05 1,225.60 1,605,529 191,999 1,413,531 57,600 1,547,930 457,767 Total assessed 2022 East Gate Road Crestview Drive Rankin Road 360 Mill / Overlay 91.56 32,962 1.05 96.14 34,610 16,301 18,309 4,890 28,071 137,330 PP Sa 2022 Crest View Drive 29th Avenue 31st Avenue 1490 Mill / Overlay 137.31 204,592 1.05 144.18 214,821 67,469 147,353 20,241 184,351 2,083,000 2022 Bell Lane Armour Terrace Crestview Drive 660 Mill / Overlay 137.31 90,625 1.05 144.18 95,156 29,885 65,270 8,966 81,659 $2,082,259.92 320,437 Bond size / bond sa 2022 2022 Armour Terrace Silver Lake Road Crestview Drive 1580 Mill / Overlay 91.56 144,665 1.05 96.14 151,898 71,544 80,354 21,463 123,202 2022 Alley (south of 29th)29th Avenue Alley (west of Roosevelt)350 A, Mill / Overlay 79.93 27,976 1.05 83.93 29,374 29,374 - 8,812 20,562 2,182,584 total cost 2022 Alley (west of Roosevelt)Roosevelt Street West Terminus 310 A, Mill / Overlay 79.93 24,778 1.05 83.93 26,017 26,017 - 7,805 18,212 0 2022 Alley (south of 29th)29th Avenue Murray Avenue 300 A, Mill / Overlay 79.93 23,979 1.05 83.93 25,178 25,178 - 7,553 17,625 2023 OFF YEAR 2024 Townview Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,225.60 1,568,762 1.03 1,262.36 1,615,824 348,068 1,267,756 104,420 1,511,404 881,101 Total assessed 2024 Alley (south of Pahl)Roosevelt Street Wilson Street 760 Mill / Overlay 104.91 79,728 1.03 108.05 82,120 82,120 - 24,636 57,484 264,330 PP Sa 2024 Alley (north of Pahl)Roosevelt Street Wilson Street 770 Mill / Overlay 104.91 80,777 1.03 108.05 83,201 83,201 - 24,960 58,240 2024 Alley (south of Pahl)Wilson Street 27th Avenue 480 Mill / Overlay 83.93 40,285 1.03 86.44 41,493 41,493 - 12,448 29,045 2,333,000 2024 Alley (north of Pahl)Wilson Street 27th Avenue 650 Mill / Overlay 83.93 54,552 1.03 86.44 56,189 56,189 - 16,857 39,332 $2,332,955.68 616,770 Bond size / bond sa 2024 2024 Roosevelt Street 35th Street County Road D 1560 Mill / Overlay 96.14 149,975 1.03 99.02 154,475 76,037 78,437 22,811 131,663 2024 35th Street Stinson Boulevard Belden Drive 1290 Mill / Overlay 96.14 124,018 1.03 99.02 127,739 62,877 64,862 18,863 108,875 2,529,336 total cost 2024 Roosevelt Street 34th Avenue 35th Avenue 630 Mill / Overlay 144.18 90,831 1.03 148.50 93,555 30,707 62,848 9,212 84,343 0 2024 Edward Street 34th Avenue 35th Avenue 630 Mill / Overlay 96.14 60,567 1.03 99.02 62,384 30,707 31,677 9,212 53,172 2024 Harding Street 34th Avenue 36th Avenue 1430 Mill / Overlay 144.18 206,171 1.03 148.50 212,356 69,701 142,655 20,910 191,446 2025 31st Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,262.36 1,615,824 1.03 1,300.23 1,664,299 348,629 1,315,670 104,589 1,559,710 545,107 Total assessed 2025 30th Avenue Wilson Street Silver Lake Road 1270 Mill / Overlay 99.02 125,758 1.03 101.99 129,531 44,086 85,445 13,226 116,305 163,532 PP Sa 2025 W Armour Terrace Roosevelt Street Silver Lake Road 1840 Mill / Overlay 148.50 273,241 1.03 152.96 281,439 63,873 217,566 19,162 262,277 2,303,000 2025 Wilson Street 29th Avenue 30th Avenue 630 Mill / Overlay 148.50 93,555 1.03 152.96 96,362 21,869 74,493 6,561 89,801 $2,302,062.66 381,575 Bond size / bond sa 2025 2025 Wilson Street 27th Avenue 29th Avenue 1310 Mill / Overlay 99.02 129,719 1.03 101.99 133,611 45,475 88,136 13,642 119,968 2,398,544 total cost 2025 Pahl Avenue Wilson Street Coolidge Street 610 Mill / Overlay 148.50 90,585 1.03 152.96 93,303 21,175 72,128 6,353 86,950 0 2026 OFF YEAR 2027 Rankin Road CR 88 31st Avenue 1310 Reconstruct 1,300.23 1,703,306 1.03 1,339.24 1,754,405 240,554 1,513,851 72,166 1,682,239 461,324 Total assessed 2027 29th Avenue Silver Lake Road Rankin Road 1290 Mill / Overlay 183.56 236,796 1.03 189.07 243,900 74,358 169,542 22,308 221,593 2,260,000 138,397 PP Sa 2027 Hilldale Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 152.96 194,254 1.03 157.54 200,081 73,206 126,876 21,962 178,120 $2,259,208.81 322,927 Bond size / bond sa 2027 2027 32nd Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 101.99 129,531 1.03 105.05 133,417 73,206 60,211 21,962 111,455 2,331,804 total cost 0 2028 Macalaster Drive 39th Avenue Silver Lane 1260 Reconstruct 1,339.24 1,687,443 1.03 1,433.51 1,806,220 273,871 1,532,349 82,161 1,724,058 549,868 Total assessed 2028 Macalaster Drive South terminus 39th Avenue 500 Reconstruct 1,339.24 669,620 1.03 1,433.51 716,754 143,351 573,403 43,005 673,749 164,960 PP Sa 2028 Wilson Street 30th Avenue 31st Avenue 630 Mill / Overlay 157.54 99,253 1.03 162.27 102,231 26,445 75,785 7,934 110,164 2,970,000 2028 Harding Street 30th Avenue 31st Avenue 630 Mill / Overlay 105.05 66,183 1.03 108.20 68,169 26,445 41,723 7,934 76,102 $2,969,276.93 384,907 Bond size / bond sa 2028 2028 Edward Street 33rd Avenue 34th Avenue 620 Mill / Overlay 105.05 65,133 1.03 108.20 67,087 26,025 41,061 7,808 74,894 2,968,166 total cost 2028 Belden Drive 33rd Avenue 34th Avenue 1280 Mill / Overlay 157.54 201,657 1.03 162.27 207,707 53,730 153,977 16,119 223,826 0 2029 OFF YEAR 2030 Penrod Lane 39th Avenue Silver Lane 1260 Reconstruct 1,433.51 1,806,220 1.03 1,476.51 1,860,406 373,647 1,486,759 112,094 1,748,312 698,480 Total assessed 2030 34th Avenue Stinson Boulevard Silver Lake Road 2200 Mill / Overlay 108.20 238,049 1.03 111.45 245,191 112,718 132,473 33,815 279,006 209,544 PP Sa 2030 Hilldale Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 162.27 178,498 1.03 167.14 183,853 56,359 127,494 16,908 200,761 2,766,000 2030 32nd Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 108.20 119,025 1.03 111.45 122,595 56,359 66,236 16,908 139,503 $2,766,016.30 488,936 Bond size / bond sa 2030 2030 Townview Avenue Wilson Street Silver Lake Road 1290 Mill / Overlay 162.27 209,329 1.03 167.14 215,609 66,094 149,515 19,828 235,437 2,700,097 total cost 2030 Belden Drive 32nd Avenue 33rd Avenue 650 Mill / Overlay 108.20 70,333 1.03 111.45 72,443 33,303 39,140 9,991 82,434 0 2031 Shamrock Drive 39th Avenue Silver Lane 1260 Reconstruct 1,476.51 1,860,406 1.03 1,520.81 1,916,218 391,285 1,524,934 117,385 1,798,833 942,934 Total assessed 2031 Fordham Drive 39th Avenue Silver Lane 1260 Reconstruct 1,476.51 1,860,406 1.03 1,520.81 1,916,218 333,384 1,582,835 100,015 1,816,203 282,880 PP Sa 2031 30th Avenue Stinson Boulevard Wilson Street 960 Mill / Overlay 111.45 106,992 1.03 114.79 110,202 47,193 63,009 14,158 96,044 4,295,000 2031 Roosevelt Street St. Anthony Boulevard 30th Avenue 1210 Mill / Overlay 167.14 202,238 1.03 172.15 208,305 59,482 148,823 17,845 190,461 $4,294,452.25 660,054 Bond size / bond sa 2031 2031 Murray Avenue Roosevelt Street Wilson Street 830 Mill / Overlay 111.45 92,504 1.03 114.79 95,279 40,802 54,477 12,241 83,038 4,452,251 total cost 2031 Murray Avenue Wilson Street Coolidge Street 710 Mill / Overlay 167.14 118,669 1.03 172.15 122,229 34,903 87,326 10,471 111,758 0.21 2031 Coolidge Street St. Anthony Boulevard 29th Avenue 730 Mill / Overlay 111.45 81,359 1.03 114.79 83,799 35,886 47,913 10,766 73,034 ANNUAL STREET PROGRAM DETAILED COSTS EXHIBIT A 2032 OFF YEAR 2033 Skycroft Circle Skycroft Drive Skycroft Drive 1550 Reconstruct 1,520.81 2,357,253 1.03 1,566.43 2,427,970 496,875 1,931,096 149,062 2,278,908 710,838 Total assessed 2033 34th Avenue Skycroft Drive Croft Drive 300 Reconstruct 1,520.81 456,242 1.03 1,566.43 503,007 27,604 475,403 8,281 494,726 213,251 PP Sa 2033 Pahl Avenue Roosevelt Street Wilson Street 720 Mill / Overlay 114.79 82,652 1.03 118.24 85,131 47,581 37,550 14,274 70,857 3,177,000 2033 Roosevelt Street 27th Avenue Pahl Avenue 550 Mill / Overlay 172.15 94,684 1.03 177.32 97,525 36,347 61,178 10,904 86,621 $3,176,160.17 497,586 Bond size / bond sa 2033 2033 27th Avenue Stinson Boulevard Pahl Avenue 1550 Mill / Overlay 114.79 177,930 1.03 118.24 183,268 102,431 80,837 30,729 152,539 3,296,902 total cost 2034 Skycroft Drive Maplewood Drive 33rd Avenue 1560 Reconstruct 1,566.43 2,443,635 1.03 1,613.43 2,516,944 392,842 2,124,102 117,853 2,399,091 558,472 Total assessed 2034 39th Avenue Stinson Blvd Silver Lake Road 2200 Mill / Overlay 255.34 561,742 1.03 263.00 578,595 99,832 478,763 29,950 548,645 167,542 PP Sa 2034 Roosevelt Street 33rd Avenue north terminus 340 Mill / Overlay 118.24 40,201 1.03 121.78 41,407 11,020 30,386 3,306 38,101 3,351,000 2034 Roosevelt Street 31st Street 33rd Avenue 1290 Mill / Overlay 177.32 228,740 1.03 182.64 235,602 41,813 193,789 12,544 223,058 $3,351,331.31 390,930 Bond size / bond sa 2034 2034 Anthony Road Roosevelt Street Edward Street 400 Mill / Overlay 118.24 47,295 1.03 121.78 48,714 12,965 35,749 3,890 44,824 3,421,261 total cost 0 2035 OFF YEAR 2036 Downers Drive Skycroft Drive Highcrest Road 1140 Reconstruct 1,613.43 1,839,305 1.03 1,661.83 1,894,484 328,558 1,565,926 98,568 1,795,917 565,494 Total assessed 2036 31st Avenue Wilson Street Silver Lake Road 1260 Mill / Overlay 121.78 153,449 1.03 125.44 158,052 65,183 92,869 19,555 138,497 2,472,000 169,648 PP Sa 2036 31st Street Stinson Boulevard Wilson Street 990 Mill / Overlay 182.64 180,811 1.03 188.12 186,235 51,215 135,020 15,365 170,871 $2,472,908.28 395,846 2036 Edward Street 31st Street 33rd Avenue 1390 Mill / Overlay 121.78 169,281 1.03 125.44 174,359 71,908 102,451 21,573 152,787 2,570,530 total cost 2036 2036 Wilson Street 31st Street 32nd Street 630 Mill / Overlay 182.64 115,061 1.03 188.12 118,513 32,592 85,922 9,777 108,736 0 2036 32nd Street Edward Street Belden Drive 310 Mill / Overlay 121.78 37,753 1.03 125.44 38,886 16,037 22,849 4,811 34,075 2037 Croft Drive 33rd Avenue Downers Drive 1270 Reconstruct 1,661.83 2,110,522 1.03 1,711.68 2,173,838 384,413 1,789,424 115,324 2,058,514 2,481,000 413,343 Bond size / bond sa 2037 2037 Chandler Drive/Foss Road 37th Avenue Highcrest Road 3190 Mill / Overlay 125.44 571,544 1.03 129.20 412,153 206,076 206,076 61,823 350,330 $2,481,108.56 2,585,990 TBD Anthony Lane N County Road C North terminus 800 Reconstruct 1,711.68 1,369,347 1.03 1,763.03 1,410,427 493,649 916,777 148,095 1,262,332 $1,300,202.05 345,555 TBD TBD Anthony Lane S County Road C south 2930 Reconstruct 1,763.03 5,165,689 1.03 1,815.92 5,320,659 1,862,231 3,458,429 558,669 4,761,990 $4,845,324.85 1,303,562 TBD Industrial Park - Upon Redevelopment / TIF Silver Lake 36THAVE N E 31STAVE N E 33RD AVE N E 33RD AVE N E 33RD AVE N E 34TH AVE N E STINSON PKWY N ESILVER LNL O W R YAVE N E CO RDNO 88SILVER LAKE RD1 6 T HAVE S W SILVER LAKE RD3 9 T H A V E N E 39TH AVE NE HIGHCREST RDP IN E KENZIE TER ASHCEDAR DIAMONDEIGHTTERSILVERLAKE CTSILVER LN ROZELLE DRCHANDLER DRSKYCROFTDR COOLIDGE ST N EIRONW OOD32ND AVE N E 32ND AVE N E LOWRYAVEN E ELM FOSS RD ROOSEVELTST N ESILVER LA KETER PAHL AVE PI NECRESTVIEW DRROOSEVELT ST N EJ U N IP E R FORDHAMCT NEMAPLEWOODDROLD HWY 8 WILSON ST N ESTINSON BLVD NEELM FOSS RDFOSS RDG U M PENROD LACHELMSFORD RDHIGHCREST RDHIGHCREST RDLOWRYAVEN E 34THAVE N 35TH AVE N E A N T H O N Y L A SROOSEVELTCT N ESILVER LAKE RDSILVER LAKE RDSILVER LAKE RDRANKIN RDRANKIN RDWILSONST N EANTHONY LA SS IL V E R L N SILVER LNLOCUST 39T HAVE N E M A P L E W O O D D R O A K EASTGATE RD DOWNERS DRAPACHELANE ES T A N T H O N Y R D MACALASTERDRMACALASTER DRKENZIE TERKENZIE TERKENZIE TERARMOUR TER27TH AVE N E PENTAGON DR 30TH AVE N E ST ANTHONY BLVD S T A N T H O N Y B L V D ARMOUR TER W STINSON BLVD N ESTINSONBLVD N ESTINSON BLVD N E38TH AVE NE PAHL AVE FRONTAGE RDHARDING ST N EROOSEVELT ST N E29TH AVE N E 29THAVE N E 29TH AVE N E 37TH AVE NE 37TH AVE NE 37TH AVE NE CROFT DREDWARD ST N EEDWARD ST N ECOOLIDGE ST N ESKYCROFT DRHARDING ST N ECROFT DRB E L L L A MURRAY AVE SKYCROFTCIRB E L D E N D R BELDEN DRFORDHAM DRANTHONY LA31ST AVE N E 31ST AVE N E 31ST AVE N EROOSEVELT ST N E36TH AVE N E 36TH AVE N E 36TH AVE N E HCRRA CORRIDORH C R R A C O R R ID O RCROFT DROLD HWY 8OLD HWY 8HIGHWAY NO 88HIGHWAYNO 88HIGHWAY NO 88HILLDALE AVE N E PENROD LNSHAMROCK DRTOWNVIEW AVE 37TH AVE N E 37TH AVE N E EDGEMERE AVE WENDHURST AVE SKYCROFT DR SKYCROFT DR1 inch = 750 f eet Document Path: K:\013266-000\GIS\Maps\CIP_ProjectMapUpdated2021.mxd Date Saved: 10/11/2021 2:06:14 PMStreet & Utility CIP for 2022 and BeyondSt. Anthony, MN City BoundaryStreet & UtilityReconstruction Program 20222024202520272028203020312033203420362037Mill & O verla y Program20222024202520272028203020312033203420362037 Project Location Map 0 750Feet¯ EXHIBIT C City of St. Anthony Debt Levy - Roads, Tax Abatement, Public Facilities 802,382 897,435 902,685 918,015 916,965 920,850 929,565 937,755 950,670 729,039 565,647 142,865 138,581 139,547 140,033 2022 Levy Year 60 61 62 63 64 2018 2019street 2020 Street 2021 2022 Existing Bonds Fund 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 $1,700,000 - 2003A (Refunding 2011A) 503 118,057 121,103 123,992 121,473 124,204 132,028 134,286 $1,305,000 - 2008A (2014C) 365 175,652 177,319 178,526 169,602 170,021 172,436 169,496 171,806 168,761 170,966 172,673 173,040 $2,630,000 - 2009A (Refunded in 2017A) 512 184,768 185,450 185,975 186,343 186,553 186,605 172,921 179,549 180,612 181,518 187,516 187,949 182,974 $1,645,000 - 2009B (2001B & 2002A) 503 196,995 192,401 187,808 193,714 183,608 106,150 $1,375,000 - 2010A (Refunded in 2019A)514 108,587 112,065 110,175 108,285 111,645 109,413 112,209 114,624 103,271 110,587 112,233 108,419 109,854 111,080 $1,940,000 - 2011A (Refunded in 2019A)516 141,991 138,684 140,626 142,411 138,789 140,416 141,886 142,871 125,653 121,883 123,363 124,633 125,694 126,544 121,934 $2,210,000 - 2011B (2004A and 2005A) 503 250,300 226,977 226,899 221,025 225,157 223,441 226,430 223,537 109,589 $9,495,000 - 2012A (2006A & 2007A) 503/518 324,405 423,185 518,973 519,813 530,693 520,758 520,968 526,218 531,153 535,773 306,356 141,358 142,865 138,581 139,547 140,033 $1,775,000 - 2013B (Refunding 2021A)520 - - 118,685 118,930 119,176 119,120 119,063 118,523 117,984 117,082 112,438 115,914 114,036 112,157 115,529 108,296 111,667 $2,230,000 - 2014A 522 - - - 157,629 155,848 159,318 157,433 155,548 153,663 157,028 154,896 151,488 153,330 155,015 151,292 152,820 154,190 154,914 $2,580,000 - 2015A 524 - - - - 185,075 182,847 185,869 183,537 186,454 184,016 186,829 184,286 186,993 183,886 186,029 182,331 183,884 184,819 185,111 $1,455,000 - 2016A 526 102,173 106,135 104,742 103,349 101,956 105,813 104,315 102,817 106,568 104,965 103,362 107,009 105,025 103,042 105,757 $2,600,000 - 2017A 528 189,734 191,592 193,296 189,591 191,136 192,523 193,753 189,575 190,647 191,562 192,320 192,919 193,362 193,646 193,774 $2,610,000 - 2018A 530 179,849 180,959 181,859 177,298 177,998 178,467 178,737 178,797 180,484 176,764 178,294 179,666 180,382 180,927 181,302 $1,145,000 - 2019A 532 103,950 101,430 104,160 101,430 103,950 101,010 103,320 100,170 103,058 100,537 103,268 100,590 103,162 100,328 102,742 $3,000,000 - 2020A 534 235,830 237,644 232,600 232,806 232,856 232,747 237,731 237,150 236,412 232,471 233,780 234,984 236,083 237,077 232,715 (13,145) $2,165,000 - 2021A 538 155,495 158,508 156,165 153,823 151,481 159,639 157,087 154,535 157,233 156,186 93,397 92,398 91,398 90,199 94,250 Total Levy 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,258,694 2,389,519 2,327,849 2,154,461 1,983,704 1,789,833 1,676,288 1,556,428 1,423,129 1,307,455 1,154,153 970,341 806,244 610,111 431,217 322,914 81,105 - - - - 2022 Road Improvements Bonds $2,083,000 - 2022A 2022A - 142,709 142,709 142,709 142,709 142,709 142,709 142,709 142,709 142,709 142,709 147,099 147,099 147,099 147,099 147,099 2023-2037 Road Improvements Bonds 2023 - OFF YEAR $2,333,000 - 2024A 2024A 144,929 144,929 144,929 144,929 144,929 144,929 144,929 144,929 144,929 144,929 102,986 102,986 102,986 102,986 102,986 $2,303,000 - 2025A 2025A 171,239 171,239 171,239 171,239 171,239 171,239 171,239 171,239 171,239 171,239 105,591 105,591 105,591 105,591 105,591 2026 - OFF YEAR $2,260,000 - 2027A 2027A 157,585 157,585 157,585 157,585 157,585 157,585 157,585 157,585 157,585 157,585 110,996 110,996 110,996 900K REDUCTION IN BORROWING (63,034) (63,034) (63,034) (63,034) (63,034) (63,034) (63,034) (63,034) (63,034) (63,034) (44,398) (44,398) (44,398) $2,970,000 - 2028A 2028A 248,638 248,638 248,638 248,638 248,638 248,638 248,638 248,638 248,638 248,638 193,053 193,053 2029 - OFF YEAR $2,766,000 - 2030A 2030A 223,325 223,325 223,325 223,325 223,325 223,325 223,325 223,325 223,325 223,325 $4,295,000 - 2031A 2031A 332,835 332,835 332,835 332,835 332,835 332,835 332,835 332,835 332,835 2.6M REDUCTION IN BORROWING (186,720) (186,720) (186,720) (186,720) (186,720) (186,720) (186,720) (186,720) (186,720) 2032 - OFF YEAR $3,177,000 - 2033A 2033A 244,764 244,764 244,764 244,764 244,764 244,764 244,764 1.4M REDUCTION IN BORROWING (107,696) (107,696) (107,696) (107,696) (107,696) (107,696) (107,696) $3,351,000 - 2034A 2034A 290,020 290,020 290,020 290,020 290,020 290,020 1.98M REDUCTION IN BORROWING (171,112) (171,112) (171,112) (171,112) (171,112) (171,112) 2035 - OFF YEAR $2,472,000- 2036A 2036A 204,151 204,151 204,151 204,151 PAY CASH NO BONDING (204,151) (204,151) (204,151) (204,151) $2,481,000 - 2037A 2037A 196,387 196,387 196,387 Additional levy - - - - - - - - - - - 142,709 142,709 287,638 458,877 458,877 553,428 802,065 802,065 1,025,390 1,171,504 1,175,894 1,312,962 1,389,927 1,324,279 1,324,279 1,345,614 1,290,030 1,187,044 Road levy before debt reduction 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,258,694 2,389,519 2,327,849 2,297,170 2,126,413 2,077,471 2,135,165 2,015,305 1,976,557 2,109,520 1,956,219 1,995,731 1,977,748 1,786,005 1,744,179 1,712,841 1,405,384 1,324,279 1,345,614 1,290,030 1,187,044 Stormwater Utilty (25,000) (170,000) (150,000) (95,000) (85,000) - - - - (50,000) (50,000) (75,000) (50,000) (50,000) (150,000) - - - - - - - - - - - MSA Advance (7,500) (25,000) (85,000) (168,000) (152,500) - (41,729) (1,374) (171,060) - - - - - (50,000) - - - - - - - - - - - Excess Bond Balance (115,000) (101,921) (92,500) (140,000) (140,009) (215,310) (354,300) (340,615) (150,000) - - - - - - - - - - - - - - - - - Conduit Fee/Refunding & Project savings (15,079) (116,180) (79,792) - - - - - - - - - - - - - - - Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (75,000) (70,000) (150,000) (147,000) (65,000) - - - - - - - - - - - - - - - - Infrastructure Levy - - - - - - Road improvement levy 1,500,755 1,577,184 1,776,580 1,791,725 1,828,847 1,792,206 1,778,431 1,854,886 1,852,204 1,843,699 1,835,860 1,829,110 2,011,413 2,027,471 2,060,165 1,965,305 1,926,557 1,909,520 1,956,219 1,995,731 1,977,748 1,786,005 1,744,179 1,712,841 1,405,384 1,324,279 1,345,614 1,290,030 1,187,044 % Increase in Road levy 5.09% 12.64% 0.85% 2.07% -2.00% -0.77% 4.30% -0.14% -0.46% -0.43% -0.37% 9.97% 0.80% 1.61% -4.60% -1.97% -0.88% 2.45% 2.02% -0.90% -9.70% -2.34% -1.80% -17.95% -5.77% 1.61% -4.13% -7.98% $ Increase in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 76,455 (2,682) (8,505) (7,839) (6,750) 182,304 16,057 32,695 (94,860) (38,748) (17,036) 46,698 39,513 (17,983) (191,743) (41,826) (31,338) (307,457) (81,105) 21,335 (55,584) (102,986) TAX ABATEMENT (2016B/2017A) 149,395 146,480 151,025 153,148 155,112 224,877 227,430 222,653 228,375 228,585 228,638 233,782 233,415 96,390 - - - - - - - - - - - - - - - PUBLIC FACILITIES (Refunded 2012A) 409,773 379,197 378,462 382,872 387,322 396,207 399,882 403,347 406,602 414,897 422,683 424,289 - - - - - - - - - - - - - - - - - 559,168 525,677 529,487 536,020 542,434 621,084 627,312 626,000 634,977 643,482 651,321 658,071 233,415 96,390 - - - - - - - - - - - - - - - FLATL LINE 2,854,932 Total debt levied after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,480,886 2,487,181 2,487,181 2,487,181 2,487,181 2,244,828 2,123,861 2,060,165 1,965,305 1,926,557 1,909,520 1,956,219 1,995,731 1,977,748 1,786,005 1,744,179 1,712,841 1,405,384 1,324,279 1,345,614 1,290,030 1,187,044 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Total levied debt before reduction 2,059,923 2,102,861 2,321,146 2,475,244 2,673,202 2,775,790 2,863,743 2,918,395 2,893,671 3,033,001 2,979,170 2,955,241 2,359,828 2,173,861 2,135,165 2,015,305 1,976,557 2,109,520 1,956,219 1,995,731 1,977,748 1,786,005 1,744,179 1,712,841 1,405,384 1,324,279 1,345,614 1,290,030 1,187,044 % Increase in Debt Levied 2.08% 9.66% 0.94% 1.87% 1.77% -0.31% 3.12% 0.25% 0.00% 0.00% 0.00% -9.74% -5.39% -3.00% -4.60% -1.97% -0.88% 2.45% 2.02% -0.90% -9.70% -2.34% -1.80% -17.95% -5.77% 1.61% -4.13% -7.98% % Increase in Debt Scheduled to be levied 2.08% 10.38% 6.64% 8.00% 3.84% 3.17% 1.91% -0.85% 4.82% -1.77% -0.80% -20.15% -7.88% -1.78% -5.61% -1.92% 6.73% -7.27% 2.02% -0.90% -9.70% -2.34% -1.80% -17.95% -5.77% 1.61% -4.13% -7.98% $ Increase in Debt Levied 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 6,295 (0) 0 (0) (242,352)(120,968) (63,695) (94,860) (38,748) (17,036) 46,698 39,513 (17,983) (191,743) (41,826) (31,338) (307,457) (81,105) 21,335 (55,584) (102,986) 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Total Debt Levied before reduction Final two years of existing plan Modifying the pace of improvements, transition Debt Levy to Infrastrucure Levy Total Debt Levied after reduction Z:\Budget 2022\Capital Equipment\FINAL 2022 DEBT LEVY EXHIBIT C.xlsx 10/4/2021 BUILDINGS IMPROVEMENT FUND SOURCES Building improvement levy Community Center transfer USES HVAC Roofs Lighting Security Windows & Doors Tuck -pointing CAPITAL EQUIPMENT FUND SOURCES Capital equipment levy Equipment sales, trade-ins & donations MSA allocation USES Fleet Squads & unmarked Public Works trucks Fire trucks & rescue vehicles Heavy equipment Specialty equipment Technology PARK IMPROVEMENT FUND SOURCES Parkland dedication fees Donations & grants USES Athletic facilities & playground structures Park shelters Splash pads Trail construction UTILITIES INFRASTRUCTURE FUND SOURCES Connection fees Collection of inter-fund loans Grants as available Utility Fund transfer (Beginning in 2024) USES Water infrastructure & equipment Sewer infrastructure & equipment Fiber infrastructure & equipment STORMWATER FUND SOURCES Stormwater fees Watershed grants & cost sharing USES Permitting (MS4) & agency reporting Engineering studies Stormwater pond maintenance Flood improvements Water quality activities STREET IMPROVEMENT & DEBT SERVICE FUNDS SOURCES Street improvement levy Bond proceeds Assessments MSA allocation One-time revenues & project savings USES Street improvement debt Street reconstruction Utility reconstruction Street lights Sidewalks Mill & overlays Alleys