Loan EMI Amortization Table
Get a full month-by-month EMI breakdown with principal, interest, and balance for any loan.
About this tool
The Loan EMI Amortization Table turns a loan into a month-by-month schedule of EMI, principal repaid, interest paid and remaining balance. Seeing every row makes abstract advice, like "prepay early", concrete: you can find the exact month in which your balance falls below half, or how much interest you have paid by the end of year two.
Enter the amount, the annual rate and the tenure in months. The tool prints a summary line with EMI, total interest and total payment and then the full table. It is useful for verifying a lender's repayment schedule, for planning a prepayment and for filling in tax-deduction worksheets that need the interest paid in a given year.
How to use it
- Enter the Loan Amount in rupees.
- Enter the Interest Rate per year in percent.
- Enter the Tenure in months. For 5 years, enter 60.
- Press Generate Table.
- Read the summary line, then scroll the table. Add up twelve rows of the interest column to get the interest for any financial year.
Tips and common mistakes
- Interest paid in a financial year is the sum of its twelve interest cells, not the loan interest divided by the tenure.
- Use the table to pick a prepayment month: the earlier the prepayment, the larger the interest it removes.
- Check that your bank's statement matches the table row by row for the first three months. Differences point to fees or a different first-month calculation.
- For long tenures the table is long. Use your browser's search to jump to a month number.
Frequently asked questions
What does the table show?
For every month it shows the EMI, the part that repays principal, the part that pays interest and the balance still owed.
Why does the principal column grow over time?
Interest is charged on a shrinking balance, so a larger share of the same EMI is left to repay principal each month.
Can I enter the tenure in years?
The tool asks for months. Multiply years by 12, so 20 years is 240.
How do I get the interest for one financial year?
Add the interest column for the twelve instalments that fall between April and March. Your lender's interest certificate gives the official figure.
Why might my bank's balance differ slightly?
Banks may round each EMI, charge the first instalment for a broken period or apply a rate change mid-loan.
Does this include processing fees?
No. Fees are separate from the EMI schedule.