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:

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