HomeMy WebLinkAbout031924-07.3TO: Mayor and Town Council March 19, 2024
SUBJECT: January 2024 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 January 2024:
Cost Basis Market Value
Town Funds
Trust Funds
Assessment & SA
Total Cash & Investments
Total Cash & Investments
Year -to -Year Comparison
2022
December January
2023 2024
$111,100,112 $112,141,776
1,766,793 1,786,006
December
2023
$109,837,362
1,766,793
January
2024
$111,131,169
1,786,006
1,535,840 1,975,596 1,542,178 1,982,925
$114,402,745 $115,903,378 $113,146,333 $114,900,100
$112,201,376
$113,939,494 $108,390,895 $110,603,900
Purchases for the month of January 2024 consisted of one Federal Home Loan Banks
Note for $999,220 (maturity date January 8, 2027).
There were no purchases for the NERIAD Fund for the month of January 2024.
Maturities for the month of January 2024 included one American Honda Finance Note
for $1,008,634, and one John Deere Capital Note for $614,564.
Partial maturities (principal paid down) for the month of January 2024 included one GM
Financial Auto Receivables 2022-1 A3 for $8,429, Honda Auto Receivables Trust 2022-1
A3 for $26,030, one Hyundai Auto Receivables Trust 2022-A A3 for $34,628, one John
Deere Owner Trust 2022-A A3 for $17,882, one John Deere Owner Trust 2021-A A3 for
$10,598, one John Deere Owner Trust 2021-B A3 for $15,998, one Mercedes-Benz Auto
1
Lease Trust 2021-B A3 for $32,452, one Toyota Auto Receivables Trust 2021-B A3 for
$42,914, one Toyota Auto Receivables Trust 2021-D A3 for $11,848, one GM Financial
Auto Receivables 2022-1 A3 for $53,602, one Honda Auto Receivables Trust 2021-4 A3 for
$13,510, one BMW Vehicle Lease Trust 2022-1 A3 for $26,213, and one BMW Vehicle
Owner Trust 2022-A A3 for $18,583.
There were no maturities for NERIAD Fund for the month of January 2024.
The Town's net cash position changed from $17,469,363 to $19,447,615 during the month
of January 2024. This consisted of operating revenues in excess of operating expenses of
$968,707, net funds invested of $-936,620, premium/ discount recognition of $10,401 and
interest received of $62,524.
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
Accept the January 2024 Month End Treasurer's Report.
Prepared by:
Reviewed by:
� 41
Joseph A. Calabrigo
Town Manager
Attachment: January 2024 Month End Treasurer's Report
January 2024 Treasurer's Report 2 March 19, 2024
O O O O O O O O O
M W O N M o O Ln T
M TI,- CO O O O O T
r M N't m d 0, m
0 0 0 0 0 0 0 0 0
(M N � CO I-0 0 M N
OO M Lo O w O O M LC)
CO CO O �
Nco C.0 0000
69
N m (o Ict CM
0
�t
0 g o o 0 0 0
O O
Lo Lo
I,- rn
M O
9 O
(OO (O CO
Il- ti Co Lo
O CO
Q
c0F
O N rt LLq 000
N
cm
aN0
U�N
N m (O NT
ch
0
�t
0 g o o 0 0 0
O Lo r� O CO
0 m 0 0
Lo Lo
I,- rn
N m co
f7
691
r-
0
U) M
o U) O
O N
D �
U) 0
O O >+
L
o"
a u r
H e m o 8
DLL an
O
a
i
00 0 0 0" 0 0" 0 Iorol AN N M1t(OtiN TNOOO
N M fl T N (D T O O O O
—It &1&1000)
0T0 O T M ((���J r o M j
O) CO O) N 00 r
M N T M O ti L�) 0 T s=
N T r
Q9 I v�-
D N - N (07
�
M Ln }
Q
cm
CO O N co N
>
0
F—
000
O 00 N
V)
N00�
0000 NO
r
U)
U
c
�
o
rn
C) o
L�
c
r
W
T
T P- 00 r
oza�w
CO
T
r �
Q 3 C
�
U
W
Z
0
0
T
H4
r
oq
T
N
r
7
O
T T T
i l l
y I
d?
C) o
L�
c
N
T
T P- 00 r
O
CO
T
r �
r
r
U
O
a
/
2 U
/ 7
CN
�
9
/
Z
�
& _
t CY)
/f 7
§
LL (D
f �
® m
_2
U) o
L
$
/
C:> CD
7 %
7 7
C
�
@
/
2
2
$° m
2f t
C= Z
_
LL 3 e
ALE
ƒ / ED kk k
k / (00
Cc:s k i k, m
% c Z U f § § §
: 7 f k q
5 kƒƒ qƒ k q
m 7
LO �
7 7
A / J /
co
C\r
5
c
�
\
a)
A
2kg %
04 C) A
ii
\
�
\
7
.( ) >
7
§
2
%
A
%
CY)
cm
�
3
�
J
c
ƒk
7
of
/
\
�
! O l!•) S OO V N N LC') S 0 S 0 0 �fJ f�� p O i �� § p co N C) M Cl)
r CT Cfpl:� r h I� d I� I� pVo�� ro-� 10 CrqO f� 6'� C�Cpp ^- oo Cp
(`M (V N M C*J M 4 N r 2 CO 7 CO � � ui Cn0 � � 7 V LCJ c+') � Cc ) I�
a r r r r r CY)
Q C
1 1;,1 IV)I
OCO COO ltd � � (OD O S a0 C
M O CO T M
CoCpp 0�0 0�pp 0 p 0ppp 0 0 0 � 9p o -1
M O M OM7 M C\01:300M O
O m O O C5 O O C5 O r N
CO(pO M N~ N{� M N
ado O: M ti CO CO O Sr") N U:")
CT) m r 'cf � d r cn � 00
M O� ���pp 0OD N N 0-0 G CMO
O V 9 0 pOppp
O R N W O M M' V
I� CfJ Of- O I- O O O O lf') O S X31 O O O O GO O S N Lr) u)
> r r r r r CV r r r r r r- r r r r r (p r r r r r r r r r
N N N N N N N N�N N N N r.—
NNr N N N
O O O O O p O 0 0 0 0 0 0 0 0 0 0 0
w N N N N (N� N N N N N N N N
In O O CC cf7 le if O N O
a11
��azz55 ora O O r rO 0 0 00 r o
t-1-�a0aoao
N N N N N N N
O O O O D OM O COCpp O O O O O O O COp OO O
Ri 2 r N 10 n cD ti O
O O' G pOp O O
N S a0 M CNO,
7
N O
O O M M •- — •- N N It' M m
zi V .Y -t -t Lo Q
pNppp
0 0 0 0 0 0 0 0 0 0 0
N N N N N N N N N N N
j
a� �ZlCN amQ�m
N d p N 0 N r SZ' V t` c- r
m � 1 T yy
cc�Q iS� CSS C� Cn Cn 4
A n C� f� C� � 0b `M
0 0 0 O O O O r 0 0
��N{{ CD m tl) S o m �n N (�? r M O �Il"fn
d 4) d CV M O O tV 00 CO r N N N CO j
M 4 r- O 0 mI
bi 00 N CV I CD
N I� O CA O co 7 a0 M co cz E
a 9 N N N CO M r N S C', o9
CV O cV 0D oOO CO
CD CO
rn rn c�
co
r r N r r r r r r r N
CN
p
r CO
,ZzzzzzzzzZzzzzzzzz
_UUUUUUU
-M J J J U U U U U U U U U U J U J
J J J J J J J
U --
N m CO C~0
C!7 QMi 6) O l d
I� CA
N C) COV s CN 6� R Cd0 `
O d W
O O cMfi
O tf7 I� t` CD M aOp pp ��p0 �p
Cd O O O M V d 0�'r Oi O LO M
O fD In Ln d u� V
00 L 00 d Cn t` ti ti O) d d t7 O to In N
0) CD O S 0) .`�i �
CV
OCO COO ltd � � (OD O S a0 C
M O CO T M
CoCpp 0�0 0�pp 0 p 0ppp 0 0 0 � 9p o -1
M O M OM7 M C\01:300M O
O m O O C5 O O C5 O r N
CO(pO M N~ N{� M N
ado O: M ti CO CO O Sr") N U:")
CT) m r 'cf � d r cn � 00
M O� ���pp 0OD N N 0-0 G CMO
O V 9 0 pOppp
O R N W O M M' V
I� CfJ Of- O I- O O O O lf') O S X31 O O O O GO O S N Lr) u)
> r r r r r CV r r r r r r- r r r r r (p r r r r r r r r r
N N N N N N N N�N N N N r.—
NNr N N N
O O O O O p O 0 0 0 0 0 0 0 0 0 0 0
w N N N N (N� N N N N N N N N
In O O CC cf7 le if O N O
a11
��azz55 ora O O r rO 0 0 00 r o
t-1-�a0aoao
N N N N N N N
vvv�����
N N N CV N N N N N N N
0 0 0 0 0 0 0
N N N N N N
0 0 0 0 0 0 0
0 0
N N N N N N N N N N0 N
N
ll' Lpn C5 L 5 l! if 115
Lo U
pNppp
0 0 0 0 0 0 0 0 0 0 0
N N N N N N N N N N N
0
Q
O O N N N N M N CO CC'S c� C M N
N N N N N N N N N N N N N
M M 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
O O p 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 N N
0 0 0 0 0 0 0
N N N N N N N
0 0 0 0 0 0 0 0 0 0 0
N N N N N N N N N N N
j
a� �ZlCN amQ�m
N d p N 0 N r SZ' V t` c- r
m � 1 T yy
cc�Q iS� CSS C� Cn Cn 4
A n C� f� C� � 0b `M
0 0 0 O O O O r 0 0
0 0 O O O O r r r 0 0 0
0 0 0 O
0 0 0 x 0 0 •-
0
Q
p
O
N N N N N N
cc�cdQQddddd
0a?
o o o o o 0 0 0 0 0 0 0 0
,ZzzzzzzzzZzzzzzzzz
_UUUUUUU
-M J J J U U U U U U U U U U J U J
J J J J J J J
U --
U- L=- L=- L=- ILLI U- ILL- LLL,_ ILL- U- LLL- ILL- LLL- LLL- LLL- L=- U- L=L
$ LUL lUi L=L L=L L=L L=L
u.
U
O I 0 0 0 0 0 0 0 0
=zzzzzzzzzzz
�1—HHH F—F—HF—F—I—H
�. v� ui uS uS ui ui u5 u� v� u� vi
O O O O p O O O p O O O O O O U) 0 0 0 Un M N Cn C0n W m U') N O� N 0 O t` (, M
O O O O O N U) O Cq O T pp cY N � � O T
O o m M� � M�� 0 tl0 m O O 00 � Cn CO (D � 0 0? 4 V
y� CO T 00 M N I� 00 M p f� eri CV m r- I- CO CO T
a) u 00 f CO U) tC) 9 N r
C
Q
!f]
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ 0 0ln 0 0 � 0 0 0 e 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0 0
O + Op M Cp M S M CO CCpp CD I- U7 r O M 0 0 c� M p �� � V fes'] N 000 l� j I� 0 N A N
V CO Cl? f� In U) O 0 00 O N O H O O O (n e0 a0 V; g
O 0 0 (V 0 0 CV CV (V C7 C'7 m CM 7 -,t O7 N ('M O O O O O M CV CV
}
(a
0 0 0 U) N U7 OD O O Lo N 0 M 0 (C) N f-
M O �} r O O U) O O O U) Cl) f- ((pp
ti
CV N
In
O Np M O eD CO U)
NCpp O
7
N 0 C In 11') r N 0 O f� (C) f� 0 M 0
M U) 00 -I I� r, U7 O ti (06 Cn 0 (p�p CO
O 00 O
0 CD
(`
N
N
00 N O M O
00 N U) N M
CO
(`
C p
W O Cn O (O IC(� M
O r M M t: (T O
>
(p (p N M 11 C'�
V N 0 T (n N N Lti Cb
(Cnp
Ln N
N
� M 0) Cl) M
T
M M CO (Cpq O T (` In M
m
T
r r r r r r r
r
—
M (+') M N N
N
Y
T r
r
(rj (v j
aiLD
EA
6g
lW
N ON
O M cA 0 4 0 C Mp O M pp Cw 0 pC�p {V I- co (V (v) p U7
O CONr NS coomN 0~0 00 (n O (N (1') (1') M V cOD coON 0
COV (o CVC7 rD
f� O ��N}} pr" N (o+�p N O' No Cp M Cfl M N CMp r Op ��}7 moo} 00 (Np U-5
((j N M g �F M Ll� co (D O� M VLO � N O W M N lm
r T T T r r r T T r r r r T T T r NCt M M 0
00 W O Lt7 � � E .2
M CNO CD (O 00 g
Cl) M— M N N (C
O
> T(O TOpp r r Tpp r Tpo orlw rop 8r rO rO OO -Or S O OD NEN08 r �2 O
p O O ppp C14 O Cl) 10 O CN O (n UI�.) g g g (nN
MpOpOIpn CpO pcoCOp ( m M mDN r r r T M r- NrpnpOppD �(Vppp �N!� fN� W0OCND
V(r
Mn
0
r r
fR �
0)
❑jvNMN0(nN (nN uNO NON(n(Nn N (Nn10'0(0tiNpp1N0-
0nN rN0�
0 0 0 000o0 ON0 No p N NNN N NNNNN C'4 C'4
NT O O OrONO
CM C] MMM C) QNOC
�000$�o 0§C:) o$oo�o�
(U (� C�J CV
O N N N N N N N N N N N N N N N N g N N Cl)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 C:, 0 O O O
N N N N N N N N N N N N N N N N N N N N
�5ab aas��65 663 �
N O CV N r N O N N O O r 0 0 0 N O N 0
a 000 ooa oC)C)00 oo
Df
m
a n.
00
U U
r (n
8g
N N
C C
w w
L L
'M Y Y -M
15
� 9
Z> 2 (7�
fB 6 6 @ f3 6 6 is @ 6 ffl s�Y
o o o o 0 0 0 16 z o o 15 16- 0
zzzzzzzzzzzzzzzzzzzzL
zL,��szzilL,L ��z�z�� �FCD}
iD t0 i6 iD di i6 iD i6 t6i6 tC Z Y
��-
F- F -F- HHF-F- H 5LLU o S LL
ujCiviu5viWC/iviviuiviviviv5viu5(rivivi EMM0-0 �(mn¢
»»»»»»»»> m ❑
U
(n U') 0 LO CO CO O CC) (0 co (D
N N N N N N N N N N N
N N N N N N N N N N N
U O I� T (O l�f if CO T
ON CNCqq _ N
O N 0 0 0 Bob 0
N N N N N N N N N N N
0 0 0 0 0 O O O O O
N N N N N N N N N N N
M
M (r) M Cl) M Q
N< Q Q Q Cry Q
M CO 0 T Q
¢N¢NNQN�QQ
N O O O p N
m N N N Q V
Np 2 N v N N i
NSF -NF -F- =NF -
c
5 >
o0 0
0 0 W 150
> , ¢¢ ¢¢>
ii ❑ a) (c ❑ (a
Cm ❑ (3
a=fir
mcg �=��moDo
Q
U)
N
f
1OCrO W OCn r ' CO 'N117 hNSN r r
M �
CCl �VW cO7D 1C�1] r OMO MO 2 SMCo Np` CA C) N N N O O 17 N N h VN N �cl) Vh
O
C It
M
Q �
ON0 O0 O0 O0 O O0 -.1 O0 O0
•MCO�r;r,r� m D671 OENO
0 d121
0
OV' \O0o \Or ° \hOcy ° cho
15
°
r Cfi M CC) :Ci LdC'J -_ •-; O O O O O O N cV CV C6 4 N ,I- Lo U-) U-) -1- Lo Lo M ICV
co CA h MM 0 r M C31 O O h h CD N O 1•C) W O) V N CD co �'�' In c
CCpp 1 QQ�� CO { W 110 j M CO N u7 r h ltd r lf) r (h0 M 00 N ^� rr� N N CO N _ L O h Cfi h C
Cpp i cO�� r CV 117 Op f` O c� OJ 117 (V Ci> CV M ��pp O M
70 SoN N N I N m� ff� t ^�h"-� T '0V 9 rn N m Cn O CJ�'7 c� S C M
r r r
co r
Y 1�
H -T H-?
11
cN CA N ='f WO 0�0 $ N CO Oho N ti ti hcO Cho �Op O ROO Lo 7 �O�pp 0 000 M pppp O�JJ I tc`�
mMm Cn ' O} h 1� O W C p O r h M h O W CS) 1.1) N O O N f` M O N Cr O N c7 `--
m Oa. ti c;� o N N O �O�pp N O Mo M 1pf�J O Lpfp7 O O 0 C,5
1OC'� O p OOH� M ..1.
r N N r N c� a7 N O O) N to F) 110 O C CO O N h lf') O Cn M 6') Cp
' I I
pp p ln��` 0 117 lli g�ogplriolrippopoc0008o`no°'
C+Mj OrC\l CO ti N T C N pp !�l C� 8 h (+p'7 O 00 8 h O CO rLo- O O O
O� O u = O 110 V 67 M O Cf] h h O N h lfi M O) r
M_CrJ
❑ � f � r
> 13 N I
C C
❑ — l.L m j Cp CO h W W W �t Q u7 11') ltd 1n 1!) N O CO W W O CO CO CO h
o C ❑ N N N N N N N N N N N N NN N N N N N N N N N N N N N N
O O O �' O O O O OO O O O O N O 0 0 0 0 0 0 0 0 0 0 0 0 0
_ N N N N N N cc,:', CV C'V N N N N O` N N N` N_ N N N 1 N N N
~ - 6'Zc5 15 Z?5
�w �rr000� o`�o c�ir�ir� nco�c c8o ;:oCD00----
r r r o 0 0 0 0 0 0 0 $ r o 0 0 0 r o
-5n IN
H �y N �V N M l.C') M M M M M M M g
N �V
®-� N N co co N N N N N N N N N N N N N N N N N N N N N N N N
�I N N N N N N N N O pp 0 0 0 0 0 0 0 0 0 pp O O O C O 0 CN:,
0 0
N N N N N N N N N N N N N` N N N N N N N
1,r arnrn tioc`�� r�� v�c3o�o�Nar oo
a o o � 1 n S J 9 g m' FV C� �
r o r o o 0 0 0 0 0 0 0 0 o r o r r
Q
M coM Q �
a Co 8 0
NN Cl) N C
C'M N Q O N Q CQ Q CQ z 0 47 Z
N N N N N Z U U T CU � -�
CD �04 R �� oo-M Q) o oZ y y o a� M
8 Q Y a a ro ro c8 Z o Z U U o 8 m o Q Z 0 U 25
~ 8
a Z a� a� o Z U a� Z Z m o CJ O
N m -) s a� o U d 0 o CL Y C� H
❑Ir -i -- b3 N,
8 8 �� `o—z�U oo�Z tz
0 0 c c> �i�U.� c-9UU m 0ZZ Y 0U Co
20 to �e o r
17-L LZ
ML LL 17L 0) co
C7UC7ml-U oo c U UQQU < U <0 0022 -5 �5
i U9 Z
M
0
i
CD
❑
I
L
co
ti
T
C�
N
w LL
U
to
C) IA
=7
\
R
\
#
e
7
01
/
0
e
f
/
fl- 0) ^R
k#
<z
_
@@aRR
a
GGg\\
\k
It It
»2
0)0 0)
g\@\R
§
\
�/ �}
�
I
a
=o=e/
7\2\0
�\ �$
J
a
g2EE7
R NLO
/
\\ �¢
&
�
. <
k
§
®
�
>1-4
2
cFa /ƒ�
ƒ
/ƒ0
\/
»
ƒ/
k
3
�
f
77�
a)
§#�
z=
#
7
§ s £
21I�/
_
\2
>f3
.3 LL LL
LL
f�4«�
\
R
\
#
e
7
01
/
0
e
f
/
'
nnnCe)
LoLoLO 8
/
§
%\qq
=
�
§
dAe/
t 3
)%§%�
0it' I':!'
§§§§
�.\{
b(<
Jaeaa
2
»\{
LF
°
R»
@____
$§@$A
C-) ED
=
o
\
ƒ\
rLn, dLOw�
Z2q
¥
I �
�
§
k0
\~�
$\
C4
A
b
I
�
J
�
�
\
-�
_
r-
§
§%§§�
%§?$§
\
\
q
Rqk\
c
3 04
k
�
E
nnnCe)
2
/
§
%\qq
\
�
§
dAe/
t 3
E
0
I
2
/
\
�
§
t 3
)%§%�
0it' I':!'
§§§§
�.\{
b(<
2
e@@@@
LF
@____
%__
C-) ED
=
o
\
0