SLN

Determines depreciation of asset using straight-line method

Syntax of Excel SLN formula:
=SLN(cost, salvage, life)

In words:
=Calculate straight line depreciation of asset with this (cost, residual value, useful life)

Examples of Excel SLN formula

=SLN(1000,100,5) will return $180 as depreciation