Description
SLN returns a Number specifying the straight-line depreciation of an asset for a single period.
Arguments
cost is a Number or Currency that specifies the initial cost of the asset.
salvage is a Number or Currency that specifies the value of the asset at the end of its useful life.
life is a Number that specifies the length of the useful life of the asset. It must not equal 0.
Action
SLN returns a Number specifying the straight-line depreciation of an asset for a single period.
Example
Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. The depreciation per year is:
SLN (500000, 60000, 10)
Returns 44000. Thus the depreciation per year is $44,000.