DDB

Returns the depreciation of an investment using the variable 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,{factor})

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.
factor	The rate of balance decline.  If omitted, the system assumes 2 (double declining balance method). Must be a positive number.

Example

DDB(10000,1000,5,1,3) is $6,000.

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