DDB(arg1, arg2, arg3, arg4, arg5) → { number | string | boolean }

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


Name Type Description
arg1 number

Is the initial cost of the asset.

arg2 number

Is the salvage value at the end of the life of the asset.

arg3 number

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

arg4 number

Is the period for which you want to calculate the depreciation. Period must use the same units as Life.

arg5 number

Is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method).


number | string | boolean