DB function
DB(OriginalCost,
SalvageValue, Lifetime, Year, MonthsInFirstYear?)
DB(OriginalCost;
SalvageValue; Lifetime; Year; MonthsInFirstYear?)
OriginalCost
Number or { Number }
The initial cost of the asset.
SalvageValue
Number or { Number }
The value at the end of the depreciation (sometimes called the salvage value of the asset).
Lifetime
Number or { Number }
The number of years over which the asset is being depreciated.
Year
Number or { Number }
The year number for which the depreciation is calculated.
MonthsInFirstYear
Number or { Number } (optional)
The number of months in the first year. If omitted, it is assumed to be 12.
Returns
Number or { 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(10000, 1000, 5,
1)DB(10000; 1000; 5;
1)
Returns $3,690, which is the depreciation in the first year for an asset which cost $1,0000 and is written down to $1,000 over five years.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.