SYD (Primitive Spread Function) returns the sum-of-years' digits depreciation of an asset for a specified period.

SYNTAX:

SYD(Cost,Salvage,Life,Per)

REMARKS:

Arguments are as follows:

Argument Description 
Cost Initial cost of the asset 
Salvage Value at the end of the depreciation 
Life Number of periods over which the asset is being depreciated 
Per The period for depreciation
Must use the same units as the Life argument.

The SYD function calculates the standard deviation as follows:  

                                                       

EXAMPLES:

SYD(100000,10000,5,2)=24000