Treasurer Report 1-30-24

1-30-2024
To:
Robert J. Brule ~ First Selectman
Kim Allen - Director of Finance
Glenn Patterson & Board of Finance Members
Paul Goldstein & RTM Members
Thomas W. Giard III - Superintendent of Schools
Joseph Mancini — Director of Finance & Operations ~ BOE
Pat Fedor & Board of Education Members
From: Abbas Danesh - Treasurer
Subject: Quarterly Treasurer's Report and Related Financials ending 12/31/2023.
‘The following attachments are included for reference:
Attachment 1 ~ 12/31/2023 Cash Positions - Town of Waterford
Attachment 2 ~ CDs & Bonds Summary ~ Town of Waterford
attachment 2 Oct ~ Dec & attachment 2 combined
Attachment 3 ~ Graph of Total Interest Income vs. Fiscal Years
Attachment 4 ~ Interest Income by Funds vs. Fiscal Years
Attachment S$ - FY 2024 Estimated General Fund Cash Flow
Attachment 6 - Bond Debt Service
Happy New Year.
Customary to my New Year opening, | am delighted to acknowledge that Ginny, Christy, Ernesta,
Shea and Becky are a tremendous help. Borrowing a line from Mr. Warren Buffett, I get to “tap dance to
work”, making it a pleasure to come to work. Also my thanks to Kim, our Finance Director, for a well-run
finance department.
Going over our three baskets/institutions:
STIF interest rates are going up ©
Averages for Oct 5.41%, Nov 5.45%, Dec 5.44%
M&T’s Savings interest is at 3.25%.
Fidelity account activities:
Oct: Two Mil treasury matured. Purchased two Mil treasury maturing 3/2024, 400K treasury
maturing 4/2024 and 70K JP Morgan CD maturing 10/2024.
Nov: One Mil treasury, 245K CD and 100K CD matured. Purchased one Mil treasury
maturing 4/2024, 115K BOA CD maturing 11/2025, 235K Charles Schwab CD maturing 11/2024
and 40K JPM CD maturing 11/2024.
Dec: 44K agency, 11K agency were called, 35K Morgan Stanley CD matured. Purchased one
Mil treasury maturing 5/2024, 34K agency maturing 12/2031 and 95K agency maturing 6/2025.
Please see Attachment 2 combined, the monthly running of WAM, WAY, and Annualized
ALPHA to get a more accurate picture of our portfolio.

Ap you observe our ALPHA, which measures performance, | underperformed our benchmark
in Oct, Nov and Dec by (-1.44%, -1.44% and -1.35%, respectively). Our Weighted Average Yield
(WAY) has been steadily increasing, from an average of 0.65% in FY2021 to 4.09% in Dec of 2023.
Attachments 3 & 4 show our interest income with comparable amounts from previous years.
FY 2024 2" quarter of $2,410,030 vs FY 2023 2" quarter of $1,218,144...we are having a good
start in FY 2024 ©
Please see Attachment 5, our estimated General Fund cash flows for FY 2024.
Please see Atachment 6, our updated bond debt service.
Itis an honor and a pleasure to be in my position as treasurer; | welcome any questions or
suggestions.
Sincerely Yours,
of ac 4
Abbas Danesh - Treasurer
samy next quarterly report will be in April 2024.

