Loading...
HomeMy WebLinkAbout5.1 Monthly Financial Report - July 2018BoardDocs® Pro Agenda Item Details Page I of 2 Meeting Jul 17, 2018 - REGULAR MEETING OF THEM UT PROSPECT VILLAGE BOARD - 7:00 p.m. Category 5. CONSENT AGENDA Subject 5.1 Monthly Financial Report - June 2018 Access Public Type Action (Consent) Preferred Date Jul 17, 2018 Absolute Date Jul 17, 2018 Fiscal Impact No Budgeted No Recommended Action Accept the monthly financial report for June 2018. Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended June 30, 2018. Alternatives 1. Accept the monthly financial report for May 201 2. Action at discretion of Village Board. I Staff Recommendation Staff recommends the Village Board accept the monthly financial report for June 30, 2011 06 1wrie[::3o&i,-,d UIIG- III oad ......... Ilf:Xtf:(."33.."33-3 K[::3) C o ten Ib i ii e d III iii ii a ii ". i a III s f iii- 6 ...- 3 2 0 8 d f (7 4'.1' .. IIS III 3 Administrative Content Executive Content https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login 7/13/2018 BoardDocs® Pro Page 2 of 2 All items • Consent Agenda are considered routine by the Village Board and will be enacted by one motion. There will be no separate discussion of those items unless a Board member or member from the audience so requests, in which the item will be removed from the Consent Agenda and considered in its sequence on the agenda. https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login 7/13/2018 w �w F� rw V A w A w w ao 0 N O M �." h LLn rn �q o o Lq �q o of of 7 O .�-i LO LO N of .--I M f, Ln Ln LOO .--I .--I Ln LO LO t\ f, M t- 01 01 O oo N LD LLnn 7 7 7 OM 7 t, 7 M + .M -I W LMn LMn W 001 W o o O of M of OM f, 7 LO M rlj O N 7 f, 7 01 W W 01 N m Ln 7 M Ln of 7 O LO m t\ m 01 N .--i r< 7 M .ti W 7 7 ON O . -I 001 Lin CD N .-I of of M t\ O t\ M O Ln N M O 01 v f, O .--I m .--I .--I LOO M N m n n Ln M O 7 m M of N LO m M N .--I M OO O O O O O O O O O O O O O O O O O O Lnt\ O ON LO 01 .m -I M O O CD r, Ln M W O W O O 7 W t\ M M 01 Ln LO f�rj O � r, ^ t Ln N v t\ 7 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 of O O O 01 Ln O O f, M Ln t\ Ln W .--I LnLN 7 of OM 7 ON N N LO o7 .--i 7 .--i 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 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 of O O O 01 Ln O O f, M Ln t\ Ln W .--I LnLN 7 of OM 7 ON N N LO o7 .--i 7 .--i N as ui� Ism 141 as as ' fu OEM Ism LLx.l) wmmw y uj lS LLY'j i�x A ai r l fl) <! f c^ �) l:S+ r'o ^�ca lS+ gra a I V) ii fu 6�wli�•S as V+ 0 r✓ n C MEM u � n 0 CC"b Q y IF-� Cl• i t6 Cn : F Cy n ill U t6 a� E I u C. uj x n 0. 0 CM L_ u Cn : V U 0y TJ fU � kl ce TJ � DC7 C: fU kl fU L 0C? TJ � 'cJ ¢17 kl LLn rn �q o o Lq �q o of of 7 O .�-i LO LO N of .--I M f, Ln Ln LOO .--I .--I Ln LO LO t\ f, M t- 01 01 O oo N LD LLnn 7 7 7 OM 7 t, 7 M + .M -I W LMn LMn W 001 W o o O of M of OM f, 7 LO M rlj O N 7 f, 7 01 W W 01 N m Ln 7 M Ln of 7 O LO m t\ m 01 N .--i r< 7 M .ti W 7 7 ON O . -I 001 Lin CD N .-I of of M t\ O t\ M O Ln N M O 01 v f, O .--I m .--I .--I LOO M N m n n Ln M O 7 m M of N LO m M N .--I M OO O O O O O O O O O O O O O O O O O O Lnt\ O ON LO 01 .m -I M O O CD r, Ln M W O W O O 7 W t\ M M 01 Ln LO f�rj O � r, ^ t Ln N v t\ 7 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 of O O O 01 Ln O O f, M Ln t\ Ln W .--I LnLN 7 of OM 7 ON N N LO o7 .--i 7 .--i 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 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 of O O O 01 Ln O O f, M Ln t\ Ln W .--I LnLN 7 of OM 7 ON N N LO o7 .--i 7 .--i N Ln t\ of 7 7 m O O O O O (D N N of of 7 7 M M Ln I.n V) I+ CA Ilk uj �y r uj uj �A °r s r.L. as ui� as as ' LLx.l) wmmw y uj lS LLY'j i�x ry fl) r'1 ai r l fl) <! f c^ �) l:S+ r'o ^�ca lS+ gra a I V) ii c a) �V+ `, as V+ 0 r✓ > M w f.. fl) fl) <! <:) Ln t\ of 7 7 m O O O O O (D N N of of 7 7 M M Ln I.n V) I+ CA Ilk uj �y r uj uj �A °r s r.L. - M .--I cx) �wwmm���ll ������� ) l O O1 0 CD O O M M Ism N + + M OJ M O O CD..........A O ru LO OEM Ism O O u --I n aY �������������• A ��n N Ln ti L ti fu n MEM t\ .--I O O u M N O O � n 0 CC"b OJ G1 Q y IF-� ti W m N �y c LO r-4 '-I Cl• i t6 Cn : F Cyn fU U t6 a� E i u C. uxj xIn : � CM L_ u cn : V fU U Oy TJ E kl ce TJ � Q C: fU kl fU U 5, LL TJ 0 'cJ ¢17 kl - M .--I 7 O O O O1 Lq O1 O O M M N N + + M OJ M O O O O LO 0J LO N O O N ON '-I --I OJ O O O O O O O O O O O O O LLq Ln O ON O O cc t\ N O O O O ^ M + + 7 7 O O + + O - O Lr Ln N + + M OJ M O O O O LO 0J LO N O O .--I N - OJ N N of W o M N Ln ti L ti v f, N t\ .--I O O M M N O O Ln 0) fl N OJ G1 CIL ti W m N LO r-4 '-I O O O O O O O O O O O O O LLq Ln O ON O O cc t\ N O O O O O O O O O O O O O OJ O O O O O - O Lr Ln O O O N W O O ujX 0 _y >k �s uj va `as as ea OJ .--I M O .--I O ca �a as ai 5" �a r s as iv as r.. as as it , r,:) N '-I '-I 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 OJ O O O - O Lr Ln O O ujX 0 _y >k �s uj va `as as ea O N W ca �a as ai 5" �a r s as iv as r.. as as it , r,:) OJ .--I M O .--I O N '-I '-I 7 01 N Lr) M O M m O CIL C\ O O CILN O t\ O CD O m OJ rlj 7 01 N Lr) M O M m O CIL C\ O O CILN O t\ O CD O O O O OJ OJ O O Lr) Lr) V) IQ M . CA Ilk uj �y r ux d uxj �A �A °r s r.L. ro IIIIIIY ujX 0 _y >k �s uj va `as as ea iv as r �a ` n �a ca �a as ai 5" �a r s as iv as r.. as as it , r,:) 7 01 N Lr) M O M m O CIL C\ O O CILN O t\ O CD O m OJ rlj 7 01 N Lr) M O M m O CIL C\ O O CILN O t\ O CD O O O O OJ OJ O O Lr) Lr) V) IQ M . CA Ilk uj �y r ux d uxj �A �A °r s r.L. ro D o rn o 0 0 0 � M fl N N N N + 7 ^) ..��� ) O 2 0 CD O � A t6 fU Ism + O O O O O O O O O D II .......... A ru OEM Ism O y^ q w,a O O TJ 'cJ n O O O IIS � �...� O O Ln fu y Cy In MEM �l m" r\ U sw � t6 C ca CC"b Mr✓ Q y IF-� cra �y c t6 cn : uujN N: y as as 7- iv s v c �y n ill U t6 r.. 0r uj 01 a� E u C. x 0 L_ u cn : V fU �y TJ fU � kl ce TJ � DC7 C: fU kl fU U 5, LL TJ 0 'cJ ¢17 kl D o rn o 0 0 0 � M fl N N N N + 7 + O O 7 + W + O O + O O + O O O O O O O O O O O O O O O O O O MO O O O E � O O Ln y Ln r\ �l r\ O O -CD O O O O Lo O O O O LO rn m 7 Ln O O O O O O O O O O O O CD CD m CD CD CD O O M O O O CD CD Ln O N N N O O O O O O O O O O O O O O O O O O O O O �A O O O O O O O O O O M '-I O Ln f'l 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 �A O O O O O O O O O O O O O O M '-I �l Ln f'l r �A �A cl �l E y �l ca Mr✓ f cra uujN N: y as as 7- iv s v c f r.. 0r uj 01 O M rl Lf1 0 O CD O O CD O O O O O O O O O O O O N N V) IQ . CA Ilk uj �y r uj uj > uj �A fl.. E u...0 CNI U °r s M kl .--i O O O LO O M O LO O O O M O LO O LO O 7 t - M .--i N N 7 M Ln1 M N Ln Ln1 '-I M N t ) ..� ) t N 0) 0 CD t t t t Ism Ln t t u�u ru OJ Lq Ism O W O N O Ln MO 00O M LL O ^ fu M n MEM LO O7 M M u r< v .E t6 � n 0 CC"b m CD Q y IF-� CD m CD N CD —i Lq OJ O Cl• i t6 Cn : �A F O OJ G M t\ O l0 t\ ~ cl 7 OJ Ln '-I N Cyn fU U t6 a� E u C. as ' rr x 0 - 0 A L_ u as ca Cn : V fU �y TJ fU � ` as as s riy kl ria L>ljiv > �s I, cea' ce II., uj TJ � DC7 C: fU kl 2 1 fU U 5, LL TJ 0 'cJ ¢17 kl kl .--i O O O LO O M O LO O O O M O LO O LO O 7 t - M .--i N N 7 M Ln1 M N Ln Ln1 '-I M N t t O W t N 0) t t t t t t t Ln t t u�u OJ Lq W O W O N O Ln MO 00O M O ^ M LO O7 M M r< v m CD CD m CD N CD —i Lq OJ O O O �A O OJ G M t\ O l0 t\ ~ cl 7 OJ Ln '-I N O O O O O O O O O O O O O O O O M Lq OJ O N O G O OJ fl t\ LnLLn1 M Ln 7 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 O O N O OJ Ln 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 O O O O O O O O O O O O O O O O N O OJ Ln M r r n.a r u�u r �A �A cl as ' rr A 'M as ca ° ` as as s riy ai ria L>ljiv > �s I, cea' II., uj 2 1 II, .�o r✓ <,�7 <,.7 O Lr) m M rljM rl 0 O >J O rlj7 O Ln1 OJ t\ t\ Lr) Lf1 O C OJ N Lri7 7 >J O rlj7 O Ln1 OJ t\ t\ Lr) Lf1 O C O O O O O O O O O O N N M M V) IQ F -- Lu LLu f.."." �y r z > r uj r u �A E �A �s r.. I�x kl N CD CD 0) CD CD N O O 1-! Lq O t- 11, r1l CD Ln Ln m r-4 LD 01 of 0) CD LD m 0) r-4 + + t- cx) o) + + 2 0 CDfU CD CD Ism fn 0 CD O O O CDII ............ ru 00 OEMTJ Ism y^ q u .......... IIS r-4 m CD CD CD .......... fu CD Cy In MEM O M O t- u 00 CD u r-4 cc� CD rl - llO CD C� N LD CD rlj rl - rq F E Cyn wu E u C. uj 0 0 u In fU 0y TJ E klE ce fU E kl t 5, LL TJ 0 kl kl N CD CD 0) CD CD N O O 1-! Lq O t- 11, r1l CD Ln Ln m r-4 LD 01 of 0) CD LD m 0) r-4 + + t- CD CD + + CD CD CD CD CD O O O O O LD 00 c6 LSD r-4 CD CD CD CD CD CD O O O M O t- r-4 00 CD r-4 cc� CD rl - llO CD C� N LD CD rlj rl - rq CD CD CD CD CD CD O O O O O O CD CD CD �D CD CD C� C� C� t: C� C� CD rlj rlj CD CD m of cc� CD N CD CD CD CD CD CD O O O O O O CD CD CD CD CD CD CD CD C� C� C� C� 00 Ln LD CD 00 r-4 r-4 N CD CD CD CD CD CD CD CD CD CD CD CD CD CD CD CD CD CD O O O O O O CD CD CD CD CD CD CD CD C� C� C� C� 00 Ln LD CD 00 r-4 r-4 N as rr as uj 7- x I I W M uj > > 0 uj 01 01 as ry CZ CD r-4 .-I CD r-4 t CD t M m M Ol N M Lf1 O .ti Lq OJ OJ M m Ism N O O O x.. 0. C OOl N O fu 0) Ism N M fl O M Lf1 t\ 7 C W O W6U fu n � C PS Y w W �A sw � O O1 t6 TJ 6 O Lq M CC"b M Q y IF-� O M 7 OJ O N OJ ti • is t6 cn : p O V y > Ln F s Cr as rn,n c s as ai f as Cyn fU U t6 > r'„) IIs r'1 !S) a� E r'o c✓ t) u C. x 0 L_ u Cn : V fU �y TJ fU � kl ce TJ � DC7 fU kl fU U 5, LL TJ 0 'cJ ¢17 kl t CD t M m M Ol N M Lf1 O .ti Lq OJ OJ M m m N O O O 7 C OOl N O Ln 0) N N M fl O M Lf1 t\ 7 N t CD t M m M Ol N M Lf1 t M n Lq 7 m m N O O O 0 o Lq OOl � � t\ N 'I- N O .ti M Lf1 m 7 N W O W6U Ln PS Y �A O O1 7 O Lq M N M N O M 7 OJ O N OJ ti M 00 p O V y > Ln rlT s Cr as 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 Lq M n Lq 7 m m N O O O r-4 OJ rl .--i M rl N l0 t\ N 'I- O 00t- 7 ~ 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 Ln LDD 'I- O O O O rl tl 7 'I- 7 7 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 O O O Ln LDD 'I- rl tl 7 7 f" Y II W6U A� W6U W6U PS Y �A i M� C1 Ma uj as CPS W 1� d y ,Yt ry � . Cl M, f I' V y > s Cr as rn,n c s as ai f as > r'„) IIs r'1 !S) II r'o c✓ t) t\ CDt- OJ rl 0 CD Ln Ln Lq Ln r CD Ln O O O O O O O O O O t\ t\ M M M M 7 7 V) IQ . CA uj f..".” �y r uj Ilaa. uj weU �A W6U Y �A S fI.L.. K&I kl r-4 r-4 m CD r-4 r-4 Lq Lq O m m fU Ism 1461 CIO U................ lD � rl m as C� . . .... fu m OEM Ism LD LD r, Ln 00 Ln 00 Ln m .......... fu MEM + uTJ + 6 CD m m M O1 O t: t: 0 cc� r,� Cl rl� rl� N N m Ln r-4 Ln r-4 F E 00 00 r, t- CD CD O m -! O Lq Lq LD Ln r-4 Cyill m CD CD r-4 E N Ln di di u C. uj 00 Ln � 00 Ln � 0. 0 , Z- u TJ In kl ce fU kl t 0L TJ kl kl r-4 r-4 m CD r-4 r-4 Lq Lq O m m rl M - ail lD lD � rl Lr as C� C� LD Ln m LD LD r, Ln 00 Ln 00 Ln + N + + CD CD m m M O1 O t: t: cc� r,� w rl� rl� N N m Ln r-4 Ln r-4 00 00 00 r, t- CD CD O m -! O Lq Lq LD Ln r-4 m m CD CD r-4 r-4 N Ln di di r, Ln 00 Ln � 00 Ln � CD CD CD CD O O O O CD CD CD CD CD CD C� C� C� Ln Ln Ln m - CIL CD CD O O CD CD CD CD C� C� Ln Ln V) IQ Ilk uj uj uj > uj mi r*- IIIIIIY ail as > > uj 01 0 > w I 5::oc2 CD CD O O CD CD CD CD C� C� Ln Ln V) IQ Ilk uj uj uj > uj mi r*- M CD m LD LD O O fl� rl� rl� tF� Ism 1461 CIO U................ m 0) m m CD .w„„ fu Ln OEM Ism CD O LO CD O LD LO TJ CD rj 00 00 + + m .......... fu MEM CD CD CD O O O u O O CD LD TJ O LO CD O LD LO LD LO 00 Ln m m r, M m 0 Cl CD CD CD CD CD O O O O F E CD CD CD CD C� CD C� CD C� Ln Ln Ln N r-4 � r-4 � CD CD Cyill CD CD O O O O E CD -b�l CD -b�l u C. uj TJ In kl ce fU kl t 0L TJ kl M CD m LD LD O O fl� rl� rl� tF� tF� Ln m m 0) O O m CD CD O Ln CD CD O LO CD O LD LO LD LO CD rj 00 00 + + CD CD CD CD CD O O O O O O CD LD LD O LO CD O LD LO LD LO 00 Ln m m r, M m CD CD CD CD CD O O O O O CD CD CD CD C� CD C� CD C� Ln Ln Ln N r-4 � r-4 � CD CD CD CD CD O O O O O CD -b�l CD -b�l CD CD O O CD O CD O CD O CD CD tF� tF� CD CD CD CD CD O O O O O O CD LD LD O LO CD O LD LO LD LO 00 CD 00 00 CD CD CD CD CD O O O O O CD -b�l CD -b�l kl CD O 00 V) IQ Uj z uj uj N a kl ai ni tll Ism U................ cc: ............. fu OEM Ism . . . M .......... fu MEM u 0 Cl Cyill ni E IOIOJ u C. uj CY TJ kl ce tll kl t 0L TJ kl kl ai CD m m O rV rV CD Ln Ln L CD m m cc� - c CD rl rl O rl� rl� kl cx) o) 2 0 CDMs Ism .&J CD........... ru OEM Ism gs . .......... ci m .......... fu C� In MEM u TJ i F E Cyn wu ni E u C. uj In 0 In TJ kl ce tll kl t 5, LL TJ 0 kl CD m m O rV rV CD Ln Ln L CD m m cc� - c CD rl rl O rl� rl� kl Ln - ,D ; LD rl cc� � Ln M m M r-4 Ln O Ol Lq Lm 00n r-4 r, Ln kl ni tll Ism CIO q) U................ (V rc: ............. fu OEM Ism m .......... fu IIn y. MEM u 0 Cl F E Cyill ni E u C. uj 0 TJ kl ce tll kl t 0L TJ kl Ln - ,D ; LD rl cc� � Ln M m M r-4 Ln O Ol Lq Lm 00n r-4 r, Ln kl kl rl rl CD CD Lq C� C� C� N lD N lD M rl CD 00 00 CD 00 00 CD -bP, -bP, CD CD O O CD O cx) o) CD O 2 0 CD CD CD 0 Ism fn 0 CD CD t- CD CD CD............. CD C ru C� OEM Ism Lq Lq CD . .......... r-4 r-4 -bP, m .......... fu Cy In MEM V) IQ u TJ 6 - FCa Ilk uj F E uj uj ml Cyn wu E x u C. uj ail 0 Z - u In ml fU 0y TJ kl x mi ce va t 5, LL 0 kl rl rl CD CD Lq C� C� C� N lD N lD M rl CD 00 00 CD 00 00 CD -bP, -bP, CD CD O O CD O CD O CD O CD O CD CD 0 CD CD 0 0 0 CD CD CD t- CD CD CD C C� Lq C� C� Lq Lq CD r-4 r-4 r-4 -bP, -bP, CD CD CD CD O O O O CD CD CD CD C� C� CD r-4 0) CD CD CD CD CD CD CD CD CD CD CD CD CD CD 0 0 0 0 0 0 CD CD CD CD CD C CD C CD CD CC� CD r-4 r-4 r-4 V) IQ - FCa Ilk uj uj uj ml x ail ml x mi va Ir� uj z uj > cz I I CD �q Ln rl C� r-4 CDt- O� Or� t- cx) o) O 2 0 CD rl rl r Ism Ln LO Ln LO C6 ti CD............. 0) ru X OEM Ism 00 00 4 d .......... CD CD CD O O O O O M CD CD CD .......... fu CD Cy In MEM CD C� CD C� CD C� CD CD u m m CD r-4 r-4 r-4 CD CD CD CD Cy In CD O O O O CD -bPl CD -bPl Cyn wu E u C. uj 0 0 u In V TJ E < .1 ce E fU E kl t 5, LL TJ 0 kl CD �q Ln rl C� r-4 CDt- O� Or� t- O O O Ln rl rl r Lin Ln LO Ln LO C6 ti 0) 0) 00 X 0 0, 00 00 CD CD CD CD CD CD O O O O O O CD CD CD CD CD CD CD C� C� CD C� CD C� CD C� CD CD m m m CD r-4 r-4 r-4 CD CD CD CD CD CD O O O O CD -bPl CD -bPl CD CD CD CD O O O O CD CD CD CD CD CD C� C� C� CD CD m CD r-4 O Uj > 2 S •z oujj�25"E > uj X 0 0, m 0 I I au as as kl CD CD CD CD O O O O CD C� CD .-I CD CD CD CD O O O O M CD Ln CD GC� M CD Ln CD N LO I weu cx) o) 0 CDCC IIS Ism CD........... ru OEM Ism Cis .......... M cl, .......... fu y. MEM u TJ 6 uj Mry X as iv 2, > uj > W cz u 0 Cl Ca F E Cyn wu E u C. uj 0 0 z - u In TJ kl ceaCy fU kl t 5, LL TJ 0 'cJ a17 kl kl CD CD CD CD O O O O CD C� CD .-I CD CD CD CD O O O O M CD Ln CD GC� M CD Ln CD N LO I weu IIS cl, 0 uj Mry X as iv 2, > uj > W cz u uj Ca CD CD O O M m Lr) Lr) cc� cc� uj z eu uj uj a, ml I'd w cl, 0 2 ch. O W M N O 7 O 7 CD O � m rl O v Ln 7 M Lf1 7 7 01 + M O + + M + 7 o W C 7 o LLq 0 O O LO O O O .--i O N CD 01 cc l0 NO ON Lf1 O Ln W W W. --I N O LO fl Ln O Ln O .~-i 0 0 1 7 00 7 O O O M M O O 7 .--I Ln .--I 7t\ v .--I fl m LO - N rle O O O O O O O O O O O O O O O O Ln 0 001 o 0 ^ 00 7 0 � 0 N W 7 O v � v '-I 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 N O O O O 7 O LO O O N m .--I 00 00 t- Ln rl 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 O O O O O O O O O N O O O O 7 O LO O O N m .--I 00 00 t- Ln rl r a 4j cx)������� ) 0 CD fll,, mA Ism o�A ru Ism CPN TJ p u Aw a �A In y. C r^ va'll ai as as ,„a � n In 0 CC"b LLYy in z LLey e.z a'Y Q y IF-� caUJ W r r cz as as • is t6 n FE Cyn fU ca t6 a� E I C. c: uj x 0 L_ u Cn : V fU 0y TJ fU � kl ce TJ � DC7 C: fU kl fU U 5, LL TJ 0 'cJ QL7 kl O W M N O 7 O 7 CD O � m rl O v Ln 7 M Lf1 7 7 01 + M O + + M + 7 o W C 7 o LLq 0 O O LO O O O .--i O N CD 01 cc l0 NO ON Lf1 O Ln W W W. --I N O LO fl Ln O Ln O .~-i 0 0 1 7 00 7 O O O M M O O 7 .--I Ln .--I 7t\ v .--I fl m LO - N rle O O O O O O O O O O O O O O O O Ln 0 001 o 0 ^ 00 7 0 � 0 N W 7 O v � v '-I 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 N O O O O 7 O LO O O N m .--I 00 00 t- Ln rl 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 O O O O O O O O O N O O O O 7 O LO O O N m .--I 00 00 t- Ln rl r a fll,, mA o�A CPN r^ va'll ai as as ,„a LLYy in z LLey e.z a'Y ' m caUJ W r r cz as as Ln Ln7 M M Ln M 0 LnM O O O O O O O O M M O O V) IQ CA Ilk F -- Lu �y a uj uj > CY% mA r ail fl.. mA m inu.ma my °r s r.L. CD C� �CDq Ln Lq CD t: CD C� LLnq Ln Lq 00 m r, O m Ism 1461 CIO U................ r-4 m m N .w„„ fu OEM Ism CD LO CD CD O TJ CD CD m + .......... fu In y. + Ln M ~ 7 + u + + Ln CD CD IQ m CD - - C� r� C� 0� 0� m M Ln 01 r-4 01 r-4 Ln Lf1 F E LO LO uj CD CD � m Cyn llca m m C� O� z L E 00 t- �D u C. uj CD CD CIL Bey r, 0 Z - u CD CD CD CD In CD CD O O O O O O O TJ CD CD CD CD m Ln kl C� O� �q C� C� m t- t- r, r,, CD m r, r-4 ce Ln CIL Ln Ln fU kl CD CD CD CD t 0L TJ CD CD O O O O kl CD C� �CDq Ln Lq CD t: CD C� LLnq Ln Lq 00 m r, O m m O Ln r-4 m rl� m N ti t - CD LO CD CD O CD CD LO LO CD CD + + Ln M ~ 7 + . + + Ln CD CD IQ m CD - - C� r� C� 0� 0� m M Ln 01 r-4 01 r-4 Ln Lf1 LO LO uj CD CD � m CDq m m C� O� z L C� 00 t- �D CD CD CIL Bey r, CD CD CD CD CD CD CD O O O O O O O CD CD CD CD m Ln CD C� O� �q C� C� m t- t- r, r,, CD m r, r-4 Ln CIL Ln CIL Ln Ln CD CD CD CD CD CD CD O O O O O O O CD CD CD CD CD CD LO CD O CD O CD LO CD LO in CD CD CD CD CD CD CD O O O O O O O CD -b�l CD -b�l CD CD CD CD CD CD CD O O O O O O O CD CD CD CD CD CD LO CD O CD O CD CD LO LO IQ Ilk uj z uj Bey in mi Ira 01 W r IrBey w in z > W cz u uj 01 CD CD Lq �CDq CCD CD C� C� � m �D Ln rl Ln CD cr-4 r, rl rl CD cx) o) CD 2 0 CDfU 10 + O Ism fn 0 O CD CD CD O CDII ............ ru O OEMTJ Ism 0J y^ q CD .......... WOO 00 IIS CD Ln 00 m CD L'i 00 rl .......... fu Cy In MEM rl rl u Ln In Ln Ln V) IQ F E - FCa Cyn wu Ilk E uj u C. uj In uj uj > uj TJ kl ce fU kl t 5, LL TJ 0 kl CD CD Lq �CDq CCD CD C� C� � m �D Ln rl Ln CD cr-4 r, rl rl CD CD CD - Ln CD O O O r*� 1-! O 0) 00 0) CD 00 - c� Ln �D rl rl CD CD CD CD CD CD O O O O O O CD CD CD r-4 CD CD O O O Lq O O Ln 00 rl CD CD CD CD CD CD O O O O O O CD CD CD O CD CD CD Ln Ln CD CD CD CD CD CD CD CD CD CD CD CD Ln Ln M G� 00 .-I Ln t - CD CD CD CD + + 1 CD 10 + O O O O O CD CD CD O Ln CD O O O ^ 0J O CD ti WOO 00 O CD CD Ln 00 CD L'i CD L'i 00 rl CD CD CD - Ln CD O O O r*� 1-! O 0) 00 0) CD 00 - c� Ln �D rl rl CD CD CD CD CD CD O O O O O O CD CD CD r-4 CD CD O O O Lq O O Ln 00 rl CD CD CD CD CD CD O O O O O O CD CD CD O CD CD CD Ln Ln CD CD CD CD CD CD CD CD CD CD CD CD Ln Ln M G� 00 .-I Ln t - CD CD CD CD CD CD CD CD O O O O O O O O CD CD CD CD CD O CD CD Ln CD O CD L'i CD L'i rl rl Ln Ln Ln V) IQ - FCa Ilk uj uj uj > uj 14 in uj M in 2-1 W I I W uj > V, � :r W > uj 0 W 01 ::: `� rn,s as �6 as as cn 0 rlj Ln (D <D r, r, C! I: C! C! I: I: N m Ln Ln pl 00 LD I- I - Lr CD to to yr en CD CD CD CD C! C! C! C! r, CD rlj CD clC� CD m O rq CCb Ism I.&J ail .............. rc: ............. fu OEM Ism va rca �a as ci m ca .......... fu y. MEM uj CJ u W > M oujv,f:: > w r "E cz u uj 01 as as as > S S 0 Cl F E Cyill E u C. uj 0 TJ In kl ce fU kl t 0L TJ kl cn 0 rlj Ln (D <D r, r, C! I: C! C! I: I: N m Ln Ln pl 00 LD I- I - Lr CD to to yr en CD CD CD CD C! C! C! C! r, CD rlj CD clC� CD m O rq 9 na ail va rca �a as ca uj CJ 11 W > M oujv,f:: > w r "E cz u uj 01 as as as > S S 9 r-4 o 11, o o LLq 01 111 01 M 7 W OJ Lf1 N 7 01 fl N N N 00 O O O O O O O O 2 0 CD + � A t6 fU Ism O O W O D II .......... A ru � OEM Ism 0 y^ q w,a CD 00 TJ 'cJ n 00 IIS .M -I M �...� 00 01 111 7 01 fu Cy In MEM N ai i u �a rca � n 0 as f ca CC"b asi 1�1 tv Q y IF-� '1 a S ,: c2 y M cz 11,. �y c • is t6 Cn : �y n ill ca t6 a� E C. e: x 0 L_ u cn : V fU 0y TJ fU � kl ce TJ � DC7 C: fU kl fU U 5, LL TJ 0 'cJ ¢17 kl r-4 o 11, o o LLq 01 111 01 M 7 W OJ Lf1 N 7 01 fl N N N 00 0� 7 N O O O 00 .N -I LO 111 LO O Ln M O N O N O 00 O O O O O O O O O O O O 001 n .M -I O O 7 W N 0� 1 r Lri O O O O O O O O O O O O Ln O + + M O O M O O O O O W O Ln o LMf1 � 0 0 0 CD 00 Ln 00 Ln 00 O 7 .M -I M 00 01 111 7 01 N 00 N ai 0� 7 N O O O 00 .N -I LO 111 LO O Ln M O N O N O 00 O O O O O O O O O O O O 001 n .M -I O O 7 W N 0� 1 r Lri O O O O O O O O O O O O O O O O O O O O M O O O O O W O Ln '-I Ln 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 O O O W O Ln '-I Ln O rn t\ 7 00 0 0 Ln rn O CD Ln O O 7 CD O O CIL7 CDt\ '-I O CD O CD Ln O O 7 CD O O CIL7 CDt\ '-I O CD r r �A �A na ail w ai �a rca va �a as f ca ue.l uj > uj is d'1_ asi 1�1 tv i CIn �Ci 1 Lw,J �1 >j '1 a S ,: c2 y M cz 11,. rn t\ 7 00 0 0 Ln rn O CD Ln O O 7 CD O O CIL7 CDt\ '-I O CD O CD Ln O O 7 CD O O CIL7 CDt\ '-I O CD 't rlj CD �D �D Lq N O m m O 00 fU Ism 1461 U................ m . . .... fu CD OEM Ism r-4 O O O O O CD rl rl L�D m +n + M m Ln .......... fu Ln Ln MEM m m uTJ m 00 CD Ln 6 t- Lr Ln O CD C� CD C� N v CD r-4 CD r-4 CD yr en 0 CD r-4 Cl � O O O 00 m ti rl m CD C� m m N r-4 CD CD CD tp, ;� CD CD Cyill ca CD CD O O O O E CD -b�l CD -b�l u C. uj 0. Z - u TJ In kl ce fU kl t 0L TJ kl 't rlj CD �D �D Lq N O m m O 00 00 00 CD N CD r-4 r-4 O O O O O CD rl rl L�D m +n + m m Ln + Ln Ln CD r1l m m m m 00 CD Ln Ln t- Lr Ln O CD C� CD C� N v CD r-4 CD r-4 CD yr en CD CD CD r-4 r-4 � O O O 00 m ti rl m CD C� m m N r-4 CD CD CD tp, ;� CD CD CD CD CD O O O O O CD -b�l CD -b�l � --! CD C� rl Lq rl Lq N m m O 00 rl Lr rl Lr� CD CD CD CD CD O O O O O rl CD rl rl m CD C� m m Ln CD r1l CD CD CD CD CD CD CD O O O O O CD CD 1-6- t`� CD CD CD CD CD O O O O O rl CD rl rl m CD C� m m Ln CD N CD r-4 CD r-4 � � kl V) IQ Ilk uj uj uj > uj CY-1 I'd cl, w rl I CNI E 0 U ig N rl CD rl LD LD M LO O O O O fU Ism 1461 �D U................ 00 M r-4 LrL cc� M Ln rl LnL . . .... fu OEM Ism M M N CIL M va M .......... fuIIS In uj If1 u W CD Ln CJ TJ 6 1 W Uj > uj 01 0 > W I I j 5� c2 ill uj (M 0 0 u In TJ kl ce t 0L kl N rl CD rl LD LD M LO O O O O �D Ln �D 00 00 M r-4 LrL cc� oyA Ln rl LnL rl LnL Ln r-4 M M N CIL M va uj If1 00 W CD Ln CJ CD CD CD CD O O O O CD CD CD 00 Ln CD CD r1l CIL C� C� LnL 't M - rlj %,D r 00 LnL oyA va uj If1 W CJ 1 W Uj > uj 01 0 > W I I j 5� c2 M + t- CD cx).II II S o) + r-4 Ln lq lq + r, m fU Ism —r) . ........ 00�. rl� O OJ m CD -! fu r, OEM Ism Ln CD Ln� I- rl� Ln Ln CD - CD CD CD CD m r-4 m m r1l IF .......... fu CD y. MEM CD Lr� e CD Ln� CD m 't u r, C� -! L00q O� 00 r-4 m ld� Ln rl� 'l- Ti- rl�, CD m m m 0 Ln r-4 - Ln Cl CD -b�l CD -b�l F E CD CD CD CD CD O O O O O CD -b�l CD -b�l Cyill E u C. uj 0 0 z - u TJ kl ce t 0L M + t- CD 'o, - + r-4 Ln lq lq + r, - - CD Lr� r, rl 00 rl� 00�. rl� O OJ m -! -! r, r, Ln Ln CD Ln� I- rl� Ln Ln CD - CD CD CD CD m r-4 m r-4 m r1l IF rIT CD e O CD CD Lr� e CD Ln� CD m 't r, r, C� -! L00q O� 00 r-4 m ld� Ln rl� 'l- Ti- rl�, CD m m m LD N Ln r-4 - Ln - Ln CD -b�l CD -b�l CD CD CD CD CD O O O O O CD -b�l CD -b�l CD I- r, - - O OJ fl� lq lq M r, - - CD Lr� r, rl 00 rl� 00�. rl� m �D Ln Ln 00 Ln I- r -4 I- r-4 CD CD CD CD CD O O O O O CD CD CD CD O CD CD Lr� CD Lr� CD Ln� 't Ln Ln �D rl� 00 ld� rl�t- rl�t- Ln yr en CD CD CD CD CD O O O O O CD -b�l CD -b�l kl N N in 0 kl r-4 Ln N t- CD CD CD CD rl� 00 rl�00 I: CD CD I- 00 00 Ln LO LO O CD CD r14 CD CD 00 m Ln N OJ m 01 01 O CD CD m N CD CD Ln CIL CIL rl�, LD LD CD Ln Ln Ln m m � CD CD CD O O O CD CD CD -b'I, -bP, -bP, �D 00 O LD Ln tF� CD CD CD O O O CD CD m CD CD I - CIL CIL cc� m 00 cc� Ln CD CD CD O O O CD CD CD tF� 16- 16- CD CD CD O O O CD CD m CD CD I - CIL CIL cc� m 00 cc� m m Ln -bP, -bP, r14 rl V) IQ IQ Ca Ca uj Qj >uj uj CY-1 Ism 141 U................ fu OEM Ism m .......... fu C� y. MEM u 15ry C. Cy 0 Cl F E Cyill E u C. uj 0 V TJ E < 15ry C. ce E fU E kl t 0L TJ kl in 0 kl r-4 Ln N t- CD CD CD CD rl� 00 rl�00 I: CD CD I- 00 00 Ln LO LO O CD CD r14 CD CD 00 m Ln N OJ m 01 01 O CD CD m N CD CD Ln CIL CIL rl�, LD LD CD Ln Ln Ln m m � CD CD CD O O O CD CD CD -b'I, -bP, -bP, �D 00 O LD Ln tF� CD CD CD O O O CD CD m CD CD I - CIL CIL cc� m 00 cc� Ln CD CD CD O O O CD CD CD tF� 16- 16- CD CD CD O O O CD CD m CD CD I - CIL CIL cc� m 00 cc� m m Ln -bP, -bP, r14 rl V) IQ IQ Ca Ca uj Qj >uj uj CY-1 W+ t6 � cn 'cl ro CI�.y n l . U C: V kl rl W .--i O 7 .--i N N O m m m O rl O 01 N O1 OJ r* M Lq LO O .ti Lf1 rl O n O .ti O m m LO LO O O M .ti n m Ln Ln Ln m OJ 7 Ln 7 W n Ln .-I Ln 01 M LO O M OJ O1 7 Lf1 rl 1p 7 M r, l6 M 7 .--i O Ln M .--i m LO 7 M O M N LO rl O O1 O rl n 7 O rl N W N N Ln 7 Ln 7 N m CD 7 O N � t � O t t OJ .ti n lD M m 7 rl O 7 m 7 O lD O N O Lq LO rl 7 M Lq O OJ OJ N O rl O .ti M m O rl 7 M O LO Ln OJ N 7 O 00 CD OJ Lf1 O N M O m TtW 7 O M Ln m 0)N O1 O rl� O .-- M i 7 .-- O i 01 N M 01 01 7 O O .--I M - 7 O Ln O OJ OJ 7 01 Tt Ln Ln N M 7 N N M LO M rl t- r\ t - N m rl 7 7 m LO M O LO .ti .--I O m O rl O1 M M LO Lq LO rl O .--I O M O Ln O Ln m O - n W N M W n rl 7 LO O N N LO OJ Ol N n lD .ti O M O1 rl n L .-I M N OJ 01 lO M N lD W O M .--i r-4 7 M N N Ln N M N rl M rl O O LO O M O O O O O O m O m O O O O O LO O O rl O O O 7 O OJ O Ln O M Ln LO OJ LO .� O1 .--i rl N 7 W Ln 01 01 N OJ M M rl LO Ln N m O m N M N m O LO O m O - O Lf1 O1 M OJ O O 7 O1 O OJ Lf1 rl O Lf1 O M - n 7 m n lD 7 M OJ Ln LO M LO M OJ LO rl n W .--i r, N rl N N 7 Lf1 M rl .--I n n n .-- OJ Ln I M .--� 7 OJ 7 M 01 7 O 7 LO .ti M lD O LO Ln 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 O O O O rl 7 01 O lD lD Ln LO OJ LO O OJ O Ln rl Ln CD Ln rlj Irl m m CD O N LMf1 O1 O O lO O1 7 7 n O1 7 O Ln 7 OJ LO .--i 7 n n M 01 M 01 O O O O1 LO Tt Ln M Ln OJ LO Ln LO Ln 01 Ln lO M 7 r, lD N O n O 7 W N .-I O O O O O O O O OO O O O O O O O O O O O O OCD O O O O O O OO O OJ CD 00 OCD CD m OJ O 7 7 M 0 p 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 O O O O rl 7 01 O lD lD Ln LO OJ LO O O O M M M Ln rl Ln .-I N Ln N rl M O O O N Lf1 O1 N O lO .ti 7 OJ rl Lf1 O O Ln 7 W lD 01 Tt n 7 M Ln 7 M W O O 01 LO Tt M M - Ln OJ .-I Ln Ln 01 Ln 01 7 Ln LO M 7 r, lD N W n O 7 oo N ti CD 7 O O 01 M N 7 0 CD CD OJ OJ 7 7 OJ OJ 7 7 M M O O O O 7 7 N N O O O O Ln Ln Ln Ln O O O O OJ OJ O O rl rl OJ OJ Vf 1tR O O O O OJ OJ 7 7 Lf1 Lf1 OJ cc cOc J 7 7 Lf1 Ln tF� tF� V) d M� �. Ca uj i'_ uj����I����• X. uj 7 w^M "lS f,l,s V) tdd tV M CJ V) tdd tV tV O �1 IIS ujC1 ' y uj HIS f: �a �d � Xu V L1� as rr c PdM O Y'1 I I Mi Y II t,.7 as Y CM f (IS E a `X �. i C d V+ td) 5 �i �V s SS':o' �J X Gt,7 f.. Yt. I �d f Y'1 01 �*X coCI l%. III td) c lX'�' III rd In MX �+ as iv + .. X'y 0d f, M? CD 7 O O 01 M N 7 0 CD CD OJ OJ 7 7 OJ OJ 7 7 M M O O O O 7 7 N N O O O O Ln Ln Ln Ln O O O O OJ OJ O O rl rl OJ OJ Vf 1tR O O O O OJ OJ 7 7 Lf1 Lf1 OJ cc cOc J 7 7 Lf1 Ln tF� tF� V) d M� �. Ca uj i'_ uj����I����• X. uj 7 w^M "lS f,l,s TJ � DC7 kl fU fU 5y LL TJ 0 'cJ ¢17 kl kl O O N N LLq O O O CD O of 7 N M W t t N O ^ t t t t ti Ln O t t t t rl fl ON CD O t t N co LD 0 0 o Ln LLn 0 0 r f� 0) N O O Ln M LO O O O O O fl M O O Ln �a ai va M 6fY 0 0 0 7 LLq 0 0 f 00 Irl Ln O O 7 M of LD 00 N Ln O O O O O O O O O O O O O O CD CD CD CD CD CD O O O N O O O W N O OJ �D Irl Ln Ln O O O O O O O O O O O O O O O O ti O O O O rl fl ON CD O N LD LD r f� 0) N LD r f� 0) 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 O O II O fl fl O N O O N LD LD r f� 0) N O m 00M 0 7 O m 00M O O O O N N t\ t\ 7 7 O O Lf1 Ln tF� tF� V) �. Ca uj i'_ uj a 8 uj CPN fR N lS f,l,s ro Y II �fR �a ai va v+ vi 6fY V LLY.1 f V �s uj Ma u, X X71 Ma X� Cd t7 o Xo cc 4 t) O m 00M 0 7 O m 00M O O O O N N t\ t\ 7 7 O O Lf1 Ln tF� tF� V) �. Ca uj i'_ uj a 8 uj CPN fR N lS f,l,s ro CD CD OJ ON N 7 O O Om O � Ln m Ln � � LO M Lf1 Lf1 M N Ln LO .^—I fl ON 7 N t- 0) 7 7 O + O m + + O + o + + + M N + W O O O - O O Ln OO LO LO O O O OJ O OCD O O1 O1 OCD CD Ln m N N M O O1 fl M O O Lf1 O CIL O O M Ln M 7 N 07 07 - M 7 N M Lf1 L N N t `r t `r O O O N O O Ln Ln O N N O O O 7 O O OJ —i O 7 7 N - N 0 0 N N Ln 07 01 M M N N 01 Ln Ln N N O O O fl O O O Ln O N N O O O fl O O O W O lq lq CD Ln rl rl O lD Ln --I --I O O O M M Ln OJ Ln 01 01 fl .--I N N M M O O O O O O - Ln O LO LO O O O N O O O1 LO O fl t\ OJ O O O CD W o 0 tPr V} O O O O O O O O O O O O O O O O O O O O O O OCD Ln M O N 7 N N N O O N N 07 Ln 07 N fl O O M Ln O O O O O O O O O O O O O O O O O O O O O O O O Ln .—I LO LO O O N N 7 7 O O N M M O Ln OJ OJ Ln fl l0 l0 fl t\ 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 fl O t\ t\ m CD CD CD O O N O N N O OJ O O N Oi Oi Oi fl O 7 t- .^-I M M N N V) IQ �. Ca uj Z II uj Ilry a- r Y uj O CNI ml T II dlry O• Ell M� W W cr =s "fi asi M W n z. e.i Ly as � as e.s e.s 0,Iuj Ma as ,a Ma ca `al rsi M TJ � E E kl fU fU 0y LL TJ 0 'cJ ¢17 kl O O O m O m m O O O O O N O O O O O O O O N O O 7 O O O O O O r, r, 7 O + + N + o OJ + + + N + ++ O O O 0) O 0) 0) O O O O O O O Ln O 7 7 LO 7 7 OJ CIL CI M M �. Ca 0) M m O M N tF} N tF} O O O N O O O O O1 O CD CD 7 O M '-I O O O 0) O O O O O1 O Ln Ol O N Ln m O N 0 0 o LLq 0 N 7 .ti ti O O O O O O O O O O O O O O O O 7 t, t\ M O O O O O O O O O O Itt 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 r, r, 7 r, W OJ M M M V) IQ �. Ca F-- uj C z uj „II G3_ Y j 1�1 I'd Y C 0 on8 II � w dlry CNI CPN N u CfY i� uj 6'X'y V) f tX) ,'> > i 0 M M Loll v e.X uj '` as v 0 Ma Itt TJ � DC7 fU kl fU fU 5, LL TJ 0 'cJ ¢17 kl CD m CD CD CD CD o M Ln N 7 .--I Ln Lr m O N d 7 N Ln .-I O O O fl LO O OJ O O O O CD CD CD CD r1l OJ fl ti WC7 N ti ti ri .ti O rl CD LLq 0 0 0 0 0 LSO O 0) O M O O fl O N 7 N M N O O O O O fl LO N O O O O Lq LO O O M O O O LO M M OJ OJ ri - 7 O O O O O O O O O O O O O O 01 Ln O O fl 7 N Lf1 M M fl O1 7 N Ln Ln Ln fl N Ln N r W O O O O O O O O O O O O O O Ln Ln rl tl 7 M fl Ln t - r -4 O O O O O O O O O O O O O O LO O LO LO O O N Lf1 Ln OM OM O LCD Of1 7 N Ln Ln N O N O OJ Ln 00 100 7 .ti !Pr CD O W rl CD'-I N rl '-I O O N CD O CDO OJ Ln O1 01 00 OJ V, ., uj VT z u a - X. uj CD O OJ CD O O N CD O CDO OJ Ln O1 01 00 OJ 11 3 11 CfY V'a lX CfY,� ISS s+'uj '_0 uj O <J Va 0 III ::::::s 0 x. cuj N LO .^-I + Ln t 00m - CD CD N OJ O1 O O O M ti W N 7 O M W N Ln O 0 7 7 7 07 O M N Ln .-I O O O fl LO O OJ O O O O CD CD CD CD r1l OJ fl ti WC7 N ti ti ri .ti O rl CD LLq 0 0 0 0 0 LSO O 0) O M O O fl O N 7 N M N O O O O O fl LO N O O O O Lq LO O O M O O O LO M M OJ OJ ri - 7 O O O O O O O O O O O O O O 01 Ln O O fl 7 N Lf1 M M fl O1 7 N Ln Ln Ln fl N Ln N r W O O O O O O O O O O O O O O Ln Ln rl tl 7 M fl Ln t - r -4 O O O O O O O O O O O O O O LO O LO LO O O N Lf1 Ln OM OM O LCD Of1 7 N Ln Ln N O N O OJ Ln 00 100 7 .ti !Pr CD O W rl CD'-I N rl '-I O O N CD O CDO OJ Ln O1 01 00 OJ V, ., uj VT z u a - X. uj CD O OJ CD O O N CD O CDO OJ Ln O1 01 00 OJ 11 3 11 CfY V'a lX CfY,� ISS s+'uj '_0 uj O <J Va 0 III ::::::s 0 x. cuj v rn v � � o Lq LO Lf7 M M M OJ m o o m � v m m .--i Ln O 7 v of Ln 7 Ln M m 00 7 7 N 7 .--I m rlj N M CD fl m 0) CDrl 00 LO Lf7 M M M OJ N Ln W fl t\ l0 fl W O OJ N O M O O 7 M M N 00 7 m M m 00 N Ln 01 0) fl '-I M O N .ti O O O O O O O O N O O O N O fl N 0) O 00 LO Lf7 LO M LO O m l0 01 W N M 7 fl t\ l0 fl .ti M 01 O m N m 7 LO M M O 01 00 7 m M m 00 N Ln 01 0) fl '-I M O 7 O O O O O O O O O O O O O O of of tl N .--i CD W OJ N 7 7 M 7 M M N LO LO O .ti M t\ M LO M O M O- N m cc .–I N fl N t\ 0 d 0) N N ~ M O O O O O O O O O O O O O O O O O O O m l0 01 W N M 7 fl t\ l0 fl O - ~0) CD N 7 OJ M N 7 01 M M O 7 O O O O O O O O O O O O O O Ln O Ln rl r\ Ln r\ Ln ur Lq 0 7 t\ CD N Ln M co7 rlO O 00 01 '-I O O CD N M O 7 M rl r\ Ln r\ 00 Lq t\ CD N Ln M co7 rlO O 00 01 '-I O O CD N M O 7 M K&I O O O O O O O O O O O O O O O O O O - l0 7 M M O O 01 OJ M O 7 l0 � .^–I .^–I O 01 .--i 00 LD O of of tl N .--i W OJ N 7 7 M 7 M M 7 7 4P) IQ M �. Ca uj 4P) '......Y uj����I����• a- uj 0 0• W6U CSS M U 6U bW r C J S"U �1 „M @ull U Ir} Cf} 0 C1 o r} M' Y 7" W6U CP'i cri `r s' WLr• rl } uj d; "k �) cc 417 uj w Cj uj w M fs Va Y7 ":a VA Yui r:; r i K&I C r, - �q r-4 �q CD C� m C� w m ,-Z r, r, cc� %,0 00 m 01 - CD 0) m LD + CD cy-, + + Cn Ln r, Ln Lr1 CD O N 00 CD 00 n uj CILp cc� r, Ln N V) Cn co CD M (1) OJ 00 7 CD O CD O is M LO r-4 r,0) X. 0 uj �z m CIL rl�. r, C� cDr, C� F-- r-4 r, CIn wu Ln m N N CD OO1 r, 00 - cc� CD O CD O - Ln CIL E00 u uj 't r-4 O CD O CD O CD U� 0 m r� CD (1) cD Ln cc� r-4 r, rl� Ln S F -- u -j t w CD O CD O CD O CD O CD O -a r1l CD0) E CD Ln < m Ln M Ln LD - CD Ln m CD m 0) CD CD CD CD CD O O O O O 0) Ln Ln CD M M CD CD CD CD CD O O O O O N CD CD ti CD CD M Ln CD CD Ln LD Ln CD M - m lD 00 00 r- II x uj V) 0 uj a - M X. 0 uj �z r co 00 00 r- TJ � DC7 E C: E kl fU fU 0y LL TJ 0 'cJ ¢17 kl kl CD Irl CD CD CD CD CD N 7 O fl O O O O O 00 m O t- . ti M .--I M 7 N tl N O N t t Ln ^ N t t t t t t Ln Ln t t t t t t t t t t Ln .-I .-I O O O O O M N LO Lq O O O O M 0) 0) MN 7 O Ln v O S CD rl Ln m m CD CD CD CD O M fl M 7 O O O O Ln m O 7 O 01 �D .--i LO - oJ N LO 01 p ti o t\ O O O O O O O O O O O O O O O O O O 00 0 CD W n 7 0 0 0 0 0 CD O W rl LD . Oj t\ Ln Lf7 M Ln M O O O O O O O O O O O O O O O O O O 7 N O O ti Ln ti O Ln M 7 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 7 N O O .--I Ln O Ln fl M 7 O O O O 00 00 M M 7 7 4P) d M� �. Ca uj i'_ IluiO u a - X. fN LL!j• "lS S fI.L.. V) t7d !V M LJ V) l7d .!V lV "lX l7d W PdM 6"+1V' 417 LL1'.1 !V W �''„o lri "X II.I a C1 III uj Vi 0 V fX IiD !a X” (7 fdM O O O O 00 00 M M 7 7 4P) d M� �. Ca uj i'_ IluiO u a - X. fN LL!j• "lS S fI.L.. I" m 110 r LOO 0 .II 0 ............. cj5 ... ........ d ru 3 4 d 0 . .......... u 0 C: ..... Ism fu Cy In uj a- x. uj OEM fj Ism C� In Ca MEM u Cyn wu E u C. uj In 0 In TJ kl kl LU E 5, LL -j 0 kl CD CD CD CD rl� O O O rl 00Ln CD Ln cc� rlj 3111111111111 "m CD CD CD CD O O O O CD CD CD CD CD CD CD CD O Lr 7 CD Ln N CD CD O O CD CD CD CD m m V) IQ uj V) Z uj a uj CPN lX 0) VA VA 911 V) uj a- x. uj fj CD CD O O CD CD CD CD m m V) IQ uj V) Z uj a uj CPN lX 0) Cy - m W In Cy In In F-' Cyn llca E u C. uj In In F -- t TJ 11 _5 kl CD CD CD CD CD O O O O O CD CD -b�l -b�l CD + CD o, CD CD CD CD CD CD O O O O O CD CD CD CD CD CD CD CD N r-4 CD CD CD CD CD O O O O O CD CD -b�l -b�l CD CD CD CD CD O O O O O CD CD -b�l -b�l CD CD CD CD CD O O O O O CD CD -b�l -b�l CD CD CD CD CD O O O O O CD CD CD CD CD CD CD CD N r1l � � CD CD CD CD CD O O O O O CD CD � � CD CD CD CD CD O O O O O CD CD CD CD CD CD CD CD N r-4 V) IQ Ca 10 uj V) uj a- x, uj mi Mi mi Mi uj V) 6 91, z ::::::� cc I" m 110 r II LOO 0 + 00 + t - CD CD CD ............. CD CD cj5 rl ... ........ d ru CD CD 3 4 d 0) iJ CD CD O O 0 . .......... u LD LO LD LO 0 C: ..... Ism fu Cy In CD CD CD CD CD CD O O M M CD CD CD OEM M CIL m CIL m CIL Ism CD CD CD CD CD C� In O O O O O Ca MEM u CD CD tF� -bP, CD CD CD CD CD Cyn wu O O O O O O CD -bP, E u C. uj In fU 0y TJ kl kl LU E 5, LL -j 0 kl CD CD rl + o II + 00 + t - CD CD CD CD CD CD O O rl O CD CD 0) 0) 0) CD CD O O LD LO LD LO LD LO CD CD CD CD CD CD O O M M CD CD CD M CIL m CIL m CIL CD CD CD CD CD CD O O O O O O CD CD tF� -bP, CD CD CD CD CD CD O O O O O O CD -bP, CD -bP, CD CD CD CD I (D I (D O O O O O O CD CD CD (D (D Ln rl rl � tp, (D (D (D (D C! C! C! C! O O (D (D (D (D O C! O C! C� C� C� (D (D C! C! O C! V) IQ uj V) Z uj a uj in vX II II uj in V) 0 uj a a Er U :::::: t ,u M (D (D C! C! O C! V) IQ uj V) Z uj a uj in vX I" m 110 r CD LOO 0 .II CD CC"I O O O O O 0 O ............. CD CD cj5 CD ... ........ d ru CD C� 3 4 d CD C� CD C� CD Lr 0 . .......... u Ln Ln 0 C: ..... CD Ln Ln Ism fu Cy In M l0 l0 M In U OEM Ism Cy In co Z_ I uj u m In C. MEM u V) z Cyn wu uj a - E X. u C. uj uj 0 0 TJ ml x kl mi LU E 5, LL -j 0 kl Lq CM� CCD� Lq O� �Dmrlj CD m t- %,D - t- CD 00 Ln LD CD r� r-4 CD CD CD CD CD CD CD O O O O O O O CD CD CD CD CD CD CD CD C� CD C� CD Ln CD C� CD C� CD Lr CD Lr� Ln Ln Ln CD Ln Ln M l0 l0 V) IQ uj V) z uj a - X. uj ml x mi Iri ra > V) uj a M M uj W Cy 0 - m W In 'cl n5 00 Iq rlj Ln I, I, -J� Cn CD r-4 O fl� 00 In rl Ln CIn CD O CD O CD O CD u uj O O -bPl In CD O I- N I- N 0 In rl Ln rl Ln CD CD V -j t -j t w CD CD O CD O CD O 11 i _5 LL -j 0 i CD CD < CD CD < Llj Llj L CD CD O O kl -j t CD CD 5, O O LL -j 0 i CD CD < rn ni ryj cn 'cl n5 G S � O m O M O O O O O O O O O M O O O O O O Ln L M 7 7 O �D O O O + M + O O O O OO Ln O O W O N O O O O fl O CD CD OCD luCD CD CD 01 0) Ln W 00 00 O O O .--i O O O N Ln LD .–I - fl N .N_. O 0) O 0) O O O O Ln O O .--i O N O O O O N O O W N M Orl O 7 N Ln N Ln f\ ti O N N 0) Lf1 O LO O O O O O O O O O LO O O O O O O O O W M N O �D 0) CD Ln LLq 0 00 0 0 0 0 0 0 O O v f� Ln 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 O 0) Ln Ln Ln O O O O 7 M O O O M 00 r-4 Ln 7 N f, M O O O O O O O O O O O O O O O O O O O O CD CD CD CD CD CD CD CD CD CD O O O O O O O O O O O O O O O O O 0) LrLn LrO O O O 7 M O O O M 00 r-4 Ln 7 N f, M Ln t cc f tLn t esr 0 Ln Ln t Jf t O f 10 Ln t N f y} a (D (D O O O O Lf1 Lf1 Ln Ln tp, tl� V) 0 Ca j X;8 V) N..... z �1 uj a Y LLYj 0 �I Ory X;,A �A 0 N;;87 is fx LL. t6 ryj cn 'cl ro N 7 N O O1 O L0 O O O O N O O O O rl t\ M l0 l0 N W N CD . Ln .ti M O N M O l0 M .--i OJ L0 O O N m O L0 .--i N O1 7 M Ln Ln .~-I O 00 M 7 m fl 7 M m N t t 01 O O M O O t t t t t t t O 7 Ln N N L0 L0O O O O O1 O O O N O O1 O 7 O1 t\ O O O O l0 O O O 7 O Ln CD CD 00 M OJ .Ni Irl W t\ O^ l0 Ln L0 .^-I O O O 7 fl O1 l0 O l0 7 .--i fl O Lr OJ O O N L0 M .--i 07 N fl 7 M .--i .--i LD O Ln OJ O Mm .--i CD 7 N l0 01 W O .--I Ln M O L0 m fl W 7 N O O O O .--i L0 O O m O OJ OJ Lq M Lr1 O O O O O O M O O O Lr1 O 7 m .–I t- Irl .--I M O Ln Ln fl .ti M .--I 7 .--i f, M Ln 01 O 01 7 N M O l0 7 OJ 7 M O N ti m O m m fl 7 ti 7 Ln 7 .--I M M M M 7 m fl W t\ r 7 l0 .--I O O O .--i O O N O O O O O 7 O O O O O O Lf1 L0 O O N O O O O O O1 O O O O t\ Ln L0 O L0 O o rn m v rn o v m N .-4 7 M L0 '-I Lr1 7 � .--I O1 OJ � O O O O O t\ O O O O OJ O ^ l0 W M .--I N O O . M M O1 N O O1 O OJ OJ L0 O OJ .�-I ^ .M -I N 7 r rl 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 00 7 N o) W Ol 7 � O l0 W .--i O O 7 .–I N Lf1 OJ N O1 O1 O O M O1 O O Lf1 07 01 m Ln .--I 7 01 O .--i m 7 O Ln N .-I N 7 OJ fl 01 N t\ t\ O .--i .ti W M 0) OJ rl M N rl .--I .--I N OJ Ln 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 CD CD O Lf1 N O 7 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 O O O O O O O O OJ M 01 N N N Ol O O - O O L0 .�rlj o) -I W N G G O O M N LLr O O Lf1 07 01 m Ln .--I 7 01 O .--I N N O Ln N rl N 7 OJ Irl 0) N fl rl l0 .--I rl OJ M 0) OJ .-I M - 7 .ti - N OJ Ln V) �1 tV M O �1 oy8 tV Cf} oy8 "lS CPN as �1 M� fl • uj ftm" in zca I� .Y} �e y lX Ly,.l r CJ S'> Cf}cc r`;? Vi W 1 Wf',: >I��� ea r'1 ' C Y"I, � � Cf}V'a trs s".a ,�, �a, �1 ca r v s Y'1.. es ep M,s ti Iii �) e.n lX co f . Y'1 u,I�� lX co �} C) <) W <) Cf} , r1 va r, Cc i rl O N N 01 MCI O O O O �D �D 7 7 00 00 OJ OJ t\ t\ OJ OJ tF tF V) IQ �. Ca uj i'_ II ujfl..... a- x. uj CPN O ml 01 ml inIl �q "lS I I.S i W cn 'cl ro LLq 7 Lm0 O O O O O O O 01 M f1) 01 r-4 . 0) O f, �D W 7 rl 7 7 N CD O t t O 00 t t t t t t t m Lmr7 0 0 0 0 0 0 0 f, W CD l0 N Ln O O N N 01 LO M Ln Lf7 N CD W f, f, l0 N 7 .--i CD CD CD CD CD CD CD M N Om O O O O O O O N LO 7 f, O t\ 7 M W 7 W W 0) M 0 0 7 0 0 0 0 0 0 0 fh O^ LLq 0G1 LLq 0 0 0 0 0 0 W O LLn 7 O . W M 7 O N ' 7 O O O O O O O O O O O O O O O O O O O O f, O f, Ln Ln O O LO fl O l0 Ln Lf7 O W f, .--I f, O M - l0 Ln 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 O O O O f, Ln M 7 N LO O LO O^ CD O l0 Ln LOf7 O W f, .--I f, O M - l0 Ln 0 V) �) d V) .tV tV �1 �1 h� Aye ca Y'a.. r.. va 1 > w^M 417 tV �i UJCP'I tV 1 MX CJ f 0 Cl IIA 01 a ?^ ca v v y lX LLJ'.1CiI S I I Q I I r,,.d o r „d t 7 cc fdM O f O f M f y} a F -10E O Nr,, f O f � f 7 t\ t N f rn f M f y} a W i Ln t f, f � f y} a O f O f r rl f� f t6 ryj n v n? O Ol Ill O O N O O O O Ol .–I N O - N 7 O1 O1 �D ip ip N Ln .--I N .--I .ti M 7 7 M ON CD N + + + + t t t t W N M Lq Lq O O M O 7 W LO LrL m O 7 M M 7 LO o Ol O .MMm CD CD m CD -I LO 7 7 O O M O Ln M LO O W - W 7 7 O M 7 N fl M LO W N Ol N O O .--i O O O O O O O O O LO O O O O O O O ti O O LLr N W fl O l0 Lq 7 O O fl O .Tt00 –I O W LSO W .M -I n N fl N .--I .--I Ln O O O O O O O O O O O O O O O O O O O O Ln f, W f, f, Ln N O W CIL M Ol Lfl W M W O N .–I O rl O O O O O O O O O O O O O O O O O O O O Ol f rl � t Ln I Ln I {{} a CD 7 CD7 M f '-I 1p t y} a 7 N f M f M f y} a Clco f M i O f O f O f � f O f N f M f f� f O O O O O O O O O O O O O O O O O O O O O O O O Ln f, co f, f, Ln Ol Ol N O cl CIL M MLLfl O O co M co .--i (D M M N .–I O .ti .--I f, f, rl tl .--I V) IQ M �. CA uj C i'_ II uj a - Y uj ask � C �1 Y CSS ILII..... M C ctii du61 oy8 va �$M r.^ Cf} N...' W61 CPN a va in Ili CfY tXA Yl V'a tX) V'a Mi il �A> r LL.e.lA gwy V)4XA PdM r IFq i'_ CP'} �A r si y cA CA ;v uu ya as Ma ps , ci i ) rAi i u.i raa. I M O .ti Lf7 O O1 O O fl OJ OM m O .--I 7 Ln .ti l0 l0 O M l0 O1 0 0 M N N N N 7 M N N O fl lD Ln M t O - Ln fl W m LO m t Ln 01 t .~-i � 7 LLf1 n o W o N rl W N W Ln Ln O LO fl l0 M lO .ti W M M O7 O fl ti O 00 7 .N -i 7 0 M rlj CD CD CD OJ O M 7 O1 O r( O 't Tt rlj Tt Irl Irl 00 CD O 7 LO M LO LO 01 01 f� l0 Lf7 fl .--I t\ N 7 0 W M N W Ln N N CD CD CD CD Ln CD CD CD O O ON O M O O O OJ Ln M ti O .ti 7 rl .--i O O M M LO O O O N LO O m fl .M -I . O OJ O1 Lf7 M O1 tl N ~ 7 O O O O O O O O O O O O O O O O O O N M Ln O Ln 01 N 7 7 M O OJ M fl lD W OJ Ln '7 W M .--� M O O O N O 7 .--i Ln '-I 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 N M Ln O Ln 01 N 7 7 M O OJ M fl lD W OJ Ln '7 W M �--� M O O O N O 7 .--i Ln '-I OJ N 7 01 M 7 '-I Lf7 Lf7 7 Ln M rl L~f7 7 Lr) O O N C O N O CD M 7 '-I Lf7 Lf7 7 Ln M rl L~f7 7 Lr) O O N C O N O CD 9 V) t7a !V M Y P1 !V tV �I S 0�8 �1 41 ^+ M' �1 Yl X8 uj d; "k 417 ASV �'7 a� Y 0 uj Cf} r. �) In � Vi is a) co > Ca Yl C1 .a ` cj III 01 t"al a ;a f i �+ �? h” a Y7 0 cd C � r i V'+ Y„].. II,.I 01 <7 III II,.I �) CA �1 (5 OJ N 7 01 M 7 '-I Lf7 Lf7 7 Ln M rl L~f7 7 Lr) O O N C O N O CD M 7 '-I Lf7 Lf7 7 Ln M rl L~f7 7 Lr) O O N C O N O CD 9 Cy 0 - m W In kl CD - CD O fl� O 0) N cc� t: cc� m II cl, w uj V) 0s 0 z uj uj ai Ma as X ca Cyn llca E u C. uj In 0 ni In TJ kl E E klt B 5, LL -j Cl 'cJ a17 kl kl CD CD O O Lr) Lr) Lri Lri V) IQ uj V) ZII uj a - X. uj I'd cl, w rl I CNI E 0 u ASV lS ig CD O m rl�rl� m Cl a- M N N N m r-4 r-4 r-4 Vf + t + + Ln C� CD O 00 rl rl W rl r rl W ,7, Lri r-4 Ln r-4 Ln J' N r-4 CraCy n CD c� (1) Lq (1) Lq Cyn llca E u C. uj In 0 ni In TJ kl E E klt B 5, LL -j Cl 'cJ a17 kl kl CD CD O O Lr) Lr) Lri Lri V) IQ uj V) ZII uj a - X. uj I'd cl, w rl I CNI E 0 u ASV lS ig Cy 0 - m W In Cy In In Cyn llE u C. uj In 0 E In a, V fU 0y TJ C. 0 0 CD LD m CD CD O N 1-! O O CD LD Ln cc� G� ld� m 0) r-4 N CD m O 01 Ln W CD O CD O 00 rl� 00 ", rl t- r1l r1l rl LO r1l 00 CD Lf1 CD Lr� N M m Ln rl Ln r Ln CD CD CD CD CD CD CD O O O O O O O CD 00 CD 00 00 CD m C� CIL CD C� > m CIL m CIL rl lD CD m m N LD LrL r-4 00 :5 Is Laj 00 00 Ca III Y M M CD CD CD CD CD CD CD O O O O O O O CD � CD � CD CD CD CD CD O O O O O CD 00 CD CD m CD C� CIL C� rl lD CD N LD r-4 LrL 00 > Ir� uj 911 V) :5 Is Laj "'ifa Ca III Y M M as uj Cy Cy In co Z_ In C. 0 m C C C C C O O ti r, r-4 CD CD CD CD t- r-�m CD CD CD O , CD CD CD 0) t - CIL CD CD CD N Ln r-4 - LD Ln r-4 CD CD CD 00 + + fl� O O O O m m CD CD CD CD N CD CD CD O 0) CD CD CD r, CD CD CD CD Ln r-4 Ln r-4 ,t� - CD CD CD CD N O O O O m CD CD CD CD fl� O O O O CD CD r1l CD C� CD - CD CD Lr Ln CD - C� (1) Ln 00 00 t - Ln rIT CD CD CD CD CD CD O O O O O O m t- CD CD CD CD O LO O O O O Ln Ln 00 Ln Ln ld� N CD CD O O CD O CD O CD O CD O Ln CD CD CD CD O Ln CD Lr� Lr� CD C� CD - CD C� m Ln Ln CD - CD M Ln CD Ln CD CD CD CD CD CD O O O O O O CD CD CD CD CD CD O O O O O O Ln CD CD CD CD Ln CD Lr Lr CD C� CD - CD C� M Ln Ln CD M Ln CD O CD Lr) CD CD O O Lr) Lr) Lr) Lr) rlj rq rl� rl� Ln Ln � � V) IQ F-- uj V) z uj a- x. uj 61 lS N N II Wali LIJ a - Y uj VA CD O CD Lr) CD CD O O Lr) Lr) Lr) Lr) rlj rq rl� rl� Ln Ln � � V) IQ F-- uj V) z uj a- x. uj 61 lS N N fU Cy Cy co cn Cy wu E u C. uj 0 0 TJ cn 0 m m CD CD CD M Lq O O O CD CD Ln Ln 00 m � c1 ll�. Ln 00 N - CD CD CD CD Lr1 O O O O Ln LD CD 00 t - CD CD CD CD CD O O O O O CD CD CD CD CD CD CD CD CD M Ln CD CD m ti Ln CD CD CD CD CD O O O O O CD CD CD CD CD O O O O O CD CD CD CD CD CD CD CD CD M Ln CD CD m ti Ln O II O Wali V tXa uj 11, z as ccry aia LQ,j Ex Ca aEE X. uj r 00 O1 Lr) M (14 TA Mount Prospc Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: JULY 12, 2018 SUBJECT: MONTHLY FINANCIAL REPORT — JUNE 2018 Attached hereto are the cash position and investment statements of the Village for the month ended June 30, 2018. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report — All Funds (page 4) This report provides a detailed summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit and Flex comp Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flex comp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. Governmental and Enterprise Funds - Cash and cash equivalents at May 31 was $53.1 million. During June, cash receipts totaled $5,356,682 and investment income was $89,122. There was also a transfer in from investments of $1.3 million. Reductions in cash and cash equivalents during June totaled $6,623,007. Of this amount, payments to vendors were $5,073,875 and employee payroll expenses were $1,549,132. Inflows resulting from interfund activity totaled $53,321 while other reductions to cash totaled $11,809. Cash and cash equivalents at June 30 were $53.2 million. Investments in the Governmental and Enterprise Funds at May 31 were $7,401,993. During the month of June, investment income was $44,563. There was also a transfer out to cash of $1.3 million. Notes and CD's accounted for in the Governmental and Enterprise Funds reside in multiple Funds investing surplus funds above what is needed for cash flow purposes. Total investments at June 30 are $6.2 million. Total cash and investments for Governmental and Enterprise Funds at May 31 were $60,502,857. Cash and investments at June 30 totaled $59,411,729. This is a decrease of $1,091,128 for the month. Monthly Financial Report —June 2018 July 12, 2018 Page 2 Trust and Agency Funds - Cash and cash equivalents at May 31 was $3.8 million. During June, cash receipts totaled $177,805. Investment income for the month was $70,335. There was also a net increase in cash due to investment activities of $2,222 while outflows due to Interfund activity totaled $53,321. Reductions in cash and cash equivalents during June totaled $978,598. Of this amount, payments to vendors were $129,278 and employee payroll and related expenses were $846,729. Other disbursements totaled $2,591. Cash and cash equivalents at June 30 were $3.0 million. Total investments at June 30 were $136,102,320, an increase of $85,654 from May 31. There were investment gains of $87,876 and a net transfer to cash of $2,222 that accounted for the change. Total cash and investments for Trust and Agency Funds at May 31 were $139,835,438. Cash and investments at June 30 totaled $139,139,537. This is an increase of $695,901. Summary of Cash Activity by Fund Type (page 5) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating fund. Detail on the activity of the General Fund is highlighted below. General Fund — Cash and cash equivalents at May 31 totaled $14,152,675. During June, cash receipts totaled $3,029,073, and investment income was $21,016. Significant cash receipts include sales and income taxes. Sales tax revenues for the month totaled $1,864,283. Sales taxes received in June are for March sales as there is a three-month lag in getting this distribution from the state. State income tax receipts for June totaled $343,194 and were for the month of June Disbursements from the General Fund for June included payments to vendors of $1,478,093, payments for employee wages and benefits of $1,365,141 and other disbursements of $6,000. There was also a net decrease in cash from Interfund transfers totaling $761,974. Cash and cash equivalents at June 30 were $14,845,551, a decrease of $692,876 from May 31. In addition, investments consisting of certificates of deposit totaling $2,472,463 bring total cash and investments for the General Fund to $17,318,014. Statement of Investments (page 6) This report provides a breakdown of investments by trust and agency funds and governmental and enterprise funds. The report also provides a fund -by -fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are made up of Certificates of Deposit. At June 30, there was a total of $6,192,560 invested in CD's and various governmental notes. These notes and CD's are investing surplus monies available from the governmental and enterprise funds. A detail list of holdings is included with this report. Trust and Agency Funds — The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. At June 30, there was a total of Monthly Financial Report —June 2018 July 12, 2018 Page 3 $136,102,320 invested in a combination of fixed income and equity instruments. A detail list of holdings is included with this report. Escrow refunds are processed two times per month. Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. A breakdown of where pension funds are invested is included with this report. Conclusion This cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Using this report, we are able to provide trend information to support cash management and maximize investment earnings while ensuring availability of funds to meet the Village's commitments. This report is provided to the Village Board and Finance Commission on a monthly basis. Please do not hesitate to contact me with any questions. David O. Erb Finance Director VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended June 30, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable Payroll Other Balance at June 30, 2018 (5,073,875.38) (1,549,131.70) (11,808.66) (5,073,875.38) (1,549,131.70) (11,808.66) $ 53,219,168.63 $ 6,192,560.22 $ 59,411,728.85 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at May 31, 2018, restated $ 53,100,864.50 ** $ 7,401,992.53 $ 60,502,857.03 Cash receipts 5,356,681.86 5,356,681.86 Investment income 89,121.73 44,563.32 133,685.05 Transfers from investments to cash 1,253,995.63 (1,253,995.63) - Transfers to investments from cash - - - Interfund activity 53,320.65 53,320.65 Disbursements: Accounts payable Payroll Other Balance at June 30, 2018 (5,073,875.38) (1,549,131.70) (11,808.66) (5,073,875.38) (1,549,131.70) (11,808.66) $ 53,219,168.63 $ 6,192,560.22 $ 59,411,728.85 TRUST AND AGENCY FUNDS * Disbursements: Accounts payable Payroll Flex spending Other Balance at June 30, 2018 (129,277.56) (794,525.67) (52,203.11) (2,590.85) (129,277.56) (794,525.67) (52,203.11) (2,590.85) $ 3,037,216.36 $ 136,102,320.19 $ 139,139,536.55 * Assets are restricted in purpose and do not represent discretionary assets of the government. ** Balance restated to include 2018A Bond Proceeds not reflected in May 2018 report. 4 Cash and Cash Total Cash and Equivalents Investments Investments Balance at May 31, 2018 $ 3,818,772.05 $ 136,016,666.04 $ 139,835,438.09 Cash receipts 177,804.84 177,804.84 Investment income (loss) 70,335.19 87,876.27 158,211.46 Transfers from investments to cash 1,417,847.81 (1,417,847.81) - Transfers to investments from cash (1,415,625.69) 1,415,625.69 - Interfund activity (53,320.65) (53,320.65) Disbursements: Accounts payable Payroll Flex spending Other Balance at June 30, 2018 (129,277.56) (794,525.67) (52,203.11) (2,590.85) (129,277.56) (794,525.67) (52,203.11) (2,590.85) $ 3,037,216.36 $ 136,102,320.19 $ 139,139,536.55 * Assets are restricted in purpose and do not represent discretionary assets of the government. ** Balance restated to include 2018A Bond Proceeds not reflected in May 2018 report. 4 Cla 00-, iaw Z Z 'i LL 0 0 V, Z < Z w 2 ui co v R LLJ (n En z w z ILL uj :D F_ LL Wz T.j w LO C: Of Ul m Df u UJI C, z U) 0 w 0D 0 w D_ z LU z w X LU > U) CO Z F- :) M U_ w 0 W < :D C) z 0 W UJ Z a� co > Z w z W (9 ll [Z' In M I co C.3 19) - M M M HO H.CA (o 00 If) 0 G) (1) 1, N n a.3 In It cli C) 0 Id) 1.2 co asst_ 't 0�. CO n N (q. , , m 0, "t (3) IN I-) m m oIn (D lo IN 7 'o cc ,r) I- In v 4 0 a In (D IN cU Ilp 0 I'- (N (d 0) n 0 M 0 CO I: 0 M C.3 r- N, 00 GJ rq U-� If) N LqL N M, Iru D M 1;; 0) �s C,� a� o (D D In m oo I.n 1, Ip .n e u) w 1J) co (0 -4 �^q (,0 cq (1) Cl 1.0 10 0 I'D LO SO 1-: �2 CIO 01 m I'PJp D - , It 111 r_ Hfh 43 0 IX3 In no a) 00 0) IN 0 Ill.. I 00 IQ al V) Ir 0 M.) 0) `) q) 0) M c In a) V) .0 1 P_ m 1.0 M Irl .0 w "' , , "o I " fo - N to V (y) 0 I'D (o m u.ri W N 00 r CN a CD m 10 :13 a,.) I, It v -'I a) 01) I 1$ M q 0) 0 CC) IN O In n 111) m 3) -..O 1.10 ID 0 Cr In CO -co 0 C .0 at 0 Ol C', a) 69 0) qA 0 Ni f2 0 I'l , 0(0 q b C) CD Co In U), 1 T9 m IN In w m 0 'D -1 07 'tih Pte. Y) m N I- (0 00 N OD 0) CD CA 0) O I)o In U) 0 It 0 C .0 at 0 Ol C', a) 69 0) wx 0 If) 0) V) N kr) 0) V`- cn CD (q I, V 0A cli (o Io cn ( i 1 11 r -;s 0) q_ 0 :t 'm U') m c 0) m q In CA 0) 0) - If) CO Iry NIf) `r m C9 0u"V 1- N 0 Ln 0 M (jo 00 w IQ In P- 00 CNI In In P,0 Lv o I'M 69 eq O 69 0 It,(D C4 E IRco O t:f 69 mo �2 'D In cu O QP fA Co A 2 In In N 5 co In co r-0 < w -0 T ®) 05 o_ a) 2 0 c L4 _0 0 M < 0 O El OQ L>U (D .N 2 <_ 0 M ®. Z, > —0 ZD I ww 2' C a, > P?m �- U_ LU > o < D o 2E 5 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of June 30, 2018 Maturity GOVERNMENTAL AND ENTERPRISE FUNDS Financial Date Maturity Purchase Financial Investment CUSIP/ Various Market Date Date Institution Description FDIC # Net Yield Value GENERAL FUND (001) 12/31/18 12/28/17 U.S. Treasury Note Treasury Note 912828A75 1.500% 1,239,821.40 12/13/19 12/28/17 Federal Home Loan Bank Agency Notes 3130AOJR2 2.375% 1,232,641.15 2,472,462.55 VEHICLE REPLACEMENT FUND (061) 05/30/19 12/28/17 Freddie Mac Agency Notes 3137EADGI 1.750% 1,243,036.25 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 1,232,575.00 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 1,224,423.75 3,700,035.00 RISK MANAGEMENT FUND (063) 03/06/19 03/06/17 Mount Prospect State Bank Certificate of Deposit 354058 0.250% 20,062.67 20,062.67 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 6,192,560.22 Maturity Purchase Financial Date Date Institution Various POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various Investment CUSIP/ Description Acct # Wells Fargo Investments Various Mutual Fund Investments Various FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract Various Various Wells Fargo Wells Fargo Investments Various Various Various Mutual Fund Investments TOTAL TRUST AND AGENCY FUND INVESTMENTS * Assets are restricted in purpose and do not represent discretionary assets of the government. 8-10810 Various Various Interest Market Rate % Value Various $ 23,016,489.18 Various 47,851,428.31 70,867,917.49 Variable 5,868,435.70 Various 22,123,048.30 Various 37,242,918.70 65,234,402.70 $ 136,102,320.19