Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions

Transformation Language Reference

Transformation Language Reference

PV

PV

Returns the present value of an investment.

Syntax

PV(
rate, terms, payment
[,
future value, type
] )
The following table describes the arguments for this command:
Argument
Required/
Optional
Description
rate
Required
Numeric. Interest rate earned in each period. Expresses as a decimal number. Divide the rate by 100 to express it as a decimal number.
terms
Required
Numeric. Number of period or payments. Must be greater than 0.
The Spark engine writes null values for rows when the terms argument passes a 0 value. In the native environment, the Data Integration Service rejects the row and does not write it to the target.
payments
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.
types
Optional
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
Data Integration Service
treats the value as 1.

Return Value

Numeric.

Example

The following expression returns 12,524.43 as the amount you must deposit in the account today to have a future value of $20,000 in one year if you also deposit $500 at the beginning of each period:
PV( 0.0075, 12, -500, 20000, TRUE )

0 COMMENTS

We’d like to hear from you!