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.
Payments per year
Number of payments in one year; use 12 for monthly payments.
Extra
Extra principal repayment, in addition to the scheduled payment.
First extra-payment month
Month when extra repayment starts; zero means immediately before the first period.
Extra frequency
Choose one extra payment or repeated extra payments on scheduled repayment dates.
Prepayment mode
Choose whether extra repayment shortens the loan or reduces later scheduled payments.
Prepayment fee
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 |
| Payments per year | 12 |
| Extra | 50,000 |
| First extra-payment month | 12 |
| Extra frequency | Once |
| Prepayment mode | Reduce tenure |
| Prepayment fee | 0 |
Formula:
B_t = max(0,B_{t−1}(1+r)−C_t−E_t)
Net saving = 22669.1142515779
Period = 1.00000000000000; Opening balance = 500000.000000000; Periodic payment = 10623.5223556341; Interest = 4166.66666666667; Principal paid = 6456.85568896746; Balance = 493543.144311033
Period = 54.0000000000000; Opening balance = 1681.52949209406; Periodic payment = 1695.54223786151; Interest = 14.0127457674505; Principal paid = 1681.52949209406; Balance = 0.00000000000000
| Result | Value |
|---|---|
| Net saving | 22,669.114252 |
| Interest saved | 22,669.114252 |
| Periods saved | 6 |
| Original payment | 10,623.522356 |
| Last regular payment | 10,623.522356 |
| Total paid | 614,742.227086 |
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 | 22,669.114252 | 22,850.970715 |
| Annual interest / discount rate | 10% | 11% | Net saving | 22,669.114252 | 25,394.542333 |
| Months | 60 | 66 | Net saving | 22,669.114252 | 26,101.114172 |
| Payments per year | 12 | 1 | Net saving | 22,669.114252 | 23,205 |
| Extra | 50,000 | 55,000 | Net saving | 22,669.114252 | 24,709.627786 |
| First extra-payment month | 12 | 13 | Net saving | 22,669.114252 | 22,083.572519 |
| Extra frequency | Once | Monthly | Net saving | 22,669.114252 | 79,758.189056 |
| Prepayment mode | Reduce tenure | Periodic payment | Net saving | 22,669.114252 | 10,870.200243 |
| Prepayment fee | 0 | 1 | Net saving | 22,669.114252 | 22,668.114252 |
