|
<< Click to Display Table of Contents >> SYD (sum-of-years’ digits depreciation) |
Syntax:
SYD(Cost, Salvage, Life, Per)
Description:
This returns the depreciation of an asset for the specified period, using the sum-of-years' digits method.
The function expects the following arguments:
Cost = Initial cost of asset
Salvage = Salvage value (value at the end of the depreciation)
Life = Life of asset (in number of periods)
Per = Period to evaluate (in the same time unit as Life)
Note:
This function is only partially applicable to the tax law of some countries (for example, Germany)!
Example:
In the case of a machine purchased for €200,000 that is used for 10 years and then has a salvage value of €10,000, the following annual depreciation amount must be applied for the first year:
SYD(200000, 10000, 10, 1) returns €34,545.45 (depreciation in year 1)
See also: