Personal loan EMI calculator formula in Excel

To calculate the EMI (Equated Monthly Installment) for a personal loan using Excel, you can use the PMT function. The PMT function calculates the monthly payment for a loan based on the loan amount, the interest rate, and the loan term. Here is the formula you can use:



  • Rate: The interest rate per annum
  • Term: The loan term in years
  • Amount: The loan amount

To use this formula, enter the values in their respective cells in Excel and then use the PMT function to calculate the EMI. Here’s an example:

Assuming the interest rate is 12% per annum, the loan amount is Rs. 1,00,000, and the loan term is 3 years, the formula would be:


The result would be the EMI amount for the loan, which in this case would be Rs. 3,316.82.

Leave a Reply

Your email address will not be published. Required fields are marked *