In the example shown the formula in C10 is. The formula to use is Initial investment 1 Annual interest rate Compounding periods per year Years Compounding periods per year. You already know the answer.
The general formula for compound interest is.
The indicates an exponent. FV PV1rn where FV is future value PV is present value r is the interest rate per period and n is the number of compounding periods. The compound interest formula reduces to 1001008115 100108. How much will your investment be worth after 5 years at an annual interest rate of 8.