SYD
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: