header

Goal Seek Help

1. Set the time to 5 years.

2. Set the present value to 8000.

3. Set the periods per year to 12.

4. Using the Goal Seek tool, set cell B9 (the future value) to 10000 (the goal) by changing cell B3 (the nominal rate).

You should get a nominal rate of 4.47%.