@COMPOUND

This 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 [, XrangeList])

Parameters

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 Essbase assumes balanceMbr to be a single deposit in the first member of rangeList or XrangeList. This is equivalent to entering the constant value in the first member in the range 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 or XrangeList. If your interest is compounded monthly, this value would be the annual interest rate divided by 12.

XrangeList

Optional parameter specifying the range over which the interest is compounded. The last value in the range is the total compounded interest for that range. If a range is not specified, Essbase uses the level 0 members from the dimension tagged as Time.

Can be a valid member name, a comma-delimited list of member names, cross dimensional members, or a return value from a member set function or range function (including @XRANGE).

For more information about rangeList and XrangeList, see Range List Parameters in the topic Range and Financial Functions.

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",FY1998:FY2001,FY2002);

This example produces the following report:

               FY1998   FY1999   FY2000   FY2001   FY2002
               ======   ======   ======   ======   ======
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

The following example assumes a Year dimension is added to Sample Basic. It calculates compound interest using a multidimensional range.

FIX ("100-10", "New York")
"Compound Interest" = @COMPOUND(Deposit,"Credit Rate",@XRANGE("2011"->"Sep", "2012"->"Mar"));
ENDFIX

The above calculation is performed across the following multidimensional range specified by XrangeList:


2011->Sep
2011->Oct
2011->Nov
2011->Dec
2012->Jan
2012->Feb
2012->Mar