Loading...
HomeMy WebLinkAbout4.1 2022 First Quarter Review - Joint Workshop with the Village Board and Finance CommissionIL Mr�GauC'd'+rt;�iect Item Cover Page Subject 2022 First Quarter Review - Joint Workshop with the Village Board .. Finance Commission Meeting April 26, 2022 - JOINT VILLAGE BOARD AND FINANCE COMMISSION SPECIAL WORKSHOP - Fiscal Impact Dollar Amount Budget Source Category Discussion Items Type Discussion Item Information Each year the Finance Department prepares a first quarter review that presents the preliminary results of operations for the prior year along with a first look at the results of the first quarter financial activities and performances. The financial review will cover following items. a) FY 2021 Unaudited Financial Results and Analysis The year 2021 started with many uncertainties. Early 2021 experienced the peak of COVID-19 with a very high number of cases. In anticipation of the unfavorable market conditions and economy, the Village Budget for the year 2021 assumed a higher level of conservatism and caution. However, as the year progressed, the Village emerged not only financially strong, but also achieved historical milestones for many of its revenue sources. The Village collected $52.2 million in intergovernmental revenues against the original budget of $43.7 million and the attached report discusses each of the major revenue line item's performance. Overall, the Village collected outperforming state sales tax, home rule sales tax, income tax (LGDF) revenue, use tax, and ambulance billing fees. Additionally, the Village received $3.5 million from the U.S. Treasury for the American Rescue Plan. All of these items allowed the Village to collect $19.3 million more compared to the revenues collected in the fiscal year 2020. However, the fiscal year 2020 was heavily impacted by COVID-19 and a comparison of 2021 performance with 2020 may not represent a fair comparison. The attached report herewith provide more 1 details about revenues and expenditures for the year 2021. b) FY 2021 General Fund Reserves The total General Fund revenue budget for the year 2021 was $58.9 million, while the original expenditure budget was $60.8 million. The revenue budget was eventually revised to $71.1 million, while the expenditure budget was revised to $63.3 million. The actual recognized revenue for the General Fund totaled $72.8 million, while the expenditure totaled $60.4 million. As mentioned earlier, a few outperforming intergovernmental revenues including the state sales tax, income tax, use tax, and ambulance billing fees, along with a one-time American Rescue Plan Grant of $3.5 million contributed toward the recorded surplus for the year. The General Fund started the fiscal year 2021 with $23.5 million in the unrestricted fund balance, while the actual spendable fund balance as of January 1, 2021 was $15.8 million. During the year 2021, $2.3 million was released from the restricted fund balance and was spent on a Flood Control Project for the year. The net accounting surplus of $12.3 million (from 2021 activities) is added to the unrestricted fund balance. At last, the newly restricted revenue source (American Rescue Plan) will reduce the unrestricted fund balance by $3.5 million, and a new unrestricted fund balance of $34.3 million is derived. The fund balance represents 49.5 percent of the annual budget, while the fund balance policy requires a fund balance from 20 to 30 percent of the annual budget. It is important to note that the actual spendable fund balance as of December 31, 2021 is $25.2 million (36.3% of the annual budget); the remaining amount of the fund balance totaling $9.1 million is not readily available, as it is a product of year end audit adjustments for the state taxes receivable. (Collection normally lags by 3 months.) c) FY 2021 Police and Fire Pension Funding Report Overall, fiscal year 2021 was a good year for the Police and Fire Pension funds and both funds added $9.6 million and $4.5 million, respectively, to their net positions. Regardless of outperforming investment returns, both the pension funds' funding ratio decreased by 2.0 percent. The downward pressure of returns in the investment market and global uncertainties have caused both the consolidated Police and Fire Pension Investment Funds to adjust their future earning assumptions. The interest rate assumptions have been reduced from 7.25% to 7.00 percent. In addition, previously the Village used RP -2014 mortality tables, but now the Department of Insurance has come up with the new mortality tables called Pub -2010, which provides for a higher life expectancy for public safety employees by 1.0 to 1.5 year. Both of these items are the primary results for the 2 higher pension costs for the coming years as well as the reduction in the funding ratio for both pension funds. The attached report provides more details about both the pension funds. d) Q1 2022 Revenue Analysis The Q1-2022 shows the total recognized revenues of $26.4 million, and it represents 17.1 percent of the annual budgeted revenues. At the same time last year, the total collected totaled $23.2 million. The Q1-2022 collection is trailing higher by $3.2 million or 14.0 percent compared to the Q1-2021 collection. The attached report provides more detailed analysis for the revenues recorded in Q1- 2022. e) Q1 2022 Expenditure Analysis Q1-2022 expenditures totaled $24.8 million or 15.5 percent of the annual budget. The expenditures are trailing higher by $3.2 million compared to Q1-2022, mainly due to higher Personnel and Capital Improvement costs. The attached report provides more detailed analysis for the expenses recorded in Q1-2022. f) The report also provides a preliminary proposal from the Village Staff for deploying the recent surplus from the General Fund, especially from Sales Tax. The proposal is added for discussion purpose only and will be subject to Board approval. The final proposal will be added to the 2023 Budget and will be finalized as part of the annual budget process. Alternatives 1. Discuss the first quarter review with the Village Board and Finance Commission 2. Action at the discretion of the Village Board Staff Recommendation Discuss the first quarter review with the Village Board and Finance Commission. ATTACHMENTS: 03 March Board Reports for Upload .pdf Q12022 Review - 04262022.pdf KI w M N N O N M � v CC A v w W, m 0 Nriv �oIq N r% rN 7 ll- O % Lrn 7 m O m ,-i N M 7 Ln O �D Lf) N N n N lD .� Nn + I.r1 M N 7 N M + N + W Ln m Ln m N W N n In n CD W O M W lD 7 In Lr) W N M l0 O lD N lD Lr) W n O O� r l lD N ' Ln lD n � � M n ^ N O M M O lD n M Cl Lr Lr W lD O M n Cb N n M W l0 � Lfl � Lrl oo N O o O O o Cl O Cl O O O O O O O O O O O O 7 7 01 0\ t0 � Ln .^1 N O McDrljmLn rlroO M W Nm r O O IDM Ln 7 O n M N ,Mi N N 7 7 N W M to O O O Cl O O O O O O O O O O O O O O O O M O O In O O O Cl O Lr] U O ll O C M C M 7 01 M O N W .Ni 1p M M co Lr) U .moi � 01 M N � r, n M O O O Cl 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 O O O O O O O O m o o vi Ci o Ci o o rl O O M O O Ln O Ln Lr] lrl O Cl O M O M t- 01 M O N W N lD M M LQ .moi 7 Ol M .--I N � n n M :5 10 tiWD Cx"$ 'Pl Y,Yb dd) CIl .. CIl S � �fIX >b yr W 7 7 cl� C",k, " 7.I aX 02 r „ Lr! LO LO 007 00 W 00 N n .^i O O N 4A O W O O n 4A CD O O <R 0 m N T n LO 10 r 'I rr7 ��. �� ................ i Q7 b d C a � U Q C S' O � U u v c E V W cm L � O O V a vcoC O � C3 N � Qa C � (U Qm 40 ceC C�C Q C � C m Q} Q W, m 0 Nriv �oIq N r% rN 7 ll- O % Lrn 7 m O m ,-i N M 7 Ln O �D Lf) N N n N lD .� Nn + I.r1 M N 7 N M + N + W Ln m Ln m N W N n In n CD W O M W lD 7 In Lr) W N M l0 O lD N lD Lr) W n O O� r l lD N ' Ln lD n � � M n ^ N O M M O lD n M Cl Lr Lr W lD O M n Cb N n M W l0 � Lfl � Lrl oo N O o O O o Cl O Cl O O O O O O O O O O O O 7 7 01 0\ t0 � Ln .^1 N O McDrljmLn rlroO M W Nm r O O IDM Ln 7 O n M N ,Mi N N 7 7 N W M to O O O Cl O O O O O O O O O O O O O O O O M O O In O O O Cl O Lr] U O ll O C M C M 7 01 M O N W .Ni 1p M M co Lr) U .moi � 01 M N � r, n M O O O Cl 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 O O O O O O O O m o o vi Ci o Ci o o rl O O M O O Ln O Ln Lr] lrl O Cl O M O M t- 01 M O N W N lD M M LQ .moi 7 Ol M .--I N � n n M :5 10 tiWD Cx"$ 'Pl Y,Yb dd) CIl .. CIl S � �fIX >b yr W 7 7 cl� C",k, " 7.I aX 02 r „ Lr! LO LO 007 00 W 00 N n .^i O O N 4A O W O O n 4A CD O O <R 0 m N T n LO 10 r 'I rr7 m 21 t 0 0 i ri; E 0 C) 00 m ISA O O n N Ln M Ln 7 O O O m O O t - o Cl n O co O D M cD O O n N N O ru Q jGy �;I n N ,Mi O N O O C Cb N c 0 N N O O Ln O Q C N M... c O ® U C uu c �0 ® E V W O V V v C C3 N - m c � (U E m Q 40 ce C C�C Ot C C C m 47 E m 21 t 0 0 0 0 0 C) 00 m O O n N Ln M Ln 7 O O O O N ^ } } 10 CO m O O M W 0 N M O 7 O O O m O O t - o Cl n O co O D M cD O O n N N O sv ll} jGy �;I n N ,Mi O N O O C N O n O .--i n m Q� Cl O O O 10 CO m O O M W 0 O M Ln M O o O O o Cl O O O O O O Ln O 01 O n W O O O O O N Ol O ,Mi O C7, M n 00 O i O O O O O Cl O O O O O O toO O O sv ll} jGy �;I Cb O l0 O O Cl O C Cb N O N N O O Ln O N O O O O O O O O O O O O O O O O O O O O O O O O to O O O Cb O l0 O O O O O O N LO N N Ln O 01 LD 7> f N r P' B C IIIIIIG Iddd.. No �s 7> f r . W C)W S 7ui cl�C, rr7b � sv ll} jGy �;I S i o 61 v �,, GJ CI7,: rXk fll 7 r4 N IliO 7 rl m N N M W O� coco EA 0 O O M O O W O LO co O 7 LO O O O CO n O 7 ,I - OJ W M O O to O W O Cl LO O O irl N W m 0 CM tCcC C:) �o r1l 0 + CD O + + CD O 0 CD C) O cm) O CD >T CD c� ... .... .. . ........ 00 4- m 0 c� c� t: Q, c� C? CD 00 R CD CD c�c 00 Lr) c:l CD CD � CD O C! C? C=l CD c:) C=l -0 c:l c:l CD CD O m Z� V 0 cm LU 0 4E� co Cli LU 1w > LU PP -o Q) E oC: E < NPP O 40 ce m 0 CM tCcC C:) �o r1l 0 + CD O + + CD O CD CD C) O cm) O CD CD c� CD c� CD c� CD CD 00 0 m 0 c� c� t: c� c� C? CD 00 CD CD c�c 00 Lr) c:l CD CD � CD O C! C? C=l CD c:) C=l c:l c:l CD CD q - CZ) cm) CD CD cm) c:l 0 0 0 0 0 0 CD M rlj C:) O M O q q q q q 00 CD CD O O CD O O O O O CD O CD CD C) O cm) O CD CD c� CD c� CD c� CD O C=l CD cm� C=l cm� cmi CD CD c:) c:l CD c:) O O O C! C? C? 00 t: c:) �o r-4 ,J) CD cn O O c:) O = O cm) O C:) C:? cm) O C) O cm) O O cm� cm� cl cm� cmi C) c:) U) Z� 0 LU Cli LU 1w > LU PP oC: E NPP O CIC!, > O Fii 0 O. li :3 E ci:::C Ir a V c: is Ciem" �3 rIX :3 LIJ in U: :x > ui Ll 21 V 0 c), cn m 21 loLr)mc)r-4mc)c) Lf) 'i C2 C2 N O O O `4 7 t- C) r4 r, Ln rlt cci t- m CY) lD �D ro C� ;8 to CZ) cm) CD CD cm) Cl CD Cl 0 0 0 0 0 0 0 0 — = m m t- m m C) n O O O n O Un O Ln 'r IV cy) Ln CDr4 00 r, cy) r-� r-� Ln 00 N CD CD CD CD m Cl CD CD O O O O O C! O C! CD C. CD CD CD CD CD CD CD CD CD CD c� R cl UD c� CD CD t- — CD U) QD c� lq� Lf) N — Lr) CD CD C) CD CD C) CD C) O O O O C? C? O O O c:) = cm) C) cm) = cm) C) cm) O O O O c:? O O O O O O c:) O C) cm) C) C) c:) cm� cmi cm� LO cmi cm� kcL lD t- — Ln C) Lf) QD (1) c�Lri c� Ci N Lr) a) c7l 0 LU LA LU w > C2 0 LiLl, u 1w, m nor E > IS a 1w oll 1A II �10 cid SII :3 0 C!v f EJ ui M WC: ui cl� iv v nr :" r co (NIJ ri 0, C::71 ri; E 0 ................ 11 >2 ce. ........ Q, ru (1) O -0 O u E 4,� M -o N -o E < 40 ce o, -o m 47 E m 21 loLr)mc)r-4mc)c) Lf) 'i C2 C2 N O O O `4 7 t- C) r4 r, Ln rlt cci t- m CY) lD �D ro C� ;8 to CZ) cm) CD CD cm) Cl CD Cl 0 0 0 0 0 0 0 0 — = m m t- m m C) n O O O n O Un O Ln 'r IV cy) Ln CDr4 00 r, cy) r-� r-� Ln 00 N CD CD CD CD m Cl CD CD O O O O O C! O C! CD C. CD CD CD CD CD CD CD CD CD CD c� R cl UD c� CD CD t- — CD U) QD c� lq� Lf) N — Lr) CD CD C) CD CD C) CD C) O O O O C? C? O O O c:) = cm) C) cm) = cm) C) cm) O O O O c:? O O O O O O c:) O C) cm) C) C) c:) cm� cmi cm� LO cmi cm� kcL lD t- — Ln C) Lf) QD (1) c�Lri c� Ci N Lr) a) c7l 0 LU LA LU w > C2 0 LiLl, u 1w, m nor E > IS a 1w oll 1A II �10 cid SII :3 0 C!v f EJ ui M WC: ui cl� iv v nr :" r co m C) C) m C) 0 m 0 0 0 0 0 0 C) + 0 (NIJ ri CN C::71 d; E� + CD CD CD CD CD C� CD Cl CD C CD CL O CD CD CD In ce. CD O O O N O O CD W ........ Q, C) CD C� 00, re) m O C� O 00 Lr) ru CL rl ,I- CD C � r4 Lri 0 C) C Cl CD O O O -0 O O " 00 10 LD V) O m 0 an eu u E LU C WA LU C� > o LU 4v M Ed -o N -o E < 40 ce R -o m 47 E m C) C) m C) 0 m 0 0 0 0 0 0 C) + 0 r, C) + CD CD CD CD CD C� CD Cl CD C CD CL O CD CD CD In O CD O O O N O O CD W rl) CD C) CD C� 00, re) m O C� O 00 Lr) Lr) CL rl ,I- CD C � r4 Lri 0 C) C Cl CD O O O r*� O O " 00 10 LD q - CZ) cm) CD CD cm) Cl 0 0 0 0 0 0 CD C:) C) O m C) O O O O O CD CD O O CD O CD O m O Cl O CD CD CD CD CD C� CD Cl CD C CD CL O 00Lr) C:) cm) cm� r, CD _-z cmi r4 CD CD C) CD CD C) O O O O O O C) C� N O CCD Lr) m C:) O C:) O = O cm) O C) C? cm) O C) O cm) O O C:) cm) cm� cm� cmi CL cm� Cl O Ln CL LrL Lri ;� Z} V) 0 LU C WA LU C� > o LU Ed Irr :3 V > W 3 . IJ C:1 E�. 10 Qj LIJ E U :x > Ll W rt 3 II lE ui cj� Q3 I'M Y'1 Cl fll 0 t 5o Lr) m W, m C: 0 u 4E� o u 21 C) ro O rli N i (NIJ ri CN C::71 ri; E� 0 0 C) C) ........ .. j (,n ........... Tr C7, CD N CD CL m ................ 11 >2 lD ce. CD O —! N rl� O ro Il m ........ CD m CD rl C� CD O C� rl) r". rl Lr) O ru (1) rl) U') -0 Cl CD O 01 W:x Ui W: cl U ) Q: C3, n u I I z k Z F" W E:: ll� V 5o a, M 01 r1i CD rl� O CZ) cm) CD CD cm) Cl O O O O O O u E 4,� M ei -o N -o E < 40 ce R -o m 47 E W, m C: 0 u 4E� o u 21 C) ro O rli N i n m O m CR C) C) C) CD m 00 C7, CD N CD CL m CD cn rl lD O CD O —! N rl� O ro CD 00 LO r1i m co O 01 01 N O G\ u) rlj Ln C) m Ln '1� co lo u) u) CD CD O O CD O CD O = O Cl O + rIj " rIj CD CD C. R CD Cl CD N CD CL CD C� CD cn rl lD O CD O —! N rl� O Il m rlj CD m CD rl C� CD O C� rl) r". rl Lr) O Lr) rl) U') -;I- Cl CD O 01 W:x Ui W: cl U ) Q: C3, n u I I z k Z F" W E:: ll� V 5o a, M 01 r1i CD rl� CZ) cm) CD CD cm) Cl O O O O O O CD 00 LO r1i m co O 01 01 N O G\ u) rlj Ln C) m Ln '1� co lo u) u) CD CD O O CD O CD O = O Cl O CD CD CD CD CD C. R CD Cl CD N CD CL CD C� Lr) Lr) O M CD CD CD CD CD CD O O O O O O C:) C:) O O = O cm) O C) O cm) O O C) cm) C) cmi cm� N CL cmi Ln Ln O M Lr) C) LO LO X-1 0 fillll 1111181 W:x Ui W: cl U ) Q: C3, n u I I z k Z F" W E:: ll� V 5o c ou E: rNX :: 5 0 } : CIl cle C) Lr) C) LO LO X-1 0 c: ol 1111181 0 din >T e. .......... 4- .... Q, .......... R uu W E C: W UJ > V > ui u Ol E 3 M w. C2 v I I O C12 o V E cm 0 co _0 Q) E < 4 ce W, m 0 C) m C) m m N In r-,, m CY) CY) m 8 14 00 OO 8 CZ) cm) CD CD O o O o O O 01 lD N n O C:) = cm) O O O O C:) O C) 01 In cm� 00 rl O rl- 1111181 din ui W E C: W UJ > V > ui u Ol E 3 M w. C2 v I I > �q C12 o rl- C) C) m 0 0 0 CZ) cm) CD o Cr O Cr Cr CD 4� I 0 >T ... .... .. . 4- ........ Q, R -0 O V E cm 0 4E� co -o Q) E < 40 ce E- o as o) < C) C) m 0 0 0 CZ) cm) CD o Cr O Cr Cr CD 4� I (NIJ ri CN C::71 d; E� 0 ce . ........ ru Nis= -0 t O m an eu 4,� -o N -o E < 40 ce R -o E E- O o) < f IH CD O CD O CD O Cl O 0 CD CD CD CD C� r1j N r4 r1L r1j 00 ................ 00 >T ... .... .. . {h CD 4- C) Cl ........ Q, O O C) R C:) C) O O O O C:) C:) = = -0 m m m -bl)- ip, V) O 0 I— In m LU 0 LU > V LU IIS E cm 0 4v co IMM -o Q) V E E 11:5 11 < ui aj 40 ce uj > 1::::7 wCl� E- O o) < f IH C-) r -q CD O CD O CD O Cl O CD CD CD CD CD C� r1j N r4 r1L r1j 00 00 m ifT {h CD CD C) Cl O O O O C) C) C:) C) O O O O C:) C:) = = m m m -bl)- ip, V) 0 I— In LU 0 LU > LU IIS IMM V E 11:5 11 ui aj uj > 1::::7 wCl� C-) r -q f 1! r-i r -q LO T— (NIJ ri CN C::71 d; E� 0 ................ 11 >2 ce. ........ Q, ru (1) -0 O man eu 4,� -o N -o E < 40 ce R -o E E- O o) < f 1! r-i r -q LO T— 0 u u 4E� o u C) m o Cni m o (NIJ ri CN C::71 d; E� m N rl 0 C:) cm) Cl rlj -6 r 4 r C) rlj + + a, ON ce + . 0) 0 cs 0) ON ........ Q, 4jT rl� U1 O O c/1 nra ru cl 0) CD Cl 00 m ifF m lfl -0 NV: O O l0 IR LU C EA Hi WA O 0� 0 CO x IIS an eu diN 4,� M -o N -o ai cu E D 1111 < 40 ce R -o Sns V E E- o o) < 0 u u 4E� o u C) m o Cni m o m o m N m N rl C:) cm) Cl rlj -6 r 4 r C) rlj + + a, ON + + CD 0) 0 cs 0) ON 4jT rl� U1 O O c/1 nra cl 0) CD Cl 00 m ifF m lfl NV: O O l0 IR LU C EA Hi CZ) cm) 0 0 CD 0 CD 0 cm) 0 Cl 0 C) cm) 0 0 C:) cm) Cl -6 r 4 r C) m m m a, ON 0) 0 cs 0) ON 4jT N r -q C:) 0 C:) 0 = 0 cm) 0 C) cm) 0 0 C:) o in In in 0) 0 cs 0) ON 141 c/1 nra 0 LU C WA LU 0� 0 CO x IIS diN ai „gipV D 1111 Sns V uj cl� N r -q W, m u 4E� O rn Lr, Ln Ln 1A Ili 0 On q mro dP ................ >T mro ... .... .. . ........ 4- C1 � 00 C) co rtD Q, I'll ai LLJ ::) �n Q R CD CD CD Cl O CD O O O C! O C! CD CD CD CD CD CD CD C� R ro -0 CD Ui CD In Ln CD I'l In m U) 00 co m EA iA CD CD C) Cl CD C) O O C! C? C? un C) C) V E cm 0 4v co -o Q) E < 40 ce 07 47 W, m u 4E� O rn Lr, Ln Ln 1A Ili C:) C:) = cm) O O O O C:) C:) cm� cmi Ln Ln m ILI) 00 4- O On q mro dP rl� mro Ol C1 � 00 C) co rtD V > V I'll ai LLJ ::) �n Q �>1 WN > uj IJ: cl� CD CD CD Cl O CD O O O C! O C! CD CD CD CD CD CD CD C� R CD Lrl CD Ui CD In Ln CD I'l In m U) 00 co m EA iA CD CD C) Cl CD C) O C! C? C? C) C) C:) C:) = cm) O O O O C:) C:) cm� cmi Ln Ln m ILI) 00 4- 0 3 mro dP mro :3 Y..... rtD V > V I'll ai LLJ ::) �n Q �>1 WN > uj IJ: cl� > LI II'II 0 3 W, m 21 0) IN m 00 cq IR O � M Il C) N 00 Il M m M rlj rn 14 00 O ID 1A CZ) cm) CD CD 0 0 0 0 M C:) C) C) �q O O O t - S4 Ln Lr1 C:) O (NIJCN ri C::71 d; E� cm) O 0 cm) C:? C) C) cm) C) O ................ 11 >2 cm� ce. Cl Cl O Ln O Ln ........ Ln C) OIL Ln Ln ru (1) -0 O LU iw an eu u >LU 4,� M WL WJ _0 N _0 E < IIIA 40 ce 0, -0 m 47 E W, m 21 0) IN m 00 cq IR O � M Il C) N 00 Il M m M rlj rn 14 00 O ID 1A CZ) cm) CD CD 0 0 0 0 M C:) C) C) �q O O O t - S4 Ln Lr1 r -q C:) O = O = O cm) O C) O cm) C:? C) C) cm) C) O cm� cm� Cl Cl Cl O Ln O Ln Ln Ln C) OIL Ln Ln LU iw >LU WL WJ IIIA Qi th V E ad :x :3 rwl uj CLI E > W n, g: > ui U cl� 0 W r -q W, m 21 cq o o v^i v o 0 0 01 O Ln 7 O 01 W O n O O 17 M M 7 + O O z3- N O + O O + N M + u + + O O .--I Om O I, O 00 O O lT N O O Ln O O O M l9 O In O M o o in M m O 0 o co 0, o m o M � W O O O O O O O W a� O O M j- W 0` .-I- O O O 10 O O N M M � 0 0 0 0 0 Cl 0 Cl 0 0 0 0 0 0 0 0 0 0 O O O t: 7 LD O O M Ln N OM O N 7 O Lf) N Cl 0 0 CD O o 0 0 Cl 0 o O o O o 0 0 0 0 0 0 Ci Ci Ci Ci vi Cl o O O O O N Cl O O O D\ O In O U) Lr) O Lr) Il O MN .Ni N N O O Lr) O kD O O O O O O O O O O O O O O O O O O O O 0 0 0 0 C) 0 C) 0 C) 0 0 0 0 o C7 o C7 0 0 0 o C) vi o C) O O O O N O O O O T Cl lf) O Ln Lf) W Lf) 1l O M .--I N N N O o Ln o ID m 0 S' B C"NIJ CN 1C::71i ri; .. C IIIIIG Iddd.. SID '' R ® K� �C �d1„�����. . .. mwm "O Cfl V l �..... ru Q C G IM"9 � iµ'Vi W "C C 2 :x U C A ii7 I I7 " I1 1,,: YIX 1;,7 "x-Yt 1U leb I�d YII y l rGt 1 F" CIl F � 111 Q C S Y � w14 nS CIl : 01 II„ " CI1 Y) „m O ® u C uu c r0 ® E V W L � d V V M v c V N - m C � (U Qm 40 ce C C�C Q C C C m 47 E W, m 21 cq o o v^i v o 0 0 01 O Ln 7 O 01 W O n O O 17 M M 7 + O O z3- N O + O O + N M + u + + O O .--I Om O I, O 00 O O lT N O O Ln O O O M l9 O In O M o o in M m O 0 o co 0, o m o M � W O O O O O O O W a� O O M j- W 0` .-I- O O O 10 O O N M M � 0 0 0 0 0 Cl 0 Cl 0 0 0 0 0 0 0 0 0 0 O O O t: 7 LD O O M Ln N OM O N 7 O Lf) N Cl 0 0 CD O o 0 0 Cl 0 o O o O o 0 0 0 0 0 0 Ci Ci Ci Ci vi Cl o O O O O N Cl O O O D\ O In O U) Lr) O Lr) Il O MN .Ni N N O O Lr) O kD O O O O O O O O O O O O O O O O O O O O 0 0 0 0 C) 0 C) 0 C) 0 0 0 0 o C7 o C7 0 0 0 o C) vi o C) O O O O N O O O O T Cl lf) O Ln Lf) W Lf) 1l O M .--I N N N O o Ln o ID m 0 S' B C IIIIIG Iddd.. SID S� BA l C G IM"9 � iµ'Vi W "C C 2 :x U C A ii7 I I7 " I1 1,,: YIX 1;,7 "x-Yt 1U leb I�d YII y l rGt YNF I'1 cr1 u r., YNIc:;k F" CIl F � 111 YN�k YNk rr• S Y"a r k S Y � w14 nS CIl : 01 II„ " CI1 Y) r,N O N n CT O 7 0 .Mi M ID co H} 0 CD CD O O <R 0 LO IJLli N M roro Ln rl rn T 00 00 00 m C:) C:) = cm) C) 0 0 0 0 C:? C) cm) (NIJ ri CN C::71 ri; E 0 0 0 0 ce . ........ LU ru WA O Nis= -0 t LU aero CD O m u E 4,� M mi -o N -o cu E V W < of In 'ID W 40 ce ui R -o E lid z ui :x 11 E- O o) > < 00 00 00 m C:) C:) = cm) C) 0 0 0 0 C:? C) cm) 110 r -q Ln D 0 0 LU WA LU E LU aero CD mi V W of In 'ID W m ui lid z ui :x 11 > nc ui 1:3 c 0 110 r -q C) C) m m m C) ri C� C� I: cl�) C� Ln Lr) + + CD O (114 �-! O C) C? 0 CD CD CD CD C �D —� CD CD C� CD CD Ln m Ln >T O O t: cD ... .... .. . . t. .......... CD CD NO 4— CD C) O O .......... 01 ;2 CD �o oo R -0 U) Cl 0 O U m LUO C u E WL, LU LU cm LU 0 4E� co mm -o E < 40 ce +19 C) C) m m m C) ri C� C� I: cl�) C� Ln Lr) + + CD O w �-! O C) C? CD CD CD CD CD C �D —� CD CD C� CD CD Ln m Ln CD O O t: O1-� Lni O CD CD NO Cl CD C) O O Lr) 01 ;2 CD �o oo Lr) Il 0 0 CD O O Ln cO O q- rl 00 00 0 q- Lr� cz) cm) CD CD cm) Cl O O O O O O CD C) CD �D Lr) C) O q rl) r� M rl It- �� rl Ln CD CD O O CD O Cl O O O CD O C) C? CD CD CD CD CD C �D —� CD CD C� CD cm) In cm� Lni Cl CD CD C) Cl CD C) O O O C! C? C? Ln t: 00 r, CL Ln ,J) O Ln ,J) 1p LO rll r -q C:) O C:) O = O cm) O C) C? cm) O C) O cm) O C) cm) cm� Lni Cl kcL Ln ko �o U) 0 LUO C WL, LU LU LU mm +19 PNIc :3 994 V > 1:1. 3 C3 C: M w i 13 II II LIJu �n z :x > uiN > Ll > ui rll r -q W, m 0 C) m m C) 0 0 0 0 Ln CY) Ln 00 0 In m 00 Lr) 0 ID 0 0 r*� ri O O O 00 O CZ) cm) CD CD O O O O CD m CD C) (T1 cq O O Ln CD �9 cm) 0 C:) 0 = 0 cm) 0 0 .......... 3 (f) ........... ................ >T C) ... .... .. . ........ 4- 14 Q, 14 N M Ci R (1) rl) CL Ci N r-4 r4 V) Ha uu J U -0 V) 2� 0 O LUO C V E UL, LU W > lu cm C qd 0 1w, 4E� co -o Q) cuE < fillll 40 ce m at W, m 0 C) m m C) 0 0 0 0 Ln CY) Ln 00 0 In m 00 Lr) 0 ID 0 0 r*� ri O O O 00 O CZ) cm) CD CD O O O O CD m CD C) (T1 cq O O Ln CD �9 0 N CN cm) 0 C:) 0 = 0 cm) 0 C) cm) C? 0 o 14 14 N M Ci (1) rl) CL Ci N r-4 r4 V) Ha V) 2� 0 LUO C UL, LU W > lu C C qd 1w, fillll ii v E o > 0 U II ui ui E >W Wol raps', lE y.f Yo 0 0 0 N CN W, m 0 u u 4E� o u 21 8 m r, m m m 0 OR 0 0 0 �i 1`1� C7, 00 ED Ln r1j M ri d; E� CD CD cm) O C) O + ISA = Nil = + ................ 11 >2 CD ce CD . CD O O O CD r, ........ cm) CD 00 m CD 0 CD Ln CD R a, Lr) ru Lr) 00 Lr) Lr) Ln r1i O CD CD C) -0 CD C) O O O O O O (n 2i O 0 u E LU C LU WA 0 .2 2: -d LU 1W > LU PP 4,� M E W _0 N _0 E < NPP 40 ce IIIIIIU 0, -0 PP m 47 E W, m 0 u u 4E� o u 21 8 m r, m m m 0 OR 0 0 0 �i 1`1� C7, 00 ED Ln r1j M C) + CD CD cm) O C) O + = oo = + CD CD Ln CD 0 CD Lq O—! CD O O O CD r, CD cm) CD 00 m CD 0 CD Ln CD R a, Lr) Lr) 00 Lr) Lr) 0 L� O ti O O O CD cm) O C) O cm) O = oo = = oo M C) cm) Ln lt� M CD CD O C, cz) cm) cD cD cm) C, 0 0 0 0 0 0 CDC)i:�-Mmm Lq O= C:) O O O O CD cm) O C) O cm) O = = = = cm) C) cm) Ln lt� CD CD CD CD O C, O O O O O C! CD C. CD CD Lin CD Ln CD R LrCD i CD C CD C� r, Lr) Lr) Ln r1i r, CD CD C) CD CD C) O O O O O O 00 ol� n N O Ln ,J) Lr, Ln a) r -q C:) O C:) O = O cm) O C) C:? cm) O C) O cm) O = = = = cm) C) cm) Ln lt� cmi Lri C1 C1 Ln a Ln a� ko 1`11 � Lin Ln r, (n 2i 0 LU C LU WA LU 1W > LU PP E W NPP IIIIIIU PP fillll th :3 o u th U :3 uj :5 cGJ:: II II 10 W> :3 0:, lit > uj W tY fY,Y 7Y fXkE 10 V a) r -q C) yq M U) ri rll� C) O co O 00 O 00 U) 0 ED Ln ................ >2 Lr) ... .... .. . ........ 4- tR Hi CD CD CD Q, O O O O O O CD U) In m CD r1l O C C� LU -0 CD CD C) Cl CD 0 C! C? C) C) yr O V E E E GA G th cm 0 co CIL E _0 Q) 10 1:15 cuE 5`y < L'iU 4 ce >Ib W 01 1::: :7 cl� m at C) yq M U) ri rll� C) O co O 00 O 00 U) Lr) 0C:) ED Ln Ln Lr) 0 tR Hi CD CD CD Cl O O O O O O CD U) In m CD r1l O C C� LU CD CD C) Cl CD 0 C! C? C) C) yr C—) (14 ,=, 0 C:, =, 0 0 U) C:,=, 0 Lr) Lr) 0C:) N N JA 0 C—) (14 U) D 0 F- IV LU LU > LU E E E GA G th CIL E 10 1:15 5`y L'iU UJ >Ib W 01 1::: :7 cl� rXz I 1 14 C) C—) (14 W, m C uu C V 21 M 7 Ln In M O .moi W M N .-1 LD N Lr) o Ci t - v rn v m N N CDMCDM Q N O1 Ln Q M N D D M O I� N M O1 Lr) M Ni Lr) N .Mi N W 111 N N Lri Lri O O � N O o O o O O O o 7 O O N �D W O 7 O Ln N M O O O O O O O O rl O O O O O In 7 Cl ll �o .Mi m N .^ O O O O O O O O O O O O O O O O O O O O O 0 Ln In .Mi N O i ri; .. M II��II��11 db 2 a ® 0� C) m o V ..... ru Q uu" S b rLJ w�c 1 a e 3 Q C Yrr W c CIJ DNXUJ S W rIb^ oll nc m, O ® u C an eu u c �0 ® E V W C C �L v C C3 N _ m C � a1 Qm 40 ce C C�C Q C C C m 47 E W, m C uu C V 21 M 7 Ln In M O .moi W M N .-1 LD N Lr) o Ci t - v rn v m N N CDMCDM Q N O1 Ln Q M N D D M O I� N M O1 Lr) M Ni Lr) N .Mi N W 111 N N Lri Lri O O � N O o O o O O O o 7 O O N �D W O 7 O Ln N M O O O O O O O O rl O O O O O In 7 Cl ll �o .Mi m N .^ O O O O O O O O O O O O O O O O O O O O O 0 Ln In .Mi N O n n O iri m w O n N n O N Vi COO O O Cl N O Zf O O O m O1 O M LO m to O rlj O1 C Cl O O O irl N LO N M II��II��11 db N uu" S b rLJ w�c ru a e 3 nip Yrr W c CIJ DNXUJ S W rIb^ oll nc m, :7 n n O iri m w O n N n O N Vi COO O O Cl N O Zf O O O m O1 O M LO m to O rlj O1 C Cl O O O irl N LO N M. 31 Rl aj a Q e O I M m Ln ID o Ln � � rm M y lD en o IDo vi o Di en ri Lo N M06 o a;N N M co W N N 7 In O Ln LQ O 7 .moi pJ W O\ n O O (Ar1i O O O M O r-4 ,Ni N N M OJ D Ol O i Ln 7 N N O N L m O In 7 N O .--i N + Ln O N M N N N N N M M + + Il W N Ln Il O t- 10 .-1 O M m O O O O W M n t: l0 O n O O Ol N O O O Il M M In 7 In n n O l0 Ol O m .^1 n N n O n 7 N O D\ Ol ” O 7 N Lfl 7 M lD O M,moi l0 7 W M N O M l0 I\ M In rljM 10 7 .^i O ko OM M N O 1l 7 0 O N n N M N .-I Ln 10 O LD O eT O .-I O O Ln O O -! Lq N tD 5: a� q: 6� O O W O n O ul M (71 n a, .--6 1l co M M l0 M c0 O l0 .-I M 1l Lr O Ln O etl n n .--6 c0 0o 1, n tD O l0 M O� LD N lD ID O O Il O 1l O O v O O ID +--6 O Ln O 0 0 O OR O O cD o O .-I rn o N O . o LM Ill 14 lDn lD rn D` ID n l0 N .--i N M N O O O .ti In CO ,-I m V M N co O O M N O m O l0 7 O` n .--I n W Ln O O l0 O O Il O O .--6 Il m ID n 7 O 10 W M .-I c0 O m Lr Lr N � M .--� O O Lfl M M I;r ol W O m O O 7 M c0 lD M M 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 O O M M ,-I O 1:3- 10 M O N O N 7 .--6 O M l0 N - n O N N N O n Ln N O u'1 O 1p Lr .-I .ti ll . --6 [%1 Ln .I O t0 O co N M lD M N 01 ^ lD M M l0 00 In u'6 Ln 10 m07 N O m 10 O n n m co 01 M M n er N n M — 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 C3O O O Ol O O O O O N O O M VC1 N W .-i M 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 . . . . . . . . . . . . . . . M l0 N Lr O N ,Ni N O .^i M N O lfl al lD Ln lL 0 � (b LIl nZ. l0 O m N O ID It N Ol Ll lD M In 7 eO In 111 Ln lD.M1 CP N W O 7 Ln Ol Il � en co o M M r-, l D\ N n N 7 N of N ih co O M O Lfl ter O 7 tDM M co LD O W {f�- co 10 N ol ol fPr O Fi W 7 ID 16 0 of W N ID +R N rn Ln O Ili N N fD N ih 00 M n O yr O 1010 M li} 7 M V co ID O co W LD LD N Ol ID O O O t- LoLo rl co N 0 S,1 CC1 C7 i :M VPI T +P1 fld,9 � 6!:V 111 Z W W (,"PI FJ I' 0 +Yb I norD Q 1111 vPl } f1Y ,1„° ? ""a iXX ITwuLC3l Pa I CYI ti le"1 r� F :: nH I Y"i UJb yX cy] y Y=.4 II CIl CIb Y*b c e7 C13 k Hill f . +'Y,b 0 UI r"rt L I" a,C a'? 6rJ :s jr4 Nen' i!: N 7 N of N ih co O M O Lfl ter O 7 tDM M co LD O W {f�- co 10 N ol ol fPr O Fi W 7 ID 16 0 of W N ID +R N rn Ln O Ili N N fD N ih 00 M n O yr O 1010 M li} 7 M V co ID O co W LD LD N Ol ID O O O t- LoLo rl co N t (11,111 o - + 0 rw) C Entl rl + + ................ > . > ce CD ............ ......... . 0 0 0 CD 0 0 0 c: ........... < ........... ; L D c C) r4 N ru > C7, ol� r1i lD tZ CD CD Lr) t 4. CD C) O O O C=, O O O 11", rr (A N v � ) Cd M C! O O O O O O 00 0 U _0 _0 tl E tl -0 T < CL x uj o C) C) C) = m C) C) C) C) C) C) m C) C) . . . . C6 + + o o - + + + + C r1l rl + + C C� of cc� C> 0 0 0 0 0 CD 0 0 0 q q 0 q 0 C) r4 N CD C� C7, ol� r1i lD tZ CD CD Lr) CD CD CD C) O O O C=, O O O 11", rr u C:: 10 :5 qk fll N v � ) Cd C)CCCC>C:lc> C! O O O O O O 00 C) C) 06 ,J) CD C) C) fH tFr D 0 0 0 CCC C)OOOC>C)C) O q q q O C r1l C> C C� of cc� C> Ln c) N o r -i tZ CD CD CD C) CD CD C) O O O O O O O C:) C:) 0 0 C) 0 C:) 0 C:) 0 C:) 0 cm) C:? O 14 Cl cc� Ln c) N C, C, !!!!!!!I tZ �V r4 C!� c!v U, z Lu CL X WQ :3 tj M c w° '13I"A n :x Will c C: 0 (:tl rNXU Hill 11", rr u C:: 10 :5 qk fll j lill v � ) Cd 0 W M. 31 7 It u Rl aj a Q e O I C'n O O O O O O T n O 7 0 0 o Il 0 0 o Ln o v, N N O 7 01 m of Ln LO lD lD lD Ln m I� O + N + +O + o + + + .N -r + + + + + O O Cl LD Cl O O O O to lD O O O M O O O O O M M O O O O O O O C. O CD O co 7 CD O r1i N O Cl Ln ro m 00 co .N1 .ti Ln O UD nz. tD N 7 l0 7 kc 7 l0 +A lA O O O O O O O iD O Ln e+l O • O O O O O O N O � N N Lf1 lfl D -;r O Cl 10 N N O O O N O O O O O O O O M O O O iD O O O O rl M M O O M M M n O m O Ln LO co O O O V? {sr O O O co O O O ID O 7 7 O O O M O O O C� O M M co O of ol O O of Cl of cl 7 u i u'i M M M O O O N O O O M O N N O O O Ln O O O O� O Ln en O O O O n O co O O O O O N O O M N .--I Lr .-I u'e NO Ln LD LO n t^D rl .--i O O� N O O O EPr H} O O O n Cl O O Lf1 O N N O O O Ln O O O CT O LQ Lq O O O n O O O O O N O O n lD Ln o1 LO C Ln O O m N N N .M -i ti O O iA iA 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 C 0 0 0 0 0 o lD Ln LD Ln lD en 0 o Ln Lo m r -i m tYi m i .N1 N 10 O Ln .N1 7 O N N n 01 eT V) cl, p I-W....% L1 T.... Z IA LU 1w, IL S; X ��^.D� W VAN N�M^P SWW u fl .r;;i IL..V i+ C.1 rIb I"" ° CI1 ',1° V I"" W CII IY t.,ll F°rw Ull KX 'Y X°X f": W d xNk Yr'i W Cl Y1,. +SII Z ru CIi r c!'V W r,„j Ilil !"'„t 11111 11 11 II:I a” "^ CL MN S K5 (I',j a +A pl C'n M. 31 5 It u CD C) C) 0 cm CD C) C) 0 cm C) C) M C3 LrL ,I - 1A C) 0 = 0 = 0 = 0 = 0 = 0 = 0 cmi cm� CL Cl C) ID ko UD 00 r',�. r1i CCL rlj C� co 00 m ,J) (n 2� 0 LU C V) !U Z IA LU IL x E w 0 IIIIIIV� .Iwo rr rr far 1w LU > In U) w 2 :3 (111 z :3 ra C, CL x M. r F M o 0 0 0 0 D o rn o 0 0 0 r C Il m M O n M .Mi O tD O � o 0 0 O + S .--I N O 'l- + 10 N iD ON O N o Cl v m O O o in o 0 N O O O N O lD O O N O lD O CA I N O In 0 N �o M Ln In O CD c 0 N 7 In N LnM O O O O O O O ti 0 0 0 0 O 0 0 0 0 0 0 M m N O CT D O O O O O S .--I N O 'l- 10 N iD ON O N o Cl v 7 M IP1 Vl m N In O O O O In O O V: o 0 0 0 0 0 O �D c 0 T In 1`1 CT N LnM O O O O N O O co .--i N O O tD W ON O u�i O^i 7 M IP1 Vl m N In O O O O In O O O O O O NO O O �D T In 1`1 CT LnM .v~n N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m N O O LD D N O O M In In O .N1 N O t - L, 16 00M 0 rn M M n N M O N O co N 0 D1 W Lnf J H � III W Z W X w Ij n N CT O Ln N O O N !R 0 T W In tPr ?,1111 .Iwo u� .v~n Ir �q V .j I �tNR rc na n , T �] Jw"Lb CI1 II II y.' UZ) z rig i, m�!',u w r rwa o a CL n7, , t uu, IZ W e y YNk rdX s r F M. 31 7 It u aj a Q e O I o m o I`1 m m m N en ro M M 0 m7 rn Ln 01 ti M m ID M M 10 M n co M In O.^ 0 0 + ul I, N N Ln -r + N 01 N Lfl 7 M + l0 N N 01 O ID O lD N M I� O W O O In m In Ln O n .^i N CD 7 CID N �D t .M1 O O O O O L!1 01 N In t- lD � .--I M M O 7 O 7 M 00 M I� n Go .--i n M lD [V N O -! O C�l `3: � .J�a N .-I M r, O 10 n O 01 O a, lfl M O n O � O I� M Lf1 n O O O O O O O N i0 07 O" 0 0 O M 7 07 00 Ln 1- m 01 N Lfl 7 M l0 N h O .--i n lD N M M M O O O O O O O M '-I In 10 � .--I M M O 7 O 7 m O 00 M I� n I, O .--i n M lD [V N M 01 ti CIl � .J�a O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M Ln lD m O 7 Ln O M 1� h O .--i n lD N M M 7 0 14N 00 N 0 W O CDN N 7 Ul O 7 {ft O M H co O N (A 00 ID 7 O M EA O 01 lf1 01 v- cDO O I 0 M Idd6.. �1 6::P'r ...... cry �V cry r7 M iii CIl � .J�a a� D r 11 r11 N,�' ID 4J, IXk N d1) fll CID Z Ci"7 rYb % rXk �"��1' LU Nr,i ryb J CL II II,.I V% Cqr 1" C) r^3 W Gi 6 0 14N 00 N 0 W O CDN N 7 Ul O 7 {ft O M H co O N (A 00 ID 7 O M EA O 01 lf1 01 v- cDO O I M. tc t tlE cr -0 T Q1 d 0 O C� CD 00 00 r, co rl) EA Lr, m ID 1A O C) r� Lri r,4 V: rl r -i Vi Lr) r, r1i rl) 0 14 ko Lr) CL V) 0 F— LU V) 2: LU IL X uj r- 3O IX E U W 0 9!!!!:V Lu U) Z LU CL X PnntN :3u M U rIX Cl 0, K5 rCl 7D O C� CD 00 00 r, co rl) EA Lr, m ID 1A O C) r� Lri r,4 V: rl r -i Vi Lr) r, r1i rl) 0 14 ko Lr) CL V) 0 F— LU V) 2: LU IL X uj r- tIII I'll, arra ............. . CD u.> .............. 5 ......... . rV cry r . ........... c < ........... ; cn ro > t U mm 4. _0 mm fA M u n 119 rYv tl Ll CID ic 0 113 S. U c!� LU ED ch CL X _0 _0 tl IZ LLI E Z7 'C' CD [A U u c: -0 T Q CL x uJ o M C) M = M M C) C) C) ti + + + + + + + + O CD CD r4 c:l CD CD CD C) O Ln 00 T O O O q: O O O O O C) C) CD CD CD C) C) C) (D O O O O O O O O O DOOVOCCCC r-i c)OOcc>c)c)(Dc) O CD CD CD C:) c:l CD c:) CD c:) O o 0 0 0 0 0 C? C! c:) C:) 0 = cm) = cm) = c:) 0 0 0 0 0 0 C:? 0 C:? Ln M Kq� nd arra cry cn w 11)Vii n 119 rYv CID 113 S. c!� LU ED CL X IZ LLI Z7 'C' r0 ) U u M Kq� C) C) C) = 0 0 0 0 C) C� C) C, I C) C� C�yr to C, 0 ID -V� C:) C:) = = 0 0 0 0 cmi cm� cm� m m C !i LiLl, ............. . C u.> .............. ......... . V r . ......... . <..... ........... ; ra.p E V Cl U Zy U 1111 III ro > M . t I:rI mm 4. -0 1 mm fA C, m Nis= u Ic I c I c Ll ic 0 U Ch _0 a) tl _0 E CD [A cr C: -0 T CD CL x uj -0 o -0 C) C) C) = 0 0 0 0 C) C� C) C, I C) C� C�yr to C, 0 ID -V� C:) C:) = = 0 0 0 0 cmi cm� cm� m m C !i LiLl, V IV LU (f) z LU CL W Ir CL E 11111 rlb J� 10 a 1 1 M ra.p E V Cl U Zy U 1111 X tIII I'll, C:) 0 = 0 = 0 cm) 0 ............. . CD � u.> .............. 5 ......... . rV cm� cmi r . .........c . < ........... ; ..... III V) 2� ro > M . t I:rI mm 4. -0 1 mm fA 0 [- m Nis= LU u U) C 2! !2 LU D- X IIS Ic I c I c Ll ic 0 U LW AA P�9 Ch _0 a) tl _0 E CD [A cr C: icr WAA -0 T CD CE, CL x X3 uj -0 W o -0 C) 0 0 O q q C) C) C� CD CD CD 0 0 0 C r -q LO M C:) 0 C:) 0 = 0 = 0 cm) 0 cmi cm� cmi 1� in V) 2� 0 [- LU U) C 2! !2 LU D- X IIS LW AA P�9 II icr WAA CE, V X3 W 11113 Lura R; cH c! LU CL M X LLI r. lill Coll C r -q LO M tIII C) C) I'll, C) C) CD CD C) C) cs C; ............. > . CD u. .............. 5 ......... . rV m + + o r c . ......... . < ........... ; C!u ..... IU Ca. W V C. CD ro > CD M 0 . t I:rI mm 4. C> CD C. CD C. CD -0 1 mm fA C, C�Dl M 01- 01 u (=)Cccc>c:lc> C� O O O O O O Ic I S I c Ll CY, m frr a, yr ic 0 U Ch _0 a) tl _0 E CD [A cr C: -0 T CD CL x uj -0 o -0 C) C) C) C) C) C) 0 0 C) C) CD CD C) C) cs C; 'A C. C) m + + o + + CD C!u LU IU Ca. W V C. CD CL LLI CD 0 CD C� C> CD C. CD C. CD C�Dl 01- 01 71 (=)Cccc>c:lc> C� O O O O O O CY, m frr a, yr C) 0 0 0 C> O q q q q C) 0 0 C) 0 0 C� C� C� C!u LU IU Ca. W V IZ CL LLI tIII CD O I'll, + r4 LQ Ln ............. > . 00 0 F, CDlu. .............. 5 ......... . rV r4 O I -q q q O CA r c . ......... . < ........... ; 0 C. %D rrL ..... CD ll:� M Ln ro > r, r4 M C) Ln . t I:rI mm 4. -0 1 mm fA C, V) Nis= Z WA u LU a - X Ic I S I c Ll En ic aww Ch _0 a) tl _0 E CD [A tl cr C: -0 T CD CL x uj -0 o -0 C) Ln m 0 m m C) C) C) 0 C) C) C) m 0 0 C> Cl O M O O O� rl) C) CD CD CD CD C) O O O O O (D ;i 0 0 0 CD c� c� c� c� Lr? co rIj oo rl) qqqqq,n O o c c c) c c c O oo r -j CD CD O O CD O C) O + r4 LQ Ln 00 0 F, 0 0 CD r4 O I -q q q O CA 0 a) 0 CD 0 0 C. %D rrL CD M CD ll:� M Ln CD Lr) r, r4 C) m 0 0 C> Cl O M O O O� rl) C) CD CD CD CD C) O O O O O (D ;i 0 0 0 CD c� c� c� c� Lr? co rIj oo rl) qqqqq,n O o c c c) c c c O oo r -j CD CD O O CD O C) O Cl O r4 LQ Ln 00 0 C:) 0 0 CD cm) C) 0 0 0 0 0 0 c:� Ln LcL C) Ln LU Lo C) Ln C) ,J) N r-1 Ln 0 0 LU V) Z WA LU a - X ui 0 En aww P9 V 10 IU a) "A E LL, ,J) Ca. 1� W C!V Z LU E :31 V Ll X3 CL 'Y' j N r-1 tIII ri ICY) ............. > . CD II p .............. ......... . r . ......... . <..... ........... ; ro > M t Cr c mm _0 mm fA M u tl Ll ic 0 U Ch _0 a) tl _0 E CD [A cr C: -0 T CD CL x uj -0 aj . 0 -0 u SII Lu CL C4 J) �i I:x III c!I, Lu E:: CL 0 IZLlj C3 j m M r -q co M t111 110 C:) 0 = 0 = 0 cm) 0 0 0 cm) 0 C) 0 C:) 0 C) 0 cm) 0 ............. > . CD 0 CD ............ .............. 5 ......... . rV r . ........... c < ........... ; tl Loi cm� Li cm� ro > cm� C:L . t C) fA C, C) rl) 00 0 M 10 M 00 ID M CL m Ci tl N cli Ll Ch _0 I w _0 E cl, CD [A tl C: 0 -0 T CD CL x uj o C:)C)C)rlmmmmmmm o Cq o In C2 0 0 0 0 0 0 C) Ln C) m t- M C) C) 10 74 l7i a) 'I 74 7i CD—O� ... C)C)C)+ . . . ol + + 0 0 0 `4 CD CD 0 CD 0 CD CD O Lq q cq O q O q q O q C. In CD M CD M CD C. m CDCD 00 Ll rL Li I C� ll� O1 — kD CD rr) I'll kD ko 00 C) 0 0 X C> Cl C> Cl Cl CD (D O LQ O -!O O O O O O OV- to C) 10 N C) %0 cc� cy) r, .2 O CD CD CD CD cD CD c) (D c) cD O O O O O O O O O O O (DOOOOCD0C>0C)CD o Lq o o O o 0 0 0 0 0 v - lo lo C)OccC>C)C)CDC)CDC) O q q q q q q q q q q C) 0 0 0 CD of C) L'C)COO C)ODC) i C� C� C� lzl� C� Or. O MDo C lo co ol rl) "D cD CD CD c) Cl CD C) cD C) cD cD O O O O O O O O O O O r, C) 4A 0 LQ ID 'r C:) 0 C:) 0 = 0 = 0 cm) 0 0 0 cm) 0 C) 0 C:) 0 C) 0 cm) 0 C) 0 CD 0 Loi cm� Li cm� cm� C:L C) 1- C) rl) 00 0 M 10 M 00 ID M CL m Ci N cli cl, 0 — Fau LU (r) Z pal LU IIW 1w, Mmm V C!v 19 W to L:: E M W E3 V o 11) OD lip li"II IU E X3 ou L.0 II II A L✓ E xGl ID CL 11111 U :3 IZI,J uj al o 0 CO o W CO M. 31 7 It u N d Q e O I (b N O lD � Q1 N O O Ql O N lD O O O O O O M 7 � 7 N 7 W O O Lfl O Lf1 I� O O O O O O M 14 111 n 111 M lu l CP 7 O ri M N 7 M (T Lf) 01 O N eT 01 .--i I, CT 7 7 7 2 Ln N M .-1 Lr ltl N .moi N l0 r,Lrl .N -i m N+ + M O m lD + O O O + + N IN N N N ll') + + N .--I + 01 + + + + + + + l0 O (b m .-1 m CO O O O O l0 M O O O O O O �q 01 N !T N O O O O CO W O O O O O O O m M O O\ M N co Ln 00 .ti O M ;; i O l0 Ln l0 M n O co N M (b O O O ,^i 01 .^i O\ 0l O O M N O M O .-i M (b .Ni n .-1 O n liCD Ln M m n UD .-1 7 M In lD UD Ln V O N N 0` Lr1 LD O O W O Lr1 m O O O O O O M OR i0 O n 0` O_ O O O O n O O O O O O 1`11N 01 N LD n .--1 a C:) . N ltl K O O N 0l Lr1 M n ID(n O .-I O n W 1IZ. l0 N .--I O N 0` lM N l0 O O O M O O LO O O t0 O O 01 O O O O O O O O O .! O O o O O 11� O rn O O O O O O . CD q- 1`1 10 N Lf1 L�f1 1� In O M 01 lcO Ln M n 01 n 01 u'f n O O O O 10 N O O O O O O W 01 W n O N O O O O O N .--I O O O O O O 7 - In V 01 7 Mm lD O O +--I 01 01 O W 7 l0 01 O M N t0 M O1 M1p M N .ti (b Go O O O O O O O O O 7 O O O O O O O O O O O O O O O O O O lD O O lD O O O O O O IXI N W n LD .--I eb CD ltl ID O O .--I O M Lf1 7 .--I .-I M M N N Lf1 01 O M O N n N lD n lD 11 N .--I lM O M O lD N10 10 ID O 01 01 — r IN M W .--i lM lD � In N ^ 01 M .--I 1`1 M 7M co .--i .--I N lD .--I - N ID N co M O O O O O O O O O 7 O O O O O O O O O O O O O O O O O O 10 O O l0 O O O O O O . O O N O N In 7 ti N 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 0 o O o O O O o O o O o . W N CO ,^i l0 +-i CD O Lnl0 M L!] M M O N ,moi O O M O N n N lD n lD O O O M O ID n CD ID CD O 01 O .-I 7 O Ln WLO ID t- Lnm m .--I 1`1 ro 7 01 W .N1 ,^i N Ln .Mi N Ln 10 N co Ln O Ln N IDO n M ko W W M 01 O W O 00 M O N y} M 10O CD5- "i M 7 N (b In N 0 N N M O M 111 O N N Ili 01 n M ID ID (b W M 01 O 1f} W O co M O [V M O V M M 7 N cc N 0 N LON M IDO m w d `r O LU T,... � II„II LU CL x W S, ILII n"A'k .Iwo I6�V O S U) rl X111 u.lti.. 0 n,b flfl8 a�yro P„�1 cn V Miry M I",i,iV II II U1 LU W CIL¢ i � J1 PP7 Yr'4 rv,l YbIk fl"Y yy rYA II II G ; .” tC I., M” II II i(,) r DNX v5% 1 Y 4 k 7 YXk 1 5 ^sa r d CI1 ID C.Y C.W Fwd NX % rNk � 61 II q�) rts r-+ J PxX t r7 % "'„Xl 3 f,',r'I fll C 'f Y T II II I ^ I :Y �b 1 'f I,� I. ., ',�„,A 11 ^. Ct1 P �% I 1 rYb i Cy "Sr ii rr S d � Cr I'YI r'. e, X II,� cl,r II IiIL IYn J r C”, '�1 ) O Ln N IDO n M ko W W M 01 O W O 00 M O N y} M 10O CD5- "i M 7 N (b In N 0 N N M O M 111 O N N Ili 01 n M ID ID (b W M 01 O 1f} W O co M O [V M O V M M 7 N cc N 0 N LON M IDO m w d `r O LU T,... � II„II LU CL x W S, ILII n"A'k .Iwo I6�V O S U) rl t (111111 0 6P" En ................ > . ce CD ............ ......... . T c: ........... < ........... ; L D c ru > Sol 4. 11 mm (A M tl ic _0 I w _0 E cr -0 T < CL x aj a tj c o -0 .Ni Fl ,1 m m m m 00 m Lq N Ol O O O OR Ocli ID t- Ln m r4 m t- �D F, r4 I- r, r� Ln C� 7 m N r4 -q- m N r4 m rl) cli C) . . . m + + NO ko r4 m CD CD CD m CD I: mt: O O O cq C� Il m t- CD m LrL L't- t- CDi Lr �l rlL m m 'D CD t- rl) O 0) m m - C> CD ClC) NN C9 O O OO lzr 'j- O lzrl cy) 10 w ol Lfl co cy) C� lzl� n 00 T3- " m m C) CD CD CD C) C) C) CD C) (D O O M O C! C? C! O O O O m r14 m ID rl CD O C> C3 CD CD ul v: T-� m O O O O O O m r1i rl) rl C) m 00 r -i r1i rl C� c) ll:� oo rIj rIj ti C)OccC>C)C)(DC)(DC) O q q q q O O O O q q O) `3- c ID Lr1 C) 00 0 0 rNi 00 C) oci C� rlm � C� M C� CMO C)Ln CD CD CD C) CD CD C) CD C) CD CD 0 0 0 0 C! C? C? 0 C! 0 0 ;2 4A C:) C:) C) = C:) C) cm) C) C:) C) cm) C) CD 0 0 0 0 0 0 0 0 0 0 0 0 0 t- q) t- o � Ln o m m ccl c:� r,,i c� m Ln CL cm� cmi o om 0) m Ln Ln c!7 ur cl, 0 LU (r) Z LA LU E: a_ x W 1w 0 Wb un Q :3 V �6 E ID Lu Q3 cia rri fllCL C!v LU W u x 7 CL u ED 01 L . > rZxoll LEE uj z:5 u 'd lill 0 Will U ��5 c ['� m TMI IV t (111111 C:) 0 C:) 0 C) 0 0 rw) C) 0 En C) 0 C:) 0 C) 0 cm) 0 ................ > . ce CD ............ ......... . M Ln T c: ........... < ........... ; L D c t- Ln a� r1in ll�. cc i Mcci "IL ru ow C Cl i cc� 4. ID m (A M tl o ul 22 0 _0 I 0 Q _0 E F- IV LU -0 T < CL x uj Z WA o Om N Ln ID C� t: MO1 r": 111 O O O O rl Lr) -q-m;�Oom� .... N r4 N M+ + + + Ln C> CD CD CD CD cl� O O O O m m �D Ln 00 CD CD co rli CIL 00 t- 0% rl m Cl C> C) Cl C) O IR u� r� N O O O O Cr� C) CD rl CD CD C) CD C) ID C) O O `l: O C! C? C! O O O ol m 0 m co m co O C> C3 C) M N O O O O rl ID M m 00 m c� c) r,� v- — co N — C)OccC>C)C)(DC)C) O q q q q O O NN rl Moci 17� rIz, ol� rl� 210 CD CD CD C) CD CD C) CD C) CD O O o 0 C! C? C? o C! o rlj LO ro cri C7, LLO `4 Ln m M CY) ,J) rl r -q N IV C:) 0 C:) 0 C) 0 = 0 C:) 0 C) 0 cm) 0 C) 0 C:) 0 C) 0 cm) 0 C) 0 rl Ln Ln M Ln to In t- Ln a� r1in ll�. cc i Mcci "IL Cl i cc� ID m 0) ul 22 0 0 F- IV LU Ln Z WA LU 0- X ui IV &I 0 0 V 0, 1w w Q Lu Q3 A El r4 U) a V E A 2! W M. c!v LU u X3 1k >11 lit M ED 01 CL L. > uj lill 0 Will u CO M I II rl r -q N IV M. 31 7 It u Rl N d Q e o ID O O Ol N o In o O o In m o rl o Ln o 0 0 M vi rn o10 ID v o L 7 m rl N N O tD M ^i 7 N M v -" O D. L w + O O N N N + + Ol M n � O 7 e0 O_ O O N 7 !;i O O m m ON 7 M .i Ln M M N lD 7 .^i Cb n O N N Ln O m co M N lD O O N O_ O O V O In W In N N w N O O � Lrl en M L/1 N M n O O N N O O O L� O O .--I O O O Go rl ti Ol Lf1 N M co ,-I 1D O m O N Il O O O o� n O o� O 7 en O O O Il 7 O m 7 d` � Lf1 In In ^ 7 Moo to .� of M lD O O O O O O O O O O 10 ID m .--i O M 0' .--i N %D of co D1 m n M M rl 7 M lD Lr O N l0 7 O M Il n loN O O O O O O O O O O O O O O O O O O O O C) O o o O o O O O o o O o o O o O O O o LD �o In O M t- 01 1� 7 M lD Lr O N to 7 O M h n 7 7 r N o Ln `°10 �% �1 Cryy1 �L V� tN C7 i""' Yrl n rda Clb ' b c!V r^3 U LU CL W 4J "' Ji C""7 .' Nri Gi +Yb C 6, CID Yb ryb �Ik .X II II,.I �X Jd1a" i V% Cda rXk r 1" � CIX PJ C) i % U Q d 61 II YNk fLX iIk f X"': II III I.I,.II K 7 CYb 0 m eri 0 7 M O rl rlN 00 7 !R M O O O cc N 71)cli N 7 M N Hi O N M rld O O <R 0 N Ln w O O O O In Ln N N N N rn rn M M N N tR V} Ln 22 J .Ry 0 0 F- IV LU LnLU x W F£$ c db d94 O M,D O l.S f'. 0 M. tc C) C) C) 0 0 0 Ln m m 0 In m C7, m 0 Ln CYN CYN Iq IV C) O ID V: 0 O 10 q: ID `3: ID 10 ID %D 10 ID V- 0) o, a, Lni Ln� Lri cl) yr ea cD ID cD uD �o c� t: c� t: t: %o ko � %o ko � C) C) C) 0 C) 0 0 0 0 0 cm� cm� cl M m rl) I r4 14 rlL N v) 0 Lu C v) !U 2! IA Lu 1w a_ X uj El� IIS C, WMS ::3 jD vi Lu c!v Lu :x 1 17 11 cL L � 3 W j IN Iq IV tIII C) rlj ppryppri ICY) = 0 = 0 n n 00 co ............. > . co CD .............. 5 ......... . rV co AA + + o + + r c . ......... . < ........... ; rr) ..... C. CD ro > M in t Cr c mm V) 2� _0 mm fA m VT iA M O O u N m 01 01 LU C tl 2! IR Ll LU 1w 10- x w Valli ic WP 0 U Ch _0 a) tl _0 Zi E CD [A cr C: -0 T CD CL x uj -0 o -0 C) C) C) C) C) rlj = 14 C) N = 0 = 0 n n 00 co co Ln m m 4j� co AA + + o + + t- + + rr) C. CD in V) 2� 00 m m VT iA O O N N m 01 01 LU C C rl LO v C:) 0 C:) 0 = 0 = 0 cm) 0 cmi cm� Cl in V) 2� 0 IS LU C U) !2 2! IR LU 1w 10- x w Valli WP :5 Ei 11 c ra (Liu) IU cH 3 C!:` LU :x Ol 112 III CL III 9 X :Z 11L? CI C rl LO v M. C) = = = = 0 0 0 0 0 cmi n L'i cm� C) r1i C) rn O V: M O O 0 2 t r1i Lr� C) = = = = 0 0 0 0 0 cmi n L'i cm� C) r1i C) rn rn 10 C) Lri co �D Cz tai hr¢V s n3 IU A LU U) 2!:3 III ID I I U :J CY ID 9!!!!:,VLU CL u M U I :5 ID X wN1y r1 Gs rn 10 C) Lri co �D Cz Village of Mount Prospect Finance Department First Quarter Financial Review For the Quarter Ended March 31, 2022 Prepared By: Amit Thakkar, CPA Director of Finance 47 IIII intirod tictioiiia The Finance Department prepares and presents a review of the financial activities for the most recently ended quarter. This report summarizes the financial activities of the Village of Mount Prospect for the first quarter of the fiscal year 2022. The report begins with summarized and unaudited financial results from the fiscal year 2021, followed by an analysis of General Fund reserves and Police and Fire Pension Funds' funding reports. Further, the report contains revenues and expenditure analysis for the quarter ended March 31, 2022. The report also contains a few special items of interests and updates. 2021 Lhinauditedl IIIC° liii uir ui liii llll The year 2021 started with many uncertainties. Early 2021 experienced the peak of COVID-19 with a very high number of cases. In anticipation of the unfavorable market conditions and economy, the Village Budget for the year 2021 assumed a higher level of conservatism and caution. However, as the year progressed, the Village emerged not only financial strong, but also achieved many historical milestones for many of its revenue sources. The Village collected $52.2 million in intergovernmental revenues against the original budget of $43.7 million and the report discusses each of the major revenue line item's performance. Overall, the Village collected outperforming state sales tax, home rule sales tax, income tax (LGDF) revenue, use tax, and ambulance billing fees. Additionally, the Village received $3.5 million from the U.S. Treasury for the American Rescue Plan. All of these items allowed the Village to collect $19.3 million more compared to the revenues collected in the fiscal year 2020. However, the fiscal year 2020 was heavily impacted by COVID-19 and a comparison of 2021 performance with 2020 may not represent a fair comparison. The below table summarizes the 2021 revenue performance. It is important to note that there is a three-month lag between actual revenue recognition and collection. Therefore, while some of these revenues are recognized in December 2021 per the GASB standards, the actual collection of the 48 revenue occurred between January 2022 and March 2022. The investment income is reported per the GASB standard, which includes the premature withdrawal penalties. The recognition of unrealized losses due to premature withdrawal is reflected in market value but the Village is not planning to liquidate any of its investments prematurely. The Village has the intention and capacity to hold these investments through their maturity (2023 - 2024) and the reported losses are merely an accounting adjustment. Property Taxes 260,565,255, 260,565,255 26R, ,35,08,8 19,969,131 515,957 2,6 OtherTaxes 13,300,000 13,3 ,000 14,852,966 10.2,259,799 2,593,16,6, 21.2% InitergoverntmenitM Revenue 43,755,343 52,459,104 52,205,332 37,89,9,5 53 14,3605,779 37.7% Licenses, IPermits & Dees 3,6x67,000 3,067,000 3,7044,958 3,0483,18, 0 96,778, 3.2 Charges lrrrServices 35,925,469 36,793,46,9 37,4210,,.529 35,208,752 2,212,776 6,3 Fines & IForfelilts 45%500 45%500 6283,522 415,2609 213,,313 57.4% Investment (Income 450,5,01 450,5,01 �16xJ„196G� 417,,26,9 (548,,459) -1122,6% Other lFinancungSources 106,,940,606060 7,340,606060 4,912,9105 5,7075,,56010 (262,5`3,6) -5.1% OtherR3evenue 2,269,926; 2,269,920 3,149,544 2,575,747 273,797 9.5 Reimbursements 445,000 445,000 396,4705 493,127 (960v712) -19,6% Tot,al Revenues, 137,177,990 137,153,751 137,091079 117,79!21269 1%303,810 -15.51% The above listed revenue sources are analyzed below: I::Iroll,,)erty fax Property tax is one of the most reliable revenue sources. The Village's total 2021 levy was $19.4 million, which includes 2.0% for losses and costs. The Village was expected to collect 98.5 percent of the 2020 levy payable in 2021. The actual property tax collection for the year 2021 totaled $19.1 million or 98.9 percent. The property tax budget for the year also included $1,348,000 for Tax Increment Financing District (TIF). The actual collection for the TIF was recorded at $1,483,537. The Village levy for the year 2020 as well as for the year 2021 was approved with a 0% increase in the levy. Other „u,,,,axes Other Taxes mainly include locally enacted taxes comprised of home rule sales tax, food & beverage tax, real estate transfer tax, municipal motor fuel tax, utility taxes, hotel/motel taxes and cable franchise fees. The 2021 collection totals $14.9 million, which is higher than the 2020 collection by $2.6 million or 21.2 percent. The home rule sales tax collection 49 totaled at $6.7 million, an increase of $1.4 million or 26.1% compared to the 2020 collection. In addition, there were a few major commercial real estate transactions, which provided additional real estate transfer tax. The total real estate transfer tax collection for the year 2021 was $1,471,917, an increase of $509,230 or 52.9 percent compared to the total 2020 collection of $962,687. The food & beverage tax collection for the year totaled $1,412,583, an increase of $296,759 or 26.6 percent compared to the total collection recorded for the year 2020. I rater (:.)vs.t nmen,W I eveurwe The intergovernmental revenues includes revenues received from the other governmental units and agencies, mainly from the State of Illinois. The Village has recognized intergovernmental revenues totaling $52.2 million for the year 2021, an increase of $14.3 million or 37.5 percent compared to the total 2020 intergovernmental revenues. The most significant revenue source under this category is the state sales tax. The State of Illinois shares 1% of all general merchandise sales that occurs within the jurisdiction of the Village of Mount Prospect with the Village. All-time high sales totaling $2.29 billion were recorded for the year of 2021, and the Village received the total sales tax collection of $29.3 million. The 2021 state sales tax amount is higher by $7,361,395 or 33.6 percent compared to the 2020 revenues. The Village Administration will be proposing a plan to use some of this sales tax surplus strategically during the budget 2023. A brief summary of the preliminary proposal is discusses later in this report. Furthermore, the Village's income tax budget was kept flat at $5.3 million for the year 2021, but the actual collection at the State level was much higher. The income tax revenue is shared as a per capita item and the State shares 6.6% of the income tax collection with all local governments based on the population. The total collection for the year 2021 is recorded at $7.2 million, an increase of $1.3 million or 21.9 percent compared to the prior year collection. The Village also received $3.5 million from the American Rescue Plan in the year 2021. Although the American Rescue Plan revenue is received in 2021, the amount is restricted and will be treated as deferred revenue for the year 2021 and will not be part of the annual income or the unrestricted fund balance. The 50 Intergovernmental revenue also includes $19,238 in Municipal Cannabis Tax. The amount collected is lower than the initially expected analysis but staff is tracking this revenue source, and staff will provide further updates as and when available. Licenses & I1:)erirniit The Village collected $3,144,958 in license and permit fees. The amount collected is higher by $96,778 or 3.17 percent compared to the 2020 collections. This category includes $1,451,051 in vehicle license fees, which is earmarked for the street resurfacing program. Moreover, the Village collected $739,596 in building permit fees. This category also includes $632,111 in various business license and permit fees. Chap rge for Seirviices The Village collected $37.4 million in charges for services for the year 2021. The amount is higher by $2.2 million or 6.28 percent compared to the 2020 collection. The charges for services includes water and sewer fees, refuse fees, ambulance billing fees, parking fees, internal service insurance payments and vehicle lease payments. The increase in the charges for services are mainly due to planned increases in the water, sewer and refuse fees and also due to additional ambulance billing fees of $800,000 collected through Ground Emergency Medical Transport (GEMT). The Water and Sewer Fund recorded revenues totaling $17.6 million. The total charges for services also includes $2.0 million in vehicle lease payments, $2.4 million in vehicle maintenance payments and $7.8 million in risk management payments including health insurance, general liability insurance, worker's comp and other payments. 1::::1ne & I1:::::orfeftuire The Village collected $628,522 in fines and forfeitures during the year 2021. The collected amount is higher by $213,313 or 51.3 percent compared to the 2020 collection. The 2020 collection under this category was heavily impacted by COVID-19. Subsequently, the Village implemented a new in-house adjudication program, was able to reduce certain administrative costs charges by Cook County, and was able to collect greater amounts. 51 The above amount also includes $131,397 in water and sewer late payment penalties and fees. Inver-bi°neint IInconie The Village conducted an analysis during the year 2021 and invested excess liquid funds in the U.S. Treasuries and other allowed secured investments. Per the GASB standards, all the investments have to be recorded at the market value. The market value for given investments include premature withdrawal penalties, which is to some extent an unrealized loss. These losses will be realized only if the Village prematurely withdraws these investments. The Village has the intention and capacity to hold these investments through their maturities. The investment income is reporting a negative income due to mark -to -market adjustments of premature withdrawal penalties, which are merely accounting adjustments. Upon reaching maturity, these investments will reverse all the recorded losses and will register a positive income in the years 2023 and 2024. Other II°tevenUe All other revenue sources includes Other Financing Sources (interfund Transfers), Other Misc. Revenues and Reimbursements. All of these sources combined recorded revenues totaling $8.5 million. This amount includes $4.5 million in interfund transfers from the General Fund. Of this amount, $3.79 million is transferred to the Flood Control Construction Fund and $750,000 is transferred to the CIP Fund. This category also includes $2.6 million in health insurance contributions from employees as well as retirees and other risk management reimbursements. Additionally, this category also includes $396,415 in various reimbursements from other Governmental agencies. 202.1, Dgoenditur (uu audit.'E The original Expenditure Budget for FY 2021 was $132.5 million. The actual spending for the year was $121.8 million. Original budgets were revised and increased/decreased with carryover items from time to time due to the timing issues of the projects The below tables recap the annual budget and actual spending for the year 2021 by department and by expenditure category. 52 Personnel 51,397,880 51,649,675 50,589,445 97.9% 50,046,503 542,942 1.1% Contractual Services 34,904,060 35,690,976 34,207,305 95.8% 34,094,838 112,467 0.3% Supplies & Commodities 2,311,566 2,303,901 1,901,517 82.5% 1,803,131 98,386 5.5% Debt Service 10,287,668 10,287,668 9,807,675 95.3% 9,078,379 729,296 8.0% Capital Improvements 27,872,085 27,785,109 20,265,564 72.9% 35,303,421 (15,037,858) -42.6% Other Expenditures 5,750,131 6,599,119 5,023,922 76.1% 9,731,352 (4,707,430) -48.4% Total Expenditures 132,523,390 134,316,448 121,795,429 90.7% 140,057,625 (18,262,196) -13.0% 10Public Representation 574,,153 457,,538 79.7% 20 'VIRllllage Admliniistrati on 4,,817,,963 4,,144,,8+02 86.0% 30 Finance 2,,230,,348, 2,102,,571 94.3% 40 Community Development 4,,26,2,,9,01 3,406,360 79.9'% 50 Neuman Services 1„222,,340 1,175,556, 96.2% GO Police 20,595,6,34 20,281„326, 98.5% 7,0 Fire 18,842,420 1,3,,,646�,8+08, 99.0% 90 IPublic Works 56,624,942 47,630,931 84.1% 00 IND 25,141„746, 23,949,537 95.3% Personnel 51,649,675 50,589,445 97.9% Contractual Services 35,690,976 34,207,305 95.8% Supplies & Commodities 2,303,901 1,901,517 82.5% Debt Service 10,287,668 9,807,675 95.3% Capital Improvements 27,785,109 20,265,564 72.9% Other Expenditures 6,599,119 5,023,922 76.1% All the Village Departments have performed within the stipulated budget limits for the year 2021. The Village has spent a total $121.8 million in expenditures for the year 2021, which equates to 90.7 percent of the total approved budget. The Department of Public Works is responsible for various capital projects. Some of these projects are either delayed due to supply chain issues, or they are grant funded and the grant amounts have not yet been received to conduct the projects. The expenditure by category (as mentioned in the second table) shows that the Village has spent 97.9 percent of Personnel costs, 95.8 53 percent of contractual services, 82.5 percent of supplies and commodities, and 95.3 percent of the debt service budget. The capital improvement items spent totaled $20.3 million, which equates to 72.9 percent of the total budget. General Fund Revenue 58,8 9,777 71,078,712 72,776,979, Expenses, 50,739,402 63,261,044 50,442,105 4 2,10.5 The total General Fund revenue budget for the year 2021 was $58.9 million, while the original expenditure budget was $60.8 million. The revenue budget was eventually revised to $71.1 million, while the expenditure budget was revised to $63.3 million. The actual recognized revenue for the General Fund totaled $72.8 million, while the expenditure totaled $60.4 million. As mentioned earlier, a few outperforming intergovernmental revenues including the state sales tax, income tax, use tax, and ambulance billing fees, along with a one-time American Rescue Plan Grant of $3.5 million contributed toward the recorded surplus for the year. Unrestricted Fund Balance as of Jan 1, 2,021 Add: Release of Restricted Fund Balance Add: I et Surplus Less: Less: Restricted Fund Balance as of Dec 31, 2,021 Less: Taxes Receivable from tthe Share & Other Agende 23,492,469 37.1% 2,300,000 12,w 3 34,,3,74 3, 8,.54, 38,.51 9,113,145 13.2% As mentioned in the above table, the General Fund started the fiscal year 2021 with $23.5 million in the unrestricted fund balance, while the actual spendable fund balance as of 54 January 1, 2021 was $15.8 million. During the year 2021, $2.3 million was released from the restricted fund balance and was spent on a Flood Control Project for the year. The net accounting surplus of $12.3 million (from 2021 activities) is added to the unrestricted fund balance. At last, the newly restricted revenue source (American Rescue Plan) will reduce the unrestricted fund balance by $3.5 million, and a new unrestricted fund balance of $34.3 million is derived. The fund balance represents 49.5 percent of the annual budget, while the fund balance policy requires a fund balance from 20 to 30 percent of the annual budget. It is important to note that the actual spendable fund balance as of December 31, 2021 is $25.2 million; the remaining amount of the fund balance totaling $9.1 million is not readily available, as it is a product of year end audit adjustments for the state taxes receivable. (Collection normally lags by 3 months.) The Village Administration will be proposing a plan at the Joint Workshop for strategically utilizing the General Fund Surplus and the plan should be implemented as a part of the 2023 budget subject to the Village Board approval. I1°°1' IIII liii ,,.i aind III°°° iiii hire IIII°°1 iin liiiain 11""ixind Unaudited Overall, the fiscal year 2021 was a good year for the Police and Fire Pension funds and both funds added $9.6 million and $4.5 million, respectively, to their net positions. Regardless of outperforming investment returns, both the pension funds' funding ratio decreased by 2.0 percent. The downward pressure of returns in the investment market and global uncertainties have caused both the consolidated Police and Fire Pension Investment Funds to adjust their future earning assumptions. The interest rate assumptions have been reduced from 7.25 % to 7.00 percent. In addition, previously the Village used RP -2014 mortality tables, but now the Department of Insurance has come up with the new mortality tables called Pub -2010, which provides for a higher life expectancy for public safety employees by 1.0 to 1.5 year. Both of these items are the primary results for the higher pension costs for the coming years as well as the reduction in the funding ratio for both pension funds. Overall results for both the pension funds are summarized in the table below. 55 Income, Contributions Member 8,87,1 26, 78,2,338, Municipal 3,9,65,48,2 3,641,606 Total Conthibution 4,852,608, 4,423,944 Investment Income Interest & Dividends, 4,459,487 4,749,613 �F a li r Value I n cre a se/(D,e cre a s e) 6,960,854 2,387,708, Investment Expenses (136,111� (11,5,6,99,) Total Investment Income 11,284,230 7,021,622 Tot,al Income, Expenditures, Administration Pension Benefits & Refunds Tot,al Expenditures nning Net Pos,ition Accrued Liability Percentage, Funded Percentage, Unfunded .16,136,838, 11,445,566 53,354 104,290 5,518,558, 6,,78,3,,5 3 G 5,571,912 6,5;92,815 I I M vil I W, I The Police Pension Costs/Levy for the year 2022, payable in 2023, will be $4,760,936, an increase of $940,920 or 24.6 percent from the prior amount. The same amount for the Fire Pension Fund will be $4,427,561, an increase of $759,744 or 20.7 percent from the prior year amount. These increases are unusual and represent approximately 8.7 percent of the total Village Levy. 56 Quairteir, SII ,........... IIII° e! in tie The Q1-2022 shows the total recognized revenues of $26.4 million, and it represents 17.1 percent of the annual budgeted revenues. At the same time last year, the total collected totaled $23.2 million. The Q1-2022 collection is trailing higher by $3.2 million or 14.0 percent compared to the Q1-2021 collection. The data is summarized in the below table. Property Taxes 20,873,259 20,873,259 10,774,92f 8,,519,226 2„25.5,694 26.5% OthherTaxes 13,304,500 13,304,5,00 1,074~809 841,359 233,451 27.7°. Intergouernmentall Revenue 54,713J45 54,713w145 3,503,536, 3J93,551 705,986 22.2% Licenses, Iperrmiits &Dees 3,008,,000 3,008,,000 1,164,448 1,170,082 X5,635) -0.5 Charges lFor 5ervIices 38,~333,258 38,,333,258, 9,049~625 8,,469,806 579,820 6.81% Fines & IForfelfts 541,000 541,000 101,359 1012,878 1,518) -1.5 InvestmentIIncorne 118,,,070 118w070 (238,123), 17,493 (255,616) -1461.2% Other IFiinanciing Sources 20,580,000 20,580,000 - 297,971 (297,971) 0.0 OtherRevenue 2~261,860 2~261,860 544,723 527,428 17,295 3.3 IRelirmbursements 397,000 397,000 5 6,048, 48,195 7,853 16.3% TotaI Revenues 154,130,092 154,130,092 26,431,746 23„188,389 3,243,„358 14.0% • Q1-2022 Property Tax collection for the first installment is higher by $2,255,694 compared to the Q1-2021 collection. The first installment due date was extended during the year 2021 and that resulted in delayed payment for the first installment. While no such extension is granted for the year 2022. The second installment of the property tax from Cook County may be delayed. The Village holds sufficient funds at this time and the probable delay in the Property Tax payments are not expected to affect the Village operation. • Other Taxes encompass locally enacted taxes, including home rule sales tax, food & beverage tax, hotel/motel tax, municipal motor fuel, real estate transfer tax and a few more. The collection is trailing higher by $231,169. The amount shown above is not final, as the home rule sales tax for the Q1-2022 will be recognized in April 2022 and beyond. • The intergovernmental revenues totaling $3.9 million were collected during the 57 Q1-2022. The collected amount is trailing higher by $709,986 or 22.2 percent. For the most part, the revenues for Q1-2022 will be received in Q2-2022, as the State taxes lag by three months. The Village received a Rebuild Illinois Grant Installment totaling $594,611 during Q1-2022. • License and permit fees are tracking lower by $5,635 compared to the Q1-2021 collection. The total Q1-2022 collection is $1,164,447 and it includes vehicle license fees totaling $656,556. The amount also includes $507,891 in various building permits and business license revenues. • Charges for Services are trailing higher by $579,820. The total $9,049,625 is recognized for the Q1-2022 as charges for services. The higher amounts are attributable to the rate increases in the water, sewer and refuse rates. The total recognized revenue includes $4.4 million in water and sewer fees, $1.2 million in refuse fees and $518,075 in various General Fund service charges including ambulance billing fees. • The Village collected $101,359 in fines and forfeitures during the quarter under review. The amount is marginally trailing behind by $1,518. • Investment income is reporting an unrealized loss totaling $238,122 due to changes in the market rates as well as premature withdrawal penalties. These losses are merely accounting adjustments and will reverse themselves out upon maturity. • The majority of the other items are on track as expected and are in line with the 2022 budgeted revenues. Quarter 1II w 2022IIID x,11 uir-i ° liii taii vires Q1-2022 expenditures totaled $24.8 million or 15.5 percent of the annual budget. The expenditures are trailing higher by $3.2 million compared to Q1-2022, mainly due to higher Personnel and Capital Improvement costs. A brief analysis of each of these categories is provided on the next page. 58 Personnel 53,,006,755 14,,3 55,882 27.1% 11,986,36.5 2,,373,,516, Contractual Services 35,206,88.5 7,,397,,75+0 21.0% 8µ020,g405 (622,,625) Supplies 2,405,821 524,299 21.8% 6,76,826, (1,52,527) Capital Improvements 49,987,999 2,,370,970 4.7% 8,32,,5,77 1,,538µ093 Debt Servllce 9,988µ211 24,,074 0.2% 43,,397 (19,323) Otther Expenditures ..................................... ........., ......... .................. ........., ......... 9,892x595 ........., ......... ......... ........., ......... ......... 144x371 ........., ......... ........., ......... 1.5% ........., ......... ........., ......... 78µ384 ........., ......... ........., ......... 6.5x987 ......... .................. ......... .................. Total Expenditures, 160,? 4912?5i�66 24,w821,„375 15.51%, 21,„639„�25�6 3J93 119 10 (Public (Representation 613,657 35,134 6.2% 55,750 (17,646) 20 village Administration 4,893r316, 971,x782 19.9% 986fr297 (14r515) 30 (Finance 2,r300,r407 46f2,r440 20.1% 431r428, 31,x012 40 Community Development 4r434r367 768µ150 17.3% 61%063 14%087 50 Human Services 1,x5=61,x38,5, 330223 17.7% 264r530 6.5x693 GO Police 20,r752,r384 5r8,.57,r194 28.2% 5r107,r557 74%637 70 Fire 20,r051,r352 5r231,r223 26.1% 4,r268,145 963,x075, SO IPublic Works 78,µ257,r235 5r046fr821 10.3% 6fr78 , 41X4 1,x25 , 406f 00 1N on-Deparltrmontall ......... ......... ........., ......... ........., 27,r328µ460 ......... ......... 3,r115,r4G5 ........., ......... 11.4% ........., ......... 3,ril7,r,042 ........, ......... �1,r63X4) ......... .................. Total Expenditures, 160,? 49/22566 24,w821,„375 15.51%, 21,„638„25�6 %I83JIL91 • Normally, the property tax collection for the first quarter includes the pension levy. The due date for the property tax levy was extended for the first installment from March 1 to May 3 for the year 2021. The change has resulted in a lower collection of property tax for the year 2021. When the property tax is received for the pension levy, it is an income for the Pension Fund and an expense for the General Fund. There was no such extension granted for the year 2022 and the expenditures as well as revenues are recognized as expected. • Contractual Services are trailing behind by $622,628 due to timing issues as well as delays resulting from supply chain issues. Overall, contractual service expenditures are within the expected range. There are some concerns about inflationary pressure and increase in costs. There are certain bid results, which have come in higher than expected and may require adjustments to the 2022 budget. So far, the contractual service expenditures are under control and 59 within the expected budgetary constraints. • Commodities and Supplies show a decrease of $152,527 compared to Q1- 2021 and totals $524,299, which includes fuel costs, salt, water/sewer parts purchases, general repair parts, as well as a few other miscellaneous items. This category is the most vulnerable to inflation and will reflect the impact of inflation sooner than other categories of expenditures. • The Q1-2022 capital improvement spending totaled $2,370,970. This amount represents 4.7 percent of the annual budget. Most of the capital projects have started for the year and major costs are expected to be paid out during the summer and the fall. A few projects might face supply chain issues and may result in delayed projects as well as expenditure recognition. • The major debt service payments are due on June 1 and December 1. There are no significant debt service payments in Q1-2022. • The Village incurred $144,371 in Other Expenditures during Q1-2022. The amount represents 1.5 percent of the annual other expenditures budget. Otheir 111terns • Most towns use 100% of the Home rule sales tax for capital projects while the Village of Mount Prospect has used 25% of the home rule sales tax for funding the General Fund operating expenditures. In light of the excellent financial performance and recent surplus, staff is proposing to reallocate home rule sales tax with a new formula listed below: General Fund Street Construction Fund Flood Control Construction Fund Capital Improvement Fund 25% 1,50,0 - - 25% 1,500,00 33.33 2"000"000 25% 1,500,000 33.33% 2,"CWCWCN"000 25% 1,500,000 33.33% 2,"000,"000 6,000,000 6,000,000 60 The additional state sales tax collection should provide sufficient support to the General Fund and the home rule sales tax allocation relieved by the General Fund will provide critical support to the above-mentioned three capital project funds. • Recently, the Village has seen a 33% growth in state sales tax revenues. Village staff is still examining consistency and stability of the recent growth. If proven stable and consistent, Village staff may propose the following changes to the Village Budget for the year 2023 and onwards: o Deploying $1.0 million from the state sales tax revenue toward the Street Construction Program. The sales tax allocation totaling $1.0 million along with additional home rule sales tax totaling $500,000 should be sufficient to replace the vehicle sticker/license revenues, which may allow the Village to eliminate the Vehicle Sticker Program. o Deploying $500,000 from the state sales tax revenue toward the Flood Control Project Fund (based on need). Along with additional home rule sales tax, totaling $500,000 the Village may eliminate the implementation of the Strom Sewer Utility Fees. o The Police and Fire Head Quarter bonds have an annual levy totaling $1.4 million. Subject to availability of the sufficient sales tax revenue, staff may propose to use the sales tax revenues for debt service, which will allow the Village to abate the debt service levy for the series 2018B bonds totaling $1.4 million. o As noted earlier in the report, the Police and Fire Pension funds have higher pension costs for the year 2023 and beyond. For the tax year 2022, payable in 2023, the pension levy is increasing by $1.7 million, which equates to an 8.7% increase in the property tax levy. Such a high percentage of increase is not sustainable in the short or long term. At this time, staff is proposing to start a stabilization fund with an annual sales tax allocation of $750,000. The pension stabilization fund will only be utilized to abate the pension levies. The annual allocation can be part of the annual budget process and the amount can be adjusted based on the sufficiency of sales tax revenues as well as other aspects. 61 o All the above items are not final and will be discussed with the Village Board and the Finance Commission and are subject to consistency and stability of sales tax revenue. These items may be presented as part of the 2023 budget and may be adopted subject to the Village Board approval. • The current inflation rate is approximately 8.5 percent; this rate is the highest in last 30 years and represents a real threat. The higher inflation will result in higher supply prices, contractual obligations, construction costs/bid results and higher personnel and benefit costs. Normally, the Village allows anywhere from 2 % to 4% for inflationary adjustments, and expected increases in revenues have been approximately 3.5%. The year 2021 was an exceptional year and the Village recorded unusual growth. The Village is in a strong position to digest any short- term impact of inflation but in the long -run the Village may have to change its strategies regarding procurement of goods and services. _Apr 2021 Ju 12021 O�t 2021 Jan 2022 ■111111111 Recently, the interest rate yield curve was inverse, i.e. short-term interest rates are higher than long-term rates. Recently, the interest rate for 2 year Treasuries were 20 basis points higher than the 10 -year interest rates. Per some economists, the inverted yield curve is a reflection of a recession in the near future. As of now, the yield curve is not inverted, but current market conditions, the global climate, and uncertainties may cause a recession. The Village is in strong financial health and although no major impacts are anticipated in the near future, the Village Administration is alert and already has a contingency plan (if needed). 62 lint, 6 _Apr 2021 Ju 12021 O�t 2021 Jan 2022 ■111111111 Recently, the interest rate yield curve was inverse, i.e. short-term interest rates are higher than long-term rates. Recently, the interest rate for 2 year Treasuries were 20 basis points higher than the 10 -year interest rates. Per some economists, the inverted yield curve is a reflection of a recession in the near future. As of now, the yield curve is not inverted, but current market conditions, the global climate, and uncertainties may cause a recession. The Village is in strong financial health and although no major impacts are anticipated in the near future, the Village Administration is alert and already has a contingency plan (if needed). 62 • The Police Department is requesting an additional headcount of sworn Police Officer. The new officer will have a title of Community Relations Officer and will be performing a variety of functions, including various community outreach programs, social media management, community policing and attending Citizen's Police Academy programs. Staff believes that the Community Relation Officer will be an essential position for strengthening the bonds between the Community and the Police and will help in achieving the mission statement of the Mount Prospect Police Department. The total cost for this position (including benefits and pension contribution) is expected to be around $176,831. The Village Administration is supportive of this request from the Police Department and agrees with the analysis provided by the Police Department. inclll tjii liiiaini The Village is in strong and sustainable fiscal health and can provide quality governmental services to its residents and businesses consistently with a strong fiscal backbone. The Village's performance in the year 2021 proves a strong and robust local economy. The recent affirmation from S&P also proves the faith in the Village's fiscal strength and ability to serve its residents and business community for a sustainable future. This report and other items will be discussed at the Joint Workshop with the Village Board and the Finance Commission. Respectfully Submitted, Amit Thakkar, Director of Finance 63