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?
|