Window FY2028–FY2033Scenario

CRF: Building Maintenance

Property taxes · General Fund · 10-year horizon

Every figure the reserves table quotes for this fund, derived again here line by line. The bar in a public meeting is not trust-the-software; it is check line four.

← all reserve funds · horizon 6 years10 years20 years

The answer

Holding today's deposit of $246,000 flat, this fund goes negative in FY2035. Closing the gap takes $41,554 a year more — or, with less price shock, a deposit that grows by $9,234 each year.

One recurrence, applied 10 times: balance = balance × (1 + 0.0%) + deposit − draws. Deposits are today’s figure, held flat. No solver and no goal-seek — the answers below are closed-form, so the same inputs always give the same figures.

Balance, both ways

negatives are shown, never floored — a fund going under is the finding
-$332k$172k$677k$1.2M$1.7MAt today’s deposit · FY2028 · $1,676,552At today’s deposit · FY2029 · $1,203,779At today’s deposit · FY2030 · $1,099,779At today’s deposit · FY2031 · $654,225At today’s deposit · FY2032 · $786,725At today’s deposit · FY2033 · $916,725At today’s deposit · FY2034 · $954,925At today’s deposit · FY2035 · -$332,432At today’s deposit · FY2036 · -$103,432At today’s deposit · FY2037 · -$12,432With the gradual step-up · FY2028 · $1,685,786With the gradual step-up · FY2029 · $1,231,482With the gradual step-up · FY2030 · $1,155,184With the gradual step-up · FY2031 · $746,567With the gradual step-up · FY2032 · $925,238With the gradual step-up · FY2033 · $1,110,644With the gradual step-up · FY2034 · $1,213,483With the gradual step-up · FY2035 · $0With the gradual step-up · FY2036 · $312,108With the gradual step-up · FY2037 · $495,450FY28FY29FY30FY31FY32FY33FY34FY35FY36FY37
At today’s depositWith the gradual step-up

The roll-forward, line by line

every draw names its projects
YearDepositDrawsDrawn byBalanceStep-up depositBalance, stepped
Openingavailable, net of commitments, as of 31 Oct 2025$1,696,552$1,696,552
FY2028$246,000$266,000membrane roof DPW1 $97,500Carpet Howe $92,000Membrane Roof DPW2 $56,500+1 more$1,676,552$255,234$1,685,786
FY2029$246,000$718,773Solar Array PS & DPW $226,273Elevator repair old Howe $160,000Howe Sidewalk & retaining wall $150,000+4 more$1,203,779$264,468$1,231,482
FY2030$246,000$350,000Heat pumps DPW $125,000Flooring PD $91,000Howe chimney liners/repointing $65,000+2 more$1,099,779$273,703$1,155,184
FY2031$246,000$691,554Heat Pumps Police $370,000Howe control system $124,000Howe Library Air Handlers $75,000+2 more$654,225$282,937$746,567
FY2032$246,000$113,500High Efficiency heat pump phase 1 TH $93,500DC Inverter (solar) TH $20,000$786,725$292,171$925,238
FY2033$246,000$116,000Low Temp Heat pump phase 2 TH $65,000Air Conditioning RWB $51,000$916,725$301,405$1,110,644
FY2034 ·beyond the window$246,000$207,800Roof Replacement PD $128,800Carpet RWB $37,000RWB parking lot lighting $30,000+1 more$954,925$310,640$1,213,483
FY2035 ·beyond the window$246,000$1,533,357Howe Library HVAC $955,000Heat Pumps Howe $305,000Roof Replacement (west side) $165,000+2 more-$332,432$319,874$0
FY2036 ·beyond the window$246,000$17,000RTU Air Conditioner $17,000-$103,432$329,108$312,108
FY2037 ·beyond the window$246,000$155,000Multipurpose room floor $80,000Propane Tube Heaters $75,000-$12,432$338,342$495,450

Where the two answers come from

the same arithmetic, checkable on paper

The flat answer. The binding year is FY2035 — the year whose cumulative draws are hardest to cover. Through it:

Draws, FY2028–FY2035$3,996,984
less the opening balance− $1,696,552
less the deposits already planned− $1,968,000
Uncovered$332,432
spread over 8 equal annual additions$41,554 / yr

The gradual answer — the one with less price shock.Instead of the same amount every year, the addition grows: $9,234 in year one, $18,468 in year two, and so on. A deposit rising in year t contributes t steps by year T, so the divisor is 1 + 2 + … + 8 = 36rather than 8:

Uncovered through the binding year FY2035$332,432
divided by the triangle number 36$9,234 more each year

This is the recommendation the budget request prints: a gradual annual adjustment so that no year goes negative and there is less price shock. The Town raises a contribution once — it does not reset one. As projects shift, are removed, or reprice, both answers recompute; they cannot go stale.

What is lingering just outside the window

this is what drives the contribution
YearAssetDraw
FY2034Roof Replacement PD$128,800
FY2034Carpet RWB$37,000
FY2034RWB parking lot lighting$30,000
FY2034Low Temp Heat pump Etna Lib$12,000
FY2035Howe Library HVAC$955,000
FY2035Heat Pumps Howe$305,000
FY2035Roof Replacement (west side)$165,000
FY2035Generator DPW$86,357
FY2035Solar Hot Water RWB$22,000
FY2036RTU Air Conditioner$17,000
FY2037Multipurpose room floor$80,000
FY2037Propane Tube Heaters$75,000
FY2038Membrane Roofing RWB$117,000
FY2038Training Room flooring, ceiling & lights$48,000
FY2038Roof TH$48,000
38 assets beyond the window in total$4,638,857
A fund can look over-funded inside a six-year window and be correctly funded once the assets landing beyond it are on screen. The recommended contribution is computed on the full horizon, which is why this panel exists.