DDB (OriginalCost, SalvageValue, Lifetime, Year, Factor?) DDB (OriginalCost; SalvageValue; Lifetime; Year; Factor?)

OriginalCost

Number Number

The initial cost of the asset.

SalvageValue

Number Number

The value at the end of the depreciation (sometimes called the salvage value of the asset).

Lifetime

Number Number

The number of years over which the asset is being depreciated.

Year

Number Number

The year number for which the depreciation is calculated.

Factor

Number Number (optional)

The depreciation rate factor. If omitted, it is assumed to be 2.

Returns

Number Number

The depreciation of an asset.

Returns the depreciation of an asset for a given year using the double declining-balance method (or any other factor).

Examples

DDB (15000, 2000, 6, 1)
DDB (15000; 2000; 6; 1)

Returns $5,000. The rate is 2/6, or roughly 33.33%. The book value at the start of year one is $15,000, and 33.33% of $15,000 is $5,000.

DDB (15000, 2000, 6, 2)
DDB (15000; 2000; 6; 2)

Returns roughly $3,333.33. The book value at the start of year two is $15,000 - $5,000 = $10,000, and 33.33% of $10,000 is roughly $3,333.33.

DDB (15000, 2000, 6, 3)
DDB (15000; 2000; 6; 3)

Returns roughly $2,222.22. The book value at the start of year three is $10,000 - $3,333.33 = $6,666.67, and 33.33% of $6,666.67 is roughly $2,222.22.

DDB (15000, 2000, 6, 4)
DDB (15000; 2000; 6; 4)

Returns roughly $1,481.48. The book value at the start of year four is $6,666.67 - $2,222.22 = $4,444.44, and 33.33% of $4,444.44 is roughly $1,481.48.

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell