@COMPOUND

The @COMPOUND() function compiles the proceeds of a compound interest calculation. The calculation is based on the balances of the specified member at the specified rate across the specified range.

Syntax

@COMPOUND(balanceMbr, rateMbrConst [, rangeList])

balanceMbr Single member specification representing the beginning balance across a range of periods. The input can be either one deposit or a series of deposits. If balanceMbr is a constant, then Hyperion Essbase assumes balanceMbr to be a single deposit in the first member of rangeList. This is equivalent to entering the constant value in the first member in the rangeList followed by zeros. The function keeps track of each deposit separately, but returns a composite value. If balanceMbr is a member, or a range, then it is assumed to be a series of deposits.

rateMbrConst Single member specification, variable name, or numeric expression in decimal form. This represents the interest rate per time period specified in the rangeList. If your interest is compounded monthly, this value would be the annual interest rate divided by 12.

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. rangeList represents the range over which the interest is compounded. The last value in the range is the total compounded interest for that range.

Notes

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

Example

The following example determines the compound interest of a series of deposits, based on a credit rate of 0.0525, across a series of fiscal years:

"Compound Interest"=@COMPOUND(Deposit,"Credit Rate",FY1991:FY1994,FY1995);

This example produces the following report:

               FY1991   FY1992   FY1993   FY1994   FY1995
               ======   ======   ======   ======   ======
			   
Credit Rate    0.0525  0.0525    0.0525   0.0525    0.0525
Compound Interest   0     105  110.5125 273.8144  288.1897
Deposit             0   2,000         0    3,000         0

See Also

@INTEREST

balanceMbr	Single member specification representing the beginning balance across a range of periods. The input can be either one deposit or a series of deposits. If balanceMbr is a constant, then Hyperion Essbase assumes balanceMbr to be a single deposit in the first member of rangeList. This is equivalent to entering the constant value in the first member in the rangeList followed by zeros. The function keeps track of each deposit separately, but returns a composite value. If balanceMbr is a member, or a range, then it is assumed to be a series of deposits.
rateMbrConst	Single member specification, variable name, or numeric expression in decimal form. This represents the interest rate per time period specified in the rangeList. If your interest is compounded monthly, this value would be the annual interest rate divided by 12.
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. rangeList represents the range over which the interest is compounded. The last value in the range is the total compounded interest for that range.