It must involve a reworking of this formula
Anyone help me out? Also if you could help me do this through excel it would be great.
Hey, how do I work out the compound interest rate when I know the money invested each year and I know the final amount at the end
Here are the details
£2,000 invested every year
£205,000 in account after 24 years
What is the interest rate?
Also if someone could help me out with how to put the appropriate formula into Excel that would be amazing.
I ran this through Excel. I got 21.2775% as an interest
rate. I don't know if that's what you need or not. I didn't use anything fancy.
I entered 2000 in cell A1 and some interest rate in cell B1.
Then in cell A2 enter =A1+$B$1*A1 and drag it down to cell A25.
If you enter .212775 into cell B1 you'll get 205000.80 pounds.
Maye you can use Excel and play with it yourself.
CaptainBlack, I posted this in the other thread before you closed it.Originally Posted by CaptainBlack
Here are two ways to put this in Excel.
First way: use the IRR function for internal rate of return. Copy 2000 into 24 cells. Enter -205000 into the 25th cell. In the 26th cell use the IRR function with the 25 cells as the input array. Use initial guess .1. The answer is .1024 = 10.24%.
Second way: put .1 in a cell, call it r. Put the formula
205000 - (2000*(1+r)*(power(1+r;24)-1))/r
into another cell where r is a reference to the first cell. Use the Goal Seek tool to find the value of r that sets the formula cell to target value 0. Same result.
Sorry about that , but it illustrates the point yet again about multiple postsOriginally Posted by JakeD
just causing confusion. I posted my comment in response to galactus's post
about using Excel, and had completely forgotten what you have said in the