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
0
}
O O O O O O O O O
M CO 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-C 0 M N
OO M Lo O M O O M Lo
CO CO O �
N co � 00
69
N m (o Ict CM
O O
M O
9 O
(OO (O CO
Il- ti Co Lo
O CO
c0
O N rt LLq C co
N
CNO
U�N
N m (O Nt
co
0
�t
0 g o o 0 0 0
O Lo f� O CO
0 m 0 0
Lo Lo
I,- rn
N m co
f7
691
r-
0
U) M
o U) O
O N
z �
U) 0
O O >+
L
o"
a u r
H e m o 8
DLL an
O
a
i
0 0� o 0 0" 0 0 0 0 Iorol
AN N M1t(OtiN TNOOO
N M ti T N (O T O O O O
N oT0 O T M ((���J r o M co —It &1 O) CO O) N 00 r
M N T v (O N:L�) 0 T
N T r
Q!.!� IVI-11
0 N - N (O7
�
M Lf) }
Q
cm
CO O N co N
>
0
F—
000�
O 00 N
V)
N00�
0000 NO
r
U)
U
c
�
o
rn
r
W
oza�w
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?
o 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
f o
L
$
/
� CD
7 %
7 7
C
�
@
/
2
2
$a)m
2f t
C= Z
_
LL 3 e
ALE
ƒ / ED k k 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 %
04o� A
ii
\
7
.( ) >
7
§
2
%
A
%
CY)
c
�
3
�
J
c
ƒk
7
of
/
\
�
! O l!•) S O V N N LC') S 0 S 0 0 �fJ f�� p O i �� § p co N C) M Cl)
r 0 S r h I� d I� I� pV� r- 10 CrqO f� 6'� C�Cpp ^- oo Cp
(`M (V N M C*J M 4 N � 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
O O O O D OM O COCpp O O O O O O O COp OO O
2 r N 10 n cD ti ro
O O' G pOppp O O
N S 00 M CNO,
7
OND N O
O O In M •- — •- N N It' c*7 m
zi V .Y d-t Lo Q
��N{{ CD m tl) S o m �n N (�? r M O �Il"fn
W 4) d CV M O O tV 00 CO r N N N CO j
M 4 r- O 0 mI
bi 00 N N I CD
aN I� O CA O co 7 00 M c'7 cz E
9 ti N N CO M r N S 0 O
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
N m CO C~C)
S QMi 6) O 1 0
I� 0
N C) COV s CN 6� R CO0 `
O 0 W
O O cMfi
O tf7 I� CD M �Op pp ��p0 �p
d O O O CM V 0 0�'r Oi O LO CM
O CO In Ln O u� V
00 L d 0 Ln n ti ti O) 0 0 tt O f� In N
0) CD O CO0 0) �
CV
OCO COO lt� � � (OD O S a0 C.
M O CO T M
CoCpp 0�0 0�pp 0 p 0ppp 0 0 09 9p o -1
M O M OM7 M N� 00 M O
O m O O Cj CD CC5 O r N
CO(pO M N~ N{� M N
aO0 O: M ti CO CO O Sr") N U:")
0 m r 'cf � O r cn � 00
OO MO�000 OM0 G ppOM O
V 90 RN W O M M'pp V
I� CfJ O f- O I- O O O O lf') O S �31 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 N NNr N N N
0 0 0 0 0 6 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
��a azz55 ora O O r rO 0 0 00 r o
�t-1- �00RK
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 O O O O O ON O
N N N N N N N N N N
N
ll' Lpn C5 L 5 l! if 115
if! Q if lf� l�[ M Lo U
pNppp
nr,�
O O N N N N M N CO N 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
O O O O O O O
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� CAS 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 r 0 0 •-
0
Q
p
O
N N N N N N
cc�cdQQddddd
0 a?
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- U- U- , LPL. LUL L,L U- U- U- LUL U- U- LUL U- U- U-
$ LUL lUi L=L U- U- 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
Wm UV') N O�CD CO T � pp CO N O Cc ti Of1 TMO o mOq00 N Cn Colo)
�
CO T 00 M N PI: 00 M
a0I- CO CO CT u fpU�rVN r9
C
Q
!f]
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ o 0ln 0 0 � o 0 0 e o 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 G M CO CCpp CO I- U) r O M 0 m c� M p �� � V coamN m l� j I� 0 N A N
V CO Cl? f� In U) O O 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
M Cn m U) N U7 W O O Lo N M M 0 (O N f-
M O �} r O O U) O O O U) Cl) f- ((pp
ti
CV N
U')
O Np M O eD CO U)
NCpp O
7
>>
N CA Q) In 11') r N C l O f� (C) f� O M O
M U) 00 -I I� r, U7 O ti (06 Cn 0 (� CO
(p (p N M 11 N
O 00 CO (� N N ((i 00
V N O T
O CD
ti
L8 N
CV
N
N
00 N O M O
00 N U) N M
� M 0) Cl) M
CO
ti
C p
W O Cn O (O IC(� M
O r M M' (T O In M
M M CO (Cpq CO T f� m
T
r r
r
—
M (+') M N N
N
Y
r r r r r T r
r
(rj (v j r
aiLD
EA
6g
lW
N ON
O M cA E 4 O C Mp O M pp Cw m pC�p {y ti co (V co p�
O CONr NS co�N 0~0 00 (n O (N (1') (1') M V cOD cco 0)oo N COV co CVC7 rD
f� O ��N}} p,= N (o+�p N O' No Cp M Cfl M N CMp r Op ��}7 moo} CO (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 m
O W O Ln � � E .2
M CNO CD (0 00 g
M M— M N N (C
O(O Opp pp po olw op 8 OOOOO S O I�00 N10 N8 r 2 O
p O O ppp C14 O Cl) (p O N O (n UI�) g g g (nN
MpOpOIpn CpO pcoCC, p (m Npnp00pp Nti ��c�}p WCO})
r
M
cY M O m�
- N N (n
T r r r r r N r r r T M M r C77
r r
fR �
0)
❑jvNMN0(nN (nN uNO NON(n(Nn N (Nn10'0(0tiNpp1N0-
0rNnrN0�
0 0 0 000o0 ON0 No p N NNN N NNNNN NNN
NT O O OrONO
CM C] MMM C) QNOC
�000$�o 0§C:) o$oo�o�
N ((�� (C��JJ C� (y (� (y (�
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 0 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 66�3 �
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 (�
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 t6 i6 tC Z Y
��-
F- F-F- HHF-F- H 5LLU o
ujCiviu5viWC/iviviuiviviviv5viu5(rivivi EMM 0-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 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 0
> , ¢¢ ¢¢>
ii ❑ a) (6 ❑ (a
Cm ❑ (3
a=fir
mc� �=��moDo
Q
U)
N
f
OCrO_ W OO cr0 ' CO 'NU7 hNN r r M �
(O � VW OcOD CC�(] TMOpO Mp 2 S 'R Co Np` CA () N N N O O (d N N h VN N �cl) Vh O
C It
M
O O O O O O O f " ' D O O O
o I M m 61 N M V O r h 1q,
r o
C v pp pp ,, `r ,- I r i 7 c c°3 a�i, (v
.!5 N C-0 ui (D N O :'r:I (O CO 7 iCi O
� 7 r (fi M CC) :[i Ld C'J -_ •-; O O O O O O N CV (V M 4 N ,I- Lo U-) U-) � Lo Lo MIN
co O h co co r M O O O h h (0 N O Cn W 0) V N co (O U, COO
M N CO N _ L O h (fi h C
Cpp i cO�� r (V l(j C+0 f� O (''� OJ 117 CV CC��JJ CS> CV M ��pp O (`')
70 SoN N N I N Qhi � 6� t ^�h"-� T 'WV 9 rn N m Cn O Q�'7 c� S C M
r r r
1(rj r
Y ljj�
H-T H-?
11
cN O N �•!' 8 WO 0�0 $ N (O oho N ti ti I�c�p0 Cho O CRO0 7 �OCpp o 000 M pppp O�JJ I tc`�
mMm CT CA h« O W CT O r 6� h M h O W 67 O N N Cr O N c7 `--
m O
r a. 0CfJ O ppO O M
g
ON h O 7 CCM p1 tJ
N NrN c� 8 O OC ..1.
' I
M(+j = ` O V L67 Mri O (f] h h L,ioL6grooO
ono°tiNC �0� O) rOpp T N h M
C\l �
_M CrJ
❑ � f � r
> [7 N I
C C
❑ — l.L m CO h W W W �t Q i.t i Lfi ll� In L! i In CO CO CO CO CO CO CO CO I�
o C ❑ N N N N N N N N N N N N N NC� 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
~ C-OCZ0( 15u'5 c�cou� 031��000�0 �'o`SNo 00000
�w �r�000� o`�o (�(nir�u�co�c c8o rco(CD00----
r r r o 0 0 0 0 0 0 0 $ r o 0 0 0 r o
-5n IN
N M ICJ M M M M M M M g
®N �Cyy NC� NC� NN
-� 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 N
�I N N N N N N COy N O pp O O O O O O O O O pp O O O C O 0 0 R. 0
N N N N N N N N N N N N N` N N N N N N N
�arnrn tio(`�'or= ( 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 00 0 o r o r r
Q
M Cl)
Q �
a Co 8 0
NN Cl)
CND� C
CM N Q O N Q CQ Q CQ z 0 47 Z
N N N N N Z U U T �
CD ��� oo-M a) 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
❑Ir -i -- b 8 8 �� `o—z�U oo�Z t �O--m
0 0 c c> z
�i�U.� (-9UU m 0ZZ Y 0U Co
20 to �e o r
C7UC7ml-U oo c U UQQU < U<0 0022 -5 �5
i U9 Z
N
7
ID
g
M.
i
CD
I
L
0
co
ti
T
C�
N
w 'L
U
to
C) IA
=7
�$ ^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
c/ƒ�
ƒ
/ƒ0
\/
»
ƒ/
k
3
�
f
77�
a)
§#�
z=
#
7
§ s £
21I�/
_
\2
>f3
.3
LL
f�4«�
\
R
\
#
e
7
01
/
0
e
f
/
'
LoLoLO 8
=
Jaeaa
°
)
rwd0w�
Z2q
¥
�
I �
�
§
k0C4
\~� $\
>
A
b
I
�
J
�
�
\
-�
_
r-
§
§%§§�
%§?$§
\
\
q
Rqk\
c
3 04
k
�
nnnn
§
%\qq
dAe/
E
I
2
/
\
�
§
t 3
)%§%�
0it' I':!'
§§§§
�.\{
b(<
2
e@@@@
LF
@____
%__
e=u
=
o
\
0