SYD

  • Updated

Returns the depreciation of an asset for a specified period using the sum of years digits method.

Sample Usage

SYD(100,50,10,2)
SYD(A2,A3,A4,1)

 

Syntax

SYD(cost, salvage, life, period)

  • cost - The initial cost of the asset.
  • salvage - The value at the end of the depreciation.
  • life - The number of periods over which the asset is depreciated.
  • period - Period for which to calculate the depreciation.

 

Examples

SYD(100,50,10,2) returns the depreciation allowance for the second year.

Notes

  • life and period must be measured in the same units.