Window FY2028–FY2033Scenario

CRF: Road Construction

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 $75,000 flat, this fund goes negative in FY2030. Closing the gap takes $14,990 a year more — or, with less price shock, a deposit that grows by $7,495 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
-$45k$89k$222k$356k$490kAt today’s deposit · FY2028 · $66,030At today’s deposit · FY2029 · $57,030At today’s deposit · FY2030 · -$44,970At today’s deposit · FY2031 · $1,530At today’s deposit · FY2032 · $76,530At today’s deposit · FY2033 · $127,530At today’s deposit · FY2034 · $110,730At today’s deposit · FY2035 · $153,730At today’s deposit · FY2036 · $126,730At today’s deposit · FY2037 · $77,730With the gradual step-up · FY2028 · $73,525With the gradual step-up · FY2029 · $79,515With the gradual step-up · FY2030 · $0With the gradual step-up · FY2031 · $76,480With the gradual step-up · FY2032 · $188,955With the gradual step-up · FY2033 · $284,925With the gradual step-up · FY2034 · $320,590With the gradual step-up · FY2035 · $423,550With the gradual step-up · FY2036 · $464,005With the gradual step-up · FY2037 · $489,955FY28FY29FY30FY31FY32FY33FY34FY35FY36FY37
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$46,030$46,030
FY2028$75,000$55,000Midblock Crossing 2 $30,000Lebanon/Park Signal Mast Arms $25,000$66,030$82,495$73,525
FY2029$75,000$84,000Lyme/Richmond signal upgrade $84,000$57,030$89,990$79,515
FY2030$75,000$177,000Park/Lyme Control Cabinet $86,000Lebanon/Park Gridsmart Video Detection System $32,000West/W Wheelock Video Detection system $31,000+1 more-$44,970$97,485$0
FY2031$75,000$28,500Park/Wheelock Mast Arms $28,500$1,530$104,980$76,480
FY2032$75,000$76,530$112,475$188,955
FY2033$75,000$24,000Main/Wheelock Mast Arms $24,000$127,530$119,970$284,925
FY2034 ·beyond the window$75,000$91,800Summer/Park Control Cabinet $61,000Midblock Crossing 1 $30,800$110,730$127,465$320,590
FY2035 ·beyond the window$75,000$32,000Park/Lyme Mast Arms $32,000$153,730$134,960$423,550
FY2036 ·beyond the window$75,000$102,000Lebanon/Summer Control Cabinet $102,000$126,730$142,455$464,005
FY2037 ·beyond the window$75,000$124,000APS - pedestrian activation $124,000$77,730$149,950$489,955

Where the two answers come from

the same arithmetic, checkable on paper

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

Draws, FY2028–FY2030$316,000
less the opening balance− $46,030
less the deposits already planned− $225,000
Uncovered$44,970
spread over 3 equal annual additions$14,990 / yr

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

Uncovered through the binding year FY2030$44,970
divided by the triangle number 6$7,495 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
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.