Double-declining balance (asset depreciation)

Returns the depreciation of an asset for a specified period, using the double-declining-balance method. Double declining balance is a method of accelerated depreciation that is twice as fast as the straight line depreciation method.

Syntax

Ddb <Factor> (Cost, Salvage, Life, Period)

Where:

Cost is the initial cost.

Salvage is the cost at the end of depreciation.

Life is the number of periods over which depreciation occurs.

Period is the period for which depreciation is calculated.

Factor is the rate at which the balance declines.

Expression

Usage Notes

All arguments must be positive values.

The double-declining balance method computes depreciation at an accelerated rate: depreciation is highest during the first period and decreases with each succeeding period.