Excel Function : DB

Download now!

Excel Function : DB




Returns the depreciation of an asset for a specified period by using the fixed-declining balance method

Microsoft Excel Reference Page


Syntax and Description of the DB Excel Function

(syntax) I am trying to find the syntax for Excel's DB function (declining balance method) but have been unable to locate it. Does anyone know where I can find the syntax? A: I don't know where you can find the documentation for this function, but the syntax is: =DB(cost, salvage, life, period, [month]) where: cost is the initial cost of the asset salvage is the value of the asset at the end of its life life is the number of

About DB Excel Function

The DB function in Excel calculates the future value of an investment using a double-declining balance method. The syntax for the DB function is as follows: DB(cost,salvage,life,period,month) where: cost: The initial cost of the asset. salvage: The value of the asset at the end of its life. life: The number of periods over which the asset will be depreciated. period: The period for which you want to calculate the depreciation. month: The number of months in the first year.