Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
SLN
The SLN function returns the depreciation of an asset for a single period using the straight-line method. All arguments are number values.
SLN(cost, salvage, life)
cost: The cost of the asset to be depreciated. cost is often formatted as a currency and must be greater than or equal to 0. The cost is generally the purchase price, including taxes, delivery, and setup. Certain tax benefits may be deducted from the cost.
salvage: The salvage value of the asset. salvage is often formatted as a currency and must be greater than or equal to 0.
life: The number of periods over which the asset is depreciating, known as the depreciable life or the expected useful life. life must be greater than 0. A decimal (fractional) part of life is allowed (for example, 5.5 for a five and one-half year depreciable life).
Notes
The currency shown in this function result depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS).
Examples |
|---|
Suppose you purchased an asset with a cost of $10,000 (cost) and an estimated salvage value of $1,000 (salvage) at the end of its depreciable life of 6 years (life). =SLN(10000, 1000, 6) returns $1,500, the depreciation per year, in dollars, based on the assumptions given. =SLN(10000, 0, 6) returns $1,666.67, the depreciation per year, in dollars, if the same asset had no estimated salvage value. |