Downloads
DAXFinancialBeginner

SLN

Returns the straight-line depreciation of an asset for one period.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals