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])
| Parameter | Description |
|---|---|
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. 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, 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",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 0See Also