ƒx

Excel SLN Formula

finance Difficulty:

One-Click Copy

SLN(cost, salvage, life)

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Returns the straight-line depreciation of an asset for one period.

Determine annual depreciation for an asset evenly over its life.

Calculate Straight-Line Depreciation

Determine annual depreciation for an asset evenly over its life.

Inputs

cost Initial cost of the asset.
salvage Value at the end of depreciation.
life Number of periods over which the asset is depreciated.

Practical Example

=SLN(10000, 1000, 5)

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.