CRF: Road Construction
Property taxes · General Fund · 6-year horizonEvery 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 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 findingThe roll-forward, line by line
every draw names its projects| Year | Deposit | Draws | Drawn by | Balance | Step-up deposit | Balance, stepped |
|---|---|---|---|---|---|---|
| Opening | available, net of commitments, as of 31 Oct 2025 | $46,030 | $46,030 | |||
| FY2028 | $75,000 | $55,000 | Midblock Crossing 2 $30,000Lebanon/Park Signal Mast Arms $25,000 | $66,030 | $82,495 | $73,525 |
| FY2029 | $75,000 | $84,000 | Lyme/Richmond signal upgrade $84,000 | $57,030 | $89,990 | $79,515 |
| FY2030 | $75,000 | $177,000 | Park/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,500 | Park/Wheelock Mast Arms $28,500 | $1,530 | $104,980 | $76,480 |
| FY2032 | $75,000 | — | $76,530 | $112,475 | $188,955 | |
| FY2033 | $75,000 | $24,000 | Main/Wheelock Mast Arms $24,000 | $127,530 | $119,970 | $284,925 |
Where the two answers come from
the same arithmetic, checkable on paperThe 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| Year | Asset | Draw |
|---|---|---|
| FY2034 | Summer/Park Control Cabinet | $61,000 |
| FY2034 | Midblock Crossing 1 | $30,800 |
| FY2035 | Park/Lyme Mast Arms | $32,000 |
| FY2036 | Lebanon/Summer Control Cabinet | $102,000 |
| FY2037 | APS - pedestrian activation | $124,000 |
| FY2038 | Main/Wheelock Video Detection System | $40,000 |
| FY2039 | Summer/Park Mast Arms | $36,000 |
| FY2039 | School zone speed flashers | $32,000 |
| FY2040 | West/W Wheelock Control Cabinet | $112,000 |
| FY2040 | Lebanon/Park Signals Control Cabinet | $112,000 |
| FY2040 | Traffic Signal Replacement | $40,000 |
| FY2041 | Lebanon/Summer Mast Arms | $38,000 |
| FY2041 | Park/Lyme Video Detection System | $25,000 |
| FY2041 | Park/Wheelock Video Detection System | $25,000 |
| FY2041 | Main/South/Maple Gridsmart Video Detection System | $25,000 |
| 22 assets beyond the window in total | $1,218,300 | |