PowerCenter
- PowerCenter 10.4.0
- All Products
PMT(rate, terms, present value[,future value, type] )
Argument | Required/ Optional | Description |
---|---|---|
rate | Required
| 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.
|
terms
| Required
| Numeric. Number of periods or payments. Must be greater than 0.
|
present value
| Required
| Numeric. Principle for the loan.
|
future value
| Optional
| Numeric. Cash balance you want to attain after the last payment. If you omit this value, PMT uses 0.
|
type
| Optional
| 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 Service treats the value as 1.
|
PMT( 0.01, 10, 20000 )