Loading...
HomeMy WebLinkAbout5.1 Monthly Financial Report - April 20186/8/2018 Agenda Item Details Meeting Category Subject Access Type Preferred Date Absolute Date Fiscal Impact Budgeted Recommended Action BoardDocs® Pro May 15, 2018 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. 5. CONSENT AGENDA 5.1 Monthly Financial Report - April 2018 Public Action (Consent) May 15, 2018 May 15, 2018 No Accept the monthly financial report for April 2018. Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended April 30, 2018. Alternatives 1. Accept the monthly financial report for April 2018. 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for April 30, 2018. 04 April Board Reports for Upload_.pdf (333 KB) Combined Financials for BD 4-18.pdf (752 KB) Administrative Content Executive Content All items under 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. Motion & Voting https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login 1/2 6/8/2018 BoardDocs® Pro Accept the monthly financial report for April 2018. Motion by Paul Hoefert, second by Richard Rogers. Final Resolution: Motion Carries Yea: William Grossi, Paul Hoefert, Richard Rogers, Colleen Saccotelli, Michael Zadel https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login 2/2 ai u V C ED C W O u M u C O Q l!1 Iq O O W h N t0 ll1 O N W O l!') lD W N Il O OJ 7 M N O N m m O V: 7 N M N In O O7 O l0 .N1 In n N co N m N M N - N M M .--I + r -I + 7 N O1 O1 .NiO W ^ O 01 W 7 co m O M M 01 OIn O In n N O Ln 0 W In N N In ON ti 7 O l0 M 01 M O M .M... n tp O .ti co L/1 M 01 co N O N O vl : O O n O N 01 I� O co p M -I vOi N LM � OM1 1O0 10 vOi O O N N n W oc co M O N t0 O n N 111 In 01 10 V- .--I N ^ co W W � to N .--I N co .--I In O O O O O O O O O O O O O O O O O O O O ID N N OM1 01 N O O1 01 O1 O O u7 iD t0 Lm lO .y Oi 01 M N W W O M N W I1 M v - N O W Il W 01 I� W l0 l0 � N lD rl O O O O Cl O O O O O O O O O O O O O O O O Cl O O O O O Cl O O O Cl l0 O O O O O O O O W O O O 01 111 7 .^i W O M O 111 L N 7 W M 7 N N N L0 to N O O O O O O O O O O O O O Cl O Cl O O O O O O O O O O O O O O O O O 10 O O O O O C O C W O O O 01 u1 OO I, M V'1 n m W .--i v- .--I .--I W O M O 111 N lll W M 7 N N N N �IIII Ys II..... iXk > IIS IT v C y W iii u) � :5 u0 u� "r iv y rr wHT1 f; 's W :3 a" 11 11 W rYl x C3 Q' r"X lilt av"ti ill tYi M',: +1Y Cil y l r c.. C O W N M 10 H �h O O IDN oo ID 7 VF O o O O O M M O W N ID M 1 '-I in O O IDN 00 kD 7 O C O O O O CD C, N N W W M M l!1 ll'f {A M Q uYC'' F l.ry Z 111 M W u> �N O O w3 :3 u.u.. ci u V C ED C W I, M O If) O O I tT %Q O N O OkD Lr) f ID t0 0 O 01 ID 10 M 10 m O O » + + y + + j + + t rn v n 0 0 o i N m N n M N n O 0 1"o.�.i 1 N 0 ^r 0 0 o i n tp n v N � vl In I In O 1 N� O O O O O O If O O O O O O f .--I O -! W O O t M I� n M n O N H O O O O O O f o O O O O O t CD tri o 0 O In O o In o O N W M O 0 O O O O O O t O O O O O O t W M O tPr N O O O O O O Cl O O O Cl O O Cl O O O m O O tp W O In ti O � lc O co M O O O O N '-I N lI'1 In V} !Pr M HT1 Q � O W � V Z Lu > Cui:111. IVB WMD q0 u ., �D tl "> 5 mm I,Y} wi�'II WWW ti' f y- ) r7 }m"7 WiZ u' Wy > W I rll x III"" b 2' ' v V C. QY I"1 yYu }Il IY 'i III. Cl.. 0 4 p o a o N M C) 11, C) C) C) n q O O O ID m r, C) CL 0 + V- + C) C) r1l + of + C> ID + C, C� + C> C� ID CD 0 c) c:> 0 o O rNi O o O CD CD M - CD CD C) C) CD 0% 0 ti u CD LO O O M O O O 0 0 a� r, 1! O113: C! O O Go Go M II CD CD O O CD O C) O C, O C) C! CD C, CD CD CR O C> ID CD C� C, C� C> C� ID CD CD C� CU), CD C) C� CD C� CD CD C� C� O O O O O O If rn C, O CD CR CD O C, CR C) CR C, CR CD CD CR O CD CD CD CD CD CD CD C� C) C� C) C� CD C� CD CD C� C� 0 - O CD - - 0 ti u 10 10 N rlj U') -j uj uj > uj MP O > 1r1N I] :5 CL IIID F. 0 uo Lu � o > > LUt� E A 0 cer C3 W jI U a 0 rn I E ffi E m m m m m m m m C2 O O O O O " CR co co C) C) co CGo m i n m m ID Ln rlj " n r1l rlj + + N + 00 + r1l 00 + + lIl + 'I- + + + + + N CD O CD i CD CD k0 O O O O Ln O . i 7- Lrco ko ti m q D Cm D n D Il 01 co r1l co CC) -I- co Lr� c� ti rl) ti lo CD CD - CD m O O O cl� O r1l. lc 10 0 m r -j 10 00 10 10 - CD CD CD CD Cl CD CD CD 0 0 0 0 0 0 0 0 CD Cl CD CD CD Cl CD CD CCCC� CD Cl r -i C) CC) Ln m l7i lll� O O O O O O O O ID M ID m Ci Ln M LQ Ln �9 cq CD Lr� CD m a� +ff OO O C) ol Vi 00 CD O C) q cm) O Cl O CD CR Cl CR C) O (Z) CR cm) CR C) O C:) C:) CD C) C) CD C:) C� C:) C� CD C� CD C� CD CR. CD C� 0 CD r4 C) r4 r1i of 10 10 +Pl I -P, U'l M"9 uj uj U > uj O rtMB E: CT E > :3 WWW0 E 4d5 � x LUjj�J W V�r > �u LU M > IY > LU 0 :3 Clr lill c C3 Q' p::3 > v 11 11 S cle o C) E O E cm m C:) C) 0 q m C) C) "i Lri lr--� 17-4 IN 0 + I'l C) C) + rl] + 00 + :3 C, II Ep 64 LuVYG C3 LU CD 0 0 10 CD CD I O O O O O 10 In I- CD 14 CD CD m O rl) r1i r4 0 CCD , C:> cx� CCD 0 C� � CCD � -1 IN C, C> C� cl� ol� O q O fS O O If Go CD C) CD C) CD C) O O O O O O CD CD C) CD CD CD C) C> CC) Lr) ID CD CC) O O O O O O It C, CD cm) C, C) CD O CR O CR CR CR C) C) C, CD CD CD CD CD C� C� C� C� CID m 10 C) CID a V4 10 Lr) C > E :3 C, II Ep 64 LuVYG C3 LU V, C: M ill > E ce c 3 o Lr) u V C ED C W O 7 lfl M O N O Ili n O CR f Ill Ln T 7 1 n 10 0 M M m m f 7 I .-1 1 + N M (31 O M + + 1 O W W In Cl Cl O N M W O N 7 7 O 11) 7 N CD W O 1 N N 00 M b W f N 1 o rl ID Cl rn i -1 / l W lo O n O f rl 111 n N M M fV W I N N f M 1 O O O O O O If O O O O O O f O O Ol Om O O 00 1 1 N n Ol W I O N N M f n f N 1 O O O O O O f O O O O O O f Cl O O O O f Cl O O O O f O O O O O f n 7 1- 0 O O O O O O f O O O O O O f O O O O O O Cl O O O O O O O O O O O O O O O O O O O O ui iD 7 .--i .--i Waw co q� m, 81 II Waw co CI NMw �N wEw Eli u1F i;Y} M 4b ulS W Y1k X,.. J,l�A �V FIT YIk NI} S17 0 rIr VAI; C LU lu W 0.' W r"X., M, n "A: f! Y' C' 2III CL ill F � Y h,. N,�� II w o Y2"I.. 0 tPr O O O O O O O O O O n n M M M M T17� E O E r1i v C) C) C3, Cz r, m M M T CD CD O1 O O 0 T CD CD C) cm) Cl O CR O C:) C:) CD ol "i mull 1111181 :7 c XIX 5! LUr: W :3 E E W > Lu > lu L> u c, C3 CD� C, OO CD C, CD C, C� C� Ln LO Ln 4 r- M C) � O q Cl ID cn Ln ID LQ ;2 r-4 IR O Ln ID CD O C) CR cm) O Cl O CD CD CD CD CD li CDM CCD � CCD � Ln 0 -j R uj II I uj W a: II^ II O Nib Nib IIIIIIII Viol 0 IIS 1:3 Nva til LU W r'l n t:: 11 0 r: V LU C3 LU c m Un r-4 CD O C) CR cm) O Cl O CD CD CD CD CD CD CD CD r -j Ln 0 -j R 0 uj W > uj ce dMP wwn 11117, PAP' 17 5� LuG Io JI III Y i91 II II LU C3 LU c ID -U)- 1 +F? Af I 2 fPr 4A - -61r oo oc) oo oo oc) Go CD O C) CR cm) O C, CR C) CR C, CR C:) C) CD CD CD C� CD C� CD C� CD C� 0 cli ol a, ol 'Al n LU LU > LU m Clf 0 CO x ow Cn u LDU VN,M, c:: r: L>u r C3 LU > o o E E O m C3 O o O ID C) V - r, C) In UZ cz LQ CD C) co r*� O cl� CD O C) q cm) O Cl CR CD CR Cl O C:) C:) CD CD C, C:) C� C:) C� CD C� CD C� C, C� C) Cl m m m C) to in n LU LU rtM LU � lily II I > Cl LU E u': v, E C LU > > Sl E C3 LU E E C) C) m 0 q 0 C) C� C) rn CD O C) CR cm) q C, O CD O M CD m In LM cl CD C Lo C1 Ln 17i M IN lr� oc� cl:� M 0 _j < 110 Lu >Lu Lu X� "Ell O O mm C m ch. Lu X U : c :3 Lu > Lu C3 Q� Q 0 o u V C ED C W C O u U o O Q ID O M M - O O M lO O O Ir": � O Lq o O o co v N N W W M N N Cl a 0 Il O m Ln 7 Il N N Ci7 + W O l0 v- + M N + M M N M +CID Cl rn N R CD CD CD In O 7 7 co O O lfl r-4 7 In O M OJ In M In ol.Ni W N r, In .--i I� 01 .moi l0 O O 7 o � � � o o � N CD C, m -T N l0 .--i N lc ll .--I N '-I 07 10 M M O O O O O O O O O O O O O O O O O I, O In O O O n O O n M O O 7 c0 O^ M T 01 co .--i In M cl N ^ 01 11'1 co of N � '-I O O O O Cl O O O O O O O O O O O Cl O O O O O Cl O O O O O O N O i O O Cl O l0 CID 00 7 O ti to O O O O O O O O cq Yb 10 00 H O O O rli 01 m O C W W 7 10 co '-I C. Vi O O O C.O O V} O CD O O O O O O Cl O O O Cl O O O O O O O O O O O O O O O O O CD O N CD O - CD O CD O CD M rl O V- O 10 O O O O N V- M .--I CID O O 01 tT O l0 a, a, K} fPr B O f W"9 W WI � V Z W WA CUF w;F 0 O m, '......II 'JD ILII II �o l Cr l,Y i� +,m YYk V,fy f" Il II W ! �W 1i fw ca U W WY11 VY ��:- r Fu �, n 0�. 'If'. 8 I ® U NM C m F N V C ED C W C C O CN (V C v O u N u 0 O U Q C) Ln o o I f N 7 7 v m o a i +n + u M O + c + M O M + In + + M CD Ln Lq m � o m i NW In ; O co 10 O 2 O t0 f p N O f .N1 .N1 1 !Pr O S M I: ON f C, n A Ol N .--I M f ti W f 10 ID 0 0 0 0 o O f 0 0 0 0 o O f tPr O -� W OM O ON 1 O of .--� •--� n u 7 M V- N O H} O O O O O O f O O O O O O f Cl O O O f Cl O O O ; l0 O O t0 � � f +i} O O O O O O f 4Pr O O O O O O t O O O O O O f O O Cl O f O O Cl O O O 0 M M n I ol ol f c—I Qw F 0 d LU LU EL LU "q�A V m PY i W w Zvi u°ww mo u:mu .. I k t. uf1 E Vey 0 i.I! r illf 0. 4 LU a u. a ruI"' 4 Nxu 16,1 Lu E CC LU 43 YpJ. A.kI} sIY ew c—I I ® U N C m u V C ED C W i� C C O O CN N C U ~ O O In h O O N N 0 0 o rn Ui o ui Lq O co m N N "i mi cp - ID W ID O7 Ur � O Ur In W V} tPr + + M W In + o M W V- rn Z + + + In CD CD CD C3 O O 7 W l0 O OJ OJ �CD Ln M U) In O a a, Cl Ian �,o w m'0 O Gia ti ti & k y 1 Y?,II S to RI Nw„II Ilin Lu i^,II LU W ,� M E C: `> Cl 11k r °-! 0 0 C3 �+ III, rXa J V m o ill o WIY1 u,.y o u o of vi vi T v O O H} Hf O O O O O O O O O O O O O O O O V} tPr O O N 7 O O I� n M T W In In pml N N N N M M O O O O O O O O O O O O O O O O O O O O Cl Cl O O In O O O In Cl In .moi .moi iA .�1 tPr O O O O O O O O Cl O H+ H+ O O O Cl O Cl O O O O O O O O O O O Cl O O O C I O Lr Lr iD n 11'1 lI'1 U7 to to r- ci m ., T1 F 1 O � O W � V Z m,.. 81 Ji >D Ji ° 81 Ian �,o w m'0 Gia . & k y 1 Y?,II S to RI Nw„II Ilin Lu i^,II LU W ,� M E C: `> 11k r I,, C: V ^„ r} C3 �+ III, rXa J V nl WWG y ill o WIY1 u,.y o r- ci E O E co n C) IQ 0 0 V- cn Ln Ln kj:� 00 ID rl 10 co -q CD O C) CR cm) O Cl O CD O r, C:) r, r, ,711 of C:) C� m OZ r1l oz C) m m M V- C T C� V- C� rQ N r4 < 110 ,a LU LU > LU c 81 O O V, fli LUVdD :::::T > LU > C3 LU s CD co -q u V C ED C W C O u N u C O Q N O 7 O O If) 1 M Ill M 1 M co M 1 M In M 1 W n 1 7 N I In 1 M O O + + 1 < + + + + 1 7 O .moi O O O f O O O O O O 1 W O0 O 1 N O Inrl f n 1 O rn o 1 0 0 o i O O C� r, I O N M /T O Ib al q 1 Il N O M � Ln 1 O O O O O O If O O O O O O f a? O I- O O N 1 rl co 7 I N l Go ` M ti M � 1 H O O O O O O f O O O O O O f O Cl O O f O Cl O O f M O O O ( W O U) L 1 � I O O O O O O I( O C) CO M 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 C O O O O M M ti W O ul V- 7 .-I O lIl O M M n n V} !Pr M Q � O W � V Z W IWC W MP O mi m , e re �0 �w �z �w o m'.. Y ✓Ik F : uo VrD di,7 .'I! r � C", 11 V w W x µ " ul V W YXk iii s g v W u 4 Y 1, Q� a��uID n� ylk IP fi IC a 0 C) co - N c> � m � m V: I: O cq cq Lr) C� r, ol� clz rl rl r, O CD O C) CR cm) O C, O C) O r, C:) r, r, ol L'i a, L'i lo lo C) rIj C) r4 c) < 110 Lu Lu mm > O Lu 18 WwF :Y Th. Q, E 0 OIL qj,% E E %0 0 c ^�.7 Lu C3 M Lu C3 Lu C2 O I E O E rn QR Lq M -I- oo O 00 N T c� clco� W O ol 10 ll:� LM (D r, 1A 81 II mw W LU Will :3 E C W O Lu > c, lu C3 LU CD :QJ I Ln Cl r -j ID O a, rn OD CD fPr R Lr� 10 rn O O cm? of rl� CD Kf wj1 0 IN IN CD 0 CD 0 Cl CD 0 CD _0 Cl C� CD in 00 E to O 5, E 0 O C. O 1=1 O E CD O C) q cm) q O aj -L 0) o C:) C:) C� 10 CD CD Go Ln Cl r -j ID O a, rn OD CD fPr R Lr� 10 rn O O cm? of rl� CD Kf wj1 0 IN IN ol IQ rl) co rl�. C> r, -61�- V - LO Lr) Cl O 00 rl� C> r, C) C) oc� fPr F® } O L u C ® m Eo C W O• n N O W 7 M M O In 7 W O O O M 1D N O W lD 7 O In V: N O O O I, .--i Ln M O 7 m O M +--i v M co 10 c0 a, .--r O In M I, N m IT n N O 01 u'1 Ln 7 Il W 7 N m M .--I N le Ol W M rl M 1-i N Ol co c0 .--i .--r M M W O r, N 7 M M M M O N ,-i 7 + i0 O + + W Il O O n W Ln O O W M O tD O O? q In II: u'1 : M n O n Lq W O 17 O +--r M N O .--r O OW tD O .--r -T W O In N N Lm T n O In M v- -T O O Vl W ul O O q Lr O lq 7 W lD N O OA N O u'i m M W O M u'1 t0 W T O tD .--i O1 T N n n n W .--i m M -T m V u'f M tD N N 7 ID - M n CY, W In r -I l0 - M N to O O n M O M O O O M In N l!) tD O O M O n O O O m O � O` O ul .--r M W lD W N W O M u'} .--i M lD W N Ol Cl vl O lcO .--i M N W l O O n 'r 01 M M W In t0 M .-I lD -T r, ri N O O O O O O O O O T O .--i O O O .--r O N O O N O O V: O W O N � M n 10 10 N I� M O W M O W II M M N .-i Oi N lA N N 00 D I� n O In 00 M M W N N W O In M I, O O O N N I� W O M W M O Ol In O O O Il N Ol 7 W O N In 7In 01 M 7 M W M In 7 O I� In 7 N t0 I 7 7 C in rl 7 .-1 n 7 7 10 WO O 7 C) .-i 01 t0 ON W 7 In .ti M O .-1 N W I, 7 O O Cl Cl Cl O O O O O O O O Cl O O O O O O O O O O O O O O O O I, 7 al O l0 c0In l0 W 10 O CO O M M M In I, In O In N n M M O O N In 01 O O 10 01 W rl In 7 O In 7 co c0 �r.^i n M In M M O O O ml0 7 In M In W \0 In l0 In Ol In l0 M 7 I, 10 N O n 0 7 W 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 . Cl O O W W co O � M O N H lO 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 1� T O O l0 O .--r In l0 W 10 O O O Cl) M M in I� ul .--I N to N n M O O O N 111 G N O l0 .ti W IIz. #n C O m T co lD Ol 7 I, 7 M u'1 v- M co O O Ol lD 7 M M .--r u'1 W +--i In u'f Ol In O\ 7 In lD M -,r n O N co I, ID T co N Cl O W iA 0 M ifs N O O {I} ll} 7 7 O O M M O O n n M M M M O Cl O O M M 7 7 N N O O O O LO Ln LO LO O O W co O O W W Y7 ci d"71 �I 01 .x I. p„y mull ..�� 1111181 wfl,I.i wl m” rIk rv,'",H q•p YA 1S VI ', In f'. II 1 W z Lu ¢Y W #a III... x Yli^h'X p�u r rIa d7 ti. y. :r II IL II S� ; ° III U rJ7 N J #",: In 7 C: 4J Cr # 1 Z u # 1 o:,] 0 "Y v G C :x III U,!%'� �} r, v.. Y. r1 j fp a III U V1 � a"1., II 16.P t oA1 % 1 xtG Y "vl jjNITr N Cl O W iA 0 M ifs N O O {I} ll} 7 7 O O M M O O n n M M M M O Cl O O M M 7 7 N N O O O O LO Ln LO LO O O W co O O W W Y7 ci FO } O 0. u a C O v � Qt C tat � C O ® U m C m u U C ® m Eo C W i CC O O : V + M C V QI C C F C � v Q fn + + O O I, + + 0 0 0 o Lri o 0 + + I� O O + + Ni N r -I + + O O I, + + + + H O + + + + I� O O + + Ni 10 C 0 0 o COD o 0 r-6 .-1 &�4 n O 0 n O O O O O O O lull, I� N Ik i,�' Wlk i1} 6d1 r.S O O O O w O O ui O Z 7 f M W IIVI M} LU 0. 4y N .� O O O O O O O O O O O O O O O O O O O O O O Cl O O O O Cl O Cl O Cl O O O H O I� O O Ni 10 I� N M .-1 &�4 n O O O O O O O O O O O O O O H O I, O O O .N-6 I� phi N &�4 13 IIIIIIII �k &�4 n p��m t ✓id lull, �,qu'l 1 Ik i,�' Wlk i1} 6d1 r.S V1G ti11 arG rS u dl CslI O Z 7 f 1116.11 IIVI M} LU 0. 4y Cl .� c . III.. C3x mA JI yIY W Y_ Y till Y till 10 III.., I ]' �',;,,i YAG YAG J; 1 Cl Cl V! 0 O C) N Vf O O O O V+ Vf O O O O O O V} V} WYE N I ® U NM C m u U C ® m Eo O V C W C O O : V C N QI C C F :O O O OM W O rl Cl -Ir 10 r'4 10 m r1l Cl m a, M I, O M lM rl U'1 co 7 + O -O + + ,^ F1 + + + + + + + + + 0 0 0, o qLq o M O I� t0 1+'1 O O q v 1+'1 ,M -r .mco -r O v- co ti M n M M '-I CD O O O In O O O O� O M W O r l0 .--I O O O CO O O O O O O Il, O O O u O In L co r, Cl M O O O M O O O O O O O %q O O OM O O M In N C In O N O Cl O Cl Cl Cl O O O O O O O O O O O O O O In I, M O N 7 N O O N N W In co N I, m LO M In 7 lr O O O O O O O O O O O LM O O N r - O CO co O O O O O O O O O O O O I� O O O O N O 00 CD Cl r4 r., O 00 .--r r, N 7 - -I rl qP m,.. B II rtMB m�^lld. III rte ITP u LU tn aM Z 0. 4Y L>6 1 .. IIIa J r AGI r wl5 !'i w ✓Ik JL y tiL ti° B Y di. yra 0 ,,1 . r•I B I t 4 rVo iY w i W i 7 u] 1 ts� 0 10 0 M lfl Ib I! O ! n I M 1 O t O t O 7 4Pr ' I- 1 N 1 tT 1 n I tPr O O O O n n N N 7 � M M N N fPr {A Q F r� W P, Z W X LU �P A� CLM', IM CL am CR P+dl O LII M 4O '!" E E Ip CDCDQLnQLnm O O O N O N rs! C, q C) q CD Cl In C) In 11'1 Cl C� Cl C� C) C� C:) 10 + 10 cz oz + + + ol 0 C) C) m (D w w q q C� q q q q Ln ol +a5 T V- 10 co 00 M < M T Mf V- +F� 0 CD C> Cl O O O M O M ri 0 10 10 ko 0 a, ol C3, 00 Go r, tPr r, CD O C) C� CD C� C, q C) C� C, q C) q CD Cl Cl C) CD C� Cl C� Cl C� C) C� C:) cz oz en +a5 < LU LU u 0- x LU Bj pia C E Th, V, fli 4 W Id Lu Ln o Lu X C3 LU V (U E Ip CD CD Q C, Q Q C� 0� 0� C� C� C� rl Go ol rll 0, a, r, 0, a, m C) l0 Ol + Irl N Cl O C:) O CD C! + r4 Ln = 10 10 Ll Ln OC)MC>(DC)V- 00 ON rlL Ln Lr� CD "i O q u1 q q q N C) IT 10 Ln LM 00 (31 rl CD CID C) CO N Il CD ol ro 0 CD C> C, CD CD O O O O O O C, C, rl CD rl O O 1: O O O N CD m m 10 N C, a, ID Lr� co CD C) C) C) C) C) O O O O Ln ko ;2 LO cq ol 00 Ln 00 Lr) CD q Cl O CD O Cl O Cl q Cl O C:) O CD C! C) 0 %D = 10 10 Ll Ln co 00 ON rlL Ln Lr� CD "i CD ll� rl cli Ln Ln Ln r, N co 0 CD C> C, Cl CD CD CD CD C�C�C�C�C�C�qqq .1 .1 CD CD V- M V- r -i CD CD O O O O O O q O q 10 C) 10 10 C, C) 00 Go ol M L'i cm) ll� Cl Ili Cl C� C) Lri m cl� M Gi NCD Nm " C) ol a, r -I rl 00 m - co - Go < 110 CR Lu c LU LU 3 - LU IIS Mmm O 81 O CP dj 0 2 C 0 V, fX fli A O wl 5 V) lz qll Ij r LU T C: I 3 Ln 2! iu! :::::T � 'ai Car :3 0 iJ r Lou 00 0 11 x 11 II,II llt! 'i C3 LU 0 ! 5 8) � i 6 1 16�, �, J Lr) C O u U C O Q +--b M V- L N m .--I t%0 M W I� O W 01 l0 O 00 N M mlorlim N rj V- O r1lN r -I rl uM'1 M T M Il 7 co 10 -Ir m '-I '-I 0 nz. N 7 ol W O O .--6 00 M W N I, m m M O N M N M N Cl O Cl O Cl O Cl O O O t%0 M W I� O W 01 l0 O 00 N M 7 N rj V- M O W OZ N N O M v- W nz. M Lr m '-I '-I 0 nz. N 7 ol W O ^ .--6 00 M 10 O N 00 r, N l0 Il co M O v - M 1l, lO .--i N O —! O .--i CO M v- .--i co O CO oc N m CO 1l W v- rl O O O O O O O In O O W N m m I� O n In In N 7 I� M M i N M O O N lO W co m N N i N M O Cl O O Cl O Cl O Cl O Cl O O O ON O O O O 01 l0 O 00 N M 7 n 7 n tO lO C) 01 .ti M O 10 O 1� 0 nz. N 7 O M .--6 00 O O O O O O O O 7 n co M in 0 N O co n O co coC N N '-I O +R Ln 7 10O cl O M Vi Cl O LoM N Lo M 7 O Ln O n 00 M i!} PC O O O O O O O O O O .--i �1- tO -1- M M O O O O M O tO nz. O ol .--6 00 10 O W 00 r, .--i W N -Ir 7 7 M 7lf? 7V� J Q F 0 CAd ISI � IIIIIIII Z W...... X 0 W C CL wMb qY 0 !3 of A wd'a Oa, ml„I rlt 1111181 ... 4,t IIU cu m .,,Th,7 C”: In v N. wli a„y1Ai, �, u1 r• r•p. dV 4y „o"V U Ir Qn"ro �n 'b Yli ^KX � CLuCl /1 elu w v!'u E as ¢rwV a IIU u:k In c.: 0 C3 x e o , .. PC rn 16 Go 0 n 0 .ti n N Cl O O O N N O] W M M n n tPr W O O (Ln ) O Cl M M m O O M M N N n n c0 W 7 � rl H (n F �1 W D (n Z W XW ""..... �Y u �r. wll"m rel O O v Cl O Cl O Cl O � 0 O 0 ® D O O (n l0 rn lD v (n v rn Cl c Qf Q, C '6 In M W ti M m E O .. Y X Vey Y1 m r 6�1 0 w Z �Y X,. a O O O O O Ln v + '^ -d to N lD + OJ C + Cl Y fn M a Q (n v (n O O N (n O LQ O O O O oo yC O n O OO N OM O O O O N M N rQ Qt C 10 C3 Q O M M 0 M (n lq: O V Ul In O lDOl .--I C (Mn O W ® U ID n O N Y C m lD O I, O O M O Ol O O U n - C m r (n LQ co 97 c C W O O N O O O lD (n O O =n o%m 7 CC O O N (n Il cr co 7 : V n l0 N + M C VI QI C C F rn 16 Go 0 n 0 .ti n N Cl O O O N N O] W M M n n tPr W O O (Ln ) O Cl M M m O O M M N N n n c0 W 7 � rl H (n F �1 W D (n Z W XW ""..... �Y u �r. wll"m rel O O Cl O Cl O Cl O Cl O N O Ol `Q D O O (n l0 m Ln CD Cl c Qf Q, C '6 In M <D .-1 N M M m E O .. Y X Vey Y1 m 6�1 x w Z �Y X,. O O O O O 4Y Y t7 "I Cw C C Cl -E C C fn M PSi � E Q O O O O O N OO ti lD O O O O N M OO Lmm -0 10 C3 Q O M M 0 rn 16 Go 0 n 0 .ti n N Cl O O O N N O] W M M n n tPr W O O (Ln ) O Cl M M m O O M M N N n n c0 W 7 � rl H (n F �1 W D (n Z W XW ""..... �Y u �r. wll"m rel ua !r VY7 d.. .. Y X Vey Y1 m 6�1 x w Z �Y X,. VN 4Y Y t7 "I rn 16 Go 0 n 0 .ti n N Cl O O O N N O] W M M n n tPr W O O (Ln ) O Cl M M m O O M M N N n n c0 W 7 � rl H (n F �1 W D (n Z W XW ""..... �Y u �r. wll"m rel N 7 O N O O O O O v1 iD O I0 O O O O O v1 7 O 00 M Cl u 10 V- Oi .--i V ri ti + + + + + + + + + + + + 0 0 0 o 0 0 0 0 0 O 10 u0i ti cl u N CD O O O N O O O O O n .ti M O O O O O O O O O O O O .-1 O O O O O O O OO O O O O O N 7 M O Cl Cl Cl Cl Cl O O O O O O O O O O O O 7 N O O ti In i O In i M 7 O O O O O O O O O O O O O O O O O O � N O O ti 7 0 i W t � 1 u'} 1 M 1 0 W n ro N II 7 M 1 ,-,I- C! Pr O I � V � V � V 0]co t 7 1 y} O [CD O O O O 10 <0 � <0 � <0 W W Q F r� � IIS W Z W X nii LU " "T�II D a*] adN �1 d:71 01 .x I. M p„y O YAP 7 I � W WYk i.11W ad V• 4 M VW'D W I} �I I Lu a 0 II 4Y LUa ',:V YIk �” IX 0 r'b M Xa rIa Y }) tl o ll ” W III.. d1 1116,11 4...`A d_„b J Y (";y � '1Y',X w 0 i W t � 1 u'} 1 M 1 0 W n ro N II 7 M 1 ,-,I- C! Pr O I � V � V � V 0]co t 7 1 y} O [CD O O O O 10 <0 � <0 � <0 W W Q F r� � IIS W Z W X nii LU " "T�II D a*] CD CD Q C, O O O O C) C� CD C) r1i C) r-4 114 O r,00 m m 00 m CD CD CD CD CD CD O O C? C? C? q CD CD CD CD Cl CD CD C) C� Lr� CD CD C� Cl 01 CD C� ` C Ln a M r1i E 0 CD C> C, Cl CD O O O IR O C! Cl frr C, yr CD C) CD C, O O q O CD C) cm) Cl CD C) cm) Cl N TIC I �o V, In W Lu ` C Ln a M E LU 11111 1 lill 110 a- x �U C3 LU c5 0 TIC I �o CD CD C) O O O Cl C� Cl �Al Lm Ln OR CN M In CD C� C) C� CD C� C, C� C) C� CD cm) C, C) CD O CD C� C, C� C3 C� p— NRb LU U) MV LU a- x LU M. 111A O C3 LU Ln Lu a - C3 X LU =C, 0 on rl) co (n co 'Al CD Cl CD CD � C, � C, O O O O O O CD CD CD Cl CD CD C) CD Cl CD C� C� C� C� C� In r, r, 0 CD C:> C, C� C� C� C� O O CD C) CD C, O O O O CD C) cm) CD C) cm) C� CC� qU II 0 5 �u j;, C3 LUYpS a I 10 m Q C� C, Q C� C� C� C� cli m Cl C) co Cl n co of rl M V- C-� 7 In -V} CD CD CD C, C) O O O O O CD C) C) C) C) C) C) O O O O O O O CD CD Cl In In In CD C� C) C In In C) c� Cl In C) In 11'1 In In O tPr V} CD Cl Cl Cl Cl Cl C:) O C? C? C? O q O CD CD CD CD Cl CD CD CD C) C� C� CD In CD C� Cl C� CD In CD LQ _j in Cl in Ln M 10 ID 0 CD C> C, C� CD CD O O O O O O O C, 'Al CD +Pl CD O C) C� CD C� C, C� C) q C, q C) q CD C) CD Cl C) Cl C) CD C� C) C cm) In Cl C� C) c� Cl In C) In 11'1 In In O In In O u) _j < Lu V] IIIIIIII Lu 3- X Lu DO x CO II M ,1111 qrp CR :3 w`y (Ij Lu Ln C a Cl u cE'o'155 a" 11111 1 c: 0 x EiIY C 3 Lu III. Ja c5c> j Ym UJ qa O LD C�, I I ® U N m (bl U C ® m Eo C W Y � CC O O : V C N QI C C F w C E Pal � E Q m O O O M O Cl O Cl O O 1 O O O M O O O O O O 1 � 1 N 1 M 1 7 07 O C'J O O O + O + + + 1 + + C T o 0 0 0 0 0 0 0 C ko o T 0 0 C) °� Ol O In Lr O O O v i ol .--i .--i O O O M I lO O m to .--i W I CO I, N n .--6 I N O N O O O O O O O O 1 O 10 M 1p Lr W O O M M � 1 O CC O O O O O O O O ! M T M C t0 O Cl 00 a, I O co O O O O O O O O f O M O O O O O O O O 1 N � n In I N 01 O Cl Cl Cl Cl Cl O O O O I O O O O O O O O O O I O O O O Cl O O O O O O O Cl O O Ill In In O O O C 7 1 +-i M O O O M I N Ill 10 W N n (h 1 O O O O O O O O O O li O O O O O O O O O O O O O O O O O C1, O O O O O O O .--6 111 Itl I/1 O O O O � m O O O M W 00 M FA dro II II m... qU m... C lk �N mll�In 41A y d l 7J .4 p W SI Jr"5 V � IS ry„ I} � 411 r"rG Ul Pl 15 � M,,: f r F� � .. Z l ti^t Y"I + t_i a_. III P r LU 1116.11 tl C":I�•d V:Y II R1 WS C3 rIS YIl Y.1 4Y7 t1! "i ay f) 1 ocr n N n F® } O L u U C ® m Eo O O C W m W In m M to M O O O Ol m I� O O O O lD 7 V'1 LQ LQ M O O O O -! O GJ O O O O N O O m .--6 I� .--6 10 ol 0, ol ol c0 00 c0 7 -Ir N O .--6 111 W M M M M -Ir M N N 111 N N m M M O^ +--i O ti N M M ko N � M Fi + + N O N N O O O + r -j+ + + + + + r, O vl rn O v m O O O o m r, O O O O W M -! II: M t0 O O O O O IQ IQ O O O O ID ID 111 .ti N T n O O Ln M O O O I, O N .--i v- ol t0 U'1 lD M m O O +--Y Il W O ll N N In O M ccO O L'f Oi - v- N m M l0 w .--i W M O in N M M N lD M lD lD lD 01 to .--i .--6 W tD lD In '-I N .--I O r lD v - M O Ln O O lD lD O O O O .--i � O O O O +--Y 1l, W .--i I� M v: O O O O O N O O O O ,y lD M 111 m n .--6 Cl lD M v- T 01 lP1 M '-I a u'} Il clcllc N 7 ol W1l, co .--I .--I .--I W .--I M M 1, cl .--6 co M M N N In ID N O N O O O .--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 n O 00 I� O O O N D N Ln I� 7 M N ul H ID 7 O 77 ,moi O O O O O O .^i O O O O tD OO Il In W O O O O O O O O O 7 N Il 10 In 7 O ID O7 n 7 in in 7 N O Ol 01 W 7 In M O In lDI, n lD I� 7 .-i M ,ti cD O Cl Cl Cl Cl O O O O O O O O Cl O O Cl O O O O O O O O O O O O O O O O O W M al N N N al O O 7 O O l0 7 N Ol co pl 7 l0 O t0 W O O 7 N In of N C C O C M Ol O O In W Ol M In7 m O .-i M 7 O In N N 7 CD I� O N n n O M m CD .-i M N N co In O O O O O O O O O O O O O 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 OC) N -I- IN 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 c0 M O N N N O O O .--i �1- O O 10 N O co O -T 10 O 10 OD - O O -T .-I N 111 O N T O O O M ll C O ul W Ol M u'/ .--6 7 Ol O .--6 N N O V'1 N N v- W I, ol N n n LD .--i .--6 OO M 01 oz M - q H .--I N OO m n M 10W Cl 0 N n rq 10W O O O O O W n coz. co V! I Vf M 'A Ln ci adN �1 d:71 nl: O of mi '......I Ida �o �d psi �o :3 r In uY 1j r•l r"5 CD YS 1S VIc in 'q UI Z In 0. x Y W 1 rli nb YIS ^KX I)v" :*. '..Y Cl IIIU W xa 4'.Y as 1.: CO3 Y"a ID°c: 111111 hl IJ} 43 'a r;y IIIU VY) IIID "L%t3YV "S oA1 "« Y 1 11 a¢q 0 YAG }11 AI }Il a n M 10W Cl 0 N n rq 10W O O O O O W n coz. co V! I Vf M 'A Ln ci N O 0. a C O v N C7t C N C O ® U C m u C ® m Eo C ISI i CC O O : V a• M C VI QI C C F w C E PYI � E Q O m O O O O O O O O m m of CO CO O O O O O O O V: +--i Mol tD N N l0 lD ol .--I N In co 00 Ol u M W W KF Vi N M .^-6 M O + + O � + G + + + M of rn to O O O O O O O c v O O O O O O O O M M to N to In M M N o <D T In O 1 -iv ll rl '-i O Il to V T N rl 111 AA AA- C, PrO Cl O O O O O M M CO Q�l Ll� O O O O O O O N N In N n co N N W .-I N N W {A O O M O O O O O O O M M O O O O O O O O O v: to m .--6 - n ID o l li M oo CO M +Pl Mfg O 7 N O O O O O O O l0 l0 M In W In O O O O O O 7 I, 7 co m In 7 In N N I” M N 7 7 N ti N l0 VD tPr Vi O Cl Cl O O Cl O O O O O Cl O O O O O O O O O O O O I, In M 7 N to O I, n Il O n In In Cl O t0 l0 t0 I� O lo In In O CO.^1 n O to l0 M 0 In n VF tPr O O O O O O O O O O O O O O O O O O O O O O O O O O W W O O O O O O O O O O O O O O O O O O O O O O O O 1� ul M T N to O n n trl 0 OM ^ O to O 0 t0 t0 0 of Il '-i I, O lo lo M rl to K} W ED ci r� � O W Z Ji�^ III'....'.. X W ��I'IKI�P9 aau n� M1 �9 O mi �1 XI ¶15 l w iP O ..M n ..�'' ✓Yk 16��"R U 0.J pVdV` 14 Cru �l as VAD W AI nJ M,ti y Vn✓1"� WV A � X YID I".AN IF �',7 M'3 Z aA1 nA �"G I1 y'' 'i a a tj Y_W n Mti7 0. M C:II "f7 II II of ^ rM, x"" u"G f- v. C3 LU K'. "I I Y I C3 C3 III.. d7 1116,11 d »ti d »V f":Y YAG 'iCX ED ci O 0. u Y a O v � m C tat F N C O ® U C m u C ® m Eo C W i CC O O : V C N QI C C F w C E PYI � E Q 10 M N t0 m In O O O O O O m M m In 10 N O O O O L1 u7 m .~-I n10 � 0 In 10 Ol 1 N u^7 N N KF N Vi O + + + + N M M M W + + + + M m O m O m O O O O Ln Ln 0 0± - to O O O O c v, ,y Ol 10 M v to 101D cl 01 � OZ � m t0 N N C O 01 W m m O ID �D ti mull 01 A V+ 4R +--6 O .--6 O N O O O O O V- � M .--I O M O O O t0 O I� n M Il � M N asp O O C, M N OM N rq M CD O LM n m n CID -T Ill' -I V- V1 m M W M {A O O .--Y O O O O O O O O O m O O O O O O O m m U I� n N N O as N M M 10 �✓t ''. In +u N H na e N K} N W 7 m7 m O O O O O O O In l0 O .N1 In O O O O O O O N N O M'3 Z aA1 11A a m m N O O 01 7 01 Il 7 m MwJ W ry p I) O In Cl In N N IIID a I,'d IJ1 p 0 l0 c"] .-i K 3 W VF Vi O Cl Cl Cl Cl Cl O Cl O O O Cl O O O O O O O O O O O O In Il m Il n In G..I J 1 '71"M II'"4 0) m Il m N O al m m M l0 Ol m In O N O N m M m O mm .-i ifR tPr O O O O O O O O O O O O O O O O O O O O O O O O O O W W 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 Il m Il n Ol Ol I� T N O Ol m m M 10 Ol m to O N O N N m 00 O� rn m n K} W rl"G' � 0 Z W W FF �I M mull 01 „II +Ai M asp 3 I) ll U as VI aY 4 �✓t ''. 1 +u ^ na e ik V)y] r"i'G ndl UI rli^IGXu M'3 Z aA1 11A a ru 1. w MwJ W ry p I) d '^-^ I r} �'; 1 IIID a I,'d IJ1 p c"] K 3 W "I 3 YIS 0 T b III... 41 1116,11 d »ti ) .w G..I J 1 '71"M II'"4 I ® U NM m u U C ® m Eo C W O O :G V C N QI C � F w C E Pal � E Q W IR r% O O n � � 7 I^n Cl m kD W M rl .--I (7 N n N 7 M 7 M 7 7 n+ M ,M -Y M u'f O M tT Ib O 1X1 O N co O n W O ll Lr o .--i M M M ol IV l0 .--I IS M n M u ti ID N ti — N M W n W O O O tD I: tT M O q: O N O m .--i M IT LO T co O rIGIC�In lD � Mmm M m N m M - N - M .ti .--I O O O CD CD CD N O tD O O O N f Cl T tD T NCl N O O O M O O O O O IT ID O M Ill W O O O co W Ln W I!1 In O co M Ori CA M M C %D ID n Ln ID N M O Cl Cl Cl Cl Cl O O O O O O O O O O O O N M In O In IT N 7 m Ili co CD r4 rl CD ID 7 M O W M n 0 W W In 7 co M .--i M O 7 In O O O O O O O O O O O O O O O O O O N M In Cl In T N -;r Cl) N co Cl N n (Z)ID ` M O 1X1 M n 10 Ib W U'S V- 00 M .--i M O 7 Cl rlj In 7 � � 1 � 1 � 1 n I ltl 1 0 7 O O n I T t � 1 7 M 1 N 1 V! ' M N II O I LQ 1 W f M 1 ,-,I- LO } co ri adN �1 d:71 ol A d �o M .m.m IZ 0 Lu Ln W a- V Y x III.. V) rypM 0-y d7 }.. 1116,11 r, III P YIk 4...`a " d_„b l v w {"1 F^: q_„b III P MIY "y� 0 Cl k^d, . 111111 III P „ yl C) 0 7 � � 1 � 1 � 1 n I ltl 1 0 7 O O n I T t � 1 7 M 1 N 1 V! ' M N II O I LQ 1 W f M 1 ,-,I- LO } co ri (U E Ip -Y} m C� O O C? lo Ln ui cA CD O Cl O Cl O Cl O Cl O ID 10 ID 00 CD Go Ln Ln G Ln Ci cli r4 fPr H} 0 CD C> C, CD CR q O q q 10 10 10 O O O O q C) Cl C) C) C� Cl C� C3 C� 10 ko 10 co rl� 00 co cli < LU U) LU a- x LU bA Pik II C5 LU Ln O c u it LU SII Il a - x C3 LU m CD IR Ln co Cl Iq Ln oo � IG, ID 10 -VT l.'), CD CD CD C, Ul ol clIj a, r4 17N rIj 1o)- 1Al Ln A j F < uj Ln W x w uj O mull u IIIIIIII 1646.. 1F NG9 Th, mid OIL 0 :a Lu dl Ln LU liIx xQl C3 c LU �52 4O '!" E E Ip CD CD m C� C, Q C� I: C� C� C:) 00 r1l co C:) 10 C�co Cl cr N r4 rl O C) q q C) C, C) C� C� CD co cm) CD m cm) oo X1 mull IIIIIIB II mew nBB 12 re IT" LU 6d1 r Vrb Ln LU a -c: R ii' C3 AGI C'. L,U YW A 116�, 0 0 °IT X1 4O '!" E E Ip a, m rll� C� Q C� C, C� Q C� C�Q r1l 10 CD CD C) + V- olCl r1l CD C r4 _-z 1-Z ol cli c) (D _-z c) Lri c� q c� 'I- r CD O CD + m CD CD Cl + Ln C) Lr) Lr� CD C I Cl C� Ln w c) (D cD c) m C� �9 c� q c� c w c> c> (D r, oo lll� ll� c> c� (D - c) c� m oo m (D cn cn 1A Lu Ln 2p LU a- C3 LU W Ik m 022 m C: 0 a Ln rIj C> C, Cl cD cq c0 O O O O ,r - co ol cD cD cD cl c) cl c� c� c� c� c� c� _i m m m m m . q O O O O Ln Ln l0 .N1 m N m ,I- CD Cl O O CD O Cl O Cl O Cl Ln CD CD CD Cl Ln C) Lr) Lr� CD C I Cl C� m Ln m C� �9 Ln 0 CD C> C, CD CD O O O O O O CD q C) q CD C, C� q C) C, C� C) cm) Cl C) C) cm) Cl C) qF mull 1111181 II M 1A Lu Ln 2p LU a- C3 LU W Ik m 022 m C: 0 a u) 15 L: 3 U u C:: I a w E dj :3 E :3 x ,o 11 U Hill �u 0 0 �l CD Ln rl� U') M -T I -q ol I OO E O E Ip rl CD Q C� C, Q I)q C� C� C� V- Cl r1l C) In r, N C6 In NCD O CD M O q q O q CD C) cm) Cl C) C) C:) m r, N m to 10 00 01 r4 -64 U 81 II M II II dU x C3m LU C= 0 C: :a C C:: 2sIY v, o x a ala j Y w dj 0 r, N m to 10 00 01 r4 -64 U Village of Mount Prospect M ntP vc Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: MAY 10, 2018 SUBJECT: MONTHLY FINANCIAL REPORT—APRIL 2018 Attached hereto are the cash position and investment statements of the Village for the month ended April 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 Flexcomp Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. Governmental and Enterprise Funds - Cash and cash equivalents at March 31 was $45.2 million. During April, cash receipts totaled $6,895,139 and investment income was $44,859. Reductions in cash and cash equivalents during April totaled $5,172,585. Of this amount, payments to vendors were $3,750,167 and employee payroll expenses were $1,422,418. Outflows resulting from interfund activity totaled $1,536 while other reductions to cash totaled $12,321. Cash and cash equivalents at April 30 were $46.9 million. Investments in the Governmental and Enterprise Funds at March 31 were $9,913,563. During the month of April, investment income was ($15,985). The 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 April 30 are $9.9 million. Total cash and investments for Governmental and Enterprise Funds at March 31 were $55,131,334. Cash and investments at April 30 totaled $56,868,906. This is an increase of $1,737,572 for the month. Monthly Financial Report — April 2018 May 10, 2018 Page 2 Trust and Agency Funds - Cash and cash equivalents at March 31 was $5.1 million. During April, cash receipts totaled $195,417. Investment income for the month was $7,990. There was also a net increase in cash due to investment activities of $170,963 while inflows due to Interfund activity totaled $1,536. Reductions in cash and cash equivalents during April totaled $947,871. Of this amount, payments to vendors were $136,853 and employee payroll and related expenses were $811,018. Other disbursements totaled $1,477. Cash and cash equivalents at April 30 were $4.6 million. Total investments at April 30 were $134,086,270, a decrease of $94,590 from March 31. There were investment gains of $76,374 and a net transfer to cash of $170,963 that accounted for the change. Total cash and investments for Trust and Agency Funds at March 31 were $139,326,507. Cash and investments at April 30 totaled $138,658,476. This is a decrease of $668,031. 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 March 31 totaled $15,228,168. During April, cash receipts totaled $3,342,099, and investment income was $3,743. Significant cash receipts include sales and income taxes. Sales tax revenues for the month totaled $1,853,430. Of this amount, $1,755,581 is generated from the 1 % state portion and $97,849 is generated from the quarter -cent home rules sales tax. Sales taxes received in April are for January sales as there is a three-month lag in getting this distribution from the state. State income tax receipts for April totaled $459,947 and were for the month of April. Disbursements from the General Fund for April included payments to vendors of $1,372,346, payments for employee wages and benefits of $1,260,034 and other disbursements of $6,702. There was also a net decrease in cash from Interfund transfers totaling $802,453. Cash and cash equivalents at April 30 were $15,132,474, an increase of $95,694 from March 31. In addition, investments consisting of certificates of deposit totaling $3,677,164 bring total cash and investments for the General Fund to $18,809,638. 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 April 30, there was a total of $9,897,578 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. H:\ACCT\Treasurer's Report\2018\Monthly Cash Position Report - April 2018.docx Monthly Financial Report — April 2018 May 10, 2018 Page 3 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 April 30, there was a total of $134.1 million 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 H:\ACCT\Treasurer's Report\2018\Monthly Cash Position Report - April 2018.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report- All Funds For the Month Ended April 30, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Equivalents Balance at March 31, 2018 $ 45,217,770.96 Cash receipts 6,895,139.49 Investment income 44,859.42 Transfers from investments to cash - Transfers to investments from cash - Interfund activity (1,536.17) Disbursements Accounts payable (3,750,166.50) Payroll (1,422,417.65) Other (12,321.22) Balance at April 30, 2018 $ 46,971,328.33 Total Cash and Investments Investments $ 9,913,562.74 $ 55,131,333.70 (15,985.08) $ 9,897,577.66 TRUST AND AGENCY FUNDS * Cash and Cash Equivalents Balance at March 31, 2018 $ 5,145,647.55 6,895,139.49 28,874.34 (1,536.17) (3,750,166.50) (1,422,417.65) (12,321.22) $ 56,868,905.99 Total Cash and Investments Investments $ 134,180,859.86 $ 139,326,507.41 Cash receipts 195,416.90 195,416.90 Investment income (loss) 7,990.35 76,374.03 84,364.38 Transfers from investments to cash 1,507,283.46 (1,507,283.46) - Transfers to investments from cash (1,336,319.71) 1,336,319.71 - Interfund activity 1,536.17 1,536.17 Disbursements: Accounts payable Payroll Flex spending Other Balance at April 30, 2018 (136,852.84) (780,833.41) (30,185.36) (1,477.29) (136,852.84) (780,833.41) (30,185.36) (1,477.29) $ 4,572,205.82 $ 134,086,270.14 $ 138,658,475.96 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 w IL U) 0 w a. F - z n 0 2 0LL w I 2 -0 6 a) < c w 0 c 0 5 E E LL 0�- (D - 8 (D w o u) u) cf)� r� V 0 LO M6 N oo co aY 1- 04 t -r- _j c"rm- �2 N Qj N LIO clj �t G� M - (D v o m r-- q m 0 cQ GU a) (D 0 (D M LO o cl) -sooD c'D co ! o Lco u7 m 't co oo oo N cn N u) M co Vy N clj I - Z m Lo N N'Ir mco LnLn Nm eq LLJ I! co - Of (D Z < ui n a LL z 0 < c') co oo w cc (D Oc �T co 0 u) m N o -'t m c,'4, a.) m cl) T o N co N I - z Lij z < oo 2) �2 m N m m (D P-� rN co o oo q N14 t- ma, cli Ln ci u) m m � c Lf) (o M (D (D a) of 0 z co o w- S Pq t- co Iq m W c0 9. lz o- uj a_ c) m Iq r, �t oD co v) bq LU lao r u) S Lo a) M co- rl- rD 1) co = F, wi EL P- 'n co N (N h O o m (A) LQ c7t LU F -z < z D 04 0 N LI) a) I'.- M a) oD c0 w w eq F- LU u- 0 In (D v M ID w In z < U) 0 o (D N m o a) a) z < D o c) o m o co c o (n m m Iri co a) N co c co 04 (D -1 u- (D co m r -I In vi Lf $ m (D cj oz co mw w mo co 6 o Ln > of m r. cc� w W o m o v v U7m ca L4 w r- , , m Im m I- m w Mw r) c D v(D c� 04 Of u) o- 0 1- 0 LO o) 'c co m'I) co- V- h-- m. - V-� (o o (Q (c) (D N, W'z o) (DLO mm M Do w D c' - o (N 14 a) 6P It Z w AtP t9 V) Lo o co m Ir clj 0 c N M L) 0 (D 0) 10 c'� co to oR FLLli z - - - Iq LO (0 La LO o < 0 D c'! o mw 14 - 'r) L6 Cl - w co M co 9 Df'o Vco "I I's a) a! U) 0 F C Lu Z - - p ao m LL uj 0 r- N w Fn o(D LQ co M c oo o :t c,o co coo 1(-0- Aq �2 m(D c; < :D U) z 0 cN .Ln r- or 0 c14 C c'4 W W Z o 4 Ln t': (y) m > M co o) a) UJ W GY W v) z Go 0 (D mr- Mo u- M N (D <D N "t (D co co co "T -r 0m IT 14 c < co N m N (D o N N w N g o- (D [I- N - s �2 n0 cq co Z Ld v) LO m m .6 uj - 0 to 4A cn z W zo w rn to w IS > '&;D� < o E E z CY a) m W u F > w o a. a Z 3:(D (or Ec U5 rn UY 12u h > > ID < co z z o E 'o W E E E E mo w m , 2 E au) w2 u_ > c w w � -ffi E < EO w w F- < a) > N W Mo Lo T s C > b z 0 L) m Cl Q 0 0 LLJ - ::) iS VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of April 30, 2018 * Assets are restricted in purpose and do not represent discretionary assets of the government. 11 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Market Date Date Institution Description FDIC # Net Yield Value GENERAL FUND (001) 06/29/18 12/28/17 Freddie Mac Agency Notes 3134G9TH0 5.000% 1,206,296.40 12/31/18 12/28/17 U.S. Treasury Note Treasury Note 912828A75 1.500% 1,238,606.02 12/13/19 12/28/17 Federal Home Loan Bank Agency Notes 3130AOJR2 2.375% 1,232,262.01 3,677,164.43 WATER AND SEWER FUND (050) 05/31/18 12/28/17 U.S. Treasury Note Treasury Note 912828VE7 1.000% 2,499,606.94 2,499,606.94 VEHICLE REPLACEMENT FUND (061) 05/30/19 12/28/17 Freddie Mac Agency Notes 3137EADGI 1.750% 1,242,660.00 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 1,231,843.75 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 1,226,252.50 3,700,756.25 RISK MANAGEMENT FUND (063) 03/06/19 03/06/17 Mount Prospect State Bank Certificate of Deposit 354058 0.250% 20,050.04 20,050.04 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 9,897,577.66 TRUST AND AGENCY FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution Description Acct # Rate % Value POLICE PENSION FUND (070) Various Various Wells Fargo Wells Fargo Investments Various Various $ 22,750,395.89 Various Various Various Mutual Fund Investments Various Various 46,687,831.39 69,438,227.28 FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract 8-10810 Variable 5,795,527.03 Various Various Wells Fargo Wells Fargo Investments Various Various 22,088,926.37 Various Various Various Mutual Fund Investments Various Various 36,763,589.46 64,648,042.86 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 134,086,270.14 * Assets are restricted in purpose and do not represent discretionary assets of the government. 11