Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 Capital Funds book
City of St. Anthony Village 3301 Silver Lake Road St. Anthony, Minnesota 55418 www.savmn.com City of St. Anthony CAPITAL FUNDS 2020-2024 & 2025-2036 INDEX: Fund Summaries: Buildings Improvement Capital Equipment Park Improvement UƟ liƟ es Infrastructure Stormwater Streets Improvement & Debt Service APPENDIX: Sources & Uses Fiscal Year 2020 SOURCES 2019 Est. Actual 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Community Center Fund Transfer (1)90,000$ 94,694$ 96,588$ 98,520$ 118,520$ 120,000$ 120,000$ 720,000$ 720,000$ Reimbursement for Liquor Stores - - - - 99,000 - 5,500 118,460 - Public Facilities Capital Levy (2) 78,000 78,000 83,000 88,000 93,000 98,000 103,000 712,000 750,000 TOTAL 168,000$ 172,694$ 179,588$ 186,520$ 310,520$ 218,000$ 228,500$ 1,550,460$ 1,470,000$ USES City Hall/Community Center 109,000$ -$ 120,000$ 177,100$ 207,500$ -$ 16,000$ 414,122$ 383,350$ Fire Station 12,000 - 12,000 - 30,000 - 31,000 185,917 67,500 Public Works 12,000 - 12,000 - 7,500 48,861 40,640 384,553 140,000 Park Shelters 8,000 16,954 - 34,000 5,000 14,000 - 70,730 24,000 Liquor Stores - - - - 99,000 - 5,500 118,460 - TOTAL 141,000$ 16,954$ 144,000$ 211,100$ 349,000$ 62,861$ 93,140$ 1,173,782$ 614,850$ NET CHANGE 27,000 155,740 35,588 (24,580) (38,480) 155,139 135,360 376,678 855,150 BEGINNING CASH BALANCE 347,435 347,435 503,175 538,763 514,183 475,703 630,842 766,202 1,142,880 ENDING CASH BALANCE 374,435$ 503,175$ 538,763$ 514,183$ 475,703$ 630,842$ 766,202$ 1,142,880$ 1,998,030$ (1) Community Center fund transfer increase coincides with increase in School District rent in 2022. (2) Additional Building Improvement Levy of $5,000 annually, beginning in 2019, ending in 2029. BUILDINGS IMPROVEMENT PLAN 2020 - 2036 BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2019 EST ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 City Hall 1996 Building Components Metal Door Frame & Replacement PD and EE Entrances 2018 Multi.Internal -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 28,000$ -$ -$ -$ -$ -$ -$ -$ -$ Security upgrades - Cameras 2016 7 Internal - - - - - - - - - - 22,710 - - - - - - - - Security upgrades -Control Server 2016 1 Internal - - - - - - - - - - 46,706 - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - - 46,706 - - - - - - - - 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 - 64,000 - - - - - - - - - - - - - - - - RTU-4 (City)Fair 1 Sebesta - - - 69,000 - - - - - - - - - - - - - - - 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 - - - - - - - - - - - - - - - - - - - Domestic Water Heaters Fair 2 Sebesta - - - - - - 16,000 - - - - - - - - - - - - Relamp & Reballast (LED-PD) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - 5,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 - - - - 20,000 - - - - - - - - - - - - - - Outdoor sign Fair 1 Internal 45,000 - 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 109,000$ -$ 120,000$ 177,100$ 207,500$ -$ 16,000$ -$ 182,500$ -$ 144,122$ 55,000$ 32,500$ 140,000$ 160,850$ 30,000$ 7,500$ 45,000$ -$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - - - 12,500 - - - - - - 15,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 - - - - - - - - - - - - - - Domestic Water Heaters 2016 1 Sebesta - - - - - - - - 12,880 - - - - - - - - - - Relamp & Reballast Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - 47,672 - - - - - - - - - - - Exterior Paint 1 Internal 12,000 - 12,000 - - - - - - - - - - - - - - - - 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$ -$ 12,000$ -$ 30,000$ -$ 31,000$ 47,672$ 47,880$ -$ 15,365$ 15,000$ 60,000$ -$ -$ -$ -$ 67,500$ -$ Public Works 2004 Building Components Metal Door Frame & Replacement Fair Internal - - - - 7,500 - - - - - - 9,000 - - - - - - - Security upgrades -Cameras 2016 3 Internal - - - - - - - - - - 6,990 - - - - - - - - Security upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - - 17,515 - - - - - - - - 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 - 12,000 - - - - - - - - - - - - - - - - Parking Lot mill and overlay 30 years Internal - - - - - - - - - - - - - - - - 140,000 - - Rehab salt storage 25 years Internal - - - - - - - - - - - 40,000 - - - - - - - TOTAL 12,000$ -$ 12,000$ -$ 7,500$ 48,861$ 40,640$ 206,048$ -$ -$ 24,505$ 154,000$ -$ -$ -$ -$ 140,000$ -$ -$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2019 EST ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Central Park Pavilion 2003 Roof 2018 - - - - - - - - - - - - - - - - - - Security upgrades -Cameras 2016 - 9,000 - - - - - - - - 8,360 - - - - - - - - Security upgrades - Entrance controls 2016 - - - - - - - - - 7,005 - - - - - - - - HVAC Fair - - 12,000 - - - - - - - - - - - - - - - Domestic water heaters Fair - - - - - - - - - - - - - - - 4,000 - - Exterior updates Fair 8,000 7,954 - - - - - - - - - - - - - - - - - Interior updates 2018 - - - - - - - - - - - - - - - - - - Parking Lot mill and overlay 30 years - - - - - - - 15,000 - - - - - - - - - - 8,000$ 16,954$ -$ 12,000$ -$ -$ -$ -$ 15,000$ -$ 15,365$ -$ -$ -$ -$ -$ 4,000$ -$ -$ Emerald Park Pavilion 2009 - - - - - - - - - - - - - - - - - - - Roof Fair - - - - - - - 25,000 - - - - - - - - - - - Security upgrades -Cameras 2016 - - - - - - - - - - 8,360 - - - - - - - - Security upgrades - Entrance controls 2016 - - - - - - - - - - 7,005 - - - - - - - - HVAC Fair - - - - - 14,000 - - - - - - - - - - - - Domestic water heaters Fair - - - - 5,000 - - - - - - - - - - - - - - Exterior updates Fair - - - 10,000 - - - - - - - - - - - - - - - Interior updates Fair - - 12,000 - - - - - - - - - - - - - - - Parking Lot mill and overlay 30 years - - - - - - - - - - - - - 20,000 - - - - - -$ -$ -$ 22,000$ 5,000$ 14,000$ -$ 25,000$ -$ -$ 15,365$ -$ -$ 20,000$ -$ -$ -$ -$ -$ Park Shelters 8,000$ 16,954$ -$ 34,000$ 5,000$ 14,000$ -$ 25,000$ 15,000$ -$ 30,730$ -$ -$ 20,000$ -$ -$ 4,000$ -$ -$ TOTAL IMPROVEMENTS GOVERMENTAL 141,000$ 16,954$ 144,000$ 211,100$ 250,000$ 62,861$ 87,640$ 278,720$ 245,380$ -$ 214,722$ 224,000$ 92,500$ 160,000$ 160,850$ 30,000$ 151,500$ 112,500$ -$ Marketplace Liquor 2005 Building Components Rooftop Unit Fair 2 Sebesta - - - - 35,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - 10,800 2,925 - - - - - - - - Security upgrades - Entrance controls 2017 1 Internal - - - - - - - - - - 5,915 - - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - - - 5,500 - - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta - - - - - - -- - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - 36,398 - - - - - - - - - - - TOTAL -$ -$ -$ -$ 35,000$ -$ 5,500$ 36,398$ 10,800$ -$ 8,840$ -$ -$ -$ -$ -$ -$ -$ -$ Silver Lake Liquor 2005 Building Components Rooftop Units Good 1 Sebesta - - - - 64,000 - - - - - - - - - - - - - - Security upgrades -Cameras 2016 1 Internal - - - - - - - - 10,800 - 2,925 - - - - - - - - Security upgrades - Entrance controls 2017 Internal - - - - - - - - - - 5,915 - - - - - - - - Exhaust Fans Good 1 Sebesta - - - - - - - - - - - - - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - 42,782 - - - - - - - - - - - TOTAL -$ -$ -$ -$ 64,000$ -$ -$ 42,782$ 10,800$ -$ 8,840$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL IMPROVEMENTS ENTERPRISE -$ -$ -$ -$ 99,000$ -$ 5,500$ 79,180$ 21,600$ -$ 17,680$ -$ -$ -$ -$ -$ -$ -$ -$ COMBINED TOTAL IMPROVEMENTS 141,000$ 16,954$ 144,000$ 211,100$ 349,000$ 62,861$ 93,140$ 357,900$ 266,980$ -$ 232,402$ 224,000$ 92,500$ 160,000$ 160,850$ 30,000$ 151,500$ 112,500$ -$ BuildingsBuildings 1996 St. Anthony Community Center St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Fire StaƟon 2004 St. Anthony Public Works Facility BuildingsBuildings 2005 St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Village Liquor Store Silver Lake Village Fiscal Year 2020 SOURCES 2019 Est. Actual 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Capital Improvement Levy 258,200$ 258,200$ 283,200$ 308,200$ 333,200$ 358,200$ 383,200$ 2,824,200$ 3,724,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 5,000 25,000 15,000 15,000 15,000 15,000 15,000 90,000 90,000 Donations/Grants - - - - - 61,600 90,000 - 33,000 Interest / Equipment note proceeds 6,500 9,500 8,000 5,000 4,000 2,000 625,750 754,000 5,000 TOTAL 359,700$ 382,700$ 396,200$ 418,200$ 442,200$ 526,800$ 1,203,950$ 4,208,200$ 4,392,200$ Uses Police 146,380$ 73,935$ 125,407$ 192,196$ 201,801$ 154,486$ 105,180$ 1,022,818$ 1,140,665$ Fire 107,297 93,808 104,554 175,002 141,184 325,890 240,300 1,227,399 1,553,561 Administration/Finance 23,096 31,376 4,240 26,500 30,307 5,825 65,850 153,962 122,289 Streets 170,350 92,320 105,123 78,258 46,800 81,730 38,083 322,910 326,165 Parks 18,530 10,384 67,152 83,708 72,486 9,599 5,082 105,831 537,776 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 465,653 301,824 406,476 555,665 492,578 577,530 454,495 2,832,919 3,680,456 MINIMAL SHORTFALL (105,953)$ 80,876$ (10,276)$ (137,465)$ (50,378)$ (50,730)$ 749,455$ 1,375,281$ 711,744$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines* - - - - - - 591,701 706,522 - Dump Trucks (moved 1 DT to utility fund) - - - - - 220,000 - 270,108 331,870 F750 High Ranger Aerial Truck - - - - - - - 184,566 - 1995 Street 444G Front-End Loader - - 185,000 - - - - - - 1999 Parks 4500 Tractor - - - - - 83,022 - - - - - 185,000 - - 303,022 591,701 1,161,195 331,870 OVERALL SHORTFALL (105,953)$ 80,876$ (195,276)$ (137,465)$ (50,378)$ (353,752)$ 157,754$ 214,085$ 379,874$ NET CHANGE (105,953)$ 80,876$ (195,276)$ (137,465)$ (50,378)$ (353,752)$ 157,754$ 214,085$ 379,874$ BEGINNING CASH BALANCE 696,746$ 590,793$ 671,669$ 476,393$ 338,928$ 288,550$ (65,202)$ 92,552$ 306,637$ ENDING CASH BALANCE 590,793$ 671,669$ 476,393$ 338,928$ 288,550$ (65,202)$ 92,552$ 306,637$ 686,511$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE CAPITAL EQUIPMENT 2020 - 2036 Fiscal Year 2020 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Police Department Squads 85,655 - 81,675 84,050 83,996 37,129 89,112 454,393 526,039 Unmarked - - - 32,630 33,446 34,282 - 116,579 135,231 Retired to Other Services - - 796 820 1,689 - 896 7,011 4,712 Technology 38,000 35,299 18,570 22,401 29,359 47,472 3,456 228,724 193,102 Specialty Equipment 22,172 23,147 15,396 15,110 6,636 17,273 10,111 96,598 126,869 Investigative Equipment - - 3,412 4,100 - - 965 14,963 6,985 General Equipment 552 15,489 5,559 33,086 46,676 18,329 640 104,551 147,727 TOTAL PD 146,380$ 73,935$ 125,407$ 192,196$ 201,801$ 154,486$ 105,180$ 1,022,818$ 1,140,665$ Fire Department Apparatus - - - 90,000 46,897 - 591,701 821,159 63,026 Station Based Equipment - - - - - - 1,920 13,183 62,966 Protective Gear 5,520 6,285 16,398 - 14,478 246,400 51,197 54,548 154,934 Technology 13,289 10,189 6,319 5,505 7,359 10,340 5,760 81,637 47,668 Protective Equipment/Tools 20,900 16,099 3,700 10,000 6,650 - 27,855 99,470 69,561 Office Furniture 1,987 - 9,038 2,047 - 5,000 - 43,274 22,853 Debt Service Payments 65,600 61,235 69,100 67,450 65,800 64,150 153,568 820,649 1,132,553 TOTAL FD 107,297$ 93,808$ 104,554$ 175,002$ 141,184$ 325,890$ 832,001$ 1,933,920$ 1,553,561$ Administration/Finance Computer Hardware 5,330 10,697 2,250 16,500 15,655 825 10,850 55,462 54,318 Computer Software - - - - - - 55,000 7,500 - Furniture and Equipment 15,834 18,747 - - 5,000 - - 75,000 50,000 Council Chambers 1,932 1,932 1,990 10,000 9,652 5,000 - 16,000 17,971 TOTAL AF 23,096$ 31,376$ 4,240$ 26,500$ 30,307$ 5,825$ 65,850$ 153,962$ 122,289$ DEPARTMENTAL SUMMARIES 2020-2036 Fiscal Year 2020 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 DEPARTMENTAL SUMMARIES 2020-2036 PUBLIC WORKS Streets Department Fleet replacements 34,779 29,163 - 55,638 38,003 59,026 32,643 41,527 269,978 Plows/Dump trucks - - - - - 220,000 - 277,938 331,870 Heavy Equipment 6,623 3,832 189,928 5,051 5,177 5,307 5,439 252,285 41,301 Speciality Equipment 128,949 59,325 100,195 17,570 3,619 17,397 - 21,267 14,886 TOTAL 170,350$ 92,320$ 290,123$ 78,258$ 46,800$ 301,730$ 38,083$ 593,018$ 658,035$ Parks Department Fleet replacements - - - 49,781 - - - 103,894 133,495 Heavy Equipment 7,729 4,588 1,137 5,857 5,302 73,727 - 103,460 59,655 Mowers 9,753 552 62,546 18,571 45,744 - 1,280 29,291 224,740 Field Maintenance - - - 4,685 18,906 - - 21,132 54,214 Rink Maintenance - 2,539 - 586 - 12,029 640 4,380 31,484 Speciality Equipment 1,049 2,705 3,468 4,228 2,534 6,866 3,162 28,238 34,189 TOTAL 18,530$ 10,384$ 67,152$ 83,708$ 72,486$ 92,621$ 5,082$ 290,397$ 537,776$ TOTAL PW 188,881$ 102,704$ 357,275$ 161,967$ 119,286$ 394,351$ 43,165$ 883,414$ 1,195,811$ GRAND TOTAL 465,653$ 301,824$ 591,476$ 555,665$ 492,578$ 880,552$ 1,046,196$ 3,994,115$ 4,012,326$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.03 1.03 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.34391638 1.384234 1.425761 1.468534 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.104081 0 1.137203 1.171319 1.206458904 1.242653 1.27993225 1.31833 1.35788 1.398617 1.44057502 1.483792 1.528306 1.574155 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Active Squads 1576 705 2016 DODGE DODGE CHARGER - PATROL 3 1 37,433 41,775 - 33,979 - - - 38,243 - - - 43,043 - - - 48,445 - - - 54,526 1577 706 2016 FORD FORD EXPLORER SUV - PATROL 3 1 39,876 43,880 - 47,696 - - - 50,868 - - - 57,253 - - - 64,439 - - - 72,526 1598 707 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 34,998 - 37,129 - - - 41,789 - - - 47,034 - - - 52,938 - 1599 708 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 49,052 - - - 52,394 - - - 58,970 - - - 66,372 - - 1629 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3 1 43,335 - - - 47,948 - - - 53,966 - - - 60,740 - - - 68,363 - - 1630 710 2018 DODGE DODGE CHARGER - PATROL 3 1 32,989 - - - - 36,048 - - - 40,572 - - - 45,664 - - - 51,396 - - 85,655 - 81,675 84,050 83,996 37,129 89,112 52,394 94,539 41,789 100,296 58,970 106,404 47,034 112,884 66,372 119,759 52,938 127,052 Unmarked 1557 6 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - - 32,630 - - - - - 37,841 - - - - - 43,896 - - - 1600 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 - - - - 1559 703 2015 DODGE DODGE CHARGER - COURT 7 1 700 - - - - 845 - - - 951 - - - 1,070 - - - 1,204 - - 1482 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 - - - 820 - - - 923 - - - 1,039 - - - 1,169 - - - - - 796 820 1,689 - 896 923 1,901 - 1,008 1,039 2,140 - 1,135 1,169 2,408 - - 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 NA NEW VARIOUS BODY CAMERAS / VIDEO/WEARABLES 5 23 400 - 7,103 - - 10,562 - - - - 12,244 - - - - - 14,203 - - - NA NA NEW VARIOUS SQUAD VIDEO CAMERAS 7 7 4,895 - 3,830 - 4,808 - - 42,142 - - 5,913 - - - 51,829 - - 7,273 7,491 NA NA NEW VARIOUS FACILITY VIDEO CAMERAS 5 6 3,680 38,000 24,366 2,500 14,074 15,539 - - - 29,982 - - - - 34,757 - - - - - 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 - - 38,000 35,299 18,570 22,401 29,359 47,472 3,456 46,102 33,648 12,244 112,735 - 23,994 39,486 56,207 78,002 4,644 7,273 7,491 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 - - - 5,857 - - - - 6,789 - - - - 7,871 - - - - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS) 5 10 500 552 552 569 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 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,312 4,312 3,412 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 NA NA VARIOUS VARIOUS FIREARMS 15 23+ varies 2,208 3,621 2,274 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 NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 16,100 14,662 - - - - - - - 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 NA NA 2014 VARIOUS BIKES 10 2 1,500 - - 3,412 - - - - - 4,074 - - - - - - - - - - 22,172 23,147 15,396 15,110 6,636 17,273 10,111 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 14,417 3% AVERAGE ANNUAL INFLATION FIXED ASSET SCHEDULE POLICE DEPARTMENT 1.03 1.03 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.34391638 1.384234 1.425761 1.468534 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.104081 0 1.137203 1.171319 1.206458904 1.242653 1.27993225 1.31833 1.35788 1.398617 1.44057502 1.483792 1.528306 1.574155 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 3% AVERAGE ANNUAL INFLATION Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP/RECORDERS 5-7 7 500 - - - 4,100 - 965 - - 4,895 - - 1,528 - - 1,670 - - - 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,955 - - - - 4,585 - - - - 5,315 - - - 3,412 4,100 - - 965 3,955 - 4,895 - - 6,113 - - 1,670 - 5,315 - 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 - 1,065 2,559 - - 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 552 552 3,000 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 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 - 13,872 - - - - - - 6,500 - - - - 6,500 - - - - 6,500 1483 NA 2011 LETG RECORDS RETENTION MGMT SYSTEM 10-15 1 65K - - - 32,500 32,500 - - - - - - - - - - - - 75,000 - 552 15,489 5,559 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 TOTAL POLICE 146,380 73,935 125,407 192,196 201,801 154,486 105,180 123,069 165,103 129,218 310,306 108,862 186,260 114,114 183,845 234,946 201,476 249,912 156,372 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 Ford Interceptor SUV (2) 2015-2018 Dodge Charger (5) 2018 Ford Taurus 2016, 2017 Chevrolet Impala (3) 2011 Ford Fusion (1) FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.104081 0 1.13720323 1.17131932 1.2064589 1.24265267 1.27993225 1.31833022 1.35788013 1.39861653 1.44057502 1.48379228 1.52830604 1.57415523 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.03 1.03 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 1.60470644 1.65284763 1.70243306 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 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 - - - - 46,897 - - - - - - - - - 63,026 - - - - 1385 2006 FORD INSPECTIONS VEHICLE (1) n/a 1 - - - - - - - - - - - - - - - - - - - 2006 BOAT AND MOTOR 20 1 8,000 - - - - - - - - 14,449 - - - - - - - - - - - - - 90,000 46,897 - 591,701 - 114,638 - - - 706,522 - 63,026 - - - - 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 10 25 2,000 - - 16,398 - - - 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 - 765 - - - - - - 9,777 - - - - - - - - - - 2001/2004 SCBA COMPLETE PACK 20 36 7,700 - - - - - 246,400 - - - - - - - - - - - - - Various SCBA BOTTLES/FACEPIECE 15 65 800 - - - - - - - - - - - - - 59,818 - - - - 2005 ICE RESCUE EQUIPMENT 10 4 1,250 5,520 5,520 - - - - - 6,592 - - - - - - - - - 8,859 - 5,520 6,285 16,398 - 14,478 246,400 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,637 4,637 - 4,920 - 5,219 - 5,537 - 5,874 - 6,232 - 6,611 - 7,014 - 7,441 - 2006 VEHICLE COMPUTERS 5 2 2,000 4,000 5,000 - - - - 5,120 - - - - 5,935 - - - - 6,880 - - Various OFFICE COMPUTERS 5 7 800 - - - - 6,756 - - - - 6,713 - - - - 7,783 - - - - 2014 RADIOS/BATTERIES 12 12 2,500 - - - - - - - - 20,368 20,979 - - - - - - - - - 2008 EOC TECHNOLOGY 6 5 Various 4,100 - 5,750 - - 4,500 - - - 5,734 - - - - - 6,847 - - - Various OTHER BATTERIES 500 552 552 569 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 13,289 10,189 6,319 5,505 7,359 10,340 5,760 6,196 21,047 40,000 720 12,909 764 7,399 8,593 14,696 7,741 8,327 912 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 7,700 7,622 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 10,000 8,002 - - - - 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 2,000 475 - - 4,000 - - - - 4,500 - - - - 5,000 - - - - Various GAS MONITOR 6 10 600 1,200 - 1,200 - - - - 1,350 - - 750 - - - - - 1,800 - - 1290 Various OUTDOOR WARNING SIRENS 30 2 22,600 - - - - - - 29,794 - - - - - - - - - - - 20,900 16,099 3,700 10,000 6,650 - 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.104081 0 1.13720323 1.17131932 1.2064589 1.24265267 1.27993225 1.31833022 1.35788013 1.39861653 1.44057502 1.48379228 1.52830604 1.57415523 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.03 1.03 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 1.60470644 1.65284763 1.70243306 ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 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 - 1,987 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 1,987 - 9,038 2,047 - 5,000 - - 14,529 12,294 6,483 2,671 7,298 - 16,053 - - - 6,800 TOTAL FIRE 41,697 32,574 35,454 107,552 75,384 261,740 678,433 68,321 170,091 73,578 34,722 27,580 738,980 158,462 129,160 81,497 15,791 17,186 18,912 FIRE ENGINE DEBT SERVICE 65,600 61,235 69,100 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 107,297 93,808 104,554 175,002 141,184 325,890 832,001 220,089 325,059 226,596 120,790 113,648 927,739 347,220 317,919 270,256 204,549 205,945 207,671 500,000 41,697 32,574 35,454 107,552 75,384 261,740 240,300 68,321 170,091 73,578 34,722 (472,420) 1,227,399 158,462 129,160 81,497 15,791 17,186 1,553,561 1,933,920 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 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 CISCO ETHERNET SWITCH/FIBER SWITCHS (RUNS ALL CITY BLDGS) 5 5 1,500 4,605 7,319 - - 2,495 - 8,500 - 925 - 3,600 - 10,350 - 1,000 - 4,200 - 12,500 NA VARIOUS FILE SERVER & SOFTWARE UPGRADES/ROSEVILLE 10 1 23,059 725 725 750 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 UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 - - - 12,000 - - - - - - 13,000 - - - - - - 14,000 - NA VARIOUS COMPUTER EQUIPMENT 5 10 1,200 - 2,653 1,500 - 12,360 - 1,500 1,545 - 12,731 - 1,545 1,591 - 13,113 - 1,591 1,639 - 5,330 10,697 2,250 16,500 15,655 825 10,850 2,420 1,825 13,656 22,100 2,520 12,941 1,025 15,138 1,050 6,841 16,689 13,575 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 LIQOUR CC SYSTEM MP 15 1 9,030 - - - - - - - - - - - - - - - - - - - 1642 2018 POS LIQOUR CC SYSTEM SLV 15 1 9,030 - - - - - - 55,000 - - - 7,500 - - - - - - - - Furniture and Equipment 1581RC NA ELECTION MACHINES & EQUIPMENT 10 2 10,000 5,834 5,834 - - - - - 35,000 - - - - - - - - - 40,000 - 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS 10,000 12,913 - - 5,000 - - - 40,000 - - - - - - 10,000 - - - 15,834 18,747 - - 5,000 - - 35,000 40,000 - - - - - - 10,000 - 40,000 - Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS - - - - - 5,000 - - - - 5,000 - - - - 5,000 - - - MULTIPLE VARIOUS COUNCIL CHAMBERS CAMERAS (1) 10 5 8,200 - - - - - - - - - - - - - - - - - - - NA VARIOUS COUNCIL CHAMBERS COMPUTERS/MONITORS 7-10 4 1,750-8,000 1,932 1,932 1,990 - 9,652 - - - - - - - - - 12,971 - - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS - - - 10,000 - - - - - - - 11,000 - - - - - - - 1,932 1,932 1,990 10,000 9,652 5,000 - - - - 5,000 11,000 - - 12,971 5,000 - - - TOTAL ADMIN/FINANCE 23,096 31,376 4,240 26,500 30,307 5,825 65,850 37,420 41,825 13,656 34,600 13,520 12,941 1,025 28,109 16,050 6,841 56,689 13,575 (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 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 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 34,779 29,163 - - - - - - - - - - - - - - 54,184 - - 1409 2007 FORD 6 F150 PICKUP 4X4 (SUPR TO MECH) 15 1 31,500 - - - - 38,003 - - - - - - - - - - - - - - 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 - - - - - 59,026 - - - - - - - - - - - - - 1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - 55,638 - - - - - - - - - - - - - - 86,682 256,500 34,779 29,163 - 55,638 38,003 59,026 32,643 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 6,623 3,832 4,928 5,051 5,177 5,307 5,439 5,575 5,715 5,858 6,004 6,154 6,308 6,466 6,627 6,793 6,963 7,137 7,315 1216 1995 JOHN DEERE 32 444G FRONT END LOADER 20 1 160,000 - - 185,000 - - - - - - - - - - - - - - - - 338,105 6,623 3,832 189,928 5,051 5,177 5,307 5,439 222,247 5,715 5,858 6,004 6,154 6,308 6,466 6,627 6,793 6,963 7,137 7,315 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 49,684 52,304 - - - - - - - - - - - - - - - - - 1201 1995 ROSCO 42 VIBRASTAT 111(3) ASPHALT ROLLER 15-20 1 15,000 - - 17,058 - - - - - - - - - - - - - - - - 1202 1999 STEPP 51 SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 55,204 - 55,204 - - - - - - - - - - - - - - - - 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 - - - - - - - - - - - - - - - - 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 - - - 17,570 - - - - - - - - - - - - - - - 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 7,500 3,516 - - - - - - - - - - - - - 11,344 - - - GARAGE & OFFICE COMPUTERS 7 4 - 3,505 - - - - - - - - - - - - - - - - - 258,900 128,949 59,325 100,195 17,570 3,619 17,397 - - - - 6,429 14,838 - 3,542 - 11,344 - - - TOTAL STREETS 170,350 92,320 290,123 78,258 46,800 301,730 38,083 263,774 5,715 5,858 282,541 20,992 14,138 10,008 79,589 18,137 117,297 7,137 425,867 174,887 174,887 - - - 270,108 - - ####### #######593,018 (4,537) (82,567) 290,123 78,258 46,800 301,730 38,083 263,774 5,715 5,858 12,433 20,992 14,138 10,008 79,589 18,137 117,297 7,137 425,867 FOOTNOTES 340,701 184,640 (1) REPLACEMENT MADE RETAINED FOR BACKUP (2)NOT SCHEDULED FOR REPLACEMENT Specialty Equipment Fleet Plows/Dump Trucks Heavy Equipment 3% AVERAGE ANNUAL INFLATION Public Works Department—Street FLEET 2014 Chevrolet Malibu 2010 Ford F150 Pickup 2007 Ford F150 4x4 2008 Ford F450 Mini Dump 2 Ton 4x4 2006 Ford F450 Mini Dump 2 Ton 4x4 2017 Ford F350 Pickup Public Works Department—Street FLEET 2004 Ford F150 Pickup 4x4 Public Works Department—Street PLOW/DUMP TRUCKS 2003 Sterling M8500 Acterra 2013 International 7400 Dump Truck 1990 Ford L8000 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 2018 Bobcat Replacement Program 1995 John Deere 444G Front End Loader Public Works— Streets SPECIALTY EQUIPMENT 2019 Stepp Crack Sealer 1999 Stepp SPH-2.0 Asphalt Hot Box 1998 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 1995 Rosco Asphalt Roller FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 1379 2006 FORD 20 F350 MINI DUMP 1 TON 4X4 15 1 42,500 - - - 49,781 - - - - - - - - - - - - - - 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 - - - 49,781 - - - - 48,252 - - 55,642 - - 55,938 - - - 77,557 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 7,729 4,588 - - - - - - - - - - - - - - 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 - - - - - - - - - - - - - - - 1,825 1974 VERMEER TREE SPADE 25+ 1 VARIES - - - - - - - - - - - - - - - - - - - 1974 GIBSON CEMENT MIXER 25+ 1 2,000 - - - - - 2,485 - - - - - - - - - - - - - 156,222 7,729 4,588 1,137 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 - - - - - - - - - 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 - - - - - - - - - - - - - - - 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 9,201 - - - - - - - - - - - - - - - - - - 2005 HONDA PUSH MOWER 10 1 500 552 552 - - - - - - - - - 742 - - - - - - - 1975 JERRI JERRI SICLE MOWER 25+ 1 3,000 - - - - - - - - 4,074 - - - - - - - - - - 163,416 9,753 552 62,546 18,571 45,744 - 1,280 - 4,074 24,476 - 742 - 122,652 - - 1,720 - 100,368 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 Fleet Field Maintenance Mowers Heavy Equipment Public Works - Parks FLEET 2014 Ford F250 Flatbed 2017 Ford F250 Park Utility 4x4 2006 Ford F350 Mini Dump 1 Ton 4x4 2011 Ford F250 Pickup 4x4 Public Works - Parks HEAVY EQUIPMENT 2015 Bobcat 3400G UTV 2018 Echo Bearcat Tow Behind Vacuum Debris Loader 2011 Bobcat Tool Cat 5600 2012 Hydraulic Tractor Sweeper Sidewalks and Ice Rinks 2019 Big Tex 18’ Tandem Park Utility Trailer Public Works - Parks HEAVY EQUIPMENT 2004 Trac Vac 880 Leaf Vaccum Dethatcher 1999 John Deere 4500 Tractor 1974 Vermeer Tree Spade Public Works - Parks MOWERS 2010 Toro Grandstand Mower 2011 Toro Grounds Master 360 2001 Deweze Slope Mower 72LC 2017 Toro Z Master G3 5000 Mower 2016 Toro Zero Turn Mower 5000 MYRIDE 60” Public Works - Parks FIELD MAINTENANCE 2016 Linelazer Field Painter FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 3% AVERAGE ANNUAL INFLATION 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 - 552 - - - - 640 - - - - 742 - - - - 860 - - NA MB MCD-WB WALK BEHIND BROOM 10 1 1,800 - 1,987 - - - - - - - - - 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 - 2,539 - 586 - 12,029 640 - 679 - 288 3,413 - 787 - 25,829 3,956 - 912 NA VARIOUS WEED WHIPS 5 4 VARIES 166 166 - 305 181 186 192 - 353 210 216 223 - 409 243 251 258 - 474 NA VARIOUS CHAIN SAWS 5 5 VARIES 221 221 284 586 724 870 283 330 679 839 1,008 419 382 787 973 1,169 721 443 912 NA STIHL LEAF BLOWERS 5 5 VARIES 221 221 227 234 241 311 256 264 272 280 360 297 306 315 324 418 344 354 365 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 NA VARIOUS TRIMMERS 5 4 VARIES - - 455 176 181 - - 527 204 210 - - 611 236 243 - - 709 274 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 442 442 - - - - 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 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,656 - - - - 1,920 - - - - 2,226 - - - - 2,580 - - NA NA EVENT BARRICADES 5 MLTP 1,500 - - - - - - - - - - - - - - - - - - - 18,535 1,049 2,705 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 TOTAL PARKS 18,530 10,384 67,152 83,708 72,486 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 FOOTNOTES - (1) DUPLICATE REMOVED 18,530 10,384 67,152 83,708 72,486 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 (2) NOT SCHEDULED FOR REPLACEMENT Parkland/Sidewalks/Trees Rink Maintenance Fiscal Year 2020 2019 Est. Actual 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 SOURCES Park Dedication Fees 1,500$ 1,500$ 2,000$ 7,500$ 1,500$ 1,500$ 1,500$ 9,000$ 9,000$ Donations - - - - - - - - - Micellaneous Income 725 725 800 850 900 900 900 5,795 5,853 TOTAL 2,225$ 2,225$ 2,800$ 8,350$ 2,400$ 2,400$ 2,400$ 14,795$ 14,853$ USES Central Park 4,150 5,612 2,800 - - - - - - Emerald Park 5,000 6,686 2,100 - - - - - - Salo Park - - - - - - - - - Silver Point Park 3,434 32,108 1,200 - - - - - - Trillium Park - - - - - - - - - Water Tower Park 1,905 10,141 - - 63,000 - - - - TOTAL 14,489 54,546 6,100 - 63,000 - - - - NET CHANGE (12,264)$ (52,321)$ (3,300)$ 8,350$ (60,600)$ 2,400$ 2,400$ 14,795$ 14,853$ BEGINNING CASH BALANCE 121,660 121,660 69,339 66,039 74,389 13,789 16,189 13,789 28,584 ENDING CASH BALANCE 109,396$ 69,339$ 66,039$ 74,389$ 13,789$ 16,189$ 18,589$ 28,584$ 43,437$ PARK IMPROVEMENT 2020 - 2036 PARKS IMPROVEMENT PROGRAMPARK CIRA DESCRIPTIONCONDITION GRADECOST / INTERNAL EST / QUOTE2019EST ACT. 20192020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036Central Park2003Park Amenities Signage‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Ballfields ‐ multi‐use 950 537 600 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Ballfields ‐ soccer 400 1,074 1,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Batting Cages ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Off‐Street Parking ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Picnic Area ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Play Equipment 1,500 1,200 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skateboard Park 600 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ general 350 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ hockey 2020 LED lighting 350 4,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Walking Paths ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Splash Pad water reuse assessment ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Splash Pad/Shade Structures & Seating Additional need under review ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL 4,150$ 5,612$ 2,800$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Emerald Park2009Park Amenities Signage‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Ballfields ‐ multi‐use 800 269 300 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Ballfields ‐ soccer 1,500 537 600 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Basketball Half‐Court 200 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Off‐Street Parking ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Picnic Area 300 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Play Equipment 1,500 1,200 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ general 350 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ hockey 2019 LED lighting 350 5,880 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Walking Paths ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Splash Pad/Shade Structures & Seating Additional need under review ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL 5,000$ 6,686$ 2,100$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Salo Park2006Park Amenities Signage‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Amphitheater‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Became part of 2018 Improvements funded by PUI fundPARK COMMISSION EVALUATION IN PROGRESS PARKS IMPROVEMENT PROGRAMPARK CIRA DESCRIPTIONCONDITION GRADECOST / INTERNAL EST / QUOTE2019EST ACT. 20192020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036Silver Point Park1998Park Amenities Signage‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Ballfields ‐ multi‐use 800 269 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Basketball Full‐Court ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Off‐Street Parking ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Picnic Area 318 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Play Equipment 1,736 ‐ 1,200 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ general ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Skating Rink ‐ hockey 2019 LED lighting 579 2,400 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Walking Paths ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Drinking Fountains ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ New hockey rink ‐ 29,439 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL 3,434$ 32,108$ 1,200$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Trillium Park 1980Park Amenities Signage‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Water Fountain ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Off‐Street Parking‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ Water Tower Park2004Park Amenities Signage‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Basketball Half‐Court ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Off‐Street Parking‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Picnic Area 405 419 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Play Equipment1,500 2,522 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Tennis Courts / Repairs Resurface ‐ 7,200 ‐ ‐ 63,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Walking Paths‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL 1,905$ 10,141$ ‐$ ‐$ 63,000$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ TOTAL PARK IMPROVEMENTS 14,489$ 54,546$ 6,100$ ‐$ 63,000$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ PARK COMMISSION EVALUATION IN PROGRESS ParksParks Park AmeniƟes Amphitheater Ballfields ‐ mulƟ‐use Ballfields ‐ soccer Basketball Courts Baƫng Cages Off‐Street Parking Picnic Area Play Equipment Shelter Skateboard Park SkaƟng Rink ‐ general SkaƟng Rink ‐ hockey Tennis Courts Walking Paths Splash Pads Central Park—2003 X X 1/2 X X X X X X X X X X Emerald Park —2009 X X 1/2 X X X X X X X X Salo Park—2006 X X Silver Point Park— 1998 X X X X X X X X X Trillium Park—1980 X Water Tower Park— 2004 X X X X X Fiscal Year 2020 SOURCES 2019 Est. Actual 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Interfund Loan collections (1)45,766 45,766 45,470 198,667 191,976 185,285 178,594 690,050 - Utility Fund Transfer (2)- - - - - - - 225,000 1,350,000 Connection fees 8,500 8,500 85,000 17,000 - - - - - Interest and other income 46,183 46,183 55,058 48,256 47,691 58,868 58,868 288,348 360,318 TOTAL 100,449$ 100,449$ 185,529$ 263,923$ 239,667$ 244,153$ 237,462$ 1,203,398$ 1,710,318$ USES Water Infrastructure 80,920 37,871 12,500 18,843 17,500 197,675 43,450 1,487,129 562,421 Water Equipment 2,492 2,492 2,232 38,791 905 1,933 1,600 72,973 152,012 Sewer Infrastructure 15,000 - 15,000 - - - - 25,000 60,000 Sewer Equipment 382,492 2,492 382,232 3,651 905 1,933 1,600 72,973 736,709 Fiber Infrastructure 33,213 2,500 - - 15,000 - - 22,000 29,000 TOTAL 514,117$ 45,355$ 411,964$ 61,285$ 34,310$ 201,542$ 46,650$ 1,680,076$ 1,540,142$ NET CHANGE (413,669)$ 55,093$ (226,435)$ 202,638$ 205,357$ 42,611$ 190,812$ (476,678)$ 170,176$ BEGINNING CASH BALANCE 2,949,349 2,949,349 3,004,442 2,778,007 2,980,645 3,186,002 3,228,613 2,980,645 2,503,967 ENDING CASH BALANCE 2,535,680$ 3,004,442$ 2,778,007$ 2,980,645$ 3,186,002$ 3,228,613$ 3,419,425$ 2,503,967$ 2,674,143$ (1) Principal collection of $959,326 estimated to begin 2021. (2) Utility Fund Transfer available upon retirement of Water Bonds in 2024. UTILITIES INFRASTRUCTURE 2020 - 2036 UTILITES INFRASTRUCTUREPLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM1.03 1.03 1.0609 1.092727 1.12550881 1.1592741 1.1940523 1.2298739 1.2667701 1.3047732 1.3439164 1.3842339 1.4257609 1.4685337 1.5125897 1.557967417DEPT PURPOSE DESCRIPTION 2019EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036Plant FacilitiesAOP PlantElectrical 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 14,900 14,750 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 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 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ProductionWell 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 ‐ 1,621 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 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 59,520 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Wellhouse 3, 4, 5 maintenance, roofs in 20244,000 4,000 ‐ ‐ ‐ ‐ 37,500 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Storage‐ Ground Storage and Tower Cleaning & Inspection ‐ ‐ ‐ 11,000 ‐ ‐ ‐ 12,000 ‐ ‐ ‐ ‐ 13,500 ‐ ‐ ‐ 14,500 ‐ ‐ Tower Painting (last painted in 2000) ‐ ‐ ‐ ‐ ‐ ‐ ‐ 300,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Distribution System‐ ‐ Watermains (Included in streets reconstruction) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Meter reading software upgrade / Customer portal ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 80,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Mandates‐ ‐ Wellhead Protection Plan Documentation (MDHS) ‐ 15,000 10,000 ‐ ‐ ‐ ‐ 30,000 ‐ ‐ ‐ ‐ 35,000 ‐ ‐ Education/Public Awareness 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 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,000 1,000 1,001 1,001 1,001 1,001 1,001 Annual Well Sampling 500 500 500 500 500 500 500 500 500 500 500 500 501 502 503 503 503 503 503 80,920 37,871 12,500 18,843 17,500 197,675 43,450 372,100 97,500 185,400 402,406 203,722 226,001 315,502 2,505 126,399 22,005 73,505 22,505 Lift StationsLift Stations ‐ SCADA system/Fiber ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 60,000 ‐ ‐ ‐ Foss Road Lift Station Pump Replacement/re‐hab 15,000 ‐ 15,000 ‐ ‐ ‐ ‐ 10,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Harding Lift Station Pump Replacement/re‐hab ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 15,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Collection SystemCollection System (Included in streets reconstruction) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 15,000 ‐ 15,000 ‐ ‐ ‐ ‐ 10,000 ‐ 15,000 ‐ ‐ ‐ ‐ ‐ 60,000 ‐ ‐ ‐ FIBER BackboneFiber expansion from Fire Station to Central Park‐2019 ‐ 2,500 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 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 ‐ 33,213 2,500 ‐ ‐ 15,000 ‐ ‐ ‐ ‐ ‐ ‐ 22,000 ‐ ‐ ‐ ‐ ‐ 29,000 ‐ TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 129,133$ 40,371$ 27,500$ 18,843$ 32,500$ 197,675$ 43,450$ 382,100$ 97,500$ 200,400$ 402,406$ 225,722$ 226,001$ 315,502$ 2,505$ 186,399$ 22,005$ 102,505$ 22,505$ SEWER UTILITYWATER UTILITY UTILITES INFRASTRUCTUREEQUIPMENTFIXED ASSET # YEAR MAKE DESCRIPTION LIFE 2019EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 20361403 2006 SPRINTER 4 W WATER UTILITY VAN 15 ‐ ‐ ‐ 35,140 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 68,224 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 94,437 ‐ ‐ ‐ 35,140 ‐ ‐ ‐ 68,224 ‐ 1,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 94,437 ‐ 14381999 STERLING 19 S STERLING VACTOR/JETTER 15 380,000 ‐ 380,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 471,200 ‐ ‐ ‐ ‐ ‐ 1644 2018 FORD 15 D L8000 DUMP TRUCK 15‐25 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2007 ZIEGLER CAT S 200KW ‐ FOSS RD LS 25‐30 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 113,497 ‐ ‐ ‐ ‐ 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15‐20 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2013 CASE 590 D BACKHOE 20‐25 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 175,290 ‐ ‐ ‐ 380,000 ‐ 380,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 471,200 113,497 175,290 ‐ ‐ ‐ 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 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,977 ‐ ‐ ‐ ‐ 2,292 ‐ ‐ ‐ ‐ ‐ 2,737 1209 2005 INGERSOL RAND D ROTO HAMMER 10 276 276 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 371 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 1417 2005 HONDA D EG1500W GENERATOR 10 552 552 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 742 ‐ ‐ ‐ ‐ ‐ ‐ ‐ EST 2005 HOMELITE D 3" DIAPHRAM PUMP 5‐10 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 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,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 1,656 1,656 ‐ ‐ ‐ ‐ ‐ ‐ 2,037 ‐ ‐ ‐ ‐ ‐ ‐ 2,505 ‐ ‐ ‐ NEW DTransfered 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 ‐ ‐ ‐ 2,484 2,484 4,464 4,802 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 2016 RTA D RTA FLEET SOFTWARE (SHOP) 15‐20 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 9,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ D COMPUTERS/PRINTERS 7‐10 2,500 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 1442 2009 SENSUS D COMPUTER SOFTWARE 20 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 20,368 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2,500 2,500 ‐ 2,500 ‐ 2,500 ‐ 11,500 20,368 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ 2,500 ‐ TOTAL UTILITY 384,984 4,984 384,464 42,442 1,810 3,867 3,200 87,561 23,899 19,584 1,585 8,064 6,254 475,274 122,515 183,802 3,440 2,500 101,189EQUIPMENT SPECIFIC TO WATER 0 0 0 35,140000000000000000EQUIPMENT SPECIFIC TO SEWER 380,000 0 380,000 0000000000471,200 113,4970000DUAL PURPOSE EQUIPMENT4,984 4,984 4,464 7,302 1,810 3,867 3,200 87,561 23,899 18,584 1,585 8,0646,254 4,074 9,019 183,802 3,440 2,500 101,189384,984 4,984 384,464 42,442 1,810 3,867 3,200 87,561 23,899 18,584 1,5858,064 6,254 475,274 122,515 183,802 3,440 2,500 101,189Technology Reassigned from Capital Equipment Fund3% AVERAGE ANNUAL INFLATIONFleet Reassigned from Capital Equipment FundHeavy Equipment Reassigned from Capital Equipment FundSpecialty Equipment Reassigned from Capital Equipment Fund Utilities InfrastructureUtilities Infrastructure 1953 Water Tower 2007 Foss LiŌ StaƟon 2001 Harding LiŌ StaƟon 1953 St. Anthony Water Treatment Facility, 1991 GAC, 2017 AOP Utilities InfrastructureUtilities Infrastructure 1957 Well #3 1959 Well #4 1961 Well #5 Utility InfrastructureUtility Infrastructure FLEETFLEET 1 1999 Sterling Vactor/Je Ʃer 2006 Sprinter UƟlity Van 2015 Ford F350 UƟlity 4x4 2004 Freightliner M2 Water Tanker/Flusher Utility InfrastructureUtility Infrastructure HEAVY EQUIPMENTHEAVY EQUIPMENT 1999 Onan 400K Gen Set 1992 Onan 375K Gen Set 1989 Sreco RSR‐38TR Sewer Rodder 2013 Case 590 Loader/Backhoe Fiscal Year 2020 SOURCES 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Stormwater fees UB 205,734$ 206,200$ 210,324$ 214,530$ 218,821$ 223,198$ 227,661$ 1,274,563$ 1,287,309$ Bond Proceeds- SLR Flooding (1)293,700 - - - - - - - - Grants-Silver Lake Rd Flooding (1)500,000 - - - - - - - - Grants-Industrial Park Flooding (2)250,000 - 250,000 - - - - - - Grant-prior projects - 11,432 - - - - - - - Interest 2,750 2,750 3,250 3,500 3,500 3,500 3,500 48,000 76,750 TOTAL 1,252,184$ 220,382$ 463,574$ 218,030$ 222,321$ 226,698$ 231,161$ 1,322,563$ 1,364,059$ USES Stormwater Maintenance -$ -$ -$ 50,000$ -$ -$ -$ 155,000$ 280,000$ Flood Improvements (1)1,002,000 - 300,000 - - - - - - Water Quality 31,530 32,289 53,104 49,160 50,663 317,217 53,823 434,832 878,095 Mandates 8,100 8,200 8,260 8,422 8,587 8,755 18,925 57,289 64,233 Annual Reconstruction 85,000 85,000 - 85,000 85,000 105,000 75,000 150,000 - TOTAL 1,126,630 125,489 361,364 192,582 144,251 430,972 147,748 797,121 1,222,329 NET CHANGE 125,554$ 94,893$ 102,210$ 25,448$ 78,071$ (204,274)$ 83,413$ 525,442$ 141,730$ BEGINNING CASH BALANCE 97,650 97,650 192,543 294,753 320,201 398,272 193,997 277,411 802,853 ENDING CASH BALANCE 223,204$ 192,543$ 294,753$ 320,201$ 398,272$ 193,997$ 277,411$ 802,853$ 944,583$ STORMWATER 2020 - 2036 STORMWATER CAPITAL PLANImprovement TypeLocationPotential Financial Sources 2019EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036Stormwater 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 ImprovementsIndustrial Park Flood Improvements SAV/MWMO 300,000 ‐ 300,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Mirror Lake ‐ capacity increased RCWD, Ramsey County ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Mirror Lake ‐ EriosIon/Pipe re‐route RCWD, SAV Street ImpSilver Lake Rd Flooding Preliminary Analysis SAVSilver Lake Rd Flooding Project SAV,DNR,Ramsey,RCWS 702,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 1,002,000 ‐ 300,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Water Quality Street Sweeper SAV ‐ ‐ ‐ ‐ ‐ 235,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 350,000 ‐ ‐ ‐ Salo Pond Treatment System SAV 18,980 19,739 20,529 21,350 22,204 23,092 24,016 24,976 25,975 27,014 28,095 29,219 30,388 31,603 32,867 34,182 35,549 36,971 38,450 Regional Stormwater Treatment system (1) MWMO 1,550 1,550 1,575 21,600 22,032 22,473 22,922 23,381 23,848 24,325 24,812 25,308 25,814 26,330 26,857 27,394 27,942 28,501 29,071 Clean Streets maintenance costs SAV 6,000 6,000 6,000 6,210 6,427 6,652 6,885 7,126 7,376 7,634 7,901 8,177 8,464 8,760 9,066 9,384 9,712 10,052 10,404 Silver Lake Delisting / Weed mgmt CO‐OP 5,000 5,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Water Re‐use Maintenance SAV ‐ ‐ 25,000 ‐ ‐ 30,000 ‐ ‐ 35,000 ‐ ‐ 40,000 ‐ ‐ 45,000 ‐ ‐ 50,000 ‐ 31,530 32,289 53,104 49,160 50,663 317,217 53,823 55,483 92,199 58,973 60,808 102,704 64,665 66,693 113,791 420,960 73,203 125,524 77,925 MandatesSWIPP Stormwater Management Plan update SAV ‐ ‐ ‐ ‐ ‐ ‐ 10,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ MS4 MS4‐Engineer costs SAV 1,500 1,500 1,560 1,622 1,687 1,755 1,825 1,898 1,974 2,053 2,135 2,220 2,309 2,402 2,498 2,598 2,701 2,809 2,922 Internal SW Education / Green Step Program SAV 6,600 6,700 6,700 6,800 6,900 7,000 7,100 7,200 7,300 7,400 7,500 7,600 7,700 7,800 7,900 8,000 8,100 8,200 8,300 8,100 8,200 8,260 8,422 8,587 8,755 18,925 9,098 9,274 9,453 9,635 9,820 10,009 10,202 10,398 10,599 10,802 11,010 11,223 Annual Reconstruction (2)Internal use for debt levy reduction 85,000 85,000 ‐ 85,000 85,000 105,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Contribution to streets reconstruction 2024‐2026 ‐ ‐ ‐ ‐ ‐ ‐ 75,000 75,000 75,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 85,000 85,000 ‐ 85,000 85,000 105,000 75,000 75,000 75,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL STORMWATER CAPITAL PLAN 1,126,630 125,489 361,364 192,582 144,251 430,972 147,748 184,581 226,473 68,426 70,442 112,524 134,674 76,895 274,188 431,558 144,006 206,534 89,148 NOTES:(1) Final Project costs paid in 2017, subsequent year's costs are utilities and maintenance(2) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan Stormwater RetentionStormwater Retention 2004‐2005 Salo Pond North 2004‐2005 Salo Pond South 2003 Harding Pond 1962 Mirror Lake Stormwater Treatment SystemsStormwater Treatment Systems 2015 Silver Lake Stormwater Treatment Facility at Salo Pond 2016 St. Anthony Regional Stormwater Treatment System 2014 Central Park Rain Garden Stormwater ReuseStormwater Reuse 2008 Water Reuse Fountain Stormwater EquipmentStormwater Equipment 2006 Elgin Pelican Street Sweeper Fiscal Year 2020 SOURCES 2019 Est. Actual 2019 2020 2021 2022 2023 2024 2025-2030 2031-2036 Bond Proceeds 1,150,000$ 1,213,141$ 1,982,000$ 2,352,000$ 2,351,000$ 1,826,000$ 2,413,000$ 14,358,000$ 1,819,000$ Road Improvement Levy 1,914,886 1,914,886 1,927,204 1,928,941 1,948,102 1,990,213 2,399,681 15,646,465 12,331,369 Prepaid Assessments - - 166,152 146,548 173,867 146,189 205,641 1,222,486 485,163 MSA Funds - not part of DLR - - - - 30,000 60,000 340,000 1,250,000 1,250,000 Grant Funding - - - - - - - - - Debt Levy Reduction Funding 377,509 377,509 343,177 375,591 313,049 302,016 13,722 - - Miscellaneous - - - - - - - - - TOTAL 3,442,395$ 3,505,536$ 4,418,533$ 4,803,080$ 4,816,018$ 4,324,418$ 5,372,044$ 32,476,951$ 15,885,532$ USES Streets/Utilities Reconstruction (1)1,471,640$ 1,471,640$ 1,915,440$ 2,372,212$ 3,275,140$ 2,256,639$ 2,603,009$ 15,251,045 - Mill and Overlays - - - - - - - 253,278 1,808,914 Alleys - - - - - 80,000 60,000 188,851 373,380 Sidewalks/Street Lights - - - - - - - 458,481 1,723,111 Road Improvement debt 2,292,395 2,292,395 2,258,694 2,293,275 2,250,324 2,281,832 2,273,813 14,983,742 14,482,420 Miscellaneous - - - - - - - - - TOTAL 3,764,035$ 3,764,035$ 4,174,134$ 4,665,487$ 5,525,464$ 4,618,471$ 4,936,822$ 31,135,397$ 18,387,826$ NET CHANGE (321,640)$ (258,499)$ 244,399$ 137,593$ (709,446)$ (294,053)$ 435,222$ 1,341,555$ (2,502,294)$ BEGINNING ACTIVITY - (321,640) (321,640) (77,241) 60,352 (649,094) (943,147) (943,147) 398,408 CUMULATIVE ACTIVITY (321,640)$ (580,139)$ (77,241)$ 60,352$ (649,094)$ (943,147)$ (507,925)$ 398,408$ (2,103,886)$ STREETS IMPROVEMENT PLAN 2020 - 2036 STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2019 EST. ACTUAL 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Street /Utility Reconstruction Program Foss, Macalaster and Highcrest 2018 Debt Levy/Assmts/Grants & Aids 2,638,200 527,640 527,640 - - - - - - - - - - - - - - - Silver Lake Rd Flood Mitgation, County Rd C - Utilities & Trails 2019 Debt Levy/Assmts/Grants & Aids 1,180,000 944,000 944,000 236,000 - - - - - - - Croft Dr, 32nd Ave and Silver Lake Terrace 2020 Debt Levy/Assmts/Grants & Aids 2,099,300 1,679,440 419,860 - - - - - - Skycroft Dr, Croft Dr, 31st Ave. Silver Lane M/O 2021 Debt Levy/Assmts/Grants & Aids 2,440,440 - - 1,952,352 488,088 - - - - - - - - - - - - No. Rankin, Townview 2022 Debt Levy/Assmts/Grants & Aids 3,483,815 - - - - 2,787,052 696,763 - - - - - - - - - - - So. Rankin 2023 Debt Levy/Assmts/Grants & Aids 1,949,845 - - - - - 1,559,876 389,969 - - - - - - - - - - Penrod , MaCalaster 2024 Debt Levy/Assmts/Grants & Aids 2,766,300 - - - - - - 2,213,040 553,260 - - - - - - - - - Shamrock, Fordham 2025 Debt Levy/Assmts/Grants & Aids 2,565,700 - - - - - - - 2,052,560 513,140 - - - - - - - - Skycroft and Downers 2026 Debt Levy/Assmts/Grants & Aids 2,776,800 - - - - - - - - 2,221,440 555,360 - - - - - - - Skycroft Cir. and Skycroft Dr 2027 Debt Levy/Assmts/Grants & Aids 2,945,000 - - - - - - - - - 2,356,000 589,000 - - - - - - - So. Anthony Ln 2028 Debt Levy/Assmts/Grants & Aids 3,375,500 - - - - - - - - - 2,700,400 675,100 - - - - - - - No. Anthony Lane 2029 Debt Levy/Assmts/Grants & Aids 3,034,785 - - - - - - - - - - 2,427,828 606,957 - - - - - - TOTAL RECONSTRUCTION 31,255,685 1,471,640 1,471,640 1,915,440 2,372,212 3,275,140 2,256,639 2,603,009 2,605,820 2,734,580 2,911,360 3,289,400 3,102,928 606,957 - - - - - - Mill and Overlays Estimated M/O program 2023+Debt Levy/Assmts TBD - - - - - - - - - - 253,278 265,942 279,239 293,201 307,861 323,254 339,417 TOTAL MILL AND OVERLAY - - - - - - - - - - - - - 253,278 265,942 279,239 293,201 307,861 323,254 339,417 Alleys Coolidge -1 2026 Debt Levy/Assmts 98,851 - - - - - - - - - 98,851 - - - - - - - - - Roosevelt-1 2020 Debt Levy/Assmts 80,000 - - - - - 80,000 - - - - - - - - - - 145,000 - Pahl Ave. area -3 2022 Debt Levy/Assmts 90,000 - - - - - - - 90,000 - - - - - - - - 133,509 - - Alleys North of Sliver Lake Blvd 2021 Debt Levy/Assmts 60,000 - - - - - - 60,000 - - - - - - - - 94,871 - - - TOTAL ALLEYS 328,851 - - - - - 80,000 60,000 90,000 - 98,851 - - - - - 94,871 133,509 145,000 - Sidewalks / Intersections / Signals / Lighting / Drainage Sidewalk / Lighting Stinson South of 37th 2028-29 Debt Levy 299,785 - - - - - - - - - - - - - 401,400 222,355 Sidewalk / Lighting Stinson Boulevard South of 33rd 2030-31 Debt Levy 374,731 - - - - - - - - - - - - - - - - 294,871 303,717 - Street lighting 37th Avenue NE (County Road D)2030 Debt Levy 327,890 - - - - - - - - - - - - 458,481 - - - - - - Street lighting 33rd Avenue NE (County Road C2)2026 Debt Levy 368,876 - - - - - - - - - - - - - - - 500,768 - - - TOTAL SIDEWALKS/LIGHTING ETC.1,371,282 - - - - - - - - - - - - 458,481 401,400 222,355 500,768 294,871 303,717 - TOTAL STREETS IMPROVEMENT PLAN 32,955,818 1,471,640 1,471,640 1,915,440 2,372,212 3,275,140 2,336,639 2,663,009 2,695,820 2,734,580 3,010,211 3,289,400 3,102,928 1,318,716 667,342 501,594 888,840 736,241 771,971 339,417 City of St. Anthony Debt Levy - Roads, Tax Abatement, Public Facilities 802,382 897,435 916,965 920,850 929,565 937,755 950,670 729,039 565,647 142,865 138,581 139,547 140,033 2020 Levy Year 60 61 62 63 64 2018 2019street 2020 Street 2021 2022 Existing Bonds Fund 2012 2013 2014 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 132,028 134,286 $1,305,000 - 2008A (2014C) 365 175,652 177,319 178,526 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,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 106,150 $1,375,000 - 2010A (Refunded in 2019A)514 108,587 112,065 110,175 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 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 223,441 226,430 223,537 109,589 $9,495,000 - 2012A (2006A & 2007A) 503/518 324,405 423,185 518,973 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 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 - - - 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 - - - 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,585 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 Total Levy 1,500,755 1,577,184 1,791,659 2,154,706 2,236,431 2,292,395 2,258,694 2,153,415 1,938,212 1,767,303 1,598,830 1,407,398 1,295,664 1,167,238 1,036,295 916,508 764,449 580,375 477,863 281,630 102,742 - - - - - - 2020 Road Improvements Bonds $1,982,000 - 2020A 2020A 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 139,860 2021-2027 Road Improvements Bonds $2,352,000 - 2021A 2021A 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 172,252 $2,351,000 - 2022A 2022A 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 202,417 $1,826,000 - 2023A 2023A 160,454 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,413,000 - 2024A 2024A 211,100 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 $2,502,000 - 2025A 2025A 219,153 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 $2,628,000 - 2026A 2026A 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 $2,787,000 - 2027A 2027A 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 $2,889,000 - 2029A 2029A 252,162 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 $2,872,000 - 2031A 2031A 252,162 252,162 252,162 252,162 252,162 252,162 252,162 252,162 252,162 2030-2032 Mill/Overlays, Sidewalks and Street Lighting $680,000 - 2028A 2028 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 $544,000 - 2030A 2030 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 $461,000 - 2032A 2032 38,661 49,216 49,216 49,216 49,216 49,216 49,216 49,216 $814,000 - 2033A 2033 68,215 68,215 68,215 68,215 68,215 68,215 68,215 Additional levy - - - - - - - 139,860 312,112 514,529 674,983 883,143 1,095,693 1,325,616 1,571,540 1,634,018 1,886,179 1,921,318 2,173,480 2,212,140 2,290,911 2,290,911 2,151,051 1,978,799 1,776,382 1,618,867 1,414,371 Road levy before debt reduction 1,500,755 1,577,184 1,791,659 2,154,706 2,236,431 2,292,395 2,258,694 2,293,275 2,250,324 2,281,832 2,273,813 2,290,541 2,391,357 2,492,854 2,607,835 2,550,526 2,650,629 2,501,693 2,651,343 2,493,770 2,393,653 2,290,911 2,151,051 1,978,799 1,776,382 1,618,867 1,414,371 Stormwater Utilty (150,000) (95,000) (85,000) - (85,000) (85,000) (105,000) - - - - - - - - - - - - - - - - MSA Advance (85,000) (168,000) (152,500) - (10,000) (75,688) Excess Bond Balance/Project Savings (92,500) (140,000) (140,009) (215,310) (189,300) (213,115) (107,000) Conduit Fee/ 2010 & 2011 refunding savings/assmts (15,079) (116,180) (80,034) (4,107) (3,931) (3,756) (3,520) (0) Public Facilities/Abatement Excess (35,000) (55,000) (60,000) (75,000) (70,000) (75,000) (80,000) Infrastructure Levy - 64,812 184,933 176,927 75,430 (39,551) 17,758 (82,345) Road improvement levy 1,500,755 1,577,184 1,776,580 1,792,206 1,778,431 1,854,886 1,852,204 1,858,941 1,873,102 1,910,213 2,334,869 2,471,954 2,568,284 2,568,284 2,568,284 2,568,284 2,568,284 2,501,693 2,651,343 2,493,770 2,393,653 2,290,911 2,151,051 1,978,799 1,776,382 1,618,867 1,414,371 % Increase in Road levy 5.09%12.64%-2.00%-0.77%4.30%-0.14%0.36%0.76%1.98%22.23%5.87%3.90%0.00%0.00%0.00%0.00%-2.59%5.98%-5.94%-4.01%-4.29%-6.10%-8.01%-10.23%-8.87%-12.63% $ Increase in Road levy 76,429 199,396 (36,641) (13,775) 76,455 (2,682) 6,737 14,160 37,111 424,656 137,085 96,330 1 (1) (0) 0 (66,591) 149,650 (157,572) (100,118) (102,742) (139,860) (172,252) (202,417) (157,514) (204,497) TAX ABATEMENT (2016B/2017A) 149,395 146,480 151,025 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 396,207 399,882 403,347 406,602 414,897 422,683 424,289 - - - - - - - - - - - - - - - - - 559,168 525,677 529,487 621,084 627,312 626,000 634,977 643,482 651,321 658,071 233,415 96,390 - - - - - - - - - - - - - - - FLATL LINE 2,854,932 Total levied debt after reduction 2,059,923 2,102,861 2,306,067 2,413,290 2,405,743 2,480,886 2,487,181 2,502,423 2,524,423 2,568,284 2,568,284 2,568,344 2,568,284 2,568,284 2,568,284 2,568,284 2,568,284 2,501,693 2,651,343 2,493,770 2,393,653 2,290,911 2,151,051 1,978,799 1,776,382 1,618,867 1,414,371 0 60 (60) 1 (1) (0) 0 (66,591) Total levied debt before reduction 2,059,923 2,102,861 2,321,146 2,775,790 2,863,743 2,918,395 2,893,671 2,936,757 2,901,645 2,939,903 2,507,228 2,386,931 2,391,357 2,492,854 2,607,835 2,550,526 2,650,629 2,501,693 2,651,343 2,493,770 2,393,653 2,290,911 2,151,051 1,978,799 1,776,382 1,618,867 1,414,371 % Increase in Debt Levied 2.08%9.66%1.77%-0.31%3.12%0.25%0.61%0.88%1.74%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-2.59%5.98%-5.94%-4.01%-4.29%-6.10%-8.01%-10.23%-8.87%-12.63% % Increase in Debt Scheduled to be levied 2.08%10.38%3.84%3.17%1.91%-0.85%1.49%-1.20%1.32%-14.72%-4.80%0.19%4.24%4.61%-2.20%3.92%-5.62%5.98%-5.94%-4.01%-4.29%-6.10%-8.01%-10.23%-8.87%-12.63% $ Increase in levied Debt 42,939 203,205 42,009 (7,547) 75,143 6,295 15,242 21,999 43,861 0 59 (60) 1 (1) (0) 0 (66,591) 149,650 (157,572) (100,118) (102,742) (139,860) (172,252) (202,417) (157,514) (204,497) 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 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Total Levied Debt before reduction Total Levied Debt after reduction Z:\Budget 2020\Debt Levy\Final 2020 debt levy .xlsx 10/15/2019 SILVER LAKE STREET & UTILITY RECONSTRUCTION PROGRAM 2022 2021 2024 2023 2025 2026 Schedule subject to change 2027 2020 MILL & OVERLAY PROGRAM 2028 2021: SILVER LANE St. Anthony Village, Minnesota Street & Utility CIP for 2020 and Beyond Revised June 2020 N 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