What is an Amortization Schedule?
An amortization schedule is a detailed table that shows each loan payment over the full term. For a personal loan with a fixed EMI, the schedule lists every installment, how much of it goes toward interest and how much toward reducing the principal, and the remaining loan balance after each payment.
The word “amortization” refers to gradually paying off a debt over time through regular payments. For personal loans, the EMI amount is typically fixed for the entire tenure, but the split between principal and interest changes with every payment.
- Each row shows the payment number, the total EMI, the interest portion, the principal portion, and the outstanding balance.
- The interest portion is highest in the early months and decreases over time.
- The principal portion starts small and increases as the loan matures.
- The final payment brings the outstanding balance to zero.
| Month | EMI (₹) | Interest (₹) | Principal (₹) | Outstanding Balance (₹) |
|---|---|---|---|---|
| 1 | 16,607 | 5,000 | 11,607 | 4,88,393 |
| 2 | 16,607 | 4,884 | 11,723 | 4,76,670 |
| 3 | 16,607 | 4,767 | 11,840 | 4,64,830 |
| 4 | 16,607 | 4,648 | 11,959 | 4,52,871 |
| 5 | 16,607 | 4,529 | 12,078 | 4,40,793 |
| 6 | 16,607 | 4,408 | 12,199 | 4,28,594 |
| 7 | 16,607 | 4,286 | 12,321 | 4,16,273 |
| 8 | 16,607 | 4,163 | 12,444 | 4,03,829 |
| 9 | 16,607 | 4,038 | 12,569 | 3,91,260 |
| 10 | 16,607 | 3,913 | 12,694 | 3,78,566 |
| 11 | 16,607 | 3,786 | 12,821 | 3,65,745 |
| 12 | 16,607 | 3,657 | 12,950 | 3,52,795 |
| 13 | 16,607 | 3,528 | 13,079 | 3,39,716 |
| 14 | 16,607 | 3,397 | 13,210 | 3,26,506 |
| 15 | 16,607 | 3,265 | 13,342 | 3,13,164 |
| 16 | 16,607 | 3,132 | 13,475 | 2,99,689 |
| 17 | 16,607 | 2,997 | 13,610 | 2,86,079 |
| 18 | 16,607 | 2,861 | 13,746 | 2,72,333 |
| 19 | 16,607 | 2,723 | 13,884 | 2,58,449 |
| 20 | 16,607 | 2,584 | 14,023 | 2,44,426 |
| 21 | 16,607 | 2,444 | 14,163 | 2,30,263 |
| 22 | 16,607 | 2,303 | 14,304 | 2,15,959 |
| 23 | 16,607 | 2,160 | 14,447 | 2,01,512 |
| 24 | 16,607 | 2,015 | 14,592 | 1,86,920 |
| 25 | 16,607 | 1,869 | 14,738 | 1,72,182 |
| 26 | 16,607 | 1,722 | 14,885 | 1,57,297 |
| 27 | 16,607 | 1,573 | 15,034 | 1,42,263 |
| 28 | 16,607 | 1,423 | 15,184 | 1,27,079 |
| 29 | 16,607 | 1,271 | 15,336 | 1,11,743 |
| 30 | 16,607 | 1,117 | 15,490 | 96,253 |
| 31 | 16,607 | 963 | 15,644 | 80,609 |
| 32 | 16,607 | 806 | 15,801 | 64,808 |
| 33 | 16,607 | 648 | 15,959 | 48,849 |
| 34 | 16,607 | 488 | 16,119 | 32,730 |
| 35 | 16,607 | 327 | 16,280 | 16,450 |
| 36 | 16,614 | 164 | 16,450 | 0 |
How Principal and Interest are Calculated
For a fixed-rate personal loan, each EMI is calculated using a standard formula that takes the loan amount, the monthly interest rate, and the number of monthly payments. The monthly interest rate is the annual rate divided by 12. In the example above, 12% annual interest becomes 1% per month.
In each payment, the interest portion is the current outstanding balance multiplied by the monthly interest rate. The remaining amount of the EMI reduces the principal. Because the outstanding balance decreases with each payment, the interest portion also decreases, and the principal portion increases.
- EMI = P × r × (1 + r)^n / ((1 + r)^n − 1), where P is the loan amount, r is the monthly interest rate, and n is the number of months.
- For a ₹5,00,000 loan at 1% monthly interest over 36 months, the EMI is about ₹16,607 per month for the first 35 months, with a slightly adjusted final payment of ₹16,614 to clear the balance exactly.
- First month interest: ₹5,00,000 × 1% = ₹5,000. Principal repaid: ₹16,607 − ₹5,000 = ₹11,607.
- Second month interest: ₹4,88,393 × 1% = ₹4,884 (rounded).
Sample Amortization Schedule (Loan: ₹5,00,000, 12%, 3 years)
The table above shows the complete amortization schedule for a personal loan of ₹5,00,000 at 12% annual interest for 3 years (36 months). The regular EMI is ₹16,607 per month, and the final payment is ₹16,614 to ensure the balance reaches exactly zero. The table lists every month’s interest, principal, and outstanding balance.
Notice that the total interest paid over the loan term is approximately ₹97,859. If the same loan were taken for a longer tenure, the monthly EMI would be lower, but the total interest would be higher. Conversely, a shorter tenure would raise the EMI but reduce total interest.
- Total repayment = 35 × ₹16,607 + ₹16,614 = ₹5,97,859
- Total interest = ₹5,97,859 − ₹5,00,000 = ₹97,859
- This example uses the nominal annual interest rate of 12% for the payment calculation. The actual cost may be higher if the lender charges processing fees or other charges; these are not included in this illustration.
How Schedule Changes with Tenure and Rate
The shape of your amortization schedule depends heavily on two factors: the interest rate and the loan tenure. A higher rate increases the interest portion of early payments, while a longer tenure spreads the principal over more months, reducing the EMI but increasing total interest.
For example, compare a ₹5,00,000 loan at 12% for 3 years versus the same loan for 5 years. At 3 years, the EMI is about ₹16,607 and total interest is about ₹97,859. At 5 years, the EMI drops to about ₹11,122 but total interest rises to about ₹1,67,320.
The interest rate also has a major effect. For a 3-year loan of ₹5,00,000, a lower rate of 10% results in an EMI of about ₹16,134 and total interest of about ₹80,824. A higher rate of 14% raises the EMI to about ₹17,084 and total interest to about ₹1,15,024.
- Shorter tenure: higher EMI, lower total interest.
- Longer tenure: lower EMI, higher total interest.
- Lower interest rate: lower total interest and a faster principal paydown.
- Always compare the total interest cost, not just the monthly EMI, when evaluating loan offers.
| Tenure | Rate | Monthly EMI (₹) | Total Interest (₹) |
|---|---|---|---|
| 3 years (36 months) | 10% | 16,134 | 80,824 |
| 3 years (36 months) | 12% | 16,607 | 97,859 |
| 3 years (36 months) | 14% | 17,084 | 1,15,024 |
| 5 years (60 months) | 12% | 11,122 | 1,67,320 |
Prepayment on the Schedule
If you make an extra payment toward the principal, the outstanding balance drops immediately. This reduces the interest for all future months, and your loan may be paid off earlier than the original schedule, depending on whether the lender recalculates your EMI or keeps it fixed.
There are two common ways lenders handle prepayment. Some reduce the loan tenure while keeping the EMI the same; others recalculate the EMI for the remaining tenure. Both methods lower the total interest you pay, but the effect is different. Always check your lender’s policy on prepayment charges and how they adjust the schedule.
- Prepayment reduces the principal balance, so future interest costs are lower.
- If the lender keeps the EMI constant, the loan is cleared earlier than the original term.
- If the lender reduces the EMI, the tenure stays the same but each payment has a higher principal portion.
- Lenders may charge a prepayment penalty for personal loans; check the loan agreement.
Using the Schedule for Financial Planning
An amortization schedule helps you plan your finances in several ways. You can see exactly how much of your EMI is going toward interest, which is useful for budgeting and tax planning (if applicable). You can also estimate the impact of making extra payments or choosing a different tenure.
For example, if you receive a bonus, you can use the schedule to see how much interest you would save by making a lump-sum prepayment. You can project when your loan will be paid off and how your cash flow will change over time.
- Track how your outstanding balance falls each month.
- Identify the point at which the principal portion of your EMI exceeds the interest portion.
- Compare the total cost of different loan offers using total interest, not just EMI.
- Use the schedule to decide whether prepayment is worth any fees.
Interest
A frequent misunderstanding is that the interest is simply the annual rate multiplied by the loan amount. In reality, interest is calculated on the outstanding balance, so you do not pay the full 12% of the original amount every year. Another myth is that paying the EMI on time automatically reduces the interest portion faster; the schedule is set in advance, so only extra payments change the original schedule.
Some borrowers believe that a longer tenure is always better because the EMI is lower. However, the lower monthly payment comes with significantly higher total interest. It is important to look at the full cost of the loan over its life.
- Interest is not simply loan amount × rate × tenure; it is calculated on the reducing balance.
- Paying your EMI on time does not change the interest split; extra principal payments do.
- A longer tenure does not always mean a better deal—check the total interest.
- Even if the EMI is fixed, the interest and principal components vary each month.
Frequently asked questions
Why is interest higher at the start of my loan?
Interest is calculated on the outstanding principal. Early in the loan, the balance is highest, so the interest portion is also high. As you make payments, the principal decreases, so the interest portion declines.
How do I read an amortization table?
Each row corresponds to a payment period (usually a month). The table shows the payment amount, how much of it is interest, how much goes to principal, and the remaining balance after that payment. The balance decreases over time until it reaches zero at the end.
What happens to my amortization schedule if I make an extra payment?
An extra payment reduces your outstanding principal. As a result, future interest calculations use the lower balance, which reduces the total interest you will pay. Depending on your lender, the extra amount may either shorten the loan term (if the EMI stays the same) or reduce the EMI (if the tenure stays fixed). Check with your lender for their specific policy and any prepayment charges.
Can I get an amortization schedule from my lender?
Yes, most personal loan lenders provide an amortization schedule at the time of loan approval or on request. It is often available through the lender’s online portal or customer service.
Is the EMI amount fixed for the entire tenure?
For most personal loans, the EMI is fixed, meaning it remains the same every month. However, if you make prepayments or miss payments, the lender may adjust the schedule. Some loans have floating or variable interest rates, which can change the EMI, but this is uncommon for unsecured personal loans.