Description Returns the depreciation of an asset for a specified period using the sum-of-years method. This depreciation method uses an accelerated rate, where the greatest depreciation occurs early in the useful life of the asset.
Syntax SYD ( cost, salvage, life, period )
| Argument | Description |
|---|---|
| cost | The initial cost of the asset. |
| salvage | The salvage value of the asset. |
| life | The number of periods in the useful life of the asset. |
| period | The period for which to calculate the depreciation. The time units used to determine period and life must match. |
Example This function returns 1607.14:
