Formulas and Functions Help
- Welcome
- Intro to formulas and functions
-
- 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
SYD
The SYD function returns the amount of depreciation of an asset for a specified period using the sum-of-the-years-digits method. All arguments are number values.
SYD(cost, salvage, life, depr-period)
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 a half year depreciable life).
depr-period: The period for which you want to calculate depreciation. depr-period must be greater than 0. Any decimal (fractional) part of depr-period is ignored.
Notes
The currency shown in this function result depends on your Language and Region settings (in System Preferences in macOS and in Settings in iOS and iPadOS), or on your Time Zone and Region settings in iCloud Settings.
Examples |
|---|
Suppose you purchased an asset with a cost of $10,000 (cost) and an estimated salvage value of $1000 (salvage) at the end of its depreciable life of 9 years (life). =SYD(10000, 1000, 9, 1) returns $1,800, the depreciation amount for the first year (depr-period is 1) in dollars. =SYD(10000, 1000, 9, 2) returns $1,600, the depreciation amount for the second year. =SYD(10000, 1000, 9, 8) returns $400, the depreciation amount for the eighth year. |