How to calculate time in excel in compound interest?
Answers
Answered by
4
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.
If an amount of $5,000 is deposited into a savings account at an annual interest rate of 5%, compounded monthly, the value of the investment after 10 years can be calculated as follows... P = 5000. r = 5/100 = 0.05 (decimal). n = 12.
If an amount of $5,000 is deposited into a savings account at an annual interest rate of 5%, compounded monthly, the value of the investment after 10 years can be calculated as follows... P = 5000. r = 5/100 = 0.05 (decimal). n = 12.
Similar questions