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 |
---|---|
An accumulation of values up to the specified member |
|
The proceeds of a compound interest calculation |
|
A series of values that represent the compound growth of the specified member across a range of members |
|
Depreciation for a specific period, calculated using the declining balance method |
|
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 |
|
A series of values that represents the linear growth of the specified value |
|
The simple interest for a specified member at a specified rate |
|
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). |
|
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. |
|
The Net Present Value of an investment (based on a series of payments and incomes) |
|
The period-to-date values of members in the dimension tagged as time |
|
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. |
|
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(...))).