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). |
| REMARKS |
| * 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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top