Treasurer report 3 31 2024

4-23-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 Ill - 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 3/31/2024.
‘The following attachments are included for reference:
Attachment 1 — 3/31/2024 Cash Positions & QTLY Cash Positions - Town of Waterford
Attachment 2 CDs & Bonds Summary - Town of Waterford
attachment 2 Jan ~ Mar & attachment 2 combined
Attachment 3 - Graph of Total Interest Income vs, Fiscal Years
Attachment 4 ~ Interest Income by Funds ys. Fiscal Years
Attachment 5 ~ FY 2024 Estimated General Fund Cash Flow
Attachment 6 - Bond Debt Service
Going over our three baskets/institutions:
Averages for STIF interest rates
Jan 5.44%, Feb 5.43%, Mar 5.42%
People’s Savings interest is at 3.25%.
Fidelity account activities:
JAN: two Mil treasury matured. 84K & 12K Agency Bonds were called. Purchased one Mil
treasury maturing 6/2024, 73K UBS CD maturing 1/2027 and 98K Wells Fargo CD maturing 1/2029.
FEB: three Mil treasury & 100K Agency Bonds matured. 42K Agency Bonds were called.
Purchased one Mil treasury maturing 5/2024, one Mil treasury maturing 8/2024, 1.8 Mil treasury
maturing 11/2024, 28K UBS Bank CD maturing 2/2027, 104K BMW Bank CD maturing 2/2027 &
140K UBS Bank CD maturing 2/2029.
MAR: two Mil Treasury matured. Purchased one Mil treasury maturing 6/2024, 105K Wells
Fargo CD maturing 3/2027 & 71K Morgan Stanley CD maturing 3/2027.
Please see Attachment | cash positions as of 3/31/2024. Please note on bottom of the page,
added quarterly cash p. ns-year over year.
Please see Attachment 2 combined, the monthly running of WAM, WAY, and Annualized
ALPHA to get a more accurate picture of our portfolio.

As you observe our ALPHA, which measures performance, | underperformed our benchmark
in Jan, Feb, and Mar by (-1.41%, -1.42% and -1.38%, respectively). Our Weighted Average Yield
(WAY) has been steadily increasing, from an average of 0.65% in FY2021 to 4.04% in Mar of 2024.
Attachments 3 & 4 show our interest income with comparable amounts from previous years.
Fiscal year to date of $3,664,194 vs the same time frame FY2023 of $2,150,159.
Please see Attachment 5, our estimated General Fund cash flows for FY 2024.
Please see Attachment 6, our updated bond debt service.
Itis an honor and a pleasure to be in my position as treasurer; I welcome any questions or
suggestions.
Sincerely Yours,
Abbas Danesh - Treasurer
-my next quarterly report will be in July 2024.

