Returns the depreciated value of the asset for any specified period, including partial periods, using the double declining-balance method or other specified method.
The function VDB stands for variable decreasing balance method.
grammar
VDB(cost,salvage,life,start_period,end_period,factor,no_switch)
cost indicates the original asset value.
salvage is the value of the asset at the end of depreciation (also known as the salvage value of the asset).
life is the period of depreciation (sometimes called the useful life of the asset).
start_period is the beginning period for which depreciation is calculated. Start_period must be in the same unit as life.
end_period is the end period for which depreciation is calculated. End_period must be in the same unit as life.
factor is the decreasing balance rate (depreciation factor), and if the parameter factor is omitted, the function assumes that factor is 2 (double decreasing balance method).
If you do not want to use the double decreasing balance method, you can change the value of the parameter factor.
no_switch is a logical value that specifies whether to switch to the straight-line depreciation method when the depreciation value is greater than the decreasing balance calculated value.
- If no_switch is TRUE, the WPS table does not switch to the straight-line depreciation method even if the depreciation value is greater than the decreasing balance calculated value.
- If no_switch is FALSE or ignored and the depreciation value is greater than the decreasing balance calculated value, the WPS table switches to the linear depreciation method.
Note All parameters except no_switch must be positive.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/