Thanks, MickG - sorry but I don't understand your reply. i am trying to calculate backwards from $1,000,000 goal with klnown term and interest rate to calculate saving amt reqd. Thanks Squiggler47, your answer is very close but my manual calculation came up with $5,429.90m - are there any other ways to calculate this. Cheers