Author: Oscar Cronquist Article last updated on December 12, 2018

The SYD function calculates the yearly asset depreciation of a given year.

Formula in cell C6:


Excel Function Syntax

SYD(cost, salvage, life, per)


cost Required. The cost of an asset.
salvage Required. The final value after depreciation (salvage value).
life Required. The number of periods the asset is depreciated.
per Required. The period you want to know the depreciation for.