MS Excel: Db Function
In Excel, the Db function returns the depreciation of an asset for a given time period based on the fixed-declining balance method.
The syntax for the Db function is:
Db( cost, salvage, life, period, number_months )
cost is the original cost of the asset.
salvage is the salvage value after the asset has been fully depreciated.
life is the useful life of the asset or the number of periods that you will be depreciating the asset.
period is the period that you wish to calculate the depreciation for. Use the same units as for the life.
number_months is optional. It is the number of months in the first year of depreciation. If this parameter is omitted, the Db function will assume that there are 12 months in the first year.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at a few examples:
This first example returns the depreciation for an asset that costs $10,000, with a salvage value of $5,000. The useful life of the asset is 5 years. The depreciation is being calculated for the first year, and there are 12 months in the first year.
=Db(10000, 5000, 5, 1, 12)
This next example returns the depreciation for an asset that costs $10,000, with a salvage value of $5,000. The useful life of the asset is 5 years. The depreciation is being calculated for the second year, and there are 12 months in the first year.
=Db(10000, 5000, 5, 2, 12)
This next example returns the depreciation for an asset that costs $10,000, with a salvage value of $5,000. The useful life of the asset is 5 years. The depreciation is being calculated for the third year, and there are 10 months in the first year.
=Db(10000, 5000, 5, 3, 10)