Calculates the Net Present Value of an investment based on the series
of payments (negative values) and income (positive values).
@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, Essbase uses the level 0 members from the dimension tagged as
Financial functions never return a value; rather, they calculate a series
of values internally based on the range specified.
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