- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Financial - SLN Function
Description
The SLN function returns the straight-line depreciation of an asset for one period.
Syntax
SLN (cost, salvage, life)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Cost | The initial cost of the asset. | Required |
| Salvage | The value at the end of the depreciation (sometimes called the salvage value of the asset). | Required |
| Life | The number of periods over which the asset is depreciated (sometimes called the useful life of the asset). | Required |
Notes
If the specified life argument is 0, SLN returns #DIV/0! Error.
If any of the specified life arguments is a non-numeric value, SLN returns non-numeric value Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_financial_functions.htm
Advertisements