SYD

Determines the depreciation allowance of a given period using the sum-of-years digit method.

Syntax:

SYD(cost:number, salvage:number, life:number, period:number)

where:

cost is the original value of the asset;
salvage is the predicted future value at the end of the depreciation period.
Both cost and salvage must be presented in the same format, e.g. both in the same currency;
life is the number of periods in the depreciation period;
period is the year of the life for which you wish to calculate the depreciation allowance.

Example:

You purchase a £500 computer that has a salvage value of £100 after five years. The depreciation allowance for the first year is given by the formula

SYD(500, 100, 5, 1)

which returns the number 133.33 (pounds).