Window FY2028–FY2033Scenario

Reserve funds

10-year horizon

Holding today's deposit, how much more per year keeps each fund solvent. Two closed-form answers, no solver — every line can be checked on paper.

Holding today's deposits flat, closing every gap costs $198,423 a year — 7% on top of the $2,702,660 the Town already puts in, and 6 of 12 funds dip below zero inside 10 years.

All of it falls on Property taxes — the water and sewer funds are solvent on their own ratepayer money.

Horizon6 years10 years20 years— twenty is what the Town asked for
Cost index 4.0%Bond 4.00% over 20 yrsContributions adopted, held flatReserve interest 0.0%

The ask, by fund

Highway Equipment$66,770
Building Maintenance$41,554
Property Revaluation$34,358
Ambulance Equipment$32,077
Road Construction$14,990
Dispatch Center$8,675

Balance projection

funds that go negative
-$334k$169k$671k$1.2M$1.7MHighway Equipment · FY2028 · $112,239Highway Equipment · FY2029 · $440,614Highway Equipment · FY2030 · $14,875Highway Equipment · FY2031 · $157,712Highway Equipment · FY2032 · -$333,848Highway Equipment · FY2033 · -$34,473Highway Equipment · FY2034 · $413,902Highway Equipment · FY2035 · $254,670Highway Equipment · FY2036 · -$68,205Highway Equipment · FY2037 · $184,770Building Maintenance · FY2028 · $1,676,552Building Maintenance · FY2029 · $1,203,779Building Maintenance · FY2030 · $1,099,779Building Maintenance · FY2031 · $654,225Building Maintenance · FY2032 · $786,725Building Maintenance · FY2033 · $916,725Building Maintenance · FY2034 · $954,925Building Maintenance · FY2035 · -$332,432Building Maintenance · FY2036 · -$103,432Building Maintenance · FY2037 · -$12,432Property Revaluation · FY2028 · -$28,716Property Revaluation · FY2029 · -$68,716Property Revaluation · FY2030 · -$68,716Property Revaluation · FY2031 · -$103,716Property Revaluation · FY2032 · -$103,716Property Revaluation · FY2033 · -$103,716Property Revaluation · FY2034 · -$103,716Property Revaluation · FY2035 · -$103,716Property Revaluation · FY2036 · -$103,716Property Revaluation · FY2037 · -$103,716Ambulance Equipment · FY2028 · $287,847Ambulance Equipment · FY2029 · -$64,153Ambulance Equipment · FY2030 · $123,847Ambulance Equipment · FY2031 · $311,847Ambulance Equipment · FY2032 · $499,847Ambulance Equipment · FY2033 · $687,847Ambulance Equipment · FY2034 · $875,847Ambulance Equipment · FY2035 · $1,063,847Ambulance Equipment · FY2036 · $1,251,847Ambulance Equipment · FY2037 · $1,401,947Road Construction · FY2028 · $66,030Road Construction · FY2029 · $57,030Road Construction · FY2030 · -$44,970Road Construction · FY2031 · $1,530Road Construction · FY2032 · $76,530Road Construction · FY2033 · $127,530Road Construction · FY2034 · $110,730Road Construction · FY2035 · $153,730Road Construction · FY2036 · $126,730Road Construction · FY2037 · $77,730Dispatch Center · FY2028 · $218,426Dispatch Center · FY2029 · $197,226Dispatch Center · FY2030 · $231,026Dispatch Center · FY2031 · $39,826Dispatch Center · FY2032 · -$43,374Dispatch Center · FY2033 · -$9,574Dispatch Center · FY2034 · $24,226Dispatch Center · FY2035 · $58,026Dispatch Center · FY2036 · -$68,174Dispatch Center · FY2037 · -$57,874FY28FY29FY30FY31FY32FY33FY34FY35FY36FY37
Highway EquipmentBuilding MaintenanceProperty RevaluationAmbulance EquipmentRoad ConstructionDispatch Center

Negatives are shown, never floored. A fund going under is the finding.

Every fund

flat and step-up, per fund
FundPayerOpeningDepositDrawsLowestRuns dryFlat askStep-upBeyond the window
CRF: Highway EquipmentProperty taxes$297,914$542,375$5,536,893-$333,848FY2032$66,770+$22,257/yr24
CRF: Building MaintenanceProperty taxes$1,696,552$246,000$4,168,984-$332,432FY2035$41,554+$9,234/yr38
CRF: Property RevaluationProperty taxes$1,284$0$105,000-$103,716FY2028$34,358+$28,716/yr
CRF: Ambulance EquipmentProperty taxes$794,747$188,000$1,272,800-$64,153FY2029$32,077+$21,384/yr1
CRF: Road ConstructionProperty taxes$46,030$75,000$718,300-$44,970FY2030$14,990+$7,495/yr22
CRF: Dispatch CenterProperty taxes$233,126$33,800$629,000-$68,174FY2032$8,675+$2,892/yr6
CRF: Fire Vehicle & EquipmentProperty taxes$967,412$162,000$1,804,115$504,99923
CRF: Municipal TransportationDedicated fee$82,657$34,000$225,000$18,6576
CRF: Parking FacilitiesParking fund$301,874$84,000$778,350$116,1747
CRF: Police VehiclesProperty taxes$310,144$140,000$999,900$37,9941
CRF: Sewer EquipmentSewer user fees$2,665,566$605,084$6,237,111$534,95728
CRF: Water TreatmentWater user fees$1,083,634$592,401$1,978,432$761,03517
Total, each fund at its own requirement$198,423
Flat is the smallest constant amount added to each year of the existing plan.Step-up is a gradual annual increase doing the same job — the Town raises a contribution, it does not reset one, and a gradual adjustment is less price shock. A fund can show no gap over the window and still need more per year, because the draws land before the deposits do. Where the two disagree, the per-year figure binds.