Calculates the periodic amount that an asset in the current period may be depreciated, calculated across a range of periods. The depreciation method used is straight-line depreciation:
cost - salvage value / life
The SLN method assumes that the asset depreciates by the same amount each period.
More than one asset may be depreciated over the range. The value is depreciated from its entry period to the last period in the range. The resulting value represents the sum of all the per-period depreciation values of each asset being depreciated.
Syntax
@SLN (costMbr, salvageMbrConst, lifeMbrConst [, rangeList])
| Parameter | Description |
|---|---|
costMbr | Single member specification representing an input asset for the current period. |
salvageMbrConst | Single member specification, variable name, or numeric expression, providing a constant numeric value. This value represents the value of the asset in the current period at the end of the useful life of the asset. |
lifeMbrConst | Single member specification, variable name, or numeric expression representing the useful life of 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. rangeList represents the range over which the function accepts input and returns depreciation values. If rangeList is not specified, Essbase uses the level 0 members from the dimension tagged as Time. |
Notes
Financial functions never return a value; rather, they calculate a series of values internally based on the range specified.
Example
In this example, the depreciation for each year is calculated by taking into account the initial asset (Asset), the salvage value of the asset (Residual), and the life of the asset (Life).
"SLN Dep" = @SLN(Asset,Residual,Life,FY1991:FY1995);
This example produces the following report:
FY1991 FY1992 FY1993 FY1994 FY1995 FY1996
====== ====== ====== ====== ====== ======
Asset 9,000 0 1,000 0 0 0
Residual 750.00 0.00 0.00 0.00 0 0
Life 5.00 #MI 5.00 0.00 0.00 0
SLN Dep 1650 1650 1850 1850 1850 0See Also