DB()
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.
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.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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
