@DECLINE

The @DECLINE calculation function for Essbase calculates the depreciation of an asset.

This function calculates the depreciation of an asset for the specified period, using the declining balance method. The factor by which the declining balance depreciates the assets is specified using factorMbrConst. For example, to calculate a double declining balance, set factorMbrConst to 2.

Syntax

@DECLINE (costMbr, salvageMbrConst, lifeMbrConst, factorMbrConst [, XrangeList])

Parameters

costMbr

Single member specification representing the starting values of the assets. More than one asset can be input and depreciated across the specified range. The function calculates each asset separately.

salvageMbrConst

Single member specification, variable name, or numeric expression that provides a constant value. This value represents the value of the asset at the end of the depreciation.

lifeMbrConst

Single member specification, variable name, or numeric expression that provides a constant value. The value represents the number of periods over which the asset is depreciated.

factorMbrConst

Single member specification, variable name, or numeric expression that provides a constant value. The value represents the factor by which the asset is depreciated.

XrangeList

Optional parameter specifying the periods over which the function is calculated. More than one asset can be depreciated. 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, seeRange 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 calculates the depreciation of Asset for the specified series of fiscal years.

"Decline Dep" = @DECLINE(Asset,Residual,Life,2,FY2000:FY2001,FY2002,FY2003);

This example produces the following report:

            FY2000    FY2001    FY2002    FY2003
            ======    ======    ======    ======                
Asset        9,000         0         0         0
Residual       750         0         0         0
Life             5         0         0         0
Decline Dep  3,600     2,160     1,296       778

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

FIX ("100-10", "New York")
"Decline Dep" = @DECLINE(Asset,Residual,Life,2,@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

See Also