SYD

---

Name

Sum-of-years' digits depreciation

Description

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:

See also DB, DDB, and SLN.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

SYD(R1C2,1000,10,1)
SYD(100000,10000,5,2)=24000