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.

See Also

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.

In order to use the DDB formula, start with your edited Excellentable

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. 

	A	B	C
1	State	Population	Cost	Salvage	Life
2	Alabama	4833722	5000
3	Alaska	735132	10000
4	Arizona	6626624	20000
5	Arkansas	2959373	30000
6	California	38332521	5000
7	Colorado	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

5000

5

7

5000

5

1

5000

5

9

5000

5

4

5000

5

3

5000

5

7

5000

5

5

5000

5

1

5000

5

6

5000

5

14

5000

5

2

5000

5

2