Want to quickly figure out your monthly loan payments? Excel can help you with that! Follow these straightforward instructions to find your EMI in just a few clicks. First entering the loan amount, interest rate, and duration into separate cells. Then, use the PMT function to determine your EMI. The formula will look like this: =PMT(interest_rate