CALC 1 Home Documentation Home Contact

CALC 1 SYD Function Sum of the Years Depreciation Formula Calculator

Calculates depreciation using the Sum of the Years method.


Formula: syd(cost, slvg, life, period)

syd: The result of the formula.

cost: The initial cost of the asset. 0 < cost

slvg: The salvage value. 0 <= slvg <= cost

life: The life of the asset. 0<= life

period: The period of the depreciation. 0 < period

Example 1

Calculate the annual depreciation of a 10,000 asset with a salvage value of 1,000 and a life of 5 for period 1.

Value Keystrokes Display Description
10000 cost 10,000.0000 Stores the cost value.
1000 slvg 1,000.0000 Stores the slvg value.
5 life 5.0000 Stores the life value.
1 period 1.0000 Stores the period value.
  syd 3,000.0000 Calculates the syd.

Example 2

What salvage value is required for a 3,100 depreciation?

These keystrokes assume the values from example 1.

Value Keystrokes Display Description
3,100 syd 3,100.0000 Stores the sydF value.
  slvg 700.00 Calculates the slvg value.


Depreciation - Wikipedia