HomeMy WebLinkAbout5.1 Monthly Financial Report- January 20182/20/2018
Agenda Item Details
Meeting
Category
Subject
Type
Preferred Date
Absolute Date
Fiscal Impact
Budgeted
Recommended Action
BoardDocs® Pro
Feb 20, 2018 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m.
5. CONSENT AGENDA
5.1 Monthly Financial Report - January 2018
Action (Consent)
Feb 20, 2018
Feb 20, 2018
No
No
Accept the monthly financial report for January 2018.
Information
The monthly financial report contains a Cash Position Report and Fund Financials for the month ended January 31, 2018.
Alternatives
1. Accept the monthly financial report for January 2018.
2. Action at discretion of Village Board.
Staff Recommendation
Staff recommends the Village Board accept the monthly financial report for January 31, 2018.
01 January Board Reports for Upload .pdf (329 KB) Combined Financials for BD 1-18.pdf (756 KB)
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.
https://www.boarddocs.com/il/vomp/Board.nsf/Public# 1/1
w
�
N
M
h
MSI
�
w
�
w
mw
A
O O O� 10 m M O � 7 O 7 O
N 01 v- 01 lo .--I '-I co
rl Ln al
Ui O cD ko O cD M N
N N M M N 01 tO N
0\ O .--I CO M
N
+
+
N M O LM M O 01 to O
Lq N O 0? I� W Il� n N O
.M -i Lm O .�-I I� O U
W W
1`1 In N m n N n Oi
LQ i0 M � W O O
.-I N
I� O O N 1=1
N N � O
7
7 01 - M l
W 1 O 10
Il n N M M 01
01 N -T to n
O In �
O O O O O O O O O O
7 Il O O N N N N Ln � O
7 01 W � M ol � � O � .
I, n In M M 01 N .--i .--I
O N T m
01 111 v -
O O Cl Cl O Cl Cl O O O
O O O O O O O O O O
O O O Cl O Cl O O O
O O O l0 O O O O O
C O C W C O C 01 Lr
O O Il M In n In W
7 O O M OlA
Lr N 7 O M 7 NN
N
�O c0 .-1 7 .-1
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 i0 O O O O O
O O O Dl C O O O to
O O 1l M ul n ul W .--i
.--I .-I co O M O .ti ul
Lr N 7 W M V- N N N
lO of ti v- .--i
N
W> V
lIA li
i
,F
VF
fx, II II III. 1} 2 lll wnm,,,:
V C`h?dE 7f✓ III..
W '71 X L:S1 IT,
C3ps y -i Y1k i.,ll �I� IY a1,Y !'.;Il P hl +11
¢::) II +"..1 0
N
O
N
O
O
N
ClO
C.
ID
O
7
M
,A-
Cl
Pr
O
Cl
fiT
O O
O O
N N
co Yb
10 ID
10 ID
M M
U7 111
fPr {A
J
Q
F
W n,
� I
Z
W
W
SID
�B
ci
ro"VA,
m
OCD C) cm) Cl C3
a CR 0 00
C. CD
O
C)
+
+
C. ?W
CD
Cl
C�
C�
C.
C� in
�2
CD
C�
C) 0
CD
CD
CD
CD
q q
q
C?
e4m
, z
c,w LU
>ce
C3 LU
C) 00
C>
C>
a,
E
VI
:3
llt:;
U W
C) 0
c) -
cl In
Lm
ID
c�
c� "
CO
O
O
O
oo
O c
Cl
(D
C.
Cl
CD CD C) C) C, C3
C� C� C� C� C� C�
cDoac—Dc�
O O q O O O
C. CD
O O
Cl
O
Cl
O
CD
O
Cl
C. ?W
CD
Cl
C�
C�
C.
C� in
�2
CD
C�
C. N
OD
C)
c�
00 —
co
e4m
, z
c,w LU
>ce
C3 LU
N —
-
>
0
�,j
In
a,
E
VI
:3
llt:;
U W
C) 0
C! IR
IR
O
O
O
CD c
O
C)
C)
CD
C)
q
q
q
C�
C�
CD m
C)
C)
CD -
R Lr�
m
C)
c�
O fli
co
e4m
, z
c,w LU
>ce
C3 LU
co -
Ili c�
-
>
0
�,j
In
a,
E
VI
:3
llt:;
U W
C) 0
J
Cl
X1
r1i
e4m
, z
c,w LU
>ce
C3 LU
0,
W
o
>
0
�,j
In
a,
E
VI
:3
llt:;
U W
C) 0
J
Cl
X1
r1i
r7ol"MA,
III
9-
R
O
O
ro
O
rl
111
t0
l0
110
� 1111111
W mm
� VIII
0
0
ro
m
0 0 0 0 0
O O + + O + O +
0 0 0 0 0 0 0 0
C) o 0
O � N O
l3 -1-
M
'-I H
O O O O O O O O
coco
O O O O O O O O
OOOOOOO O
O
N
O O Cl Cl O Cl Cl O
O O O O O O O O
O O O Cl
O O O O
C O C C
O O N O
W In M
Ilkc
O O O O O O O O
C:, t
1
O
O <
O <
co
O
u'i 1
fPr '
O 1
O 1
O 1
O t
O t
N 1
� t
� t
M 1
tPr '
O
O
O
H+ '
O
O
O
O
O
O
O
O
O O
O
O
O
O
O O
O
O
O
O
O
C
O
O
O O
O O
O
O
N
O
N N
07
1
M
10 l0
+Pr K}
W
� I
Z
LU u
W
Ilq�
WAY
�M
V
W�
�
ro
OIL
�F
M
F"M
IIF
c,w Lu >
LUC3
'.I
m Tu
u u.,
KI
".1
x
en Mr`
rXk
C
�AJ
'. u
>
y,
ti
tillk
, g
eYS
Y_:
a l':;.
Y}
ti
till
rIk
r
r..:
rI
rl..
'62
a
�,II
0
3
:1
Ln
III^,,:..
t..
vYl
p
IN
u
SII
F
ro"VA,
m
C)CD C) cm) E� C3
a 0 0Lo CR
16
C. +
r'd
C)
C)
+
C.
CD
Cl
CD
C.
C
CD
C
CD
C�
CD
C�
00
Ln
10
CD
cl
00
N
cli
C?
cli
C)
C)
C>
Cl
C)
C)
r1i
Lr�
Cl
c�
CD
c�
O
G6
-T
lo
Ooo
n
10
Cl
a,
a,
42;
J
Cl
CD CD C) CD C, C3
C� C� C� C� C� C�
cDoac—Dc�
O O O O O O
C. CD
O q
Cl
O
Cl
O
CD
O
Cl
C.
CD
Cl
CD
C.
C
CD
C
CD
C�
CD
C�
00
Ln
10
CD
cl
00
N
cli
CD
cli
cl
C)
C.
R
C! IR
O
O
O
O
Lr)
CD
c
CD
C)
CD
C)
CD
CD
qc�c�qc�c�qq
cl
C)
CD
cl
cl
C)
C.
R
C)
C
CD
C�
cl
C
cl
R
C)
C�
co
n
10
Cl
a,
a,
co
N
N
(n
M
rl)
m
en
+a5
<
LU
� 1111111
LU
LU
LU
Ab
I
mm
3
1
U
>
VI
Yl.
:3
YIA
K5
LU
u
zKYlk
v
1X
LU
lu
>
C3Cr
E
c
C:
'b
>
V
Lr)
ro"VA,
m
I
�D fli ol cm) Cl C3
C� 09 IQ O� ,� C�
ti m N a, C3
cl� lc�
+ r,
O
In
C)
CD
CD
CD
Cl
CD
Cl
CD
C�
CD
C
CD
C�
CD
C
Cl
C�
c) lo
'D
Lm
cD
cD
r,
Wuul
Lm
w
cD
cD
Lm
Lm
O O
O
O
O
O
cc�
M
Cl Lm C. 1=1
O Mr*� � O O
-
rl a, C�
ID -T
r,
r1l
CD CD CD C) C, C3
O O O O O O
cl v- m Ln c� cD
O M r*� V'1 O O
ol
Ln -
Ln nc� v-
c� rl� r*l
lo T
r,
N
C. CD
O O
Cl
O
Cl
O
CD
O
CD
q
CD
CD
Cl
CD
Cl
CD
C�
CD
C
CD
C�
CD
C
Cl
C�
Ln
'D
-;r
C,
C
C3
C�
r,
Wuul
O O
O
O
O
O
CD c
C)
C)
CD
C)
C� q
C�
q
C�
C�
CD
C)
C)
C,
C3
CD
C�
C)
C�
CD
C�
C,
C
C3
C�
Wuul
Ci
Cl
00
J
10
Go
Go
C�
00ti
X1
X-1
Wuul
5
i'l
Lu
'WI
VdD
u
jjc�
11
jjc,,1
0
h >
LU
E
>
LU
V
C3 lz
Or
tillC>k
c
0Ww
G;
c
C :
V
Ci
Cl
00
J
10
Go
Go
C�
00ti
X1
X-1
m
O CD CDcm)
CR 0
c:l
00
rlj
-V�
CD CD
O O
C)
O
CD
O
C,
O
CD
O
c:l
CD
jjg�
:3
O N
O
O
0
(D
O
rl
M
rl m
rml
O
c q CD :) c� c�
�D cm) c)
ID CD c)
cy,
Ivi
O O
cl C)
cl C)In V1
rl-
II
x
jjg�
:3
I.>
11
Cie
IF
C:: Q
LU
>
>
o
ce
LU
1:3
v
cc
O O
cl C)
cl C)In V1
rl-
m
O
q
c�
c�
c�
O
ID
K-]
ro"VA,
A,
m
I
yl�
C)
C3
r
�o
ro"VA,
A,
m
I
CD
c
CD
C)
C�
C�
C�
C�
O
CD
C)
CD
CD
CD
CD
CD
(n
rfi
LU
LU
LU
of
Mm
SII
C3
Lu
z
LU
>
C3 LU
c
jj��
ro"VA,
A,
m
I
C. CD
O O
C. CD
C. CD
CLO
LO
N
C) 0
O O
yl�
ro"VA,
A,
m
I
C)CD
C)
cm)
Cl
C3
a
CR
0
00
C3
C�
q q
ip,
{F}
cDmaOmal
cl C3
C.
R
C. Ln
+
+
cl C3
CC�
C)
+
+
C:,
0
Ol
CD
C)
C)-
CD
CD
H}
-61)-
o r**:
q
o
10
10
10
C) a,
Ccc
ON
cl
a,
cl�
C)
lior
ol
ol
'Al
ol
I*
C) m
Cl
(D
(71
m
C! N
C!
O
r�
0
C.
O
+Pr
HT
CD CD
C� C�
C)
C�
CD
C�
C,
C�
C3
C�
CD C)
C�
Cl
C3
C�
q q
ip,
{F}
cDmaOmal
cl C3
C.
R
CD
C�
O
cl C3
CC�
C)
0
Ol
CD
C)
Ol a,
H}
-61)-
CD
c
CD
C)
CD C)
C�
q
C�
C�
q q
cl
CD
cl C3
C.
R
CD
C�
cl C3
CC�
C)
Ol
Ol a,
<
lior
LU
LU
>
LU m
II
K3
1101
LuY7
c:::
U
>
N
vsG
>LU
C3 LU
C
0
ro"VA,
m
C) CD CD cm)
C� q CR 0
C:)
C:)
+
q
C) 0 q q CD qCD
C) 0 CD
C) 0 CD
C� C� C�
C) 0 m
C,
CR
C,
C,
D C
C
C
C
C
CD
C)
C
0
C�
C�
q
q
CD0
a
O
O
CD
0 0q
0
0
0
C,
C�
C3
C�
C)
m
r -i
CD
O
c
CD
C)
CD
C)
C�
C�
C�
q
q
C,
CD
C)
C,
C3
C.
R
CD
C�
C)
C�
C,
C�
C3
C�
C)
CD
m
m
r)
lior
LU
LU MF
LU II
qhs
qhs
00
ivww
3
C3
>
5U
uj
co ::)
v
:
f:
C::
Z
K
r5
YI
c,w > Lu
LU
KI
>
C3
m
r -i
ro"VA,
m
C) CD CD
C) CD C)
tsr
CD CD
C� C�
C)
C�
CD
C�
C,
C�
C)
O
Cl
C�
q
q
qCD
CD rl,
a
r,
rl,
fli
cn
m
cl�
C)
C
111 ol
rl)
ol
ol
O
c
CD
C)
C�
q
q
qCD
M
C)
fli
cn
m
cl�
C)
C
rl)
C)
rl)
m
C)
ll
m
oz
OZ
4A-
+Al
Ln
-j
<
uj
uj
1w
!2
1w
Ipp
1w
SII
C
Lu
X
a7
>
Lu
C3 lz
0
c
>
0
I
mw
m
O O m 10 O O O
O O O M O O O
�
p In 10 10
W 7 u 7 W
N N lD U'n
n
O
+i r, 'o v+ — O
+ N +
+ +
0 0- oq-q o
llo N lOA Lm lo W O
.^ lo -i W N .--i r, O
M O
M V'1
rl
O O O .--i W O W O
n 1 Cl
N M 1/1 Cl T
IV 1� n M
N
O
O O O O O O O O
O O O -! W O 1X1 O
N M 111 7 .
O
.ti
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 O O
CD O N O O O
N 7 OCD CD
M OJ O
7 to
O O O O O 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 .--i C O
O T O 10 O O
N M co O
7 m
.ti
0
C
8V
�F
�D
qAF
IAF
� n
co i
W t
O
to
cq f
1
N 1
rl
L 1
O �
ts�
O O
O O
O O
M M
O O
lc O
01
!Pr ifl
Q
W
I
LUZ
W
� AnM
qF
i'
Pen
�P
b
I
M"9
K3
a
ILS...
Ln
-q
LL,
FFA
W
Y.:,! !1°
ill
tl
112
iY
unw7`
iXk
ytXJ
u
II
�'�]
Y1
G
A
II.I...
r?�k
Y...
I
C
11
till:
i
YI1
IkX
0
22
f
i17
ce
s
i
I VL
�:T A
WWx
I'oe III.,,
i',II +Yl
0
� n
co i
W t
O
to
cq f
1
N 1
rl
L 1
O �
ts�
O O
O O
O O
M M
O O
lc O
01
!Pr ifl
Q
W
I
LUZ
W
� AnM
qF
i'
Pen
�P
b
I
M"9
K3
a
ILS...
Ln
-q
m
C)
Cl
C3
Cl
09
o
�
Go
00
-
Go
Go
C
N
M
M
�
�
O
V}
'Al
+
n
+
W
O N
00
Lm
O
V1
lA
.--i
W
10
N
10
t0
-1
01
�
LM
W
Ln
of
10
N
Oi
Oi
n
H
n
n
r
ld-
O I�
Ll�
O
V:
q:
M
1-
W
�
�
n
n
n
Gq
fH
4Pr I
O O
O
O
O
O
O
M
O
Cl
Y1
EA
41}
Wn„N
O Il
qtu
V'1
O
I,,.J
7
M
V-
W
V-
7
n
n
n
11.11=
y}
{q
O O
Cl
Cl
O
Cl
Cl
O O
O
O
O
O
O
O
O
Cl
Cl
Cl
O
l0
O
C
O
O
Cl
l0
Cl
t0
M
Ji
M
En
Il
n
O O
O
O
O
O
O
O
O
HT
Hf
O O
O
O
O
O
O
O
O
O
O
O
O
l0
O
O
O
O
O
i0
O
t0
O
N
O
-I
T
r
H}
rl
+R
ED
ci
N
J
F u
W
W
Ji
N
4�
CD
�
O
Gq
M
Y1
Wn„N
qtu
I,,.J
YYX
k
11.11=
4
✓;1„4'�
�
C'..
Ji
En
ED
ci
m
ao
o
Cl
0
a o
0
0�
o
Q
F t,)
m
N
N
N
W N,l
� 1111111
Z
+ +W
+
LU
>
In
Ln
0 0
co
o
o
In
o
M
oo
oo
m
oo
II I
N
Co c
O ON
O
CO
O
O
O
T
�F
t0
.--I
.--Y
O
N
N�WO
M
.--I
T
M
v -
M
M
M
M
4Pr
W
NN4
„I
O O
O
O
O
O
O
O
N�9
c
I7
Cl
O
SGV
y>,
",
ld}
Cl 0
ON
O O
O
c0
O
O
O
c
m
.T
.--Y
VI!
O
M
^;
7
-Ir
M
YIA'
M
a a
ylrY
10'
M
M
-I
r
JrF
f'p%
u
tJ
r
O O
Cl
Cl
O
Cl
Cl
O
O O
O
O
O
O
O
O
O
Cl
O
Cl
Cl
I}
O
O
O
In
O
C
IIS
Cl
In
O
In
, a
lo
III..
C3
n
n
Ln
JYY
Lo
!Pr
.moi
V}
"1
°IT'w
a`r
a
(;:'
0
O O
O
O
O
O
O
O
O
O
Hf
H+
Cl
O O
O
O
O
O
O
O
O
O
O
O
O
O
O
M
O
O
O
ltl
O
L/1
K}
K}
UI 0
Q
F t,)
W N,l
� 1111111
Z
LU
>
LU NR
II I
�F
N�WO
NN4
„I
V;I1'
N�9
c
I7
VI
SGV
y>,
rrY
II,C
VI!
^;
RN,,,
YIA'
a a
ylrY
10'
W
JrF
f'p%
u
tJ
,
II n"
K
Y
II IIY]
,w W
I
r.
I}
f..
>
LU
IIS
Y
'X
"I}
Y ."
, a
c
xl}
III..
C3
JYY
IIID
"1
°IT'w
a`r
a
(;:'
0
ro"VA,
m
I
V- CD Cl
09 CR
10 V:
� I R
cl cm) C)
C� C� C�
TA1
00
r -i
mw
A
N O M O Cl O
M O O O O
W Ln O
O O N
n ti Oi
03 O
In
+
+
O
O O
O
+
+
Cl
O O
M O
O
C
+
+
Cl
O
+--i O
Il
O
O
N
O O
M
O
O
O
uY O
ol
O
M
W
N O
O O
O
O
O
01
CI
rl co
rl
.--I
co
V-
n
'-I
rl
111
-T
V-
O O Iq O O O
N W O
7 N
M
rl
O O O O O O
0� O O O O O�
N 00 C)
7 N
O O
O O
Cl
O
Cl
O
O
O
Cl
O
O O
O
O
O
Cl
O O
M O
O
C
Cl
O
W
O
In
O
N
10
O
O
O
M
O
O
O O
O
O
O
O
O
7
7
M
O
Ir
C,
01
loM
ff}
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
M
O
O
O
C
O
O
O
M
O
M
.--I
co
O
111
-T
n
0
(n
M
K}
K}
(!1
¢Sy
Q
F S1
W N,I
� 1111111
Z
W
,III
LU
�R
4F
P6N
IIIII;V
�",w,
�R
I�
WMD
u
q
no
I
.l,.M
2
"Yf
W
of
-'3 d'
VIJ,
till
J'.:
trY
5
.F""
LYY
'w
f:}
J"�;4
ro"VA,
m
m CD C) a, a,
O N CR N N
C
C, N CD
r1l
00 Ln +
+ 00
a, 0
qCD
LM Il r-4 "
C. rQ m m
C lq� lq�
00 - a, of
00 co 00
IA- v.
. --i0 Cl - -
,I: UR O q q
a, rl 'D 10
tsr +n
CD CD C) CD C,
C� C� C� C� C�
O Cl
ip,
ti r1l
al
C� n'D 10 -t -t
rl
C. CD Cl Cl CD
C? C? C? q O
r� CD rl rl
C
CD a, m
C� Lr Lr� Lr�
LO ko 10
C. Cl CD
N r-4
{A iPr
O O O O O
O C.
CD c CD q CD Cl
C� C� C� C�
Il cm) rl r1l
a, CD a, ol
L'i In
10 10
ON cm) r4 rljCl
of Hl
to A
-j F
<
110
AF
uj
uj
c
u
GA
L3
GIIA
41
A
V
Lu
R�
CER LU
lill
u �
C:
CE, LU
>
E
C3 LU
Cb,
ro"VA,
m
co fli C) cm)
N CR N
ol CD
10 10
,T
03 O C, CA
Cl
C�
In
CD CD C) C)
O O O O
Il 10 a m
cq —! q m
r1l rli cc�
-q� ol
m
10
m
10
P
A�
I
au
IPI
Vel
:p
Ilry
LUx
ce
>
LU
Cb,
C3 01:
0.
t
C
V
ac
A�
I
ro"VA,
m
O
ol
-V�
TV
ro"VA,
!Pr
m
o
W
r,
Lr)
v:
cq
®
LQ
Lo
01
Ici
rIj
cc�
rl)
!Pr
m
o
W
0
U�1
Qt C
CJ5 �
TS
m ~
�Ql �
.a rn
n -a
O �
d O
V1 O M O � O In O O W l0 O O O
7 I* O% M0%
O% t0 N N I: O O N OJ O O O
M 17 7 W O � 7 t0 7 m cl
V] I� m .-i W M 00 .M -I O O O .^-I + .-i O
+
m tirn .-I 0 0 o w w o 0 0
o? o r, : rn % O o v, In O O o
ti V 00 In N N Ln O l0 W m 01 O O
10 Ol 10 co 7 O
In N - O
W M rl V V OZ 07 ll O O
m l!i ti 10 M lri N M .m 7 O? M Cl
7 mIn M M 10 IO0 N W n
N M
W T W ONi O V N O O Lq Oo1 O O O
O Ol In 'r Cl M to l0 t0
N W L00 co r N l^n n �--!
vi co co V V
O� T 7 co M M
O O O O N O O O O O O oo O O O
o O O O l0 O o T o O o V o O O
V N N O
ti t\ Lr O
In T
�o tIn
N m M
n
tOm N m O O1 O O N i0 O O O
W W0� O 7 N O O In O O O O
W
oo n �
oo ti
N ocIn N In n 7
Vi co i0 l0 oo 7 I�
O� o V oo M M
O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O
I� V 01 O lD lfl u1 l0 07 l0 O O O
M M M In r to N to N N M O O
O N lA O1 N O lD 7 07 I� In O O
Vi r oo t0 Oi 7 Il v. M m 7 M co Cl
O m lD V M M In oo .--I Ln to m lA
Oi 7 In i0 M 7 N t0 N co Il
o V oo
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
0 0 0 0 0 0 0 0 0 0 (a 0 0 0 0
O O O O O O O O O O O O O O O
n v O, o �o to vi �o of io 0 0 0
M M M In
O N N
rl to N to N n M O O
In 01 O l0 V � n Ln O O
O T l0 V M MW .--I Ln T In
Oi M 7 N n loN N co N
N V OJ
N .--I
ri
,
IY
iCF
r*^2
c�
fWJ
..WJ
MM1
lw
�
Mf
KII)
V_!
rIA r1X
YIT
�d
'2L +41
hI
VY
%�r
rLl r,
t,
y ul
Yy
"t(U
01" -
X71
JI%
YI)
y
%
'M W
VI
rM7%. II P
an
':�
k
Cb
U
Y Nb
II II
Y Y
X
;'�
f1
fis
CII Wt%
'S
Y
V) W
b
f'�,.
Y7%
II 111 0
YYI$
J�
M "�'«
f )
M'")
Ym C)
f,.'A
6
ri
a
E
-0
E
+ +
+ +
0
C>
M
+
+
+
+
C=�
0
0
C?
F,
(V
div
0 0 Cl C> Cl C> 0
C� C� C� C� CO
� C� C�
0 O O O O O O
O O O O O O O
0 0
0
0
0
0
0
C=�
F,
(V
div
0 0
0
0
0
0
0
C:�
F,
RIIII
(V
div
ul
jjII I
x
LU
l�
NJ
T3
C:
NI
SNI 40}
0
o
m
m
m
C!
Ci
r1i
0
�Ql �
.a rn
0 o O ti O o 0 0
0 0 0 0 0 0 0 0
1 o r
in o
M tD
�O O
+ O .--I + + M O +
+ + + +
O O O N O O of O O
O O O M O O O O O
O O M llc O
M O O,
N 7 7
O O Cl O Cl O 01 O O
O
O O O CO O O O O O
O o O l0 O o O o O
O IO
n �
O O O O O O O O
O
O
0 0 0 0 0 0 0 0 0
'
O O O N O
Cl W N
N 7 7
O O O O O O O O O
0
0
0
H}
0
V
co
O
a,
N
4A
0
V
N
O
4A
7
M
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
M
O
O
O
O
O
7
N
O
O
rl n
N N
co
V} {FT
d
W C
� W
Z IIM.
W Ilm
X �p
�M.
�m
i1!
w
f
004
Y
�NY
rIV
f
al
..
Clr
d:y
i
a
"Y�
1116.E
Y
FHL
II.N
II III
0
1
1A
M
e
rT3
5
3
nn
o
o
M
a
E
-0
E
C
0
u
Ln
"I
1*
0
0
0
0
0
0
0
C:�
C:�
C:�
C:�
:3
3
�N
ISN
IN
ul
al
0
04
W
1*
0
�Ql N
.a rn
Q
0 0 0 o O O
0 0 0 0 0 o
rn
N
O O
O
O
+
O
M
m N
0
0
O
+
O
O
N l!711
Cl
M
O
O
7 N
m
lti
o
M
N
Q1
0 0
0
0
0
0
0
N
O
O
O
00
O
N
O
O
O
O
O
7 N
ti
lli
lti
N
O
O
lD
OOOOOOO
O O
0 0
O
0
O
o
O
O
O
O
O
O
m N
0
0
O
O
O
N l!711
Cl
M
O
O
7 N
m
lti
o
M
N
Q1
N
o
Ln
in �n
T a
O
O7
O O
O
O
O
O
O
O O
O
O
O
O
O
m N
0
0
O
O
O
N l!711
Cl
M
O
to
7 N
m
lti
o
M
N
O
N
o
Ln
in �n
T a
O
O7
Vl
V'i
N
O
O� T
O O
O
O
O
O
O
rn rn
rn rn
0
N
0 0
00 00
co 00
O O
CD
O
O
O
OD
NT
co
{A
O
O
co
!T
W
tFr
O
in
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
00 co
m
N
vi
In
o
M
0
M
0
O
o
Ln
in �n
T a
7
N
Vl
V'i
N
O
O� T
ti
O
W
lA
O 07
tH fPr
W C
� W
Z IIM.
dl ��
W
µ.a
cz
aur
..ias
�u
OR
al
II..
NdijuY
11v
CD
Y M
fY
�
WA
i%1
M
!
'M d
i
f*)
III
II,Y
x
c:�
Yry
aM Lu
in
0
�Ql N
.a rn
n -a
O �
d fg
O
u
U
C
u
Q
W 7 .moi 7 0
N O n N V
N n co N
Vim] m
M
OD
m
N
O
w M
N
N
V
V
O co
N
N
^
V
M
7 O l^O M N 1l O
tiOl W N ti N
M 11i T m N
16 0 n N
.ti tp
O O O O O O O
O O O O O O O
O)
,I-
0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
of v �o v ri ri o 0
O� t0 N 1� n n t0 n n
Q1 W M O V l0 n
O O ri 00 t0 O O O]
W N V V V
CO M M
c+i V 7
V} EPr
O I
W
N W
Z IIM.
dl XGM
W &�
pX�
Ilam
n O
�A
R3��� +P�) II
II�N..WJ
Mil Y..
5,
ell
rM) .,...
W
InN
IYM" v rNA YflX ni +i?i
ul v Iii" : w
CU
��'Y W rl r�„ IrIP i rNJ a,a
X r1 my rrF�
Mr IIFII,I 0 fr Y ) l
LO
M In
V
N
O co
N
O O
O
O
O
O
O
m O
N
n
n
n
M0
O� 00
tiO
O
V
t0
I�
D
W
N
ID
V
N
W
M
O O
O
O
O
O
O
O)
,I-
0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
of v �o v ri ri o 0
O� t0 N 1� n n t0 n n
Q1 W M O V l0 n
O O ri 00 t0 O O O]
W N V V V
CO M M
c+i V 7
V} EPr
O I
W
N W
Z IIM.
dl XGM
W &�
pX�
Ilam
n O
�A
R3��� +P�) II
II�N..WJ
Mil Y..
5,
ell
rM) .,...
W
InN
IYM" v rNA YflX ni +i?i
ul v Iii" : w
CU
��'Y W rl r�„ IrIP i rNJ a,a
X r1 my rrF�
Mr IIFII,I 0 fr Y ) l
LO
E
-0
E
0 0 m C> Cl
C� C�O
C� C�
V)
'A
O O O O O
C:� C:�
V1 l0 In O
13
O
O
IRO
Ool
ID
CD
a)
+
cc�
C�
N
E
-0
E
0 0 m C> Cl
C� C�O
C� C�
V)
'A
O O O O O
C:� C:�
V1 l0 In O
13
ul
a,
x
U
::D
(p
an
r-
�Ql �
.a rn
CL '6
O �
� rg
d
o L� o rn o 0 0 0 0
n � M
N O
+ + O O O + + + +
+ + + + + +
+ + + + + +
0 0 0ol
0 0 0 0 0
ti 10
ti 10
v
0 0 Cl v Cl 0 0 0 0
ti
0 o O o O o 0 0 0
0 0 0 0 0 0 0 0 0
O O O O O O O O
O O O O O O O O O
O lA
M
7
O O O O O O O O O
0 o O o O O O o 0
0 0 0 0 0 0 0 0 0
V N O
N o In
ti ri
M
W
H}
0
O
OD
C6
Lq
co
w
O
W
M
tPr
O
4A
Q
E
-0
E
0 0
0
0
0
0
i ilii ii
�fl�Y
rr1
0 0
C,
Ol
ol
m
CZ Loill:�
v�
Lr�
: 13
lim
O O
O
10
W
W
W
0 0
0
0
0
0
V7
O
O
V
O O O O
C:� Lri V C:�
I
0)
i ilii ii
�fl�Y
rr1
o6 T
I
: 13
lim
llII,
W
10
�S
I
0)
0
0 0
0
0
0
O O
CZ
C�
C� C=�
0
C,
C>
C,
CZ
C�
C�
C�
VT EH
0 0
0
0
0
O
O
O
O O
0 0
0
0
0
O O
CZ
C�
C� C=�
O
O
O
O O
CZ
C�
C� C=�
VT EH
O
O
O
O O
C�
C:�
C:� C:�
0
U)
J3
lIJ
X
AMM
J3
3
17
3
qI ul
x
LU
m
13
C::
0
0
0
0
+
+
+
ii,n ul
0
Z
0
cz
C)
C�
lim
LXUrOF
Pv tNt
.0
PM
C,
C�
0
C�
Cl
V�
C=>
C�
'd
O
O
O
Ou
E
LU
0
2 t
4
u
N
q
q
O
C?
0
0
Cl
E
<
CZ
C�
C=�
E
-0
O
O
C?
E
5
0
O
O
O
O
m
13
C::
:3
ii,n ul
Z
til
lim
LXUrOF
Pv tNt
IIIr r 5 f„) 6
E
-0
E
owClC>CImw
C� Iq
C�
CO�
O
O
O
O
0
co
co
O
C:�
0
C>
CD
C:�
in
L'i
VT
M
0 0
0
0
0
C:?
0
0
CZ
C,
CC> �
CC,
�
E
-0
E
owClC>CImw
C� Iq
C�
C�
C�
Lq
kq
co
0
co
co
C:�
C:�
C:�
C:�
in
L'i
VT
M
0 0
0
0
0
C:?
0
Vi
iA
m
C>
0
0
0
0
0
0
0
C:�
C:�
C:�
C:�
in
L'i
�n :3
X
X3
cz
:3
cell
0
x
2
Wi
X3
ul
W
"I
w
13
Q
C:
( :::,
IIY
x
2
P
F
LU
E
-0
E
I
0
�Ql �
.a rn
eg
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
7 O O O O O O + Cl +
+ +
o goo, 0 0 0 0 0 0 0 0
ol in Loi o 0 0 o v
of N loA t00 W
M
OOOOOOOOOO
O V O O O O O O O O
co
lT
W
O O O O O O O O O O
b
ID
O O O O O O O O O O
O O O O O O O
tiN ti O O O O 7
07 N loA too Co
M
O O O O O O O O O O
0
w
0
N
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
0
0
0
0
0
0
0
of
ai of
Loi
Loi
Loi
o
0
0
o
V
a+ T
c+i
Li Li
W 1R
� cd{
O II
W
N
Z grcQ
d �'I
W ili�il���p
•1::A
'n'n���:
u
M�
ill
I�
µ'Q
m
4
fl
Y)
YI�
IQN
x^
r
diCD}
VaY
f1
ulQj
my
Yflr
M
FHill
(lIh�u�
�'Y W
Ol
Y
�IIY
rl �'
V AYpF!
rN!
V
}
yYQ
Cl
0
�Ql �
.a ae
CL '6
O �
d O
a I, W V m C Q I-
W
W t\ O O O 7 O O O O O
o o ao rl ao o ID LO
M O ti N T M n m O
O 1
0 10 CID M Ib 7m
+ + O O O rl O O O +
+ + +
O I!7 ol t0 OJ t0 N O O O O O O O O O O
v, orn q In o 0 o O o O O o o O o
n IN N lD M O t O ON O O lD
N In n In M ol O 10 W N O O 7
N O N lD O tiM O O M n O O In M i0 O i0 N O N Il] O N
W t0 M N lD co I` IN co W
co O M M r
N W VI
O InN 7 M O O O O O O O Cl O Cl
lO O N N O� W I* O O O O O O O O O O
O In i0 tO O .-i t0
O INTI kr O t0
M 10 N IV V N V1
O O O M O O O O O O O O O O O O O
O O O N O O O O O O O O O O O O
N IA i0
ti n
N
W n O O O O O O O O O O
� O V lM0 01 t0
7 t0 n 7 n n
m ID D
O O O O O O O O O O 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 � W 7 O OJ ti O O 7
N lA W N 01 0 (7 1 O O M 7 O O l!7
Ib Di M tri7 a, ON N O It) N
N V W n of N IN IN
M a, W .-I M - 7
N W V
O O O O O O O O O O O O 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 0 0 o O o O O O O O o 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
co MT N N N T O O V O O lD
7 N O+ w O+ g t0 O O O O
N In W N T a O O M V O O Lr
M a, W ti M
N W V
V I:
In
r-1
K,
uY
in
L..
ira
�w
iWi
ar!
N
:]
qnm%
+MA
m
rui
a
✓�
i
ra
"fin
rNA
Yflk
f7l
dj
1 L +41
r✓I
^a�.,y.
✓a�!
1,3e�
C^l 'm
C'i
W,
iIt
rYNr+l
rb
u a
I Iu
II II i
�.r,',
+
r u`I,
II li i
r
rk'!
�.a W
]
I"N.,
u4M'Y
x
+,-,
rN!
0.l
Sl A
CY1
10 407
0
mu
rm c
n•a
V I:
In
r-1
0
�Ql �
.a rn
CL '6
� rg
d
Q
T o io 0 0 0 0 0 0 0
IR I0 0 0 0 0 0 0 0
VI O O M
N .-t
N � lOn O O O O O O
M V M � Ln 1011 ti
V1 10 O O O O O O O
M 1� lD to O O O O O O
M N W
N .-t
OOVOOOOOOO
N l0
01 07
In M
M
M n O In O O O O O O
M N OJ
N .-t
O O O O O O O O O O
n O n Nn O O
l0I� O t0 Ln to O
M w^ -I l0 ^ 1011
O O O O O O O O O O
O
0
o
0
0
0
0
0
o
0
O
0
O
0
O
0
O
0
O
0
O o
0 0
I�
to
M
V
N
t0
O
n n
I�
l0
O
Ill
n
O
to
t0
to
Ln
O
to
O
O
ti 10
tPr iA
((1 (dl
Q Ia
fwY
� M
Zi
LlJ IeeI��
d T
W IqV�
"13
rll,r
cz
I�3
IN....
Iliiilliir
�
I�M
cn
as'J
mA
CY)
SII
ig11
V")
Yu)
IN
., ::
R
C
�II Y�
tlrlW1
V M..
CY)
W5
II
II
r
vA'l
N}
JIY
0.0)
rl!
a.
11'RR
tlAl
(U
d,
u'Y,
uu1
xrr
Rur
�..
a
1
wR;
u
LuCo
0
�Ql �
.a rn
n -a
� O
d
Q
M V .Ni O O O O O
O I: 7 O O O O O
VI O M � ti
M L o v o 0 0 0 0
ko m ti w co co
Lr A M co In
N .Nt ID
- O O O w O O O O O
l0 l!7 O O to O O O Om co
O
\ tT
O O O O O O O O O O
O O M O O O O O O O
m
fb
N
�O In O O lel] O O O O O
M W
O O O O O O O O O O
IN � 01 W 10 W
N O cc M m In
N
O O O O O O O O O O
N N
co 00
C C
0
rn
IN
0 C
00 Go
trT tPr
n n
m n
to tR
O
O
O
O
M
ti
tri
O
O O O O O O O O O O O O
O O O O O O O O O O O O
vi n co 1, l' vi ai ai
N O cc 10 'i MM M Lri1 rl ON
O] M W O M M
ri tPr iA
� NiM
� 81
Z
aA
M
W
�S
tAb
�M
.u:ry
z' KI
IIA V'"I'.i IV
cz ,6
M
N
NN la) u
C' ff7 �/{
"
LX
�RII KIS, I)IV
�rIA SPX ^N� uN) e I II II..
I AA SAY
u pai nIY
ryf�
u
�(U}
C� W ] f•X., t-" :% W
F
li� Y1„ II
III U X 0 Ytl5 n'G
0
�Ql N
.a rn
CL '6
� O
d
v w 100 .
I� In N N
VNI N N
N W In .Ni M N 7
N O V O V '
N W
7 M N M
O, M N
N W Cl ID Lq n N O O O
ti W N W
0 W T
0 N
0 0 0 W o cq 0 0 0
N M
� lf1
.moi n
N
N W O IQ n N O O O
W V N W
l0W 0
10 N
O O O O O O O O O
N M lA O lA 0) N 7
7 M O W M n 'D W
O O O N
O O O O O O O O O
o O o O o O o O O
0 0 0 0 0 0 0 0 0
N M In O lA T N V
M O W M n 0 W
O] - 7 w M M
O O O N
O -,v .--I to
0
K
T.i
rW)
IIM
+'tib
6.A
R.....
'iWa
�F
�m
�YuX
AT
F
r0.)
�F
C
41
W�
fII
�
M
F"5
IV
YryX"�
011" �1
PY
w
Y
CI y�'➢
P
Ul
4 P,",M
tlAl
rN!
'F W
tl
1 IIP
8
a
nlY
]
a'y� fry
II Y
11 111 IIP
X
W
0
5
r1
3 aur
iFr
nl
a am
W
F, r
r
t
r
x..
U !:
IR
OD
w
n
V}
lA
Vf
O
O
N
O
O
4A
O
O
N
V]
fA
fA
00
r-1
a
E
-0
E
- a, -
o I: o
Ln
+ N
+
q w
q
cq
cq
00
N
OD
N
00
N
O ON
O
ON
N
co
co
CC)
O
O
Ni
m
r -I
a
rs
E
-0
E
ti
O
O
O
O
In
lA
U1
a,
Vl ol
ON
N
14
N
0
Ln
W Ivy
X ap
El:
ap
V
X3
r ,
,
IIA
n,
w
OR
w
CD
ED
:3
al
CIr
jjrN
x
Lu
C)
C)
a
E
-0
E
o n o 0 0
�o
10
rn
rn
I`
O O O O O
O W
C:� Ili
W
I
—A
Irli
Ch
m
R'
m
�V
ti
ul
LU
li
0
0
I
—A
Irli
a
E
-0
E
� LO
w 0
0
C>
CD
+
0
0
Lrin
Cl
C=�
C:
Cl
C=VI�
C�
c�
lz
In
C,
0
C,
N
ti
C)
O
IN IN Cl C> Cl C>
O� C� C� C� C� C�O
0 O O O O O
O O O O O O
O
0 0
0
0
0
0
0
0
Lrin
Cl
C=�
C:
Cl
C=VI�
C�
c�
lz
VI
0 0
0
0
0
0
L'i in
C:�
C:
C:�
C�
lz
VI
�o
.0
ll�
.0
CID
OZ
CID
'A
10
00
ll�
00
8
m
co
cl�
14
co
I
C:
C�
lz
ul
dij
W
Im II II.I
LU
P
F
0 C)
�o
.0
ll�
.0
CID
OZ
CID
'A
10
00
ll�
00
8
m
co
cl�
14
co
I
0
�Ql N
ra 6e
n -a
� O
d
Q
rn o 0 0 0
o rn
� n �
� O
7
m m O O O
o rn o 0 0
N C,
O
O� ti O
N
7 0 O O O
0 co
co
N N
CO
,I-
0
O O O O O
0 o O o O
W
N N
0 0 0 0 0
0 0 00 0
o Lr o o
M lA O
VI
O O O O O
OO O O O
0 0 0 0 0
0 0 o O
�O In O O
M lA O
O M N N
l0 rl
O
O
M
fV
W
IIM,
C
O
IlaC
tib... vA1
PMm
���
rr!
f.,PY 0.0)
IIM
MyA
fl
V7
CII)
rv''i�
'�➢
+"fll
r 1 x
W 1.6.Y
w
Pt
air
O
O
M
fV
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: FEBRUARY 14, 2018
SUBJECT: MONTHLY FINANCIAL REPORT — JANUARY 2018
Attached hereto are the cash position and investment statements of the Village for the month ended
January 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 detail 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 December 31 was $47.2 million.
During January, cash receipts totaled $6,439,590 and investment income was $47,547. Reductions in cash
and cash equivalents during January totaled $7,132,853. Of this amount, payments to vendors were
$5,520,748 and employee payroll expenses were $1,612,105. Inflows resulting from interfund activity
totaled $48,807 and other reductions to cash totaled $174,647. Cash and cash equivalents at January 31
were $34.0 million.
Investments in the Governmental and Enterprise Funds at December 31 were $755,225. During the month
of January an additional $12.5 million was transferred from cash into various CD's and US Treasury and
Agency Notes. The large cash amount came primarily from the issuance of bonds. Proceeds from the
issuance will be spent on various TIF developments and utility infrastructure projects during 2018. 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 January 31 are $13.2
million.
Monthly Financial Report — January 2018
February 14, 2018
Page 2
Total cash and investments for Governmental and Enterprise Funds at December 31 were $47,989,049.
Cash and investments at January 31 totaled $47,217,049. This is a decrease of $771,556 for the month.
Trust and Agency Funds - Cash and cash equivalents at December 31 was $3.6 million. During January,
cash receipts totaled $695,724. Investment income for the month was $73,712. There was also a net
increase in cash due to investment activities of $46,032 while outflows due to Interfund activity totaled
$48,807. Reductions in cash and cash equivalents during December totaled $941,866. Of this amount,
payments to vendors were $191,374 and employee payroll and related expenses were $750,472. Other
disbursements totaled $2,753. Cash and cash equivalents at January 31 were $3.5 million.
Total investments at January 31 were $139,155,420, an increase of $4,576,032 from December 31. There
were interest income of $4,622,064 and a net transfer to cash of $46,032 that accounted for the change.
Total cash and investments for Trust and Agency Funds at December 31 were $138,216,857. Cash and
investments at January 31 totaled $142,614,932. This is an increase of $4,398,075.
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 December 31 totaled $15,381,954. During January, cash
receipts totaled $3,888,216 and investment income was $27,159. Significant cash receipts included sales
and income taxes.
Sales tax revenues for the month totaled $1,570,513. Of this amount, $1,463,715 was generated from
the 1% state portion while $106,798 was generated from the .25% home rule portion. Sales taxes
received in January are for October sales as there is a three-month lag in getting this distribution from
the state.
State income tax receipts for January totaled $411,622 and were for the month of December.
Disbursements from the General Fund for January included payments to vendors of $2,071,939, payments
for employee wages and benefits of $1,409,908 and other disbursements of $17,272. There was also a net
decrease in cash from Interfund transfers totaling $1,522,481 and a transfer to investments of $3,748,911.
Cash and cash equivalents at January 31 were $10,526,818, a decrease of $4,855,136 from December 31.
In addition, investments consisting of certificates of deposit totaling $4,175,111 bring total cash and
investments for the General Fund to $14,701,928.
Statement of Investments (pane 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 January 31, there was a total of $13,228,950 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 - January 2018.docx
Monthly Financial Report — January 2018
February 14, 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 January 31, there was a total
of $139.2 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 - January 2018.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report- All Funds
For the Month Ended January 31, 2018
GOVERNMENTAL AND ENTERPRISE FUNDS
Disbursements
Accounts payable
Cash and Cash
Total Cash and
(5,520,747.71)
Equivalents Investments
Investments
Balance at December 31, 2017
$ 47,233,810.85 $ 755,237.69
$ 47,989,048.54
Cash receipts
6,439,590.26
6,439,590.26
Investment income
47,547.34 -
47,547.34
Transfers from investments to cash
- -
-
Transfers to investments from cash
(12,473,711.97) 12,473,711.97
-
Interfund activity
48,806.66
48,806.66
Disbursements
Accounts payable
(5,520,747.71)
(5,520,747.71)
Payroll
(1,612,105.11)
(1,612,105.11)
Other
(174,647.47)
(174,647.47)
Balance at January 31, 2018
$ 33,988,542.85
$ 13,228,949.66
$ 47,217,492.51
TRUST AND AGENCY FUNDS
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at December 31, 2017
$ 3,637,469.00
$ 134,579,388.02
$ 138,216,857.02
Cash receipts
695,724.03
695,724.03
Investment income (loss)
73,711.80
4,622,064.18
4,695,775.98
Transfers from investments to cash
1,477,368.54
(1,477,368.54)
-
Transfers to investments from cash
(1,431,336.74)
1,431,336.74
-
Interfund activity
(48,806.66)
(48,806.66)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at January 31, 2018
(191,393.76)
(750,472.17)
(2,752.82)
(191,393.76)
(750,472.17)
(2,752.82)
$ 3,459,511.22 $ 139,155,420.40 $ 142,614,931.62
* Assets are restricted in purpose and do not represent discretionary assets of the government.
F
U
W
a
0
Ix
IL
z
Z
7
0
e
LL
0
W
CD
J
(D
F N
C -
Cl)
LL L,
ca
.0 D
7
Q
L c
mw
U $
0 0
E
7LL
Z
LL
LL
U
Z
W
U
Q
z
Z
a
F-
U)
D
w
F -
y
r
OD C14 7 Or ON
6.I-Lo0 V'OvO
N V'
r
V'
d�yy--
(O 9�yM
OOD
O
d
h
Ji
a
NMN MO V'
r
N
Lf)
O
d'M
0)0) V
M'
d
F-
U] r• r-
v N N a �
N N
f0
00
V
(0 CD rD
N M
(10
Cl
C'
w £ C N 0
W V Cb v
M h�
d'
N I'� V
M
R
C
E
Ln N c- v
N O
Cl)
r V Off)
LN
!�
>
_= L N N N .� 7 7 7 7
C
LL
N J
c J
a
Q ate') m> m m Q; D V Ai m
O O)
~
CO F F- 0000
W
zU�i
F F-
(n >-
N U) r a N 00
a O
M
" w
K
of Z (n
Lo O�
O
C
F- W 0COp
0
V N h-
c
d'
V
Of Z
� N
N
n
W0LL
rN
M
OQ
�
ss��
M V'(OD ti V
�I-
OM
N
V)
fJ O In W (p V "
" N
CO~
U)
" V t0
V'
O
10
Z W Z
a () (�
d (D t+)O
V M N M M CD
N ti
c,{ N
O
M00
!T
N
N
Ln
J
N M P, V'
O r
CD 00
to
(C
Z
OV V ~ V V `M`..
r
r
to
cc
LL a CL LU
N .."
.Oh,,_.
N
r" ��yy
ti
N
07
tf)
r
y
W
LD (o IT N wI`�
O
w
O
(n
ON M M W V
r
00
(D
(D
N
ty�
oon ;:8
o-4
v
v
v
m
0 0- U)
m °o' L`rn r= OD (�
rrl
Ln
rn
()
i
W❑
J F- Z
r�
N
cq
N
~
N V V ._.
O
0O)
N
N
w LL
V O r
pz
V
a
4A
co
U) d r-(7 N 00
M aD
N
N
N
V
J Z
Q
r- O Lo U) (D 0)
a V' M
O
O
N "
Ni
cN(1�jj
00
fG
J
zLL
00)CCDDa) O0OM LOD
W
N0)d' MNM
0)(o
O
tlN'
N
V
O
W>
ONO N
Oco
W
h
D
t.-
0)
ti
0)
NV
M
Z
C6
r "
(m
of
�
w
W
ttpp
O
.0
N
U�
�
O-
V L110)00
0) 00 Lfl ° [� (O m
((o
" 00V'
i" "
h-
M
Q'0
ao -L0
MLOQM
co
N
N
N
mO)',,
O
N
WZ
W Z
0) h (D r• N
CD
M
0)
LV
0)
fD N N "�
N
V m
0)
IQ
N
F- LL
V
`�
(~D
L
Z
00 — N
In
CV
N
00
W
N
N
Moo
N
N
N
J
co (o co
r n a a
CD (D
00
a e
r-
Oi
u r
n
ti
N
n
W0
d5 00 0)
d LU Z
r. O
Pi`
ti
LL
m ami
m
Cl)
m
0
C6
M
a
aS
m
to
LL]
n (D
o
0
(° r�
O
" r r
af(n
0
IN N
O
N
n
W
W Z
0) (hD-
F -Z)
m LL
r
W
efl
40
(p
0UD co (D OO (MD,
(D
(p
N
J W
U Z O
h- cD L(7 N10
V
O) M
N
(7
W W Z
00 h•- V CNC0O V Oi
N (f)
N
hl
N
N(DD V'�.r.,
.�V
O.
V
V
U)wLL
(A 04
N
r•
N
0)
w
(q
P O LDO Ln N
Ln C+)
r-
O
O
r -
Z
GO Lo (O —0
U) M
(0
00
CD
-e
�}
00IN.,
tl
r-
O
O
N
LL
IOON
O M..
LD
M00 00 N co �„�~,�
00
CC)
ti
Lo
O
W
_ _
Z
W
y
r
rn
rn p N
w
Z n
g
W r n
J = N N
N
w
>
> c L p 7
= c
Z
CYIn
w £ C N 0
N
N Z
Q
_ Uc N .N. Y Y
u) E c
0
(�
N 2>>
F- � L
0
C
E
Q a a w ° o aci v aci aci
c�ac�DaEiaEaEioEi
m
n
0
w w 0
Z�
to
T a
U
>
_= L N N N .� 7 7 7 7
C
LL
N J
c J
a
Q ate') m> m m Q; D V Ai m
LU
> m
~
CO F F- 0000
W
zU�i
F F-
5
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of January 31, 2018
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity
Purchase
Financial
Investment
CUSIP/
Date Date Institution
Description
Date
Date
Institution
Description
FDIC #
Net Yield
Purch Price
GENERAL FUND (001)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
02/28/18
02/29/16
Cit Bank/Onewest Bank, CA
Certificate ofDeposit
58978
1.250%
142,000.00
02/28/18
02/29/16
Bank ofthe West, CA
Certificate ofDeposit
3514
1.200%
142,000.00
02/28/18
02/29/16
Midland States Bank, IL
Certificate ofDeposit
1040
1.170%
142,200.00
06/29/18
12/28/17
Freddie Mac
Agency Notes
3134G9TH0
5.000%
1,251,401.35
12/31/18
12/28/17
U.S. Treasury Note
Treasury Note
912828A75
1.500%
1,250,067.88
12/13/19
12/28/17
Federal Home Loan Bank
Agency Notes
3130AOIR2
2.375%
1,247,441.57
* Assets are restricted in purpose and do not represent discretionary
assets of the government.
4,175,110.80
PROSPECT AND MAIN TIF DISTRICT
03/31/18
12/28/17
U.S. Treasury Note
Treasury Note
912828QB9
2.875%
2,482,129.06
2,482,129.06
WATER AND SEWER FUND (050)
02/28/18
02/29/16
Cit Bank/Onewest Bank, CA
Certificate ofDeposit
58978
1.250%
34,000.00
02/28/18
02/29/16
Bank ofthe West, CA
Certificate ofDeposit
3514
1.200%
34,000.00
02/28/18
02/29/16
Midland States Bank, IL
Certificate ofDeposit
1040
1.170%
34,000.00
05/31/18
12/28/17
U.S. Treasury Note
Treasury Note
912828VE7
1.000%
2,497,287.58
2,599,287.58
VEHICLE REPLACEMENT FUND (061)
02/28/18
02/29/16
Cit Bank/Onewest Bank, CA
Certificate ofDeposit
58978
1.250%
69,000.00
02/28/18
02/29/16
Bank of the West, CA
Certificate ofDeposit
3514
1.200%
69,000.00
02/28/18
02/29/16
Midland States Bank, TL
Certificate ofDeposit
1040
1.170%
69,000.00
05/30/19
12/28/17
Freddie Mac
Agency Notes
3137EADGI
1.750%
1,250,297.28
06/12/20
12/28/17
Federal Home Loan Bank
Agency Notes
313383MB4
1.875%
1,248,799.87
12/11/20
12/28/17
Federal Home Loan Bank
Agency Notes
3130A3UQ5
1.875%
1,246,287.38
3,952,384.53
RISK MANAGEMENT FUND (063)
03/06/19
03/06/17
Mount Prospect State Bank
Certificate ofDeposit
354058
0.250%
20,037.69
20,037.69
TOTAL GOVERNMENTAL
AND ENTERPRISE FUNDS
$ 13,228,949.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,627,288.16
Various Various Various
Mutual Fund Investments
Various
Various
49,077,916.49
71,705,204.65
FIRE PENSION FUND (071)
Various 5/26/2015 Principal Life Insurance Company
Group Annuity Contract
8-10810
Variable
3,207,364.15
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
22,089,645.87
Various Various Various
Mutual Fund Investments
Various
Various
42,153,205.73
67,450,215.75
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$ 139,155,420.40
* Assets are restricted in purpose and do not represent discretionary
assets of the government.
2