HomeMy WebLinkAbout042120-05.3ADMINISTRATIVE STAFF REPORT 5.3
TO: Mayor and Town Council
SUBJECT: February 2020 Month End Treasurer's Report
BACKGROUND
April 21, 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 February 2020:
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2019
Cost Basis
January February
31, 2020 29, 2020
$76,518,151
1,233,441
2,136,881
$79,888,473
$76,722,153
1,043,983
2,044,398
$79,810,534
Market Value
January
31, 2020
$77,576,474
1,233,441
2,139,080
$80,948,995
February
29, 2020
$78,194,830
1,043,983
2,047,664
$81,286,477
$85,244,089 $85,098,706 $84,729,781 $84,586,035
There were no purchases for the month of February 2020.
There were no purchases for the NERIAD Fund for the month of February 2020.
Maturities for the month included one Federal National Mortgage Association Note for
$509,675 and one Federal National Mortgage Association Note for $795,855.
Maturities for the NERIAD Fund for the month of February 2020 included one U.S.
Treasury Bill for $195,022.
The Town's net cash position changed from $8,185,113 to $9,694,645 during the month of
February 2020. This consisted of operating revenues in excess of operating expenses of -
$161,775, net funds invested of $1,305,530, premium/ discount recognition of $9,448 and
interest received of $32,779.
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 February 2020 Month End Treasurer's Report.
Prepared by:
Lani Ha
Finance Manager/ Treasurer
Reviewed by:
Joseph A. Calabrigo
Town Manager
Attachment: February 2020 Month End Treasurer's Report
February 2020 Treasurer's Report 2 April 21, 2020
IE5
N r- M kn O O =
[-
a, It) M O O In
O
C�
O m
0 0 0 0 0 0 0
0
O C1 M O
00
000
N
w In kn Cl kn
O
O
00 r 00 M oll
` O
M
v1 N �O N — oo O
o0
l� It�
--CN
M
8
69
N M 1p M 00 M
69
N to o1 N - I:T N
00
N N ,--
r-
00 00 kn r- Vl O — 01 I M
,It \O 'IT — 00
r-
�n
O
C�
O m
0 0 070
O C1 M O
00
000
N
o �
O
r
M V'1 lO ^� ON
00
69
69
0
o O It o 0
0 0
00000
00
�o
0 0 0 0
o kr
O;
O o a, r- O
It 110
\0
CD r` \�O N 'IT
00 O�
00
N -I:i O;
N N
-
[�
69 169
N O N vl r` kn N DD N O
N
N N
O
C�
O m
0 0 070
O C1 M O
00
O
�
o �
b
M V'1 lO ^� ON
00
cn
A W U d U Z A
N O N vl r` kn N DD N O
O
N N
O
C�
O m
0 0 070
O C1 M O
00
O
�
- O M
00 O M
M V'1 lO ^� ON
00
69 11,111
Gn
>, A Oovo o 0 0o r` �
0
0 N ~ O
co
O
H
M
O
O�
o0
O
O
v')
0 0 0
O O1
0
O
O M O\ Vl
l-
00
\ O
\O
\
\0C1
01
O\
O
M 00 \O O1
r
O
V1
V
O
F"
O O
O
O a d
H
O
00 O\ n O
W
M
�n
vi
C0
\O \D
N
W
N
M kfi N
\O
Con
C()
V1
M W)
O\
dP�w�Uya�
ON
uU
01 Vl CN
M
011
O�
qlT �
v')
kn
U
O M O\ Vl
l-
00
\ O
\O
\
\0C1
01
O\
O
M 00 \O O1
r
O
V1
V
O
F"
O O
O
O a d
H
O
00 O\ n O
W
M
�n
vi
C0
\O \D
N
W
N
M kfi N
\O
Con
C()
V1
M W)
O\
dP�w�Uya�
ON
uU
01 Vl CN
00
U
Z
H H Z
N
Cd
U
N
N
00 ,--� •--�
,--i
[�
00
69
69
60)
69
69
69
69
69
M
01
O1
00
ON
CN
M M 01
00
\O
\0
O\ M
N
N
k/1 00 \O N
M
01
n
00
--� 01 Vl 00
Vl
M
V'1
V'1
N \O
00
00
N M W) 00
O
V)
V1
M t!1
00
00
N ul 00
01
6s
69
6s
69
69
bis
es
69
M
all
O1
O ,--i
-
,--i
CYl M O1
00
00
\O
\p
O M
M
M
I'll 00 \O M
N
O\
V1
kl
' O O
O
O
\O O\ n
Cl
M
kn
�
V'1 \p
OS M V'1 .--i
O
kn
V)
M Vl
01
01
\fl R7r V'1 O,
\O
00 O lI- N
cl\
SII 60�I60"II 64, ISI ",II to!� 1 SII
N
CC
ol
U
W
U
o
O
m Cd
Cd
O
F"
O
0
O a d
H
U
W
> O
bA V]cn
H o
O �
C0
C0cn
W
U
Con
w
QW
dP�w�Uya�
uU
U
Z
H H Z
Cd
U
Cd
U
v�
N
CC
ol
rn
F."
N
r. O
0 4 N
ro O a;
A � N
y� O
O �
0 P5
w
H
69
r r r r r r r kr)N
r
' 00 00
c-�
M
[� V1 N
It[�
00
00t
M
�O 00 O
z .--�
O,
V'1
O
h
O� kn
ON CN
O
N
O o
tn
r
m O1
M 00
O�
00
kn
O�
s9 c>9 t�v
c-�
M
O
[�
�
O
�
N
r
m O1
M 00
O�
00
kn
O�
Qq
ss 6s
s9 c>9 t�v
c-�
sR
0 0
0 0
z
00
all
O� kn
O
kn
O o
tn
ro ro
U Z
O O
rn �
Qq
ss 6s
s9 c>9 t�v
c-�
sR
0 0
0 0
z
O o
ro ro
U Z
O O
rn �
Q� Q
N N
bq bq
ro ro
bq by
0 0
O O
ro
U
o
'Cd
ro
c
C
00
O
U
ai
ro zz
N
th
ot L
ro
'C
L�
th
w w
t
CO
c
M
D\ vl 7 0 DD O 00 O T O\ O wl O�c v'1 �D U1
[- In w O I v'1 N V M w O V1 W) M O
M N M cl - --� V of 00
l� vi M U O l- O� vi '-i M �D N h O 00 Vi7 v'i I� [-
--� O O N 7 N 0 00 O O [- C\ N 0� O o0 M 7- , �--� O
p O v� v1 vl M �O O O 7 C\ 00 � O 7 N l� 7 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 O O O O O O O O
O O O O ul 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0
M
O
O
0 0 0 0 0 0 0 0 0 0 Ul O V1 0 0 0 0 0 0 0 0
O O O Cl W) O O O O O l� O N O O O Vl O O O O
O O O Cl ON O N O O O CN O 00 v1 O O O (0\ O H O
m
-It
-It
o0 ocn a �D �D 00 r` 00 O � O O Cl �--� O
O
O\
Cl
N �D M W) v'i M DO N O t v1 r- 'o O O
�
M
M
w
M N N N "t N N N �--� N �--� �--� M N M 7 M N M
M
N
N
a�
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 aAi
6A
o
0 00000 0000000 0
m00000000000000000000
0
0
0
0
'b
M 7 N l� oo [� O 00 � �t U1 vl O O l� �o 7 O
V V 7 V1 Q, W) 00 .� O\ In 00 00 W, �D 00 r-. V N O
[�
iG
ti
cd
N^^ — �--� N N �--� N N N �--� �-+ M �--� N N N N N
N
H
ld
�D 00 w) V1 l� 'D 00 I- [� O\ 00 00 O\ D\ 00 O\ 00 00 O\ O\ O\
U
00 M r n M O "D M 7 00 t W) V M M 00 N m g
00
U1
Vl
o0 N N M�c V'1 � Vl r r� M m�
r
00
00
ol0 no(0 N [l �--� .--- cl --� M
(71 N IO r
O 7 O M N 00 �D v1 �D O 7 O v1 10� [� N h --� 00 r-
G r
00
O vl Vl Vl M Ul l 0 7 C 7 0 00 r- O Vl M l� Vl of
'.
N
69
6A
D\ vl 7 0 DD O 00 O T O\ O wl O�c v'1 �D U1
[- In w O I v'1 N V M w O V1 W) M O
M N M cl - --� V of 00
l� vi M U O l- O� vi '-i M �D N h O 00 Vi7 v'i I� [-
--� O O N 7 N 0 00 O O [- C\ N 0� O o0 M 7- , �--� O
p O v� v1 vl M �O O O 7 C\ 00 � O 7 N l� 7 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 O O O O O O O O
N
O
i N OJ
bDOzzz zzzzzzzz�- zzzzzzzz
as as
a Ga CG as p� m 4 oa CG as CQ Cq f� oa
xw�U5
ww
.bwwwww
w
69
ca
O
P
7
0000
41
M
O
O
O
O
O
O
N
O
N
a,
N
V
O
O
N
O
N
O
M
O
6H
79
O
p
O
N
O O O O O O O O O O O O O O O O O O O O O
N
Q
7
0 0 0 0 0 0 0 0 0 0 Ul O V1 0 0 0 0 0 0 0 0
O O O Cl W) O O O O O l� O N O O O Vl O O O O
?
O U1 Ul v1 M V1 �D O O V O o0 l� O vl N [ O\ Vl
C.
a
Q N
cF.
4"'
O
N
Q
0 0 0 0 0 0N N N N N N N N N N m M M
N
N N N N N N NN 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 aAi
M W N C, [- �D 01 C,
rn
cd
rn kn �D [- - N �--�--� 13,
y
�-+
O O O O --� --� .� �--� 0 0 0 0 0 0 0 �--� �--� �--� O O O
iG
ti
cd
N
H
ld
�D 00 w) V1 l� 'D 00 I- [� O\ 00 00 O\ D\ 00 O\ 00 00 O\ O\ O\
Q
N
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 N N N N N N N N N N N N N
M � Vl l- M N [- Z Z in w) l- O o0 o0 O
(71 N IO r
O O 0 0 0 0 0 0
N
O
i N OJ
bDOzzz zzzzzzzz�- zzzzzzzz
as as
a Ga CG as p� m 4 oa CG as CQ Cq f� oa
xw�U5
ww
.bwwwww
w
69
ca
O
P
7
0000
41
M
O
O
O
O
O
O
N
O
N
a,
N
V
O
O
N
O
N
O
M
O
6H
79
O
p
O
N
O O O O O O O O O O O O O O O O O
O
00 7 0 l- �O
M
M [- r� M 00
[-
W N N
N O N V) O\ N O U) O O [- Vn O\ �o W) O O
[-
V) V) V)
M N r- M V)
N
•� y
00 00 U O 7 O\ n V) ll� M r O lD O hr-
M
DD
r
M M V) .--� O
V
N
l O� O1 00 N O�� 7 V [- N r W V 'O
M l O O --�
7 Cl) Qi O
00
00 00 U �o
M
[- 7 v) n
�--N N N V M N N N N M cV
4
00 M O O O\
m
C14 N N [, Mm M
N v) kr N V) M N O\ O1 v1 v) vl
�n
N
v) 7 M �-• lt* V N N N 00 O1 V 7
C
_M
�O �n M N'
M �O 7 00
O\
�O
7 M lO --t o0
n N 7 00 r
N �O kf) N V)
X
- - - ,--i ,--i - '-+ - - - -
U �--i �--i - .--i - - - - - - - •--� �--� ~
Y9
- 10
ON
69
0
0 0 0 0 0 0 0 0 0
0, 00.00000,0,0°00001
0
0 0 0
00000���
0
0 0 0
00000l,l
0
00 N �O M �o 7 V) O S T 00 00 1, O 00
N
7 7 O) O
M
M 00 O1 M
V)
O O O O O O O O O O O O O O O O O
O M �O �D [� �O �O �D N l- � O� O N DD M �
O,
O O V) O
kn
O D\ n N 0,
M
yrt
^- �-. ----- N N fV - M N �--� N
- O O
M N- N-
N
N
h 10 r.- N N w 00 O, M D\ O O r c, 'n
N
O W v)
O� ID o0 vl
N
C
W N N
O
'CF N M V) N l" 00 M N O\ M O IO-+ 00 l-
00
00 M �--� �--� O\
7
M a N C V) M [� N v') V ll U)
M O\ O 00 00
W O\ M
V)
O M v) O
N O 00 )o 00 00 N N W) (71 -It N O� O O
M
M l O O --�
r- Vi M r-
O1 N O O 7 7 N v) M W) Vi 00 7� M
7 0 0 0 0 0 0 0 V) l-
I-
7 7"t O,
[- 7 v) n
V
00 M O O O\
m
C14 N N [, Mm M
N v) kr N V) M N O\ O1 v1 v) vl
�n
N
v) 7 M �-• lt* V N N N 00 O1 V 7
C
_M
�O �n M N'
M �O 7 00
O\
�O
7 M lO --t o0
n N 7 00 r
N �O kf) N V)
X
- - - ,--i ,--i - '-+ - - - -
U �--i �--i - .--i - - - - - - - •--� �--� ~
- 10
ON
N
V9
6R
O O O O O O O O O O O O O O O O O
O
69
w)
69
O O O O O O O O O O O O Cl O O O O
O
O M 00 �O N [- �O Ml- O 00 O N 00
Do
O W v)
v)
C
Ka, N M O\ N �/') O M O) oo N w w"D 00
r
�-+
00 M ol-IT
Ch r
M a N C V) M [� N v') V ll U)
O M
O\ O� O\ 01 O`
N O 00 )o 00 00 N N W) (71 -It N O� O O
M
r- Vi M r-
V
7 7"t O,
N DD ON O O\ rl 00 O � V �o -It 00 �o C\
7
� v) M N
m
r- M n �c
v) 7 M �-• lt* V N N N 00 O1 V 7
C
w r-
7 M lO --t o0
N N h
U �--i �--i - .--i - - - - - - - •--� �--� ~
- 10
ON
N
V9
6R
O O O O O O O O O O O O O O O O O
O
O r- V)
w)
O O O O O
O O O O O O O O O O O O Cl O O O O
O
oo M--� mV
O O0 O O
C O O O O O O O O O O O O O O O O
O
O M U) O
"R
O O O O O
O O O O O O O O O O Cl Cl O O O O O
O
r- v') M [-
V
w) v2 w) V) O
V) 0 0 0 0 0 0 0 In O O w) O Wn Cl O O
O
�o U) M �--� N
m
n �--� M r 0`
� n� Wl M N� V) N Vl M N 01 D\ n n n
O
7 M V o0
�
N G h N V)
,-. - - - - - - - - r-",
0.,
69
69
N
0 0 N N N N M M M
N N M M 7
Q N N N N NN 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 O o0
M M M M M M M M M M N M M M M M M
N
'It N 00 C7N O ,= M O\ O N M 00 �- kn O
kn 00
O O O O O O O O O O O
0 0 0 0
V) [- l- l- DD o0 00 l- w D\ O\ O\ O
O O O O O O O O O O O O O O O O O
0 0
O C, C) N N N W) O O O N O
77! ZZ N N ~ M U U
w N O O�
--� --� O O 0 0 0 0 0 0 �--� �--� O O O O O O
O O
N N_
b 'O
GJ Y Y N 7J N +0+ ,0+ +0+ Y N N Y N GJ N N O O
o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c V,
�z zzzzzzzzzzzzzzzz
ro z
V) V) V] V] V) V) V) V) vi V] V] V) V) V) V] V) V) W al
�3 �:) �So- 7- .3 �D �D �D rte-
� U
00 00 O\ T O\
O O O O O
N N N N N
U) 00 00 r- O
O O O O
O
M
u
a
0 o O o o O o O o 0 0 o O o 0
O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o
W N W) In� 0
O o
O M V1 01 O --i M M lO V 00 i� m 0o I>
M �--� °� eO N 0 N [� M � � O V1 O
N -+ M M N M N — N N M N N N N N N N
N w V (71 00 O N N N M �O M V 00 C, 7 r O 00 kf) O
M N Oi r- DD 00 7 0 M 00 N �O �O N �o 01 M
n oo N o0 7 v N N W M O� 7 O N O 00
O O N O o0 M DD n M 00 7 ON GM N 00 7� 01 V
It (= .-� [� O �--� M � � M N O l° � 00 n r- W)
00 00 O\ O r O Okr) N O n n r- 00 O M --�
oo
b9 69 6A
0 0 0 0
0
o O Wn 0 0 0 0 7 0 W) In O O v)
00
00v)Oo,N
ornorknOOo- Ot--C-W) or.n
V M N
--�
v1 [-- O l� M °� 00 O Vi N O l� °i O Oi
o0
M
y
N N N M
O
N M N N -� M N- N-
O
U
d
M
69
ss sA
69
69
0 o O o o O o O o 0 0 o O o 0
O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o
W N W) In� 0
O o
O M V1 01 O --i M M lO V 00 i� m 0o I>
M �--� °� eO N 0 N [� M � � O V1 O
N -+ M M N M N — N N M N N N N N N N
N w V (71 00 O N N N M �O M V 00 C, 7 r O 00 kf) O
M N Oi r- DD 00 7 0 M 00 N �O �O N �o 01 M
n oo N o0 7 v N N W M O� 7 O N O 00
O O N O o0 M DD n M 00 7 ON GM N 00 7� 01 V
It (= .-� [� O �--� M � � M N O l° � 00 n r- W)
00 00 O\ O r O Okr) N O n n r- 00 O M --�
oo
b9 69 6A
�--� W) [- 00 =
�D 00 �--�
r- ) W) �° V 01 M
O r- O O W) O O O O O V'
00 v) r- l- O O' O N N O M n
N N n V N M O� N r- --
[-- Ci [- V00
M O\ C\ M 00
n v -i Oi t O O� 'n O N � � � w -'F N
w M N 7 O kn 00 V') �O It N O�o N
C
N V O, O ll
DO 00 O r r- O O V N T l- l� l� 00 O O [-
va
ss sA
O O o 0 o
o O O O o
Cl o O O O O Cl o 0 0 0 0 o O O O Wn
0 0 0 0 0 0 o O O O O O o O O O v
a�
q
0
00000
o 0 0
00000000vi00000C)Inm
o o n n o 0 o n o n n n o n opo
N V) O •--� ol
0o O r n O O11 N O r n r oo 01 17 o0
ro
W
q w N
3
N
O Cl
N N N N
N N N N M M M M M 7
N N N N N N N N N N N N N N N
O O O O O O
N N N N N N N N N N N N N
h
00 C1 V V) V1 �° V1 .\-� M OOH M �° N
0 0 0
sy,
ti
H
N
cd
[- l- 00 00
[_� 00 00 [- 00 00 O\ Q1 O) ON 01 °\ 01 01 Q1
q
O O O O
O O O O O O O O O O O O O O O
[O
kn N �C M
N M [� oo O, M O, V) C1 w) O � O)
N�
F+
7 00 U
V) w) M O O1 �O : V [-w)M 00
0 Cl 0 0
a
O
U
0
°
o
Z
w
Z
C
Z Ion. ZZ
U ° °3 cZ U ZZ
a°iU
w
�q ���
o°' Z Z z�' o yZ
��
>
cn
t.SpH
Z B . `° U `° U w -, C)
p o
i
q
3
o
a°i w
x1 v o
v oU oZ
oE8b
oS ° Uw ow -sem
'w
ca a`i ani v
-6°
p U u. w do PC
o a
Uv�wald�xlOaUF- D W d�
°
Ux1ga
o
cl)
q
00 I 00
0 0
0
0
rn
M
M
•�
�
N
M
00M
A
a
M
M
O
6s
N
0
°
° o
O
69
69
00
0000
cl
O^
°
en
cn
U
O
O
69
�
00 I 00
0 0
m
rn
rn
M
M
•�
�
O
O
A
a
69
6s
0
°
° o
y
c�
p O m
0
°
a
A
�
U
i.+
a
w
Q
a
°
b
°
a
w
Y
N
A
H
�
N
is
CJ
bOq
co
o a
U
v�
m
O
U
0 0 0 0 0
o
a1 O o O
kn M N oll O�
M = N N �10
00 N N N kn
69 1460S
kn M N C1 C\
M 00 N N 110
oo N N N n
--i ke) M W) W)
Cl) M [-
6s s9'i
m
M 00 N N IC
00 N N N n
--� kn
69 69 69 6AI69I
kn
V'1
69
O1
00
N
cbn
a
a �:,
a
O O O I O
M 00 r- C1
N
N 1.0
69 69 69 169
V1 M O 01
in 00 t-
00 a1 N
N
69 69 69 169
O O O O
O O O O
O O kn v
69 69 69 169
M M N
bb�
� N W)
69 I I I
69 169
O � O
69 69I69I
O
69
H