Description Returns the depreciation of an asset for a specific period of time using the double-declining balance method or a declining balance factor you supply.
Syntax DDB ( cost, salvage, life, period [, factor] )
| Argument | Description |
|---|---|
| cost | The initial cost of the asset. |
| salvage | The salvage value of the asset. |
| life | The number of periods in the useful life of the asset. |
| period | The period for which to calculate the depreciation. The time units used to determine period and life must match. |
| [factor] | Optional. The rate at which the balance declines. Of this argument is omitted, a default factor of 2 (the double-declining balance factor) is used. |
Remarks The double-declining balance method uses an accelerated rate where the highest depreciation occurs in the first period, decreasing in successive periods.
All arguments for this function must be positive numbers.
Example This function returns 1457.73:
