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

What is the SLN function?
The SLN function is a calculation used to determine the straight-line depreciation for an asset over one period. The required arguments for the SLN function are cost, salvage, and life.
What is the return value of the SLN function?
The SLN function returns a value that is the straight-line depreciation for one period.
What are the required arguments for the SLN function?
• Cost
• Salvage
• Life 