Best Math Formula website. Search anything about Math Formula in this website.
what is the formula for calculating compound interest in excel. N is the number of investment periods for example 36 months 3 years etc. In addition to the formula you also can use Function to calculate the compound interest.
Compound Interest Excel Formula With Regular Deposits Excel Formula Compound Interest Excel from www.pinterest.com
Formula For Compound Interest is represented as Compound Interest P 1 rntn 1. In our example the formula is A2 1B2 where A2 is your initial deposit and B2 is the annual interest rate. The compound interest can be calculated such as.
Monthly Compound Interest Formula.
This example assumes that 1000 is invested for 10 years at an annual interest rate of 5 compounded monthly. The formula now becomes. The compound interest formula reduces to 10000 10044 415 10000 10160 7. In the example shown the formula in C10 is.
