Essbase @SLN

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    0

See Also

  • @DECLINE
  • @SYD