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)

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:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.