The rate of interest is 075 per yearBefore beginning the calculations you need to express 075 as an equivalent decimal number. Click on cell B5 to select it and then click inside the formula bar to enter this formula. Compound Annual Growth Rate Calculator.
You can see it is a good idea to reinvest your interest earned.
Compound Interest in Excel Formula. This can be achieved by dividing 075 by 100. Here P denotes the principal r represents the annual interest rate n is the number of times the interest is compounded per year and t is the time in years. Add 1 to the periodic rate.