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.
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
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!