VDB

VDB(arg1, arg2, arg3, arg4, arg5, arg6, arg7) → { number | string | boolean }

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.

Parameters:

Name Type Description
arg1 number

Is the initial cost of the asset.

arg2 number

Is the salvage value at the end of the life of the asset.

arg3 number

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

arg4 number

Is the starting period for which you want to calculate the depreciation, in the same units as Life.

arg5 number

Is the ending period for which you want to calculate the depreciation, in the same units as Life.

arg6 number

Is the rate at which the balance declines, 2 (double-declining balance) if omitted.

arg7 boolean

Switch to straight-line depreciation when depreciation is greater than the declining balance = FALSE or omitted; do not switch = TRUE.

Returns:

Type
number | string | boolean