- PowerCenter 10.4.0
- All Products
PV(rate, terms, payment[,future value, type] )
Numeric. Interest rate earned in each period. Expresses as a decimal number. Divide the rate by 100 to express it as a decimal number. Must be greater that or equal to 0.
Numeric. Number of period or payments. Must be greater than 0.
Numeric. Payment amount due per period. Must be a negative number.
Numeric. Cash balance after the last payment. If you omit this value, PV uses 0.
Boolean. Timing of the payment. Enter 1 if 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.
PV( 0.0075, 12, -500, 20000, TRUE )
Updated December 12, 2019