Spread Formula Reference
SYD
Formula Functions > Functions R to S > SYD

This function returns the sum-of-years’ digits depreciation of an asset for a specified period.

Syntax

SYD(cost,salvage,life,period)

Arguments

This function has these arguments:

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
period Period for depreciation; must use the same units as the life argument.

Remarks

This function calculates the digits depreciation as follows:

SYD Equation

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SYD(B1,1000,10,1)

SYD(R1C2,1000,10,1)

SYD(100000,10000,5,2) gives the result $2,4000

Version Available

This function is available in product version 1.0 or later.

See Also

DB | DDB | SLN | Financial Functions