Calculation guide
For each replacement, allocate its own existing reserve and enter expected nominal replacement cost at its due date. Equal annual contributions earn zero interest.
annual = Σ max(0, replacement cost − assigned reserve)/remaining years
Inputs
Cost at replacement date
Example entry 100000 (in the selected currency).
Assigned reserve
Example entry 40000 (in the selected currency).
Years to replacement
Example entry 5. Allowed range 1e-06 to 250.0.
Worked example
Reserve study components
| Cost at replacement date | Assigned reserve | Years to replacement |
|---|---|---|
| 100,000 | 40,000 | 5 |
| 15,000 | 0 | 5 |
| Result | Value |
|---|---|
| Required annual reserve contribution | 15,000 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Cost at replacement date (row 1) | 100,000 | 110,000 | Required annual reserve contribution | 15,000 | 17,000 |
| Assigned reserve (row 1) | 40,000 | 44,000 | Required annual reserve contribution | 15,000 | 14,200 |
| Years to replacement (row 1) | 5 | 6 | Required annual reserve contribution | 15,000 | 13,000 |
