Syntax. DB(Purchase_Value,Residual_Value,Life,Period,Months)

Definition. This function calculates the depreciation amounts for an asset by using the geometric-degressive depreciation method, where part of a year (in complete months) is considered in the first depreciation period.


  • Purchase_Value (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 value that can be evaluated as a number, the #VALUE! error is displayed. If the entered number is negative, the #NUMBER! error is displayed.

  • Salvage_Value (required) 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 ...

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.