Returns the depreciation value of an asset for a specified period using the sum-of-years depreciation method.
SyntaxSYD(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 the asset salvage value).
life is the depreciation period (sometimes also called the asset's useful life).
per is the period, and its unit is the same as life.
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 years' digits method to calculate the depreciation value of an asset in a given period, we can use the SYD function of WPS to calculate it.
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 calculations.
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 for 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条)
测试