Best Math Formula website. Search anything about Math Formula in this website.
how to calculate compound interest yearly in excel. The following three examples show how the FV function is related to the basic compound interest formula. Suppose we have the following information to calculate compound interest in a table excel format systematically.
Assume you put 10000 into a bank. To calculate monthly interest rate the formula in C6 is. Gross figure x 1 interest rate per period.
To get the total number of payment periods we multiply it by 12.
N is the number of investment periods for example 36 months 3 years etc. For the formula for compound interest just algebraically rearrange the formula for CAGR. Gross figure x 1 interest rate per period. Enter the years 0-5 in cells A2 to A7.