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)

costis the original value of the asset,
salvageis the predicted future value at the end of the depreciation period. Both cost and salvage must be presented in the same format, eg both in the same currency,
lifeis the number of periods in the depreciation period,
periodis 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).