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.