oup'ecis
§——
ses'sts'es
wecons
—
zez'ersus
GYOFAILWM
AO
NMOL
-
YWAK
YANO
AVIA
-
SNOILISOd
HSVO
ATL!
sev'osc'ss
§—0az'is
seater
race
exer
zee
ogre
_nwuag
seve
au.0
suena
fq
reonbos
Jed
190.4
peINgUIEPOOW'SIS 8
rou
"WW
PUOWIWEH
{suoyssywuiog
pue
soysouig
saueU
Jo
jonuoD
sepUN)
ars
ft
ung
vorsuag
mene
$
puns
a3d0
suosiapy
Arefoypn
Aq
pabeuew-
seaueieg
o6%e4
sie
ssunoade
snoues
aut
40}
,03
29a,
199481
0U
0G
S20UEIEG
24h
Voo0or
[SCE18
S|
FLL9IN
S|
soos9s
S|
o1v'res
S|
vav'esL
$]eISzE
S|
cer0er9
Sloss
S|
seeer'y
¢
$
S730)
bnezae
—lesvvacze
8/65
s|ssotre
—$
waves.
s|ciszezr
s|
au"
$|ows
$|szemmy
s|
rows
s[sevoree
$
us|
[x00
$
se
$|__
Wr
weR
Lan
Foro
3
orm
E
s[az_—s
=
cin
puta
Lan]
rzee
fneez
$
weessrer
—$|
sbeia09
Krepis
rene
bnero
$s)
ae
=
x00 9
0690)
re
a
&/
4 PA [ee
é
ee =
é TG 4
VALAIS,
le a
A
GYOIYFLYM
4O
NMOL
-
SNOILISOd
HSWD
¥Z0Z/LEIE
1
waunpeny

CDs & Bonds Summary - Town of Waterford, Jan 2024
COA Bank ame arcane Pies | —Ancant
‘ae “matory
TSUTDzG|ORSH AND ACCRUED TEREST 7 Toeee
TZris0z4JUNTED STATES TREAS $ _“ssasto [1000.00
721182024] UNTED STATES TREAS. $ ‘5 2.000,00.
721262024] FEDERAL HOME LOAN BANKS $ ‘5 s00,00.
21272024 UNTED STATES TREAS 5 $00 600
‘3z4I2024]UNTED STATES TREAS. $ 52,000,000
‘ia2024]UNTEO STATES TREAS. $ 5 400,000
723012024] UNTED STATES TREAS. ‘ $0009
‘5/1202 WELLS FARGO BANK KATL ASSN CO $ $a. 600
7162024] UNITED STATES TREAS $ 50000.
{3/2024|GOLOMAN SACHS BX USA CO $ 5 tes.00
‘armen UNITED STATES TREAS. $ '$—Tpoo.000
er307024 UNTED STATES TREAS $ ‘$s 600.00.
87302024 UNITED STATES TREAS. $ 500,00.
13/8/2024] AMERICAN EXPRESS NATL BAN 5 ‘$13,000,
172872024] SALLIE MAE BANK. $ 5 s00
1172024] FLAGSTAR BANK CO 5 Fes 000
Tars2024] JP MORGAN CHASE CO $ ‘$70.00.
aa2024] WELLS FARGO BANK NATL ASSNCO s +
iia024] CHARLES SCHWAB CO 5 +
7287024] FEDERAL HOME LN MTG CORP 5 r
1247024] J MORGAN CHASE CO. s r
{THEHROR4| WELLS FARGO BANK NATL ASSN CO s
#2717024) FEDERAL HOWE LOAN BANKS s $
'1143025| GOLDMAN SACHS BK USA NY CO $sno2e7
{32025 GOLOMAN SACHS BK USA CO swan le
137262025] FEDERAL HOME LOAN BANKS $5000 [
7112025] GOLOMAN SACHS BK USA CO $ nase
Trisaoas TENNESSEE VALLEY AUTH $a
51102025] GOLOMAN SACHS 6K USA 3 s0900 fs
‘7212025 TOYOTA FINL SVGS BANK CO $245.00 fs
51/2025 STATE BANK OF INDIA CO $_245000 Fs
59/2035 FEDERAL HOME LN MTG CORP $100.00 [&
3/18/2025] MERRICK BANK CO $ 245000 Lf
7ia?2025| MORGAN STANLEY CO $1500
11772026] BANK OF AMERICA.CO $ 118000 Fs
aa7025|CMIBANK CO. s
"I3i@026| UNITED STATES TREAS SER U:2026 5 $
37232028] ORGAN STANLEY CO $ Hy
[—-aanzbze| uniTeD states TREAS SER W.2026 $ r
"33172028 UNITED STATES TREAS SERW.2026 s r
7312026] UNITED STATES TREAS SER W2026 s
“4202024 UNITED STATES TREAS SER AA2026 $ $
"s72038| SALLIE MAE BANK 5
‘nig027|uBs BANK CO s +
“207027 FEDERAL HOME LOAN BANKS. $ Es
‘97272027| FEDERAL HOME LOAN BANKS, $ E
737202027] BRIOGEWATER BANK CO s $
Ta7237027| SPIRITBANK HA TULSA OKLA CO $ $
Fuzuz0a7| CELTIC BK SALT LAKE CITY UTAH ED $
1012028] MORGAN STANLEY CO 5 Es
32472028] AMERICAN EXPRESS NATL BANK s 43,000
Taa026] FIRST FED SVGS & LN CO $ ‘$700.00.
31152026] US TREAS SEC STRIPPED INT $ $7.00
“282028 FEDERAL HOME LN HTG CORP 5 #2000
‘7112028] ADAMS COUNTY BANK CO s $ Fes 00
8777028] MORGAN STANLEY CO s $100 00
"12372029| WELLS FARGO BANK NATL ASSN CO 5 ‘sos.
sr072029|FEDERAL FARM CR GKS BOND 3 Ls aon.
187030] FEDERAL HOME LOAN BKS BONO 5 ‘3 — a0
7HI302090] JP MORGAN CHASE CO. 3 ‘$245,000
"THA/030|LIVE OAK BKG CO NC CO 5 $245,000
“i282030]MINNWEST BANK CO s $245,000
anz7930| FEDERAL HOME LN UTG CORP 3 ‘5 too.e00
THIS FEOERAL FARM CR GXS BOND $ 34000
579720335 YNCHRONY GAN CO $ ‘seo
71872042] UNITED STATES TREAS $__sanstr [¢ —6,000
i
Total investments 5 fameste s ss.aras20
Weighted Average Yield 4.09%
owe see
‘Annualized ALPHA (ns264,996),
‘Weighted Average Maturity in Years 179

(CDs & Bonds Summary - Town of Waterford, Feb 2024
ata
ox ame
‘Date
[pests piee | “Anoa
PEEL (GASWAND ACCRUED TEREST
Sawro24
“aa2)
lunteo states TREAS
lUNTED States TREAS
ass024
‘azo2
luNTEO STATES TREAS
|WELLS FARGO BANK NATL ASSN'CO
‘soro2 lUNITED STATES TREAS
wriano2 |UNTEO STATES TREAS
wsz024 \GOLOMAN SACHS BK USACO
wana
waaroa
‘012024
"U0
[= wasraa]
waue0a
‘1172024
lUNITEO STATES TREAS
|UNITEO STATES TREAS
|UNITEO STATES TREAS
[AMERICAN EXPRESS NATL BANK
ISALLIE MAE GANK.
[UNITEO STATES TREAS
[FLAGSTAR BANK ED
Tovts2624 |JP MORGAN CHASE CO
‘ovteze24 [WELLS FARGO BANK NATL ASSN.CO
“anoaa) |chaRLes sciwas co
‘asz02 EDERAL HOME LN MTG CORP
‘sva02624\UNITES STATES TREAS
“yiaea034) JP MORGAN CHASE CO
“yawr0)
{ELLS FARGO BANK NATL ASSN CO
sanri0.|
‘sans
‘Ua7035)
52672026)
[FEDERAL HOME LOAN BANKS
\GOLOMAN SACHS 8K USANY CO
[GOLOMAN SACHS BK USA CO
[FEDERAL HOME LOAN BANKS
Tages |GOLOMAN SACHS Ox USA CO.
THsr035[TENNESSEE VALLEY AUTH
arn2e35
wai2035
|coLoMaN sacks 8k USA
TOYOTA Fit SVGS BANK CO
ou7035
‘wn2035
ans2036
yorw7025
1t7202|
‘tau702
[STATE BANK OF NDLA.CD
|FECERAL HOME LN MTG CORP
[MERRICK BANK CO.
MORGAN STANLEY CO
[BANK OF AMERCA.CO
lergank co
“Wav7034 ONTTED STATES TREAS SER U:2028
aa37034 IMonGaN STANLEY co
aat034
aia034
lUNTED STATES TREAS SERW.2026
\UNITED STATES TREAS SERW.2026
aa17a094 \UNTED STATES TREAS SERW.2026
|UNITED STATES TREAS SER AA.202%
ea07024
2 'SALLE MAE GANK
“Tinaoey
78S BANK CO
e707
aasze2
18S BANK CO
uw BANK CO
|FEDERAL HOME LOAN BANKS
[FEDERAL HOME LOAN BANKS
laRIOGEWATER BANK CO
|SPIRTBANK NA TULSA OKLACO
\CELTIC BK SALT LAKE CITY UTAHCO
[MORGAN STANLEY CO
[AMERICAN EXPRESS NATL BAN
Inst FED Svcs a UNC
US TREAS SEC STRIPPED INT
|aoams counry Bank co.
MORGAN STANLEY CO
|WELLS FARGO BANK NATL ASSN/CO
Ups Bank co
|FECERAL FARM CR XS BONO
[FEDERAL HOME LOAN GKS BOND
JP MORGAN CHASE CO.
live Oak BKGCO Ne CO
Inmnwest BANK co
FEDERAL HOME LX MTG CORP
FEDERAL FARM CR BKS BOND,
[SYNCHRONY BANK CO
UNITED STATES TREAS
Tass
11348000
309812
917200
#77000
ss7020
‘13900
248,00
245 00
268,000
6,600
34.00
740,900
Total Investments
Weighted Average Vield
‘Annualized ALPHA
Weighted Average Maturity in Veors
19275409 $ 19;381203
408%
78267,498)
487

(CDs & Bonds Summary - Town of Waterford, Mar 2024
ata Bank nae [Borsa Pee | — amount
‘ns maturity “| Ye
SB VGOR|CRSW AND ACCRUED TEREST FEvoR AO |S 202A] — a0
‘uzt24]ONTeO STATES TREAS. $ + ‘S80
aiw/a0ad] UNITED STATES TREAS. $ $ re
‘702024 WELLS FARGO BANK NATL ASSNCO s i 84
‘SIZaUZA|UNTED STATES TREAS ‘ 505]
TriabzalUMTED STATES TREAS. 5 304]
‘i874 GOLOMAN SACHS BK USACO 4 “taser [§—‘teso00 | —o-
aster] uNTED STATES TREAS $ —_sen.z03 [¢—yoo,oco | —s |
‘z77a024JUNTED STATES TREAS. 3 svaze7 [5 —soo000 |:
TsbzozilUNTEO STATES TREAS. 3 susse [5 — “cooooo | 535
lonmTeo states TReAS $_svea70 [$s 000600
{ERIGAN EXPRESS NATL BANK, 3 txe00 [sino
Trzartza SALLE MAE OANK 5 ‘000 [$000
eta¥z4JUNTED STATES TREAS. $sezit0 [Ss —iso0000|
‘raaGz4|FLAGSTAR BANK CO $ 248000 [§ “pug 000
7ov182024 Je WORGAN CHASE CO $_“e\coe [$ —"7o.s00
r182024| WELLS FARGO BANK NATL ASSN CO $ enna [¢ ——~se.a00
Tiiaa624| CHARLES SCHWAB CO 323000 [¢ asso
1282024] FEDERAL HOME LN MTG CORP $__ts¢000 [¢ Taxco
goz0zd]UNTES STATES TREAS $aetsta [s—i,s00000
‘202024 JP HORGAN CHASE CO $ e.o00 fs "aoc
‘vB5024| WELLS FARGO BANK NATL ASSN CD $ _ s¥ao00 fs —Tec.ca0
272024) FEDERAL WOME LOAN GARKS ‘saeco [son
{7142025|GOLDMAN SACKS BK USA NY CO 8 '$ i000] — 035]
'G32025]GOLOMAN SACHS BK USAC $_ “ara [s — ‘3.060 | — 0.
‘Wzurezs] FEDERAL HOME LOAN BANKS 4 s8.000 [8,000 | — so
T3823] GOLOMAN SACHS BK USACO $_sstaas [6 —roo.000] —01
Tisrao2s| TENNESSEE VALLEY AUTH! $s “naaze [¢ —ateo.
‘inztrs}GOLOVAN SACHS GK USA $ taco Ls roo
Wzuatzs]TOvOTA FIN SVGS BANK CO $3 1us.000 [5 aus c00
472028] STATE OANK OF INDIA CO $ 248.000 [¢ ras c00
ina078] FEDERAL HOME LM MTG CORP $ too 60
asaa2i]meRricK Gan CO 5 $243 200
ar142025| MORGAN STANLEY CO $ sta
THI72025| BANK OF AWERICA CO. s $1600
‘Tvauezeleribank co $ a | §— ro000
aoa6| UNITED STATES TREAS SER U.2020 5 00 coo
[32372074] MORGAN STANLEY CO $ 00
[Sauabze]UNTED STATES TREAS SER W.2026 $ foo 00
[Sauatat] UNITED STATES TREAS SER W.2026 $ 5100600
‘a17024] UNITED STATES TREAS SER 2026 $ ‘$00 900] — 0705)
JUMITED STATES TREAS SER AA 2026 $ 100,000
[saLLie wae Bann 5 ETN
lues warn co $ 37300
luBs Bann co $ 52800
‘BANK CO $ §—Toe00
LLS FARGO BANK NATL ASSNCO 5 tos 00
(GAN STANLEY CO $ 5 Tigao
FEDERAL HOME LOAN BANKS 5 iano
|FEDERAL HOME LOaW BANKS 4 5189000
JoROGEWATER BANK CO + 524800
|SPRITBANK NA TULSA OKLA CO. $ 5200000
Icetnc 8x SALT LAKE crry UTAH CO $ 200 00
IMORGAN STANLEY CO s “as 00
RICAN EXPRESS NATL BANK 3 $——ta00
Inst Feo SvGS BNC 4 ‘50.00
lus TReAs Sec STRIPPED INT $ [ssn
‘COUNTY BANK CO 5 5 2as 00
Iocan STANLEY CO 3 5 ton 00
WELLS FARGO BANE NATL ASSNCO + 5 sh00
lues eanx co 3 + vane
IFeOERAL FARM CR BKS BOND $ ‘§—to0.00| —ta35]
IFEDERAL HOME LOAN BxS BONO 5 '$— doe00| — e003]
|s9 woRGAN CHASE co i ‘$_—aes00 | — 1003]
luve oax Bx co ne co 3 ‘3 2as00] —o 985
Innnowest Babe co rs 's—24s.00| a9]
TATOO FEDERAL HOME LN MTG CORP 3 5 too 00 | iat]
22031 FEDERAL FARM CR BKS BOND 7 $4000 | 6.00%]
“9128 2033| SYNCHRONY BANK CO 5 $—wa.e00 | son]
Tae NsTeD STATES TREAS = $—seac00 |v)
Toto! vestments $ rosenass 5 19426400
Weighted Average Yield 400%
wwe se
Annualized ALPHA (mns267,600),
Weighted Average Maturiy in Yoors 182

loruvus
corres
secs
vues
costars:
serzees
LENS
Levees!
usz8s
L9Us6ES
OF
iste
yar
panrenuur}
leer
ot
we
oy
a
at
a
a
we
won|
owe
ese
saweo
usv0
oor
uly
co
SOP
MO
tse
ae
awe
aT
vel
eounr
wekew
yeudy
peveN
peed
Per
E7290
ETAON
E2190
Eades
ee-Bny
EZINe
Ty EY EY boo

sea,
[e914
pz0zitele
-
SANN4
T1V
-
SONINUV]
LS3yaLNI
GYOsuaLYM
4O
NMOL
eneuony
ewioduy ys220}U}

execs
sortoes
costs
arenes
‘onna
ssn
e340}
eects
artes
TES
ETS
aS
WKS
arses
paces
HsvUaTs
evn
nonsna
lrcrvosies
sueuzo'es
SLEEVES
“POOOREHS
GEV'OLLS
SRO'GICE
CHOZELS
ZOr'SSLS
LON'SLIS
CeLISIS
ose'zeIS
cLO'SOCs
a9vNWW
waunsvaus
W404]
ee
ee
ec
‘oka
NOLMUUSINIRGY
vonvas
levees
cesenss
uses
sree
totes
wees
sess
ms
“w
6
us
oss
vous]
ss
=
6
6
oo
ws
sts
ms
ees
‘%
ooinstiom
axoneaiva
wens
ses
tms
ness
sates
warns
eras
warts
ets
ess
TS
ssf
GNU
ANaNaor
sata
waoNvnaiAivo
ana]
-Lvanaownwn
ann}
sevees
anos
caves
NS
tows
ess
ests
wee
sevens
owes
tess
GRIST
eeoers
certs
ares
ess
teers
OTE
unatnoneNON
WHO]
eves
veymons—onrest”GrTGIS—wseIsevsonseraus
sks
ens
onrcns
‘oxn
waa
GERERIOE
HRC
ATGE
TRE|
TOES
SIOESTOE
Siar
WISE
WIOERION
CTOEEIOE
era
Tine
WiGEONOE
a
a
7
cnn
ae
eT
a
A
Pee
16
WHE AO
SY
FEOE Ad
HOE
SNNa
CUOINILVA
JO
NAO.L~
AWOONI
ISANTLNT

veoz/ez/y
syoday
saunsea,
p2-Te-€\pZ0Z-TE-€\oday
seqqy\dorysaq\ysauepe\siasn\:>
000'9ze'8z
$
o00‘0Es‘£
$
O00‘9ST'9E
$
o00'9st'9e
$
o00‘08"£
$
000'986'er
$
000'986'Er
$
000‘0€8‘s
$
000'9T8"TS
$
UUOW
Jo
pus
jeg
SQ
ONusAay
Xe]
@21A1ag
199q
Auuow
eouejeg
puny
je12ue5
PLOPA}eM
JO
UMOL
-
MOJ-4
YSED
puny
jesIUaH
pazeuyysy
ZOZ
Eun
-
yZ0z
Id
gjuawyseny
anor}
AVN
hiv

[Attachment 6
BOND DEBT SERVICE
Outstanding Debt Service Post 2020 Taxable Refund
Town of Waterford, Connecticut
Fiscal Year Principal
2025 $6,595,000
2026 $6,645,000
2027 $6,395,000
2028 $5,545,000
2029 $5,770,000
2030 $5,375,000
2031 $5,340,000
2032 $3,635,000
2033 $3,570,000
2034 $1,585,000
2035 $680,000
2036 $680,000
2037 $680,000
2038 $680,000
2039 $680,000
2040 $680,000
2041 $680,000
$55,215,000
Interest
$1,514,746
$1,319,500
$1,083,426
$829,375
$632,762
$482,770
$344,138
$239,800
$166,780
$114,224
$91,800
$78,200
$64,600
$50,575
$36,125
$21,675
$7,225
$7,077,719
Debt Service
$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
$62,292,719)