Documentation/Calc Functions/VDB

From The Document Foundation Wiki
Jump to: navigation, search

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:

DDB

SLN

ODF standard:

Section 6.12.50, part 2

Equivalent Excel functions:

VDB