VDB function

The VDB function in Excel is used to calculate the depreciation of an asset for a specified period using the variable declining balance method. This method is an accelerated depreciation approach, where more depreciation is recognized in the earlier years of the asset’s life, and it gradually decreases over time.

The VDB function allows you to specify a start and end period for depreciation and provides flexibility in how depreciation is calculated over time.

Syntax

VDB(cost, salvage, start_period, end_period, factor, no_switch)

Parameters

1. cost: The initial cost (or purchase price) of the asset.
2. salvage: The salvage value of the asset, which is the estimated residual value at the end of the asset’s useful life.
3. start_period: The period at which the depreciation calculation begins. This can be an integer representing the period number.
4. end_period: The period at which the depreciation calculation ends. This also should be an integer representing the period number.
5. factor (optional): The rate at which the asset will depreciate. The default value is 2, which is the standard for double-declining balance depreciation. A factor greater than 1.0 applies more rapid depreciation, while a factor less than 1.0 applies slower depreciation.
6. no_switch (optional): A logical value (TRUE or FALSE) that determines whether to apply the switching of depreciation methods (from double declining to straight-line) when the asset’s depreciation reaches its salvage value. If omitted or set to FALSE, Excel will automatically switch methods at the optimal time. If set to TRUE, the method is not switched.

How It Works

The VDB function calculates the depreciation for a specific period based on the variable declining balance method, which means that the depreciation decreases over time. It considers the cost of the asset, its salvage value, the number of periods, and the depreciation factor.

The calculation follows this formula for each period:

$$\text{Depreciation for a period} = \text{Cost} \times \left( \frac{\text{Factor}}{1} \right) \times \left( \frac{\text{Remaining value at the beginning of the period}}{\text{Total asset value}} \right)$$

Example

Suppose you have the following details for an asset:

• Cost: $10,000
• Salvage value: $1,000
• Depreciation starts in period 1 and ends in period 5
• Depreciation factor: 2 (double-declining balance method)
• No switch of depreciation methods (set to TRUE)

The formula to calculate the depreciation for periods 1 to 5 would be:

=VDB(10000, 1000, 1, 5, 2, TRUE)

This would calculate the total depreciation for the asset over the 5 periods, with the depreciation factor set to 2 (double-declining balance method).

Important Notes

• The VDB function calculates depreciation for a set period, so it’s especially useful for calculating partial-year depreciation.
• The factor parameter controls the speed of depreciation: a value of 2 is typically used for double-declining balance, but you can change it if needed.
• The no_switch parameter determines whether the function will switch from the accelerated depreciation method to straight-line depreciation once the asset’s value gets close to the salvage value.

Summary

The VDB function in Excel is a depreciation function used to calculate the depreciation of an asset over a specified period using the variable declining balance method. It allows for more rapid depreciation in the earlier years and gradually slows down over time, depending on the factor and period values you provide.