Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / VDB
In This Topic
    VDB
    In This Topic

    This function 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)

    Arguments

    This function has these 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

    Remarks

    If factor is omitted, the calculation uses two, which represents the double‑declining balance method. For other methods, use a different value. For more information about the double‑declining balance method, see DDB.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    VDBD(B1,1000,10,1,8)

    VDB(50000,500,1200,100,1000,1) gives the result $37,122.94

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    DB | DDB | SLN | SYD | Financial Functions