Results are estimates for illustration only and not financial, tax, or investment advice. Verify with a qualified, registered advisor before making decisions.
Home Loan Amortization Schedule
Last updated
A home loan amortization schedule outlines each periodic payment across your loan term, detailing principal reduction and interest charges. For a ₹50 Lakh loan at 8.5% over 20 years, monthly EMI is ₹43,391. Total interest paid is ₹54,13,879 on a total repayment of ₹1,04,13,879, with early payments predominantly covering interest before principal repayments accelerate.
Generate a complete year-by-year home loan amortization schedule. Understand how each monthly installment splits between principal and interest, and model prepayment impact on your borrowing.
Runs in your browser
Your files and text are processed locally in your browser and are not uploaded.
How to Generate a Home Loan Amortization Schedule?
- Loan amount is preloaded at ₹50,00,000 (₹50 Lakh).
- Enter your sanctioned interest rate (default example uses 8.5%).
- Set your loan tenure in years (e.g., 20 years).
- Optionally enter monthly or annual prepayments to model early loan payoff.
- Review the year-by-year breakdown table and balance reduction chart.
Amortization Milestones for ₹50 Lakh Home Loan (8.5% Rate, 20-Year Tenure)
| Loan Year | Annual Principal Paid | Annual Interest Paid | Closing Balance | Principal % of Payment |
|---|---|---|---|---|
| Year 1 | ₹99,511 | ₹4,21,182 | ₹49,00,489 | 19.1% |
| Year 5 | ₹1,39,641 | ₹3,81,053 | ₹44,06,359 | 26.8% |
| Year 10 | ₹2,13,274 | ₹3,07,420 | ₹34,99,691 | 41.0% |
| Year 15 | ₹3,25,733 | ₹1,94,961 | ₹21,14,937 | 62.6% |
| Year 20 | ₹4,97,492 | ₹23,202 | ₹0 | 95.5% |
Source: Standard reducing balance amortization schedule. Exact EMI: ₹43,391.13 per month. Figures rounded to nearest rupee.
The Inversion Phenomenon in Amortization Schedules
In reducing-balance loans, interest is calculated on the remaining unpaid principal each month: - Initial Years: Because the outstanding principal is near ₹50 Lakh, monthly interest charges dominate. In Year 1, over 80% of your annual payments go toward interest, reducing principal by only ₹99,511. - Mid-Tenure: By Year 12 to 13, the principal repayment portion overtakes monthly interest charges. - Final Years: With principal largely repaid, interest drops to almost zero, and nearly 100% of each EMI directly pays off the remaining principal.
How Prepayments Shorten the Amortization Curve
Because early installments contain so little principal reduction, making prepayments in Years 1 to 5 yields outsized interest savings: - Prepaying ₹1,00,000 in Year 2 cuts months off your loan because it bypasses years of front-loaded interest on that capital.
Frequently asked questions
What is an amortization schedule in a home loan?
An amortization schedule is a complete chronological table showing each loan installment, the breakdown between interest and principal repayment, and the remaining loan balance after every payment.
Why is principal repayment so low in the first few years?
Under the reducing-balance method, interest is calculated on the outstanding balance. Since the balance is highest at the start of your loan, most of your EMI goes toward paying interest, leaving little to reduce principal.
When is the best time to make prepayments on a home loan?
The most effective time to prepay is during the first 5 to 7 years of the loan, when the interest proportion of your EMI is highest. Early prepayments maximize lifetime interest savings.
Need a different size? Use the full Loan Amortization.