Ddb

Syntax

Ddb(Cost, Salvage, Life, Period[, Factor])

Parameters

Cost. The initial cost of the asset.

Salvage. The value at the end of the depreciation.

Life. Number of periods after which the asset is depreciated.

Period. The period, for which depreciation must be calculated. The period must be specified using the same units, as the Life parameter.

Factor. Interest rate of decreasing remainder. Optional parameter. The default value is 2.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify.

Comments

The Ddb function calculates depreciation using an increased coefficient. Depreciation is maximum in the first period, decreasing in the following periods. The Ddb function uses the following equation to calculate depreciation value over a period:

((Cost - Salvage) - total depreciation over the pas periods) * (Factor/Life).

If another method is required to calculate depreciation value, change the Factor parameter value.

Example

Formula	Result	Description
=Ddb(5000, 100, 12, 1)	833,33	Depreciation for the first period.
=Ddb(54000, 1200, 24, B6,7)	2808,46	Depreciation for the period, specified in the B6 cell. The B6 cell contains the 6 value.