Finance
Work out sum-of-years depreciation
=SYD(B1,B2,B3,1)How it works in Excel
- B1 is the cost.
- B2 is the value at the end.
- B3 is the useful life.
- 1 is the year you want.
- It front-loads the expense, but less sharply than double-declining.
The idea in general
Each year takes a shrinking slice of the total to be written off.
What I assumed
- The cost is in B1, the end value is in B2 and the life is in B3.
Check the result on your own data before relying on it.