Financial Toolbox | ![]() ![]() |
Fixed declining-balance depreciation schedule
Syntax
Arguments
Description
Depreciation = depfixdb(Cost, Salvage, Life, Period, Month)
calculates the fixed declining-balance depreciation for each period.
Examples
A car is purchased for $11,000 with a salvage value of $1500 and a lifetime of eight years. To calculate the depreciation for the first five years
See Also
depgendb
, deprdv
, depsoyd
, depstln
![]() | daysdif | depgendb | ![]() |