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
@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
|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. The range represents the periods over which the function is calculated.
More than one asset can be depreciated.
Financial functions never return a value; rather, they calculate a series
of values internally based on the range specified.
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