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.