- PowerCenter 10.4.0
- All Products
PMT(rate, terms, present value[,future value, type] )
Numeric. Interest rate of the loan for each period. Expressed as a decimal number. Divide the rate by 100 to express it as a decimal number. Must be greater than or equal to 0.
Numeric. Number of periods or payments. Must be greater than 0.
Numeric. Principle for the loan.
Numeric. Cash balance you want to attain after the last payment. If you omit this value, PMT uses 0.
Boolean. Timing of the payment. Enter 1 if the payment is at the beginning of period. Enter 0 if the payment is at the end of period. Default is 0. If you enter a value other than 0 or 1, the
PowerCenter Integration Servicetreats the value as 1.
PMT( 0.01, 10, 20000 )
Updated December 12, 2019