Returns the depreciation of an asset for any given period using the double-declining balance method or some other method you specify.
Syntaxis
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])Argumenten
costvereist
The initial cost of the asset.
salvagevereist
The value at the end of the depreciation (sometimes called the salvage value of the asset).
lifevereist
The number of periods over which the asset is being depreciated.
start_periodvereist
The starting period for which you want to calculate the depreciation.
end_periodvereist
The ending period for which you want to calculate the depreciation.
factoroptioneel
The rate at which the balance declines (defaults to 2 for double-declining).
no_switchoptioneel
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.