DDB function
Summary
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
Syntax
DDB(cost, salvage, life, period, [factor])
The DDB function syntax has the following arguments:
• Cost Required. The initial cost of the asset.
• Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.
• Life Required. The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
• Period Required. The period for which you want to calculate the depreciation. Period must use the same units as life.
• Factor Optional. The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method).
Important: All five arguments must be positive numbers.
• Cost Required. The initial cost of the asset.
• Salvage Required. The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.
• Life Required. The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
• Period Required. The period for which you want to calculate the depreciation. Period must use the same units as life.
• Factor Optional. The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method).
Important: All five arguments must be positive numbers.
Example
=DDB(A2,A3,A4*365,1)
=DDB(A2,A3,A4*12,1,2)
=DDB(A2,A3,A4,1,2)
=DDB(A2,A3,A4,2,1.5)
=DDB(A2,A3,A4,10)
=DDB(A2,A3,A4*12,1,2)
=DDB(A2,A3,A4,1,2)
=DDB(A2,A3,A4,2,1.5)
=DDB(A2,A3,A4,10)