Financial Toolbox

depgendb

General declining-balance depreciation schedule

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)
  

returns

• Depreciation =
         4400.00     2640.00     1584.00     950.40     425.60
  

See Also

depfixdb, deprdv, depsoyd, depstln

depfixdb

deprdv