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