As you move from year to year the principal amount continues to grow. For example 7 is entered as 7 - do not enter 07. You need the beginning value interest rate and number of periods in years.
The formula for compound interest is P 1 rn nt where P is the.
For daily compounding most organizations use 360 or 365. Calculating quarterly compound interest is just like calculating yearly compound interest. For the formula for compound interest just algebraically rearrange the formula for CAGR. You need the beginning value interest rate and number of periods in years.