DB Function Explained
The DB function in Microsoft Excel is used to calculate the depreciation of an asset for a specified period using the fixed-declining balance method. It takes three arguments: cost, salvage, and life. The cost argument is the initial cost of the asset, the salvage argument is the value of the asset at the end of its useful life, and the life argument is the number of periods over which the asset is depreciated. The function returns the depreciation amount for the specified period.
DB Function Syntax
DB(cost,salvage,life,period,month)
- cost – The initial cost of the asset
- salvage – The value of the asset at the end of its useful life
- life – The number of periods over which the asset is being depreciated
- period – The period for which you want to calculate the depreciation
- month – The number of months in the first year of the depreciation schedule