VDB

See also A-Z Spreadsheet Function List

Description Returns the depreciation of an asset for a specified period using a variable method of depreciation.

Syntax VDB(cost, salvage, life, start_period, end_period [, factor] [, method])

cost is the initial cost of the asset.

salvage is the salvage value of the asset.

life is the number of periods in the useful life of the asset.

start_period is the beginning period for which to calculate the depreciation. The time units used to determine start_period and life must match.

end_period is the ending period for which to calculate the depreciation. The time units used to determine end_period and life must match.

factor is the rate at which the balance declines. Omitting this argument assumes a default of 2, which is the double-declining balance factor.

method is a logical value that determines if you want to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. Use True to maintain declining balance calculation; use False or omit the argument to switch to straight-line depreciation calculation.

See Also DDB , SLN , and SYD functions

Examples VDB(10000, 1000, 7, 3, 4) returns 1041.23