# PMT function

The Excel PMT function is a financial function that helps you calculate the periodic payment for a loan or investment, assuming a constant interest rate and fixed payments.

## Syntax

=PMT(rate, nper, pv, [fv], [type])

## How to use

Let’s understand how to use the PMT function with an example:

Example: You want to calculate the monthly payment for a \$10,000 loan with an annual interest rate of 5%, to be repaid over 3 years, with payments made at the end of each month.

This formula uses a monthly interest rate (5% divided by 12 months) and the total number of payments (3 years multiplied by 12 months) to calculate the monthly payment for the loan. The present value (loan amount) is \$10,000. The PMT function will return the monthly payment amount.

## Additional Information

The PMT function is commonly used for various financial calculations, including loan repayments, annuities, and investments. It helps you determine how much you need to pay or how much you will receive regularly to reach a financial goal.