## How to calculate EMI in excel with Principle and the Interest components | DataWitzz

#### How to calculate EMI in excel

How to calculate EMI is most annoying thing when we take loan or planning to take loan. It also very difficult when we wanted to check interest and loan amount components spread over EMI tenure. Though there multiple online stuffs are available to calculate EMI but the spread over EMI tenure is very early. I just tried to make it excel which will surely help you.

**Let us first learn How to calculate EMI in excel :**

In excel to calculate EMI we would use PMT function of excel. Syntax for PMT function is as below:

PMT function requires below input to calculate EMI:

**rate**: interest rate