How to read a loan amortization schedule
An amortization schedule shows how much of each payment covers interest, how much clears principal and how much debt remains. It is useful when you want to compare a lender's quote with your statement, estimate the balance on a sale date, or check how a prepayment was applied.
Work through three rows
Take a ₹3,00,000 loan at 12% a year over 24 months, with monthly interest and no fees. The EMI calculator gives about ₹14,122.04 per month. The monthly rate is 1%.
- Month 1. Opening principal is ₹3,00,000.00. Interest is ₹3,000.00 and principal paid is ₹11,122.04. Closing principal is ₹2,88,877.96.
- Month 2. Opening principal is ₹2,88,877.96. Interest is ₹2,888.78 and principal paid is ₹11,233.26. Closing principal is ₹2,77,644.70.
- Month 3. Opening principal is ₹2,77,644.70. Interest is ₹2,776.45 and principal paid is ₹11,345.59. Closing principal is ₹2,66,299.10.
You can recreate a row in a spreadsheet. Multiply opening principal by the period rate, subtract interest from the EMI to get principal paid, then subtract principal paid from the opening balance. Carry the closing balance into the next row. Use full precision and round only for display. Adding or subtracting the rounded figures can produce a one-paisa difference.
A quick check on a statement
After one year in this example, the principal remaining is about ₹1,58,945. The total paid is about ₹1,69,464, of which about ₹1,41,055 reduced the original balance and ₹28,409 paid interest. Compare the principal remaining on the same date and after the same payment number. A lender's amount due on a specific date can also include accrued interest and other charges.
If you're reconciling an actual loan, check the disbursement and first payment dates, rate resets, and any extra payments. In the model above, the next row after an extra ₹10,000 principal payment would start ₹10,000 lower. At 1% a month that reduces the next period's interest by ₹100. Later savings depend on what happens to the EMI and repayment term.
Use the prepayment calculator to compare keeping the EMI with keeping the end date. For a covered bank term loan, compare that model with the lender's amortization schedule in the Key Facts Statement under the RBI's Responsible Business Conduct Directions, Chapter VIII.