This article describes the formula syntax and usage of the SYD function in Microsoft Excel.


Returns the sum-of-years’ digits depreciation of an asset for a specified period.


SYD(cost, salvage, life, per)

The SYD function syntax has the following arguments:


SYD is calculated as follows:


Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

$ 30,000.00Initial cost
$ 7,500.00Salvage value
10Lifespan in years
FormulaDescription (Result)Result
=SYD(A2,A3,A4,1)Yearly depreciation allowance for the first year (4,090.91)$4,090.91
=SYD(A2,A3,A4,10)Yearly depreciation allowance for the tenth year (409.09)$409.09

Leave a Reply

Your email address will not be published. Required fields are marked *

Open chat
ভর্তি/সার্টিফিকেট তথ্য জানতে ক্লিক করুন
Scan the code
আস সালামু আলাইকুম। বিস্তারিত জানতে/ কল করতে ক্লিক করুন Open Chat বাটনে