Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Council Packet - 3/10/2020
Council Work Session March 10, 2020 Time indicated below Harold E. Getty Council Chambers Roll Call. Approval of Agenda, as proposed or amended. 4:00 p.m. Discussion of MET Transit funding for the FYE2021 budget. Submitted By: Michelle Weidner, Chief Financial Officer Approx. Discussion of the FYE2021 budget. 4:20 p.m. Submitted By: Michelle Weidner, Chief Financial Officer ADJOURNMENT Kelley Felchle City Clerk CITY OF WATERLOO Council Communication Discussion of MET Transit funding for the FYE2021 budget. City Council Meeting: 3/10/2020 Prepared: 3/5/2020 REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/5/2020 - 6:56 PM ATTACHMENTS: Description Type ❑ MET Transit Authority Presentation 3-20 Backup Material ❑ MET Budget Comparsion FY19-21 Backup Material SUBJECT: Submitted by: Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: Discussion of MET Transit funding for the FYE2021 budget. Submitted By: Michelle Weidner, Chief Financial Officer ET MET Transit Authority 4 Welcome to MET Transit! 1515 BLACK HAWK ST. WATERLOO, IA www.mettransit.org MET Transit Mark Little, General Manager 319-234-5714 # 1 O 1 m.little@mettransit.org INRCOG Codie Leseman, Transportation Planner II 319-235-0311 cleseman@inrcog.org MD MET History In 1953, the St. John's Transportation Company bought the transit system from the Waterloo, Cedar Falls, and Northern Railroad (WCF&N) with the intent of establishing a financially sound operation. However, Waterloo and Cedar Falls experienced a decline in rider ship that mirrored the national postwar trend in the increased use of the personal auto. Re -nues continued to decline and the business again changed hands in 1958 . nd was subsequently placed in receivership in 1964. In 1965, National City ines, a national transit management company, contracted to operate the trsit system for the Waterloo Industrial Development Association which rved as the representative of the metropolitan area. Later, municipal epresentation was further refined through the establishment of a Bus Board which governed the operations of the Waterloo/Cedar Falls Transit Company with subsidization from the cities of Waterloo and Cedar Falls. MET History (cont.) In August of 1972, the Bus Board reorganized as the Metropolitan Transit Authority of Black Hawk County, Inc. and became a nonprofit quasi -public corporation as provided for in Chapter 388 of the Code of Iowa. Effective July 1, 1981, the Metropolitan Transit Authority of Black Hawk County, was re -chartered under Chapter 28E of the Code of Iowa, including the cities of Waterloo, Cedar Falls, Evansdale, and Elk Run Heights. In 1986, Evan •ale and Elk Run Heights opted out of the agreement. Today, MET serv-s Waterloo and Cedar Falls with fixed route and paratransit service, and Ev: nsdale with paratransit service under a separate agreement. Overview MET exists to provide public transportation for the citizens of the urbanized area of Black Hawk County, particularly the cities of Waterloo and Cedar Falls. The service we provide may be divided into two services, fixed route and paratransit. Fixed route service is the raditio al public transit bus service with which many people are most famil. r. Paratransit is a reservation -based door-to-door service int= ded to transport persons with disabilities that are unable to utilize t - fixed route system. Paratransit service is also provided to elderly ersons on a more limited basis. MET Personnel Management Staff 4 Full-time employees Maintenance Dept. 7 Full-time employees Transit Coordination 4 Full-time employees 1 Full-time Office Assistant Drivers Fixed Route 19 Full-time 1 Part-time Paratransit 15 Full-time 3 Part-time lim Metropolitan Transit Authority of BHC Board Members FY20 Rudy Jones Waterloo Pat Becker Waterloo David Glenn -Burns Cedar Falls Amanda Goodman Waterloo Rosalyn Middleton Waterloo Janna Diehl Waterloo Stefanie Hartel Cedar Falls Bonetta Culp Waterloo David Sturch Cedar Falls Pennie Drew Waterloo Barb Prather Waterloo Andrew Stensland UNI Cedar Falls Fixed Route 12 Fixed Routes 7 -Waterloo 1 - Cedar Falls 2 - Waterloo/Cedar Falls 1 - HCC/UNI 1 - UNI Campus Other Service Cattle Congress Special Cedar Valley Pride Fest Waterloo Black Hawks Shuttle Cedar Falls Downtown Shuttle Services Provided Fixed Route Service Average Weekday Rides: 1,187 Averag - Saturday Ri•-rship: 752 RIDERS 27% Elderly 38 Disabled General Public Paratransit Service Average 14 Routes per weekday Average 4 Routes on Saturdays 1111111 Daily Rides - Paratransit Weekday Disabled/Elderly Saturday Disabled 224 rides 49 rides Vehicles Total 40 Large / Medium duty / Light duty All vehicles are accessible to persons with disabilities /AII Fixed Route buses are quipped with bike racks and video surveillance Total miles FY 19 - Funding for Operations FY19 Operating Budget $5,1 19,321 FY20 Operating Budget $5,033,684 FY21 (Projected) Operating Budget: $5,21 1,782 Fixed Route and Paratransit Funding Sources Local Governments 36.9% Federal 34.2% Contracts 15.0% Fare box 7.6% State 6.3% Increase Revenue in Contracts Decreases Fare box Revenue Cities levying Taxes for Operation and Maintenance of Municipal Transit Systems Transit Levy Rate City . FY ' 15 { Cedar Falls Waterloo 0.24825 0.61945 FY'16 { FY'17 # FY 0.24226 0.63745 0.23776 0.62775 '18 # FY'19 f 0.20912 0.61699 0.20476 0.62331 FY'20 0.21399 0.60119 Cedar Rapids 0.80787 0.80787 0.80787 0.80787 0.80787 0.80787 Ames 0.65719 0.65200 0.64261 0.65194 0.63361 0.62811 Sioux City k_ 0.40047 0.59053 0.65407 0.65593 0.78785 0.86617 Dubuque 0.48268 0.48461 0.49739 0.66319 0.62877 0.61307 Iowa City 0.95000 0.94977 0.95000 0.95000 0.95000 0.95000 Marion 0.15561 0.16043 0.19520 0.26220 0.27564 Transit Levy Taxes Levied City - . FY'15 a FY'16 FY'17 FY'18 a FY'19 0. 28391j * FY'20 Cedar Falls I $370,045 $365,745 $373,115 $365,969 $375,254 Waterloo $1,328,419 $1,354,400 $1,357,106 $1,362,230 $1,362,469 Cedar Rapids 1 $4,492,891 $4,579,535 $4,609,082 $4,909,971 $5,148,739 Ames $1,542,372 $1,590,484 $1,669,335 $1,756,830 $1,842,263 $417,377 $1,365,520 $5, 295, 831 $1,929, 598 Sioux City $860,143 $1, 269, 624 $1, 545, 651 $1,624,744 $2, 077, 644 $2, 334, 620 Dubuque $1,050,056 $1,056,450 $1,135,973 $1, 523, 544 $1,527,512 $1, 515,145 Iowa City $2,913,708 $2,945,177 $3,136,939 $3, 248, 023 $3, 436, 028 $3, 575, 605 Marion $209,120 $217,849 $269,154 $385, 325 $421,185 $459,148 https://dom.iowa.gov/citybudgets Route Changes System will change from 9 full- time routes and 2 split routes to 10 full-time routes. Routes will largely travel in two dire ions, instead of large loops. his will reduce travel times. Some routes could run more frequently. Ridership is expected to increase as a result. Same service hours. Why restructure? Coverage has been very spread out. Service will improve for the vast majority of passengers, including transit -dependent rides. R: structuring will also ncourage "choice riders". Very low -ridership areas may lose coverage. High priority was given to improving service throughout downtown. Post Office Central Transfer Hawkeye ALC SportsPlex Public Library, Expo Plaza Convention Center Option for Expansion in Waterloo artner sr %o wamrss-oar.rH 9raes St John Deere Waterloo Weeks Fa� 3 Mks. W Perke,s ar Hie g'. Waterloo Airline Highway Tripper: Monday through Friday Arrive before 6:00, 7:00, and 8:00 a.m. Depart after 2:30, 3:30, and 4:30 p.m. Service to Omega, ConAgra, Advanced Heat Treat, Waterloo Warehousing, Donaldson, and more Estimated cost: $67,300 PROJECTS 2016 Ecolane web -based scheduling software and use of on -board mobile data terminals in Paratransit 217-18-19 nite GPS real time bus tracking solution for Fixed Route service www.mettransit.org/realtime Remix transit planning software New bus stops and shelters with the University Ave reconstruction project (Waterloo & Cedar Falls) Future projects Additional Fixed Route service and complete restructuring of routes Co tinned work with Waterloo and Cedar alls on bench and shelter placement Challenges Reduced Federal Funding for Bus Replacement Fixed Service Requests Expanded Coverage Expanded Hours Charter Regulations Metropolitan Transit Authority (MET Transit) Draft FY19 FY20 FY21 +/- FY20 REVENUE $5,119,321 $5,033,684 $5,211,782 $178,098 Wavier Income Federal Operating Waterloo/Cedar Falls w EXPENSES + / - Salaries/Wages FY19 FY20 FY21 FY20 Fringes $2,406,844 $2,465,599 $2,528,914 $63,315 Negotiated Labor increase +/- FY19 FY20 FY21 FY20 Vehicle Insurance/Work Comp $1,280,533 $1,223,205 $1,332,484 $109,279 Health Insurance +/- FY19 FY20 FY21 FY20 Admin Expenses $475,604 $475,634 $483,484 $7,850 +/- FY19 FY20 FY21 FY20 $126,279 $122,100 $128,700 $6,600 +/- Marketing FY19 FY20 FY21 FY20 Shop/Vehicle Maintenance $13,300 $16,800 $16,800 $0 +/- FY19 FY20 FY21 FY20 $628,491 $613,327 $613,981 $654 Metropolitan Transit Authority (MET Transit) Building Maintenance +/- FY19 FY20 FY21 FY20 Expenses / Purchased Service $62,519 $62,019 $62,419 $400 +/- FY19 FY20 FY21 FY20 Total Expenses from Operations Revenue from Operations $750 $0 $0 $0 +/- FY19 FY20 FY21 FY20 $4,994,321 $5,119,321 $4,978,684 $5,033,684 $5,166,782 $188,098 $5,211,782 $178,098 Surplus from Operations $125,000 $55,000 $45,000 Local Capital Projects $125,000 $55,000 $45,000 Ending $0 $0 $0 NOTE: The FY21 Draft Budget includes a 3% increase from both Waterloo and Cedar Falls -$10,000 CITY OF WATERLOO Council Communication Discussion of the FYE2021 budget. City Council Meeting: 3/10/2020 Prepared: REVIEWERS: Department Reviewer Action Date Finance Felchle, Kelley Approved 3/5/2020 - 6:57 PM ATTACHMENTS: Description Type ❑ Budget Options Council Requests Mar 5 2020 Backup Material ❑ FYE2021 Additioal Needs Budget Change in Cost Backup Material General Fund ❑ FYE2021 Additional Needs Budget General Fund Backup Material ❑ FYE2021 Additional Needs Budget Other Funds Backup Material ❑ FYE2021 Max Levy Budget General Fund Backup Material ❑ FYE2021 Max Levy Budget Other Funds Backup Material ❑ Proposed Budget State Forms FYE2021 Backup Material ❑ Published Budget Estimate FYE2021 Backup Material ❑ Property Valuation Changes Comparison Backup Material ❑ Local Option Sales Tax Backup Material SUBJECT: Submitted by: Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: Discussion of the FYE2021 budget. Submitted By: Michelle Weidner, Chief Financial Officer 3/6/2020 4:05 PM A B C D E F G H I J K 1 Waterloo FYE21 Budget 2 Thursday, March 05, 2020 3 Council Requests 4 5 Published Levy Rate 18.87697 6 Amount generated per penny of property tax 23,340 7 8 OPTION A OPTION B OPTION C 9 10 AMOUNT OF 11 ACTIVITY DEPARTMENT DESCRIPTION CHANGE 12 13 Requests Also Made by Departments in Additional Needs Level: 14 010 26 4250 C&A Add Graphic Artist (Digital Arts Mgr) 59,357 15 16 010 29 7700 Airport Add 1 FT operations specialist 87,043 17 18 010 018220 Info Tech 1 FT Individual - GIS specialist 101,386 101,386 19 20 SUBTOTAL - REQUESTS INCLUDED IN DEPARTMENT ADDITIONAL NEEDS LEVEL 160,743 - 188,429 21 22 Requests NOT included by Departments in Additional Needs Level: 23 24 010 26 4208 C&A Incr Ed. Asst Salary from $10 to $11 3,178 25 010 26 4208 C&A FT Staff 10% Increase 17,174 26 27 010 26 4250 C&A FT Staff 10% Increase 33,040 28 010 26 4250 C&A Fixed Asset Repair Fund 10,000 29 30 010 27 2500 Human Rights 1 FT Individual (used RJ's rate) 85,040 31 010 27 2500 Human Rights Education Outreach 10,000 32 33 010 017800 MET MET Transit Funding Increase 72,000 34 35 010 33 3100 Library 1 FT Individual Library Assistant 56,010 36 010 33 3100 Library 1 FT Individual Library Assistant - Levy Portion 17,897 37 010 33 3100 Library Materials 50,000 38 39 01018 7950 Central Garage 1 FT Mechanic 91,123 91,123 40 41 010 06 8600 City Attorney 1 FT Assistant Attorney 82,517 82,517 42 43 010 22 5100 Building Inspections 1 FT Individual 91,807 44 45 01012 1400 Fire - Grants 5 1st Yr Fire Fighters (FF) 423,817 423,817 423,817 46 01012 1400 Fire - Property Tax 5 FF 25% funded (Reduce by 75% grant funding) (318,896) (317,863) (317,863) 47 01012 1400 Fire - Property Tax Reduce Overtime (95,000) (95,000) (95,000) 48 49 52515 5125 Code Enforcement 1 FT Code Enforcement Officer 90,241 50 51 NET CHANGES 629,707 102,077 183,712 52 53 ADD BACK REVENUE INCREASES 318,896 317,863 317,863 54 55 TOTAL EXPENSE CHANGES 948,603 419,940 501,575 56 OTHER FUNDS (LIBRARY LEVY FUND PORTION AND SANITATION) (17,897) (82,517) 57 NET GENERAL FUND EXPENSES 930,706 419,940 419,058 K:\USERS\MICHELLE-W\Budget FYE21\Council Work Sessions\Thurs Mar 5\Budget Options Council Requests Mar 5 2020.xlsx Budget Options Mar 5 2020'age 1 of 1 A C F G H 1 J K 2 3 6 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 City of Waterloo FYE202I General Fund Additional Needs Budget Change In Cost From FY20 Property Taxes FYE2020 (Excl Debt Svc & Lib, Incl. Excise Tax, Grout) General Fund Personal Services increases (decreases): Salaries & longevity Remove hiring delays included in FYE19 Certified Budget Add 1 Airport Operations Specialist Add 5 Ambulance Medical Services Specialist Add C&A Digital Arts Manager (was p-t funded with hotel/motel tax) Add 1 maintenance position back to general fund (was funded with h/m tE Remove 1 maintenance position previously funded with hotel/motel taxes Add 1 MIS GIS Coordinator Increase in Personnel Costs Charged to Grants Increase Overtime Increase Part Time Labor Police & fire overtime, double time & bonus pay Misc, overtime, double time & bonus pay Payroll taxes Employee sick and casual payouts Retirement payouts Other misc personnel increases (decreases) Health insurance 664,734 Retiree health insurance (67,140) Reduce use of health insurance fund balance Police Pension 187,946 Fire Pension 179,451 Subtotal - Personnel Increases Amount 33, 572, 526 1,686,089 (258,816) 57,928 25,064 31,970 64,293 (64,293) 70,141 8,600 67,285 12,304 54,000 (42,335) 125,011 (20,000) 17,494 0 5971594 367,397 % of Total Change From Prior Year Tax Levy 23,340 1 cent on the levy raises this much 5.03% Includes avg 2.5% raises, step increases, longevity - 0.77% 0.17% 0.19% 021% 0.03% 020% 0.04% 0.16% - 0.13% 0.37% - 0.06% 0.05% 1.79% 2,432,329 1.04214 Personnel increases excl. fire & police pension 1.09% 2,799,726 1.19955 Total personnel increases 2,799,726 8.34% K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET Additional Needs Level Print Copy.xlsx\ Comparison to FYE20 3/5/2020 3:54 PM A C D F G H 1 J K 4 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 City of Waterloo FYE2021 General Fund Additional Needs Budget uhange In Cost From FY20 Contractual Services and Commodities: Airport - Increase Advertising and Other contractual BH County EMA - Increase Exp Council Central Garage - Computer Software Clerk Finance - Software, Misc Clerk Finance - Elections Cultural Arts -Increase Utilities, Misc Cultural Arts Increase Grant Expenses Comm Development LHAP Housing Pool Facilities Maintenance - Increase in Utilities Fire - Increase Dispatch. Software, Uniforms Fire - Ambulance - Reduce Billing Cost, Incr Travel Collect Services, Sup Garage - Motor Pool Hotel Motel Funding Increase INRCOG Dues Leisure Services - Univ Ave Leisure Services Golf - Decrease in Sales Tax Leisure Golf Course Improvements Decrease Leisure Services Young Arena - Incr utilities and sales tax Leisure Projects - Decrease Expenses Leisure Sportsplex Decrease Liability Insurance Library - Decrease County Expenses Mayor - Increase travel, strategic planning, program supplies MET - Increase in Requested Funding Parking - Decrease Expenses P olice - Increase Dispatch, fuel, travel, misc P olice Incr Grant Expenses Planning - Increase building & grounds maintenance S elf Funded Health insurance S ullivan Brothers Expense Increase Various Depts - Decrease In Other Expenses Subtotal - Contractual Services and Commodities Increases Amount 20,736 1,337 1,152 4,000 23,239 (60,000) 1,668 59,000 18,390 7,000 37,069 (31,215) 112,700 155,000 684 17,000 (4,849) (749) 24,000 (15,000) (36, 657) 147,953 (5, 625) 51,252 48,214 (6, 000) 106,172 8, 500 24,000 410, 946 2,511,658 2,478 % of Total Change From Prior Year Tax Levy 0.06% 0.00% 0.00% 0.01% 0.07% -0.18% 0.00% 0.18% 0.05% 0.02% 0.11% - 0.09% 0.34% 0.46% 0.00% 0.05% - 0.01% 0.00% 0.07% - 0.04% - 0.11% 0.44% - 0.02% 0.15% 0.14% -0.02% 0.32% 0.03% 0.07% 1 22% 7.48% 0.01% 3,634,053 10.80% 6,433,779 2 75657 Total all expense increases K:\USERS\MICHELLE-W\Budget FYE211FY21 BUDGET Additional Needs Level Print Copy.xlsx\ Comparison to FYE20 3/5/2020 3:54 PM 3 5 6 95 96 97 98 99 100 101 102 103 104 105 106 107 108! 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 A B C D F G H 1 J K City of VVaterloo FYE202I General Fund Additional Needs Budget Change In Cost From FY20 Revenue: Airport - Increase Central Garage - Increase Dept Charges Clerk work comp decrease Clerk/Finance - Increases Comm Development LHAP Housing Pool Cultural/Arts - Increased Fees Cultural Arts Grant increase Fire Ambulance - Increases Fire- Decreased Revenue Fire - Increase Training Center Revenue Hotel Motel Funding Increase Leisure Young Arena Incr Leisure Projects Decrease Rev Leisure Golf Course Improvements Decrease Leisure Sportsplex Decrease Leisure Services Golf - Decrease Library - Decrease Fine revenue Library Decrease County Funding MIS - Increase Fees Parking Revenue - Decrease Planning - Reductions in Revenue Police Increase Revenue Police Increase Grant Revenue S elf Funded Health Insurance S ullivan Brothers Rev Increase Increase use of fund balance S ubtotal - Revenue Net (Increases) Decreases Unemployment expense decrease Increase use of Fund Balance (restricted for Health Insurance) Increase use of Fund Balance (restricted for Workers Compensation) Total Increases (Decreases) Property Taxes Required (Excl Debt Service, Library Levy, Grout Levy) Maximum Levy Allowed Amount (73, 300) (112,700) 150,000 (108,210) (18, 390) (27,221) (59,548) (60, 000) 744 (1,200) (155, 000) (20, 000) 15,000 749 2,500 94,371 8,440 3,450 (12, 000) 6,000 161,926 (113,847) (25, 311) (410,916) (2,515,697) (937,246) 0 0 0 2,226,373 35,798,899 35,798,899 % of Total Change From Prior Year Tax Levy - 0 22% - 0.34% 0.45% - 0.32% - 0.05% -0.08% - 0.18% - 0.18% 0.00% 0.00% - 0.46% - 0.06% 0.04% 0.00% 0.01% 0 28% 0.03% 0.01% -0.04% 0.02% 0.48% -0.34% -0.08% -1 22% -7.49% - 2 79% (4,207,406) -12 53% 0.00% 0.00% 0.00% 6.62% 0.03% -1.80267 Total all revenue changes K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_ Additional Needs Level Print Copy.xlsx\ Comparison to FYE20 3/5/2020 3:54 PM 6 135 136 137 138 139 140 141 142 143 144 145 146 147, C City of Waterloo FYE2021 General Fund Additional Needs Budget Change In Cost From FY20 Amount Required to be Cut to meet maximum levy permitted Total change in taxes - formula check Variance - property taxes required E Amount 0 2,226,373 0 Decrease in Debt Service Levy (6,188) Decrease in Grout Taxes (5,033) Decrease in Library Levy (5,033) Total Additional Taxes 2,210,119 0 F G % of Total Change From Prior Year Tax Levy J K K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_ Additional Needs Level Print Copy.xlsx\ Comparison to FYE20 3/5/2020 3:54 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT L NEEDS BUDGET COMPARISON - CITY OF WATERLISCPt. Additional Budget GENERAL FUND 2/20/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET °% FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES FUND -GENERAL BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS LEVIED $ 18.61487 3 $ AMOUNT % LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE 4 CHANGE 5 PUBLIC SAFETY 6 010-11-1100 POLICE OPERATIONS 1C 13,963,647 14,735,932 5.53% 248,664 362,511 13,714,983 14,373,421 658,438 4.80% 7 010-11-1105 POLICE COMPUTER SERVICE 1C 224,276 242,968 8.33% 0 0 224,276 242,968 18,692 8.33% 8 010-11-1200 PUBLIC SAFETY ADMINISTRATION 1C 162181 168,449 3,86% 0 0 162,181 168,449 6,268 3.86% 9 200-11-1140 POLICE PENSION 1D 2,327,059 2,515,005 8.08% 0 0 10 010-11-1150 POLICE GRANTS 1C .. _ 2,327,059 2,515,005 187,946 8.08% 596,715 615,526 2.81% 598,715 615,526 "0 - 0 0 11 010-11-1150 POLICE GRANTS (DISCR H/M) 1C 0 ; " 0. 0.00% 0 ."0.00°l0 12 010-11-1160 LAW ENFORCEMENT PROGRAMS 1C 236,500 245,000 3.59% :- .. 236,500245,000 0" 0 "" ". 0 0 0.00% 13 010-11-1165 POLICE TOBACCO ENFORCEMENT 1C 5,500 5,500 0.00% 5,5.00 0 5,500 0 0 0.00% 0 0 : 0 0,00% 14 010-01-1700 B.H. COUNTY EMA/SIREN MAINTENANCE 3C 94,675 96,012 1.41% 0 0 94,675 96,012 1,337 1.41% 15 010-12-1400 FIRE RESCUE 5C 9,325,225 10,006,270 7.30% 62,594 61,850 9,262,631 9,944,420 681,789 7.36% 16 010-18-1405 FIRE -GARAGE PARTS & SERVICE 5C 193,708 197,672 2.05% 0 0 193,708 197,672 3,964 2.05% 17 200-12-1420 FIRE PENSION 5D 1,589,530 1,734,227 9.10% 0 0 1,589,530 18 1,734,227 144,697 9.10% 010-12-1412 FIRE RESTRICTED PROGRAMS 5C 25,305 25,305- 0.00%" - 25,305: 25,305" 19 _ _. 0 0 0 0.00% 010-12-1415 HAZARDS REGIONAL RESPONSE TRG PROG 5C 179,358 181,357 1.11% 165,300 166,500 14,058 20 010-12-1425 FIRE SAFER GRANT 14,857 799 5.68% 5C 0 0 0.00% 0 0 21 010-12-1410 FIRE AMBULANCE SERVICE 6C 2,237,861 2,363,384 5.61% 1,948,000 2,008,000 0 289,861 0 355,384 0 65,523 0.0O%0"/0 22.60% 22 200-12-1410 FIRE AMBULANCE SERVICE PENSION 342,278 377,032 342,278 377,032 34,754 10.15% 23 010-18-1411 AMBULANCE -GARAGE PARTS & SERVICE 6C 38,500 38,500 0.00% 0 0 38,500 38,500 0 0.00% 24 010-22-5100 BUILDING INSPECTION 7C 1,203,684 1,249,147 3.78% 1,639,009 1,639,009 (435,325) (389,862) 45,463 25 -10.44% 26 TOTAL -PUBLIC SAFETY 11C 32,748,002 34,797,286 6.26% 4,929,587 5,129,201 27,818,415 29,668,085 1,849,670 6.65% 27 Less Fund 200 (4,258,867) (4,626,264) - 28 TOTAL -GENERAL FUND 28,489,135 30,171,022 29 PUBLIC WORKS 30 010-07-7650 SIDEWALKS 12C 215,000 215,000 0.00% 215,000 215,000 0 0 0 0,00% 31 010-17-7910 PARKING FACILITY MAINTENANCE 13C 17,580 18,960 7.85% 0 0 17,580 18,960 1,380 7.85% 32 010-22-7930 PARKING OPERATIONS 13C 533,500 527,500 -1.12% 533,500 527,500 0 0 0 0.00% 33 010-29-7700 AIRPORT OPERATIONS 19C 1,075,407 1,209,814 12.50% 1,075,407 1,148,707 0 61,107 61,107 NEW 34 010-01-7800 MET TRANSIT AUTHORITY 21C 1,414,374 1,462,588 3.41% 0 0 1,414,374 1,462,588 48,214 3.41% 35 010-18-7950 CENTRAL GARAGE 21C 449,251 510,785 13.70% 84,800 84,800 364,451 425,985 61,534 16.88% 36 010-18-7952 CENTRAL GARAGE - CHARGEBACKS 21C 530,000 530,000 0.00% 530,000 530,000 0 0 0 0.00% 37 010-18-7955 MOTOR POOL -PASS THROUGH ACCOUNT 21C 1,935,768 2,048,468 5.82% 1,956,859 2,069,559 (21,091) (21,091) 0 0.00% 38 39 TOTAL -PUBLIC WORKS 22C 6,170,880 6,523,115 5.71% 4,395,566 4,575,566 1,775,314 1,947,549 172,235 9.70% 40 41 HEALTH & SOCIAL SERVICES 42 010-27-2500 HUMAN RIGHTS COMMISSION 29C 267,783 278,760 4.10% 0 0 267,783 43 010-27-2505 EEOC CONTRACT 29C 45;000. 45,000 0,00% 45,000 45,000 278,760 =- 10,977 4.10% 44 010-27-2510 FAIR HOUSING ENFORCEMENT 29C 0' " ' ',0 0,00% 0 . , 0 0 0 io.00vo : 45 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 29C 0 0 0 --0 0 0,00% 0 =0.00% 0 0 46 010-27-2520 HUMAN RIGHTS PROJECTS 29C 0 0 0.00% ' 0 0 0 0 0 0.00% 47 0 0 0 0.00% 48 TOTAL -HEALTH & SOCIAL SERVICES 30C 312,783 323,760 o 3.51 /0 45,000 l 45,000, 267,783 278,760 10,977 4.10% K:\USERSWICHELLE-W\Budget FYE21\FY21 BUDGET Additional Needs Level Print Copy.xlsx 1 3/5/2020 3:32 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT'L NEEDS BUDGET COMPARISON - CITY OF WATERLOCS. Additional Budget GENERAL FUND 2/20/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS LEVIED $ 18.61487 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE CHANGE 4 49 CULTURE & RECREATION 50 010-01-4405 CEMETERY OPERATIONAL SUBSIDY 35C 50,000 50,000 0.00% 0 0 50,000 50,000 0 0.00% 51 010-01-4220 GROUT MUSEUM 32C 659,430 652,746 -1.01% 24,222 22,571 635,208 630,175 (5,033) -0.79% 52 010-26-4208 YOUTH PAVILION 32C 409,585 415,106 1.35% 94,300 105,600 315,285 309,506 (5,779) -1.83% 53 010-26-4250 CENTER FOR THE ARTS 32C 734,805 830,462 13.02% 141,579 160,000 593,226 670,462 77,236 13.02% 54 010-26-4251 RIVERLOOP EVENT FACILITIES 32C 14,350 15,958 11.21% 20,000 17,500 (5,650) (1,542) 4,108 -72.71% 55 010-26-4265 C&A GRANTS & PROJECTS 32C 358000 948000 168.57°h 35,000 94,000 0 0 56 010-26-4265 CENTER FOR THE ARTS (HIM) 32C 0 0 0,00% 0 0 0- 0 0 0;004/6 57 010-26-4265 CENTER FOR THE ARTS (DISCR H/M) 32C 188643 198191 2.94% 18,643. 19,191 0 0 0 0.00% 58 010-33-3100 LIBRARY SERVICES 31C+levy 1,837,384 11894,628 I 0 0,00% 3.12% 27,000 18,560 I 1,810,384 ( 1,876,068 L_- 65,684 ' 3.63% 59 010-33-3110 LIBRARY - ENRICH IOWA GRANT 31C -'188417 1$,417 O.00% ° ; 18,417 18;417- 0 0 60 010-33-3150 LIBRARY OPEN ACCESS PLUS 31C 3OD0- 3OOD; '- 0.00% _- "3,000 -_- 3,OOD, `. 0 0; 0 0,00% 61 010-33-3160 LIBRARY GRANTS 31C , 51;865 518865"; ; ' 0,00%' `" '. ' 51865 51;866 ` � 0 - 0 - 0 - O 0.00% : 0.00% 62 010-33-3180 LIBRARY GIFT & MEMORIAL 31C 5000 5000 0.00%':: 5000 5000 D 0 0 63 010-33-3190 IOWA LIBRARY SERVICE 31C 4.120.,, 4;1-20 ; ry 0 00°h:' : 4,120 ", '4,120 ; 0 0 OJ)0% " , ;. 0 . 0.00% 64 010-33-3200 COUNTY LIBRARY 31C 738083 69)633,' 472°h :73,083,` 698633` ;. ' 0 0 65 010-33-3210 LIBRARY OPEN ACCESS 31C 10,000 10,000 0.00% 10,000- ' 10,000 0. 0", 0 0.00% 66 010-37-4100 LEISURE SERVICES - PARKS 33C 1,6661960 1,762,269 5.72% 39,737 39,737 " 1,627,223 1,722,532 0 95,309 0.00% 5.86% 67 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACK 33C 950,000 950,000 0.00% 950,000 950,000 0 0 0 0.00% 68 010-37-4105 LEISURE SERVICES PROJECTS 33C 228000 78000` -66,16°h 228000 7,000 0. 0 0 69 010-37-4105 LEISURE SERVICES PROJECTS (H/M) 33C 0 0 0.00% " 0 "" 0" 0 0 0 0.00%% 0.00% 70 010-37-4110 LEISURE SERVICES - DOWNTOWN MTCE 33C 378,049 405,225 7.19% 0 0 378,049 405,225 27,176 7.19% 71 010-37-4120 GOLF COURSES 34C 1,176,638 1,196,006 1.65% 933,153 838,782 243,485 357,224 113,739 46.71% 72 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARGI34C 98253 8 504 -8.09%. 9,253 8,504' - 0 0 73 010-37-4180 SPORTSPLEX 34C 1,440,000 1,437,500' 0.17%""" 1,940,000" 1,437500` 0" 0 0 0600% 0 74 010-37-4200 SPORTS &YOUTH SERVICES 34C 620,906 638,187 2.78% 282,400 282,400 "" 338,506 355,787 17,281 0.00% 5.11% 75 010-37-4500 YOUNG ARENA 36C 783,472 818,771 4.51% 699,000 719,000 84,472 99,771 15,299 18.11% 76 77 TOTAL -CULTURE & RECREATION 38C 10,971,960 11,357,588 3.51% 4,901,772 4,882,380 6,070,188 6,475,208 405,020 6.67% 78 - 79 COMMUNITY & ECONOMIC DEVELOPMENT 80 010-08-5700 PLANNING & ZONING 42C 730,554 701,663 -3.95% 443,155 258,155 287,399 443,508 156,109 54.32% 81 010-08-5750 RECREATION AREA DEVELOPMENT 43C 700 700 0.00% 45,200 53,000 (44,500) (52,300) (7,800) 17.53% 82 010-08-5885 CITY PROPERTY MANAGEMENT 43C 121,200 145,200 19.80% 0 0 121,200 145,200 24,000 19.80% 83 010-01-5710 INRCOG MEMBERSHIP 43C 34,203 34,887 2.00% 0 0 34,203 34,887 684 2.00% 84 010-08-6100 PLANNING & ZONING -ECONOMIC DEVEL 40C 105,834 121,108 14.43% 105,834 121,108 0 0 0 85 010-08-6105 ECONOMIC DEVELOP -SPECIAL PROJECTS 40C 0 . 0 0.00% . 0, 0 ; "., 0" 0 0 0.00% 0,00% 86 010-01-6650 TOURISM PROMOTION -VARIOUS GRTS (H/M) 40C 240,000 270,000 12.50% 240,000 270,000 0 0 0 87 010-01-6660 TOURISM PROMOTION -VARIOUS DISCR (H/M) 40C 808000 130,000 62,50% 80,000 "" -- ' 1308000 - " 0.00% 0 0`` 0 0.00% 88 010-01-6920 CONVENTION & VISITORS BUREAU (H/M) 40C 600000 `- 675000 12.50% 6008000= 6758000 0 0 0 89 010-22-6860 SULLIVAN CENTER 0,00% MAINTENANCE 43C 267,835, 301 874 -° 12,71°k "267,835 --., 301,874 1 `0- " D 0 ,... .' ... 0.00% 90 010-32-5850 COMM DEVEL-ADMINISTRATIVE 41C 0-'- O'0:00%" 0' ' 0:0 0- 91 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 41C .448050 62;440` "41.75°/n - 44,050' -� fi2,440 0 0" 0 0,00% 0 92 0 0 0 0.00% 0.00% 93 TOTAL -COMMUNITY & ECONOMIC DEV 45C 2,224,376 2,442,872 9.82% 1,826,074 1,871,577 398,302 571,295 172,993 43.43% 94 K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_Additional Needs Level Print Copy.xisx 2 3/5/2020 3:32 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT'L NEEDS BUDGET COMPARISON - CITY OF WATERL(EFt. Additional Budget GENERAL FUND 2/20/20 A B D E F G H I J I K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES FUND BUDGET -GENERAL CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT L NEEDS LEVIED $ 18.61487 $ AMOUNT ok 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE CHANGE 4 95 96 GENERAL GOVERNMENT 97 010-01-8200 MAYOR'S OFFICE 46C 300,575 365,043 21.45% 0 0 300,575 365,043 64,468 21.45% 98 010-01-8280 COMMUNICATIONS 46C 10,891 10,891 0.00% 0 0 10,891 10,891 0 0.00% 99 010-01-8220 ADMIN SERVICES/MIS 46C 391,951 506,227 29.16% 1,445 13,445 390,506 492,782 102,276 26.19% 100 010-01-8222 ADMIN SERVICES/MIS -CHARGEBACKS 46C 40,000 40,000 0.00% 40,000 40,000 0 0 0 0.00% 101 010-02-8100 CITY COUNCIL 46C 74,175 76,999 3.81% 0 0 74,175 76,999 2,824 3.81% 102 010-03-8400 CITY CLERK AND FINANCE 47C 1,277,862 1,352,795 5.86% 5,962,026 6,070,236 (4,684,164) (4,717,441) (33,277) 0.71% 103 010-03-8400 CITY CLERK AND FINANCE - ELECTION COST 48C 60,000 0 -100.00% 0 0 60,000 0 (60,000) -100.00% 104010-03-8402 CITY CLERK AND FINANCE -CHARGEBACKS 47C 77,500 77,500 0.00% 77,500 77,500 0 0 0 0.00% 105 010-06-8600 CITY ATTORNEY 49C 312,690 353,135 12.93% 0 0 312,690 353,135 40,445 12.93% 106 010-03-8900 LIABILITY INSURANCE 51C 1,284,685 1,431,858 11.46% 0 0 1,284,685 1,431,858 147,173 11.46% 107010-03-8902 LIABILITY INSURANCE -CHARGEBACKS 51C 500,000 500,000 0.00% 500,000 500,000 0 0 0 0.00% 108 010-03-8905 HEALTH/LIFE INSURANCE 0 0 0.00% 0 0 0 0 0 0.00% 109 010-03-8950 SELF FUNDED HEALTH INSURANCE 52C 3,472,295 3,883,241 11.83% 3,472,295 3,883,211 0 30 30 NEW 110 010-03-8960 SELF FUNDED WORK COMP 52C 777,457 777,457 0.00% 250,000 100,000 527,457 677,457 150,000 28.44% 111 010-03-8150 PUBLIC ACCESS STUDIO 52C 159,971 160,849 0.55% 30,750 30,750 129,221 130,099 878 0.68% 112 010-03-8970 PRINT SHOP 52C 46,000 46,000 0.00% 0 0 46,000 46,000 0 0.00% 113 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 52C 14,500 14,500 0.00% 0 0 14,500 14,500 0 0.00% 114 010-09-8250 HUMAN RESOURCES 52C 399,548 422,232 5,68% 0 0 399,548 422,232 22,684 5.68% 115010-09-8252 HUMAN RESOURCES -CHARGEBACKS 52C 32,500 32,500 0.00% 32,500 32,500 0 0 0 0.00% 116 010-09-8255 SAFETY COMMITTEE 52C 17,500 17,500 0.00% 0 0 17,500 17,500 0 0.00% 117 010-22-8800 CITY HALUFACILITIES MAINTENANCE 50C 567,861 678,051 19.40% 0 0 567,861 678,051 110,190 19.40% 118 010-22-8820 CITY FACILITIES RESTRICTED PROJECTS 50C 5;085 5,085 0.00% 5,085 5,085 0 0 119 010-22-8850 VETERANS MEMORIAL HALL 50C 8,815 8,815 0.00% 0 0 8,815 8,815 0 0 0.00°/u 0.00% 120 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 121 122 TOTAL -GENERAL GOVERNMENT 53C 9,849,333 10,778,150 9.43% 10,371,601 10,752,727 (522,268) 25,423 547,691 -104.87% 123 - - 124 125 TRANSFERS 126 010-03-9050 HOTEUMOTEL DEBT SERVICE TRANSFER 75C 0 0 0,00% 0 U 0 127 0 0.00% 010-03-9050 TIF ECONOMIC DEV TRANSFER (INTERNAL TI 76C 127;000 127,000 0.00% 127,000 127,000 0 0 128 010-08-9050 PLANNING & ZONING TRANSFER (TIF) 0.00% D 0.00% 129 TOTAL -TRANSFERS 77C 127,000 127,000 0.00% 127,000 127,000 0 0 0 0.00% 130 131 STATE REPLACEMENT FUNDS (COMM/IND ROLLBACK) 0 1,250,000 1,250,000 (1,250,000) (1,250,000) 0 0.00% 132 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% 350,000 1,287,246 (350,000) (1 287,246) (937,246) 267 78% 133 BACKFILL ADJUSTMENT 0 0.00% 0 0 0 0 0 0.00% 134 0 135 TOTAL CITY BUDGET - GENERAL FUND 62,404,334 66,349,771 6.32% 28,196,600 29,920,697 34,207,734 36,429,074 2,221,340 6.49% K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_Additional Needs Level Print Copy.xlsx 3 3/5/2020 3:32 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT L NEEDS BUDGET COMPARISON - CITY OF WATERL GENERAL FUND t. Additional Budget 2/20/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES FUND -GENERAL BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS LEVIED $ 18.61487 3 $ AMOUNT % LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE 4 CHANGE 136 137 TAXABLE VALUATION FYE2020 FYE2021 Increase % Increase 138 (In Thousands) (In Thousands) (Decrease) (Decrease) 139 Taxable valuation - including TIF but excluding gas & electric utility values 2,539,331 2,539,996 665 0.03% 140 Taxable valuation - excluding TIF & gas & electric utility values 2,271,362 2,255,590 (15,772) -0.69 % 141 Taxable valuation - including TIF and electric utility values 2,620,592 2,618,388 (2,204) -0.08% 142 Taxable valuation - excluding TIF but including gas & electric utility values 2,352,623 2,333,982 (18,641) -0.79% 143 Commercial/Industrial Property Rollback 105,541 107,173 1,632 1.55% 144 Commercial/Industrial Property Rollback for Debt Service 125,097 111,833 (13,264) -10.60% 145 Taxable valuation - Ag Land 14,264 14,891 627 4.40% 146 Tax Askings per One Cent of Levy 23,526 23,340 (186) -0.79% 147 85.00% 78.00% 148 PROPERTY TAX LEVY ANALYSIS: FY2020 TAX FY2020 TAX FY2021 TAX STATE BACKFILL FY2021 TAX $ AMOUNT 149 LEVY RATE LEVY CORP ROLLBACK RATE CHANGE 150 DEBT SERVICE LEVY 7,222,233 $ 2.75595 7,216,045 240,398 $ 2.75591 $ (6,188) 151 POLICE & FIRE PENSION SYSTEM 41284,537 $ 1.82117 41626,264 165,696 $ 1.98213 $ 341,727 152 EMERGENCY MGMT COMMISSION LEVY 94,675 $ 0.04024 96,012 3,439 $ 0.04114 $ 1,337 153 TRANSIT LEVY 1,414,374 $ 0.60119 1,462,588 52,385 $ 0.62665 $ 48,214 154 TORT INSURANCE LEVY 1,284,685 $ 0.54606 1,431,858 51,283 $ 0.61348 $ 147,173 155 FICA/IPERS LEVY 2,045,944 $ 0.86964 2,168,924 77,683 $ 0 92928 $ 122,980 156 HEALTH INSURANCE LEVY 4,169,083 $ 1.77210 5,738,166 205,521 $ 2.45853 $ 1,569,083 157 WORKERS COMP. INSURANCE LEVY 527,457 $ 0.22420 677,457 24,264 $ 0.29026 $ 150,000 158 UNEMPLOYMENT LEVY 17,472 $ 0.00743 17,472 626 $ 0.00749 $ 159 LIBRARY VOTED LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 160 EMERGENCY LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 161 GROUT LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 162 AG LAND LEVY 42,845 44,729 $ 1,884 163 Y GENERAL FUND $8.10 LEVY 19,056,246 $ 8.10000 18,905,254 677,119 $ 8.10000 $ (150,992) 165 TOTAL PROPERTY TAX LEVY $ 42,065,175 $ 17.54797 $ 44,275,294 $ 1,566,127 $ 18.61487 $ 2,210,119 $ 2,220,185 166 ROLLBACK REPLACEMENT- GENERAL LEVY NCLUOING EMPLOYEE BENEFITS LEVY, EXCL DEBT SERVICE $ 1,280,587 $ 167 ROLLBACK REPLACEMENT -GENERAL LEVY $ 851,939 168 ROLLBACK REPLACEMENT - EMPLOYEE BENEFITS LEVY $ 9,214,722 $ 473,790 169 AMOUNT CHANGE IN TAX LEVY $ 2,210,119 $ 1.07 170 % CHANGE 5.25% 6.08% 171 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT 0 $ 172 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) 18,905,254 $ 18.51487 173 $ 15.31895 1.32905 174 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) (150,992) 175 TOTAL PROPERTY TAX COLLECTION INCREASE 5.25% 176 177 Maximum Levy under384.15A 33,529,681 $ 14.25203 35,754,170 $ - 15.31896 2,224,489 6.63% K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_ Additional Needs Level Print Copy.xisx 4 3/5/2020 3:32 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT L NEEDS BUDGET COMPARISON - CITY OF WATERL GENERAL FUND Additional Budget 2/20/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS LEVIED $ 18.61487 $ AMOUNT 3 % LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE 4 CHANGE 178 179mu Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 181 $ 18.61487 FYE2021 152,234 152,234 0.550743 1,560.71 82.64 6.89 2.64% 182 $ 17.54799 FYE2020 152,234 152,234 0.56918 1,520.51 42.44 3.54 2.87% 183 $ 17.45595 FYE2019 152,234 Ind reval 152,234 0.556209 1,478.07 (47.52) (3.96) -3.11% 184 $ 17.60000 FYE2018 152,234 152,234 0.569391 1,525.58 34.74 2.90 2.33% 185 $ 17.60522 FYE2017 147,973 2.88% 152,234 0.556259 1,490.84 25.86 2.16 1.77% 186 $ 17.76370 FYE2016 147,973 147,973 0.557335 1,464.98 19.92 1.66 1.38% 187 $ 17.95159 FYE2015 154,138 -4% 147,973 0.544002 1,445.06 20.93 1.74 1.47% 188 $ 17.49319 FYE2014 154,138 154,138 0.528166 1,424.13 (0.01) (0.00) 0.00% 189 $ 18.20505 FYE2013 154,138 154,138 0.507518 1,424.14 37.79 3.15 2.73% 190 $ 18.53335 FYE2012 154,138 154,138 0.485299 1,386.35 65.76 5.48 4.98% 191 $ 18.26406 FYE2011 154,138 154,138 0.469094 1,320.59 34.15 2.85 2.65% 192 $ 18.30689 FYE2010 154,138 154,138 0.455893 1,286.43 38.51 3.21 3.09% 193 $ 18.36687 FYE2009 144,054 7% 154,138 0.440803 1,247.93 16.26 1.36 1.32% 194 $ 18.76669 FYE2008 144,054 144,054 0.455596 1,231.67 (17.04) (1.42) -1.36% 195 $ 18.84580 FYE2007 132,160 9% 144,054 0.45996 1,248.71 34.44 2.87 2.84% 196 $ 19.15566 FYE2006 132,160 132,160 0.479642 1,214.27 10.97 0.91 0.91% 197 $ 18.78999 FYE2005 118,000 12% 132,160 0.484558 1,203.30 56.70 4.72 4.95% 198 $ 18.90914 FYE2004 118,000 118,000 0.513874 1,146.60 26.52 2.21 2.37% 199 $ 18.37162 FYE2003 100,000 18% 118,000 0.516676 1,120.08 118.52 9.88 11.83% 200 $ 17.80075 FYE2002 100,000 N/A 100,000 0.562651 1,001.56 96.99 8.08 10.72% 201 $ 16.49097 FYE2001 100,000 100,000 0.548525 LUL 904.57 203 LU4 Commercial Tax Askings Property Value Avg. Revaluation Adj Value Rollback Tax Incr (Derr) Monthly Change % Change 205 $ 18.61487 FYE2021 752,427 752,427 0.90 12,605.70 784.80 65.40 6.08% 206 $ 17.54799 FYE2020 752,427 752,427 0.90 11,883.22 62.33 5.19 0.53% 207 $ 17.45595 FYE2019 752,427 752,427 0.90 11,820.90 (97.55) (8.13) -0.82% 208 $ 17.60000 FYE2018 752,427 752,427 0.90 11,918.44 (3.53) (0.29) -0.03% 209 $ 17.60522 FYE2017 752,427 752,427 0.90 11,921.98 (107.32) (8.94) -0.89% 210 $ 17.76370 FYE2016 752,427 752,427 0.90 12,029.30 (802.60) (66.88) -6.25% 211 $ 17.95159 FYE2015 752,427 752,427 0.95 12,831.90 (330.45) (27.54) -2.51% 212 $ 17.49319 FYE2014 752,427 752,427 1 13,162.35 (535.62) (44.64) -3.91% 213 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59) -1.77% 214 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89 1.47% 215 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32.23) (2.69) -0.23% 216 $ 18.30689 FYE2010 752,427 752,427 1 13,774.60 (7.98) (0.67) -0.06% 217 $ 18.36687 FYE2009 690,300 9% 752,427 0.997312 13,782.58 827.94 68.99 6.39% 218 $ 18.76669 FYE2008 690,300 N/A 690,300 1 12,954.65 55.85 4.65 0.43% 219 $ 18.84580 FYE2007 690,300 N/A 690,300 0.991509 12,898.79 (324.36) (27.03) -2.45% 220 $ 19.15566 FYE2006 690,300 N/A 690,300 1 13,223.15 348.79 29.07 2.71% 221 $ 18.78999 FYE2005 585,000 18% 690,300 0.99257 12,874.36 1,812.51 151.04 16.39% 222 $ 18.90914 FYE2004 585,000 N/A 585,000 1 11,061.85 554.11 46.18 5.27% 223 $ 18.37162 FYE2003 585,000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91% 224 $ 17.80075 FYE2002 585,000 N/A 585,000 1 10,413.44 766.22 63.85 7.94% 225 LLU $ 16.49097 FYE2001 500,000 17% 585,000 1 9,647,22 K:\USERS\MICHELLE-VV\Budget FYE21\FY21 BUDGET_Additional Needs Level Print Copy.xlsx 5 3/5/2020 3:32 PM FYE2020 CERTIFIED AND FYE2021 DEPT. ADDT'L NEEDS BUDGET COMPARISON - CITY OF WATERLG&t, Additional Budget GENERAL FUND 2/20/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES LEVIED 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS LEVIED $ 18.61487 $ AMOUNT 3 LINE EXPENSE EXPENSE REVENUE REVENUE $ 17.54799 6.08% CHANGE CHANGE 4 227 LLU Industrial Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 229 $ 18.61487 FYE2021 1,000,000 N/A 1,000,000 0.90 16,753.38 1,043.03 86.92 6.08% 230 $ 17.54799 FYE2020 1,000,000 N/A 1,000,000 0.90 15,793.19 82.84 6.90 0.53% 231 $ 17.45595 FYE2019 1,000,000 N/A 1,000,000 0.90 15,710.36 (129.65) (10.80) -0.82% 232 $ 17.60000 FYE2018 1,000,000 N/A 1,000,000 0.90 15,840.00 (4.70) (0.39) -0.03% 233 $ 17.60522 FYE2017 1,000,000 N/A 1,000,000 0.90 15,844.70 (142.63) (11.89) -0.89% 234 $ 17.76370 FYE2016 1,000,000 N/A 1,000,000 0.90 15,987.33 (1,066.68) (88.89) -6.25% 235 $ 17.95159 FYE2015 1,000,000 N/A 1,000,000 0.95 17,054.01 (439.18) (36.60) -2.51% 236 $ 17.49319 FYE2014 1,000,000 N/A 1,000,000 1 17,493.19 (711.86) (59.32) -3.91% 237 $ 18.20505 FYE2013 1,000,000 N/A 1,000,000 1 18,205.05 (328.30) (27.36) -1.77% 238 $ 18.53335 FYE2012 1,000,000 N/A 1,000,000 1 18,533.35 269.29 22.44 1.47% 239 $ 18.26406 FYE2011 1,000,000 N/A 1,000,000 1 18,264.06 (42.83) (3.57) -0.23% 240 $ 18.30689 FYE2010 1,000,000 N/A 1,0001000 1 18,306.89 (59.98) (5.00) -0.33% 241 $ 18.36687 FYE2009 1,000,000 N/A 1,000,000 1 18,366.87 (399.82) (33.32) -2.13% 242 $ 18.76669 FYE2008 1,000,000 N/A 1,000,000 1 18,766.69 (79.11) (6.59) -0.42% 243 $ 18.84580 FYE2007 1,000,000 N/A 1,0001000 1 18,845.80 (309.86) (25.82) -1.62% 244 $ 19.15566 FYE2006 1,000,000 N/A 1,000,000 1 19,155.66 365.67 30.47 1.95% 245 $ 18.78999 FYE2005 1,000,000 N/A 1,000,000 1 18,789.99 (119.15) (9.93) -0.63% 246 $ 18.90914 FYE2004 1,000,000 N/A 1,000,000 1 18,909.14 537.52 44.79 2.93% 247 $ 18.37162 FYE2003 1,000,000 N/A 1,000,000 1 18,371.62 570.87 47.57 3.21% 248 $ 17.80075 FYE2002 1,000,000 N/A 1,000,000 1 17,800.75 1,309.78 109.15 7.94% 249 $ 16.49097 FYE2001 1,000,000 N/A 1,000,000 1 16,490.97 250 251 LOG Multi -Residential Tax Askings Adj Value Rollback Tax Ina (Decr) Monthly Change % Change 253 $ 18.61487 FYE2021 500,000 N/A 500,000 0.7125 6,631.55 (241.73) (20.14) -3.52% 254 $ 17.54799 FYE2020 500,000 N/A 500,000 0.7500 6,580.50 (292.78) (24.40) -4.26% 255 $ 17.45595 FYE2019 500,000 N/A 500,000 0.7875 6,873.28 (386.72) (32.23) -5.33% 256 $ 17.60000 FYE2018 500,000 N/A 500,000 0.8250 7,260.00 (332.25) (27.69) -4.38% 257 $ 17.60522 FYE2017 500,000 N/A 500,000 0.8625 7,592.25 (401.41) (33.45) -5.02% 258 $ 17.76370 FYE2016 500,000 N/A 500,000 0.9000 7,993.67 (533.34) (44.45) -6.25% 259 $ 17.95159 FYE2015 500,000 N/A 500,000 0.9500 8,527.01 (219.59) (18.30) -2.51% 260 $ 17.49319 FYE2014 500,000 N/A 500,000 1 8,746.60 K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_Addiional Needs Level Print Copy.xisx 6 3/5/2020 3:32 PM FY2020 CERTIFIED AND FY2021 ADDT'L NEEDS BUDGET COMPARISON o CITY OF WATERLOO ALL OTHER FUNDS Addt'I Needs Budget 3/5/20 A B I C D E F 1 G H I J I K I L M N 1 0 1 P Q 1 PROJECT CERT FY2020 BUDGET FY2021 BUDGET % FY2020 BUDGET FY2021 BUDGET FY2020 FY2020 FY2021 FY2021 FY2020 FY2021 $ AMOUNT To 2 BUDGET CODE ACTIVITIES -OTHER FUNDS CODE BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 4 PUBLIC SAFETY ` 5 200-11-1140 POLICE PENSION SYSTEM 1D 2,327,059 2,515,005 8.08% 0 0 2,327,059 2,515,005 187,946 8.08% 6 200-12-1420 FIRE PENSION SYSTEM 5D 1,931,808 2,111,259 9.29% 0 0 1,931,808 2,111,259 179,451 9.29% 7 8 TOTAL -PUBLIC SAFETY 11D 4,258,867 4,626,264 8.63% 0 0 0 0 0 0 4,258,867 4,626,264 367,397 8.63% 9 10 11 PUBLIC WORKS 12 205-07-7400 BRIDGE MAINTENANCE - LOCAL OPTION 12D 0 0 0.00% 0 0 0 0 - 0.00% 13 205-07-7500 STREET CONSTRUCTION - LOCAL OPTION 12D 8,375,000 8,479,047 1.24% 10,085,000 10,245,000 (1,710,000) (1,765,953) (55,953) 3.27% 14 205-07-7830 ENGINEERING - LOCAL OPTION TAX 12D 705,948 735,500 4.19% 0 0 705,948 735,500 29,552 4.19% 15 205-19-7110 SEAL COATING - LOCAL OPTION 12D 940,323 1,030,453 9.59% 0 0 9 940,323 1,030,453 90,130 9.59% 16 266-07-7830 ROAD USE TAX REVENUE 0 0 0.00% 7,308,975 7,749,057 (7,308,975) (7,749,057) (440,082) 6.02% 17 266-07-7300 BRIDGE REPLACEMENT - ROAD USE TAX 12D 750,000 750,000 0.00% 0 0 750,000 750,000 0 0 0.00% 18 266-07-7500 STREET CONST - ROAD USE TAX 12D 7,500,000 7,500,000 0.00% 7,500,000 7,500,000 _ 0 0 0 0.00% 19 266-07-7830 ENGINEERING - ROAD USE TAX FUND 12D 1,133,437 1,160,676 2.40% 49,050 49,050 1,084,387 I 1,111,626 27,239 2.51% 20 266-07-7832 ENGINEERING - CHARGEBACKS (OUT) 12D 21,000 21,000 0.00% 21,000 21,000 0 0 0 0.00% 21 266-07-7832 ENGINEERING - CHARGEBACKS (IN) 12D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 22 266-17-7105 STREET LIGHTING UTIL - ROAD USE TAX 14D 518,000 518,000 0.00% 0 0 518,000 518,000 0 0.00% 23 266-17-7120 TRAFFIC SAFETY - ROAD USE TAX FUND 15D 1,499,000 1,536,158 2.48% 26,900 27,350 1,472,100 1,508,808 36,708 2.49% 24 266-17-7122 TRAFFIC SAFETY - CHARGEBACKS (OUT) 15D 32,000 32,000 0.00% 32,000 32,000 0 0 0 0.00% 25 266-17-7125 TRAFFIC SAFETY - RESTRICTED PROJ 17TRF DSCV 15D 100 100 0.00% 100 100 0 0 0 0.00% 26 i 266-17-7161 TRAFFIC SIGNALS UTIL - ROAD USE TAX 15D 48,000 48,000 0.00% 0 0 48,000 48,000 0 0.00% 27 266-19-7100 STREET MTCE - ROAD USE TAX FUND 12D 1,900,051 1,965,631 3.45% 550 550 1,899,501 1,965,081 65,580 3.45% 28 266-19-7102 STREET MTCE - CHARGEBACKS (OUT) 12D 158,500 158,500 0.00% 158,500 158,500 0 0 0 0.00% 29 266-19-7200 SNOW REMOVAL 16D 1,817,820 1,855,542 2.08% 0 8,000 1,817,820 1,847,542 29,722 1.64% 30 266-37-7902 ROW FORESTRY & MOWING 12D 900,000 900,000 0.00% 900,000 900,000 0 0 0 0.00% 31 291-29-7750 AIRPORT FEDERAL PROJECTS 29AIP xxxx 19D 758,808 634,528 -16.38% 758,808 634,528 0 0 0 0.00% 32 291-29-7755 AIRPORT PASSENGER FACILITY CHARGES 29AIP xxxx 19D 9 96,881 96,881 0.00% 96,881 96,881 0 33 291-29-7760 AIRPORT STATE PROJECTS 29PRO Vlxx 19D 129,000 177,000 37.21% 129,000 177,000 0 0 0 0.00% 0 0 0.00% 34 35 TOTAL -PUBLIC WORKS 22D 27,333,868 27,649,016 1.15% 27,116,764 27,649,016 0 0 0 0 217,104 0 (217,104) -100.00% 36 37 38 CULTURE & RECREATION 39 204-33-3100 LIBRARY - TAX LEVY 31C 641,712 667,690 4.05% 3,500 14,944 638,212 652,746 14,534 2.28% 40 41 TOTAL -CULTURE & RECREATION 641,712 667,690 4.05% 3,500 14,944 0 0 0 0 638,212 652,746 14,534 2.28% 42 43 J 44 COMMUNITY & ECONOMIC DEVELOPMENT 45 224-32-5850 JCOMM. DEVELOPMENT -BLOCK GRANT VARIOUS 41D 1,591,600 1,646,384 3.44% 1,591,600 1,646,384 0 0 0 0 1 0.00% 46 224-32-5853 COMM. DEVELOPMENT -LEAD PAINT GRANT 41D 1,106,460 1,378,918 24.62% 1,106,460 1,378,918 0 0 0 0 0.00% 47 224-32-5854 COMM. DEVELOPMENT -NEW CONSTRUCTIO 32NC4 xxxx 41D 0 0 0.00% 0 0 0 0 0 0.00% 48 224-32-5870 COMM. DEVELOPMENT -FEDERAL HOME VARIOUS 41D 841,781 1,361,742 61.77% 841,781 1,361,742 0 0 0 0.00% 49 224-32-6800 NEIGHBORHOOD SERVICES BG005 0016 41D 85,000 85,173 0.20% 85,000 85,173 0 0 U 0 0.00% u 51 283-13-5450 HOUSING - RIDGEWAY TOWERS 41D 253,200 262,000 3.48% 253,200 262,000 0 0 0 0.00% 52 283-13-5451 HOUSING - CAPITAL FUNDS (c/o) 13CAP FYxx 41D 60,000 65,000 8.33% 60,000 65,000 0 0 0 0.00% 53 283-13-5452 HOUSING - SECTION 8 41D 5,532,866 5,672,200 2.52% 5,532,866 5,672,200 0 0 0 0.00% 54 283-13-5453 HOUSING - FAMILY SELF SUFFICIENCY 41D 20,000 20,000 0.00% 20,000 20,000 0 0 0 0 0.00% 55 283-13-5455 HOUSING - DOWNPAYMENT ASSISTANCE 41D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 56 283-13-5861 HOUSING - LHAP HOUSING POOL 41D 0 0 0.00% 0 0 0 0 0 0.00% 57 58 TOTAL -COMMUNITY & ECONOMIC DEV 45D 9,540,907 10,541,417 10.49% 9,540,907 10,541,417 0 0 0 0 0 0 0 0.00% 59 60 K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_Additional Needs Level Print Copy.xlsx 1 3/5/2020 3:34 PM FY2020 CERTIFIED AND FY2021 ADPT'L NEEDS BUDGET COMPARISON o CITY OF WATERLOO ALL OTHER FUNDS Addt'I Needs Budget 3/5/20 A B C D E F G H I 1 J I K L M L N 1 0 P Q 1 PROJECT CERT FY2020 BUDGET FY2021 BUDGET % FY2020 BUDGET FY2021 BUDGET FY2020 FY2020 FY2021 FY2021 FY2020 FY2021 2 BUDGET CODE ACTIVITIES -OTHER FUNDS $ AMOUNT CODE BUDGET CERTIFIED ADDT'L NEEDS CHANGE CERTIFIED ADDT'L NEEDS TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE 3 CHANGE LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 113 525-15-5400 SANITATION 641 3,660,362 4,741,923 29.55% 3,419,124 5,236,759 241,238 (494,836) 114 525-15-5402 SANITATION - CHARGEBACKS 641 (736,074) -305.12% 376,500 376,500 0.00% 451,500 451,500 (75,000) (75,000) 0 0.00% 115 525-15-5125 _ SANITATION -CODE ENFORCEMENT 641 552,731 651,863 17.93% 68,815 81,080 1 16 525-17-2400 483,916 570,783 86,867 17.95% SANITATION -ANIMAL CONTROL 641 290,486 362,689 24.86% 108,700 111,700 181,786 117 250,989 69,203 38.07% SUBTOTAL - SANITATION FUND 4,880,079 6,132,975 25.67% 4,048,139 5,881,039 0 118 831,940 251,936 (580,004) -69.72% 119 TOTAL -BUSINESS TYPE ACTIVITIES 731 29,118,423 47,653,154 63.65% 28,539,204 48,828,348 0 2,561,343 2,427,130 3,140,562 1,251,936 120 (2,496,766) -60.14% 121 122 DEBT SERVICE 123 lop GEN. OBLIGATION BOND DEBT SERVICE 54F 13,731,607 13,157,973 -4.18% 533,070 497,367 (5,976,304) ( (5,444,561) 7,222,233 7,216,045 (6,188) 124 101 TIF ECONOMIC DEV & REBATES 43E 2,381,849 2,610,938 -0.09% 9.62% 8,735,719 9,398,510 (127,000)1 7,482,795 6,914,572 125 101 (127,000) 1,001,925 0 (1,001,925) -100.00% TAX INCREMENT DEBT SERVICE 54E 0 0 126 0.00% 0 0 0 0 0.00% 127 TOTAL -DEBT SERVICE 16,113,456 15,768,911 -2.14% 9,,,, 268 789 9 895 877 (6,103,304) 7,482,795 � (5,571,561) 6,914,572 8,224,158 7,216,045 128 (1,008,113) -12.26% 129 130 CAPITAL PROJECTS 131 419/420-8980 G.O. BOND PROCEEDS 55G 10,000,000 11,000,000 10.00% 10,000,000 11,000,000 0 0 0 0.00% 132 416/417/418/419 G.O. BOND/CAPITAL PROJECTS 55G 6,000,000 5,000,000 -16.67% 0 6,000,000 133 417/418/419 G.O. BOND/CAPITAL 5,000,000 (1,000,000) -16.67% PROJECTS--TIF 56G 0 0 0.00% 0 0 0 0 0.00% 134 417 G.O. BOND/CAPITAL PROJECTS—TECHWORKS IRD 55G 0 0 0.00% 0 IOD 0 0 0 0.00% 136 426-07-7400 CAP IMPR - 4TH ST BRIDGE CANOPY 55G 750,000 750,000 0.00% 750,000 750,000 0 0 0 0 0.00% 137 426-07-7355 CAP IMPR - UNIVERSITY AVENUE 265,000 265,000 0.00% 265,000 265,000 0 0 0 0 0.00% 139 426-37-4105 CAP IMPR - RIVERFRONT IMPR 55G 0 50,000 NEW 0 50,000 0 0 0 0.00% 140 426-37-4105 CAP IMPR LINCOLN PARK - PROJECT 37LINC GAME 55G 500,000 0 -100.00% 500,000 0 0 0 0 0.00% 141 426-37-4207 CAP IMPR - BOAT HOUSE AREA IMPR 55g 0 0 0.00% 0 0 142 0 0 0 0.00% 426-08-6205 CAP IMPR - SAN MARNAN TIF PROJ 56G 1,200,000 15,000 -98.75% 0 0 (1,200,000) (15,000) 0 143 426 08 6210 CAP IMPR RATH 0 0 0.00% - TIF PROJECTS 56G 150,000 300,000 100.00% 0 0 (150,000) (300,000) 0 0 0 0.00% 144 426-08-6220 CAP IMPR _ - NE SITE TIF PROJECTS 56G 100,000 0 -100,00% 0 0 145 (100,000) 0 0 0 0 0 0.00% 426-08-6250 CAP IMPR - MARTIN RD TIF PROJECTS 56G 275,000 196,000 -28.73% 0 0 (275,000) (196,000) 0 0 0 0.00% 146 426-08-6260 CAP IMPR MIDPORT TIF PROJECTS - 56G 1,305,000 2,048,033 56.94% 0 0 (1,305,000) (2,048,033) 147 426-08-6270 0 0 0 0.00% CAP IMPR - DOWNTOWN TIF PROJECTS 56G 0 40,000 NEW 0 0 (40,000) 148 426-08-6280 0 0 0 0.00% CAP IMPR - LOGAN SALE OF PROPERTY 56G 1,000,000 1,250,000 25.00% 0 0 (1,000,000) (1,250,000) 0 149 426-08-6280 0 0 0.00% 13000 56G 0 0 0.00% 0 0 - - 0 0 0 0.00% 150 151 TOTAL PROJECTS -CAPITAL 57G 21,560,000 21,093,522 -2.16% 11,530,000 12,244,489 (4,030,000) 0 (3,849,033) 0 6,000,000 5,000,000 (1,000,000) 152 -16.67% 153 154 (TOTAL CITY BUDGET - OTHER FUNDS 111,816,305 135,568,289 21.24% 89,425,764 116,944,934 (10,133,304) 10,239,138 (9,420,594) 9,541,702 22,496,375 18,744,463 (4,360,052) -16.68% K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET_Additional Needs Level Print Copy.xlsx 3 3/5/2020 3:34 PM 1 2 3 4 5 6 7 8 9 A FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO Max Levy Hearing Budget GENERAL FUND 3/4/20 BUDGET CODE B ACTIVITIES -GENERAL FUND D CERT BUDGET LINE E FY 2020 BUDGET CERTIFIED EXPENSE F FY2021 BUDGET PROPOSED EXPENSE G CHANGE H - FY 2020 BUDGET CERTIFIED REVENUE FY 2021 BUDGET PROPOSED REVENUE 10 PUBLIC SAFETY 010-11-1100 010-11-1105 010-11-1200 200-11-1140 010-11-1150 POLICE OPERATIONS POLICE COMPUTER SERVICE PUBLIC SAFETY ADMINISTRATION POLICE PENSION POLICE GRANTS 1C 1C 1C 1D 1C 11 12 010-11-1150 010-11-1160 POLICE GRANTS (DISCR H/M) LAW ENFORCEMENT PROGRAMS 1C 1C 13 010-11-1165 POLICE TOBACCO ENFORCEMENT 1C 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 010-01-1700 010-12-1400 010-18-1405 200-12-1420 010-12-1412 010-12-1415 010-12-1425 010-12-1410 200-12-1410 010-18-1411 010-22-5100 PUBLIC WORKS 010-07-7650 010-17-7910 010-22-7930 010-29-7700 010-01-7800 010-18-7950 010-18-7952 010-18-7955 B.H. COUNTY EMA/SIREN MAINTENANCE FIRE RESCUE FIRE -GARAGE PARTS & SERVICE FIRE PENSION FIRE RESTRICTED PROGRAMS HAZARDS REGIONAL RESPONSE TRG PROG FIRE SAFER GRANT FIRE AMBULANCE SERVICE FIRE AMBULANCE SERVICE PENSION AMBULANCE -GARAGE PARTS & SERVICE BUILDING INSPECTION TOTAL -PUBLIC SAFETY Less Fund 200 TOTAL -GENERAL FUND SIDEWALKS 3C 5C 5C 5D 5C 5C 5C 6C 6C 7C 11C 13,963,647 224,276 162,181 2,327,059 14,735,932 598,715 o . 236,500' 5,500 94,675 9,325,225 193,708 1,589,530 242,968 168,449 2,515,005 615,526 0'. 8951000_ 5:500 96,012 10,269,172 197,672 1,816,621 26 005 179,358 2,237,861 342,278 38,500 1,203,684 32,748,002 (4,258,867) 25,305` 181,357 0` 2,363,384 377,032 38,500 1,340,954 35,884,389 (4,708,658) 5.53% 8.33% 3.86% 8.08% 2,81°% 278,44% 0,00°% 1.41% 10.12% 2.05% 14.29% 0,00%. O,OD"% 5.61% 0.00% 11.40% 9.58% 248,664 0 0 0 598,715 236,500 5,500 0 62,594 0 0 362,511 0 0 0 615,526 0 895,000 5,500 0 380,746 0 0 25,305 25,305 165,300 166,500 0 0 1,948,000 2,0081000 J FY2020TAXES LEVIED $ $ 17.54799 0 1,6391009 4,929,587 0 1,639,009 6,098,097 13,714,983 K 1 L FY2021TAXES LEVIED 18.87699 $ AMOUNT 7.57% CHANGE J M CHANGE 14,373,421 658,438 4.80% 224,276 242,968 18,692 8.33% 162,181 2,327,059 0_ 0 0 0 94,675 9,262,631 193,708 168,449 2,515,005 0 0 0 96,012 6,268 187,946 0 0 0 0 1,337 3.86% 8.08% 0.00°% 0.00% 0.00% 0.00% 1.41% 9,888,426 1,589,530 14,058 0 289,861 197,672 625,795 1,816,621 0 14,857J 0 355,384 3,964 6.76% 2.05% 227,091 14.29% 0 0.00% 799 5.68% 0 0.00% 65,523 22.60% 342,278 38,500 377,032 38,500 34,754 0 10.15% 0.00% (435,325) 27,818,415 (298,055) 29,786,292 137,270 1,967,877 -31.53% 7.07% PARKING FACILITY MAINTENANCE PARKING OPERATIONS AIRPORT OPERATIONS MET TRANSIT AUTHORITY CENTRAL GARAGE CENTRAL GARAGE -CHARGEBACKS MOTOR POOL -PASS THROUGH ACCOUNT TOTAL -PUBLIC WORKS HEALTH & SOCIAL SERVICES 010-27-2500 010-27-2505 010-27-2510 010-27-2510 010-27-2520 HUMAN RIGHTS COMMISSION EEOC CONTRACT 12C 13C 13C 19C 21C 21C 21C 21C 22C 28,489,135 215,000 17,580 533,500 1,075,407 1,414,374 449,251 530,000 1,935,768 6,170,880 31,175,731 215,000 18,960 527,500 1,209,814 1,534,588 601,908 530,000 2,048,468 6,686,238 0.00% 7.85% -1.12% 12.50% 8.50% 33.98% 0.00% 5.82% 8.35% 215,000 0 533,500 1,075,407 0 84,800 530,000 1,956,859 4,395,566 215,000 0 527,500 1,148,707 0 84,800 530,000 2,069,559 4,575,566 0 17,580 0 0 1,414,374 364,451 0 (21,091) 1,775,314 0 18,960 0 61,107 1,534,588 517,108 0 (21,091) Imp 0 1,380 0 61,107 120,214 152,657 0 0 0.00% 7.85% 0.00% NEW 8.50% 41.89% 0.00% 0.00% 2,110,672 335,358 18.89% FAIR HOUSING ENFORCEMENT FAIR HOUSING PARTNERSHIP GRANT HUMAN RIGHTS PROJECTS TOTAL -HEALTH & SOCIAL SERVICES 29C 29C 29C 29C 29C 30C 267,783 373,800 45,000 45;000 312,783 418,800 39.59% 33.89% 0 45,000 ,. 45,000 0 0 45,000 267,783 0 267,783 373,800 0 0 0 0 106,017 0 0 0 39.59% 0,00% 0.00% 0,00% 0.00% 373,800 106,017 39.59% K:\USERS\MICHELLE-WlBudget FYE21\FY21 BUDGET Max Levy Hearing.xlsx 3/5/2020 3:12 PM FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO Max Levy Hearing Budget GENERAL FUND 3/4/20 i A B D E F G H I J K L M CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET FY2021TAXES LEVIED CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 3 LINE EXPENSE EXPENSE 18.87699 $ AMOUNT % REVENUE REVENUE $ 17.54799 7.57% 4 CHANGE CHANGE 49 CULTURE & RECREATION 50 010-01-4405 CEMETERY OPERATIONAL SUBSIDY 35C 50,000 50,000 0.00% 0 0 50,000 50,000 0 51 010-01-4220 GROUT MUSEUM 32C 659,430 652,746 -1.01% 24,222 22,571 635,208 630,175 0.00% 52 010-26-4208 YOUTH PAVILION 32C 409,585 435,458 6.32% 94,300 105,600 315,285 329,858 (5,033) 14,573 -0.79% 53 010-26-4250 CENTER FOR THE ARTS 32C 734,805 873,502 4.62% 18.88% 141,579 160000 593,226 713,502 54 010-26-4251 RIVERLOOP EVENT FACILITIES 32C 14,350 15,958 11.21% 20,000 17,500 (5,650) 120,276 20.27% 55 (1,542) 4,108 010-26-4265 C&A GRANTS & PROJECTS 32C 35,000 94,000:, 168;57% 35,000 94,000 _ _ _ _-72.71% 56 010 26-4265 CENTER FOR 0 0 0 0.00/0 THE ARTS (WM) 32C 0 0 0.00% 0 0 0 0 0 57 010-26-4265 CENTER FOR THE ARTS (DISCR H/M) 32C 18,643 19,191 2 94% 18,643 19,191 0.00% 0 0 58 010-33-3100 LIBRARY SERVICES 0 0.00% 31C+levy 1,837,394 L 2,000,638 889%1 27,000 18,560 I 1,810,384 I 1,982,078 _ 171,694 I 9.48% 59 010-33-3110 LIBRARY- ENRICH IOWA GRANT - 31C 18,417 o 18�417 Q00% 18,417 18;417 60 010-33-3150 LIBRARY OPEN ACCESS PLUS 31C 3,000 3000 000%. ' 3,000 3,000 0 0 0 0.00% 0: 0 0 61 010-33-3160 LIBRARY GRANTS 31C 51,865 51,865 0,00% 51,865 51,865', 0.00% 62 010-33-3180 LIBRARY GIFT & MEMORIAL 31C 0` 0 0 0,00% 5,000 5000 0,00% 5,000 5,000 63 010-33-3190 IOWA LIBRARY SERVICE 31C =4,120 4120`" 000% `-'= 41120 , 4120 0- 0 - 0 0.00% 0. 0`„ 64 010-33-3200 COUNTY LIBRARY 31C 73,083 691633`. 4,72%0 ` 73,083 69,633 0- 0,00% 65 010-33-3210 LIBRARY OPEN ACCESS 31C 10,000 10,000 0,00% 10,000 10,000 0 0 0 0,00% 0 66 0 0 0.00% 010-37-4100 LEISURE SERVICES PARKS - 33C 1,666,960 1,762,269 5.72% 39,737 39,737 1,627,223 1,722,532 67 010-37-4102 LEISURE SERVICES - PARKS - CHARGEBACK 33C 950,000 950,000 95,309 5.86% 0.00% 950,000 950,000 0 0 0 68 010-37-4105 LEISURE SERVICES PROJECTS 33C 0.00% 22,OOD 7,000 68,18°!0 22;000 69 010-37-4105 LEISURE SERVICES PROJECTS (H/M) 33C 0 0 0,00%nK 0. 7;000 13 0 o o 0.00% , 0 0 0 0,00% 70 010-37-4110 LEISURE SERVICES 37- - DOWNTOWN MTCE 33C 378,049 405,225 7.19% 0 0 0 378,049 405,225 - - - 71 010-37-4120 GOLF COURSES 34C 1,176,638 27,176 719% 1,196,006 1.65% 933,153 838,782 243,485 113,739 46.71% 72 010-37-4125 GOLF COURSE IMPROVEMENTS-SURCHARG _ 34C 9,259 8,504 -, -8,09% ;.. . 9 253 8,504 _357,224 _ 73 010-37-4180 SPORTSPLEX 34C 1,440,000' 1,437,500Y -0,17% '" 1,440,000 1,437,500 0 0 0 0.00% 0 0 74 0 0.00% 010-37-4200 SPORTS & YOUTH SERVICES 34C 620,906 638,187 2.78% 282,400 282,400 338,506 355,787 _ 75 010-37-4500 YOUNG ARENA 36C 783,472 17,281 5.11% 818,771 4.51% 699,000 719,000 84,472 99,771 15,299 76 18.11% 77 TOTAL -CULTURE & RECREATION 38C 10,971,960 11,526,990 5.06% 4,901,772 4,882,380 6,070,188 6,644,610 574,422 9.46% 78 79 COMMUNITY & ECONOMIC DEVELOPMENT 80 010-08-5700 PLANNING & ZONING 42C 730,554 701,663 -3.95% 443,155 258,155 287,399 443,508 156,109 54.32% 81 010-08-5750 RECREATION AREA DEVELOPMENT 43C 700 700 0.00% 45,200 53,000 (44,500) (52,300) 82 010-08-5885 CITY PROPERTY MANAGEMENT 43C 121,200 145,200 19.80% 0 0 121,200 145,200 (7,800) 24,000 17.53% 83 010-01-5710 INRCOG MEMBERSHIP 43C 34,203 34,887 2.00% 0 0 34,203 34,887 684 19.80% 84 010-08-6100 PLANNING & ZONING -ECONOMIC DEVEL 40C 105,834 121,108 14.43% 105,834 121,108 0 2.00% 0 0 0.00% 85 010-08-6105 ECONOMIC DEVELOP -SPECIAL PROJECTS 40C 0 0 0,00% 0 - _ 86 010-01-6650 TOURISM PROMOTION -VARIOUS GRTS (H/M) 40C 240,000 270,000 12,50% 240,000 270;000 0 0 0 0 0,00% 87 010-01-6660 TOURISM PROMOTION -VARIOUS DISCR (H/M) 40C 80,000 130,000 :. 62.50% 80,000 130,000 0 0 0 0,00°k 0 0 0 88 010-01-6920 CONVENTION & VISITORS BUREAU (H/M) 40C 600,000 6751000 . 12:50%> 600,000 675,000 0.00% 89 010-22-6860 SULLIVAN CENTER MAINTENANCE 43C 267,835 ., 0-100,00% 267,835 507,482 0 . 0 """ 0 " 0.00% 0 (507,482) (507,482) NEW 90 010-01-6860 SULLIVAN CENTER ADMINISTRATION 43C 0 ""2779,493'"NEW; 0 2,272,011 , 0' 507,482 507,482 NEW 91 010-32-5850 COMM DEVEL-ADMINISTRATIVE 41C 0 0 0,00% 0- 0 92 010-32-5861 COMM DEVEL-LHAP HOUSING POOL 41C 44,050 62,440`"' " 41.75% 44,050 62,440 0 0 0 0.00% 0 0 0 0,00% 93 0 0 94 TOTAL -COMMUNITY & ECONOMIC DEV 45C 2,224,376 0 0.00 % 4,920,491 121.21% 1,826,074 4,349,196 398,302 571,295 172,993 43.43% 95 K:\USERS\MICHELLE-w Budget FYE21\FY21 BUDGET_Max Levy Hearing.xlsx 2 3/5/2020 3:12 PM FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO Max Levy Hearing Budget GENERAL FUND 3/4/20 A B D E F G H I J K L CERT M FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED PROPOSED FY2021TAXES LEVIED CHANGE CERTIFIED PROPOSED LEVIED $ 3 LINE EXPENSE EXPENSE 18.97699 $ AMOUNT % REVENUE REVENUE $ 17.54799 4 7.57% CHANGE CHANGE -96 97 GENERAL GOVERNMENT 98 010-01-8200 MAYOR'S OFFICE 46C 300,575 365,043 21.45% 0 0 300,575 365,043 64,468 99 010-01-8280 COMMUNICATIONS 46C 10,891 10,891 0.00% 0 0 10,891 10,891 0 21.45% 100 010-01-8220 ADMIN SERVICES/MIS 46C 391,951 506,227 29.16% 1,445 13,445 390,506 492,782 102,276 0.00% 101 010-01-8222 ADMIN SERVICES/MIS - CHARGEBACKS 46C 40,000 40,000 0.00% 40,000 40,000 0 0 26.19% 102010-02-8100 CITY COUNCIL 46C 74,175 76,999 3.81%_ 0 0 74,175 76,999 0 0.00% 103 010-03-8400 CITY CLERK AND FINANCE 47C 1,277,862 1,352,795 5.86% 5,962,026 6,070,236 (4,684,164) (4,717,441) 2,824 3.81% 104 010-03-8400 CITY CLERK AND FINANCE - ELECTION COST 48C 60,000 0 -100.00% 0 0 60,000 0 (33,277) 0.71% 105 010-03-8402 CITY CLERK AND FINANCE - CHARGEBACKS 47C 77,500 77,500 (60,000) -100.00% _ 0.00% 77,500 77,500 0 0 106 010-06-8600 CITY ATTORNEY 49C 312,690 435,652 39.32% 0 0 312,690 435,652 0 122,962 0.00% 107010-03-8900 LIABILITY INSURANCE 51C 1,284,685 1,431,858 11.46% 0 0 _ 1,284,685 1,431,858 147,173 39.32% 108 010-03-8902 LIABILITY INSURANCE - CHARGEBACKS 51C 500,000 500,000 0.00% 500,000 _ 500,000 0 0 0 11.46% 109 010-03-8905 HEALTH/LIFE INSURANCE 0 0.00% 0 0.00% 0 0 0 0 0 110 010-03-8950 SELF FUNDED HEALTH INSURANCE 52C 3,472,295 3,883,241 0.00% 11.83% 3,472,295 3,883,211 0 30 30 111 010-03-8960 SELF FUNDED WORK COMP 52C 777,457 777,457 0.00% 250,000 NEW 100,000 527,457 677,457 112 010-03-8150 PUBLIC ACCESS STUDIO 52C 159,971 160,849 0.55% 30,750 30,750 129,221 130,099 150,000 878 28.44% 113 010-03-8970 PRINT SHOP 52C 46,000 46,000 0.00% 0_ 0 46,000 46,000 0 0.68% 114 010-09-2600 EAP SUBSTANCE ABUSE PROGRAM 52C 14,500 _ 14,500 0.00% 0 0 14,500 14,500 0 0.00% 115 010-09-8250 HUMAN RESOURCES 52C 399,548 422,232 _ 0.00% 5.68% 0 0 399,548 422,232 22,684 116 010-09-8252 HUMAN RESOURCES - CHARGEBACKS 52C 32,500 32,500 0.00% 32,500 32,500 0 5.68% 117 010-09-8255 SAFETY COMMITTEE 0 0 0.00°% 52C 17,500 17,500 0.00% 0 0 17,500 17,500 118 010-22-8800 CITY HALL/FACILITIES MAINTENANCE 50C 567,861 678,051 19.40% 0 0 567,861 0 0.00% 678,051 110,190 119 010-22-8820 T 19.40% CITY FACILITIES RESTRICTED PROJECTS 50C 5,085 5,085 0.00% 5,085 5 120 0 0 00% 010-22-8850 VETERANS MEMORIAL HALL 50C 8,815 8,815 0.00% 0 0 8,815 8,815 121 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 0 0.00% 17,472 0.00% 0 0 17,472 17,472 0 0.00% 122 123 TOTAL -GENERAL GOVERNMENT 53C 9,849,333 10,860,667 10.27% 10,371,601 10,752,727 (522,268) 107,940 630,208 124 -120.67% - 125 - 126 TRANSFERS 127 010-03-9050 HOTEUMOTEL DEBT SERVICE TRANSFER 75C 0 0 000% 0 000% 128 010-03-9050 TIF ECONOMIC DEV TRANSFER (INTERNAL TI 76C 127,000 127 000 0.00% 127,000 127,000 129 010-08-9050 PLANNING & ZONING TRANSFER (TIF) 0,00% 0 0 = 0 0.00% _ 130 TOTAL -TRANSFERS 77C 127,000 127,000 - 0.00% 127,000 127,000 0 0 131 0 0.00% 132 STATE REPLACEMENT FUNDS (COMMAND ROLLBACK) 0 1,250,000 1,250,000 (1,2501000) (1,250,000) 0 133 010-03-8400 PROPOSED USE OF FUND BALANCE 0 0.00% 350,000 1,303,782 (350,000) (1,3031782) (953,782) 0.00% 272.51% 134 BACKFILLADJUSTMENT 0 0.00% 0 0 0 0 0 0.00°% 135 o 136 TOTAL CITY BUDGET - GENERAL FUND 62,404,334 70,424,575 12.85% 28,196,600 33,383,748 34,207,734 37,040,827 2,833,093 8.28% K:\USERSWIICHELLE-Mudget FYE21\FY21 BUDGET_Max Levy Hearing.xlsx 3 3/5/2020 3:12 PM FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO Max Levy Hearing Budget GENERAL FUND 3/4/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED LEVIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.87699 3 LINE EXPENSE $ AMOUNT % EXPENSE REVENUE REVENUE $ 17.54799 7.57% 4 CHANGE CHANGE 137 138 TAXABLE VALUATION _ FYE2020 FYE2021 Increase % Increase 139 (In Thousands) (In Thousands) (Decrease) (Decrease) 140 Taxable valuation - including TIF but excluding gas & electric utility values 2,539,331 2,539,996 665 0.03% 141 Taxable valuation - excluding TIF & gas & electric utility values 2,271,362 2,255,590 (15,772) -0.69% 142 Taxable valuation - including TIF and electric utility values 2,620,592 2,618,388 (2,204) -0.08% 143 Taxable valuation - excluding TIF but including gas & electric utility values 2,352,623 21333,982 _ (18,641) -0.79% 144 Commercial/Industrial Property Rollback 105,541 107,173 1,632 1.55% 145 Commercial/Industrial Property Rollback for Debt Service 125,097 111,833 (13,264) -10.60% 146 Taxable valuation - Ag Land 14,264 14,891 627 4.40% 147 Tax Askings per One Cent of Levy 23,526 23,340 (186) -0.79% 148 85.00% 78.00% 149 PROPERTY TAX LEVY ANALYSIS: FY2020 TAX FY2020 TAX FY2021 TAX STATE BACKFILL FY2021 TAX $ AMOUNT 150 LEVY RATE LEVY CORP ROLLBACK RATE CHANGE 151 DEBT SERVICE LEVY 7,2221233 $ 2.75595 7,216,045 232,390 $ 2.75591 $ (6,188) 152 POLICE & FIRE PENSION SYSTEM 4,284,537 $ 1.82117 4,708,658 168,648 $ 2.01744 $ 424,121 153 EMERGENCY MGMT COMMISSION LEVY 94,675 $ 0.04024 _ 96,012 3,439 $ 0.04114 $ 1,337 154 TRANSIT LEVY _ 1,414,374 $ 0.60119 1,5341588 54,963 $ 0.65750 $ 120,214 155 TORT INSURANCE LEVY 1 284,685 $ 0.54606 _ 11431,858 51,283 $ 0.61348 $ 147,173 156 FICA/IPERS LEVY _ 2,045,944 $ 0.86964 2,168,924 77,683 $ 0.92928 $ 122,980 157 HEALTH INSURANCE LEVY 4,169,083 $ 1.77210 6,195,530 221,902 $ 2.65449 $ 2,026,447 158 WORKERS COMP. INSURANCE LEVY 527,457 $ 0.22420 677,457 24,264 $ 0.29026 $ 150,000 159 UNEMPLOYMENT LEVY 17,472 $ 0.00743 17,472 626 $ 0.00749 $ 160 LIBRARY VOTED LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 161 EMERGENCY LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 162 GROUT LEVY 635,208 $ 0.27000 630,175 22,571 $ 0.27000 $ (5,033) 163 AG LAND LEVY 42,845 44,729 $ 1,884 164 GENERAL FUND $8.10 LEVY 19,056,246 $ 8.10000 18,905,254 677,119 $ 8.10000 $ (150,992) 166 TOTAL PROPERTY TAX LEVY $ 42,065,175 $ 17.54797 $ 44,8871052 $ 1,580,030 $ 18.87699 $ 2,821,877 $ 21831,943 167 ROLLBACK REPLACEMENT- GENERAL LEVY NCLUDING EMPLOYEE BENEFITS LEW, EXCL DEBT SERVICE $ 1,3021498 $ 5 168 ROLLBACK REPLACEMENT- GENERAL LEVY $ 493,3 169 ROLLBACK REPLACEMENT- EMPLOYEE BENEFITS LEVY $ 9,672,0861$ 493,123 170 AMOUNT CHANGE IN TAX LEVY $ 2,82.7 $ 1.33 171 % CHANGE 6.71%7 7.57% 172 AMOUNT (OVER) UNDER $8.10 LEVY LIMIT 0 $ - 173 ADJUSTED TOTAL PROPERTY TAX LEVY (AT GF $8.10 LEVY LIMIT) 18,905,254 $ 18.87699 15.6164 174 $ 15.58108 1.32905 175 GENERAL FUND $8.10 LEVY INCREASE (DECREASE) (150,992) 176 TOTAL PROPERTY TAX COLLECTION INCREASE 6.71% 177 178 Maximum Levy under 384.15A 33,529,681 $ 14.25203 36,365,928 $ 15.58108 2,838,247 8.46% K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET Max Levy Hearing.xlsx 4 3/5/2020 3:12 PM Max Levy Hearing Budget FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND 3/4/20 ____11 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY2020TAXES FY2021TAXES 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED LEVIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.87699 3 LINE EXPENSE $ AMOUNT /, EXPENSE REVENUE REVENUE $ 17.54799 7.57% 4 CHANGE CHANGE 179 180 IUI Residential Tax Askings Home Value Avg Revaluation Adj Value Rollback Tax Ina (Decr) Monthly Change % Change 182 $ 18.87699 FYE2021 152,234 152,234 0.550743 1,582.68 104.62 8.72 4.09% 183 $ 17.54799 FYE2020 152,234 152,234 0.56918 1,520.51 42.44 3.54 2.87% 184 $ 17.45595 FYE2019 152,234 Ind reval 152,234 0.556209 1,478.07 (47.52) (3.96) -3.11% 185 $ 17.60000 FYE2018 152,234 152,234 0.569391 1,525.58 34.74 2.90 2.33% 186 $ 17.60522 FYE2017 147,973 2.88% 152,234 0.556259 1,490.84 25.86 2.16 1.77% 187 $ 17.76370 FYE2016 147,973 147,973 0.557335 1,464.98 19.92 1.66 1.38% 188 $ 17.95159 FYE2015 154,138 -4% 147,973 0.544002 1,445.06 20.93 1.74 1.47% 189 $ 17.49319 FYE2014 154,138 154,138 0.528166 1,424.13 (0.01) (0.00) 0.00% 190 $ 18.20505 FYE2013 154,138 154,138 0.507518 1,424.14 37.79 3.15 2.73% 191 $ 18.53335 FYE2012 154,138 154,138 0.485299 1,386.35 65.76 5.48 4.98% 192 $ 18.26406 FYE2011 154,138 154,138 0.469094 1,320.59 34.15 2.85 2.65% 193 $ 18.30689 FYE2010 154,138 154,138 0.455893 1,286.43 38.51 3.21 3.09% 194 $ 18.36687 FYE2009 144,054 7% 154,138 0.440803 1,247.93 16.26 1.36 1.32% 195 $ 18.76669 FYE2008 144,054 144,054 0.455596 1,231.67 (17.04) (1.42) -1.36% 196 $ 18.84580 FYE2007 132,160 9% 144,054 0.45996 1,248.71 34.44 2.87 2.84% 197 $ 19.15566 FYE2006 132,160 132,160 0.479642 1,214.27 10.97 0.91 0.91% 198 $ 18.78999 FYE2005 118,000 12% 132,160 0.484558 1,203.30 56.70 4.72 4.95% 199 $ 18.90914 FYE2004 118,000 118,000 0.513874 1,146.60 26.52 2.21 2.37% 200 $ 18.37162 FYE2003 100,000 18% 118,000 0.516676 1,120.08 118.52 9.88 11.83% 201 $ 17.80075 FYE2002 100,000 N/A 100,000 0.562651 1,001.56 96.99 8.08 10.72% 202 LUO $ 16.49097 FYE2001 100,000 100,000 0.548525 904.57 204 LVJ Commercial Tax Askings Property Value Avg. Revaluation Adj Value Rollback Tax Mu (Decr) Monthly Change % Change 206 $ 18.87699 FYE2021 752,427 752,427 0.90 12,783.20 962.31 80.19 7.57% 207 $ 17.54799 FYE2020 752,427 752,427 0.90 11,883.22 62.33 5.19 -0.30% 208 $ 17.45595 FYE2019 752,427_ 752,427 0.90 11,820.90 (97.55) (8.13) -0.82% 209 $ 17.60000 FYE2018 752,427 752,427 0.90 11,918.44 (3.53) (0.29) -0.03% 210 $ 17.60522 FYE2017 752,427 752,427 0.90 11,921.98 (107.32) (8.94) -0.89% 211 $ 17.76370 FYE2016 752,427 752,427 0.90 12,029.30 (802.60) (66.88) -6.25% 212 $ 17.95159 FYE2015 752,427 _ 752,427 0.95 12,831.90 (330.45) (27.54) -2.51% 213 $ 17.49319 FYE2014 752,427 752,427 1 13,162.35 (535.62) (44.64) -3.91% 214 $ 18.20505 FYE2013 752,427 752,427 1 13,697.97 (247.02) (20.59) -1.77% 215 $ 18.53335 FYE2012 752,427 752,427 1 13,944.99 202.62 16.89 1.47% 216 $ 18.26406 FYE2011 752,427 752,427 1 13,742.37 (32.23) (2.69) -0.23% 217 $ 18.30689 FYE2010 752,427 752,427 1 13,774.60 (7.98) (0.67) -0.06% 218 $ 18.36687 FYE2009 690,300 9% 752,427 0.997312 13,782.58 827.94 68.99 6.39% 219 $ 18.76669 FYE2008 690,300 N/A 690,300 1 12,954.65 55.85 4.65 0.43% 220 $ 18.84580 FYE2007 690,300 N/A 690,300 0.991509 12,898.79 (324.36) (27.03) -2.45% 221 $ 19.15566 FYE2006 690,300 N/A 690,300 1 13,223.15 348.79 29.07 2.71% 222 $ 18.78999 FYE2005 585,000 18% 690,300 0.99257 12,874.36 1,812.51 151.04 16.39% 223 $ 18.90914 FYE2004 585,000 N/A 585,000 1 11,061.85 554.11 46.18 5.27% 224 $ 18.37162 FYE2003 585,000 N/A 585,000 0.977701 10,507.74 94.30 7.86 0.91% 225 $ 17.80075 FYE2002 585,000 N/A 585,000 1 10,413.44 766.22 63.85 7.94% 226 $ 16.49097 FYE2001 500,000 17% 585,000 1 9,647.22 LL! K:\USERS\MICHELLE-VJ\Budget FYE21\FY21 BUDGET_Max Levy Hearing.xisx 5 3/5/2020 3:12 PM Max Levy Hearing Budget FYE2020 CERTIFIED AND FYE2021 MAX LEVY BUDGET COMPARISON - CITY OF WATERLOO GENERAL FUND 3/4/20 A B D E F G H I J K L M 1 CERT FY 2020 BUDGET FY 2021 BUDGET % FY 2020 BUDGET FY 2021 BUDGET FY202OTAXES FY2021TAXES 2 BUDGET CODE ACTIVITIES -GENERAL FUND BUDGET CERTIFIED LEVIED PROPOSED CHANGE CERTIFIED PROPOSED LEVIED $ 18.87699 3 LINE EXPENSE EXPENSE $ AMOUNT %, REVENUE REVENUE $ 17.54799 7.57% 4 CHANGE CHANGE 228 Industrial Tax Askings GL.7 Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 230 $ 18.87699 FYE2021 1,000,000 N/A 1,000,000 0.90 16,989.29 1,278.94 106.58 7.57% 231 $ 17.54799 FYE2020 1,000,000 N/A 1,000,000 0.90 15,793.19 82.84 _ 6.90 0.53% 232 $ 17.45595 FYE2019 _ 1,000,000 N/A 1,000,000 0.90 15,710.36 (129.65) (10.80) -0.82% 233 $ 17.60000 FYE2018 _ _ 1,000,000 N/A 1,000,000 0.90 15,840.00 (4.70) (0.39) -0.03% 234 $ 17.60522 FYE2017 1,000,000 N/A 1,000,000 0.90 15,844.70 (142.63) (11.89) -0.89% 235 $ 17.76370 FYE2016 1,000,000 N/A 1,000,000 0.90 15,987.33 (1,066.68) (88.89) _ -6.25% 236 $ 17.95159 FYE2015 1,000,000 N/A 1,000,000 0.95 17,054.01 (439.18) (36.60) -2.51% 237 $ 17.49319 FYE2014 1,000,000 N/A 1,000,000 1 17,493.19 _ (711.86) (59.32) -3.91% 238 $ 18.20505 FYE2013 1,000,000 N/A 1,000,000 1 18,205.05 (328.30) (27.36) -1.77% 239 $ 18.53335 FYE2012 1,000,000 N/A 1,000,000 1 18,533.35 269.29 22.44 147% 240 $ 18.26406 FYE2011 1,000,000 N/A 1,0001000 1 18,264.06 (42.83) (3.57) -0.23% 241 $ 18.30689 FYE2010 1,000,000 N/A 1,000,000 1 18,306.89 (59.98) (5.00) -0.33% 242 $ 18.36687 FYE2009 1,000,000 N/A 1,000,000 1 18,366.87 (399.82) (33.32) -2.13% 243 $ 18.76669 FYE2008 1,000,000 N/A 1,000,000 1 18,766.69 (79.11)_ (6.59) -0.42% 244 $ 18.84580 FYE2007 1,0001000 N/A 1,0001000 1 18,845.80 (309.86) (25.82) -1.62% 245 $ 19.15566 FYE2006 1,000,000 N/A 1,000,000 1 _ 19,155.66 365.67 30.47 1.95% 246 $ 18.78999 FYE2005 1,0001000 N/A 1,000,000_ 1 18,789.99 (119.15) (9.93) -0.63% 247 $ 18.90914 FYE2004 1,000,000 N/A 1,000,000 1 18,909.14 537.52 44.79 2.93% 248 $ 18.37162 FYE2003 1,000,000 N/A 1,000,000 1 18,371.62 570.87 47.57 3.21% 249 $ 17.80075 FYE2002 1,000,000 N/A 1,000,000 _ 1 17,800.75 1,309.78 109.15 7.94% 250 $ 16.49097 FYE2001 1,000,000 N/A 1,000,000 1 16,490.97 251 252 LOU Multi -Residential Tax Askings Adj Value Rollback Tax Incr (Decr) Monthly Change % Change 254 $ 18.87699 FYE2021 500,000 N/A 500,000 0.7125 6,724.93 (148.35) (12.36) -2.16% 255 $ 17.54799 FYE2020 500,000 N/A 500,000 _ 0.7500 6,580.50 (292.78) (24.40) -4.26% 256 $ 17.45595 FYE2019 500,000 N/A 500,000 0.7875 6,873.28 (386.72) (32.23) -5.33% 257 $ 17.60000 FYE2018 500,000 N/A 500,000 0.8250 7,260.00 (332.25) (27.69) -4.38% 258 $ 17.60522 FYE2017 500,000 N/A 500,000 0.8625 _ 7,592.25 (401.41) (33.45) -5.02% 259 $ 17.76370 FYE2016 500,000 N/A 500,000 _ 0.9000 7,993.67 (533.34) (44.45) -6.25% 260 $ 17.95159 FYE2015 500,000 N/A 500,000 0.9500 8,527.01 (219.59) (18.30) -2.51% 261 $ 17.49319 FYE2014 500,000 N/A 500,000 1 8,746.60 K:\USERS\MICHELLE-W\Budget FYE21\FY21 BUDGET Max Levy Hearing.xlsx 6 3/5/2020 3:12 PM FY2020 CERTIFIED AND FY2021 MAX LEVY HEARING BUDGET COMPARISON - CITY OF WATERLOO ALL OTHER FUNDS Max Levy Hearing 3/4/20 A B C D E F G H 1 J K1 L M N 0 P Q 1 PROJECT CERT FY2020 BUDGET FY2021 BUDGET % FY2020 BUDGET FY2021 BUDGET FY2020 FY2020 FY2021 FY2021 FY2020 FY2021 $ AMOUNT 2 BUDGET CODE ACTIVITIES -OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 4 PUBLIC SAFETY 5 200-11-1140 POLICE PENSION SYSTEM iD 2,327,059 2,515,005 8.08% 0 0 2,327,059 2,515,005 187,946 808% 6 200-12-1420 FIRE PENSION SYSTEM 5D 1,931,808 2,193,653 13.55% 0 0 1,931,808 2,193,653 261,845 13.55% 7 8 TOTAL -PUBLIC SAFETY 11D 4,258,867 4,706658 10.56% 0 0 0 0 0 0 4,258,867 4,708,658 449,791 10.56% 9 10 11 PUBLIC WORKS 12 205-07-7400 BRIDGE MAINTENANCE - LOCAL OPTION 12D 0 0 0.00% 0 0 0 0 0.00% 13 205-07-7500 STREET CONSTRUCTION - LOCAL OPTION 12D 8375000 8479047 1.24% 10,085,000 10,245,000 (1,710,000) (1,765,953) - (55,953) 3.27% 14 205-07-7830 ENGINEERING - LOCAL OPTION TAX 12D 705,948 735500 4.19 % 0 0 705,948 735,500 29,552 4.19% 15 205-19-7110 SEAL COATING - LOCAL OPTION 12D 940323 1,030,453 9.59% 0 0 940,323 1,030,453 90,130 9.59% 16 266-07-7830 ROAD USE TAX REVENUE 0 0 0.00% 7,308,975 7,749057 (7,308,975) (7,749,057) (440,082) 6.02% 17 266-07-7300 BRIDGE REPLACEMENT - ROAD USE TAX 12D 750,000 750,000 0.00% 0 0 750,000 750,000 0 0.00% 18 266-07-7500 STREET CONST - ROAD USE TAX 12D 7500,000 7500000 0.00% 7500,000 7500000 0 0 0 0.00% 19 266-07-7830 ENGINEERING- ROAD USE TAX FUND 12D 1,133,437 1,160,676 2.40% 49,050 49,050 1,084,387 1,111,626 27,239 2.51% 20 266-07-7832 ENGINEERING-CHARGEBACKS (OUT) 12D 21,000 21,000 0.00% 21,000 21,000 0 0 0 0.00% 21 266-07-7832 ENGINEERING- CHARGEBACKS (IN) 12D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 22 266-17-7105 STREET LIGHTING UTIL -ROAD USE TAX 14D 518,000 518,000 0.00% 0 0 518,000 518,000 0 0.00 23 266-17-7120 TRAFFIC SAFETY -ROAD USE TAX FUND 15D 1,499,000 1,536,158 2.48% 26,900 27,350 1,472,100 1,508,808 36,708 2.49% 24 266-17-7122 TRAFFIC SAFETY-CHARGEBACKS (OUT) 15D 32,000 32,000 0.00% 32,000 32,000 0 0 0 0.00% 25 266-17-7125 TRAFFIC SAFETY- RESTRICTED PROD 17TRF DSCV 15D 100 100 0.00% 100 100 0 0 0 0.00% 26 266-17-7161 TRAFFIC SIGNALS UTIL - ROAD USE TAX 15D 48,000 48,000 0.00%_ 0 0 48,000 48,000 0 0.00 27 266-19-7100 STREET MTCE - ROAD USE TAX FUND 12D 1,900,051 1*965,631 3.45% 550 550 1,899,501 1,965,081 65,580 3.45% 28 266-19-7102 STREET MTCE - CHARGEBACKS (OUT) 12D 158,500 158,500 0.00% 158,500 158,500 0 0 0 0.00% 29 266-19-7200 SNOW REMOVAL 16D 1,817,820 1,855,542 2.08% 0 8,000 1,817,820 1,847,542 29,722 1.64% 30 266-37-7902 ROW FORESTRY & MOWING 2D 900,000 900,000 0.00% 900,000 900,000 0 0 0 0.00% 31 291-29-7750 AIRPORT FEDERAL PROJECTS 29AIP xxxx 19D 758,808 634,528 -16.38% 758,808 634,528 0 0 0 0.00% 32 291-29-7755 AIRPORT PASSENGER FACILITY CHARGES 29AIP xxxx 19D 96,881 96,881 0.00% 96,881 96,881 0 0 0 0.00% 33 291-29-7760 AIRPORT STATE PROJECTS 29PRO Vixx 19D 129,000 177,000 37.21% 129,000 177,000 0 0 0 0.00% 34 35 TOTAL -PUBLIC WORKS 22D 27,333,868 27,649,016 1.15% 27,116,764 27,649,016 0 0 0 0 217,104 0 (217,104) -100.00% 36 37 38 CULTURE & RECREATION 39 204-33-3100 LIBRARY -TAX LEVY 31C 641,712 667,690 4.05% 3,500 14,944 638,212 652,746 14,534 2.28% 40 41 TOTAL -CULTURE & RECREATION 641,712 667,690 4.05% 3,500 14,944 0 0 0 0 638,212 652,746 14,534 2.28% 42 43 44 COMMUNITY & ECONOMIC DEVELOPMENT 45 224-32-5850 COMM. DEVELOPMENT -BLOCK GRANT VARIOUS 41D 1,591,600 1,646,384 3.44% 1,591,600 1,646,384 0 0 0 0.00% 46 22432-5853 COMM. DEVELOPMENT -LEAD PAINT GRANT 41D 1,106,460 1,378918 24.62% 1,106,460 1,378,918 0 0 0 0.00% 47 224-32-5854 COMM. DEVELOPMENT -NEW CONSTRUCTIC 32NC4 xxxx 41D 0 0 0.00% 0 0 0 0 0 0.00% 48 224-32-5870 COMM. DEVELOPMENT -FEDERAL HOME VARIOUS 41D 841,781 1,361,742 61.77% 841,781 1 361 742 0 0 0 0.00% 49 224-32-6800 NEIGHBORHOOD SERVICES BG005 0016 41D 85,000 85,173 0.20% 85,000 85,173 ^iD- 0 0 0 0.00% 51 283-13-5450 HOUSING- RIDGEWAY TOWERS 41D 253,200 262,000 3.48% 253,200 262,000 0 0 0 0.00% 52 283-13-5451 HOUSING- CAPITAL FUNDS (c/o) 13CAP FYxx 41D 60,000 65,000 8.33% 60,000 65,000 0 0 0 0.00% 53 283-13-5452 HOUSING -SECTION 8 41D 5,532,866 5,672,200 2.52% 5,532,866 5,672,200 0 0 0 0.00% 54 283-13-5453 HOUSING- FAMILY SELF SUFFICIENCY 41D 20,000 20,000 0.00% 20,000 20,000 0 0 0 0.00% 55 283-13-5455 HOUSING- DOWNPAYMENT ASSISTANCE 41D 50,000 50,000 0.00% 50,000 50,000 0 0 0 0.00% 56 283-13-5861 HOUSING- LHAP HOUSING POOL 41D 0 0 0.00% 0 0 0 0 0 0.00% 57 • 58 TOTAL -COMMUNITY & ECONOMIC DEV 45D 9,540,907 10,541,417 10.49% 9,540,907 10,541,417 0 0 0 0 0 0 0 0.00% 59 60 K:\USERS\MICHELLEAMBudget FYE211FY21 BUDGET_Max Levy Hearing.xlsx 1 3/5/2020 3:12 PM FY2020 CERTIFIED AND FY2021 MAX LEVY HEARING BUDGET COMPARISON - CITY OF WATERLOO ALL OTHER FUNDS Max Levy Hearing 3/4/20 A B C ID E F G H I J K L M N 0 P Q 1 PROJECT CERT FY2020 BUDGET FY2021 BUDGET % FY2020 BUDGET FY2021 BUDGET FY2020 FY2020 FY2021 FY2021 FY2020 FY2021 $ AMOUNT 2 BUDGET CODE ACTIVITIES -OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 61 GENERAL GOVERNMENT 62 200-09-8980 UNEMPLOYMENT FUND 52D 17,472 17,472 0.00% 0 0 17,472 17,472 0 0.00% 63 64 TOTAL -GENERAL GOVERNMENT 53D 17,472 17,472 0.00% 0 0 0 0 0 0 17,472 17,472 0 0.00% 65 66 67 SPECIAL REVENUES CAPITAL PROJECTS 68 290-07-5300 STORM WATER PUMP STATIONS-COMM 64. 07FLD 5007 55D 0 0 0.00% 0 0 0 0 0 0.00% 69 290-07-5300 STORM WATER PUMP STATIONS-COMM 35. 07FLD D078 55D 0 0 0.00% 0 0 0 0 0 0.00% 70 290-07-5300 STORM WATER PUMP STATIONS-RESIDEN1 07FLD D277 55D 0 0 0.00% 0 0 0 0 0 0.00% 71 290-07-7500 STREETS -ASSEMBLY DRIVE 07STR 55D 0 0 0.00% 0 0 0 0 0 0.00% 72 290-07-7500 STREETS-MIDPORT AREA RISE ROAD 07STR.RM764 55D 550000 5,043,543 817.01% 550,000 5,043,543 0 0 0 0.00% 73 290-07-7500 STREETS -CROSSROADS AREA RISE ROAD 55D 600,000 0 -100.00% 600,000 0 0 0 0 0.00% 74 290-07-7520 US 63 55D 636,600 0 -100.00% 636,600 0 0 0 0 0.00% 75 290-08-6100 BROWNSFIELD OBBKE RT734 08BKE TAP741 55D 200,000 200,000 0.00% 200,000 200,000 0 0 0 0.00% 76 290-17-7161 TRAFFIC-ANSB TO BLACK HAWK 17TRF STP757 55D 152,000 300,000 97.37% 152,000 300,000 0 0 0 0.00% 77 290-17-7161 TRAFFIC -VISION ZERO 17TRF xxxx 55D 5,000 5,000 0.00% 5,000 5,000 0 0 0 0.00% 78 290-17-7161 TRAFFIC IMPR-GREYHOUND & RIDGEWAY 17TRF xxxx 55D 310,000 310,000 0.00% 310,000 310,000 0 0 0 0.00% 79 290-17-7161 TRAFFIC DOWNTOWN CAMERA & FIBER 17TRF xxxx 55D 520,000 550,000 5.77% 520,000 550,000 0 0 0 0.00% 80 290-17-7161 TRAFFIC SIGNAL RETIMING 17TRF STP754 55D 8,000 0 -100.00% 8,000 0 0 0 0 0.00% 81 290-17-7161 TRAFFIC SAFETY CAMPAIGN 17TRF XXXx 55D 8,000 40,000 400.00% 8,000 40,000 0 0 0 0.00% 82 290-17-7161 TRAFFIC IMPR-TRAFFIC CONTROL CENTER 17TRF xxxx 55D 16,000 0 -100.00% 16,000 0 0 0 0 0.00% 83 290-17-7161 TRAFFIC-RIDGEWAY AVE 17TRF xxxx 55D 96,000 700,000 629.17% 96,000 700,000 0 0 0 0.00% 84 290-17-7161 TRAFFIC -PARK AVE BICYCLE SIGNAL PROJ 17TRF xxxx 55D 0 72,000 NEW 0 72,000 0 0 0 0.00% 85 290-17-7161 TRAFFIC IMPR-5TH & 6TH STREETS 17TRFxxxx 55D 0 0 0.00% 0 0 0 0 0 0.00% 86 290-37-4100 GREENBELT LAKE IMPROVEMENTS 371MP.GRNBLT 55D 0 200,000 NEW 0 200,000 0 0 0 0.00% 87 290-37-4105 BOATHOUSE AREA IMPROVEMENTS 55D 0 0 0.00% 0 0 0 0 0 0.00% 88 290-37-4700 RIVERVIEW REC AREA TRAIL EXTENSION 08REC TRL13 55D 0 0 0.00% 0 0 0 0 0 0.00% 89 290-32-5856 NEIGHBORHOOD STABILIZATION 32NS3 xxxx 55D 130,000 130,000 0.00% 130,000 130,000 0 0 0 0.00% 90 207- IA REINVESTMENT DISTRICT 0 300 NEW 195,000 220,300 195,000 200,000 0 (20,000) (20,000) NEW 91 92 TOTAL -SPECIAL REVENUES CAPITAL PROJECTS 57D 3231,600 7550,843 133.66% 3,426,600 7,770,843 0 195,000 0 200,000 0 (20,000) (20,000) NEW 93 94 Subtotal - 200 Series Funds - Less Library Levy 44,382,714 50,467,406 40,084,271 45,961,276 0 195,000 0 200,000 5,131,655 5,358,876 227,221 4.43% 95 96 97 BUSINESS TYPE ACTIVITIES 98 520-14-5200 WATER POLLUTION CONTROL PLANT 601 9,403,241 7,834,707 -16.68% 12,989,065 13,536,940 (3,585,824) (5,702,233) (2,116,409) 59.02% 99 520-14-5202 WATER POLLUTION - CHARGEBACKS 601 692,000 692,000 0.00% 692,000 692,000 0 0 0 0.00% 100 520-14-5280 SEWER REVENUE PLANT SRF 711 - 14,340,000 NEW 0 14,340,000 0 0 0 0.00% 101 520-14-5375 SEWER REVENUE COLLECTION SRF 711 - 11,800,000 NEW 0 11,800,000 0 0 0 0.00% 102 520-14-8980 SEWER REVENUE DEBT SERVICE 701 304,070 1,015,750 234.05% 0 0 304,070 - 1,015,750 711,680 234.05% 103 520-14-9050 SEWER GO BOND DEBT SERVICE 751 0 0 0.00% 0 0 2,561,343 2,427,130 2,561,343 2,427,130 (134,213) -5.24% 104 520-22-5335 FOOTING DRAIN DISCONNECTIONS 601 720,411 138,347 -80.80% 0 0 720,411 138,347 (582,064) -80.80% 105521-14-5310 STORMSEWER MAINTENANCE 601 689,496 715,632 3.79% 0 0 689,496 715,632 26,136 3.79% 106 521-19-5500 STREET CLEANING 601 347,780 358,884 3.19% 0 0 347,780 358,884 11,104 3.19% 107 521-07-7830 ENGINEERING -STORM WATER ADMIN 601 331,346 453,853 36.97% 2,410,000 2,425,000 (2,078,654) (1,971,147) 107,507 -5.17% 108 521-07-5300 STORM WATER CAPITAL PROJECTS 711 1,050,000 1050,000 0.00% 0 153,369 1,050,000 896,631 (153,369) -14.61% 109 520-14-5320 SEWER SYSTEM IMPROVEMENTS 711 8,400,000 2,121,006 -74.75% 8,400,000 - 0 2,121,006 2,121,006 NEW 110 617-14-5320/898 SEWER GO BOND PROJECTS 711 2,300,000 1,000,000 -56.52% 2,300,000 1,000,000 (1,300,000) -56.52% 111 SUBTOTAL- SEWER FUND 24,238,344 41,520,179 71.30% 24,491,065 42,947,309 0 2,561,343 2,427,130 2,308,622 1,000,000 (1,308,622) -56.68% 112 K:\USERSWICHELLE-lAABudget FYE21\FY21 BUDGET_Max Levy Hearing.xlsx 2 3/5/2020 3:12 PM FY2020 CERTIFIED AND FY2021 MAX LEVY HEARING BUDGET COMPARISON - CITY OF WATERLOO ALL OTHER FUNDS Max Levy Hearing 3/4/20 A B C D E F G H 1 J K L M N 0 P Q 1 PROJECT CERT FY2020 BUDGET FY2021 BUDGET % FY2020 BUDGET FY2021 BUDGET FY2020 FY2020 FY2021 FY2021 FY2020 FY2021 $ AMOUNT 2 BUDGET CODE ACTIVITIES -OTHER FUNDS CODE BUDGET CERTIFIED PROPOSED CHANGE CERTIFIED PROPOSED TRANSFERS TRANSFERS TRANSFERS TRANSFERS LEVIED LEVIED CHANGE CHANGE 3 LINE EXPENSE EXPENSE REVENUE REVENUE (IN) OUT (IN) OUT 113 525-15-5400 SANITATION 641 3,660,362 4,741,923 29.55% 3,419,124 5,236,759 241,238 (494,836) (736,074) -305.12% 114 525-15-5402 SANITATION- CHARGEBACKS 641 376,500 376,500 0.00% 451,500 451,500 (75,000) (75,000) 0 0.00% 115525-15-5125 SANITATION- CODE ENFORCEMENT 641 552,731 651,863 17.93% 68,815 81,080 483,916 570,783 86,867 17.95% 116525-17-2400 SANITATION -ANIMAL CONTROL 641 290,486 362,689 24.86% 108,700 111,700 181,786 250,989 69,203 38.07% 117 SUBTOTAL -SANITATION FUND 4,880,079 6,132,975 25.67% 4,048,139 5,881,039 0 831,940 251,936 (580,004) -69.72% 118 119 TOTAL -BUSINESS TYPE ACTIVITIES 731 29,118,423 47,653,154 63.65% 28,539,204 48,828,348 0 2,561,343 2,427,130 3,140,562 1,251,936 (1,888,626) -60.14% 120 121 122 DEBT SERVICE 123 100 GEN. OBLIGATION BOND DEBT SERVICE 54F 13,731,607 13,157,973 -4.18% 533,070 497,367 (5,976,304) (5,444,561) 7,222,233 7,216,045 (6,188) -0.09% 124 101 TIF ECONOMIC DEV & REBATES 43E 2,381,849 2,610,938 9.62% 8,735,719 9,398,510 (127,000) 7,482,795 (127,000) 6,914,572 1,001925 0 (1,001,925) -100.00% 125 101 TAX INCREMENT DEBT SERVICE 54E 0 0 0.00% 0 0 0 0 0.00% 126 127 TOTAL -DEBT SERVICE 16,113,456 15,768,911 -2.14% 9,268,789 9,895,877 (6,103,304) 7,482795 (5,571,561) 6,914,572 8,224,158 7,216,045 (1,008,113) -12.26% 128 129 130 CAPITAL PROJECTS 131 419/420-8980 G.O. BOND PROCEEDS 55G 10,000,000 11,000,000 10.00% 10,000,000 11,000,000 0 0 0 0.00% 132 416/417/418/419 G.O. BOND/CAPITAL PROJECTS 55G 6,000,000 5,000,000 -16.67% 0 6,000,000 5,000,000 (1,000,000) -16.67% 133 417/418/419 G.O. BOND/CAPITAL PROJECTS—TIF 56G 0 0 0.00% 0 0 0 0 0.00% 134 417 G.O. BOND/CAPITAL PROJECTS—TECHWORKS 1RD 55G 0 0 0.00% 0 0 0 0 0.00% 136 0• •0 CAP IMPR - BRIDGES 155G 750,000 750,000 0.00% 750,000 750,000 0 0 0 0.00% 137 0 265,000 265,000 0.00% 265,000 265,000 0 0 0 0.00% 138 • . ' . • CAP IMPR - RIVERFRONT IMPR 55g 0 50,000 NEW 0 50,000 0 0 0 0.00% 139 4• • 55G 15000 179,489 1096.59% 15,000 179,489 0 0 0 0.00% 140 • DIAMOND •' •VEMENT:137SPT FLDLGH 55G 0 0 0.00% 0 0 0 0 0 0.00% 141 •5 CAP IMPR - LINCOLN PARK PROJECT 37LINC GAME 55G 500,000 0 500,000 0 -100.00% 0 0 0 0.00% 142 42637-4207 BOAT H• 559 0 0 0.00% 0 0 0 0 0 0.00 % 143 426-08-6205 PROJ 56G 1,200,000 15,000 -98.75% 0 0 (1,200,000) (15,000) 0 0 0 0.00% 144 426-08-6210 CAP IMPR- RATH TIF PROJECTS 56G 150,000 300,000 100.00% 0 0 (150,000) (300,000) 0 0 0 0.00% 145 426-08-8220 CAP IMPR - NE SITE TIF PROJECTS 56G 100,000 0 -100.00% 0 0 (100,000) 0 0 0 0 0.00% 146 426-08-6250 CAP IMPR - MARTIN RD TIF PROJECTS 56G 275,000 196,000 0 0 -28.73% (275,000) (196,000) 0 0 0 0.00% 147426-08-6260 CAP IMPR - MIDPORTTIF PROJECTS 56G 1,305,000 2,048,033 56.94% 0 0 (1,305,000) (2,048,033) 0 0 0 0.00% 148426-08-6270 CAP IMPR - DOWNTOWN TIF PROJECTS 56G 0 40,000 NEW 0 0 (40,000) 0 0 0 0.00% 149 426-08-6280 CAP IMPR - LOGAN SALE OF PROPERTY 56G 1,000,000 1,250,000 25.00% 0 0 (1,000,000) (1,250,000) 0 0 0 0.00% 150 426-08-6280 13000 56G 0 0 0.00% 0 0 - - 0 0 0 0.00% 151 152 TOTAL -CAPITAL PROJECTS 57G 21560,000 21,093,522 -2.16% 11,530,000 12,244,489 (4,030,000) 0 (3,849,033) 0 6,000,000 5,000,000 (1,000,000) -16.67% 153 154 155 TOTAL CITY BUDGET -OTHER FUNDS 111,816,305 135,650,683 21.32% 89,425,764 116,944,934 (1011331304) 10,239,138 (9,420,594) 9,541,702 22,496,375 18,826,857 (3,669,518) -16.31% K:\USERS\MICHELLE-WtBudget FYE211FY21 BUDGET_Max Levy Hearing.xisx 3 3/5/2020 3:12 PM Dec-18 Form 635.1 Department of Management The City of: Adoption of Budget and Certification of City Taxes FISCAL YEAR BEGINNING JULY 1, 2020 - ENDING JUNE 30, 2021 WATERLOO County Name: BLACK HAWK 07 054 Resolution No.: Date Budget Adopted: The below -signed certifies that the City Council, on the date stated above, lawfully approved the named resolution adopting a budget for next fiscal year, as summarized on this and the supporting pages. Attached is Long Term Debt Schedule Form 703 which lists any and all of the debt service obligations of the City. County Auditor Date Stamp Code Sec. 384.1 (384) 12(8) 12(10) 12(11) 12(12) 12(13) 12(14) 12(15) 12(17) 12(21) (384) 12(1) 12(2) 12(3) 12(4) 12(5) 12(6) 12(9) 12(16) 12(18) 12(20) 28E.22 0.67500 0.95000 Amt Nec 0.13500 0.06750 0.27000 0.06750 Amt Nec Amt Nec Dollar Limit 8.10000 Purpose • Regular General levy Regular DEBT SERVICE Ag Land Non -Voted Other Permissible Levies on Contract for use of Bridge Opr & Maint publicly owned Transit Rent, Ins. Maint of Civic Center Opr & Maint of City owned Civic Center Planning a Sanitary Disposal Project Aviation Authority (under sec.330A.15) Levee Impr. fund in special charter city Liability, property & self insurance costs Support of a Local Emerg.Mgmt.Comm. 2a 3a 4a 5 319-293-4323 Telephone Number (Dale) xx/xxhrx Signature January 1, 2019 Property Valuations With Gas & Electric Without Gas & Electric 2,333,982,546 2b 2,618,387,984 3b 14,891,151 2,255,590,437 2,539,995,874 TAXES LEVIED (A) Request with Utility Replacement 6 7 8 9 10 11 13 14 462 18 905,259 • 1,534, 588 1,431,858 96,012• (B) Property Taxes Levied 18,270,283 0 43 45 46 47 48 49 0 il 51 1,383,760 52 92,795 465 Last Official Census 68,406 (C) Rate 8.10000 0 0 0 0 0.61348 0.04114 o e Levie s Voted Other Permissible 0.13500 InstrumentalNocal Music Groups 0.81000 Memorial Building 0.13500 Symphony Orchestra 0.27000 Cultural & Scientific Facilities As Voted County Bridge 1.35000 Missi or Missouri River Bridge Const. 0.03375 Aid to a Transit Company 0.20500 Maintain Institution received by gift/devise 1.0000o City Emergency Medical District 0.27000 Support Public Library 1.50000 Unified Law Enforcement Total General Fund Regular Levies (5 thru 24) 384.1 3.00375 Ag Land Total General Fund Tax Levies 384.8 0.27000 384.6 Amt Nec Amt Nec Amt Nec Rules (25 + 26) Special Revenue Levies P Emergency (if general fund at levy limit) Police & Fire Retirement FICA & IPERS (if general fund at levy limit) Other Employee Benefits Total Employee Benefit Levies (29,30,31) Sub Total Special Revenue Levies (28+32) 386 As Req SSMID 1 SSMID 2 SSMID 3 SSMID 4 SSMID 5 SSMID 6 SSMID 7 SSMID 8 (A) (A) (A) (A) (A) (A) (A) (A) With Gas & Elec Valuation (B) (B) (B) (B) (B) (5) (B) (B) Total Special Revenue Levies Without Gas & Elec • 15 16 17 18 19 20 21 22 463 23 24 630,175 630,175 25 23,228,067 26 44, 729 27 23,272,796 28 29 30 31 32 33 34 35 36 37 555 556 1177 1185 • 630,175 :•I 4,708,658 2,168, 924 6,890,459 13,768,041 14,398,216 • 39 14,398,216 609.0 0 €• •• 0 Wiwi 0 0 609,00911 0€ 22,447,907 53 54 55 56 57 58 59 60 466 61 62 609,009 64 2,096,075 6,659,022 13,305,593 65 13,914,602,:,. .. ................................................. 0 66 67 68 69 565 V I`i 566 0 EE`?" #!## 0? 0 0 0.27000 0 0 0 0 0 0.27000 0 3.00375 Do Not Add 0.27000 2.01743 0.92928 2.95223 5.89894 0 0 0 0 0 0 0 384.4 Amt Nec Debt Service Levy 76.10(6) 384.7 0.67500 Capital Projects (Capital Improve Reserve) 40 7,216,045 41 40 41 Total Property Taxes (27+39+40+41) 42 44,887,057 42 7, 000, 000. 70 0 € 71 43,407,238 2.75591 0 72 18.87697 COUNTY AUDITOR - I certify the budget is in compliance with ALL the following: Budgets that DO NOT meet ALL the criteria below are not statutorily compliant & must be returned to the city for correction. 1) The prescribed Notice of Public Hearing Budget Estimate (Form 631.1) was lawfully published, or posted if applicable, filed proof was evidenced. 2) Budget hearing notices were published or posted not less than 10 days, nor more than 20 days, prior to the budget hearing. 3) Adopted property taxes do not exceed published or posted amounts. 4) Adopted expenditures do not exceed published or posted amounts in each of the nine program areas, or in total. 5) Number of the resolution adopting the budget has been included at the top of this form. 6) The budget file uploaded to the SUBMIT Area matched the paper copy certified by the city to this office. 7) The long term debt schedule (Form 703) shows sufficient payment amounts to pay the G.O. debt certified by the city to this office. ( County Auditor) Form 631 A P1 GOVERNMENT ACTIVITIES (A) (B) PU BLIC SAFETY Police Department/Crime Prevention 1 Jail 2 Emergency Management 3 g Y 9 Flood Cont rol 4 Fire Department Ambulance Building Inspections ections Miscel laneous us Protective Services Anim al Control 5 6 7 8 9 Other Publ ic Safet y 10 TOTAL (lines 1 - 10) 11 PUBLIC WOR KS Roads, Bridges, & Sidewalks 12 Parking - Meter and Off -Street 13 Street Lighting 14 Traffic Control and Safety 15 Snow Removal 16 Highway Engineering g y 17 Street Cleaning I anin g 18 Airport (if not Enterprise)19 Garba ge t En terprise) no 20 Other Public Works 21 TOTAL (lines ' 12 -21) 22 HEA LTH & SOCIAL SERVICES Welfare Assis tance 23 CityHosp ital 24 Payments nts to Private Hospitals tals 25 Health Regulatio n an d Inspection 26 Water, Air, and Control ntro I 27 Community Mental Health nt I 28 Other Health and Social Services 29 TOTAL (lines 23 - 29) 30 CU LTURE LT URE & C RE REATI ON Library Services 31 Museum, Band and Theater 32 Parks 33 Recreation 34 Cemetery 35 Community Center, Zoo, & Marina 36 Other Culture u ture an d Recreation ti n 37 TOTAL (lines 31 -37) 38 CITY OF WATERLOO EXPENDITURES SCHEDULE PAGE 1 Fiscal Year Ending 2021 Department of Management Fiscal Years GENERAL (C) REVENUES SPECIAL (D) SPECIAL REVENUES TIF (E) SERVICE DEBT (F) PROJECTS CAPITAL (G) PERMANENT PROPRIETARI� (I) BUDGET 2021 (J) RE -ESTIMATED 2020 (K) ACTUAL 2019 (L) 1 .................• 6663375• ............................. 25 15 00 5 ....•..• :;:• .....(H).. .......................... • • • 1 91783 , 80 17517 878 1 9 448 41 0 • • • • 0 0 0 9 60 12• • • 96,012 94 67 5 1 034 , 7 3 • • • • • 0 0 0 106 7 3 506 1,816,62 1• ..• ••• 12,490,127 11,313,126 9,356,806 2 401 88 4 377 0 32 • • • 2,778,916 2618639 2,013,120 1 3 4 0 95 4 • • 1 340 954 12 03 , 684 107 861 7 '' 0 0 0 0 0 .:.. • • • 0 0 0 31 7 15731 4 70 8 , 658 • 35 8 84 389 32748002 31,999,480 215 ..... 000 • .• .......................• 22 5 7 0 8 ... 0 7 22,965,807 807 22, 6 259 21, 304,511 511 • 546,460 546,460 551,080 0 603,497 03 4 518 000 518,000 518,000 616,190 , 0 1 616 2 58 1,616,258 1,579,100 14 36 960 1 85 5 542 • 1 855 542 1,817,820 1 688 391 ''` :,, • 0 0 • 0 0 1 209 8 14 908 409 2 118 23 2 060 096 251 5 086 ..,.:....• • • • 0 0 0 4,714,964 • • 4,714,964 4,329,393 393 4,150,916 916 66862 38 7 2 649 016 0 • 34 335 254 33,504,748 32 251 551 .;..... ,; • 0 0 :; `;• • • 0 0 0 • • • 0 0 0 °:;°: • • • 0 0 • 0 0 0 • • • • • 0 0 4 18 800 • • • • 418,800 312 78 3 274,475 4• 188 , 00 0 0 • • 41 8 800 312 , 7 83 2 74 475 2..8....................................... 30 3 • 63 • • • • 2,830,368 26 44 , 581 447 781 8 • 2 090 855 • • 2 090 855 18718 13 1 074 426 3 124 49 4 • • 3,124,494 3,017,009 2,865,111 ,865 , 1 32 80 197 • • 3,280,197 3, 246,797 , 797 3,060,731 50 0 00 • 50,000• 50,000 , 0 50,000 8 18 771 • 818 , 771 783 , 4 72 810 026 • • • • • 0 0 0 • • 12 19 4,680 680 0 1 2 194, 68n 11,61 3,672 672 10,3 08,075 075 Form 631 A P2 GOVERN NT „ C u IVITIES CONT (A) COMMUNITY at ECONOMIC DEVELOPMENT Community Beautification Economic Development Housing and Urban Renewal Planning & Zoning Other Com & Econ Development TIF Rebates TOTAL (lines 39 - 44) GENERAL GOVERNMENT Mayor, Council, & City Manager Clerk, Treasurer, & Finance Adm. Elections Legal Services & City Attorney City Hall & Genera Tort Liability (B) 39 40 41 42 43 44 45 46 47 48 49 I Buildings 50 51 Other General Government 52 TOTAL (lines 46 - 52) DEBT SERVICE Gov Capital Projects TIF Capital Projects TOTAL CAPITAL PROJECTS 53 54 55 56 57 TOTAL Government Activities Expenditures (lines 11+22+30+38+45+53+54+57) 58 BUSINE SS S TYPE ACTIVITIES A ITIE Proprietary: to En terprise se p Budgeted ri B & ud eted ISF Water Utility 59 Sewer Utility 60 Electric Utility 61 Gas Utility 62 Airport 63 Landfill/Garbage 64 Transit 65 Cable TV, Internet & Telephone 66 Housing Authority 67 Storm Water Utility 68 Other Business Type (city hosp., parking,etc.) 69 Enterprise DEBT SERVICE 70 Enterprise CAPITAL PROJECTS 71 Enterprise TIF CAPITAL PROJECTS 72 TOTAL Business Type Expenditures (lines 59 - 73) 73 TOTAL ALL EXPENDITURES (lines 58+74) Regular Transfers Out Internal TIF Loan / Repayment Transfers Out Total ALL Transfers Out 74 75 76 77 Total Expenditures 4; Fund Transfers Out (lines75+78) 78 Ending Fund Balance June 30 79 • • • • • • • : • • • • • • • • • • • • • MY OF WATER. 0 701,663 2,960,280 435,652 691,951 5,365,170 10,843,195 66,239,135 :::: • . i=XPEND0 T k 1,S SCHFDLLE PAG fiscall Year Finding 2,610,938 E `r 2C2 l 17,244,489 3,849,033 21,093,522 :: :;: 21, 093, 522 • • • • • : 4. • .• • ••• es i i : •• a• se : al, 4. .. •• : .. 4. ... .6 •:, .. ..• ; :I • ; el I •• .4 se •• ea : 6. e• ; •• :,: :;: ... • • ... . .•.• ... - • :: .• :,: :•:,: • • :• ••. :;::;: . •. •.••••• •••••••• •• •: •64::;:•:0.::• ••••• ::• �u 239,135 127,000 127,000 66,363, 3 5 16,034,524i 50,467,406 10,387,780 10, 387,780i 60,85 1l 86 ' 29,103,722', 2,610,938 ::. • :..•.. •.•.. 6,914,572 6,914,572 9 10 2,646,118 13,157,973 1,353,631 21,093,522 21.0 14,659,199 r� • r :;:• • :;: .. •. •.• • :::•••: :.•. • •: •: :;:•: :•: ::: :: ••• :::::: • .:•• .• ;: 30,311,006 47.653.154 47,653,154 2,427,130 2,427,130 Department of Management Ascadl Years BUDGET 2021 (J) 0 1,196,108 10,603,85T 701,663 5,571,218 0 18. 072, 846 988,269 1,430,295 0 435,652 691,951 1,931,858 5,382,642 10,860,667 13,157,973 24, 795,332 RE -ESTIMATED 2020 (K) 0 1,025,8341 9,584,957 730,554 2,8051787 0 14,147,132 8'17,592 1,355,362 60,000 312,690 581,761 1,784,685 4,937,243 9,849,333 20,761,600' 3,849,033 4,030,0001 28,644,365 24,791,600 ACTUAL 2019 (L) 0 1,802,602 7,577,786 627,661 388,916 1,848,229 12,245,194 ••.788,912 1 4,628,543 7,194,578 3,869,235 11,063,813 153,568,974 50,030,284, 15,272,047 A continuing appropriation is the unexpended budgeted amount from a prior year's capital project. The entry is made on the Con Approps page that must accompany the budget forms if used. SEE INSTRUCTIONS FOR USE. 0 10,193,423 0 0 6,132,975 0 0 0 0 0 1,015,750 30,311,006 0 47,653,154 l 201,222,128 12,814,910 7,041,572 19, 856,482 078,610 79,069,241 140,698,8771 .: :;. :; :;. • :: • :;: 0 12,184,274 •:• 123,706,356 7,331,824 0 0 0 0 0 4,880,079 0 0 3,764,567 0 0 0 0 0 0 1,099,172 0 304,070' 11,750,000', 0 0 193,738 4,367,877 0 29,118,423 1169,817,300' 10,053,455, 7,609,795 17,663,250 187,480, 550 16,757,178. 140,463,534'1 9,523,5691 7,101, 064 16 624,633 157,088,-167 .. ••• •• •- • Form 631 B CITY OF WATERLOO REVENUES DETAIL Fiscal Year Endin 2021 Department of Management The last two columns will fill in once the Re -Est forms are completed Fiscal Years (A) (B) GENERAL (C) REVENUES SPECIAL (D) REVENUES SPECIAL TIF (E) SERVICE DEBT (F) PROJECTS CAPITAL (G) PERMANENT (H) PROPRIETARY (I) BUDGET 2021 (J) RE -ESTIMATED 2020 (K) ACTUAL 2019 (L) REV T a xes ENUES HUES Levied & 0 nPo OTH Pr operty p ER rt FINANCING N A N ING SOURCES 1 22.,4g.....6........ 7 0 • ....•....................... 43,407,238 40,639,192 38,980,334 Less. Uncollected P ro e �Y Taxes- LevyYear 2 0 0 0 Net Cur rent nt Property p rt Y3 Tax es(line 1 minus line 2) 22 4 92 ,2 636 13 914 60 2 • 7,000,000 0 , 43 407 3 8 40,639,192 0 1 92 38,980,334 Delinquent Prop ertYaxe Taxes 4 0 0 21,994 TIF Reven ues :. 9 388 510 €€€€''€: ::` ' € € €€ €€ '`' 9388510 8725719 8948992� , Other Utility it tY216 City Tax T Y Taxes Replacement E xc'se i Taxes 6 . . 78 01 , 6 0 483 ,• 614 j 045 0 1 �479� 81 9 1,425,983 � 114271161. ..� Utility it ty franchise c h t tax (Iowa Co de Chapter P• 64 2 3 . 7 4,285,000 4 285 000 4,315,000 4 35 3 045 Pari m utue Iwa g er t ax 8 0 0 0 Gam ing 9 wag g er er tax 9 1,256,250 , 250 1 2620 5 5 1,256,250 1 251 1 68 Mobi le le Home m Taxes 10 34,700 7 0 12,000 , 46,700 46,700 727 9 5 H oe t l/Mo e!. t T a xes 11 1,419,191 1,419,191 1 20 8 6 43 1,344,860 Other Loc alOption Taxes 12 9,720,000 72 000 9 7 20 000 9,600,000 1 0 3 51 582 Subtotal - Other th r CityTaxes x i lines 6 thru 9 2 �2 1 3 77 ,18,206,960 7 5 301 10,203,614 2 80 , 45 0: 1785257618,8001615 Lice i nses &Per Permits s 1, 389,060 060 ,50 26 750 .:...:.:.:.:...:... 1 8 7 75 1,434,585 14291 1 4 78 661 Use of Money & Property 15 1,375,7284 326,300 10,000 30,000 122,500 1,864,528 1,632,628 3,444,579 Inte Federal r gv o e rnmental: Grants t & Rei m bu s re m e nts 16 426,113 •1 2 , 988 9 4 5 1341 5 08 5 12 1 2088 2 10,523,049 Rod a Use Tax es 17 ..• . ........... . .........8 88 10 88 2 • •• r _ 8 810 8 82 8,400,000 8 37 07 9 Other State Grants nt &Reimbursements 18 971,573 515,692 0 2401398 0 :...:::......:::......::::::::::.:..:...:. ... .................... . 0 1,727,663 2,100,778 7,694,900 384,837 6,748,543 273,624 7,407,004 3,231,407 1,5801711 Local Grants &Reimbursements 19 Subtotal - Intergovernmental g ( lines � 6 thru � 9 ) 20 1 1,782,523 7 29,064,062 0 240,398 0 €'���'�''���� ............................ 273,624 31,360,607 25,853,013 281635,739 Ch Water• arges 9• es Utilit for Fee y s Service:sap 21 ..•.............................................................................. :.:.:.:....:..:•.: •...............,.... ..•...................:.....................................•.......•......................:.......,...:...:............ .:.......:.....................:......:.:.....,... • ,....-... •.•... •- ...........:... +..-........................ .:.:.:.......:..:......................................................................................................................................•..............:.............................. -....................-:.................. ... ........... ... . ... ..• .... .. ........ ............. . 0 ...... ............ .... ...... 0 ..........• ............. 0 Sewer Utilit Y• 22 • 16,490,665 16,490,665 16,015,665 13,185,925 Electric Utility 23 Gas Utility 24 •0 0 0 Parking 25 527,500 527,500 533,500 513,878 Airport 26 299 30•p 7 96,881 '` 396,188 336,288 355,781 Landfill/Garbage 27 • 5,572,415 _ 5,572,415 3,739,515 3,783,610 Hospital 28 :.:.:.:.:.:::.:.:..:.:.:.:.:•�•:.::• Transit 29•• :.:i 0 0 0 Cable TV, Internet & Telephone 30 0 0 0 Housing Authority 31 • 0 0 0 Storm Water Utility 32 0 0 1,748,773 Other Fees & Charges 910,050,168 for Service 33 9,878,093 172 075 ' • 7,470,235 7,240;390 Subtotal - Charges for Service (lines 21 thru 33) 34 10,704,900 268,956 €' ' € 0 0 0 22,063,080 33,036,936 28,095,203 26,828,357 Special Assessments 35 19 8,000 000 52,000 250,000 210,000 253,328 5 3 2 8 Miscell aneous 36 6,413,501 70,900 €€€������''�' 214,969 1,244,489 7,943,859 6,009,536 7,825,802 Other Financing Regular Operating Sources: r Tr ansfers s In 37 10,187,780• 2,627,130 12,814,910 10,053,455 6,523)569- Internal TIF Loan Transfers In 38 248,108 127,000 2,817,431 3,849,033 7,041,572 7,609,795 7,101,064 Subtotal ALL Operating Transfers In 39 10,435,888 0 127,000 5,444,561 3,8491033 0 0 19,856,482 17,663,250 16,624,633 Proceeds of Debt (Excluding T1F Internal Borrowing) 40 , i ` ' J '°° '' • _ ., • . 26,140,000 37,140,000 18,400,000 11,041,211 Proceeds of Capital Asset Sales . 41 55,000 5,000 60,000 260,000 125,276 Subtotal -Other Financing Sources (lines 36 thru 40) 42 101490,888 0 127,000 5,444,561 14,849,033 0 26,145,000 57,056,482 36,323,250 27,791,120 Total lines (41) to Revenues n 3 4............ 5,131 exceptfor 4 1 or 5 2 beginning 9 0343 5 9 36 f and & balance• 43 62,622,537 ..........................................................................................................•.......... 53,875,184 9,525,510 13,157,973 16,093,522 ............................................. 0 48,674,979 ............ .......................•................ 203,949,705 166,770,267 .................................. 163,009,521 ......... Beginning Fund Balance July 1 44 19,778,122 36,083,724 2,646,118 1,353,631 19,659,199 0 16,677,352 96,198,146 116,908,429 110,987,075 TOTAL REVENUES & BEGIN BALANCE (lines42+43) 45 82,400,659 89,958,908 12,171,628 14,511,604 35,752,721 0 65,352,331 300,147,851 283,678,696 273,996,596 Form 635.2A CITY OF WATERLOO ADOPTED BUDGET SUMMARY YEAR ENDED JUNE 30, 2021 Department of Management Fiscal Years TIF SPECIAL SPECIAL DEBT CAPITAL BUDGET RE -ESTIMATED ACTUAL PROPRIETARY 2021 2020 2019 GENERAL REVENUES REVENUES SERVICE PROJECTS PERMANENT (H) (I) (J) (K) (L) (A) (B) (C) D)• (�• (F) (G} Revenues Taxes x Levied &Other on Property Financing p• rtY Sources 1 22 492 .. 63 . 6 .. 13 9 1 ... 4602 . .. 7 000 .. . 000 .. . ... 0 43 407 2 8 3 40 6 3 9 19 2 38 980 33 4 Less. U Ilecte d Property p Y Tax Taxes e s -Levy Lev Year Y••••••••• 2 0 0 0 0 0, 0 0 Net Cur rent Property p rt Y Taxes 3 22 492 6 36 1 3 9 14 602 iiii iiii'i • 7 000 000 43• ,407,238 40,639,192 38,980,334 Delinquent q n t Property P p ert Y Taxes 4 0 0 0 0 0 0 2 1 994 TIF Revenues v Hues 5 ••• 9 38 851 0 9, 388,510 510 8,725,719 8,948,992 Other City Taxes 6•Y 301 ............. 10 203 614 . :::::::::::::::::::::::: .................•........... 228 045 0 ..............:.............:.........:...........:.......:....:....°.:.:.........::.:.::.:.:.:.:.:.::.:: ........................ 18,206 ,960 17,852,576 18,800,615, Lice nses s & Permits P mits 7 1 89 3 , 060 2 6 750 1 87 7 5 1 43 4 585 1,429 4 150 1,478,661 Use of Money and Property 8 1,375,728 326,300 10,000 _ 30,000 0 0 122,500 1,864,528 1,632,628 3,444,579 Intergovernmental 9 1,782,523 29,064,062 0 240 398 O (i;;iiiiiiiiiii`(iii(iii:ii(ii i i i ii i 273,624 31,360,607 25,853,013 28,635,739 Charges for Fees &Service 10 10,704 900 268 956 .;.,.,.;.;.:• .:.:..:.:.:...:.:.:.:.:.:..:..:.:.:.:.... •• ' 0 0 0 22,063,080 33,036,936 28,095,203 26,828,357 Special p i IAses Assessments s•::;t.: 11 1 98 000 0 .:......:::::::::::::::.:.:::.. . 0 0 52,000 250,000 0 210,000 2 53 32 8 Miscellaneous 12 6,413,501 70 900 ,.. . 214,969 1,244 ,489 0 0 7,943,859 6,009,536 7,825,802 Sub -Total Revenues 13 52,131,649 53,875,184 9,398,510 7,713,412 1,244,489 0 22,529,979 146,893,223; 130,447,017 135,218,401 Ot TotalTransfers her Fi n a ncing In Sc urces: 14 ......................................................................................:......................:..:............................................................................:........ 10,435,888 • • • • • • • 0 127,000 5,444.,561 • 3,849,033 .............................................:.....:......:.......: ... .. 0 .......................................... 0 19,856,482 ........................................................................ 17,663,250 16,62.4,633 Proceeds of Debt 15 0 0 0 0 11,000, 000 iii i i ...... i 'i i i ' : 26,140,000 37,140,000 18,400,000 11,041,211 Proceeds of Capital Asset Sales 16 55,000 0 0 0 0 0 5,000 60,000 260,000 125,276 Total Revenues and Other Sources 17 62,622,537 53,875,184 9,525,510 13,157,973 16•,093,522 0 48,674,979 203,949,705' 166,770,267 163,009,521 Expenditures Public Safety ures & O Other t Fina Financing in Uses 18 31 1757 3 1 470865 8 0 0 35 884 389 32 748 002 31 999 480 Public Wor ks k 19 6,686,238 238 27,649,016 0 0 34,335,254 33,504 748 4 32,251,551 H ea Ith ari d Social Services 20 418,800 , 00 0 0 0 418,800 31 2 783 27 4 475 Cultu re re and Recr eation 21 121946 80 ,•• 0 0 0 12,194,680 11,613,672 10,308,075 Co mmunity tY an d EconomicDevelopment 22 49 20 491 ,18,072,846 10,541,417 26 1 093 8 0 8 072 8 1 4 147 132 12,245,194 2 245 94 Ge n• er al Gove rnme nt 23 108 4 39 1 5 17 7 4 2 0 0 1 0 860 667 9 849 3 33 1 0935 225 Debt Service 24 0 0 0 13,157,973iiiiiiiiiiiiiiiiiiiii .• . 13,157,973 13,731,607 14,628,543 CapitalP � s 2 5 0 7 550 84 3 ........:... 1 21,093,5224 093 ......... 522 0 '• .'`��'�� .:.:...:.:.:.:.::::.:.:.:.:.::.:.:.•:.:.::•::::::.:. •••.• • 2 8,644,365 24,791,600 11,063,813 Total Government Activities Expenditures p 26 66 239 135 50 467 406 2,610,938 13,157,973 21,093,522 0• • i'''•i'' i ii• i'iiiii 153,568,974 140 - - -- 698 877 123,706,356 Business n Ty T pe e Pr o P rietr Y En nter terprise p ise r & ISF 27 47 653 154 47,653,154 29 1 18 423 1 6 757 1 78 Total Gov & Bus Type Expenditures 28 66,239,1'35' 50,467,406 2,610,938 13,157,973 21,09.3,522 0 47,653,154 201,222,128 169,817,300 140,463,534 Total Transfers Out 29 127,000 10,387,780 6,914,572 0 0 0 2,427,130 19,856,482 17-,663,250 16,624,6'33 Total ALL Expenditures/Fund Transfers Out 30 66,366,135 60,855,186 9,525,510 13,157,973 21,093,522 0 50,080,284 221,078,610, 187,480,550 157,088,167 Excess (Under) ( x ss r ) Revenues x Expenditures/Transfers p enditures n & Oh Other lTransf S Sources e r s Out Ov er e r 31 32 �........................... 3,743,598 _..........•................•.....•...•...•..... 6,980,002 0 .......•....•...•..•....... 0 -5,000,000 •: :::.........................• .. 0 ...................•.............•.•.•................................................................................ -1,405,305 -17,128,905 -20,710,283 5,921,354 — -- :i:::::;:;✓::;:;: Beginning Fund Balance July 1 33 19,778,122 36,083,724 2,646,118 1,353,631 , 19,659,199 0 16,677,352 96,198,146 116,908,429 110,987,075 Ending Fund Balance June 30 34 16,034,524 29,103,722 2,646,118 1,353,631 14,659,199 0 15,272,047 79,069,241 96,198,146 116,908,4290 Form 631.1 Department of Management City of NO F I G 1: or PUBLIC H EA R I N G BUDGET ESTIMATE FISCAL YEAR BEGINNING JULY 1, 2020 - ENDING JUNE 30, 2021 WATERLOO , Iowa The City Council will conduct a public hearing on the proposed Budget at City Hall Council Chambers on 3/19/2020 at 5:30 pm (Date) xx/xx/xx (hour) The Budget Estimate Summary of proposed receipts and expenditures is shown below Copies of the the detailed proposed Budget may be obtained or viewed at the offices of the Mayor, City Clerk, and at the Library. The estimated Total tax levy rate per $1000 valuation on regular property $ 18.87697 The estimated tax levy rate per $1000 valuation on Agricultural land is .. $ 3.00375 At the public hearing, any resident or taxpayer may present objections to, or arguments in favor of, any part of the proposed budget. The city budget is subject to protest. More information on protest can be found at https://dom.lowa.gov/local-gov-appeals. (319) 291-4323 phone number Michelle Weidner, Chief Financial Officer City Clerk/Finance Officer's NAME Budget 2021 FY Re -estimated 2020 FY Actual 2019 FY (a) (b) (c) Revenues &Other Financing Sources Taxes Levied on Property . 1 . ................. 43,407,238 .......... 40,639,192 .... ...................... 38,980,334 Less. Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 43,407,238 40,639,192 38,980,334 Delinquent Property Taxes 4 0 0 21,994 TI F Revenues 5 9,388,510 8,725,719 8, 948,992 Other City Taxes 6 18, 206, 960 17, 852, 576 18, 800,615 Licenses & Permits 7 1,434,585 1,429,150 1,478,661 Use of Money and Property 8 1,864,528 1,632,628 3,444,579 Intergovernmental 9 31, 360, 607 25, 853, 013 28, 635,739 Charges for Fees & Service 10 33, 036, 936 28, 095, 203 26, 828,357 Special Assessments 11 250,000 210,000 253,328 Miscellaneous 12 7,943,859 6,009,536 7, 825,802 Other Financing Sources 13 37,200,000 18,660,000 11,166,487 Transfers In 14 19,856,482 17,663,250 16,624,633 Total Revenues and Other Sources 15 203,949,705 166,770,267 163,009,521 ............................................... ............................................... ................... ........ ........ Expenditures ...... ...... & Other .............................. .............................. ........................... Financing Uses ... ... .. ... ... .. ................ .............. ................ .............. ................ ................ .............. .. .... .... .. .. .. .. ........ ................... ........ ................... ...... . ...... . ................... .... .... .... .... . . . . . . . . .......... ................. .......... ................. .......... .......... ................. . . . . ..... ..... ..... ..... Public Safety 16 35, 884, 389 32, 748, 002 31, 999,480 - Public Works 17 34, 335, 254 33, 504, 748 32, 251, 551 Health and Social Services 18 418,800 312,783 274,475 Culture and Recreation 19 12,194,680 11,613,672 10,308,075 Community and Economic Development 20 18,072,846 14,147,132 12,245,194 General Government 21 10, 860, 667 9,849,333 10, 935, 225 Debt Service 22 13,157,973 13,731,607 14,628,543 Capital Projects 23 28, 644, 365 24, 791, 600 11, 063, 813 Total Government Activities Expenditures 24 153,568,974 140,698,877 123,706,356 Business Type / Enterprises 25 47,653,154 29,118,423 16,757,178 Total ALL Expenditures 26 201,222,128 169,817,300 140,463,534 Transfers Out 27 19, 856,482 17, 663, 250 16, 624, 633 Total ALL Expenditures/Transfers Out 28 221,078 610 187,480,550 157,088 167 Excess (Under) Revenues Expenditures/Transfers &Other Sources Out Over 29 -17,128,905 -20,710,283 5,921,354 Beginning Fund Balance July 1 30 96,198,146 116,908,429 110,987,075 Ending Fund Balance June 30 31 79,069,241 96,198,146 116,908,429 2020/2021 TAXABLE VALUATION CHANGE, TOP 15 CITIES DEPARTMENT OF MANAGEMENT - LOCAL BUDGET DIVISION CHANGE IN TAXABLE VALUE - USED FOR REGULAR PROPERTY TAX CALCULATION TAXABLE VALUE REGULAR W G&E RANKING 1 2 3 4 5 6 7 8 9 10 11 12 13 14 CITY SIOUX CITY IOWA CITY ANKENY DES MOINES URBANDALE MARION DAVENPORT WEST DES MOINES BETTENDORF CEDAR RAPIDS DUBUQUE COUNCIL BLUFFS AM ES CEDAR FALLS JANUARY 1, 2018 2,807,885,259 3,806,513,568 3,549,932,642 7,798,033,783 3,023,593,271 1,630,283,877 4,570,177,740 5,174,907,290 2,381,715,505 6,842,869,326 2,542,043,245 2,809,624,482 3,079,908,598 1,955,185,106 TAXABLE VALUE REGULAR W G&E JANUARY 1, 2019 3,116,251,053 4,172,675,883 3,878,916,115 8,376,694,815 3,214,491,894 1,731,148,967 4,769,677,623 5,364,636,433 2,428,877,662 6,950,968,990 2,579,355,511 2,844,858,007 3,112,286,020 1,968,057,686 TAXABLE VALUE TAXABLE VALUE $ CHANGE CHANGE 308,365,794 11.0% 366,162,315 9.6% 328,983,473 9.3% 578,661,032 7.4% 190,898,623 6.3% 100,865,090 6.2% 199,499,883 4.4% 189,729,143 3.7% 47,162,157 2.0% 108,099,664 1.6% 37,312,266 1.5% 35,233,525 1.3% 32,377,422 12,872,580 0.7% FY20 LEVY 15.68 15.83 10.35 16.64 10.52 14.22 16.78 10.99 12.50 15.44 10.33 18.26 10.03 10.95 PRELIM. LEVY FY21 LEVY $ CHANGE 14.89 -0.79 15.77 - 0.06 10.00 -0.35 16.54 -0.10 10.16 - 0.36 14.45 0.23 16.78 0.00 10.00 -0.99 12.80 0.30 15.66 0.22 10.43 0.10 18.26 0.00 10.14 0.11 11.43 0.48 LEVY CHANGE - 5.0% - 0.4% -3.4% -0.6% -3.4% 1.6% 0.0% -9.0% 2.4% 1.4% 1.0% 0.0% 1.1% 4.4% 15 WATERLOO 2,352,622,826 2,333,982,545 (18,640,281) -0.8% 17.55 18.33 0.78 4.5 2020/2021 TAXABLE VALUATION CHANGE, TOP 15 CITIES DEPARTMENT OF MANAGEMENT - LOCAL BUDGET DIVISION TAX INCREMENT FINANCING VALUATOIN TAXABLE VALUE TAXABLE VALUE TIF INCREMENT TIF INCREMENT TAXABLE VALUE TAXABLE VALUE RANKING CITY JANUARY 1, 2018 JANUARY 1, 2019 $ CHANGE CHANGE 1 AM ES 45,584,078 75,857,137 30,273,059 66.4% 2 BETTENDORF 70,492,813 102,289,753 31,796,940 45.1% 3 COUNCIL BLUFFS 100,883,278 138,010,702 37,127,424 36.8% 4 CEDAR FALLS 104,565,502 138,806,175 34, 240, 673 32.7% 5 CEDAR RAPIDS 329,955,898 417,106,848 87,150,950 6 SIOUX CITY 320,616,271 390,744,272 70,128,001 26.4% 21.9% 7 DES MOINES 839,346,269 966,764,829 127,418,560 15.2% 8 DUBUQUE 353,396,716 405,604,502 52,207,786 14.8% 9 MARION 111,866,538 124, 518, 294 12,651,756 11.3% 10 WEST DES MOINES 11 WATERLOO 12 URBANDALE 13 14 ANKENY DAVENPORT 15 IOWA CITY 557,155,824 267,969,299 307,600,351 292,312,551 187,047,180 115,175,495 599,366,631 284,405,439 316,759,604 298,261,068 182,623,128 42,210,807 16,436,140 9,159,253 5,948,517 (4,424,052) 7.6% 6.1% 3.0% 2.0% -2.4% 84,077,937 (31,097,558) -27.0% 2020/2021 TAXABLE VALUATION CHANGE, TOP 15 CITIES DEPARTMENT OF MANAGEMENT - LOCAL BUDGET DIVISION TOTAL TAXABLE VALUATION - REGULAR PLUS TAX INCREMENT FINANCING TAXABLE VALUE TAXABLE VALUE DEBT SVC W G&E DEBT SVC W G&E TAXABLE VALUE TAXABLE VALUE RANKING CITY JANUARY 1, 2018 JANUARY 1, 2019 $ CHANGE % CHANGE 1 SIOUX CITY 3,128,501,530 3,506,995,325 378,493,795 12.1% 2 ANKENY 3,842,245,193 4,177,177,183 334,931,990 8.7% 3 IOWA CITY 3,921,689,063 4,256,7531820 335,064,757 8.5% 4 DES MOINES 8,637,380,052 9,343,459,644 706,079,592 8.2% 5 MARION 1,742,150,415 1,855,667,261 113,516,846 6.5% 6 URBANDALE 3,331,193,622 3,531,251,498 200,057,876 6.0% 7 DAVENPORT 4,757,224,920 4,952,300,751 195,075,831 4.1% 8 WEST DES MOINES 5,732,063,114 5,964,003,064 231,939,950 4.0% 9 DUBUQUE 2,895,439,961 2,984,960,013 89,520,052 3.1% 10 BETTENDORF 2,452,208,318 2,521,167,415 68,959,097 2.8% 11 CEDAR RAPIDS 7,172,825,224 7,368,075,838 195,250,614 2.7% 12 COUNCIL BLUFFS 2,910,507,760 2,982,868,709 72,360,949 2.5% 13 CEDAR FALLS 2,059,750,608 2,106,863,861 47,113,253 2.3% 14 AM ES 3,125,492,676 3,188,143,157 62,650,481 2.0% 15 WATERLOO 2,620,592,125 2,618,387,984 (2,204,141) -0.1% Local Option Sales Tax (LOST) Ames Sioux City Dubuque Davenport Bettendorf 1987 1987 1988 1989 1989 Council Bluffs 1990 Waterloo Cedar Falls Cedar Rapids Marion W Des Moines Urbandale Des Moines Ankeny 1991 1991 2009 2009 2018 2018 2019 60% Property Tax Relief; 40% Other Improvements 60% Property Tax Relief; 40% Other Improvements 50% Property Tax Relief; 50% Other Improvements 60% Property Tax Relief; 40% Other Improvements 60% Property Tax Relief; 40% Other Improvements 100% Streets and Sewers 100% Street Repair 100% Street Repair 100% Street Repair 70% Street & Sewer; 30% Other Improvements 50% Property Tax Relief; 50% Other Improvements 50% Property Tax Relief; 50% Other Improvements 50% Property Tax Relief; 50% Other Improvements None Iowa City None