Save for Retirement Your goal is to save $1,000,000 for retiremenet. You do so in a savings account with a fixed annual interest rate, compounded monthly. Annual Rate of Return 7% Monthly deposit This value gets determined by Goal Seek. Years to retirement 35 Payments per year 12 Total value after 35 years Use goal seek to determine the monthy deposit over a 35 year period at 7% APR to save a million dollars for retirement Use the Future Value function (FV) in B27