CRF: Highway Equipment
Property taxes · General Fund · 20-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 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 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 |
| FY2034 ·beyond the window | $542,375 | $94,000 | Chipper $80,000Trailer 2 - 9 ton $14,000 | $413,902 | $698,171 | $1,037,085 |
| FY2035 ·beyond the window | $542,375 | $701,606 | Truck 5 -6 wheel dump with plow $336,000Truck 15 -F550 $130,491Truck 4 pickup (Grounds) upgrade to 550 $89,116+3 more | $254,670 | $720,427 | $1,055,906 |
| FY2036 ·beyond the window | $542,375 | $865,250 | Truck 14 - 6 wheel dump with plow $384,000Truck 12 -6 wheel dump with plow $384,000Backhoe Loader ( Kubota ) $75,000+1 more | -$68,205 | $742,684 | $933,340 |
| FY2037 ·beyond the window | $542,375 | $289,400 | Snogo - loader snow blower $197,400Roadside Mower boom $92,000 | $184,770 | $764,941 | $1,408,881 |
| FY2038 ·beyond the window | $542,375 | $359,171 | Bulldozer $359,171 | $367,974 | $787,197 | $1,836,906 |
| FY2039 ·beyond the window | $542,375 | $14,400 | Culvert Cleaner (De-Icer) $14,400 | $895,949 | $809,454 | $2,631,960 |
| FY2040 ·beyond the window | $542,375 | — | $1,438,324 | $831,710 | $3,463,670 | |
| FY2041 ·beyond the window | $542,375 | — | $1,980,699 | $853,967 | $4,317,637 | |
| FY2042 ·beyond the window | $542,375 | — | $2,523,074 | $876,223 | $5,193,860 | |
| FY2043 ·beyond the window | $542,375 | $99,000 | RTV P&R $53,000Compressor HW $32,000Hydro Seeder $14,000 | $2,966,449 | $898,480 | $5,993,340 |
| FY2044 ·beyond the window | $542,375 | $83,000 | 20 Tn Equipment Trailer $83,000 | $3,425,824 | $920,736 | $6,831,076 |
| FY2045 ·beyond the window | $542,375 | $563,000 | Road Side Tractor $471,000Bucket Truck $92,000 | $3,405,199 | $942,993 | $7,211,069 |
| FY2046 ·beyond the window | $542,375 | — | $3,947,574 | $965,249 | $8,176,319 | |
| FY2047 ·beyond the window | $542,375 | — | $4,489,949 | $987,506 | $9,163,825 |
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 | |