SLN
Returns the straight-line depreciation of an asset for one period.
SLN(<cost>, <salvage>, <life>)Returns: A number. The same amount is charged in every period of the asset's life.
What it does
SLN spreads the cost of an asset, less its expected salvage value, evenly over its useful life. It is the simplest and most common depreciation method. Finance teams use it for fixed asset schedules, for the monthly depreciation journal and for the depreciation line in a budget. It gives a flat charge each period, so it is easy to check and easy to explain to an auditor.
Syntax and arguments
- cost: the original cost of the asset. Required.
- salvage: the value expected at the end of the useful life. Required. Use 0 if no salvage value is expected.
- life: the number of periods in the useful life, in the same unit as the depreciation period. Required.
Example
A company buys equipment for 120,000 with an expected salvage value of 10,000 and a useful life of five years. The annual depreciation charge is the same in every year.
Annual Depreciation = SLN(120000, 10000, 5)
The result is 22,000 a year. That is 110,000 of depreciable cost, spread over five years. Over the five years, the asset is written down to its salvage value of 10,000.
Example: a second, different use
A monthly depreciation journal for the same asset. The life is entered in months, so the result is the monthly charge.
Monthly Depreciation = SLN(120000, 10000, 5 * 12)
The result is about 1,833.33 a month.
Things to watch
- SLN does not prorate a partial first year. If the asset starts in July, the first year's charge is half the annual amount. Multiply by the months in service divided by 12 for the first and last years.
- Keep the life and the depreciation period in the same unit. Years with annual charges, months with monthly charges.
- Salvage should be less than cost. If not, the depreciation is negative, which is a sign of a data error.
- Compare with SYD, DB or DDB when the asset loses more value early in its life. Straight-line is the right method only when the asset's use is even over time.
In business terms
SLN is the default for fixed asset schedules in most companies, for the monthly depreciation journal, for the budget of depreciation expense and for the check on a fixed asset register. It is the baseline used to compare the other methods.