# Calculate Compound Interest

• I am trying to create a calculator based on a worksheet I have. I do not know how to write a formula for simple interest calculations and for compound interest calculations. Any help would be really appreciated.

• 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

• Re: Calculate Compound Interest

check this file
may solve ur question

## Files

.
:chase:
Why not learn from the mistakes of others?--you can't make them all yourself!

• 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

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!