View Single Post
  #3   Report Post  
Fred Smith
 
Posts: n/a
Default

You don't need Goal Seek. Just use the PMT function:

=pmt(6.35%/12,8*12,0,-50000,1)

The answer is just under $400 per month.

--
Regards,
Fred


"Duke20" wrote in message
...
I have a goal to save $50,000.00 in eight years. My annual interest rate is
6.35%. What amount would I need to put away monthly, to obtain this goal? How
would I use FV and Goal Seek command to get this done?