Fdb()

Description:

The function 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.

Parameters:

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 has 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)

103799.11308935669