Window FY2028–FY2033Scenario

Debt

19 issuesscenario: fit inside 1m

Each debt-funded project becomes a level-payment issue, sold in its project year, first payment the year after. Rate and term are inputs on the page, not constants.

New borrowing only. No schedule of existing outstanding debt has been loaded, so every figure below is an addition to a number that is not shown, and the total understates by exactly the Town's current debt service. Peer towns publish theirs.

Principal
$52M
$52,343,550
Interest
$25M
at 4.00% over 20 years
Peak annual service
$3.9M
FY2038
Total repaid
$77M
47% more than borrowed

Annual debt service

by fund
$0$963k$1.9M$2.9M$3.9MFY2029 · Bond: General Fund · $1,103,726FY2029 · Bond: Wastewater · $103,014FY29FY2030 · Bond: General Fund · $1,103,726FY2030 · Bond: Wastewater · $103,014FY2030 · Bond: Water · $596,012FY2031 · Bond: General Fund · $1,103,726FY2031 · Bond: Wastewater · $103,014FY2031 · Bond: Water · $596,012FY2032 · Bond: General Fund · $1,103,726FY2032 · Bond: Wastewater · $103,014FY2032 · Bond: Water · $596,012FY32FY2033 · Bond: General Fund · $1,140,517FY2033 · Bond: Wastewater · $103,014FY2033 · Bond: Water · $596,012FY2034 · Bond: General Fund · $1,140,517FY2034 · Bond: Wastewater · $1,574,649FY2034 · Bond: Fire · $47,460FY2034 · Bond: Water · $596,012FY2035 · Bond: General Fund · $1,140,517FY2035 · Bond: Wastewater · $1,574,649FY2035 · Bond: Bridge · $73,328FY2035 · Bond: Fire · $47,460FY2035 · Bond: Water · $596,012FY35FY2036 · Bond: General Fund · $1,140,517FY2036 · Bond: Wastewater · $1,633,073FY2036 · Bond: Bridge · $73,328FY2036 · Bond: Fire · $143,117FY2036 · Bond: Water · $596,012FY2037 · Bond: General Fund · $1,264,134FY2037 · Bond: Wastewater · $1,633,073FY2037 · Bond: Bridge · $73,328FY2037 · Bond: Fire · $227,736FY2037 · Bond: Water · $596,012FY2038 · Bond: General Fund · $1,264,134FY2038 · Bond: Wastewater · $1,687,671FY2038 · Bond: Bridge · $75,977FY2038 · Bond: Fire · $227,736FY2038 · Bond: Water · $596,012FY38FY2039 · Bond: General Fund · $1,264,134FY2039 · Bond: Wastewater · $1,687,671FY2039 · Bond: Bridge · $75,977FY2039 · Bond: Fire · $227,736FY2039 · Bond: Water · $596,012FY2040 · Bond: General Fund · $1,264,134FY2040 · Bond: Wastewater · $1,687,671FY2040 · Bond: Bridge · $75,977FY2040 · Bond: Fire · $227,736FY2040 · Bond: Water · $596,012FY2041 · Bond: General Fund · $1,264,134FY2041 · Bond: Wastewater · $1,687,671FY2041 · Bond: Bridge · $75,977FY2041 · Bond: Fire · $227,736FY2041 · Bond: Water · $596,012FY41FY2042 · Bond: General Fund · $1,264,134FY2042 · Bond: Wastewater · $1,687,671FY2042 · Bond: Bridge · $75,977FY2042 · Bond: Fire · $227,736FY2042 · Bond: Water · $596,012FY2043 · Bond: General Fund · $1,264,134FY2043 · Bond: Wastewater · $1,687,671FY2043 · Bond: Bridge · $75,977FY2043 · Bond: Fire · $227,736FY2043 · Bond: Water · $596,012FY2044 · Bond: General Fund · $1,264,134FY2044 · Bond: Wastewater · $1,687,671FY2044 · Bond: Bridge · $75,977FY2044 · Bond: Fire · $227,736FY2044 · Bond: Water · $596,012FY44FY2045 · Bond: General Fund · $1,264,134FY2045 · Bond: Wastewater · $1,687,671FY2045 · Bond: Bridge · $75,977FY2045 · Bond: Fire · $227,736FY2045 · Bond: Water · $596,012FY2046 · Bond: General Fund · $1,264,134FY2046 · Bond: Wastewater · $1,687,671FY2046 · Bond: Bridge · $75,977FY2046 · Bond: Fire · $227,736FY2046 · Bond: Water · $596,012FY2047 · Bond: General Fund · $1,264,134FY2047 · Bond: Wastewater · $1,687,671FY2047 · Bond: Bridge · $75,977FY2047 · Bond: Fire · $227,736FY2047 · Bond: Water · $596,012FY47FY2048 · Bond: General Fund · $1,264,134FY2048 · Bond: Wastewater · $1,687,671FY2048 · Bond: Bridge · $75,977FY2048 · Bond: Fire · $227,736FY2048 · Bond: Water · $596,012FY2049 · Bond: General Fund · $160,408FY2049 · Bond: Wastewater · $1,584,657FY2049 · Bond: Bridge · $75,977FY2049 · Bond: Fire · $227,736FY2049 · Bond: Water · $596,012FY2050 · Bond: General Fund · $160,408FY2050 · Bond: Wastewater · $1,584,657FY2050 · Bond: Bridge · $75,977FY2050 · Bond: Fire · $227,736FY50FY2051 · Bond: General Fund · $160,408FY2051 · Bond: Wastewater · $1,584,657FY2051 · Bond: Bridge · $75,977FY2051 · Bond: Fire · $227,736FY2052 · Bond: General Fund · $160,408FY2052 · Bond: Wastewater · $1,584,657FY2052 · Bond: Bridge · $75,977FY2052 · Bond: Fire · $227,736FY2053 · Bond: General Fund · $123,617FY2053 · Bond: Wastewater · $1,584,657FY2053 · Bond: Bridge · $75,977FY2053 · Bond: Fire · $227,736FY53FY2054 · Bond: General Fund · $123,617FY2054 · Bond: Wastewater · $113,022FY2054 · Bond: Bridge · $75,977FY2054 · Bond: Fire · $180,275FY2055 · Bond: General Fund · $123,617FY2055 · Bond: Wastewater · $113,022FY2055 · Bond: Bridge · $2,649FY2055 · Bond: Fire · $180,275FY2056 · Bond: General Fund · $123,617FY2056 · Bond: Wastewater · $54,598FY2056 · Bond: Bridge · $2,649FY2056 · Bond: Fire · $84,619FY56FY2057 · Bond: Wastewater · $54,598FY2057 · Bond: Bridge · $2,649
Bond: General FundBond: WastewaterBond: BridgeBond: FireBond: Water
Cost index 4.0%Bond 4.00% over 20 yrsContributions adopted, held flatReserve interest 0.0%Peak FY2038

