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.