Version

UltraCalcFunctionDDB Class

Calculates an asset's depreciation using the double declining balance (DDB) or another weighted factor method over a specified term.
Syntax
'Declaration
 
Public Class UltraCalcFunctionDDB 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionDDB : BuiltInFunctionBase 
Remarks

DDB(assetCost, salvageValue, lifespan, period, weight)

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.

Weight allows you to fine tune the calculation method. By default, the double declining balance method uses a factor of 2.

For some assets, alternative calculation methods such as the DB() function may be more appropriate. Your accountant can advise you for which assets the double declining balance method is an acceptable means of calculating depreciation, and what factors can be used when depreciating certain assets such as high-tech equipment or motor vehicles which exhibit accelerated depreciation in their first years of use.

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