Spread 8.0 Documentation
VDB
Support Options
Formula Reference > Built-In Functions > VDB

Glossary Item Box

VDB


Name

Variable depreciation

Description

Returns the depreciation of an asset for any period you specify using the variable declining balance method.

Syntax

VDB(cost,salvage,life,start,end,factor,switchnot )

Remarks

This function has the following arguments:

Argument Description
cost Initial cost of the asset
salvage Value at the end of the depreciation period
life Number of periods over which the asset is being depreciated
start Number representing the starting period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated
end Number representing the ending period for which to calculate the depreciation in the same units as life; if not an integer, the number is truncated
factor [Optional] Rate at which the balance declines; if omitted, uses two (2)
switchnot [Optional] Logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation; if omitted uses FALSE

If factor is omitted, the calculation uses two, which represents the double-declining balance method. For other methods, use a different value.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

VDB(B1,100,10,1,8)
VDB(50000,500,1200,100,1000,1)=37122.94

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.