DDB

Definition: DDB is a function that returns the depreciation of an asset for a specified period using the double-declining balance method.

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

Situation: This formula is suitable when you need to calculate the depreciation of an asset using the double-declining balance method.

Example: If you have an asset with a cost of $100,000, a salvage value of $10,000, a useful life of 10 years, and want to calculate the depreciation for the first year, the formula =DDB(100000, 10000, 10, 1) can be used.