A spreadsheet software program can do these repetitive. In one of our previous articles we unveiled the power of compound interest and how to calculate it in Excel. PV future value1rateperiod.
Now select B10 and enter the formula.
Experimenting with different values to observe the corresponding variation in results is a common. A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. For calculation of interest paid during a specific period we will use below formula. The formula you need to use is.