Returns the calculated depreciation allowance on an asset at a specific period of time using the double declining balance method.
Syntax:
DDB( cost:Number, salvage:Number, life:Number, period:Number {, factor:Number} )
where:
cost | is the original value; |
salvage | is the value at the end of the life; |
life | is the number of periods for which you want to calculate the depreciation allowance; |
period | is the period for which the depreciation is being measured; |
factor | is the rate at which the balance declines. Default is 2 (two). |
Example:
What is the depreciation allowance of a £5000 asset with a salvage value of £1000 one year into its five-year depreciation?
The formula
DDB(5000, 1000, 5, 1)
returns the number 2000
(pounds).
Revisions:
Starting with 2.00, this function will accept an extra optional parameter, factor. The default factor is two.
Starting with 2.24, this function will accept a non-integer period.