1. An employee plans to invest $50,000 per year in a retirement fund at the beginning of each of the next 10 years. The employee believes she will earn 14% on her investments in each of the first 3 years and 7% in each of the final 7 years before she retires.
   1. How much money will the employee have in the retirement fund at the end of 10 years?
   2. What would be the internal rate of return associated with her investments and her final retirement position?
   3. Using Solver or Goal Seek determine the annual investment amount that would result in a retirement fund of $1,200,000 at the end of 10 years?

2. A college savings education plan claims that had you invested $600 per quarter in the plan for the last 17 years you would have accumulated $300,000. Assuming the investments were made at the beginning of each quarter, calculate the effective annual rate of return an investor would have received on a compounded basis using either Goal Seek or Solver.