The URL can be used to link to this page

Home My WebLink About2021 Capital Funds bookCity of St. Anthony Village 3301 Silver Lake Road St. Anthony, Minnesota 55418 www.savmn.com City of St. Anthony CAPITAL FUNDS 2021-2025 & 2026-2037 INDEX: Fund Summaries: Buildings Improvement Capital Equipment Park Improvement Utilities Infrastructure Stormwater Streets Improvement & Debt Service APPENDIX: Sources & Uses Fiscal Year 2021 SOURCES 2020 Est. Actual 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Community Center Fund Transfer (1)94,694$ -$ 60,000$ 105,000$ 109,200$ 113,568$ 118,111$ 720,000$ 720,000$ Reimbursement for Liquor Stores - - - 6,000 99,000 5,500 82,960 73,060 36,000 Building Improvement Levy (2) 78,000 78,000 78,000 88,000 93,000 98,000 103,000 712,000 750,000 TOTAL 172,694$ 78,000$ 138,000$ 199,000$ 301,200$ 217,068$ 304,071$ 1,505,060$ 1,506,000$ USES City Hall/Community Center 69,000$ 121,160$ 64,000$ 171,600$ 180,000$ 15,000$ 16,000$ 504,223$ 308,350$ Fire Station 12,000 995 - 30,000 - 31,000 47,672 142,745 157,500 Public Works 12,000 4,880 - 7,500 - 48,861 40,640 384,553 170,500 Park Shelters - 11,600 22,000 5,000 14,000 - 26,950 88,180 81,000 Liquor Stores - - - 6,000 99,000 5,500 82,960 73,060 36,000 TOTAL 93,000$ 138,635$ 86,000$ 220,100$ 293,000$ 100,361$ 214,222$ 1,192,761$ 753,350$ NET CHANGE 79,694 (60,635) 52,000 (21,100) 8,200 116,707 89,849 312,300 752,650 BEGINNING CASH BALANCE 509,754 509,754 449,119 501,119 480,019 488,219 604,926 694,775 1,007,074 ENDING CASH BALANCE 589,448$ 449,119$ 501,119$ 480,019$ 488,219$ 604,926$ 694,775$ 1,007,074$ 1,759,724$ (1) Community Center fund transfer paused for 2020, School District rent reformulated in 2020. (2) Additional Building Improvement Levy of $5,000 annually, paused for 2021, on schedule for 2022. BUILDINGS IMPROVEMENT PLAN 2021 - 2037 BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2020 EST ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 City Hall 1996 Building Components Metal Door Frame & Replacement PD and EE Entrances 2018 Multi.Internal -$ -$ -$ -$ -$ -$ -$ -$ -$ 28,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Security upgrades - Cameras 2016 7 Internal - - - - - - - - - 24,313 - - - - - - - - - Security upgrades -Control Server 2016 1 Internal - - - - - - - - - 17,500 - - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - 24,410 - - - - - - - - - Replacement of Fire Alarm Panel 2016 1 Internal - - - - - - - - - - - 25,000 - - - - - - - Parking Lot LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - - 15,000 - - Building LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - - 25,000 - - Boilers/Fans etc Replaced in 2015-130K 2 Sebesta - - - 7,500 - - - 7,500 - - - 7,500 - 160,850 - 7,500 - - - RTU-3 (Day Care)Fair 1 Sebesta - - 64,000 - - - - - - - - - - - - - - - - RTU-4 (City)Fair 1 Sebesta 69,000 53,800 - - - - - - - - - - - - - - - - - RTU-4 (City) DUCTWORK/ PCA CONTROL - 49,760 - - - - - - - - - - - - - - - - - RTU-1 (Gym)Fair 1 Sebesta - - - 46,000 - - - - - - - - - - - - - - - RTU-2 (Multi-purpose)Fair 1 Sebesta - - - 27,600 - - - - - - - - - - - - - - - RTU-5 (Police)Fair 1 Sebesta - - - 34,500 - - - - - - - - - - - - - - - HVAC Controls for 5 RTU update with RTU Units 1 TBD - 2,600 - - - - - - - - - - - - - - - - - Domestic Water Heaters Fair 2 Sebesta - 10,000 - - - - 16,000 - - - - - - - - - - 15,000 - Relamp & Reballast (LED-PD) Done w/2015 LED project 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 - 5,000 - - - 15,000 - - - - - - - - - - - - 30,000 Outdoor sign Fair 1 Internal - - - 56,000 - - - - - - 55,000 - - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - 140,000 - - - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - - - 175,000 - - - - - - - - - - - TOTAL 69,000$ 121,160$ 64,000$ 171,600$ 180,000$ 15,000$ 16,000$ 182,500$ -$ 94,223$ 55,000$ 32,500$ 140,000$ 160,850$ 30,000$ 7,500$ 65,000$ 15,000$ 30,000$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - - 12,500 - - - - - - 15,000 - - - - - - - 20,000 Security upgrades -Cameras 2016 4 Internal - - - - - - - - - 8,360 - - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - 7,005 - - - - - - - - - Rooftop Units Fair - Good Multi.Sebesta - - - - - 31,000 - - - - - - - - - - - - - Makeup Air Unit Fair 2 Sebesta - - - 17,500 - - - - - - - - - 20,000 - - - - - Domestic Water Heaters 2016 1 Sebesta - - - - - - - 12,880 - - - - - - - - - 15,000 - Relamp & Reballast Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - 35,000 - - Roof Fair 1 Sebesta - - - - - - 47,672 - - - - - - - - - - - - Exterior Paint 1 Internal 12,000 995 - - - - - - - - - - 4,500 - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - - - - - 67,500 - - Parking Lot mill and overlay 30 years 1 Internal - - - - - - - 35,000 - - - - - - - - - - - Overhead garage doors 25 years 3 Internal - - - - - - - - - - - 60,000 - - - - - - - TOTAL 12,000$ 995$ -$ 30,000$ -$ 31,000$ 47,672$ 47,880$ -$ 15,365$ 15,000$ 60,000$ 4,500$ 20,000$ -$ -$ 102,500$ 15,000$ 20,000$ Public Works 2004 Building Components Metal Door Frame & Replacement Fair Internal - - - 7,500 - - - - - - 9,000 - - - - - - - - Security upgrades -Cameras 2016 3 Internal - - - - - - - - - 6,990 - - - - - - - - 8,500 Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - 17,515 - - - - - - - - 22,000 Rooftop Unit 2017 1 Sebesta - - - - - 23,000 - - - - - - - - - - - - - Makeup Air Unit Good 3 Sebesta - - - - - - 19,250 - - - - - - - - - - - - Air Handling Unit Good 1 Sebesta - - - - - - 8,050 - - - - - - - - - - - - Exhaust Fans Good 6 Sebesta - - - - - - 13,340 - - - - - - - - - - - - Domestic Water Heaters Good 2 Sebesta - - - - - 25,861 - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - 206,048 - - - - - - - - - - - Overhead garage doors/Shop fixtures 25 years 7 Internal - - - - - - - - - - 105,000 - Exterior Paint Internal 12,000 4,880 - - - - - - - - - - - - - - - - - Parking Lot mill and overlay 30 years Internal - - - - - - - - - - - - - - - 140,000 - - - Rehab salt storage 25 years Internal - - - - - - - - - - 40,000 - - - - - - - - TOTAL 12,000$ 4,880$ -$ 7,500$ -$ 48,861$ 40,640$ 206,048$ -$ 24,505$ 154,000$ -$ -$ -$ -$ 140,000$ -$ -$ 30,500$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2020 EST ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Central Park Pavilion 2003 Roof 2018 - - - - - - - - - - - - - - - - - - Security upgrades -Cameras 2016/2019 - - - - - - - - 8,360 - - - - - - - - 10,000 Security upgrades - Entrance controls 2016/2019 - - - - - - - - 7,005 - - - - - - - - 8,000 Other Technology 2019 1 Internal - - - - - 1,950 - - - - - 1,950 - - - - - - HVAC 2020 - 11,600 - - - - - - - - - - - - - - - - - Domestic water heaters Fair - - - - - - - - - - - - - 5,000 - - - - Exterior updates 2019 - - - - - - - - - 12,000 - - - - - - - - Interior updates 2018 - - - - - - - - - 8,500 - - - - - - - - Parking Lot mill and overlay 30 years - - - - - - 15,000 - - - - - - - - - - - -$ 11,600$ -$ -$ -$ -$ 1,950$ 15,000$ -$ 15,365$ 20,500$ -$ 1,950$ -$ 5,000$ -$ -$ -$ 18,000$ Emerald Park Pavilion 2009 - - - - - - - - - - - - - - - - - - - Roof Fair - - - - - - 25,000 - - - - - - - - - - - - Security upgrades -Cameras 2016 - - - - - - - - - 8,360 - - - - - - - - 10,000 Security upgrades - Entrance controls 2016 - - - - - - - - - 7,005 - - - - - - - - 8,000 HVAC Fair - - - - 14,000 - - - - - - - - - - - - - Domestic water heaters Fair - - - 5,000 - - - - - - - - - - 5,000 - - - - Exterior updates Fair - - 10,000 - - - - - - - - - - - - - - 15,000 - Interior updates Fair - - 12,000 - - - - - - - - - - - - - - 20,000 - Parking Lot mill and overlay 30 years - - - - - - - - - - - - 20,000 - - - - - - -$ -$ 22,000$ 5,000$ 14,000$ -$ 25,000$ -$ -$ 15,365$ -$ -$ 20,000$ -$ 5,000$ -$ -$ 35,000$ 18,000$ Park Shelters -$ 11,600$ 22,000$ 5,000$ 14,000$ -$ 26,950$ 15,000$ -$ 30,730$ 20,500$ -$ 21,950$ -$ 10,000$ -$ -$ 35,000$ 36,000$ TOTAL IMPROVEMENTS GOVERMENTAL 93,000$ 138,635$ 86,000$ 214,100$ 194,000$ 94,861$ 131,262$ 451,428$ -$ 164,823$ 244,500$ 92,500$ 166,450$ 180,850$ 40,000$ 147,500$ 167,500$ 65,000$ 116,500$ 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 - - - 3,000 - 5,500 - - - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta - - - - - -- - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - 15,000 - - - - - - - Roof Fair 1 Sebesta - - - - - - 36,398 - - - - - - - - - - - - TOTAL -$ -$ -$ 3,000$ 35,000$ 5,500$ 38,288$ 10,800$ -$ 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 - - - 3,000 - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - 15,000 - - - - - - - Roof Fair 1 Sebesta - - - - - - 42,782 - - - - - - - - - - - - TOTAL -$ -$ -$ 3,000$ 64,000$ -$ 44,672$ 10,800$ -$ 8,840$ -$ 15,000$ 1,890$ -$ -$ -$ 12,000$ -$ 6,000$ TOTAL IMPROVEMENTS ENTERPRISE -$ -$ -$ 6,000$ 99,000$ 5,500$ 82,960$ 21,600$ -$ 17,680$ -$ 30,000$ 3,780$ -$ -$ -$ 24,000$ -$ 12,000$ COMBINED TOTAL IMPROVEMENTS 93,000$ 138,635$ 86,000$ 220,100$ 293,000$ 100,361$ 214,222$ 473,028$ -$ 182,503$ 244,500$ 122,500$ 170,230$ 180,850$ 40,000$ 147,500$ 191,500$ 65,000$ 128,500$ Buildings 1996 St. Anthony Community Center St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Fire Station 2004 St. Anthony Public Works Facility Buildings 2005 St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Village Liquor Store Silver Lake Village Fiscal Year 2021 SOURCES 2020 Est. Actual 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Capital Improvement Levy 283,200$ 283,200$ 283,200$ 318,200$ 353,200$ 388,200$ 423,200$ 3,064,200$ 3,964,200$ MSA/Revolving Funds 90,000 90,000 90,000 90,000 90,000 90,000 90,000 540,000 540,000 Trade/Sale of Equipment 30,000 30,000 20,000 20,000 20,000 20,000 20,000 120,000 120,000 Donations/Grants - - - - 138,600 - - - 33,000 Interest / Equipment note proceeds 8,000 11,350 7,250 3,500 2,500 626,350 1,500 754,000 12,000 TOTAL 411,200$ 414,550$ 400,450$ 431,700$ 604,300$ 1,124,550$ 534,700$ 4,478,200$ 4,669,200$ Uses Police 125,408$ 98,821$ 150,181$ 186,205$ 153,650$ 182,891$ 123,069$ 1,011,843$ 1,153,474$ Fire 104,554 85,148 90,623 148,839 173,490 240,300 221,689 1,357,791 1,435,394 Administration/Finance 4,240 1,725 25,050 28,430 17,825 59,050 44,965 113,942 125,086 Streets 105,123 96,015 21,612 95,573 61,848 102,176 81,098 71,035 370,547 Parks 67,151 51,521 33,927 123,760 21,380 5,082 17,204 410,185 440,463 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 406,477 333,230 321,394 582,807 428,193 589,499 488,025 2,964,796 3,524,965 MINIMAL SHORTFALL 4,723$ 81,320$ 79,056$ (151,107)$ 176,107$ 535,051$ 46,675$ 1,513,404$ 1,144,235$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines* - - - - - 591,701 - 706,522 - SCBA COMPLETE PACK - - - - 277,200 - - - - Dump Trucks (moved 1 DT to utility fund)- - - - - 220,000 - 270,108 331,870 2008 F750 High Ranger Aerial Truck - - - - - - 184,566 - - 1995 Street 444G Front-End Loader 185,000 143,342 - - - - - - - 1999 Parks 4500 Tractor - - - - 71,241 - - - - 185,000 143,342 - - 348,441 811,701 184,566 976,629 331,870 OVERALL SHORTFALL (180,277)$ (62,022)$ 79,056$ (151,107)$ (172,334)$ (276,650)$ (137,891)$ 536,775$ 812,366$ NET CHANGE (180,277)$ (62,022)$ 79,056$ (151,107)$ (172,334)$ (276,650)$ (137,891)$ 536,775$ 812,366$ BEGINNING CASH BALANCE 722,185$ 722,185$ 660,163$ 739,219$ 588,112$ 415,778$ 139,128$ 1,236$ 538,011$ ENDING CASH BALANCE 541,908$ 660,163$ 739,219$ 588,112$ 415,778$ 139,128$ 1,236$ 538,011$ 1,350,377$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE CAPITAL EQUIPMENT 2021 - 2037 Fiscal Year 2021 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Police Department Squads 81,675 87,042 91,082 49,387 37,129 126,241 52,394 449,033 553,706 Unmarked - - - 32,630 33,446 34,282 - 116,579 135,231 Retired to Other Services 796 - 820 845 - 896 923 4,067 6,101 Technology 18,570 3,097 8,327 43,433 47,472 3,456 46,102 222,108 191,346 Specialty Equipment 15,396 6,864 12,767 9,636 17,273 16,411 8,569 108,335 116,901 Investigative Equipment 3,412 - 4,100 3,600 - 965 3,955 11,008 8,810 General Equipment 5,559 1,818 33,086 46,676 18,329 640 11,125 100,712 141,379 TOTAL PD 125,408$ 98,821$ 150,181$ 186,205$ 153,650$ 182,891$ 123,069$ 1,011,843$ 1,153,474$ Fire Department Apparatus - - - 56,897 90,000 591,701 - 821,159 76,465 Station Based Equipment - - - - - 1,920 13,183 62,966 - Protective Gear 16,398 16,393 - 14,478 277,200 51,197 6,592 107,774 95,116 Technology 6,319 - 11,126 9,015 10,340 5,760 7,796 86,100 60,125 Protective Equipment/Tools 3,700 1,057 10,000 2,650 4,000 27,855 42,350 85,398 41,282 Office Furniture 9,038 249 2,047 - 5,000 - - 43,274 29,853 Debt Service Payments 69,100 67,449 67,450 65,800 64,150 153,568 151,768 857,640 1,132,553 TOTAL FD 104,554$ 85,148$ 90,623$ 148,839$ 450,690$ 832,001$ 221,689$ 2,064,313$ 1,435,394$ Administration/Finance Computer Hardware 2,250 1,500 15,050 13,778 12,825 4,050 9,965 50,442 57,115 Computer Software - - - - - 55,000 - 7,500 - Furniture and Equipment - - - 5,000 - - 35,000 40,000 50,000 Council Chambers 1,990 225 10,000 9,652 5,000 - - 16,000 17,971 TOTAL AF 4,240$ 1,725$ 25,050$ 28,430$ 17,825$ 59,050$ 44,965$ 113,942$ 125,086$ DEPARTMENTAL SUMMARIES 2021-2037 Fiscal Year 2021 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 DEPARTMENTAL SUMMARIES 2021-2037 PUBLIC WORKS Streets Department Fleet replacements - - - 57,307 39,144 93,440 41,527 - 269,978 Plows/Dump trucks - - - - - 220,000 - 277,938 331,870 Heavy Equipment 189,928 146,852 5,051 5,177 5,307 5,440 222,247 36,506 42,335 Speciality Equipment 100,195 92,505 16,561 33,088 17,397 3,296 1,890 26,699 58,234 TOTAL 290,123$ 239,357$ 21,612$ 95,573$ 61,848$ 322,176$ 265,664$ 341,143$ 702,417$ Parks Department Fleet replacements - - - 51,275 - - - 103,894 133,495 Heavy Equipment 1,137 529 5,857 5,302 73,727 - 13,183 91,851 58,080 Mowers 62,546 50,992 18,571 45,744 - 1,280 - 151,943 134,982 Field Maintenance - - 4,685 18,906 - - - 27,429 47,917 Rink Maintenance - - 586 - 12,029 640 - 5,167 30,697 Speciality Equipment 3,468 - 4,228 2,534 6,866 3,162 4,021 29,900 35,292 TOTAL 67,151$ 51,521$ 33,927$ 123,760$ 92,621$ 5,082$ 17,204$ 410,185$ 440,463$ TOTAL PW 357,274$ 290,878$ 55,539$ 219,333$ 154,469$ 327,258$ 282,868$ 751,327$ 1,142,880$ GRAND TOTAL 591,477$ 476,572$ 321,394$ 582,807$ 776,634$ 1,401,200$ 672,591$ 3,941,425$ 3,856,834$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.3439164 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.137203 1.171319 1.2064589 1.242653 1.2799323 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Active Squads 1576/tbd 705/711 2016/2020 DODGE DODGE CHARGER / DURANGO SUV - PATROL 3-4 1 37,433 33,979 47,665 - - 38,243 - - - 43,043 - - - 48,445 - - - 54,526 - 1577 706 2016 FORD FORD EXPLORER SUV - PATROL 3-4 1 39,876 47,696 - 50,523 - 50,868 - - - 57,253 - - - 64,439 - - - 72,526 - 1598 707 2017 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - 39,377 - 37,129 - - 41,789 - - - 47,034 - - - 52,938 - - 1599 708 2017 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - - 40,559 - - 52,394 - - - 58,970 - - - 66,372 - - - 74,702 1629 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3-4 1 43,335 - - - 49,387 - - 53,966 - - - 60,740 - - - 68,363 - - - 1630 710 2018 DODGE DODGE CHARGER - PATROL 3-4 1 32,989 - - - 37,129 - - 40,572 - - - 45,664 - - - 51,396 - - - 81,675 87,042 91,082 49,387 37,129 126,241 52,394 94,539 41,789 100,296 58,970 106,404 47,034 112,884 66,372 119,759 52,938 127,052 74,702 Unmarked 1557 6903 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - - 32,630 - - - - 37,841 - - - - - 43,896 - - - - 1600 6901 2017 CHEV CHEV IMPALA - CHIEF 6 1 23,000 - - - - 33,446 - - - - 38,787 - - - - - 44,993 - - - 1631 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 31,191 - - - - - 34,282 - - - - 39,951 - - - - - 46,343 - - - - - 32,630 33,446 34,282 - - 37,841 38,787 39,951 - - - 43,896 44,993 46,343 - - Retired To Other Services (1) 1558 702 2015 FORD FORD INTERCEPTOR SUV - CSO 7 1 700 - - - 845 - - - 951 - - - 1,070 - - - 1,204 - - - 1513 698 2013 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 700 796 - - - - 896 - - - 1,008 - - - 1,135 - - - 1,277 - 1482 UM 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 - - 820 - - - 923 - - - 1,039 - - - 1,169 - - - 1,316 796 - 820 845 - 896 923 951 - 1,008 1,039 1,070 - 1,135 1,169 1,204 - 1,277 1,316 Technology NA NA 2018 VARIOUS SQUAD COMPUTERS 5 9 4,550 - - 3,519 - 47,472 - 3,960 - - 55,033 - 4,729 - 63,799 - - - - 1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 13,000 13,000 - - - - - - - - - - 19,868 - - - - - - - NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies varies 2,500 3,097 4,808 40,175 - - 42,142 29,982 12,244 5,913 - - 34,757 51,829 14,203 - 7,273 40,293 - NA NA VARIOUS VARIOUS PORTABLE/SQUAD RADIOS (2) varies varies varies 3,070 - - 3,257 - 3,456 - 3,666 - 51,789 - 4,126 - 4,378 - 4,644 - 4,927 - 18,570 3,097 8,327 43,433 47,472 3,456 46,102 33,648 12,244 112,735 - 23,994 39,486 56,207 78,002 4,644 7,273 45,220 - 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,300 - 6,789 - - - - 7,871 - - - - - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS)5 10 500 569 - 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 NA NA VARIOUS VARIOUS RIOT GEAR - 12 sets total 10 6/6 1,000 - - - - 7,456 - - - - 8,643 - - - - 10,020 - - - - NA NA VARIOUS VARIOUS TASERS/BATTERIES 5 23 1,500 3,412 5,100 3,514 3,619 3,728 3,840 3,955 4,074 4,196 4,322 4,451 4,585 4,722 4,864 5,010 5,160 5,315 5,475 5,639 NA NA VARIOUS VARIOUS FIREARMS 15 23+varies 2,274 1,764 2,343 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 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,729 - 2,811 - 2,982 3,072 - - 3,357 3,457 - - 3,778 3,891 - - 4,252 4,380 - NA NA VARIOUS VARIOUS HAND HELD RADAR 10 2 3,000 3,000 - - 3,000 - - - - - - - - - - - - - - - NA NA 2014 VARIOUS BIKES 10 2 1,500 3,412 - 3,514 - - - - 4,074 - - - - - - - - - - - 15,396 6,864 12,767 9,636 17,273 16,411 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 14,417 10,338 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.3439164 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605 1.137203 1.171319 1.2064589 1.242653 1.2799323 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP/RECORDERS 5-7 7 500 - 4,100 - 965 - - 4,895 - - 1,528 - - 1,670 - - 1,825 - NA NA VARIOUS VARIOUS SECURITY CAMERAS/DVR/INTERVIEWS (3)5 16 5,600 - - - - - - - - - - - - - - - - - - - NA NA ~2007 VARIOUS SURVEILLANCE EQUIPMENT 10-15 1 3,000 3,412 - - 3,600 - - 3,955 - - - - 4,585 - - - - 5,315 - - 3,412 4,100 3,600 - 965 3,955 - 4,895 - - 6,113 - - 1,670 - 5,315 1,825 - Administrative Equipment 1583 NA 2016 VARIOUS COPIER 1 7 11,250 - - 13,573 - - - - - 16,206 - - - - - 19,351 - - - NA NA VARIOUS VARIOUS OFFICE COMPUTERS -18 / PRINTERS-2 6 20 750 2,559 1,500 - - 17,708 - 2,966 - - 20,528 - 3,439 - - 23,798 - 3,986 - - NA NA VARIOUS VARIOUS VARDA UNITS 10 2 3,000 - - - - - - 8,147 - - - - - - - - - - - NA NA VARIOUS VARIOUS MAIN OFFICE FURNITURE / CHAIRS 15 30+250 3,000 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 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 - 318 - - - - - 6,500 - - - - 6,500 - - - - 6,500 - 1483 NA 2011 LETG RECORDS RETENTION MGMT SYSTEM 10-15 1 65K - 32,500 32,500 - - - - - - - - - - - - 75,000 - - 5,559 1,818 33,086 46,676 18,329 640 11,125 15,326 699 37,455 742 39,203 7,287 811 24,633 20,211 87,372 7,412 940 TOTAL POLICE 125,408 98,821 150,181 186,205 153,650 182,891 123,069 164,153 129,218 310,306 108,862 185,190 114,114 183,845 234,946 200,272 249,912 197,204 87,295 1,011,843 1,153,474 FOOTNOTES (1)EXTENDING LIFE OF ACTIVE/UNMARKED OFFICER VEHICLES WITH BUILD-UP/TEAR DOWN COSTS, ALSO REPLACES FIRE DEPARTMENT INSPECTION VEHICLE (2)PORTABLE RADIOS LEASED RATHER THAN PURCHASED IN 2018 (3)REMOVED AS EQUIPMENT BEING REPLACED AS PART OF THE PANASONIC INTEGRATED VIDEO SYSTEM Police Department 1 2016 Ford Explorer (1) 2015, 2018 , 2020 Ford & Dodge SUV (3) 2017-2020 Dodge Charger (3) 2018 Ford Taurus 2016, 2017 Chevrolet Impala (3) 2011 Ford Fusion (1) FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.1372032 1.1713193 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.0609 1.092727 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.3047732 1.3439164 1.3842339 1.4257609 1.4685337 1.5125897 1.5579674 1.6047064 1.6528476 1.7024331 1.7535061 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Apparatus 1636 2018 CUSTOM FIRE ENGINE - 14 25-30 1 495,540 - - - - - - - - - - - - - - - - - - - 1154 1999 TOYNE ENGINE - 11 25-30 1 425,000 - - - - - 591,701 - - - - - - - - - - - - - 1288 2000 HME ENGINE - 12 25-30 1 425,000 - - - - - - - - - - - 706,522 - - - - - - - 1156 1991 ROAD RESCUE UTILITY TRUCK (rebuild vs replace)30 1 150,000 - - - - 90,000 - - - - - - - - - - - - - - 1575 2016 FORD RESCUE - F350 10 1 80,000 - - - - - - - 100,189 - - - - - - - - - - - 1487 2011 FORD CHIEF VEHICLE 150 10 1 31,500 - - - 56,897 - - - - - - - - - 76,465 - - - - - 1385 2006 FORD INSPECTIONS VEHICLE (1)n/a 1 - - - - - - - - - - - - - - - - - - - 2006 BOAT AND MOTOR 20 1 8,000 - - - - - - - 14,449 - - - - - - - - - - - - - - 56,897 90,000 591,701 - 114,638 - - - 706,522 - 76,465 - - - - - Station Based Equipment 1390 2006 COMPRESSOR 25-30 1 40,000 - - - - - - - - - - - 62,966 - - - - - - 2007 POWER WASHER 15-20 1 1,500 - - - - - 1,920 - - - - - - - - - - - - - 2003 TO WASHER DRYER 20 2 10,000 - - - - - - 13,183 - - - - - - - - - - - - - - - - - 1,920 13,183 - - - - - 62,966 - - - - - - Protective Gear Various TURNOUT GEAR/ HELMENTS 10 25 2,000 16,398 16,393 - - - 51,197 - - - - - 21,396 - - 66,801 - - - - Various ROOKIE TURN OUT GEAR 10 6 2,000 - - - 14,478 - - - - 16,783 - - - - 19,457 - - - - - Dated EMS COATS / PANTS 15 32 225 - - - - - - - 9,777 - - - - - - - - - - - 2001/2004 SCBA COMPLETE PACK 20 36 7,700 - - - - 277,200 - - - - - - - - - - - - - - Various SCBA BOTTLES/FACEPIECE 15 65 800 - - - - - - - - - - - - 59,818 - - - - - 2005 ICE RESCUE EQUIPMENT 10 4 1,250 - - - - - - 6,592 - - - - - - - - - 8,859 - - 16,398 16,393 - 14,478 277,200 51,197 6,592 9,777 16,783 - - 21,396 59,818 19,457 66,801 - 8,859 - - Technology 1501 Various PAGERS/BATTERIES 5 35 600 - - 4,920 - 5,219 - 5,537 - 5,874 - 6,232 - 6,611 - 7,014 - 7,441 - 7,894 2018 NETWORK SWITCH 6 1 2,500 - - - 2,500 - - - - 2,500 - - - - - 2,500 - - - - 2019 WIFI ROUTER 6 2 1,600 - - - - - - 1,600 - - - - - 1,600 - - - - - 1,600 2006 VEHICLE COMPUTERS 5 2 2,000 - - - - - 5,120 - - - - 5,935 - - - - 6,880 - - - Various OFFICE COMPUTERS 6 8 700 - - - 5,912 - - - - 5,874 - - - - 6,810 - - - - 7,894 2014 RADIOS/BATTERIES 12 12 2,500 - - 5,621 - - - - 20,368 20,979 - - - - - - - - - - 2008 EOC TECHNOLOGY 6 5 Various 5,750 - - - 4,500 - - - 5,734 - - - - - 6,847 - - - - Various OTHER BATTERIES 500 569 - 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940 6,319 - 11,126 9,015 10,340 5,760 7,796 21,047 41,661 720 12,909 764 8,999 7,620 17,196 7,741 8,327 912 18,329 Protective Equipment/Tools 2017 DEFIBRILLATOR 7 5 1,700 - - - - - 6,528 4,482 - - - - - 8,028 5,513 - - - - - 2017 DEFIBRILLATOR FOR POLICE DEPT 7 6 1,700 - - - - - 6,528 6,723 - - - - - 8,028 8,269 - - - - - Various HOSE REPLACEMENT 15 116 100-425 2,500 - - 2,650 - 2,800 - 2,800 - 3,000 - 3,000 - 3,250 - 3,250 - 3,500 - Various HOSE APPLIANCES 10 30 150 - - 3,000 - - - - - - - - - 4,722 - - - - - - 1468 Various THERMAL IMAGER 10 5 5,500-12,000 - - - - - 12,000 - - - - 12,000 - - - - - - - - Various NOZZLE REPLACEMENT 15 1,000-2,500 - - 7,000 - - - - 7,300 - - - - 7,500 - - - - 7,700 - 2013 LUCAS DEVICE 15 1 16,500 - - - - - - - - - 23,769 - - - - - - - - - Various FANS AND BLOWERS 15 8 2,400 - - - - - - - - - - - - - - - 3,000 - - - Various SAWS (CHAIN AND CUT OFF)10 6 1,650 - - - - 4,000 - - - 4,500 - - - - 5,000 - - - - - Various GAS MONITOR/ CARBON MNX DTC 6 10 600 1,200 1,057 - - - - 1,350 - - 750 - - - - - 1,800 - - - 1290 Various OUTDOOR WARNING SIRENS 30 2 22,600 - - - - - 29,794 - - - - - - - - - - - - 3,700 1,057 10,000 2,650 4,000 27,855 42,350 10,100 4,500 27,519 12,000 3,000 28,279 22,032 - 8,050 - 11,200 - 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.1372032 1.1713193 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.0609 1.092727 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.3047732 1.3439164 1.3842339 1.4257609 1.4685337 1.5125897 1.5579674 1.6047064 1.6528476 1.7024331 1.7535061 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Office Furniture 2004 OFFICE CHAIRS/FURNITURE 15 9 315 - - - - 5,000 - - - 6,000 - - - - 6,000 - - - - - 2004 TRAINING ROOM CHAIRS 15 35 85 - - - - - - - - - - - 4,547 - - - - - - - 2004 DAY ROOM/KITCHEN/APPLIANCES 15 6 600 1,987 249 2,047 - - - - - - - 2,671 2,751 - - - - - - - 2014 COPIER 6 1 6,200 7,051 - - - - - - 8,419 - - - - - 10,053 - - - - - 2003 FITNESS EQUIPMENT 10 3 4,500 - - - - - - - 6,110 6,294 6,483 - - - - - - - 6,800 7,000 9,038 249 2,047 - 5,000 - - 14,529 12,294 6,483 2,671 7,298 - 16,053 - - - 6,800 7,000 TOTAL FIRE 35,454 17,699 23,173 83,039 386,540 678,433 69,921 170,091 75,238 34,722 27,580 738,980 160,062 141,626 83,997 15,791 17,186 18,912 25,329 FIRE ENGINE DEBT SERVICE 69,100 67,449 67,450 65,800 64,150 153,568 151,768 154,968 153,018 86,068 86,068 188,759 188,759 188,759 188,759 188,759 188,759 188,759 188,759 104,554 85,148 90,623 148,839 450,690 832,001 221,689 325,059 228,256 120,790 113,648 927,739 348,820 330,385 272,756 204,549 205,945 207,671 214,088 500,000 35,454 23,173 83,039 386,540 240,300 69,921 170,091 75,238 34,722 (472,420) 1,230,660 160,062 141,626 83,997 15,791 17,186 1,570,127 1,435,394 1,937,181 FOOTNOTES (1)REPLACED WITH RETIRING UNMARKED SQUAD Fire Department 2016 Rescue 11 1999 Engine 11 2 2000 Engine 12 1991 Utility 11 2011 Staff Vehicle 2018 Engine 14 5 6 7 8 Fire Department 2006 Inspections Vehicle 2006 Boat and Motor 2006 Compressor FIXED ASSET SCHEDULE ADMINISTRATION/FINANCE ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 / 2017 CISCO ETHERNET SWITCH/FIBER SWITCHS 7 5 1,500 - - 10,550 - - - 9,090 - - 10,550 - - - 9,090 - - 10,550 - - UNASSIGNED 2018 WIFI ROUTERS 6 4 800 - - - - - 3,200 - - - - - 3,200 - - - - - 3,200 - NA VARIOUS FILE SERVER & SOFTWARE UPGRADES/ROSEVILLE 10 1 23,059 750 500 4,500 800 825 850 875 900 925 5,500 975 1,000 1,025 1,025 1,050 1,050 1,050 1,075 1,075 UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 - - - - 12,000 - - - - - - - 13,000 - - - - - - NA VARIOUS COMPUTER EQUIPMENT 6 14 900 1,500 1,000 - 12,978 - - - - 13,367 - - - - 13,768 - - - - 14,181 2,250 1,500 15,050 13,778 12,825 4,050 9,965 900 14,292 16,050 975 4,200 14,025 23,883 1,050 1,050 11,600 4,275 15,256 Computer Software 1532/1639 2012 FINANCIAL SOFTWARE (CIVIC) 15 1 55,000 - - - - - 55,000 - - - - - - - - - - - - - UNASSIGNED 2014 LASERFICHE 15 1 7,000 - - - - - - - - - 7,500 - - - - - - - - - 1641 2018 POS LIQUOR CC SYSTEM MP 15 1 9,030 - - - - - - - - - - - - - - - - - - - 1642 2018 POS LIQUOR CC SYSTEM SLV 15 1 9,030 - - - - - - - - - - - - - - - - - - - - - - - - 55,000 - - - 7,500 - - - - - - - - - Furniture and Equipment 1581RC NA ELECTION MACHINES & EQUIPMENT 10 2 10,000 - - - - - - 35,000 - - - - - - - - - 40,000 - - 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS - - - 5,000 - - - 40,000 - - - - - - 10,000 - - - - - - - 5,000 - - 35,000 40,000 - - - - - - 10,000 - 40,000 - - Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS - 225 - - 5,000 - - - - 5,000 - - - - 5,000 - - - - MULTIPLE VARIOUS COUNCIL CHAMBERS CAMERAS (1) 10 5 8,200 - - - - - - - - - - - - - - - - - - - NA VARIOUS COUNCIL CHAMBERS COMPUTERS/MONITORS 7-10 4 1,750-8,000 1,990 - - 9,652 - - - - - - - - - 12,971 - - - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS - - 10,000 - - - - - - - 11,000 - - - - - - - - 1,990 225 10,000 9,652 5,000 - - - - 5,000 11,000 - - 12,971 5,000 - - - - TOTAL ADMIN/FINANCE 4,240 1,725 25,050 28,430 17,825 59,050 44,965 40,900 14,292 28,550 11,975 4,200 14,025 36,854 16,050 1,050 51,600 4,275 15,256 (1) ALL BROADCAST EQUIPMENT NOW INCLUDED IN A/V UPGRADES ESTIMATED ACTUAL FIXED ASSET SCHEDULE PUBLIC WORKS STREETS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2015 1536 2014 CHEVY 5 MALIBU PW DIRECTOR 10 1 22,000 - - - - - 32,643 - - - - - - - - - 56,150 - - - 1464 2010 FORD 1 F150 PICKUP 15 1 31,500 - - - - - - 41,527 - - - - - - - - - - - - 1289 2004 FORD 2 F150 4X4 REPLACED BY FORD EDGE 15 1 31,500 - - - - - - - - - - - - - - - 54,184 - - - 1409 2007 FORD 6 F150 PICKUP 4X4 (SUPR TO MECH) 15 1 31,500 - - - - 39,144 - - - - - - - - - - - - - - 1601 2017 FORD 8 F350 PICKUP 4X4 15 1 45,000 - - - - - - - - - - - - - 72,962 - - - - - 1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - - 60,797 - - - - - - - - - - - - - 1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - 57,307 - - - - - - - - - - - - - 86,682 - 256,500 - - - 57,307 39,144 93,440 41,527 - - - - - - 72,962 - 110,334 - 86,682 - 1508 2013 IHC 14 7400 DUMP TRUCK 15-25 1 181,859 - - - - - - - - - - - - - - - - - 331,870 - 1186 2003 STERLING 11 M8500 DUMP TRUCK 15-25 1 187,500 - - - - - - - - - 270,108 - - - - - - - - - 1181 1995 FORD 12 L8000 DUMP TRUCK 15-25 1 187,500 - - - - - 220,000 - - - - - - - - - - - - - 1582 2016 WESTERN 8 FT PLOW BLADE 15 1 6,682 - - - - - - - - - - - 7,830 - - - - - - - 563,541 - - - - - 220,000 - - - 270,108 - 7,830 - - - - - 331,870 - 1450 2010 VERMEER BRANCH CHIPPER 15 1 32,105 - - - - - 32,105 - - - - - - - - - - - - 1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - 184,566 - - - - - - - - - - - - 1635 NA BOBCAT BOBCAT REPLACEMENT PROGRAM NA 1 6,000 4,928 3,500 5,051 5,177 5,307 5,440 5,576 5,715 5,858 6,004 6,154 6,308 6,466 6,628 6,793 6,963 7,137 7,316 7,499 1216 1995 JOHN DEERE 32 444G FRONT END LOADER 20 1 160,000 185,000 143,352 - - - - - - - - - - - - - - - - - 338,105 189,928 146,852 5,051 5,177 5,307 5,440 222,247 5,715 5,858 6,004 6,154 6,308 6,466 6,628 6,793 6,963 7,137 7,316 7,499 2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - - 2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - - - 6,429 - - - - - - - - - 1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - 6,213 - - - - - - - - - - - - - - 1222 1999 CRAFCO 200 PAVEMENT ROUTER (2) 15-25 1 20,000 - - - - - - - - - - - - - - - - - - - TBD 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - - - - - - - - 1201 1995 ROSCO 42 VIBRASTAT 111(3) ASPHALT ROLLER 15-20 1 15,000 17,058 13,600 - - - - - - - - - - - - - - - - - 1202 1999 STEPP 51 SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 55,204 48,366 - - - - - - - - - - - - - - - - - 1997 WHACKER WP 1550AW VIBROPLATE 15-20 1 3,000 - - - 3,619 - - - - - - - - - - - - - - - 1998 TRAFFIC MANAGER SY3913060 ARROW BOARD 30X60" 15-20 1 9,000 - - - - 11,184 - - - - - - - - - - - - - - 1997 ERSKINE 2418 - 61" SNOWBLOWER (1) 15-20 1 5,000 - - - - - - - - - - - - - - - - - - - 1999 BOBCAT 70" ANGLE BROOM 15-20 1 10,000 11,372 - - 11,372 - - - - - - - - - - - - - - - 1184 2000 MASTER TOW CAR DOLLY (2) NA 1 15,000 - - - - - - - - - - - - - - - - - - - 1183 1998 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 16,561 - 16,561 - - - - - - - - - - - - - - - - 1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 - - - 18,097 - - - - - - - - - - - - - - - 2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - - - - - 3,542 - - - - - - 1579 2016 GRACO LINELAZER STREETS PAINTER 3900 13 1 10,000 - - - - - - - - - - 14,838 - - - - - - - - 1991 MUD TUB CONCRETE HAULER/DUMPER (2) NA 1 10,000 - - - - - - - - - - - - - - - - - - - **NEW CADLINK VINYL CUTTER/PRINTER 15 1 7,500 - - - - - - - - - - - - - - 11,344 - - - - NETWORK SWITCH 6 1 1,290 - - - - - - 1,290 - - - - - 1,290 - - - - - 1,290 WIFI ROUTER 6 1 600 - - - - - - 600 - - - - - 600 - - - - - 600 GARAGE & OFFICE COMPUTERS 6 4 800 - - - - - 3,296 - - - - - - - - - - - - - GAS PUMPS 15-20 2 15,270 - 30,539 - - - - - - - - - - - - - - 45,000 - - 284,360 100,195 92,505 16,561 33,088 17,397 3,296 1,890 - - 6,429 14,838 - 5,432 - 11,344 - 45,000 - 1,890 TOTAL STREETS 290,123 239,357 21,612 95,573 61,848 322,176 265,664 5,715 5,858 282,541 20,992 14,138 11,898 79,590 18,138 117,297 52,137 425,867 9,389 - - - 270,108 - - ####### ####### 341,143 702,417 290,123 21,612 95,573 61,848 322,176 265,664 5,715 5,858 12,434 20,992 14,138 11,898 79,590 18,138 117,297 52,137 425,867 9,389 FOOTNOTES (1) REPLACEMENT MADE RETAINED FOR BACKUP (2)NOT SCHEDULED FOR REPLACEMENT Specialty Equipment Fleet Plows/Dump Trucks Heavy Equipment 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL — ϮϬϭϰŚĞǀƌŽůĞƚDĂůŝďƵ ϮϬϭϬ&ŽƌĚ&ϭϱϬWŝĐŬƵƉ ϮϬϭϵ&ŽƌĚ&ϭϱϬϰǆϰ ϮϬϬϴ&ŽƌĚ&ϰϱϬ DŝŶŝƵŵƉϮdŽŶϰǆϰ ϮϬϬϲ&ŽƌĚ&ϰϱϬ DŝŶŝƵŵƉϮdŽŶϰǆϰ ϮϬϭϳ&ŽƌĚ&ϯϱϬWŝĐŬƵƉ — ϮϬϬϰ&ŽƌĚ&ϭϱϬWŝĐŬƵƉϰǆϰ — Ȁ ϮϬϬϯ^ƚĞƌůŝŶŐDϴϱϬϬĐƚĞƌƌĂ ϮϬϭϯ/ŶƚĞƌŶĂƟŽŶĂůϳϰϬϬ ƵŵƉdƌƵĐŬ ϭϵϵϱ&ŽƌĚ>ϴϬϬϬƵŵƉdƌƵĐŬ ϮϬϭϴ/ŶƚĞƌŶĂƟŽŶĂůϳϱϬϬ ƵŵƉdƌƵĐŬ — ϮϬϭϭsĞƌŵĞĞƌϭϱϬϬŚŝƉƉĞƌ ϮϬϬϴ&ŽƌĚ&ϳϱϬ ,ŝŐŚZĂŶŐĞƌĞƌŝĂůdƌƵĐŬ ϮϬϮϬŽďĐĂƚZĞƉůĂĐĞŵĞŶƚ WƌŽŐƌĂŵ ϮϬϮϬ:ŽŚŶĞĞƌĞϱϮϰ>&ƌŽŶƚ ŶĚ>ŽĂĚĞƌ — ϮϬϭϵ^ƚĞƉƉƌĂĐŬ^ĞĂůĞƌ ϮϬϮϬ^ƚĞƉƉ^W,-Ϯ͘Ϭ ƐƉŚĂůƚ,ŽƚŽǆ ϭϵϵϴdŽǁŵĂƐƚĞƌd-ϱd ^ŝŶŐůĞǆĞůdƌĂŝůĞƌ ϭϵϵϵdŽǁŵĂƐƚĞƌd-ϭϬ ddĂŶĚĞŵǆĞůdƌĂŝůĞƌ ϮϬϭϲ^ƚƌĞĞƚƐWĂŝŶƚĞƌdƌĂŝůĞƌ ϮϬϭϲ>ŝŶĞůĂǌĞƌ^ƚƌĞĞƚƐWĂŝŶƚĞƌ ϯϵϬϬ — ϭϵϵϮ>ĞƌŽǇYϭϴϱŝƌŽŵƉƌĞƐƐŽƌ ϮϬϮϬtĂĐŬĞƌEĞƵƐŽŶZŽůůĞƌ FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 1379 2006 FORD 20 F350 MINI DUMP 1 TON 4X4 15 1 42,500 - - - 51,275 - - - - - - - - - - - - - 77,557 - 1516 2014 FORD 18 F250 CREW CAB FLATBED 15 1 37,500 - - - - - - - - - - 55,642 - - - - - - - - 1462 2011 FORD 21 F250 PICKUP 4X4 15 1 34,500 - - - - - - - 48,252 - - - - - - - - - - - 1604 2017 FORD 22 F250 PICKUP 4X4 15 1 34,500 - - - - - - - - - - - - - 55,938 - - - - - 149,000 - - - 51,275 - - - 48,252 - - 55,642 - - 55,938 - - - 77,557 - 1562 2015 BOBCAT BOBCAT 3400G UTIL VEH (ATV) 10 1 10,000 - - - - - - 13,183 - - - - - - - - - 17,717 - - 1188 1999 JOHN DEERE 38 4500 TRACTOR 15-25 1 35,000 - - - - 43,493 - - - - - - - - - - - - - - 1999 JOHN DEERE 20" PTO AUGER (W/ TRACTOR) 15-25 1 8,000 - - - - 9,652 - - - - - - - - - - - - - - 1999 JOHN DEERE 72" FLAIL MOWER (W/ TRACTOR) 15-25 1 15,000 - - - - 18,097 - - - - - - - - - - - - - - 1488 2011 BOBCAT 36 TOOL CAT 5600 (V-Blade, Snblw, BF Drag) 15 1 46,507 - - - - - - - 63,151 - - - - - - - - - - - 2012 MB HT HYDRAULIC TRACTOR SWEEPER 15 1 15,000 - - - - - - - - 20,979 - - - - - - - - - - 1634 2018 GIANT-VAC 2501 LEAF VACCUM ATTACHMENT 10 1 6,320 - - - - - - - - - - - - - 10,247 - - - - - 2019 BIG TEX TRAILER 15 1 7,000 - - - - - - - - - - - - - - - 12,041 - - - N/A 2018 TRAC VAC 1070 LEAF MOWER ATTACHMENT 10 1 4,395 - - - 5,302 - - - - 6,147 - - - - 7,126 - - - - - 2006 CARRY-ON TRAILER 5X8 2000 LBS 15 1 5,000 - - 5,857 - - - - - - - - - - - - - - 9,124 - 2001 TRAFFIC CT JR ROAD COUNTER 15 1 1,000 - - - - - - - - - - - - 1,574 - - - - - - 2000 HONDA 1400W GENERATOR 15 1 1,000 1,137 529 - - - - - - - - - - - - - - - 1,825 - 1974 VERMEER TREE SPADE 25+ 1 VARIES - - - - - - - - - - - - - - - - - - - 1974 GIBSON CEMENT MIXER 25+ 1 2,000 - - - - 2,485 - - - - - - - - - - - - - - 156,222 1,137 529 5,857 5,302 73,727 - 13,183 63,151 27,126 - - - 1,574 17,373 - 12,041 17,717 10,949 - 1449 2010 TORO 47 GRANDSTAND MOWER (SPRD., VAC ) 10 1 17,500 - - 18,571 - - - - - 24,476 - - - - - - - - - 32,893 1491 2011 TORO 45 GROUNDSMASTER 360 (BLW, SWP, CAB) 10 1 37,916 - - - 45,744 - - - - - - - - 59,685 - - - - - - 1578 2016 TORO ZERO TURN MOWER 5000 MYRIDE 60" 15 1 25,000 - - - - - - - - - - - - 39,354 - - - - - - 1196 2001 DEWEZE 44 SLOPE MOWER 72LC 15 1 55,000 62,546 50,992 - - - - - - - - - - - - - - - 100,368 - 1606 2017 TORO 48 Z MASTER G3 MOWER 10 1 15,000 - - - - - - - - - - - - 23,612 - - - - - - 2014 TORO LAWN MOWER 10 1 500 - - - - - 640 - - - - - - - - - 860 - - - 2014 TORO LAWN MOWER 10 1 500 - - - - - 640 - - - - - - - - - 860 - - - 1999 JOHN DEERE 5'6" FLAIL MOWER (not replacing) 15 1 8,500 - - - - - - - - - - - - - - - - - - - 2005 HONDA PUSH MOWER 10 1 500 - - - - - - - - - - 742 - - - - - - - - 1975 JERRI JERRI SICLE MOWER 25+ 1 3,000 - - - - - - - 4,074 - - - - - - - - - - - 163,416 62,546 50,992 18,571 45,744 - 1,280 - 4,074 24,476 - 742 - 122,652 - - 1,720 - 100,368 32,893 1580 2016 GRACO LINELAZER FIELD PAINTER 10 1 15,000 - - - - - - - 20,368 - - - - - - - - - 27,373 - 1999 INFIELD BLUES BALL FIELD DRAG/SCARIFIER/GROOMER 15 1 4,000 - - 4,685 - - - - - - - - - 6,297 - - - - - - 1999 NEW STRIPE BALL/SOCCER FIELD LINE STRIPER 15 1 500 - - - - - - - - - - - 764 - - - - - - - 2000 INFIELD BLUES BALL FIELD DRAG (1) na 1 2,000 - - - - - - - - - - - - - - - - - - - 2002 RYAN SOD CUTTER 20 1 5,000 - - - 6,032 - - - - - - - - - - - - - - - 1999 JOHN DEERE 3 PT POST HOLE AUGER HAND (2) 15 1 2,000 - - - - - - - - - - - - - 3,243 - - - - - 2012 LAND PRIDE CA 1572 AIRATOR 10 1 2,500 - - - 3,016 - - - - - - - - - 4,053 - - - - - 1490 2012 LAND PRIDE OS 1548 SLIT SEEDER 10 1 8,171 - - - 9,857 - - - - - - - - - 13,248 - - - - - 39,171 - - 4,685 18,906 - - - 20,368 - - - 764 6,297 20,544 - - - 27,373 - 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Fleet Field Maintenance Mowers Heavy Equipment FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 3% AVERAGE 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 - 586 - - - - 679 - - - - 787 - - - - 912 - 1633 2018 ES1600 SNOWBLOWER 15 1 5,786 - - - - - - - - - - - - - - 9,663 - - - - NA TORO CCR POWERLITE 20" SNOWBLOWER 5 1 500 - - - - - 640 - - - - 742 - - - - 860 - - - NA MB MCD-WB WALK BEHIND BROOM 10 1 1,800 - - - - - - - - - - 2,671 - - - - 3,096 - - - NA STIHL KW 85 PADDLE BROOM 5 1 200 - - - - 249 - - - - 288 - - - - 334 - - - - NA JOHN DEERE ICE RINK BROOM 10 1 9,480 - - - - 11,780 - - - - - - - - - 15,832 - - - - 23,266 - - 586 - 12,029 640 - 679 - 288 3,413 - 787 - 25,829 3,956 - 912 - NA VARIOUS WEED WHIPS 5 4 VARIES - - 305 181 186 192 - 353 210 216 223 - 409 243 251 258 - 474 489 NA VARIOUS CHAIN SAWS 5 5 VARIES 284 - 586 724 870 283 330 679 839 1,008 419 382 787 973 1,169 721 443 912 940 NA STIHL LEAF BLOWERS 5 5 VARIES 227 - 234 241 311 256 264 272 280 360 297 306 315 324 418 344 354 365 376 NA STIHL BACKPACK LEAF BLOWERS 5 2 300 341 - - 362 - - 395 - 420 - - 458 - 486 - - 532 - - NA BROYHILL WEED SPRAYER 5 1 2,500 - - - - 3,107 - - - - 3,601 - - - - 4,175 - - - - NA EARTHWAY FERTILIZER SPREADER 5 1 400 455 - - - - - 527 - - - - 611 - - - - - - - NA VARIOUS EDGERS 5 3 VARIES - - 586 - 186 - - 679 - 216 - - 787 - 251 - - 912 940 NA VARIOUS TRIMMERS 5 4 VARIES 455 - 176 181 - - 527 204 210 - - 611 236 243 - - 709 274 282 NA STIHL FS 86 BRUSH CUTTER 5 1 200 - - - 241 - - - - 280 - - - - 324 - - - - - NA NA WHEEL BLOWER 5 1 275 - - - - 342 - - - - 396 - - - - 459 - - - - NA STIHL HT75 POLE PRUNER 14' 5 1 400 - - - - - 512 - - - - 594 - - - - 688 - - - NA SHOP MADE SIGN PAINTING TRAILER 10 2 1,500 1,706 - - - - - 1,977 - - - - 2,292 - - - - 2,658 - - NA NA TRAFFIC WARNING SIGNS 5 MLTP 2,000 - - 2,343 - - - - 2,716 - - - - 3,148 - - - - 3,650 3,759 NA NA TRAFFIC WARNING CONES 5 MLTP 500 - - - 603 - - - - 699 - - - - 811 - - - - - NA NA TRAFFIC WARNING BLINKER BARRICADE 5 MLTP 1,500 - - - - 1,864 - - - - 2,161 - - - - 2,505 - - - - NA NA TRAFFIC WARNING BARRICADES 5 MLTP 1,500 - - - - - 1,920 - - - - 2,226 - - - - 2,580 - - - NA NA EVENT BARRICADES 5 MLTP 1,500 - - - - - - - - - - - - - - - - - - - 18,535 3,468 - 4,228 2,534 6,866 3,162 4,021 4,902 2,937 7,959 3,758 4,661 5,683 3,405 9,227 4,592 4,695 6,588 6,785 TOTAL PARKS 67,151 51,521 33,927 123,760 92,621 5,082 17,204 141,426 54,539 8,247 63,555 5,425 136,992 97,259 35,055 22,309 22,412 223,748 39,679 FOOTNOTES - 410,185 440,463 (1) DUPLICATE REMOVED 67,151 33,927 123,760 92,621 5,082 17,204 141,426 54,539 8,247 63,555 5,425 (273,193) 97,259 35,055 22,309 22,412 223,748 (400,784) (2) NOT SCHEDULED FOR REPLACEMENT 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 2021 2020 Est. Actual 2020 2021 2022 2023 2024 2025-2030 2031-2036 SOURCES Park Dedication Fees 2,000$ 2,000$ 7,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ Donations - - - - - - - - Micellaneous Income 800 800 850 900 900 900 5,795 5,853 TOTAL 2,800$ 2,800$ 8,350$ 2,400$ 2,400$ 2,400$ 14,795$ 14,853$ USES Central Park 6,850 1,200 - - - - - - Emerald Park - 1,200 - - - - - - Salo Park - - - - - - - - Silver Point Park - 1,200 - - - - - - Trillium Park - - - - - - - - Water Tower Park - - - 170,000 - - - - TOTAL 6,850 3,600 - 170,000 - - - - NET CHANGE (4,050)$ (800)$ 8,350$ (167,600)$ 2,400$ 2,400$ 14,795$ 14,853$ BEGINNING CASH BALANCE 71,163 67,113 67,113 75,463 (92,137) (89,737) (87,337) (72,542) ENDING CASH BALANCE 67,113$ 66,313$ 75,463$ (92,137)$ (89,737)$ (87,337)$ (72,542)$ (57,689)$ PARK IMPROVEMENT 2021 - 2037 PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2020 Est Actual 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Central Park 2003 Park Amenities Signage -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Ballfields - multi-use 600 - - - - - - - - - - - - - - - - - - Ballfields - soccer 1,000 - - - - - - - - - - - - - - - - - - Batting Cages - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area - - - - - - - - - - - - - - - - - - - Play Equipment 1,200 - 1,200 - - - - - - - - - - - - - - - - Skateboard Park - 6,850 - - - - - - - - - - - - - - - - - Skating Rink - general - - - - - - - - - - - - - - - - - - - Skating Rink - hockey - - - - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - TOTAL 2,800$ 6,850$ 1,200$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Emerald Park 2009 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Ballfields - multi-use 300 - - - - - - - - - - - - - - - - - - Ballfields - soccer 600 - - - - - - - - - - - - - - - - - - Basketball Half-Court - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area - - - - - - - - - - - - - - - - - - - Play Equipment 1,200 - 1,200 - - - - - - - - - - - - - - - - Skating Rink - general - - - - - - - - - - - - - - - - - - - Skating Rink - hockey - - - - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Splash Pad/Shade Structures & Seating - - - - - - - - - - - - - - - - - - - TOTAL 2,100$ -$ 1,200$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Salo Park 2006 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Amphitheater - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2020 Est Actual 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Silver Point Park 1998 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Ballfields - multi-use - - - - - - - - - - - - - - - - - - - Basketball Full-Court - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area - - - - - - - - - - - - - - - - - - - Play Equipment 1,200 - 1,200 - - - - - - - - - - - - - - - - Skating Rink - general - - - - - - - - - - - - - - - - - - - Skating Rink - hockey - - - - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Drinking Fountains - - - - - - - - - - - - - - - - - - - New hockey rink - - - - - - - - - - - - - - - - - - - TOTAL 1,200$ -$ 1,200$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Trillium Park 1980 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Water Fountain - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Water Tower Park 2004 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Basketball Half-Court - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area - - - - - - - - - - - - - - - - - - - Play Equipment - - - - - - - - - - - - - - - - - - - Tennis Courts / Repairs Resurface - - - 170,000 - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ 170,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL PARK IMPROVEMENTS 6,100$ 6,850$ 3,600$ 170,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS Parks Park Amenities Amphitheater Ballfields - multi-use Ballfields - soccer Basketball Courts Batting Cages Off-Street Parking Picnic Area Play Equipment Shelter Skateboard Park Skating Rink - general Skating Rink - hockey Tennis Courts Walking Paths Splash Pads Central Park—2003 X X 1/2 X X X X X X X X X X Emerald Park —2009 X X 1/2 X X X X X X X X Salo Park—2006 X X Silver Point Park— 1998 X X X X X X X X X Trillium Park—1980 X Water Tower Park— 2004 X X X X X Fiscal Year 2021 SOURCES 2020 Est. Actual 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Interfund Loan collections (1)45,766 45,766 45,766 205,063 198,667 191,976 185,285 351,088 - Utility Fund Transfer (2)- - - - - 25,000 35,000 225,000 1,350,000 Connection fees 85,000 8,500 255,000 255,000 - - - - - Interest and other income 55,058 41,294 17,900 16,000 15,000 16,100 15,000 65,000 62,700 TOTAL 185,824$ 95,560$ 318,666$ 476,063$ 213,667$ 233,076$ 235,285$ 641,088$ 1,412,700$ USES Water Infrastructure 12,500 12,500 33,843 17,500 197,675 43,450 422,100 1,430,531 294,424 Water Equipment 2,232 - 40,212 905 191,933 2,200 43,781 31,830 394,415 Sewer Infrastructure 15,000 7,500 15,000 - - - 10,000 15,000 60,000 Sewer Equipment 382,232 400,562 5,073 905 1,933 2,200 43,781 31,830 1,063,697 Fiber Infrastructure 2,500 2,372 - 15,000 - - - 22,000 29,000 TOTAL 414,464$ 422,934$ 94,128$ 34,310$ 391,542$ 47,850$ 519,661$ 1,531,191$ 1,841,535$ NET CHANGE (228,640)$ (327,375)$ 224,538$ 441,753$ (177,875)$ 185,226$ (284,376)$ (890,103)$ (428,835)$ BEGINNING CASH BALANCE 2,827,586 2,827,586 2,500,212 2,724,750 3,166,502 2,988,628 3,173,854 2,889,478 1,999,376 ENDING CASH BALANCE 2,598,946$ 2,500,212$ 2,724,750$ 3,166,502$ 2,988,628$ 3,173,854$ 2,889,478$ 1,999,376$ 1,570,541$ (1) Principal collection of $959,326 estimated to begin 2022. (2) Utility Fund Transfer available after retirement of Water Bonds in 2024 UTILITIES INFRASTRUCTURE 2021 - 2037 UTILITES INFRASTRUCTURE PLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM 1.0609 1.092727 1.12550881 1.15927407 1.1940523 1.22987387 1.26677008 1.30477318 1.34391638 1.38423387 1.42576089 1.46853371 1.51258972 1.55796742 ASSET REPLACEMENT PRORGRAM DEPT PURPOSE DESCRIPTION 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Plant Facilities AOP Plant Electrical Panels serviced - placeholder - - - - - - - - - - - 175,000 - - - - - - - Peroxide Equipment - placeholders - - - - - - - - 25,000 - - - - - - 15,000 - - GAC / Iron plants (moved from Buildings CIP in 2017)- - - - - - - - - - - - - - - - - - - Metal Door Frame & Replacement - - - 15,000 - - - - - - - - - - - - - - - Security upgrades -Cameras - - - - - - - - - - - - - - 15,000 - - - - Security upgrades - Entrance controls / Fiber - - - - - - - - - - - - - - - - - - - Reznor Heating Units - - - - - - - - - 24,190 - - - - - - 27,000 - - Dehumidifier - - - - 102,500 - - - - - - - - - - - - - - Domestic Water Heaters - - - - - 3,450 - - - - - - - - - 5,000 - - - Dehumidifier - - - - - - - - 77,900 - - - - - - - - - - Boiler - - - - - - 27,600 - - - - - - - - - 29,000 - - Relamp & Reballast - - 5,343 - - - - - - - - - 7,000 - - - - - - Flow meters- GAC & Iron - - - - - - - - - - 18,492 - - - - - - 20,000 - Chorine booster pump -GAC - - - - 5,796 - - - - - - - 6,000 - - - - - - GAC Roof 2016 / Iron plant roof 2026/AOP roof 2041 - - - - - - - 95,000 - - - - - - - - - - - Production Well No. 3 Well casing - - - - - - - - 80,000 - - - - - - - - - - Well No. 3 Pump restoration - - - - - - - - - - 102,730 - - - - - - - Well No. 4 Pump restoration - - - - 86,878 - - - - - - - - - 108,894 - - - - Well No. 5 Pump restoration - - - - - - - - - 100,716 - - - - - - - - - Retro fit Well No. 5 for mobile Generator - - - - - - - - - - - - 300,000 - - - - - - Add permanent generator Well No. 4 - - - - - - - - - 275,000 - - - - - - - - - Central Park water re-use Done in 2018 - - - - - - - - - - - - - - - - - - 45,000 Wellhouse 3, 4, 5 maintenance, roofs in 2024 - - - - - 37,500 - - - - - - - - - - - - - Storage - Ground Storage and Tower Cleaning & Inspection - - 11,000 - - - 12,000 - - - - 13,500 - - - 14,500 - - - Tower Painting (last painted in 2000)- - - - - - 350,000 - - - - - - - - - - - - Distribution System - - Watermains (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - Meter reading software upgrade / Customer portal - - - - - - - - - - 80,000 - - - - - - - - Mandates - - Wellhead Protection Plan Documentation (MDHS)10,000 5,000 - - - - 30,000 - - - - 35,000 - - Water System Risk anaylsis and response plan due 6/30/21 7,500 15,000 Education/Public Awareness 1,000 - 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 Update Inventory of Potential Contamination Sources 1,000 - 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 1,001 1,001 Annual Well Sampling 500 - 500 500 500 500 500 500 500 500 500 501 502 503 503 503 503 503 503 12,500 12,500 33,843 17,500 197,675 43,450 422,100 97,500 185,400 402,406 203,722 226,001 315,502 2,505 126,399 22,005 73,505 22,505 47,505 Lift Stations Lift Stations - SCADA system/Fiber - - 15,000 - - - - - - - - - - - 60,000 - - - - Foss Road Lift Station Pump Replacement/re-hab 15,000 7,500 - - - - 10,000 - - - - - - - - - - - - Harding Lift Station Pump Replacement/re-hab - - - - - - - - 15,000 - - - - - - - - - - Collection System Collection System (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - 15,000 7,500 15,000 - - - 10,000 - 15,000 - - - - - 60,000 - - - - FIBER Backbone Fiber expansion from Fire Station to Central Park CARRY OVER FROM 20192,500 2,372 - - - - - - - - - - - - - - - - - Silver Point Park-2018 est 13K / Project date TBD - - - - - - - - - - - - - - - - - - - Regional SW Treatment-2018 est 23K / Project date TBD - - - - - - - - - - - - - - - - - - - Network switch City Hall - - - 15,000 - - - - - - 22,000 - - - - - 29,000 - - 2,500 2,372 - 15,000 - - - - - - 22,000 - - - - - 29,000 - - TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 30,000$ 22,372$ 48,843$ 32,500$ 197,675$ 43,450$ 432,100$ 97,500$ 200,400$ 402,406$ 225,722$ 226,001$ 315,502$ 2,505$ 186,399$ 22,005$ 102,505$ 22,505$ 47,505$ SEWER UTILITY WATER UTILITY UTILITES INFRASTRUCTURE EQUIPMENT ASSET REPLACEMENT PRORGRAM 1 1.03 1.0609 1.092727 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.3047732 1.3439164 1.3842339 1.4257609 1.4685337 1.5125897 1.137203227 1.1713193 1.206458904 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 FIXED ASSET # YEAR MAKE DESCRIPTION LIFE 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 1403 2006 SPRINTER 4 W WATER UTILITY VAN 15 - - 35,140 - - - - - - - - - - - 50,101 - - - - 1561 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 - - - - - - 68,224 - - - - - - - - - - 94,437 - - - 35,140 - - - 68,224 - 1,000 - - - - - 50,101 - - 94,437 - - 1438 1999 STERLING 19 S STERLING VACTOR/JETTER 15 380,000 400,562 - - - - - - - - - - - - - - 605,886 - - 1644 2018 FORD 15 D L8000 DUMP TRUCK 15-25 - - - - - - - - - - - - - - - - - - 384,110 2007 ZIEGLER CAT S 200KW - FOSS RD LS 25-30 - - - - - - - - - - - - - 113,497 - - - - - 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 - - - - 190,000 - - - - - - - - - - - - - - 1517 2013 CASE 590 D BACKHOE 20-25 - - - - - - - - - - - - - - 175,290 - - - - 380,000 400,562 - - 190,000 - - - - - - - - 113,497 175,290 - 605,886 - 384,110 1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 - - - - - - - - 6,993 - - - - - - - - - - 1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 - - - - - - - - 6,993 - - - - - - - - - - 1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 - - 1,288 - - - - 1,494 - - - - - - - - - 2,007 2,068 2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 - - - 1,810 - - - - 2,098 - - - - 2,432 2,505 - - - - EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 - - - 1,367 - - - - 1,585 - - - - - - - 2,007 - 1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 1,706 - 1,706 - - - 1,977 - - - - 2,292 - - - - - 2,737 - 1209 2005 INGERSOL RAND D ROTO HAMMER 10 - - - - - - - - - - 371 - - - - - - - - 1417 2005 HONDA D EG1500W GENERATOR 10 - - - - - - - - - - 742 - - - - - - - - EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 - - - - - 1,280 - - - - - 1,528 - - - - - - - EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 1,137 - 1,137 - - - 1,318 - - - - - 1,574 - - - - - - EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 1,621 - 2,343 - - - - - - - 2,968 - - - - 3,440 - - - EST 2005 NA D 12V POWER VENT 5-10 - - - - - 1,920 - - - - - 2,433 - - - - - - - 1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 - - - - - - - 2,037 - - - - - - 2,505 - - - - NEW D Transfered to 2018 street project fund)5-10 - - - - - - - - - - - - - - - - - - - 2018 HACH WATER TESTING EQUIPMENT 5-10 - - - - - - 4,542 - - - - - - 5,586 - - - - - EST 2005 STIHL D TS460 PARTNER SAW 5-10 - - 1,171 - - - - - - - 1,484 - - 1,001 1,001 - - - - 4,464 - 7,645 1,810 1,367 3,200 7,837 3,530 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - 6,752 2,068 2016 RTA D RTA FLEET SOFTWARE (SHOP) 15-20 - - - - - - 9,000 - - - - - - - - - - - - D NETWORK SWITCHES 7-10 - - - - - 1,200 - - - - - - 1,200 - - - - - - D COMPUTERS/PRINTERS 7-10 - - 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 - - - - - - - 20,368 - - - - - - - - - - - - 2,500 - 2,500 1,200 11,500 20,368 2,500 - 2,500 - 3,700 - 2,500 - 2,500 - 2,500 TOTAL UTILITY 384,464 400,562 45,285 1,810 193,867 4,400 87,561 23,899 19,584 1,585 8,064 6,254 5,274 122,515 233,902 3,440 608,386 101,189 388,678 EQUIPMENT SPECIFIC TO WATER 0 0 35,140 0 190,000 0 0 0 0 0 0 0 0 0 50,101 0 0 0 0 EQUIPMENT SPECIFIC TO SEWER 380,000 400,562 0 0 0 0 0 0 0 0 0 0 0 113,497 0 0 605,886 0 0 DUAL PURPOSE EQUIPMENT 4,464 0 10,145 1,810 3,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 9,019 183,802 3,440 2,500 101,189 388,678 384,464 400,562 45,285 1,810 193,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 122,515 233,902 3,440 608,386 101,189 388,678 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 Utilities Infrastructure 1953 Water Tower 2007 Foss Lift Station 2001 Harding Lift Station 1953 St. Anthony Water Treatment Facility, 1991 GAC, 2017 AOP Utilities Infrastructure 1957 Well #3 1959 Well #4 1961 Well #5 Utility Infrastructure FLEET 2020 Vactor/Jetter 2015 Ford F350 Utility 4x4 2004 Freightliner M2 Water Tanker/Flusher 2006 Sprinter Utility Van Utility Infrastructure HEAVY EQUIPMENT 1999 Onan 400K Gen Set 1992 Onan 375K Gen Set 1989 Sreco RSR-38TR Sewer Rodder 2013 Case 590 Loader/Backhoe Fiscal Year 2021 SOURCES 2020 EST. ACTUAL 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Stormwater fees UB 210,324$ 211,028$ 215,502$ 219,812$ 224,208$ 228,692$ 233,266$ 1,413,592$ 1,427,728$ Grants-Industrial Park Flooding (1)- - - 250,000 - - Grant-prior projects - 700 - - - - - - Interest 4,500 3,400 2,600 1,900 2,400 2,700 4,000 55,000 72,000 TOTAL 214,824$ 215,128$ 218,102$ 221,712$ 226,608$ 481,392$ 237,266$ 1,468,592$ 1,499,728$ USES Stormwater Maintenance -$ -$ 50,000$ -$ -$ -$ 45,000$ 110,000$ 280,000$ Flood Improvements (1)- - - - - 550,000 - - 750,000 Water Quality 53,104 65,677 293,825 34,985 66,183 37,422 38,702 336,631 765,218 Mandates 8,260 5,701 7,000 7,210 7,424 17,643 7,867 52,193 61,687 Annual Reconstruction - - - - - 75,000 75,000 450,000 450,000 TOTAL 61,364 71,378 350,825 42,195 73,608 680,065 166,569 948,823 2,306,905 NET CHANGE 153,460$ 143,750$ (132,723)$ 179,517$ 153,000$ (198,673)$ 70,697$ 519,769$ (807,176)$ BEGINNING CASH BALANCE 188,703 188,703 332,453 199,730 379,247 532,247 333,574 404,271 924,041 ENDING CASH BALANCE 342,163$ 332,453$ 199,730$ 379,247$ 532,247$ 333,574$ 404,271$ 924,041$ 116,864$ (1) Plan includes costs for expansion of exsisting ponding and future redevelopment placeholder $592,399.00 STORMWATER 2021 - 2037 STORMWATER CAPITAL PLAN Improvement Type Location Potential Financial Sources 2020 Est.Actual 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Stormwater Pond Maintenance Mirror Lake SAV - - - - - - - - - - - - - 150,000 - - - - - Silver Lake Ramsey, CH, SAV - - - - - - - - - - - - - - - - - - - Harding Pond SAV - - 50,000 - - - - - - - - 60,000 - - - - - - - Salo Pond SAV - - - - - - 45,000 - - - - - - - - 60,000 - - - Central Park Rain Garden SAV - - - - - - - 50,000 - - - - - - - - 70,000 - - - - 50,000 - - - 45,000 50,000 - - - 60,000 - 150,000 - 60,000 70,000 - - Flood Improvements Industrial Park Flood Improvements SAV/MWMO - - - - 550,000 - - - - - - - 750,000 - - - - - 550,000 - - - - - - - - - - - 750,000 - Water Quality Street Sweeper SAV - - 235,000 - - - - - - - - - - - - - - 350,000 - Salo Pond Treatment System SAV 20,529 46,986 24,000 24,960 25,958 26,997 28,077 29,200 30,368 31,582 32,846 34,159 35,526 36,947 38,425 39,962 41,560 43,223 44,952 Regional Stormwater Treatment system MWMO 1,575 1,575 1,575 1,675 1,775 1,875 1,975 2,075 2,175 2,275 2,375 2,475 2,575 2,675 2,775 2,875 2,975 3,075 3,175 Clean Streets maintenance costs SAV 6,000 13,912 8,250 8,350 8,450 8,550 8,650 8,750 8,850 8,950 9,050 9,150 9,250 9,350 9,450 9,550 9,650 9,750 9,850 Silver Lake Delisting / Weed mgmt CO-OP - - - - - - - - - - - - - - - - - - - Water Re-use Maintenance SAV 25,000 3,204 25,000 - 30,000 - - 35,000 - - 40,000 - - 45,000 - - 50,000 - - 53,104 65,677 293,825 34,985 66,183 37,422 38,702 75,025 41,393 42,807 84,271 45,784 47,351 93,972 50,650 52,387 104,185 406,048 57,977 Mandates SWIPP Stormwater Management Plan update SAV - - - - - 10,000 - - - - - - - - - - - - - MS4 MS4-Engineer costs SAV 1,560 3,200 2,750 2,860 2,974 3,093 3,217 3,346 3,480 3,619 3,764 3,914 4,071 4,233 4,403 4,579 4,762 4,953 5,151 Internal SW Education / Green Step Program SAV 6,700 2,500 4,250 4,350 4,450 4,550 4,650 4,750 4,850 4,950 5,050 5,150 5,250 5,350 5,450 5,550 5,650 5,750 5,850 8,260 5,701 7,000 7,210 7,424 17,643 7,867 8,096 8,330 8,569 8,814 9,064 9,321 9,583 9,854 10,130 10,413 10,704 11,003 Annual Reconstruction (1) Internal use for debt levy reduction - - - - - - - - - - - - - - - - - - - Contribution to streets reconstruction 2024-2037 - - - - - 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 - - - - - 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 TOTAL STORMWATER CAPITAL PLAN 61,364 71,378 350,825 42,195 73,608 680,065 166,569 208,120 124,722 126,376 168,084 189,849 131,672 328,555 135,504 197,517 259,598 1,241,751 143,979 (1) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan Stormwater Retention 2004-2005 Salo Pond North 2004-2005 Salo Pond South 2003 Harding Pond 1962 Mirror Lake Stormwater Treatment Systems 2015 Silver Lake Stormwater Treatment Facility at Salo Pond 2016 St. Anthony Regional Stormwater Treatment System 2014 Central Park Rain Garden Stormwater Reuse 2008 Water Reuse Fountain Stormwater Equipment 2006 Elgin Pelican Street Sweeper Fiscal Year 2021 SOURCES 2020 Est. Actual 2020 2021 2022 2023 2024 2025 2026-2031 2032-2037 Bond Proceeds 2,930,000$ 3,101,806$ 1,829,000$ 1,693,000$ 2,005,000$ 2,107,000$ 2,381,000$ 16,264,000$ 4,314,000$ Road Improvement Levy (1)1,927,203 1,927,203 1,913,699 2,029,468 2,029,468 2,029,468 1,807,770 14,939,066 14,993,908 Prepaid Assessments - - 225,307 161,421 320,274 244,167 198,194 1,741,049 398,631 MSA Funds 1,000,000 1,042,585 - - - - - - - Grant Funding - - - - - - - - - Debt Levy Reduction Funding 331,490 331,490 475,821 257,222 178,931 3,756 3,520 - - Infrastructure levy - - - - - - - - - Miscellaneous - - - - - - - - - TOTAL 6,188,693$ 6,403,084$ 4,443,827$ 4,141,110$ 4,533,672$ 4,384,391$ 4,390,483$ 32,944,115$ 19,706,539$ USES Streets/Utilities Reconstruction 2,580,000$ 2,211,938$ 2,672,080$ 1,884,057$ 2,202,190$ 2,175,346$ 2,459,213$ 16,948,071 3,452,800 Sidewalks/Street Lights - - - - - - - 291,841 1,923,509 Road Improvement debt 2,258,693 2,258,693 2,389,519 2,286,689 2,208,399 2,033,224 1,811,290 14,939,066 14,993,908 Miscellaneous - - - - - - - - - TOTAL 4,838,693$ 4,470,631$ 5,061,599$ 4,170,746$ 4,410,588$ 4,208,569$ 4,270,503$ 32,178,978$ 20,370,217$ NET CHANGE 1,350,000$ 1,932,453$ (617,772)$ (29,636)$ 123,084$ 175,821$ 119,980$ 765,137$ (663,678)$ BEGINNING ACTIVITY - 1,932,453 1,314,681 1,285,045 1,408,129 1,583,950 1,703,930 2,469,067 CUMULATIVE ACTIVITY 1,350,000$ 1,932,453$ 1,314,681$ 1,285,045$ 1,408,129$ 1,583,950$ 1,703,930$ 2,469,067$ 1,805,389$ (1) PER 2021 DEBT LEVY PROGRAM SEE EXHIBIT C STREETS IMPROVEMENT PLAN 2021 - 2037 STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2020 Est. Actual 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Annual Street / Utility Program SEE EXHIBT A FOR DETAIL OF TYPE OF IMPROVEMENTS BY YEAR, 2019 Debt Levy/Assmts/Grants & Aids 1,180,000 236,000 236,000 - - - - - - - SEE EXHBIT B FOR STREET MAP FOR YEAR OF STREET IMPROVEMENT 2020 Debt Levy/Assmts/Grants & Aids 2,930,000 2,344,000 1,975,938 1,054,062 - - - - - - 2021 Debt Levy/Assmts/Grants & Aids 2,022,522 - - 1,618,018 404,504 - - - - - - - - - - - - - 2022 Debt Levy/Assmts/Grants & Aids 1,849,440 - - - 1,479,552 369,888 - - - - - - - - - - - - 2023 Debt Levy/Assmts/Grants & Aids 2,290,377 - - - - 1,832,302 458,075 - - - - - - - - - - - 2024 Debt Levy/Assmts/Grants & Aids 2,146,588 - - - - - 1,717,271 429,318 - - - - - - - - - - 2025 Debt Levy/Assmts/Grants & Aids 2,537,370 - - - - - - 2,029,896 507,474 - - - - - - - - - 2026 Debt Levy/Assmts/Grants & Aids 2,539,892 - - - - - - - 2,031,913 507,978 - - - - - - - - 2027 Debt Levy/Assmts/Grants & Aids 2,570,781 - - - - - - - - 2,056,625 514,156 - - - - - - - - 2028 Debt Levy/Assmts/Grants & Aids 3,995,020 - - - - - - - - - 3,196,016 799,004 - - - - - - - - 2029 Debt Levy/Assmts/Grants & Aids 2,898,888 - - - - - - - - - - 2,319,111 579,778 - - - - - - - 2030 Debt Levy/Assmts/Grants & Aids 3,004,817 - - - - - - 2,403,853 600,963 - - - - - - 2031 SPECIFIC STREETS TBD 1,789,000 - - - - - - - 1,431,200 357,800 - - - - - 2032 SPECIFIC STREETS TBD 1,532,000 - - - - - - - - 1,225,600 306,400 - - - - 2033 SPECIFIC STREETS TBD 717,000 - - - - - - - - - 573,600 143,400 - - - 2034 SPECIFIC STREETS TBD 846,000 - - - - - - - - - - 676,800 169,200 - - TOTAL 29,599,078 2,580,000 2,211,938 2,672,080 1,884,057 2,202,190 2,175,346 2,459,213 2,539,387 2,564,603 3,710,172 3,118,114 2,983,631 2,032,163 1,583,400 880,000 820,200 169,200 - - Sidewalks / Intersections / Signals / Lighting Sidewalk / Lighting Stinson South of 37th Debt Levy 299,785 - - - - - - - - - - - - - - 401,400 222,355 - - - Sidewalk / Lighting Stinson Boulevard South of 33rd Debt Levy 374,731 - - - - - - - - - - - - - - - - - 294,871 303,717 Street lighting 37th Avenue NE (County Road D) Debt Levy 327,890 - - - - - - - - - - - - 291,841 200,398 - - - - - Street lighting 33rd Avenue NE (County Road C2) Debt Levy 368,876 - - - - - - - - - - - - - - - - 500,768 - - TOTAL SIDEWALKS/LIGHTING ETC.1,371,282 - - - - - - - - - - - - 291,841 200,398 401,400 222,355 500,768 294,871 303,717 TOTAL STREETS IMPROVEMENT PLAN 30,970,360 2,580,000 2,211,938 2,672,080 1,884,057 2,202,190 2,175,346 2,459,213 2,539,387 2,564,603 3,710,172 3,118,114 2,983,631 2,324,005 1,783,798 1,281,400 1,042,555 669,968 294,871 303,717 ANNUAL STREET PROGRAM DETAILED COSTS EXHIBIT A INITIAL INITIAL INITIAL Revised Revised Revised Previously Year Road From To Street Length Improvement COST PER FT Cost Est inflation inflation COST PER FT Cost Est Assessments net city cost PP SA Bond size Bond A/R SA 2021 Skycroft Drive 33rd Avenue 32nd Avenue 630 Reconstruct 855.72 539,106 855.72 539,106 139,435 399,671 41,831 497,276 751,025 Total assessed 592390 158,635 2021 Croft Drive 33rd Avenue 32nd Avenue 630 Reconstruct 855.72 539,106 855.72 539,106 139,435 399,671 41,831 497,276 225,307 PP Sa 2021 29th Avenue Stinson Boulevard Silver Lake Road 2260 Mill / Overlay 174.33 393,975 174.33 393,975 196,987 196,987 59,096 334,879 1,829,000 2021 St. Anthony Boulevard Stinson Boulevard Kenzie Terrace 2230 Mill / Overlay 145.27 323,954 145.27 323,954 161,977 161,977 48,593 275,361 1,828,666 525,717 Bond size / bond sa 2021 2021 31st Avenue Rankin Road Croft Drive 840 Mill / Overlay 121.06 101,690 121.06 101,690 50,845 50,845 15,253 86,436 2,022,522 total cost 2347900 325,378 2021 Croft Drive Rankin Road 31st Avenue 1030 Mill / Overlay 121.06 124,691 121.06 124,691 62,345 62,345 18,704 105,987 0 429%2533500 484,013 2022 Rankin Road 31st Avenue 33rd Avenue 1310 Reconstruct 959.03 1,256,336 12%NA 959.03 1,256,336 217,286 1,039,049 65,186 1,191,150 538,069 Total assessed 2021 2022 East Gate Road Crestview Drive Rankin Road 360 Mill / Overlay 121.06 43,581 0%5%127.11 45,760 21,791 21,791 6,537 37,044 161,421 PP Sa 2021 2022 Crest View Drive 29th Avenue 31st Avenue 1490 Mill / Overlay 121.06 180,378 0%5%127.11 189,397 90,189 90,189 27,057 153,321 1,693,000 2021 2022 Bell Lane Armour Terrace Crestview Drive 660 Mill / Overlay 121.06 79,899 0%5%127.11 83,894 39,950 39,950 11,985 67,914 $1,692,370.30 376,648 Bond size / bond sa 2022 2021 2022 Armour Terrace Silver Lake Road Crestview Drive 1580 Mill / Overlay 121.06 191,273 0%5%127.11 200,837 95,637 95,637 28,691 162,582 2022 Alley (south of 29th)29th Avenue Alley (west of Roosevelt)350 Mill / Overlay 72.64 25,422 0%5%76.27 26,694 26,694 - 8,008 18,685 1,849,440 total cost 2022 Alley (west of Roosevelt)Roosevelt Street West Terminus 310 Mill / Overlay 72.64 22,517 0%5%76.27 23,643 23,643 - 7,093 16,550 0 429% 2022 Alley (south of 29th)29th Avenue Murray Avenue 300 Mill / Overlay 72.64 44,308 0%5%76.27 22,880 22,880 - 6,864 16,016 2022 2023 Townview Avenue Silver Lake Road Rankin Road 1280 Reconstruct 959.03 1,227,564 0%5%1,006.99 1,288,943 435,851 853,092 130,755 1,158,188 1,067,580 Total assessed 2023 Alley (south of Pahl)Roosevelt Street Wilson Street 760 Mill / Overlay 101.69 77,284 0%5%112.11 85,206 85,206 - 25,562 59,644 320,274 PP Sa 2023 Alley (north of Pahl)Roosevelt Street Wilson Street 770 Mill / Overlay 101.69 78,301 0%5%112.11 86,327 86,327 - 25,898 60,429 2023 Alley (south of Pahl)Wilson Street 27th Avenue 480 Mill / Overlay 72.64 34,865 0%5%80.08 38,439 38,439 - 11,532 26,907 2,005,000 2023 Alley (north of Pahl)Wilson Street 27th Avenue 650 Mill / Overlay 72.64 47,213 0%5%80.08 52,052 52,052 - 15,616 36,437 $2,004,580.12 747,306 Bond size / bond sa 2023 2022 2023 Roosevelt Street 35th Street County Road D 1560 Mill / Overlay 121.06 188,852 0%5%133.47 208,210 104,105 104,105 31,231 176,978 2022 2023 35th Street Stinson Boulevard Belden Drive 1290 Mill / Overlay 121.06 156,166 0%5%133.47 172,173 86,087 86,087 25,826 146,347 2,290,377 total cost 2022 2023 Roosevelt Street 34th Avenue 35th Avenue 630 Mill / Overlay 121.06 76,267 0%5%133.47 84,085 42,042 42,042 12,613 71,472 0 429% 2022 2023 Edward Street 34th Avenue 35th Avenue 630 Mill / Overlay 121.06 76,267 0%5%133.47 84,085 42,042 42,042 12,613 71,472 2022 2023 Harding Street 34th Avenue 36th Avenue 1430 Mill / Overlay 121.06 173,115 0%5%133.47 190,859 95,429 95,429 28,629 162,230 2021 2024 31st Avenue Silver Lake Road Rankin Road 1280 Reconstruct 855.72 1,095,327 -11%5%1,057.34 1,353,390 417,292 936,098 125,188 1,228,202 813,891 Total assessed 2023 2024 30th Avenue Wilson Street Silver Lake Road 1270 Mill / Overlay 121.06 153,745 0%5%140.14 177,979 88,990 88,990 26,697 151,282 244,167 PP Sa 2023 2024 W Armour Terrace Roosevelt Street Silver Lake Road 1840 Mill / Overlay 121.06 222,749 0%5%140.14 257,860 128,930 128,930 38,679 219,181 2,107,000 2023 2024 Wilson Street 29th Avenue 30th Avenue 630 Mill / Overlay 121.06 76,267 0%5%140.14 88,289 44,144 44,144 13,243 75,046 $2,106,931.07 569,724 Bond size / bond sa 2024 2023 2024 Wilson Street 27th Avenue 29th Avenue 1310 Mill / Overlay 121.06 158,587 0%5%140.14 183,585 91,792 91,792 27,538 156,047 2,146,588 total cost 2023 2024 Pahl Avenue Wilson Street Coolidge Street 610 Mill / Overlay 121.06 73,846 0%5%140.14 85,486 42,743 42,743 12,823 72,663 0 429% 2023 2025 Rankin Road CR 88 31st Avenue 1310 Reconstruct 1,419.77 1,859,900 66%?1,419.77 1,859,900 321,911 1,537,989 96,573 1,763,327 660,646 Total assessed 2025 29th Avenue Silver Lake Road Rankin Road 1290 Mill / Overlay 193.69 249,866 -77%5%235.44 303,714 151,857 151,857 45,557 258,157 2,381,000 198,194 PP Sa 2025 Hilldale Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 121.06 153,745 0%5%147.15 186,878 93,439 93,439 28,032 158,846 $2,380,111.68 462,452 Bond size / bond sa 2025 2025 32nd Avenue Silver Lake Road Rankin Road 1270 Mill / Overlay 121.06 153,745 0%5%147.15 186,878 93,439 93,439 28,032 158,846 2,537,370 total cost 0 429% 2024 2026 Macalaster Drive 39th Avenue Silver Lane 1260 Reconstruct 919.30 1,158,324 7%5%1,165.71 1,468,798 338,006 1,130,792 101,402 1,367,396 786,125 Total assessed 2024 2026 Macalaster Drive South terminus 39th Avenue 500 Reconstruct 919.30 459,652 7%5%1,165.71 582,856 204,000 378,857 61,200 521,656 235,837 PP Sa 2026 Wilson Street 30th Avenue 31st Avenue 630 Mill / Overlay 121.06 76,267 0%5%154.51 97,338 48,669 48,669 14,601 111,939 2,494,000 2026 Harding Street 30th Avenue 31st Avenue 630 Mill / Overlay 121.06 76,267 0%5%154.51 97,338 48,669 48,669 14,601 111,939 $2,493,409.75 550,287 Bond size / bond sa 2026 2026 Edward Street 33rd Avenue 34th Avenue 620 Mill / Overlay 121.06 75,057 0%5%154.51 95,793 47,897 47,897 14,369 110,162 2,539,892 total cost 2026 Belden Drive 33rd Avenue 34th Avenue 1280 Mill / Overlay 121.06 154,956 0%5%154.51 197,767 98,884 98,884 29,665 227,432 0 429% 2024 2027 Penrod Lane 39th Avenue Silver Lane 1260 Reconstruct 919.30 1,158,324 0%5%1,224.00 1,542,238 514,615 1,027,623 154,384 1,387,854 1,028,886 Total assessed 2024 2027 34th Avenue Stinson Boulevard Silver Lake Road 2200 Mill / Overlay 121.06 266,330 0%5%162.23 356,908 178,454 178,454 53,536 410,444 308,666 PP Sa 2024 2027 Hilldale Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 121.06 133,165 0%5%162.23 178,454 89,227 89,227 26,768 205,222 2,616,000 2024 2027 32nd Avenue Belden Drive Silver Lake Road 1100 Mill / Overlay 121.06 133,165 0%5%162.23 178,454 89,227 89,227 26,768 205,222 $2,615,664.96 720,220 Bond size / bond sa 2027 2024 2027 Townview Avenue Wilson Street Silver Lake Road 1290 Mill / Overlay 121.06 156,166 0%5%162.23 209,278 104,639 104,639 31,392 240,669 2,570,781 total cost 2024 2027 Belden Drive 32nd Avenue 33rd Avenue 650 Mill / Overlay 121.06 78,688 0%5%162.23 105,450 52,725 52,725 15,818 121,268 0 429% 2025 2028 Shamrock Drive 39th Avenue Silver Lane 1260 Reconstruct 1,018.13 1,282,850 11%5%1,285.20 1,619,350 391,285 1,228,065 117,385 1,501,964 1,336,807 Total assessed 2025 2028 Fordham Drive 39th Avenue Silver Lane 1260 Reconstruct 1,018.13 1,282,850 11%5%1,285.20 1,619,350 567,363 1,051,987 170,209 1,449,141 401,042 PP Sa 2025 2028 30th Avenue Stinson Boulevard Wilson Street 960 Mill / Overlay 121.06 116,217 0% 5% 170.34 163,529 81,764 81,764 24,529 138,999 3,657,000 2025 2028 Roosevelt Street St. Anthony Boulevard 30th Avenue 1210 Mill / Overlay 121.06 146,482 0%5%170.34 206,114 103,057 103,057 30,917 175,197 $3,656,871.94 935,765 Bond size / bond sa 2028 2025 2028 Murray Avenue Roosevelt Street Wilson Street 830 Mill / Overlay 121.06 100,479 0%5%170.34 141,384 70,692 70,692 21,208 120,177 3,995,020 total cost 2025 2028 Murray Avenue Wilson Street Coolidge Street 710 Mill / Overlay 121.06 85,952 0%5%170.34 120,943 60,472 60,472 18,141 102,802 0.33 429% 2025 2028 Coolidge Street St. Anthony Boulevard 29th Avenue 730 Mill / Overlay 121.06 88,373 0%5%170.34 124,350 62,175 62,175 18,652 105,697 2027 2029 Skycroft Circle Skycroft Drive Skycroft Drive 1550 Reconstruct 947.20 1,468,164 -7%5%1,349.46 2,091,660 698,443 1,393,217 209,533 1,882,127 993,774 Total assessed 2027 2029 34th Avenue Skycroft Drive Croft Drive 300 Reconstruct 915.63 274,689 5%302,844 43,139 259,705 12,942 289,903 298,132 PP Sa 2026 2029 Pahl Avenue Roosevelt Street Wilson Street 720 Mill / Overlay 121.06 87,163 0%5%178.86 128,779 64,389 64,389 19,317 109,462 2,647,000 2026 2029 Roosevelt Street 27th Avenue Pahl Avenue 550 Mill / Overlay 121.06 66,583 0%5%178.86 98,373 49,186 49,186 14,756 83,617 $2,646,269.15 695,642 Bond size / bond sa 2029 2026 2029 27th Avenue Sinson Boulevard Pahl Avenue 1550 Mill / Overlay 121.06 187,642 0%5%178.86 277,232 138,616 138,616 41,585 235,647 2,898,888 total cost 2026 2030 Skycroft Drive Maplewood Drive 33rd Avenue 1560 Reconstruct 1,028.44 1,604,373 1%5%1,416.93 2,210,413 611,497 1,598,915 183,449 2,026,963 1,008,699 Total assessed 2027 2030 39th Avenue Stinson Blvd Silver Lake Road 2200 Mill / Overlay 213.06 468,741 0%5%187.80 413,165 206,583 206,583 61,975 351,190 302,610 PP Sa 2027 2030 Roosevelt Street 33rd Avenue north terminus 340 Mill / Overlay 121.06 41,160 0%5%187.80 63,853 31,926 31,926 9,578 54,275 2,750,000 2027 2030 Roosevelt Street 31st Street 33rd Avenue 1290 Mill / Overlay 121.06 156,166 0%5%187.80 242,265 121,133 121,133 36,340 205,925 $2,749,495.51 706,090 Bond size / bond sa 2030 2027 2030 Anthony Road Roosevelt Street Edward Street 400 Mill / Overlay 121.06 48,424 0%5%187.80 75,121 37,560 37,560 11,268 63,853 3,004,817 total cost 0 429% Silver Lake 36THAVE N E 32NDAVE N E 33RD AVE N E 33RD AVE N E 33RD AVE N E 33RD AVE N E 34TH AVE N E 34TH AVE N E STINSON PKWY N ESILVER LNLOWRYAVE N E 26THAVEN E CO RDNO 88SILVERLAKE RDSILVERLAKE RD16THAVE SW SILVER LAKE RDSILVER LAKE RD39TH AVE NE 39TH AVE NE 39TH AVE NE HIGHCREST RDPINE ASH LOWRYGROVECEDAR DIAMONDEIGHTTERSILVERLAKE CTSILVER LN ROZELLEDRCHANDLER DRSKYCROFTDR COOLIDGE ST N EIRONWOOD 32ND AVE N E 32NDAVE N E 32ND AVE N E LOWRYAVE N E ELM FOSS RD ROOSEVELTST N ESI L V E R LA K E TE R PA H L AV E CRESTVIEW DRROOSEVELTST N EFORDHAMCT NEMAPLEWOODDROLD H W Y 8 WILSON ST N ESTINSON BLVD NEELM FOSS RDFOSS RDFOSS RDGUM PENROD LACHELMSFORD RDHIGHCREST RDHIGHCREST RDLOWRYAVE N E 34THAVE N 35THAVE N E 35TH AVE N E ANTHONY LA SANTHONY LA SROOSEVELTCT N ESILVER LAKE RDSILVER LAKE RDSILVER LAKE RDSILVER LAKE RDSILVER LAKE RDRANKIN RDRANKIN RDWILSON ST N EWILSON ST N EANTHONYLA SSILVER LN SILVER LNLOCUST MAPLEWOOD DR OAK EASTGATE R D DOWNERS DRAPACHELANE EST ANTHONY RD MACALASTER DRKENZIE TERKENZIE TERKENZIETERARMOUR TER27THAVE N E 27TH AVE N E PENTA G O N D R 30TH AVE N E 30TH AVE N E ST ANTHONY BLVD ST A N T H O N Y B L V D S T A N T H O N Y B L V D ARMOUR TER W STINSON BLVD N ESTINSONBLVD N ESTINSON BLVD N ESTINSON BLVD N E38TH AVE NE PAHL AVE FRONTAGE RDHARDINGST N EROOSEVELT ST N EROOSEVELTST N E29TH AVE N E 29TH AVE N E 29TH AVE N E 29TH AVE N E 37TH AVE NE 37TH AVE NE 37TH AVE NE 37TH AVE NE CROFT DREDWARD ST N EEDWARD ST N EEDWARD ST N ECOOLIDGE ST N ECOOLIDGE ST N ESKYCROFT DRHARDING ST N EHARDING ST N ECROFT DRBELL LA MURRAY AVE SKYCROFTCIRBELDEN DRBELDEN DR BELDEN DRBELDEN DRFORDHAM DRANTHONY LA31ST AVE N E 31ST AVE N E 31ST AVE N E 31ST AVE N EROOSEVELT ST N E36TH AVE N E 36THAVE N E 36TH AVE N E 36TH AVE N E HCRRA CORRIDORHCRRA CORRID O RCROFT DROLD HWY 8OLD HWY 8OLD HWY 8HIGHWAY NO 88HIGHWAY NO 88HIGHWAY NO 88HIGHWAY NO 88HILLDALE AVE N E HILLDALE AVE N EPENROD LNSHAMROCK DRTOWNVIEW AVE TOWNVIEW AVE 37THAVE N E 37THAVE N E EDGEMERE AVE WENDHURST AVE SKYCROFT DR SKYCROFT DR1 inch = 750 feet Document Path: K:\013266-000\GIS\Maps\CIP_ProjectMapUpdated.mxd Date Saved: 3/13/2020 4:36:28 PMProject Location Map (March 2020) Street & Utility CIP for 2020 and Beyond St. Anthony, MN City BoundaryStreet & UtilityReconstruction Program 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Mill & Overlay Program2021202220232024202520262027 2028 2029 2030 0 750Feet¯Exhibit B 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 2021 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 520 - - 118,685 118,930 119,176 119,120 119,063 118,523 117,984 117,082 115,939 119,864 118,133 116,402 119,133 116,476 119,070 - $2,230,000 - 2014A 522 - - - 157,629 155,848 159,318 157,433 155,548 153,663 157,028 154,896 151,488 153,330 155,015 151,292 152,820 154,190 154,914 $2,580,000 - 2015A 524 - - - - 185,075 182,847 185,869 183,537 186,454 184,016 186,829 184,286 186,993 183,886 186,029 182,331 183,884 184,819 185,111 $1,455,000 - 2016A 526 102,173 106,135 104,742 103,349 101,956 105,813 104,315 102,817 106,568 104,965 103,362 107,009 105,025 103,042 105,757 $2,600,000 - 2017A 528 189,734 191,592 193,296 189,591 191,136 192,523 193,753 189,575 190,647 191,562 192,320 192,919 193,362 193,646 193,774 $2,610,000 - 2018A 530 179,849 180,959 181,859 177,298 177,998 178,467 178,737 178,797 180,484 176,764 178,294 179,666 180,382 180,927 181,302 $1,145,000 - 2019A 532 103,950 101,430 104,160 101,430 103,950 101,010 103,320 100,170 103,058 100,537 103,268 100,590 103,162 100,328 102,742 $3,000,000 - 2020A 534 235,830 237,644 232,600 232,806 232,856 232,747 237,731 237,150 236,412 232,471 233,780 234,984 236,083 237,077 232,715 (13,145) 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,175,856 1,999,903 1,831,636 1,640,254 1,528,411 1,404,969 1,273,445 1,152,920 996,920 814,155 712,847 517,713 339,819 232,715 (13,145) - - - - 2021 Road Improvements Bonds $1,829,000 - 2021A 2021A - 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 110,834 2022-2030 Road Improvements Bonds $1,693,000 - 2022A 2022A 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 141,509 $2,005,000 - 2023A 2023A 111,050 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 $2,107,000 - 2024A 2024A 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 155,190 $2,381,000 - 2025A 2025A 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 197,282 $2,494,000 - 2026A 2026A 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 186,707 $2,616,000 - 2027A 2027A 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 224,734 $3,657,000 - 2028A 2028A 255,028 255,028 255,028 255,028 255,028 255,028 255,028 255,028 255,028 255,028 255,028 255,028 $2,647,000 - 2029A 2029A 194,451 194,451 194,451 194,451 194,451 194,451 194,451 194,451 194,451 194,451 194,451 $2,750,000 - 2030A 2030A 207,803 207,803 207,803 207,803 207,803 207,803 207,803 207,803 207,803 207,803 2031-2034 Road Improvements Bonds $2,100,000- 2031A 2031 144,629 144,629 144,629 144,629 144,629 144,629 144,629 144,629 144,629 $1,742,000 - 2032A 2032 107,545 107,545 107,545 107,545 107,545 107,545 107,545 107,545 $1,227,000 - 2033A 2033 72,893 100,393 100,393 100,393 100,393 100,393 100,393 $1,345,000- 2034A 2034 127,966 210,467 210,467 210,467 210,467 210,467 Additional levy - - - - - - - - - - 110,834 252,343 363,393 565,048 762,330 949,038 1,173,772 1,428,800 1,623,251 1,831,054 1,975,683 2,083,228 2,156,120 2,311,586 2,394,088 2,283,254 2,141,744 1,984,230 1,829,040 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,286,689 2,252,246 2,195,029 2,205,302 2,290,741 2,354,007 2,447,217 2,581,720 2,620,171 2,645,209 2,688,530 2,600,941 2,495,939 2,544,301 2,380,943 2,283,254 2,141,744 1,984,230 1,829,040 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) (90,000) (115,000) - - - - - - - - - - - - - - - - - Excess Bond Balance (115,000) (101,921) (92,500) (140,000) (140,009) (215,310) (354,300) (163,115) (60,000) - - - - - - - - - - - - - - - - - Conduit Fee/Refunding & Project savings (15,079) (116,180) (79,792) (4,107) (3,931) (3,756) (3,520) - - - - - - - - - - - - - - - Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (75,000) (70,000) (75,000) (85,000) - - - - - - - - - - - - - - - - - Infrastructure Levy - - - 221,698 348,215 355,645 292,379 199,169 64,666 26,215 - - - - - - - - - - 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,954,468 1,988,315 2,412,971 2,549,997 2,646,386 2,646,386 2,646,386 2,646,386 2,646,386 2,645,209 2,688,530 2,600,941 2,495,939 2,544,301 2,380,943 2,283,254 2,141,744 1,984,230 1,829,040 1,913,699 2,029,468 2,073,315 2,412,971 2,549,997 2,646,386 2,646,386 2,646,386 2,646,386 2,646,386 2,645,209 2,688,530 2,600,941 2,495,939 2,544,301 2,380,943 2,283,254 % Increase in Road levy 5.09% 12.64% 0.85% 2.07% -2.00% -0.77% 4.30% -0.14% -0.46% 6.01% 1.73% 21.36% 5.68% 3.78% 0.00% 0.00% 0.00% 0.00% -0.04% 1.64% -3.26% -4.04% 1.94% -6.42% -4.10% -6.20% -7.35% -7.82% $ Increase in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 76,455 (2,682) (8,505) 110,769 33,848 424,656 137,025 96,390 (0) (0) 0 0 (1,177) 43,321 (87,589) (105,001) 48,362 (163,359) (97,689) (141,509) (157,514) (155,190) TAX ABATEMENT (2016B/2017A) 149,395 146,480 151,025 153,148 155,112 224,877 227,430 222,653 228,375 228,585 228,638 233,782 233,415 96,390 - - - - - - - - - - - - - - - PUBLIC FACILITIES (Refunded 2012A) 409,773 379,197 378,462 382,872 387,322 396,207 399,882 403,347 406,602 414,897 422,683 424,289 - - - - - - - - - - - - - - - - - 559,168 525,677 529,487 536,020 542,434 621,084 627,312 626,000 634,977 643,482 651,321 658,071 233,415 96,390 - - - - - - - - - - - - - - - FLATL LINE 2,854,932 Total debt levied after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,480,886 2,487,181 2,487,181 2,605,789 2,646,386 2,646,386 2,646,387 2,646,386 2,646,386 2,646,386 2,646,386 2,646,386 2,645,209 2,688,530 2,600,941 2,495,939 2,544,301 2,380,943 2,283,254 2,141,744 1,984,230 1,829,040 (0) (0) 0 0 0 (0) (0) (1,177) 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,938,010 2,910,317 2,428,444 2,301,692 2,290,741 2,354,007 2,447,217 2,581,720 2,620,171 2,645,209 2,688,530 2,600,941 2,495,939 2,544,301 2,380,943 2,283,254 2,141,744 1,984,230 1,829,040 % Increase in Debt Levied 2.08% 9.66% 0.94% 1.87% 1.77% -0.31% 3.12% 0.25% 0.00% 4.77% 1.56% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -0.04% 1.64% -3.26% -4.04% 1.94% -6.42% -4.10% -6.20% -7.35% -7.82% % Increase in Debt Scheduled to be levied 2.08% 10.38% 6.64% 8.00% 3.84% 3.17% 1.91% -0.85% 4.82% -3.13% -0.94% -16.56% -5.22% -0.48% 2.76% 3.96% 5.50% 1.49% 0.96% 1.64% -3.26% -4.04% 1.94% -6.42% -4.10% -6.20% -7.35% -7.82% $ Increase in Debt Levied 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 6,295 (0) 118,608 40,598 0 (0) (0) 0 (0) 0 0 (1,177) 43,321 (87,589) (105,001) 48,362 (163,359) (97,689) (141,509) (157,514) (155,190) EXHIBIT C 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Total Debt Levied before reduction Total Debt Levied after reduction Z:\Budget 2021\Capital Equipment\2021 Streets Summary and Detail.xlsx 10/19/2020 BUILDINGS IMPROVEMENT FUND SOURCES Building improvement levy Community Center transfer USES HVAC Roofs Lighting Security Windows & Doors Tuck -pointing CAPITAL EQUIPMENT FUND SOURCES Capital equipment levy Equipment sales, trade-ins & donations MSA allocation USES Fleet Squads & unmarked Public Works trucks Fire trucks & rescue vehicles Heavy equipment Specialty equipment Technology PARK IMPROVEMENT FUND SOURCES Parkland dedication fees Donations & grants USES Athletic facilities & playground structures Park shelters Splash pads Trail construction UTILITIES INFRASTRUCTURE FUND SOURCES Connection fees Collection of inter-fund loans Grants as available Utility Fund transfer (Beginning in 2024) USES Water infrastructure & equipment Sewer infrastructure & equipment Fiber infrastructure & equipment STORMWATER FUND SOURCES Stormwater fees Watershed grants & cost sharing USES Permitting (MS4) & agency reporting Engineering studies Stormwater pond maintenance Flood improvements Water quality activities STREET IMPROVEMENT & DEBT SERVICE FUNDS SOURCES Street improvement levy Bond proceeds Assessments MSA allocation One-time revenues & project savings USES Street improvement debt Street reconstruction Utility reconstruction Street lights Sidewalks Mill & overlays Alleys