@SLN

The @SLN calculation function for Essbase calculates the periodic amount that an asset in the current period may be depreciated, 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 [, XrangeList])

Parameters

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.

XrangeList

Optional parameter specifying the range over which the function accepts input and returns depreciation values. 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, see Range List Parameters.

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    0

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

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