Straight line depreciation is the most straight forward and the most common method of depreciation. Most accounting departments choose this method due to its simplicity and the fact that most fixed assets' usefulness are consumed at a fairly even rate. If you buy a car, even though the fair market value declines most sharply in the first year, you probably are not planning on selling it anyway. The car still serves its function of getting you from point A to point B in the same way in year 5 as it does in year 1.

See a table comparing the different depreciation amounts using different depreciation methods.

Video Explanation

Purpose

To return the value of one period of straight line depreciation expense.

Syntax

=SLN(cost,salvage,life)

  • cost - Acquistion cost of the asset. Includes purchase price and costs associated with its acquisition such as freight and sales tax.
  • salvage - Amount that you expect to receive in exchange for the asset at the end of its useful life. Typically, this is zero. However, an example of a case where this not zero is the expected trade-in value of an automobile.
  • life - Length of time that the asset is expect to be in service given in number of periods.

Formula

SLN formula

Examples

Example 1

An automobile is purchased for $40,000 that is expected to last 36 months and be traded-in for $4,000.

ABC
1DataArgumentDescription
2$40,000costacquisition cost
3$4,000salvagemoney back at end of life
436lifenumber of periods for useful life

FormulaDescriptionResult
=SLN(A2,A3,A4)Depreciation expense each period$1,000

Example 2

A laptop computer is purchased for €3,000 that is expected to last 24 months and have no value after the end of the two years.

FormulaDescriptionResult
=SLN(3000,0,36)Depreciation expense each period€83.33