Financial Toolbox

depgendb

Syntax

Depreciation = depgendb(Cost, Salvage, Life, Factor)

Arguments

Cost	Cost of the asset.
Salvage	Estimated salvage value of the asset.
Life	Number of periods over which the asset is depreciated.
Factor	Depreciation factor. Factor = 2 uses the double-declining-balance method.

Description
Depreciation = depgendb(Cost, Salvage, Life, Factor) calculates the declining-balance depreciation for each period.

Examples
A car is purchased for $11,000 and is to be depreciated over five years. The estimated salvage value is $1000. Using the double-declining-balance method, the function calculates the depreciation for each year and returns the remaining depreciable value at the end of the life of the car.

Depreciation = depgendb(11000, 1000, 5, 2)

Depreciation =
       4400.00     2640.00     1584.00     950.40     425.60

See Also
depfixdb, deprdv, depsoyd, depstln

depfixdb

deprdv