DB
Determines the depreciation of asset using declining balance method
Syntax of Excel DB Formula:
=DB(cost, salvage, life,period,[month])
In words:
=Calculate depreciation with declining balance method if asset has this(cost, salvage value, useful life term, for this period, [starting this month in the first year])
Example of Excel DB formula
=DB(1000,100,5,1) will give $369
=DB(1000,100,5,1,6) will give $184.50 as only six month’s depreciation is calculated.