Window FY2028–FY2033Scenario

Overview

6 years · 166 projectsscenario: fit inside 1m

Everything on this page is computed from the Town's own register. Nothing is illustrative and nothing is typed twice.

Total demand
$83,375,674
FY2028–FY2033, across 166 projects
New money required
$65,486,033
$17,889,641 is covered by money that already exists
Borrowed or unfunded
78%
55% borrowing, 23% with no source identified
Reserve ask
$116,975 /yr
4% on top of the $2,702,660 the Town puts in today

Capital spending by year

by funding class
$0$5.5M$11M$17M$22MFY2028 · Saved in advance · $3,150,290FY2028 · Borrowed · $16,400,000FY2028 · Outside money · $213,000FY2028 · Unfunded · $200,000FY28FY2029 · Saved in advance · $5,091,914FY2029 · Borrowed · $8,100,000FY29FY2030 · Saved in advance · $3,826,834FY2030 · Unfunded · $17,450,000FY30FY2031 · Saved in advance · $1,746,592FY31FY2032 · Saved in advance · $2,789,372FY2032 · Borrowed · $500,000FY2032 · Unfunded · $1,803,322FY32FY2033 · Saved in advance · $1,434,850FY2033 · Borrowed · $20,645,000FY2033 · Outside money · $24,500FY33
Saved in advanceBorrowedOutside moneyUnfunded
Cost index 4.0%Bond 4.00% over 20 yrsContributions adopted, held flatReserve interest 0.0%

Share of the plan

Saved in advance · $18,039,852 · 21.6%Borrowed · $45,645,000 · 54.7%Outside money · $237,500 · 0.3%Unfunded · $19,453,322 · 23.3%
Saved in advance 22% $18,039,852Borrowed 55% $45,645,000Outside money 0% $237,500Unfunded 23% $19,453,322

Borrowed money is covered by nothing: no money is set aside, every dollar of debt service is new, and it continues past the window.

Who ultimately pays

Sewer user fees · $26,885,211 · 32.2%Property taxes · $26,513,554 · 31.8%Not identified · $19,453,322 · 23.3%Water user fees · $9,470,737 · 11.4%Parking fund · $590,350 · 0.7%Outside the Town · $237,500 · 0.3%Dedicated fee · $225,000 · 0.3%
Sewer user fees 32% $26,885,211Property taxes 32% $26,513,554Not identified 23% $19,453,322Water user fees 11% $9,470,737Parking fund 1% $590,350Outside the Town 0% $237,500Dedicated fee 0% $225,000

Ratepayer money never touches the property tax and is never summed into a tax-rate figure. Water, sewer and parking answer to different people.

What needs attention

not a chart — a work list
FindingWhereRowsAmount
runs dry CRF: Highway Equipment goes negative in FY2032Reserve funds—-$333,848
runs dry CRF: Property Revaluation goes negative in FY2029Reserve funds—-$106,164
runs dry CRF: Road Construction goes negative in FY2030Reserve funds—-$44,970
runs dry CRF: Dispatch Center goes negative in FY2032Reserve funds—-$43,374
missing input No schedule of existing outstanding debtDebt—understates by that amount
missing input No assessed valuation, so nothing converts to a tax rateAffordability——
warning 166 classifications have not been confirmed by anybodyData health166$83,375,674
error 166 projects do not say how far they can moveData health166$83,375,674
error 157 projects disagree with their funding source about the set of booksData health157$43,684,852
warning 24 projects have no divisionData health24$21,906,764
error 1 project names no set of booksData health1$20,000,000
warning 6 projects have no funding source identifiedData health6$19,453,322
Data health scores 24 of 100, with 9 checks failing.Work through them →

Borrowing

PRINCIPAL
$52M
INTEREST
$25M
PEAK SERVICE
$3.9M
FY2038

New borrowing only. No schedule of existing outstanding debt has been loaded, so every total here understates by exactly the Town's current debt service.

Reserve funds

4 of 12 funds run dry inside the window. Holding today's deposits flat, closing every gap costs $116,975 a year — 4% on top of the $2,702,660 the Town already puts in.

All of it falls on property tax. The water and sewer funds are solvent on their own ratepayer money.