Financial Functions
Advanced
SYD Function
Calculate sum-of-years-digits depreciation.
Task:
Calculate depreciation for each year using sum-of-years-digits method.
Learning Objectives:
- Learn SYD function
- Understand sum-of-years depreciation
- Practice depreciation calculations
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Parameter | Value |
| 2 | Cost | 24000 |
| 3 | Salvage | 3000 |
| 4 | Life | 10 |
| 5 | Period | 1 |
| 6 | SYD |
What this exercise teaches (contains the answer)
SYD calculates depreciation using the sum-of-years-digits method, another accelerated depreciation approach.