The DDB function calculates double-declining depreciation for a specified period in the life of an asset that was purchased at cost and that has an estimated salvage value.
This function has the following syntax:
DDB(cost = value, salvage = value, life = value, period = value)
Argument
Data Type
Description
cost
Float
Original cost of the asset
salvage
Float
Asset salvage value at end of life
life
Integer
Life of asset (number of periods)
period
Integer
Depreciation period
This function returns:
• Float—Double-declining balance depreciation for specified period