DDB Function
Calculate the depreciation of an asset
Description
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.
Syntax
DDB (Cost, Salvage, Life, Period)
DDB (Cost, Salvage, Life, Period, Factor)
Required Parameter
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.
Optionaler Parameter
Factor
The rate at which the balance declines. If omitted, 2 (double-declining method) is assumed.
Examples
