CRF: Property Revaluation
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 $0 flat, this fund goes negative in FY2028. Closing the gap takes $34,358 a year more — or, with less price shock, a deposit that grows by $28,716 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 | $1,284 | $1,284 | |||
| FY2028 | $0 | $30,000 | Revaluation first year — Town Wide — FY28 $15,000Revaluation first year — Town Wide — FY28 $15,000 | -$28,716 | $28,716 | $0 |
| FY2029 | $0 | $40,000 | Revaluation Second Year — Town Wide — FY29 $20,000Revaluation Second Year — Town Wide — FY29 $20,000 | -$68,716 | $57,432 | $17,432 |
| FY2030 | $0 | — | -$68,716 | $86,148 | $103,580 | |
| FY2031 | $0 | $35,000 | Revaluation Salvage $35,000 | -$103,716 | $114,864 | $183,444 |
| FY2032 | $0 | — | -$103,716 | $143,580 | $327,024 | |
| FY2033 | $0 | — | -$103,716 | $172,296 | $499,320 | |
| FY2034 ·beyond the window | $0 | — | -$103,716 | $201,012 | $700,332 | |
| FY2035 ·beyond the window | $0 | — | -$103,716 | $229,728 | $930,060 | |
| FY2036 ·beyond the window | $0 | — | -$103,716 | $258,444 | $1,188,504 | |
| FY2037 ·beyond the window | $0 | — | -$103,716 | $287,160 | $1,475,664 | |
| FY2038 ·beyond the window | $0 | — | -$103,716 | $315,876 | $1,791,540 | |
| FY2039 ·beyond the window | $0 | — | -$103,716 | $344,592 | $2,136,132 | |
| FY2040 ·beyond the window | $0 | — | -$103,716 | $373,308 | $2,509,440 | |
| FY2041 ·beyond the window | $0 | — | -$103,716 | $402,024 | $2,911,464 | |
| FY2042 ·beyond the window | $0 | — | -$103,716 | $430,740 | $3,342,204 | |
| FY2043 ·beyond the window | $0 | — | -$103,716 | $459,456 | $3,801,660 | |
| FY2044 ·beyond the window | $0 | — | -$103,716 | $488,172 | $4,289,832 | |
| FY2045 ·beyond the window | $0 | — | -$103,716 | $516,888 | $4,806,720 | |
| FY2046 ·beyond the window | $0 | — | -$103,716 | $545,604 | $5,352,324 | |
| FY2047 ·beyond the window | $0 | — | -$103,716 | $574,320 | $5,926,644 |
Where the two answers come from
the same arithmetic, checkable on paperThe flat answer. The binding year is FY2029 — the year whose cumulative draws are hardest to cover. Through it:
| Draws, FY2028–FY2029 | $70,000 |
| less the opening balance | − $1,284 |
| less the deposits already planned | − $0 |
| Uncovered | $68,716 |
| spread over 2 equal annual additions | $34,358 / yr |
The gradual answer — the one with less price shock.Instead of the same amount every year, the addition grows: $28,716 in year one, $57,432 in year two, and so on. A deposit rising in year t contributes t steps by year T, so the divisor is 1 + 2 + … + 1 = 1rather than 1:
| Uncovered through the binding year FY2028 | $28,716 |
| divided by the triangle number 1 | $28,716 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.