Fvdb()

Description:

The function equals the Excel VDB function.

Syntax:

Fvdb(cost,salvage,life,start_period,end_period,factor)

Note:

The function calculates the depreciation of an asset for a specfied period, using variable declining balance method, or double-declining balance method or another user-defined method.

Parameters:

cost

The initial cost of the asset

salvage

The value of the asset at the end of the depreciation (also known as asset residual value)

life

The number of periods over which the asset is to be depreciated (sometimes called expected useful life of the asset)

start_period

The starting period for which you want to calculate the depreciation. It must use the same unit as life.

end_period

The ending period for which you want to calculate the depreciation. It must use the same unit as life.

factor

The rate of depreciation. If omitted, it takes on the default value of 2, specifying the double-declining balance method

Options:

@s

Do not switch to the straight-line depreciation method when depreciation is greater than the declining balance calculation

Example:

Fvdb(100000, 10000,10, 0,1)

20000.0

Fvdb@s(100000, 10000,120, 6,18,1.5)

12992.03902742642