DDB(cost, salvage, life, period [,factor])
Returns the depreciation of an asset over a period of time (Double).
|cost||The initial cost of the asset (Double).|
|salvage||The value at the end of its useful life (Double).|
|life||The length of useful life of the asset (Double).|
|period||The period you want to calculate the depreciation over (Double).|
|factor||(Optional) The rate at which the balance declines (Integer).|
|* The "cost", "salvage", "life, "period" and "factor" must all be positive numbers.|
* The "life" and "period" arguments must be expressed in the same units (days, months, years).
* If "factor" = 1, then ??
* If "factor" = 2, then the double declining balance method is used.
* If "factor" is left blank, then 2 is used.
* The double declining balance method computes depreciation at an accelerated rate. Depreciation is highest in the first period and decreases in successive periods.
* The equivalent Excel function is Application.WorksheetFunction.DDB
* The equivalent .NET function is Microsoft.VisualBasic.Financial.DDB
* For the Microsoft documentation refer to docs.microsoft.com
DDB(10000,500,24,12) = 319.9960
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top