Calculate Compound Interest

Re: Future Interest

Try doing a search of the built in excel help for future value or financial functions. It will give a complete list of the different formulas/functions available with examples.

Re: Future Interest

Now your thread title matches you question, see all Possible Answers table above.

Re: Calculate Compound Interest

check this file
may solve ur question

Re: Calculate Compound Interest

Hello,

To make £X grow into £Y in n years with a constant annual growth rate of r%, we need Y = X((1+(r/100))^n) where ^ means raised to the power of. Hence:

r = 100((Y/X)^(1/n))-1)

So for X = 200, Y = 750, n = 10, we have

r = 100*(((750/200)^(1/10))-1) = 14.1309%

You can raise the number in a cell to the power of another by using the appropriate ^ command in Excel or on a suitable calculator.

To work out what the interest rate would have to be to achieve £2Y, other things being equal, then insert £2Y in the above formula instead of Y.

Barney2003