Compound interest is the addition of interest to the principal sum of a loan or deposit or we can say interest on. Beginning Value 1 interest rate NCPPY years NCPPY Future Value where. Simple Interest Principal Interest Rate Time Period.
The future value of the investment rounded to 2 decimal places is 12210.
Amount 1. 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. Interest principal rate term So using cell references we have. Simple Interest Principal Interest Rate Time Period.