Free Online Tutorials on Spreadsheets

SYD function in Excel

Use

SYD function is a Financial function, which returns the sum-of-years’ digits depreciation of an asset for a specific period.

Syntax

=SYD(cost, salvage, life, per)

The SYD function has the following arguments:

cost – Required. The initial cost of the asset, when it was purchased.

salvage – Required. The salvage value of the asset, when it will be depreciated.

life – Required. The useful life of the asset.

per – Required. The period for which you want to calculate the depreciation, it must be used as the same units of life.

Example

Result. The above-mentioned terms for the asset have the first year depreciation of $1,636.

In a similar way, total depreciation for the asset will be:

Function Errors

Error Occurs
#VALUE! If any supplied argument is non-numeric.
#NUM! If the supplied salvage value is less than zero.
If the supplied ‘per’ argument is greater than the supplied life argument.
If the supplied life or per argument is less than or equal to zero.

Related Functions

SLN function uses the straight-line depreciation method to find out the depreciation of an asset for one period.

DDB function calculates depreciation of an asset by using the Double Declining (DDB) Method or another method specified by the user.

VDB function calculates the depreciation of an asset, for a specified given period, by using any selected depreciation method, such as the double declining balance method etc.

DB function calculates depreciation of an asset by using the fixed-declining balance method over the useful life of the asset.

AMORLINC function calculates depreciation of an asset, on a prorated basis, for a specified accounting period.

AMORDEGRC Function returns the depreciation of an asset for each accounting period till a useful life of an asset.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved