Need to calculate your Equated Monthly Installment (monthly payment) for a mortgage in Excel? It’s quite straightforward! This guide will walk you through the steps of using Excel’s PMT function to compute your periodic payments. First, know that the PMT function requires three key inputs: the interest, the number of payment periods, and the lo