The general formula for compound interest is. You need the beginning value interest rate and number of periods in years. The compound interest formula reduces to 1000010044415 1000010160.
ROUND PMT B212B3-B10 2.
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. Assume you put 10000 into a bank. In the example shown the formula in C10 is. Compound interest is the amount that a dollar invested now will be worth in a given number of periods at a given compounded interest rate per period.