# DB

### Definition

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

### Syntax

`DB(cost, salvage, life, period, [month])`

• `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.

• `month` - [ OPTIONAL - `12` by default ] - The number of months in the first year of depreciation.

### Notes

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

`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.

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

### By adding the values you would like to calculate, Excellentable generates the outcome:

A
B
C
1
Product
Product one
Product two
2
Initial Cost
\$500,000.00
\$400,000.00
3
Salvage Value
\$25,000.00
\$40,000.00
4
5
5
5
Depreciation
6
Year 1
\$225,500.00
\$147,600.00
7
Year 2
\$123,799.50
8
Year 3
\$67,965.93
9
Year 4
\$37,313.29
10
Year 5
\$20,485.00
D
1
Product three
2
\$600,000.00
3
\$30,000.00
4
5
5
6
\$270,600.00
7
8
9
10

JavaScript errors detected