@SYD

The @SYD() function calculates the amount per period that an asset in the current period may be depreciated, across a range of periods. The depreciation method used is sum of the year's digits. 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 per-period depreciation values of each asset.

Syntax

@SYD (costMbr, salvageMbrConst, lifeMbrConst [, rangeList])

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 is the value of the asset in the current period after 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, Hyperion 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).

"SYD Dep"=@SYD(Asset,Residual,Life,FY1991:FY1994,FY1995);

This example produces the following report:

          FY1991    FY1992    FY1993    FY1994    FY1995
          ======    ======    ======    ======    ======
		  
Asset     9,000         0       1,000       0          0
Residual 750.00      0.00        0.00    0.00          0
Life       5.00  #MISSING        3.00    0.00       0.00
SYD Dep    2750      2200        2150    1433        717

See Also

@DECLINE
@SLN

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 is the value of the asset in the current period after 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, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.