Best Math Formula website. Search anything about Math Formula in this website.
what is the formula to calculate compound interest in excel. This example assumes that 1000 is invested for 10 years at an annual interest rate of 5 compounded monthly. Gross figure x 1 interest rate per period.
Compound Interest Formula In Excel Interesting Things Excel Tutorials Compound Interest from www.pinterest.com
Annual compound interest - Formula 1 An easy and straightforward way to calculate the amount earned with an annual compound interest is using the formula to increase a number by percentage. If you need to calculate the future value of an interest when compounding frequency is quarterly you can simply change the value in cell B6 to 4. How to calculate compound interest in Excel.
You need the beginning value interest rate and number of periods in years.
You need the beginning value interest rate and number of periods in years. Principal Amount 1Annual Interest Rate12 Total Years of Investment12 In above example with 10000 of principal amount and 10 interest for 5 years we will get 16453. In the example shown the formula in C10 is. If you need to calculate the future value of an interest when compounding frequency is quarterly you can simply change the value in cell B6 to 4.
