Returns the depreciation value of an asset for a specified period calculated using the sum-of-years depreciation method.
Syntax
SYD(cost,salvage,life,per)
cost is the original value of the asset.
salvage is the value of the asset at the end of the depreciation period ( Also known as asset salvage value).
life is the depreciation period (sometimes also called the useful life of the asset).
per is the period, and its unit is the same as life .
Description
In financial work, we often have to calculate depreciation value.
The sum-of-the-years' digits method is a depreciation method that uses decreasing fractions as the depreciation rate and multiplies the net value of fixed assets respectively.
When we want to use the sum of the years digits method to calculate the depreciation value of an asset during a given period.
You can use the SYD function of WPS to calculate.
Next, I will show you the specific steps of using this function in this table.
■ Select cell A5, click Insert Function, find and select the SYD function in the search box, and click OK.
A dialog box will pop up with a total of four parameters.
Original value: that is, the original value of fixed assets.
Residual value: The estimated residual value of an asset at the end of its useful life.
Depreciation period: the total number of periods for depreciation calculation.
Period: The period for depreciation calculation must be the same as the unit of the depreciation period.
Suppose we want to calculate the depreciation value in year 1.
Fill in the values one by one based on the known conditions.
Fill in A2 for the original value of the asset, fill in A3 for the residual value of the asset, and fill in A4 for the depreciation period. Since the depreciation to be calculated is the first year, fill in 1 for the period.
Click OK to calculate the depreciation value very quickly.
评论列表(196条)
测试