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. Must be greater than or equal to 0. |
terms | Required | Numeric. Number of periods or payments. Must be greater than 0. |
payment | Required | Numeric. Payment amount due per period. Must be a negative number. |
future value | Optional | Numeric. Cash balance after the last payment. If you omit this value, PV 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, Data Integration treats the value as 1. |