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

Read on to learn more about compound interest and how to calculate it using Excel. Let's say that you have an account with a deposit of $100 that earns a 10% annual compounded interest rate.