DDB

See also A-Z Spreadsheet Function List

Description Returns the depreciation of an asset for a specific period of time using the double-declining balance method or a declining balance factor you supply.

Syntax DDB(cost, salvage, life, period [, factor])

cost is the initial cost of the asset.

salvage is the salvage value of the asset.

life is the number of periods in the useful life of the asset.

period is the period for which to calculate the depreciation. The time units used to determine period and life must match.

factor is the rate at which the balance declines. Omitting this argument assumes a default factor of 2, the double-declining balance factor.

Remarks The double-declining balance method uses an accelerated rate where the highest depreciation occurs in the first period, decreasing in successive periods.

         All arguments for this function must be positive numbers.

See Also DB , SLN , SYD , and VDB functions

Example DDB(10000,1000, 7, 3) returns 1457.73