HomeMy WebLinkAbout031720-06.3ADMINISTRATIVE STAFF REPORT 6.3
TO: Mayor and Town Council
SUBJECT: January 2020 Month End Treasurer's Report
BACKGROUND
March 17, 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 January 2020:
Cost Basis
December
31, 2019
Town Funds $74,346,266
Trust Funds 1,260,553
Assessment & SA 1,699,051
Total Cash & Investments $77,305,870
Total Cash & Investments
Year -to -Year Comparison
2018/2019 $82,210,032
Market Value
January
December
January
31, 2020
31, 2019
31, 2020
$76,518,151
$75,115,839
$77,576,474
1,233,441
1,260,553
1,233,441
2,136,881
1,700,962
2,139,080
$79,888,473
$78,077,355
$80,948,995
$85,244,089 $81,551,341 $84,729,781
Purchases for the month of January 2020 consisted of one Mitsubishi United Financial
Group Bank Limited Discount Commercial Paper for $1,394,185 (maturity date April 29,
2020).
There were no purchases for the NERIAD Fund for the month of January 2020.
Maturities for the month included one Federal Farm Credit Bank Note for $1,498,545, one
Federal Home Loan Mortgage Corporation Note for $1,483,396 and one U.S. Treasury
Note for $1,359,128.
There were no maturities for the NERIAD Fund for the month of January 2020.
The Town's net cash position changed from $3,066,344 to $8,185,113 during the month of
January 2020. This consisted of operating revenues in excess of operating expenses of -
$1,961,242, net funds invested of $2,946,884, premium/ discount recognition of -$6,069
and interest received of $216,712.
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 January 2020 Month End Treasurer's Report.
Prepared by:
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: January 2020 Month End Treasurer's Report
January 2020 Treasurer's Report 2 March 17, 2020
O 4,
0 0 0 0
O� -- 00 M O
0 0 0 0 0 0 0 0
w 110 M C� to O kn 00
d
E
00 00 � l y V'1 O � Q\
E
00 00 o
In rn
d N M
DO N
N �O 00 N •-
Y
•> O
� � N
M M W') 0� dt 00
00
O W
p
O �
U
oo N d N
a
a�
N N
d
cd
E�
0 0 m o 0 0 0 0
0 0 0 0
O� -- 00 M O
0 0 0 0 0 0 0 0
w 110 M C� to O kn 00
d
00 00 � l y V'1 O � Q\
•
00 00 o
In rn
d N M
DO N
N �O 00 N •-
d� N
0 0 0 0 0 0 0 0 0 0 0
N N
r- O
d O N Int In Cl M C,
O � O T d'
--� N
d
00 00 � l y V'1 O � Q\
•
d
d
M M W') 0� dt 00
00
oo N d N
Qpp 00 O �
O O� �
N N
d
O f 1 1 I
M M
\O 00 r-
O N
0 0 m o 0 0 0 0
N
00-00 00
0 0 o 0 o v
o
�
O •� oo l� O d' �
t
�
DO Cl
�O
N 1,0 00 N
N N -
l
b9
C�
Q
�
¢
Y
S.
Y A U
3
CA
x U
U •� O
QCccd>
O
W N G O
�wUdU2ri �
0 0 0 0 0 0 0 0 0 0 0
N N
r- O
d O N Int In Cl M C,
O � O T d'
--� N
d
d
d
Qpp 00 O �
O O� �
N
d
O f 1 1 I
M M
\O 00 r-
O N
>
N
O
H
�
�
9
O
O O
O O O \
O
O
O O
O �n v1 O
O
O
O O
\O M O
O
N N
M Ln
v-)
N 'n
Cl
' O lo� Cl
Cl
Cl
M
V) V'•
O�
00
M
00
M
�n V')
Q')00 M 00
00
00
l� M 'n 00
d'
N
00 00
00 d' N
N
kn N 00 N
01
O
l�
00
64
69 69
69 69
69
69
69
M M
O 00 00
00
m 00
00
M
Vn V'1
N kn 00
00
M W) 00
00
N
o0 00
N
n N oo N
ao
M
' O O1 O1
ON
M
v'1 -, a
a
O M D1
M
Vn kn
M kn 00
'n 00
N
00 00
00 d' N
N
\O N 00 N
O
l�
00
69
69 69
69 69
69
69
69
U
VO
W
U
o
O
Uy
W
on va
E-�
o
.>
`�ai
�
ami
r�wwun
U
Z
UZ
U
U
rn
O ^
N �
O O
11
' -f) O
M N
M
kn
69
I
00
N
r
00
00 M
(01,r-
00
Ln
00
0
- rn �
�
C) r-
�
00
—
�n M
O 01,
kr)
0
V'j
- 00 M fT
1p
0
U
00 k
p U G.
z m u
� o
(]a U
O
�,
Ursa
69
O ^
N �
O O
11
' -f) O
M N
M
kn
69
I
00
N
00 M
00
Ln
0
M "t 't M
N
69 69
69 69 69 69 69 69
69
I
69
N
Y
O
z
0
0
0
U
p U G.
z m u
� o
(]a U
O
�,
Ursa
cd
F.
U
c
In
VD
N
_T o0 00 Q, 0, 00 c, w o0 O1 0\ 01
N O O O O O v)0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0
Cl
V1
O
� V N O O O`i M .--� r- .--� r- M N l� �D W) M r O D2 00 O
�--� �--� N N �--�
1� y
�O �0 O O O Oa,O N O O O D1 O w vl 0 0 0 Q\ O
N 01 M o0 o0 V 7 r- olO <D O O O�
H N M M kn O O �--� N N ON N �O r- 01 Oti .- O W N M M
O O O Cl Cl '--� O �--� �--� 0 0 0 0 0 0 --.-� O� 0 0 0
0.
2
00 N 7 �O N �O M �O v) M DD N O �--� t v) r-� O O
a
U
Y
C
Cl
y
M N N N 7 N N N N M N M
N
�n
Nkn
N
Q.-t'.'
N
0y O y +0+ N
y EzzzH yy+0tiN"N FNfNge
Hz zz^yz 7 z
•.fir V
O T
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
o 0 m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
o c
b �
N N M 7 4t N t` 00 00 �O O 00 00 00 v) v) O do O ll- I'0 N O
�O �O V 7 � v) � V1 QD .--, � v) 00 00 vl v) .-� �O 00 l� d' N O
V
�
l�
N N N
N
-
M h M M O v1 O 00 W N �C 7 Q1 7 W 01
0-ItO
7 v) v1 00 M r- �O O M N al V O M N O
-It
0\
00
00
co
M v ) M O O O 10� vl vl r- O Q1 00 .--� N0,l- M O V
o0 O v) cr N r• V �O o0 D m O .: �O a, vi �c Oi r- 4 l- w
�c
01 O O 01 O v) 0 7 0� N 01 M N 01 V 01 00 r- 7 M M
kl M v) O O 7 O 00 �D O 7 N r- v) 01 v)
7
M
M
EA
69
v) v) O O �t v) c7N v) -Zt O o0 Cl DD O O) m O v) O �O v) 14D w)
00
v)
�n
l� v) M knr- v) 00 O \O v) N 7 M 00 O v) In M O
`O ocN 01 M N M 0\ V V 00
O,
W
00
W) lO O w vV � v1 m --� Qi l- 01 p m 'O cV vj i W) l- t`
m
d=
<t
�--�
O 0� O O N V N O 00 O O r� a1 N ON Cl 00 M .- m 3 O
v) [� O v) v) vj M v1 � 01 Cl 00 �o O V N n 7 a,
r-
O
O,
M
011
M
o
b9
69
OO 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
00 0 0 0 0 0 O O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O O O O O O O O
O
O
-
O
O
O
O
O O O O O O O O O O O O v) O v). 0 0 0 0 0 0 0 0
-- O O O O O�) 0 0 0 0 0 r- O N O O O kn O O O O
O
O
Cl
Cl
O
v) 00 O M v) O 7 O 7 O 00 l� O N r- v)
O
V
7
�
N
i3.
69
69
N
O O O O O O O ON N N N" N N N N N M M M
O
Q
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 Cl O O O O O O O O O O O O O O O O Cl O O
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
00 00 M 00 N U n .-• O v) O O C1 0) 0, O, O O\
ON
O
N N N N N N --� --� O !::� OR 0 0!7 '- O
N
N N M v) g r` � - N 'o 'D O, 0, 0, O N N --� M 'oa'
0 0 0 0 Cl 0 �--� �--� �--� 0 0 0 0 0 0 0
O
N
_T o0 00 Q, 0, 00 c, w o0 O1 0\ 01
Cl
Q O O O O O O O O O O O O O O O O O O O O O O O
a� 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
� V N O O O`i M .--� r- .--� r- M N l� �D W) M r O D2 00 O
�--� �--� N N �--�
O
H N M M kn O O �--� N N ON N �O r- 01 Oti .- O W N M M
O O O Cl Cl '--� O �--� �--� 0 0 0 0 0 0 --.-� O� 0 0 0
0.
Cl
a
U
Y
C
Cl
p
N
H
N
0y O y +0+ N
y EzzzH yy+0tiN"N FNfNge
Hz zz^yz 7 z
•.fir V
w
U
m l- r- M 00
[-C14 [- kn N
M M V1 O d'
00 00 0; �c .- M
b9
00 0 0 0 to
M 00 U M 7
O D\ C` N M Q\ M
M N — N N
O o0 V �D O 00
00
r- N �o 00 7 CN
l- N M r- ll- 00
N 1,0 Ln N Wn Irq
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M '-W) '- 0, O
N O N W)0, N OW) O O r- V1 C, �o v1 O O r
o0 o0 01 O l -t Q\ r' n V M r- O O V1 r-� M
C MN (7,M
o0 l0 7 O O
[� Oi 00 cV � 7 r- N d' r- 00 V 'D
V M00 r
O
N N N N V M N N N N M N N�
M
CC
�--
.-�
:;
O, '- 01 V r -
Q1 Q\ O\ a, O1
b9
N O DD .-� W o0 N cn 0; � N O ID O O
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
00 N �M 10 V W) O r0 Q\ 00 O 00 N
o 0 0 0 0
0 0 0 0 0 0
b �
O M �c �D r'- 10 1100 �O N l- V O, O N N 00 o0 M l- Q,
O O �--� O Q\ 00
0 cd
'- ,..- — — -- '- '- r- N N N — M N �-- N —
.-� ,-- O O ""
I 1.0 o0 N
N O
W
.--
N
r 7 V Wn 1.0 �o V N 00 w O a r N C` 00 00 00
O 00 O In M
— — — — r- — — — — — '-+ ,--� — .--
M M r Vl r MI'D O N�— N O S
r- N W N C>
.�
01 N h M O N'C O O M r- '= - 'r - M
-
lO O N 00 o0 --
l O w Q; O IC w <t N_ w vi In l� O_
O O vi
�c 00 N o0
N
V�
,-- .-- .-- .-+ .-- .-- r- r- — — — r- '. '. N
r- 00
64
�
6R
m l- r- M 00
[-C14 [- kn N
M M V1 O d'
00 00 0; �c .- M
b9
00 0 0 0 to
M 00 U M 7
O D\ C` N M Q\ M
M N — N N
O o0 V �D O 00
00
r- N �o 00 7 CN
l- N M r- ll- 00
N 1,0 Ln N Wn Irq
N
Q 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
M M M M M M M M M M N M M M M M M
<I' r`
O O OCD O r- 0 0 0 O O --
\o V1 r- r- v1 r- l� r- 00 00. 00 N w 0� T 01 T
O O O O O O O O Cl o 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 Q, O V1 N [l- In w Cl m
O C N N CO CD 00 N 0 0 7 CO 7 Q>
Cl 0 0 0 0 0 0 O O O O
C
O � rn rn � � ti ti cn uJ vi
zzzzzzzzzz
co i+ 3- N Sr H - 1- N '- t
� F F F F F -F F F F F F
H CO vi rri vn v) vi cn vi vn vi
�:) �D O �D �D �:) �D
CIO
O
z z z z z z z
H H H H h H H
viv)vauovivoC�n
�:) O �D �:) �D �D �D
N N M M d'
N N N N N
(= O O O O
N N N N N
00 C"', Ul .n- 1") --�
V)00 00 r-
" O Cl O
00 00 0, 0\ C,
O O O O O
N N N N N
Vl o0 00 r O
O 0 0 O
N
b9
bH
EA
P-
O M o0 I'D N r- 10 M '-+ r O w O N 10 00
00
O 00 O b7
M
eF O'D O
D1 N M U N Ul O M O� 00 N DD 00 ID= '2 ,,
M N O .-- 7 �n v1 M l� N V l- In �--� 0�
t
--�
r N DD N O
O r o0 oc
�--
.-�
:;
O, '- 01 V r -
Q1 Q\ O\ a, O1
N O DD .-� W o0 N cn 0; � N O ID O O
M
�C -- kn O O
cn
�F <t V� V of
In N DD D\ O O� l� ao O � O Ct IO � w 10 Oa
�
I 1.0 o0 N
N O
W
.--
l� ,--� M r--1.0
N �D In N In
U
— — — — r- — — — — — '-+ ,--� — .--
l�
00
N
64
b9
00 0 0 0 0 0 0 0 0 0 0 0 0 0 O O
Cl
O 00 �--� Q\ v1
M
Cl Cl O O O
0 0 0 0 0 0 0 O O O O O O O O o 0
O O O O O O O O O O O O O O O O O
0
O
[- Noo N O
�D o r 00 oc
r-
•--
O O O O O
O O O O O
O
0 0 0 0 0 0 0 0 0 0 Cl 0 0 0 0 0 0
Cl
I0 '-. In O o
w�
W1 V1 vi cn O
kn 0 0 Cl 0 Cl Cl 0 V) O O �) O vn Cl O O
�O 'n vl r nM M N Q1 Q1 v1 Vl V1
O
O
�o oo N
M N O
o0
--
r -M r- r-
N 'm In N V1
N
N
r-
o0
R.
F
oo�
N
Q 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
M M M M M M M M M M N M M M M M M
<I' r`
O O OCD O r- 0 0 0 O O --
\o V1 r- r- v1 r- l� r- 00 00. 00 N w 0� T 01 T
O O O O O O O O Cl o 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 Q, O V1 N [l- In w Cl m
O C N N CO CD 00 N 0 0 7 CO 7 Q>
Cl 0 0 0 0 0 0 O O O O
C
O � rn rn � � ti ti cn uJ vi
zzzzzzzzzz
co i+ 3- N Sr H - 1- N '- t
� F F F F F -F F F F F F
H CO vi rri vn v) vi cn vi vn vi
�:) �D O �D �D �:) �D
CIO
O
z z z z z z z
H H H H h H H
viv)vauovivoC�n
�:) O �D �:) �D �D �D
N N M M d'
N N N N N
(= O O O O
N N N N N
00 C"', Ul .n- 1") --�
V)00 00 r-
" O Cl O
00 00 0, 0\ C,
O O O O O
N N N N N
Vl o0 00 r O
O 0 0 O
N
b9
bH
EA
P-
OOOOo <D C)�)0000vO�nWnOOW) n o
00 V3 O (71 N OO� O t- V1 O O O O t- t- W) N `O --�
' O 7 �n 00 Q\ N M M 7 �n 00 1p N 00 N l- l-
6A 6A 69
o O o 0 0 o O o 0 0 0 0 0 0 0 0 0 0
O M O1 O M m 7 00 oo -11,' N N r- tI -11"' In t= 00
l- �O m M °� �--� D O O M -- O, 00 O N N n M h Ul O In
N m N N N N N N
O O\ t- O O\ O 01 M N
p M d' N CD h N M�t C, 00 t- M 'O �t V Vl O t-
n �O l� t� � O oo r- d' 00 N O� oo nV
O O t- t` vi m O; �o N oo 7 O, N vi r- oo t` N m
� O O O h O m V 'o M �-+ (= w)M t� t- �O V C- m t -
V'1 O ,-. 00 wn oo T O t- t- O O N O t- t- t- oo O
N N v�
69 69 fA
V1 l� 00 Cl t- OO wn O O O t- O O V1 w) �O V ON
�p oo V oo �n r- v� �° r- O 01 O N N O M r- �n
O lc O N O N N lr 7 F N M O
l- °� l- V oo l- Vi °, V O �O O; w� O N zt �c t- 00 "t 00
M 011 O\ �n oo oo M N N' O -� O\ � w V] � 7 N O �o
0 rl 00 00 O t- r -O O � N O� t- t- t- 00 O O kr
U'. -: -zj- 'r '. ,-: N
Qq 69 "S
il
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 O O O O O O O O O O O O O �--�
D 0 0 0 0 0 0 0 0 0 0 0 0 Cl Cl w) O
V 0 0 0 d' <= O Ln M O O O kn O V1 Wj W) O In �D t-
N kr� O 00 00 a, O t` t` O O Wl N O t` t` t` 00 Oti O+ �O
0.
69 b9 H9
N
N N N Nm M M M M
Q N N N N NC:) 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
00 Ol V It +n In �O M M I:Yl M �C N
O O O O O Cl O O O O O 0 0 0 0 0 0
N
c�0
Q
r- t- 00 0_0
t- 00 00 � 00 00 ON O1 O ON O, O, O1 O� ON
O O O O
O O O O O O O O O O O O O O O
«S
vQ
kn N M
N M t` 00 �O M M W) 01 kn 01 t- �N
O
� 00 a1
O O O O
In M O 10 �n M o0
O O Cl 0 0 0 0 0 0 0
a
0
U
°3
z
°
o
°o U
c
°
y
°
lu o
° U p
a
00
U ° 2 °5 o z °� U Z Z
Z o 0 °'
aa) U t'
>
°' °
U
c°'i
2o° Z Z
° Z
`? o Z Y u°
on °
�' A
Q
Q
^ U U
O
o w
u
Uy o
pa u o� U °
N 3
UZxr. 8 pz�-Z�x
U w
a, .� s, � � � Z
as i
a� U x > 0 an
coo
r�
uEn -dm W oaUF° a1d��
gum
to
to
N
Q
3
o �
w
Q
.a
b
c
�
0
0
bi)
>
•�
Q
W
N
M
M
M
M
M
M
N
N
N
Cd
69
69
a
�
U
M
N
M
N
69
69
3
o �
w
Q
.a
b
c
�
U
Cd
bi)
>
•�
Q
W
�
M
M
N
N
a
3
o �
w
Q
.a
b
c
�
U
Cd
bi)
>
•�
Q
W
O
U
v�
» # # # r
2 \ f Cl Cl g f
\ \ e
\
\
�
\
Gll� Gn GO,) CAI CAI a
\
Q
00
/
a
%
%
—
/
ƒ
�/
/ %
00
00
r r
=
00
\
a
m
Gn
/
_
m
_
\
\
�
\
Gll� Gn GO,) CAI CAI a
\
Q
00
/
a
—
ƒ
0000
/ %
00
00
00_
a
m
Gn
\
\
�
\
Gll� Gn GO,) CAI CAI a
\
Q
00
/
a
—
/ %
00
00
\
\
�
\
Gll� Gn GO,) CAI CAI a
\
Q
00
/
a
OWN
N a3
N
cd
N
►]
Y
O
U
N
M
Q
►]
m
��molo
d' N M O t=
W1 M 00 L` O
N N — N
N o0
69 69 69 69169
69 69 69 69169
O O 10
l� M
N N N o0
69 69 69 69 69
:�T�
0 0 0 0
N N N N
N M M N
N c
E E E E
Y
o
zzzz
V1 Y+ Sr 3--i Sr
CIO CIO cn C/3
69 169
69 69169
0
O
N
69
69
Y
0
H
w
Q
N