Calculation guide
Inputs
Current replacement price
Example entry 120000.0 (in the selected currency).
Annual price escalation (%)
Example entry 0.0 %. Allowed range 0 to 100.
Years until replacement
Example entry 5.0. Minimum 1. Use whole numbers.
Expected future sale proceeds
Example entry 20000.0 (in the selected currency).
Existing reserve
Example entry 10000.0 (in the selected currency).
Annual reserve yield (%)
Example entry 0.0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Current replacement price | 120,000 |
| Annual price escalation (%) | 0% |
| Years until replacement | 5 |
| Expected future sale proceeds | 20,000 |
| Existing reserve | 10,000 |
| Annual reserve yield (%) | 0% |
| Result | Value |
|---|---|
| Annual reserve contribution | 18,000 |
Calculation steps
Annual reserve contribution = (max(0, ((((Current replacement price × ((1 + (Annual price escalation (%) ÷ 100)) ^ Years until replacement)) − Expected future sale proceeds) ÷ ((1 + (Annual reserve yield (%) ÷ 100)) ^ Years until replacement)) − Existing reserve)) × payment(1, (12 × Annual reserve yield (%)), Years until replacement))
(max(0, ((((120,000 × ((1 + (0 ÷ 100)) ^ 5)) − 20,000) ÷ ((1 + (0 ÷ 100)) ^ 5)) − 10,000)) × payment(1, (12 × 0), 5)) = 18,000
Interpreting the result
A zero contribution means projected reserves and resale proceeds already cover the replacement purchase.
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 |
|---|---|---|---|---|---|
| Current replacement price | 120,000 | 132,000 | Annual reserve contribution | 18,000 | 20,400 |
| Annual price escalation (%) | 0% | 1% | Annual reserve contribution | 18,000 | 19,224.241202 |
| Years until replacement | 5 | 6 | Annual reserve contribution | 18,000 | 15,000 |
| Expected future sale proceeds | 20,000 | 22,000 | Annual reserve contribution | 18,000 | 17,600 |
| Existing reserve | 10,000 | 11,000 | Annual reserve contribution | 18,000 | 17,800 |
| Annual reserve yield (%) | 0% | 1% | Annual reserve contribution | 18,000 | 17,543.581965 |
