Calculate sum of years depreciation.

`=SYD(cost,salvage,life,period)`

- cost - the initial cost of the asset
- salvage - [REQUIRED] the asset's value at the end of the depreciation
- life - [REQUIRED] the number of periods over which the asset is depreciated
- period - [REQUIRED] the period to calculate depreciation for

`=SYD(10000,2000,5,1)`

The SYD function is used to calculate the sum-of-years' digits depreciation of an asset over a specified period. The function uses the following arguments: cost, salvage, life, and period. For example, this returns the depreciation of an asset with a cost of $10,000, a salvage value of $2,000, and a life of 5 years in the first period, which is $2,667.

`=SYD(cost,salvage,life,B7)`

The SYD function can also be used to calculate the depreciation of an asset in the current period. For example, this returns the depreciation for the asset in the worksheet C7. In this example, the cost, salvage, and life of the asset must be specified in the function and the current period is indicated by the cell reference B7.

`=SUM(SYD(10000,2000,5,1), SYD(10000,2000,5,2), SYD(10000,2000,5,3), SYD(10000,2000,5,4), SYD(10000,2000,5,5))`

The SYD function can be used to calculate the total depreciation of an asset over its lifetime. To do this, the function must be nested in a SUM function. For example, this formula returns the total depreciation of an asset with a cost of $10,000, a salvage value of $2,000, and a life of 5 years, which is $8,000.

The SYD function calculates the sum of years' digits depreciation for an asset. It requires four arguments: cost, salvage, life, and per, and returns the depreciation value.

- The SYD function calculates the sum of years of depreciation for an asset over a certain period, based on initial asset cost, salvage value, and the number of periods of depreciation.
- The arguments for the SYD function are cost, salvage, life, and period.

The SYD function calculates the sum of years digits depreciation for an asset.

The arguments for the SYD function are:

- Cost
- Salvage
- Life
- Per

The SYD function returns a value which is the sum of years digits depreciation of an asset.

Drop CSV