Essbase @NPV

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])
Parameter Description
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, 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