Calculates the depreciation of an asset for a specified period using the double-declining balance method.
DDB(cost, salvage, life, period, [factor])
cost- The initial cost of the asset.
salvage- The value of the asset at the end of depreciation.
life- The number of periods over which the asset is depreciated.
period- The single period within
lifefor which to calculate depreciation.
factor- [ OPTIONAL -
2by default ] - The factor by which depreciation decreases.
periodmust be measured in the same units.
DDBcalculates double-declining depreciation by default, use of
factorallows specification of other methods.
SYD: Calculates the depreciation of an asset for a specified period using the sum of years digits method.
SLN: Calculates the depreciation of an asset for one period using the straight-line method.
DB: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.