The sum of the years’ digits method uses the function SYD to calculate a fraction: (years left of useful life) ÷ (sum of useful life). Excel can also calculate the declining balance method (DB ...