DB

See also A-Z Spreadsheet Function List

Description Returns the real depreciation of an asset for a specific period of time using the fixed-declining balance method.

Syntax DB(cost, salvage, life, period [, months])

cost is the initial cost of the asset.

salvage is the salvage value of the asset.

life is the number of periods in the useful life of the asset.

period is the period for which to calculate the depreciation. The time units used to determine period and life must match.

months is the number of months in the first year of the item’s life. Omitting this argument assumes there are 12 months in the first year.

See Also DDB , SLN , SYD , and VDB functions

Example DB(10000, 1000, 7, 3) returns 1451.52