Returns the sum-of-years'-digits depreciation of an asset for the specified period.

Syntax  Copy Code
SYD( Number cost, Number salvage, Number life, Number period ) → Currency

Parameters

cost

Required. The initial cost of the asset.

salvage

Required. The value at the end of the depreciation (also known as the salvage value).

life

Required. The number of periods over which the asset is being depreciated.

period

Required. The period; it must use the same units as life.

Remarks

SYD is calculated as follows: SYD = (cost - salvage) * (life - per + 1) * 2 / (life * (life + 1)).

If life is zero, the function returns the #DIV/0! error value. If life is less than zero or period is greater than life, the return is #NUM!.

Example

Formula  Copy Code
=SYD(10000,1500,10,1)

See Also

Function Reference
DDB Function
SLN Function