Login     Register

        Contact Us     Search

XLeratorDB/financial Documentation

SQL Server SYD function


SYD
 
Updated: 5 August 2010
Use SYD to calculate the sum-of-years' digits depreciation of an asset for a specified period
Syntax
SELECT [westclintech].[wct].[SYD] (
   <@Cost, float,>
 ,<@Salvage, float,>
 ,<@Life, float,>
 ,<@Per, float,>)
Arguments
@Cost
the total acquisition cost of the asset. @Cost is an expression of type float or of a type that can be implicitly converted to float.
@Salvage
the estimated value of the asset at the end of the depreciation period. @Salvage is an expression of type float or of a type that can be implicitly converted to float.
@Life
is the number of periods over which the asset is depreciated (sometimes called the useful life of the asset). @Life is an expression of type float or of a type that can be implicitly converted to float.
 
@Per
 
the period to be calculated. @Per must use the same units as @Life. @Per is an expression of type float or of a type that can be implicitly converted to float.
Return Type
float
Remarks
·         SYD is calculated as follows:
SYD = ((@Cost-@Salvage)*(@Life-@per+1)*2)/((@Life)*(@Life+1))
·         This method accelerates the rate of depreciation, so that the depreciation is greater in the earlier periods.


 
Examples
 
SELECT wct.SYD(30000
,7500
,10
,1)
Here is the result set
----------------------

4090.90909090909



Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service