SYD function

SYD(OriginalCost, SalvageValue, Lifetime, Year) SYD(OriginalCost; SalvageValue; Lifetime; Year)

OriginalCost

Number or { Number }

The initial cost of the asset.

SalvageValue

Number or { Number }

The value at the end of the depreciation (sometimes called the salvage value of the asset).

Lifetime

Number or { Number }

The number of years over which the asset is being depreciated.

Year

Number or { Number }

The year number for which the depreciation is calculated.

Returns

Number or { Number }

The depreciation of an asset.

Returns the depreciation of an asset for a given year using the sum of the years' digits method.

Example

SYD(10000, 2000, 4, 1)SYD(10000; 2000; 4; 1)

Returns $3,200, which is the depreciation in the first year for an asset which cost $10,000 and is written down to $2,000 over four years. The total loss of value is $8,000 — $3,200 is 4/10ths of $8,000.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.