Loan Amortization Schedule
Generate a complete loan amortization table showing monthly breakdown of principal and interest.
About this tool
A loan amortization schedule is the repayment plan in full: for every month it shows the EMI, how much of it repays principal, how much is interest and what balance remains. This tool generates the schedule and the headline numbers for any fixed-rate loan, and displays the first two years in the table so it loads instantly.
It is helpful when you want to understand how a loan behaves rather than just what it costs. For example, in the first year of a 20-year loan most of each EMI is interest, and the principal portion creeps up month after month. Seeing it in numbers makes the case for early prepayment and for choosing a shorter tenure.
How to use it
- Enter the Loan Amount.
- Enter the Annual Interest Rate in percent.
- Enter the Loan Term in years.
- Press Generate Schedule.
- Read the summary (EMI, total interest, total amount) and then the first 24 months of the schedule.
Tips and common mistakes
- Check your bank's schedule against this one. The interest and balance columns should agree within rounding.
- Interest in the first years of a long loan is the largest part of your EMI, so that is when prepayment helps most.
- If you change tenure or rate, regenerate the schedule. The EMI and every row change.
- Save or print the schedule for loan-interest tax filings.
Frequently asked questions
What is an amortization schedule?
It is the full repayment plan of a loan, listing each instalment, how much of it is interest, how much repays principal and the balance after that payment.
Why does the table show only 24 months?
The table is kept short so the page stays fast. The summary above it reflects the whole loan. Use the Loan EMI Table tool to see every month.
Does the schedule change if I prepay?
Yes. A prepayment lowers the balance and either shortens the loan or reduces the EMI. Use the prepayment calculator for that.
What if my loan has a floating rate?
The schedule assumes a fixed rate. If your rate changes, the EMI or tenure changes and you should regenerate it from the current balance.
Why is the last instalment sometimes slightly different?
Banks round each payment, so the final instalment is adjusted to bring the balance to exactly zero.
Can I use it for any currency?
Yes. The maths does not depend on the currency.