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).