SLN

Updated 2023-10-09 13:01:31.363000

Syntax

SELECT [westclintech].[wct].[SLN] (
   <@Cost, float,>
 ,<@Salvage, float,>
 ,<@Life, float,>)

Description

Use the scalar function SLN to calculate the straight-line depreciation of an asset for one period.

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.

@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.

@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.

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.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"14375"}]}