SYD

Formulas / SYD
Calculate sum of years depreciation.
=SYD(cost,salvage,life,period)
  • cost - the initial cost of the asset
  • salvage - [REQUIRED] the asset's value at the end of the depreciation
  • life - [REQUIRED] the number of periods over which the asset is depreciated
  • period - [REQUIRED] the period to calculate depreciation for

Examples

  • =SYD(10000,2000,5,1)

    The SYD function is used to calculate the sum-of-years' digits depreciation of an asset over a specified period. The function uses the following arguments: cost, salvage, life, and period. For example, this returns the depreciation of an asset with a cost of $10,000, a salvage value of $2,000, and a life of 5 years in the first period, which is $2,667.

  • =SYD(cost,salvage,life,B7)

    The SYD function can also be used to calculate the depreciation of an asset in the current period. For example, this returns the depreciation for the asset in the worksheet C7. In this example, the cost, salvage, and life of the asset must be specified in the function and the current period is indicated by the cell reference B7.

  • =SUM(SYD(10000,2000,5,1), SYD(10000,2000,5,2), SYD(10000,2000,5,3), SYD(10000,2000,5,4), SYD(10000,2000,5,5))

    The SYD function can be used to calculate the total depreciation of an asset over its lifetime. To do this, the function must be nested in a SUM function. For example, this formula returns the total depreciation of an asset with a cost of $10,000, a salvage value of $2,000, and a life of 5 years, which is $8,000.

Summary

The SYD function calculates the sum of years' digits depreciation for an asset. It requires four arguments: cost, salvage, life, and per, and returns the depreciation value.

  • The SYD function calculates the sum of years of depreciation for an asset over a certain period, based on initial asset cost, salvage value, and the number of periods of depreciation.
  • The arguments for the SYD function are cost, salvage, life, and period.


Frequently Asked Questions

What is the SYD Function?
The SYD function calculates the sum of years digits depreciation for an asset.
What are the arguments for the SYD Function?
The arguments for the SYD function are:
  • Cost
  • Salvage
  • Life
  • Per
What is the return value of the SYD Function?
The SYD function returns a value which is the sum of years digits depreciation of an asset.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV