SYD ( cost , salvage , life , per )
Description: Computes the sum-of-years' digits depreciation of an asset for a specified period.
Mathematical Formula:
Arguments:
|
Name |
Type |
Description |
|
cost |
number |
The initial cost of the asset. |
|
salvage |
number |
The value at the end of the depreciation. (This is sometimes called the salvage value of the asset.) |
|
life |
number |
The number of periods over which the asset is being depreciated. (This is sometimes called the useful life of the asset.) |
|
per |
number |
The period and shall have the same units as life. |
Return Type and Value: number – The sum-of-years' digits depreciation of an asset for a specified period.
[Example:
SYD(30000,7500,10,1) results in 4,090.91
SYD(30000,7500,10,10) results in 409.09
end example]