Treasurer Report 6.30.2024

7-25-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 6/30/2024.
The following attachments are included for reference:
Attachment 1 — 6/30/2024 Cash Positions & QTLY Cash Positions — Town of Waterford
Attachment 2 ~ CDs & Bonds Summary ~ Town of Waterford
attachment 2 April ~ June & attachment 2 combined
Attachment 3 ~ Graph of Total Interest Income vs. Fiscal Years
Attachment 4 ~ Interest Income by Funds vs. Fiscal Years
Attachment 5 - FY 2025 Estimated General Fund Cash Flow
Attachment 6 - Bond Debt Service
Attachment 7 — Detailed Bond Debt Service FY2025 to FY2032
Attachment 7 combined Bond Debt Service FY2025 to FY2032
Going over our three baskets/institutions:
Averages for STIF interest rates
April 5.42%, May 5.42%, June 5.42%
People’s Savings interest is at 3.25%.
Fidelity account activities:
: One Mil treasury and 400K treasury matured, Purchased two Mil treasury maturing
6/2024, 41K Bank of America CD maturing 4/2026 and 400K Agency Bonds maturing 4/2034.
May: Two Mil treasury & 87K Wells Fargo CD matured. Purchased one Mil treasury
maturing 8/2024, one Mil treasury maturing 4/2025, one Mil treasury maturing 5/2025, 109K Bank of,
America CD maturing 5/2026, SK Morgan Stanley CD maturing 5/2029 & 30K Agency Bonds
maturing 5/2031.
June: Four Mil Treasury & 166K Goldman Sachs CD matured. 70K JP Morgan CD was
called. Purchased one Mil treasury maturing 10/2024, one Mil treasury maturing 12/2024, one Mil
treasury maturing 2/2025, one Mil treasury maturing 5/2025 & 241K Morgan Stanley CD maturing
6/2029.
Please see Attachment | cash positions as of 6/30/2024. Please note on bottom of the page,
the quarterly cash positions-year over year.

RK,
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 April, May, and June by (-1.34%, -1.33% and -1.30%, respectively). Our Weighted Average Yield
(WAY) has been steadily increasing, from an average of 0.65% in FY2021 to 4.12% in June of 2024.
Attachments 3 & 4 show our interest income with comparable amounts from previous years.
FY 2024 of $4,614,433 vs FY 2023 of $3,027,719.
Please see Attachment 5, our estimated General Fund cash flows for FY 2025.
Please see Attachment 6, our updated bond debt service.
Please see Attachment 7, our detailed bond debt service annually to FY 2032....total principal
due...our weighted average interest payments & weighted average maturity in years.
Please see Attachment 7 combined
«as of 7/1/2024... we have $55,215,000 outstanding Bonds...which we pay 2.92% annual
interest...with average maturity of 4.63 years.
.-.with our current outstanding Bonds, by FY 2032....we will have $13,550,000 in outstanding
Bonds...which we'll pay 2.04% annual interest...with average maturity of 2.78 years.
Itis an honor and a pleasure to be in my position as treasurer; I welcome any questions or
suggestions.
Sincerely Yours,
App |oo
Abbas Danesh - Treasurer
-.-my next quarterly report will be in Oct 2024,

ns eases
T
‘Goose
eveeenss
veers
wuss
peetars
(oocosoes
—ss0'ess—ais'zses—aszeav'es
[ss
BEE
i
t
—
|)
sane
smo
9
so0bra
Kanara BOW
PEAR
OBESE
TY
WOH
PUOUIEH
t { { | sivieeeh 4 fund e340 | sonvov kena Kapebumn sro 3 sm
{
{
ae
sino
never
6
64
#9
um
ow
oa
sou
wu
——|
|
BaD
ER
—F
[OOS
WLL
&
[REPRE
—¥
[waETEFOF
[WAET
=F
|
aa'eeeT_$
[oar
vin
Ths
[oaveeaE
5]
sre]
BHEOLL—§ |
verte
—¥
|
sAriavs—$
[seers]
Tee
STORIE
—
STATE
F
jews]
See wo
vj
GYOIUILVM
4O
NMOL~SNOLLISOd
HSVD
PZ0Z/0E/9

aati ;
(CDs & Bonds Summary - Town of Waterford, April 2024
a ono Tame | —
ous aratety_| Wa
[CASH AND ACCRUES TEREST Taree] yaar — sl
—iz24} WELLS FARGO BANK NATL ASSH‘CO 3" "tr0oo [s—“areco, — sora
‘aoat|Unreo Srares meas 4a 20 [$—touooo | el
Twrsad|UNTED STATES TEAS 3 voonoos [$e soo —:
i024] COLOMAN SACHS GX USA CO $__Wraser [4 takooo | — oa
‘awratadJuNrreD STATES TREAS ~~ ans203 [000.0007 — 5395]
Taba/UNITED STATES TREAS 5 —sare3ee [520.00 | — eae]
trisz4|UNTED STATES TREAS 3—"Staaer [5 — Coon — a
7024] UNITED STATES TREAS $Sasies [4 — sooo) — ea
‘eal uneD STATES TREAS $—sroore [$~aonaooo| —e]
{812001 AWEROCAN EXPRESS NATL BANK 4—"t3en0 [tan] — 3
erszt| SALLE Mae BANK +
tzu] UNITED STATES TREAS a
‘revat|FLAGSTAR BANK CO. $
“rs/aset sp WORGAN Guase CO +
Wels FARGO Oat NATL ASSHCD as
zal CHARLES SENS CD +
FeoenaL nome Ux wt CORP 3 tneooo [5
nes srates reas 1s amen fe
[2? WORGAN CHASE CO Ts“ taooo
felts FAROO BANK NATLASEN'CO 1s goes
IFEDERAL Wome LOAN Bans 1s saoo0 fF
{GOLOMAN SACHS Ox USA Wr CO [boon |
‘796/GOLDUAN SACHS OX USACD 3 aaa
[/—wauaozs reoeAL Howe LOAN aA 4 seeo rs
| —“rmzas'cot owas sacs ex usAco 3 sineas [saan
Trane TeNWESSE® VALLEY AUTH $m
‘uia2sas| GOLDMAN SAGHS BX USA $e0eo fs
| —eaiaeas vorota ine svo8 ean co [3 aes 000
“GUSH STATE BANK OF OA CO 1s oo
‘132025| FEDERAL HOME LMT CORP $5 taaees Pe
“anizos] MERRICK BANK CO i $
“oriaastslnonaan Srantey CO 5
‘i285 oAve Or aUemicA CO is 5
Haarezslemennn co rs $
aise tt i
—saaaea| 4 tho |§ —3.509| —s.08)
[xovaszs onTeD staves TREAS SER W028 280 [¥
Sitvanze|UnteD STATES TREAS SER W.2008 + sases
~aisvzen|uNTED STATES TREAS SER W028 + mast
-tryamalanun OF AERCA CO $atooo fF
‘enorzas| NED STATES TREAS SER AA2028 3 mees Ts
4 aeaeoo [s
[vee 3 "raooe FF
unez 4 aewo
Prue 3 soet0o
‘82077 $takooe FF
wuezr + $
sass 4 A
2 if+8 +s
1
+
+
+
+
JUS TREAS See stiupreD wr +
—trrzeaa|abaus county eannc co +
‘rman uonennstancerco +
(22029 WELLS FARGO BANK NATL ASSN CD +
ais Ubs BANK CO +
‘8501209 FEDERAL FAR CR HS BOND 3
BelLve oak Bxa Co Ne cD in
lannavest sank co Te
FEDERAL HOME LX WIG CORP $
FEDERAL FaRu GR OKs BOND ars
SYNCHRONY Bank CO 03
+
[OneD STAvES TREAS 3 sue
a I EE
‘Total investmente $ sasmo1 $ toaseare
| Weighted Average Viela T 408%
oe 4 se
Annualized ALPHA sar
Weighted Average Maturity in Years 197

CDs & Bonds Summary - Town of Waterford, May 2024
Coa} Fae
[CASH ANG RECRIEOTNTEREST
IcoLouan sachs ex USA CO
lbwreo STATES TREAS
IUMTED STATES TREAS
[UTED STATES TREAS
luateD STATES TREAS
lunTeD STATES TREAS
AMERICAN EXPRESS WATL BANK
ISALLE MAE BAN.
[DwTeo sTATes TREAS
lune STATES TREAS.
JFusasraR wane co
[uP MORGAN CHASE CO
WELLS FARGO BANK MATL ASSNCO
Jcuanies scrwas co
FEDERAL HOME LN MTG CORP
MERCK BANK CO
MORGAN STANLEY CO
{BANK OF AMERCAED
femeank co
UMTED STATES TREAS SERUIER0
MORGAN staNLeY co
lnteo STATES TREAS SER w.2028
lune STATES TREAS SER Wi2030
louteD STATES TREAS SER W.2020
laanx oF auenica co
Bank oF awenica €O
NITED STATES TREAS SER AA 2020
ae BAN
(CELTIC OX SALT LAKE CTY UTANE
{MORGAN stameY cD
[AMERICAN EXPRESS NATL HANK
[rast Feo svos aco
lus TReAs see stRPPEOT
COUNTY BANK CO,
[MORGAN STANLEY CO
at
Ee ree
‘2029, FEDERAL FARM CR OX BONO
‘s142000 FEDERAL HOME LOAN BXS BOND
FARGO BANK NATEASSHCD
JPMORGAN CHASE CO
‘Tia7030] VE OAK 8KG CONG CO
702939)
"Hinva0i0|FEDERAL HOME LN MTG CORP
MINE Bank CO
1142033] FEDERAL HOME LATS CORP
EDERAL FARM CR BKS BOND
1172033] SYNCHRONY BANK CO
iva FEDERAL HOME LA MTG CORP
[UWITED STATES TREAS
Total Investments
Weighted Average Vela
swe
‘Annualized ALPHA
‘Weighted Average Maturity In Yours

Rae
[Ds & Bonds Summory - Town of Waterford, June 2004
‘Batty Bank Nee aan me
matty
in000841CASW AND ACCRUED TEREST Tne
‘iaaze24UMTED STATES TREAS $—winoeo!
tusazoza] UnTeD STATES TREAS ono
‘Si2024|AMERICAN EXPRESS NATL BANK
—aetanze saute Mae ean
{Hzin02]UNTED STATES TREAS
isa] UNITED STATES TREAS
[FEDERAL Wome LN WTO CORP
| -—areaoasluerack Bann co.
IMOROAN STANLEY CO
laanx oF auericnco
lemaanxeo
lUuTeo STATES TeeAs SER U-I026
[MORGAN STANLEY CO
Unie STATES TREAS SERW2000
laanx OF AMERICACD
[Bank OF AMERICA CO 5 —ioaoo
|UuTeD STATES TREAS SER AA-026 ‘$—toaseel — 0s
ISALUE MAE aan $—saqe00]| 84
KO 's—T000] 
— a00%4
‘202027065 BANK ED $—zaooo | a3
joaNK CO “$—iteero| as
[32027] WELLS FARGO BANK NATL ASSN CO “keoe|
2027 MORGAN STANLEY CO Tete] — 406
{Wane PEOERAL WOME LOAN BANKS “intone — Sox]
THDBOGT|FEDERAL HOME LOAN GANKS. “inteee| —esox]
lompcewareR aanx co zixeso| — e704)
IRITOANK NA TULSA ORLACO 2oneoe|
zt] ee IC BK SALT UKE CITY UTAH CO —teneco| ar
‘1702 WORDAN STANLEY CD |
“22083 SYNCHRONY BANK CO
-Sraz0oaPEOERAL HOME Ut TG CORP
iwaoes|unTeD STATES TREAS
lalalofe P= PePrrrt aagao rerrrrr
5 Wasianer § ioasosee
40%
‘Annualized ALPHA t a,
Weighted Averoge Maturity In Years 2a


sea,
1eOSi4
rears
costs
g
i
‘ewiodu| }Se10}U,
$Z0Z/0€/9
-
SANN4
T1V
-
SONINNV3
LSaYSLNI
GYyOsNaLVM
JO
NMOL
ewmuxonny

cess
eves
(GUST
esviowts
seve
—_fvortoss
—Swessts
Saar
o
t
‘xn
asa
0340
‘ooress
cere
evens
jeeeues—ervers
—sorees
sens
is
[z0s'as4s
cez'isis
[ove'zais
c10's0R8|
caovNvi
waunsvauL
W104]
evo
eves
tensors)
naveres
|
eeees
|
eres
ners
‘anna
Novena
lcvvsa'ys
‘enc'zeo'es
ast'eoes
‘veu'eons
cxssci'ss
[vaotone ss
[esv'oscs
exs'eutt
cha
z6t8
en
uNoUvassiNInavEaNMana|
levers
veseees—etts
eos
sss
jars
fesees
ene
lores
owes
sees
—eavens
leans
cessor
tne
foes
roses
fre
os
1
oa
a
is
a
s
100104 Ho
axons
brn
peeves
surah
tome
ess
aes
ese
fees
ferree
aris
ss
=
i
|
gina
weanaoraxaa
wsoeauNnne
a]
lestes
avers
ever
res
sevens
novos
co's
esr
sees
eeves
jase
ve)
sana
aru
lessees
evens
rset
Tews
estos
aaoens
esse
wes
aes
eect
fares
loes
aunwaroaw Non
WN
“wove
losis
‘on
wean]
a
ie
ie
—
REO|
HORESTOE |
SUOEWTREWIOETHOE|
TTR
COE
TIRE
|
HOTTRE
a
iI
#20
06
700
IO
SVC
Ad
WOT

y202/S27/L
spoday
sainseasl
»2-0€-9\pZ02-0¢-9\uoday
seqqy\dorysaq\ysauepe\siasf\:3
|
000'0v0'2
$
O00%000'00T
—$
svz‘60t's
—$_00'000‘0ZT‘66
1201
ore'eev'zz
$
o00'ort
$
|
ooo'osz's
«|
Ote"ezs’sE
$
ann]
O16‘EzS'SE
$
_000'0LT
$|
000'092'8
$
ore'et9'ey
_
$
AWM
Or6'er9'er
$_000'oct
$|
000'097's
$
_
ot6'e0z'ts
$
Tray]
O16‘E0L'TS
$
o00'0LT
$
0so'69T
$
|
000'092'8
$
_096'296'6S
$a
096'296'6s
$
000'0ct
$
viz‘ovs
$
000°092'8
$_
ver'e6s‘89
$
aad
‘Lt‘E6s'89
$
o00'0ct
$
000‘000'2t
$
0000928
$
vct'ess'6s
$
_NVE
vLT'e89'6S
$
|
000'oct
$_
000'000'
$
000‘092'8
$
vLT'ELL'09
$
oad
vLU'ELL'09
$
000'oct
$}
000‘092'8
$
vét'e98'89
$
AON
vLt'E98'89
$
|
o00’0ct
al
[
000'092'8
$|
ver'es6'94
$190)
VLT'ES6'9L
$
_o00'oct
$
[series
$
000'097'8
$
|
eve'vt6'se
$_
aas|
Gre'pte'ss
$
o00'oct
$|
o00°000"Tr
$
Loe‘ezs'9
$
o00'092"'s
$
9so'ees‘e8
$
ony
gso'E€s'6s
$
_000'0LT
$|
000‘000's9
$
|
000'092'8
$
_gs9'ez9'ze
$|
Ata}
UJUOW 40
puajegysy
—
ewZ09u
3S915;u]
‘anuanoy
xeL
ad1Alas
1990
|
Awuow
=
s9uejegq
puny
Je10U29
|
psoplajeyy
JO
UMO]
-
MOj-4
YSED
puny
jesaUED
poyeusjsy
Szoz
euNe
-
pzOz
AlN
g
wewyoeny

[Attachment 6
BOND DEBT SERVICE
Outstanding Debt Service Post 2020 Taxable Refund
‘Town of Waterford, Connecticut
Fiscal Year
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
Principal
$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
$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|

‘Aachen FY 20S
[Detailed Bond Debt Service - Town of Waterford, FY 2025
Pay off
Dato ‘Bond Components Principal | Interest
'8/18/2024]$9,440,000 GO Refunding, Issue of 2014 $835,000
£8115/2025|$9,440,000 GO Refunding, issuo of 2014 $840,000 | 6.00%,
£8/18/2026|$9,440,000 GO Refunding, Issue of 2014 $ 845,000 |.
8/1/2024|$14,585,000 GO Refunding, Issue of 2017 $1,086,000
£8/1/2026|$14,585,000 GO Refunding, Issue of 2017 $1,070,000
8/1/2026|$14,585,000 GO Refunding, issue of 2017 $2,830,000
| ___8/412027]$14,585,000 GO Refunding, Issue of 2017 $2,820,000
8/4/2028] $14,585,000 GO Refunding, Issue of 2017 $4,070,000
8/112029| $14,585,000 GO Refunding, Issue of 2017 ‘$685,000
8/1/2030] $14,585,000 GO Refunding, Issue of 2017 $680,000
'8/1/2024] $9,085,000 GO Refunding, Series 2019 ‘$855,000 | 5.
8/1/2025] $9,085,000 GO Rofunding, Sorios 2019 ‘$870,000 00%|
'8/1/2026| $9,085,000 GO Refunding, Series 2019 ‘$885,000 | 5.
8/1/2027] $9,085,000 GO Refunding, Series 2019 ‘$905,000
'8/1/2026] $9,085,000 GO Refunding, Series 2019 ‘$918,000
'8/1/2028| $9,085,000 GO Refunding, Sorios 2019 ‘$950,000
8/1/2030] $9,085,000 GO Refunding, Series 2019 ‘$960,000
'118/2024]$13,655,000 GO, Issue of 2020 ‘$685,000
'/18/2025|$13,655,000 GO, Issue of 2020 ‘$685,000
'9/18/2026|$13,655,000 GO, Issue of 2020 ‘$685,000
'9118/2027|$13,655,000 GO, Issue of 2020 ‘$685,000
'9/16/2028]| $13,655,000 GO, Issuo of 2020 ‘$686,000
'9/1512028] $13,655,000 GO, Issue of 2020 ‘$685,000
‘9/18/2030 $13,655,000 GO, Issue of 2020 ‘$685,000
'9/18/2031|$13,655,000 GO, ‘$685,000
| a18/2032| $13,685,000 Go, ‘S__ 680,000
'$13,655,000 GO, ‘$680,000
[$13,655,000 Go, ‘$680,000
[$13,655,000 GO, ‘$680,000
[$13,655,000 GO, Issue of 2020 ‘$680,000
[$13,655,000 GO, Issue of 2020 ‘$680,000
[$13,655,000 GO, Issue of 2020 $680,000
'$13,655,000 GO, Issue of 2020 $680,000
— '$13,655,000 GO, Issuo of 2020 $680,000
'8116/2024]$28,890,000 GO Refunding Bonds, ‘$3,136,000
'8/45/2025|$28,890,000 GO Refunding Bond: ‘$3,180,000
'8/1512026| $28,890,000 GO Refunding Bond: ‘$1,150,000
8/16/2027] $28,890,000 GO Refunding Bond: ‘$1,135,000
8/15/2028] $28,890,000 GO Refunding Bond: [$3,100,000
'8/15/2029]$28,890,000 GO Refunding Bonds, $3,088,000
8/15/2030] $28,890,000 GO Refunding Bond: $3,018,000
'8/15/2031]$28,890,000 GO Refunding Bond: $__ 2,950,000
8/18/2032]$28,890,000 GO Refunding Bond: $2,890,000
'8/15/2033|$28,890,000 GO Refunding Bonds, Series 20208 | $ 308,000
|
‘Total Principal Due $55,215,000 |
Our Weighted Average Interest Payment 2.92%
Weighted Average Maturity in Years 4.63

‘Ailachment 7 FY 2006
Detailed Bond Debt Service - Town of Waterford, FY 2026
Pay off
Date Bond Components Principal Interest
8/15/2025|$9,440,000 GO Refunding, Issue of 2014 $ 5.00% |
8/16/2026 |$9,440,000 GO Refunding, Issue of 2014 $ 5.00%!
8/1/2025|$14,585,000 GO Refunding, issue of 2017 $ 5.00%)
8/1/2026|$14,585,000 GO Refunding, Issue of 2017 $s 5.00%
8/1/2027|$14,585,000 GO Refunding, Issue of 2017 $ 5.00%)
8/1/2028] $14,585,000 GO Refunding, Issue of 2017 $ 4.00%|
8/1/2029|$14,585,000 GO Refunding, Issue of 2017 $s 4.00%
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 4.00%!
'8/1/2026| $9,085,000 GO Refunding, Series 2019 $ 5.00%|
8/1/2026) $9,085,000 GO Refunding, Series 2019 $s 5.00%!
8/1/2027|$9,086,000 GO Refunding, Series 2019 $ 5.00%!
'8/1/2028] $9,085,000 GO Refunding, Series 2019 $ 4.00%
8/1/2029] $9,085,000 GO Refunding, Series 2019 $s 4.00%
'8/1/2030| $9,085,000 GO Refunding, Series 2019 $ 4.00%
3/16/2026] $13,655,000 GO, Issue of 2020 $ 5.00%|
9/16/2026| $13,655,000 GO, Issue of 2020 $ 685,000 5.00%!
9/15/2027|$13,655,000 GO, Issue of 2020 $s 685,000 5.00%!
9/18/2028)$13,655,000 GO, Issue of 2020 $ 685,000 5.00%!
9/16/2029] $13,655,000 GO, Issue of 2020 $ 685,000 4.00%
9/16/2030|$13,655,000 GO, Issue of 2020 $ 685,000 3.00%|
9/16/2031|$13,655,000 GO, Issue of 2020 $ 685,000 3.00%|
9/16/2032| $13,655,000 GO, Issue of 2020 $ 680,000 3.00%!
9/15/2033|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2034|$13,656,000 GO, Issue of 2020 $ 680,000 2.00% |
9/15/2035 | $13,655,000 GO, Issue of 2020 $ 680,000 2.00% |
9/15/2036 $13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/15/2037 |$13,656,000 GO, Issue of 2020 $ 680,000 213%!
9/15/2038|$13,665,000 GO, Issue of 2020 $ 680,000 2.13%!
9/18/2039 /$13,655,000 GO, Issue of 2020 $ 680,000 213%
9116/2040)$13,655,000 GO, Issue of 2020 $ 680,000 2.43%}
8/16/2025|$28,890,000 GO Refunding Bonds, Series 2020B $3,180,000 0.78%
8/16/2026) $28,890,000 GO Refunding Bond: ries 2020B $1,150,000 1,03%|
8/15/2027|$28,890,000 GO Refunding Bonds, Series 2020B $1,136,000 1.19%|
8/15/2028) $28,890,000 GO Refunding Bonds, Series 20208 $3,100,000 1.47%)
8/15/2029) $28,890,000 GO Refunding Bonds, Series 2020B $ 3,055,000 1.67%)
8/15/2030|$28,890,000 GO Refunding Bonds, Series 2020B $3,015,000 1.67%
8/16/2031 |$28,890,000 GO Refunding Bonds, Series 2020B $2,950,000 1.75%
8/18/2032|$28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%!
8/15/2033|$28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.98%)
Total Principal Due $48,620,000
Our Weighted Average Interest Payment 2.92% |
Weighted Average Maturity in Years 4.24

