header

Goal Seek Help

1. Set the time to 5 years.

2. Set the nominal rate to 3%.

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 B8 (the present value).

You should get a present value of $8,608.69.