Calculation guide
For borrowers checking repayment costs and timing under their entered terms.
Rates are entered annual nominal rates converted to the stated payment period. Payments occur at period ends. Principal and interest are kept separate, and the final payment reconciles the remaining balance. Fees are included only where entered. Comparing different terms also shows remaining balances at a common horizon. These are product assumptions, not lender approval or universal statutory APR calculations.
Inputs
Principal
Original deposit or outstanding loan amount before this calculation adds interest.
Annual interest / discount rate
Annual interest or discount rate; the selected frequency determines its periodic rate.
Months
Duration in months. Payment frequency may divide this into different repayment periods.
New rate
Annual interest rate offered for the replacement loan.
New months
Remaining duration in months for the replacement loan.
Switching costs
One-off charge included in this scenario. It reduces savings, available money or net proceeds.
Worked example
| Input | Value |
|---|---|
| Principal | 500,000 |
| Annual interest / discount rate | 10% |
| Months | 60 |
| New rate | 9% |
| New months | 60 |
| Switching costs | 5,000 |
Formula:
ΔK = K₀−K₁; K_j=Σ C_{j,t}+B_{j,H}+F_j
Net saving = 9660.68454742932
Month = 1.00000000000000; Keep cost = 504166.666666667; Switch cost = 508750.000000000; Net saving = -4583.33333333331
Month = 60.0000000000000; Keep cost = 637411.341338048; Switch cost = 627750.656790619; Net saving = 9660.68454742932
| Result | Value |
|---|---|
| Net saving | 9,660.684547 |
| Scenario 1 | 637,411.341338 |
| Scenario 2 | 627,750.656791 |
| Original payment | 10,623.522356 |
| New payment | 10,379.177613 |
| Lifetime saving | 9,660.684547 |
| Break even month | 13 months |
Interpreting the result
Reduction in the specified cost compared with the original scenario. A negative amount means extra cost.
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 |
|---|---|---|---|---|---|
| Principal | 500,000 | 550,000 | Net saving | 9,660.684547 | 11,126.753002 |
| Annual interest / discount rate | 10% | 11% | Net saving | 9,660.684547 | 24,522.035389 |
| Months | 60 | 66 | Net saving | 9,660.684547 | 22,628.15925 |
| New rate | 9% | 10% | Net saving | 9,660.684547 | -5,000 |
| New months | 60 | 66 | Net saving | 9,660.684547 | -1,854.314141 |
| Switching costs | 5,000 | 5,500 | Net saving | 9,660.684547 | 9,160.684547 |
