Loan Amortization Schedule Calculator
Generate comprehensive month-by-month and year-by-year reducing balance amortization tables showing exact interest charges, principal repayment, and outstanding balances.
Adjust Parameters
Sanctioned loan amount to be amortized.
Compounded monthly on reducing balance basis.
Duration of the amortized repayment term.
For 240 months (20 Years (240 Months))
108.28% of total loan amount
Total cash outflow over loan life
Total interest divided by principal
Breakdown
Total: ₹62,48,327| Category | Amount | Percentage |
|---|---|---|
| Principal Repayment | ₹30,00,000 | 48.0% |
| Total Interest Cost | ₹32,48,327 | 52.0% |
Complete Loan Amortization Schedule
Reducing balance breakdown of principal and interest per period
| Year | Opening Balance | Principal Repaid | Interest Charged | Total Installment | Closing Balance |
|---|---|---|---|---|---|
| Year 1 | ₹30,00,000 | ₹59,710 | ₹2,52,710 | ₹3,12,420 | ₹29,40,293 |
| Year 2 | ₹29,40,293 | ₹64,985 | ₹2,47,433 | ₹3,12,420 | ₹28,75,309 |
| Year 3 | ₹28,75,309 | ₹70,729 | ₹2,41,688 | ₹3,12,420 | ₹28,04,580 |
| Year 4 | ₹28,04,580 | ₹76,982 | ₹2,35,436 | ₹3,12,420 | ₹27,27,600 |
| Year 5 | ₹27,27,600 | ₹83,784 | ₹2,28,630 | ₹3,12,420 | ₹26,43,815 |
| Year 6 | ₹26,43,815 | ₹91,191 | ₹2,21,228 | ₹3,12,420 | ₹25,52,625 |
| Year 7 | ₹25,52,625 | ₹99,251 | ₹2,13,164 | ₹3,12,420 | ₹24,53,374 |
| Year 8 | ₹24,53,374 | ₹1,08,026 | ₹2,04,393 | ₹3,12,420 | ₹23,45,351 |
| Year 9 | ₹23,45,351 | ₹1,17,572 | ₹1,94,844 | ₹3,12,420 | ₹22,27,779 |
| Year 10 | ₹22,27,779 | ₹1,27,964 | ₹1,84,451 | ₹3,12,420 | ₹20,99,815 |
| Year 11 | ₹20,99,815 | ₹1,39,275 | ₹1,73,142 | ₹3,12,420 | ₹19,60,540 |
| Year 12 | ₹19,60,540 | ₹1,51,586 | ₹1,60,829 | ₹3,12,420 | ₹18,08,954 |
| Year 13 | ₹18,08,954 | ₹1,64,983 | ₹1,47,429 | ₹3,12,420 | ₹16,43,969 |
| Year 14 | ₹16,43,969 | ₹1,79,568 | ₹1,32,849 | ₹3,12,420 | ₹14,64,402 |
| Year 15 | ₹14,64,402 | ₹1,95,439 | ₹1,16,976 | ₹3,12,420 | ₹12,68,962 |
| Year 16 | ₹12,68,962 | ₹2,12,715 | ₹99,700 | ₹3,12,420 | ₹10,56,247 |
| Year 17 | ₹10,56,247 | ₹2,31,518 | ₹80,899 | ₹3,12,420 | ₹8,24,730 |
| Year 18 | ₹8,24,730 | ₹2,51,981 | ₹60,436 | ₹3,12,420 | ₹5,72,749 |
| Year 19 | ₹5,72,749 | ₹2,74,252 | ₹38,164 | ₹3,12,420 | ₹2,98,495 |
| Year 20 | ₹2,98,495 | ₹2,98,495 | ₹13,920 | ₹3,12,420 | ₹0 |
How Loan Amortization Schedule is Calculated
Transparent mathematical formulas and assumptions used across our financial engines.
Variables & Legend
Conventions & Assumptions
- During the initial years of a loan, a major portion of each monthly EMI goes towards interest charges, with only a small portion reducing principal.
- As the principal balance reduces over time, the interest component decreases and the principal repayment component accelerates.
- Prepayments made in the first 30% to 50% of the loan tenure have the most dramatic impact on reducing total interest liability.
- Amortization tables allow you to track your exact outstanding balance for tax deduction calculations under Section 24(b) and Section 80C.
Frequently Asked Questions
Related Calculators & Scenarios
Explore AlternativesFast monthly installment calculation for any loan type.
Model how extra payments reduce your amortization schedule.
Calculate maximum borrowing capacity based on take-home salary.
All loan calculation, borrowing, and amortization tools.