Login     Register

        Contact Us     Search

XLeratorDB/financial Documentation

SQL Server SLN function


SLN
 
Updated: 5 August 2010
Use SLN to calculate the straight-line depreciation of an asset for one period.
 
Syntax
SELECT [westclintech].[wct].[SLN] (
   <@Cost, float,>
 ,<@Salvage, float,>
 ,<@Life, 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
the number of periods over which the asset it to be depreciated. @Life is an expression of type float or of a type that can be implicitly converted to float.
Return Type
float
Remarks
·         This method of depreciation distributes costs evenly over the life of an asset
Examples
 
SELECT wct.SLN(600000
,25000
,40)
Here is the result set
----------------------

14375



Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service