: =PPMT(Rate, Month_Number, Total_Months, -Loan_Amount)
: Up to ₹6,500 + GST or up to 2% of the loan amount.
In the cell where you want to see the EMI (e.g., B4), enter this formula: =PMT(B2/12, B3*12, -B1)
: =IPMT(Rate, Month_Number, Total_Months, -Loan_Amount)
: =PPMT(Rate, Month_Number, Total_Months, -Loan_Amount)
: Up to ₹6,500 + GST or up to 2% of the loan amount.
In the cell where you want to see the EMI (e.g., B4), enter this formula: =PMT(B2/12, B3*12, -B1)
: =IPMT(Rate, Month_Number, Total_Months, -Loan_Amount)
![]() |
|
![]() |
|
![]() |
|
Copyright © 2011 - iLike-share. All Rights Reserved. hdfc bank personal loan emi calculator excel download