Overpayment versus keeping cash in savings · Calculation guide

Compare avoided loan interest and after-tax savings interest over a short horizon.

Calculation guide

Simple interest on an unchanged incremental balance for the entered horizon. No repayment fee; funds remain invested for the whole period. Liquidity has no assigned value.

Advantage = cash × months/12 × [loan rate − savings rate × (1 − tax%)] / 100.

Inputs

Amount

Example entry 5000 (in the selected currency).

Nominal annual interest rate

Example entry 8 %. Allowed range 0 to 100.

Annual savings rate

Example entry 5 %. Allowed range 0 to 100.

Tax rate on savings interest

Example entry 20 %. Allowed range 0 to 100.

Months remaining

Example entry 12. Allowed range 1 to 120. Use whole numbers.

Worked example

InputValue
Amount5,000
Nominal annual interest rate8%
Annual savings rate5%
Tax rate on savings interest20%
Months remaining12
ResultValue
Advantage of repayment200
Loan interest avoided400
After-tax savings interest200

Calculation steps

Advantage of repayment = ((((Amount × Months remaining) ÷ 12) × (Nominal annual interest rate − (Annual savings rate × (1 − (Tax rate on savings interest ÷ 100))))) ÷ 100)

((((5,000 × 12) ÷ 12) × (8 − (5 × (1 − (20 ÷ 100))))) ÷ 100) = 200

Loan interest avoided = ((((Amount × Months remaining) ÷ 12) × Nominal annual interest rate) ÷ 100)

((((5,000 × 12) ÷ 12) × 8) ÷ 100) = 400

After-tax savings interest = (((((Amount × Months remaining) ÷ 12) × Annual savings rate) ÷ 100) × (1 − (Tax rate on savings interest ÷ 100)))

(((((5,000 × 12) ÷ 12) × 5) ÷ 100) × (1 − (20 ÷ 100))) = 200

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Amount5,0005,500Advantage of repayment200220
Nominal annual interest rate8%9%Advantage of repayment200250
Annual savings rate5%6%Advantage of repayment200160
Tax rate on savings interest20%22%Advantage of repayment200205
Months remaining1213Advantage of repayment200216.666667
Overpayment versus keeping cash in savings →

Sources