SYD – Sum of Years Digits method
Syntax:
=SYD(cost,salvage,life,per)
cost: cost of the asset
salvage: residual value of asset at the end of its useful life
life: useful life of asset
per: accounting period for which depreciation is to be calculated
Example
Another widely known depreciation model. Following steps help you carryout depreciation using this method:
Step 1: Make sure SYD tab is active. Observe the data.
Step 2: In cell B12 enter this formula: =SYD(B7,B8,B9,B10). On hitting enter depreciation expense will be calculated for you.
You can practice the use of this method in the following live worksheet as well:
