SYD

Used only in ReliaSoft Workbooks

Description: Based on a specified period, returns the sum-of-years-digits depreciation of an asset.

Syntax: SYD(Cost, Salvage, Life, Per)

• Cost is the initial cost of the asset.
• Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset).
• Life is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
• Per is the period and must use the same units as life.

Remarks:

• SYD is calculated as follows:

Example:

If you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500, the yearly depreciation allowance for the first year is:

• SYD(30000,7500,10,1) = $4,090.91

The yearly depreciation allowance for the tenth year is:

• SYD(30000,7500,10,10) = $409.09