Description Returns the real depreciation of an asset for a specific period of time using the fixed-declining balance method.
Syntax DB ( cost, salvage, life, period [, months] )
| 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. |
| [months] | Optional. The number of months in the first year of the item's life. If this argument is omitted, 12 is used. |
Example This function returns 1451.52:
DB(10000, 1000, 7, 3)
