Navigation:  Reference > Functions >

PMT function

Print this Topic Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Items

Calculates the payment for a loan based on constant payments and a constant interest rate.

Syntax

PMT(rate,nper,pv,type)

Rate

is the interest rate for the loan, consistent with the number of payment periods. For example if the annual interest rate is 9% (0.09) and the payments are made monthly, then Rate should be 0.09/12.

Nper

total number of payments for the loan.

Pv

present value of the loan, also known as the principal.

Type

indicates when payments are due. Set to 0 if payments are due at the end of each period; 1 if payments are due at the beginning of each period.

This function is identical to Excel's PMT function with a future value of 0.

Examples:

Payment vs. Number of Payment Periods:

Payment vs. Interest Rate:

 

____________________________

See also:

Functions

 


Page url: https://www.dplot.com/help/index.htm?pmt_function.htm