SYD (sum-of-years’ digits depreciation)

<< Click to Display Table of Contents >>

SYD (sum-of-years’ digits depreciation)

Syntax:

SYD(Cost, Salvage, Life, Per)

Description:

Returns the depreciation of an asset for the specified period, using the sum-of-years' digits method.

The function expects the following arguments:

Cost = Initial cost of asset

Salvage = Salvage value (value at the end of the depreciation)

Life = Life of asset (in number of periods)

Per = Period to evaluate (in the same time unit as Life)

Note:

This function is only partially applicable to the tax law of some countries (e.g. Germany)!

Example:

For a machine purchased for € 200,000 that is used for 10 years and then has a salvage value of € 10,000, the following annual depreciation amount must be applied for the first year:

SYD(200000, 10000, 10, 1) returns 34545.45 (depreciation in year 1)

See also:

DBB, DB, SLN