Financial Toolbox | ![]() ![]() |
Syntax
Depreciation = depgendb(Cost, Salvage, Life, Factor)
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 | ![]() |