Fdb()

Description:

The external library function (See External Library Guide) equals the Excel DB function.

Syntax:

Fdb(cost,salvage,life,period,month)

Note:

The function calculates the depreciation of an asset for a specified period, using the fixed-declining balance method.

Parameter:

cost

The initial cost of the asset.

salvage

The value of the asset at the end of the depreciation (asset residual value) .

life

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

period

The period number for which you want to calculate the depreciation (it must have the same unit with life) .

month

The number of the months used in the calculation of the first year of depreciation. If omitted, it takes the value of 12 by default.

Example:

Fdb(500000,100000,3,1,6)

103750.0