CRF: Highway Equipment
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 $542,375 flat, this fund goes negative in FY2032. Closing the gap takes $66,770 a year more — or, with less price shock, a deposit that grows by $22,257 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 | $297,914 | $297,914 | |||
| FY2028 | $542,375 | $728,050 | Grader $446,250Sidewalk Tractor 1 $168,000Truck 3 (Grounds) $48,000+2 more | $112,239 | $564,632 | $134,495 |
| FY2029 | $542,375 | $214,000 | Truck 6 -10 wheel dump with attachments $113,000Truck 10 - pickup $53,000Excavator Rebush/assess $33,000+2 more | $440,614 | $586,888 | $507,383 |
| FY2030 | $542,375 | $968,114 | Truck 8 -6 wheel dump with plow $228,000Roller Compactor $212,714Sidewalk Tractor 2 $195,000+2 more | $14,875 | $609,145 | $148,414 |
| FY2031 | $542,375 | $399,538 | Loader 1 DPW $255,256Truck 18 -F350 Pickup $72,141Truck 26 pickup F350 $72,141 | $157,712 | $631,401 | $380,277 |
| FY2032 | $542,375 | $1,033,935 | Excavator $433,935Vacuum Sweeper $338,000Sidewalk Tractor 3 $212,000+1 more | -$333,848 | $653,658 | $0 |
| FY2033 | $542,375 | $243,000 | Truck 9 -10 Wheel Dump $243,000 | -$34,473 | $675,914 | $432,914 |
Where the two answers come from
the same arithmetic, checkable on paperThe flat answer. The binding year is FY2032 — the year whose cumulative draws are hardest to cover. Through it:
| Draws, FY2028–FY2032 | $3,343,637 |
| less the opening balance | − $297,914 |
| less the deposits already planned | − $2,711,875 |
| Uncovered | $333,848 |
| spread over 5 equal annual additions | $66,770 / yr |
The gradual answer — the one with less price shock.Instead of the same amount every year, the addition grows: $22,257 in year one, $44,513 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 | $333,848 |
| divided by the triangle number 15 | $22,257 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 | Chipper | $80,000 |
| FY2034 | Trailer 2 - 9 ton | $14,000 |
| FY2035 | Truck 5 -6 wheel dump with plow | $336,000 |
| FY2035 | Truck 15 -F550 | $130,491 |
| FY2035 | Truck 4 pickup (Grounds) upgrade to 550 | $89,116 |
| FY2035 | Truck Buildings | $66,000 |
| FY2035 | Truck W (Grounds) | $40,000 |
| FY2035 | Truck 70 Recreation | $40,000 |
| FY2036 | Truck 14 - 6 wheel dump with plow | $384,000 |
| FY2036 | Truck 12 -6 wheel dump with plow | $384,000 |
| FY2036 | Backhoe Loader ( Kubota ) | $75,000 |
| FY2036 | Truck lift (16 TN) | $22,250 |
| FY2037 | Snogo - loader snow blower | $197,400 |
| FY2037 | Roadside Mower boom | $92,000 |
| FY2038 | Bulldozer | $359,171 |
| 24 assets beyond the window in total | $3,189,828 | |