@IRR

The @IRR() function calculates the Internal Rate of Return on a cash flow that must contain at least one investment (negative) and one income (positive) value.

Syntax

@IRR(cashflowMbr, discountFlag[, rangeList])

cashflowMbr Single member specification.

discountFlag Member specification, variable name, or numeric expression providing a constant value of either 1 or 0. discountFlag indicates 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 same dimension. 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

This example calculates the Internal Rate of Return (Return) on a cash flow (Cash).

Return = @IRR(Cash,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
Return       0       0      0      0          0          0

cashflowMbr	Single member specification.
discountFlag	Member specification, variable name, or numeric expression providing a constant value of either 1 or 0. discountFlag indicates 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 same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.