Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

SLN

Description: Based on one period, returns the straight-line depreciation on an asset.

Syntax: SLN(Cost, Salvage, Life)

• Cost is the initial cost of the asset.

• Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset).

• Life is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

Example:

Suppose you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500. The depreciation allowance for each year is:

• SLN(30000, 7500, 10) = $2,250