Suppose you invest $5,000 at an annual interest rate of 5%, compounded monthly over 10 years. Here’s how you’d set up the formula: In Google Sheets and Excel, you can type this directly or ...