PowerCenter
- PowerCenter 10.5.1
- All Products
NPER(rate, present value, payment[,future value, type] )
Argument
| Required/
Optional
| Description
|
---|---|---|
rate
| Required
| Numeric. Interest rate earned in each period. Expressed as a decimal number. Divide the rate by 100 to express it as a decimal number.
|
present value
| Required
| Numeric. Lump-sum amount a series of future payments is worth.
|
payment
| Required
| Numeric. Payment amount due per period. Must be a negative number.
|
future value
| Optional
| Numeric. Cash balance you want to attain after the last payment is made. If you omit this value, NPER uses 0.
|
type
| Optional
| Boolean. Timing of the payment. Enter 1 if payment is at the beginning of period. Enter 0 if 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.
|
NPER ( 0.015, -500, -2000, 20000, TRUE )