depfixdb

Fixed declining-balance depreciation schedule

Syntax

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

Arguments

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.

Description

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

Examples

expand all

Compute the Fixed Declining-Balance Depreciation

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.0e+03 *

    2.4251    1.8904    1.4737    1.1488    0.8955

Was this topic helpful?