The initial cost of the asset.
The value at the end of the depreciation (sometimes
called the salvage value of the asset). This value can be 0.
The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
The period for which you want to calculate the
depreciation. Period must use the same units as life.
Optionalfactor: number = 2The rate at which the balance declines. If
factor is omitted, it is assumed to be 2 (the double-declining balance
method).
the depreciation
Calculates the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
Remarks:
Min( (cost - total depreciation from prior periods) * (factor/life), (cost - salvage - total depreciation from prior periods) )factorif you do not want to use the double-declining balance method.