@DECLINE

The @DECLINE() 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 [, rangeList])

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.

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, Hyperion Essbase uses the level 0 members from the dimension tagged as Time. The range represents the periods over which the function is calculated. More than one asset can be depreciated.

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,FY1991:FY1992,FY1993,FY1994);

This example produces the following report:

            FY1991    FY1992    FY1993    FY1994
            ======    ======    ======    ======
			
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

See Also

@SLN
@GROWTH

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.
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, Hyperion Essbase uses the level 0 members from the dimension tagged as Time. The range represents the periods over which the function is calculated. More than one asset can be depreciated.