Financial Toolbox | ![]() ![]() |
General declining-balance depreciation schedule
Syntax
Arguments
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.
See Also
depfixdb
, deprdv
, depsoyd
, depstln
![]() | depfixdb | deprdv | ![]() |