SYD()

Syntax. SYD(Cost,Salvage,Life,Per)

Definition. This function determines the depreciation amounts of an asset according to the arithmetic-degressive method (also called the digital method).

Arguments

  • Cost (required) The purchase cost (net purchase price plus incidental purchase expenses minus reduction of purchase cost) of an asset. If you don’t use a number, the #VALUE! error is displayed. If the entered number is negative, the calculated values cannot be interpreted.

  • Salvage (required) Returns the value of the asset at the end of the depreciation duration. If you don’t use a number, the #VALUE! error is displayed. If the entered number is negative, the #NUMBER! error is displayed.

  • Life (required) The number of periods in which the asset is depreciated. ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.