What the Loan Repayment Schedule does
The Loan Repayment Schedule turns a loan amount, interest rate and tenure into a full month-by-month table: each EMI, how much of it is interest, how much repays the loan, and the balance left. Add an extra amount each month to see how much interest you save and how much sooner the loan ends. The table can be downloaded for a spreadsheet.
How to use it
- Enter the loan amount, the yearly interest rate and the tenure in years.
- Optionally, enter an extra payment you could make every month.
- Choose the month of the first EMI so each row shows a date.
- Read the EMI, total interest and end date, then scroll the schedule or download it as CSV.
Example
A ₹25 lakh home loan at 8.5% for 20 years has an EMI of ₹21,695.58 and costs ₹27,06,939.40 in interest. In the first month, ₹17,708.33 of the EMI is interest and only ₹3,987.25 repays the loan. Paying ₹5,000 extra every month clears it in 155 months instead of 240, 7 years 1 month sooner, and saves ₹10,89,360.61 in interest.
Why the early years are mostly interest
Interest is charged each month on what you still owe. At the start the balance is highest, so most of the EMI goes on interest. As the balance falls, the interest part shrinks and more of each EMI repays the loan. This is why extra payments early in a loan save the most.
Most Indian banks do not charge a penalty for prepaying a floating-rate home loan taken by an individual, but check your loan agreement first.
Questions people ask
Is this the same as my bank’s schedule?
It should be very close. Banks may differ by a few rupees because of rounding, the day the EMI is debited and any fees.
What does the extra payment do?
It goes straight to the principal each month, so the balance falls faster, less interest is charged and the last EMI comes sooner.
Can I see the schedule by year?
The EMI Calculator shows a yearly summary. This tool shows every month, which is what lenders print.
Is my loan information stored?
No. Everything is worked out in your browser and nothing is sent anywhere.