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