HomeMy WebLinkAbout061620-05.04ADMINISTRATIVE STAFF REPORT 5A
TO: Mayor and Town Council
SUBJECT: April 2020 Month End Treasurer's Report
BACKGROUND
June 16, 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 April 2020:
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2019
Cost Basis
March
31, 2020
$76,328,185
1,026,619
1,729,507
$79,084,311
$85,072,567
April
30, 2020
$80,073,938
995,617
1,787,459
Market Value
March
31, 2020
$78,125,266
1,026,619
1,735,824
April
30, 2020
$82,043,624
995,617
1,792,838
$82,857,014 $80,887,709 $84,832,079
$89,709,571 $84,908,260 $89,562,047
There were no purchases for the month of April 2020.
Purchases for the NERIAD Fund for the month of April 2020 consisted of one Federal
Farm Credit Bank Discount Note for $101,432 (maturity date December 21, 2020).
Sales before maturities for the month included one Honda Auto Receivables Trust 2018-
2 A3 (partial) for $19,336 and one Honda Auto Receivables Trust 2018-3 A3 (partial) for
$40,071.
Maturities for the month included one Mitsubishi United Financial Group Bank Limited
Discount Commercial Paper for $1,394,185 and one US Treasury Note for $1,326,919,.
There were no maturities for the NERIAD Fund for the month of April 2020.
The Town's net cash position changed from $7,671,324 to $14,197,582 during the month
of April 2020. This consisted of operating revenues in excess of operating expenses of
$3,620,427, net funds invested of $2,780,511, premium/ discount recognition of $3,901 and
interest received of $121,419.
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.
RECOMMENDATIO
Accept the April 2020 Month End Treasurer's Report.
Prepared by:
Elm
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: April 2020 Month End Treasurer's Report
April 2020 Treasurer's Report 2 June 16, 2020
0
H
0
00 0 0 0 0
00 tT N vl O O --
N N O O N N
fA
00 cn N oo O O = 't
V'1 �--i 00 V') �--i �--i
--� kr) 00 00
M 1.0
0\ Cl�
Iq C\
�O l� V)
00 N
N M 01 00
00
n
N
O l- It N
--�
N N —
110 O
fA
00 cn N oo O O = 't
V'1 �--i 00 V') �--i �--i
69
0
O
O
d'
N
M
O
N
00
69
00
M
o�
M
O
O
00
69
00
M
00
CO
O
00
VA
a)
O 00 [- 00
00 O
o\ V)
00 N
A
n
N
++
69
110 O
O
O O 000 kr)
O O
O O lr N
O O
O 00 DD
v (� s
a,
�O
M O� cn
00 N
E� cd W �, '+J O
69
0
O
O
d'
N
M
O
N
00
69
00
M
o�
M
O
O
00
69
00
M
00
CO
O
00
VA
0 0 0 0 0 0 0 0 0 0 0
e
M [— W) kn O
N N —
1.0 �o It M r r %lo O V O
,It M C)allMall O M N
O N Vl C� �t M I- m cn "T
110 O O O� t— W) It w o�
oo W) V1 M N C, (7� — 00 to
M — — N M kn M [— 01 N
69
C> kn
¢'
0 `4 c kn ob
O
0
O
H
a)
A
n
N
++
W b 34
�A
Cd
\
v (� s
as ¢ O co sV, .0 '� O
O
E ~
E� cd W �, '+J O
to
�WUdUZcn
0 0 0 0 0 0 0 0 0 0 0
e
M [— W) kn O
N N —
1.0 �o It M r r %lo O V O
,It M C)allMall O M N
O N Vl C� �t M I- m cn "T
110 O O O� t— W) It w o�
oo W) V1 M N C, (7� — 00 to
M — — N M kn M [— 01 N
69
C> kn
¢'
0 `4 c kn ob
O
0
O
H
Cd
0
O
o I
69
0 4= v l o
�
0
O O
O O
110 110
"DMI�
4 X t` d1
C1 - [- 00
69 I69I
69 I69
0
O
O
69
t`
w
69
cn kr O N
O Obi � � OMO
00
N 00
00 (`
N
E -
U
�
H O
o
t- ON O o
O C� IZ
51, ._
Q
4
00
00
to
Q C%
cn
Ncr
w
z
0
O
O
69
t`
w
69
cn kr O N
O Obi � � OMO
00
N 00
00 (`
N
E -
H O
t- ON O o
O C� IZ
ON
00
00
69 I 69
DD ll O� F �
O Vi O 00 �D
O O0i " 0000
O N
00 DD
U
N
E -
H O
Q
F°HQz
z
N
cc
P.
_
§
\
���7
, ,
kk
k
k
Cf)
N
k
/.
rq
2
® a
0
ƒ
/
77a
\
7
\
\ $ \-,:l
/ /
/
j
§
f
/
$
n
®
d
_
_
_
7
§
\
, ,
N
k
/.
2
® a
2
00
0
\
0
0
\ $ \-,:l
/ /
/
j
§
f
/
2
n
_
_
7
§
\
, ,
N
N
/.
® a
¥ 4
0
\
0
0
\ $ \-,:l
/ /
/
j
§
f
/
2
n
.§
k
\
_
k
e ®
_
�
§ 0
—
2{R
022
\�00
��7
k�
k
k
m
/
o
It mcr
Cd/
q
Q
7
G
@
/
$
k
/
-
__a
__
_
_
7
§
e
® a
\
80
\ $ \-,:l
/ /
/
j
§
f
/
2
n
.§
k
k
e ®
m
91
£
Cl O O Wn O O O O O O o 00 O O O o0 0 0 0 0 0 m
O O O O O N O 0 0 ON O w vl O O O Q, O �D O g vl 00
10 10 00 o0 r, 0� lD l0 o0 7 `1 n oo O lc O O O O Q\ 7
7 M N od
N N 7 N N C14M N od N4 n 0 M N M M O O M N
69
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O o 0 0 0 0 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0
V 7 N O 00 � 00 �O o0 00 v1 v) 0 7 0 l- '0 7 0 C 00
00
7 <h V1 Q\ Vl 00 a,vl 00 00 V1 h \O 00 r__ 7 N O 00 W 0 O
N N N N N M N N N N N O O N
wC,
00
w 00 00 0 V
00 O O 'O r_ --i — 7 r_ .� �O o0 cl �D
J O O O� � N 7 m 0 VMj V � M O 000 �0 000 0M � M
V1 M �1 O O ul O 00 l� O Ul M 00 Vl Q� V'1 00 V1 Q\.
n
r N
G
b9
O O O O O O O
W z Z Z z z Z, Z %. �. Z Z Z Z z �. Z �. z Z Z Z z
.b www ww www w w w w w w w w w w w w w w
w
O v'1 p, v1 O a0 O W O O1 p, O W) O �O vi �0 v'1 N V1 v1
�O W) �-. r- vi 00 O �O vi N 7 M 00 O 'n v� M O �n N
.r Cl M N M O\ o0 lr O l_ �--� M O Vl
O
Vl M--� i O [�
ti
O
O
O V'1M M O "It 17, 00 O O N V1 00
U
N
&I
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 O Cl O O O O O O O Cl O O O O O O O O
N
O
0 0 0 0 0 0 0 0 0 ul O kn 0 0 0 0 0 0 0 0 0 0 0
Q
O O O V1 O O O O O [� O N O O O vl 0 0 0 0 0 0 0
V1 V1 M ul 'O
O
a�
p 0 F�" M
id
O O O O O �--� N N N N N N N N N N M M M V 7
a
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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 4
N N N N N N N N N N N N N N N N N N N N N N
O aQi Q
• F;,
00 N 01 r- W) O In Cl �c D Q, O, C, O, O O, Ln w
m
Ul D r-- 'D 'D m Q, m
O 0 0 0 0 0----�--� O O O O O
7
O
H
H
N
id
DD v'1 v_? [_- �c DD n [� U DD DD m pN 00 c, 00 00 T D\ O O O
Q
O O O O O O O O O O O O O O O O O O O O O O
O m M r- vn [- M N l-- �o D n n l- O o0 00 O t M
O O O O O O O
W z Z Z z z Z, Z %. �. Z Z Z Z z �. Z �. z Z Z Z z
.b www ww www w w w w w w w w w w w w w w
w
M 00 V) N [-- �D M [� O 00 O N 1D 00 00
N M O\ N In O M M 00 N 00 w w w V) V)
O\ N O �-• t Vl V) M l� N h 7 l- In �-. 01 [*
O DD I 00 00 7 N V1 O\ V N Cl �O O O I O
N 00 U 00 O 1D 7 "o 7 00 10 O\ T
0 V1 't M �--� 7 7 N V N N 00 01 7lll 7 O
14
N
O
y,.
R
W
Q
O O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O
O O O O O O O O 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 vl O O Vl O Vl 0 0 0
•I N N N N M M M
N N N N N N N N
N N N N N N N N
O Cl O O O O O O O O O O O O O O
N N N N N N N N NQ N N N NQ N
r.C) C> C> C> 00 - -o CD
M M M M M M M M M N M M M M M M
[- 00 Q1 M 7 Q1 O N M 00 V%1 O
O O O O O O Cl O O O O --�
Vl [- [- V) [- [- [l- 00 00 00 [- 00 01 01 01 01
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 NNNQ
( 1 O ) N [-- V1 00 O 01 00 t It O1 C1 M
, z M N N N !--� O !7 N O N O N !--
O 8 7 N N 10 �O o0 N< 0 7 10� 01
�--� O O �--� 0 0 0 0 0 0 'R 2 0 0 0 0
C
O ti rn � ti y v7 ti ti rn rn y ti y y y y
0 0 0 0 0 0 0 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
61)
O
O
O
O
O
N
6A
00 00 N [� [- N
7 N 00 \O V1 00
r 00 O [� I Vn
M 00 M Q1 Ni [--
10 7 O N V Q
M O1�
&S
00 00 N [- [� N
7 N 00 D In 00
M 00 M 01 N l�j
M 01 V
69
5 F.
00
V1
O O
N N
O 'ct 1D N O r--
In
�M O1
M 00 O\ 01 O1 01
V 10 M r 10 10
N V) V1 N Vl m
Vl 7 0 0 0 0
M D O O O O
1D In V1 Cl O
N V1 V) N V1 M
N N M M 7 7
N N N N N N
O O O O O O
N N N N N N
00 NN n n n n
Vl00 00 �Nr N 00
O O O O O
00 00 D1 Q. ( 1 O
O O O O O O
N N N N N N
N N ON O
V) 00 00 n O M
O O O O O
O1
O O O O O O O O O O O O O O Cl O
O
1D V1 O N [-
N
1 V M DD [�
--
_O
�o 01 1D 00 r- 1D o0 N
V1 O, N O vl O O [� V1 O1
O N � V7 O O
CO C1 O V O1 lD n Vl 7 M l- O 10 O V) r
Vl
Vl
7 M O �--� r-
M O
l�
iz
7
'n O, r M V1 O
M o0 Vl --� O �--�
DD
O
pC y
Oi Oi 00 N Oi 7 � r N V r- �--� 00 7 �D
M
01
O,
r 01 � .--�
V1
C Y
�--� �--� N �--� N N N 7 M N N N N M N
O
�
N
OJ
Q �
Nxxx0z
o
6A
69
69
6H
O
0 0 0 0 0 0 0 0 0
0 0 0 o a o e o 0 0 0 0 o
0
0 0
o_ o_ o_ 0 0
00
0
0 0
',
0 0 0 0
0
0
N 1D M 7 V1 O 1D Q1 00 00 l� O 00
00
O
N
M 00 01 M -
Vl
b
M 10 1D [- 10 1D 10 N r" It O, O N o0 M ["
C\
O O O O 1a
,-.
O O, r N 01 --�
--�
N N N �-. M N �--� N .�
O O O O �--�
M N -- N --� --�
N
M 00 V) N [-- �D M [� O 00 O N 1D 00 00
N M O\ N In O M M 00 N 00 w w w V) V)
O\ N O �-• t Vl V) M l� N h 7 l- In �-. 01 [*
O DD I 00 00 7 N V1 O\ V N Cl �O O O I O
N 00 U 00 O 1D 7 "o 7 00 10 O\ T
0 V1 't M �--� 7 7 N V N N 00 01 7lll 7 O
14
N
O
y,.
R
W
Q
O O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O
O O O O O O O O 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 vl O O Vl O Vl 0 0 0
•I N N N N M M M
N N N N N N N N
N N N N N N N N
O Cl O O O O O O O O O O O O O O
N N N N N N N N NQ N N N NQ N
r.C) C> C> C> 00 - -o CD
M M M M M M M M M N M M M M M M
[- 00 Q1 M 7 Q1 O N M 00 V%1 O
O O O O O O Cl O O O O --�
Vl [- [- V) [- [- [l- 00 00 00 [- 00 01 01 01 01
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 NNNQ
( 1 O ) N [-- V1 00 O 01 00 t It O1 C1 M
, z M N N N !--� O !7 N O N O N !--
O 8 7 N N 10 �O o0 N< 0 7 10� 01
�--� O O �--� 0 0 0 0 0 0 'R 2 0 0 0 0
C
O ti rn � ti y v7 ti ti rn rn y ti y y y y
0 0 0 0 0 0 0 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
61)
O
O
O
O
O
N
6A
00 00 N [� [- N
7 N 00 \O V1 00
r 00 O [� I Vn
M 00 M Q1 Ni [--
10 7 O N V Q
M O1�
&S
00 00 N [- [� N
7 N 00 D In 00
M 00 M 01 N l�j
M 01 V
69
5 F.
00
V1
O O
N N
O 'ct 1D N O r--
In
�M O1
M 00 O\ 01 O1 01
V 10 M r 10 10
N V) V1 N Vl m
Vl 7 0 0 0 0
M D O O O O
1D In V1 Cl O
N V1 V) N V1 M
N N M M 7 7
N N N N N N
O O O O O O
N N N N N N
00 NN n n n n
Vl00 00 �Nr N 00
O O O O O
00 00 D1 Q. ( 1 O
O O O O O O
N N N N N N
N N ON O
V) 00 00 n O M
O O O O O
O1
n O 'D O r 7 M [-- O V O 01 M 7
N
00 00 N [- [-
N
a1 V a, V1
N
_O
�o 01 1D 00 r- 1D o0 N
01
7 N o0 1D In
[� 00 O [-
00
Vn
'r--� N D\
O O 1D 00
O'
V1 V1 N O O V1 00 \O O O1 C� V M N O
O O O 1D 7 M 00 M O1 �c O n
10
N
M W M 01 N
10 7 O N
[-:
D\
7 7 O1 O�
V [- [- [-- 1D
V'1 N Vl M N Vl V) N Vl M N 01 01 V) n v'l
W
M O n
�--�
N Vl W) N Vn M
N
OJ
Nxxx0z
o
69
69
M 00 V) N [-- �D M [� O 00 O N 1D 00 00
N M O\ N In O M M 00 N 00 w w w V) V)
O\ N O �-• t Vl V) M l� N h 7 l- In �-. 01 [*
O DD I 00 00 7 N V1 O\ V N Cl �O O O I O
N 00 U 00 O 1D 7 "o 7 00 10 O\ T
0 V1 't M �--� 7 7 N V N N 00 01 7lll 7 O
14
N
O
y,.
R
W
Q
O O O O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O
O O O O O O O O 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 vl O O Vl O Vl 0 0 0
•I N N N N M M M
N N N N N N N N
N N N N N N N N
O Cl O O O O O O O O O O O O O O
N N N N N N N N NQ N N N NQ N
r.C) C> C> C> 00 - -o CD
M M M M M M M M M N M M M M M M
[- 00 Q1 M 7 Q1 O N M 00 V%1 O
O O O O O O Cl O O O O --�
Vl [- [- V) [- [- [l- 00 00 00 [- 00 01 01 01 01
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 NNNQ
( 1 O ) N [-- V1 00 O 01 00 t It O1 C1 M
, z M N N N !--� O !7 N O N O N !--
O 8 7 N N 10 �O o0 N< 0 7 10� 01
�--� O O �--� 0 0 0 0 0 0 'R 2 0 0 0 0
C
O ti rn � ti y v7 ti ti rn rn y ti y y y y
0 0 0 0 0 0 0 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
61)
O
O
O
O
O
N
6A
00 00 N [� [- N
7 N 00 \O V1 00
r 00 O [� I Vn
M 00 M Q1 Ni [--
10 7 O N V Q
M O1�
&S
00 00 N [- [� N
7 N 00 D In 00
M 00 M 01 N l�j
M 01 V
69
5 F.
00
V1
O O
N N
O 'ct 1D N O r--
In
�M O1
M 00 O\ 01 O1 01
V 10 M r 10 10
N V) V1 N Vl m
Vl 7 0 0 0 0
M D O O O O
1D In V1 Cl O
N V1 V) N V1 M
N N M M 7 7
N N N N N N
O O O O O O
N N N N N N
00 NN n n n n
Vl00 00 �Nr N 00
O O O O O
00 00 D1 Q. ( 1 O
O O O O O O
N N N N N N
N N ON O
V) 00 00 n O M
O O O O O
O1
M
Q
�o �Qoa
N N
OJ
Nxxx0z
o
OOooO O..oWnooO V OWnVnoov) v)C>
00 W1 O O� N O 01 O [- O O O O l— [-- v1 N �o �o l—
N O 7 h 00 O\ N MM 7 o0
O y V M N Vi l� O [� 01 00 O V'1 N O 01 O Oi m
p N N N M O N M �--� N �--� �--� m N 00 V1
C-4 kfj
6A 69 69
m
O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O M U1 O1 O m M m m 00 7 N r- In V V l> 7 7
�D M O� �--� 01 O O M 01 oo 0o O" " N [- M M w) O Ul O,
--� --� N N NM M N N (N N M N N N N N N
O. kf) N O O�D r 7 O [-- v1 7 O M O1 �t M In N' 7
O. m M 01 00 M l- So [� M W MC, Vl o, M O\ 7 00 10 N
M l— 00 D1 O O1 O1 O O O� Ul O --� [- llO O� lO
O g N O1 00 M O r- r- 01 00 l� M w) M �o 'o M oo N M
7 CD N oo O Nm � 7 N O %0 Moo 00 00 �o 00
N kf 00 00 01 O r- O O In N O [— l— [- 00 O1 G O
oc
00
H3 69 69
GUl r( =V �--�
�D oo 00 vl [— Vl l- O U o N Q1 N O
O
00 � r V1 D\ O 01 O N 7 10 r W O M
m 01 ON W1 00 �--� w M N 01 V1 00 V1 �o 7 N O N r -
C N V 01 O r- 00 00 fJ O1 [— l— [- oo O M O
oo
ss> s9 vj
O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cl O o0
O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o m
O O O o C C 0 C 0 0 0 0 0 0 0 0 0 0 0 0 00
00000 0000000v-,000000 v o
�000� o own000wnO�nknkno�n -�o
C • 00 00 Ul N O n r n o0 ON N O
CD
00
a
6q 69 69
N
N N N N m m m m M 7
Q 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
N N N N N N N N N N N N N N N N N N
ul ol 7 00 V ul 00 Vl Vl C\ 10
O O O O O Cl O O O O O O O O O O O
N
fd l- l� o0 00 [- 00 00 l� 00 O1 O1 O, O\ O\ O1 01 01 O1
Q O O O O O O O O O O O O O O O O O O
cO kn N ',D M N M n �--� D OO, M O� h In C� l� O�
VO N N :- N O N O N
i.. 7 00 �--� 01 \n V M O Q, 1D .--� 7 l- V1 m oo
O O O O O O O O 0 0 0 0 0 0 0 0
C4
C
O
U
a�
z z
o
Z
o ozz NY ug
ani �3 " ai z °' :' azi O ° b o U w
'Z• Z V fn Z
C❑Ei
¢ O Vi
pul) CO iC a~i
� �� ��aaaa aaoa,UH �D m¢3¢'
�a
4C
y
Q
U �D
0
2
;
9
� ƒ
q
&
®
\
ƒ
�
f
$
i
-
k
»
�;2
�
\
2
\
\
/
E
K
\I \
k
/
;
9
a
k
\
\
2
i
-
-
»
�;2
�
Q
m
\
2
m
Q
2
k
P
$
a
2
�
2
�
�
2
�
2
�
\
§
/
\
k
.§
4
a
U
�
k
/
O
U
,zT = �t
V) M O
N [— O
N M \-O
69 69
�O -
rl0
� � N a1
vi M O
69 69
IC M "t
k M O
N r- O
N M �O
69 69 69 69169
m H
U
CUC
U N
U U
C�
it
o
a a a
�HHH
'O bq o o
•'"www
w
Cd
U
w
a
00
7-2
N
Cd
Gr
O
o 0 0
0 0 0
0
O
0 0 0
0
'i
kn
N M O
M
V')
kr)
Vl n n
�7
c�
O O
4)
V1 kf)
00 M �O
�
kr) 00 � M
Cl
Q\ M C\
01 00 l--
00
O
N N
12
69 69 69
69 69 69
I69
69 69
69
U1 N Wn
M 00 [—
l—
00 V'1 M
V'1
I M S
ke) M O
o1
O 110 r-
--�
a�
O\ O�
V V') 00
l�
an 00 rl
Vl
�O �D
00 a\
N
M N 1
O
O
O\
M
M r- O
00
U
k N
\O
V1
69 69 69
69 69 69
69
69 69
69
Q
O O O
0 0 0
O
00 v') M
M
¢
y
O O O
O O O
O
O \D l--
[—
O
O O O
O O O
O
01 00 t-
l�
iz
[- O l-
O O tr1
Wn
M N \D
00
w
'IZT
O T
O 110 [l-
M
M [— O
00
y
N N
\C
�n
C
ti
N69
69 69
69 69 69
69
69 69 69
69
Q
i
N N
N O N
O
O O
O O
N N
N N N
N
M
id > Ih c,
¢ N
00
Q ~ O
M
O O
E
O
CL,>
N N
D\ a, O�
¢
¢
Q
N N
N N N
0000Cd
O O N
W)
Cd
Cd
N
O
z
bbb
EEE
o
>%