Description:
The external library function (See External Library Guide) 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.
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 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 |