This means that your interest is being compounded annually at 6. Compound Interest P 1 r t P where. You need the beginning value interest rate and number of periods in years.
Enter your principal in cell B2.
The bank gives you a 6 interest rate and compounds the interest each month. This means that your interest is being compounded annually at 6. Let S be an initial sum of money. For example imagine you are started with 1000.