‘Atiachment 7 FY 2027,
Detailed Bond Debt Service - Town of Waterford, FY 2027
Pay off
Date Bond Components. Principal Interest
8/15/2026|$9,440,000 GO Refunding, Issue of 2014 $ 845,000 5.00%
8/1/2026|$14,585,000 GO Refunding, Issue of 2017 $ 2,830,000 5.00%
8/112027/$14,585,000 GO Refunding, Issue of 2017 $ 2,820,000 5.00%
8/1/2028 /$14,585,000 GO Refunding, Issue of 2017 $ 1,070,000 4.00%
8/1/2029 |$14,585,000 GO Refunding, Issue of 2017 $ 685,000 4.00%
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 680,000 4.00%
8/1/2026 |$9,085,000 GO Refunding, Series 2019 $ 885,000 5.00%
8/1/2027 |$9,085,000 GO Refunding, Series 2019 $ 905,000 5.00%!
8/1/2028 $9,085,000 GO Refunding, Series 2019 $ 915,000 4.00%
8/1/2029|$9,085,000 GO Refunding, Series 2019 $ 950,000 4.00%
8/1/2030|$9,085,000 GO Refunding, Series 2019 $ 960,000 4.00%
9/15/2026) $13,655,000 GO, Issue of 2020 $ 685,000 5.00%!
9/15/2027|$13,655,000 GO, Issue of 2020 $ 685,000 5.00%!
9/15/2028] $13,655,000 GO, Issue of 2020 $ 685,000 5.00%
9/15/2029|$13,655,000 GO, Issue of 2020 $ 685,000 4.00%
9/15/2030|$13,655,000 GO, jue of 2020 $ 685,000 3.00%!
9/16/2031) $13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/15/2032|$13,655,000 GO, Issue of 2020 $ 680,000 3.00%
9/15/2033] $13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2034| $13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/18/2035] $13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/15/2036|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2037|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%!
9/15/2038 /$13,655,000 GO, Issue of 2020 $ 680,000 2.13%!
9/15/2039 /$13,655,000 GO, issue of 2020 $ 680,000 2.13%!
9/15/2040|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%
8/15/2026|$28,890,000 GO Refunding Bonds, Series 2020B $ 41,150,000 1.03%
8/16/2027|$28,890,000 GO Refunding Bonds, Series 2020B $ 1,135,000 1.19%!
8/15/2028|$28,890,000 GO Refun Bonds, Series 2020B $ 3,100,000 1.47%
8/15/2029/$28,890,000 GO Refunding Bonds, Series 2020B $ 3,055,000 1.57%!
8/15/2030|$28,890,000 GO Refunding Bonds, Series 2020B $ 3,015,000 1.67%!
8/15/2031/|$28,890,000 GO Refunding Bonds, Series 20208 $ 2,950,000 1.75%!
8/15/2032) $28,890,000 GO Refunding Bonds, Series 2020B $ 2,890,000 1.85%
8/15/2033) $28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.95%!
Total Principal Due $ 41,975,000
Our Weighted Average Interest Payment 2.91%
Weighted Average Maturity in Years 3.89

