Financial Toolbox

depfixdb

Fixed declining-balance depreciation schedule

Syntax

• Depreciation = depfixdb(Cost, Salvage, Life, Period, Month)
  

Arguments

Cost	Initial value of the asset.
Salvage	Salvage value of the asset.
Life	Life of the asset in years.
Period	Number of years to calculate.
Month	(Optional) Number of months in the first year of asset life. Default = 12.

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

• Depreciation = depfixdb(11000, 1500, 8, 5)
  

returns

• Depreciation =
         2425.08     1890.44     1473.67     1148.78     895.52
  

See Also

depgendb, deprdv, depsoyd, depstln

daysdif

depgendb