Description:
The function equals the Excel VDB function.
Syntax:
Fvdb(cost,salvage,life,start_period,end_period,factor)
Note:
The external library function (See External Library Guide) calculates the depreciation of an asset for a specified period, using variable declining balance method, or double-declining balance method or another user-defined method.
Parameter:
|
cost |
The initial cost of the asset. |
|
salvage |
The value of the asset at the end of the depreciation (also known as asset residual value) . |
|
life |
The number of periods over which the asset is to be depreciated (sometimes called expected useful life of the asset) . |
|
start_period |
The starting period for which you want to calculate the depreciation. It must use the same unit as life. |
|
end_period |
The ending period for which you want to calculate the depreciation. It must use the same unit as life. |
|
factor |
The rate of depreciation. If omitted, it takes on the default value of 2, specifying the double-declining balance method. |
Option:
|
@s |
Do not switch to the straight-line depreciation method when depreciation is greater than the declining balance calculation. |
Example:
|
Fvdb(100000, 10000,10, 0,1) |
Calculate the depreciation in the first month, result is 20000.0. |
|
Fvdb@s(100000, 10000,120, 6,18,1.5) |
Calculate the depreciation from the 8th year to the 16th year, result is 12992.03902742642. |