Returns the depreciation of an asset for any given period using the double-declining balance method or some other method you specify.
الصيغة
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])المعاملات
costمطلوب
The initial cost of the asset.
salvageمطلوب
The value at the end of the depreciation (sometimes called the salvage value of the asset).
lifeمطلوب
The number of periods over which the asset is being depreciated.
start_periodمطلوب
The starting period for which you want to calculate the depreciation.
end_periodمطلوب
The ending period for which you want to calculate the depreciation.
factorاختياري
The rate at which the balance declines (defaults to 2 for double-declining).
no_switchاختياري
A logical value specifying whether to switch to straight-line depreciation when it is greater than declining balance.
The VDB function calculates depreciation using a variable declining balance method. It is particularly useful when you need to calculate depreciation for a partial period or when you want to switch to straight-line depreciation automatically.
=VDB(10000, 1000, 10, 0, 1)→2000Calculates the depreciation for the first year of an asset costing 10,000 with a 1,000 salvage value over 10 years.
Identify asset parameters
Gather the cost, salvage value, and total life of the asset.
Define the period
Specify the start and end periods for the calculation range.
Apply the VDB function
Enter the formula into a cell using the identified parameters.
The default value is 2, which represents the double-declining balance method.