PMT Formula in Excel calculates the payment for a loan based on constant payments and a constant interest rate. The PMT formula is explained in the post.