The PMT function in Excel is a financial function used to calculate a loan's payment based on payments and interest rates. Learn How to use it.

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

Note that because this is a payment, Excel will display this number in parenthesis and red font. To avoid that, insert a "-" sign in front of the PMT formula, like below.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.