Skip to main content

Pmt - script and chart function

This function returns the payment for a loan based on periodic, constant payments and a constant interest rate. It cannot change over the life of the annuity. A payment is stated as a negative number, for example, -20.

Pmt(rate, nper, pv [ ,fv [ , type ] ] )

Return data type: numeric. By default, the result will be formatted as currency..

To find the total amount paid over the duration of the loan, multiply the returned pmt value by nper.


Argument Description
rate The interest rate per period.
nper The total number of payment periods in an annuity.


The present value, or lump-sum amount, that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero).


The future value, or cash balance, you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0.


Should be 0 if payments are due at the end of the period and 1 if payments are due at the beginning of the period. If type is omitted, it is assumed to be 0.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!