Financial Toolbox™

depfixdb

Fixed declining-balance depreciation schedule

Syntax

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

`Cost`	Scalar for the initial value of the asset.
`Salvage`	Scalar for the salvage value of the asset.
`Life`	Scalar value for the life of the asset in years.
`Period`	Scalar integer for the number of years to calculate.
`Month`	(Optional) Scalar value for the number of months in the first year of asset life. Default = 12.

Depreciation = depfixdb(Cost, Salvage, Life, Period, Month) calculates the fixed declining-balance depreciation for each period.

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