Loan Amortization Schedule Calculator
Generate an exact month-by-month and annual amortization schedule for your loan with detailed principal, interest, and remaining balance tracking.
Amortization Schedule Breakdown
Track how each payment reduces principal versus interest over time.
| Year | Opening Balance | Principal Paid | Interest Paid | Total Annual EMI | Closing Balance |
|---|---|---|---|---|---|
| Year 1 | ₹30,00,000 | ₹1,03,476 | ₹2,51,030 | ₹3,54,506 | ₹28,96,524 |
| Year 2 | ₹28,96,524 | ₹1,12,622 | ₹2,41,884 | ₹3,54,506 | ₹27,83,902 |
| Year 3 | ₹27,83,902 | ₹1,22,577 | ₹2,31,929 | ₹3,54,506 | ₹26,61,325 |
| Year 4 | ₹26,61,325 | ₹1,33,412 | ₹2,21,095 | ₹3,54,506 | ₹25,27,913 |
| Year 5 | ₹25,27,913 | ₹1,45,204 | ₹2,09,302 | ₹3,54,506 | ₹23,82,709 |
| Year 6 | ₹23,82,709 | ₹1,58,039 | ₹1,96,468 | ₹3,54,506 | ₹22,24,671 |
| Year 7 | ₹22,24,671 | ₹1,72,008 | ₹1,82,498 | ₹3,54,506 | ₹20,52,663 |
| Year 8 | ₹20,52,663 | ₹1,87,212 | ₹1,67,294 | ₹3,54,506 | ₹18,65,451 |
| Year 9 | ₹18,65,451 | ₹2,03,760 | ₹1,50,747 | ₹3,54,506 | ₹16,61,691 |
| Year 10 | ₹16,61,691 | ₹2,21,770 | ₹1,32,736 | ₹3,54,506 | ₹14,39,921 |
| Year 11 | ₹14,39,921 | ₹2,41,373 | ₹1,13,134 | ₹3,54,506 | ₹11,98,548 |
| Year 12 | ₹11,98,548 | ₹2,62,708 | ₹91,798 | ₹3,54,506 | ₹9,35,841 |
| Year 13 | ₹9,35,841 | ₹2,85,929 | ₹68,577 | ₹3,54,506 | ₹6,49,912 |
| Year 14 | ₹6,49,912 | ₹3,11,202 | ₹43,304 | ₹3,54,506 | ₹3,38,710 |
| Year 15 | ₹3,38,710 | ₹3,38,710 | ₹15,797 | ₹3,54,506 | ₹0 |
What Is a Loan Amortization Schedule?
A Loan Amortization Schedule is a comprehensive financial table that outlines every periodic payment across the lifespan of a loan. It breaks down each monthly installment into the exact amount allocated toward principal repayment versus the amount absorbed by accrued interest charges, alongside the reducing balance.
Why Is Loan Interest Front-Loaded?
Because monthly interest is calculated directly on the remaining loan principal, the interest burden is greatest when the loan balance is at its maximum (during the first 3 to 7 years of a 20-year loan). As monthly payments gradually reduce the principal balance, the interest charge shrinks, allowing a larger portion of each EMI to extinguish the principal.
Frequently Asked Questions
Related Calculators
Other calculators you might find useful.
EMI Calculator
Calculate monthly EMI, total interest, and total payment for home, car, or personal loans.
Loan Prepayment Calculator
Calculate interest savings and tenure or EMI reduction by making partial loan prepayments.
Present Value Calculator
Calculate current discounted present value of a future cash sum.
Future Value Calculator
Calculate future value of a single present investment compounding at a fixed interest rate.
Compound Interest Calculator
Calculate compound interest growth with annual, semi-annual, quarterly, or monthly compounding.