Window FY2028–FY2033Scenario

CRF: Dispatch Center

Property taxes · General Fund · 6-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 $33,800 flat, this fund goes negative in FY2032. Closing the gap takes $8,675 a year more — or, with less price shock, a deposit that grows by $2,892 each year.

One recurrence, applied 6 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
-$43k$30k$103k$175k$248kAt today’s deposit · FY2028 · $218,426At today’s deposit · FY2029 · $197,226At today’s deposit · FY2030 · $231,026At today’s deposit · FY2031 · $39,826At today’s deposit · FY2032 · -$43,374At today’s deposit · FY2033 · -$9,574With the gradual step-up · FY2028 · $221,318With the gradual step-up · FY2029 · $205,901With the gradual step-up · FY2030 · $248,376With the gradual step-up · FY2031 · $68,742With the gradual step-up · FY2032 · $0With the gradual step-up · FY2033 · $51,150FY28FY29FY30FY31FY32FY33
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$233,126$233,126
FY2028$33,800$48,500Digital Alarm Monitor $48,500$218,426$36,692$221,318
FY2029$33,800$55,000Video System $55,000$197,226$39,583$205,901
FY2030$33,800$231,026$42,475$248,376
FY2031$33,800$225,000Radio Console $225,000$39,826$45,366$68,742
FY2032$33,800$117,000Police simulcast radio system $117,000-$43,374$48,258$0
FY2033$33,800-$9,574$51,150$51,150

Where the two answers come from

the same arithmetic, checkable on paper

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

Draws, FY2028–FY2032$445,500
less the opening balance− $233,126
less the deposits already planned− $169,000
Uncovered$43,374
spread over 5 equal annual additions$8,675 / yr

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

Uncovered through the binding year FY2032$43,374
divided by the triangle number 15$2,892 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
FY2036Dispatch furniture$135,000
FY2036Hayes Hill Generator$25,000
FY2037Logger recorder$23,500
FY2038Town Hall/Hayes/PD Antenna$375,000
FY2043Fire A & B Repeater$504,000
FY2043Dispatch Ctr Renovations$200,000
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.