To calculate a loan payment in Excel, you can use the PMT function. The PMT function calculates the payment for a loan that has constant payments and a constant interest rate. Enter an interest rate, the number of payments, and the loan amount on the worksheet. Then, refer to those cells in the PMT formula