SYD Function in Google Sheets

Calculate the sum-of-years' digits depreciation of an asset over its useful life.

SYD Function

The SYD function in Google Sheets calculates the sum-of-years’ digits depreciation of an asset over its useful life.

Syntax

SYD(cost, salvage, life, period)
  • cost: The initial cost of the asset.
  • salvage: The salvage value of the asset at the end of its useful life.
  • life: The number of periods (usually years) over which the asset will be depreciated.
  • period: The period for which you want to calculate the depreciation.

Examples

  1. Basic Depreciation Calculation

Calculate the depreciation for the 3rd year of an asset costing $5000 with a salvage value of $500 over 5 years:

=SYD(5000, 500, 5, 3)

This will output 900.

Notes

  • Depreciation is weighted more heavily in the earlier years of the asset’s life.
  • The result represents the depreciation expense for the specified period.
  • SLN: Calculate straight-line depreciation.
  • DDB: Calculate depreciation using the double-declining balance method.