There is no periodic payment in this example, so we use zero forpmt.
Finally, we provide the present value (pv) as -1000.
Calculate compound interest
To calculate compound interest in Excel, you can use the FV function. This example assumes that $1000 is invested for 10 years at an annual interest rate of 5%, compounded monthly. In the example shown, the formula in C10 is: =FV(C6/C8,C7*C8,0,-C5) The FV function returns approximately 1647 as a final result.
