# Documentation/Calc Functions/VDB

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

VDB

## Category:

Financial Analysis

## Summary:

Calculates the depreciation of an asset for a specified or partial period using a variable declining balance method.

## Syntax:

VDB(**Cost**; **Salvage**; **Life**; **S**; **End**[; **Factor**[; **NoSwitch**]])

## Returns:

Returns a real number (in currency units) which is the depreciation allowance of an asset with an initial value, an expected useful life, and a final value of salvage for a period specified, using the variable-rate declining balance method.

## Arguments:

**Cost** is a positive real number or a reference to the cell containing that number which is the initial cost of an asset.

**Salvage** is a real number or a reference to the cell containing that number which is the value of an asset after depreciation.

**Life** is a non-negative real number or a reference to the cell containing that number which is the period fixing the time span over which an asset is depreciated.

**S** is a non-negative real number or a reference to the cell containing that number which is the point in the asset's life when you want to begin calculating depreciation. It can be any value greater than or equal to 0, but cannot be greater than **Life**. It must be entered in the same data unit as the duration.

**End** is a non-negative real number or a reference to the cell containing that number which is the point in the asset's life when you want to begin calculating depreciation. It can be any value greater than **S**.

**Factor** is a positive real number or a reference to the cell containing that number which is the depreciation factor. Factor = 2 is double rate depreciation and is considered by default.

**NoSwitch** is a real number or a reference to the cell containing that number which you include if you do not want VDB to switch to straight-line depreciation for the remaining useful life. Normally, declining-balance switches to such a straight-line calculation when it is greater than the declining balance calculation. If **NoSwitch** is FALSE or 0 or omitted, VDB automatically switches to straight-line depreciation when that is greater than declining-balance depreciation. If **NoSwitch** is TRUE or 1, VDB never switches to straight-line depreciation.

- If either
**Cost**or**Factor**is less than or equal to 0 then the function returns an error value. - If either
**Life**or**S**or**End**is less than then the function returns an error value. - If
**S**is greater than**Life**then the function returns an error value. - If
**End**is less than**S**then the function returns an error value.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=VDB(35000;7500;36;10;20;3;1) | The function calculates the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated. Here depreciation factor is 3 and the function never switches to straight-line depreciation. | 7,161.64 (currency units) |

=VDB(35000;7500;36;10;20) | The function calculates the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated. Here depreciation factor is 2 by default and the function switches to straight-line depreciation (by default). | 8,603.80 (currency units) |

=VDB(35000;7500;36;40;20;3;1) | The function returns an error value since start period (S) is greater than life time (Life) period. |
Err:502 |

=VDB(0;7500;36;10;20;3;1) | The function returns an error value since Cost cannot be 0. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

VDB