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.