DB function
Summary
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
Syntax
DB(cost, salvage, life, period, [month])
The DB function syntax has the following arguments:
• Cost Required. The initial cost of the asset.
• Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
• Life Required. The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
• Period Required. The period for which you want to calculate the depreciation. Period must use the same units as life.
• Month Optional. The number of months in the first year. If month is omitted, it is assumed to be 12.
• Cost Required. The initial cost of the asset.
• Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset).
• Life Required. The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
• Period Required. The period for which you want to calculate the depreciation. Period must use the same units as life.
• Month Optional. The number of months in the first year. If month is omitted, it is assumed to be 12.
Example
=DB(A2,A3,A4,1,7)
=DB(A2,A3,A4,2,7)
=DB(A2,A3,A4,3,7)
=DB(A2,A3,A4,4,7)
=DB(A2,A3,A4,5,7)
=DB(A2,A3,A4,6,7)
=DB(A2,A3,A4,7,7)
=DB(A2,A3,A4,2,7)
=DB(A2,A3,A4,3,7)
=DB(A2,A3,A4,4,7)
=DB(A2,A3,A4,5,7)
=DB(A2,A3,A4,6,7)
=DB(A2,A3,A4,7,7)