Loan Amortization Calculator
A loan amortization schedule is a complete table of periodic loan payments showing the amount of principal and interest that comprise each payment until the loan is paid off.
Key Insight: Front-Loaded Interest
In the first month of a 20-year home loan, only ~15% of your EMI reduces the principal. By month 200, over 85% goes toward principal. That's amortization at work.
Enter your loan details below to generate a full month-by-month schedule. Download it as CSV to import into Excel or Google Sheets.
Loan Details
20 yr 0 mo
Loan Summary
- Monthly EMI
- ₹43,391
- Total Amount Payable
- ₹1.04 Cr
- Total Interest
- ₹54.14 L
- Interest as % of Total
- 52.0%
💡 For every ₹100 you pay, ₹48.0 goes toward principal and ₹52.0 goes to interest.
Amortization Schedule
Repayment Schedule
| Month | EMI | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | ₹43,391 | ₹7,974 | ₹35,417 | ₹49,92,026 |
| 2 | ₹43,391 | ₹8,031 | ₹35,360 | ₹49,83,995 |
| 3 | ₹43,391 | ₹8,088 | ₹35,303 | ₹49,75,907 |
| 4 | ₹43,391 | ₹8,145 | ₹35,246 | ₹49,67,762 |
| 5 | ₹43,391 | ₹8,203 | ₹35,188 | ₹49,59,559 |
| 6 | ₹43,391 | ₹8,261 | ₹35,130 | ₹49,51,298 |
| 7 | ₹43,391 | ₹8,319 | ₹35,072 | ₹49,42,978 |
| 8 | ₹43,391 | ₹8,378 | ₹35,013 | ₹49,34,600 |
| 9 | ₹43,391 | ₹8,438 | ₹34,953 | ₹49,26,162 |
| 10 | ₹43,391 | ₹8,498 | ₹34,894 | ₹49,17,665 |
| 11 | ₹43,391 | ₹8,558 | ₹34,833 | ₹49,09,107 |
| 12 | ₹43,391 | ₹8,618 | ₹34,773 | ₹49,00,489 |
Frequently Asked Questions
What is loan amortization?
Loan amortization is the process of paying off a loan through regular scheduled payments. Each payment covers the interest due and reduces the principal. An amortization schedule shows the breakdown for every payment over the life of the loan.
Why does interest feel so high in the early months?
Because interest is charged on the outstanding principal. At the start, your balance is highest, so more of each EMI goes to interest. As the principal reduces, the interest portion shrinks and the principal portion grows — this is called the "front-loaded interest" effect.
How does a part-prepayment help?
A lump-sum prepayment directly reduces your outstanding principal. Since future interest is calculated on this lower balance, you save significantly on total interest and can potentially reduce tenure.
What is the difference between EMI and amortization?
EMI is the fixed monthly payment amount. Amortization describes how that payment is split between principal and interest, and how the loan balance evolves month by month.
Can I download the amortization schedule?
Yes. Use the "Download CSV" button below the schedule to export it to Excel or Google Sheets.