Excel
SYD function in Excel
Returns the sum-of-years' digits depreciation of an asset for a specified period
=SYD(cost, salvage, life, per)SYD syntax and parameters
Four arguments, four required.
- costnumberRequired
The initial cost of the asset.
- salvagenumberRequired
The value at the end of the depreciation (sometimes called the salvage value of the asset).
- lifenumberRequired
The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
- pernumberRequired
The period and must use the same units as life.
SYD examples
Formulas you'll actually reuse.
Sum-of-years'-digits, year 1 — 5/15 of the depreciable $20,000:
=SYD(24000, 4000, 5, 1)Result
6666.67Year 5 — 1/15 of the same amount:
=SYD(24000, 4000, 5, 5)Result
1333.33
SYD in Google Sheets
Same name — your formula ports as-is.
Try SYD in the playground
Edit the example — nothing to install.
Preloaded with the SYD formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets