Functions
SLN
Straight-line depreciation
Try it
When to use it
When should I use SLN?
Use SLN to compute the straight-line depreciation of an asset for a single period — the simplest depreciation method that spreads cost evenly over the asset's useful life.
Used in
Syntax
SLN(cost, salvage, life)Examples
=SLN(100,50,10) // => 5