The SYD function calculates the sum-of-years' digits depreciation of an asset for a specified period.

SYD takes 4 required arguments and no optional arguments:

Syntax: SYD(cost, salvage, life, period)

#1)
Using the SYD function:
#2)
The arguments for the SYD function are:
Argument Required? Description
cost Required The initial cost of the asset.
salvage Required The value at the end of the depreciation (the salvage value of the asset). This value can be 0.
life Required The number of periods over which the asset is being depreciated (the useful life of the asset).
period Required The period for which you want to calculate the depreciation. Period must use the same units as life.

Summary

The SYD function calculates the sum-of-years' digits depreciation of an asset for a specified period.
comments powered by Disqus