Window FY2028–FY2033Scenario

CRF: Dispatch Center

Property taxes · General Fund · 20-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 $58,380 a year more — or, with less price shock, a deposit that grows by $6,868 each year.

One recurrence, applied 20 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
-$934k-$540k-$145k$249k$643kAt 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,574At today’s deposit · FY2034 · $24,226At today’s deposit · FY2035 · $58,026At today’s deposit · FY2036 · -$68,174At today’s deposit · FY2037 · -$57,874At today’s deposit · FY2038 · -$399,074At today’s deposit · FY2039 · -$365,274At today’s deposit · FY2040 · -$331,474At today’s deposit · FY2041 · -$297,674At today’s deposit · FY2042 · -$263,874At today’s deposit · FY2043 · -$934,074At today’s deposit · FY2044 · -$900,274At today’s deposit · FY2045 · -$866,474At today’s deposit · FY2046 · -$832,674At today’s deposit · FY2047 · -$798,874With the gradual step-up · FY2028 · $225,294With the gradual step-up · FY2029 · $217,831With the gradual step-up · FY2030 · $272,235With the gradual step-up · FY2031 · $108,508With the gradual step-up · FY2032 · $59,649With the gradual step-up · FY2033 · $134,658With the gradual step-up · FY2034 · $216,535With the gradual step-up · FY2035 · $305,281With the gradual step-up · FY2036 · $240,895With the gradual step-up · FY2037 · $319,877With the gradual step-up · FY2038 · $54,227With the gradual step-up · FY2039 · $170,445With the gradual step-up · FY2040 · $293,531With the gradual step-up · FY2041 · $423,486With the gradual step-up · FY2042 · $560,309With the gradual step-up · FY2043 · $0With the gradual step-up · FY2044 · $150,559With the gradual step-up · FY2045 · $307,987With the gradual step-up · FY2046 · $472,282With the gradual step-up · FY2047 · $643,446FY28FY29FY30FY31FY32FY33FY34FY35FY36FY37FY38FY39FY40FY41FY42FY43FY44FY45FY46FY47
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$40,668$225,294
FY2029$33,800$55,000Video System $55,000$197,226$47,536$217,831
FY2030$33,800$231,026$54,405$272,235
FY2031$33,800$225,000Radio Console $225,000$39,826$61,273$108,508
FY2032$33,800$117,000Police simulcast radio system $117,000-$43,374$68,141$59,649
FY2033$33,800-$9,574$75,009$134,658
FY2034 ·beyond the window$33,800$24,226$81,877$216,535
FY2035 ·beyond the window$33,800$58,026$88,746$305,281
FY2036 ·beyond the window$33,800$160,000Dispatch furniture $135,000Hayes Hill Generator $25,000-$68,174$95,614$240,895
FY2037 ·beyond the window$33,800$23,500Logger recorder $23,500-$57,874$102,482$319,877
FY2038 ·beyond the window$33,800$375,000Town Hall/Hayes/PD Antenna $375,000-$399,074$109,350$54,227
FY2039 ·beyond the window$33,800-$365,274$116,218$170,445
FY2040 ·beyond the window$33,800-$331,474$123,086$293,531
FY2041 ·beyond the window$33,800-$297,674$129,955$423,486
FY2042 ·beyond the window$33,800-$263,874$136,823$560,309
FY2043 ·beyond the window$33,800$704,000Fire A & B Repeater $504,000Dispatch Ctr Renovations $200,000-$934,074$143,691$0
FY2044 ·beyond the window$33,800-$900,274$150,559$150,559
FY2045 ·beyond the window$33,800-$866,474$157,427$307,987
FY2046 ·beyond the window$33,800-$832,674$164,296$472,282
FY2047 ·beyond the window$33,800-$798,874$171,164$643,446

Where the two answers come from

the same arithmetic, checkable on paper

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

Draws, FY2028–FY2043$1,708,000
less the opening balance− $233,126
less the deposits already planned− $540,800
Uncovered$934,074
spread over 16 equal annual additions$58,380 / yr

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

Uncovered through the binding year FY2043$934,074
divided by the triangle number 136$6,868 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.