Loan Amortization Generator
Generate a complete month-by-month breakdown of principal and interest payments for any loan.
Loan Details
Monthly EMI
₹ 20,517
Total Interest
₹ 2,31,020
Total Payment
₹ 12,31,020
| Month | Beginning Balance | Interest Paid | Principal Paid | Ending Balance |
|---|
Understanding Loan Amortization
Amortization refers to the process of paying off a debt over time through regular scheduled payments. Each EMI consists of two components — a principal portion and an interest portion. In early months, the bulk goes toward interest. Over time, the split reverses as the outstanding balance reduces.
The schedule above shows every month's split. Use it to decide the best time for prepayment — paying extra in the first few years saves significantly more interest than prepaying later.
EMI Formula (Reducing Balance)
EMI = P × r × (1+r)^n / [(1+r)^n − 1]
- P = Principal loan amount
- r = Monthly interest rate (Annual % ÷ 12 ÷ 100)
- n = Total months (Years × 12)
How Much Does Interest Really Cost?
Total interest paid as a % of loan amount at 8.5% p.a. — you pay far more than the loan itself for long tenures.
| Tenure | Monthly EMI (₹10L loan) | Total Interest | Interest % of Loan |
|---|---|---|---|
| 1 Year | ₹87,376 | ₹48,513 | 4.9% |
| 3 Years | ₹31,569 | ₹1,36,470 | 13.6% |
| 5 Years | ₹20,517 | ₹2,31,022 | 23.1% |
| 10 Years | ₹12,400 | ₹4,87,996 | 48.8% |
| 15 Years | ₹9,847 | ₹7,72,469 | 77.2% |
| 20 Years | ₹8,678 | ₹10,82,726 | 108% |
Typical Loan Rates in India (May 2025)
| Loan Type | Rate Range | Tenure | Key Feature |
|---|---|---|---|
| Home Loan | 8.40–9.50% | Up to 30 years | Tax benefit on interest (Sec 24b) & principal (80C) |
| Car Loan | 8.70–12.00% | 1–7 years | No tax benefit; vehicle is collateral |
| Business Loan | 10.00–16.00% | 1–5 years | Interest is business expense (tax deductible) |
| Personal Loan | 10.50–24.00% | 1–5 years | Unsecured; no tax benefit |
| Education Loan | 8.00–15.00% | Up to 15 years | Interest deductible under Sec 80E for 8 years |
| Loan Against Property | 9.00–13.00% | Up to 15 years | Lower rate; property is collateral |
6 Things Your Amortization Schedule Reveals
Interest-Heavy First Half
In the first 50% of your loan tenure, you pay roughly 65–75% of the total interest. Prepayments in Year 1–3 have 3× the impact of the same amount prepaid in Year 8–10.
The Break-Even Point
The month where your principal component first exceeds your interest component is your amortization midpoint — typically around 60–65% through the loan tenure at standard rates.
Tenure vs Rate Tradeoff
Reducing your rate by 0.5% on a ₹50L 20-year loan saves ~₹3.8L. Reducing tenure by 5 years saves ~₹8L. Tenure reduction is almost always the better strategy.
Part-Prepayment ROI
Every ₹1 prepaid early in a loan at 9% effectively earns you 9% guaranteed, tax-equivalent return — better than most fixed deposits.
Balance for Loan Transfer
The outstanding balance column tells you exactly what you owe at any point — useful when considering a balance transfer to a lower-rate lender.
Tax Planning (Home Loans)
The interest column in each year helps you claim the correct deduction under Section 24(b) (up to ₹2L/year) when filing your ITR.