Principal Amount 1Annual Interest Rate12 Total Years of Investment12 In above example with 10000 of principal amount and 10 interest for 5 years we will get 16453. If the interest on your investment is paid quarterly while being quoted as an annual interest rate the Excel compound interest formula becomes. And we can easily apply this formula as following.
For daily compounding the interest rate will be divided by 365 and n will be multiplied by 365 assuming 365 days in a year.
To reach the formula for compound interest you algebraically rearrange the formula for CAGR. This formula returns the FV ie future value. You can use this formula if you do not want to use the above formula. You need the beginning value interest rate and number of periods in years.