In cell C5, enter “sum of years date.” Enter “=SYD(B1,B2,B3,6)” into cell C6. Calculate the other depreciation values using the sum of the years’ digits method in Excel with this function.

Sum-of-the-years’ digits: Much like declining value, the sum-of-the-years' digits method depreciation allows you to depreciate more value upfront. Instead of using a percentage, ...

The car has a 5-year useful lifespan, so the sum-of-the-years digit is 15. The depreciation value for the first year is $16,666. Units of Production .

Sum of the years’ digits depreciation: Depreciation Expense = (Undepreciated asset cost balance - salvage value) X Remaining asset life / Sum of years' digits. YEAR 1 = ($100,000 - 10,000) X 10/ 55 ...

Sum-of-the-Years Digits Depreciation. Another accelerated method, this approach applies a different rate each year to calculate the asset’s depreciable amount.

Sum-of-the-Years’-Digits (SYD) Method: You can use this method to calculate depreciation by multiplying the asset’s depreciable base by a fraction that changes each year.