@NPV

The @NPV() function calculates the Net Present Value of an investment based on the series of payments (negative values) and income (positive values).

Syntax

@NPV (cashflowMbr, rateMbrConst, discountFlag [, rangeList])

cashflowMbr Member specification providing a series of numeric values.

rateMbrConst Single member specification, variable name, or numeric expression, providing a constant value.

discountFlag Single member specification, variable name, or numeric expression set to 0 or 1 to indicate whether the function should discount from the first period. 1 means do not discount from the first period.

rangeList Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the dimension tagged as Time. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.

Notes

Financial functions never return a value; rather, they calculate a series of values internally based on the range specified.

Example

In this example, Value is calculated with the following formula:

Value = @NPV(Cash, Rate, 0, FY1990:FY1994, FY1995:FY2000);

This example produces the following report:

       FY1990  FY1991  FY1992  FY1993  FY1994  FY1995
       ======  ======  ======  ======  ======  ======

Cash   (1,000)   500     600     500  #MISSING  #MISSING
Rate       0      0       0       0   #MISSING  #MISSING
Value     296    296     296     296      296     296

See Also

@PTD

cashflowMbr	Member specification providing a series of numeric values.
rateMbrConst	Single member specification, variable name, or numeric expression, providing a constant value.
discountFlag	Single member specification, variable name, or numeric expression set to 0 or 1 to indicate whether the function should discount from the first period. 1 means do not discount from the first period.
rangeList	Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the dimension tagged as Time. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.