Loading...
HomeMy WebLinkAboutSupplemental Attachments - 2/4/2020U T 3 o,vw z.uoro 149.956 9.43% r le o CO CO30 0 0rr *0� a 0 o o a - < r• O r 34,754 0 o r 4,395,568 1,775,314 1,880,856 85,542 0 0 n n 1,589,530 I 1,739,486 165,300 14,058 18,399 t�f.n <,s3.4y.:9.as:,a ,>:1Ad. �'Lai'a<...0;i 1.948.000 289 861 416 Ann N" O r- r N S N m el g o Oi O] CO 0 O N 0 of N CO Cr- 0 III 30 M uI a m r N 162,181 168,449 3.86% 0 0 2,327 059 .... 2,515,005 8.08% 0 0 598,715 598,715 0.00% 598,715 598,715 0 0 0.00% 0 0 236,500 236,500 0.00% 236,500 236,500 5,500 5,500. 0.D0% 5,500 5,500 94,675 I..._.. 94,675I 0.00%l 0r ....._0- O 1.639.009 r N O1 a 2 O v -_ 1,948,000 I'IIII W a 215,000 1 Otq 533,500 1,075,407 O 2 co 2 2 a } . I To I I IL) IAL-HEALTH & SOCIAL SERVICES 130C 312,783 I 323,760 I 3.51%I 45,000 0.00% 3.78% I10III00000I m o** m o' * om I? `'� �' ti a 1,589,530 1,739,48] 25,305 25,305". 179,358 183,699 0 ,0r3 2,237,861 2,364,650 377,032 I�mi Ci • is In CO (4,631,523) N o r c CO N O o Iri N O m CO 533,500 Ill o oa 1,414,374 I 530,000 I M r toly 6,256,422 I O 267,783 278,76(TI t 2 W N" CO 1,203,684 32,748,002 (4,258,887) W a co oi N 215,000 17,580 533,500 1,075,407 I a v r W 3 g0 iiS r c r. la 0 0 W U ~ O m J U U U❑ U U U U U el 000000 H N N b O b U O U r ' e- N U N U N V N U N C.)00000� N N NNN N CO ACTIVITIES -GENERAL FUND rUCLK: SAFETY 010-I I100 POLICE OPERATIONS 3DIAd3 _')I1(1rII CnLL-LL-nlnr UIU-11-1z00 P C SAFETY ADMINISTRATION 200-11-1140 'POLICE PENSION 010-11-1150 J POLICE GRANTS 1010-11-1150 POLICE GRANTS (DISCR HIM) 1010-11-1160 I LAW ENFORCEMENT PROGRAMS 1010-11-1165 (POLICE TOBACCO ENFORCEMENT 010-01-1700 I B.H. COUNTY EMA/SIREN MAINTENANCE 010-12-14UU FIRE RESCUE 01u-18.1405 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 I TOTAL -GENERAL FUND PUBLIC WORKS J uIU-li-IU1U IPARKING FACILITY MAINTENANCE 1 010-22-7930 PARKING OPERATIONS 10-29-7700 'AIR*UKI OPERATIONS 1 010-01-7800 MET TRANSIT AUTHORITY § u1 u-10-/UOZ CENTRAL GARAGE -CHARGEBACKS UIU-18-7955 MOTOR POOL -PASS THROUGH ACCOUNT I TOTAL -PUBLIC WORKS f F u I V-ul-zzuu rULAUK HAWK COUNTY HEALTH DEPT. 0'10-27-2500 HUMAN RIGHTS COMMISSION 010-27-2505 EEOC CONTRACT 010-27-2510 FAIR HOUSING ENFORCEMENT 010-27-2510 FAIR HOUSING PARTNERSHIP GRANT 010-27-2520 HUMAN RIGHTS PROJECTS Q (J o w I I-` I r-12-1420 -12-1412 37a N o 1010-12-1425 N o N N a0 DS 0 o N 0 o nOOrmAO - 1� J a J r oS Ib d O Da 2 fO W'< 2 N ch V In lfl r co m CD,- N o7 a(0 (0 ,l`z. ID W NIN I NIN N N(0 NININI M c.7., M 2' (0 (0 (r') M M 7 .17. 4V '"V V V V 7 i 2/4/2020 4:06 PM x O 0 0 co 2 a LL w 0 FI N LL m a W co 8 3 0 0 J W u_ O - 1 0 ^W 1. 2 0 p Z W C7 u- � m re W Z MQ W/� W V N N a V.. 0 0 } g -I FY2021 TAXES LEVIED e W U' Q U e 0 0 e n c- e n e CI 1c 14,350 I 15,790I 10.03% 20,000I 20,000 (5,650) (4,210)1 1,440 25.49% 35,000 35,000 0.00%35,000 35,000 0 0 0 0.00% 0 0 0.00% 0 0 0 0 0 0.00% 18,643 19,191 2.94% 18,643 19,191 0 0 0 0.00% 1,837,384 1.,894,6281 3.12% _ 27,000 27,000 1,810,384 1,867,628 57,244 3.16% 18,417 18,417 0.00% 18,417 18,417 0 0 0 0.00% 3,000 3,000. 0.00% 3,000 3,000 0 0 0 0.00% 51,865. 51,865 0,00% 51,865 51,865 0 0 0 0.00% 5,000 5,000 0.00% 5,000 5,000 0 0 0 0.00% 4,120 4,120 0.00% 4,120 4,120 0 0 0 0.00% 73,083 75,258 2.98% 73,083 75,258 0 0 0 0.00%. 10,000 10,000 0.00% 10,000 10,000 0 0 0 0.00% 1,6669601. 1,745,269 ] 4.70%I 39,737 ] 39,737 1,627,223 ] 1.705.5321_... 78 300 1 4.8196 , 950,000 950.000 0.00% 950,000 950,000 0 0 0 1 0 00% 22,000 22000 0.00% 22,000 22,000,. 0 0 0 0.00% 0 0 0.00% 0 ,.0 0 0 4 0 0.00% 0 I o I o.00%I 0 I 0 0 I 01 0 I 0.00% ems° ' r) t o 0 a IC n n 0.00%I e : 0 d e 0 o 114,432 8.17 % 105,834 1 114,482 ' 0 ' 0 0 0.00% 0 0.00% 0 0 0 0 0 0.00%'. 240,000 0.00% 240,000 240,000 0 0 0 0.00% 80,000. 0.00% 80,000 80,000 0 0 0 0.00% 600,000 0.00% 600,000 600,000 0 0 0 0.00% 271,874 1.51% 267,835 271,874 0 0 0 0.00% 0 0.00% 0 0 0 0 0 0.00%. 44,050 0.00% 44,050 44,050 0 0 0 0.0096 I L-_. I _... i .. _.. 0 1 0 1 01 0.00% $ AMOUNT CHANGE 0 o co O. lll h O r Y) Cr16 27.176 r• 0 lO (y Lop N(yy 0 0 d m 0) en 0 (11 50.000 630.175 320.806 7 r CO10 (0 405,225 inW N N C) (o N (44.500) 121,200 34.203 1 I FY2020TAXES LEVIED ] $ 17.54799 8 80Np N M f0 CA O 593,226 sp�� O r 0 O 933,153 243,485 9,253 D. 1,469,675 0 282,400 338,506 699,000 84,472 6,070,188 287.399 1 G O @ N C. N CO 1 FY 2021 BUDGET PROPOSE]] REVENUE O r N N O m I 141,579 4,932,175 v) } 45,200 0 0 FY 2020 BUDGET CERTIFIED REVENUE O N N O OOI 0) Yr) NI" N n W r0 ��Yll 0 N 0 0 0 tit CHANGE eeee 0 .- 0 h e N e Cj o.00%1 ee 0 0 LL I FY 2021 BUDGET] PROPOSED EXPENSE 1 O O 0) C. ? 0 415,108 1 772,372 405,225 ON 01 v. 0 01 0 00 r 00 N N 34,203 1 LI1 FY 2020 BUDGET CERTIFIED 1 EXPENSE II°°0 0 oO N 0 V ) I) O V 734,805 378,049 f00 W A 0) O 730,554 ] 700 I 121,200 1 0 N 0) CI K o F tow m W -1 0 m 0 CON 0 CO O m O O m O m O m y U m O m O m D U M U M U U M U U CQ w O M D U (0n U U oti U m U of 0 Pmi 0 e°i 0 v 0 0 0 0 U 0 0 0 0 a U o 0 a 0 < (D 0 z 0 LL W z W 9 m W F_ U U Q (CULTURE & RECREATION CEMETERY OPERATIONAL SUBSIDY GROUT MUSEUM YOUTH PAVILION CENTER FOR THE ARTS RIVERLOOP EVENT FACILITIES C&A GRANTS & PROJECTS ]CENTER FOR THE ARTS (H/M) ]CENTER FOR THE ARTS (DISCR H/M) ]LIBRARY SERVICES I LIBRARY - ENRICH IOWA GRANT ]LIBRARY OPEN ACCESS PLUS LIBRARY GRANTS ]LIBRARY GIFT &MEMORIAL ]IOWA LIBRARY SERVICE ]COUNTY LIBRARY ]LIBRARY OPEN ACCESS 1LEISURE SERVICES - PARKS LEISURE SERVICES - PARKS - CHARGEBACK LEISURE SERVICES PROJECTS LEISURE SERVICES PROJECTS (H/M) I LEISURE SERVICES - SOUTH HILL PARK LEISURE SERVICES - DOWNTOWN MTCE GOLF COURSES GOLF COURSE IMPROVEMENTS-SURCHARG SPORTSPLEX SPORTS & YOUTH SERVICES YOUNG ARENA TOTAL -CULTURE & RECREATION COMMUNITY & ECONOMIC DEVELOPMENT 'PLANNING & ZONING RECREATION AREA DEVELOPMENT CITY PROPERTY MANAGEMENT INRCOG MEMBERSHIP PLANNING & ZONING -ECONOMIC DEVEL ECONOMIC DEVELOP -SPECIAL PROJECTS ]TOURISM PROMOTION -VARIOUS GRTS (H/M) 'TOURISM PROMOTION -VARIOUS DISCR (H/M) I CONVENTION & VISITORS BUREAU (H/M) SULLIVAN CENTER MAINTENANCE 'COMM DEVEL-ADMINISTRATIVE ICOMM DEVEL-LHAP HOUSING POOL TOTAL -COMMUNITY & ECONOMIC DEV BUDGET CODE 010-01-4405 0 01 N O 0 0 m 0 N 0 0 0 IID fA N 0 0 010-26-4251 010-26-4285 10 Q0 tD N 6 0 I010-264285 0 0 CS 0) 6 0 I010-33-3110 0 ID M CO 6 0 I010-33-3160 0 CO N P) o 0 0 C) LC`]S CI o 0 0 0 [CNJj (7 o 0 0 N 9 o 0 o O 9 o 0 010-37-4102 010-37-4105 010-37-4105 1 0 O M 6 0 010-37-4110 010-37-4120 010-37-4125 0 0 m 6 0 010-37-4200 010-37-4500 0 O 11) O 0 0 010-08-5750 010-08-5885 010-01-5710 010-08-6100 010-08-6105 o N (00 o 0 0 010-01-6660 O N( m 9 o 0 o m N 6 0 010-32-5850 10 N O 0 *' N M V"IO O 0 N 0 (•') 0 V' 0 I() CD 1O IO 1` 0 000)O IO I!) CO 07 N CO CO CO V'N CO CO CO CO I- CO CO CO CO CO 0 n r 1- 1'• N CO V' r• r• )O N- CD 1"- 1� 1- (00)0 N- 1•. 000000(O NM V- )D co co (0 I,- 00 W (00)O M co 0) O) NM 0) 0) V' 0) ID 0) CO 0) 2/4/2020 4:06 PM \Valomain\waterloo JSERS\MICHELLE-\MBudget FYE21 \FY21 BUDGET Base February 4 2020.xlsx N -0 NI - co N cn Ill CO 0 0 -J a LL0 Z ''0^ V! 0 0 Z Wry Q u- W W Z W N 0 W LL Z 1. W LL_ W 0 Q N N W U. FY91191TAYFC I mnFn in se w Z 7 0 U e'eeeeeeep V < o m O M O 0 N_ N a- 0 O gees 0 0 0 o O o 0 0 a 0 0 eeeeeeeeee 0 0 0 O m O O O O O In m 0 0 0 O gOj O d'o �o. O S 0 O m N e N 0 0.00% 0 01 0 I 0 I 00• 000% 127,000` 0.00°% 127.000127,000 00 0 0.00%" 127,000 0.00% 127,000 r 127,0'00 I 0 I 0 1 n n nnoe 3 > 0 O O 2°� O OO co C 2' i0 co a Z ) n 1 w i U.'< Z U m o c , ) N ^ g co 0 0 I( ' 'Vnnm > O O O O m O O W N O O N 0 0 £= 0 co v 1 ) 0 0 0 2,270,385 oh m < e c to iA A ,- N O W 0 p m Y O rV-� m n 0 V M 0 a. CC G 6 u I< co N 0 W 03 i co N. 0 0 0 N Q N mV m O ‘_co) c c V UU6 VI, i M 1 N N 0 m r P 0. r co •- ,. .-gkf 0 •m` 1. m n N N o 0p m N. ,- o I1o� l� 0 0 N. a cli FY2020TAXES LEVIED )0 P. W I 0 0< N 0 0 0 CO 0 I 74.175 0 V' mm 0 O m N M m V' N < 0 0 0 I 527.457 1 N 46.000 ! In a N CO CD t0 O 17.500 I m m In CO. m 1,250,0001 (1.250.000) p 0 N 0 n O N. m - FY2021 BUDGET PROPOSED REVENUE 0 0 Y0 a < 40.000 0 m 0 T d 0 77.500 O 0 500,000 0 m N V M 250,000 30.750 0 0 0 32,500 00 - Q. 0 O 0 m M O < 350,000 1 350,000 1 0 0 O 0 m of N d N I FY 2020 BUDGET 0 atN LI rem W U REVENUE 0 0 i 40,000 000 O m a. 77,500 0 0 00 O O o inN O N N N 0 250,000 30,750 I 0 0 0 32,500 I O O m9 O 01 Nli O t0 M O< 1,250,000 1. o g m W C9 e 1 CHANGE I 4.40% eeeee 0 N O CO 0 0.00% 0.00% ee CO 0 I %00'O eeee 0 0 0 m 0 0 e0 8 0 0.00%I aa:e;ee W ';,-. 0 O e In 0 0 82, 404, 334 I 64, 717, 809 1 3.71 % I LL ~ o ❑ O N CI lc PROPOSED EXPENSE r 0) m< 0) l0 O .} GO p Vp V 40,000 75,847 1,329,556 pO O O m 77,500 353,135 0 0 CO N < 500,000 0 CO N N N. 10 10 A N. m 0 O m 48,0001 0 10 O < N 0 {{yy Q 32,500 O ID A — N IO -'. [ m d 17,472 07. N W 0 W IFY 2020 BUDGET 0 F W< 0 EXPENSE 300,575 m �F� W 0 74,175 1,277,862 60,000 Ipn �0NI m tD O p 3.472,295 777,457 roil- P4 p 14,500 I 399,548 I co_ �rnm,, I) < m '' m m m 17,472 I m 00 w o 0 0 IL U 1- 111 p 7❑ W Z J 0 CO 0 CO 0 CO U CO U a 0 v 0 CO 0 v 0 CO 0 <0 0 0 0 u0i 0 N 0 N U 0 U <0 0 0 0 l0 0 CV 0 0 0 WI _- ❑ INn 0 n 0 nCO U U rr-- 13/1 (TOTAL CITY BUDGET -GENERAL FUND 1 m ACTIVITIES -GENERAL FUND (GENERAL GOVERNMENT MAYOR'S OFFICE COMMUNICATIONS ADMIN SERVICES/MIS ADMIN SERVICES/MIS - CHARGEBACKS CRY COUNCIL CITY CLERK AND FINANCE CITY CLERK AND FINANCE - ELECTION COST CITY CLERK AND FINANCE - CHARGEBACKS CITY ATTORNEY LIABILITY INSURANCE LIABILITY INSURANCE - CHARGEBACKS HEALTH/LIFE INSURANCE SELF FUNDED HEALTH INSURANCE SELF FUNDED WORK COMP PUBLIC ACCESS STUDIO PRINT SHOP EAP SUBSTANCE ABUSE PROGRAM HUMAN RESOURCES HUMAN RESOURCES - CHARGEBACKS SAFETY COMMITTEE CITY HALUFACILRIES MAINTENANCE CITY FACILITIES RESTRICTED PROJECTS VETERANS MEMORIAL HALL UNEMPLOYMENT FUND I TOTAL -GENERAL GOVERNMENT I HOTEL/MOTEL DEBT SERVICE TRANSFER TIF ECONOMIC DEV TRANSFER (INTERNAL TI PLANNING & ZONING TRANSFER (TIF) TOTAL -TRANSFERS j S I A I E REPLACEMENT FUNDS (COMMAND RO PROPOSED USE OF FUND BALANCE BACKFILL ADJUSTMENT Q W ❑ 0O W CO ❑ p m 1 1 ' I OOZR-LOULO ORZR-Ln-OLn O N 1'11 opt- N N 0 O o 8 CO N O 0 p O a m C) (7 O 0 O ppp 4 O 0 N 4 10 O 0 O 0 I m, � I m I 1 o i U'I U-UJ-ae00 N 0 0l CO +l) 0 3dl m 0 0' 1 CJ I O I o 0968-£0-OLO 096R-c0-OLO nuLR-rn-fI.n ` A I I J I 7I 7, nnuz-An-nin O 0 10 Y >) .f, ddo( N N m o N I N I N 1 m) O) ( 4) o i lulu-zz-uuuu '010-22-8820 010-22-8850 0 CO A 9 T �' T'1 111000 IL Io CO 0 K D; ('1 Z O addd i- o 0 m co O 0 0 0 o5 O 0 i • 1 1 1 i 1 nnarrrn-n Ln rN M V a, 0 m00000000000r,-r .-r .1-- <.-c-r,-.--rr r r r r-.- -- r CO r r(D W 0 rNNNN r NCI)d' <.r ,-.- LC NN CO .- r 0.10)O N r �,- 0MI10<O +MMM(h rrrrr'- P MC N. 2/4/2020 4:06 PM N y • FY2021TAXES LEVIFr) 1 oe W 0 Q x 0 Z I 0 N I < w W c � Z a 0 m O m cD .9 g c b ' o v C e N N t W CI owe CO 0 owe m 4 a CO 4 e r 4 0.00% ': epe O C pep 'Q Q e Iwo, 9 CO 7 v1 N NI (9 I FY2020TAXES W C' � ma. 6* w y� e3 m m g v m 00 627 O.I. _, _ 0 H CHANGE *3696969096466*494969696919 m CO m -0 (o m m o o om) (o(i CC') (m) vovi m m r ro m $ 2.265.352 . 69 FY 2021 BUDGET PROPOSED REVENUE N o E (In Thousands) (0 m N 110 N N 2,618,388 0 CO co. N O e^ G N W Q co co G N X I -I- N 01 >- IL. IW„ $ 2.75827 I cq - 09 O 0 M m 0 49 $ 0.55010 $ 0.90553 $ 2.61359 $ 0.22599 $ 0.00749 $ 0.27000 $ 0.27000 $ 0.27000 $ 8.10000 o of 69 69 O m $ (0.03634)1 1'OD co N 2 FY 2020 BUDGET CERTIFIED REVENUE FYE2020 (In Thousands) 0. N 2,271,362 2,620,592 C1 N< m M 0) N 125,097 V m N 23,526 I e 0 O ID STATE BACKFILL I CORP ROLLBACK A m m N 0) m c) 0) 0') N m< CO CO m m CO N Y 74,545 CO ID Id N v 0 m co 3- N (O N. N N M 22,227 N N N 0) O mm m m G. 3 6969 n N m 4 $ 832,000 1 m` N 9- 19 C7 ewe CHANGE �( Q N N } LL yy ju J (I c N r IICO 91 H m a _. 94,875 ! Y co.r } �._ 1,283,905 2,113,495 N O 3- m Y N 17,472 I m --' 0 (0 tts .- (0 m c am] 2 ® r 18,990,067 $ 44,330,527 01 " M w q $ 2,265,3521 3e co m v! W `mom' 1µn N 0) m N m'- O T` m LL '11 FY 2021 BUDGET 1 PROPOSED EXPENSE I- N N t w(0 Q ACC m03 m 0 CI �` F N m (9 $ 0.04024 ,- 3- co0 m O 19 CO m t O W m con to m O 69 $ 1.77210 $ 0.22420 co a 0 O w $ 0.27000 ! $ 0.27000 N O .9 O^ m 19 I $ 17.54797 W ROLLBACK REPLACEMENT - GENERAL LENCLUDING EMPLOYEE BENEFITS LEW, EXCL DEBT SERVICE ll.1 IFY 2020 BUDGE CERTIFIED EXPENSE !Taxable valuation - including TIF but excluding gas & electric utility values Taxable valuation - excluding TIF & gas & electric utility values Taxable valuation - including TIF and electric utility values Taxable valuation- excluding TIF but including gas & electric utility values O N U. J {(9 tNN(t���� N n N V m m M O l(�p0_ N 2,045,944 O b 527,457 17,472 pp� N an m 635,208 N O W oi p N co CO Oi 1 in O VNi N ADJUSTED TOTAL PROPERTY TAX LEW (AT GF $8.10 LEVY LIMIT) 1 0 F" 0 F W = O) W J Commercial/Industrial Property Rollback Commercial/Industrial Property Rollback for Debt Service GENERAL FUND $8.10 LEVY INCREASE (DECREASE) l I TOTAL PROPERTY TAX COLLECTION INCREASE m 1 ACTIVITIES -GENERAL FUND !TAXABLE VALUATION Taxable valuation - Ag Land Tax Askings per One Cent of Levy PROPERTY TAX LEVY ANALYSIS: DEBT SERVICE LEW POLICE & FIRE PENSION SYSTEM EMERGENCY MGMT COMMISSION LEW TRANSIT LEVY 'TORT INSURANCE LEW I FICAAPERS LEVY HEALTH INSURANCE LEVY WORKERS COMP. INSURANCE LEVY UNEMPLOYMENT LEW LIBRARY VOTED LEW EMERGENCY LEVY GROUT LEVY AG LAND LEVY GENERAL FUND $8.10 LEVY TOTAL PROPERTY TAX LEVY ROLLBACK REPLACEMENT- GENERAL LEVY ROLLBACK REPLACEMENT - EMPLOYEE BENEFITS LEW AMOUNT CHANGE IN TAX LEVY % CHANGE AMOUNT (OVER) UNDER $8.10 LEVY LIMIT Q BUDGET CODE 1 N CO t00) V CO CO 0 V d' N (V) V V '4 V O (D d' 'I- Is. '14 CO V 0) V u) 0 (O )f) N )f) M (O NI' (O (O CO (O )1 n CO IO (O 0) CO 0 CO (D N (`')V (D CO 1n50. (O ) 03 CO 0) 0) 0 Is- 0 n I` N CO r I- V (() (DI r 0- 2/4/2020 4:06 PM \Wlomain\waterloo\USERS\MICHELLE-1N\Budget FYE21\FY21 BUDGET Base February 4 2020.xlsx yo O V V N 0 CO CO 2 __I FY2021 TAXES LEVIED ' I el 0 0 x 0 ) 10 a I w I a x U C s 0 e eeeeeeeseeeeeeeeeeee n c0 (V n.-. CO N .- M M 6.- 0 CO e- n 4- e- O 0 O 0 n (V CO CD V 0 CO CV 0 O M N 0 CO O r; a 0 [V r 03 O LO CD 4 IN 0 N E0 0 e- N n 0 NO t 0 e eetoeeeeeveeeeeeeee O 00 O C1 0 N CO 0 C: CC C 17011 I LO N I si .- 30 N e- 03 C? IN rt.V; .2 n 0 N Q 0 O Q 0 CO t0 CO V O 0.- el- N n N 0) 0 m N N LO e- 0 0 al r c 0 I Monthly Chanae O O zri:ii::iii:':io N m CO 0 W 0 0 m 7 r 0 O 0 0 4 L0 0 N O CO N V 2.87 0) N n N 0 0 8.08 Monthly Chanae Ii:::::::::::: COd CO COy� 0 10 a 0 m 0 0 0 W 0 N 0 0 0 0 0 0 0 n O O 0 0na 0 0 63.85 I 0 FY2020TAXES LEVIED $ 17.54799 Incr (Decr) 0 0 4.n EV 7 (47.521 d' , c0 CO N N 0) OI 4- 0 0 N 0 O n ih M 65.76 d' C) LO (0 co N (6 4- O N Q co 01 O r 56.70 I 0 0 N 118.52 0 0 0) Incr (Decr) 776.03 C) 01 0• CO I` 00 1- CO- N c0 (330.451I CO N LO LO (247.021I CO 01 00 N N 01 CD C 827.94 I CO Ni c0 PIN a N CO co V CO N N e- CO. �- •- V t0 0 O 0 a W 766.22 I _ 1 FY 2021 BUDGET I PROPOSED I REVENUE x CO N 0 t00 LO 00 N 00 e- n 0 INN 'rt e- 0 0 0 e- el- 0 0) eh e- CO ss0� c0 a e- 1,445.06 1,424.13 N d0 I 1,386.35 0) LO N t0 e- 1,286.43 c0 0 V fV r- n CO CO N r 1,248.71 I n N x- N e- 0 t0 O N 4- O 0 V r CO 0 N r 0 0 O O e- n CO OCO 0) X I --CO 11,883.22 11,820.90 - - 0) 0) CO 13,944.99 13,742.37 f 0 0 0- 0. 13,782.58 I c0 c0 c0 0) D Con n 0 CO D LO e- E OM N CI- 12,874.38 I Y) 00 CD 0 e-06 10,507.74 4 m V 9,647.22 = FY 2020 BUDGET W F 0 I REVENUE V 2 W l0.550743 0 N ID O 0.5562091 M 0 0 0.556259 0.557335 0.544002 0.528166 CO N 0 0 0.485299 0.469094 CO a00 0? 0 C) 0 0.455596 0.459961 N 10 IN 0 0.4545581 0.513874 0 m N O 0.5626611 0.5485251 V 2 tt e- e- 0.997312I - 0) 6—E.— W ca G 0.992571 co 0 e- CD I CHANGE Adj Value 154,138 154,138 1 144,054 132,160 118,000 I __ - - Adj Value 752,427 752,427 752,427 752,427 I 752,427 752,427, n N •I' 10 IN 752,427 I n N 10 n 752,427 I 752,427 I 0 O 0 W CD 690,300 0 O M 0) CO 0 O c0 ® 0.0 0 O O 0 585,000 585,000 585,000 LL I FY 2021 BUDGET PROPOSED I EXPENSE I Avg Revaluation Ind revel 2.88% e e e e eg Z 12 et z zz e m z N/A z e n W Ill0 0 n m 0 N 0 N I CERTIFIED EXPENSE Home Value M N N N 0 N N 0 tcn N N 0 152,234 n 0) 147,973 M ? 0 , 154,138 144,054 - 132,160 118,000 - - 100,000 100,000 Property Value 752,427 I 752,427 752,427 752,427 N 7 r 752,427 1 752,427 752,427 N '0 N N O r O C) N 690,300 I O C) CD 690,300 I 585,000 585,000 I O O c0O 585,000 I m 0 1 ACTIVITIES -GENERAL FUND CO Y W 1- T. C '1' 0 LL' FYE2021 O N 0001 N i 0) N LLL )}L 0 I N I FYE2017 0 0 tel IIL IFYE2015 FYE2o14 M 0 N Li N 0 N •- 0 N FYE2010 CO 3 0 0 1 N 1 FYE2008 N 0 0 N 1 CO 0 0 c}04 LL 0 0 0 f}04 LL R O 0 0 IL iL CO 0 0 }N IL N 0 0 N 0 0 } N LL Commercial Tax Askings FYE2021 0) 3 0 N 3 LLL I FYE2018 0- 0003 N LLi CO } N LL LO N LL I FYE2014 I M 0 N i N 0 } N LL .- 3 0 1 104 IL I FYE2010 I 03 0 0 NN IL IL CO O 0 DI }N n CI 0 04 LLLLILII 0 0 0 W LL 0 0 ( 0D W LL 0 0 W LL CO 0 t 0 } W LL IL N 0 C 0 } W I I FYE2001 Q .N 1 11 1 i CUUGET CODE $ 18.60191 O 0)ONn 100 O 7 co N: IN: - e- 9 ONO O co e- V) (9 O CO nIN: l E9 CO n CD e- e- E9 0 LC) IO n I,:od e- 69 03 LO r-Oc0O000E000000) CO LO CD d' e- E9 LC) CO N LO e- EA CO CO COO 06 e- EA at CD N CO God e- E9 0> CO [D CO r- CA n CD CD 6 E9 0) LO n COn 6c6 a-. E9 O CD l0 eet40 e- -r_r E9 Di 0) CO CO CD 66 y) E9 s{ CD CD IS 0)CO T E9 N LO IN • I: E9 00 O 0 co E9 n 0) W 4-. LO LO AONn A R CD n -e-.t-.-e-e-e-.-.-e-e-T-,k-,,.-.-r-r-. 9E9 ONO O LC) CD nn CO I� Vj E9 l0 n 69 0) CO O 0) n E9 0) 40 LO 0)0 al- q n 6669 OM00000OO CO CO N m W CD CO 0 6 6464 V CO NCO 60606 W CO O CD CO E9 n CD CD od 49 0 40 nCO0) Od EfT 0 LC) 7 6:3 0 CC) (A T co Di E9 0) 0) nCO 06 Od es V' CD CD on Od E9 N) c0c CO lac E9E O I IC Of CO V co x- e-'-a-'�""e- rJ CO W C00 W 4-•-•-4-4-4- W 00 OW 000)O) 4- 0) 00)) 4-T'.-'.-e- Dom) 0�) OO) COn C0)00)0 e-NNeI OD0. N I.C) CO 00 n0CD NNNN 00 a-NM- NNNN e-- LO N NNNN O n00)O N NN040 NNNNNN 2/4/2020 4:08 PM N \Womain\waterloo\USERS\MICHELLE-NABudget FYE21\FY21 BUDGET_Base February 4 2020xlsx n J FY2021 TAXES LEVIED CHANGE $ AMOUNT CHANGE % Change I eet(eeeeeeee O W M N 6 N W 6 M O 6 W W 6 10 N 6 W lV O m 1� N I A V .- M N 0 m m 0 eseeeee M .- tV N V a.-.- N m W 0 M W O M O (Y N O) 7.94% % Change eeee W O (7 W N q' M M uI W M eee N O N O N fO N N W O 10 W 10 Monthly Change 10 O 10 co 0 W W 0 O O Of m O W O r O) O (0 co O O (0 (59.32) (27.36) 22.44 1'. O 0) O 0 10 N M 0) 0 W m N CO ID Vm h V O M W m ._, 44.79 1` O n v ` O) oN I Monthly Change 0) O O (24.40) CO N N v 0 O I� In 0) (44.45) (18.30) FY2020TAXES LEVIED 0O 01 n tll i. U 0 U = M. 0 0 82.84 I 1n W (0 N ... o^ I. v M W 04 V e- M W (0 O O W s- O) M .p.. m CO ,- C (328.30)1 269.29 CO CO 04 (OO CO O) 10 N CO 0 O) v .,- .- O) (_, m CO 0 O v N CO. 1 O M 1)) .- W .- v N 10 1- m I0 570,87 W N O) O •1) Incr (Decr) LOW M (0 V 0) r N O 0')') (386.72)'. (332.25) (401.41) (533.34) O) N O) v FY 2021 BUDGET PROPOSED I REVENUE Tax 1 N I- '7 r.l'-t,. O O) .- M O) O O M O O 15,840.00 I 15,844.70 I 15,987.33 I O 1.66646 ID OVNLONM ' W .- O 1: O O O (D O M M O ID O (O OD O) W 0 CD 18,366.87 I 0 co O (0 1-0d CD 18,845.80 WV O 66 10 0) 18,789.99 O 06 18,371.62 17,800.75 1\ O) O O x H MO ow 66 NW CO 66 O 6,873.28 0 O O (O N I� 7,592.25 I,- W 0) 0) 0 r 8,527.01 0 (O (0 V I. CD = FY 2020 BUDGET CERTIFIED REVENUE y V o a o re 0 O 6666666 0 O) 0 0 0 W 0 O) 0 0 10 0 U - O ce 00 N N 0 O n 0 0.7875 0.8250I 0.8825 00 00'- um 66 0, CHANGE 0 D N > 1,000,000 0 0 0 666 0 0 .-.-.- 0 0 0 0 0 0 0 0 0 0 1,000,000 I 0 0 0 O 0 0 1,000,000 1,000,000 1,000,000 00 00 0 [0 00 0.0. r.- 0 O 1,000,000 1,000,000 1,000,000 0 0 0 666 0 coo 0 0 0 0 «� 0 0 0 0 1,000,000 1,000,000 0 o 0 O 0 o 1,000,000 I m = {p > Q 500,000 _ 500,000 0 o 0 0 0 ID 0 0 0 0 0 ID 0 0 0 0 0 In 0 0 0 0 0 In I 500,000 I 0 0 0 O 0 In LL FY 2021 BUDGET' PROPOSED EXPENSE -_INIA ZZZZZZZZZZZZZZZZZZ 4 Q¢ C R 4$ 2 Q g ¢ 4 4 Q$ Q Z C$ Z Z Q Z Q Z Q Z Q Z N/A w FY 2020 BUDGET CERTIFIED EXPENSE I 00 o 0 0 00 00 0 0 0 1,000,000 1,000,000 I 0 0 0 6666666 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,000,00o 0 0 0 666 0 0 0 0 0 0 0 0 0 0 0 0 1,000,000 0 0 0 0 0 0 1,000,000 1,000,000 00 00 0 66 00 00 0 0 0 0 o 0 ID 500,000 I 500,000001 0 0 0 0 0 ID 500,000 500,000 500,000 500,000 Ow02 F I- W O W m ACTIVITIES -GENERAL FUND I Industrial Tax Askings FYE2021 FYE2020 O) 0 N(�1 W LLLLLLLLLL W 0 W 1, 0 W W 0 �(�II W ID 0 N W FYE2014 M 000000 N(� }W LLLLLLLLLLLL N— N W W 0 W 0 W O W FYE2007 O 0 N W LLLL O 0 N W FYE2004 FYE2003 FYE2002 O 0 N W LL Multl-Residential Tax Askings N 0 N W LL 'FYE2020 O) 0 NN W LLLL W 0 W FYE2017 W 0 N W LL FYE2015 V 0 N W LL Q BUDGET CODE' $ 18.60191 $ 17.54799 $ 17.45595 $ 17.60000 $ 17.60522 $ 17.76370 In I() CM I� 64 $ 17.49319 $ 18.20505 M M tD 00 d3 I $ 18.26406 I $ 18.30689 $ 18.36687 $ 18.76669 O V eD cc;0) Ui (00) 10 .- Vi 00 1, (0 0, -- 0 001 N Vi (D 1� N Vi I$ 17.80075 0)) CO 'd' 6h (A $ 18.60191 $ 17.54799 $ 17.45595 $ 17.60000 $ 17.60522 $ 17.76370 (D 00 M 63 r d' h E%J N M V 1- N 0 m V N O N N N N 0) N V N 10 N (O N 1". N W N 0) N O N N N N M N V N ID N (0 N i� N N N O) N O N N V M V N d' N (0) N (O N r N O N O) N 0 N 2/4/2020 4:06 PM \\Alamein\waterloo\USERSVv1ICHELLE-W\Budget FYE21\FY21 BUDGEf_Base February 4 2020.xlsx ,01 W 0C o u) 1 1 Lt June 30, 2019 (f 1 (a -U c co c co CU V-- U O.) O r 0_ O ..,_, N O = co Q N CU c - = O O U 'i as Ca (a E E E O E E t U) U) CL • • • • MireiRlalliMMNIfilarCM To . 0 .0 c co 2 2 (a U) q" 4= A5 O ha 176 E aco cn _c= u) cn co — c cB 2 cu U •— O -t V; El V c.)ci) _o ( co w U -0 u) Ac-,',) E 2 2 (13 >. Cl. (1) ' — D N i- Q U U CT CO -0c< ' -E c ..., .-002'4-6 o- co 0 �8aQ(I)�a2 cn 16 n al 5 N c-ru co U O U O ira , . 0) E �� O OE U� •— O O ® N Q) Ct Q) > ° aCi c7) tO 4u2, .5 a) 1 w — �v)2 UT. — I)22 . . . 1 I g 1 co (1) 75 U_ rg3a ft a) a) Total 2019 $108,136,620 Total 2018 $101,981,264 0 0 0 0 0 0 0 0 0 0 0 0 0 O. O. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Co (0 7 c+') N E9 64 En 64 E9 44 Other Taxes I 1 ■ r overnment. Total 2019 $112,949,532 Total 2018 $121,749,734 O O O O O O O O O O O O O O O O O O O O O O O O O O O O LriOLriO 1.6 _o to EA EFJ EA 64 Ea EA EA E9 Debt Service c A o d C C U 'o 0 a c N U p E E c 0 0- o C O E 8 m Ewa U O • d • d Uct Public Works UO N'N N :Q C00 N m 00 N ,N EA 6S N N O co m M O m N co m N CO 0 00 CO m N o Q LO 0 Q o m CO 69 N CO LC; CD m CO- N 6? N N N Q r. m CI, 0 0 N N • • I n 1 u v v v \ . NS v v v v u u v v v v v v v v v v v u v a) U c Co co m 73 C L.L 6) O N O Cr) a) c n -) 73 C U. c L a) c a) 0 1.0 1.0 M 00 N- C) N {t 73 N c cp 0 c c D N (-0 d LC) (D tom- CO Cr) O O O O - O O O O N N N N N N N N • ® ❑ ❑ ■ • $50,000,000 O 09 Fund Balance Expenditures a) C a) a) • 0 -o a) co co -o LL EL3 a) a) 0 r C) 0 CN 10 0 r OZ) r r N- CfD in r r •,— o 0 CNI C \ I C•sl 0 0 0 r 0 oo n r1 ogaN Ams .01 ✓1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o co (0 '- nj r r lA VS) (f? fZe $12,000,000 0 0 0 0 0 0 0 00 00 0 00 0 6 0 0 o oo o o o o EI CO r cv 0 ch m June 30, 2019 ■ Change in Net Position ❑Nonoperating Expenses ■ Operating Expenses ■ Operating Revenues 61 v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v 0) c f O Q a) a) U c co . Q E O 0 C CO O L O 0 co i a) ca o C G CO O L (1) CI > a) cn co c co a) co a) co E L 0 a) 0 c a) • U 4= CD a▪ ) o 0- CO L) CD .cm --E (0 o o 45 Z L Control Over Financia • - Immaterial instances of noncompliance with state statutes • Deficit fund balances — Grants, CDBG and Capital Improvements Funds • Airport cash deficit }0) 0 a_ a) Ct a) U c co 0 < U a) U c Q Cr) - Low -risk auditee for Single Audit purposes - 1 major programs tested: Section 8 Housing Choice Vouchers - Unmodified ("clean") opinion on major program - No instances of noncompliance reported In a 1 Unmodified "Clean" Opinion Over the Financial Statements ■ N ca E Management Judgments and Significant Accounting Es ■ Audit Adjustments —None ■ Passed adjustments • Disagreements with Management —None ■ Significant Issues Discussed with Management —None • Difficulties Encountered in Performing the Audit —None • C2 0 0 z u_ < 0 zct I 0 F--- >- z 0 z LU Cr .0" © 2019 RSM US LLP. All Rights Reserved. RSM, the RSM logo and the power of being understood are registered trademarks of RSM International Association. on= 0,na)mmm \-. ,CD /\2 E\ agn GG s-0 \2.%2&a 74. }ter g(J) ,__, ):cn k\\}} m\\\ °°CD. Go/7 /{///E i cE -7\ an 70- 0 m-0/§E\ (E\/ }/a\\) ;o=§_ 3=0 \ 7=-5 /-:=e oma= E£3\@g \A$§ -oa 5'}ff }/\�/) \CD 7@$/\2 \%{/ \�/\\/ �\`c ::®°_ §�_w £®=o: 230 0G{G%\ f&}2 \a®/Jo /§E% &]0)0\: 20 \ CD- { §� !,\ % - - o c.-. \g{z \2®-2& °°/2 //\< &},- !=k��e fr{\ Zms%\r tog( a3C5Q _!«0 m\o;§ }=E: /:i/g :J=& &\/$\E /k/j �mG}\/ §=_E !/°`G -oG= =0 0CD $)� E=73a& —2 /Ee=9E z,= 000 Goo - , §l=k-= Q({ 6 s E 2 o m2, Imm=am a. %\ EE- o; -\2 ®(�fCD 0\ _ o &$_@@ �&_,,c /// -@{ƒ2/ /m;£®{ /\/ 0Hr =y} -72e\\ 0_ ®`/§2/ / \ { a) \ -Z / o tuawnoop slyl \ E 0 ] c % 2 0 Nine \ Nvmso