CRF: Building Maintenance
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
At today's deposit of $246,000 this fund covers every draw on the horizon. Nothing more is required.
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 findingAt today’s depositWith the gradual step-up
The 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 | $1,696,552 | $1,696,552 | |||
| FY2028 | $246,000 | $266,000 | membrane roof DPW1 $97,500Carpet Howe $92,000Membrane Roof DPW2 $56,500+1 more | $1,676,552 | $246,000 | $1,676,552 |
| FY2029 | $246,000 | $718,773 | Solar Array PS & DPW $226,273Elevator repair old Howe $160,000Howe Sidewalk & retaining wall $150,000+4 more | $1,203,779 | $246,000 | $1,203,779 |
| FY2030 | $246,000 | $350,000 | Heat pumps DPW $125,000Flooring PD $91,000Howe chimney liners/repointing $65,000+2 more | $1,099,779 | $246,000 | $1,099,779 |
| FY2031 | $246,000 | $691,554 | Heat Pumps Police $370,000Howe control system $124,000Howe Library Air Handlers $75,000+2 more | $654,225 | $246,000 | $654,225 |
| FY2032 | $246,000 | $113,500 | High Efficiency heat pump phase 1 TH $93,500DC Inverter (solar) TH $20,000 | $786,725 | $246,000 | $786,725 |
| FY2033 | $246,000 | $116,000 | Low Temp Heat pump phase 2 TH $65,000Air Conditioning RWB $51,000 | $916,725 | $246,000 | $916,725 |
What is lingering just outside the window
this is what drives the contribution| Year | Asset | Draw |
|---|---|---|
| FY2034 | Roof Replacement PD | $128,800 |
| FY2034 | Carpet RWB | $37,000 |
| FY2034 | RWB parking lot lighting | $30,000 |
| FY2034 | Low Temp Heat pump Etna Lib | $12,000 |
| FY2035 | Howe Library HVAC | $955,000 |
| FY2035 | Heat Pumps Howe | $305,000 |
| FY2035 | Roof Replacement (west side) | $165,000 |
| FY2035 | Generator DPW | $86,357 |
| FY2035 | Solar Hot Water RWB | $22,000 |
| FY2036 | RTU Air Conditioner | $17,000 |
| FY2037 | Multipurpose room floor | $80,000 |
| FY2037 | Propane Tube Heaters | $75,000 |
| FY2038 | Membrane Roofing RWB | $117,000 |
| FY2038 | Training Room flooring, ceiling & lights | $48,000 |
| FY2038 | Roof TH | $48,000 |
| 38 assets beyond the window in total | $4,638,857 | |
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.