The PMT function is an Excel Financial function that ... It is required. See the example of the EFFECT function in the photo. The NOMINAL function returns the annual nominal interest rate.