The URL can be used to link to this page

Home My WebLink About2023 Capital Funds bookCity of St. Anthony Village 3301 Silver Lake Road St. Anthony, Minnesota 55418 www.savmn.com City of St. Anthony CAPITAL FUNDS 2023-2027 & 2028-2039 INDEX: Fund Summaries: Buildings Improvement Capital Equipment Park Improvement UƟ liƟ es 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-2022. o Four of the five roof top units have been replaced. Updated control units for RTU’s have been completed. o The Gym roof top unit will be replaced in 2023 or later. The controls for that unit do not need replacement. o To finish off the HVAC system a quote was obtain for the various entry way heaters and their related controls. The expected replacement will be 2023. The replacement of the controls will complete the separation from the Boiler system. The old controls caused a high run rate for boiler system. • We are obtaining a quote for replacing the City Hall / Community Center’s roof given the building is 26 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. • The painting of the City Hall main entrance doors along with added door security features was budgeted for 2022 at an estimated cost of $26,500. The 2022 work included certain other entrance doors for painting and repair as needed. The final cost of this project was $37,091. • 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 in 2023. • LED lighting upgrades have been scheduled for the Park Shelters in 2023. Transitioning to LED lighting is a practice which helps maintain the City’s Green Step 5 rating, along with providing energy savings. • Lastly it has been several years since the last professional evaluation of the City building’s major components. Staff has been considering an evaluation of this type to ensure that the existing plan’s replacement items, costs and timing are reasonably accurate and complete. The $15,000 project placeholder has been moved to the 2023 budget. Future considerations for Building Improvement Fund: • Renewal of Community Center Lease in 2028. • Review adequacy of building improvement levy in connection with results of "Sebesta Type" evaluation of City Buildings. Capital Equipment Fund Police • One squad is scheduled for replacement in 2023. 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 CIP plan. • As in past years, certain of the retiring squads are assigned to other purposes until their full useful life has been met. o In 2022 squad 709, a 2018 Dodge Durango, was repurposed for the PD Reserve vehicle. o Then the 2016 Ford Explorer/PD Reserve vehicle was repurposed to replace the Fire Department’s 2006 Ford Explorer Code enforcement / Inspections vehicle. • The unmarked squad for the Police Chief is scheduled for replacement in 2023. The replacement will be a 2023 Chevy Traverse. The unmarked squads are on a six-year replacement schedule. • Retiring unmarked squads are often used to fill other needs. o In 2022 the retired Investigator 2016 Chevy Impala became the Court/School car. The prior Court/School was sold. o In 2023 the Chief’s retired 2017 Chevy Impala will be reassigned to the 2nd Investigator / patrol position designed in 2022. • The replacement of body worn cameras in 2022 has been deferred to 2023. The replacement of facility and squad video cameras has been deferred to 2025. This is due to the department’s body worn cameras in use are no longer available. Therefore, requiring the purchase of new charging equipment and related camera accessories as well. The Police Department is evaluating other possible vendors and data storage options. The Chief is in discussions with other Ramsey County Police department’s in our similar position. The estimated costs reflected in the budget represents the current vendor’s pricing of comparable equipment. A 2023 vendor decision has been anticipated for budget purposes. Fire • The Fire department’s 2023 replacement of self-contained breathing apparatus (SCBA) equipment was estimated at $277,200 in last year’s CIP budget. The replacement cost has been lowered to $218,700 in this years CIP. The cost reduction was achieved by the department’s participation in fire services JPA. Public Works • Public Works – Streets Division: In 2023 fleet replacements Ford F150 Electric truck. Significant purchases for replacing the 1995 plow truck and the 2008 aerial truck are reflected as occurring in 2024-2027. The priority and timing of these purchases will be evaluated year to year. • Public Works – Parks Division: In 2023 significant replacements will be the multi-use Tool Cat 5600 at an estimated cost of $74,000 and a Toro Groundmaster 360 mower at an estimated cost of $45,744. These two pieces of equipment are heavily used. The 2023 replacement of a John Deere 4500 Tractor has been rescheduled to 2026 as the tractor is in reasonable condition. Admin. and Finance • Administration and Finance – 2023 costs include replacing the majority of desktop and laptop computers not replaced in 2022 and the cost of recodification of the city code and the web hosting of the same. 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: • 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. Targeting 2024 CIP process to review and possibly implement this change. Parks Improvement Fund • The results of the WSB Parks Evaluation study will inform the items and timing of future capital expenditures. • Present needs included for 2023 are: • $10,000 to repair Skateboard park for surface safety issue. • A placeholder for the potential repair or replacement of Silverpoint park playground equipment has been added for the Parks Commission’s review. The placeholder included is the full replacement option, less costly options will also be evaluated. • A $177,000 transfer of general fund surplus has been anticipated as a source in 2022. The general fund transfers will be reviewed for Council action at a Council meeting prior to year-end. Future considerations for Park Improvement Fund: • The Park improvement fund’s revenue source is Park Dedication fees. Allowed uses of park dedication fees are limited in scope. Also, dedication fees are insufficient to add any new amenities in the City Parks. Therefore, the City has been reliant on debt financing for significant additions and improvements. In order to fund the replacement of existing park amenities initiating a Parks capital improvement levy should be considered. Levy phase-in implemented in 2021. • Based on WSB’s Parks Evaluation findings, consider additional interfund loan to finance priority needs. Utilities Infrastructure Fund • Water infrastructure improvements for 2022 included the water tower rehab and painting project. That project has been completed and the estimated final cost is $525,000. • Significant purchases for Water treatment plant components are reflected as occurring in 2023-2026. Staff has proposed a 2023 Plant components assessment be performed by a third- party subject matter expert. A placeholder of $35,000 has been included in the capital budget. The amount reflects the complexities of three separate water treatment processes employed by the City. • Fleet and other equipment used in maintain the delivery and collections systems is budgeted separately from the Water treatment plant and Sanitary lift stations. In 2023 a Ford Electric pickup is anticipated to be delivered replacing a 2007 pick-up. The water tanker was scheduled for replacement in 2023 that has been pushed to 2024 given the tanker is still in good operating condition. The Tanker will be evaluated 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 2022 Plant components assessment will aid in informing the necessary capital expenditure items and timing of the same. Stormwater Fund • A placeholder for an Industrial Park flooding mitigation has moved to 2030, anticipating that redevelopment will not occur until a later date. • The Harding Pond project will be going out for bid within the new few weeks. The $272,000 estimated project anticipates restoring the flooding capacity to the ponds original design. • A repair of a failed stormwater pipe along 33rd Ave was completed as part of the 2021 street project. This project will resolve localized minor flooding during heavy rains that has occurred over the last several years. • The 2022 street project included projects to repair an alley storm water situation and the 15- year maintenance needs for the Foss Rd ditch system. This project was ordinally scheduled in 2024-2025 time-frame. Project was moved up due to need. 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. • The stormwater rates have been adjusted over time to support maintenance costs and capital needs. Continuing rate management will ensure sustainability. Street Improvement and Debt Service Plan • Plan reflects the current street improvement schedule. • Plan has updated projections for future bond interest rates. • Annual street improvements include a mixture of street, utility and storm water reconstruction, alley improvements and mill and overlays. • The street improvement schedule and 2023 debt levy reduction program were presented to the City Council at the 3/22/22 council work session and approved at the 7/12/22 City Council meeting. Summary The proposed 2023 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 2023 SOURCES 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 Community Center Fund Transfer 105,474$ 105,474$ 110,000$ 115,000$ 120,000$ 125,000$ 130,000$ 810,000$ 840,000$ Reimbursement for Liquor Stores - 4,500 110,000 82,960 21,600 15,000 66,460 36,000 GF Excess Fund balance Transfer (1)- - - - - - - Building Improvement Levy (2)88,000 88,000 93,000 98,000 103,000 108,000 113,000 718,000 720,000 TOTAL 193,474$ 193,474$ 207,500$ 323,000$ 305,960$ 254,600$ 258,000$ 1,594,460$ 1,596,000$ USES City Hall/Community Center 166,550$ 267,364$ 46,500$ 97,500$ 216,000$ 175,000$ 56,000$ 476,073$ 252,778$ Fire Station - - 98,700 48,500 12,500 53,000 50,000 179,865 137,500 Public Works - 13,470 7,500 - 40,640 35,000 210,000 403,996 245,500 Park Shelters - - 9,000 14,000 31,950 15,000 20,000 93,180 81,000 Liquor Stores - - 4,500 110,000 82,960 21,600 15,000 66,460 36,000 TOTAL 166,550$ 280,834$ 166,200$ 270,000$ 384,050$ 299,600$ 351,000$ 1,219,573$ 752,778$ NET CHANGE 26,924 (87,360) 41,300 53,000 (78,090) (45,000) (93,000) 374,887 843,222 BEGINNING CASH BALANCE 698,664 698,664 611,304 652,604 705,604 627,514 582,514 489,514 864,401 ENDING CASH BALANCE 725,588$ 611,304$ 652,604$ 705,604$ 627,514$ 582,514$ 489,514$ 864,401$ 1,707,623$ (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 PLAN 2023 - 2039 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 BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACED DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2022 EST ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 City Hall 1996 Building Components PARTIAL 2018 Metal Door Frame & Replacement PD and EE Entrances 2018 Multi.Internal -$ -$ -$ -$ -$ -$ -$ 28,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 2022 Front Entr. Doors paint / security controls Main Entry set & EE interior Multi.Internal 26,500 37,091 - - - - - - - - - - - 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 - - - - - - - 17,500 - - - - - - - - - 21,875 2017 Security upgrades - Entrance controls 2017 Multi.Internal - 2,423 - - - - - 24,410 - - - - - - - - - 30,513 2016 Replacement of Fire Alarm Panel 2016 1 Internal - - - - - - - - - 25,000 - - - - - - - - 2015 Parking Lot LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - 15,000 - - - 2015 Building LED Lighting 2015/2021 Multi.Internal - - - - - - - - - - - - - - 25,000 - - - 2015 Boilers Replaced in 2015-130K 2 Sebesta - - - - 10,000 - - - - - - 160,850 - - - - - - 2022 RTU-3 (Comm. Services -Adm/Classrooms )Poor -Replaced Fall 22 1 Sebesta 98,750 98,750 - - - - - - - - - - - - - - - - 2020 RTU-4 & DUCKWORK (City) Replaced in 2020 1 Sebesta - - - - - - - - - - - - - - - - - - RTU-4 & DUCKWORK (City) Replaced in 2020 - - - - - - - - - - - - - - - - - - RTU-1 (Gym)FAIR -Replace 2023+1 Sebesta - - - 75,000 - - - - - - - - - - - - - - 2022 RTU-2 (Multi-purpose)Replaced in 2022 1 Sebesta - 76,200 - - - - - - - - - - - - - - - - 2021 RTU-5 (Police)Replaced in 2021 1 Sebesta - - - - - - - - - - - - - - - - - 2022 HAVC Controls RTU-3 (Comm services)update with RTU Units 1 TBD 26,300 28,100 - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-4 (City)update with RTU Units 1 TBD - 24,800 - - - - - - - - - - - - - - - - HVAC Controls RTU-1 (Gym)update with RTU Units 1 not required - - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-2 (Multi-purpose)update with RTU Units 1 TBD - - - - - - - - - - - - - - - - - - 2021 HVAC Controls RTU-5 (Police)update with RTU Units 1 TBD - - - - - - - - - - - - - - - - - - Entry heaters / controls - - 31,500 Domestic Water Heaters Fair 2 Sebesta - - - - 26,000 - - - - - - - - - - 15,000 - - Relamp & Reballast (LED-PD/City Hall) Done 2015/2021 Multi.Sebesta - - - - - - - - - - - - - - 25,000 - - - Roof Poor - Fair 1 Sebesta - - - - 180,000 - - - - - - - - - - - - - Acoustic panels/overflow AV 2017 1 Internal - - - - - - - - - - - - 15,000 - - - - - Community Service VCF Tiles 2017 1 Sebesta - - - - - - - - - - - - 15,000 - - - - - Overhead garage doors 25 years 2 Internal - - - 22,500 - - - - - - - - - - - - 30,000 - Outdoor sign Fair 1 Internal - - - - - - 56,000 - - - - - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - 140,000 - - - - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - 175,000 - - - - - - - - - - - - "Sebesta Type" evaluation of City Buildings 15,000 - 15,000 - - - - - - - - - - - - - - - TOTAL 166,550$ 267,364$ 46,500$ 97,500$ 216,000$ 175,000$ 56,000$ 94,223$ -$ 25,000$ 140,000$ 160,850$ 30,000$ 30,000$ 65,000$ 15,000$ 30,000$ 82,778$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - 12,500 - - - - - - - - - - - 20,000 - Security upgrades -Cameras 2016 4 Internal - - - - - - - 8,360 - - - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - 7,005 - - - - - - - - - - Station Paging System Fair - Good 1 Internal - - - - - - 50,000 Rooftop Units Fair - Good Multi.Sebesta - - - 31,000 - - - - - - - - - - - - - - Makeup Air Unit Fair 2 Sebesta - - - 17,500 - - - - - - - 20,000 - - - - - - Domestic Water Heaters 2016 1 Sebesta - - - - - 18,000 - - - - - - - - - 15,000 - - Relamp & Reballast Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - 35,000 - - - Roof Fair 1 Sebesta - - 98,700 - - - - - - - - - - - - - - - Exterior Paint 2020 1 Internal - - - - - - - - - - 4,500 - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - - - 67,500 - - - STATION APPARATUS FLOOR 25 years 1 Internal - - - - - - - - - 30,000 - - - - - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - 35,000 - - - - - - - - - - - - Overhead garage doors 25 years 3 Internal - - - - - - - - - 60,000 - - - - - - - - TOTAL -$ -$ 98,700$ 48,500$ 12,500$ 53,000$ 50,000$ 15,365$ -$ 90,000$ 4,500$ 20,000$ -$ -$ 102,500$ 15,000$ 20,000$ -$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACED DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2022 EST ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Public Works 2004 Building Components Metal Door Frame & Replacement Fair Internal - - 7,500 - - - - - 9,000 - - - - - - - - - Security upgrades -Cameras 2016 3 Internal - - - - - - - 6,990 - - - - - - - - 8,500 - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - 17,515 - - - - - - - - 22,000 - Rooftop Unit 2017 1 Sebesta - - - - - 35,000 - - - - - - - - - - - - Makeup Air Unit Good 3 Sebesta - - - - 19,250 - - - - - - - - - - - - - Air Handling Unit Good 1 Sebesta - - - - 8,050 - - - - - - - - - - - - - Exhaust Fans Good 6 Sebesta - - - - 13,340 - - - - - - - - - - - - - Domestic Water Heaters 2022/TBD 2 Sebesta - 13,470 - - - - - - - 15,491 - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - 210,000 - - - - - - - - - - - Overhead garage doors/Shop fixtures 25 years 7 Internal - - - - - - - - 105,000 - - - - - - - - - Exterior Paint 2020 Internal - - - - - - - - - - - - - - - - - - Tuck pointing -brick 30 years Internal - - - - - - - - - - - - - - - - 75,000 - Parking Lot mill and overlay 30 years Internal - - - - - - - - - - - - - 140,000 - - - - Rehab salt storage 25 years Internal - - - - - - - - 40,000 - - - - - - - - - TOTAL -$ 13,470$ 7,500$ -$ 40,640$ 35,000$ 210,000$ 24,505$ 154,000$ 15,491$ -$ -$ -$ 140,000$ -$ -$ 105,500$ -$ Central Park Pavilion 2003 Roof 2018 - - - - - - - - - - - - - - - - - Security upgrades -Cameras 2016/2019 - - - - - - 8,360 - - - - - - - - - 10,000 Security upgrades - Entrance controls 2016/2019 - 2,500 - - - - 7,005 - - - - - - - - - 8,000 Other Technology 2019 1 Internal - - - 1,950 - - - - - 1,950 - - - - - - - HVAC 2020 - - - - - - - - - - - - - - - - - Domestic water heaters Fair - - - - - - - - - - - 5,000 - - - - - Exterior updates 2019 - - - - - - - 12,000 - - - - - - - - - Interior updates (LED 2023)2018 - 4,997 2,000 - - - - - 8,500 - - - - - - - - - Parking Lot mill and overlay 30 years - - - - 15,000 - - - - - - - - - - - - -$ 4,500$ -$ 1,950$ 15,000$ -$ 15,365$ 20,500$ -$ 1,950$ -$ 5,000$ -$ -$ -$ -$ 18,000$ Emerald Park Pavilion 2009 - - - - - - - - - - - - - - - - - - Roof Fair - - - - 25,000 - - - - - - - - - - - - - Security upgrades -Cameras 2016 - - - - - - - 8,360 - - - - - - - - - 10,000 Security upgrades - Entrance controls 2016 - - 2,500 - - - - 7,005 - - - - - - - - - 8,000 HVAC Fair - - - 14,000 - - - - - - - - - - - - - - Domestic water heaters Fair - - - - 5,000 - - - - - - - 5,000 - - - - - Exterior updates Fair - - - - - - 10,000 - - - - - - - - 15,000 - - Interior updates (LED 2023)Fair - - 2,000 - - - 10,000 - - - - - - - - 20,000 - - Parking Lot mill and overlay 30 years - - - - - - - - - - 20,000 - - - - - - - -$ -$ 4,500$ 14,000$ 30,000$ -$ 20,000$ 15,365$ -$ -$ 20,000$ -$ 5,000$ -$ -$ 35,000$ -$ 18,000$ Park Shelters -$ -$ 9,000$ 14,000$ 31,950$ 15,000$ 20,000$ 30,730$ 20,500$ -$ 21,950$ -$ 10,000$ -$ -$ 35,000$ -$ 36,000$ TOTAL IMPROVEMENTS GOVERMENTAL 166,550$ 280,834$ 161,700$ 160,000$ 301,090$ 278,000$ 336,000$ 164,823$ 174,500$ 130,491$ 166,450$ 180,850$ 40,000$ 170,000$ 167,500$ 65,000$ 155,500$ 118,778$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT OR REPLACED DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2022 EST ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Marketplace Liquor 2005 Building Components Rooftop Unit Fair 2 Sebesta - - - 35,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - 10,800 - 2,925 - - - - - - 12,000 - - - Security upgrades - Entrance controls 2017 1 Internal - - - - - - - 5,915 - - - - - - - - 6,000 - Other Technology 2019 1 Internal - - - - 1,890 - - - - - 1,890 - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - 5,500 - - - - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta - - - -- - 15,000 - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - 15,000 - - - - - - - - Roof Fair 1 Sebesta - - - - 36,398 - - - - - - - - - - - - - TOTAL -$ -$ 40,500$ 38,288$ 10,800$ 15,000$ 8,840$ -$ 15,000$ 1,890$ -$ -$ -$ 12,000$ -$ 6,000$ -$ Silver Lake Liquor 2005 Building Components Rooftop Units Good 1 Sebesta - - - 64,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - 10,800 - 2,925 - - - - - - 12,000 - - - Security upgrades - Entrance controls 2017 Internal - - - - - - - 5,915 - - - - - - - - 6,000 - Other Technology 2019 1 Internal - - - - 1,890 - - - - - 1,890 - - - - - - - Exhaust Fans Good 1 Sebesta - - - - - - - - - - - - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - 5,500 - - - - - - - - - - - - - - Finish Walk-In Cooler Refrigeration place Good 1 Sebesta - - 4,500 - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - 15,000 - - - - - - - - Roof Fair 1 Sebesta - - - - 42,782 - - - - - - - - - - - - - TOTAL -$ -$ 4,500$ 69,500$ 44,672$ 10,800$ -$ 8,840$ -$ 15,000$ 1,890$ -$ -$ -$ 12,000$ -$ 6,000$ -$ TOTAL IMPROVEMENTS ENTERPRISE -$ -$ 4,500$ 110,000$ 82,960$ 21,600$ 15,000$ 17,680$ -$ 30,000$ 3,780$ -$ -$ -$ 24,000$ -$ 12,000$ -$ COMBINED TOTAL IMPROVEMENTS 166,550$ 280,834$ 166,200$ 270,000$ 384,050$ 299,600$ 351,000$ 182,503$ 174,500$ 160,491$ 170,230$ 180,850$ 40,000$ 170,000$ 191,500$ 65,000$ 167,500$ 118,778$ Fiscal Year 2023 SOURCES 2022 Est. Actual 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 Capital Improvement Levy 308,200$ 308,200$ 338,200$ 368,200$ 398,200$ 428,200$ 458,000$ 3,379,200$ 4,166,400$ Infrastructure Transfer 90,000 90,000 90,000 90,000 90,000 90,000 90,000 270,000 270,000 Trade/Sale of Equipment 38,223 72,545 55,000 35,000 35,000 35,000 35,000 210,000 210,000 Donations/Grants - 303,021 424,079 - - - - - 33,000 GF Excess Fund balance Transfer (1)140,000 140,000 100,000 - - - - - - Interest / Equipment note proceeds 3,500 3,500 7,500 7,500 7,500 7,500 7,500 867,487 12,000 TOTAL 579,923$ 917,266$ 1,014,779$ 500,700$ 530,700$ 560,700$ 590,500$ 4,726,687$ 4,691,400$ Uses Police 168,997$ 181,216$ 230,824$ 250,735$ 217,619$ 142,140$ 147,095$ 1,540,253$ 1,495,466$ Fire 91,940 132,916 220,269 133,666 212,886 103,477 240,679 1,026,485 1,317,580 Administration/Finance 33,116 2,862 32,500 10,525 60,618 50,000 13,367 149,035 149,667 Streets 124,419 116,198 58,545 3,296 151,565 - 5,000 118,870 465,274 Parks 78,607 62,451 126,366 7,102 16,479 101,350 28,105 279,361 387,911 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 497,079 495,643 668,505 405,323 659,166 396,966 434,247 3,114,004 3,815,898 NET CHANGE BEFORE BIG TICKET ITEMS BELOW 82,844$ 421,623$ 346,274$ 95,377$ (128,466)$ 163,734$ 156,253$ 1,612,683$ 875,502$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines* - 300,921 424,079 - - - - 863,487 - SCBA COMPLETE PACK - - 218,700 - - - - - - Dump Trucks (moved 1 DT to utility fund)- - - 230,000 - - - 251,528 331,870 2008 F750 High Ranger Aerial Truck - - - - - - 195,806 - - 1991 FIRE UTILITY TRUCK (rebuild vs replace) 105,000 105,000 - - - - - - - 1999 Parks 4500 Tractor - - - - - 57,765 - - - SIGNIFICANT ITEMS 105,000 405,921 642,779 230,000 - 57,765 195,806 1,115,015 331,870 NET CHANGE (22,156)$ 15,702$ (296,505)$ (134,623)$ (128,466)$ 105,969$ (39,553)$ 497,668$ 543,633$ BEGINNING CASH BALANCE 840,767$ 840,767$ 856,469$ 559,964$ 425,342$ 296,875$ 402,844$ 363,290$ 860,958$ ENDING CASH BALANCE 818,611$ 856,469$ 559,964$ 425,342$ 296,875$ 402,844$ 363,290$ 860,958$ 1,404,591$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE CAPITAL EQUIPMENT 2023 - 2039 (1) 2022 Transfer based on Audited 2021 General Fund results and Fund balance policy, 2023 Transfer based on estimated General Fund operating result and Fund balance policy. Fiscal Year 2023 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 Police Department Squads 49,387 49,188 52,631 165,788 57,473 118,395 56,922 599,220 711,571 Unmarked 32,630 38,207 46,000 48,760 50,223 - 51,729 228,049 260,645 Retired to Other Services 845 1,800 - 896 923 951 - 5,421 5,152 Technology - 6,949 98,893 1 86,926 - - 378,338 292,941 Specialty Equipment 8,636 5,915 17,767 20,111 8,569 15,616 31,749 117,761 126,865 Investigative Equipment 5,000 3,150 - 965 2,380 - 5,996 9,831 11,563 General Equipment 72,500 76,007 15,533 14,213 11,125 7,179 699 201,633 86,729 TOTAL PD 168,997$ 181,216$ 230,824$ 250,735$ 217,619$ 142,140$ 147,095$ 1,540,253$ 1,495,466$ Fire Department Apparatus 105,000 411,335 514,079 - 70,000 9,000 103,195 863,487 607,340 Station Based Equipment - - - 1,920 17,535 - - 64,188 76,244 Protective Gear 14,478 16,155 218,700 29,648 6,149 9,121 9,721 123,303 109,063 Technology 9,012 7,531 13,369 6,618 7,402 656 19,485 48,559 56,409 Protective Equipment/Tools 2,650 38,016 44,000 26,979 39,599 10,100 29,458 117,696 87,024 Office Furniture - - 5,000 1,000 6,500 5,700 11,871 25,776 38,044 Debt Service Payments 65,800 65,800 67,900 67,500 65,700 68,900 66,950 646,962 343,456 TOTAL FD 196,940$ 538,837$ 863,048$ 133,666$ 212,886$ 103,477$ 240,679$ 1,889,972$ 1,317,580$ Administration/Finance Computer Hardware 18,464 1,189 22,500 10,525 15,618 - 13,367 74,564 68,667 Computer Software - - - - 15,000 - - 27,500 33,000 Furniture and Equipment 5,000 1,673 5,000 - 30,000 50,000 - 10,000 40,000 Council Chambers 9,652 - 5,000 - - - - 36,971 8,000 TOTAL AF 33,116$ 2,862$ 32,500$ 10,525$ 60,618$ 50,000$ 13,367$ 149,035$ 149,667$ DEPARTMENTAL SUMMARIES 2023-2039 Fiscal Year 2023 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 DEPARTMENTAL SUMMARIES 2023-2039 PUBLIC WORKS Streets Department Fleet replacements 89,950 75,708 58,545 - 143,083 - - 72,962 258,670 Plows/Dump trucks - - - 230,000 - - - 251,528 331,870 Heavy Equipment - 7,000 - - - - 195,806 - 136,152 Speciality Equipment 34,469 33,490 - 3,296 8,482 - 5,000 45,908 70,452 TOTAL 124,419$ 116,198$ 58,545$ 233,296$ 151,565$ -$ 200,806$ 370,398$ 797,144$ Parks Department Fleet replacements 53,000 57,601 - - - 55,315 - 124,197 92,354 Heavy Equipment 5,857 - 74,000 2,750 13,183 57,765 27,126 18,947 40,707 Mowers - - 45,744 1,280 - 4,074 - 64,416 187,054 Field Maintenance 18,906 4,850 - - - 20,368 - 7,061 27,373 Rink Maintenance - - 249 640 - 13,873 - 30,316 4,869 Speciality Equipment 845 - 6,374 2,432 3,296 7,720 979 34,424 35,553 TOTAL 78,607$ 62,451$ 126,366$ 7,102$ 16,479$ 159,115$ 28,105$ 279,361$ 387,911$ TOTAL PW 203,027$ 178,649$ 184,911$ 240,398$ 168,044$ 159,115$ 228,912$ 649,759$ 1,185,055$ GRAND TOTAL 602,079$ 901,564$ 1,311,284$ 635,323$ 659,166$ 454,731$ 630,053$ 4,229,019$ 4,147,767$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.12550881 1.15927407 1.1940523 1.229873865 1.2667701 1.3047732 1.34391638 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.206458904 1.24265267 1.27993225 1.318330219 1.3578801 1.3986165 1.44057502 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.99409274 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Active Squads 1674 711 2020 DODGE DODGE DURANGO SUV - PATROL 3-4 1 37,433 - - - 55,263 - - - 62,199 - - - 70,005 - - - 78,791 - - - TBD 714 2021 DODGE DODGE DURANGO - PATROL 3-4 1 39,876 - - - 55,263 - - - 62,199 - - - 70,005 - - - 78,791 - - - TBD 712 2021 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - - - 55,263 - - 56,922 - - - 64,066 - - - 72,107 - - - 81,157 TBD 713 2021 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - - - - 57,473 - - - 64,687 - - - 72,805 - - - 81,943 - - 1629 715 2022 FORD FORD INTERCEPTOR SUV - PATROL 3-4 1 43,335 49,387 49,188 - - 59,197 - - - 66,627 - - - 74,990 - - - 84,401 - 1630 710 2018 DODGE DODGE CHARGER - PATROL 3-4 1 32,989 - - 52,631 - - 59,197 - - - 66,627 - - - 74,990 - - - 84,401 - 232,387 49,387 49,188 52,631 165,788 57,473 118,395 56,922 124,397 64,687 133,254 64,066 140,010 72,805 149,979 72,107 157,583 81,943 168,803 81,157 Unmarked 1557 6903 2022 CHEV CHEV TRAVERSE - INVESTIGATOR 6 1 24,577 32,630 38,207 - - - - 51,729 - - - - - 60,006 - - - - - 69,607 1600 6901 2017 CHEV CHEV IMPALA - CHIEF (2023 TRAVERSE) 6 1 23,000 - - 46,000 - - - - 54,367 - - - - - 61,806 - - - - - 1631 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 31,191 - - - 48,760 - - - - 55,998 - - - - - 63,661 - - - - 6904 2017 CHEV CHEV IMPALA - 2ND INVESTIGATOR 6 1 NA - - - - 50,223 - - - - 57,678 - - - - - 65,570 - - - 78,768 32,630 38,207 46,000 48,760 50,223 - 51,729 54,367 55,998 57,678 - - 60,006 61,806 63,661 65,570 - - 69,607 Retired To Other Services (1/2) 1558 702 2015 FORD FORD INTERCEPTOR SUV - CSO 7 1 700 845 900 - - - 951 - - - 1,070 - - - 1,204 - - - 1,355 - 1577 709 2018 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 700 - 900 - - 923 - - 1,008 - - - 1,135 - - - 1,277 - - - 1482 UM 2016 CHEV CHEVY IMPALA - COURT/SCHOOL 7 1 700 - - - 896 - - - - 1,039 - - - 1,169 - - - 1,316 - - 2,100 845 1,800 - 896 923 951 - 1,008 1,039 1,070 - 1,135 1,169 1,204 - 1,277 1,316 1,355 - Technology NA NA 2018 VARIOUS SQUAD COMPUTERS 5 9 4,550 - - 47,472 1 3,960 - - 55,033 - 4,729 - 63,799 - - 5,482 - 73,960 - 1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 13,000 - 6,949 - - - - - - - 19,868 - - - - - - - - - NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies varies 10,562 - 51,421 - 82,966 - - 60,144 - - - 102,950 71,815 - - - - 85,751 127,748 27,245 - 6,949 98,893 1 86,926 - - 115,177 - 19,868 4,729 102,950 135,614 - - 5,482 - 159,711 127,748 Specialty Equipment NA NA ~ 2005 VARIOUS REDMAN SUIT & TASER SUIT 15 1 ea 1,000 - - - - 1,318 1,358 - - - - - - - - - - - - NA NA VARIOUS VARIOUS BULLET RESISTANT SHIELDS 5 2 2,500 - - - - - 6,789 - - - - 7,871 - - - - 9,124 - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS) 5 10 500 603 - 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 968 997 NA NA VARIOUS VARIOUS SAFETY GEAR CIVIL UNREST/ CP SAFETY GRANT 10 6/6 1,000 - - 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 1,500 3,619 3,502 3,728 3,840 3,955 4,074 4,196 4,322 4,451 4,585 4,722 4,864 5,010 5,160 5,315 5,475 5,639 5,808 5,982 NA NA VARIOUS VARIOUS FIREARMS 15 23+ varies 2,413 2,413 2,485 2,560 2,637 2,716 2,797 2,881 2,968 3,057 3,148 3,243 3,340 3,440 3,543 3,650 3,759 3,872 3,988 NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 - - - - - - 20,700 - - - - - - - 36,675 - - - NA NA VARIOUS VARIOUS SQUAD RADAR 4 7 1,200 - - 2,982 3,072 - - 3,357 3,457 - - 3,778 3,891 - - 4,252 4,380 - - NA NA VARIOUS VARIOUS HAND HELD RADAR 10 2 3,000 2,000 - 2,000 - - - - - - - - - 3,500 - - - - - NA NA 2014 VARIOUS BIKES 10 2 5,000 - - - 10,000 - - - - 11,600 - - - - 13,456 - - - - 15,609 21,400 8,636 5,915 17,767 20,111 8,569 15,616 31,749 26,274 19,761 8,406 20,307 12,809 30,205 22,917 50,671 23,541 10,338 19,398 ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.12550881 1.15927407 1.1940523 1.229873865 1.2667701 1.3047732 1.34391638 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.80611123 1.206458904 1.24265267 1.27993225 1.318330219 1.3578801 1.3986165 1.44057502 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.99409274 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 ANNUAL INFLATION OR ESTIMATED ACTUAL Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP 5-7 7 500 - 965 - - 4,895 - - 1,528 - - 1,670 - - 1,825 - - 1,994 NA NA VARIOUS VARIOUS HIC VISION 5 1 5,600 5,000 950 - - - - 1,101 - - - - 1,275 - - - - 1,477 - - NA NA VARIOUS VARIOUS INVESTIGATOR EHANCED COMPUTER EQUIP. 3 1 3,000 - 2,200 - - 2,380 - - 2,574 - 2,784 - - 3,011 - - 3,257 - - - 9,100 5,000 3,150 - 965 2,380 - 5,996 2,574 - 1,528 2,784 1,275 1,670 3,011 - 1,825 4,734 - 1,994 Administrative Equipment 1583 NA 2016 VARIOUS COPIER 1 7 11,250 - - - 13,573 - - - - - - 17,709 - - - - - - - 22,434 NA NA VARIOUS VARIOUS OFFICE COMPUTERS -18 / PRINTERS-2 6 20 750 - 4,376 14,912 - 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+ 250 7,500 6,609 621 640 659 679 699 720 742 764 787 811 835 860 886 912 14,097 968 997 NA NA 2014 VARIOUS FRONT OFFICE FURNITURE / LOCKER ROOM 10-15 NA EST - - - - 7,500 - - - - 35,000 - - - - 7,500 - - - - NA NA VARIOUS VARIOUS FITNESS EQUIPMENT/CARPET 10-15 6-8 VAR - - - - - 6,500 - - - - 6,500 - - - - 6,500 - - - 1483 NA 2021 CENT SQ RECORDS RETENTION MGMT SYSTEM 10 1 65K 65,000 65,022 - - - - - - - - - 90,000 - - - - - - - 12,250 72,500 76,007 15,533 14,213 11,125 7,179 699 21,248 742 39,203 24,996 90,811 24,633 860 12,372 7,412 14,097 28,556 23,431 TOTAL POLICE 383,250 168,997 181,216 230,824 250,735 217,619 142,140 147,095 345,046 142,226 261,007 116,881 348,990 326,103 239,777 198,811 262,691 112,428 377,823 303,936 1,154,396 1,488,799 1,517,632 FOOTNOTES 1 EXTENDING LIFE OF ACTIVE/UNMARKED OFFICER VEHICLES FOR OTHER USES 2 2016 FORD INTERCEPTOR SUV - RESERVE TRANSERED TO FIRE FOR CODE ENFORCEMENT VEHICLE WŽůŝĐĞĞƉĂƌƚŵĞŶƚ ϮϬϭϱ͕ϮϬϭϴ͕ϮϬϮϬ͕ϮϬϮϭ͕ϮϬϮϮ &ŽƌĚΘŽĚŐĞ^hs;ϱͿ ϮϬϭϴ-ϮϬϮϭŽĚŐĞŚĂƌŐĞƌ;ϯͿ ϮϬϭϴ&ŽƌĚdĂƵƌƵƐ ϮϬϭϲ͕ϮϬϭϳŚĞǀƌŽůĞƚ/ŵƉĂůĂ;ϮͿ ϮϬϮϮŚĞǀǇdƌĂǀĞƌƐĞ FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.398616529 1.44057502 1.4837923 1.52830604 1.5741552 1.6213799 1.670021278 1.7201219 1.7717256 1.8248773 1.8796237 1.9360124 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.304773184 1.34391638 1.3842339 1.42576089 1.4685337 1.5125897 1.557967417 1.6047064 1.6528476 1.7024331 1.7535061 1.8061112 ASSET REPLACEMENT PROGRAM ANNUAL INFLATION ESITMATED OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Apparatus 1636 2018 CUSTOM FIRE ENGINE - 14 495,540 - - - - - - - - - - - - - - - - - - 1154 1999 TOYNE ENGINE - 11 425,000 - 300,921 424,079 - - - - - - - - - - - - - - - 1288 2000 HME ENGINE - 12 425,000 - - - - - - - 863,487 - - - - - - - - - - 1156 1991 ROAD RESCUE UTILITY TRUCK (rebuild vs replace)150,000 105,000 105,000 - - - - - - - - - - - - - - - - 1575 2016 FORD RESCUE - F350 74,550 - - - - - - 103,195 - - - - - - - - - 138,685 - 1487 2011 FORD CHIEF VEHICLE 150 46,897 - - - - 70,000 - - - - - - - - - 94,074 - - - NEW FORD SAFER STAFF - - - 90,000 - - - - - - - - - - 124,581 - - - - 1385 2016 FORD INSPECTIONS VEHICLE (1)5,000 - 5,414 - - - - - - - - - - - - - - - - 2006 BOAT - MOTOR REPLACEMENT 8,000 - - - - - 9,000 - - - - - - - - - - - - 105,000 411,335 514,079 - 70,000 9,000 103,195 863,487 - - - - - 124,581 94,074 - 138,685 - Station Based Equipment 1390 2006 COMPRESSOR (SCBA)40,000 - - - - - - - - - - 64,188 - - - - - - - 2007 POWER WASHER 1,500 - - - 1,920 - - - - - - - - - - - - - - 2003 TO WASHER DRYER 10,000 - - - - 17,535 - - - - - - - - - - - - - 1389 2006 STATION STANDBY GENERATOR 40,985 - - - - - - - - - - - - - - 76,244 - - - - - 1,920 17,535 - - - - - 64,188 - - - - 76,244 - - Protective Gear Various TURNOUT GEAR/ HELMENTS 2,483 - - - 29,648 - - - - - 35,402 - - 19,342 - - - - 46,191 Various ROOKIE TURN OUT GEAR 2,483 14,478 14,900 - - - - 9,721 - - - - 15,025 - - - - 17,418 - 2021 VESTS -CIVIL UNREST/2022 CP GRANT 890 - 1,255 - 18,480 - - - - - - - Dated EMS COATS / PANTS 225 - - - - - 9,121 - - - - - - - - - - - - 2001/2004 SCBA COMPLETE PACK 7,811 - - 218,700 - - - - - - - - - - - - - - - 2016/2018 SCBA BOTTLES 750 - - - - - - - - - - - 35,054 - - 37,189 - - - 2005 ICE RESCUE EQUIPMENT 1,250 - - - - 6,149 - - - - - - - - - 8,264 - - - 14,478 16,155 218,700 29,648 6,149 9,121 9,721 - - 35,402 18,480 50,079 19,342 - 45,453 - 17,418 46,191 Technology 1501 Various PAGER EQUIPMENT 600 - - 4,869 - 5,165 - 5,480 - 5,814 - 6,168 - 6,543 - 6,942 - 7,365 - 2018 NETWORK SWITCH 2,500 2,500 - - - - - 2,500 - - - - - 2,500 - - - - - 2019 WIFI ROUTER 1,600 - - - - 1,600 - - - - - 1,600 - - - - - 1,600 - 2006 VEHICLE COMPUTERS 2,000 - - - 6,000 - - - - 6,956 - - - - 8,063 - - - - Various OFFICE COMPUTERS 700 5,912 6,810 - - - - 5,480 - - - - 6,353 - - - - 7,365 - NEW TABLET CODE ENFORCEMENT 1,500 - - 1,500 - - - - 1,739 - - - - - 2,076 - - - - 2008 EOC TECHNOLOGY Various - - 4,500 - - - 5,350 - - - - - 6,388 - - - - - Various OTHER BATTERIES 500 600 721 2,500 618 637 656 675 696 716 738 760 783 806 831 855 881 908 935 9,012 7,531 13,369 6,618 7,402 656 19,485 2,434 13,486 738 8,528 7,136 16,237 10,970 7,797 881 17,237 935 Protective Equipment/Tools FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.398616529 1.44057502 1.4837923 1.52830604 1.5741552 1.6213799 1.670021278 1.7201219 1.7717256 1.8248773 1.8796237 1.9360124 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.304773184 1.34391638 1.3842339 1.42576089 1.4685337 1.5125897 1.557967417 1.6047064 1.6528476 1.7024331 1.7535061 1.8061112 ASSET REPLACEMENT PROGRAM ANNUAL INFLATION ESITMATED OR ESTIMATED ACTUAL FIXED ASSET # YEAR MAKE DESCRIPTION UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2022 CARDICA MEDICAL EQUPMENT 35,400 - 35,366 - - - - - - - - - - 48,955 - - - - - 2017 DEFIBRILLATOR 1,700 - - - 6,090 4,182 - - - - - 7,490 5,143 - - - - - 9,211 2017 DEFIBRILLATOR FOR POLICE DEPT 1,700 - - - 6,090 6,272 - - - - - 7,490 7,714 - - - - - 9,211 Various HOSE REPLACEMENT 100-425 2,650 2,650 - 2,800 - 2,800 - 3,000 - 3,000 - 3,250 - 3,250 - 3,500 - 3,750 Various HOSE APPLIANCES 150 - - - - - - - - - - 4,406 - - - - - - - 1468 Various THERMAL IMAGER 6K-12K - - - 12,000 - - - - 14,000 - - - - 16,000 - - - - 2021 NOZZLE REPLACEMENT & ACESSORIES 500 - - - - - 7,300 - - - - 7,500 - - - - 7,700 - - 2013/2021 LUCAS DEVICE 16,500 - - - - - - 24,958 - - - - - - - - 29,601 - - NEW EXTRACTION EQUIPMENT 40,000 - - 40,000 - - - - - - - - - - - - - - - Various FANS AND BLOWERS 2,400 - - - - - - - - - - - - - 3,000 - - - - Various SAWS (CHAIN AND CUT OFF)1,650 - - 4,000 - - - 4,500 - - - - 5,000 - - - - - - Various GAS MONITOR/ CARBON MNX DTC 600 - - - - 1,350 - - 750 - - - - - 1,800 - - - - 1290 Various OUTDOOR WARNING SIRENS 22,600 - - - - 27,795 - - - - - - - - - - - - - 2,650 38,016 44,000 26,979 39,599 10,100 29,458 3,750 14,000 3,000 26,885 21,107 48,955 24,050 - 40,801 - 22,172 Office Furniture 2016 OFFICE CHAIRS/FURNITURE 315 - - 5,000 - - - 6,000 - - - - 7,000 - - - - - 6,500 2015 TRAINING ROOM CHAIRS 85 - - - - - - - - - 10,000 - - - - - - - - 2014 DAY ROOM/KITCHEN/APPLIANCES 800 - - - 1,000 - - - - - - 1,250 - - - - - - - 2021 COPIER 5,600 - - - - - - - 7,526 - - - - - 8,986 - - - - 2016-2018 FITNESS EQUIPMENT 4,500 - - - - 6,500 5,700 5,871 - - - - - - - 6,800 7,000 7,200 - - - 5,000 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 131,140 473,037 795,148 66,166 147,186 34,577 173,729 877,197 27,486 49,140 119,330 85,322 84,534 168,588 154,125 124,927 180,540 75,798 FIRE ENGINE DEBT SERVICE 65,800 65,800 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 - - 196,940 538,837 863,048 133,666 212,886 103,477 240,679 979,232 132,071 156,100 228,491 196,507 197,570 283,298 270,335 237,462 180,540 75,798 500,000 FOOTNOTES (1)CODE ENFORCEMENT VEHICLE REPLACED WITH POLICE VEHICLE 2,289,532 1,889,972 Fire Department 2016 Rescue 11 1999 Engine 11 2 2000 Engine 12 1991 Utility 11 2011 Staff Vehicle 2018 Engine 14 5 6 7 8 Fire Department 2013 Inspections Vehicle 2006 Boat and Motor 2006 Compressor FIXED ASSET SCHEDULE ADMINISTRATION/FINANCE ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 / 2017 NETWORK ACCESS DEVICES (METRO I-NET ) 7 5 1,500 5,486 - - 7,325 15,618 - - 11,903 6,309 - 8,424 17,961 - - 13,688 7,255 - 9,687 UNASSIGNED 2018 WIFI ROUTERS 6 4 800 - - - 3,200 - - - - - 3,200 - - - - - 3,200 - - UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 - - 12,000 - - - - - - - 13,000 - - - - - - - NA VARIOUS COMPUTER EQUIPMENT 6 14 900 12,978 1,189 10,500 - - - 13,367 - - - - 13,768 - - - - 14,181 - 18,464 1,189 22,500 10,525 15,618 - 13,367 11,903 6,309 3,200 21,424 31,729 - - 13,688 10,455 14,181 9,687 Computer Software 1532/1639 2012 CIVIC MODULES EXPANDED / ADDED 15 1 55,000 - - - - 15,000 - - - - - 20,000 - - - - - 25,000 - UNASSIGNED 2014 LASERFICHE 15 1 7,000 - - - - - - - 7,500 - - - - - - - - - - 2022 CODE CODIFCATION / WEB-HOSTING 15 11,000 - 1,100 9,900 - - - - - - - - - - - - - - - 1641 2018 POS LIQUOR CC SYSTEM MP 15 1 9,030 - - - - - - - - - - - - - - - - - - 1642 2018 POS LIQUOR CC SYSTEM SLV 15 1 9,030 - - - - - - - - - - - - - - - - - - - - - - 15,000 - - 7,500 - - 20,000 - - - - - 25,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,673 - - - - - - - - - - - - - - - - 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS 5,000 - 5,000 - - 50,000 - - - - - - 10,000 - - - - - 5,000 1,673 5,000 - 30,000 50,000 - - - - - - 10,000 - 40,000 - - - Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS - - 5,000 - - - - 6,000 - - - - 7,000 - - - - 8,000 NA VARIOUS COUNCIL CHAMBERS COMPUTER/MONITORS 7-10 4 1,750-8,000 9,652 - - - - - - - - - 12,971 - - - - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS - - - - - - - - 11,000 - - - - - - - - - 9,652 - 5,000 - - - - 6,000 11,000 - - 12,971 7,000 - - - - 8,000 TOTAL ADMIN/FINANCE 33,116 2,862 32,500 10,525 60,618 50,000 13,367 25,403 17,309 3,200 41,424 44,700 17,000 - 53,688 10,455 39,181 17,687 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.206459 1.242653 1.279932 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155 1.62137988 1.6700213 1.720121917 1.7717256 1.8248773 1.879623662 1.9360124 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2015 1536 2014 CHEVY 5 MECHANIC - SEDAN / EV F150 PICKUP (1) 10/15 1 22,000 32,643 - - - - - - - - - - - - - - - - 1464 2010 FORD 1 F150 PICKUP -SIGN TRUCK 15 1 31,500 - - - - 56,019 - - - - - - - - - - - - - 1409 2007 FORD 2 F150 4X4 / REPLACED WITH EV F150 (2) 15 1 31,500 - - 58,545 - - - - - - - - - - - - - - 89,475 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 - - - - 87,064 - - - - - - - - - - - - - 1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 w/plow 15 1 47,500 57,307 75,708 - - - - - - - - - - - - - 115,705 - - 260,000 89,950 75,708 58,545 - 143,083 - - - - - - 72,962 - - 53,491 115,705 - 89,475 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 - - - 230,000 - - - - - - - - - - - - - - 1582 2016 WESTERN 8 FT PLOW BLADE included with truck purchase 15 1 - - - - - - - - - - - - - - - - - - 556,859 - - - 230,000 - - - 251,528 - - - - - - - 331,870 - - 1450 2010 VERMEER BRANCH CHIPPER 32,105 - - - - - - - - - - - - - - - - - - 1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - - 195,806 - - - - - - - - - - - 1670 2022 BOBCAT BOBCAT 10-15 1 43,723 - 7,000 - - - - - - - - - - - 61,152 - - - - 1669 2020 JOHN DEERE 524L 524L FRONT END LOADER 20 1 160,000 - - - - - - - - - - - - - - - - - 375,828 - 7,000 - - - - 195,806 - - - - - - 61,152 - - - - 2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - - 2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - - 6,429 - - - - - - - - - - 1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - - 6,592 - - - - - - - - - - - - - 1656 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - - - - - - - - 1671 2020 WACKER NEUSON WACKER NEUSON RD12A-90 ROLLER 15-20 1 15,000 - - - - - - - - - - - - - - - - - - 1672 2020 STEPP SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 - - - - - - - - - - - - - - - - - - 1997 WHACKER WP 1550AW VIBROPLATE 20-30 1 3,000 - - - - - - 5,000 - - - - - - - - - - - 2018 ERSKINE 1600 2418 - 61" SNOWBLOWER (3) 15-20 1 5,000 - - - - - - - - - - - - - - - - - - 2022 BOBCAT 52" & 60" ANGLE BROOMS 10-15 2 10,000 11,372 10,323 - - - - - - - - - - - 14,438 - - - - 1183 2021 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 - - - - - - - - - - - - - - - - - - 1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 18,097 - 19,250 - - - - - - - - - - - - - - - 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 - - - - - - - - **NEW 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 - 468 - 3,296 - - - - - - - - - - - - - - 1675 2020 GASBOY GAS PUMPS 15-20 2 15,270 - - - - - - - - - - - - - - 45,000 - - - 2022 WELDER 7 1 5,000 5,000 - - - - - - - 7,419 - - - - - - 9,124 - - PW SUPER OFFICE BUILD-OUT / COMPUTER 2,500 - 2,042 - - - - - - - - - - - - - - - - 2022 PRESSURE WASHER 7 1 1,657 - 1,657 - - - - - - - - - - - - - - - 273,517 34,469 14,490 19,250 3,296 8,482 - 5,000 6,429 7,419 15,283 5,432 - 11,344 14,438 45,000 9,124 1,890 - TOTAL STREETS 124,419 97,198 77,795 233,296 151,565 - 200,806 257,957 7,419 15,283 5,432 72,962 11,344 75,590 98,491 456,699 1,890 89,475 - - 251,528 - - ####### 486,897 716,976 733,488 124,419 77,795 233,296 151,565 - 200,806 6,429 7,419 15,283 5,432 72,962 11,344 75,590 98,491 456,699 1,890 89,475 FOOTNOTES (1) REPLACEMENT WILL BE PART OF UTILITY INFRASTRUCTURE FLEET (2) RETRO FIT EXISTING EV CHARGERS (3)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 2014 Chevrolet Malibu 2010 Ford F150 Pickup 2020 Ford F150 4x4 2008 Ford F450 Mini Dump 2 Ton 4x4 2022 Ford F450 Mini Dump 2 Ton 4x4 2017 Ford F350 Pickup Public Works Department—Street FLEET 2007 Ford F150 Pickup 4x4 Public Works Department—Street PLOW/DUMP TRUCKS 2003 Sterling M8500 Acterra 2013 International 7400 Dump Truck 1995 Ford L8000 Dump Truck 2018 International 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 1992 Leroy Q185 Air Compressor 2020 Wacker Neuson Roller FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM 1.2064589 1.2426527 1.279932 1.3183302 1.35788013 1.39861653 1.440575 1.48379228 1.528306 1.57415523 1.62137988 1.67002128 1.72012192 1.7717256 1.824877341 1.879623662 1.936012371 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 1379 2006 FORD 20 F350 MINI DUMP 1 TON 4X4 w/plow 15 1 42,500 53,000 57,601 - - - - - - - - - - - - - - 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 53,000 57,601 - - - 55,315 - - 60,125 - - 64,071 - - - - 92,354 - 1562 2015 BOBCAT BOBCAT 3400G UTIL VEH (ATV)10 1 10,000 - - - - 13,183 - - - - - - - - - 17,717 - - - 1188 1999 JOHN DEERE 38 4500 TRACTOR 15-25 1 35,000 - - - - - 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 - - - - - - - - - - - - - - - - 1488 2011 BOBCAT 36 TOOL CAT 5600 (V-Blade, Snblw, BF Drag) (2)10-15 1 46,507 - - 74,000 - - - - - - - - - - - - - - - 2012 MB HT HYDRAULIC TRACTOR SWEEPER 15 1 15,000 - - - - - - 20,979 - - - - - - - - - - - 1634 2020 GIANT-VAC 2501 LEAF VACCUM ATTACHMENT 10 1 6,320 - - - - - - - - - - - 10,247 - - - - - - N/A 2020 TRAC VAC 1070 LEAF MOWER ATTACHMENT 10 1 4,395 - - - - - - 6,147 - - - - 7,126 - - - - - - 2019 BIG TEX TRAILER 15 1 7,000 - - - - - - - - - - - - - 12,041 - - - - 2006 CARRY-ON TRAILER 5X8 2000 LBS 15 1 5,000 5,857 - - 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 5,857 - 74,000 2,750 13,183 57,765 27,126 - - - 1,574 17,373 - 12,041 17,717 10,949 - - TBD 2021 TORO 47 GRANDSTAND MOWER (SPRD., VAC )10-15 1 17,500 - - - - - - - - - - - - - - - 31,935 - - 1491 2011 TORO 45 GROUNDSMASTER 360 (BLW, SWP, CAB)10-15 1 37,916 - - 45,744 - - - - - - - - - - - - - - 53,030 1578 2016 TORO ZERO TURN MOWER 5000 MYRIDE 60" 15 1 25,000 - - - - - - - - - - 39,354 - - - - - - - 1673 2020 VENTRAC 4500Z KUBOTA MOWER/ SIDEWALK 15 1 55,000 - - - - - - - - - - - - - - - 100,368 - - 1606 2017 TORO 48 Z MASTER G3 MOWER 15 1 15,000 - - - - - - - - - - - 24,321 - - - - - - 2014 TORO LAWN MOWER 10 1 500 - - - 640 - - - - - - - - - 860 - - - - 2014 TORO LAWN MOWER 10 1 500 - - - 640 - - - - - - - - - 860 - - - - 2005 HONDA PUSH MOWER 10 1 500 - - - - - - - - 742 - - - - - - - - - 1975 JERRI JERRI SICLE MOWER 25+1 3,000 - - - - - 4,074 - - - - - - - - - - - - 163,416 - - 45,744 1,280 - 4,074 - - 742 - 39,354 24,321 - 1,720 - 132,304 - 53,030 1580 2016 GRACO LINELAZER FIELD PAINTER 10 1 15,000 - - - - - 20,368 - - - - - - - - - 27,373 - - 2013 RAHN BALL FIELD DRAG/SCARIFIER/GROOMER 15 1 4,000 - 4,850 - - - - - - - - 6,297 - - - - - - - 2002 RYAN SOD CUTTER (2)20 1 5,000 6,032 - - - - - - - - - - - - - - - - - 1999 JOHN DEERE 3 PT POST HOLE AUGER HAND 15 1 2,000 - - - - - - - - - - - - - - - - - - 2012 LAND PRIDE CA 1572 AIRATOR (2)10 1 2,500 3,016 - - - - - - - - - - - - - - - - - 1490 2012 LAND PRIDE OS 1548 SLIT SEEDER (2)10 1 8,171 9,857 - - - - - - - - - - - - - - - - - 39,171 18,906 4,850 - - - 20,368 - - - 764 6,297 - - - - 27,373 - - ANNUAL INFLATION OR ESTIMATED ACTUAL Fleet Field Maintenance Mowers Heavy Equipment FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM 1.2064589 1.2426527 1.279932 1.3183302 1.35788013 1.39861653 1.440575 1.48379228 1.528306 1.57415523 1.62137988 1.67002128 1.72012192 1.7717256 1.824877341 1.879623662 1.936012371 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 ANNUAL INFLATION OR ESTIMATED ACTUAL NA SHOP MADE RINK ICE SHAVER (2)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 - - - - NA MB MCD-WB WALK BEHIND BROOM 10 1 1,800 - - - - - - - - 2,671 - - - - 3,096 - - - - NA STIHL KW 85 PADDLE BROOM 5 1 200 - - 249 - - - - 288 - - - - 334 - - - - - NA JOHN DEERE ICE RINK BROOM 10 1 9,480 - - - - - 13,194 - - - - - - 15,832 - - - - - 23,266 - - 249 640 - 13,873 - 288 3,413 - 787 - 25,829 3,956 - 912 - - 2021 VARIOUS WEED WHIPS -Electric 5 4 VARIES - - - 2,037 - - - - 2,361 - - - - 2,737 2,819 2,904 NA VARIOUS CHAIN SAWS 5 5 VARIES - - - - - 679 - - - - 787 - - - - 912 940 968 2021 STIHL LEAF BLOWERS- ELECTRIC 5 5 VARIES - - - - - - 3,935 - - - - 365 376 387 2021 STIHL BACKPACK LEAF BLOWERS -ELECTRIC 5 2 300 - - - - 791 - - - - 917 - - - - 1,063 - - - NA BROYHILL WEED SPRAYER 5 1 2,500 - - 3,107 - - - - 3,601 - - - - 4,175 - - - - - NA EARTHWAY FERTILIZER SPREADER 5 1 400 - - - - 527 - - - - 611 - - - - - - - - NA VARIOUS EDGERS 5 3 VARIES - - 186 - - 679 - 216 - - 787 - 251 - - 912 940 968 2021 VARIOUS TRIMMERS - ELECTRIC 5 4 VARIES - - - - - 1,609 - - - - 1,865 - - - - 274 282 290 NA STIHL FS 86 BRUSH CUTTER 5 1 200 241 - 250 - - - 280 - - - - 324 - - - - - - NA NA WHEEL BLOWER 5 1 275 - - 342 - - - - 396 - - - - 459 - - - - - NA STIHL HT75 POLE PRUNER 14'5 1 400 - - - 512 - - - - 594 - - - - 688 - - - - NA SHOP MADE SIGN PAINTING TRAILER 10 2 1,500 - - - - 1,977 - - - - 2,292 - - - - 2,658 - - - NA NA TRAFFIC WARNING SIGNS 5 MLTP 2,000 - - - - - 2,716 - - - - 3,148 - - - - 3,650 3,759 3,872 NA NA TRAFFIC WARNING CONES 5 MLTP 500 603 - 625 - - - 699 - - - - 811 - - - - - - NA NA TRAFFIC WARNING BLINKER BARRICADE 5 MLTP 1,500 - - 1,864 - - - - 2,161 - - - - 2,505 - - - - - NA NA TRAFFIC WARNING BARRICADES 5 MLTP 1,500 - - - 1,920 - - - - 2,226 - - - - 2,580 - - - - NA NA EVENT BARRICADES 5 MLTP 1,500 - - - - - - - - - - - - - - - - - - PARK SIGNAGE 3,200 - - - - - 4,345 - - - - 5,037 - - - - 5,840 - - 18,985 845 - 6,374 2,432 3,296 7,720 979 6,375 2,819 3,821 12,884 1,135 7,390 3,268 3,721 8,851 9,116 9,390 TOTAL PARKS 78,607 62,451 126,366 7,102 16,479 159,115 28,105 6,663 67,099 4,585 60,896 106,900 33,218 20,985 21,438 180,389 101,470 62,419 FOOTNOTES 326,463 464,401 419,921 (1)NOT SCHEDULED FOR REPLACEMENT 78,607 126,366 7,102 16,479 159,115 28,105 6,663 67,099 4,585 (265,567) 106,900 33,218 20,985 21,438 180,389 (362,931) (357,501) (2)TRADE IN VALUE 22,000 INCLUDED AS REVENUE Parkland/Sidewalks/Trees Rink Maintenance - ϮϬϭϰ&ŽƌĚ&ϮϱϬ&ůĂƚďĞĚ ϮϬϭϳ&ŽƌĚ&ϮϱϬWĂƌŬhƟůŝƚǇϰǆϰ ϮϬϮϮ&ŽƌĚ&ϯϱϬ DŝŶŝƵŵƉϭdŽŶϰǆϰ ϮϬϭϭ&ŽƌĚ&ϮϱϬWŝĐŬƵƉϰǆϰ - ϮϬϭϱŽďĐĂƚϯϰϬϬ'hds ϮϬϭϴĐŚŽĞĂƌĐĂƚdŽǁĞŚŝŶĚ sĂĐƵƵŵĞďƌŝƐ>ŽĂĚĞƌ ϮϬϭϭŽďĐĂƚdŽŽůĂƚϱϲϬϬ ϮϬϭϮ,ǇĚƌĂƵůŝĐdƌĂĐƚŽƌ^ǁĞĞƉĞƌ ^ŝĚĞǁĂůŬƐĂŶĚ/ĐĞZŝŶŬƐ ϮϬϭϵŝŐdĞǆϭϴ͛dĂŶĚĞŵ WĂƌŬhƟůŝƚǇdƌĂŝůĞƌ - ϮϬϮϬdƌĂĐ-sĂĐDŽǁĞƌ ƩĂĐŚŵĞŶƚ ϭϵϵϵ:ŽŚŶĞĞƌĞϰϱϬϬdƌĂĐƚŽƌ ϮϬϮϬ'ŝĂŶƚ-sĂĐ>ĞĂĨĂŶĚ ĞďƌŝƐdƌƵĐŬ>ŽĂĚĞƌ ϭϵϳϰsĞƌŵĞĞƌdƌĞĞ^ƉĂĚĞ - ϮϬϮϭdŽƌŽ'ƌĂŶĚƐƚĂŶĚDŽǁĞƌ ϮϬϭϭdŽƌŽ'ƌŽƵŶĚƐDĂƐƚĞƌϯϲϬ ϮϬϮϬsĞŶƚƌĂĐϰϱϬϬ ^ůŽƉĞDŽǁĞƌ ϮϬϭϳdŽƌŽDĂƐƚĞƌ 'ϯϱϬϬϬDŽǁĞƌ ϮϬϭϲdŽƌŽĞƌŽdƵƌŶDŽǁĞƌ ϱϬϬϬDzZ/ϲϬ͟ - ϮϬϭϲ>ŝŶĞůĂǌĞƌ&ŝĞůĚWĂŝŶƚĞƌ Fiscal Year 2023 2022 Est. Actual 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 SOURCES Park Dedication Fees 25,000$ 3,000$ 1,500$ 1,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ Park improvement levy 5,000 5,000 10,000 15,000 20,000 25,000 30,000 270,000 300,000 Interfund Loans / Transfers - 177,000 - - - - - - - Donations 900 300 900 900 900 900 900 5,795 5,853 TOTAL 30,900$ 185,300$ 12,400$ 17,400$ 22,400$ 27,400$ 32,400$ 284,795$ 314,853$ USES Central Park -PD Fee - - 10,000 - - - - - Central Park -PI Levy 1,678 - Emerald Park -PD Fee - - - - - - - - Emerald Park -PI Levy 800 - Salo Park -PD Fee - - - - - - - - Salo Park - PI Levy - - Silver Point Park -PD Fee - - 141,300 - - - - - Silver Point Park -PI Levy 800 - Trillium Park -PD Fee - - - - - - - - Trillium Park -PI Levy 4,024 - Water Tower Park -PD Fee - - - - - - - - Water Tower Park -PI Levy - - WSB Park Evaluation study - - Interfund loan payments 4,500 4,500 4,613 4,728 14,848 17,098 19,285 119,211 57,075 TOTAL 4,500 11,802 151,300 - - - - - NET CHANGE -PD Fee 25,000$ 3,000$ (149,800)$ 1,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ NET CHANGE -PI Levy 500 173,854 5,387 10,272 5,152 7,902 10,715 150,789 242,925 BEG. CASH BAL. -PD Fee 310,499 310,499 313,499 163,699 165,199 166,699 168,199 168,199 177,199 BEG. CASH BAL. -PI Levy 1,078 1,078 174,932 180,319 190,591 195,743 203,645 203,645 354,435 END CASH BAL. -PD Fee 335,499$ 313,499$ 163,699$ 165,199$ 166,699$ 168,199$ 169,699$ 177,199$ 186,199$ END CASH BAL. -PI Levy 1,578$ 174,932$ 180,319$ 190,591$ 195,743$ 203,645$ 214,360$ 354,435$ 597,359$ PARK IMPROVEMENT 2023 - 2039 PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2022 Est Actual 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Central Park 2003 Park Amenities LEVY Signage -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ LEVY Ballfields - multi-use - 1,678 - - - - - - - - - - - - - - - - LEVY Ballfields - soccer - - - - - - - - - - - - - - - - - - LEVY Batting Cages - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - PD Play Equipment - - - - - - - - - - - - - - - - - - PD Skateboard Park - - 10,000 - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - - TOTAL -$ 1,678$ 10,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Emerald Park 2009 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Ballfields - multi-use - 800 - - - - - - - - - - - - - - - - LEVY Ballfields - soccer - - - - - - - - - - - - - - - - - - LEVY Basketball Half-Court - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - PD Play Equipment - - - - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - PD Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - - TOTAL -$ 800$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Salo Park 2006 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Amphitheater - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2022 Est Actual 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Silver Point Park 1998 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Ballfields - multi-use - 800 - - - - - - - - - - - - - - - - LEVY Basketball Full-Court - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - PD Play Equipment (assumes full ADA replacement option)- - 141,300 - - - - - - - - - - - - - - - LEVY Skating Rink - general - - - - - - - - - - - - - - - - - - LEVY Skating Rink - hockey - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - LEVY Drinking Fountains - - - - - - - - - - - - - - - - - - PD New hockey rink - - - - - - - - - - - - - - - - - - TOTAL -$ 800$ 141,300$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Trillium Park 1980 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Fountain - 4,024 - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - TOTAL -$ 4,024$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Water Tower Park 2004 Park Amenities LEVY Signage - - - - - - - - - - - - - - - - - - LEVY Basketball Half-Court REMOVED - - - - - - - - - - - - - - - - - - LEVY Off-Street Parking - - - - - - - - - - - - - - - - - - LEVY Picnic Area - - - - - - - - - - - - - - - - - - PD Play Equipment (assumes full ADA replacement option)- - - - - - - - - - - - - - - - - - LEVY Tennis Courts / Repairs Resurface 2021 resurfaced - - - - - - - - - - - - - - - - - - LEVY Walking Paths - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL PARK IMPROVEMENTS -$ 7,302$ 151,300$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS WĂƌŬ ŵĞŶŝƟĞƐ ŵƉŚŝƚŚĞĂƚĞƌ ĂůůĮĞůĚƐ-ŵƵůƟ-ƵƐĞ ĂůůĮĞůĚƐ-ƐŽĐĐĞƌ ĂƐŬĞƚďĂůůŽƵƌƚƐ ĂƫŶŐĂŐĞƐ Kī-^ƚƌĞĞƚWĂƌŬŝŶŐ WŝĐŶŝĐƌĞĂ WůĂǇƋƵŝƉŵĞŶƚ ^ŚĞůƚĞƌ ^ŬĂƚĞďŽĂƌĚWĂƌŬ ^ŬĂƟŶŐZŝŶŬ-ŐĞŶĞƌĂů ^ŬĂƟŶŐZŝŶŬ-ŚŽĐŬĞǇ dĞŶŶŝƐŽƵƌƚƐ tĂůŬŝŶŐWĂƚŚƐ ^ƉůĂƐŚWĂĚƐ —͚͛͘͘ y y ϭͬϮ y y y y y y y y y y —͚͘͘͡ y y ϭͬϮ y y y y y y y y —͚͘͘͞ y y — ͙͡͡͠ y y y y y y y y y —͙͘͡͠ y — ͚͘͘͜ y y y y y Fiscal Year 2023 SOURCES 2022 Est. Actual 2022 2023 2024 2025 2026 2027 2027-2032 2033-2038 Interfund Loan collections (1)204,767 - 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 40,000 9,500 300,000 - - - - 450,000 - Interest and other income 16,000 15,000 15,000 16,100 15,000 15,000 16,500 65,000 62,700 TOTAL 260,767$ 513,076$ 207,485$ 334,074$ 327,679$ 322,783$ 1,355,000$ 902,700$ USES Water Infrastructure 52,500 645,261 238,675 43,450 72,100 97,500 185,400 1,276,535 220,530 Water Equipment 905 - 31,206 197,200 9,669 11,949 9,292 61,665 342,825 Sewer Infrastructure - 67,071 - - 10,000 - 15,000 60,000 - Sewer Equipment 905 - 31,206 2,200 9,669 11,949 9,292 175,161 342,825 Transfer to street reconstruction 140,000 140,000 140,000 420,000 420,000 Fiber Infrastructure 115,000 8,400 90,000 - - - - 22,000 29,000 TOTAL 169,310$ 720,732$ 391,087$ 242,850$ 241,437$ 261,399$ 358,984$ 2,015,361$ 1,355,179$ NET CHANGE 91,457$ (720,732)$ 121,990$ (35,365)$ 92,637$ 66,280$ (36,201)$ (660,361)$ (452,479)$ BEGINNING CASH BALANCE 3,062,603 3,062,603 2,341,871 2,463,861 2,428,496 2,521,133 2,587,413 2,587,413 1,927,051 ENDING CASH BALANCE 3,154,060$ 2,341,871$ 2,463,861$ 2,428,496$ 2,521,133$ 2,587,413$ 2,551,212$ 1,927,051$ 1,474,572$ (1) Principal collection of $959,326 delayed to 2023. (2) Utility Fund Transfer available after retirement of Water Bonds in 2024 UTILITIES INFRASTRUCTURE 2023 - 2039 UTILITES INFRASTRUCTURE PLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM 1.12550881 1.159274074 1.194052297 1.229873865 1.266770081 1.304773184 1.343916379 1.384233871 1.425760887 1.468533713 1.512589725 1.557967417 DEPT PURPOSE DESCRIPTION EST CURRENT RPLMT COST 2014 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Plant Facilities AOP Plant Electrical Panels serviced - placeholder - - - - - - - - - 175,000 - - - - - - - - - Peroxide Equipment - placeholders - - - - - - 25,000 - - - - - - 15,000 - - - - GAC / Iron plants - - - - - - - - - - - - - - - - - - - Metal Door Frame & Replacement (and all well houses) Internal 15,000 35,900 - - - - - - - - - - - - - - 50,000 - - Security upgrades -Cameras 2 Internal - - - - - - - - - - - - 15,000 - - - - - - Security upgrades - Entrance controls / Fiber Internal - - - - - - - - - - - - - - - - - - - Reznor Heating Units 2 Sebesta - 19,661 - - - - - 24,190 - - - - - - 27,000 - - - - Dehumidifier 1 Sebesta - - 102,500 - - - - - - - - - - - - - - - - Domestic Water Heaters 1 Sebesta - - - 3,450 - - - - - - - - - 5,000 - - - - - Dehumidifier 1 Sebesta - - - - - - 77,900 - - - - - - - - - - - - Boiler 1 Sebesta - - - - 27,600 - - - - - - - - - 29,000 - - - - Relamp & Reballast Multi.Sebesta - - - - - - - - - - 7,000 - - - - - - - - Flow meters- GAC & Iron - - - - - - - - 18,492 - - - - - - 20,000 - - - Chorine booster pump -GAC - - 5,796 - - - - - - - 6,000 - - - - - - - - GAC Roof 2016 / Iron plant roof 2026/AOP roof 2041 1 Sebesta - - - - - 95,000 - - - - - - - - - - - - - Production Well No. 3 Well casing - - - - - - 80,000 - - - - - - - - - - - - Well No. 3 Pump restoration - - - - - - - - 102,730 - - - - - - - - - Well No. 4 Pump restoration - - 86,878 - - - - - - - - - 108,894 - - - - - - Well No. 5 Pump restoration - - - - - - - 100,716 - - - - - - - - - - - Retro fit Well No. 5 for mobile Generator - - - - - - - - - - 300,000 - - - - - - - - Add permanent generator Well No. 4 - - - - - - - 275,000 - - - - - - - - - - - Central Park water re-use - - - - - - - - - - - - - - - - 45,000 - - Wellhouse 3, 4, 5 maintenance, roofs in 2024 - - - 37,500 - - - - - - - - - - - - - - - Storage - Ground Storage and Tower Cleaning & Inspection (2)- - - - 12,000 - - - - 13,500 - - - 14,500 - - - - - Tower Painting /rehab (last painted in 2000) - 525,000 - - - - - - - - - - - - - - - - - Distribution System - - Watermains (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - Meter reading software upgrade / Customer portal - - - - - - - 80,000 - - - - - - - - - - Technolgy Redundant server 24,000 Chemical room SCADA 9,000 Wells 3&5 drawdown SCADA 9,200 Wells 3,4&5 Card reader and alarm 18,000 Wells 4&5 low temp alarm 2,000 Well 4 drawdown SCADA 6,000 Back wash valves automation 224K Mandates - - Wellhead Protection Plan Documentation (MDHS)- - - 30,000 - - - - 35,000 - - Plant Compenents Assessment 35,000 35,000 - - - - - - - - - - - - - - - - Water System Risk anaylsis and response plan - - - - - - - - - - - - - - - - - - Education/Public Awareness 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 1,001 1,001 Update Inventory of Potential Contamination Sources 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 1,001 1,001 Annual Well Sampling 500 500 500 500 500 500 500 500 500 501 502 503 503 503 503 503 503 503 503 52,500 645,261 238,675 43,450 72,100 97,500 185,400 402,406 203,722 226,001 315,502 2,505 126,399 22,005 73,505 22,505 97,505 2,505 2,505 Lift Stations Lift Stations - SCADA system/Fiber (1)- - - - - - - - - - - 60,000 - - - - - - Foss Road Lift Station Pump Replacement/re-hab - 58,751 - - 10,000 - - - - - - - - - - - - - - Harding Lift Station Pump Replacement/re-hab - - - - - 15,000 - - - - - - - - - - - - Collection System Collection System (Included in streets reconstruction)- 8,320 - - - - - - - - - - - - - - - - - - 67,071 - - 10,000 - 15,000 - - - - - 60,000 - - - - - - FIBER Backbone Complete Fiber Installs, Lift Stations SCADA Connections (1)100,000 8,400 90,000 - - - - - - - - - - - - - - - - Network switch City Hall 15,000 - - - - - - 22,000 - - - - - 29,000 - - - - 115,000 8,400 90,000 - - - - - 22,000 - - - - - 29,000 - - - - TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 167,500$ 720,732$ 328,675$ 43,450$ 82,100$ 97,500$ 200,400$ 402,406$ 225,722$ 226,001$ 315,502$ 2,505$ 186,399$ 22,005$ 102,505$ 22,505$ 97,505$ 2,505$ 2,505$ ASSET REPLACEMENT PRORGRAM SEWER UTILITY WATER UTILITY UTILITES INFRASTRUCTURE EQUIPMENT 6 7 8 9 10 11 12 13 14 15 16 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.3986165 1.440575 1.4837923 1.528306 1.5741552 1.6213799 1.6700213 1.7201219 1.7717256 1.8248773 1.8796237 1.9360124 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 1403 2021 SPRINTER 4 W WATER UTILITY VAN 15 1 30,000 - - - - - - - - - - - - - - - - - FORD 5 D FORD 150 EV 15 58,545 - 58,545 - - - - - - - - - - - - - 92,159 - 1561 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 1 51,750 - - - - - - - 74,550 - - - - - - - 94,437 - - - 140,295 - 58,545 - - - 1,000 74,550 - - - - - - - 94,437 - 92,159 - - 1438 1999 STERLING 19 S STERLING VACTOR/JETTER 15 1 225,000 - - - - - - - - - - - - - - - - - - - 1644 2018 FORD 15 D L8000 DUMP TRUCK 15-25 187,500 - - - - - - - - - - - - - - - - 384,110 - - 2007 ZIEGLER CAT S GENERATOR 200KW - FOSS RD LS 25-30 1 70,000 - - - - - - - - - - - 113,497 - - - - - - - 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 1 150,000 - - - 195,000 - - - - - - - - - - - - - - - 1517 2013 CASE 590 D BACKHOE 20-25 104,963 - - - - - - - - - - - - 175,290 - - - - - - 737,463 - - - 195,000 - - - - - - - 113,497 175,290 - - - 384,110 - - 1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 1 5,000 - - - - - - 6,993 - - - - - - - - - - - - 1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 1 5,000 - - - - - - 6,993 - - - - - - - - - - - - 1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 1 1,100 - - - - - 1,494 - - - - - - - - - 2,007 2,068 - - 2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 2 1,500 1,810 1,800 - - - - 2,098 - - - - 2,432 2,505 - - - - - - EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 1 1,100 - - 1,367 - - - - 1,585 - - - - - - - 2,007 - - - 1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 1 1,500 - - - - 1,977 - - - - 2,292 - - - - - 2,737 - - - 1209 2005 INGERSOL RAND D ROTO HAMMER 10 1 250 - - - - - - - - 371 - - - - - - - - - - 1417 2005 HONDA D EG1500W GENERATOR 10 1 500 - - - - - - - - 742 - - - - - - - - - - EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 1 1,000 - - - 1,280 - - - - - 1,528 - - - - - - - - - EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 1 1,000 - - - - 1,318 - - - - - 1,574 - - - - - - 1,936 - EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 1 2,000 - 2,000 - - - - - - 2,968 - - - - 3,440 - - - - - EST 2005 NA D 12V POWER VENT 5-10 1 1,500 - - - 1,920 - - - - - 2,433 - - - - - - - 2,904 - 1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 1 1,500 - - - - - 2,037 - - - - - - 2,505 - - - - - - 2018 HACH WATER TESTING EQUIPMENT 5-10 3,445 - - - - 4,542 - - - - - - 5,586 - - - - - - - EST 2005 STIHL D TS460 PARTNER SAW 5-10 1 1,000 - - - - - - - - 1,484 - - 1,001 1,001 - - - - - - 32,395 1,810 3,800 1,367 3,200 7,837 3,530 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - 6,752 2,068 4,840 - 2016 RTA D RTA FLEET SOFTWARE (SHOP) 15-20 1 6,000 - - - - 9,000 - - - - - - - - - - - - - - D NETWORK SWITCHES 7-10 10 1,000 - - - 1,200 - - - - - - 1,200 - - - - - - 1,200 1,200 D COMPUTERS/PRINTERS 7-10 10 1,000 - - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 1442 2009 SENSUS D COMPUTER SOFTWARE 20 1 15,000 - - - - - 20,368 - - - - - - - - - - 23,000 - - 2,500 1,200 11,500 20,368 2,500 - 2,500 - 3,700 - 2,500 - 2,500 - 2,500 1,200 3,700 TOTAL UTILITY 933,153 1,810 3,800 62,412 199,400 19,337 23,899 19,584 76,134 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 98,199 3,700 EQUIPMENT SPECIFIC TO WATER 180,000 0 0 0 195,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT SPECIFIC TO SEWER 295,000 0 0 0 0 0 0 0 0 0 0 0 113,497 0 0 0 0 0 0 0 DUAL PURPOSE EQUIPMENT 399,608 1,810 3,800 62,412 4,400 19,337 23,899 18,584 76,134 8,064 6,254 5,274 9,019 183,802 3,440 2,500 101,189 388,678 6,040 3,700 874,608 1,810 3,800 62,412 199,400 19,337 23,899 18,584 76,134 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 6,040 3,700 ASSET REPLACEMENT PRORGRAM Technology Reassigned from Capital Equipment Fund 3% AVERAGE ANNUAL INFLATION Fleet Reassigned from Capital Equipment Fund Heavy Equipment Reassigned from Capital Equipment Fund Specialty Equipment Reassigned from Capital Equipment Fund ϭϵϱϯtĂƚĞƌdŽǁĞƌ ϮϬϬϳ&ŽƐƐ>ŝŌ^ƚĂƟŽŶ ϮϬϬϭ,ĂƌĚŝŶŐ>ŝŌ^ƚĂƟŽŶ ϭϵϱϯ^ƚ͘ŶƚŚŽŶǇtĂƚĞƌ dƌĞĂƚŵĞŶƚ&ĂĐŝůŝƚǇ͕ϭϵϵϭ'͕ ϮϬϭϳKW ϭϵϱϳtĞůůηϯ ϭϵϱϵtĞůůηϰ ϭϵϲϭtĞůůηϱ ϮϬϮϬsĂĐƚŽƌͬ:ĞƩĞƌ ϮϬϭϱ&ŽƌĚ&ϯϱϬhƟůŝƚǇϰǆϰ ϮϬϬϰ&ƌĞŝŐŚƚůŝŶĞƌDϮtĂƚĞƌ dĂŶŬĞƌͬ&ůƵƐŚĞƌ ϮϬϮϭdƌĂŶƐŝƚhƟůŝƚǇsĂŶ ϭϵϵϵKŶĂŶϰϬϬ<'ĞŶ^Ğƚ ϭϵϵϮKŶĂŶϯϳϱ<'ĞŶ^Ğƚ ϮϬϭϯĂƐĞϱϵϬ>ŽĂĚĞƌͬĂĐŬŚŽĞ Fiscal Year 2023 SOURCES 2022 EST. ACTUAL 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 Stormwater fees UB 219,812$ 219,104$ 230,059$ 241,562$ 253,640$ 258,713$ 263,887$ 1,537,060$ 1,552,431$ Grants-Industrial Park Flooding (1)- - - - - - 250,000 - Miscellaneous / Interest 1,900 2,900 2,400 2,700 4,000 4,000 4,000 55,000 72,000 TOTAL 221,712$ 222,004$ 232,459$ 244,262$ 257,640$ 262,713$ 267,887$ 1,842,060$ 1,624,431$ USES Stormwater Maintenance 302,000$ 213,903$ 220,000$ -$ -$ -$ 95,000$ 325,000$ 515,000$ Flood Improvements (1)- - - - - - - 850,000 - Water Quality 59,985 36,163 58,525 39,535 30,577 166,653 32,765 317,068 682,626 Mandates 13,850 6,000 9,000 9,425 9,866 10,325 10,801 85,929 128,727 Annual Reconstruction - - - - - - - - - TOTAL 375,835 256,066 287,525 48,960 40,444 176,978 138,565 1,577,997 1,326,353 NET CHANGE (154,123)$ (34,062)$ (55,066)$ 195,302$ 217,197$ 85,735$ 129,322$ 264,063$ 298,077$ BEGINNING CASH BALANCE 263,875 263,875 229,813 174,747 370,049 587,246 672,981 802,303 1,066,366 ENDING CASH BALANCE 109,752$ 229,813$ 174,747$ 370,049$ 587,246$ 672,981$ 802,303$ 1,066,366$ 1,364,444$ (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 2023 - 2039 STORMWATER CAPITAL PLAN Improvement Type Location Potential Financial Sources 2022 Est.Actual 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Stormwater Pond Maintenance Ramsey County Foss Rd Ditch maintenance SAV, Ramsey - 62,736 - - - - - - - - - - - - - 125,000 - - 33rd and Stinson (In 2021 Street Imp) SAV 30,000 59,752 - - - - - - - - - - - - - - - - Alley storm water repair (In 2022 Street Imp) SAV - 39,415 - - - - - - - - - - - - - - - - Mirror Lake SAV - - - - - - - - - - - 250,000 - - - - - - Silver Lake Ramsey, CH, SAV - - - - - - - - - - - - - - - - - - Harding Pond SAV 272,000 52,000 220,000 - - - - - - - - - - - 200,000 - Salo Pond SAV - - - - - - 95,000 - - - - - 105,000 - - - - Central Park Rain Garden SAV - - - - - - - 75,000 - - - - - 85,000 - - - 302,000 213,903 220,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 24,960 17,500 20,250 21,060 21,902 22,778 23,690 24,637 25,623 26,648 27,714 28,822 29,975 31,174 32,421 33,718 35,066 36,469 Regional Stormwater Treatment system MWMO 1,675 1,675 1,775 1,875 1,975 2,075 2,175 2,275 2,375 2,475 2,575 2,675 2,775 2,875 2,975 3,075 3,175 3,275 Clean Streets maintenance costs SAV 8,350 4,828 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 Silver Lake Delisting / Weed mgmt CO-OP - - 10,000 - - - - 10,000 - - - - 10,000 - - - - Water Re-use Maintenance SAV 25,000 12,160 30,000 - - 135,000 - - 40,000 - - 45,000 - - 50,000 - - - 59,985 36,163 58,525 39,535 30,577 166,653 32,765 33,912 85,098 36,323 37,589 83,897 40,250 51,649 93,096 394,593 46,141 47,744 Mandates SWIPP Stormwater Management Plan update SAV - - - - - - 10,000 - - - - - - - - - 15,000 MS4 MS4-Engineer costs SAV 9,500 4,500 6,500 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 Internal SW Education / Green Step Program SAV 4,350 1,500 2,500 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 13,850 6,000 9,000 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 Annual Reconstruction (1) Internal use for debt levy reduction - - - - - - - - - - - - - - Contribution to streets reconstruction 2024-2037 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL STORMWATER CAPITAL PLAN 375,835 256,066 287,525 48,960 40,444 176,978 138,565 130,208 96,908 898,669 50,492 347,381 54,339 171,367 193,470 535,650 262,913 80,259 (1) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan ϮϬϬϰ-ϮϬϬϱ^ĂůŽWŽŶĚ EŽƌƚŚ ϮϬϬϰ-ϮϬϬϱ^ĂůŽWŽŶĚ ^ŽƵƚŚ ϮϬϬϯ,ĂƌĚŝŶŐWŽŶĚ ϭϵϲϮDŝƌƌŽƌ>ĂŬĞ ϮϬϭϱ^ŝůǀĞƌ>ĂŬĞ^ƚŽƌŵǁĂƚĞƌ dƌĞĂƚŵĞŶƚ&ĂĐŝůŝƚǇĂƚ^ĂůŽWŽŶĚ ϮϬϭϲ^ƚ͘ŶƚŚŽŶǇZĞŐŝŽŶĂů ^ƚŽƌŵǁĂƚĞƌdƌĞĂƚŵĞŶƚ^ǇƐƚĞŵ ϮϬϭϰĞŶƚƌĂůWĂƌŬZĂŝŶ'ĂƌĚĞŶ ϮϬϬϴtĂƚĞƌZĞƵƐĞ&ŽƵŶƚĂŝŶ ϮϬϮϭůŐŝŶWĞůŝĐĂŶ ^ƚƌĞĞƚ^ǁĞĞƉĞƌ Silver Lake 36THAVE N E 31STAVE N E 33RD AVE N E 33RD AVE N E 33RD AV E N E 34TH AVE N E STINSON PKWY N ESILVER LNL O W R YAVE N E CO RDNO 88SILVER LAKE RD1 6 T HAVE S W SILVER LAKE RD3 9 T H A V E N E 39TH AVE NE HIGHCREST RDP IN E KENZIE TER ASHCEDAR DIAMONDEIGHTTERSILVERLAKE CTSILVE R LN ROZELLE DRCHANDLER DRSKYCROFTDR COOLIDGE ST N EIRONW OOD32ND AV E N E 32ND AVE N E LO W RYAVEN E ELM FOSS RD ROOSEVELTST N ESILVER LA KETER PAHL AVE PI NECRESTVIEW DRROOSEVELT ST N EJ U N IP E R FORDHAMCT NEMAPLEWOODDROLD HWY 8 WILSON ST N ESTINSON BLVD NEELM FOSS RDFOSS RDG U M PENROD LACHELMSFORD RDHIGHCREST RDHIGHCREST RDLOW RYAVEN E 34THAVE N 35TH AVE N E A N T H O N Y L A SROOSEVELTCT N ESILVER LAKE RDSILVER LAKE RDSILVER LAKE RDRANKIN RDRANKIN RDWILSONST N EANTHONY LA SS IL V E R L N SILVER LNLOCUST 39T HAVE NE M A P L E W O O D D R O A K EASTGATE RD DOWNERS DRAPACHELANE ES T A N T H O N Y R D MACALASTERDRMACALASTER DRKENZIE TERKENZIE TERKENZIE TERARMOUR TER27TH AVE N E PENTAGON DR 30TH AVE N E ST A NTH ONY BLVD S T A N T H O N Y B L V D ARMO UR TER W STINSON BLVD N ESTINSONBLVD N ESTINSON BLVD N E38TH AVE NE PAHL AVE FRONTAGE RDHARDING ST N EROOSEVELT ST N E29TH AVE N E 29THAVE N E 29TH AVE N E 37TH AVE NE 37TH AVE NE 37TH AVE NE CROFT DREDWARD ST N EEDWARD ST N ECOOLIDGE ST N ESKYCROFT DRHARDING ST N ECROFT DRB E L L L A MURRAY AVE SKYCROFTCIRB E L D E N D R BELDEN DRFORDHAM DRANTHONY LA31ST AVE N E 31ST AVE N E 31ST AVE N EROOSEVELT ST N E36TH AVE N E 36TH AVE N E 36TH AVE N E HCRRA CORRIDORH C R R A C O R R ID O RCROFT DROLD HWY 8OLD HWY 8HIGHWAY NO 88HIGHWAYNO 88HIGHWAY NO 88HILLDALE AVE N E PENROD LNSHAMROCK DRTOWNVIEW AVE 37TH AVE N E 37TH AVE N E EDGEMERE AVE WE NDHURST AVE SKYCROFT DR SKYCROFT DR1 inch = 750 f eet Document Path: K:\013266-000\GIS\Maps\CIP_ProjectMapUpdated2023.mxd Date Saved: 10/4/2022 5:00:31 PMStreet & Utility CIP for 2023 and BeyondSt. Anthony, MN City Boundary Stree t & UtilityReconstruction Program 2024 2025 2027 2028 2030 2031 2033 2034 2036 2037 Mill & Ov er la y Program 2024 2025 2027 2028 2030 2031 2033 2034 2036 2037 Project Location Map 0 750Feet¯ STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2022 Est. Actual 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 Annual Street / Utility Program SEE EXHIBT A FOR DETAIL OF TYPE OF IMPROVEMENTS BY YEAR, 2021 Debt Levy/Assmts/Grants & Aids 2,165,000 433,000 - - - - - - - - - - - - - - - - - SEE EXHBIT B FOR STREET MAP FOR YEAR OF STREET IMPROVEMENT 2022 Debt Levy/Assmts/Grants & Aids 2,458,534 1,966,827 1,966,827 393,365 - - - - - - - - - - - - - - - 2023 Debt Levy/Assmts/Grants & Aids Off year - - - - - - - - - - - - - - - - - - 2024 Debt Levy/Assmts/Grants & Aids 2,864,749 - - - 2,291,799 572,950 - - - - - - - - - - - - - 2025 Debt Levy/Assmts/Grants & Aids 2,556,744 - - - - 2,045,395 511,349 - - - - - - - - - - - - 2026 Debt Levy/Assmts/Grants & Aids Off year - - - - - - - - - - - - - - - - - - 2027 Debt Levy/Assmts/Grants & Aids 2,570,781 - - - - - - 2,056,625 514,156 - - - - - - - - - 2028 Debt Levy/Assmts/Grants & Aids 3,408,635 - - - - - - - 2,726,908 681,727 - - - - - - - - - 2029 Debt Levy/Assmts/Grants & Aids Off year - - - - - - - - - - - - - - - - - - 2030 Debt Levy/Assmts/Grants & Aids 2,953,029 - - - - - - - - - 2,362,423 590,606 - - - - - - - 2031 Debt Levy/Assmts/Grants & Aids 5,269,846 - - - - - - - - - - 4,215,877 1,053,969 - - - - - - 2032 Debt Levy/Assmts/Grants & Aids Off year - - - - - - - - - - - - - - - - - - 2033 Debt Levy/Assmts/Grants & Aids 4,010,800 - - - - - - - - - - - - 3,208,640 802,160 - - - - 2034 Debt Levy/Assmts/Grants & Aids 3,808,997 - - - - - - - - - - - - - 3,047,198 761,799 - - - 2035 Debt Levy/Assmts/Grants & Aids Off year - - - - - - - - - - - - - - - - - - 2036 Debt Levy/Assmts/Grants & Aids 2,987,911 - - - - - - - - - - - - - - - 2,390,329 597,582 - 2037 Debt Levy/Assmts/Grants & Aids 3,224,918 - - - - - - - - - - - - - - - - 2,579,935 644,984 TOTAL 22,772,643 2,399,827 1,966,827 393,365 2,291,799 2,618,345 511,349 2,056,625 3,241,064 681,727 2,362,423 4,806,483 1,053,969 3,208,640 3,849,358 761,799 2,390,329 3,177,517 644,984 Sidewalks / Intersections / Signals / Lighting Sidewalk / Lighting Stinson South of 37th Debt Levy 299,785 - - - - - - - - - - - - 426,054 247,749 - - - - Sidewalk / Lighting Stinson Boulevard South of 33rd Debt Levy 374,731 - - - - - - - - - - - - - - - 328,547 338,403 Street lighting 37th Avenue NE (County Road D) Debt Levy 327,890 - - - - - - - - - - 297,578 204,337 - - - - - - Street lighting 33rd Avenue NE (County Road C2) Debt Levy 368,876 - - - - - - - - - - - - - - 627,987 - - - TOTAL SIDEWALKS/LIGHTING ETC.1,371,282 - - - - - - - - - 297,578 204,337 426,054 247,749 627,987 328,547 338,403 - TOTAL STREETS IMPROVEMENT PLAN 24,143,925 2,399,827 1,966,827 393,365 2,291,799 2,618,345 511,349 2,056,625 3,241,064 681,727 2,362,423 5,104,060 1,258,306 3,634,694 4,097,107 1,389,786 2,718,876 3,515,920 644,984 STREET PROGRAM DETAILED COSTS EXHIBIT A BASE BASE Inflation PROJECTED PROJECTED Year Road From To Street Length Improvement COST PER FT Cost Factor COST PER FT Cost Est Assessments net city cost PP SA Bond size Bond A/R SA 15,000 2022 Rankin Road 31st Avenue 33rd Avenue 1370 Reconstruct 1,448.88 1,984,966 1.00 1,448.88 1,984,966 239,241 1,745,725 84,438 1,900,528 492,653 Total assessed 2022 East Gate Road Crestview Drive Rankin Road 360 Mill / Overlay 82.10 29,556 1.00 82.10 29,556 8,176 21,380 3,271 26,285 188,990 PP Sa 2022 Crest View Drive 29th Avenue 31st Avenue 1490 Mill / Overlay 82.10 122,329 1.00 82.10 122,329 47,423 74,906 18,969 103,360 303,663 Assmts financed by bond 2022 Bell Lane Armour Terrace Crestview Drive 660 Mill / Overlay 82.10 54,186 1.00 82.10 54,186 21,259 32,927 8,503 45,683 2022 2022 Armour Terrace Silver Lake Road Crestview Drive 1580 Mill / Overlay 82.10 129,718 1.00 82.10 129,718 49,058 80,660 19,623 110,095 2,390,000 Bond w/ issuance costs 2022 Alley (south of 29th)29th Avenue Alley (west of Roosevelt)350 A, Mill / Overlay 143.52 50,232 1.00 143.52 50,232 52,023 (1,791) 22,110 28,122 $2,269,544 2022 Alley (west of Roosevelt)Roosevelt Street West Terminus 310 A, Mill / Overlay 143.52 44,491 1.00 143.52 44,491 55,489 (10,997) 23,583 20,909 2022 Alley (south of 29th)29th Avenue Murray Avenue 300 A, Mill / Overlay 143.52 43,056 1.00 143.52 43,056 19,984 23,072 8,493 34,563 2,458,534 2,458,534 20.04% 2023 OFF YEAR 2024 Townview Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,448.88 1,854,566 1.06 1,535.81 1,965,840 441,329 1,524,511 132,399 1,833,442 1,012,406 Total assessed 2024 Alley (south of Pahl)Roosevelt Street Wilson Street 760 A, Mill / Overlay 147.82 112,341 1.06 156.69 119,081 107,173 11,908 32,152 86,929 303,722 PP Sa 2024 Alley (north of Pahl) Roosevelt Street Wilson Street 770 A, Mill / Overlay 147.82 113,819 1.06 156.69 120,648 108,583 12,065 32,575 88,073 708,684 Assmts financed by bond 2024 Alley (south of Pahl) Wilson Street 27th Avenue 480 A, Mill / Overlay 147.82 70,952 1.06 156.69 75,209 67,688 7,521 20,307 54,903 2024 Alley (north of Pahl)Wilson Street 27th Avenue 650 A, Mill / Overlay 147.82 96,081 1.06 156.69 101,846 91,661 10,185 27,498 74,348 2,637,900 Bond w/ issuance costs 2024 2024 Roosevelt Street 35th Street County Road D 1560 Mill / Overlay 82.10 128,076 1.06 87.03 135,761 73,260 62,500 21,978 113,783 $2,561,027 2024 35th Street Stinson Boulevard Belden Drive 1290 Mill / Overlay 82.10 105,909 1.06 87.03 112,264 25,641 86,623 7,692 104,571 2024 Roosevelt Street 34th Avenue 35th Avenue 630 Mill / Overlay 82.10 51,723 1.06 87.03 54,826 25,641 29,185 7,692 47,134 2024 Edward Street 34th Avenue 35th Avenue 630 Mill / Overlay 82.10 51,723 1.06 87.03 54,826 21,978 32,848 6,593 48,233 2024 Harding Street 34th Avenue 36th Avenue 1430 Mill / Overlay 82.10 117,403 1.06 87.03 124,447 49,451 74,997 14,835 109,612 2,864,749 35.34% 2025 31st Avenue Silver Lake Road Rankin Road 1280 Reconstruct 1,535.81 1,965,840 1.04 1,597.25 2,044,474 527,704 1,516,770 158,311 1,886,163 718,260 Total assessed 2025 30th Avenue Wilson Street Silver Lake Road 1270 Mill / Overlay 87.03 110,523 1.04 90.51 114,944 59,677 55,267 17,903 97,041 215,478 PP Sa 2025 W Armour Terrace Roosevelt Street Silver Lake Road 1840 Mill / Overlay 87.03 160,128 1.04 90.51 166,533 83,407 83,126 25,022 141,511 502,782 Assmts financed by bond 2025 Wilson Street 29th Avenue 30th Avenue 630 Mill / Overlay 87.03 54,826 1.04 90.51 57,019 7,912 49,107 2,374 54,646 2025 2025 Wilson Street 27th Avenue 29th Avenue 1310 Mill / Overlay 87.03 114,004 1.04 90.51 118,564 13,846 104,718 4,154 114,410 2,412,260 Bond w/ issuance costs 2025 Pahl Avenue Wilson Street Coolidge Street 610 Mill / Overlay 87.03 53,086 1.04 90.51 55,209 25,714 29,495 7,714 47,495 $2,341,266 28.09% 2026 OFF YEAR 2027 Rankin Road CR 88 31st Avenue 1310 Reconstruct 1,597.25 2,092,391 1.04 1,661.14 2,176,087 393,224 1,782,863 117,967 2,058,120 566,202 Total assessed 2027 29th Avenue Silver Lake Road Rankin Road 1290 Mill / Overlay 130.33 168,126 1.04 135.54 174,851 45,692 129,159 13,708 161,143 169,861 PP Sa 2027 Hilldale Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 90.51 114,944 1.04 94.13 119,542 57,659 61,882 17,298 102,244 396,342 Assmts financed by bond 2027 2027 32nd Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 90.51 114,944 1.04 94.13 119,542 69,626 49,915 20,888 98,654 2,493,630 Bond w/ issuance costs 21.86%$2,420,161 2028 Macalaster Drive 39th Avenue Silver Lane 1260 Reconstruct 1,661.14 2,093,030 1.04 1,760.96 2,218,813 393,224 1,825,589 117,967 2,100,846 811,740 Total assessed 2028 Macalaster Drive South terminus 39th Avenue 500 Reconstruct 1,661.14 830,568 1.04 1,760.96 880,481 268,376 612,106 80,513 799,969 243,522 PP Sa 2028 Wilson Street 30th Avenue 31st Avenue 630 Mill / Overlay 94.13 59,300 1.04 97.89 61,672 24,335 37,338 7,300 68,973 568,218 Assmts financed by bond 2028 Harding Street 30th Avenue 31st Avenue 630 Mill / Overlay 94.13 59,300 1.04 97.89 61,672 32,289 29,383 9,687 71,359 2028 2028 Edward Street 33rd Avenue 34th Avenue 620 Mill / Overlay 94.13 58,359 1.04 97.89 60,693 27,676 33,017 8,303 68,996 3,353,680 Bond w/ issuance costs 2028 Belden Drive 33rd Avenue 34th Avenue 1280 Mill / Overlay 94.13 120,483 1.04 97.89 125,302 65,839 59,463 19,752 145,054 $3,255,197 23.81% 2029 OFF YEAR 2030 Penrod Lane 39th Avenue Silver Lane 1260 Reconstruct 1,760.96 2,218,813 1.04 1,831.40 2,307,566 646,579 1,660,987 193,974 2,113,592 937,155 Total assessed 2030 34th Avenue Stinson Boulevard Silver Lake Road 2200 Mill / Overlay 97.89 215,363 1.04 101.81 223,978 70,320 153,657 21,096 245,074 281,146 PP Sa 2030 Hilldale Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 97.89 107,682 1.04 101.81 111,989 60,615 51,373 18,185 130,174 656,008 Assmts financed by bond 2030 32nd Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 97.89 107,682 1.04 101.81 111,989 67,853 44,136 20,356 132,345 2030 2030 Townview Avenue Wilson Street Silver Lake Road 1290 Mill / Overlay 97.89 126,281 1.04 101.81 131,332 74,022 57,311 22,206 153,539 2,932,410 Bond w/ issuance costs 2030 Belden Drive 32nd Avenue 33rd Avenue 650 Mill / Overlay 97.89 63,630 1.04 101.81 66,175 17,765 48,410 5,330 71,505 $2,846,228.35 31.74% 2031 Shamrock Drive 39th Avenue Silver Lane 1260 Reconstruct 1,831.40 2,307,566 1.04 1,904.66 2,399,868 486,941 1,912,928 146,082 2,253,786 1,354,359 Total assessed 2031 Fordham Drive 39th Avenue Silver Lane 1260 Reconstruct 1,831.40 2,307,566 1.04 1,904.66 2,399,868 699,340 1,700,529 209,802 2,190,067 406,308 PP Sa 2031 30th Avenue Stinson Boulevard Wilson Street 960 Mill / Overlay 101.81 97,736 1.04 105.88 101,645 46,189 55,456 13,857 87,788 948,051 Assmts financed by bond 2031 Roosevelt Street St. Anthony Boulevard 30th Avenue 1210 Mill / Overlay 101.81 123,188 1.04 105.88 128,115 35,925 92,190 10,778 117,338 2031 2031 Murray Avenue Roosevelt Street Wilson Street 830 Mill / Overlay 101.81 84,501 1.04 105.88 87,881 20,956 66,924 6,287 81,594 5,009,920 Bond w/ issuance costs 2031 Murray Avenue Wilson Street Coolidge Street 710 Mill / Overlay 101.81 72,284 1.04 105.88 75,175 34,214 40,961 10,264 64,911 $4,863,538 2031 Coolidge Street St. Anthony Boulevard 29th Avenue 730 Mill / Overlay 101.81 74,320 1.04 105.88 77,293 30,793 46,500 9,238 68,055 25.70% STREET PROGRAM DETAILED COSTS EXHIBIT A 2032 OFF YEAR 2033 Skycroft Circle Skycroft Drive Skycroft Drive 1550 Reconstruct 1,904.66 2,952,219 1.04 1,980.84 3,070,308 885,509 2,184,799 265,653 2,804,655 1,139,173 Total assessed 2033 34th Avenue Skycroft Drive Croft Drive 300 Reconstruct 1,904.66 571,397 1.04 1,980.84 629,965 56,256 573,710 16,877 613,089 341,752 PP Sa 2033 Pahl Avenue Roosevelt Street Wilson Street 720 Mill / Overlay 105.88 76,234 1.04 110.12 79,283 60,970 18,313 18,291 60,992 797,422 Assmts financed by bond 2033 Roosevelt Street 27th Avenue Pahl Avenue 550 Mill / Overlay 105.88 58,234 1.04 110.12 60,564 6,877 53,687 2,063 58,500 2033 2033 27th Avenue Stinson Boulevard Pahl Avenue 1550 Mill / Overlay 105.88 164,115 1.04 110.12 170,679 129,561 41,118 38,868 131,811 3,780,100 Bond w/ issuance costs 28.40%$3,669,047.61 2034 Skycroft Drive Maplewood Drive 33rd Avenue 1560 Reconstruct 1,980.84 3,090,116 1.04 2,060.08 3,213,721 804,459 2,409,262 241,338 2,972,383 1,073,466 Total assessed 2034 39th Avenue Stinson Blvd Silver Lake Road 2200 Mill / Overlay 158.57 348,846 1.04 164.91 362,800 147,954 214,846 44,386 318,414 322,040 PP Sa 2034 Roosevelt Street 33rd Avenue north terminus 340 Mill / Overlay 110.12 37,439 1.04 114.52 38,937 25,940 12,997 7,782 31,155 751,426 Assmts financed by bond 2034 Roosevelt Street 31st Street 33rd Avenue 1290 Mill / Overlay 110.12 142,049 1.04 114.52 147,731 74,938 72,793 22,481 125,250 2034 2034 Anthony Road Roosevelt Street Edward Street 400 Mill / Overlay 110.12 44,046 1.04 114.52 45,808 20,176 25,633 6,053 39,755 3,591,610 Bond w/ issuance costs 28.18%$3,486,957.64 2035 OFF YEAR 2036 Downers Drive Skycroft Drive Highcrest Road 1140 Reconstruct 2,060.08 2,348,488 1.04 2,142.48 2,442,428 726,646 1,715,782 217,994 2,224,434 1,057,345 Total assessed 2036 31st Avenue Wilson Street Silver Lake Road 1260 Mill / Overlay 114.52 144,296 1.04 119.10 150,067 126,380 23,688 37,914 112,153 317,203 PP Sa 2036 31st Street Stinson Boulevard Wilson Street 990 Mill / Overlay 114.52 113,375 1.04 119.10 117,910 23,466 94,444 7,040 110,870 740,141 Assmts financed by bond 2036 Edward Street 31st Street 33rd Avenue 1390 Mill / Overlay 114.52 159,183 1.04 119.10 165,551 111,127 54,424 33,338 132,212 2036 2036 Wilson Street 31st Street 32nd Street 630 Mill / Overlay 114.52 72,148 1.04 119.10 75,034 56,653 18,381 16,996 58,038 2,751,130 Bond w/ issuance costs 2036 32nd Street Edward Street Belden Drive 310 Mill / Overlay 114.52 35,501 1.04 119.10 36,921 13,074 23,848 3,922 32,999 $2,670,707.60 35.39% 2037 Croft Drive 33rd Avenue Downers Drive 1270 Reconstruct 2,142.48 2,720,950 1.04 2,228.18 2,829,788 854,282 1,975,506 256,285 2,573,504 944,644 Total assessed 2037 2037 Chandler Drive/Foss Road 37th Avenue Highcrest Road 3190 Mill / Overlay 119.10 571,544 1.04 123.87 395,130 90,361 304,768 27,108 368,021 283,393 PP Sa 661,251 Assmts financed by bond 29.29%3,030,260 Bond w/ issuance costs $2,941,525.11 TBD Anthony Lane N County Road C North terminus 800 Reconstruct 2,228.18 1,782,544 1.03 2,295.03 1,836,020 642,607 1,193,413 192,782 1,643,238 $1,692,535.27 449,825 TBD TBD Anthony Lane S County Road C south 2930 Reconstruct 2,295.03 6,724,424 1.03 2,363.88 6,926,157 2,424,155 4,502,002 727,246 6,198,910 $6,307,391.36 1,696,908 TBD 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 2023 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 $2,665,640 - 2024A 2024A 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 146,861 146,861 146,861 146,861 146,861 $2,412,260 - 2025A 2025A 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 149,271 149,271 149,271 149,271 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 $2,493,630 - 2027A 2027A 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 178,444 178,444 178,444 980K REDUCTION IN BORROWING (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (69,593) (69,593) (69,593) $3,353,680- 2028A 2028A 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 249,697 249,697 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 $2,932,410 - 2030A 2030A 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043 $5,009,920 - 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 (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) 2032 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,780,100 - 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) $3,591,600 - 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 $2,751,130- 2036A 2036A 256,344 256,344 256,344 256,344 2.25M REDUCTION IN BORROWING (210,202) (210,202) (210,202) (210,202) $3,030,60 - 2037A 2037A 243,179 243,179 243,179 2038 - OFF YEAR $0.00 $0.00 Additional levy - - - - - - - - - - - - - 191,915 385,630 385,630 514,920 799,864 799,864 1,044,907 1,271,335 1,271,335 1,493,529 1,606,712 1,606,712 1,608,410 1,831,150 1,795,904 1,649,042 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,173,113 2,254,979 2,131,408 2,128,937 2,294,339 2,142,418 2,210,123 2,268,113 2,042,347 2,086,807 2,092,532 1,851,401 1,772,421 1,831,150 1,795,904 1,649,042 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) (4,896) (3,521) (7,510) (1,010) (5,301) (4,355) (3,583) (2,964) (2,492) (2,019) (1,752) (6,618) (6,097) (5,638) - - - Excess Bond Balance (115,000) (101,921) (92,500) (140,000) (140,009) (215,310) (354,300) (340,615) (351,824) - - - - - - - - - - - - - - - - - Conduit Fee/Refunding & Project savings (15,079) (116,180) (79,792) - - - - - - - - - - - - - - - - - - Water / Sewer bonds retired - - (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (75,000) (70,000) (150,000) (160,000) (65,000) - - - - - - - - - - - - - - - - Infrastructure Levy - - - - - - Road improvement levy 1,500,755 1,577,184 1,776,580 1,791,725 1,828,847 1,792,206 1,778,431 1,854,886 1,852,204 1,843,699 1,835,860 1,829,109 2,103,319 2,029,592 2,107,469 1,990,398 1,983,636 2,149,984 1,998,835 2,067,159 2,125,621 1,900,328 1,945,055 1,945,914 1,705,304 1,626,783 1,691,150 1,655,904 1,509,042 % 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% 14.99% -3.51% 3.84% -5.56% -0.34% 8.39% -7.03% 3.42% 2.83% -10.60% 2.35% 0.04% -12.36% -4.60% 3.96% -2.08% -8.87% $ 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) 274,211 (73,728) 77,877 (117,071) (6,762) 166,348 (151,149) 68,324 58,462 (225,293) 44,727 859 (240,610) (78,521) 64,367 (35,246) (146,861) 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 2,854,932 Total debt levied after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,480,886 2,487,181 2,487,181 2,487,181 2,487,181 2,336,734 2,125,982 2,107,469 1,990,398 1,983,636 2,149,984 1,998,835 2,067,159 2,125,621 1,900,328 1,945,055 1,945,914 1,705,304 1,626,783 1,691,150 1,655,904 1,509,042 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,269,503 2,254,979 2,131,408 2,128,937 2,294,339 2,142,418 2,210,123 2,268,113 2,042,347 2,086,807 2,092,532 1,851,401 1,772,421 1,831,150 1,795,904 1,649,042 % 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% -6.05% -9.02% -0.87% -5.56% -0.34% 8.39% -7.03% 3.42% 2.83% -10.60% 2.35% 0.04% -12.36% -4.60% 3.96% -2.08% -8.87% % 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% -5.70% -0.64% -5.48% -0.12% 7.77% -6.62% 3.16% 2.62% -9.95% 2.18% 0.27% -11.52% -4.27% 3.31% -1.92% -8.18% $ Change in Debt Levied 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 6,295 (0) 0 (0) (150,446)(210,753) (18,513) (117,071) (6,762) 166,348 (151,149) 68,324 58,462 (225,293) 44,727 859 (240,610) (78,521) 64,367 (35,246) (146,861) EXHBIT A 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 2023\3 22 22 debt levy ws\2023 debt levy .xlsx 10/4/2022 Fiscal Year 2023 SOURCES 2022 Est. Actual 2022 2023 2024 2025 2026 2027 2028-2033 2034-2039 Bond Proceeds 2,390,000$ 2,385,000$ -$ 2,637,900$ 2,412,260$ -$ 2,493,630$ 15,076,110$ 9,373,000$ Road Improvement Levy (1)1,985,860 1,985,860 1,989,110 2,168,319 2,029,592 2,107,469 1,990,398 12,225,563 7,803,161 Prepaid Assessments 188,950 151,160 37,790 303,722 215,748 - 169,861 1,272,728 922,636 Annual Assessment collections (2)195,000 195,000 185,250 194,513 204,238 194,026 203,728 839,347 434,600 MSA Funds - - - - - - - - - Grant Funding - - - - - - - - - Debt Levy Reduction Funding 341,989 341,989 358,258 4,896 143,521 147,510 141,010 570,112 580,105 Infrastructure levy 65,000 65,000 70,000 75,000 80,000 90,000 95,000 100,000 105,000 Stromwater / Water & Sewer Capital Funds 47,989 47,989 - - - - - - - Miscellaneous - - - - - - - - - TOTAL 5,214,788$ 5,171,998$ 2,640,408$ 5,384,350$ 5,085,359$ 2,539,006$ 5,093,627$ 30,083,860$ 19,218,502$ USES Streets/Utilities Reconstruction 2,014,816$ 1,966,827$ 393,365$ 2,291,799$ 2,618,345$ 511,349$ 2,056,625$ 15,354,306 10,823,987 Sealcoating / Reclimite - - 35,000 40,000 45,000 - 55,000 225,000 275,000 Sidewalks/Street Lights - - - - - - - 492,239 1,723,111 Road Improvement debt 2,327,849 2,327,849 2,347,368 2,173,215 2,173,113 2,254,979 2,131,408 12,795,675 8,383,266 Issuance costs 71,700 78,957 - 85,732 78,398 - 81,043 489,974 304,623 Miscellaneous - - - - - - - - - TOTAL 4,414,365$ 4,373,633$ 2,775,733$ 4,590,747$ 4,914,856$ 2,766,328$ 4,324,076$ 29,357,194$ 21,509,987$ NET CHANGE 800,423$ 798,365$ (135,325)$ 793,603$ 170,503$ (227,323)$ 769,551$ 726,666$ (2,291,485)$ BEGINNING ACTIVITY 2,010,909 2,811,331 3,609,696 3,474,371 4,267,974 4,438,477 4,211,155 4,211,155 4,937,821 CUMULATIVE ACTIVITY 2,811,331$ 3,609,696$ 3,474,371$ 4,267,974$ 4,438,477$ 4,211,155$ 4,980,705$ 4,937,821$ 2,646,336$ (1) PER 2023 DEBT LEVY PROGRAM SEE EXHIBIT C (2) Estimate based on 5 yr. average collections, adjusted for inflation STREETS IMPROVEMENT PLAN 2023 - 2039 BUILDINGS IMPROVEMENT FUND SOURCES Building improvement levy Community Center transfer Liquor store reimbursements Transfers USES HVAC Roofs Lighting Security Windows & Doors Tuck-pointing CAPITAL EQUIPMENT FUND SOURCES Capital equipment levy Equipment sales, grants & donations Transfers USES Fleet Squads & unmarked Public Works trucks Fire trucks & rescue vehicles Heavy equipment Specialty equipment Technology PARK IMPROVEMENT FUND SOURCES Parkland dedication fees Donations & grants Parks Improvement Levy Transfers & Interfund Loans USES Athletic facilities & playground structures Park shelters Splash pads Trail construction UTILITIES INFRASTRUCTURE FUND SOURCES Connection fees Collection of inter-fund loans Grants as available Utility Fund transfer (Beginning in 202) USES Water infrastructure & equipment Sewer infrastructure & equipment Fiber infrastructure & equipment STORMWATER FUND SOURCES Stormwater fees Watershed grants & cost sharing USES Permitting (MS4) & agency reporting, Engineering studies Stormwater reconstruction Stormwater pond maintenance Flood improvements Water quality activities Equipment STREET IMPROVEMENT & DEBT SERVICE FUNDS SOURCES Street improvement levy Bond proceeds Assessments MSA allocation Transfers & project savings USES Street improvement debt Street reconstruction Utility reconstruction Street lights Sidewalks Mill & overlays Alleys