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.

On the Excel screen, this function can be found using the command fx and under the category ‘Financial’. Periodic investments Here’s an example of how PMT can be used.

There are other examples, but so long as you remember that the payments need to be constant in amount and frequency of payment, then you can use the PMT finance function. Using PMT In Excel. Microsoft ...