FV function stands for Future Value returns the future value of an investment based on periodic constant payments and a constant interest rate. The formula for compound interest is similar to the one for Compounded Annual Growth Rate CAGR. For this you require the following four things.
Initial investment 1 annual interest ratecompounding periods per year years compounding periods per year.
To calculate compound interest multiply the principal amount with 1 Interest Rate raised to the number of years. For the formula for compound interest just algebraically rearrange the formula for CAGR. Ending Investment Start Amount 1 Interest Rate n Where n Number of years of investment. The compound interest formula reduces to 10000 10044 415 10000 10160.