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. |
Reference: