EMI Calculator Excel


Interest Rate
Tenure (in months)

Loan EMI


Total Interest Payable


Total Amount


Certainly! Here’s an example of an EMI (equated monthly installment) calculator in Excel:

Open Microsoft Excel.

In the first column (Column A), create the following headers:
Loan Amount
Interest Rate
Loan Tenure (in months)
EMI (Equated Monthly Installment)
In the second column (Column B), enter the corresponding values for the loan amount, interest rate, and loan tenure.
In cell B5, enter the formula to calculate the EMI. Assuming the loan amount is in cell B2, the interest rate is in cell B3, and the loan tenure is in cell B4, the formula would be:
Copy code
PMT(B3/12, B4, -B2)

Format the values in column B as currency (select the cells, right-click, choose Format Cells, and select the currency format).
Adjust the column widths and formatting as needed to make the table clear and presentable.
That’s it! Now you have an EMI calculator in Excel. You can change the values in cells B2, B3, and B4 to calculate the EMI for different scenarios. The calculated EMI will be automatically updated based on the changes you make.

Please note that the formula assumes the interest rate is an annual rate and divides it by 12 to get the monthly interest rate. The loan tenure is also assumed to be in months. Adjust the formula accordingly if your requirements differ.

Remember to double-check the formula and adjust it as necessary to suit your specific needs.