Spread Formula Reference
Formula Functions / Functions R to S / SYD
In This Topic
    SYD
    In This Topic

    This function returns the sum-of-years’ digits depreciation of an asset for a specified period.

    Syntax

    SYD(cost,salvage,life,period)

    Arguments

    This function has these arguments:

    Argument Description
    cost Initial cost of the asset
    salvage Value at the end of the depreciation
    life Number of periods over which the asset is being depreciated
    period Period for depreciation; must use the same units as the life argument.

    Remarks

    This function calculates the digits depreciation as follows:

    SYD Equation

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    SYD(B1,1000,10,1)

    SYD(R1C2,1000,10,1)

    SYD(100000,10000,5,2) gives the result $2,4000

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    DB | DDB | SLN | Financial Functions