EXCTOOLZ
/

Loan Prepayment Calculator

Compare remaining loan payments with a one-time prepayment and extra monthly payments to estimate time and interest saved.

Your inputs

₹ INR
Choose the currency for your amounts. Values are not exchange-rate converted.
YOUR RESULT

Net estimated savings

₹13,95,372.10
Original monthly EMI
₹26,034.70
New monthly payment
₹28,034.70
Interest after prepayment
₹18,52,955.18
Months saved
77
New remaining months
163
Prepayment + fees
₹3,00,000.00
Calculation method & assumptions

The original EMI is retained. The lump sum reduces the balance immediately; extra payments are added to every subsequent EMI.

The fixed rate and remaining term define the comparison. Fees entered are deducted from the estimated savings.

Repayment breakdown

Compare the components of the estimated total.

Repayment breakdownCompare the components of the estimated total. Principal repaid: INR 27,00,000; Interest paid: INR 18,52,955Principal repaidINR 27,00,000Interest paidINR 18,52,955Estimated total4.6M

Remaining loan balance

Values at selected points in the calculation period.

Remaining loan balanceValues at selected points in the calculation period. M1: INR 26,91,090; M16: INR 25,49,615; M30: INR 24,03,351; M45: INR 22,29,740; M60: INR 20,36,740; M75: INR 18,22,186; M89: INR 16,00,367; M104: INR 13,37,077; M119: INR 10,44,381; M134: INR 7,18,996; M148: INR 3,82,595; M163: INR 02.7M2.0M1.3M672.8K0M1M16M30M45M60M75M89M104M119M134M148M163INR

Detailed breakdown

163 rows
MonthPaymentPrincipalInterestBalance
1₹28,034.70₹8,909.70₹19,125.00₹26,91,090.30
2₹28,034.70₹8,972.81₹19,061.89₹26,82,117.50
3₹28,034.70₹9,036.36₹18,998.33₹26,73,081.13
4₹28,034.70₹9,100.37₹18,934.32₹26,63,980.76
5₹28,034.70₹9,164.83₹18,869.86₹26,54,815.93
6₹28,034.70₹9,229.75₹18,804.95₹26,45,586.17
7₹28,034.70₹9,295.13₹18,739.57₹26,36,291.05
8₹28,034.70₹9,360.97₹18,673.73₹26,26,930.08
9₹28,034.70₹9,427.28₹18,607.42₹26,17,502.80
10₹28,034.70₹9,494.05₹18,540.64₹26,08,008.75
11₹28,034.70₹9,561.30₹18,473.40₹25,98,447.45
12₹28,034.70₹9,629.03₹18,405.67₹25,88,818.42
13₹28,034.70₹9,697.23₹18,337.46₹25,79,121.19
14₹28,034.70₹9,765.92₹18,268.78₹25,69,355.27
15₹28,034.70₹9,835.10₹18,199.60₹25,59,520.17
16₹28,034.70₹9,904.76₹18,129.93₹25,49,615.41
17₹28,034.70₹9,974.92₹18,059.78₹25,39,640.48
18₹28,034.70₹10,045.58₹17,989.12₹25,29,594.91
19₹28,034.70₹10,116.73₹17,917.96₹25,19,478.17
20₹28,034.70₹10,188.39₹17,846.30₹25,09,289.78
21₹28,034.70₹10,260.56₹17,774.14₹24,99,029.22
22₹28,034.70₹10,333.24₹17,701.46₹24,88,695.98
23₹28,034.70₹10,406.43₹17,628.26₹24,78,289.55
24₹28,034.70₹10,480.15₹17,554.55₹24,67,809.40
25₹28,034.70₹10,554.38₹17,480.32₹24,57,255.02
26₹28,034.70₹10,629.14₹17,405.56₹24,46,625.88
27₹28,034.70₹10,704.43₹17,330.27₹24,35,921.45
28₹28,034.70₹10,780.25₹17,254.44₹24,25,141.20
29₹28,034.70₹10,856.61₹17,178.08₹24,14,284.58
30₹28,034.70₹10,933.51₹17,101.18₹24,03,351.07
31₹28,034.70₹11,010.96₹17,023.74₹23,92,340.11
32₹28,034.70₹11,088.95₹16,945.74₹23,81,251.15
33₹28,034.70₹11,167.50₹16,867.20₹23,70,083.65
34₹28,034.70₹11,246.60₹16,788.09₹23,58,837.05
35₹28,034.70₹11,326.27₹16,708.43₹23,47,510.78
36₹28,034.70₹11,406.50₹16,628.20₹23,36,104.28
37₹28,034.70₹11,487.29₹16,547.41₹23,24,616.99
38₹28,034.70₹11,568.66₹16,466.04₹23,13,048.33
39₹28,034.70₹11,650.60₹16,384.09₹23,01,397.73
40₹28,034.70₹11,733.13₹16,301.57₹22,89,664.60
41₹28,034.70₹11,816.24₹16,218.46₹22,77,848.36
42₹28,034.70₹11,899.94₹16,134.76₹22,65,948.42
43₹28,034.70₹11,984.23₹16,050.47₹22,53,964.19
44₹28,034.70₹12,069.12₹15,965.58₹22,41,895.07
45₹28,034.70₹12,154.61₹15,880.09₹22,29,740.47
46₹28,034.70₹12,240.70₹15,793.99₹22,17,499.76
47₹28,034.70₹12,327.41₹15,707.29₹22,05,172.36
48₹28,034.70₹12,414.73₹15,619.97₹21,92,757.63
49₹28,034.70₹12,502.66₹15,532.03₹21,80,254.97
50₹28,034.70₹12,591.22₹15,443.47₹21,67,663.74
PASS IT ON

A useful tool is worth sharing.

RELATED TOOLS

A little more to explore.

All tools
SIP CalculatorStep-up SIP CalculatorLumpsum CalculatorSWP CalculatorCAGR Calculator
USEFUL TOOLS

Explore the collection, one useful tool at a time.

15 useful tools · Ready when you areView all tools
HOW IT WORKS

Three steps. Ready for what’s next.

01

Enter your inputs

Use the labelled fields and select the assumptions or dates that apply to your calculation.

02

Review the result

Results update as inputs change. Check the breakdown, calculation method and assumptions.

03

Copy or download

Copy a summary or download the calculation breakdown as a CSV.

About Loan Prepayment Calculator.

How loan prepayment is calculated

The original EMI is retained. The lump sum reduces the balance immediately; extra payments are added to every subsequent EMI.

What the result means

Compare remaining loan payments with a one-time prepayment and extra monthly payments to estimate time and interest saved.

Assumptions and scope

The fixed rate and remaining term define the comparison. Fees entered are deducted from the estimated savings.

Using the calculator

Enter outstanding loan balance, annual interest rate, duration (years), one-time prepayment now, extra monthly payment, prepayment fees. Change the values to compare results. Calculations run in your browser. No account is required.

A LITTLE CLARITY

Good questions. Simple answers.

A few helpful answers before you get started.

Do I need an account?

No. This tool is open to everyone without signing in.

Does this tool need the internet?

Your inputs are calculated in this browser. Load the tool online before using it offline.

Still have a question?Get in touch