DB

Definition

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

Sample Usage

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.

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.

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

To use the DB Formula, simply begin with your edited Excellentable:

Then begin typing the DB formula in the area you would like to display the outcome:

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	Lifetime in Years	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

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.