SLN (straight-line depreciation)

<< Click to Display Table of Contents >>

SLN (straight-line depreciation)

Syntax:

SLN(Cost, Salvage, Life)

Description:

Returns the depreciation per period of an asset, using the straight-line depreciation method.

Cost = Initial cost of asset

Salvage = Salvage value (value at the end of the depreciation)

Life = Life of asset (in number of periods)

Example:

Initial values: Initial cost = 6000, Salvage value = 3000, Life of asset = 5 years

SLN(6000, 3000, 5) returns 600 (per year)

See also:

SYD, DDB, DB