ClassMicrosoft.VisualBasic.Financial SyntaxDDB(cost, salvage, life, period[, factor])
DescriptionThe DDB function returns a Double representing the depreciation of an asset for a specific time period. This is done using the double-declining balance method or another method that you specify using the factor argument. The double-declining balance method calculates depreciation at a differential rate, which varies inversely with the age of the asset. Depreciation is highest at the beginning of an asset's life and declines over time. Usage at a Glance
ExampleDim initialCost As Double = 2000 Dim salvageValue As Double = 50 Dim usefulLife As Double = 12 Dim totalDepreciation As Double = 0 Dim periodScan As Double Dim thisPeriodDepr As Double For periodScan = 1 To 12 thisPeriodDepr = DDB(initialCost, salvageValue, _ usefulLife, periodScan) totalDepreciation += thisPeriodDepr Console.WriteLine("Month " & periodScan & ": " & _ thisPeriodDepr) Next periodScan Console.WriteLine("Total: " & totalDepreciation) |