svoday
wineay
ECTETT
sawp
meng
weg
eueng
fa
8nbss
sed
20
wl
NE
OODLE
HNoUY
"WOW
PUOUILIEH
wees
puny
worsuog
(euojssqunwon pue
30120119
eaueuly yo
Jox1U09
spun)
orem
§
ung
g3d0
‘suosupy
(uejaipn,
Aq
peBeuey -
seouryeg
06184
31M
eaTEe
TEE
roctis
Sei
owT
S[
oot:
$[veweer
s[rivaeer
Sl
erroire
sleet
S|
sercorh
$|rer
eaves
$[re9'%60009
F
ssrveces
—$[
5
S[ezort—§
wees
_s|nreesy
—s[eseiwro
sleet
_#|
serenry
i|
oevez
S|
vruzees
5
[een
owen
§
sivzz0%
8
[ezncer
core
$
aes
z
[ae
=
o
‘sootrez—$
[ecneer
eerserer
6
eevverar
$s
[ezseer.
arin
$s}
ier
$
Jezncer
GYOIYALYM
AO
NMOL
-
SNOILISOd
HSVD
EZOZ/LERL
1
waupeny

CDs & Bonds Summary - Town of Waterford, Oct 2023
112024] FEDERAL HOME LN MTG CORP,
Tis024] WELLS FARGO BANK NATL ASSN CO
127772024] EDERAL HOME LOAN BANKS
‘ta3025]GOLOMAN SACHS OX USANY CO
132026] GOLOMAN SACHS BK USA.CO
7112025] GOLOMAN SACHS BK USA CO.
7iisa0as] TENNESSEE VALLEY AUTH
41192025] GOLDMAN SACHS BX USA
"W2172025| TOYOTA FINL SVGS BANK CO
3142026] STATE BANK OF INDIA CO
‘72025 EDERAL HOME LN MTG.CORP
7i19025| MERRICK BANK CO.
aia7026] MORGAN STANLEY CO
Tinao2s|cmaank co
"13120z6|UNITEO STATES TREAS SER U:2026.
“22026 MORGAN STANLEY CO
[1317076] UNITED STATES TREAS SER W2026
JUNITED STATES TREAS SER W.2026
luniTED stares TREAS SER W.2026
IED STATES TREAS SER AA2026
'SALUE MAE GANK
[FEDERAL HOME LOAN BANKS
[FEDERAL HOME LOAN BANKS
lBRIOGEWATER BANK CO
|SPRITBANK NA TULSA OKLA CO
[Cenc ex SALT LaKe cry UTAKCO
107625] MORGAN STANLEY CO
7242028] AMERICAN EXPRESS NATL BANK.
Tia2026] FEOERAL HOME LN MTG CORP.
Tauro2a Fins FED SVS & LN CO.
IFEDERAL FARM CR GKS BOND
US TREAS SEC STRIPPED INT
JFEDERAL HOME LN MTG COR
laoaws COUNTY BANK CO
MORGAN STAKLEY CD
IFEDERAL FARM CR &KS BOND
[FEDERAL HOME LOnN xS BOND
|4P MORGAN CHASE CO
Live OAK 8G CONC CO
IMNKWEST BANK CO
JFEDERAL HOME LN NTG CORD
JFEDERAL FARM CR QXS BOND.
|FEOERAL FARM CR axS BOND.
SYNCHRONY BANK CO
Ttsabe2] UNITED STATES TREAS.
near
aa
825
2328
10000,
Cr Sank Rane Barchase Pee | acon
‘One Bi maturigy
61095] CRSH AND ACCRUED INTEREST Wea [Sosa
Tg923]-SRAEL BANK CO 248,000 [5 ——2as.o00
“H2623] SYNCHRONY BANK CO ‘00,000 [5 to0.0
7182023] NITED STATES TREAS 193,993 [$0 00
3072023] UNITED STATES TREAS ‘73aso [$1000 200
2872023] MORGAN STANLEY CO ‘35000 [$500
‘Tona023| nmreo STATES TREAS ssoors |'¢ 10,000
'va2024] UNITED STATES TREAS ‘76.758 [1.800000
pi872024] UNITED STATES TREAS ‘senie [$ 1.600600
‘118024 UNITED STATES TREAS 72300 [52,000,000
721262024] FEDERAL HOME LOAN BANKS ‘e000 [409
22024] UNITED STATES TREAS. s73aso [$100 c00
[3202024] UNTED STATES TREAS 1.348 900 [$000 00
a1aoz4| UNITED STATES TREAS ‘asia | $400,000
‘2024 WELLS FARGO BANK NATL ASSN CO ‘7900 [¢ 7.90
ars024|GOLOMAN SACHS BK USACO seaer
“oz4|unTED STATES TREAS 308786
‘1z0z4JUNTED STATES TREAS a7997
1192024] AMERICAN EXPRESS NATL BANK. 13,000,
Tiaiz024| sat Lie MAE BANK 000
“av18024|FLAGSTAR BANK CO 245,000
7087024] 0 ORGAN CHASE CO 79000
T0n024] WELLS FARGO BANK NATL ASSN/CO 61393
se a et rt
Total investments ’
Weighted Average Yield
oe
Annuslized ALPHA
Weighted Average Maturity in Yeers
10977908

CDs & Bonds Summary - Town of Waterford, Nov 2023
|—aaterte
Sema oe Baraka Bee
Resour
aiturt
Tae] (GASH AND ACCRUED INTEREST Tasso
er)[MORGAN STANLEY CO. 35.000,
Taav200| lUNTEO STATES TREAS
stoore
‘isa
aisnoa
Bisn04
PETIT
‘aoa
sanz02
“uta
aan2024
svat
| “saoaozs}
wst24
lUNTEO STATES TREAS
lUNTED STATES TREAS
|UNITEO STATES TREAS
IFEDERAL HOME LOAN BANKS
lUNTED stares TREAS
lUNITED STATES TREAS
|UNITED STATES TREAS
|UNITED STATES TREAS
WELLS FARGO BANK NATL ASSN CO
|GOLOMAN SACHS aK USA.CO
UNITED STATES TREAS
JUNITED STATES TREAS
|AMERICAN EXPRESS NATL BANK.
azar 'SALLIE MAE Gann
sibel
yovis2e24
“aria2024)
ia
Tze
vi62024
sza2024
sp7a2|
ia7e28|
ai32036)
Tae
IFLAGSTAR BANK CO
\sP MORGAN CHASE CO
SWELLS FARGO GANK NATL ASSN CO
(CHARLES SCHWAB CO
[FEDERAL HOME LNT CORP
13? MORGAN CHASE CO
[WELLS FARGO BANK NATL ASSN.CO
[FEDERAL HOME LOAN OANKS
(GOLDMAN SACHS OK USA NY CO
|GOLOMAN SACHS OK USACO
|GOLOMAN SACHS 8K USACO
Trs2035
aint
mzta035
TeNNESSEE VALLEY AUT
IGOLOMAN SACHS 8K USA
ITovora FIN SVGS BANK CO
'STATE BANK OF NDIACO.
IFEDERAL HOME LN MTG CORP.
[MERRICK BANK CO
MORGAN STANLEY CO.
|BANK OF AMERICA CO
PX
35000
Tate 209
eel
pesca
err rrrrl
718000 | —5 4
lemaank co [x to900 | —o 795)
|UNITEO STATES TREAS SER U:2026 [s—v00.000 | 0-705)
MORGAN STANLEY CO 43,000 | — 8.00%)
|UNITED STATES TREAS SER w.2026 195,280 | ¢ 200,000 | — omy
|UNITED STATES TREAS SER W20: ‘0880 | ¢ 100000 | ean
|UNITED STATES TREAS SER W.2026 9987s [§ —teag00 | —0 78
|UMITED STATES TREAS SER AA 2026 s98so [5 100.000 | egos
'SALLIE MAE BANK ‘240,900 [5240000 | —e:
[FEDERAL HOME LOAN BANKS ‘20.090 | $40,000 | — 3.603]
[FEDERAL HOME LOAN BANKS 100000 | §—too,600 | 0.603]
|BRIOGEWATER BANK CO 248,00 | $245 600.1 0705]
'SPIRITBANK NATULSA OKLA CO. 200000 |
[CELTIC OK SALT LAKE CrTY UTAH CO 209000 [$
IMORGAN STANLEY CO 43000 [$
|AMERSCAN EXPRESS NATL BANK. 15900 [5
|FEDERAL HOWE LN MTG CORP 2000
18ST FED SVGS &LNCO. sssa00 {s
|FEDERAL FARM CR GXS 80ND ss000 [$
lUS TREAS Sec sTRPPEOINT now [F
IFEDERAL HOME LN MTG CORP 22000 [$
[ADAMS COUNTY BANK CO 248.000 [§
IMORGAN STANLEY CO. ‘20000 [§
FEDERAL FARM CR BKS GOND ‘00,000 [§
FEDERAL HOME LOAN BKS BOND 140,000 [$
|sP MORGAN CHASE CO zasa00 [¢
uve OAK aKG.co Ne co 245000 [§
uNNWEST BANK CO 45000 [¢
"EDERAL HOME LN MTG CORP 100000 [§
[FEDERAL FARM CR BS BOND ‘44000 [5
[FEDERAL FARM CR BKS BOND ‘000 [
[SYNCHRONY BANK CO 4000 [§
711872042] UNITED STATES TREAS. sats [S
I
Tote! investments 5 19000405. $ 19,205.60
Weighted Average Yield 401%
oe som
Annualized ALPHA $268,089
Weighted Average Maturity in Yeors 183

TRF OR
CDs & Bonds Summary - Town of Waterford, Dec 2023
com aan ae [Purchase Pie | —Amoamr
Oat etary | Wild
TBaTzOTs| CASH AND ACCRUED WEREST Ty [ 17728 | — 3708]
‘suauz02s| ured STATES TREAS. ‘nore | $1200 000
BUZBR4|UNITED STATES TREAS, ‘7e.788 [3 — 1600000
2Fis024] UNTED STATES TREAS ‘seesta [5 — 1600 00
27182024] UNITED STATES TREAS 1.972300 | $2,000,000
‘HHMT024| FEDERAL HOME LOAN BANKS ‘100,00 | § — 10,000
‘pas7024| UNITED STATES TREAS 73,480 | $00,000
[¥iNTz024]UNITEO STATES TREAS 7.0 00
iu7024] UNITED STATES TREAS. 8000
“Taoz02K) UNITED STATES TREAS 700
‘S12024] WELLS FARGO BANK NATL ASSW.CO 7,000
‘e7024] UNITED STATES TREAS Tan 09
"815 2024|GOLOMAN SACHS BK USA CO “009
{3072024 UNITED STATES TREAS. 300000
{63072024|UNITED STATES TREAS 7500 009
11872024] MERICAN EXPRESS NATL BANK 1.000
267024) SALLIE MAE BANK. 8000
‘S78 2024)FLAGSTAR BANK CO
7arisiat24| 3 MORGAN CHASE CO
rigtz4|WELLS FARGO BANK NATL ASSN CO
Ti/2U24I CHARLES SCHWAB.CO
Tizs2024| FEDERAL HOME LN MTG CORP
"izez824] 3 MORGAN CHASE CO
Tzaz624| WELLS FARGO BANK NATL ASSN CO
"UTa024| FEDERAL HOME LOAN BANKS.
TW142076| GOLDMAN SACHS OK USAINY CO
1132025] GOLOMAN SACHS BK USA CO ara
267026] F EDERAL HONE LOAN BANKS 983,00,
T2625] OLOMAN SACHS @K USA.CO ana
THsr025] TENNESSEE VALLEY AUTH 20228
WiN72025| GOLOMAN SACHS BK USA 000
12172025] TOYOTA FINL SVGS BANK CO 245000
oi2025]STATE GANX OF INDIACO 245.000
0872025] EDERAL HOME LN MTG CORP 126000
G787026| MERRICK BANK CO 245000
oriazb26] MORGAN STANLEY CO 181000
aairezs
er0707
san70ze
e007
wor
2072027
wpa
spat
s020
sraraa
EEA
Taaroa
snia029
srra0a8
si02029
ar099
ena7e30]
‘2030
37252039
Tunes
2034
2/099
3297039
Tiwz0e]
[UNITED STATES TREAS SER U:2026
[MORGAN STANLEY CO.
|UNITED STATES TREAS SERW.2026
JUNITED STATES TREAS SERW.2026
JunITED STATES TREAS SERW.2026
JUNITED STATES TREAS SER AA 2026
[SALLIE MAE BANK
FEDERAL HOME LOAN BANKS
FEDERAL HOME LOAN BANKS.
JBROGEWATER BANK CO
|SPIRITBANK NA TULSA OKLACO
ICeLTic Bx SALT Laxe cITY UTAH CO
IMOAGAN stanteY CO
RICAN EXPRESS NATL BANK.
IFEOERAL HOME LX TG COR?
Jrst Feo svas a unco
Jus TREAS sec srmpPEo NT
FEDERAL HOME LN WTO CORP
‘DAMS COUNTY BANK CO
MORGAN StaNLeY CO
FEDERAL FARM CR BXS BOND
FEDERAL HOME LOAN BKS BOND
|sP MORGAN CHASE cD
lve oak exo CONC co
IwinnwesT BANK cD
FEDERAL HOME UN MTG CORP.
FEDERAL FARM CR BKS BOND
FEDERAL FARM CR BKS BOND
[SYNCHRONY BANK CO.
JUNITED STATES TREAS
116.000
00,000
34000
2400
+40 900
esi?
Total investments
Weighted Average Yield
se
Annualized ALPHA
Weighted Average Maturity in Yours
morsero $ 19.218725
409%
107

lexroecs
couvress
sceurs
was
lure
nese
4890
‘eoy
Koy
use
ESE
aE
avn
veunr
whem
yeudy
yOHEW
peGed
peer
Ez-290
_—EL-AON
EVO
Eres
Ezy
EzINT
wey
|
SEY
ERA
woz
Ad
BOREAL
FLORAL
AUN OL
OE
dog
PEO
AF
PIOVDVEM TO
UNO
“VHA
TW
POZTTENULY
YM
AMA
AITO|

ezoz/teiZl
-
SANNA
T1V
-
SONINYVA
LSSY3LNI
GuyOsNaLYM
JO
NMOL
crowoery
a
&
ewioduy ISe10}U]

owes
GevUOTS
oxuoorts)
EavLOeTS
sures
orTORS
ISIS
EINE
wares
ortss
Gates
vans
ares
ssrrcts
con
unorswaul
arEs
WEN
UOT
aS
OES
loco‘ouv'zs
eis'zzo'es
6c'cors
veL'eOLs
CLI'LEN'IS
waU'ORE'HS
GoV'OLLS
SZO;ELCS
CHO'ELS
tOr'ssIs
LON'SLIS
seo'soes
‘@29VNVW
waunsvaus
W101]
lcwcouswovces
—weaots——cnvs—=waseas
ata
seas
ERTS
mses
estes
uss
‘ont
Nonnausietna
sons
pe
caveats
overs
tases
ens
wes
aS
Ss
uso
vous
Ins
os
6
%
as
ns
sts
wm
6
6
aus
sonal
ewes
wees
STS
eos
rms
aueag—
warts
urs
arts
tess
QUE
ANAMAOTAKHO-®
SONVNTENI
ANS
Jeers
caves
ves
tees
wees
evs
sees
moses
aes
ees
ws
xamiont
cer
foeveers
covers
sas
tuts
owns
SMS
LISTS
RO
cet
aCHES
NSS
Las
ES
ueacntw son
wine9]
on
ees]
jrcerers
errors
weeress
ems
vevewors—oeess
aN
HESTTERRVSOTS
EELS
oS
ERS
err
LOTS
Ta
aGE
WATE
DERE
OTSIE
HOE
HOE
FOERTO
COTTON
aE
Mt
Ms
7m
tl
la
ee)
RETIRE
Cea
eae
FREER
eae
—
TT
a
a
a
a
a
{200
16
290
dO
SVAEOE
LH
HOS
SCNAY
GYOIUALVA\
JO
NOL
TWOONI
LSAVAINI

vz0z/o€/t
suoday
sasnseas
€Z-TE-ZT\EZOZ-TE-ZT\Hoday
seqqy\dorysaq\ysauepe\s:asn\:3
nvouvnon
zey‘s0s
$
ooo‘os6'sy
$
00's"
o00%088'£
o00'0E8"<
o00'0E8'z
eames
1990
AlUOW
oe
awovnen
‘anuanas xe} uer palewnsa ,|
@vl'vtr'9e
tr'vpe'ey
v29'690'29
wunoun
aouejeg
puny
jereueD
PLO[I}EAA
JO
UMO]
-
MOJ-J
YSED
puny
jessuayH
pajyewysyz
yz70z
aunt
-
yZOZ
“EL
g
uawyoeny
SIR0L
anne}
Avi!
aay}
BT)
gad
Nve|

[Attachment 6
BOND DEBT SERVICE
|Outstanding Debt Service Post 2020 Taxable Refund
Town of Waterford, Connecticut
Fiscal Year Principal
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
$0
$6,595,000
$6,645,000
$6,395,000
$5,545,000
$5,770,000
$5,375,000
$5,340,000
$3,635,000
$3,570,000
$1,585,000
$680,000
$680,000
$680,000
$680,000
$680,000
$680,000
$680,000
$55,215,000
Interest
$805,482
$1,514,746
$1,319,500
$1,083,426
$829,375
$632,762
$482,770
$344,138
$239,800
$166,780
$124,224
$91,800
$78,200
$64,600
$50,575
$36,125
$21,675
$7,225,
$7,883,201
Debt Service
$805,482
$8,109,746]
$7,964,500}
$7,478,426
$6,374,375
$6,402,762
$5,857,770
$5,684,138
$3,874,800]
$3,736,780
$1,699,224
$771,800
$758,200]
$744,600
$730,575)
$716,125
$701,675]
$687,225]
$63,098,201