Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Approximate match with multiple criteria in Excel
  • How to get first row number in range in Excel
  • Get nth match with INDEX / MATCH in Excel
  • How to use Excel TRANSPOSE Function
  • How to retrieve first match between two ranges in Excel

Data Analysis Examples

  • How to Create Column Chart in Excel
  • Managing Conditional Formatting Rules in Excel
  • Excel Bar Chart
  • How To Compare Two Lists in Excel
  • Get column index in Excel Table

Data Validation Examples

  • Data validation must not exist in list
  • How To Create Drop-down List in Excel
  • Excel Data validation whole percentage only
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells

SYD function: Description, Usage, Syntax, Examples and Explanation

by

What is SYD function in Excel?

SYD function is one of Financial functions in Microsoft Excel that returns the sum-of-years’ digits depreciation of an asset for a specified period.

Syntax of SYD function

SYD(cost, salvage, life, per)

The SYD function syntax has the following arguments:

  • Cost: The initial cost of the asset.
  • Salvage:  The value at the end of the depreciation (sometimes called the salvage value of the asset).
  • Life: The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).
  • Per: The period and must use the same units as life.

SYD formula explanation

SYD is calculated as follows:

Example of SYD function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data Description
$ 30,000.00 Initial cost
$ 7,500.00 Salvage value
10 Lifespan in years
Formula Description (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

Post navigation

Previous Post:

TBILLEQ function: Description, Usage, Syntax, Examples and Explanation

Next Post:

SLN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count line breaks in cell in Excel worksheet
  • How to check if cell contains some words but not others in Excel
  • How to count total words in a cell in Excel
  • Remove last characters from right in a cell in Excel
  • How to get top level domain (TLD) in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Convert text to date in Excel
  • How to show last updated date stamp in Excel
  • Get first day of previous month in Excel
  • Get days between dates in Excel
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • Example of payment for annuity in Excel
  • Calculate interest for given period in Excel
  • VDB function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles