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.
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
| Input | Value |
|---|---|
| Amount | 5,000 |
| Nominal annual interest rate | 8% |
| Annual savings rate | 5% |
| Tax rate on savings interest | 20% |
| Months remaining | 12 |
| Result | Value |
|---|---|
| Advantage of repayment | 200 |
| Loan interest avoided | 400 |
| After-tax savings interest | 200 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Amount | 5,000 | 5,500 | Advantage of repayment | 200 | 220 |
| Nominal annual interest rate | 8% | 9% | Advantage of repayment | 200 | 250 |
| Annual savings rate | 5% | 6% | Advantage of repayment | 200 | 160 |
| Tax rate on savings interest | 20% | 22% | Advantage of repayment | 200 | 205 |
| Months remaining | 12 | 13 | Advantage of repayment | 200 | 216.666667 |
