Financial Functions

Financial functions allow you to include financial calculations in Essbase formulas, including accumulation, interest, growth, depreciation, and more.

Table 18-7 List of Financial Functions

Function	Calculation
@ACCUM	An accumulation of values up to the specified member
@COMPOUND	The proceeds of a compound interest calculation
@COMPOUNDGROWTH	A series of values that represent the compound growth of the specified member across a range of members
@DECLINE	Depreciation for a specific period, calculated using the declining balance method
@DISCOUNT	A value discounted by the specified rate, from the first period of the range to the period in which the amount to discount is found
@GROWTH	A series of values that represents the linear growth of the specified value
@INTEREST	The simple interest for a specified member at a specified rate
@IRR	The Internal Rate of Return on a cash flow that is calculated across the time dimension or a specified range of members and must contain at least one investment (negative) and one income (positive). Includes an initial guess of 0.07 (the initial guess cannot be configured).
@IRREX	The Internal Rate of Return on a cash flow that is calculated across the time dimension or a specified range of members and must contain at least one investment (negative) and one income (positive). Includes functionality to configure the initial guess and the number of iterations the algorithm can make.
@NPV	The Net Present Value of an investment (based on a series of payments and incomes)
@PTD	The period-to-date values of members in the dimension tagged as time
@SLN	The amount per period that an asset in the current period may be depreciated (calculated across a range of periods). The depreciation method used is straight-line depreciation.
@SYD	The amount per period that an asset in the current period may be depreciated (calculated across a range of periods). The depreciation method used is sum of the year's digits.

Note:

One member formula cannot contain multiple financial functions (for example, @NPV and @SLN, or multiple instances of @NPV). A member formula that requires multiple financial functions must be broken into separate formulas so that each formula contains only one financial function (for example, MemberName(@NPV(...));Membername(@NPV(...))).