# SLN

Formulas / SLN
Calculate depreciation.
`=SLN(cost, salvage, life)`
• cost - required, double
• salvage - required, double
• life - required, double, must be positive

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

## Summary

The SLN function is used to calculate the depreciation of an asset over a certain period of time. It requires three arguments: cost, salvage, and life.

• The SLN function calculates the amount of depreciation for an asset over a period of time.
• The three arguments that must be included when using the SLN function are cost, salvage, and life.