SLN

Examples

• SLN(cost, salvage, life)

  This function returns the depreciation for each year within the range specified.

• =SLN($20,000, $2,000, 4)

  Let's say you want to calculate the depreciation of a car over a 4 year period. The car originally cost $20,000, and is estimated to have a salvage value of $2,000 at the end of its life. To calculate its depreciation in each year, you would enter the preceding formula in Sourcetable.The result would be $4,500, which is the depreciation for each year of the car's life.

• =SLN($20,000, $2,000, 3.5)

  Let's say you want to calculate the depreciation of a car over a 3.5 year period. The car originally cost $20,000, and is estimated to have a salvage value of $2,000 at the end of its life. To calculate its depreciation in each year, you would enter the formula in Sourcetable.The result would be $5,000, which is the depreciation for each year of the