VDB

Definition: The VDB function in Excel is used to calculate the depreciation of an asset for a specific period using the variable declining balance method.

Syntax: ==VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]).

Situation: This formula is appropriate in situations where you need to calculate the depreciation of an asset for a specific period using the variable declining balance method.

Example: If you have an asset that cost $100,000, has a salvage value of $10,000, has a useful life of 5 years, and you want to calculate the depreciation for the third year using a factor of 1.5, you would use the formula =VDB(100000, 10000, 5, 1, 3, 1.5). This would return a value of $39,000, which is the depreciation for the third year.