‘Attachment 7 FY 2028_
Detailed Bond Debt Service - Town of Waterford, FY 2028
Pay off
Date Bond Components Principal Interest
8/1/2027/$14,585,000 GO Refunding, Issue of 2017 $2,820,000 5.00% |
'8/1/2028| $14,585,000 GO Refunding, Issue of 2017 $1,070,000 4.00%
'8/1/2028|$14,585,000 GO Refunding, Issue of 2017 $685,000 4.00%)
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 680,000 4.00% |
8/1/2027|$9,085,000 GO Refunding, Series 2019 $ 905,000 5.00%|
8/1/2028] $9,085,000 GO Refunding, Series 2019 $ 915,000 4.00%
8/1/2029] $9,085,000 GO Refunding, Series 2019 $ 950,000 4.00%
8/1/2030] $9,085,000 GO Refunding, Series 2019 $ 960,000 4.00%
9/1512027| $13,655,000 GO, Issue of 2020 $ 685,000 5.00%)
9/15/2028] $13,655,000 GO, Issue of 2020 $ 685,000 5.00%
9/15/2029|$13,655,000 GO, Issue of 2020 $ 685,000 4.00%
9/15/2030|$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/16/2031 |$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/15/2032|$13,655,000 GO, Issue of 2020 $ 680,000 3.00%
9/15/2033|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2034|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2035) $13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2036) $13,655,000 GO, Issue of 2020 $ 680,000 2.00%|
9/15/2037| $13,655,000 GO, Issue of 2020 $ 680,000 2.13%|
9/15/2038) $13,655,000 GO, Issue of 2020 $ 680,000 2.13%
9/15/2039}$13,655,000 GO, Issue of 2020 $ 680,000 2.13%|
9/16/2040|$13,655,000 GO, Issue of 2020 $680,000 2.13%
8/15/2027 |$28,890,000 GO Refunding Bonds, Series 2020B $1,135,000 1.49%)
8/15/2028 |$28,890,000 GO Refunding Bonds, Series 2020B $3,100,000 1.47%)
'8/15/2029|$28,890,000 GO Refunding Bonds, Series 2020B $3,055,000 1.57%
8/15/2030/|$28,890,000 GO Refunding Bonds, Series 2020B $3,015,000 1.67%
8/15/2031 |$28,890,000 GO Refunding Bonds, Series 2020B $2,950,000 1.75%
8/15/2032|$28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%
8/15/2033|$28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.95%
Total Principal Due $ 35,580,000
_ Our Weighted Average Interest Payment 2.66%
Weighted Average Maturity in Years 3.57

Attachment 7 FY 2028
Detailed Bond Debt Service - Town of Waterford, FY 2029
Pay off
Date Bond Components Principal | Interest
8/1/2028| $14,585,000 GO Refunding, Issue of 2017 $1,070,000 4.00%
8/1/2029|$14,585,000 GO Refunding, Issue of 2017 $ 685,000 4.00%!
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 680,000 4.00%
8/1/2028|$9,085,000 GO Refunding, Series 2019 $ 915,000 4.00%
8/1/2029|$9,085,000 GO Refunding, Series 2019 $ 950,000 4.00%
8/1/2030|$9,085,000 GO Refunding, Series 2019 $ 960,000 4.00%
9/15/2028 |$13,655,000 GO, Issue of 2020 $ 685,000 5.00%
9/15/2029|$13,655,000 GO, Issue of 2020 $ 685,000 4.00%
9/15/2030|$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/15/2031 |$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/1512032|$13,655,000 GO, Issue of 2020 $ 680,000 3.00%!
9/15/2033|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/15/2034|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/15/2035}$13,655,000 GO, Issue of 2020 $ 680,000 2.00%!
9/15/2036 | $13,655,000 GO, Issue of 2020 $ 680,000 2.00%|
9/15/2037|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%
9/15/2038|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%
9/15/2039|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%)
9/15/2040|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%
8/15/2028|$28,890,000 GO Refunding Bonds, Series 2020B $3,100,000 1.47%)
8/15/2029|$28,890,000 GO Refunding Bonds, Series 2020B $3,055,000 1.57%
8/15/2030|$28,890,000 GO Refunding Bonds, Series 2020B $3,015,000 1.67%
8/15/2031|$28,890,000 GO Refunding Bonds, Series 2020B $___ 2,950,000 1.75%
8/15/2032|$28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%|
8/15/2033|$28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.95%
Total Principal Due $ 30,035,000
Our Weighted Average Interest Payment 2.37%
Weighted Average Maturity in Years 3.21

