PMT Function in Excel

How to Use the PMT Function in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

PMT Function in Excel

Financial functions let you calculate things like interest, payments, and future values.

One of the most useful financial functions, the PMT function, calculates the payment for a loan based on periodic payments and a constant interest rate. For example, if you are taking out a $10,000 car loan at 8% interest and know that the loan would have to be paid off in four years, you could use the PMT function to calculate that the monthly payments for such a loan would be $244.13.

PMT Function

  1. Select the cell where you want to add the result of the payment function.
  2. Click the Insert Function button.

    The Insert Function feature helps you select, enter, and edit worksheet functions.

  3. Select Financial from the list of function categories.
    PMT Function
  4. Select the PMT function.

    A description appears below the list describing what the PMT function calculates.

  5. Click OK.
    PMT Function
  6. Fill in the function arguments.

    Pay attention to the argument notes below the argument fields. These give details about what to enter for the argument.

    The arguments in bold are required; the others are optional.

    Instead of typing argument values, click in an argument field, then select a cell or cell range in the worksheet.

  7. Click OK when you’re finished.
    PMT Function

The payment function calculates all the arguments and puts the result in the selected cell.