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
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?
I don't know where you can find the documentation for this function, but the syntax is:
=DB(cost, salvage, life, period, [month])
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.