Was this helpful?
SLN Function
The SLN function calculates the straight-line depreciation of an asset for one period, given the asset’s original cost, its estimated life, and its salvage value.
This function has the following syntax:
SLN(cost = value, salvage = value, life = value)
Argument
Data Type
Description
cost
Float
Original cost of the asset
salvage
Float
Asset salvage value at end of life
life
Integer
Life of asset (number of periods)
This function returns:
Float—Straight-line depreciation
Null—On error
Example—SLN function:
/*  Compute the Straight Line depreciation for the
**  asset with an initial cost of $5,000, a life of
**  five years, and a salvage value of $1,000.
*/
dep = sln(cost = 5000, salvage = 1000, life = 5);
Last modified date: 12/20/2023