A P 1 rn nt Where. R the annual interest rate as a percent. Python Program - Compounding Interest WITH Monthly Deposit.
The concept of compound interest is the interest adding back to the principal sum.
N the number of times that interest is compounded per year eg. Multiply 8 times 12 which equals 96 times compounding. The Excel compound interest formula in cell B4 of the above spreadsheet on the right once again calculates the future value of 100 invested for 5 years with an annual interest rate of 4. One thing we need to get straight from the beginning is the timing of the interest and contributions.