Need to figure your Equated Monthly Installment (monthly payment) for a credit in Excel? It’s remarkably straightforward! This guide will walk you through the method of using Excel’s PMT function to find your periodic payments. First, understand that the PMT function requires three key pieces of data: the interest, the number of installments, a