Whole document tree
    

Whole document tree

SYD

SYD

Name

SYD -- 

Description

SYD function calculates the sum-of-years digits depriciation for an asset based on its cost, salvage value, anticipated life and a particular period. This method accelerates the rate of the depreciation, so that more depreciation expense occurs in earlier periods than in later ones. The depreciable cost is the actual cost minus the salvage value. The useful life is the number of periods (typically years) over with the asset is depreciated.

The Formula used for sum-of-years digits depriciation is:

Depriciation expense = ( @cost - @salvage_value ) * (@life - @period + 1) * 2 / @life * (@life + 1).

@cost = cost of an asset when acquired (market value). @salvage_value = amount you get when asset sold at the end of its useful life. @life = anticipated life of an asset. @period = period for which we need the expense.

Examples

For example say a company purchases a new computer for $5000 which has a salvage value of $200, and a useful life of three years. We would use the following to calculate the second year's depreciation using the SYD method:

=SYD(5000, 200, 5, 2) which returns 1,280.00.

See also

SLN.