DB

Returns the depreciation of an investment using the fixed-declining balance method for the specified period. The 'life' and 'period' arguments must use the same units of measure.

Syntax

DB(cost,salvage,life,period,{months})

Arguments

cost	The initial cost to depreciate. Must be a positive number.
salvage	The value of the item at the end of the depreciation period. Must be a positive number.
life	The number of periods in the depreciation cycle. Must be a positive number.
period	The period of time to compute the depreciation. Must be a positive number.
months	The number of months in the first year of depreciation. If omitted, 12 months is used. Must be a positive number.

Example

DB(10000,1000,5,1) is $3,690.

A $10,000 investment depreciates $3,690 in the first year if it is depreciated over 5 years with a final salvage value of $1,000.