Open calculator ↗

Agricultural machinery replacement reserve · Calculation guide

Escalate the current replacement price, deduct expected sale proceeds and future value of the existing reserve, then fund the shortfall with equal year-end deposits.

Calculation guide

deposit = max(0,(price*(1+growth/100)^years-salvage)/(1+rate/100)^years-reserve)*pmt(1,12*rate,years)

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

InputValue
Current replacement price120,000
Annual price escalation (%)0%
Years until replacement5
Expected future sale proceeds20,000
Existing reserve10,000
Annual reserve yield (%)0%
ResultValue
Annual reserve contribution18,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Current replacement price120,000132,000Annual reserve contribution18,00020,400
Annual price escalation (%)0%1%Annual reserve contribution18,00019,224.241202
Years until replacement56Annual reserve contribution18,00015,000
Expected future sale proceeds20,00022,000Annual reserve contribution18,00017,600
Existing reserve10,00011,000Annual reserve contribution18,00017,800
Annual reserve yield (%)0%1%Annual reserve contribution18,00017,543.581965
Agricultural machinery replacement reserve →

Sources