HomeMy WebLinkAbout051920-05.3ADMINISTRATIVE STAFF REPORT 53
DANV
TO: Mayor and Town Council May 19, 2020
SUBJECT: March 2020 Month End Treasurer's Report
BACKGROUND
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 March 2020:
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2019
Cost Basis
Market Value
February March February March
29, 2020 31, 2020 29, 2020 31, 2020
$76,722,153
1,043,983
2,044,398
$79,810,534
$76,328,185
1,026,619
1,729,507
$79,084,311
$78,194,830
$78,125,266
1,043,983
1,026,619
2,047,664
1,735,824
$81,286,477
$80,887,709
$85,098,706 $85,072,567 $84,586,035 $84,908,260
Purchases for the month of March consisted of one Federal Home Loan Bank Note for
$1,560,525 (maturity date March 8, 2024), one John Deere Owner Trust 2020-A A3 for
$369,977 (maturity date August 15, 2024) and one Federal National Mortgage Association
Note for $1,808,052 (maturity date February 5, 2024).
Purchases for the NERIAD Fund for the month of March 2020 consisted of one Federal
Farm Credit Bank Discount Note for $46,945 (maturity date June 12, 2020).
Sales before maturities for the month included one US Treasury Note for $325,469, one
IBM Corporate Note for $744,165, one Honda Auto Receivables Trust 2018-2 A3 (partial)
for $14,319 and one Honda Auto Receivables Trust 2018-3 A3 (partial) for $8018.
Maturities for the month included one Federal Home Loan Bank Note for $1,017,230.
There were no maturities for the NERIAD Fund for the month of March 2020.
The Town's net cash position changed from $9,694,645 to $7,671,324 during the month of
March 2020. This consisted of operating expenses in excess of operating revenues of
-$522,660, net funds invested of -$1,629,353, premium/ discount recognition of $8,203 and
interest received of $120,489.
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 March 2020 Month End Treasurer's Report.
Prepared by:
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: March 2020 Month End Treasurer's Report
March 2020 Treasurer's Report 2 May 19, 2020
EA
M N�t = V') O l- [-
-
M It
00 O M \O
o0
01 �t —� 00 t
rl-
�
O kr
N_
N [- l'- N r
o0 N
�p [� N
a'".� cid
m
l- 00 .-r r --'t 00 O
r n �--� 0� 00 N
N N
69
O O N \O O
O O
O O M \o O
O O
O --: l-� O
O kr
N_
a� co U
>, O O •n
o0 N
�p [� N
a'".� cid
v� b 00 y U
�WUdUZ��D
69
69
N
9
Q
N
tw
\O
N_
a� co U
>, O O •n
LISoA ... v v 0 0 0
Q C
C8
O
a'".� cid
v� b 00 y U
�WUdUZ��D
1
0 0 0 0 0 0 0 0 0 0 0 0
00 kn l-- O O
N
tw
\O
N_
N O In lr O n ' W) l �O
>, O O •n
\C It kn -n M rl O N
00
N
tw
Cd
'
>, O O •n
O ,
1
k
�
M M _ ool�
00
N N M
s
;
3
o
0
H
0
6911 691 +e,
000l�
Cl
kn
69 l 10,1 l
In "- N d
16s
0
00
01
M M
vi �O O vi
W
U
o
00 --G
O
� �
69
69 69
01
M M
00 �
110 110
00 O 00
C C
N
00
O
� �
69
69 69
U F
d rn
cu
V1
llc
00
C� O
M
00 \p O
l�
6911 691 +e,
000l�
Cl
kn
69 l 10,1 l
In "- N d
16s
0
0
69
U
U)
vi �O O vi
W
U
o
00 --G
t—
00
Q
4
oA
00 �
00 O 00
4
00
00
m OItil
N
O
U F
d rn
CA
M N
00
C� O
M
00 \p O
l�
U
U
d
w
z
cd
U
c
U
0
0
69
69 I 69
z
M
Cj
vi �O O vi
00 --G
t—
00
00 01 M
00 �
00 O 00
4
00
00
m OItil
N
O
69
CA
M N
00
C� O
M
00 \p O
l�
69 I 69
z
U+
M
Q
Q
O
N
O
't
M M O �
00
,--�
ti
O
0
V�
V� C- O
N M N V1
N
m
U
O
O C 00 \1
110
kr 'ct l N 00
N
"I
t
O
00
1.0 O
V M 00
N
G7
O
th
cp
69
C\
v)
I p I I 'n
Q
oN0
n
0000
�
Do
Q
00
00
00`
00
F^47
00
�
N
Z
69
bg
J,
Om
kn
v?
N
v7
N
U
L:
00
M
�O
No
+, N
A c m
H
4.
soq
N U
En
M
[� N
O kn O r M a\
N_
�n
�O i -r
V1
N l�
1p �0 m M O 00
00
sN
.--i N M N ,t
O
N
�\C O
N N
N�
vNi
N
wr
W) m 00
M t� o -,
m
0
F�
cin
6s s9 ss
s9 s9 (,4 I.S sv ev
Is
ss
U+
M
Q
Q
O
N
O
z
N
ti
O
0
z
0
Y
o7. ' U °y' o o>
�cc
U
=
Q
t
w U
to
G7
a
U+
z
o
0
cl
0
o7. ' U °y' o o>
�cc
U
=
Q
t
to
b
as
th
O O O Wn 0 0 0 0 0 0 0 00 0 0 0 00 0 0 0 0 0
O O O 01 O N O O Cl 01 O 00 )n O O O O1 O O 7 Vl
M
00
O
'
O
.� V
O l0 cl00 rl 0, l � o0 lt� r- 00 O 10 O O O
01
Q1
N 10 M W) 10 W) M 00 O M N
00
M
Cl)
M N N N 7 N N N N M V Cl) N
N
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
H9
0
fi9
b �
V't N [, W 00 O 00 7 00 Vl V) O V O l- 'D 7p C-4
00
7 V V)01 Vl 00 -. 01 h 00 DD V) V1 .--� �o 00 l- V N O 00 00 00
7
O
N N O O
N
p
V) �o W� 00 �c 00 h r O 'ch O
700 r• 7 �. 00 W)10 N N 7 7 O m V a1 00 7 w
N
N
v)
00
V1
00
N 10 N M n S O DD 01 O O
O
.--
--�
h V l> m 10 [o V O 0\ �-. �O v) O n [� O O1 M
'C
7
V
7
O O O Ul •--� 10 N m
M O1 v') oo 1D .--� .-. 00 v) DD N 00
N w
V O W (O1 Vl DD V')
NcoN
p1
M
M
,-.
N
69
6A
O 7 v1 0\ v) 7 O 00 O 00 O 01 M O V) O 10 vl �C h N
10 V) r- kn 00 O �--� 10 h N 7 M 00 O U) V) M O1) N
�--�
o0
o0
--� 01 M N M 01 .-. 7 -• 7 o0 �-. �--. 00 v) O [l lq --� M O v')
M
O1
vl m D1 O r- m v) M 1D N w) O w v) 7 In 1� [-- o0 O
00
V
7
O O N 7 N C) 00 O O [- m N 01 O DD M 01 �-. O O 10
(O1
G
V) )n M 10 a1 O V 01 o0 1O O 7 N l� 7 01 Vl oc
•cO
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
69
O
O
O
O
69
O
O
O
O O O O O O O O O O O O O O O O O O O O O O
O
O
O
u
0 0 0 0 0 0 0 0 0 v) O V} 0 0 0 0 0 0 0 0 0 0
0
O
O
O O O V) O O O O O l- O N O O O V) 0 0 0 0 0 0
M V) 1D O o0 r- O V) N [� (1 Vl l- n
0
O1
O
O
V
N
a
❑qq O
Cl
N
V
Q
O O O O O N N N N N N M m M V�
N N N N N NN N N N N N N N N N N N N N N N
O
N
G
O O O O O O O O O O O O O O O O O O Cl O O O
N N N N N N N N N N N N N N N N N N N N N
O
N
O 0.F..
G
Q
ooc14rnr-= )noLf) o010 cO1 rnMCo CD C1knoo
o,
F•
rn
O
N N N N 7\ '. O7: !Z 7 0 0 0 • 0 0 . O O O
In �o 10 1O O1 01 01 O N N M N M
N
V
c
C.
O O O -. �-. �--� �--� 0 0 0 0 0 0 O O O O O
O
y
H
[-�
N
Q
o0 n wn [- �o o0 [- [- 01 o0 o0 m Q_1 o0 01 o0 o0 01 01 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
rq
O
r/O
cO
N N N N N N N N N N N N N N N N N N N N N N
O 01 M l� n n M N r- 10 10 V) V) r- 8 o0 o0 O 7
N
O
U
M
M '. N N N -. Z- N '• O N O -• N N �l• N r• N O
w) O O �-• N N Q1 N • 7 '1D n 0) 01 o0 N M M
M 10
M
O -• -• -. O -• -. 0 0 0 0 0 0 �--� �--� O �-• O O O O O
O
a
U
o
U
ti
G
a
En
O
O OO O 2. N B +O0
15
O�
�z
Z Zz%ZzZzz zzzz0z
.dwwwwwwwwGL��W
wwwwwww�Trwwwww
w
O
U
O
O O O O O O O O O O O O O O O O cd
O
01 V 00 O M
�o vl O M O
W)
In 01 10 N O t -
0, 00 r-
--
7 M 7' V1
CD N �c M lc � Vo O r- O, W 00 O 00
N
Qt
O O D\
M
69
M W O1 M
O r �--- Q O
b �
O M �o �D L- ��0 �o N l- 7 � O N 00 00 M n
17, a1
�D O 00 �o o0 00 V N vi 0; 7 N O �o O O
M DO V 01 Ln
O 0� ll N
- 00 ONO
0 O
O 0
O �o V V 0, 0,
N V [- .--i o0
.--�
O O O O �--�
I
M N ^ N
M vi --- 7 M �--� V V N 7 N N 00 M 7 7�
N
--� --� C14 N N N V M N N
7 M M
U — — — .-. ,--i — — — — .-. — — — ~
N
U
N O -zt 7 - n O 00 p vl 00 N O N
M
01 7 00 O M
7
l- ID In n O N
w
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
01 V 00 O M
0 0 0 0
0 0 0 0 0
0
In 01 10 N O t -
0 0 0
0 0 0 0 0 0
0
0
7 M 7' V1
CD N �c M lc � Vo O r- O, W 00 O 00
N
Qt
O O D\
M
69
M W O1 M
O r �--- Q O
b �
O M �o �D L- ��0 �o N l- 7 � O N 00 00 M n
17, a1
�D O 00 �o o0 00 V N vi 0; 7 N O �o O O
M DO V 01 Ln
O 0� ll N
- 00 ONO
0 O
O 0
O �o V V 0, 0,
— ,--i — — — — — — M N '-+ N �--�
.--�
O O O O �--�
o
M N ^ N
M vi --- 7 M �--� V V N 7 N N 00 M 7 7�
7 M M
U — — — .-. ,--i — — — — .-. — — — ~
N
U
N O -zt 7 - n O 00 p vl 00 N O N
M
01 7 00 O M
7
l- ID In n O N
w
O O [- 00 m r
a00,
vi MN O
0,
m o0 7 Oi vl
.--�
N N_ l� [- Vl M
00
rl 'n 'n V m O� M 01 �o �D [�
M N M M N h N v'> M N
�D
�o M l�
M
[�
�o M l- r- �D
M
N
69
69
69
a\ M= 'n N [" 'o M l" O W O N �o 00
r
O O O O O O O O
O O O O O O O O O O O O O O O O O
01 V 00 O M
-It
M 00 V 0\ V1
In 01 10 N O t -
N M a\ N Vl O M 01 00 N w w 10 w
r
7 M 7' V1
O N S 'n r-
N
Qt
n a\ a, V l- l-
� 01 N O --� V� v1 M� N M 7 n v1 -• a\
69
O r �--- Q O
M
O 00 � U 01 U
�D O 00 �o o0 00 V N vi 0; 7 N O �o O O
[�
M DO V 01 Ln
- 00 ONO
0 O
O 0
O �o V V 0, 0,
N N 00 ON O 0\ r DD O �o � 7� 00 �o 01
.--�
\C, 7 M l� t
o
O O M [� O
M vi --- 7 M �--� V V N 7 N N 00 M 7 7�
7 M M
U — — — .-. ,--i — — — — .-. — — — ~
N
1.0
[�
1 11,11 1 loll] I
O Cl 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
F, N oo8
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
�o
V1 0 0 0 0 0 0 0 0 Cl 0 0 0 0 0 0 0 In
M 00 V 0\ V1
N 0 0 0 0 Cl 0 0 L 0 0 vn O Vl O O O l-
�o 7 M [- 7
M N M N M N V'1 M N 171 121 Vl V1 l0
7 M 7' V1
N
Qt
69
69
O O O O O O N N N N M M M
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
N N N N N N N N N N N N N N N N N
00=
M M M M M M M M M M_
- 00 ONO
0 O
O 0
O O O --� 0 0 0 0 0 �--� O O
7J
00 00 00
Q O O O O O O O O O O O O O O O O O
N [- cn 00 O 0� oo � 7 Ol a+1 - M
�---� --�
Z Z 00 N O O 7 �o O�
0 0 0 0 0 O O O O
O
N N N N N N U N NI
zzzzzzzzz
F~ -
V]
�5 �D �D
r00 N O O O O r)
00 O O O O I I'D
�D 0� O O O O �o
O �D vi vi O O
Co O M I4 In [n
N 1,0 Ul N ul M �
N N M M "It
O O O O O
00 N Vl Vl N V1
N
V1 00
O O O
O
DD 00 � 01 O
O O O O o, O
N N N --
CD
O 'zt
0 0 0 0 � 0
M Q Q
Q M N U
N o0 y O�
N
N
F O 0 N O C
�CZ
Ln
Ln
b d H
cQa ca cd Q Q Q
O O O O O O O '/1 0 0
00 Ul O W N O 0� O l- O O O �--i O n n W' N 10 1D [-
N O 7 '/1 00 0\ N M M 7 00 1D N o0
t` O [� Oi 00 O Vi N O [� O. O 01 7 0
N N Nm O .-� N M --� N �--� M N N 00 V1
d � N
6H 69 69
0 0 0 0 0 0 0 0 0 0 0 0 0 0
O o o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O M M W 10 V 00 N i` i` 7 7 l� M
01 O O M 01 0o O N N [� M Ul v-, O In O
--�--� N N N m m N N
N O_ N r --1D N vi oo t -et w M O m m
M 1D o0 oo 0\ O M N V [� 1D
p a, N N N M 01 O 01 1D �--� 7 M �t 1D
vi M oo N
1D _7 10 O� O_ M 7 00 n N o0 1D [� 10 00 O vi
O N 00 O N V1 M m 'n O 'D 1D o0 700 7 N
r n 00 p1 --�
00
69 69 6F3
Vl [- 00 = Or- O O O O O r-- O O Vn W) It t V1
00
1D 7 --� --� w vn r V1 r-- O� O N 0\ N O M w
O 1D O N O N N �n V 1D N M �D 01 �--� 1D N
n Oi t` -It 00 1D [� V1 O 1D 01 V1 O N 7 1D [� 00 O DD
M 01 01 v1 00 --� 00 M N <= 01 In 00 v1 10 7 N O N N
N N 7 01 O ll 00O� N 01 [� l� [-- oo O M M
0 0 00 0
Cl 0 0 0= 0 0 Cl 0 0 0 0 0 0 0
0 0 0 0 0
0 o
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00
O o 0 0 0 0
a
00000
0 0 C 0 C 0 0 C C rn
0000000vi000000In00
Ca
o
�
d
0 OWn0o0W�oW) W) V -,0=W) '.
.2
�000�
00 D\ O r O O h N O r n 00 a\ N M
O 0 0
G O U O U
z ozz
U o °� cz !�U
p 0 z 'Z' O z
O
a°i w
°
.0
+
2 ° 0 Zi Z �.' A u N U
Z0�
69 69
i J2Z
Q c3 "Ca
-00 0
0
U
b�
ai
z�U
u '
U " o o d
0 0 0
zv5x
p O
O O N
O N N N Nm M M m m�
V
Q
N N N N
I
N N
N NN N N N N N N N N N
p
H
�
O O O O
N N N N
O O O O O O O O O O O O O O
N N N N N N N N N N N N N N
ani ani a"i
SSS
0 U w �a v ani > CG
uAaz.w¢wo"avF°-�w¢3a
N l V
.--i 7 U
O N
10
o0 01 Ul p 10- M 01 M N
N O N N O N
ti
cd
Vl 01 .� 7
00 Vl 00 v1 In Q1 V') 100
F.,
c
O O O O
0 0 0 0 0 0 0 �--� 0 0 0 0 0
y
G
cd
N
F"
Cd
[- l- 00 00
l- 00 00 l- 00 as 01 01 01 01 Qi D\ 01 01
Q
O O O O
_
O O8 O O O O O O O O O O O
N
N N N N
N N N N NQ N N N N N N N N
V'1 N Z M
N M r-- 10 01 M m w) (ON Vl 01 r T
11 00 p1
vl -11, 7 M O O\ 10 7 l- wl M 00
O O O O
0 0 0 C) 0 0 0 0 0 0 0 0
O
U
°z
z
0
0
o
�
d
.2
O 0 0
G O U O U
z ozz
U o °� cz !�U
p 0 z 'Z' O z
zz
a°i w
°
.0
+
2 ° 0 Zi Z �.' A u N U
Z0�
i J2Z
Q c3 "Ca
-00 0
0
U
b�
z�U
u '
U " o o d
0 0 0
zv5x
o'er
v o U Z
° U
ks o �u. °w�
d a0i
oA
c
Q �d
ova W� 0 o Y o
�
d
a
ani ani a"i
SSS
0 U w �a v ani > CG
uAaz.w¢wo"avF°-�w¢3a
xy ani
f70
gu�D
\ j
k
/
\ /
H
o
2
\
;
&
�
�
7
ƒ
f
%
o
_
@
»
2
_
_
\
3
3
a
�
a
79
\ �
�
\ 0
E
\
�
\
/
3
3
H
o
2
\
�
�
)
;
5
I
�
\
m
®
a
79
\ �
�
\ 0
_
_
�
d
0
2
E
\
�
\
cu
1
04
/
w
H
o
2
\
;
5
I
�
\
®
79
\ �
�
\ 0
U
�
cu
1
04
000 vl N
,4 k M O
M �t
� 69
V)
M (2\ kl) O\
00 I N lO
~ kn M O
M �
69 69 69 69169
69
00
N
bbcqsP.
b
r-� O O O
M C1 kr)M
01
O\
cd
00 to N
-- kr M
O
O
69
69
69
000 vl N
,4 k M O
M �t
� 69
V)
M (2\ kl) O\
00 I N lO
~ kn M O
M �
69 69 69 69169
69
00
N
bbcqsP.
C,
C� a, 0-1
o
Q N
N N N
O OLn N
O
O
W)
N
a
c
bbb
cd
� o �
C�
C1
o
y
o
`rG
i
aY
1 1 1
"
F'j
69
69
Y
O
U
cqj
a
N
Q
Cd
69 69
O O
O O
'ch �
69 69
O
N
O
N
N
0 0 0 to
NMO I
MOD t --:OSI
N
M 01 00
69 69 69 FA
m M O
V V') 00
00 0� N
.. N
es 69 69 E4
(= O O O
O O O O
O O v"i cn
69 69 6R X69
O O O
O O O
N N N
Vn kn O
W) --i M
00
W) 00 �
0 O
C� a, 0-1
Q N
N N N
O OLn N
.si M
W)
a
bbb
� o �
o
y
o
i
aY
1 1 1
F'j
0
zzz
LTy
N
Cd Cd Cc
G�
N
aw
w
�
0 o I�I o
69 6AI bgI 69