SYD

Name

SYD —
SYD(cost,salvage value,life,period)

Description

Calculates the sum-of-years digits depriciation for anasset based on its cost, salvage value, anticipated life and aparticular period.

Formula 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 life life = anticipated life of an asset period = period for which we need the expense@SEEALSO=SLN