How Do You Calculate Sum-Of-Years Digits Depreciation With Excel?
The SYD function in Excel calculates an asset’s sum-of-years’ depreciation over a specified period. This calculation is based on the original cost of the asset, the salvage value of the asset, the number of periods that the asset will be depreciated and the period to calculate the depreciation for. The following steps explain how to use the SYD function in Excel. Learn how the sum-of-years’ digits depreciation is calculated. SYD uses the following formula: SYD = (cost – salvage) * (life – per + 1) * 2 /((life) * (life + 1)). Launch Excel and position the cursor over the cell you want to calculate the sum-of-years’ digits depreciation in. That cell will now have a bold black outline indicating it has been selected. Enter “=syd(” into the cell. A tip will appear that reads “SYD(cost,salvage,life,per).” This indicates the syntax for the SYD function. The parameter that Excel is expecting you to input next will be in bold. Provide the cost of the asset, the salvage value, the lifespan and
