SYD

Name

SYD —
SYD(cost,salvage_value,life,period)

Description

Calculates the sum-of-years digits depriciation for an asset based on its cost, salvage value, anticipated life and a particular 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

See also

SLN