<< 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: