Need a more accurate EMI estimate?
Month | Beginning Loan Balance | EMI | Principal | Monthly Interest | Outstanding Balances |
January | ₹650000 | ₹5620 | ₹1043 | ₹4577 | ₹648957 |
February | ₹648957 | ₹5620 | ₹1051 | ₹4570 | ₹647906 |
March | ₹647906 | ₹5620 | ₹1058 | ₹4562 | ₹646848 |
April | ₹646848 | ₹5620 | ₹1065 | ₹4555 | ₹645783 |
May | ₹645783 | ₹5620 | ₹1073 | ₹4547 | ₹644710 |
June | ₹644710 | ₹5620 | ₹1080 | ₹4540 | ₹643629 |
July | ₹643629 | ₹5620 | ₹1088 | ₹4532 | ₹642541 |
August | ₹642541 | ₹5620 | ₹1096 | ₹4525 | ₹641446 |
September | ₹641446 | ₹5620 | ₹1103 | ₹4517 | ₹640342 |
October | ₹640342 | ₹5620 | ₹1111 | ₹4509 | ₹639231 |
November | ₹639231 | ₹5620 | ₹1119 | ₹4501 | ₹638112 |
December | ₹638112 | ₹5620 | ₹1127 | ₹4493 | ₹636985 |
Month | Beginning Loan Balance | EMI | Principal | Monthly Interest | Outstanding Balances |
January | ₹6525000 | ₹5620 | ₹1654773 | ₹4452 | ₹648957 |
February | ₹648957 | ₹5620 | ₹1051 | ₹46540 | ₹647906 |
March | ₹647906 | ₹5620 | ₹1058 | ₹4656 | ₹646848 |
April | ₹646848 | ₹5620 | ₹15555 | ₹4555 | ₹645783 |
May | ₹645783 | ₹56550 | ₹1073 | ₹4547 | ₹644710 |
June | ₹644710 | ₹5620 | ₹10330 | ₹4540 | ₹643629 |
July | ₹643629 | ₹563430 | ₹1088 | ₹4532 | ₹642541 |
August | ₹642541 | ₹5620 | ₹1046 | ₹4525 | ₹641446 |
September | ₹6341446 | ₹5620 | ₹1103 | ₹4517 | ₹640342 |
October | ₹644342 | ₹5620 | ₹1111 | ₹4509 | ₹639231 |
November | ₹639231 | ₹5620 | ₹1119 | ₹4501 | ₹638112 |
December | ₹638112 | ₹5620 | ₹1127 | ₹4493 | ₹636985 |
If you want to cross-check the EMI amount then use the following standardized formula:
E = P × r × (1 + r)^n / ((1 + r)^n - 1)
Here,
P = Principal or Loan amount
E = applicable future EMI
r = Interest rate applicable
n = Number of EMIs or applicable tenure
For example, if any borrower avails a loan of 35 lakh for a tenure of 10 years at a 9.50% rate of interest, the applicable EMI will be –
E = 35,00,000 × 0.007917 × (1 + 0.007917)^120 / ((1 + 0.007917)^120 - 1)
EMI = Rs. 45,289 per month
For instance, if a borrower takes a home loan of ₹35 lakh from Piramal Capital & Housing Finance with a 10-year tenure at a 9.5% interest rate, the amortization schedule for the initial months may look like this:
Month | EMI (₹) | Principal Payment (₹) | Interest Payment (₹) | Remaining Balance (₹) |
---|---|---|---|---|
1 | 45,289 | 17,568 | 27,721 | 34,82,432 |
2 | 45,289 | 17,704 | 27,585 | 34,64,728 |
3 | 45,289 | 17,841 | 27,448 | 34,46,887 |
4 | 45,289 | 17,978 | 27,311 | 34,28,909 |
5 | 45,289 | 18,116 | 27,173 | 34,10,793 |
120 | 45,289 | 45,062 | 227 | 0 |
This amortization schedule provides an essential view of how the loan repayment progresses over time, helping borrowers make informed financial decisions and potentially reduce their loan burden through strategic prepayments.
Have any queries? We’d love to hear from you.
📞 Call us: +91 782 769 4613
✉️ Mail us: homeloan@suganta.com