CRF: Ambulance Equipment
Property taxes · Fire 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 $188,000 flat, this fund goes negative in FY2029. Closing the gap takes $32,077 a year more — or, with less price shock, a deposit that grows by $21,384 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 | $794,747 | $794,747 | |||
| FY2028 | $188,000 | $694,900 | Ambulance1 $497,000Cardiac Monitor Defibrillators $197,900 | $287,847 | $209,384 | $309,231 |
| FY2029 | $188,000 | $540,000 | Ambulance 2 $526,000IV Med Pumps $14,000 | -$64,153 | $230,769 | $0 |
| FY2030 | $188,000 | — | $123,847 | $252,153 | $252,153 | |
| FY2031 | $188,000 | — | $311,847 | $273,537 | $525,690 | |
| FY2032 | $188,000 | — | $499,847 | $294,922 | $820,612 | |
| FY2033 | $188,000 | — | $687,847 | $316,306 | $1,136,918 | |
| FY2034 ·beyond the window | $188,000 | — | $875,847 | $337,690 | $1,474,608 | |
| FY2035 ·beyond the window | $188,000 | — | $1,063,847 | $359,075 | $1,833,683 | |
| FY2036 ·beyond the window | $188,000 | — | $1,251,847 | $380,459 | $2,214,142 | |
| FY2037 ·beyond the window | $188,000 | $37,900 | RTV FD $37,900 | $1,401,947 | $401,843 | $2,578,085 |
| FY2038 ·beyond the window | $188,000 | — | $1,589,947 | $423,228 | $3,001,313 | |
| FY2039 ·beyond the window | $188,000 | — | $1,777,947 | $444,612 | $3,445,925 | |
| FY2040 ·beyond the window | $188,000 | — | $1,965,947 | $465,996 | $3,911,921 | |
| FY2041 ·beyond the window | $188,000 | — | $2,153,947 | $487,381 | $4,399,302 | |
| FY2042 ·beyond the window | $188,000 | — | $2,341,947 | $508,765 | $4,908,067 | |
| FY2043 ·beyond the window | $188,000 | — | $2,529,947 | $530,149 | $5,438,216 | |
| FY2044 ·beyond the window | $188,000 | — | $2,717,947 | $551,534 | $5,989,750 | |
| FY2045 ·beyond the window | $188,000 | — | $2,905,947 | $572,918 | $6,562,668 | |
| FY2046 ·beyond the window | $188,000 | — | $3,093,947 | $594,302 | $7,156,970 | |
| FY2047 ·beyond the window | $188,000 | — | $3,281,947 | $615,687 | $7,772,657 |
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 | $1,234,900 |
| less the opening balance | − $794,747 |
| less the deposits already planned | − $376,000 |
| Uncovered | $64,153 |
| spread over 2 equal annual additions | $32,077 / yr |
The gradual answer — the one with less price shock.Instead of the same amount every year, the addition grows: $21,384 in year one, $42,769 in year two, and so on. A deposit rising in year t contributes t steps by year T, so the divisor is 1 + 2 + … + 2 = 3rather than 2:
| Uncovered through the binding year FY2029 | $64,153 |
| divided by the triangle number 3 | $21,384 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 |
|---|---|---|
| FY2037 | RTV FD | $37,900 |