DB
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
Syntax
DB(cost, salvage, life, period, [month])
Parameters
- cost: Required. The initial cost of the asset
- salvage: Required. The value at the end of the depreciation
- life: Required. The number of periods over which the asset is depreciated
- period: Required. The period for which you want to calculate the depreciation
- month: Optional. The number of months in the first year (default 12)
Example
=DB(1000000, 100000, 6, 1, 7)