Fixed declining-balance depreciation schedule
Depreciation = depfixdb(Cost,Salvage,Life,Period,Month)
Scalar for the initial value of the asset.
Scalar for the salvage value of the asset.
Scalar value for the life of the asset in years.
Scalar integer for the number of years to calculate.
(Optional) Scalar value for the number of months in the
first year of asset life. Default =
Depreciation = depfixdb(Cost,Salvage,Life,Period,Month) calculates
the fixed declining-balance depreciation for each period.
This example shows how to calculate the depreciation for the first five years for a car is purchased for $11,000, with a salvage value of $1500, and a lifetime of eight years.
Depreciation = depfixdb(11000, 1500, 8, 5)
Depreciation = 1×5 103 × 2.4251 1.8904 1.4737 1.1488 0.8955