• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Fvdb()

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.