A college savings education plan claims that had you invested $300 per month in the plan for

the last 18 years you would have accumulated $250,000. Assuming the investments were made

at the beginning of each month, calculate the effective annual rate of return an investor would

have received on a compounded basis using either Goal Seek or Solver. (USE EXCEL AND SHOW ALL FORMULAS)

Please identify the

i. Set Objective (Cell)

ii. To Value

iii. By Changing Variables Cell

iv. Subject to (if used