DDB
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
Syntax
DDB(cost, salvage, life, period, [factor])
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
- factor: Optional. The rate at which the balance declines (default 2, i.e. double-declining)
Example
=DDB(2400, 300, 10*365, 1, 2)