Divide the number calculated in Step 3 by the interest rate per compounding period. How to use the compound interest formula. The formula used in the compound interest calculator is A P 1rnnt A the future value of the investment P the principal investment amount r the interest rate decimal.
A the future value of the investmentloan including interest.
Step 1 We need to name cell E3 as Rate by selecting the cell and changing the name using Name Box. Amount that you plan to add to the principal every month or a negative number for the amount that you plan to withdraw every month. T the time the. Click on the Formulas tab then the Financial tab.