Loading...
HomeMy WebLinkAboutCouncil Packet - 3/15/2021 COUNCIL WORK SESSION March 15, 2021 Time indicated below Meeting will be held virtually via Zoom. Visit https://cityofwaterlooiowa.coni/register and register to receive the Zoom meeting information. Please contact the City Clerk's Office at 319-291-4323 with questions. ELECTRONIC CITY COUNCIL MEETINGS At this time, all meetings of the Waterloo City Council will be electronic because meeting in person is impossible or impractical due to the spread of COVID-19. Iowa Code Section 21.8, Governor Reynolds' Disaster Emergency Proclamations allow cities to hold electronic meetings and Mayor Hart has issued Civil Emergency Proclamations calling for electronic meetings. Electronic meetings will be held utilizing Zoom video conferencing. Zoom meeting information is available on the city website at https://cityofwaterlooiowa.com/register. You may also call the City Clerk's Office at 319-291-4323 or email clerks@waterloo-ia.org to receive the meeting information. Individuals speaking during the electronic regular session or planning session meetings are required to follow the rules for public participation. RULES FOR WORK SESSION PUBLIC COMMENT Iowa Code Chapter 21 gives the public the right to attend council meetings, but it does not require cities to allow public participation except during public hearings. The city council shall not receive any public comment during a work session. Roll Call Agenda, as proposed or amended Approval of Minutes Minutes of March 1, 2021, as proposed. 3:45 p.m. Discussion on the Dunsmore House. Submitted By:Noel Anderson,Community Planning and Development Director Approx. Discussion of the FYE2022 budget. 4:05 p.m. Submitted By:Michelle Weidner,Chief Financial Officer ADJOURNMENT Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Minutes of March 1, 2021, as proposed. City Council Meeting: 3/15/2021 Prepared: REVIEWERS: Department Reviewer Action Date Clerk Office Higby, Nancy Approved 3/8/2021 -4:23 PM ATTACHMENTS: Description Type ❑ Minutes of March 1, 2021 Backup Material COUNCIL WORK SESSION March 1, 2021 3:40 p.m. Meeting was held via Zoom. Members present: Boesen, Amos, Morrissey, Klein, Grieder, and Juon. Absent: Feuss. 159570 -Juon/Boesen that the Agenda, as proposed, be approved. Voice-vote Ayes: Six. Motion carried. 159571 -Juon/Boesen that the Minutes of February 15,2021, as proposed,be approved. Voice-vote Ayes: Six. Motion carried. Objective: Discussion of infill development located at the former Edison School site. Noel Anderson, Community Planning and Development Director, explained that the city received the property in a property exchange agreement with the Waterloo School District. The city has a good track record of doing infill development at former school sites, including developments at the former Lincoln and Irving Schools. On April 27, 2020 the department sent out RFP process but did not receive official proposals back. The city has several current proposals out there looking at developing the site and explained the different proposals. City staff has mapped out where it would be most feasible to place commercial property along Falls and the remaining portion to be one or two-family homes. The townhome design that is potentially being proposed would require a rezoning action and it would need to have input from city council, planning and zoning commission, and the neighborhood. Leisure Services has always maintained this, in part, as a park site of approximately 1-2 acres. He explained that one developer has already put forth a proposal to the Community Development board and has spoken with several council members, so it will be important to get council's direction on how they would like to proceed with the numerous interested parties and the pending action timeline for the Community Development board. Mrs. Juon commented that the neighbors prefer the 1-2 family homes with maintaining a park. Paul Hutting, Leisure Services Director, shared that department is looking to recreate a park, approximately 1-2 acres in size,with street access so that it is visible and safe. He stated that he has had Mark Kuiper with Kuiper-Ritland Landscaping to draw up some park designs and that they have been working with the neighborhood to get their input. Rachel Neil, Edison Neighborhood Association, commented that having an easily accessible park for the neighborhood is very important. She explained that the preference of the neighbors is to have single-family homes or duplexes, but that four-plex homes was a concern as far as blending into a neighborhood of primarily ranch style homes. Mr. Morrissey commented that he supports the neighborhood's vision for the infill development. Mr. Feuss joined at 3:52 p.m. Mr. Boesen commented that he understands the single family or duplex concept and noted that he has seen and likes some of the townhouse designs. He stated that there would be$6.2 million in residential assessed value with townhouses and less than half of that with just single-family or duplex homes. He agrees with having street access to the park is important and that he would be agreeable to townhomes at Falls Avenue. Mrs. Klein commented that she concurs with Mr. Boesen comments. Mr. Amos commented that he wants to see council move forward with a development that fits with the neighborhood. Page 2 Mr. Grieder commented that the city needs to find compromise between what the neighborhood wants and what will give us the biggest bang for our buck from a tax and development standpoint. Mrs. Juon commented that she would support the townhouses going toward Falls Avenue but that she would also like to see an inclusion park. Mayor Hart questioned what the council would like to see as a process going forward. Mr. Morrissey commented that he would like to see a couple developers go over the project with the leaders of the neighborhood on what they do and do not want to see happen. Mrs. Klein commented that she would like to hear what they have to say for three minutes. Mr. Boesen questioned if the city has the budget for building an inclusive park. Paul Hutting commented that they will need to work on funding. Mark Kuiper, Kuiper-Ritland Landscaping, commented that it would roughly cost $1,000,000, and grant funding would be available, and fund raising would be necessary. Mayor Hart stated that each developer would be given 3-4 minutes to give Jon Brundrett, Johnny B Construction, provided an overview of his proposal. Chris Fischels, Potential Developer,provided an overview of his proposal. Tim Combs, AFIL, provided an overview of his proposal. Mrs. Klein questioned if financing is in order for Mr. Combs' project. Tim Combs explained that they do have several investors but do not currently have 100 percent of the funds raised. They are working on putting together a capital campaign and have begun reaching out to all of the Black Hawk County veteran's organizations to help with fund raising activities to help make this happen. Mrs. Klein questioned why Mr. Brundrett's condominium association proposes just a ten-year maintenance, as her association is ongoing. Mr. Brundrett explained that the ten years is for maintenance of the city park, not the condominium grounds, which would be forever. Mrs. Klein commented that the neighborhood wants to see housing and that is what she would like to see as well. Mayor Hart questioned if there is a way to combine the housing and commercial proposals. Noel Anderson commented that staff had looked at the possibility of doing both but it would be up to the developers if they want to change their site plans to make that work. Mrs. Juon commented that she is leaning toward the Magnolia Place proposal. Mr. Grieder commented that Mr. Combs' project should move forward somewhere in our community as a support network for homeless veterans is badly needed. Mr. Boesen commented that the Magnolia Place proposal is set up for down payment assistance on at least six units for up to $240,000, which he understands has some time sensitivity through the Community Development program. Page 3 Mr. Brundrett confirmed and explained there is currently a verbal agreement with Community Development on down payment assistance, which is time sensitive. He added that they have been working with Green State Credit Union who has already developed an in-house and secondary market mortgage program to qualify buyers, and that an additional $5,000 per unit developer grant will be passed on to any buyer, whether they are low-income or not. Mr. Feuss commented that housing seems like a logical choice given what we have heard from the neighborhood. With the University Avenue Project ending and several businesses currently in the area, it would be beneficial to have additional homes to support these enhancements. Mayor Hart thanked the developers and council for their flexibility and added that it is a great to see so much competition for future development. Objective: Discussion on amending Waterloo City Code Section 5-2-13(B), Fireworks, by prohibiting use of consumer and display fireworks. Mrs. Klein commented that the amount of fireworks in Waterloo caused the air quality of the community to diminish so far that the city experienced an environmental event that gained national attention. She stated that fireworks are hard on residents, pets, and people with health conditions including PTSD. She asked that the council consider banning fireworks again. Mr. Grieder commented that as a parent with young children it was very difficult to endure the fireworks use in the community. He spoke as well with constituents that have PTSD who shared that this time was particularly difficult. He questioned what can be done to better support the police and fire department with enforcement. Mr. Amos commented that the council went through the whole gambit of banning and not banning for a certain number of days. When it was banned in the past the call volume was the same. He questioned why we are forcing our citizens to be illegal when they could be responsible and use fireworks around the 4th of July. He added that he does not believe banning fireworks will change much of anything. Mr. Boesen commented that he agrees with Mrs. Klein and Mr. Grieder. He stated that he lives in south Waterloo and it is like a war zone out in his community. The problem he sees is that in the last three years the city has issued one citation out of 1,666 calls for service. In 2020, calls for service were 686,more than double that of 2019. The minute people start shooting fireworks he begins getting calls and texts day and night from constituents. No matter what plan we have, the plan is not working. He added that he supports the ban. Mrs. Juon stated that the ban previously reduced the calls for service. When the ban was lifted the calls for service doubled. The ban cuts down the number of fireworks and the council owes it to children,people with PTSD, and animals to ban fireworks. She added that it would be great for neighbors to step up and take photos of illegal use to help support the police department. She added that several organizations have professionally run fireworks shows. Mr. Morrissey stated that he opposes any changes to the fireworks ordinance because the current ordinance is a compromise. He called for robust enforcement of the current ordinance. Chief Joel Fitzgerald commented that Iowa law makes it very difficult to arrest or cite someone for using fireworks. He asked the council what robust enforcement looks like to them. A city of 68,000 citizens has less than 100 officers on the street at any one time. They are overwhelmed with calls during that time and does not want to pull officers off gunshots or other serious calls to address nuisance calls. Mrs.Juon shared historical data of calls for service for the various levels of permissive use versus banning. She added that most of our neighboring cities have a ban. Mr.Amos questioned if it was possible to separate the 800 plus calls for service received in 2020 into categories of inside verses outside the legal window. Page 4 Chief Fitzgerald explained that it would be difficult at this point since the calls were not initially captured that way. He said that some calls were changed from a gunshot call to a fireworks call when there was no way to prove it was a gunshot. He commented that the department could do better in capturing more information on fireworks calls in the future. Mr. Morrissey asked to have the call data separated to show a breakdown of when calls occurred versus when the use was legal/illegal. Mr. Boesen clarified that sometimes illegal use is occurring when use is permitted, such as in city parks. Mayor Hart four council members want the ordinance to move forward for a vote. Objective: Discussion of FYE2022 budget. Mayor Hart shared next steps with the budget. Michelle Weidner, Chief Financial Officer, shared an overview of the dollar amounts listed in the maximum levy. Council then discussed the FYE2022 budget with the Mayor and Chief Financial Officer. 159572 -Juon/Feuss that the meeting be adjourned at 5:11 p.m. Voice-vote Ayes: Seven. Motion carried. Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Discussion on the Dunsmore House. City Council Meeting: 3/15/2021 Prepared: 3/3/2021 REVIEWERS: Department Reviewer Action Date Water Works Felchle, Kelley Approved 3/3/2021 - 3:07 PM SUBJECT: Discussion on the Dunsmore House. Submitted by: Submitted By: Noel Anderson. Community Planning and Development Director Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: CITY OF WATERLOO Council Communication Discussion of the FYE2022 budget. City Council Meeting: 3/15/2021 Prepared: 3/3/2021 REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/3/2021 - 3:09 PM ATTACHMENTS: Description Type ❑ FY22 Budget Published 3/15/2021 Backup Material ❑ Rate Impacts FYE22 March 14 Backup Material ❑ Breakout of Staff Budget Requests Backup Material SUBJECT: Discussion of the FYE2022 budget. Submitted by: Submitted By:Michelle Weidnerr, Chief Financial Officer Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGEI FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.370%,16 CHANGE CHANGE 4 5 PUBLIC SAFETY 6 010-11 -1100 POLICE OPERATIONS 1C 14,705,497 16,306,599 10.89% 720,876 1 ,128,642 13,984,621 15,177,957 1 ,193,336 8.53% 7 010-11 -1105 POLICE COMPUTER SERVICE 1C 242,966 259,968 7.00% 0 0 242,968 259,968 17,000 7.00% 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 1C 171 ,035 0 -100.00% 0 0 171 ,035 0 (171 ,035) -100.00% 9 200-11 -1140 POLICE PENSION ID 2 ,5151650 2 ,689 ,851 6.92% 0 0 21515,650 2,669,851_ 1741201 6.92% M1112 010-11 -1150 POLICE GRANTS 1C 615 ,526 744,735 20.99% 615,526 744,735 0 0 0 0.00% 010-11 -1150 POLICE GRANTS (DISCR H/M) 1C 0 0 0.00% 0 0 0 0 0 0,00% 010-11-1160 LAW ENFORCEMENT PROGRAMS 1C 895 ,000 963,483 7.65% 895,000 963,483 0 0 0 0.00% 13 010-11 -1165 POLICE TOBACCO ENFORCEMENT 1C 5,500 51500 0.00% 51500 5,500 0 0 0 0.00% 14 010-01-1700 B.H. COUNTY EMA/SIREN MAINTENANCE 3C 96,012 96, 187 0 . 18% 0 096,012 96, 187 175 0.18% 15 010-12-1400 FIRE RESCUE 5C 9,972,101 109697,952 7.28% 61 ,850 62,850 9,910,251 10,635,102 724,851 7.31 % 16 010-12-1402 FIRE RESCUE CHARGEBACKS 5C 34,169 36, 107 5.67% 34,169 36,107 0 0 0 0.00% 17 010-18-1405 FIRE-GARAGE PARTS & SERVICE 5C 1979672 203,764 3.08% 0 0 197,672 203,764 6,092 3.08% 18 200-12-1420 FIRE PENSION 5D 11750,706 1 ,920,123 9.68% 0 0 1 ,750,706 1 ,920,123 169,417 9.68% 19 010-12-1412 FIRE RESTRICTED PROGRAMS 5C 25,305 25,305 0.00% 25,305= _ 25,305 01 0 _ 0 0.00% 20 010-12-1415 HAZARDS REGIONAL RESPONSE TRG FROG 5C 181 ,357 187,873 3.59% 1 166,500 166,500 14,857 21 ,373 I _ 6,5_16 43.86% 21 010 12-1425 FIRE SAFER GRANT 5C 0 284, 192-NEW 0 284,192 0 0 _ _ _ 0 0.00% 38 22 010-12-1410 FIRE AMBULANCE SERVICE 6C 21363,384 3,3635485 42.32% 25258,000 31508,500 105, 4 (1459015) (250,399) -237.61 % 23 200.12-1410 FIRE AMBULANCE SERVICE PENSION 377,032 4019770 377,032 401 ,770 24,738 6.56 24 010-18-1411 AMBULANCE-GARAGE PARTS & SERVICE 6C 38,500 38,500 0.00% 0 0 38,500 38,500 0 0.00% 25 010-22-5100 BUILDING INSPECTION 7C 19237,379 1 ,188,997 -3.91 % 11526,713 1 ,518,965 (289,334) (329,968) (40,634) 14.04% 26 010-22-5102 BLDG INSPECTION CHARGEBACKS (OUT) 7C 112,296 120,044 6.90% 112,296 120,044429,115o354 0 0 0.00% 27 010-22-5102 BLDG INSPECTION CHARGEBACKS (IN) 7C 11 ,768 12,001 1 .98°k 11 ,768 12,001 0 0 0.00% 28 29 TOTAL-PUBLIC SAFETY 11C 35,548,857 39,546,436 11 .25% 6,433,503 8,576,82430,969,612 11854,258 6.37% 30 Less Fund 200 (4,6430388) (590115744) 31 TOTAL-GENERAL FUND 3099053469 34,534,692 32 PUBLIC WORKS 33 010-07-7650 SIDEWALKS 12C 2155000 215,000 0.00% 2153000 215,000 0 0 0 0.00% 34 010-17-7910 PARKING FACILITY MAINTENANCE 13C 18,960 9$ 00 -50.95% 0 0 18,960 91300 =439877 0.95% 35 010-22-7930 PARKING OPERATIONS 13C 527,500 515,000 -2.37% 527,500 515,000 0 00.00% 36 010-29-7700 AIRPORT OPERATIONS 19C 1 ,148,707 11143,499 -0.45% 1 ,148,707 11032,560 0 110,939NEW 37 010-01 -7800 MET TRANSIT AUTHORITY 21C 194620588 11506,465 3.00% 0 0 1 ,462,588 1 ,506,465 .00% 38 010-18-7950 CENTRAL GARAGE 21C 511 ,285 582,061 13.84% 85,300 85,300 425,985 496,761 .61 % 39 010-18-7952 CENTRALGARAGE - CHARGEBACKS 21C 530,000 530,000 0.00% 530,000 530,000 0 0 .00% 40 010-18-7955 MOTOR POOL-PASS THROUGH ACCOUNT 21C 2,048,468 2,0489468 0.00% 2,069,559 2,0693559 (211091 ) (21 ,091 ) 0 0.00% 41 42 TOTAL-PUBLIC WORKS 22C 61462,508 6,549,793 1 .35% 4,576,066 41447,419 11886,442 2,1021374 215,932 11 .45% 43 44 HEALTH & SOCIAL SERVICES 45 010-27-2500 HUMAN RIGHTS COMMISSION 29C 278,760 294,554 5.67% 0 0 278,760 294,554 15,794 5.67% 46 010-27-2505 EEOC CONTRACT 29C 451000 45,000 0.00% 45,000 452000 0 0 0 0.00% 47 010-27-2510 FAIR HOUSING ENFORCEMENT 29C 0 0 0.00% 0 0 0 0 0 0.00% 48 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 29C 0 0 0.00% 0 0 0 0 0 0.00% 49 010-27-2520 HUMAN RIGHTS PROJECTS 29C 0 0 0.00°/ 0 0 0 0 0 0.00% 50 51 TOTAL-HEALTH & SOCIAL SERVICES 30C 1 323,760 1 339,554 1 4,88% 1 45,000 1 459000 1 278,760 1 294,554 1 15,794 1 52 K :\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx 1 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L I M 1 CERT FY 2021 BUDGE7 FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24647 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37% CHANGE CHANGE 4 52 CULTURE & RECREATION 53 010-01 -4405 CEMETERY OPERATIONAL SUBSIDY 35C 50,000 709000 40.00% 0 0 501000 70,000 20,000 40.00% 54 010-01 -4220 GROUT MUSEUM 32C 652,746 655,955 0.49°k 22,571 22,850 630,175 633,106 2,931 0.47°h 55 010-26-4208 YOUTH PAVILION 32C 4159106 4119761 -0.81 % 105,600 88,800 309,506 322,961 13,455 4.35% 56 010-26-4250 CENTER FOR THE ARTS 32C 811 ,271 850,662 4.86% 160,000 160,000 651 ,271 690,662 39,391 6.05% 57 010-26-4251 RIVERLOOP EVENT FACILITIES 32C 15,958 15,958 0.00% 17,500 17 ,500 (1 ,542) (1 ,_542) 0 0.00% 58 010-26-4265 C&A GRANTS & PROJECTS 32G 94,000 94,000 0.00% 94 ,000 94 ,000 0 0 0 0,00% 59 010-26-4265 CENTER FOR THE ARTS (HIM) 32C 0 0 0.00% 0 0 0 0 0 0.00% 60 010-26-4265 CENTER FOR THE ARTS (DISCR H/M) 32C 19, 191 19,581 2.03% 19 , 191 190581 0 0 0 0,00% 61 010-33-3100 LIBRARY SERVICES 31C+levy 1 ,894,377 1 1 ,981 ,757 4.61 % 1 18,560 81000 1 ,875,817 1 ,973,757 1 97,940 5.22% 62 010-33-3110 LIBRARY - ENRICH IOWA GRANT 31C 18,417 19,184 4. 16% 18,417 19,184 0 0 0 0.00% 63 010-33-3150 LIBRARY OPEN ACCESS PLUS 31C 31000 41000 33.33% 31000 41000 0 0 0 0.00% 64 010-33-3160 LIBRARY GRANTS 31C 51 ,865 53,065 2.31 % 51 ,865 53,065 0 0 0 0.00% 65 010-33-3180 LIBRARY GIFT & MEMORIAL 31C 51000 51000 0.00% 51000 51000 0 0 0 0.00% 66 010-33-3190 IOWA LIBRARY SERVICE 31C 41120 41120 0.00% 41120 4,120 0 0 0 0.00% 67 010-33-3200 COUNTY LIBRARY 31C 69,633 70,940 1 .88% 69,633 70,940 0 0 0 0.00% 68 010-33-3210 LIBRARY OPEN ACCESS 31C 10,000 10,000 0.00% 10,000 10,000 0 0 0 0.00% 69 010-37-4100 LEISURE SERVICES - PARKS 33C 11767 ,705 1 ,934 ,002 9.41 % 39 ,737 39,737 1 ,727 ,968 1 ,894,265 j 166,297 9.62% 70 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACK 33C 950,000 950,000 0.00% 950,000 950,000 0 0 _ 0 0.00% 71 010-37-4105 LEISURE SERVICES PROJECTS 33C 7 ,000 7 ,000 0.00% 71000 lr — 79000 0 0 0 0.00% 72 010-37-4105 LEISURE SERVICES PROJECTS (H/M) 33C 0 0 0.00% 0 0 0 0 0 0.00°/ 73 010-37-4110 LEISURE SERVICES - DOWNTOWN MTCE 33C 405,225 4261728 5.31 % 0 0 405,225 426,728 21 ,503 5.31 % 74 010-37-4120 GOLF COURSES 34C 1 ,196,006 1 ,264,009 5.69% 838,782 837,779 357,224 426,230 69,006 19.32% - - -- - 75 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARG 34C 81504 81188 -3.72% 81504 81188 0 0 0 0.00% 76 010-37-4180 SPORTSPLEX 34C 11437 ,500 11437,500 0.00% 1_34370500 _ 11437,500 0 0 0 0.00% 77 010-374200 SPORTS & YOUTH SERVICES 34C 6383187 656,246 2.83% 2822400 282 ,400 355,787 373,846 181059 5.080%/o 78 010-37-4500 YOUNG ARENA 36C 818,771 8370020 2.23% 719,000 7196000 99,771 E69928,033 ,020 18,249 18.29% 79 80 TOTAL-CULTURE & RECREATION 38C 1193439582 11 ,786,676 3.91 % 4,882,380 41858,644 69461 ,202 4669831 7.23% 81 82 COMMUNITY & ECONOMIC DEVELOPMENT 83 010-08-5700 PLANNING & ZONING 42C 6809512 7123475 4.70% 2581155 447,155 422,357 2659320 (157,037) -37.18% 84 010-08-5702 PLANNING & ZONING CHARGEBACKS 42C 21 ,151 22,907 8.30% 21 ,151 22,907 0 0 0 0.00% 85 010-08-5750 RECREATION AREA DEVELOPMENT 43C 700 700 0.00% 53,000 53,000 (52,300) (52,300) 0 0.00% 86 010-08-5885 CITY PROPERTY MANAGEMENT 43C 145,200 145,200 0.00% 0 0 145,200 145,200 0 0.00% 87 010-01-5710 INRCOG MEMBERSHIP 43C 34,887 35,572 1 .96% 0 _ 0 3.4_,887 35,572_ 685 1 .96% 88 010-08-6100 PLANNING & ZONING-ECONOMIC DEVEL 40C 121 , 108 1232796 2%22% 121 , 108 123,796 0 0 0 0.00% 89 010-08-6105 ECONOMIC DEVELOP-SPECIAL PROJECTS 40C o 0 0,00% 0 0 0 0 0 0.00% 90 010-01 -6650 TOURISM PROMOTION-VARIOUS GRTS (H/M) 40C 270,000 270,000 0.00% 270,000 270,000 0 0 0 0.00% 91 010-01 -6660 TOURISM PROMOTION-VARIOUS DISCR (H/M) 40C 130 ,000 130,000 0.00°/ 130,000 130,000 0 0 0 0.00% 92 010-01 -6920 CONVENTION & VISITORS BUREAU (H/M) 40C 675 ,000 675,000 0.00% 675,000 675,000 0 0 0 0,00% 93 010-22-6860 SULLIVAN CENTER MAINTENANCE 43C 0 0 0.00% 507,482 507,482 (507,482) (507,482) 0 0.00% 94 010-01 -6860 SULLIVAN CENTER OPERATIONS 43C 21779,493 21779,493 0.00% 2,272,011 252720011 507,482 507,482 0 0.00% 95 010-32-5850 COMM DEVEL-ADMINISTRATIVE 41C 0 0 0.00% 0 0 0 0 0 0.00% 96 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 41C 62 ,440 62,440 0.00% 62,440 62,440 0 0 0 0.00% 97 0 0 0 0.00% 98 TOTAL-COMMUNITY & ECONOMIC DEV 45C 419200491 41957,583 0,75% 40370,347 4,5630791 550,144 3930792 1 (1561352) -28.42% 99 K:\USERS\MICHELLE-1MBudget FYE22\FY22 BUDGET-Published March 15 Print Copy.xlsx 2 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGETCODEJ ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIEDPUBLISHED LEVIED $ 19.24547 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18 ,44026 4.37% CHANGE CHANGE 4 100 � 101 GENERAL GOVERNMENT f 102 010-01 -8200 MAYOR'S OFFICE 46C 364,043 564,311 55,01 % 0 0 364,043 564,311 200,268 55.01 % 103 010-01 -8280 COMMUNICATIONS 46C 10,891 15,891 45.91 % 0 0 10,891 15,891 53000 45.91 ° 104 010-01 -8220 ADMIN SERVICES/MIS 46C 418,049 416,880 -0.28% 13,445 33445 404,604 413,435 8,831 2. 18% 105010-01 -8222 ADMIN SERVICES/MIS 46C 126,178 131 ,429 4.16% 126, 178 131 ,429 0 0 0 0.00°/ 106 010-02-8100 CITY COUNCIL 46C 78,499 79,085 0.75% 0 0 78,499 79,085 586 0.75% 107 010-03-8400 CITY CLERK AND FINANCE 47C 11352,795 1 ,444,392 6.77% 61175,236 51917,686 (4,822,441 ) (41473,294) 349, 147 -7.24% 108 010-03-8400 CITY CLERK AND FINANCE - ELECTION COST 48C 0 60,000 NEW 0 0 0 601000 60,000 NEW 109010-03-8402 CITY CLERK AND FINANCE - CHARGEBACKS 147C 77,500 161 ,437 108.31 % 155,627 161 ,437 (78, 127) 0 78, 127 100.00% 110 010-06-8600 ICITY ATTORNEY 149C 353, 135 361 ,597 2.40% 0 0 353,135 361 ,597 81462 2.40% 111 010-03-8900 LIABILITY INSURANCE 151C 114319858 1 ,630,969 13.91 % 0 0 1 ,431 ,858 19630,969 199, 111 13.91 % 112010-03-8902 LIABILITY INSURANCE - CHARGEBACKS 51C 5003000 500,000 0.00% 500,000 5009000 0 0 0 0.00% 113 010-03-8905 HEALTH/LIFE INSURANCE 0 0 0.00% 0 0 0 0 0 0.00% 114 010-03-8950 SELF FUNDED HEALTH INSURANCE 52C 3,883,241 2,770,000 28.67% 3,883,211 2,770,00030 0 (30) -100.00% 115 010-03-8960 SELF FUNDED WORK COMP 52C 777,457 837,457 7.72% 100,000 100,000 677,457 737,457 609000 8.86% 116 010-03-8150 PUBLIC ACCESS STUDIO 52C 160,849 169,934 5.65% 30,750 30,350 130,099 139,584 9,485 7.29°/ 117010-03-8970 IPRINTSHOP 52C 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% 118 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 52C 14,500 14,500 0.00% 0 0 14,500 14,500 0 0.00% 119 010-09-8250 HUMAN RESOURCES 52C 422,232 447,739 6.04% 0 0 422,232 447,739 25,507 6.04% 120 010-09-8252 HUMAN RESOURCES - CHARG 152C 32,500 32,500 0.00% 32,500 32,500 0 0 0 0.00% 121 010-09-8255 SAFETY COMMITTEE 52C17,500 17,500 0.00% 0 0 17,500 17,500 % NA0 0.00 122 010-22-8800 CITY HALUFACILITIES MAINTENCE 50C 678,051 700,217 3.27% 25,000 25,000 653,051 675,217 22, 166 I 3.39% 123 010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 150C 5,0$5 5,085. % �0.00% 5,085 - 5,085 0 '' 0 0 0.00%' 124 010-22-8850 VETERANS MEMORIAL HALL 150C 89815 1 81815 0.00% 0 0 8,815 8,815 0 1 0.00% 125 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 126 127 TOTAL-GENERAL GOVERNMENT 53C 10,776,650 10,433,210 -3.19% 11 ,047,032 93676,932 (270,382) 756,278 1 ,026,660 -379.71 % 128 129 130 TRANSFERS % ..- 131 010-03-9050 HOTEUMOTEL DEBT SERVICE TRANSFER 75C % % �11 % - 0 ,, % % . 0 . 000°h ,: , 0 -= , �. 0 ' 0' 0 0:00% 132 010-03-9050 TIF ECONOMIC DEV TRANSFER (INTERNAL TI 76C %% % 12%7;O0% 0 � '% - . % 11,000%, 15:75°/a >' " ' 127,000, =„ ,' 147,000 0 0' 0 0!00%' %% % % �, 133 010-08-9050 PLANNING & ZONING TRANSFER (TIF) % % 0;00%`. „ 134 TOTAL-TRANSFERS 77C 127,000 147,000 15.75% 127,000 147,000 0 0 0 0.00% 135 136 STATE REPLACEMENT FUNDS (COMM/IND ROLLBACK) 0 1 ,250,000 1 ,250,000 (1 ,250,000) (1 ,250,000) 0 0.00% 137 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% 750,000 21350,155 (750,000) (2 ,350, 155) (1 ,600, 155) 213.35% 138 BACKFILL ADJUSTMENT 0 0.00% 0 0 0 0 0 0.00% 139 0 140 TOTAL CITY BUDGET GENERAL FUND 69,502,848 73,760,252 6.13% 33,481 ,328 35,915,765 36,021 ,520 37,844,488 1 ,822,968 5.06% K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET—Published March 15 Print Copy.xlsx 3 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/ 15/21 A B D E F G H I J K L M 1 CERT FY2021 BUDGET FY2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES IFY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37°/ 4 CHANGE CHANGE 141 (o) 142 TAXABLE VALUATION FYE2021 FYE2022 Increase % Increase 143 (In Thousands) (In Thousands) (Decrease) (Decrease) 144 Taxable valuation - including TIF but excluding gas & electric utility values 2$ 39,996 20588,994 48,998 1 .93% 145 Taxable valuation - excluding TIF & gas & electric utility values 212555590 21271 ,583 15,993 0,71 % 146 Taxable valuation - including TIF and electric utility values 206180388 2,662,248 43,860 1 .68% 147 Taxable valuation - excluding TIF but including gas & electric utility values 21333,982 21344,837 101855 0.47% 148 Commercial/Industrial Property Rollback 107,173 1120840 51667 5.29% 149 CommerciaUlndustrial Property Rollback for Debt Service 111 ,833 112,840 1 ,007 0.90% 150 Taxable valuation - Ag Land 140891 15,138 247 1 .66% 151 Tax Askings per One Cent of Levy 238340 23,448 108 0.46% 152 78.00% 75.00% 153 PROPERTY TAX LEVY ANALYSIS: FY2021 TAX FY2021 TAX FY2022 TAX STATE BACKFILL FY2022 TAX $ AMOUNT 154 LEVY RATE LEVY CORP ROLLBACK RATE CHANGE 155 DEBT SERVICE LEVY 7,216,045 $ 2.75591 716019650 2411649 $ 2.85535 $ 385,605 156 POLICE & FIRE PENSION SYSTEM 416439388 $ 1 .98947 51011 ,744 180,884 $ 2.13735 $ 3689356 157 EMERGENCY MGMT COMMISSION LEVY 96,012 $ 0.04114 963187 38472 $ 0.04102 $ 175 158 TRANSIT LEVY 11462,588 $ 0.62665 1 $ 06,465 54,371 $ 0.64246 $ 43,877 159 TORT INSURANCE LEVY 1 ,431 ,858 $ 0.61348 11630,969 588865 $ 0.69556 $ 199,111 160 FICA/IPERS LEVY 21141 ,677 $ 0.91761 2,224,119 80,273 $ 0.94852 $ 82,442 161 HEALTH INSURANCE LEVY 50340,740 $ 2.28825 6$ 15,254 227,930 $ 2.69326 $ 974,514 162 WORKERS COMP, INSURANCE LEVY 677,457 $ 0.29026 737,457 26,616 $ 0.31450 $ 60,000 163 UNEMPLOYMENT LEVY 17,472 $ 0.00749 173472 631 $ 0.00745 $ 164 LIBRARY VOTED LEVY 630,175 $ 0.27000 6330106 22,850 $ 0.27000 $ 29931 165 EMERGENCY LEVY 630,175 $ 0.27000 633,106 221850 $ 0.27000 $ 21931 166 GROUT LEVY 630,175 $ 0.27000633,106 22,850 $ 0.27000 $ 2,931 167 AG LAND LEVY 44,729 459470 $ 741 168 GENERAL FUND $8.10 LEVY 18,9051254 $ 8.10000 18,993,177 6859503 $ 8.10000 $ 87,923 170 TOTAL PROPERTY TAX LEVY $ 43,867,745 1 $ 18.44025 $ 46,0791282 $ 19628,744 $ 19.24547 $ 292111537 $ 29205,675 171 ROLLBACK REPLACEMENT - GENERAL LEVY NCLLIDING EMPLOYEE BENEFITS LEVY, EXCL DEBT SERVICE $ 11341 ,395 $ 172 ROLLBACK REPLACEMENT - GENERAL LEVY $ 11052,276 173 ROLLBACK REPLACEMENT - EMPLOYEE BENEFITS LEVY $ 9,9090936 $ 3349819 174 AMOUNT CHANGE IN TAX LEVY $ 29211 ,537 $ 0.81 175 % CHANGE 5.04%b 4.37% 176 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT 0 $ 177 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) 189993,177 $ 19.24547 15.6164 178 $ 15.85012 1 .32905 179 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) 87,923 180 TOTAL PROPERTY TAX COLLECTION INCREASE 5.046/6 181 182 Maximum Levy under 384. 15A 35,346,621 $ 15.14435 37,1659950 $ 15.85012 11819,329 5.15% K:\USERS\MICHELLE-lMBudget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx 4 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON - CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J KI L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES-GENERAL FUND BUDGET CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.440264,37% CHANGE CHANGE 4 183 2,912,591 11093,266 �Tm184 Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 186 $ 19,24547 FYE2022 152,234 152,234 0.564094 1 ,652.69 106.63 8.89 6.90% 187 $ 18.44026 FYE2021 152,234 152,234 0.550743 11546. 07 25.56 2. 13 1 .68% 188 $ 17.54799 FYE2020 1529234 152,234 0.56918 11520.51 42.44 3.54 2.87% 189 $ 17.45595 FYE2019 152,234 Ind reval 1523234 0.556209 18478.07 (47.52) (3.96) -3. 11 % 190 $ 17.60000 FYE2018 1521234 152,234 0.569391 11525.58 34.74 2.90 2. 33% 191 $ 17.60522 FYE2017 147, 973 2.88% 152,234 0. 556259 1 ,490.84 25. 86 2. 16 1 .77% 192 $ 17. 76370 FYE2016 147,973 147,973 0.557335 11464. 98 19.92 1 .66 1 .38% 193 $ 17.95159 FYE2015 154, 138 4% 147,973 0.544002 11445.06 20. 93 1 .74 1 .47% 194 $ 17.49319 FYE2014 154, 138 154, 138 0.528166 11424. 13 (0.01 ) (0.00) 0.00% 195 $ 18.20505 FYE2013 1543138 154, 138 0.507518 1 ,424. 14 37.79 3. 15 2.73% 196 $ 18.53335 FYE2012 154, 138 154, 138 0.485299 11386.35 65.76 5.48 4.98% 197 $ 18.26406 FYE2011 154, 138 154, 138 0.469094 1 ,320.59 34. 15 2. 85 2.65% 198 $ 18.30689 FYE2010 154, 138 154, 138 0.455893 1 ,286.43 38.51 3.21 3.09% 199 $ 18.36687 FYE2009 144,054 7% 154, 138 0.440803 1 ,247.93 16.26 1 .36 1 .32% 200 $ 18.76669 FYE2008 144,054 1443054 0.455596 1 ,231 .67 (17.04) (1 .42) -1 .36% 201 $ 18. 84580 FYE2007 132, 160 9% 144,054 0.45996 19248.71 34.44 2.87 2 84% 202 $ 19. 15566 FYE2006 132, 160 132, 160 0.479642 11214.27 10.97 0,91 0, 91 % 203 $ 18.78999 FYE2005 118,000 12% 132, 160 0.484558 1 ,203.30 56.70 4.72 4.95% 204 $ 18.90914 FYE2004 1183000 118,000 0.513874 11146.60 26.52 2.21 2.37% 205 $ 18.37162 FYE2003 100,000 18% 118,000 0.516676 1 , 120.08 118. 52 9.88 11 . 83% 206 $ 17. 80075 FYE2002 1009000 N/A 100,000 0.562651 1 ,001 .56 96.99 8.08 10.72% 207 $ 16.49097 FYE2001 1002000 100, 000 0.548525 904.57 209 Commercial Tax Askings Property Value Avg, Revaluation Adj Value Rollback Tax Incr n(97,55) (8, 13) % Change 211 $ 19.24547 FYE2022 752,427 7521427 0.90 13,032.73 4 4.37% 212 $ 18.44026 FYE2021 7523427 752,427 0.90 12,487.45 5 5. 08% 213 $ 17.54799 FYE2020 752,427 752,427 0. 90 11 ,883.22 9 0.53% 214 $ 17 .45595 FYE2019 752,427 752,427 0.90 11 ,820.90 . ) -0. 82% 215 $ 17.60000 FYE2018 752,427 752,427 0.90 11 ,918.44 (3. 53) (0.29) 0.03% 216 $ 17.60522 FYE2017 752,427 752,427 0.90 11 ,921 .98 (107. 32) (8.94) 0.89% 217 $ 17.76370 FYE2016 752,427 7521427 0. 90 12,029.30 (802.60) (66.88) =-2,51 218 $ 17.95159 FYE2015 752,427 752,427 0.95 12,831 .90 (330.45) (27. 54)219 $ 17.49319 FYE2014 752,427 752,427 1 13, 162.35 (535.62) (44.64)220 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59)221 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89222 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32,23) (2.69) 223 $ 18.30689 FYE2010 7529427 752,427 1 13,774.60 (7.98) (0.67) -0.06% 224 $ 18.36687 FYE2009 690,300 9% 752,427 0.997312 13,782.58 827. 94 68.99 6.39% 225 $ 18.76669 FYE2008 6909300 N/A 690,300 1 12,954.65 55.85 4.65 0.43% 226 $ 18. 84580 FYE2007 690, 300 N/A 690,300 0.991509 12,898.79 (324.36) (27.03) -2.45% 227 $ 19. 15566 FYE2006 6901300 N/A 6900300 1 13,223. 15 348.79 29.07 2.71 % 228 $ 18. 78999 FYE2005 5853000 18% 690, 300 0.99257 12,874.36 1 , 812.51 151 .04 16.39% 229 $ 18 .90914 FYE2004 5651000 N/A 585,000 1 11 ,061 .85 554. 11 46. 18 5.27% 230 $ 18.37162 FYE2003 5851000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91 % 231 $ 17.80075 FYE2002 585,000 N/A 585,0001 10,413.44 766.22 63.85 7.94% 232 $ 16 .49097 FYE2001 500,000 17% 5859000 1 91647.22 K:IUSERS\MICHELLE-IMBudget FYE22XFY22 BUDGET_Published March 15 Print Copy.xlsx 5 3/15/2021 11 :55 AM FYE2021 CERTIFIED AND FYE2022 PUBLISHED BUDGET COMPARISON m CITY OF WATERLOO Published Budget GENERAL FUND 3/15/21 A B D E F G H I J K L M 1 CERT FY 2021 BUDGET FY 2022 BUDGET % FY 2021 BUDGET FY 2022 BUDGET FY2021TAXES FY2022TAXES LEVIED 2 BUDGET CODE ACTIVITIES•GENERAL FUND BUDGET ' CERTIFIED PUBLISHED CHANGE CERTIFIED PUBLISHED_) LEVIED $ 19.24547 $ AMOUNT % 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 18.44026 4.37% CHANGE CHANGE 4 234 Industrial Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 236 $ 19. 24547 FYE2022 1 , 000, 000 N/A 11000,000 0.90 17, 320. 92 724.69 60.394. 370/ 237 $ 18 .44026 FYE2021 1 , 000, 000 N/A 110000000 0. 90 16,596.23 803 . 04 66. 92 5. 08% 238 $ 17 . 54799 FYE2020 11000, 000 N/A 110001000 0, 901 150793. 19 82.84 6. 90 0. 53% 239 $ 17.45595 FYE2019 1 , 000, 000 N/A 11000, 000 0. 90 15,710. 36 (129.65) (10. 80) -0.82% 240 $ 17 .60000 FYE2018 11000, 000 N/A 1 ,000, 000 0. 90 15, 840. 00 (4.70) (0. 39) 0. 03% 241 $ 17. 60522 FYE2017 1 ,000,000 N/A 11000, 000 0. 90 15,844.70 (142.63) (11 .89) 0. 89% 242 $ 17 . 76370 FYE2016 1 , 000, 000 N/A 1 , 0001000 0.90 15, 987. 33 (11066. 68) (88. 89) -6.25% 243 $ 17 . 95159 FYE2015 11000,000 N/A 1 , 000, 000 0. 95 17,054. 01 (439. 18) (36.60) 2. 51 % 244 $ 17 .49319 FYE2014 1 , 0001000 N/A 1 , 000,000 1 17,493. 19 (711 . 86) (59 . 32) -3. 91 % 245 $ 18 . 20505 FYE2013 1 , 000,000 N/A 1 , 000, 000 1 18, 205. 05 (328. 30) (27. 36) 1 .77% 1 246 $ 18 . 53335 FYE2012 E1 , 000, 000 N/A 11000, 000 1 18, 533 . 35 269.29 22.44 1 .47% 247 $ 18. 26406 FYE2011 11000,000 N/A 1 , 000, 000 1 18,264.06 (42. 83) (3. 57) 0.23% 248 $ 18 . 30689 FYE2010 110001000 N/A 1 ,000,000 1 18, 306 . 89 (59.98) (5. 00) 0.33% 249 $ 18 . 36687 FYE2009 1 ,000,000 N/A 1 , 0001000 1 18, 366.87 (399. 82) (33.32) 2. 13% 250 $ 18 . 76669 FYE2008 1 , 000, 000 N/A 11000, 000 1 18,766.69 (79. 11 ) (6.59) -0.42% 251 $ 18 . 84580 FYE2007 1 ,0002000 N/A 1 , 0001000 1 181845. 80 (309.86) (25. 82) 1 .620% 252 $ 19 . 15566 FYE2006 11000 , 000 N/A 11000, 000 1 19, 155.66 365 .67 30.47 1 . 95% 253 $ 18 . 78999 FYE2005 1 ,000,000 N/A 1 , 000, 000 1 18,789.99 (119. 15) (9. 93) -0.63% 254 $ 18 . 90914 FYE2004 1 , 0001000 N/A 11000, 000 1 18,909. 14 537. 52 44.79 2. 93% 255 $ 18. 37162 FYE2003 1 ,0003000 N/A 13000, 000 1 18, 371 .62 570.87 47. 57 3.21 % 256 $ 17 . 80075 FYE2002 11000, 000 N/A 110001000 1 17,800.75 1 , 309.78 109. 15 7. 94% 257 $ 16 .49097 FYE2001 1 , 000, 000 N/A 110001000 1 16,490. 97 258 259 Multi-Residential Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 261 $ 19. 24547 FYE2022 5001000 N/A 500, 000 0. 6750 6 ,495 . 35 11 (74.00) (6. 17) 1 . 13% 262 $ 18 .44026 FYE2021 5001000 NIA 5001000 0.7125 6,569. 34 (11 . 15} (0. 93) -0. 17% 263 $ 17 .54799 IFYE2020 500,000 N/A 5001000 0. 7500 6 , 580.50 (292. 78) (24.40) 4 . 26% 264 $ 17.45595 FYE2019 500, 000 NIA 500, 000 0.7875 6,873.28 (386.72) (32. 23) 5. 33% 265 $ 17 .60000 FYE2018 500,000 N/A 500,000 0.8250 7,260. 00 (332.25) (27.69) -4 . 38% 266 $ 17. 60522 FYE2017 500, 000 N/A 500,000 0, 8625 7,592.25 (401 .41 ) (33.45) -5.02% 267 $ 17. 76370 FYE2016 5001000 N/A 5001000 0. 9000 71993.67 (533 . 34) (44.45) -6.25% 2681 $ 17 .95159 FYE2015 500, 000 N/A 5003000 0.9500 81527.01 (219.59) (18. 30) -2. 51 % 269 $ 17 .49319 FYE2014 5001000 N/A 500,000 1 8,746.60 K:\USERS\MICHELLE-W\Budget FYE22XFY22 BUDGET_Published March 15 Print Copy.xlsx 6 3/15/2021 11 :55 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON - CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS - G H I J 2 L M N 2 - P % % FY2021 BUDGET FY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 $ AMOUNT B C D E F 1 PROJECT CERT FY2021 BUDGET FY20228UDGETI ___— _--- 1 _ _ CERTIFIED PUBLISHED 'i_ CHANGE CERTIFIED I _ _ PUBLISHED TRANSFERS TRANSFERS I TRANSFERS ', TRANSFERS LEVIED LEVIED '�. CHANGE CHANGE 2 BUDGET CODE ACTIVITIES•OTHER FUNDS CODE BUDGET ;, EXPENSE EXPENSE I! REVENUE REVENUE ---- - " 3 -__-_ LINE ---. - -_ _ — (IN) OUT - 4 PUBLIC SAFETY - - --_-- - - ___ (IN) OUT - ---_ -- - 5 200-17-1140 POLICE PENSION SYSTEM _ . 170 2,515,650 26899857 1 6.92% 0 01 2,515,6501 21689855 774,201 6.92_% 7IFIRE PENSION SYSTEM I - - -- --- - _- --_. - -- 2, 127,738 _- 2,327 ,893_1, 194, 155 9.72% 1 - >_ -__ _.- _ 7.93 /0 0 1 -_ _ _ _ 9. 12% 0 p .__ 8 200-72 1420 1 TOTAL PUBL C SAFETY - 1 D 4,643 388 _-_ _ 5 017 ,744 _-- -_-- - p — ---- p o " j --- --__—1 9 _ - - - ! -- - - -- � _ o j 0 4,643,388 5,o11 ,744 368,356_ 7.93% 10 11 PUBLIC WORKS ( II - -- 1 1 _ -- - - 12 205-077400 1 BRIDGE MAINTENANCE LOCAL OPTION. 12D _ 0.1. _ _ 0 0 - 0.00% ' _ _ 0 0.00% 0 O 1 _ 13 20507-75_00 STREET CONSTRUCTION - LOCAL OPTION 120 81479,047 c 10,507,0°0 (1 ,765,953) 1 (1 ,872,495) 1 (106,542) 6.03% 14 205-07-7830 - . _ 1 ENGINEERING LOCAL OPTION TAX - 12D 1 735,500 6 776,974 - - 5.64 /uj_. _ 10 245 00� - - 0 j T - --735,500 776t974 41 ,474 ' 5.64% 0 SE _ T__. - 1 _ 0 _. ..-_ -- �- 10304531 ."-- 1 ,095521 65.0681 6.31 % 16 266-07-7830 ROAD USE TAX REVENUE 0 1 ,095,521 6.37 % � 0 0 1 --_ — _ 15 205 19-7110 SEAL COATING - LOCAL OPTION 1120 1 ,030,453 0l_ 0.00 /L 7,637,010 7,616,935 --- (7,637,010 T7 266-07-7300 _ . - ROAD -. j_ . --_ 0.00% 1 _ _-. 0 1 333,165 _ ) _ (7,616,935) 1 2°.075 0.26% _ I. - 750,0001 - _ _ - -04.42% 18 266 07-7500 1ST EET CONST CE ROAD USE AAXUSE TAX 12D 7,464,909 1 4,000,000 -06.42% 1 7,500,000 4,000,000 j — 735,09° 476,8305 (333,165) c -- - --- -- . - -- __� ) 1 _ 35,091 . 100.°0 % 20 26607-7832. ENGINEERING - CHARGEBACKS (OUT) _ 120 j 133,0471 133,0471 0.00°/al 1330471 _ 490501 1 1 1 ,034,670 7 ,129,3061 94,636 ." 19 26607-7830 IENGINEERING ROAD USE TAX FUND 1120 1 ,083,720 1178,3561 _ 8.73 /0 _ 49,050 — 22 266-17-7105 STREET LIGHTING_UTIL - ROAD USE TAX T14D 518,000 1_ .. 0 0.00% �_ 523,180 " -- 133,047 21 266-07-7832 IENGINEERING - CHARGEBACKS IN - 1120 0 50,000 _. _. . ( -_ ) - I 500°0 50,00 0.00% 50,D0p� _ 0I 518,000 523,180 5,180 7 .00% O1 0 23 266 17-7120 ( TRAFFIC SAFETY ROAD USE TAX FUND i 750 , " . 7 .00 / __-. �_. __ _- - - ---- T_ --- — ---- -- _- -- - ..-- - 1 ,536,1581 1 ,594,024 3.77 /0 — �- 1. 1 ,508808 1 ,566,674 57,866 '' 3.84% 0 1 � 27,350 ; 27,350 24 26617-7122 ' TRAFFIC SAFETY - CHARGEBACKS (OUT) 15D 32,000 32,000 0.170% 32,000 3210001 - - - — 0 0 0 0.00% 25 266-17-7125 , TRAFFIC SAFETY_- RESTRICTED PROD , 17TRF DSCV 115D 1001 10� 0.00% 100 } --- -- -" - - �— _� 10� 4e 000 1 4a.00p OT 0.00% 26 266 17-7161 TRAFFIC SIGNALS UTIL - ROAD USETAX 150 48,000 48,000 O.OD% 0 0.00% 28 266-19-7102 STREETMTCE - CHARGEBA_ C_ KS (OUT) : 120 156,5001 7585001 0.0000/a _- " --- 550 ! _ " ._ _ 119657081 21085,398 720,317 1,. 6.12% _ _ _ 6.72% 550 - 27 266-19-7100 STREET MTCE - ROAD USE TAX FUND 1720 1 965,631 2,085,948 -- .- I{ 158,500 - 158,500 _ -- - - - - 1 ,847,542 - 1 ,847,542 0 0.00% 29 266-79-7200- SNOW REMOVAL L ._ _. 116D 1855,54 -_7 ,855,542 I . - o.0o% I 8,000 _ 8,00 _ 01 0.00_% 30 266-37-7902 1 ROW FORESTRY & MOWING 112D i- 900,000 1 900,000 _ 0.00% 1 900,000 900,000 j 1 0 0 IP xx� _ _ T - — t) 0.00% -: -_ ! 19D 1_-- _ _ 1 -- _ 0 p 01 0.00% 32 291 -29_7755 ( AIRPORT PASS31 291-29-7750 IAIRPORT ENGER PACT FACILITY CHARGES JECTS 129AIP xxxx. _ 1 -- 696,881 i 7 100,000 --- 73.22% 1 ---_ 696,881 1 7 100,000 1 -- _-- 1 - 1, 1 - 0 -- __- o _-. _ 0 0.00 33 e91-29-7760 773,000 z.2s% 1 177,000 173,°_°0 1 0 0 0 1 0.00% 34 - AIRPORT STATE PROJECTS 1 -. -- - - 1220 - 27,649,0161 1 - -- - 14 -- - _-- 35 _ ( TOTAL-PUBLIC WORKS --� -_ -- Izx 19D 177,000 25,188697 -8.90% 27,649016 25, 188,697 D 0 0 0 O1 0 01 000% ' 36 - 37 1 - - T 39 204-33-3100& RECREATION 38 CULTURE _ } � - 1- LIBRARY - TAX LEVY 1 _431C - 1 669,7791 7074141 5.62% 17,03311 51 ,459 1 652,7461 6559551 3,209 0.49% 1 _ 40 - - _ 41 - - - ( TOTAL-CULTURE & RECREATION - 1 _ -.--- _ _ 3,209 - .. -_ - 669779 707 414 _ - 0.49% - J _- �_ 5.62% 17,033 51 ,459 0 O 0 43 -- 852,746 1 655 955 44 COMMUNITY & ECONOMIC DEVELOPMENT T - - - -- -- - ` -- -- - - _ . -" 1 T _ 45 224-32-5850 COMM. DEVELOPMENT-BLOCK GRANT V VARIOUS j41D 1 ,64_6,384 1 646,384 " 0.00% � 1 ,646,384 _ 1 ,646,384_ _ 0 0 0 0.00% 46 224-32-5853 COMM. DEVELOPMENT-LEAD PAINT GRANT ( 141D 1 ,378,918 1 ,359,093 -1 .440 1.,378,9181 1 ,359,093 ".. _. 11 T." -- , i .._ 01 0 .1 _ . 0.00% 47 _S 1 0- I o.00i o ; - �+ 0 'I of of 0.00% 48 224-32-5870 COMM. DEVELOPMENT-FEDERAL HOME TIO}VAR OUS x 141D 1 _.. 7 ,361 ,742 -� 1 ,361 ,742 1 - - 0.00% 1 -- 1 ,361 ,742 1 ,361 ,742 -__ '.; O - I o 0.00_ Oi 0 ' 49 224 32-6800 NEIGHBORHOOD SERVICES - IBGDDS 0077 1470 85,173 1 90,000 5.67% 857173 90,000 _ _ -. .. 0.00% 51 283-13-5450 HOUSING - RIDGEWAY TOWERS 41D0 _- 62,0001 52 283-13-5451 HOUSING - CAPITAL FUNDS Go . _ CAP FYxx 11410 265,0 0 _-- 270,000 7.69% 265,000 2fi0,o00 ---T --- -- ` -- - -- 0 01 000% ( ) _...__� 0 0 : _ 0.00_% , 53 283-13-5452 _ --1 HOUSING - SECTION 8 j41D 5,6.72,200 5T 11 ,834,30° 286% I 5,672,20 5,834,300 0 O 0 0.00% 54 283-13-5453 _ _ HOUSING - FAMILY SELF SUFFICIENCY 410 20,000 20,0°0 , _ 0.00°/a 20,000 1 20,000 0 0 0 0.00% 55 283-13-5455 HOUSING - 00WNPAYMENT ASSISTANCE � 41D 500000 1 50,000 0.00%1 50,0 0 50,000 T ° 0 1 _ 0 } _ 0.00% HOUS _ _ o 77 off _ o , 0.00 58 283-135861 TOTAL OMMUNITY &SING ECONOMIC DEV �4 _ T 5D �_- - 10,541 ,417 10,695519y ---- 1 D 0.46% .---- 10,541 ,4171 10,695,5191 60 - - - - p - - 0p - -I -- p -- �o - 0 1 -- 0.00 /59 - - KAUSERSWICHELLEAMBudget FYE22TY22 BUDGET_Published March 15 Print Copy.xisx 1 3/15/2021 11 :54 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON - CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS A B C D I E F G H I J K L I M N O P q PROJECT 1 --__ iFY2022 BUDGET FY2021 FY2021 FY2022 FY2022 FY2021 FY2022 $ AMOUNT % 2 BUDGET CODE ACTIVITIES•OTHERFUN0S CODE BUDGET.. CERTIFIED PUBLISHED CHANGE FY2021 YCERTIFIEDET PUBLISHED . TRANSFERS TRANSFERS I TRANSFERS ' TRANSFERS LEVIED LEVIED '.. CHANGE CHANGE _ --. --_. (IN) OUT __ (IN) OUT __ E FY2022 - - 3 LINE EXPENSE EXPENSE REVENUE REVENUE 1 61 GENERAL GOVERNMENT - - - -- - -- - --- --- _ --. 0.00% � 0 __- - 0 0 _ -0.00% 62 200-09-8980 UNEMPLOYMENT FUND _-- 520 _. - _ 17,472 -_. 17,472 - - - - - _ _- -- _ --_ 179472 17,472 63 - - 64 TOTAL•GENERAL GOVERNMENT 153D 1 17,472 17,472 1 0.00% � 0 0 0 0 " 0 0 17,472 17,472 0 0.00% 65 - -- - 66 ---- - - 67 -2-90-0-7---5300-- PECIAL REVENUES CAPITAL PROJECTS _-. _ _ 07FLD 5007 _- 0.00% 0 _ - 0 0 0 - 68 290 07 5300 STORM WATER PUMP STATIONS-COMM 64 ' 07FLD 0078 550 - - 0 0 0.00 / i 0 1 O I -- _ - '1- 1 0 --- 0 0.00% I55D 0 -- 0 . O 69 290 07-5300 STORM WATER PUMP STATIONS-COMM 35.� 0 1 I - _ _ 0 0.00% 70 290-07-7300 STREETS - W _ _ 6,000,000 i. . . NEW 0 6,000,000 _ 0 000% 71 290-07-7355 I STREETSSHAULIS RD TRAIL 08BKE.TAP766 55D x'11 0 200,000 II NEWS_ p 200,0.00 _ - - - ... - - K IITH --. -- -- .. _--_ O ----- 0_; 0 0.00% 72 290-07-7500 STREETS-LAPORT HESS RD BRIDGE REPLACE 7STR.SWAP76 550 5,043,543 _ 95NEW.04% 51043,643 250,000_ 1 - -- __ -- 0 0 01 0.00% .- _ _ _ -_ ,_ -__-_ 0 4.600,000 1 _ NEW _. 0 496003000 1 I T -- - _ _.-_ 0 .__-._ 0 I 0 1 0.00_% 74 290---07-7520 US 63 07STR.RM772 SSD 0 - - - _-_- -_�55D 0 1500,000 NEW ! 0 1 ,500,000 --- -_-1 0 -- 0 0 0.00% :. 73 290-07-7500 STREETSSHAULIS RD RECONSTSTRUCTIOPI - - - 75 76 290 07160 _ T_RAFF C ANSB TO BLACKHAWK 17TRF STP757_ ! SSD _ 300,000 0 � _ -100.00% 200,000 , _ - 0 0 I 0 0.00% ( - - L OBBKE RT734._. 1 � --1 .. -100.00% I 300.000 O --_ --- �_-_. _ _� --_ 0 _ 0 ._ 0 00% 78 290-17-7161 ! TRAFFIC IMPR GREYHOUND & RIDGEWAY I17TRF zzxx I55D,_ 310,000 0 -1 oo.00% 310,000 0 p O , 0 0.00°% „. 77 29017-7161 _ ! TRAFFIC-VISION ZERO 17TRF xxzx 55D 5,000 _ 0� -100_._00% I 5,000 _ __ 0 _ " 79 290-17-7161 1 TRAFFIC DOWNTOWN CAMERA & FIBER 17TRF xxzx 1550 I_ . - 550,000 385,000 iI -- ---� -- --_ __ __ -- 0 000 /o _ _ - �_ __-- - -_ _--__ 27.2 550,0001 400,000 0 00+, 0I 000 /0 80 290-17 7161 TRAFFIC W 9TH/SOUTH ROUNDABOUT 17TRF zzxz 550 - 0 - NEW 0 385,000 0 0 0 0.00 _- - I ___ __ - _ _ _ - .- 0 00% 81 290-17-7161 TRAFFIC SAFETY CAMPAIGN 17TRF zzxz 550 40,000 1 30,000 25.00 % 40,000 30,000 0 p 1 0 82 290 17 7161 TRAFFIC US 63 TRAFFIC ADAPTIVE PROJ t7TRF xzzx 550 0 145,000 r NEW 0 145,000 _. _ -. .. _. . .__ _ 0.00% 83 290177161 - --- 1TRAFPIC-RIDGEWAY AVE_ 17TRF xxxz _ - S5D _ - !, 700,000 --___ 0 �_ _- -100.00% � ----- - 700,000 --_ -- _0._ I -- p , 000% ; 84 290 17-7161 TRAFFIC-PARK AVE BICYCLE SIGNAL PROJ 17TRF xxxz I55D 72,000 100,000 1 38,89% 72,000 100,000 _ 0 0 0 ! 0.00% - - 0-1 0.00%% 0p j-_ - O -.._ 0 0 85 29o-nats7 - 7 _ _ _ _ 0 0 o 000 86 290-374100 GREENBELT LAKE IMPROVEMENTS I371MP.GRNBLTi55D 200,0001, _ - 200,000 p -- 0.00% 200,000 1 000% 87 290-37AI05 88 _290-37-0700 RIOVERVOIEW REC AREA TRAIL EXTENSION 66REC TRL13 I55D _ 0 - - 0.00% 0 _ 0 _ 0 1 O 0 0.00% ' 17TRF xxxz 550 0 200 000 0 _- - - _� � . .. - - - - -- . O.00hI 0 � -- - r - . - . -_ 0.00% 0 0� 0 _ 150 ` 0.00 / - 130,000 130,000 - 20,000 25 000 0 !- 0 00% - 90 207- IIA REINVESTMENT DISTRICT 1 300 1 ) - - 1 - 130,000 -50.00% 220,300 125,1501 200000 � .. _ 100,000 j- 25.00% 91 _ - -- - -.- ---__ ( ) ( 0) I (5000 -__- - D STABILIZATION 32NS3 xxxz S5D - - 130,.000 1 - I - - -._-_ - ' _ 20.000 25.00% 100,000 94 Subtotal - 200 Series PLess LibraECIAL ry REVENUES CAPITAL PROJECTS 570 504028431 13940150 ,! 64.62%1 7770,6431 14,065,750 O ! 200,0001- 0 - (20,000) : (25,000)1- (5,000) rY__.Levy___ , 136 54,853,582 i _. 45,961 ,276 49,949,366 _. - 0 . 1- 200,000 0 100,000 5,293,606 5,660,177 I 366,565 6.92% _.... _-. -_ 1 ,- - __. - - - -__-- -_ - __ - __ _. -_ 95 - - - 96 - CTIVITIES 98 520-14-5200 1 WATER POLLUTION CONTROL PLANT 1 ! (5,702,233 (5,384,841 ) 1 97 BUSINESS TYPE 99 520-14-5202 WATER POLLUTION 1 3.08°/ 13,536,9401 13,460,940 )1.- _- 317,392 -5.57°/a 100520-14-528.0 SEWER REVENUE PLANTSRF _� 17.101 1430000 ' 6650000 0.00% 692,00-0 692,000 692,0001 - _ -_ 01 .. 0.00% _ _ _ 692,0001___ -. --- 0 -. 601 692,000 _- - _ __ -.10211 000 = 53.63% 14,340,000 1 6,650,000 0 0 -- 0 0 0 0.00% 101 520-14-5375 SEWER REVENUE COLLECTION SRF 711 11 80. 0,000 1 10 211 ,000 1. 3_.47 / 11 ,_800,000 10,211 ,000 _ �_ _ T O I_ 0 1 0 0.00% -._ _{ . . _�0 BOND DEBT SERVICE 751 j 0 I -.--_ 1 _ .__ L_ 1 I 1 �148.17� 132,429 - 13.04%103 520-14-9050 ! SEWER , 102520-148980 ( SEWER REVENUE DEBT SERVICE 1701 - - 1 ,015,750 - 1 ,748179 - - - - 13.04% - -- 0 _ 0� --- - 1 ,015,750 104 52G-22-5335 FOOTINGDRAIN DISCONNECTIONS _ 1601 138 147,368 6.52% fI p 0 'i --- -- - -- - - _ (732,429) -5.46% _. -_-- 0 _ --- -- 2,427,130 --_-- ! 2,294,701 _ 21715,632 130 1 2 294,701 1 -- - - i 147,368 -_ 91021 6.52% 105 521 -14-5310 ( STORM SEWER MAINTENANCE 601 715,632 763,687 6.72 / 1 - 0 - -- -- - 763,687 _ 6.72% _ _ 3 0 - 2s748,450 -- --- T 48 055 1 107521 -07-7830 106 521-19-5500 STREETCLEANING 601 358,884 383,374 6.82h 0 0 i -- " �I� _--1 ( , ) - (2,264,526) _-_ 24,490 5.30% 108521 -07-7832 IENG-STORM WATEERA MIN CHARG BACKS ! _ 1601 457,050 -- 487,0501 _ 0_00% I 2,417,050 7,050 -- -- 1964,09701 ) 1_ 15.30% ! ---- . -� ----- -- 356,884 383374 1 -_ , 711 --1 ,050,000 1 ,2600001 20.00% i 160,419 142,5351 1 -- --- - 1- 889,581 ! -- 1 ,117465 (_(227884 tI 0.00%. 109 521-07 5300 STORM WATER CAPITAL PROJECTS 25.62% .. _ - I I ! ---_ ---- ___ ..___ 0 ( ) 1 -100.0_0% - -JECTS 11711 _STORM WATER SRF PR _ 0 1 ,4.00,000 ---- _ 889,587 110520-04-5320 ( SEWER SYSTEM IMPROOVEME TS -- - 711 2,t27 ,O06j 1 .794,593_1 -1539%a � 0� _ -__ __---. -_-- --- ---2,020,0061 1 ,794,593 ' (326,473) 1, -15.39% 112 617-14-5320/898JSEWER GO BOND PROJECTS _ _ - _ 171I __ 7 ,_000,000 0 113 (SUBTOTAL - SEWER FUND 33,017,274 " . _ -20.49% i 42,954,359 35,311 ,9751 0 2,427,1301 ! 21294,7011 (7 ,889,581 100.00% ) I 93 -__ 41 ,527,229 1 ,889,581 0 114 K:\USERSWICHELLE-WtBudget FYE221FY22 BUDGET_Published March 15 Print Copy.xlsx 2 3/15/2021 11 :54 AM FY2021 CERTIFIED AND FY2022 PUBLISHED Published Budget BUDGET COMPARISON = CITY OF WATERLOO 3/15/21 ALL OTHER FUNDS A B I C I D I E F G H I I I J I K L M N O P Q 1 _ _ % FY2021 BUDGET ! FY2022 BUDGET I FY2021 FY2021 FY2022 FY2022 _ . FY2021 _ FY2022 $ AMOUNT 1 % _ _ _ FY2021 BUDGET I FY2022 BUDGET " 3 CERTIFIED PUBLISHED T CHANGE CERTIFIED PUBLISHED TRANSFERS I TRANSFERS 1 TRANSFERS 1. TRANSFERS LEVIED LEVIED CHANGE CHANGE 115 525-15-54000ODE ISANITAT ONTIVITIES-OTHER FUNDS CODE - - 64LI EET ; EX PENS 923 EX ENSE 52T 0.04% RE 5E23Q759 f RE 5ENUE764 _(IN) _ OUT (IN) OUT -- - I - 117525-15-5125 SANITATION - CODE EN525-15-5402 SANITATION - FORCEMENT ACKS 1641 - 376,500 376,500 : 0.00% I _.. _ - 451 ,500 '. 451 ,SOOi (75,000) 1 (75,000 (231676) 40,00% _. ),.. _ 0.00_% 641 _ _ 81 ,080 58,318 1 - - _ 467,391 - (536,923 69,532 14.88% 119 525-17-2400 SANITFATIISUBTOTAOINSANITMAL ATiON FUND 1641 - 362,689 _ _ _ 377,969 8.53h _ -. ,.--- -. -- T -..- -- - 4.21� _ 111 ,700 _ 113,380 .-- __ 250989_ 2646589 13,600 5.42% -. . __� _ 6,029,583 6089962 ,, 1_._00% I 5,881 ,039 6,089,9621 0 -- -- 120 _. _- _... .. -. - __. - _ 148,544 O T (148.544) 100.00% 1 1 ) 121 _ 1TOTAL-BUSINESS TYPE ACTIVITIES 731 47,556,812 39107236 17.77% 48,835398 41 ,401 ,937 0 2,427,130 1 2294,701 1 , 148,544 (2,038,125 -100.00% 122 - - 123 -_ T 124 DEBT SERVICE 1251o0 IGEN. OBLIGATION BOND DEBT SERVICE 54F 13,157,973 (5,444561 ) I� _(5338465) 1_ 71216,045 _ 7,601 ,650 126 tot TIF ECONOMIC DEV & REBATES -_ 43E 2,610,938 11 12 673,698 2.40% _ 9,398,510 463,385 1 (127 000) 6,914,572 (147,000 - 385,605 5.3_4% 128 I __ ) __. - p _._ (268.50301 268,500- _ 10,709,_7_61 7,914,560 _ NEW - _. 0 0.00% � __. 0 -_. ) ( ) 11 0.00% 127101 1TAX INCREMENT DEBT SERVICE 154E 0 129 - TOTAL-DEBT SERVICE -� -- - �- _ _- _-4 (5,571 ,561 � (5485,465 7,914,560 7,-216045 -7,333, 147 -- 117, 102 '; 1 .62% 130 _ I 1 .96% 9,895,877 11 , 173,146 I - ) 6,914,572 131 tsontsell � 133 419/420-8980 G.O. BOND PROCEEDS_ -- I55G - 11 ,000,000_ 11 ,000,0001 - - - --- , r -- -- - 1-- 132 CAPITAL PROJECTS 134 1 G.O. BONDICAPITAL PROJECTSf _ _. _ _ p _ 0.00% 135 417/418/419/419 LG.O. BOND/CAPITAL PROJECTS-TIF - -- - I56G 5,000,0000 1 _ 5 OOO OOOo I_ 0.00 % 0 __ . _. _ _ . . 51000,000 5t000lo0o -.. 0 1!, 0.00% -. 0.001 0 _ _ o 0.00% 11000,000 1 11 ,000,000 136 417 G.D. BOND/CAPITAL PROJECTS-TECHWORKS IBD 55G 1 0 0 0.00% 0 ! - - 0 0 I)- ' 1 _ - y - - i I_ - - _ - _ p 0 I 0.00% 138 426-07-7400 ( CAP IMPR BRIDGES - - I55G .750,0_00 1 _ . --- 1 - .. - .. -- -- - -. -- - O -� _ - 55G _ . -. - 265,000._ 1 _-- 0 1� 100.00 -.- 265.000 0 0 ~_ 0 ,` 0.00% 13942607-7355 CAP IMPR 1 - T 1 -. _ _ 0_ _ O 0 0.00% _ - � 55G 0 1 ,000,00 1900.00% f _ --- 50,000 1 ,Ooo,--000 .__ -_ _..-- -.... _ _ 0 0.00% 140 426-07-7650 CAP IMPR 426-07-7610 CAP IMPR -- COMMERCIAL ALNT IS T EETSCAPE55G 50,000 - I 0 1 _. 500,000 T 1 C - . 0 0 _. _ 500 000 0.00 %� 0 O 0.00%142 01 143 426-37-4202 _._ y- 0 _ 0 01_ __ 42637-0105 _,. ICAP IMPR - -ALL DIAMOND -- 37LINC GAME (55G 179,4801 _ O t00.00% � --- _ __ 179,4809 _ - -- -.� -._.-- 0I 01 0 i 0.00% 144426-37-4105 CAP IMPR -CAP IMPR BNCOLN PARK ROJEECTMENTS 37LIN FAME !: 55G 0 0 ! 0.00% 0 - __ 9 1 - 0.00% _ -__ -_. __ o 01 0 ' 145 426-37-0207 CAP IMPR - BOAT HOUSE AREA IMPR _ 155G _ 0 _ 0 I 0.00 / � _ 0 _0 10 01 0.00% 146 426-08-62_05 CAP IMPR - SAN MARNAN TIF PROF) 56G 151000 1 1 ,000,000 6566.67 / 0 0 ) _ O 0 0.00_% 14742608-6210 - ICAP IMPR - BATH TIF PROJECTS - 56G -._-_� U 300,00 0.00% _. Of _ 0 -_ _- _ ... ),I. 0 - - T 0 0.00_% t 300,000 1 - 148 426 06-6220 - CAP IMPR - NE SITE TIF PROJECTS _ 56G T 196,000 0 �I -100.00% 0-� - (300,000) 1 (1(300 000 5 OT 1 0.00% ., 56G CAP IMPR - MARTIN RD 150 426 OB-6260 ..149 426-08-6250 ICAP IMPR =M SPORT TIFIPROJOECTSTS 1 _ I56G �_ 2,0_48,033 .. -- 1 400 000 - ----- - 0 o ) -- - 0 0 0 64% 151 42608-6270 ICAP IMPR - DOWNTOWN TIF PROJECTS � 56G 1 40,000 750.0001 177500%T OI01 (2(048,033) 1 (1400000) 1 _ D 1 O 01 0.00% -__ _. _ ._ - ) _ _ )� p - - _ 0.00% _- - 0 0 (40�000)� .. 1 0 0 0 ° o (t ,z5o,0001 ,z5o.opo (750,000 152 .. i 0 0 0.00% - _ _ 56G 1 1 ,250,0001 0 100.00 / 153 426 08-6280 CAP IMPR - LOGAN I56G 0 1 ,250,000 __ NEW 0 0 _ 1 - 0.00% 155 ( TOTAL-CAPITAL PROJECTS - 1 154 - 0 p - ORTH CROSSING 157G 21 ,093,522 1 22,200,000 525 /0 12,244,489 12,500,000 3,849,033_ o - 1 157 - 1 - - - . T -_. _. I _. ( - ) (4,700000) 1 _ 0 5,000_,000 5,OOQ - - 0 0.00% _. ._. ..--_ _... 158 TOTAL CITY BUDGET - OTHER FUNDS 1 135,491 .160 132,945,430 -1 .88% � 116,954.07311 115,075,9081 9,420,594 9,541 ,702 10, 185,465 10,309,2611 18,658,195 17,993,3161 1 ,554,458 -3.56% KAUSERSWICHELLE-MBudget FYE221FY22 BUDGET-Published March 15 Print Copy.xisx 3 3/15/2021 11 :54 AM A B C I D E F G H I publis ed BudgOl 2 City of Waterloo 3/ 15/21 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 8 Property Taxes FYE2021 ( Excl . Debt Svc & Lib , Incl . Excise Tax , Grout) 351391 , 350 23 , 448 1 cent on the levy raises this much 10 General Fund Personal Services increases (decreases) : 11 Salaries & longevity 8191876 2 . 32 % Includes avg 2 . 0 % raises , 3 . 0 % for Police and Fire , 12 0 0 . 00 % step increases , longevity 13 Add 1 Chief of Staff 1761616 0 . 50 % 14 Add 4 SAFER - regular salary only 21 , 716 0 . 06 % 15 Increase in Personnel Costs Charged to Police Grants 81457 0 . 02 % 16 Increase in Personnel Costs Charged to SAFER Grants 2081356 0 . 59 % 17 Decrease Part Time Labor (28 , 053) - 0 . 08 % 18 Misc , overtime , double time , and bonus pay 151336 0 . 04 % 19 Police & fire overtime , doubletime & bonus pay 471410 0 . 13 % 20 Payroll taxes 60 , 265 0 . 17 % 21 Employee sick and casual payouts 91546 0 . 03 % 22 Retirement payouts 96 , 951 0 . 27 % 23 24 Health insurance 4891859 4 . 89 % 31163 , 028 1 . 34893 Personnel increases excl . 25 Retiree health insurance 181482 fire & police pension 26 Reduce use of health insurance fund balance 1 , 218 , 211 117261552 27 Police Pension 1741201 28 Fire Pension 194 , 155 368 , 356 1 . 04 % 31531 , 384 1 . 50603 Total personnel increases 29 Subtotal - Personnel Increases 3 , 531 , 384 9 . 98 % 30 31 232 KAUSERS\MICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM A B CD EI F G H I Bublis ed Budgjq 2 City of Waterloo 3/ 15/21 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 35 Contractual Services and Commodities Expense Changes : 36 Airport - Decrease Advertising , etc (59 , 945) - 0 . 17 % 37 BH County EMA - Increase Exp 175 0 . 00 % 38 Building Inspections - Software 21 , 836 0 . 06 % 39 Clerk Finance - Software , Misc 17 , 000 0 . 05 % 40 Clerk Finance - Elections 60 , 000 0 . 17% 41 Cultural Arts - Decrease Utilities , Misc ( 16 , 800) -0 . 05 % 42 Communications - Increase Newsletter 51000 0 . 01 % 43 Fairview Cemetery Association 201000 0 . 06 % 44 Fire - Decrease software , dispatch ( 11148) 0 . 00 % 45 Fire - Ambulance - Increase billing , training , repairs , equipment 868 , 950 2 . 46 % 46 Garage - Utilities 160 0 . 00 % 47 INRCOG Dues 685 0 . 00 % 48 Leisure Services Golf - Decrease in Sales Tax (65) 0 . 00 % 49 Leisure Golf Course Improvements Decrease (316) 0 . 00 % 50 Leisure Sportsplex Decrease ( 11 , 897) -0 . 03 % 51 Liability Insurance 1951200 0 . 55 % 52 Library - Increase Grant Funded Expenses 21200 0401 % 53 Mayor - Increase telephone 60 0 . 00 % 54 MET - Increase in Requested Funding 43 , 877 0 . 12 % 55 Parking - Decrease Expenses ( 12 , 500) - 0 . 04 % 56 Planning - Software Expenses 45 0 . 00 % 57 Police - Increase health services , uniforms , travel , misc 531444 0 . 15 % 58 Police - Increase for Axon contract 4071766 1 . 15 % 59 Police - Increase Grant Expenses 137 , 469 0 . 39 % 60 Police - Increase ATE Expenses 243856 0 . 07% 61 Self Funded Workers Compensation 60 , 000 0 . 17 % 62 0 0 . 00 % 63 65 Subtotal - Contractual Services and Commodities Increases 1 , 816 , 052 5 . 13 % 51347 , 436 2 . 28052 Total all expense increases 66 K:\USERSWICHELLE-W\Budget FYE22\FY22 BUDGET_Published March 15 Print Copy.xlsx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM A B C D E F G H I publis ed Budgol 2 City of Waterloo 3/ 15/21 3 FYE2022 General Fund 4 Proposed Budget Change In Cost From FY21 5 % of Total 6 Amount Change From 7 Prior Year Tax Levy 87 Revenue ( Increase )/Decrease : 88 Airport - Decrease 1161147 0 . 33 % 89 Building Inspection - Increase Dept Charges (233) 0 . 00 % 90 Clerk/Finance - Decreases 251743 0 . 71 91 Cultural/Arts - Decreased Revenue 16 , 410 0 . 05 % 92 Fire - Grant Increases (284 , 192) - 0 . 80 % 93 Fire Ambulance - Increases ( 11250 , 500) -3 . 53 % 94 Fire- Increased Revenue (21938 ) - 0 . 01 95 Leisure Golf Course Improvements Decrease 316 0 . 00 % 96 Leisure Services Golf - Decrease 11003 0 . 00 % 97 Library - Decrease Fine revenue 101560 0 . 03 % 98 Library Increase Grant Funding (41274) - 0 . 01 99 MIS - Decrease 41749 0 , 01 % 100 Parking Revenue - Decrease 12 , 500 0 . 04 % 101 Planning - Increase in Revenue ( 193 , 444) -0 . 55 % 102 Police Operations Budget - Increased ATE revenue released to operations (407 , 766) - 1 . 15 % 103 Police - ATE Project Increased Revenue (945 , 498) -2 . 67 % 104 Police - Amount of ATE released 9201642 2 . 60 % 105 Police - Increase Grant Revenue ( 172 , 836) -0 . 49 % 106 Public Access Fees 400 0 . 00 % 107 Use of State Covid Money received in 2021 ( 17600 , 155) -4 . 52 % 109 Subtotal - Revenue Net ( Increases) Decreases (31527 , 366) - 9 . 96 % - 1 . 50431 Total all revenue changes 114 115 Total Increases (Decreases) 1 , 820 , 070 5 . 15 % 116 0 . 00 % 117 Property Taxes Required ( Excl Debt Service , Library Levy, 118 Grout Levy) 371211 , 420 123 124 Total change in taxes - formula check 118201070 125 126 Variance - property taxes required (0) 127 128 Increase in Debt Service Levy 3851605 129 Increase in Grout Taxes 21931 130 Increase in Library Levy 21931 131 132 Total Additional Taxes 2 , 211 , 537 133 0 K:\USERS\MICHELLE-W\Budget FYE22\FY22 BUDGET—Published March 15 Print Copy.xisx\ Comparison to FYE21 3/ 15/2021 11 : 55 AM 3/14/20218:38 PM City of Waterloo FYE2022 Budget Sample Property Tax Collections and Property Tax Changes(Amounts and Percentages) FYE2022 FYE2021 FYE2020 FYE2019 Residential Rollback 56.4094% 55.0743% 56.9180% 55.6209% Commercial Rollback 90.0000% 90.0000% 90.0000% 90.0000% Multi-Residential 67.5000% 71.2500% 75.0000% 78.7500% Total Budgeted Property Tax Collections 43,867,749 42,065,175 40,438,265 State Commercial/Industrial Rollback Replacement 1,543,522 1,588,239 1,668,470 Total Property Taxes and Rollback Replacement Funds 45,411,271 43,653,414 42,106,735 Net Property Monthly Monthly Monthly Tax Increase Increase Increase Increase (Decrease)This %Increase (Decrease) (Decrease) (Decrease) Property Tax Collections Level from State Comm %Increase (Decrease) Residential Commercial Industrial Increase(Decrease)from Property Tax %Increase Staff Requests Rollback (Decrease) Commercial ($100,000 ($500,000 ($1,000,000 FYE2021 Collections (Decrease) Level Repl Funds Residential &Industrial Levy Rate Home) Property) Property) Option 1-Base Level - Base level includes personnel ccontractual changes only and use of$750,000 general fund balance 2,735,447 46,603,196 6.24% 2,735,447 1,650,156 8.25% 5.68% $ 19.48851 $ 6.98 $ 39.31 $ 78.62 Option 2-Staff Requests Level - This level includes requested changes and use of$750,000 general fund balance 3,812,118 47,679,867 8.69% 3,812,118 1,686,513 10.69% 8.07% $ 19.92807 $ 9.05 $ 55.79 $ 111.59 Option 3-Published Budget This level includes State Covid-19 grant funds to reduce the property tax levy 2,211,533 46,079,282 5.04% (1,600,585) 1,584,582 6.90% 4.37% $ 19.24546 $ 5.84 $ 30.20 $ 60.39 Option 4-4%Increase to Residential Budget changes not identified 977,383 44,845,132 2.23% (2,834,735) 1,584,582 4.00% 1.54% $ 18.72363 $ 3.38 $ 10.63 $ 21.25 Option 5- 3%Increase to Residential Budget changes not identified 557,383 44,425,132 1.27% (3,254,735) 1,569,423 3.00% 0.57% $ 18.54451 $ 2.54 $ 3.91 $ 7.82 Option 6-2%Increase to Residential Budget changes not identified 132,383 44,000,132 0.30% (3,679,735) 1,554,084 2.00% -0.42% $ 18.36326 $ 1.69 $ (2.89) $ (5.78) Option 7-Levy Rate of$18.44003(2.42%increase-equivalent to state increase in residential rollback) Budget changes not identified 312,383 44,180,132 0.71% (3,499,735) 1,571,652 2.42% 0.00% $ 18.44003 $ 2.05 $ (0.01) $ (0.02) Option 8-Levy Rate of$18.40693(2.24%increase) Budget changes identified plus 120 day hiring delays and 5 furlough days 245,290 44,113,039 0.56% (3,566,828) 1,557,779 2.24% -0.18% $ 18.40693 $ 1.90 $ (1.25) $ (2.50) Option 9-Levy Rate of$18.00313(no residential tax increase) (712,067) 43,155,682 -1.62% (4,524,185) 1,510,688 0.00% -2.37% $ 18.00313 $ (0.00) $ (16.39) $ (32.78) Rate Impacts FYE22 Mar 14.xlsx Rate Impacts Mar 14 2021 Page 1 of 1 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Fairview Expense Adjustments Fairview Revenue Adjustments 1393 Contributions (10,000.00) (Decr)/Incr Expenses (10,000.00) (Decr)/Incr Revenue MET Expense Adjustments MET Revenue Adjustments 1393 Contributions (43,877.00) (Decr)/Incr Expenses (43,877.00) (Decr)/Incr Revenue Mayor Expense Adjustments Mayor Revenue Adjustments 1344 Telephone 1390 (15,000.00) 8280-Communications 1335 Public Info (5,000.00) (Decr)/Incr Expenses (20,000.00) (Decr)/Incr Revenue Finance Expense Adjustments Finance Revenue Adjustments 1520 Computer Software 1,600,000.00 1780 Election Costs 1111 Salaries (15,000.00) 1319 Prof Fees (11,500.00) (Decr)/Incr Expenses (26,500.00) (Decr)/Incr Revenue 1,600,000.00 Planning Expense Requests Planning Revenue Adjustments 1319 Other Prof Sery 3620 Rent 1520 Software 3622 Sale of Property (Decr)/Incr Expenses (Decr)/Incr Revenue City Attorney Expense Adjustments City Attorney Revenue Adjustments 1317 Legal Fees (40,000.00) (Decr)/Incr Expenses (40,000.00) (Decr)/Incr Revenue K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 1 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Police Expense Adjustments Police Revenue Adjustments 1100 1128 Retirement Pay-outs (23,590.00) 1314 Health Services 1345 Travel 1346 Training 1377 Radio Maintenance 1390 Other Contractual 1579 Uniforms 1319 Other Prof (4,000.00) 1325 Crime Prevention (500.00) 1344 Telephone (3,100.00) 1352 Photocopies (500.00) 1579 New Uniforms for all 78,440.00 1105 1321 Data Processing - 1520 Computer Software - (Decr)/Incr Expenses 46,750.00 (Decr)/Incr Revenue Fire Expense Requests Fire Revenue Adjustments 1400 1400 1130 Empl Benefit Reimb - 3416 Commercial Fire 1377 Radio Repair 3721 Service Charges 1390 Other Contractual 3515 False Alarms 1520 Computer Software 1344 Phone (1,000.00) OT was incr for FYE20 to keep 1114 Overtime (78,000.00) station 6 open. Reduce due to SAFER grant 1410 1410 1116 Holiday Bonus 3414 Ambulance Fee 100,000.00 1130 Empl Benefit Reimb 3721 Service Charges - 1311 Accounting Software 1315 Educational Training 1319 Other Prof Services 1378 Other Equip Repair 1390 Other Contractual K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 2 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction 1391 Dues&Memberships 1551 Drugs,medicine supplies 1785 Refunds 2116 Medical/Lab Equipment 1344 Telephone (1,000.00) 1114 Overtime (18,000.00) 2116 Remove equipment purchases (100,000.00) (Decr)/Incr Expenses (198,000.00) (Decr)/Incr Revenue 100,000.00 Garage Fire/Ambulance Expense Adjustments Garage Revenue Adjustments 1500 Parts (20,000.00) (Decr)/Incr Expenses (20,000.00) (Decr)/Incr Revenue - Garage Expense Adjustments Garage Revenue Adjustments 1100's Personnel (97,217.00) (Decr)/Incr Expenses (97,217.00) (Decr)/Incr Revenue Safety Committee Expense Adjustments Safety Committee Revenue Adjustments 1315 Utilities (2,500.00) (Decr)/Incr Expenses (2,500.00) (Decr)/Incr Revenue Airport Expense Adjustments Airport Revenue Adjustments 1328 Retirement Pay-outs (9,754.96) 1569 Vehicle Parts 1571 Machinery Parts CARES Act revenue (100,596.04) Bring tax levy to zero (Decr)/Incr Expenses (110,351.00) (Decr)/Incr Revenue Cultural&Arts Expense Adj Cultural&Arts Revenue Adjustments 1112 P-T Salaries (1,560.00) 10 to 11 Wed-Fri-Members Only Access 1112 P-T Salaries (3,120.00) Open reception Desk at 11 instead of 10 am Tues-Fri 3620 Add Rent from World's Window 1,200.00 (Decr)/Incr Expenses (215,627.04) (Decr)/Incr Revenue 1,200.00 K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 3 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Library Expense Adjustments Library Revenue Adjustments Salaries 3100 Materials 3470 Library Fees (Decr)/Incr Expenses (Decr)/Incr Revenue Leisure Expense Adjustments Leisure Revenue Adjustments 4100-Parks 1111 Delay hiring one Forestry positior (13,368.00) 1111 Salary savings-Reorganization (14,480.00) 1533 Fuel (3,000.00) 4110-Downtown Area Maintenance 1371 (4,000.00) 4120-Golf Golf 1300's (4,000.00) 3472 Golf Revenue - 4200-Sports 1300's (3,000.00) (Decr)/Incr Expenses (41,848.00) (Decr)/Incr Revenue 0.01 Totals General Fund (673,696.52) 1,701,200.01 General Fund Net Revenue Less Expense (2,374,896.53) Tax Rate Residential Comm Total Changes from Above (2,374,896.52) 18.91507 5.06% 2.57% Target to Cut to get to 2.42%increase 3,499,735.00 Balance remaining to 2.42%increase 1,124,838.47 Target to cut to get to 3%increase 3,254,735.00 Balance remaining to 3%increase 879,838.47 K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 4 of 5 3/15/20213:47 PM FYE2022 Budget General Fund Staff Requests with Changes as of March 15,2021 Expenses Revenue Addition (Addition) (Reduction) Reduction Target to cut to get to 4%increase 2,834,735.00 Balance remaining to 4%increase 459,838.47 Add Hiring Delays 120 days (586,076.00) Total Reductions (2,960,972.53) 18.66512 3.67% 1.22% Add Hiring Delays 120 days (586,076.00) Add 5 Furlough Days (546,985.00) Total Reductions (3,507,957.53) 18.43185 2.38% -0.05% K:\USERS\MICHELLE-W\Budget FYE22\Breakout of Staff Budget Requests with Changes 3 15 21.xlsx GF Pot Adj Version 3 Page 5 of 5