How to Use the SYD function to calculate depreciation in Excel
In this tip, we calculate the depreciation of an investment. To do so, use the SYD function, which returns the sum-of-years’ digits depreciation of an asset for a specified period. Here is the syntax that is used:
SYD(cost, salvage, life, per)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the deprecation.
life: [...]