Bond it or save for it

Facilty upgrade phase 2

Facilty upgrade phase 2 costs $20,000,000 in FY2033. Borrowing it costs $29,432,700 in total; saving for it from FY2028 costs $20,000,000. Saving is cheaper by $9,432,700.

YearBorrowSaveDifference
FY2028$4,000,000-$4,000,000
FY2029$4,000,000-$4,000,000
FY2030$4,000,000-$4,000,000
FY2031$4,000,000-$4,000,000
FY2032$4,000,000-$4,000,000
FY2033$0
FY2034$1,471,635$1,471,635
FY2035$1,471,635$1,471,635
FY2036$1,471,635$1,471,635
FY2037$1,471,635$1,471,635
FY2038$1,471,635$1,471,635
FY2039$1,471,635$1,471,635
FY2040$1,471,635$1,471,635
FY2041$1,471,635$1,471,635
Total$29,432,700$20,000,000$9,432,700

The Town does this by hand on its Estimates sheet for the Bridge fund. It is the CIPC memo's third bullet — options for financing and timing — and no vendor offers it.

Every issue

IssueFundPrincipalIssuedPaymentsAnnualInterest
Facilty upgrade phase 2Bond: Wastewater$20,000,000FY2033FY2034–FY2053$1,471,635$9,432,700
South Main Street ReconstructionBond: General Fund$15,000,000FY2028FY2029–FY2048$1,103,726$7,074,525
Distribution Project 2 ($455k)Bond: Water$8,100,000FY2029FY2030–FY2049$596,012$3,820,244
Fuel Island & TanksStorageBond: General Fund$1,680,000FY2036FY2037–FY2056$123,617$792,347
Pump Station #4Bond: Wastewater$1,400,000FY2028FY2029–FY2048$103,014$660,289
Engine 2Bond: Fire$1,300,000FY2035FY2036–FY2055$95,656$613,126
Tower 1Bond: Fire$1,150,000FY2036FY2037–FY2056$84,619$542,380
Dewatering centrifugesBond: Wastewater$794,000FY2035FY2036–FY2055$58,424$374,478
Pump Station #5Bond: Wastewater$742,000FY2037FY2038–FY2057$54,598$349,953
Fire Radio SystemBond: Fire$645,000FY2033FY2034–FY2053$47,460$304,205
Shed # 2 relocation to DPWBond: General Fund$500,000FY2032FY2033–FY2052$36,791$235,818
bridge112/091Bond: Bridge$217,000FY2034FY2035–FY2054$15,967$102,345
bridge131/162Bond: Bridge$201,800FY2034FY2035–FY2054$14,849$95,176
bridge133/089Bond: Bridge$182,300FY2034FY2035–FY2054$13,414$85,979
bridge115/078Bond: Bridge$125,000FY2034FY2035–FY2054$9,198$58,954
bridge107/063Bond: Bridge$91,150FY2034FY2035–FY2054$6,707$42,990
bridge110/069Bond: Bridge$90,000FY2034FY2035–FY2054$6,622$42,447
bridge108/066Bond: Bridge$89,300FY2034FY2035–FY2054$6,571$42,117
Ledyard Bridge LightingBond: Bridge$36,000FY2037FY2038–FY2057$2,649$16,979
19 issues$52,343,550$24,687,051