Calculate the depreciation of an asset
The function DDB calculates a value specifying the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify.
DDB (Cost, Salvage, Life, Period)
DDB (Cost, Salvage, Life, Period, Factor)
Cost
The initial cost of the asset.
Salvage
The value of the asset at the end of its useful life.
Life
The length of useful life of the asset.
Period
The period for which asset depreciation is calculated.
New from version 7.10:
If a zero is specified as Period, the result is a list containing the values of all periods.
Factor
The rate at which the balance declines. If omitted, 2 (double-declining method) is assumed.