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. Beginning Value x 1 interest rate number of compounding periods per year years x number of compounding periods per year Future Value. How much will your investment be worth after 15 years at an annual interest rate of 4 compounded quarterly.
Suppose we have the following information to calculate compound interest in a table excel format systematically.
You can follow this same logic to create the formula that calculates year 3 interest in cell E2 D2 x 108. In this case C2 contains the value 10180 so the Excel worksheet will calculate 10180 x 108 and will display 10917. Click Insert. Formula To Calculate Compound Interest.