Financial Toolbox    
depfixdb

Fixed declining-balance depreciation schedule

Syntax

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

returns

See Also

depgendb, deprdv, depsoyd, depstln


  daysdif depgendb