The PMT Function is a financial function in Excel that returns the periodic payment amount for a loan or an investment. PMT assumes that the payments and the interest rate are constant ... say $500 ...