HomeMy WebLinkAbout5.1 Monthly Financial Report - August 2018BoardDocs® Pro
Agenda Item Details
Meeting
Category
Subject
Access
Type
Preferred Date
Absolute Date
Fiscal Impact
Budgeted
Recommended Action
Page I of 2
Sep 18, 2018 - REGULAR MEETING OF THEM UT PROSPECT VILLAGE BOARD - 7:00 p.m.
5. CONSENT AGENDA
5.1 Monthly Financial Report - August 2018
Public
Action (Consent)
Sep 18, 2018
Sep 18, 2018
No
No
Accept the monthly financial report for August 2018.
Public Content
Information
The monthly financial report contains a Cash Position Report and Fund Financials for the month ended August 31, 2018.
Alternatives
1. Accept the monthly financial report for August 2018.
2. Action at discretion of Village Board.
Staff Recommendation
Staff recommends the Village Board accept the monthly financial report for August 31, 2018.
5
08 Augus-�.:- f:(,)�i- U��-)�I�oad �-)df (340 K[::13) Cot�nbined fo�i- [::Y[) d �f: ( . . .. .. .. .. 7"(. K[13)
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 nv
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/Public 9/19/2018
BoardDocs® Pro
Motion & Voting
• l r ill 111111ill l: iii lll 11;i;lljll��11 1 111111111 11111 -•• 100"
Motion by Colleen Saccotelli, second by William Grossi.
Final Resolution: Motion Carries
Yea: William Grossi, Eleni Hatzis, Colleen Saccotelli, Michael Zad)
Page 2 of 2
https://www.boarddocs.com/il/vomp/Board.nsf/Public 9/19/2018
M
w
o
N
M
I
�
w
w
n
0
N fl 1-!rl
^� -I OOl OOl Orl 'tOl O M O
7 7 W LOr1 O LLr1 N LCD m ^r1
O � rl ~ O NO Lmr1 M m 7
O .ti O Lr1 rl N N
01 Ln OJ LO Tt Ln CD LO Ln ++
t
0J Orl0 W 01 M O
N M LO M O N MMO
O O O Ln rl W r, 01 m N
of Oi of t\ •--� LO
N 01 rl M M W W
O 7 01 W W v W M
M OJ
O N rj 01 m M m r, O M
O
01 O M O N N W O M v
rl O 01 O ti W O O 7
7 OJ N O^ l0 N N .M -I M
LO 7 .--i Lp
O O O O O O O O O O
O O O O O O O O O O
l0 m CD
01 01 Lr1 M W 01 O M O
LO of N of rl N rl W rl
LO L
Lr1 7 01 n M O1 O1 O
rl .--I rl W O Lr1 O N W
7 l0 N 7 l0 N l0 M 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 O O OJ O O O 01 Lr1
O O rl M Ln rl Ln OJ .--I
LLr1 N 7 OJ OM 7 ON N N
LOD W .--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
CD CD CD CD CD CDCD
O O O W O O O 001 Lr1
CD 7 O- .^-i OJ O M O m Ln rl Ln W Ln
Ln N 7 OJ M 7 N N N
lD W .--I 7 .--I
ti N
as
uI�
,.r
as
is
as
as
'
ux.l)
u
>
lS u j
tV
'
W
r4
fl)
W
f
tl)
01
I.,�1
tll
lS+
�1
IL. 'aa
L J
�.+ 'V+
�1
v+
S
0
r.
�1 iv
� r..
cz I I..
fl) fl)
0
o
F --
u
C.
uj
0
U= F --
Lq OJ
Lq
m
O
O
�D
rlj
m
O
O
Ln
Lr
ti
r,
m CD
m
CD
C�
uj
)
0 z
>uj
uj
X
1,
k6
W
Ln LD
r,� m
r-4
-
ca
ai
15�
Z M
as as
S S
N
-
N -
-
r-4
+
+
Ln
+
+
Ln
m
CD
CD
LD
i�,-
m
CD
CD
LSO OM1
L~O
`ti
r'l
m
Ln rl00
m zt
CD
ti M
LrL
LD r-4
OJ m
rl
m
rl
m
CD
O
CD
O
Ln t-
00
-
O
O
m r-4
rl�
00
G1
r-4
Lr1
CD -
C� LrL
Ln
CD
C�
uj
)
0 z
>uj
uj
X
1,
k6
W
N LO �D
CD
ca
ai
15�
Z M
as as
S S
N
-
CD CD CD CD CD CD
CD CD CD CD CD CD
rl CD CD CD CD CD
O1 O O O O O
CD
Ln
CD CD
CD
CD
CD
CD
O O
O
O
O
O
CD 00
CD
CD
CD -
C� LrL
Ln
CD
C�
uj
)
0 z
>uj
uj
X
1,
k6
W
CD r-4
00
ca
ai
15�
Z M
as as
S S
00 -
CIL C�
-
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 00
CD
CD
CD -
C� LrL
Ln
CD
C�
uj
)
0 z
>uj
uj
X
1,
k6
W
CD r-4
00
ca
ai
15�
Z M
as as
S S
00 -
CIL C�
-
N -
-
rn
CD
Lr)
ro
IIIIIIY
uj
)
0 z
>uj
uj
X
1,
k6
W
�v�
x
as
>
r
w
ca
ai
15�
Z M
as as
S S
rn
CD
Lr)
ro
tCOCCC
00
CIL
Ln
� +
CD
+
CD
CD
+
O
+
O
O
CD
CD
O
CD
CD
CD CD
CD
C�
CD
CD
CD
O O
Ln
O
O
O
CD
CD
06
CD CD
C� C�
CD
CD
CD
CD
CD CD
CD CD
CD
CD
CD
CD
CD
CD
CD
CD
Ln
O
CD
CD
Ln
Ln
LD LD
C� C�
rl
CD CD m CD CD CD
C� C� Lq C� C� C�
CD 00
CD 0)
Ln
Ln
00
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
O O
O
O
O
O
CD
CD
O
CD
CD
CD
C�
CD
C�
CD
CD
C�
CD
C�
CD
CD
C�
CD
CD
CD
CIL
CD
C�
CD CD
C� C�
Ln
rl
CD CD
CD CD
CD
CD
CD
CD
CD
CD
CD
CD
rn
CD
CD
CD CD
CD
CD
CD CD
O
O
O O
O
O
O O
CD
CD
CD
CD
CD CD
CD
C�
CD
C�
CD
C�
CD
C�
CD CD
C� C�
CD
CD
CD
- -
CD
CIL
Ln
LD LD
C� C�
N r-4
V) IQ
Ilk
uj
uj
uj
>
uj
E
CNI
ml
u
CNI
E
mi
as
>
va
s
mi
W
ca
CNI
Ir�
ml
u
uj
as
as>
M
Uj
>iv>
uj
Cj
01
CY-1
as
i
as
as
rn
n
0
kl
Ln O O O f, O M O
N O O O .--i O OJ O
N M O LO
o r\ m
Ln LOO N LOO
N OJ N
m Ln
'-I
7 7 } } OJ } Ln }
t t t t
CD
CD 00 o rn Ln Ln r -4o
M f� M Ln r, OJ
M 01 t\ 0) OJ Ln
rl Ln N' -I '-I r<1 v v v Ln
v
� O W O 7 OO1 LNn O
LO O fl 01 W LLn
07 7 N M .--i f,
LO Ln N f, W
N Ln .-I
O O O O O O O O
O O O O O O O O
N O O O O f, O O
O1 O O O O O1 O O
M
Wcc
01 O
O OJ
LO - 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 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
Ln
N
LnO
M
'-I
Ln
L
OJ
00
Oi
Ln
Ln
Ln
OJ
t\
W
O
Ln
!Pr
O
O
CD
CDO
N
M
O
O
OJ
t\
W
O
Ln
!Pr
O
O
CD
CDO
N
M
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
O
O
O
O
O
O
O
O
O
O
O
O
O
O
N
O
N
N
OJ
Ln
M
LO
LO
.--I
.--I
M
M
V)
IQ
I-. Ca
Ilk
uj
�y r
uj ...
> r
.
uuj Ifl..n
�' tiro
„II
r
i„
i
cl
IL...
C%.
is
..
as
as
'
va
CPN
IL...
as
ca
M
Luh)
i
as
as
r
s ri
a
ria
w
L...
tv
>
II.
�)
va
�)
r..
uj
tia"
"cea
r 1
is
i�1
11
II
'
t7
CJ
..'w
M
� °
f..
I'
I .
r� °
P2
yy
Itt
fU
n is
C
is
t m
TJ t6
F--
CY
Ca
F --
u
C7
u
C.
uj
0
V F—TJ
TJ
kl-
kl
�D
Lq C
C
m
q
C
Ln
r,
00
m
O
CD
G�
Lrr1l
�
CCD �
r1l
cc�
CD
C�
CD
C�
Ln
m
O
rl
N
LD
-
�D +
m
0)
CD
+
�D +
0)
Ln
CD
+
CD CD
CD
CD
O O
CD
O
O
t-
oo
00
r-4
Ln
Ln
00
CD CD
CD
r,
CD
CD
O O
O
-!
O
O
r,
0)
CD
rl�
00
rl�
Ln
Lr
CD
C�
0)
00
0)
CD
00
rl
t-
r-4
CD CD
CD CD
CD
CD
CD
CD
CD
CD
CD
CD
CD CD CD CD CD CD
O O O O O O
Ln
00
CD CD
CD
CD
CD
CD
O O
O
O
O
O
CD
CD
CD
CD
CD
C�
CD
C�
CD
C�
CD
C�
00
Ln
LD
CD
00
N
r-4
r-4
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
>
M r
uj
V' lX 11 W M
uj > a' =
> 00::5as ry
uj 01 1 0
CZ
00
V)
F--
uj
uj
uj
0
o
F --
u
C.
uj
0
U= F --
CD Ln
O 1-!
rl
N
lD
m
rl
rl�
r-4
rl�
m
m
m
CDLn
O
rl
LO
m
CIL
lD
LrL
-
Ln
Ln
rl�.
00
�D
M
CD
C�
CD
r-4
r-4
'I-
00
N
+
CD
+ LD
Ln
m
Ln
LD
"f tUlas
CD m
rg
Ln
Or�
--!'I-
i�,,
r'4
Lq
0J
LD
t-
LD
06
Ln
-
CD
m
Ujw
M00
L
-
t-
cc�
>
uj
-
01
N
LrL
r-4
—Z
a,
Orl
rl�
O�
r�
1:m
m
1-!
m
m
O
O
O
Ln
cc�
CD
CD
CD
CD
ti
CD
C�
Ln
CD
C�
m
Ln
r-4
'I-
rl
N
CD CD CD CD CD CD
CD CD CD CD CD CD
cDt-Mm
C� Oi Lq CcD� Oi t-
00 %,D
rl Ln Ln rl
Lr C� - CIL
0) r-4
rl
N
CD CD
CD
CD
CD
CD
O O
O
O
O
O
CD
CD
CD
CD
CD
CD
C�
CD
C�
CD
C�
CD
C�
CD
C�
Ln
%,D
'I-
rl
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
C�
CD
C�
CD
C�
CD
C�
CD
C�
Ln
LD
't
rl
Ln
�q
00
Ln
rl
00
00
r-4
K&I
II
"f tUlas
uj
W 11;
r>
I
Ujw
1
;5 CZ
>
uj
W
01
a,
ca
>
w S
I I
j
c2
Ln
�q
00
Ln
rl
00
00
r-4
K&I
0
kl
Ln 0)
CD
m
M
�
O
�
m
CD
O
O
O
00
r-4
m
00
N Ln
LrC�
Ln
ti
Ln
r-4
n, r
r-4
00
Ln
O
N
00
r,
m
00
r,
CD
CD
CD
r,
O
O
O
0
CD
V,
a -
EE
as
r,+
oLn
i
Ln
0
01
+
w TJ
M
+
>
w
I
5�
c2
Ln
CD
CD
(n
r'4
01
O
C n
0)
r,
6
Ln
CD
cc�
Ln
01
Ln
TJ t6
0
kl
Ln 0)
CD
CD
t-
Lq N
-!
O
O
CD CD
r,
00
N Ln
LrC�
Ln
ti
r-4
n, r
0) 00
00
Ln
O
N
00
5,
CD CD
CD
CD
CD
O O
O
O
O
CD
V,
!Pr
Ln
r*-
x
ailas>
C
16
EE
as
asa
>
>
uj
0
01
cz
0
>
w
I
5�
c2
r*-
n is
C
t m
TJ t6
F--
CY
F --
u
C
u
C.
uj
V F --
kl
CD
Ln
CD
m
u
uj
Uj W
> c cz
uj 01
CD
O
00
a
-9
kl
M
kl
t -
CD
CD
CD
CD
CD
O
O
O
O
CD
CD
CD
CD
CD
cc�
CD
rq
CD
C�
CD
C�
N
r-4
�
�
V)
IQ
-j
,. 2
-
FCa
461
uj
uj
>j
C', ml
Mi
Mi
mi
Mi
uj
W
uj
>
uj
�D Ln
N
MO
N
r-4
00 0)
t- m
oo 00
rl� �
N Ln
ti CD
ti M
kl
CD CD
O O
CD CD
CD CD
L'i L'i
Ln Ln
N r-4
-bP, -bP,
V) IQ
FCA
-
Ilk
uj
uj
>
uj
cy- ,
in
E
E
L%
0
<
kl
�DLq CCD � CCD � Cr,
�
ti 00 CD
Lr
r,, r
Ln ti
rn + +
LD CD + + CD
+ + r,
CD CD CD 0)
N - O O O
00 Ln
CD
N r-4
CD CD CD
Ob O O rn
oo
CIL C� CL
N r-4
CD CD CD CD CD
O O O O O
CD
V,
CD CD CD t-
fb O O O Ob
CD CD
Ln Ln
CD CD CD CD CD
O O O O O
CD CD CD
CD CD CD
CD r-4 r-4
CD CD CD CD CD
O O O O O
CD
-bP,
CD CD CD CD CD
O O O O O
CD CD CD
CD CD CD
CD r-4 r1l
V) IQ
FCa
-
Ilk
uj
uj
uj ml
x
ail
ml
x
mi
Ir�
01
uj
>
cz
u
uj
0
Ln
rl
00
5,
Ln CD
Lq O
-
fl�
,I-
CD
rl CD
CD
00
O�
C�
C�
ti rl�,
CIL
rl
�D
CD
CD
�D
r-4
Lr
00
>
t -
ti rl
Ln r-4
Lr�
0
0,
CD
00
0
I
au
Ln
r-4
m
CD
CD
CD
m
Ln
m
m
O
O
0
CD
V,
a-
rl
rl
00
+
i
rl
+
-j
-
n j
r-4
+
Ln
CD
CD
t:
O
^
O
CIn
r-4
rl
CD
00
cc�
rl�
(1)
CD
L6
In
In
00
Ln
t -
TJ t6
0
Ln
rl
00
5,
Ln CD
Lq O
-
fl�
CD
O
�
rV
rl CD
CD
00
N r-4
t-
00
ti rl�,
CIL
� 0)
00
>
t -
ti rl
Ln r-4
X
0
0,
CD
00
0
I
au
5,
CD CD
CD
CD
CD
O O
O
O
O
CD
V,
uj
>
2
S
2-1
oujj�25"E
uj
>
X
0
0,
m
0
I
au
as asI
C
CY
O O O O
O O O O
�D + + rl
rl + + In
v
+ +
LLq 7 M OM
W Lf1 rs rs
O G N W
M N N W
m v O
v v n
Ln
rl LLq 7 M OM
rl Lf1 Ol Ol
7 G n n
O 01 N W
7 Ill O W
7 M
n
O O O O
O O O O
m O r\ O
rn rl O
O Ln
7 W M
M M
.ti
O O O O
O O O O
m CD
Ill O
G O
M O
Ill O
N O
'-I
O O O O
O O O O
O i
fb i
N f
r, r
Ln I
rl r
!Pr
O f
O f
Ln t
� f
M f
Ln I
W f
y} a
O f
O f
O f
y} a
kl
I
weu
O
O
Ill
O O O
O O O
CD
O
O f
f
Om
m
Ill I
E
I
OLn
-j
G
M
N
O
O
CD
O
G f
M f
Ln
W f
_5 G y
<
r
•--I
•--I
Vf a
kl
I
weu
IIS
r
r
ail
weu
ry
,
as iv
u j
Ca
j X8
z eu
uj
p
uuj u.u..
aru...0
I�
r
m
r
ail
I'd
a
weu
pa,
�m
.�s
r:�:x
n
0
CD v rj Leo o v o
W O 7 r, .M -I
C r\ � of Ln 00
M O 7
00
+ r, � Ln +
+ +
M O .--i - O 7 O
O O O r- NO O M O
r
o lO0 Lr .M -I rl LrC
Ol Lf1
LDD N' -I '-I O
7 LO n7 O
O O
Lf1 Ln
MCD m O O01 N OCrj D l0 O
Ln
OJ LLr 7 N 7
7 r, n M W
.--i m l0 O M
M ti
0)
O O O O O O O O
O O O O O O O O
CD
m O M W l0 O � O
o) CD M rlJ Ln t -
W 7 LO 00 00
04 M O Lf1 01
N W W n l0
Ln
7
ti
O O O O O 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
7 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 O �0CD CD
- 00 O
7 O
t -
Ln
r
ufll
,
^u
su%N
r^
va'll
ai
as
as
,„a
ux.l
in z
uuj
'
m
caUJ
C
W
r 7
cz
M
Cl
.ti
n
O
O
M
00
00
rl
O
O
00
m
W
N
m
7
O
O
CDO
CILO
m
m
CDO
O
M
Cl
.ti
n
O
O
M
00
00
rl
O
O
00
m
W
N
m
7
O
O
CDO
CILO
m
m
CDO
O
O O
O O
O O
O O
M M
CD CD
01 01
V) IQ
- CA
Ilk
uj
�y a
uj
uj
>
CY%
r
ail
fl..
m
inu.ma
°r s
r.L.
ON
V) V'a
F- Ca
Om
M
O
O1
O1
O
m
W
t\
t\
7
m
O
CD
O1
CD
7
CD
7
N
N
N
M
M
+ m
M
+
o
W
+ O
0
ti
p
+
p
+
+
O
O M
m
O
m
m
O LO
M
t\
O
O1
01
N
6
Ln
.—I
.—I
M
r,4
O1
7
7
v
O f,
m
m
O
O M
M
N
O
O
O
t,
�D
7
of
of
N
0
N
f
O
O
N
r
cra
ca
M
M
w y
in i'_
d;:'ik LYS
uj
as
,t
°
II..1
0 W )
as
W"
cz
r
�
AXI.,
O O
O
O
O
O
O
O O
O
O
O
O
O
O
O
O LO
O
m
O
O O
O
.--i
O
N
N
7
O
01
N
7
M
7
M
Ln
Ln
Ln
!Pr
V}
O O
O
O
O
O
O
O O
O
O
O
O
O
O
O
O
O
O
O
LO
O
O
O
O
O
LO
O
LO
01
01
01
O O
O
O
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
CD
CD
CD
O
LO
O
O
O
O
O
LO
O
LO
~
M
OMi
01
01
V) V'a
F- Ca
Ilk
uj
�y r
z
uj
U
W
L.
ueu
in
�I
mi
f
Era
r
cra
ca
,1"..
w y
in i'_
d;:'ik LYS
uj
as
,t
°
II..1
0 W )
as
W"
cz
r
�
AXI.,
�) uj
X71
01
�a X71
X71
CD CD
O O
Ln
N
-
LO
Ln
O1
CD
O
CD
�D
Ln
Ln
O
O
t-
of
m
m
-
0)
O
O O
M
CD
CD
CD
CD CD
+ +
r,
O CD
CD
Ln
+
+ +
CD CD
LrLr�
+
CD CD
m
Ln
CD
C� C�
m
Ln Ln
Lin
Ln
00
^
Ln
00
r,
Ln
V) IQ
CCLrq-4 OtC
C� 00 00
t -
CD.
CD CD CD CD CD CD
CD CD CD CD CD CD
CD CD r, CD CD CD
O O fl� O M O
r,
r, CD
rl
CD CD CD CD CD CD
O O O O O O
CD CD CD
O CD CD CD
Ln
LOD
Ln
CD CD CD CD CD CD
CD CD CD CD CD CD
OJ
r,
Ln
rl
Ln
CD
rn
r-4
Ln
rn
Ln
r,
C�
r-4
00
cc�
(1)
r,
C�
r-4
00
cc�
(1)
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 CD
LrLr�
Ln
Ln Ln
V) IQ
-
FCa
Ilk
uj
uj
uj
>
uj
weu
14
in
>
caM
mlcaIr�
ch.
ujM
If
eq
E
5
in z
X
W
11
W
>
M
uj
tV
>V,
�::r
z)E
>
uj
0
w
01as
::
cz
u
s
as
�6
as
as
0
-U}
9
na
ail
va
uj
ado Z
11
ra
W
>M
oujv,
>
:i
w
f'
"E
cz u
uj
01
as
as as
>
S S
9
n
CY
N m
O1 .-I
O
1-
O
O
O
O
O
O
�D
N
O
O
00
rn
LO LO
rn
N
O
O
LO
LO Ln
fl
O
O
7
0
O
'-I
M
O
O O
O
.ti
O
Ln
t
t
0)
L^O LnW
O
O
t
t
O
O
t
t
m -
O
O
O
O
O m
O�
O
O
O
CD
0)
^
rn
M
0
V) IQ
N
Ln
N m
O1 .-I
O
1-
O
O
O
O
O
O
O O
N
O
O
O
0)
M
Irl
O
O
O
7 7
M
O
O
N
t�
7
O
O O
LO
O
Ln
O
O
O
O O
O O
O
O
O
O
O
O
O
O
rn l LMn o 0 0
7 t, .--i
N � N
7 O
M .ti
.ti
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
O
O
W
O
O
O O
Ln
'-I
Ln
O
O
O
O O
O O
O
O
O
O
O
O
O
O
CD
O
CIL
Ln
7
!Pr
N
7
O
CIL
Ln
7
!Pr
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
O
O O
M M
.-I
Ln
lO
M M
V) IQ
Ilk
uj
�y r
uj
uj
>
ux-
I'a
na
ail
via
a�
CNI
ca
w„s
a
I
f
ra
i
CIn
'1
a
as
s
uxj
eaa
v
ASV'_
II
I1�
Vi
y
tV
uj
uuj
Ga
r s
is O_
01
�.�,
Al
tv
>',:
.,��
N Irl
r� O
CD
O
m
m
CD
CD
O
M LO
O
01
01
O N
rl
0)
CD
CD
rl
0)
rl
0)
C�
CD CD
CD
CD
CD
CD CD
CD
CD
CD
O O
O
O
O
0) CD
C�
CD
-b�l
CD
-b�l
CD
O
CD
O
CD
CD
CD
CD
O
O
O
O
O
rl
0)
CD
CD
rl
0)
rl
0)
C�
CD CD
CD
CD
CD
O O
O
O
O
rl CD
rl
rl
0) CD
C�
0)
0)
Ln
CD
r-4
CD
r-4
CD
r-4
1-6-
�
CD CD
CD
CD
CD
O O
O
O
O
Ilk
CD
-b�l
CD
-b�l
ig
CD
CD
CD
CD
CD
O
O
O
O
O
rl
0)
CD
CD
rl
0)
rl
0)
C�
Ln
CD
r-4
CD
r-4
CD
r-4
V)
IQ
M
Ilk
uj
uj
>
uj
I'd
CNI
E
I'd
0
CNI
CL
as
as
s
s
E
oi
Z
I I
uj
>
uj
ig
c
a
N Ln O ti
Lf1 rV O ,--i
7 N m
CD L0 ti ,M -I
m Oi tri
� rn
rl
r�
LD o n m
0J o Ln Lq
rn Ln L
ti
M v v
N
CD m
rV O Lq 7
m �D t
� � Lr �
O M N N
Ln
O O O O
O O O O
N 7 O Ln
O W O1 Lq
7 Ln 0) N
O rl 0
O O O O
O O O O
CD CD CD
Ln O O N
M O O Lf1
7 M ,--i N
L0 fb
Lf1
ri ti
O O O O
O O O O
W f
W f
Ln t
Ln t
cc i
r\ t
tLn t
V� a
00
0
C i
rl
Wcc ,
f
N f
V�a
r\ r
C i
CD i
M f
7 '
� f
Ln I
V} a
O f
O f
O f
V} a
Sol
O i
O f
W f
V} a
O f
O f
Wrl
f
W f
O f
10 t
ir-�r
0 i
V� a
O i
O i
O i
V, a
V) IQ
Ilk
uj
�y r
uj
uxj di=,ry
>
uuj
aY
m
c
r
ml
weu
r.L.
N
O
O
O
O
CD
O O
O O
CD N
O i
O i
W
TJ'
LnCD
M
O
O
O r-4
O Lf1
~ r-4
rl r
W f
CD
i
0
l0
,M -i
W
LO
r� r
V) IQ
Ilk
uj
�y r
uj
uxj di=,ry
>
uuj
aY
m
c
r
ml
weu
r.L.
N
r
r
va
weu
ca
',
uuj
IfY
x::o
W :S
�1
I
+
uuj
01
se'i
r 7
f
>
I I.s
r, J
�.5:::;
car <,.)
V) IQ
Ilk
uj
�y r
uj
uxj di=,ry
>
uuj
aY
m
c
r
ml
weu
r.L.
N
0
t-
t -
Ln
cc�
00
CD m
O rl�
0)
O
r-4
W
r-4
W
m
r-4
Ln
Ln
l0
ti
pl
m
CIL
m
CIL
LD
CD
LD
LD
N
CIL
LD
rl
00
C�
00
C�
rlj
rlj
�
�
CD CD
CD
CD
CD
O O
O
O
O
CD
CD
CD
CD
CD
C�
CD
LrL
CD
LrL
CD
LrL
't
Ln
Ln
�D
rl�
00
ll�
rl�t-
rl�t-
Ln
yr
en
CD CD
CD
CD
CD
O O
O
O
O
CD
-b�l
CD
-b�l
kl
CD CD
O O
CD CD
CD CD
L'i L'i
Ln Ln
V) IQ
FCA
-
uj
z
uj
>
uj
na
N
N
0
o
F --
u
C.
uj
0
U= F --
CD rl
O N
Ln CD
�
CIL
LOD
Ln �D
LrL rl�
LD m
Ln00
Ln
Ln
Ln
M
C�
00
cc�
00
00
00
�D
rn
O�
�D
CIL
00
r-4
O
C�
CD
-bPr
Ln
M
C�
00
cc�
00
00
00
�D
rn
O�
�D
CIL
00
O
C�
CD
-bPr
in
0
kl
M
N
■
,I: � rlj CD l0 7 M N L�0 W 7 W Lf7 O O � CDO
m fl t\ l0 O l0 M O t\ t\ M .--i LO
O fl 7 m N m N M t\ N W m .-I
01 N Lf7 .-I OJ O Lf7 Lf7 ll W N N W
7 OJ Ln .--I N OJ fl 7 M N LO 7 fl
M 7 m M M O l0 t\ O W Ln Ln
O OJ N N .-I N M Ln .-I N
LO O Ln
- O N W N lD t\ O O 7 O O + m O
LO OJ Ln LO M LO LO M fl + l0
O 7 OJ M LO 7 7 O OJ M N O m
CD
f� O
7 fl t\ O^ 00) M N 7 Ln M N 7 t\ O
OJ M O 01 N Lf7 M 7 O fl t\ t\ O
m M N M t\ 7 m 7 M m 7 m O O
m Ln
7 01 N N N .M -I OM LO ^ M fl
O N M
rl
M O Ln N O fl Ln LO O LO LO LO O 7 O
N O O1 .--I O1 M Lf7 Lf7 O .ti M W O N O
fl 0) - 01 lD M t\ M N 7 0) 0)
m m N fl m N W .--i O1 W W .--i
.-I OJ OJ OJ 01 OJ O OJ M Lf7 M .--I
Ln O N M fl 0) OJ 7 07 .--i 0)
7 Ln r-4 rl .--I N 7 ~ .^-I M
O O LO O fl O O 7 O O LO M O LO O
O O Lf7 O f* O O O O O N O1 O 7 O
M 7 LO 01 7
Lf7 O f� 7 t\ Lf7
N LD W 0) O
N
Ln M
CD
N M 7 OJ N 1-!Irl
^7 -I fl O O N t\ O rlj CD CD rlj CDM O
m LO O 7 7 7 fl W M .--i OJ
N OJ N OJ 7 LO 7 0) M M LO
Ln 0) O 'I- Ln f, t\ t\ O W
fl 1p L6 M M 7
fl l0 N Ln .-I M M N
01 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
fl 7 0) O LO LO Ln LO OJ LO O OJ O
M M OJ Ln N Ln .-I O Ln N fl M M O
O N Lf7 01 O O l0 01 7 7 4\ 01 7 O
Ln 7 fl l0 N 7 fl t\ M 0) M 0) O O
O 0) LO Tt Ln M m m LO Ln LO Ln
01 Ln l0 M 7 f, l0 N O t\
O 7 W
N .-I
O O a O O O O O O a O O O O O
O O CD O O O O O O CD O O O O O
O CD Ln 00 O CD CD O O
Ln m M
f� O 7 7
M 0 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 O O
m 7 m O l0 l0 .--i LnLO OJ LO O O O
N Lf7 01 Ln N
Ln rlj Ln rlj Irl m CD CD
O O l0 .ti 7 OJ fl Lf7 O O
Ln 7 W l0 0) Tt 4\ Tt M Ln 7 M W O
O 0) LO Tt M M Ln OJ .-I Ln Ln 0) Ln
01 7 Ln LO M 7 f, l0 N W t\
LO 7 oo
N .-I
10
O
co
7
Ln
OJ
,I -
Ln Ln
V)
t7a
!V
M
0
II II
w^M 417
CfY
�a
�
PdM
'�5
lX
Y',1..
o
l%•.
lX
�?'
%'y lX
d"'7 LL�
t�.i
>/Ca
as
cd
'iva
cd
w
fY!
l7J �V
P
�)
uj
Y�
y
�a,
as
ca
�a
!v
MA
IIs
(Id
IL.I
(7
(Id
Ya
M% �o'
Yea
t)
do
10
O
co
7
Ln
OJ
,I -
Ln Ln
■
TJ .W
E f.
Lem
LL
kl ¢C
CD CD
O O N N LOf1 O O
O CD 01 Ln
00
W 7 O
m W ti
rn �
+ +
N
O
7
+
+
+ +
O
Ln
Ln
+
+
+ +
ti
O
N
O
+
+
f,
fl
O
N
O
O
0 0
o
LLrn
LLn
o
0
r
f�
0)
N
Ln
t\
M
t\
M
t\
O O
O O
O
O
O
O
O
O
O
O
O
O
LnN
m
i )
0 0
o
v
LLn
o
0
u
CfY
O
7
N
f's:
M
LO
00
M
Ln
CD CD CD CD CD CD CD
O O O O O O O
O O O O O O O
O O O O O O O
00
O O
O
O
O
O
O
O O
O
O
O
O
O
ti
O
N
O
I
f,
fl
O
N
O
O
X„8
N
LD
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
ti
Y
O
f,
fl
O
N
O
O
I
N
LD
LD
X„8
r
f�
0)
N
(T
00
Ln
rn
00
ri
0
7
0
00
!Pr
0
00
!Pr
O O
O O
N N
t\ t\
7 7
O O
Ln Ln
V) IQ
M
Ci
uj
i'_
uj
a 8
uj
CPN
fR
N
Cly
Cly
S
fI.L..
ro
Y
I
X„8
i )
u
CfY
uj
f's:
M
y,4
CJ
f:
d"I;P
uj
5t
lS
uj
co
4
cc
4,.)
(T
00
Ln
rn
00
ri
0
7
0
00
!Pr
0
00
!Pr
O O
O O
N N
t\ t\
7 7
O O
Ln Ln
V) IQ
M
Ci
uj
i'_
uj
a 8
uj
CPN
fR
N
Cly
Cly
S
fI.L..
ro
■
o� � � rn o o rn � o
.N -I m N LD rl N
N M O m fl 7
.—I N
M
01
Ln
M
01
Ln
M
+
O
N
+
+
N
LO
+
o
+
~
+
+
^
M
+
M
+
+
+
+
M
O
O
O
.--i
O
O
LO
Ln
O
N
N
Ln
O
O
LO
O
O
M
O
O
Ln
Ln
fl
O
O
O
l0
fl
7
Ln
mO
Ln
LO
Ln
LO
.--I
Ln
Ln
7
LO
M
M
N
N
yr
en
O
O
O
O
O
r\
m
O
�D
�D
Ln
O
O
M
O
O
LO
O
O
Ln
Ln
N
01
01
.—I
N
N
.ti
M
O
lO
lD
M
N
m
LO
N
O
7
7
7
Ln
M
M
fl
Ln
t\
Ln
-b`�
-b`�
O
O
O
m
O
O
f,
t\
O
N
N
O
O
O
O
O
O
O1
m
O
O1
O1
fl
M
N
M
M
O
O
O
7
7
7
Ln
m
Ln
m
O
fl
Ln
N
N
Ln
ti
Ln
N
Ln
7
Ln
7
en
en
O
O
O
O
O
O
Ln
O
Lo
Lo
Ln
O
O
O
O
O
O1
m
O
N
N
N
M
.--i
m
m
MCD
0)
m
m
m
p
ti
ti
ti
CD
t`
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
Ln
fl
.--I
M
M
O
O
N
N
'.�
m
O
W
.--I
.--I
M
Ln
Lnrl
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
lD
lD
O
O
O
O
N
N
N
7
M
7
M
O
Ln
m
W
Ln
rl
1p
fl
1p
t\
-b�l
-b�l
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
CD
O
CD
fl
N
O
t\
t\
O
O
O
O
N
N
m
O
O
N
Oi
Oi
Oi
'w
tl
O
N
m
7
.--i
7
7
M
7
M
N
N
4P)
'?
„
M
LLY1
4P) '......Y
Z II
LLY.1 Ilry
a- r
Y
uj
O
'......Y
cl,
II
I
>
O
�I
O
M?
N
va
Va
td)
va
to
VaLj
I1,s
W
cd
V
YYuj417
"
M
CJ
II
a
LLY 1
w
0
Or
tV
�7
IIs
Yid
t )
fd1
t 7
0
M
■
0 0 o v o
0
M
M 00
Ln
~ N
N
O O O 7 O
Ln
O OJ
rl N
Ln CD
01
ri
CD
0 0 o LLq 0
CD m
Ln Ln
Ln
r N
7
O O O O O
O O O O O
O O
O O
O O
CD C\
C\
M
O O O O O
O O O O O
rl
N
7
00
M
Ln
O
Lq
m
O
M
7
7
CD
N
Ln
rl
N
7
00
M
Ln
O
Lq
m
O
M
7
7
O
O
O
O
O
O
O
m
O
O
O
m
O
O
O
O
I�S
y.
O
rn
M
O
O
Ln
W
v
N
O
O
O
O
r-4
Ln
t6
.N
-I
00
CD
0)
r,
\
rl
W
rl
W
a'
M
m
m
a-
+
+
+
o
i
r\
+
+
°'
+
v
+
+
+
�. Ca
_y
uj
4P) '......Y
O
O
O
0)
O
0)
O
O
O
O
O
O
�5
Ln
uj
rn
M
.�
IW61
00
CD
I
�
TJ t6
I
■
0 0 o v o
0
M
M 00
Ln
~ N
N
O O O 7 O
Ln
O OJ
rl N
Ln CD
01
ri
CD
0 0 o LLq 0
CD m
Ln Ln
Ln
r N
7
O O O O O
O O O O O
O O
O O
O O
CD C\
C\
M
O O O O O
O O O O O
rl
N
7
00
M
Ln
O
Lq
m
O
M
7
7
CD
N
Ln
rl
N
7
00
M
Ln
O
Lq
m
O
M
7
7
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
CD
r,
\
rl
W
rl
W
M
m
m
4P)
IQ
�. Ca
uj
4P) '......Y
uj I'd
I'd
uj
IW61
I
�
I
,
II
CNI
c>
LLY'�
417
CP)
f s
>S
tV)
uj
f..
f
f„)
r
Itt
■
rN o0 0 o N W
M N 7 00 o N
O C71 O f� Lr
N OJ
0 N rCD CD Ln
N o o M 7
(t OJ LO 0 7 M
o OJ 7 C C �,
lD '-I
N
rl
CD CD
Lq 0
CD
0
CD
0
CD
0
N
M
Ln f,
I
+
Ln
Ln
t�
o
7
LMO
LO
W
CD
CD
CD
CD
N
OJ
W
o
0
o
Ln
N
Lf1 LO
OJ
M
0
N
7
LO
N
7
7
M
Ln
1
T
.ti
\
M
0 N rCD CD Ln
N o o M 7
(t OJ LO 0 7 M
o OJ 7 C C �,
lD '-I
N
rl
CD CD
Lq 0
CD
0
CD
0
CD
0
r-4
LO
M
N
Ln
t�
o
7
LMO
LO
Y
uj
CD
00
M
M
Ln
N
o .--i
o
0
0
O1
7
N f,
61
M
(t
1
T
N
7
t\
�
0 0 0 0 0 0 0
0 0 0 0 0 0 0
61 Ln 0 o f, 7
N Lf1 M M fl G
7 N Ln Ln Ln f,
.N -I .Ln -I W
0 0 0 0 0 0 0
0 0 0 0 0 0 0
Ln Ln
t, 7
t� 7
Ln 7
N
0 0 0 0 0 0 0
0 0 0 0 0 0 0
LO 0 LO LO 0 0
Ln CD CD CD CD
N Lf1 CIL CI o LLr
7 N Ln Ln N o
N o OJ
Ln
00
Ln
00
0
Ln
0
0
m
0
LnLnL
O\
Ln
N
0
LnN
7
Ln
t\
0
m
N
t\
7
t\
!Pr
CD
OJ
t\
CDrl
'-I
'-I
0
0
N
CD
CD0
OJ
Ln
(71
00
V)
uj
V)
Z
u
00
Ln
00
0
0
m
0
LnLnL
O\
Ln
N
0
LnN
7
Ln
t\
0
m
N
t\
7
t\
!Pr
CD
OJ
t\
CDrl
'-I
'-I
0
0
N
CD
CD0
OJ
Ln
(71
00
Y
uj
I.I''�Y
1
T
C
fln
I
�
II II
.,f.s:
�,
Y
j
V)
l
Y
Y
h
Y]..,
S
Ma
'�J
LLY.1
M,
lX
xl%
i
a-
lS
uuj
tXl
tXl
V
K&I
CD
0
CD
0
CD
o
w
CD
ray E
TJ TJ
CD
V,
C
kl
CD CD
0 0
CD
o
LL
0
CD
kl ¢17
u
V)
z
uj
C.
a-
uj
uj
(1)
CD
(1)
O�
C�
O�
00
00
o
n, r
Ln
Ln
V = F --
II I
IIS
CD
CD
CD
0
0
o
CD
V,
'cl
Uy
V)
E
uj
<
a -
X.
K&I
CD CD
0 0
CD
o
V) IQ
CD
ray E
TJ TJ
10
kl
CD CD
0 0
CD
o
LL
0
CD
kl ¢17
K&I
V) IQ
10
uj 61
V)
z
uj
a-
uj
II I
IIS
V)
uj
a -
X.
lS
uj
lS
cc
K&I
■
.ti 7 L0 L0 N f� l0
L0 L0 M L0 N L0 Lf1
_ M
O 7
L0
O
m
rl
O
O
M
M
N L0
M
N
L0
M
N
N
M
N
M
OJ
O1
W
M
01
N
lD
Lr
O 7
W
M
Irl
O
N
CD
Ln
Irl
00
r -4N
m
.--i
N
LD
O
.ti 7 L0 L0 N f� l0
L0 L0 M L0 N L0 Lf1
_ M
O 7
L0
O
M
O1
O
L0
O
O
M
M
O O
O
O
O
O
O
O O
M
N
M
OJ
O1
O1 W
M
O
7
0
�
O 7
W
M
Irl
O
N
CD
ti
Irl
M
ti
7
m
.--i
M
LD
O
LLq
O
O
7
O
L^0
M fl
.--I
t\
M
N
.--I
O1 t\
7
of
O
of
of
Ln L0
.--I
t\
Ln
l0 fl
.-I
Lf1
N
O O
O
O
O
O
O
O O
O
O
O
O
O
Ln
M
7
t\
.-I N O .ti O t\ 7
M OJ fl Ln N fl
N M O - N Ln
fl W N W
O d n N M
N
M
O O
O
O
O
O
O
O O
O
O
O
O
O
m .-I
7
.--I
7
M
M
O1 W
M
O
7
0
�
O
W
rlj
M
Irl
O
N
CD
rl -
N
Irl
O1
OJ
7
O)
.--i
M
LD
O
O O
O
O
O
O
O
O O
O
O
O
O
O
7
M
Ln
M
7
7
Ln
0
Ln
t\
7
O
Ln
Lr
L
7
N
7
t\
O
Lf1
r\
M
OJ
O
Ln
rlLn
7
OJ
M
N
0
Ln
t\
7
O
Ln
Lr
r-
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
7
l0
7
M
M
O
O
O1
W
rlj
M
Irl
O
Irl
7
Irl
L0
�
Irl
Irl
O
O)
.--i
of
LD
O
of
of
'w
tl
N
.--i
W
OJ
N
7
7
M
7
M
M
7
7
V)
IQ
M
�. C1
uj
LLY'�
a- ml
uj O
O,
W6U
W6U
O
�Y
01
u
mil
W6U
�1
lS
tV
Yui
�
�s
tM
�s
cri
ca
as
as
as
r'..
a;a
cr
`aa
V,
cra
as
Orr
M
uj
v
W
Cj
x
uj
O
i..
W
w
r-
CD CD CD CD CD
O O O O O
rlj CD CD
ti CD CD
M Ln CD CD
Ln 10 Ln CD
M - m lD
r,
rl�
CD
C�
r-4
�q
CD
C�
00
r�
Lm n
CD
Ln
m
x
�D
0
00
m
rn
Ln
00
00
m
CD
CD
N
r-4
r,
N
CD
-
-
r-4
lD
r,
C.
V
0)
CD
t-
+
oo
lD
lD
+
CD
n is
CD
CD
r,
+
CD
M
O
O1
O
O
ujV'a
N
CD
0)
C.
a -
CD
-
cc�
I
Ln
CIL
C E
�z
N
LD
m
CD
00
11
_5
N
—1
Lq
O
CD
�)
!fid
t-
LD
r,
LD
t-
CD
6
klE
C�
L'i
00
r,
CD
Ln
Ln
N
CD
CD
O
O
O
O
O
TJ t6
Ln
CD CD CD CD CD
O O O O O
rlj CD CD
ti CD CD
M Ln CD CD
Ln 10 Ln CD
M - m lD
m
,I:
t-
O�
I: m
CD
C�
CD
C�
Lm n
CD
00
x
0
00
-
�
m
CD
CD
r,
r,
N
CD
-
-
r-4
lD
r,
C.
V
uj
IrY
CD
CD
r,
CD
CD
M
O
O1
O
O
ujV'a
N
CD
0)
C.
a -
CD
-
cc�
I
Ln
CIL
C E
�z
M
Ln
CD
00
11
_5
Ln
M
LD
Ln
m
CD CD CD CD CD
O O O O O
rlj CD CD
ti CD CD
M Ln CD CD
Ln 10 Ln CD
M - m lD
Ln
Lr1
LD
m
CD
O
CD
O
CD
O
Lm n
M
00
x
0
00
-
V
uj
IrY
CD
CD
CD
CD
CD
O
O
O
O
O
ujV'a
N
CD
0)
-jCD
a -
M
C �
I
Ln
tO
J
�z
M
Ln
CD
CD
11
_5
Ln
M
LD
Ln
m
�)
!fid
cc
klE
CD
CD
CD
CD
CD
O
O
O
O
O
Ln
RE
CD
CD CD CD CD CD
O O O O O
rlj CD CD
ti CD CD
M Ln CD CD
Ln 10 Ln CD
M - m lD
Iqr,
CD
�D
Lr)
-V�
a
x
uj
IrY
V)
ujV'a
a -
M
Cd01
I
0
X.
uj0
�z
a
cj
I
!d
�)
!fid
cc
Iqr,
CD
�D
Lr)
-V�
a
�S 4
C
y. c.
a
■
TJ .W
E f.
Lem
LL
N LMCD O O � CD CD CD CD CD
O O O O O
N N 7 LO .
m .--i O 0)
01 Lr N
'-I lD lD
M ti t\
N
+ + 01 .--i N + + + +
+ + ^ + + + +
+ + + + + +
Ln m - O O O O
Ln 'o r\ Ln O O O O
0 \ N Ln
v M
CD Ln
CD CD CD CD
LLq LO OJ N 7 O O O O
N 7 N O O
l0 Lf1 f� Ol .--I
7 N M
~ N
CD CD CD CD CD CD CD CD CD
O O O O O O O O O
OJ
O
O v O v O O O O O
Lq N —i M O O O O O
N 7 N Ln .
O f� N l0D
7
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
O O O O O O O O O
O O O 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 ti Ln
ti O Ln
Iq
O
7
0
v
M
O
CDm
M
N
O
OJ
O
co
7
Lr)
!Pr
CD
W
CDO
O
Iq
O
7
CD
W
CDO
O
O O
O O
OJ OJ
V) IQ
�. Ca
uj
z u
u
G3_
X. N
uj
lS
S
fI.L..
V)
!V
M
IkJ
V)
N
LLY..1
V)
�
CfY
s'
tX)
CfY
!V
aS
Pd:M
>
Cd
Yl
!V
a
a
MX
Yca
a
�.,'
r
<,.)
Cd
f
!v
I
>
Y'1. ',,
;
X r:o
r1 r
Iq
O
7
0
v
M
O
CDm
M
N
O
OJ
O
co
7
Lr)
!Pr
CD
W
CDO
O
Iq
O
7
CD
W
CDO
O
O O
O O
OJ OJ
V) IQ
�. Ca
uj
z u
u
G3_
X. N
uj
lS
S
fI.L..
r-4
m
CIL
M
CD CD CD CD
O O O O
CD CD Lq CCD I'l
C� � O�
00 Ln
N
ti CIL
CD CD CD CD
O O O O
CD CD CD CD
CD CD CD CD
Ln 't m
N
f;lV)
uj
0
uj
a
III
4d
Cd II.A
-
x.
0
uj
CDCD CD If
O OO
-0 .,
E
LL
o
OO (D I �
C! C! C!
CD
O
CD
O
CD
O
10
uj
V)
uj
a
CD
CD
CD
O
O
O
ca
O
O
O
CD
CD
-jCD
CD
Mi
-0 .,
E
LL
o
OO (D I �
C! C! C!
CD
O
CD
O
CD
O
10
uj
V)
uj
a
CD
CD
CD
O
O
O
CD
CD
-jCD
CD
Mi
kl
CD
CD
CD
Mi
O
O
O
16d
E
•I
-0
-0 .,
E
LL
o
OO (D I �
C! C! C!
V) IQ
10
uj
V)
uj
a
uj mi
Mi
Mi
16d
•I
uj
a -
10
X.
uj3
w
S
cc
0
V
IIIIIIY
V,
uj
a
uj
M
V) IQ
ca
uj
V) IIIIIIY
Z
uj
a-
x,
uj
in
a
rn
O
Lq
+
m
o
o
OJ
o
rn
O O
O
O
+
O
Ln \
CD
CD
O
CD
m
LnO
N M
O
Ln
O
LO
N N
O
.—I
+
m
M OJ
O
OJ
+
N
O O
O
O
+
O
Ln
CD
CD
O
CD
CD
N N
O
N
O
7
ti
CD
O
CD
Ln
LLn
m
N N
O
M
m
7
O
M
O .--i
O
N
O
.--I
O
O
O
N
r\ Ln
O
v
O
O
r\ r\
O
r\
O
�q
O -
-
V)
IQ
r\ r\
Ln
t -
�D
M Ln O OJ
rl
O O O O O O
O O O O O O
Ln
O
'-I
r\ Ln O O O O
LO M O O O O
f'l W
7 Ln
ti
O O
O
O
O
O
O O
O
O
O
O
O O
O
O
O
O
CD CD
O O
CD
Ln
CD
O
O
CD
O
Ln
M
CD
O
O
ti
CD
O
CD
Ln
M
O
O
O
O
O
O 00
O
O
O
O
O
O
O
O
O
O
W
W
00
0
OJ
L
7
Ln
v
7
OJ
Ln
t -
CD
00
!Pr
O
Ln
O
0
00O
N
O
O
Ln
O
CD
00
0
OJ
v
Ln
7
OJ
Ln
t -
CD
00
!Pr
O
Ln
O
0
00O
N
CD
O
O
Ln
CDO
CD
M
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
CD
O
CD
O
CD
Ln
CD
O
CD
O
CD
Ln
CD
Ln
Ln
Ln
Ln
O
Ln
Ln
Y
V)
IQ
�. Ca
uj
uj
X.
uj
�N
m,
�pp
N"
II
II I
M
'Y;"tai
sea
va
r1.
as
�a
i
cra
'
��
�s
�
a
f
av
V)
aa-
Ui
�'
0
x.
ry
ry
.
r .
uas
s
as
r
i
o
r i
rs
M
CD
O
00
00
O
CD
CD
U
Ln
Ln
C
CD
CD
w
00
u
- 00
0
a-
CD
+
r-4
rn
-j
+
+
K
0
L.
Ln
Ln
In
a,
CD
r-4
r-4
O
V
cc�
cc�
00
00
00
00
TJ t6
CD
00
00
O
Ln
Ln
M
m
00
00
CY
CD
CD
CD
O
O
O
U
CD
V,
C
u
C.
uj
CD
O
rn
rn
0
L.
Ln
Ln
In
a,
V
■
CCD o m 0 0 0 0 0 0
O 7 0) .
N Ol O
~ N M
O t- O l0 O O O +
+ M
N + +
CD O O O O m O
o ^ O O O O O r\ O
CD CD CD Ln
o CD t-
oo Lr CD � C C C
O O O N
Ln LO
O 7 O Ill O O O O Ill O
O N O .--i O O O O N O
O LO M M
O O N r'l
W M Ol N
.--I N 7 .--I
Ln Ol
N N
n
CD CD CD CD CD CD CD CD CD CD
O Lfl O O O O O O O O
Ln M
O M
Ln CD
O LO
7 Ol
O M O LO O O O O O O
O Ol O W O O O O O O
O M O
O M r'l
N O .ti
ti O Ill
M 0)
N
'-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 Ol
Lfl Lfl Lfl O O O O 7
M O O O M
00 r-4 Ln 7 N n
M
O O O O O O O O O O
O O O O O O O O O O
O O O O O O O O O O
O O O O O O O O O O
O O O O O O O Ol
Lfl Lfl Lfl O O O O 7
M O O O M
00 r-4 Ln 7 N n
M
IX8
IW�1
O
�I
weu
..
rCi
ra
�,
f
>
�d ?
r r.
+'87
L"
V)i
>
2
Yl
cra
av
w
�d
Is
Cd
a
C
cd
2
Or
lS
11.s
�y_
�Y,,'
III
tdl�
t.7
4d
Cd
�,
Cd
rid
IL.I
tdl
�o
lX
lX,
S
V
rl,,,
c
Va
C r
o i
W f
n f
Lf) t
esr a
0
7
■
f'l t\ t\ W t\ N N O O O m m O O O O O
OJ OJ OJ Lq .--! f* .--I O O O .--i O O O O O O
LD Ln.N-I f'\ Ln m W N t\ O
OJ M W O
LnN M O OJ LD l0 7 OJ
N Ln
M m .--I O m f' 7 t t m O M W O O .--i t
LD LD OJ LD 7 LD 7 t t M t
t t t
m L v t D m 0 0 0 0 o rn t o o v o
0) LnL0n N .N -I 7 L0n LD N CD r-4 N CD CD 00
O O 7
01 01 M NO t\ O O O N
.--I .--I O7 7 t- .--i LD . -- N
M i NLD O Ln OJ
Ln 01 7 01 M W lD W t- .--i .ti O
OJ N Lf1 .—I -
M ti
.--i M O f'l 7 N O O O O O .--i N O O m O
N 7 LD Lq N fl O O O O O M N O O Lq O
OJ Ln OJ Ln 0) 1- W O lD t\ t\
7 LD 7 N f'l 0) LD Ln M 0)
.—I N N M Lf1 N 01 7 O Lf1 N
'-
lD f'l m I LD D M N '-I N LD
D 7
7 LD M m t\ lD W CD t\
Ln
O O O m O O m O O O O m 7 O O O O
O O O LD O O O� O O O O t\ O1 O O O O
m 007 CD 00 t -
W W
O O 7 0
Ln M W
M
O M m O N 7 f'l O O O O O m O O O O
f* W W t\ Lq OJ Ol O O O O O W O O O O
0) LD Ln .—ILD .—I Ln Ln O .
M fl l0 M Lf1 01 7 N 7
O m - ri ri ri l6 lD O
LD OJ 7 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
00 7 N o) W 0) 7 lDD O lD W .--i O O 7
.—I N Lf1 OJ N 01 01 O O M 01 O O Lf1
O7 0) M Ln .--I 7 0) O .--i M 7 O Ln N
.—I N 7 OJ f'l 0) N t\ O .--I .--i OJ
M 0) cc .--I M N fl .--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
O O
O Lf1
N
O N
O O O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O O
00 7 N o) W 0) 7 lDD O lD W .--i O O 7
.—I N Lf1 OJ N 01 01 O O M 7 O O Lf1
O7 0) M Ln .--I 7 0) O .--i N N O Ln N
rl N 7 OJ I'l 0) N C\ C\ lD .--I rl OJ
M 0) cc - M .--I 7 .ti -
N OJ Ln
0
CA
fl.....
M
CPN
�,a
0
CA
DI
V)
fl .
I�
in
C'
I I.,.
V)
ry
a _
tV
M
CfY
(Y
f .
A
,
III
M
V!
}^
t7
lP'!
6fA
Yd
MX
o
c *r
h
lCA
Cd
Yd
lX
II'I
X
t7
0
'�X
co
<7A
u,
X
cc
�I
N.L,I
`�
f`)
�
III
X
t7
Va
tri
6fA
S
lP'a
P`w
�7A
�
�
o
tV
?
CJ
cc
CA SV
l
Va X'X
0
00
7
7
(T
OJ
N
0
O O
O O
�D �D
Lf1 Lf1
7 7
00 00
OJ OJ
t\ t\
OJ OJ
tF tF
V) IQ
d M�
�. CA
uj
i'_
II
ujfl.....
a-
x.
uj
CPN
0
ml
DI
ml
in
C�
Cly
lS
I L..
■
TJ
f
anew
0
kl ¢C
r\ m r\ O O O O O O O
LO rl M O O O O O O O
61 O LLnn LD .t --I
rl rn rl O
N O Ln
N .-I
M Ln Ln r, O + + O W +
LO LO M LO + + +
+ + +
m 0 0 0 0 0 0 0 0
N M .--i W N LO O
Ln .M -I O
G N Ln Ln N
� l0 M n l0
m CD CD CD CD CD CD CD
W N lq O O O O O O O
't - Ln LD O
Ln LLr p
7 .--i W M
N M
CD CD m CD CD CD CD CD CD CD
O O 7 O O O O O OLn
O
N
Ln
N
v n Lq Lq 0 0 0 0 0 0
M LO W LLnn .
W M W
N .--i uD
O O O O O O O O O O
O O O O O O O O O O
r, Ln M 7 N LO O
l0 O^ CD
O lD Ln LOn O
W r, '-I r, O
M - lD 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
r, Ln M 7 N LO O
l0 O^ CD
O lD Ln LOn O
W r, '-I r, O
M - lD Ln
O i
� t
M f
Ln t
CD7
y} a
0
Ln
Ln t
r r
m f
� f
W f
{{} a
� t
n r
n r
7 '
(71 f
W f
W f
{{} a
7 '
Ln I
N f
Ln I
N f
yr a
V) IQ
d
�. M�
Ca
uj
Z II
uj
a -
X.
uj IW�1
w
Y
�I
W61
t/a
td)w
01
M
in
W
uj
4_19
td)
cc
in
�.
CfM
M
!V
J
tt".d
PIS:
Cl
A
01
ca
I
y
,a
it.1
�
MA
I L,s
(Id
IL.I
rid
!"o
rid
f,,.7
co
co
iX 0
f'°:'
0
■
OM M W L0 M N O O O O
0) - l0 7 .--i N
Ln M f'l l0 N 0)
fl O N .--i 0) L0
L0 W M 7
Ln
M Ln N 0) f'l N } } } }
L0 L0 Ln N L0 t t t t
N W f, M l0 Ln O O O
W M f- W M Ln O O M O
7
M LrL M O M M M
O 7 Ln W O M
v
W l0 W .--i L0 7 O O M O
0) f'l W Ln 7 M M
N N L0 Ln 7 .--I W
01 Ln W M L0 N fl
W 7 M 0
CD CD Ln CD CD CD CD CD CD CD
O O 7 O O O O O O O
00 CD
00 CD
l0 Lf1
O N
O1 W 7 M Ln O O O O O
f'l .--I W CD
. f'l
O O 01 7
N .—I M
O O O O O O O O O O
O O O O O O O O O O
Ln f'l W f'l f'l Ln
N O W CIL M 0) Ln
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
O O O O O O O O O O
O O O O O O O O O O
Ln f'l W f'l f'l Ln .
N O W CIL M 0) Ln
W M W O
N .—I O
rl
N f
W f
Ln
7
W f
W f
blr a
:m III
N I f
N f
M f
W f
!Pr i
Ln
7
W f
N f
N f
7 '
M f
y} a
Ln I
N f
00
l0 t
Lrj t
f� f
y} a
O f
O f
CD f
O f
N f
M f
f� f
y} a
O f
O f
O f
y} a
9
1P) IQ
tV
uj
i'_
uj
a- �
r
Y
X.
uj
0
;Y
oy8
Ygy
01
IW61
M
0
Y"
tV
tV
V)
Y 1..
M
f.:
guy
II..
I'ik
gN�l
u
NW
IFq
uY.l
ICfY
LLl'.1
Va�,�'
�A
y%
tV
t"a)
a;)
cc
tdd
g}'d„
CfY
S
i.J V'a
tgi
f
6"*M
V'a
lX
Cl
y
X
f
YY
III
lSalSa
fdM
gJ
Y'1
fdM
V)
f.
9
■
f ! m�7 .M -I 7 7 OJ O O fl
N f'l ON LO OJ Ln
OJ O N .ti Ol
.--i O M .--i M O N
v Lo Ln m
O N N
fl to W m to m } O -
LO OJ � l0 W OJ + Lf7 01
7 M O1 O .ti lq O W O
01 n O LOr7 LO 7 O LO
OJ .ti .--I O 7 OJ M M
N00 00
Ln M Ln
M
N M M m m N O O O
Lf7 LO O fl W N O N O
M 7 OJ - Ln .-I 01 O
Lf7 O1 N OJ O N Lf7
07 f'l M f'l N N M
\ Ln 0)
O M M
O O O O O .--i O O O
O O O N O .--i O O O
O OJ
LMf7 O1
O
LOO W O LLq n O^ O O O
LO r\ � � o .
CD L^O OD M O
LD O O Oi
t'l M .--i 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
CD CD 7 - O
O 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
O
O
O
O
N
M
Ln
O
Ln
01
N
7
O
O
7
M
O
OJ
M
fl
lD
W
N
N
OJ
Ln
'7
W
M
.--I
M
LO
LO
O
O
O
N
Ln
Ln
O
Ln
O
N
N
4P)
IQ
�. Ca
uj
4P) '......Y
i'_
uj
a- I'd
O- C
X.
ml
O
I
ml
r
va
01
ml
M
u
ml
1
X8
Cf}
Cl1
�)
cc
417
Cf}
M]
Y7
y
�j
tV
0i;,.
Cd
III
III
tna
�,y:
III
N.I.I
uj
0,IM
M
f::
0
V F
■
(D I- (D 1;
C! N C!
m
co
�W 1�
-bP,
CD
O
M
N
CD
O
w
CD
O
CD
CD
CD
C�
CD
CD
y.
00
0
V F
■
(D I- (D 1;
C! N C!
m
co
�W 1�
-bP,
ig
CD
O
CD
O
CD
O
CD
O
CD
O
CD
CD
CD
CD
CD
CD
00
CIL
00
CIL
00
CIL
V)
IQ
F--
uj
V)
II
uj
a
uj
I'd
I'd
CNI
w
v4
uj
V)
uj
lor
I I
lS
a_
X.
uj
ig
CD
0
CD
0
00
0
00
0
00
0
Ln
Ln
Ln
N
r-4
r-4
w
uj
M
m
-bFl
m
-bPl
V)
ZII
a-
uj
a
+
+
r-4
i -j
w
+
+
+
+
r-4
I'd
cl,
w
CD
CD
-
-
-
O
O
N
N
N
1w
I
I'd
!Z
CNI
CN,
Ln
Ln
Ln
E
w
Ln
Ln
Ln
In
N
r-4
r-4
r-4
r-4
r-4
TJ t6
CL
E
CD
CD
CD
CD
CD
C�
C�
J�
J�
J�
cn
V)
W
C,
Ln
Ln
Ln
uj
X
CD
CD
CD
00
00
00
c.
CD
CD
O
O
w
u
00
Ln
00
Ln
00
Ln
E
N
r-4
u
C.
uj
CD
CD
CD
CD
CD
O
O
O
O
O
CD
CD
V
CD
CD
CD
CD
CD
O
O
O
O
O
Ln
Ln
Ln
Ln
Ln
Ln
N
r-4
r-4
all
kl
CD
CD
CD
CD
CD
O
O
O
O
O
CD
CD
V) IQ
uj
V)
ZII
uj
a
uj
I'd
cl,
w
1w
I
I'd
!Z
CNI
CN,
E
w
0
CL
E
u
uj
V)
W
C,
uj
X
X.
uj
Cm CCC
00
CD CD
CD r-4 CD
cc� C� ld�
Di - Ln
N
cc�
Ln
■
CD
O
CD
O
CD
O
CD
O
CD
O
CD
O
CD
O
CD
00
CD
00
00
CD
C�
m
CIL
CD
C�
m
CIL
m
CIL
rl
lD
CD
m
m
uj
N
lD
Lf1
r-4
l0
l0
CD
m
't
CD
CD
rlj
rlj
O
-!
m
O
O
Lr1
Lr1
CD
LD
LD
LD
Cr
Ln
Z,
u
rl
00
00
uj
V)
U=
z
■
CD
O
CD
O
CD
O
CD
O
CD
O
CD
O
CD
O
CD
00
CD
00
00
CD
C�
m
CIL
CD
C�
m
CIL
m
CIL
rl
lD
CD
m
m
N
lD
Lf1
r-4
l0
l0
00
00
00
�
�
V)
IQ
uj
V)
z
uj
a-
u uj
ml
c
ml
II
461
gww
ml
dI
ml
>
V)
Mr
uj
a
-
x
M
M
uj
CS
■
O rmm
0
0
0
0
N M
Cb
O
O
O
t\ Ln
N M
Ln
LCL
O
.-I
N
7 N
N
CD
(7
CD
O r\
O
O
O
O
M
O
O
O
O rmm
O
O
OD
+
O O
O
O
O
O
Ln O
O
O
O
m
CD
CD
CD
CD
M 7
O
O
O
O
7 0)
O
O
O
LO fl
O
O
O
O O
O O
Ln
O
O
N
O
O
m
'-I
rl
Lamq Lq
o
0
0
0
CD ON
CD
0)
O
(7 '
OJ
L t\
M
uj
O O
O
O
O
O
O O
O
O
O
O
N O O O O
M Ob O O O O
7 N
N 0)
ti O
O Cb
t\
7
O O
O
O
O
O
O O
O
O
O
O
Ln O
O
O
O
Ln O
LC1 LC1
O
O
O
-
O
O
m Ln
Ln
CD
M O
O .ti
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 O
O
O
O
Ln O
LC1 LC1
O
O
O
-
O
O
M Ln
Ln
O
M
O .ti
Wali
Ln
Y
Wali
�A
uj
0
f':
MA
f�:
C1
III II.I.
a _
X.
0
M
M
0
uj
00
CT
M
Cb
m
N
0
t\
7
rl
Ln
N
M
rl
(71
LCL
O
CD
t\
N
Cb
t\
7
N
Cb
t\
7
O O
O O
Ln Ln
Ln Ln
7 7
N N
N N
Ln Ln
V) AS'+
�. CA
F--
uj
uj
a-
x.
uj 61
C�
C�
lS
S
fI.L..
M
N
0
V F
■
LCD t- CD CD CDq O� C� C� C�
N m r-4 Ln
I'l r-4 m 00
I'l I'l -
CD CD CD CD r-4
I'l lD 00
CD m CD CD CD
fl� W O O O
N LD
t- 00
Lr� Ln�
00 r1l
Ln
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
00
L'i
W61
V
II II
>
vrv^qM
110"
uj
z
cc
M.
uj
t
x
a -
0
M
M
0
X.
uj
W
ria
ri
fj
00
L'i
TA Mount Prospc
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: DIRECTOR OF FINANCE
DATE: SEPTEMBER 13, 2018
SUBJECT: MONTHLY FINANCIAL REPORT — AUGUST 2018
Attached hereto are the cash position and investment statements of the Village for the month ended August
31, 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 July 31 was $57.1 million. During
August, cash receipts totaled $10,310,702 and investment income was $82,859. Reductions in cash and
cash equivalents during August totaled $8,518,028. Of this amount, payments to vendors were $7,052,270
and employee payroll expenses were $1,465,758. Inflows resulting from interfund activity totaled $41,416
while other reductions to cash totaled $16,955. Cash and cash equivalents at August 31 were $59.0 million.
Investments in the Governmental and Enterprise Funds at July 31 were $6,189,531. During the month of
August, investment income totaled $5,218. 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 August 31 were $6,194,748.
Total cash and investments for Governmental and Enterprise Funds at July 31 were $63,280,652. Cash
and investments at August 31 totaled $65,185,862. This is an increase of $1,905,210 for the month.
Monthly Financial Report — August 2018
September 13, 2018
Page 2
Trust and Agency Funds - Cash and cash equivalents at July 31 was $3,595,806 million. During August,
cash receipts totaled $1,507,870. Investment income for the month was $135,036. There was also a net
decrease in cash due to investment activities of $40,715 while outflows due to Interfund activity totaled
$41,416. Reductions in cash and cash equivalents during August totaled $1,145,675. Of this amount,
payments to vendors were $285,369 and employee payroll and related expenses were $860,306. Other
disbursements totaled $1,577. Cash and cash equivalents at August 31 were $4,009,329.
Total investments at August 31 were $140,762,101, an increase of $2,060,411 from July 31. There were
investment gains of $2,019,696 and a net transfer from cash of $40,715 that accounted for the change.
Total cash and investments for Trust and Agency Funds at July 31 were $142,297,496. Cash and
investments at August 31 totaled $144,771,430. This is an increase of $2,473,934.
Summary of Cash Activity by Fund Type (page 51
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 follows.
General Fund — Cash and cash equivalents at July 31 totaled $16,820,048. During August, cash receipts
totaled $6,034,575, and investment income was $54,540. Significant cash receipts included the state and
home rule sales tax and income taxes.
Second installment receipts of property taxes related to the 2017 levy were received in August. A total
of $3,467,677 was received in the General Fund during the month. Receipts year-to-date are
$16,437,197 or 99% of the annual budget.
Sales tax revenues for the month totaled $2,160,237. Of this amount, $2,034,227 was generated from
the 1% state portion while $126,010 was generated from the .25% home rule portion. Sales taxes
received in August were for May sales as there is a three-month lag in getting this distribution from the
state.
Income tax revenues for the month totaled $340,629. Income taxes received in August were for July
Disbursements from the General Fund for August included payments to vendors of $1,464,228, payments
for employee wages and benefits of $1,286,094 and other disbursements of $10,180. There was also a net
decrease in cash from Interfund transfers totaling $725,713.
Cash and cash equivalents at August 31 were $19,422,947, an increase of $2,602,899 from July 31. In
addition, investments consisting of certificates of deposit totaling $2,473,703 bring total cash and
investments for the General Fund to $21,896,650.
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 August 31, there was a total of $6,194,748 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.
Monthly Financial Report — August 2018
September 13, 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 August 31, there was a total
of $140,762,101 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
Director of Finance
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended August 31, 2018
GOVERNMENTAL AND ENTERPRISE FUNDS
Balance at July 31, 2018
Cash receipts
Investment income
Transfers from investments to cash
Transfers to investments from cash
Interfund activity
Disbursements:
Accounts payable
Payroll
Other
Balance at August 31, 2018
Cash and Cash
Total Cash and
Equivalents
Investments Investments
$ 57,091,121.82
$ 6,189,530.50 $ 63,280,652.32
10,310,701.67
10,310,701.67
82,858.60
5,217.86 88,076.46
41,415.80
41,415.80
(7,052,270.06)
(7,052,270.06)
(1,465,758.41)
(1,465,758.41)
(16,955.31)
(16,955.31)
$ 58,991,114.11 $ 6,194,748.36 $ 65,185,862.47
TRUST AND AGENCY FUNDS *
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at August 31, 2018
(285,369.40)
(841,519.65)
(18,785.74)
(1,576.54)
(285,369.40)
(841,519.65)
(18,785.74)
(1,576.54)
$ 4,009,329.16 $ 140,762,101.31 $ 144,771,430.47
* Assets are restricted in purpose and do not represent discretionary assets of the government.
4
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at July 31, 2018
$ 3,595,805.71
$ 138,701,689.91
$ 142,297,495.62
Cash receipts
1,507,869.53
1,507,869.53
Investment income (loss)
135,036.35
2,019,696.10
2,154,732.45
Transfers from investments to cash
1,965,129.16
(1,965,129.16)
-
Transfers to investments from cash
(2,005,844.46)
2,005,844.46
-
Interfund activity
(41,415.80)
(41,415.80)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at August 31, 2018
(285,369.40)
(841,519.65)
(18,785.74)
(1,576.54)
(285,369.40)
(841,519.65)
(18,785.74)
(1,576.54)
$ 4,009,329.16 $ 140,762,101.31 $ 144,771,430.47
* Assets are restricted in purpose and do not represent discretionary assets of the government.
4
L)
W
a.
0U)
w
a.
z
:3
0
2
LL
0
w
M.
MO V) a&G;Foo r -
U) C14 0) It 0 M pl-
P, — V0 a S 0
-j C-4 �- 0 01) rl_ m �q
q. Lq Oci -F� N ED v
0 00
(D r� 00 Lo 00cd
(DV)0 Cl �-: M 0 cs
IQm N 0s 0 Cl) m 0
I-- C6
> co
NU
00 0 P -
:D C) (D o c6 Lo ob Lo
61r, Ln
VO X Z cn �2 v — Lr) 1� 00 0 r1l
z F- LLJ C C6 co a LQ ll-� 9 G�
=) of 0 Z Go
LL LU < =) v
o LL
Q z 0 <
LU
(D
< co Lo 00 (D Ln
C M (D Lr) — It OD (D 04 (c
Qa Lu Z 0) N C/) oo q -i aCA ) Lo
< z (0
F- < () 9 (Q - q '-� 'ztL
(n LU -i (nr-
:) w 0 z 0 C') V (D 0 'N
of [L- a- LU n 113i 0�. 0 00
F- (N �S C14
C9 I® 0 CD
w 0 0 , , m m �t 0
Rto OD' U), 00, 0
0 n- Lo Lo C� 10 P -
N
oc� V,�
F -
LO CN
LU Z
®mom
z D
LL
LU 1- 11-1 OD
0 7 F- 0 z
<
O ii C%
-1 00) '('4' manta
<
Z D r- Lo 0 0
12 C) ED
Z
c Cl N
c
it U- 2 r- ON N M (q
LU LU 0 C-4 (D 0 I;t a)
C) (D co
F- L) -4- C04 0) N> 00 co
LL]
V)
w
4A v
M N W
Lo V- 0)
'r07
Lo
r- C-4 of
U) U) I Ol cq
co
1- r 00
co
ED
to
4,00
L6 B L6 Ed
O. IR
0
04 co
fll�
m co
N
W (D—O(D r- 0 R It 1* U� E Lo
00
(o r-
r�
Cl)(6 6 V) co
U) 00 N Cl) C 4
C,�
C,
N C4,
w0
z Cos m
Lo
w D
F- LL
Z
W
64
-1 14 1)
U)
z ofcd
o :D
cc
L) w LL
Lr)
C -i
Ucy)
00
MS l�o:
C)
co
CCN
a(O
I®
W vi
Z
00oc
Cl
U) =)
LL c! Lo
N"T
co
W
49
U) to
-j W OD co -
cc
m
< ::) (n M
cr�
00
t000
U) z 0 -
W W Z 0) 00 4 06
L6
Ld
00
m
m
UJ LL
In
Lo N 0
Z M CO CN OD -14-
0
m
co
C-4
Go LC) CD co 0 Cl) co
r-
C6
m ci
LL
8 1'- m ;z T 0 N
-i Ill LA Ct N
A
0
r-�
a (Co
F-6
-
< ®M (D 8
cli
N
cr)
Cl) CD
w 00
LLI co
cli
14i
0)
V ao
z
04
w
49
ca
z
W
LU a)
Z
0
z
2
F-
LLJ
(D
>
CY)
LuE mw
(00
' 42 q
Q.
> >
.0 CL 0
E E E
w 0
aE)
p e 12U)
m
ca m w
LL
>
U) .6, C. D o) LA
w
> ch tf 75
q
m 0
w
3 =) U
C,
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of August 31, 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,241,283.10
12/13/19 12/28/17
Federal Home Loan Bank
Agency Notes
3130AOJR2
2.375%
1,232,420.09
2,473,703.19
VEHICLE REPLACEMENT FUND (061)
05/30/19 12/28/17
Freddie Mac
Agency Notes
3137EADGI
1.750%
1,243,923.75
06/12/20 12/28/17
Federal Home Loan Bank
Agency Notes
313383MB4
1.875%
1,233,455.00
12/11/20 12/28/17
Federal Home Loan Bank
Agency Notes
3130A3UQ5
1.875%
1,223,603.75
3,700,982.50
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,194,748.36
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.
L
8-10810
Various
Various
Interest Market
Rate % Value
Various $ 23,198,317.58
Various 50,346,145.83
73,544,463.41
Variable 5,978,683.22
Various 22,376,424.01
Various 38,862,530.67
67,217,637.90
$ 140,762,101.31