‘Attachment 7 FY 2030
Detailed Bond Debt Service - Town of Waterford, FY 2030
Pay off
Date Bond Components Principal__| Interest
8/1/2029|$14,585,000 GO Refunding, Issue of 2017 $ 685,000 4.00%!
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 680,000 4.00%!
8/1/2029] $9,085,000 GO Refunding, Series 2019 $ 950,000 4.00%!
8/1/2030|$9,085,000 GO Refunding, Series 2019 $ 960,000 4.00%!
9/15/2029 |$13,655,000 GO, Issue of 2020 $ 685,000 4.00%
9/1512030)$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/1512031|$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/15/2032) $13,655,000 GO, Issue of 2020 $680,000 3.00%
9/15/2033|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2034|$13,655,000 GO, Issue of 2020 $ 680,000 2.00% |
9/15/2035] $13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/1512036| $13,655,000 GO, Issue of 2020 $ 680,000 2.00%
'9/16/2037| $13,655,000 GO, Issue of 2020 $680,000 2.13%|
9/15/2038) $13,655,000 GO, Issue of 2020 $ 680,000 2.13%!
9/15/2039|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%|
9/15/2040|$13,655,000 GO, Issue of 2020 $ 680,000 2.13%
8/15/2029|$28,890,000 GO Refunding Bonds, Series 2020B $3,055,000 1.57%
8/15/2030|$28,890,000 GO Refunding Bonds, Series 2020B $3,015,000 1.67%
8/15/2031|$28,890,000 GO Refunding Bonds, Series 2020B $2,950,000 1.75%
8/15/2032|$28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%
8/15/2033|$28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.95%
Total Principal Due $ 24,265,000 _
Our Weighted Average Interest Payment 2.28% |
Weighted Average Maturity in Years 2.94 |

