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.