Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2024 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 2024-2028 & 2029-2040 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 improvements 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 • The City Hall / Community Center’s five roof top HVAC units and related controls were scheduled for replacement during the timeframe of 2020-2024; four of the five roof top units have been replaced. Updated control units for RTU’s have been completed, the Gym roof top unit will be replaced in 2024, the expected cost for this is $75,000. The controls for this unit do not need replacement • The overhead garage doors at City Hall used for Police vehicle parking are scheduled to be replaced in 2024 at an anticipated cost of $22,500. • Staff is obtaining a quote for replacing the City Hall / Community Center’s roof given the building is 27 years old. Once the quote is received it will be adjusted for inflation and will replace the current placeholder of a $180,000 roof replacement in 2025. Along with the roof, the replacement of skylights and gym wall panels as recommended in the Oertel assessment are place marked, at an additional cost of $50,000. • Quotes for replacing the Fire Station’s roof were obtained. While the building is less than 20 years old, roof leaks have been a reoccurring issue. The quotes were used for the estimated roof replacement cost of $100,000 in 2025. This would follow the rooftop unit and Makeup air unit replacement in 2024. The estimated cost for these replacements is $48,500. • Park building costs include $14,000 for Domestic water heaters at the Emerald Park building and $8,300 for security upgrades to Silver Point Park warming house. Future considerations for Building Improvement Fund: • Renewal of Community Center Lease in 2028. • Review adequacy of building improvement levy in connection with results of the Oertel evaluation of City Buildings that was conducted in 2023. Capital Equipment Fund Police • Two squads are scheduled for replacement in 2024. Squad mileage is still used as the main factor for replacement. Currently the squad replacement cycle ranges 3-4 years. That cycle is reflected in the Police Capital Improvement plan. • As in past years, certain of the retiring squads are assigned to other purposes until their full useful life has been met. In 2024 either squad 711 or 712, a 2020 Dodge Durango or 2021 Dodge Charger, will repurposed for the PD backup vehicle depending on mileage and daily vehicle needs. • The replacement of body worn cameras took place in 2023. Future costs include the replacement of facility and squad video cameras in 2025 at an expected cost of $83,000. Fire • The Fire department’s self-contained breathing apparatus (SCBA) equipment was replaced in 2023 at a cost of $218,240. • 2024 Fire department costs include replacement of turnout gear and helmets, expected to cost around $36,000. Public Works • Public Works – Streets Division: The 1995 plow truck was replaced in 2023 at a cost of $89,749; the plow and additional build up costs will occur in 2024 and are estimated to be $169,000. The replacement of the 2008 aerial truck is reflected as occurring in 2024-2027. The priority and timing of this purchase will continue to be evaluated over the coming seasons. • Public Works – Parks Division: The 2023 replacement of a John Deere 4500 Tractor has been rescheduled to 2026 as the tractor is in reasonable condition. The Bobcat 3400G Utility Vehicle is expected to be replace in 2025 at an estimated cost of $13,200. Admin. and Finance • Administration and Finance – 2024 costs include replacing Network Access devices and Wi-Fi routers through Metro I-Net, the cost is expected to be $10,525. Purchases for election equipment, office furniture and additional financial software are slated for 2024-2026. The priority and timing of these replacements will be evaluated year to year. Future considerations for Capital Improvement Fund: • 2024 implementation of phasing out the use of Infrastructure transfers as a CIP source and converting that amount to levy. Then available Infrastructure dollars would reallocated to the debt levy reduction to negate levy impact. Parks Improvement Fund • The results of the WSB Parks Evaluation have been used to determine the items and timing of future capital expenditures. • Present needs included for 2024 are: • Silverpoint park playground equipment is in need of replacement. The placeholder for this project assumes the full accessibility option for play equipment, a vendor quote for this is $220,500. • As part of the WSB parks assessment, plans over 2024-2025 are to add accessible picnic tables and benches to Central, Emerald, and Silver Point parks; the estimated cost for the 3 parks is $30,000, and to add an accessible route to the picnic shelter and grill at Emerald Park is planned for 2025 at a cost estimate of $15,000. 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 the city initiated a Parks capital improvement levy in 2021. Currently the levy phasing will be able to fund projects that are smaller in scope, however, larger scope projects will continue to be debt reliant. Utilities Infrastructure Fund • Anticipated water infrastructure costs for 2024 include: • Replacement of the dehumidifier in the GAC plant is needed and estimated at $205,000 • Domestic water heaters in GAC and Iron plants estimated to cost $3450 • Replacement of Sodium Permanganate Pumps at $17,500 • Roof replacement on wellhouses 3, 4, & 5 at a total estimated cost of $37,500 • Significant purchases for Water treatment plant components are reflected as occurring in 2024-2026. Staff has proposed a Plant components assessment in 2024 or 2025 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. • The water tanker was scheduled for replacement in 2023, but moved to 2024 as it was determined to be in good condition. The Tanker will be evaluated in 2024 and on a year to year basis until it is eventually replaced. 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 2025 to support future capital needs. Annual adjustments to water and sewer rates will ensure that operating transfers are available. • The 2024 or 2025 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. • Mirror Lake outfall repair is expected to be included in the 2024 street project at an estimated cost of $35,000 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 through 2019. Subsequently, Stormwater funds have been used to support stormwater maintenance and water quality programs. This is likely to remain in place for the foreseeable future. • 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 • The plan reflects the current street improvement schedule and 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 2024 debt levy reduction program were presented to the City Council at the 5/23/2023 council work session and approved at the 6/27/2023 City Council meeting. Summary The proposed 2024 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 2024 BUILDINGS IMPROVEMENT PLAN 2023 - 2040 SOURCES 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028-2033 2034-2040 Community Center Fund Transfer 110,000$ 110,000$ 115,000$ 120,000$ 125,000$ 130,000$ 810,000$ 840,000$ Reimbursement for Liquor Stores 4,500 23,830 11,000 183,960 21,600 15,000 67,194 48,781 GF Excess Fund balance Transfer (1) - - - - - - - Building Improvement Levy (2) 93,000 93,000 98,000 103,000 108,000 113,000 718,000 720,000 TOTAL 207,500$ 226,830$ 224,000$ 406,960$ 254,600$ 258,000$ 1,595,194$ 1,608,781$ USES City Hall/Community Center 46,500$ 129,422$ 97,500$ 266,000$ 205,000$ -$ 450,073$ 254,028$ Fire Station - - 53,500 112,500 53,000 50,000 269,865 144,220 Public Works 7,500 7,500 - 125,502 210,000 - 357,181 245,500 Park Shelters 9,000 11,225 22,300 73,950 15,000 30,000 88,180 71,000 Liquor Stores 4,500 23,830 11,000 183,960 21,600 15,000 67,194 48,781 TOTAL 67,500$ 171,977$ 184,300$ 761,912$ 504,600$ 95,000$ 1,232,492$ 763,529$ NET CHANGE 140,000 54,853 39,700 (354,952) (250,000) 163,000 362,702 845,252 BEGINNING CASH BALANCE 569,612 569,612 624,465 664,165 309,212 59,212 222,212 584,914 ENDING CASH BALANCE 709,612$ 624,465$ 664,165$ 309,212$ 59,212$ 222,212$ 584,914$ 1,430,166$ (1) Transfer of Excess GF fund balance if available. (2) Additional Building Improvement Levy of $5,000 annually, paused for 2021, on schedule for 2023. Tops out at $120,000 in 2029. BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACE D DESCRIPTION CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA/OERTE L 2023 EST ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 FUND 510 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 - - - - - - - - - - - - 30,000 - - - - - - 2014/2016 Council Chamber Doors change-out 2014 / 2016 1 Internal - - - - - - - - - - - - - - - - - - - 2016 Security upgrades - Cameras 2016 7 Internal - - - - - - 24,313 - - - - - - - - - 30,391 - - 2016 Security upgrades -Control Server 2016 1 Internal - 11,043 - - - - 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 - - - - - - - - - 31,250 2015 Parking Lot LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - 15,000 - - - - - 2015 Building LED Lighting 2015/2021 Multi.Internal - - - - - - - - - - - - - 25,000 - - - - - 2015 Boilers Replaced in 2015-130K 2 Sebesta/Oertel - - - 10,000 - - - - - - 160,850 - - - - - - - - 2022 RTU-3 (Comm. Services -Adm/Classrooms )Poor -Replaced Fall 22 1 Sebesta/Oertel - - - - - - - - - - - - - - - - - - - 2020 RTU-4 & DUCTWORK (City) Replaced in 2020 1 Sebesta/Oertel - - - - - - - - - - - - - - - - - - - RTU-4 & DUCTWORK (City) Replaced in 2020 - - - - - - - - - - - - - - - - - - - RTU-1 (Gym)FAIR -Replace 2023+1 Sebesta/Oertel - - 75,000 - - - - - - - - - - - - - - - - 2022 RTU-2 (Multi-purpose)Replaced in 2022 1 Sebesta/Oertel - - - - - - - - - - - - - - - - - - - 2021 RTU-5 (Police)Replaced in 2021 1 Sebesta/Oertel - - - - - - - - - - - - - - - - - - - 2022 HAVC Controls RTU-3 (Comm services)Next replacement 2045+1 Internal - - - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-4 (City)Next replacement 2045+1 Internal - 3,194 - - - - - - - - - - - - - - - - - HVAC Controls RTU-1 (Gym)NA 1 not required - - - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-2 (Multi-purpose)Next replacement 2045+1 Internal - - - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-5 (Police)Next replacement 2045+1 Internal - - - - - - - - - - - - - - - - - - - 2023 Entry heaters / controls Next replacement 2045+Internal 31,500 31,500 - - - - - - - - - - - - - - - - Domestic Water Heaters Fair 2 Sebesta/Oertel - - - 26,000 - - - - - - - - - - 15,000 - - - - Relamp & Reballast (LED-PD/City Hall) Done 2015/2021 Multi.Sebesta/Oertel - - - - - - - - - - - - - 25,000 - - - - - Roof & skylights/gym wall panels Poor - Fair 1 Sebesta/Oertel - - - 230,000 - - - - - - - - - - - - - - - 2017 Acoustic panels/overflow AV 2017 1 Internal - - - - - - - - - - - 15,000 - - - - - - - 2017 Community Service VCF Tiles 2017 1 Sebesta/Oertel - - - - - - - - - - - 15,000 - - - - - - - Overhead garage doors 25 years 2 Internal - - 22,500 - - - - - - - - - - - - 30,000 - - - 1996 Outdoor sign Fair 1 Internal - 60,731 - - - - - - - - - - - - - - - - - 1996 Tuck pointing -brick 35 years 1 Internal - - - - - - - - - 140,000 - - - - - - - - - 1996 Parking Lot mill and overlay 30 years 1 Internal - - - - 175,000 - - - - - - - - - - - - - - Oertel evaluation of City Buildings Sebesta/Oertel 15,000 22,954 - - - - - - - - - - - - - - - - - Mechanical Room, City Hall:Sebesta/Oertel 1996 Radiant Tube Heaters 15-20 years 2 Internal 30,000 TOTAL 46,500$ 129,422$ 97,500$ 266,000$ 205,000$ -$ 94,223$ -$ 25,000$ 140,000$ 160,850$ 30,000$ 30,000$ 65,000$ 15,000$ 30,000$ 82,778$ -$ 31,250$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - - 12,500 - - - - - - - - - - - 20,000 - - - 2016 Security upgrades -Cameras 2016 4 Internal - - - - - - 8,360 - - - - - - - - - - - - 2017 Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - 7,005 - - - - - - - - - - - - Station Paging System Fair - Good 1 Internal - - - - - 50,000 - - - - - - - - - - - - - Rooftop Units Fair - Good Multi.Sebesta/Oertel - - 31,000 - - - - - - - - - - - - - - - - Makeup Air Unit Fair 2 Sebesta/Oertel - - 17,500 - - - - - - - 20,000 - - - - - - - - 2016 Domestic Water Heaters 2016 1 Sebesta/Oertel - - - - 18,000 - - - - - - - - - 15,000 - - - - 2015 Relamp & Reballast Done w/2015 LED project Multi.Sebesta/Oertel - - - - - - - - - - - - - 35,000 - - - - - Roof Fair 1 Sebesta/Oertel - - - 100,000 - - - - - - - - - - - - - - - 2020 Exterior Paint 2020 1 Internal - - - - - - - - - 4,500 - - - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - 140,000 - - - 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 - - - - - - - - - - Generator 10 years 1 Internal - - 5,000 - - - - - - - - - 6,720 - - - - - - TOTAL -$ -$ 53,500$ 112,500$ 53,000$ 50,000$ 15,365$ -$ 90,000$ 144,500$ 20,000$ -$ 6,720$ 102,500$ 15,000$ 20,000$ -$ -$ -$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACE D DESCRIPTION CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA/OERTE L 2023 EST ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Public Works 2004 Building Components Metal Door & Frame Replacement Fair Internal 7,500 7,500 - - - - - 9,000 - - - - - - - - - - - 2016 Security upgrades -Cameras 2016 3 Internal - - - - - - 6,990 - - - - - - - - 8,500 - - - 2017 Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - 17,515 - - - - - - - - 22,000 - - - 2017 Rooftop Unit 2017 1 Sebesta/Oertel - - - 35,000 - - - - - - - - - - - - - - - Makeup Air Unit Good 3 Sebesta/Oertel - - - 19,250 - - - - - - - - - - - - - - - Air Handling Unit Good 1 Sebesta/Oertel - - - 8,050 - - - - - - - - - - - - - - - Exhaust Fans Good/20 yrs 6 Sebesta/Oertel - - - 13,340 - - - - - - - - - - - - - - - 2022 Domestic Water Heaters 2022/TBD 2 Sebesta/Oertel - - - - - - - - 15,491 - - - - - - - - - - 2015 Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta/Oertel - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta/Oertel - - - - 210,000 - - - - - - - - - - - - - - Overhead garage doors/Shop fixtures 25 years 7 Internal - - - - - - - 105,000 - - - - - - - - - - - 2020 Exterior Paint 2020 Internal - - - - - - - - - - - - - - - - - - - Tuck pointing -brick 35 years Sebesta/Oertel - - - - - - - - - 140,000 - - - - - 75,000 - - - Parking Lot mill and overlay 30 years Sebesta/Oertel - - - - - - - - - - - - 140,000 - - - - - - Rehab salt storage 25 years Sebesta/Oertel - - - - - - - 40,000 - - - - - - - - - - - Generator - Generac Power Systems 30KW 2008 - 20 years Sebesta/Oertel - - - - - - 23,185 - - - - - - - - - - - - Outdoor Storage Canopy (new)20 years Sebesta/Oertel - - - 49,862 - - - - - - - - - - - - - - - Cold Storage Building 30 years Sebesta/Oertel - - - - - - - - - - - - - - - - - - - Solaronics gas infrared heaters 2004 - 20-25 years Sebesta/Oertel - - - - - - - tbd - - - - - - - - - - - Power Master chain drive garage door 2004 - 20-25 years Sebesta/Oertel - - - - - - - tbd - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL 7,500$ 7,500$ -$ 125,502$ 210,000$ -$ 47,690$ 154,000$ 15,491$ 140,000$ -$ -$ 140,000$ -$ -$ 105,500$ -$ -$ -$ Central Park Pavilion 2003 2018 Roof 2018 Internal - - - - - - - - - - - - - - - - - - - 2016 Security upgrades -Cameras 2016/2019 Internal - 1,319 - - - - 8,360 - - - - - - - - - 10,000 - - 2016 Security upgrades - Entrance controls 2016/2019 Internal 2,500 2,953 - - - - 7,005 - - - - - - - - - 8,000 - - 2019 Other Technology 2019 1 Internal - - - 1,950 - - - - - 1,950 - - - - - - - - - 2020 HVAC 2020 Internal - - - - - - - - - - - - - - - - - - - Domestic water heaters Fair Sebesta/Oertel - - - 3,000 - - - - - - - 5,000 - - - - - - - 2019 Exterior updates 2019 Internal - - - - - - - 12,000 - - - - - - - - - - - 2018 Interior updates (LED 2023)2018 Internal 2,000 2,000 - - - - - 8,500 - - - - - - - - - - - Parking Lot mill and overlay 30 years Internal - - - - 15,000 - - - - - - - - - - - - - - 4,500$ 6,272$ -$ 4,950$ 15,000$ -$ 15,365$ 20,500$ -$ 1,950$ -$ 5,000$ -$ -$ -$ -$ 18,000$ -$ -$ Emerald Park Pavilion 2009 - - - - - - - - - - - - - - - - - - - Roof Fair Sebesta/Oertel - - - 25,000 - - - - - - - - - - - - - - - 2016 Security upgrades -Cameras 2016 Internal - - - - - - 8,360 - - - - - - - - - 10,000 - - 2016 Security upgrades - Entrance controls 2016 Internal 2,500 2,953 - - - - 7,005 - - - - - - - - - 8,000 - - HVAC Fair Sebesta/Oertel - - 14,000 - - - - - - - - - - - - - - - - Domestic water heaters Fair Sebesta/Oertel - - - 5,000 - - - - - - - 5,000 - - - - - - - Exterior updates Fair Sebesta/Oertel - - - - - 10,000 - - - - - - - - 15,000 - - - - Interior updates (LED 2023)Fair Sebesta/Oertel 2,000 2,000 - - - 10,000 - - - - - - - - 20,000 - - - - NEW Focal Point lighting/sky lights Internal - - - - - 10,000 - - - - - - - - - - - - - Parking Lot mill and overlay 30 years Internal - - - - - - - - - 20,000 - - - - - - - - - 4,500$ 4,953$ 14,000$ 30,000$ -$ 30,000$ 15,365$ -$ -$ 20,000$ -$ 5,000$ -$ -$ 35,000$ -$ 18,000$ -$ -$ Silver Point Park warming house Roof 20-30 years Sebesta/Oertel - - - - - - - - - - - - - - - - - - - Security upgrades -Cameras Internal - - 8,300 - - - - - - - - - - - - - - - - Security upgrades - Entrance controls Internal - 2,953 - - - - - - - - - - - - - - - - - HVAC Internal - - - 14,000 - - - - - - - - - - - - - - - Domestic water heaters Internal - - - 5,000 - - - - - - - 5,000 - - - - - - - Exterior updates Internal - - - - - - - - - - - - - - - - - - - Interior updates (LED 2023)Internal - - - - - - - - - - - - - - - - - - - Parking Lot/trails mill and overlay Internal - - - 20,000 - - - - - - - - - - - - - - - -$ 2,953$ 8,300$ 39,000$ -$ -$ -$ -$ -$ -$ -$ 5,000$ -$ -$ -$ -$ -$ -$ -$ Park Shelters 9,000$ 14,179$ 22,300$ 73,950$ 15,000$ 30,000$ 30,730$ 20,500$ -$ 21,950$ -$ 15,000$ -$ -$ 35,000$ -$ 36,000$ -$ -$ TOTAL IMPROVEMENTS GOVERMENTAL 63,000$ 151,101$ 173,300$ 577,952$ 483,000$ 80,000$ 188,008$ 174,500$ 130,491$ 446,450$ 180,850$ 45,000$ 176,720$ 167,500$ 65,000$ 155,500$ 118,778$ -$ 31,250$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACE D DESCRIPTION CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA/OERTE L 2023 EST ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Marketplace Liquor 2005 Building Components Rooftop Unit Fair 2 Sebesta/Oertel - - - 36,000 - - - - - - - - - - - - - - - 2016 Security upgrades -Cameras 2016 1 Internal - - - - 10,800 - 2,925 - - - - - - 12,000 - - - - - 2017 Security upgrades - Entrance controls 2017 1 Internal - - - - - - 5,915 - - - - - - - - 6,000 - - - 2019 Other Technology 2019 1 Internal - - - 1,890 - - - - - 2,257 - - - - - - 2,695 - - Domestic Water Heaters Good 1 Sebesta/Oertel - - 5,500 - - - - - - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta/Oertel - - -- - 15,000 - - - - - - - - - - - - - HVAC Cleaning & HEPA filtered vacuum install Internal - 8,790 -- - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta/Oertel - - - - - - - - 15,000 - - - - - - - - - - Roof Fair 1 Sebesta/Oertel - - - 36,398 - - - - - - - - - - - - - - - TOTAL -$ 8,790$ 5,500$ 74,288$ 10,800$ 15,000$ 8,840$ -$ 15,000$ 2,257$ -$ -$ -$ 12,000$ -$ 6,000$ 2,695$ -$ -$ Silver Lake Liquor 2005 Building Components Rooftop Units Good 1 Sebesta/Oertel - - - 65,000 - - - - - - - - - - - - - - - 2016 Security upgrades -Cameras 2016 1 Internal - - - - 10,800 - 2,925 - - - - - - 12,000 - - - - - 2017 Security upgrades - Entrance controls 2017 Internal - - - - - 5,915 - - - - - - - - 6,000 - - - 2019 Other Technology 2019 1 Internal - - - 1,890 - - - - - 2,257 - - - - - - 2,695 - - Exhaust Fans Good 1 Sebesta/Oertel - - - - - - - - - - - - - - - - - - - Domestic Water Heaters Good 1 Sebesta/Oertel - - 5,500 - - - - - - - - - 7,392 - - - - - - Finish Walk-In Cooler Refrigeration place Good 1 Sebesta/Oertel 4,500 4,500 - - - - - - - - - - - - - - - - - HVAC Cleaning & HEPA filtered vacuum install Internal 10,540 - - - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta/Oertel - - - - - - - - 15,000 - - - - - - - - - - Roof Fair 1 Sebesta/Oertel - - - 42,782 - - - - - - - - - - - - - - - TOTAL 4,500$ 15,040$ 5,500$ 109,672$ 10,800$ -$ 8,840$ -$ 15,000$ 2,257$ -$ -$ 7,392$ 12,000$ -$ 6,000$ 2,695$ -$ -$ TOTAL IMPROVEMENTS ENTERPRISE 4,500$ 23,830$ 11,000$ 183,960$ 21,600$ 15,000$ 17,680$ -$ 30,000$ 4,514$ -$ -$ 7,392$ 24,000$ -$ 12,000$ 5,389$ -$ -$ COMBINED TOTAL IMPROVEMENTS 67,500$ 174,931$ 184,300$ 761,912$ 504,600$ 95,000$ 205,688$ 174,500$ 160,491$ 450,964$ 180,850$ 45,000$ 184,111$ 191,500$ 65,000$ 167,500$ 124,168$ -$ 31,250$ 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 2024 CAPITAL EQUIPMENT 2024 - 2040 SOURCES 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028-2033 2034-2040 Capital Improvement Levy 338,200$ 338,200$ 368,200$ 398,200$ 428,200$ 458,200$ 3,379,200$ 4,866,400$ Infrastructure Transfer 90,000 90,000 90,000 90,000 90,000 90,000 270,000 270,000 Trade/Sale of Equipment 55,000 55,916 45,000 45,000 45,000 45,000 270,000 270,000 Donations/Grants 424,079 521,325 - - - - - 33,000 GF Excess Fund balance Transfer (1)100,000 - 125,000 - - - - - Interest / Equipment note proceeds 7,500 7,500 7,500 7,500 7,500 7,500 920,000 12,000 TOTAL 1,014,779$ 1,012,941$ 635,700$ 540,700$ 570,700$ 600,700$ 4,839,200$ 5,451,400$ Uses Police 178,193$ 283,037$ 201,373$ 275,634$ 85,001$ 267,186$ 1,741,765$ 1,874,927$ Fire 185,269 278,948 138,420 151,095 190,001 238,126 1,136,046 1,187,971 Administration/Finance 48,764 48,130 10,525 60,618 50,000 13,367 174,758 149,667 Streets 77,795 79,549 3,296 104,844 - 5,000 124,930 831,732 Parks 126,553 167,081 7,182 19,907 113,255 28,105 359,063 422,138 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 616,574 856,744 360,795 612,098 438,257 551,785 3,536,561 4,466,434 NET CHANGE BEFORE BIG TICKET ITEMS BELOW 398,205$ 156,197$ 274,905$ (71,398)$ 132,443$ 48,915$ 1,302,639$ 984,966$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines*424,079 437,328 - - - - 915,296 - SCBA COMPLETE PACK 218,700 218,240 - - - - - - Dump Trucks (moved 1 DT to utility fund)- 89,749 160,893 - - - 251,528 331,870 2008 F750 High Ranger Aerial Truck - - - - 195,806 - - 1991 FIRE UTILITY TRUCK (rebuild vs replace)- 96,112 - - - - - - 1999 Parks 4500 Tractor - - - - 57,765 - - - SIGNIFICANT ITEMS 642,779 841,429 160,893 - 57,765 195,806 1,166,824 331,870 NET CHANGE (244,574)$ (685,232)$ 114,012$ (71,398)$ 74,678$ (146,891)$ 135,815$ 653,096$ BEGINNING CASH BALANCE 1,069,435$ 824,862$ 139,630$ 253,642$ 182,244$ 256,921$ 110,030$ 245,845$ ENDING CASH BALANCE 824,862$ 139,630$ 253,642$ 182,244$ 256,921$ 110,030$ 245,845$ 898,941$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE and Fund balance policy, 2023 Transfer based on estimated Fiscal Year 2024 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028-2033 2034-2040 Police Department Squads - 122,024 120,437 154,136 64,506 178,113 785,865 958,877 Unmarked 46,000 47,777 48,760 - - 51,729 228,049 365,315 Retired to Other Services - 136 896 923 951 - 5,421 5,152 Technology 98,893 84,448 - 86,926 - - 382,285 297,839 Specialty Equipment 17,767 12,460 10,352 18,569 15,616 31,749 106,161 135,673 Investigative Equipment - - 3,465 3,955 - 4,895 32,351 24,315 General Equipment 15,533 16,192 17,463 11,125 3,929 699 201,633 87,756 TOTAL PD 178,193$ 283,037$ 201,373$ 275,634$ 85,001$ 267,186$ 1,741,765$ 1,874,927$ Fire Department Apparatus 479,079 662,240 - 15,000 95,000 103,195 915,296 388,685 Station Based Equipment - - 1,920 17,535 - - 64,188 79,816 Protective Gear 218,700 221,489 36,000 9,419 9,240 6,750 116,665 112,857 Technology 13,369 25,171 10,000 7,795 1,061 19,902 54,818 82,373 Protective Equipment/Tools 44,000 48,928 22,000 29,145 10,100 29,458 227,636 142,740 Office Furniture 5,000 4,900 1,000 6,500 5,700 11,871 25,776 38,044 Debt Service Payments 67,900 67,900 67,500 65,700 68,900 66,950 646,962 343,456 TOTAL FD 828,048$ 1,030,628$ 138,420$ 151,095$ 190,001$ 238,126$ 2,051,342$ 1,187,971$ Administration/Finance Computer Hardware 22,500 25,100 10,525 15,618 - 13,367 74,564 68,667 Computer Software 9,900 6,666 - 15,000 - - 50,978 33,000 Furniture and Equipment 5,000 5,000 - 30,000 50,000 - 12,245 40,000 Council Chambers 11,364 11,364 - - - - 36,971 8,000 TOTAL AF 48,764$ 48,130$ 10,525$ 60,618$ 50,000$ 13,367$ 174,758$ 149,667$ DEPARTMENTAL SUMMARIES 2023-2040 Fiscal Year 2024 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028-2033 2034-2040 DEPARTMENTAL SUMMARIES 2023-2040 PUBLIC WORKS Streets Department Fleet replacements 58,545 60,841 - 96,362 - - 72,962 324,092 Plows/Dump trucks - 89,749 160,893 - - - 251,528 331,870 Heavy Equipment - - - - - 195,806 - 136,152 Speciality Equipment 19,250 18,708 3,296 8,482 - 5,000 51,968 371,488 TOTAL 77,795$ 169,298$ 164,189$ 104,844$ -$ 200,806$ 376,458$ 1,163,602$ Parks Department Fleet replacements - 1,096 - - 55,315 - 124,197 92,354 Heavy Equipment 74,000 47,733 2,750 13,183 57,765 27,126 89,489 48,968 Mowers 45,744 57,251 1,280 - 4,074 - 64,416 188,050 Field Maintenance - - - 2,637 20,368 - 7,061 31,605 Rink Maintenance 249 59,002 640 - 13,873 - 30,316 6,253 Speciality Equipment 6,560 2,000 2,512 4,087 19,625 979 43,583 54,906 TOTAL 126,553$ 167,081$ 7,182$ 19,907$ 171,020$ 28,105$ 359,063$ 422,138$ TOTAL PW 204,348$ 336,379$ 171,371$ 124,751$ 171,020$ 228,912$ 735,520$ 1,585,739$ GRAND TOTAL 1,259,353$ 1,698,173$ 521,688$ 612,098$ 496,022$ 747,591$ 4,703,385$ 4,798,304$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.15927407 1.1940523 1.229873865 1.266770081 1.304773184 1.34391638 1.384233871 1.425760887 1.468533713 1.51258972 1.55796742 1.60470644 1.652847632 1.70243306 1.75350605 1.80611123 1.86029457 1.91610341 1.24265267 1.27993225 1.318330219 1.357880125 1.398616529 1.44057502 1.483792276 1.528306044 1.574155225 1.62137988 1.67002128 1.72012192 1.771725574 1.82487734 1.87962366 1.93601237 1.99409274 2.05391552 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Active Squads 1674 711 2020 DODGE DODGE DURANGO SUV - PATROL 3-4 1 - - 91,509 - - 102,994 - - - 115,920 - - - 130,469 - - - - 1688 714 2021 DODGE DODGE DURANGO SUV - PATROL 3-4 1 - - 60,219 - - - 67,777 - - - 76,283 - - - 85,857 - - - - 1686 712 2021 DODGE DODGE CHARGER - PATROL 3-4 1 - - 60,219 - - 62,026 - - - 69,811 - - - 78,573 - - - 88,434 - 1687 713 2021 DODGE DODGE CHARGER - PATROL 3-4 1 - - - 62,627 - - - 70,488 - - - 79,334 - - - 89,292 - - - 1706 715 2022 FORD FORD INTERCEPTOR SUV - PATROL 3-4 1 39,023 - - 64,506 - - - 72,602 - - - 81,714 - - - 91,970 - - TBD 716 2023 DODGE DODGE DURANGO - PATROL 3-4 1 83,001 116,087 130,656 147,055 165,512 - 122,024 120,437 154,136 64,506 178,113 170,770 70,488 72,602 200,467 192,203 79,334 81,714 225,628 216,327 89,292 91,970 253,946 - Unmarked 1557 6903 2022 CHEV CHEV TRAVERSE - INVESTIGATOR 6 1 - - - - 51,729 - - - - - 60,006 - - - - - 69,607 - TBD 6901 2023 CHEV CHEV TRAVERSE - CHIEF VEHICLE 6 1 46,000 47,777 - - - - 54,367 - - - - - 69,564 - - - - - 80,694 1631 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 - 48,760 - - - - 55,998 - - - - - 71,651 - - - - - 6904 2017 CHEV CHEV IMPALA - 2ND INVESTIGATOR 6 1 - - - - - - - 57,678 - - - - - 73,800 - - - - 46,000 47,777 48,760 - - 51,729 54,367 55,998 57,678 - - 60,006 69,564 71,651 73,800 - - 69,607 80,694 Retired To Other Services (1) 706 2016 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 - - - - 951 - - - 1,070 - - - 1,204 - - - 1,355 - - 1577 709 2018 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 - 136 - 923 - - 1,008 - - - 1,135 - - - 1,277 - - - - 1630 710 2018 DODGE DODGE CHARGER - PATROL 7 1 - - 896 - - - - 1,039 - - - 1,169 - - - 1,316 - - - - 136 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 47,472 40,509 - 3,960 - - 55,033 - 4,729 - 63,799 - - 5,482 - 73,960 - - 1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 - - - - - - - - 19,868 - - - - - - - - - - NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies 51,421 43,939 - 82,966 - - 60,144 - - - 106,897 71,815 - - - - 85,751 132,645 - 98,893 84,448 - 86,926 - - 115,177 - 19,868 4,729 106,897 135,614 - - 5,482 - 159,711 132,645 - Specialty Equipment NA NA ~ 2005 VARIOUS REDMAN SUIT & TASER SUIT 15 1 ea - - 1,318 1,358 - - - - - - - - - - - - NA NA VARIOUS VARIOUS BULLET RESISTANT SHIELDS 5 2 - - - 6,789 - - - - 7,871 - - - - 9,124 - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS) 5 10 621 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 968 997 1,027 NA NA VARIOUS VARIOUS SAFETY GEAR CIVIL UNREST/ CP SAFETY GRANT 10 6/6 950 950 - - - - 8,643 - - - - 10,020 - - - - - NA NA 2023 PULIC SAFTEY FENCING CONSORTIUM 5 1 5,000 5,000 - - - - 6,250 - - - - 7,500 - - - - 8,750 NA NA VARIOUS VARIOUS TASERS/BATTERIES 5 23 3,728 3,800 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 5,982 6,162 NA NA VARIOUS VARIOUS FIREARMS 15 23+ 2,485 2,089 2,800 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 3,988 4,108 NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 - - - - 20,700 - - - - - - - 36,675 - - - NA NA VARIOUS VARIOUS SQUAD RADAR 4 7 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 2,000 - - - - - - - - - - 3,500 - - - - - NA NA 2014 VARIOUS BIKES 10 2 - - 10,000 - - - - - - - - - - - - - 0 0 17,767 12,460 10,352 18,569 15,616 31,749 26,274 8,161 8,406 20,307 12,809 30,205 9,461 50,671 23,541 10,338 19,398 10,968 11,297 ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.15927407 1.1940523 1.229873865 1.266770081 1.304773184 1.34391638 1.384233871 1.425760887 1.468533713 1.51258972 1.55796742 1.60470644 1.652847632 1.70243306 1.75350605 1.80611123 1.86029457 1.91610341 1.24265267 1.27993225 1.318330219 1.357880125 1.398616529 1.44057502 1.483792276 1.528306044 1.574155225 1.62137988 1.67002128 1.72012192 1.771725574 1.82487734 1.87962366 1.93601237 1.99409274 2.05391552 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 ANNUAL INFLATION OR ESTIMATED ACTUAL Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP 5-7 7 965 - - 4,895 - - 1,528 - - 1,670 - - 1,825 - - 1,994 - NA NA VARIOUS VARIOUS HIC VISION SECURE SURVEILLANCE DVR- 5 1 - - - - - 7,500 - - - - 8,695 - - - - 10,079 - - NA NA VARIOUS VARIOUS INVESTIGATOR EHANCED COMPUTER EQUIP. 3 1 - - 3,955 - - 4,278 - 4,627 - - 5,004 - - 5,413 - - - REDACTION SOFTWARE 2,500 4,053 - - - - 3,465 3,955 - 4,895 11,778 - 1,528 4,627 4,053 10,365 5,004 - 1,825 5,413 10,079 1,994 - Administrative Equipment 1583 NA 2016 VARIOUS COPIER 1 7 - 13,573 - - - - - - 17,709 - - - - - - - 22,434 - NA NA VARIOUS VARIOUS OFFICE COMPUTERS -18 / PRINTERS-2 6 20 14,912 15,571 - 2,966 - - 20,528 - 3,439 - - 23,798 - 3,986 - - 27,588 - - NA NA VARIOUS VARIOUS MAIN OFFICE FURN/CHAIRS/FLOOR&DESK MATS 15 30+ 621 621 640 659 679 699 720 742 764 787 811 835 860 886 912 14,097 968 997 1,027 NA NA 2014 VARIOUS FRONT OFFICE FURNITURE / LOCKER ROOM 10-15 NA - - 7,500 - - - - 35,000 - - - - 7,500 - - - - - NA NA VARIOUS VARIOUS FITNESS EQUIPMENT/CARPET 10-15 6-8 - 3,250 - 3,250 - - - - 6,500 - - - - 6,500 - - - - 1483 NA 2021 CENT SQ RECORDS RETENTION MGMT SYSTEM 10 1 - - - - - - - - - 90,000 - - - - - - - - 15,533 16,192 17,463 11,125 3,929 699 21,248 742 39,203 24,996 90,811 24,633 860 12,372 7,412 14,097 28,556 23,431 1,027 TOTAL POLICE 178,193 283,037 201,373 275,634 85,001 267,186 400,623 136,427 200,355 255,126 407,908 341,326 167,807 360,322 329,664 120,455 311,070 492,591 93,017 1,344,718 1,727,483 1,630,645 FOOTNOTES 1 EXTENDING LIFE OF ACTIVE/UNMARKED OFFICER VEHICLES FOR OTHER USES Police Department 2020, 2021, 2022, 2023 Ford & Dodge SUV (4) 2021 Dodge Charger (2) 2018 Ford Taurus 2017 Chevrolet Impala 2022, 2023 Chevy Traverse (2) FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.24265267 1.27993225 1.31833022 1.35788013 1.398616529 1.440575025 1.48379228 1.52830604 1.57415523 1.62137988 1.670021278 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.15927407 1.1940523 1.22987387 1.26677008 1.304773184 1.343916379 1.38423387 1.42576089 1.46853371 1.51258972 1.557967417 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.860294572 1.916103409 ASSET REPLACEMENT PROGRAM ANNUAL INFLATION ESITMATED OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Apparatus 1636 2018 CUSTOM FIRE ENGINE - 3 25-30 1 495,540 - - - - - - - - - - - - - - - - - - - TBD 2023 CUSTOM FIRE ENGINE - 1 25-30 1 730,144 424,079 437,328 - - - - - - - - - - - - - - - - - 1288 2000 HME ENGINE - 2 25-30 1 425,000 - - - - - - 915,296 - - - - - - - - - - - - 1156 1991 ROAD RESCUE UTILITY TRUCK (rebuild vs replace) 30 1 150,000 - 96,112 - - - - - - - - - - - - - - - 250,000 - 1575 2016 FORD RESCUE - F350 10 1 74,550 - - - - - 103,195 - - - - - - - - - 138,685 - - - 1487 2011 FORD CHIEF Vehicle (Hybrid SUV - ARPA funds ) 10 1 46,897 - 70,000 - - - - - - - - - - - - - - - - - NEW FORD Asst Chief vehicle - - - - - 95,000 - - - - - - - - - - - - - - 1385 2016 FORD Code Enforcement - Explore/repl w/ hybrid 2023 n/a 1 5,000 55,000 55,000 - - - - - - - - - - - - - - - - - 2006 BOAT and MOTOR REPLACEMENT 20 1 8,000 - 3,800 - 15,000 - - - - - - - - - - - - - - - 479,079 662,240 - 15,000 95,000 103,195 915,296 - - - - - - - - 138,685 - 250,000 - Station Based Equipment 1390 2006 COMPRESSOR (SCBA) 25-30 1 40,000 - - - - - - - - - 64,188 - - - - - - - - - 2007 POWER WASHER 15-20 1 1,500 - - 1,920 - - - - - - - - - - - - - - 3,572 - 2003 TO WASHER DRYER 20 2 10,000 - - - 17,535 - - - - - - - - - - - - - - - 1389 2006 STATION STANDBY GENERATOR 30 1 40,985 - - - - - - - - - - - - - 76,244 - - - - - - 1,920 17,535 - - - - - 64,188 - - - - 76,244 - - 3,572 - Protective Gear 1713 Various TURNOUT GEAR/ HELMETS/Helmet lights 10 25 2,483 - 3,249 36,000 - - - 16,500 - - - 18,150 - - - 19,965 - - - 21,962 1713 Various ROOKIE TURN OUT GEAR 10 6 2,166 - - - 4,500 - 6,750 - 7,155 - 7,584 8,039 - 8,522 - 9,033 - 9,575 - 2021 VESTS -CIVIL UNREST/2022 CP GRANT 10 15 890 - - - - - - - - - 18,480 - - - - - - - - - Dated EMS COATS 15 32 225 - - - - 9,240 - - - - - - - - - - - - - - 2023 SCBA COMPLETE PACK 20 28 7,811 218,700 218,240 - - - - - - - - - - - - - - - - - 2016/2018 SCBA BOTTLES 15 60 750 - - - - - - - - - - 35,054 - - 37,189 - - - - - 2005 ICE RESCUE EQUIPMENT 10 4 1,000 - - - 4,919 - - - - 5,703 - - - - 6,611 - - - - - 218,700 221,489 36,000 9,419 9,240 6,750 16,500 7,155 5,703 26,064 53,204 8,039 - 52,322 19,965 9,033 - 9,575 21,962 Technology 1501 Various PAGER EQUIPMENT 5 35 600 4,869 4,869 - 5,165 - 5,480 - 5,814 - 6,168 - 6,543 - 6,942 - 7,365 - 7,813 - 2018 NETWORK SWITCH 6 1 2,500 - - - - - 2,500 - - - - - 2,500 - - - - - 2,985 - 2019 WIFI ROUTER 6 2 1,600 - - - 1,600 - - - - - 1,600 - - - - - 1,600 - - - 2006 VEHICLE COMPUTERS 5 3 2,000 - - 9,000 - - - - 10,433 - - - - 12,095 - - - - 14,022 - Various OFFICE COMPUTERS 6 8 700 - - - - - 5,480 - - - - 6,353 - - - - 7,365 - - - NEW TABLET CODE ENFORCEMENT 5 1 1,500 1,500 1,500 - - - - 1,739 - - - - - 2,076 - - - - 2,407 - 2023 Lexipol Fire software - 15,294 - - - - - - - - - - - - - - - - - 2008 EOC TECHNOLOGY 6 5 Various 4,500 - - - - 5,350 - - - - - 6,388 - - - - - 7,405 - Various OTHER BATTERIES 500 2,500 3,508 1,000 1,030 1,061 1,093 1,126 1,159 1,194 1,230 1,267 1,305 1,344 1,384 1,426 1,469 1,513 1,558 1,605 13,369 25,171 10,000 7,795 1,061 19,902 2,864 17,407 1,194 8,998 7,620 16,736 15,516 8,326 1,426 17,798 1,513 36,190 1,605 Protective Equipment/Tools FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.24265267 1.27993225 1.31833022 1.35788013 1.398616529 1.440575025 1.48379228 1.52830604 1.57415523 1.62137988 1.670021278 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.15927407 1.1940523 1.22987387 1.26677008 1.304773184 1.343916379 1.38423387 1.42576089 1.46853371 1.51258972 1.557967417 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.860294572 1.916103409 ASSET REPLACEMENT PROGRAM ANNUAL INFLATION ESITMATED OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 1710 2022 CARDICA MEDICAL EQUPMENT 35,400 - - - - - - 47,575 - - - - 49,002 - - - - - - - 2017 DEFIBRILLATOR 7 6 2,000 - - 6,000 - - - - - - 8,305 8,555 - - - - - 10,215 10,521 - 2017 DEFIBRILLATOR FOR POLICE DEPT 7 6 1,700 - - - - - - - - - 7,490 7,714 - - - - - 9,211 9,488 - Various HOSE REPLACEMENT 15 116 100-425 - 2,805 3,000 - 2,800 - 3,000 - 3,000 - 3,250 - 3,250 - 3,500 - 3,750 - - Various HOSE ACESSORIES 10 30 150 - - - - 7,300 - - - - 11,906 - - - - - 15,000 - - - 1468 Various THERMAL IMAGER 10 5 6K-12K - - 13,000 - - - - 14,000 - - - - 16,000 - - - - 18,000 - 2013/2021 LUCAS DEVICE 15 2 16,500 - - - - - 24,958 - - - - - - - - 29,601 - - - - 2023 EXTRICATION EQUIPMENT 25 3 40,000 40,000 42,123 - - - - 51,390 - - - - - - - - - - - - Various FANS/VENTILATION 15 8 2,400 - - - - - 6,000 - - - - - 3,000 - - - - - 4,500 Various SAWS (CHAIN AND CUT OFF) 10 6 1,650 4,000 4,000 - - - 4,500 - - - - 5,000 - - - - - - - - Various GAS MONITOR/ CARBON MNX DTC 6 10 600 - - - 1,350 - - 1,450 - - - - - 3,105 - - - - 3,600 - 1290 Various OUTDOOR WARNING SIRENS 30 2 22,600 - - - 27,795 - - - - - - - - - - - - - - - 44,000 48,928 22,000 29,145 10,100 29,458 109,415 14,000 3,000 27,701 24,519 49,002 25,355 - 33,101 15,000 23,176 41,608 4,500 Office Furniture 2016 OFFICE CHAIRS/FURNITURE 15 9 315 5,000 4,900 - - - 6,000 - - - - 7,000 - - - - - 6,500 - - 2015 TRAINING ROOM CHAIRS 15 35 85 - - - - - - - - 10,000 - - - - - - - - - - 2014 DAY ROOM/KITCHEN/APPLIANCES 15 6 800 - - 1,000 - - - - - - 1,250 - - - - - - - 1,558 - 1690 2021 COPIER 6 1 5,600 - - - - - - 7,526 - - - - - 8,986 - - - - - - 2016-2018 FITNESS EQUIPMENT 10 3 4,500 - - - 6,500 5,700 5,871 - - - - - - - 6,800 7,000 7,200 - - - 5,000 4,900 1,000 6,500 5,700 11,871 7,526 - 10,000 1,250 7,000 - 8,986 6,800 7,000 7,200 6,500 1,558 - TOTAL FIRE 760,148 962,728 70,920 85,395 121,101 171,176 1,051,601 38,562 19,897 128,200 92,343 73,777 49,857 67,448 137,736 187,716 31,188 342,503 28,066 FIRE ENGINE DEBT SERVICE 67,900 67,900 67,500 65,700 68,900 66,950 102,035 104,585 106,960 109,160 111,185 113,035 114,710 116,210 112,535 - - 828,048 1,030,628 138,420 151,095 190,001 238,126 1,153,636 143,147 126,857 237,361 203,528 186,813 164,567 183,659 250,272 187,716 31,188 342,503 28,066 500,000 FOOTNOTES (1) CODE ENFORCEMENT VEHICLE REPLACED WITH POLICE VEHICLE Fire Department 2016 Rescue 1 2023 Engine 1 2 2000 Engine 3 1991 UƟlity 1 2011 Staff Vehicle 2018 Engine 2 5 6 7 8 Fire Department 2013 InspecƟons Vehicle 2006 Boat and Motor 2006 Compressor 2023 SCBA Equipment FIXED ASSET SCHEDULE ADMINISTRATION/FINANCE ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 / 2017 NETWORK ACCESS DEVICES (METRO I-NET ) 7 5 1,500 - 2,600 7,325 15,618 - - 11,903 6,309 - 8,424 17,961 - - 13,688 7,255 - 9,687 20,655 - UNASSIGNED 2018 WIFI ROUTERS 6 4 800 - 3,200 - - - - - 3,200 - - - - - 3,200 - - - - UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 12,000 12,000 - - - - - - - 13,000 - - - - - - - - - NA VARIOUS COMPUTER EQUIPMENT 6 14 900 10,500 10,500 - - - 13,367 - - - - 13,768 - - - - 14,181 - - - 22,500 25,100 10,525 15,618 - 13,367 11,903 6,309 3,200 21,424 31,729 - - 13,688 10,455 14,181 9,687 20,655 - Computer Software 1532/1639 2012 CIVIC MODULES EXPANDED / ADDED 15 1 55,000 - - 15,000 - - - - - 20,000 - - - - - 25,000 - - - UNASSIGNED 2014 LASERFICHE 15 1 7,000 - - - - - 7,500 - - - - - - - - - - 8,000 - 2022 CODE CODIFCATION / WEB-HOSTING 15 11,000 9,900 6,666 - - - - - - - - - - - - - - - - - 1641 2018 POS LIQUOR CC SYSTEM MP 15 1 9,030 - - - - - - - - - - 11,739 - - - - - - - 1642 2018 POS LIQUOR CC SYSTEM SLV 15 1 9,030 - - - - - - - - - - 11,739 - - - - - - - 9,900 6,666 - 15,000 - - 7,500 - - 20,000 - 23,478 - - - 25,000 - 8,000 - Furniture and Equipment 1581RC NA ELECTION MACHINES & EQUIPMENT 10 2 10,000 - - 30,000 - - - - - - - - - 40,000 - - - - - 2022 ID BADGE EQUIPMENT/SOFTWARE 10 1 1,675 - - - - - - - - - 2,245 - - - - - - - - 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS 5,000 5,000 - - 50,000 - - - - - - 10,000 - - - - - - - 5,000 5,000 - 30,000 50,000 - - - - - 2,245 10,000 - 40,000 - - - - - Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS 5,000 5,000 - - - - 6,000 - - - - 7,000 - - - - 8,000 - - NA VARIOUS COUNCIL CHAMBERS COMPUTER/MONITORS 7-10 4 1,750-8,000 6,364 6,364 - - - - - - - - 12,971 - - - - - - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS - - - - - - 11,000 - - - - - - - - - - - 11,364 11,364 - - - - 6,000 11,000 - - 12,971 7,000 - - - - 8,000 - - TOTAL ADMIN/FINANCE 48,764 48,130 10,525 60,618 50,000 13,367 25,403 17,309 3,200 41,424 46,945 40,478 - 53,688 10,455 39,181 17,687 28,655 - ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE PUBLIC WORKS STREETS ASSET REPLACEMENT PROGRAM 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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.99409274 2.05391552 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2015 1464 2010 FORD 1 F150 PICKUP -SIGN TRUCK 15 1 31,500 - 1,200 - 56,019 - - - - - - - - - - - - - - - 1409 2007 FORD 2 F150 4X4 / SEEKING EV REPLACEMENT 15 1 31,500 58,545 58,545 - - - - - - - - - - - - - - 89,475 62,814 64,698 1657 2020 FORD 6 F150 PICKUP 4X4 EXTENDED CAB 15 1 35,000 - - - - - - - - - - - - 53,491 - - - - - 1601 2017 FORD 8 F350 PICKUP 4X4 CREW CAB 15 1 45,000 - - - - - - - - - 72,962 - - - - - - - - 1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 w/plow 15 1 47,500 - - 40,343 - - - - - - - - - - - - - - - 1712 2022 FORD 10 F450 MINI DUMP 2 TON 4X4 w/plow 15 1 47,500 - 1,096 - - - - - - - - - - - - 53,615 - - - - 260,000 58,545 60,841 - 96,362 - - - - - - 72,962 - - 53,491 53,615 - 89,475 62,814 64,698 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 - - - - - - 251,528 - - - - - - - - - - - - 1181 1995 FORD 12 L8000 DUMP TRUCK 15-25 1 187,500 - 89,749 160,893 - - - - - - - - - - - - - - - - 556,859 - 89,749 160,893 - - - 251,528 - - - - - - - 331,870 - - - - 1450 2010 VERMEER BRANCH CHIPPER 32,105 - - - - - - - - - - - - - - - - - 75,000 - 1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - 195,806 - - - - - - - - - - - - - 1670 2022 BOBCAT BOBCAT 10-15 1 43,723 - - - - - - - - - - - - 61,152 - - - - - - 1669 2020 JOHN DEERE 524L 524L FRONT END LOADER 20 1 160,000 - - - - - - - - - - - - - - - - - - - 375,828 - - - - - 195,806 - - - - - - 61,152 - - - - 75,000 - 2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - 46,562 - 2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - 6,429 - - - - - - - - - - - 12,323 1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - 6,592 - - - - - - - - - - - - - - 10,270 1656 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - - 77,405 - - - - - - 1671 2020 WACKER NEUSON WACKER NEUSON RD12A-90 ROLLER 15-20 1 15,000 - - - - - - - - - - - - - 26,576 - - - - - 1672 2020 STEPP SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 - - - - - - - - - - - - - 88,586 - - - - - 1997 WHACKER WP 1550AW VIBROPLATE 20-30 1 3,000 - - - - - 5,000 - - - - - - - - - - - - - 2018 ERSKINE 1600 2418 - 61" SNOWBLOWER (1)15-20 1 5,000 - - - - - - - - - - - - - - - - - - - 1727-1728 2022 BOBCAT 52" & 60" ANGLE BROOMS 10-15 2 10,000 - - - - - - - - - - - - 12,340 - - - - - - 1183 2021 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 - 538 - - - - - - - - - - - - - - - - - TBD 2023 FELLING FT14DT-16 #30 Dump Trailer 15-20 1 18,170 19,250 18,170 1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 - - - - - - - - - - - - - - - - 29,040 - - 2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - - 3,542 - - - - - - - - - 1579 2016 GRACO LINELAZER STREETS PAINTER 3900 15 1 10,000 - - - - - - - - 15,283 - - - - - - - - - - 2019 CADLINK VINYL CUTTER/PRINTER 15 1 7,500 - - - - - - - - - - - 11,344 - - - - - - - 2019 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 - - - - - 2022 WELDER 7 1 5,000 - - - - - - - 7,419 - - - - - - 9,124 - - - - 2022 PW SUPER OFFICE BUILD-OUT / COMPUTER 6 1 2,500 - - - - - - 3,601 - - - - - 4,300 - - - - - 5,135 2022 PRESSURE WASHER 7 1 1,657 - - - - - - - 2,459 - - - - - 2,936 - - - - - 291,687 19,250 18,708 3,296 8,482 - 5,000 10,031 9,878 15,283 5,432 - 11,344 94,046 163,098 9,124 1,890 29,040 46,562 27,728 TOTAL STREETS 77,795 169,298 164,189 104,844 - 200,806 261,559 9,878 15,283 5,432 72,962 11,344 155,197 216,589 394,608 1,890 118,515 184,376 92,426 - 251,528 - - 77,795.00 492,958 852,591 898,144 77,795 164,189 104,844 - 200,806 10,031 9,878 5,432 72,962 11,344 155,197 216,589 394,608 1,890 118,515 FOOTNOTES 15,283 (1)REPLACEMENT MADE RETAINED FOR BACKUP Specialty Equipment Fleet Plows/Dump Trucks Heavy Equipment ANNUAL INFLATION OR ESTIMATED ACTUAL hours based Public Works Department—Street FLEET 2010 Ford F150 Pickup 2020 Ford F150 4x4 2008 Ford F450 Mini Dump 2 Ton 4x4 2022 Ford F450 Mini Dump 2 Ton 4x4 2007 Ford F150 Pickup 4x4 2017 Ford F350 Pickup Public Works Department—Street PLOW/DUMP TRUCKS 2003 Sterling M8500 Acterra 2013 InternaƟonal 7400 Dump Truck 1995 Ford L8000 Dump Truck 2018 InternaƟonal 7500 Dump Truck Public Works Department—Street HEAVY EQUIPMENT 2011 Vermeer BC1500 Chipper 2008 Ford F750 High Ranger Aerial Truck 2021 Bobcat 2020 John Deere 524L Front End Loader Public Works— Streets SPECIALTY EQUIPMENT 2019 Stepp Crack Sealer 2020 Stepp SPH-2.0 Asphalt Hot Box 2021 Towmaster T-5T Single Axel Trailer 1999 Towmaster T-10 DDT Tandem Axel Trailer 2016 Streets Painter Trailer 2016 Linelazer Streets Painter 3900 Public Works— Streets SPECIALTY EQUIPMENT 2017 Doosan Air Compressor 2020 Wacker Neuson Roller FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM 1.2426527 1.279932 1.3183302 1.35788013 1.39861653 1.440575 1.48379228 1.528306 1.57415523 1.62137988 1.670021278 1.72012192 1.7717256 1.824877341 1.879623662 1.936012371 1.994092743 2.053915525 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 1709 2022 FORD 20 F350 MINI DUMP 1 TON 4X4 w/plow 15 1 42,500 - 1,096 - - - - - - - - - - - - - 92,354 - - - 1516 2014 FORD 18 F250 CREW CAB FLATBED 15 1 37,500 - - - - - - 60,125 - - - - - - - - - - - 1462 2011 FORD 21 F250 PICKUP 4X4 15 1 34,500 - - - 55,315 - - - - - - - - - - - - - - 1604 2017 FORD 22 F250 PICKUP 4X4 15 1 34,500 - - - - - - - - - 64,071 - - - - - - - - 149,000 - 1,096 - - 55,315 - - 60,125 - - 64,071 - - - - 92,354 - - - 1562 2015 BOBCAT BOBCAT 3400G UTIL VEH (ATV) - SEEKING EV OPT 10 1 10,000 - - 13,183 - - - - - - - - - 17,717 - - - - - 1188 1999 JOHN DEERE 38 4500 TRACTOR 15-25 1 35,000 - - - 47,526 - - - - - - - - - - - - - - 1999 JOHN DEERE 20" PTO AUGER (W/ TRACTOR)15-25 1 8,000 - - - 10,239 - - - - - - - - - - - - - - 1999 JOHN DEERE 72" FLAIL MOWER (W/ TRACTOR) (1)15-25 1 15,000 - - - - - - - - - - - - - - - - - - TBD 2023 BOBCAT 36 TOOL CAT 5600 (V-Blade, Snblw, BF Drag) 10-15 1 46,507 74,000 47,733 - - - - - - - - - 77,668 - - - - - - - 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 - - - - - - - - - 8,261 - - - 2019 BIG TEX TRAILER 15 1 7,000 - - - - - - - - - - - 12,041 - - - - - - 1708 2022 FELLING FT-7 TRAILER #24 15 1 5,000 - 2,750 - - - - - - - - - - - 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 (1)25+1 2,000 - - - - - - - - - - - - - - - - - - 156,222 74,000 47,733 2,750 13,183 57,765 27,126 - - - 1,574 10,247 77,668 12,041 17,717 10,949 8,261 - - - 1689 2021 TORO 47 GRANDSTAND MOWER (SPRD., VAC )10-15 1 17,500 - - - - - - - - - - - - - 31,935 - - - - 2023 VENTRAC 45 4520Z KUBOTA MOWER/ SIDEWALK BLOWER 10-15 1 37,916 45,744 57,251 - - - - - - - - - - - - - - 53,030 - - 1578 2016 TORO ZERO TURN MOWER 5000 MYRIDE 60" 15 1 25,000 - - - - - - - - 39,354 - - - - - - - - - 1673 2020 VENTRAC 44 4500Z VENTRAC 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 - - - - - - - - - 997 - 1975 JERRI JERRI SICLE MOWER 25+1 3,000 - - - 4,074 - - - - - - - - - - - - - - 163,416 45,744 57,251 1,280 - 4,074 - - 742 - 39,354 24,321 - 1,720 - 132,304 - 53,030 997 - 1580 2016 GRACO LINELAZER FIELD PAINTER 10 1 15,000 - - - 20,368 - - - - - - - - - 27,373 - - - - 2013 RAHN BALL FIELD DRAG/SCARIFIER/GROOMER 15 1 4,000 - - - - - - - - 6,297 - - - - - - - - - 2002 RYAN SOD CUTTER (1)20 1 5,000 - - - - - - - - - - - - - - - - - - 1999 JOHN DEERE 3 PT POST HOLE AUGER HAND 15 1 2,000 - - 2,637 - - - - - - - - - - - - - 4,232 - 2012 LAND PRIDE CA 1572 AIRATOR (1)10 1 2,500 - - - - - - - - - - - - - - - - - - 1490 2012 LAND PRIDE OS 1548 SLIT SEEDER (1)10 1 8,171 - - - - - - - - - - - - - - - - - - 39,171 - - - 2,637 20,368 - - - 764 6,297 - - - - 27,373 - - 4,232 - ANNUAL INFLATION OR ESTIMATED ACTUAL Fleet Field Maintenance Mowers Heavy Equipment FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM 1.2426527 1.279932 1.3183302 1.35788013 1.39861653 1.440575 1.48379228 1.528306 1.57415523 1.62137988 1.670021278 1.72012192 1.7717256 1.824877341 1.879623662 1.936012371 1.994092743 2.053915525 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 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 - - - 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 - - - - 997 - 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 - - - - 387 - - Portable Hockey rink - Central (future repl in 501)59,900 - 59,002 - - - - - - - - - - - - - - - - - Portable Hockey rink - Emerald (future repl in 501)35,000 - - - - - - - - - - - - - - - - - Portable Hockey rink - Silver Point (future repl in 501)35,000 - - - - - - - - - - - - - - - - - NA JOHN DEERE ICE RINK BROOM 10 1 9,480 - - - 13,194 - - - - - - 15,832 - - - - - - - 153,166 249 59,002 640 - 13,873 - 288 3,413 - 787 - 25,829 3,956 - 912 - 387 997 - 2021 VARIOUS WEED WHIPS -Electric 5 4 VARIES - 2,037 - - - - 2,361 - - - - 2,737 - - - - NA VARIOUS CHAIN SAWS 5 5 VARIES - - - 679 - - - - 787 - - - - 912 - - - - 2021 STIHL LEAF BLOWERS- ELECTRIC 5 5 VARIES 318 - - - - 369 - - - - 365 - - - - 2021 STIHL BACKPACK LEAF BLOWERS -ELECTRIC 5 2 300 - - 791 - - - - 917 - - - - 1,063 - - - - 1,232 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 186 - - 679 - 216 - - 787 - 251 - - - - 968 - - 2021 VARIOUS TRIMMERS - ELECTRIC 5 4 VARIES - - - 1,609 - - - - 1,865 - - - - 2,162.48 - - - - NA STIHL FS 86 BRUSH CUTTER 5 1 200 250 - - - 280 - - - - 324 - - - - - - 344 - 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,716 - - - - 3,148 - - - - 3,650 - - - - NA NA TRAFFIC WARNING CONES 5 MLTP 500 625 - - - 699 - - - - 811 - - - - 940 - - - NA NA TRAFFIC WARNING BLINKER BARRICADE 5 MLTP 1,500 1,864 - - - - 2,161 - - - - 2,505 - - - - 2,904 - - NA NA TRAFFIC WARNING BARRICADES 5 MLTP 1,500 - - - 1,920 - - - - 2,361 - - - - 2,737 - - - - NA NA EVENT BARRICADES/TRASH RECEPTACLES 5 MLTP 1,500 - 2,000 - - - - - - - - - - 3,000 - - - - 3,081 CENTRAL PARK RAILING REPAIRS 2,000 - - - - - - - - - - - - - - - - PARK SIGNAGE 3,200 - - - 4,345 - - - - 5,037 - - - - 5,840 - - - - 18,985 6,560 2,000 2,512 4,087 19,625 979 6,591 594 4,738 22,886 1,135 7,640 688 7,784 23,605 3,101 6,098 2,639 10,990 TOTAL PARKS 126,553 167,081 7,182 19,907 171,020 28,105 6,879 64,874 5,502 70,898 99,774 111,137 18,405 25,501 195,143 103,717 59,515 8,866 10,990 FOOTNOTES 347,277 553,677 513,418 (1)NOT SCHEDULED FOR REPLACEMENT 126,553 7,182 19,907 171,020 28,105 6,879 64,874 5,502 (276,379) 99,774 111,137 18,405 25,501 195,143 (449,960) (453,903) Parkland/Sidewalks/Trees Rink Maintenance Public Works - Parks FLEET 2014 Ford F250 Flatbed 2017 Ford F250 Park UƟlity 4x4 2022 Ford F350 Mini Dump 1 Ton 4x4 2011 Ford F250 Pickup 4x4 Public Works - Parks HEAVY EQUIPMENT 2015 Bobcat 3400G UTV 2018 Echo Bearcat Tow Behind Vacuum Debris Loader 2023 Bobcat UW56 T4 2012 Hydraulic Tractor Sweeper Sidewalks and Ice Rinks 2004 Big Tex 18’ Park UƟlity Trailer 2019 Big Tex 18’ Tandem Park UƟlity Trailer Public Works - Parks HEAVY EQUIPMENT 2020 Trac-Vac Mower AƩachment 1999 John Deere 4500 Tractor 2020 Giant-Vac Leaf and Debris Truck Loader 1974 Vermeer Tree Spade Public Works - Parks MOWERS 2021 Toro Grandstand Mower 2020 Ventrac 4500Z Slope Mower 2017 Toro Z Master G3 5000 Mower 2016 Toro Zero Turn Mower 5000 MYRIDE 60” 2023 Ventrac 4520Z Mower/Sidewalk Blower Public Works - Parks FIELD MAINTENANCE 2016 Linelazer Field Painter Fiscal Year 2023 2023 Est. Actual 2023 2024 2025 2026 2027 2028-2033 2034-2040 SOURCES Park Dedication Fees 1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ Park improvement levy 10,000 10,000 15,000 20,000 25,000 30,000 270,000 350,000 IFL / Transfers/Debt proceeds - - - - - $941,800 $742,680 Donations 900 900 900 900 900 900 5,795 5,853 TOTAL 12,400$ 12,400$ 17,400$ 22,400$ 27,400$ 32,400$ 1,226,595$ 1,107,533$ USES Central Park -PD Fee 10,000 10,606 - - 5,000 10,000 101,000 399,600 Central Park -PI Levy - - 7,500 7,500 - 8,250 8,250 - Emerald Park -PD Fee - - - - - - 369,000 275,000 Emerald Park -PI Levy - - 5,000 15,000 - 2,750 2,750 - Salo Park -PD Fee - - - - - - - - Salo Park - PI Levy - - - - - - - - Silver Point Park -PD Fee 141,300 67,857 152,643 - - - - - Silver Point Park -PI Levy - - 5,000 5,000 - - 4,250 - Trillium Park -PD Fee - - - - - - - - Trillium Park -PI Levy - - - - - 12,500 16,250 - Water Tower Park -PD Fee - - - - - - 638,000 253,750 Water Tower Park -PI Levy - - 5,000 5,000 - - 3,750 - WSB Park Evaluation study - - - - - - - Interfund loan payments 4,613 - 4,729 14,848 17,098 19,285 119,211 57,075 TOTAL 151,300 78,463 179,872 47,348 22,098 52,785 1,262,461 985,425 NET CHANGE -PD Fee (149,800)$ (149,800)$ (151,143)$ 1,500$ (3,500)$ (8,500)$ (1,099,000)$ (919,350)$ NET CHANGE -PI Levy 5,387 5,387 (11,329) (26,448) 8,802 (11,885) 1,063,134 1,041,458 BEG. CASH BAL. -PD Fee 285,896 285,896 136,096 (15,047) (13,547) (17,047) (25,547) (1,124,547) BEG. CASH BAL. -PI Levy 171,537 171,537 176,924 165,595 139,147 147,949 136,064 1,199,199 END CASH BAL. -PD Fee 136,096$ 136,096$ (15,047)$ (13,547)$ (17,047)$ (25,547)$ (1,124,547)$ (2,043,897)$ END CASH BAL. -PI Levy 176,924$ 176,924$ 165,595$ 139,147$ 147,949$ 136,064$ 1,199,199$ 2,240,656$ PARK IMPROVEMENT 2024 - 2040 PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION RESOURCE COUNT 2023 Est Actual 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Central Park 2003 Park Amenities LEVY Signage 3 -$ -$ -$ -$ -$ -$ 8,250$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PD Play Equipment - - - - - - 10,000 - - - - - - - 149,600 - - - - PD Skateboard Park (Replacement: fence - 2027, surface - 2033)10,000 10,606 - - - 5,000 - - - - - 66,000 - - - - - - - PD Skating Rink - hockey (future replacements)- - - - - - - - - - - - - - - - - - - LEVY Bituminous Trails - - - - - - - - TBD - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - 25,000 - - - - - - - - - 250,000 - short term Provide accessible picnic tables and benches WSB - - 7,500 7,500 - - - - - - - - - - - - - - - long term Basketball Court - - - - - - - - - - - - - - - - - - long term Relocate/additional accessible parking near Pavilion WSB - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL 10,000$ 10,606$ 7,500$ 7,500$ -$ 5,000$ 18,250$ 25,000$ -$ -$ -$ 66,000$ -$ -$ 149,600$ -$ -$ 250,000$ -$ Emerald Park 2009 Park Amenities LEVY Signage 1 - - - - - - 2,750 - - - - - - - - - - - - LEVY Ballfields - multi-use - - - - - - - - - - - - - - - - - - - LEVY Ballfields - soccer - - - - - - - - - - - - - - - - - - - LEVY Basketball Half-Court - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - PD Play Equipment - - - - 10,000 - - - - - 260,000 - - - - - - - - Shelter - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - - PD Skating Rink - hockey (future replacements)- - - - - - - - - - - 69,000 - - - - - - - LEVY Bituminous Trails - - - - - - - - TBD - - - - - - - - - - short term Provide accessible picnic tables and benches WSB - - 5,000 - - - - - - - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - 40,000 - - - - - - - 275,000 - - - Irrigation - - - - - - - - - - - - - - - - - - - short term Provide accessible route to picnic shelter and grill WSB - - - 15,000 - - - - - - - - - - - - - - - long term Provide improved accessible parking WSB - - - - - - - - TBD - - - - - - - - - - long term Provide accessible seating and access to ballfield WSB - - - - - - - - TBD - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ 5,000$ 15,000$ 10,000$ -$ 2,750$ 40,000$ -$ -$ 260,000$ 69,000$ -$ -$ -$ 275,000$ -$ -$ -$ Salo Park 2006 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Amphitheater - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION RESOURCE COUNT 2023 Est Actual 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Silver Point Park 1998 Park Amenities LEVY Signage - - - - - - - - - - - 4,250 - - - - - - - LEVY Ballfields - multi-use - - - - - - - - - - - - - - - - - - - LEVY Basketball Full-Court - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment (assumes full accessibility option)WSB 141,300 67,857 152,643 - - - - - - - - - - - - - - - - Shelter - - - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - - LEVY Bituminous Trails WSB - - - - - - - - TBD - - - - - - - - - - LEVY Drinking Fountains - - - - - - - - - - - - - - - - - - - short term Provide accessible picnic tables and benches WSB - - 5,000 5,000 - - - - - - - - - - - - - - - short term Additional Wayfinding on Silver Lake Road & 29th Ave WSB - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL 141,300$ 67,857$ 157,643$ 5,000$ -$ -$ -$ -$ -$ -$ -$ 4,250$ -$ -$ -$ -$ -$ -$ -$ Trillium Park 1980 Park Amenities LEVY Signage - - - - - - - 3,750 - - - - - - - - - - - LEVY Fountain - - - - - - 12,500 - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Sidewalk - - TBD TOTAL -$ -$ -$ -$ -$ -$ 12,500$ 3,750$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Water Tower Park 2004 Park Amenities LEVY Signage - - - - - - - 3,750 - - - - - - - - - - - LEVY Basketball Half-Court REMOVED - - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - - PD Play Equipment (assumes full accessibility option)WSB - - - - - - - - - - - 638,000 - - - - - - - LEVY Tennis Courts / Repairs Resurface 2021 resurfaced - - - - - - - - - - - - - - - - - 253,750 - LEVY Bituminous Trails - - - - - - - - TBD - - - - - - - - - - LEVY Iron Railing and Archway painting - - - - - - - - - - - - - - - - - - - short term Provide accessible picnic tables and benches.WSB - - 5,000 5,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ 5,000$ 5,000$ -$ -$ -$ 3,750$ -$ -$ -$ 638,000$ -$ -$ -$ -$ -$ 253,750$ -$ TOTAL PARK IMPROVEMENTS 151,300$ 78,463$ 175,143$ 32,500$ 10,000$ 5,000$ 33,500$ 72,500$ -$ -$ 260,000$ 777,250$ -$ -$ 149,600$ 275,000$ -$ 503,750$ -$ Parks Park AmeniƟes Amphitheater Ballfields - mulƟ-use Ballfields - soccer Basketball Courts Baƫng Cages Off-Street Parking Picnic Area Play Equipment Shelter Skateboard Park SkaƟng Rink - general SkaƟng 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 2024 SOURCES 2023 Est. Actual 2023 2024 2025 2026 2027 2028-2034 2035-2040 Interfund Loan collections (1)198,076 198,076 191,385 179,074 172,679 166,283 - - Utility Fund Transfer (2)- - - 140,000 140,000 140,000 840,000 840,000 Connection fees 300,000 426,840 9,000 9,000 9,000 9,000 24,000 20,000 Interest and other income 15,000 15,000 16,100 15,000 15,000 16,500 65,000 62,700 TOTAL 513,076$ 639,916$ 216,485$ 343,074$ 336,679$ 331,783$ 929,000$ 922,700$ USES Water Infrastructure 238,675 175,464 270,950 75,080 97,500 185,400 1,298,540 210,611 Water Equipment 1,933 2,725 197,200 9,669 1,018 9,292 144,273 329,561 Sewer Infrastructure - 8,485 - 10,000 - 15,000 60,000 - Sewer Equipment 1,933 5,704 2,200 9,669 1,018 9,292 257,770 1,097,228 Transfer to street reconstruction - - - 100,000 100,000 100,000 600,000 500,000 Fiber Infrastructure 90,000 - - - - - 22,000 29,000 TOTAL 332,542$ 192,378$ 470,350$ 204,417$ 199,537$ 318,984$ 2,382,584$ 2,166,399$ NET CHANGE 180,535$ 447,538$ (253,865)$ 138,657$ 137,142$ 12,799$ (1,453,584)$ (1,243,699)$ BEGINNING CASH BALANCE 2,421,932 2,602,467 3,050,005 2,796,140 2,934,797 3,071,939 3,084,738 1,631,154 ENDING CASH BALANCE 2,602,467$ 3,050,005$ 2,796,140$ 2,934,797$ 3,071,939$ 3,084,738$ 1,631,154$ 387,455$ (1) Principal collection of $959,326 delayed to 2023. (2) Utility Fund Transfer available after retirement of Water Bonds in 2024 UTILITIES INFRASTRUCTURE 2024 - 2040 UTILITES INFRASTRUCTURE PLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM 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 1.86029457 1.91610341 DEPT PURPOSE DESCRIPTION EST CURREN T RPLMT COST COST EST. INTERNAL SEBESTA/OERTEL 2023 Est. Actual 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Plant Facilities AOP Plant Electrical Panels serviced - placeholder - - - - - - - - 175,000 - - - - - - - - - - Peroxide Equipment - placeholders - 4,519 - - - 25,000 - - - - - - - 15,000 - - - - - GAC / Iron plants - - - - - - - - - - - - - - - - - - - Metal Door Frame & Replacement (and all well houses) Internal - - - - - - - - - - - - - - - 50,000 - - - Security upgrades -Cameras 2 Internal - - - - - - - - - - - 15,000 - - - - - - - Security upgrades - Entrance controls / Fiber Internal - - - - - - - - - - - - - - - - - - - Reznor Heating Units 2 Sebesta/Oertel - - - - - - 24,190 - - - - - - 27,000 - - - - - Dehumidifier (GAC - 1990) 1 Sebesta/Oertel 102,500 - 205,000 - - - - - - - - - - - - - - - - Domestic Water Heaters 1 Sebesta/Oertel - - 3,450 - - - - - - - - - 5,000 - - - - - 9,581 Dehumidifier (IRP - 2003) 1 Sebesta/Oertel - - - - - 77,900 - - - - - - - - - - - - - Boiler 1 Sebesta/Oertel - - - 27,600 - - - - - - - - - 29,000 - - - - - Relamp & Reballast Multi. Sebesta/Oertel - - - - - - - - - 7,000 - - - - - - - - - Flow meters- GAC & Iron Internal - - - - - - - 18,492 - - - - - - 20,000 - - - - Chorine booster pump -GAC Internal 5,796 - - - - - - - - 6,000 - - - - - - - - - GAC Roof 2016 / Iron plant roof 2026/AOP roof 2041 1 Sebesta/Oertel - - - - 95,000 - - - - - - - - - - - - - - Sodium Permanganate Pumps (3) 17,500 Production Well No. 3 Well casing Internal - - - - - 80,000 - - - - - - - - - - - - - Well No. 3 Pump restoration Internal - - - - - - - 102,730 - - - - - - - - - - Well No. 4 Pump restoration Internal 86,878 124,882 - - - - - - - - - 108,894 - - - - - - - Well No. 5 Pump restoration Internal - - - - - - 100,716 - - - - - - - - - - - - Retro fit Well No. 5 for mobile Generator Internal - - - - - - - - - 300,000 - - - - - - - - - Add permanent generator Well No. 4 Internal - - - - - - 275,000 - - - - - - - - - - - - Central Park water re-use Internal - - - - - - - - - - - - - - - 45,000 - - - Wellhouse 3, 4, 5 maintenance, roofs in 2024 Internal - - 37,500 - - - - - - - - - - - - - - - - Storage - Ground Storage and Tower Cleaning & Inspection (2) Internal - - - 12,000 - - - - 13,500 - - - 14,500 - - - - - - Water tank perimeter, new pea gravel landscaping Internal - 11,692 - - - - - - - - - - - - - - - - - Tower Painting /rehab (last painted in 2000) Internal - - - - - - - - - - - - - - - - - - - Distribution System - - Watermains (Included in streets reconstruction) Internal - - - - - - - - - - - - - - - - - - - Meter reading software upgrade / Customer portal Internal - - - - - - - 80,000 - - - - - - - - - - - Technolgy - - - - - - - - - - - - - - - - - - - Redundant server Internal - - - - - - - - - - - - - - - - - - - Chemical room SCADA Internal - 4,335 - - - - - - - - - - - - - - - - - Connect generator alarms to SCADA Internal - - TBD - - - - - - - - - - - - - - - - Wells 3&5 drawdown SCADA Internal - - - - - - - - - - - - - - - - - - - Wells 3,4&5 Card reader and alarm Internal - 27,536 - - - - - - - - - - - - - - - - - Wells 4&5 low temp alarm Internal - - - - - - - - - - - - - - - - - - - Well 4 drawdown SCADA Internal 6,000 - - - - - - - - - - - - - - - - - - Back wash valves automation 224K Internal - - - - - - - - - - - - - - - - - - - Mandates - - Wellhead Protection Plan Documentation (MDHS) Internal - - - 30,000 - - - - 35,000 - - Plant Components Assessment Internal 35,000 - 35,000 - - - - - - - - - - - - - - - - Water System Risk anaylsis and response plan Internal - - - - - - - - - - - - - - - - - - - Education/Public Awareness Internal 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 1,001 1,001 Update Inventory of Potential Contamination Sources Internal 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 1,001 1,001 Annual Well Sampling Internal 500 500 500 500 500 500 500 500 501 502 503 503 503 503 503 503 503 503 503 238,675 175,464 300,950 75,080 97,500 185,400 402,406 203,722 226,001 315,502 2,505 126,399 22,005 73,505 22,505 97,505 2,505 2,505 12,086 Lift Stations Lift Stations - SCADA system/Fiber (1) - - - - - - - - - - - 60,000 - - - - - - - Foss Road Lift Station Pump Replacement/re-hab - 8,485 - 10,000 - - - - - - - - - - - - - - - Harding Lift Station Pump Replacement/re-hab - - - - - 15,000 - - - - - - - - - - - - - Collection System Collection System (Included in streets reconstruction) - - - - - - - - - - - - - - - - - - - - 8,485 - 10,000 - 15,000 - - - - - 60,000 - - - - - - - FIBER Backbone Complete Fiber Installs, Lift Stations SCADA Connections (1) 90,000 - - - - - - - - - - - - - - - - - - Network switch City Hall - - - - - - - 22,000 - - - - - 29,000 - - - - - 90,000 - - - - - - 22,000 - - - - - 29,000 - - - - - TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 328,675$ 183,949$ 300,950$ 85,080$ 97,500$ 200,400$ 402,406$ 225,722$ 226,001$ 315,502$ 2,505$ 186,399$ 22,005$ 102,505$ 22,505$ 97,505$ 2,505$ 2,505$ 12,086$ ASSET REPLACEMENT PRORGRAM SEWER UTILITY WATER UTILITY UTILITES INFRASTRUCTURE EQUIPMENT 1.06 1.0918 1.124554 1.1582906 1.1930393 1.2288305 1.2656954 1.3036663 1.3427763 1.3830596 1.4245514 1.4672879 1.51130654 1.556645736 1.6033451 1.6514455 1.70098883 1.75201849 ASSET REPLACEMENT PRORGRAM 1.242652671 1.2799323 1.3183302 1.3578801 1.3986165 1.440575 1.4837923 1.528306 1.5741552 1.6213799 1.6700213 1.7201219 1.77172557 1.824877341 1.8796237 1.9360124 1.99409274 2.05391552 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE 2015 AGE QTY UNIT COST 2023 EST Actual 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 1403 2021 SPRINTER 4 W WATER UTILITY VAN 15 -1993 1 30,000 - - - - - - - - - - - - - - 56,389 - - - FORD 5 D FORD 150 - seeking EV option 15 58,545 58,545 58,545 - - - - - - - - - - - - - - 92,159 - 1561 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 -1987 1 51,750 - - - - - 74,550 - - - - - - - 94,437 - - - - 140,295 58,545 58,545 - - - 1,000 74,550 - - - - - - - 94,437 56,389 - 92,159 - - 1697 2021 KENWORTH 19 S VACTOR/JETTER 15 -1993 1 397,164 - 2,980 - - - - - - - - - - - - - - 655,895 - - 1644 2018 FORD 15 D L8000 DUMP TRUCK 15-25 187,500 - - - - - - - - - - - - - - - 358,034 - - - 2007 ZIEGLER CAT S GENERATOR 200KW - FOSS RD LS 25-30 -1979 1 70,000 - - - - - - - - - - 113,497 - - - - - - - - 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 -1976 1 150,000 - - 195,000 - - - - - - - - - - - - - - - - 1517 2013 CASE 590 D BACKHOE 20-25 104,963 - - - - - - - - - - - 175,290 - - - - - - - 909,627 - 2,980 195,000 - - - - - - - 113,497 175,290 - - - 358,034 655,895 - - Dehumidifier (GAC - 1990)175,000 - Dehumidifier (IRP - 2003) 1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 -1974 1 5,000 - - - - - 6,993 - - - - - - - - - 13,144 - - - 1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 -1962 1 5,000 - - - - - 6,993 - - - - - - - - - 13,144 - - - 1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 -1971 1 1,100 - 1,100 - - - - - - - - - - - - - 2,068 2,130 - - 2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 -1985 2 1,500 - - - - - 2,098 - - - - 2,432 2,505 - - - - - 2,991 3,081 EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 -1980 1 1,100 1,367 849 - - - - 1,585 - - - - - - - 2,007 - - - - 1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 -1980 1 1,500 - - - 1,977 - - - - 2,292 - - - - - 2,737 - - - 3,142 1209 2005 INGERSOL RAND D ROTO HAMMER 10 -1977 1 250 - - - - - - - 371 - - - - - - - - - - - 1417 2005 HONDA D EG1500W GENERATOR 10 -1977 1 500 - - - - - - - 742 - - - - - - - - - - - EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 -1977 1 1,000 - - 1,280 - - - - - 1,528 - - - - - 2,789 - - - - EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 -1977 1 1,000 - - - 1,318 - - - - - 1,574 - - - - - - - 1,994 2,054 EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 -1977 1 2,000 - - - - - - - 2,968 - - - - 3,440 - - - - 6,860 - EST 2005 NA D 12V POWER VENT 5-10 -1977 1 1,500 - - 1,920 - - - - - 2,433 - - - - - - - - 2,991 - 1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 -1977 1 1,500 - - - - 2,037 - - - - - - 2,505 - - - - - - - 2018 HACH WATER TESTING EQUIPMENT 5-10 3,445 - - - 4,542 - - - - - - 5,586 - - - - - - - 7,076 EST 2005 STIHL D TS460 PARTNER SAW 5-10 -1977 1 1,000 - 3,500 - - - - - 1,484 - - 1,001 1,001 - - - - - - - 32,395 1,367 5,449 3,200 7,837 2,037 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - 7,534 28,356 2,130 14,837 15,353 2016 RTA D RTA FLEET SOFTWARE (SHOP) 15-20 0 1 6,000 - - - 9,000 - - - - - - - - - - - - - - 12,323 D NETWORK SWITCHES 7-10 Various 10 1,000 - - 1,200 - - - - - - 1,200 - - - - - - - 1,200 1,200 D COMPUTERS/PRINTERS 7-10 Various 10 1,000 2,500 - - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - - 2,500 23,000 2,500 - 1,200 11,500 - 2,500 - 2,500 - 3,700 - 2,500 - 2,500 - 2,500 - 1,200 16,023 - - - - - - - - - - - - - - - - - TOTAL UTILITY 1,105,317 62,412 66,974 199,400 19,337 2,037 19,584 76,134 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,971 445,279 658,024 108,195 31,377 - - - - - - - - - - - - - - - - EQUIPMENT SPECIFIC TO WATER 180,000 - - 195,000 - - - - - - - - - - - - 56,389 - - - EQUIPMENT SPECIFIC TO SEWER 467,164 - 2,980 - - - - - - - - 113,497 - - - - - 655,895 - - DUAL PURPOSE EQUIPMENT 399,608 3,867 5,449 4,400 19,337 2,037 18,584 76,134 8,064 6,254 5,274 9,019 183,802 3,440 2,500 101,971 388,890 2,130 16,037 31,377 1,046,772 3,867 8,429 199,400 19,337 2,037 18,584 76,134 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,971 445,279 658,024 16,037 31,377 Technology Reassigned from Capital Equipment Fund Fleet Reassigned from Capital Equipment Fund Heavy Equipment Reassigned from Capital Equipment Fund Specialty Equipment Reassigned from Capital Equipment Fund Utilities Infrastructure 1953 Water Tower 2007 Foss LiŌ StaƟon 2001 Harding LiŌ StaƟon 1953 St. Anthony Water Treatment Facility, 1991 GAC, 2017 AOP Utilities Infrastructure 1957 Well #3 1959 Well #4 1961 Well #5 Utility Infrastructure FLEET 2020 Vactor/JeƩer 2015 Ford F350 UƟlity 4x4 2004 Freightliner M2 Water Tanker/Flusher 2021 Transit UƟlity Van Utility Infrastructure HEAVY EQUIPMENT 1999 Onan 400K Gen Set 1992 Onan 375K Gen Set 2013 Case 590 Loader/Backhoe Fiscal Year 2024 SOURCES 2023 EST. ACTUAL 2023 2024 2025 2026 2027 2028-2033 2034-2040 Stormwater fees UB 229,076$ 229,137$ 240,530$ 252,556$ 257,608$ 262,760$ 1,530,492$ 1,545,797$ Grants-Industrial Park Flooding (1)- - - - - - 250,000 - ARPA funding - 164,893 - - - - - - Miscellaneous / Interest 2,400 18,915 2,700 4,000 4,000 4,000 55,000 72,000 TOTAL 231,476$ 412,945$ 243,230$ 256,556$ 261,608$ 266,760$ 1,835,492$ 1,617,797$ USES Stormwater Maintenance 220,000$ 164,893$ 35,000$ -$ -$ 95,000$ 325,000$ 515,000$ Flood Improvements (1)- - - - - - 850,000 - Water Quality 58,525 39,524 - - - - 254,706 646,745 Mandates 9,000 8,200 9,425 9,866 10,325 10,801 85,929 132,827 Annual Reconstruction - - - - - - - - TOTAL 287,525 212,617 44,425 9,866 10,325 105,801 1,515,634 1,294,572 NET CHANGE (56,049)$ 200,328$ 198,805$ 246,690$ 251,283$ 160,959$ 319,858$ 323,225$ BEGINNING CASH BALANCE 222,317 166,268 366,596 565,400 812,091 1,063,374 1,224,332 1,544,190 ENDING CASH BALANCE 166,268$ 366,596$ 565,400$ 812,091$ 1,063,374$ 1,224,332$ 1,544,190$ 1,867,415$ (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 2024 - 2040 STORMWATER CAPITAL PLAN Improvement Type Location Potential Financial Sources 2023 2023 Estimated Actual 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Stormwater Pond Maintenance Ramsey County Foss Rd Ditch maintenance SAV, Ramsey - - - - - - - - - - - - - - 125,000 - - - - 33rd and Stinson (In 2021 Street Imp) SAV - - - - - - - - - - - - - - - - - - - Alley storm water repair (In 2022 Street Imp) SAV - - - - - - - - - - - - - - - - - - - Mirror Lake(outfall repair incl in 2024 street proj) SAV - 750 35,000 - - - - - - - 250,000 - - - - - - - - Silver Lake Ramsey, CH, SAV - - - - - - - - - - - - - - - - - - - Harding Pond SAV 220,000 161,043 - - - - - - - - - - - - - 200,000 - - - Salo Pond SAV - - - - - 95,000 - - - - - - 105,000 - - - - - - Central Park Rain Garden SAV - 3,100 - - - - 75,000 - - - - - - 85,000 - - - - - 220,000 164,893 35,000 - - 95,000 75,000 - - - 250,000 - 105,000 85,000 125,000 200,000 - - - Flood Improvements Industrial Park Flood Improvements SAV/MWMO - - - - - - - 850,000 - - - - - - - - - - - - - - - - - - 850,000 - - - - - - - - - - Water Quality Street Sweeper -2021 SAV - - - - - - - - - - - - - - 350,000 - - - - Salo Pond Treatment System SAV 20,250 8,636 12,250 12,740 13,250 13,780 14,331 14,904 15,500 16,120 16,765 17,436 18,133 18,858 19,613 20,397 21,213 22,062 22,944 Regional Stormwater Treatment system MWMO 1,775 7,250 1,875 1,975 2,075 2,175 8,275 2,375 2,475 2,575 2,675 2,775 10,375 2,975 3,075 3,175 3,275 11,875 3,475 Clean Streets maintenance costs SAV 6,500 6,500 6,600 6,700 6,800 6,900 7,000 7,100 7,200 7,300 7,400 7,500 7,600 7,700 7,800 7,900 8,000 8,100 8,200 Silver Lake Delisting / Weed mgmt. CO-OP - - 10,000 - - - - 10,000 - - - - 10,000 - - - - - - Water Re-use Maintenance SAV 30,000 17,138 - - 135,000 - - 40,000 - - 45,000 - - 50,000 - - - - - 58,525 39,524 30,725 21,415 157,125 22,855 29,606 74,379 25,175 25,995 71,840 27,711 46,108 79,533 380,488 31,472 32,488 42,037 34,619 Mandates SWIPP Stormwater Management Plan update SAV - - - - - - 10,000 - - - - - - - - - 15,000 - - MS4 MS4-Engineer costs SAV 6,500 7,250 6,825 7,166 7,525 7,901 8,296 8,711 9,146 9,603 10,084 10,588 11,117 11,673 12,257 12,870 13,513 14,189 14,898 Internal SW Education / Green Step Program SAV 2,500 950 2,600 2,700 2,800 2,900 3,000 3,100 3,200 3,300 3,400 3,500 3,600 3,700 3,800 3,900 4,000 4,100 4,200 9,000 8,200 9,425 9,866 10,325 10,801 21,296 11,811 12,346 12,903 13,484 14,089 14,718 15,374 16,058 16,772 32,515 18,291 19,100 Annual Reconstruction (1) Internal use for debt levy reduction - - - - - - - - - - - - - - - - - - - Contribution to streets reconstruction 2024-2037 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL STORMWATER CAPITAL PLAN 287,525 212,617 75,150 31,281 167,449 128,655 125,902 86,190 887,521 38,899 335,324 41,799 165,826 179,907 521,545 248,244 65,003 60,327 53,719 (1) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan. Future support not currently reflected but maybe committed if needed. Stormwater Retention 2004-2005 Salo Pond North 2004-2005 Salo Pond South 2003 Harding Pond 1962 Mirror Lake Stormwater Treatment Systems 2015 Silver Lake Stormwater Treatment Facility at Salo Pond 2016 St. Anthony Regional Stormwater Treatment System 2014 Central Park Rain Garden Stormwater Reuse 2008 Water Reuse Fountain Stormwater Equipment 2021 Elgin Pelican Street Sweeper Fiscal Year 2024 SOURCES 2023 Est. Actual 2023 2024 2025 2026 2027 2028 2029-2034 2035-2040 Bond Proceeds -$ 2,508,000$ 2,015,000$ -$ 2,963,000$ 1,971,000$ 11,724,000$ 11,126,000$ Road Improvement Debt Levy (1)1,989,109 1,989,109 1,753,319 1,802,073 2,109,141 2,150,975 2,242,515 13,372,885 8,778,782 Prepaid Assessments - 302,371 251,579 98,556 139,292 795,781 1,010,468 Water / Sewer Tansfers - - - 100,000 100,000 100,000 100,000 600,000 500,000 Grant Funding - - - - - - - - Debt Levy Reduction Funding 511,824 511,824 479,896 355,000 160,000 40,000 30,000 150,000 - Infrastructure levy 65,000 70,000 635,447 332,239 280,549 337,216 249,967 1,617,368 3,900,000 Miscellaneous - - - - - - - TOTAL 2,565,933$ 2,570,933$ 5,679,034$ 4,855,891$ 2,649,690$ 5,689,747$ 4,732,774$ 28,260,034$ 25,315,250$ USES Streets/Utilities Reconstruction 436,517$ 436,517$ 1,940,548$ 2,211,928$ 431,698$ 2,319,890$ 2,181,818$ 14,477,695 15,541,178 Sidewalks/Street Lights - - - - - - 492,239 1,723,111 Road Improvement debt 2,347,358 2,347,358 2,342,515 2,342,515 2,342,515 2,005,299 2,092,548 13,372,885 8,778,782 Miscellaneous 55,000 - 70,000 - - 150,000 180,000 TOTAL 2,838,875$ 2,783,875$ 4,283,063$ 4,624,443$ 2,774,213$ 4,325,189$ 4,274,366$ 28,492,819$ 26,223,072$ NET CHANGE (272,942)$ (212,942)$ 1,395,971$ 231,448$ (124,522)$ 1,364,558$ 458,408$ (232,785)$ (907,822)$ BEGINNING ACTIVITY 709,781 436,839 223,897 1,619,868 1,851,316 1,726,793 3,091,351 1,726,793 1,494,008 CUMULATIVE ACTIVITY 436,839$ 223,897$ 1,619,868$ 1,851,316$ 1,726,793$ 3,091,351$ 3,549,759$ 1,494,008$ 586,187$ (1) DEBT LEVY PROGRAM SEE EXHIBIT C STREETS IMPROVEMENT PLAN 2024 - 2040 STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2023 Est. Actual 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 Annual Street / Utility Program SEE EXHIBT A FOR DETAIL OF TYPE OF IMPROVEMENTS BY YEAR, 2022 Debt Levy/Assmts/Grants & Aids 2,182,584 436,517 436,517 - - - - - - - - - - - - - - - SEE EXHBIT B FOR STREET MAP FOR YEAR OF STREET IMPROVEMENT 2023 OFF YEAR - - - - - - - - - - - - - - - - - 2024 Debt Levy/Assmts/Grants & Aids 2,425,685 - 1,940,548 485,137 - - - - - - - - - - - - - 2025 Debt Levy/Assmts/Grants & Aids 2,158,489 - - 1,726,791 431,698 - - - - - - - - - - - - 2026 OFF YEAR - - - - - - - - - - - - - - - - - 900000 FB LEVY 2027 Debt Levy/Assmts/Grants & Aids 2,899,862 - - - - 2,319,890 579,972 - - - - - - - - - - - 2028 Debt Levy/Assmts/Grants & Aids 2,002,307 - - - - - 1,601,846 400,461 - - - - - - - - - - - 2029 OFF YEAR - - - - - - - - - - - - - - - - - - - 2030 Debt Levy/Assmts/Grants & Aids 3,519,322 - - - - - - - 2,815,458 703,864 - - - - - - - - - 2,600,000 FB LEVY 2031 Debt Levy/Assmts/Grants & Aids 3,446,752 - - - - - - - - 2,757,401 689,350 - - - - - - - - 2032 OFF YEAR - - - - - - - - - - - - - - - - - - - 2033 Debt Levy/Assmts/Grants & Aids 2,637,671 - - - - - - - - - - 2,110,136 527,534 - - - - - - 2034 Debt Levy/Assmts/Grants & Aids 5,591,862 - - - - - - - - - - - 4,473,489 1,118,372 - - - - - 2035 OFF YEAR - - - - - - - - - - - - - - - - - - - 2036 Debt Levy/Assmts/Grants & Aids 3,752,825 - - - - - - - - - - - - - 3,002,260 750,565 - - - 2037 Debt Levy/Assmts/Grants & Aids 3,356,427 - - - - - - - - - - - - - - 2,685,142 671,285 - - 2038 OFF YEAR - - - - - - - - - - - - - - - - - - - 2039 Debt Levy/Assmts/Grants & Aids 3,385,245 - - - - - - - - - - - - - - - - 2,708,196 677,049 2040 Debt Levy/Assmts/Grants & Aids 4,910,386 - - - - - - - - - - - - - - - - - 3,928,309 TOTAL 42,269,417 436,517 436,517 1,940,548 2,211,928 431,698 2,319,890 2,181,818 400,461 2,815,458 3,461,266 689,350 2,110,136 5,001,023 1,118,372 3,002,260 3,435,707 671,285 2,708,196 4,605,358 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 43,640,699 436,517 436,517 1,940,548 2,211,928 431,698 2,319,890 2,181,818 400,461 2,815,458 3,753,107 889,748 2,511,536 5,223,379 1,619,140 3,297,131 3,739,424 671,285 2,708,196 4,605,358 ANNUAL STREET PROGRAM DETAILED COSTS EXHIBIT A PROJECTED Original Const.Proposed Year Road From To Street Length Improvement Cost Est Assessments net city cost PP SA Bond size Bond 2021 Skycroft Drive 33rd Avenue 32nd Avenue 600 Reconstruct 1,167.23 700,340 - 700,340 - 700,340 2021 Croft Drive 33rd Avenue 32nd Avenue 600 Reconstruct 1,167.23 700,340 - 700,340 - 700,340 2021 29th Avenue Stinson Boulevard Silver Lake Road 1947 Mill / Overlay 149.91 291,875 92,009 199,866 27,603 264,272 2,241,000 2021 St. Anthony Boulevard Stinson Boulevard Kenzie Terrace 1948 Mill / Overlay 149.91 292,025 119,891 172,134 35,967 256,057 2,240,551 2021 31st Avenue Rankin Road Croft Drive 840 Mill / Overlay 137.88 115,819 38,446 77,373 11,534 104,285 2021 Croft Drive Rankin Road 31st Avenue 1030 Mill / Overlay 137.88 142,016 44,454 97,563 13,336 128,680 15,000 2022 Rankin Road 31st Avenue 33rd Avenue 1370 Reconstruct 1,448.88 1,984,966 239,241 1,745,725 71,772 1,913,193 2022 East Gate Road Crestview Drive Rankin Road 360 Mill / Overlay 82.10 29,556 8,176 21,380 2,453 27,103 2022 Crest View Drive 29th Avenue 31st Avenue 1490 Mill / Overlay 82.10 122,329 47,423 74,906 14,227 108,102 2,438,000 2022 Bell Lane Armour Terrace Crestview Drive 660 Mill / Overlay 82.10 54,186 21,259 32,927 6,378 47,808 $2,437,331.41 2022 Armour Terrace Silver Lake Road Crestview Drive 1580 Mill / Overlay 82.10 129,718 49,058 80,660 14,717 115,001 2022 Alley (south of 29th) 29th Avenue Alley (west of Roosevelt) 350 A, Mill / Overlay 201.44 70,504 52,023 18,481 15,607 54,897 2022 Alley (west of Roosevelt)Roosevelt Street West Terminus 310 A, Mill / Overlay 201.44 62,446 55,489 6,958 16,647 45,800 2022 Alley (south of 29th) 29th Avenue Murray Avenue 300 A, Mill / Overlay 201.44 60,432 19,984 40,448 5,995 54,437 19.60% 2023 OFF YEAR 2024 31st Avenue Silver Lake Road Rankin Road 1280 Mill / Overlay 95.24 121,903 - 121,903 - 121,903 1993 2024 Hilldale Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 95.24 120,951 45,357 75,594 15,875 105,076 1993 2024 32nd Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 95.24 120,951 45,357 75,594 15,875 105,076 1996 2024 Roosevelt Street 35th Street County Road D 1560 Mill / Overlay 95.24 148,570 55,714 92,856 19,500 129,070 1996 2024 35th Street Stinson Boulevard Harding Street 1290 Mill / Overlay 95.24 122,856 46,071 76,785 16,125 106,731 1997 2024 Roosevelt Street 34th Avenue 35th Avenue 630 Mill / Overlay 95.24 59,999 22,500 37,500 7,875 52,124 1997 2024 Edward Street 34th Avenue 35th Avenue 630 Mill / Overlay 95.24 59,999 22,500 37,500 7,875 52,124 1997 2024 Harding Street 34th Avenue 36th Avenue 1430 Mill / Overlay 95.24 136,189 51,071 85,118 17,875 118,314 2004 2024 Hilldale Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 95.24 104,761 39,285 65,475 13,750 118,510 2,508,000 15 yr bond 2004 2024 32nd Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 95.24 104,761 39,285 65,475 13,750 118,510 - 10 yr bond 2003 2024 Edward Street 33rd Avenue 34th Avenue 620 Mill / Overlay 95.24 59,047 22,143 36,904 7,750 66,797 2,508,000 2003 2024 Belden Drive 33rd Avenue 34th Avenue 1280 Mill / Overlay 95.24 121,903 45,714 76,190 16,000 137,903 2004 2024 Belden Drive 32nd Avenue 33rd Avenue 650 Mill / Overlay 95.24 61,904 23,214 38,690 8,125 70,029 2003 2024 34th Avenue Stinson Boulevard Silver Lake Road 2200 Mill / Overlay 95.24 209,521 78,570 130,951 27,500 237,021 2005 2024 Edward Street 31st Street 33rd Avenue 1390 Mill / Overlay 95.24 132,379 49,642 82,737 17,375 115,005 2005 2024 32nd Street Edward Street Belden Drive 310 Mill / Overlay 95.24 29,523 11,071 18,452 3,875 25,648 2005 2024 Wilson Street 31st Street 32nd Street 630 Mill / Overlay 95.24 59,999 22,500 37,500 7,875 52,124 2005 2024 Roosevelt Street 33rd Avenue north terminus 340 Mill / Overlay 95.24 32,381 12,143 20,238 4,250 28,131 2005 2024 Roosevelt Street 31st Street 33rd Avenue 1290 Mill / Overlay 95.24 122,856 46,071 76,785 16,125 106,731 2005 2024 St. Anthony Road Roosevelt Street Edward Street 400 Mill / Overlay 95.24 38,095 14,286 23,809 5,000 33,095 2002 2024 31st Avenue Wilson Street Silver Lake Road 1260 Mill / Overlay 95.24 119,999 44,999 74,999 15,750 104,249 2005 2024 31st Avenue Stinson Boulevard Wilson Street 990 Mill / Overlay 95.24 94,285 35,357 58,928 12,375 81,910 2002 2024 Wilson Street 30th Avenue 31st Avenue 630 Mill / Overlay 95.24 59,999 22,500 37,500 7,875 67,874 2002 2024 Harding Street 30th Avenue 31st Avenue 630 Mill / Overlay 95.24 59,999 22,500 37,500 7,875 67,874 2004 2024 Townview Avenue Wilson Street Silver Lake Road 1290 Mill / Overlay 95.24 122,856 46,071 76,785 16,125 138,980 2,425,685 73.12% 2,425,684 2025 Macalaster Drive South terminus 39th Avenue 500 Reconstruct 1,641.77 820,886 217,197 603,689 76,019 744,868 2005 2025 39th Avenue Stinson Blvd Silver Lake Road 2200 MSA Mill / Overlay 151.43 333,139 124,927 208,212 43,724 289,414 2000 2025 29th Avenue Silver Lake Road Rankin Road 1290 MSA Mill / Overlay 100.95 130,227 48,835 81,392 17,092 113,135 788,000 15 yr bond 1999 2025 Wilson Street 27th Avenue St. Anthony Boulevard 480 Mill / Overlay 100.95 48,457 18,171 30,285 6,360 42,097 1,227,000 10 yr bond 2001 2025 Wilson Street 29th Avenue 30th Avenue 630 Mill / Overlay 100.95 63,599 23,850 39,750 8,347 55,252 2,015,000 2001 2025 W Armour Terrace Roosevelt Street Silver Lake Road 1840 Mill / Overlay 100.95 185,750 69,656 116,094 24,380 161,370 2006 2025 30th Avenue Stinson Boulevard Wilson Street 960 Mill / Overlay 100.95 96,913 36,342 60,571 12,720 84,193 2001 2025 30th Avenue Wilson Street Silver Lake Road 1270 Mill / Overlay 100.95 128,208 48,078 80,130 16,827 111,381 2006 2025 Murray Avenue Roosevelt Street Wilson Street 830 Mill / Overlay 100.95 83,789 31,421 52,368 10,997 72,792 2006 2025 Murray Avenue Wilson Street Coolidge Street 710 Mill / Overlay 100.95 71,675 26,878 44,797 9,407 62,268 2006 2025 Coolidge Street St. Anthony Boulevard 29th Avenue 730 Mill / Overlay 100.95 73,694 27,635 46,059 9,672 64,022 2006 2025 Roosevelt Street St. Anthony Boulevard 30th Avenue 1210 Mill / Overlay 100.95 122,151 45,807 76,344 16,032 106,119 2,158,489 33.30% PROJECTED BASE ANNUAL STREET PROGRAM DETAILED COSTS EXHIBIT A 2026 OFF YEAR 2027 Rankin Road CR 88 31st Avenue 1310 Reconstruct 2,213.64 2,899,862 394,223 2,505,640 98,556 2,801,307 2,963,000 15 yr bond 2,899,862 13.59% 2028 Townview Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,564.30 2,002,307 557,168 1,445,139 139,292 1,863,015 1,971,000 15 yr bond 2,002,307 27.83% 2029 OFF YEAR 2030 31st Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,757.65 2,249,792 693,109 1,556,683 173,277 2,076,515 1999 2030 Wilson Street 27th Avenue St. Anthony Boulevard 990 Mill / Overlay 135.10 133,744 50,154 83,590 17,554 116,191 2007 2030 27th Avenue Stinson Boulevard Pahl Avenue 1550 Mill / Overlay 135.10 209,398 78,524 130,874 27,483 181,914 2007 2030 Roosevelt Street 27th Avenue Pahl Avenue 550 Mill / Overlay 135.10 74,302 27,863 46,439 9,752 64,550 2007 2030 Pahl Avenue Roosevelt Street Wilson Street 720 Mill / Overlay 135.10 97,269 36,476 60,793 12,767 84,502 2,197,000 15 yr bond 1999 2030 Pahl Avenue Wilson Street Coolidge Street 610 Mill / Overlay 135.10 82,408 30,903 51,505 10,816 71,592 1,417,000 10 yr bond 2007 2030 Alley (south of Pahl) Roosevelt Street Wilson Street 760 A, Mill / Overlay 287.71 218,656 142,126 76,530 49,744 168,912 3,614,000 2007 2030 Alley (north of Pahl) Roosevelt Street Wilson Street 770 A, Mill / Overlay 287.71 221,533 143,996 77,537 50,399 171,134 2030 Alley (south of Pahl) Wilson Street 27th Avenue 480 A, Mill / Overlay 205.50 98,642 64,117 34,525 22,441 76,201 2030 Alley (north of Pahl) Wilson Street 27th Avenue 650 A, Mill / Overlay 205.50 133,577 86,825 46,752 30,389 103,189 3,519,322 38.48% 2031 Skycroft Circle Skycroft Drive Skycroft Drive 1550 Reconstruct 1,863.11 2,887,819 805,795 2,082,024 201,449 2,686,370 3,420,000 15 yr bond 2031 34th Avenue Skycroft Drive Croft Drive 300 Reconstruct 1,863.11 558,933 47,400 511,533 11,850 547,083 3,446,752 24.75% 2032 OFF YEAR 2033 Macalaster Drive 39th Avenue Silver Lane 1260 Reconstruct 2,093.39 2,637,671 532,583 2,105,087 133,146 2,504,525 2,649,000 15 yr bond 2,637,671 20.19% 2034 Shamrock Drive 39th Avenue Silver Lane 1260 Reconstruct 2,218.99 2,795,931 592,765 2,203,166 148,191 2,647,740 5,541,000 15 yr bond 2034 Fordham Drive 39th Avenue Silver Lane 1260 Reconstruct 2,218.99 2,795,931 818,580 1,977,350 204,645 2,591,286 5,591,862 25.24% 2035 OFF YEAR 2036 Penrod Lane 39th Avenue Silver Lane 1260 Reconstruct 2,493.26 3,141,508 919,757 2,221,751 229,939 2,911,569 3,080,000 15 yr bond 2019 2036 Chandler Drive/Foss Road 37th Avenue Highcrest Road 3190 Mill / Overlay 191.64 611,317 373,868 237,449 130,854 480,463 508,000 10 yr bond 3,752,825 34.47%3,588,000 2037 Croft Drive 33rd Avenue Downers Drive 1270 Reconstruct 2,642.86 3,356,427 966,490 2,389,937 241,623 3,114,804 3,292,000 15 yr bond 3,356,427 28.80% 2038 OFF YEAR 2039 Downers Drive Skycroft Drive Highcrest Road 1140 Reconstruct 2,969.51 3,385,245 868,801 2,516,443 217,200 3,168,044 3,348,000 15 yr bond 3,385,245 25.66% 2040 Skycroft Drive Maplewood Drive 33rd Avenue 1560 Reconstruct 3,147.68 4,910,386 1,101,111 3,809,275 275,278 4,635,109 4,898,000 15 yr bond 4,910,386 22.42% TBD Anthony Lane N County Road C North terminus 800 Reconstruct 2,962.32 2,369,857 829,450 1,540,407 207,362 2,162,494 $2,227,369.33 TBD Anthony Lane S County Road C south 2930 Reconstruct 3,140.06 9,200,377 3,220,132 5,980,245 805,033 8,395,344 $8,542,262.77 Industrial Park - Upon Redevelopment / TIF 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 2024 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,988 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 $2,385,000 - 2022A 2022A - 192,907 189,511 191,365 193,061 189,350 190,889 187,020 188,401 194,875 190,534 160,901 162,061 162,906 163,584 164,011 - 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,347,358 2,173,215 1,981,198 1,869,349 1,745,778 1,614,018 1,494,475 1,342,554 1,165,216 996,778 771,012 593,278 485,820 244,689 164,011 - - - 2023 Road Improvements Bonds 2023 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2024-2037 Road Improvements Bonds 2024A 2024A 275,875 270,261 275,261 270,469 270,667 270,839 271,127 270,706 269,980 274,195 130,247 132,029 133,418 134,398 129,703 2025A 2025A 229,531 229,936 230,556 231,196 226,509 227,181 227,895 227,969 232,986 226,996 141,172 142,229 142,850 143,019 142,721 2026 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2027A 2027A 291,472 290,578 289,869 294,415 293,483 292,383 291,364 289,714 293,011 290,554 282,535 293,716 294,065 980K REDUCTION IN BORROWING 960K (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) (64,000) 2028A 2028A 339,138 337,107 340,666 338,870 342,280 340,216 330,234 340,971 337,693 339,310 244,914 247,881 2029 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2030A 2030A 401,595 403,067 399,594 401,539 398,042 399,798 401,575 402,197 402,236 401,682 2031A 2031A 383,777 383,777 383,777 383,777 383,777 383,777 383,777 383,777 383,777 2.1M REDUCTION IN BORROWING 800K800 (53,333) (53,333) (53,333) (53,333) (53,333) (53,333) (53,333) (53,333) (53,333) 2032 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2033A 2033A 292,361 292,361 292,361 292,361 292,361 292,361 292,361 923K REDUCTION IN BORROWING (70,167) (70,167) (70,167) (70,167) (70,167) (70,167) (70,167) 2034A 2034A 277,608 277,608 277,608 277,608 277,608 277,608 1.55M REDUCTION IN BORROWING (119,372) (119,371) (119,371) (119,371) (119,371) (119,371) 2035 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 2036A 2036A 256,344 256,344 256,344 256,344 2.25M REDUCTION IN BORROWING (210,202) (210,202) (210,202) (210,202) 2037A 2037A 243,179 243,179 243,179 2038 - OFF YEAR $0.00 $0.00 Additional levy - - - - - - - - - - - - - 275,875 499,792 505,197 728,497 1,067,579 1,060,324 1,470,984 1,800,465 1,798,650 2,028,938 2,022,108 1,953,856 1,998,486 2,237,485 2,149,784 2,022,545 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,347,358 2,173,215 2,257,073 2,369,141 2,250,975 2,342,515 2,562,054 2,402,878 2,636,200 2,797,243 2,569,662 2,622,216 2,507,928 2,198,545 2,162,497 2,237,485 2,149,784 2,022,545 Stormwater Utilty (25,000) (170,000) (150,000) (95,000) (85,000) - - - - - - - - - - - - - - - - - - - - - - MSA Advance (7,500) (25,000) (85,000) (168,000) (152,500) - (41,729) (1,374) (6,425) - - - - - - - - - - - - - - - - - Excess Bond Balance (115,000) (101,921) (92,500) (140,000) (140,009) (215,310) (354,300) (340,615) (351,824) (419,896) (355,000) (160,000) - - - - - - - - - - - - - - Conduit Fee/Refunding & Project savings (15,079) (116,180) (79,792) - - - - - - - - - - - - - - - - - - Water / Sewer bonds retired - - (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (75,000) (70,000) (150,000) (160,000) (60,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,109 1,693,319 1,802,073 2,109,141 2,150,975 2,242,515 2,462,054 2,302,878 2,536,200 2,697,243 2,469,662 2,522,216 2,407,928 2,098,545 2,062,497 2,137,485 2,049,784 1,922,545 % Change 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%-7.42%6.42%17.04%1.98%4.26%9.79%-6.47%10.13%6.35%-8.44%2.13%-4.53%-12.85%-1.72%3.64%-4.10%-6.21% $ Change in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 76,455 (2,682) (8,505) (7,839) (6,751) (135,789) 108,753 307,068 41,834 91,540 219,539 (159,176) 233,322 161,043 (227,581) 52,554 (114,288) (309,383) (36,048) 74,989 (87,702) (127,239) 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,783 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,072 233,415 96,390 - - - - - - - - - - - - - - - FLATL LINE 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 1,926,734 1,898,463 2,109,141 2,150,975 2,242,515 2,462,054 2,302,878 2,536,200 2,697,243 2,469,662 2,522,216 2,407,928 2,098,545 2,062,497 2,137,485 2,049,784 1,922,545 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 3,005,430 2,406,630 2,353,463 2,369,141 2,250,975 2,342,515 2,562,054 2,402,878 2,636,200 2,797,243 2,569,662 2,622,216 2,507,928 2,198,545 2,162,497 2,237,485 2,149,784 2,022,545 % Change 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%-22.53%-1.47%11.10%1.98%4.26%9.79%-6.47%10.13%6.35%-8.44%2.13%-4.53%-12.85%-1.72%3.64%-4.10%-6.21% % Change 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.88% -19.92% -2.21% 0.67% -4.99% 4.07% 9.37% -6.21% 9.71% 6.11% -8.14% 2.05% -4.36% -12.34% -1.64% 3.47% -3.92% -5.92% $ Change in Debt Levied 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 6,295 (0) 0 (0) (560,446)(28,272) 210,678 41,834 91,540 219,539 (159,176) 233,322 161,043 (227,581) 52,554 (114,288) (309,383) (36,048) 74,989 (87,702) (127,239) 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 2036 2037 Total Debt Levied before reduction Phase II Transition Point Modifed the pace of improvements, transition Debt Levy to Infrastrucure Levy Total Debt Levied after reduction Z:\Budget 2024\capital\Streets\2024 debt levy for street capital format change only 11/9/2023