Version

UltraCalcFunctionDB Class

Calculates an asset's depreciation using the fixed declining balance (DB) method over a specified term.
Syntax
'Declaration
 
Public Class UltraCalcFunctionDB 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionDB : BuiltInFunctionBase 
Remarks

DB(assetCost, salvageValue, lifespan, period, months)

AssetCost is the original cost or purchase price of the asset at the start of the calculation.

SalvageValue is the market value of the asset after it's expected useful life ends, sometimes this will be the value of the asset as spare parts.

Lifespan indicates for how many periods the asset is useful (it's useful life), and must be depreciated. Accounting standards vary on what lifespan is appropriate for different classes of assets, such as durable and non-durable goods.

Period indicates the number of units of time between decremental calculations of the depreciation. If lifespan is measured in years, then the value specified for the period must also be in years.

Months allows you to specify the number of months in the first year, if the depreciation does not begin on the first day of the year. You might specify months based on when the asset was purchased new. If omitted, the calculation defaults to 12 which is equivalent to calculating starting from the first day of the year.

For some assets, alternative calculation methods such as the DDB() function may be more appropriate. Your accountant can tell you for which assets the fixed declining balance method is an acceptable means of calculating depreciation.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also