need to take the interest from an amount

Microsoft Microsoft excel 2007 full vers...
February 25, 2010 at 09:16:54
Specs: Windows XP
hello i need to take a interest from and amount that is 397,224 this included the 6% of interest for 60 month how i can calculated what the interest of each month, because is alreasy included

See More: need to take the interest from an amount

February 25, 2010 at 09:29:40

Create a 60 month * 6% increase series, starting with an initial value of 1
The result is about 32.99

Now select the last cell - the one with the result of 32.99
Use the Goal Seek function:
This will assume that the cell selected is the one to be set to the goal. Enter 397224 as the goal and select the 'cell to change' to be the first one in your series, i.e., the cell you entered 1 in.
Click OK, and the first cell in your series will be successively changed until the result of your series is 397224.

I don't have Excel 2007 on this PC, so I can't walk you through finding the goal seek function from the Ribbon.


Report •
Related Solutions

Ask Question