# DDB

### Definition of DDB

Calculates the depreciation of an asset for a specified period using the double-declining balance method.

### Sample Usage

`DDB(100,50,10,2)`

`DDB(A2,A3,A4,A5,2.25)`

### Syntax

`DDB(cost, salvage, life, period, [factor])`

• `cost` - The initial cost of the asset.

• `salvage` - The value of the asset at the end of depreciation.

• `life` - The number of periods over which the asset is depreciated.

• `period` - The single period within `life` for which to calculate depreciation.

• `factor` - [ OPTIONAL - `2` by default ] - The factor by which depreciation decreases.

### Notes

• `life` and `period` must be measured int he same units.

• While `DDB` calculates double-declining depreciation by default, use of `factor` allows specification of other methods.

`SYD`: Calculates the depreciation of an asset for a specified period using the sum of years digits method.

`SLN`: Calculates the depreciation of an asset for one period using the straight-line method.

`DB`: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. ### Then type in the DDB Formula in the area you would like to display the outcome: ### Type in the complete DDB formula for a cell as shown below: ### Excellentable will generate the outcome when hitting enter. ### Need Help?

Can't find the answer you're looking for? Don't worry we're here to help