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

### Excellentable will generate the outcome when hitting enter.

A
B
C
1
State
 Population
Cost
Salvage
Life
2
Alabama
4833722
5000
3
735132
10000
4
Arizona
6626624
20000
5
Arkansas
2959373
30000
6
California
38332521
5000
7
5268367
10000
8
Connecticut
3596080
20000
9
Delaware
925749
30000
10
Florida
19552860
40000
11
Georgia
9992167
50000
12
Hawaii
1404054
60000
13
Idaho
1612136
70000
14
15
D
E
F
1
Period
2
5000
5
7
3
5000
5
1
4
5000
5
9
5
5000
5
4
6
5000
5
3
7
5000
5
7
8
5000
5
5
9
5000
5
1
10
5000
5
6
11
5000
5
14
12
5000
5
2
13
5000
5
2
14
15
4000

JavaScript errors detected