SYD

Updated 2023-10-09 13:02:08.590000

Syntax

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

Description

Use the scalar function SYD to calculate the sum-of-years' digits depreciation of an asset for a specified 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

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.

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

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

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