Fddb()

Description:

The function equals the Excel DDB function.

Syntax:

Fddb(cost,salvage,life,period,factor)

Note:

The function calculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-defined method. Parameters should all be positive numbers.

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)

factor

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

Example:

Fddb(100000,10000,3650,1)

54.794520547945204