Loan Amortization Schedule Calculator – Full EMI Breakup Table
View your complete loan repayment schedule with principal and interest breakup. Compare up to 5 lenders side-by-side.
Related tools
More in loans
| Lender | Monthly EMI | Total Interest | Proc. Fee | Total Cost |
|---|---|---|---|---|
HDFC Bank★ 8.4% · 20yr | ₹17,230 | ₹21.35 L | ₹10,000 | ₹41.45 L |
SBI 8.55% · 20yr | ₹17,420 | ₹21.81 L | ₹5,000 | ₹41.86 L |
ICICI Bank 8.75% · 20yr | ₹17,674 | ₹22.42 L | ₹8,500 | ₹42.50 L |
Most people are shocked when they see their first amortization table. On a ₹50 lakh home loan at 8.5% for 20 years, you'll pay nearly ₹53 lakh in interest alone — more than the loan itself. The amortization schedule shows you exactly why: in the early years, almost 80% of every EMI goes toward interest, not your principal. Knowing this is the first step toward making smarter prepayments.
How to Read Your Amortization Table
An amortization table has 5 key columns. Here is how to interpret each one:
EMI Number
Shows which payment you are on (1 to N). Helps track progress through the loan tenure.
Principal Paid
The portion of your EMI actually reducing your loan balance. Increases over time.
Interest Paid
The cost of borrowing for that month. High initially, decreases gradually.
Outstanding Balance
The remaining loan amount after each payment. Should reach zero at the end.
Why Your Interest is High in Initial Years (Front-Loading Explained)
On a ₹50 lakh loan at 8.5% for 20 years:
Year 1-5
₹3.2L paid / ₹20.3L paid
86% of EMI goes to interest
Year 6-10
₹10.8L paid / ₹16.7L paid
61% of EMI goes to interest
Year 11-15
₹18.4L paid / ₹12.1L paid
40% of EMI goes to interest
Year 16-20
₹17.6L paid / ₹5.1L paid
22% of EMI goes to interest
How Prepayment Changes Your Amortization Schedule
Making a partial prepayment can dramatically reduce your total interest. Here is how:
| Scenario | Original | With ₹5L Prepayment (Year 5) | Savings |
|---|---|---|---|
| Total Interest | ₹54,13,840 | ₹41,80,000 | ₹12,33,840 |
| Loan Tenure | 20 years | 16.5 years | 3.5 years |
| Remaining EMI | ₹43,391 | ₹43,391 | Same EMI, less tenure |
Download Amortization Schedule as CSV
The amortization table below supports one-click download. You can save the full schedule for offline analysis, tax planning, or sharing with your financial advisor.
What is a Loan Amortization Schedule?
In plain words
A loan amortization schedule is a complete table showing every EMI payment broken into principal and interest components. In the initial years, a larger portion goes toward interest. Over time, the principal portion increases — this is called the reducing balance method used by all Indian banks.
Each EMI = Principal Portion + Interest Portion
Interest Portion = Outstanding Principal × Monthly Interest Rate
Principal Portion = EMI – Interest Portion
New Outstanding = Previous Outstanding – Principal PortionA quick example
Let us see how the amortization works for a typical loan:
Step by step
- 1.Monthly EMI = ₹43,391 (fixed for entire tenure)
- 2.Month 1: Interest = ₹50,00,000 × 0.7083% = ₹35,417, Principal = ₹43,391 - ₹35,417 = ₹7,974
- 3.Month 2: Interest = ₹49,92,026 × 0.7083% = ₹35,360, Principal = ₹43,391 - ₹35,360 = ₹8,031
- 4.After Year 1: Principal paid ≈ ₹1,00,000, Interest paid ≈ ₹4,20,000
- 5.After Year 10: Principal paid ≈ ₹15,00,000, Interest paid ≈ ₹37,00,000
- 6.By Year 20: Entire loan repaid, total interest = ₹54,13,840
So the answer is: In the first year, 80% of each EMI goes to interest. By year 10, it becomes 50-50. Use the amortization table to see the exact breakup.