‘Attachment 7 FY 2037
Detailed Bond Debt Service - Town of Waterford, FY 2031
Pay off
Date Bond Components Principal | Interest
8/1/2030|$14,585,000 GO Refunding, Issue of 2017 $ 680,000 4.00%|
8/1/2030|$9,085,000 GO Refunding, Series 2019 $ 960,000 4.00%
9/15/2030| $13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/15/2031 |$13,655,000 GO, Issue of 2020 $ 685,000 3.00%
9/16/2032|$13,655,000 GO, Issue of 2020 $680,000 3.00%
9/15/2033)$13,655,000 GO, issue of 2020 $ 680,000 2.00%
9/1512034|$13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2035] $13,655,000 GO, Issue of 2020 $ 680,000 2.00%
9/15/2036] $13,665,000 GO, Issue of 2020 $ 680,000 2.00%
'9/15/2037| $13,655,000 GO, Issue of 2020 $680,000 2.13%
9/15/2038| $13,655,000 GO, Issue of 2020 $ 680,000 2.13%
9/15/2039] $13,655,000 GO, Issue of 2020 $ 680,000 2.13%
9/16/2040|$13,655,000 GO, Issue of 2020 $680,000 2.13%
8/15/2030|$28,890,000 GO Refunding Bonds, Series 2020B $3,015,000 1.67%
8/15/2031 |$28,890,000 GO Refunding Bonds, Series 2020B $2,950,000 1.75%
8/15/2032|$28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%
8/15/2033|$28,890,000 GO Refunding Bonds, Series 2020B $ 905,000 1.95%
Total Principal Due $ 18,890,000
Our Weighted Average Interest Payment 2.18%
Weighted Average Maturity in Years 2.74

