How much will your investment be worth after 15 years at an annual interest rate of 4 compounded quarterly. To calculate compound interest in Excel you can use the FV function. The answer is 18167.
In Excel and Google Sheets you can use the FV function to calculate a future value using the compound interest formula.
The formula now becomes. This example assumes that 1000 is invested for 10 years at an annual interest rate of 5 compounded monthly. You need the beginning value interest rate and number of periods in years. We will initiate writing the FVSCHEDULE function into cell B6.