Question: how to calculate compound interest on savings account?
Answer: To use this spreadsheet formula for an account with compounding interest, you need to adjust several numbers. To change this annual rate to a monthly rate, divide 5% by 12 months (0.05 ÷ 12) to get 0.004167. Next, increase the number of periods to 12.