Practice free

SYD function

SYD returns sum-of-years'-digits depreciation for one period. It gives accelerated depreciation that falls steadily each year, based on the sum of the years in the asset's life.

Example

Read it as a sentence: find the first year's sum-of-years depreciation on a $30,000 asset with a $7,500 salvage value over 10 years, which gives $4,090.91.

Practice this in the app

Syntax

SYD(cost, salvage, life, per)

cost (required)
Initial cost of the asset.
salvage (required)
Value at the end of its life.
life (required)
Number of periods of use.
per (required)
Period to calculate (1 is first).

Returns: Sum-of-years'-digits depreciation for one period.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=SYD(30000,7500,10,1) $4,090.91 Year 1
=SYD(30000,7500,10,10) $409.09 Last year
=SYD(1000,2000,5,1) ($333.33) Salvage > cost
=SYD(30000,7500,10,1.5) $3,886.36 Fractional per
=SYD("30000","7500","10","1") $4,090.91 Text number
=SYD(30000,7500,10,{1,2,3}) $4,090.91 Spill
=SYD(30000,7500,10,0) #NUM! Per 0
=SYD(30000,7500,10,11) #NUM! Per > life

Watch out for

  • per and life must use the same unit.

Where it works

Excel
SYD is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .