HomeMy WebLinkAbout021820-05.3pAhV.3
ADMINISTRATIVE STAFF REPORT Jl[d.E
TO: Mayor and Town Council
SUBJECT: December 2019 Month End Treasurer's Report
BACKGROUND
February 18, 2020
The California Government Code and the Town of Danville's Investment Policy require
that a report specifying the investment activity during the month, as well as the month-
end investment balances, be prepared and presented to the Town Council on a monthly
basis.
DISCUSSION
Beginning and Ending Cash and Investment Balances for the month of December 2019:
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2018
Cost Basis
November
30, 2019
$80,635,907
1,231,335
1,699,441
$83,566,684
$78,469,544
December
31, 2019
$74,346,266
1,260,553
1,699,051
$77,305,870
$82,210,032
There were no purchases for the month of December 2019,
Market Value
November
December
30, 2019
31, 2019
$81,385,385
$75,115,839
1,231,335
1,260,553
1,701,114 1,700,962
$84,317,835 $78,077,354
$77,427,603 $81,551,341
Purchases for the NERIAD Fund for the month of December 2019 included one U.S.
Treasury Note for $274,807 (maturity date November 30, 2020).
Maturities for the month included one Federal Home Loan Bank Note for $1,610,080.
There were no maturities for the NERIAD Fund for the month of December 2019.
The Town's net cash position changed from $7,745,905 to $3,066,344 during the month of
December 2019. This consisted of operating expenses in excess of operating revenues of
-$6,458,900, net funds invested of $1,610,080, premium/ discount recognition of -$8,119
and interest received of $177,378.
Cash requirements have been projected for the next 12 months, and the Town is in a
position to meet its cash requirements.
All investments that the Town owns are in compliance with the California Government
Code and the Town's Investment Policy.
PUBLIC CONTACT
Posting of the meeting agenda serves as notice to the general public.
RECOMMENDATION
Accept the December 2019 Month End Treasurer's Report.
Prepared by:
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: December 2019 Month End Treasurer's Report
December 2019 Treasurer's Report 2 February 18, 2020
0 0 0 0 0 0 0 to
I'D 00 .--i Vl O r o0 [-
00 O N M O
-+ N ,--i N O N N N
0 0 0 0 0 0 0
M M M O �o 1.0 00
N Il- It kn O M 01
O\ 00 T I'll — \O M
C1 O M V•� o0 O o0
Vl .--i I'D a1 kn [- kn
l- 'IT N —
M M O N oo N
M 01 M N 'IT N kn
N N r -
LIS
N O M 0O O r N
C= O O N 00 [� O M
N N c+i N N
sv �oq
0 0� o 0 CD 0 0
O O M O O O M
O kn 1.0 O O kn I'D
�n O� �o r- I�0 00
M cl O N o0 a
M 00 M N --�
Qq ILII
0 0 0 0 0 0 0 0 0 0 0 0
00 '-. O 00 a, � 00 O,, 1.0 O O
00 O l- 00
1p --� •--�
V't 00 W
't
N l � 00 l�
00
o �
b
v1 �n O
O� N kn �,o \�o
.bA
O �O O
o0 -. 00 �o r�
--
�O
U
O>
N
[�
0
o
0
E-
v� d oon�U
�wUdZzi �
0 0 0 0 0 0 0 0 0 0 0 0
00 '-. O 00 a, � 00 O,, 1.0 O O
00 O l- 00
1p --� •--�
V't 00 W
't
N l � 00 l�
00
A O\ N M M W)
v1 �n O
O� N kn �,o \�o
O �O O
o0 -. 00 �o r�
--
�O
O
O>
N
[�
1 r
A O\ N M M W)
M N M
C, N 00 r
N
S.
N
O
O>
0
0
E-
69
00
DO
'ch
49I
00
00
00
00
x
G+j
691.f
00 00
00 00
,-,
110�
69 I Qn
U
W
Q vi c{
�
kn
O
00
Y
O
O
O
W) M
O
O
[�
69 69
619
6R
69
N
Y
b
�0 kn 00\.D
' 00 O o0
00
N kq 00
00
l� kn N
N
LO
l^
W
U
Q W
w O U
M
00 N
N
m N V N
z
69 69
69
69
00
DO
'ch
49I
00
00
00
00
x
G+j
691.f
00 00
00 00
,-,
110�
69 I Qn
69 J69I 69ll 69
U
W
Q vi c{
�
kn
N In 00
00
Y
[�
69 69
619
6R
69
N
V
b
�0 kn 00\.D
' 00 O o0
00
N kq 00
00
l� kn N
N
N
Okn
W
U
Q W
w O U
M
00 N
N
m N V N
z
69 69
69
69
69
U
-
M kn 01
01
00 \O 01
N
N
N 'IT N
69 J69I 69ll 69
z
U
W
�
o
`J
Y
[�
c
O 151
H
ULnd
C�
6,
Cd
;
Q
C
C H
�
W
U
Q W
w O U
z
U
U
z
N
A 0
M
00
W N
z
>,
U �
f.'
Q � �
A o �
a�
U
U 69
'C M
M
W M
C N
O
b Cl
� M
w `O
o
00
0
� M
p1 N
a1
k
i � OM1
M V1
a.�
O O^1 00
00 [� N
O 00 l-- 00
-- � � -'t110 r- 00
sv sv
0
w
w-
o
01 �c
all
N
00
0
00
r• 01
cd
60
I'D
00
z
o_
0606
�o
N
as
a�
zO
x
w
p
N00
Cd 0
O
U
+�
�
� N
vcqj
O O
69
N
A 0
M
00
W N
z
>,
U �
f.'
Q � �
A o �
a�
U
U 69
'C M
M
W M
C N
O
b Cl
� M
w `O
o
00
0
� M
p1 N
a1
k
i � OM1
M V1
a.�
O O^1 00
00 [� N
O 00 l-- 00
-- � � -'t110 r- 00
sv sv
G9 s9 s9
0
00
00
O
M
M
00
00
N
00
N
00
00
69
M
kn
O
N
69
N
M
fA
0
w
O
O144
N
a�
N
cd
60
O
z
Ob
N
as
a�
zO
x
w
O
z
Cd 0
O
U
+�
�
� N
vcqj
O O
N
G9 s9 s9
0
00
00
O
M
M
00
00
N
00
N
00
00
69
M
kn
O
N
69
N
M
fA
w
N
cbb
G.
0
O
O
O144
N
N
cd
60
cz
Ob
N
�"
a�
zO
x
w
w
N
cbb
G.
7 u
Q
O y>
'b
U. td
O O\ N O O O O O V) 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0
W) �o �D �O O O O O O, O N O O O O, O 00 V1 O O O O, O O
00 00 N O\ M �o 00 00 t- G, ,D ,D 00 lzt 7 t- 00 O ,D O. O O\ O
M N 00 N V �O N �O M Un--� ,D Un M M N O .-� 7 kn t- ,O O O
N C14 m N N N 7 N" N� 2 N �--� a M N m -IT M N M
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O, W) N N M 1t V (N t1 00 ,O O DO 00 00 W)0 7 0 ,t 7 0
U1 V1 �D �D 7 11' 7 V'1 O\ In 00 00 .� � V1 00 00 W, W, U1 �--i �o 00 lr- � 7 N O
— — — — — N— — -- N CV — N N N — — M ,-r N N N N N
m7 �D 00 N 'n N V o0 �o M O V �c 7 t- O m 7 �--� [� O 'n
'D V1 N N .--i �o 7 t- N 00 O1 (3,M t- O t, a, w W m r- N o0
(0 00 M V V 00 T L' O --� O oct- N O, lr olO (0 R O V 00 O N
Oi 7 r: 00 O v'j o0 7 O O t- t, O 7 O; O �--i t- M O 7
O, w �--� O, O O( O O V O �--� N oo N N O\ M O, 00 ,D M M N
Vl O V O O o0 O N [� Vl a1 M
In �D W1 In O O V O1 vl lzr O o0 O o0 O C\ O\ O W) O �o V1 �o v1
V O1 t, V1 M ,D Vl t- kn 00 O --� ,p --� vl N V M 00 O W) V1 M O
00 N --� 01 M N M O\ --� "1.--� 7 00 O [l--� M
00 M O; v'1 t` W' M �--� O, O t, Oi W)--� M ,D N kn O 00 vl v1 [_� t -
O O O
O, 00 O, N 7 N 0 w O O ON t- , O, O 00 M 01C)
7 ul r- O N U1 M V O\ 00 �o O
O O O O O O O O O O O O O O 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 O 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 O O O O O O
O V1 O O O O O O O O O O O O W) O W) 0 0 C. 0 0 0 0 0
O w �--� O O O O Cl v1 O O O O O t- Cl N O O O W) 0 0 0 0
W vl 00 O M n� O 7 O V O o0 l- On O, n
O O O O O O O O O O N N N N N N N N N N M M m
N N N N N N N N N N N N N N N N N N N N N N N N 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
N N N N N N N N NNQ N N N N N N N N N N N N N N
O t- 00 00 M 00 N Ur- Wn O ul O (=I ,D ,D C, O, 01 0 O O\i
.-r �
�N N !Z NQ N N --� 7 O --� 7 0 0 0 O --� O
,O 01 O, 0, O N M
0 0 0 0 0 0 0 0 0 0 0 0 O O
t` t` t` r- �c 00 In W) r- �c 00 t-- r rn 00 00 01 rn w C, 00 00 rn ON all
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cl 0 0 0
N N N N N N N N N N N N N N N N N N N N N N N N N
O N N O Cl m M �--� l� - M [� M N ,O M t` O W 00 O
M N M M V1 O O .� N NC% N O n 0 0 O o0 N M M �O
O O O O �--� �--� O-, O O O
= v
2 zz zzzz
a a
w w w w
w
z0zzzzzzzzz0
�
W WW pq CO W W PG
www wwtwwwwww
O
C)
O
69
0
69
6/3
A
O O O O O O O O O O O O O O O O O OO_
a, 00 �--� N 00
r
M n r M00
r-
O O O O
O
N Cl N kn Q1 N O W) O O r- W) Q, 10 V1 O O
N V1 M �--� 00
M N r- M V1
M
N
oo V1 O U
00
N
C�
7 l� Q1 � 00 N O� [� N 7 r- 00 7 �o
Ul
V1 M '-. �
r
00 00 Q; � �--�
M
7 M N
--� ^•--� �--� N N N 7 M N N N N M N
MV
N
M--�
�--�
�n
N N N M
F
O
69
Ff3
69
O
0 00 0 0 0 0 0 0
o 0 0 0 0 0 0 0 0 o 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 0 0
CD W N 1D M �D V VO ro 't00 00 O 00
O O 7 O 7
M 00 01 M
rO+
O O M 10� r � � c � N [- 't 0'O N 00 o0 M [-
00 DO
O
N'.
O D, n Na,
M M
'. --� --� '. --� --� --� •-� ,� N N N --� M N --� N --
--� --� O O N
--�
M N — N
N
Vn M 00 M
N
r- O [- M r-
V
r- 00 vl U 10
vl
�D 7 7 D\
M
oo oo �o 7 M V D1 n vlN oo v1 V1
kl -• O� � Ol O [� �-• 7 D, '• � C� �D l- 0o O ID
F
a,
Q1
7 oo �o M
N r-O� �D
7
M
M O1 o� N
n'. ll r- N
V
n
oo O 01 N
N ocC r-7
--�
W
O, n ON r- o0 U M ori ON ,--i r.- r.- o ON O oo
V V Q, 01 a, O a\ m
v1
�O O " N
�o
'D
N .--i M �o O
O1
Ci oo vl
vl
O\ M �-• Cl w) O �o O� O ON
tt M -• V rl v1 M N Q, C� 7 vl
�
M
�D vl kr) O O�
V r) N r- N
O
[� N M [� [�
N vl N v)
[�
Cl
M C1 O O
N 7 0 -•
7
o0
— — .-. — — — .-. — — ,-. .--i —
N
69
69
69
69
DD O M o0 �D N r- �o m r O oo O N S 00
�o
l� O_ [� M [� V
7 o
N N m N O M O� 00 N a0 00 �O o0 v1
[�
oo �D M
7
U m r-
'.
oo
-• M U N O �-• "Ij v1 lrM Nkf 7 r- kl
N
O\ O1 U U C
o0
O O N
O
O, N O 00 �O 00 00 V N vi O; 7 N O �D O O
N
�O O C14
�o
V�_ 7 7 O,
O,
l� m� 7
o0
p
Vl vl N DD O D, n oo O "D "D 7 �o 7 oo 'O Oi
O
�O v1 v1 o U
�D
r- M [- �o
�o
M ON ON kr)
00
M M '• V V N 7 N N oo O, "Id 7
.-+
V M N r-
'n N V1
6A
69
E9
5H
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
r-O_ [- M r-
7
0 0 0 0 0
0
O O O O
O
O o O O O O o O O O O O O O Cl O O O
O
W�c M
7
0 0 0 0 0
0
O O O O
Cl
O O O O O O o 0 0 0 C C 0 0 c 0 C C
C
N [� r-
M
C C 0 0 0
0
O O O O
O
cd
O Cl O O O Cl O O Cl O O O O O O O O O
O
Zt N --�
�O
Vj vj v1 W) O
O
0 0 0 0
0
Wn Irl O O o 0 0 0 o vl O o In O V1 O O O
In
�D V1 Vl O 01
�D
r- Cl) [- l-
[�
7 0 0 0
7
Q
;
M �D V1 N k l M N kn n N lr M N ON oN lr V1 n
r%
Vl N vl
N
N kr) o
00
— — — — .-w .-. .-. .-. — — — — — — '-i
M
N
N D,
"
69
69
69
69
y
y d N
pp>
u"
iO
O O
y.., b.
O O o 0 0-•-•-.-. N N N N M M M
N N N N N N N N N N N N N N N N N N
N N M M V
O O-. N
G p N
,p
Q
O O O O O O O O O O O O O O O O O O
N N N N N
O Cl O O O
N N N N
O O O O
N N N N N N N N N
N N N N N
N N N N
¢ [� N�
,N�.
•- O-.-. Cl .�-+ O �-• O O �-• oo O O �-•
00 N V1 v1 vl
N V in 7
p N U
M M M M M M M M M M M N M M M M M M-.
V r- 00 C, N M oo
N -• -•-.
v1 oo
-. O N
,
�-+
0 C. 0 Cl 0 O Cl -. 0 0 0 0 0 -.
o0
O O
o 0 0 0
�N
a
td
N
Q
w) r r- Vl r- r r- w 00 00 r oo rn O\ O1 a
oo oo m m 01
r- t- oo oo
Q
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
a a
0 0 0 0 0
0 0 0 0
N
N N N N N N N N N N N N N N N N N N
0 h 7 m 14
u u
N N N N N
N N N N
cNO
VO
�n N O N r- V1 o0 O (71 oo
O .� M N N N -• O -. N O N O N �-• �-. �-.
�-�
U U
N N N �-•
in
O N N r•
g 00 N O O 'D 7 m
oo�ooO000
V1
) oo oo r- O
V oo
a
'•'• r. oOoo
oOo
OOOOr.
0000
N N
M �
y
o0 y
m M U
p
.per
a�
d c, c,
F
0 0
x
>. >.
Q�°zZZZZZZzzZ0
0 0 0 0 0 0 0 0 0 0 0 0 0
Zo zzzz
p
ai ai ami •
O
2 g m om m m 9
o o
c°zw
N N 3
� ca ca ca ca co ca ca � � ca cd � � ca � �
aoi
� on on
IM
vi vn vn vi vn vn vn vi vi v6 v) vi cn vi vn vi vi cl�
W
U
Q z
Cl O Vn O O O O V O Vn vl O O Ul n N
Vl N
G Vi n O [� m D\ 00 O'n N O Oi O pi w pi
Nm �--� N N �--� �--� M N N O M
d � M
6A 69
Co � o o r-� 0 0
O m M m M 7 00 OD CD 00 N ['- [- 7 7 lD 00 O
O � B O O a1 00 O N N l'- M v1 In O h
- M M N M N - N N M N N N N N N
00 �n O i- m N O 7 00 It 00 C1 .-r ON
O W 00 00 00O M 00'n� O 01 01 V �p M
(7, -- DD 'nV --� N C- --� N0
o0
M N N [- M r- m N 00 O w O N N r, v�
O M 7�o N--� O Ul N� r- 1.0 O N --
00 °� O l- l- O O v� N O [- l- l- 00 O N
V) 69
Ol) O O Vl O O O lD O O V1 �O O+ 'O
00 vl l, l- O O, O N a1 N C) O m M r O
N N lr 't � N M S U � N .O tl N
I'0 [- W) a\ 7 O �D Ci vi O N V �D [- 00 It �o
O
U
00 M N 7 O O\ V1 00 vl �D 7 N O �O V
00 00 O l� l- C 0 7 N C1 l- [- [- 00 C O M
69 69
O O O O O Cl O O O O O O O O O O 7
O O O O O O O O O O O O O O O O It
O O O O O O O O O O O O O O O O M
Y
o
p
'@
0 0 0 0 0 0 Cl 0 v1 0 0 0 0 0 0 V1 10
O 3- 1 vl O O O kr) VvO
l l Vl l kf1 �O 00
O vr--r--O
^y
✓
o0 O� O lO V) N O l— l— [- o0 T (3 -,I
N a1
O
cl
> M
N
W
O y
Q
O N N N m M m to m 7
N N N N N N N N N N N N N N N
O O O O O O Cl O O O O Cl O O O
F -I
r
O O O O O O O 0 0 0 0 0 0
N
fd
O
OJ
id
l� w o0 [- w 00 m O, a1 a1 O1 (7, a, Q, a1
(\J N N N N N N N N N N N N N N
rN
D\
w' M O 01 �O l- vi M o0
O O 0 0 0 0 0 0 0 0
Ati
G
O
U
N
z
o
q
o IS U y Z U °°
U o
U y ° 5
u OzZZ °Z ° U �Q
O z p U G V ca cid o
oo-
ZA Uw O
Q
w o
O ,
V
o
za y V U"
W V v 0 U "" o d o 0 0
3
cTi
N N V z Z i"' Z f/) x
w
y
C
U
o o
°� o
d
cd
° Z Ud Q w
CQ
19 J-. o (,
�2 M 00.UF-wD
�v)00rn
g4u
rY
W
-�l 61-1
v
O
U
N
i�
a
fA
0
W
�i
wo
a
a—
N
O
id
it
`i
O O O 00
o
O -- \D 00
N N O �t 00
M 00 M (— ~
M M
69 69
O I'D 00
N N O It 00
M 00 M l-- f
kr l� N 146
M M �
� s9
N N O x'00
M
v)
M �
69 69 69 69169
00
00
69
00
00
d•
69
00
00
~
Q
H
H
00
O
U
P
N 00 kn \p --�
O DD 00 01 !`
69 69 69 69169
N M00 l— O
N W)M O N
O .,t W)
00 a0
Vl 00 01 It [`
O, ON Wn t— N
N 00
69 69 69 69169
OO O O O
O O O O O
O O O O O
O O O Wn kn
O O 1.0 l— M
N N .-- N 00
69 69 69 69169
0 0 0 0
N N N N
O O O O
N N N N
N to oo
o� 0� a, rn
O O O O
N Cl! Cl! N
N M M N
bbbb
>>>>cd
:?1 =�+ � O
v, A a
0 0 0 0
zzzz
0
iU-i SU -i lUi 7Ui
N H H H H
V� AD
N M
O k/i
M N kf)
69 169
69 169
69 69169
0
OVN
t`
00
00
N
69
M
o0
N
00
N
69
M
O
O
N
69
Y
O
H
c�
a