DDB()

Syntax. DDB(Purchase_Value,Residual_Value,Life,Period, Factor)

Definition. This function calculates the depreciation amounts by using a multiple-rate depreciation method.

Arguments

  • 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.

  • Residual_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 number is negative, the #NUMBER! error is displayed.

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

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.