T __Attachment 7 FY 2032
~ i = i
Detailed Bond Debt Service - Town of Waterford, FY 2032
= i T
Pay off |
Date Bond Components Principal__|_Interest
'9/18/2031| $13,655,000 GO, Issue of 2020 S__ 685,000 3.00%
9/15/2032| $13,655,000 GO, Issue of 2020 $680,000 3.00%
9/16/2033] $13,655,000 GO, Issue of 2020 $680,000 2.00%
9/15/2034| $13,655,000 GO, Issue of 2020 $680,000 2.00%
9/18/2035] $13,655,000 GO, Issue of 2020 $680,000 2.00%
9/15/2036| $13,655,000 GO, Issue of 2020 $680,000 2.00%
9/15/2037| $13,655,000 GO, Issue of 2020 $680,000 2.13%
9/15/2036| $13,655,000 GO, Issue of 2020 $____ 680,000 2.13%
'9/15/2039| $13,655,000 GO, Issue of 2020 $680,000 2.13%
9/15/2040| $13,655,000 GO, Issue of 2020 $680,000 2.13%
8/15/2031| $28,890,000 GO Refunding Bonds, Series 20208 $__ 2,950,000 1.75%
8/16/2032) $28,890,000 GO Refunding Bonds, Series 2020B $2,890,000 1.85%
8/15/2033) $28,890,000 GO Refunding Bonds, Series 20208 $905,000 1.95%
i = - ~
Total Principal Due - [$13,550,000 -
i
_ Our Weighted Average Interest Payment L 2.04% |
| - i
__ |Weighted Average Maturity in Years [ 2.78 |
i i

ale
7a4
vez
we
se
eae
ver
|
toy
wvm|
40%
%8VZ
%82Z
LEZ
%99°%
%hEZ
%e6%
426%
AVM
000'0s9'e1s
c00'D6e'81s
a00'saz'yzs
o00'scO‘OESs
O00'ORS'SES
O00'SZE'LYS
000'0Z9'sr$
OOO'StZ'ss$
_anP
[edioug
spuog|
z€02
Ad
L€0%
Ad
0€0Z
Ad
6702
Ad
87202
Ad
220Z
Ad
9Z0Z
Ad
$202
Ad
AY
PaIyBIEM
INO
“enp
jedioulg
spuog
pauiquio>
z
wauypeny|