DB (OriginalCost, SalvageValue, Lifetime, Year, MonthsInFirstYear?) DB (OriginalCost; SalvageValue; Lifetime; Year; MonthsInFirstYear?)
OriginalCost
Number Number
The initial cost of the asset.
SalvageValue
Number Number
The value at the end of the depreciation (sometimes called the salvage value of the asset).
Lifetime
Number Number
The number of years over which the asset is being depreciated.
Year
Number Number
The year number for which the depreciation is calculated.
MonthsInFirstYear
Number Number (optional)
The number of months in the first year. If omitted, it is assumed to be 12.
Returns
Number Number
The depreciation of an asset.
Returns the depreciation of an asset for a given year using the fixed-rate declining-balance method.
Example
DB (8000, 500, 6, 1)
DB (8000; 500; 6; 1)
Returns $2,960, which is the depreciation in the first year for an asset which cost $8,000 and is written down to $500 over six years.