Version

UltraCalcFunctionSYD Class

Calculates depreciation of an asset using the sum of years' digits (SYD) calculation method.
Syntax
'Declaration
 
Public Class UltraCalcFunctionSYD 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionSYD : BuiltInFunctionBase 
Remarks

SYD(assetCost, salvageValue, lifespan, periodNumber)

AssetCost is the initial value of the asset when it was purchased new. This numeric value needs to be greater than the salvageValue (otherwise the asset would be appreciating in value).

SalvageValue is the market price you can get for an asset at the end of it's useful life (lifespan periods). In some situations, this may represent the value of the asset's spare parts.

Lifespan is the useful life of the asset being depreciated measured in fixed-length time periods (usually years). The appropriate lifespan to use may vary with the kind of asset being depreciated. As the name of this function suggests, the lifespan when using this depreciation method is normally measured in years (although this does not necessarily have to be the case).

PeriodNumber is the one-based number of the period to calculate the depreciation of the asset for, having a value of between 1 and lifespan. It must be measured in the same units of time as the lifespan.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also