Loan Prepayment Calculator · Calculation guide

See how extra payments could reduce loan interest or repayment time.

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.

B_t = max(0,B_{t−1}(1+r)−C_t−E_t)

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

InputValue
Principal500,000
Annual interest / discount rate10%
Months60
Payments per year12
Extra50,000
First extra-payment month12
Extra frequencyOnce
Prepayment modeReduce tenure
Prepayment fee0

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

ResultValue
Net saving22,669.114252
Interest saved22,669.114252
Periods saved6
Original payment10,623.522356
Last regular payment10,623.522356
Total paid614,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal500,000550,000Net saving22,669.11425222,850.970715
Annual interest / discount rate10%11%Net saving22,669.11425225,394.542333
Months6066Net saving22,669.11425226,101.114172
Payments per year121Net saving22,669.11425223,205
Extra50,00055,000Net saving22,669.11425224,709.627786
First extra-payment month1213Net saving22,669.11425222,083.572519
Extra frequencyOnceMonthlyNet saving22,669.11425279,758.189056
Prepayment modeReduce tenurePeriodic paymentNet saving22,669.11425210,870.200243
Prepayment fee01Net saving22,669.11425222,668.114252
Loan Prepayment Calculator →