Author: Oscar Cronquist Article last updated on May 11, 2022

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

Formula in cell C6:

=SYD(C2,C3,C4,C5)

Excel Function Syntax

SYD(cost, salvage, life, per)

Arguments

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.

Comments