HomeMy WebLinkAbout061521-05.3ADMINISTRATIVE STAFF REPORT 5.3
�AIYV
Q,LE..
TO: Mayor and Town Council June 15, 2021
SUBJECT: April 2021 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 April 2021:
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2020
Cost Basis
March April
31, 2021 30, 2021
$85,711,987
1,202,427
1,709,445
$88,623,859
$91,833,988
1,204,601
1,707,209
$94,745,798
Market Value
March
April
31, 2021
30, 2021
$87,013,168
$93,094,389
1,202,427
1,204,601
1,708,864
1,706,443
$89,924,459 $96,005,433
$79,084,311 $82,857,014 $80,887,709 $84,832,079
Purchases for the month of April 2021 consisted of one U.S. Treasury Note for $1,000,352
(maturity date April 15, 2024).
There were no purchases for the NERIAD Fund for the month of April 2021.
There were no maturities for the month of April 2021.
Sales before maturities for the month included one John Deere Owner Trust 2019-B A3
(partial) for $24,831.13, one Honda Auto Receivables Trust 2018-2 A3 (partial) for
$15,533.60 and one Honda Auto Receivables Trust 2018-3 A3 (partial) for $32,357.87.
There were no maturities for the NERIAD Fund for the month of April.
The Town's net cash position changed from $17,663,349 to $22,857,712 during the month
of April 2021. This consisted of operating revenues in excess of operating expenses of
$6,041,412 net funds invested of -$927,629, premium/ discount recognition of $10 and
interest received of $80,570.
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 Towri s Investment Policy.
PUBLIC CONTACT
Posting of the meeting agenda serves as notice to the general public.
RECOMMENDATION
Accept the April 2021 Month End Treasurer's Report.
Prepared by:
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
1 *"-6f
Joseph A. Calabrigo
Town Manager
Attachment: April 2021 Month End Treasurer's Report
April 2021 Treasurer's Report 2 June 15, 2021
,
co N
O O
O
N
Cd
H
0
cn
UI
O O cM It
N kn N O O N O
It N
69
O O
00 10 �--� M
V'1
Cl O r- M
It
00 O1 r- Ot1r)
.--�
00 00
O O 0�0
'
00 01 N N
a\
M N
69
O O
00 10 �--� M
V'1
Cl O r- M
It
000 00 000
k4l)
10 kr o0
¢>Ell
00 N
o
,r -i N
69
O
2 Fri y N N
o
N
03
O C
O � 00
O
Cl)kr)
�
lq� o0
ll�
[� 00 N N
a;
M N
I.s
o_
N
0
C%
N
to
Cd
>>
o 0 0 r-� b
>
o
0
H
Cc
z
C),
bD
Cd
. 9A
3
wp
0
F-
¢>Ell
o
w cq3
bD
2 Fri y N N
o
N
03
bA .> .03 a� o
ca Q U O
+�
O
W pa N
E
v�b SO s,U
u
CO
� w U < u Z vn �:)
N
to
Cd
>>
o 0 0 r-� b
>
o
0
H
Cc
z
C),
bD
Cd
. 9A
3
wp
0
F-
its
N
c�
Ui
0
a
OIO
ISf�
691
691
0
O
:�
O s— s—
M Vn 00
M r-
eq
oo N r
00 � N
69 169
0
a
01 ,-- N -1 rA
00 O N N
r-1
U
�
o
01\C "Itr-
C—.
�-r
M
4^w
01
rT
�
N
�ab�Cd
Q W
w U
z
0
a
01 ,-- N -1 rA
00 O N N
r-1
M lO -tO
`t.
01\C "Itr-
C—.
Mch
M
4^w
01
rT
69 I vi
00 N l�
00
00 rq
8
01\C "Itr-
C—.
Mch
0o N N
i�-
�
W
bg
�
N
N
a
O
H�uz
w
rn
fA
.a
0
On
N
..
M O
O�
'n
N 0
M
rn
00
00
M
n oo
�t
M
O
0
cd
O
°O
^
F-
oo
y
0>
.�
O
00
cc
V
C�
kf)
0
GS
n
U
F�
n
2
H
1 00
00
00
Q
oo
59
N
00
Q
�
ct
�
n
ad
cn
W
N
cd
z
>.
Q
pp
o
M
01
Q
M
^
M
U En
a�
U
U
�
rn
fA
.a
0
O
M O00
N
kr)
rn
Q1
M
n V1
n
-4,
O
N O
cd
O
°O
^
�
z
y
0>
.�
O
kr
00
cc
V
C�
kf)
0
0
A
n
U
F�
�
0
2
H
cl
E
s9
59
yq sus 9S
59
rn
fA
.a
0
cd
O
cc
�
z
y
0>
U
O
cc
V
C�
cts
0
A
n
U
ou
�
0
2
H
cl
E
on
cl
�
U�
on
cq
ad
cn
cd
w
O O O N O 0 0 00 0 0 0 0 0 0 0 l- w O O o0 0 0 0 0 7 0 7 0 0 0 0
N O O O 0� O V) 00 V1 O O O ON O N V1 O �--� �O [� V) O V)
C>
4 N M N M M N
N rq CA
N
Q G
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o o 0 0 o 0 0
V1 r 'D 7 D1 V) M O V) 00 W [- N �O 'O W [- �O N �
00 "-' 01 M o0 00 ^ V) v1 �--' �O o0 n 7 N M M r) O M N N N N. N N N N o0 o0
b N CIA O N N O �--� M �--� N N N N O O O N O 0 0 0 0 0 0 0 0 0 0 0
O, w 7 M W) In Cl In M �o 00 M O1 00 r p
u ^" V) h� N --� 01 7 O N U Vl 00 M N M V) 00 O O V1 7 V) O O1 C)
M l- M <t oc00 N D o0 r M 00 �c V N M N O 'O 7 N l� 'C
V) .--i o0 N oo 01 O O O_ O � � � �O N V �o M O V) O� ,-: � O O O V 01 � N 'ch
N --� N 00 N O N Q1 r h 7 M N O �O O In O (71 O O, O V) ON a, O�o
�O O V t O Vl 00 r- O V) N r- V) U M ll V) V') M V) Ol V'1 00 �O 7 oc Vl
— ,-. ,--i — — — ,-. — — —
V O
00 ON kn V N 7 M o0 O Vl V) M V r Oa0 U V1 00 01 O N a1 '. v) N
w M �o W N V) O w V) V V) [- Q1 O oo r oo O 6 01 oo O
O o0 Cl l- 01 C� N D, O DD M01 N N a1 O O v) O D1 O DD D, v1 Oi a1 O 10
0 t O, 7 o0 O=N r 7 O� M 7 V V) M V1 O� V) w Vl 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 O O O O O O O O O O O O O O O Cl O O Cl 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 O O O O O O O O
O OO O O V) O O V) 0 0 0 0 0 0 0 0 lr O O V) 0 0 0 0 0 0 V1 O O O O
O O O N l— O O N O O O V1 O O O M N O O O �0 O O O 01 O V) O O O O
• ' f O V 7 O V) o0 r- O Vl N r- Vl 0' M n V) M V1 C� n Vl 00 ' 7 n [� h
— — .--4 — — — — — — —
y
C
O
> b N
C O
cCa N u r.
CC C, N fV N N N N N N N N N M M M M M M M M M M c, M M 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 N N N N
p M 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
+T+ 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 N N N N N N
C, ON Oi O V) N oo O, �0 Cl O 7 V o0 00 �O (� 7 v) W
H '\-. --� O N O O N .� �--� N O O O N O 0 0
O O O O O O O O O N N O 0 0 0 0 0 0 Cr- 0 0 0 0 0 — — N O O
4,
�N
a
N
H N
Q o0 [- l- O DD o0 O a\ O, 00 O, W DD a, a1 O O O O) O O O O O O O O O O O O
N N" s 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 Cl Cl 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 N N N N N N N N N N N N N N
oo V) O N O 7 w N N OO 7 O M 7 m V M
. Q 3 � .6 O N O --� N N .--� N O N O -� N O �--� O N O N O
H N N M 7 �D l� 00 Oi m : O w N M M Vl V1 B c - 00 oo Oi 01 01
a 0 0 0 0 0 0 C:l �--� O �--� 0 0 0 0 0 0 0 0 0 0 0
V
N
O
.0+ O Y Y O O O O .0+ O .0+ .0+
b00 �%. u u u u
��]. rZ Z �. U Z '7" Z. I. �. %. Z" �. U Z" O O z z z O �. z �. %. z z z O
IM ro 00
w
V)
O
000
V)
00
M
69
O
O
O
V1
M
00
M
bn
a
O
p
O
O O O O O O O O O O O O O V) O
O O l� vl 01 �O vl O O V) O O O DD O
ul
V)
'o') O 00 01
7 M r 'A
[--
O\
'O 7 r 01 DD r V
V7 r- r O 7
m
M
n7 M l� O �O O n r
�--� M
N V'1 �--� O �--� U
[�
y
N M N N N N M C',
00
N
69
yq
0 0 0 0 0 0 0
0 o 0 0 0 0 0 0 0 0 0 0 o e_ 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
O
O �O 01 00 DD n O DD N �O Cl M
N [- V 01 O N 00 M [- N M N V
O 7
O M
r
N
M 00 C1 m 7 [-
O O, r- N O\ M
O
[-
'b
N N N - M N 0 0 0 0 0
0 0 0 0 0
0
M N
y
M N 01 V) 7 O O1 w m DD 7 01 c" U1 m
M 7 O N m 00 kn O v1 01 O 00 <t O
00
'D O, %0 l� MN_
a\ O V1 �O 00
M V) �O 7 �O V1 00
--� 7�c O r M O
r
7
�O V � O (0 .. O �--� N --� n
-.
Cl Vl Cl
O1
vl 01 O l� n O
oo
.� n n N 00
�
vl O V) U M 7
O
,--� .--� r N n 7 Vl V O N 7 7 01
00 O,
O
7 01 [- l-
V M lD
V)
00
V m [� l- M
�-+ Vl N Vl M N
00
--
r.20
N
69
us
6q
M r- O 00 O N �O o0 w) N M M
01 W N 00 00 � m Vl Vl c:, �--� V1
N10
00
C1 10 l� M
O, O v1 � 00
N
--�
O N �D 00 O r- .�
7 O O, a, n n ul
M
M
M l� N V1 l, V1 '• 01 DD M 00 O Cl
17
O h � �. O
[�
V o0 Cl '. O� O\ O�
M
N
N 7 N O IO O O [- O 7[�
O 10 �D �O V o0 �O D1 7 O m V1 7 O
O
2
n n N00
, 01 l- [-
r
h
.--� V N O, m
V V'1 M M 'O .O
oo
V'1
N N N o0 D1 7 V V l� O O 00 O
M� lD
o0
--�
U-
- .-. - ,-. - - - - -
N
69
-
bA
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O Cl O O O O O O O O
O
O
M
O1 O V) o0
N
--� M O l� Cl 0 0
7" Cl 7 0 0 0
--
O O O O O O O O O O O O O O O
O
O\ v1 cl O
l�
7 00 O N 0 0 0
vl
O O O O O O O O O O O O O O O
'n O O O V'1 O O O O O O O
O
vl
l- l- N 00
7 O\ r- r-
r-
V7
7 V7 N O O vl
V) M M [- l- V)
00
w�
01 O\ [� O O Vl DD O
r
V M �O lD �D
o0
.--Vl N V'1 M N
--
t�
oo
cy
c i
Q
0.
N
N�
69
6A
6A
V)
ON
Q Gr. O
•-+ --� N N N N m M m M V -,I- V1 M 'n
N N N
W 4.i
O M
Q
N N N N N N N N N N N N
O O O O O O O O O O O O Cl O O
N N N N N N N
O O O O O O O
N N N N N N N N N N N N N N N
[~
00
OM M N M M M M ZZ M M
N �
ZZ 7! M
O� O N M 00 n 0 7 00 M 7
, .
y
O O O O O O 0 0 0 0 0
0 0 0 0 0 0
i-,
N
N
N
iO
o0 00 00 [- 00 a1 a, m O� --�
00 00 Oti D1 a1 O
Q
N N N N N N
O O O O O O O O O O O O O O O
N N
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 N N
td
O O� 00 t V O, m�--� M N V O� 7 N �D
N N N 0 0
ti
00 N O O V �D 7 MV N N m
o0 00
O O O Cl O O O O O O O O O
O O
Cl O O O O O
U U
'. In
O O
M
Cl O
<
N N
C b
M
M Q, M
Q
M Q
Q m rq U
N 00 n Q
00 0 M M M
Q Q
w tom.
H N
O Ncq
CH
lu
c-, N
O O O O
'a
'a
O O N N N
Q
o 0 o 0 0 0 O O O o o O O O O'er..,
=
Azzzzzzzz
z z z z z z
U U V pNp V N appp
V] v] v] C/) v] v1 v] v] v] v] v) v] v] v} U1
��D
�D �D �D �D �D �D�3:Z) ��
�33r� a
yxxx °zti
�
U
�
C
O
0 0 v'1 --� vc 7
O� O
U
C1 M N
O O n r- N �D � 7
N
O
N
O
O
M V DD N 00 N l- [- O M �D DD N. M
w
N --� 7
O l� O\ O w N O n O� O a N�c N
o `� p o 0
N N N N '-
Z,-
o
.2Z.0
U }; o E o o
z �
0
N
q
¢ G
0
°
Q
o 3 U o U H
69
yq bg
o
z -aUUU °J ib'ss
c
0 0 0
o e 0 0 0 0 0 0 0 0 00 o
0
•C
M
01 M M
M M 00 7 00 N l� rl-7 7 [I- 00 --�
O M 17,� O N N l� m M ul V1 C, O 7 V N
N O N
M N N N N M N N N N N O N --�
... cd
�ca¢�OaUH�a1¢3¢ °
U�D
�D
--' M
O l- Cl In M r- N M 00 O1
N
7 O
O\ 00 00 M O O M O, 00 O 7 'D 00
N r- O 00 N M O o0 v1 O l� O 00 M
�O 7
N o0 N O\ N w t
V)
O N �o M o0 DO DD V1 N M a,
--� M
r- 00 O 'D V O
69
69 6A
�n p 'D 7 M O w
l— In[� a, O N c N O .-• M� 7 00
4�
N N 7
n 7'o M"o 01 N"C�o v1 V O,
7 7 00
wi O, O a vl O N-,I� �6 n 00 7 vl M
N O 01 Vl 00
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 Cl O N
O
p
O O O
O Vi v1
O O O O O O O O O O O O O N
O Cl O O V1 0 0 0 0 0 0 vl O �o
ca
v1
O � O O Vl O v) vl Vl O to �--� N l—
•�
M 7
O l- O W) N O n r- r 00 O\ �--� r-
Q
..
�
69
69 6R
n0. _
N
C O
lu
Q w
N M--�
N N N M M M M M -It V
W O
WO
Q
N N
N N N N N N N N N N N N
p M
O O
O O O Cl O O O O O O O O
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
y
�G
i.,
�d
7
N
N
Q
00 O
O O
00 C'-00 a1 ON D\ O, O, p, U
O O O O O O O O O O O O
CN
N�c N N N N N N O O
M O, �o l� Vl M 00 M
O 0 0 0 0 0 0 0 0 0 0
C
O
U
N
O
N
O
.wr
o `� p o 0
Z,-
o
.2Z.0
U }; o E o o
z �
0
o
q
«; o z� o z p p �' o¢
z z o U U O
0
°
Q
o 3 U o U H
o
z -aUUU °J ib'ss
c
ar
El. c¢ 0 0 0 � j
2
oz��z�x
>
�ca¢�OaUH�a1¢3¢ °
U�D
�D
o
�v
00 00
O o
Q �
0
M
O
0
69
6A
69
d
Q
H
w
d
a
b
w
a�
Y
h
is
m
U
9
7
N
x
►m
O M O OIMI M
N N
i/, I b9
M 0 0 0 0 O
O O O O O O
7 vii O N N
7 O\
00 7 M
Vl l� M
M �
vj es
7 IC O N N
00 �t M
v1 l� M
M �
s9 aA
00 M
M �
69 b9 69 b:n I fA
rls
69
00
w
a
0000000
�o—r
r W) M o W)00
N N �--� N 00
00
M M
N
O �
.Jf.
69
69
69
0 0 0 0 0
0 0 0
0
�
O
M
b
O O O O O
O O O
O
-It O\ 00 M V
M V r-
[, l— M n V1
�.
O
V ON O • :-
00
N Ni Vl
oo
N NN W
V 7
N
CJ
X
44 49 4R o os
69 60,1
-
11
V O, w) N O
M 7 r
r-
r-11,
M
n 7
�
'V Oi [- O N
o0
M
ti
O
N 7 N V1 Vl
oo
O
7 7
l—
N
U
69 6q 69 69 65
6A 69
611,
11Q
O
O O O O O
O
Vi O Vj O O
o0 N •--
--�
7
•� ,u
Fz
N N N oo
V~
N
Q N
601 69 69 69 69
69 69 b9
6�9
a) -.
> °�'
O O O O
m
O" O
O O O
N N N N
EyO
id
O O O O
N N N N
Q
7 O opo O
oo ~ M
4
U
O
z
a
w
a�
o o
o
H
Q
°zzzzoj
�o
H uo on u) C6
W Q
�D �Z) �D
Saco
w
a